Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:44:21.850' ,`MLSNumber` = '67674935' ,`ListAgentFullName` = 'Marla Reade' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777728' ,`Longitude` = '-95.530705' ,`PhotoCount` = '14' ,`PostalCode` = '77024' ,`RoomCount` = '4' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Joan of Arc' ,`StreetNumber` = '11733' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine building or renovating your dream home in one of the most charming, highly esteemed and distinguished Memorial Area Villages. Located within the City of Hedwig Village, this community truly has it all with its own police/fire dept., well-kept parks, tree lined streets, walking/biking trails, and neighboring restaurants.\r\nVery close to the Town & Country shopping centers, City Centre, Memorial City Mall and Memorial\r\nHermann Hospital, your new home is situated within walking distance to award winning SBISD schools:\r\nBunker Hill Elementary, Spring Branch Middle and Memorial High School. Private school options include: Kinkaid School, Duchesne Academy, St. Cecilia, St. Francis, & Awty. Your future home sits between two recently built homes giving your home added curb appeal. You don’t want to miss this opportunity to build on one of the few remaining ‘lotvalue’ properties in the Memorial Villages. *The rendering provided is a picture of a possible renovation of the existing home.' ,`Acres` = '0.289' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 33 BLK 5 MARIAN OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Marian Oaks' ,`TaxAmount` = '12204' ,`TaxRate` = '2.3133' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709823' WHERE `Matrix_Unique_ID` = '204330936' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','207614060','1663709823','207614060','2022-09-12T18:04:44.763','3562767','Jared Turner','LennarVillageBldr-JaredTurner','','','30.085500','-95.182825','6','77365','7','300000.00','Active','Clearwater Bluff','9427','Lane','Porter','2','0','4','1946','Single-Family','NEW! \"Brenham II B\" floor plan from the Wildflower Collection by Lennar in Royal Brook. This single-story home showcases a generous open floorplan shared between the family room, dining room and kitchen, leading directly to a covered patio for seamless indoor-outdoor living. Three bedrooms in addition to the spacious primary bedroom complete this home. \r\n\r\nPrices and features may vary and are subject to change. Photos are for illustrative purposes only.','','32','Lennar','','','','Mud','','','','Kingwood East','Central Gas','1','SEC 0022 BLK 001 LOT 007','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','','','0','','','','','Composition','29 - Humble','ELM GROVE ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Kingwood Royal Brook','','2.58','Public Sewer,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:31:03.920' ,`MLSNumber` = '91837440' ,`ListAgentFullName` = 'Melody Oviedo' ,`ListOfficeName` = 'Sean Powers Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826126' ,`Longitude` = '-94.991759' ,`PhotoCount` = '39' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '430990.00' ,`Status` = 'Active' ,`StreetName` = 'Painted Bunting' ,`StreetNumber` = '4506' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is a must see! All the upgrades are already added! Tile throughout the downstairs, upgraded stair railing, 19.5 x 12 covered back patio, optional bedroom downstairs with bath added, upgraded hardware with soft close cabinets, upgraded plumbing fixtures, pre-wired for security and entertainment accessories, media/home theater room, tankless water heater, windstorm shutters, quiet belt driven garage door opener, fully sodded back yard, over $45K in upgrades! This home won\'t last long, schedule your showing ASAP!' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 GOOSE CREEK LANDING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '1819' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709823' WHERE `Matrix_Unique_ID` = '208485501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:44:47.700' ,`MLSNumber` = '83089318' ,`ListAgentFullName` = 'Drue DaSilva' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Emily Zakhem' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.529821' ,`Longitude` = '-95.407659' ,`PhotoCount` = '50' ,`PostalCode` = '77578' ,`RoomCount` = '15' ,`ListPrice` = '625000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mesquite Terrace' ,`StreetNumber` = '4605' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL and NEARLY NEW! This STATELY Perry Homes SMART HOME has 2 BEDROOMS DOWN, a 3-CAR GARAGE and is MOVE-IN READY. Features include a lovely staircase with wrought-iron balusters, brick & stone exterior, soaring ceilings, gorgeous front door, wood-look tile floors, 2\" blinds, natural light, contemporary fixtures, neutral paint, storage galore & MORE! The STUNNING KITCHEN has a huge island with breakfast bar & is well-equipped with GE Profile SS appliances, 4-burner gas cooktop, double ovens, butler\'s pantry and abundant 42\" cabinet & counter space. The private study & formal dining WILL IMPRESS YOU, as will the spacious 2-story family room with gas fireplace. The primary suite features a wall of windows and an elegant bath with soaking tub, double sinks, glass enclosed shower & 2 closets. Upstairs is a GAME ROOM, MEDIA ROOM and 2 additional bedrooms with a shared bath. 2 Powder Rooms. Enjoy the HUGE COVERED PATIO and back yard with ample green space & sprinkler system. A MUST-SEE!' ,`Acres` = '0.1881' ,`Area` = '5' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 5 (A0298 HT&BRR) BLK 1 LOT 35' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '16357' ,`TaxRate` = '3.6594' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709823' WHERE `Matrix_Unique_ID` = '208815748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:45:07.637' ,`MLSNumber` = '85535830' ,`ListAgentFullName` = 'Susanna Mayberry' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = 'Yavon Shaw-Cooper' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '29.145618' ,`Longitude` = '-95.048049' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '895000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Frio' ,`StreetNumber` = '21714' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing views from this spacious canal front home in Sea Isle! If you like people watching and the water, this is the place! Located directly across from the Sea Isle Marina, this home provides easy access to Galveston Bay! Soaring ceiling greets you upon entry. The downstairs open concept features a beautiful gourmet style kitchen with an oversized island that can seat plenty! Just off the kitchen is a very spacious utility/mud room with additional sink. Primary ensuite is downstairs as well with it\'s own private balcony overlooking the Marina. Upstairs you will find the oversized game room, or can be used for whatever you\'d like, that overlooks the downstairs living area and also affords water views. There\'s also an interior elevator to all floors. Out back, canal side, is the perfect spot to sit, relax, grill, entertain on the oversized deck with gazebo. Large two-car garage and automatic driveway gate. Boat slip/house. Don\'t miss this one - make your appointment today!' ,`Acres` = '0.1421' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 14 & 15 LOT 1647 SEA ISLE 11TH EXTENSION' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 11' ,`TaxAmount` = '12557' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709823' WHERE `Matrix_Unique_ID` = '209187667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:03:52.753' ,`MLSNumber` = '36037813' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085464' ,`Longitude` = '-95.182830' ,`PhotoCount` = '10' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Lockridge Harbor' ,`StreetNumber` = '3206' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW Village Builders Classic Collection \'\'Victoria\'\' Design with Elevation A in Royal Brook! This single-story home has a smart layout that is ideal. At the front of the home are three bedrooms and two full bathrooms. Down the hall is the open concept living area, which features a Great Room, kitchen and dining room with an adjacent study and back patio. Tucked into the back corner is the owner’s suite, which features a luxurious bathroom and huge walk-in closet.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Royal Brook' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709823' WHERE `Matrix_Unique_ID` = '209594401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:42:05.740' ,`MLSNumber` = '63586835' ,`ListAgentFullName` = 'Lilia Landin' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541231' ,`Longitude` = '-95.712403' ,`PhotoCount` = '26' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '252000.00' ,`Status` = 'Active' ,`StreetName` = 'Wandering Creek Dr' ,`StreetNumber` = '5735' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful cozy 1 Story brick Home in the Small community of Brazos Village- Spacious back yard lot, with easy access to 59 and Grand Park way 99, located near Shopping Center, restaurant and Entertaiment at Brazos Town Center.' ,`Acres` = '0.1219' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRAZOS VILLAGE SEC 2, BLOCK 2, LOT 31' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5310' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brazos Village Sec 2' ,`TaxAmount` = '4254' ,`TaxRate` = '2.6448' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709824' WHERE `Matrix_Unique_ID` = '209758984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:24:56.637' ,`MLSNumber` = '69296202' ,`ListAgentFullName` = 'Alexander Navarrete' ,`ListOfficeName` = 'Rayfield Realty Group' ,`SellingAgentFullName` = 'Alexander Navarrete' ,`SellingOfficeName` = 'Rayfield Realty Group' ,`Latitude` = '29.830765' ,`Longitude` = '-95.399384' ,`PhotoCount` = '31' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '309900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lelay' ,`StreetNumber` = '4511' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your future home! This amazing new construction home in the Whitney Place area is so remarkable it will create ever lasting memories for you and your family. The builder has not spared any detail. From adding a tankless water heater to making the home energy efficient. This home has tons of features and is a testimony to what a well built home looks like. Once you step onto the property you will feel right at home. The lighting fixtures, imported front door from abroad, kitchen cabinets and counters and countless details will amaze you for years to come. This home also qualifies for $10,000 towards closing if you use the builders lender. The home will be provided with a stainless steel refrigerator. Call us or call your agent today for a private tour! This home will not last. This home is being sold as-is.' ,`Acres` = '0.0442' ,`Area` = '9' ,`BuilderName` = 'Corona Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 31 WHITNEY PLACE WEST' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1925' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Whitney Place West' ,`TaxAmount` = '323' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709824' WHERE `Matrix_Unique_ID` = '209850482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:00:07.613' ,`MLSNumber` = '41206612' ,`ListAgentFullName` = 'Andy Onder Yaltir' ,`ListOfficeName` = 'VITA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733253' ,`Longitude` = '-95.478670' ,`PhotoCount` = '23' ,`PostalCode` = '77057' ,`RoomCount` = '5' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairdale' ,`StreetNumber` = '5708C' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CORNER LOT...Beautiful 3 story single family homes in Houston Galleria uptown area with rooftop terrace. 3 bedroom with 3 & 1/2 bath, elevator shaft, high end finishes, appliances, 200+ sqft backyard and gated community. Will be ready to move in summer 2022. Total 12 homes, 10 left, hurry up and pick your desired lot before gone. Pictures are renderings withe selected finishes, buyers can still change the finishes.' ,`Acres` = '0.0418' ,`Area` = '22' ,`BuilderName` = 'Uniform Construction' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 WESTHEIMER ESTATES 10TH PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2105' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westheimer Ests Partial Replat' ,`TaxAmount` = '2798' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709824' WHERE `Matrix_Unique_ID` = '210134419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:04:14.750' ,`MLSNumber` = '58221784' ,`ListAgentFullName` = 'Lauryn Mutina' ,`ListOfficeName` = 'Paula Mutina Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.965801' ,`Longitude` = '-95.369046' ,`PhotoCount` = '10' ,`PostalCode` = '77541' ,`RoomCount` = '2' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'N AVE C' ,`StreetNumber` = '813' ,`StreetSuffix` = '' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home offers 2 bedrooms and 1 Bath—a beautifully renovated home featuring new kitchen countertops and new flooring throughout the house. Home has easy access to highway 288 and is not far from Surfside beach. Take a look today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'VELASCO (FREEPORT) BLK 633 LOT 16-17-18' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'VELASCO (OLDER HOMES)' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709824' WHERE `Matrix_Unique_ID` = '210179108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:22:20.030' ,`MLSNumber` = '42220077' ,`ListAgentFullName` = 'Christopher Case' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681263' ,`Longitude` = '-95.629974' ,`PhotoCount` = '23' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'River Keg' ,`StreetNumber` = '13811' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Very well-kept & updated 1 story, 3 bedrooms, 2 baths Home in Kingspoint Subdivision. This open floor plan home offers upgraded Italian tile, granite counter tops in kitchen, ceiling fans in all rooms, oversized sliding doors to backyard, newer stainless appliances (all stay). Masterbath offers a separate standing shower and Jacuzzi Style Jet Bathtub. Home has brick on all 4 sides. You must see! Great home in a GREAT AREA!' ,`Acres` = '0.1616' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 6 KINGSPOINT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '26' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingspoint Sec 01' ,`TaxAmount` = '5364' ,`TaxRate` = '2.753' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709824' WHERE `Matrix_Unique_ID` = '210383441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:02:31.743' ,`MLSNumber` = '31368813' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085551' ,`Longitude` = '-95.183316' ,`PhotoCount` = '7' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Warwick River' ,`StreetNumber` = '3511' ,`StreetSuffix` = 'Trail' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Fairway Collection \"Cabot\" Plan with Elevation \"E\" in Royal Brook at Kingwood! A spacious single-story, 3 bedroom home with a two-bay garage. The gourmet kitchen overlooks the living and dining spaces which lead to a comfortable covered patio. There is plenty of flexibility for family living with two secondary bedrooms and a study, and the owner’s suite with an en-suite bathroom is tucked away for privacy.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0017 BLK 002 LOT 003' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Royal Brook' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709824' WHERE `Matrix_Unique_ID` = '210521335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:50:51.363' ,`MLSNumber` = '89097212' ,`ListAgentFullName` = 'Judy Shryock' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218202' ,`Longitude` = '-95.536076' ,`PhotoCount` = '44' ,`PostalCode` = '77382' ,`RoomCount` = '8' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Arabian' ,`StreetNumber` = '243' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1863' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Come and enjoy the lifestyle of the luxurious Del Webb 55+ community in The Woodlands! This popular \"Abbeyville\" floor plan lives large with a Foyer, 1 Owner\'s Suite Bedroom, 1 Guest Bedroom, Office/Flex Room. The Flex/Office can be converted to a 3rd bedroom if needed, 2 Baths, Gathering Room, Sunroom, Laundry Room with an extra-large walk-in storage closet! The Washer-Electric/Dryer-Gas) stays with home. Home includes many upgrades: gas stove, tile flooring, high ceilings, covered patio with pergola with a retractable screen for added sun protection, custom shelving in Utility Room, primary closet and in the garage. Premium lot that backs up to greenspace with gated access to walking trails. The Del Webb community offers the Lodge where many of the social events are held, 1 indoor pool and 1 outdoor pool, tennis and pickleball courts, gym facility, along with numerous walking trails. Conveniently located near shopping, grocery stores, restaurants and hospitals.' ,`Acres` = '0.1399' ,`Area` = '15' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S402305 - DEL WEBB THE WOODLANDS 05, BLOCK 1, LOT 60' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6092' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb The Woodlands 05' ,`TaxAmount` = '5786' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709824' WHERE `Matrix_Unique_ID` = '210566037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:58:13.453' ,`MLSNumber` = '95469915' ,`ListAgentFullName` = 'Jodi Rutledge' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Alina Bupte' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.964848' ,`Longitude` = '-95.161182' ,`PhotoCount` = '47' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '369900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lake White Rock' ,`StreetNumber` = '13718' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect family home in the GATED section of highly sought after Waters Edge! Super cute front porch welcomes you into a this 4 bedroom 3.5 bath home. FRESHLY Painted featuring soaring ceilings, huge kitchen with fantastic bar great for entertaining. SS appliances, 5-burner gas range & a breakfast nook that opens to a family room filled with natural light. Massive freshly painted primary suite offering vaulted ceiling, sitting area & ensuite with dual vanities, jetted tub & separate shower. Upstairs is a freshly painted expansive gameroom, 3 large bedrooms and 2 full baths. 400 sq ft of extra storage space with decking above the garage. Don’t miss the Community pool, park, access to Lake Houston, playgrounds and more!' ,`Acres` = '0.1941' ,`Area` = '1' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 WATERS EDGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waters Edge Sec 02' ,`TaxAmount` = '9758' ,`TaxRate` = '3.1539' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709825' WHERE `Matrix_Unique_ID` = '210767866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:05:40.063' ,`MLSNumber` = '37260810' ,`ListAgentFullName` = 'Johnny Gay' ,`ListOfficeName` = 'Johnny L. Gay Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001111' ,`Longitude` = '-95.587361' ,`PhotoCount` = '26' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Lago Villa' ,`StreetNumber` = '15602' ,`StreetSuffix` = '' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Jacuzzi w/separate Shower, Energy Saving Windows by Window World(Transferable Warranty) 4/2016\r\n30 year Roof - Replaced 10/2015, Two Wood burning Fireplaces (Family room and Primary Bedroom)\r\nRing Doorbell and Wired Spotlight Camera, Security System, Remote Thermostat, Remote Garage Door.\r\nOutside Storage Shed\r\nTwo patios with ceiling fans. \r\nThere is sitting room adjacent to the primary bedroom and there is a separate breakfast area.' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 Lakewood Village Sec 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Village sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709825' WHERE `Matrix_Unique_ID` = '210773121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:36:36.757' ,`MLSNumber` = '81840189' ,`ListAgentFullName` = 'Veso Kossev' ,`ListOfficeName` = 'The Kossev Group' ,`SellingAgentFullName` = 'Annie Barker' ,`SellingOfficeName` = 'RE/MAX Associates Northeast' ,`Latitude` = '30.072459' ,`Longitude` = '-95.202876' ,`PhotoCount` = '29' ,`PostalCode` = '77339' ,`RoomCount` = '5' ,`ListPrice` = '254000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sherwood' ,`StreetNumber` = '4002' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding Kingwood home freshly remodeled and ready for move-in! Split plan with 3 bedrooms, spacious primary suite with walk-in closet, living room with high ceilings and large window overlooking the spacious back yard. Fresh interior paint, all tile & vinyl plank flooring (No carpet), kitchen with 42\' oak cabinets, granite countertops and stainless steel appliances. Oversized corer lot with private back yard including a covered back patio.' ,`Acres` = '0.1481' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 408 BLK 21 SHERWOOD TRAILS SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '6450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Trails' ,`TaxAmount` = '5132' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709825' WHERE `Matrix_Unique_ID` = '210848072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:19:59.570' ,`MLSNumber` = '91568159' ,`ListAgentFullName` = 'Shelby Crowe' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434034' ,`Longitude` = '-95.440212' ,`PhotoCount` = '46' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Langley' ,`StreetNumber` = '2315' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home 2315 Langley is just waiting for YOU!!!-This gorgeous 2 story Castlerock home with a large backyard-you can have your own oasis-open floor plan-luxurious master downstairs with large walk in closet, his and her sinks soaking tub with separate shower-spacious living area open to the kitchen-laundry room downstairs-kitchen has an island-upstairs you have 3 bedrooms 2 baths and a game room-open to the down stairs--lots of windows for natural light-high ceilings-conveniently located within walking distance to the playground and doggie park-Master-planned community-easy access to 288-restaurants-drug stores-within 3 miles of the new Manvel town center with the new H E B under construction-new family pool under construction opening spring 2023-this one won\'t last long -Call today for your personal tour-' ,`Acres` = '0.1377' ,`Area` = '5' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 4 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '9651' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709825' WHERE `Matrix_Unique_ID` = '210878518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:54:37.847' ,`MLSNumber` = '48449104' ,`ListAgentFullName` = 'Violet Gonzalez' ,`ListOfficeName` = 'Crown Eagle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731174' ,`Longitude` = '-95.515188' ,`PhotoCount` = '38' ,`PostalCode` = '77063' ,`RoomCount` = '12' ,`ListPrice` = '349499.00' ,`Status` = 'Active' ,`StreetName` = 'Roseland Terrace' ,`StreetNumber` = '3112' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lock-N-Leave home in a GATED Community! This 2019 build, 2-story home was designed with first floor 9 ft. ceilings and two downstairs bedrooms with one full bath/shower combo. The impressive kitchen, located on the second floor, opens to the gathering room, with dramatic tray ceiling, making entertaining fun with the kitchen\'s nice granite countertops, plenty of cabinets and stainless steel appliances are all included. You will look forward to coming home after a long day, and relax on your 2nd floor balcony. The primary bedroom\'s bath is a great place to relax with its double vanity sinks and spacious spa shower. Backyard space has astro-turf so maintenance is easy! Great Value and HOA Fee covers water, trash, landscaping, security access gates, swimming pool and a great neighborhood with awesome neighbors AND Near all the great venues in town! Fabulous Location only 3 miles West of the Galleria and Beltway 8, West Chase area. Make an appointment to view TODAY!' ,`Acres` = '0.0432' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 BRIARMONT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1883' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2065' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarmont Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709825' WHERE `Matrix_Unique_ID` = '210893966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:14:48.763' ,`MLSNumber` = '89647766' ,`ListAgentFullName` = 'Aura Pou' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748663' ,`Longitude` = '-95.638254' ,`PhotoCount` = '35' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Flower Garden' ,`StreetNumber` = '1919' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous traditional home located in pristine gated community of Lakes of Parkway and zoned to top rated schools. This home has been meticulously kept, has a three car garage, two downstairs bedrooms (primary bedroom and mother in law suite, each with en suite bathroom), Radiant barrier roof, heated pool, LED lighting, Hardwood floors, Generous play/game room, and an upstairs balcony from which to enjoy your evening! You won’t be disappointed!' ,`Acres` = '0.2009' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 LAKES OF PARKWAY SEC 19 AMEND NO 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Lakes of Parkway Sec 19 Amd' ,`TaxAmount` = '17906' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709825' WHERE `Matrix_Unique_ID` = '211136328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:12:42.407' ,`MLSNumber` = '50296300' ,`ListAgentFullName` = 'Luz Elena Jaramillo' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.899514' ,`Longitude` = '-95.721888' ,`PhotoCount` = '33' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Keegans Ledge' ,`StreetNumber` = '20503' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2323' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home in highly sought after Canyon Lakes West on a great corner lot. This two story house has a bedroom downstairs, leaving room for a large game room upstairs. Plenty of counter space in the kitchen open to the family and dining rooms giving you a perfect space for entertaining! Brand new Dishwasher bought 5/16/2022. Upstairs gameroom boasts plenty of space for a large office, media room or a fourth bedroom with a closet. Close to 290, 99m I-10, tons of great shopping and restaurants with plenty of community amenities in the Cy-fair school district.' ,`Acres` = '0.1511' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 8 PINE CREEK AT CANYON LAKES WEST SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6582' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Creek at Canyon Lake West 02' ,`TaxAmount` = '7413' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709825' WHERE `Matrix_Unique_ID` = '211295487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:08:03.770' ,`MLSNumber` = '34399314' ,`ListAgentFullName` = 'Emily Dieckmann' ,`ListOfficeName` = 'Keller Williams Realty C. P.' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.443233' ,`Longitude` = '-98.002868' ,`PhotoCount` = '38' ,`PostalCode` = '78645' ,`RoomCount` = '4' ,`ListPrice` = '975000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ridge' ,`StreetNumber` = '21010' ,`StreetSuffix` = 'Street' ,`City` = 'Lago Vista' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A treehouse with a deck built around! This custom home was designed by the owners and is a very well-built Silverton Home. \r\n\r\nTall ceilings throughout the home and a beautiful wood-burning fireplace frame the sweeping views of lake Travis and the beautiful Texas Hill Country. The first floor boasts an extremely large owners suite with walls of windows and accordion black out shades. The dining room flows into the big kitchen with an eat in bar and plenty of storage in the walk-in pantry. Upstairs, there are two bedrooms, bathroom, a wet bar, and large game room with private balcony.' ,`Acres` = '0.5832' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3125 LAGO VISTA COUNTRY CLUB ESTATES SEC 10' ,`LotDesciption` = 'Other' ,`LotSize` = '25404' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '114 - Lago Vista' ,`SchoolElementary` = 'LAGO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAGO VISTA HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Lago Vista Country Club Estate' ,`TaxAmount` = '11798' ,`TaxRate` = '2.4782' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709826' WHERE `Matrix_Unique_ID` = '211316576' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211331275','1663709826','211331275','2022-09-12T18:47:07.380','21279586','Suyapa Jedeh','HomeSmart','','','29.745650','-95.301664','24','77011','2','140000.00','Active','Avenue','6821','','Houston','1','0','2','642','Single-Family','Great Investment opportunity in the East End district! Being SOLD \'AS-IS\' WHERE IS- No repairs. PLEASE NOTE: LOT SIZE AND HOUSE SF IS INCORRECT IN APPRAISAL DISTRICT. Lot SIZE 2,500 AND HOUSE 642 SF. Buyer to verify all information including room dimensions, taxes, schools etc. Lot size and square footage per HCAD. Buyer to purchase a Survey. Great potential as new construction is being built in the area. Property has not flooded, prime location with easy access to Medical Center, Southeast of downtown and the Port Of Houston. Please call with any questions.','0.1148','4','','','','','Sellers Disclosure','0','','1','East End Revitalized','Other Heating','0','LTS 13 & 14 BLK 133 CENTRAL PARK','Subdivision Lot','2500','Other','','','0','','0','','0','','','','','Composition','27 - Houston','FRANKLIN ELEMENTARY SCHOOL (HOUSTON)','AUSTIN HIGH SCHOOL (HOUSTON)','EDISON MIDDLE SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','Central Park','2762','2.3307','Public Water','1930','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211355418','1663709826','211355418','2022-09-12T19:00:35.547','2340764','Joan Zaldivar','HoustonDesignHomes.com','','','29.675524','-95.180141','10','77502','10','279000.00','Active','Rayburn','2214','Court','Pasadena','2','1','4','2520','Single-Family','','0.2781','6','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Pasadena','Central Gas','0','LT 32 & TR 33A BLK 1 3.08 FT OF LT 33 PARKVIEW ESTATES SEC 1','Corner','12114','Survey','','','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','41 - Pasadena','FISHER ELEMENTARY SCHOOL (PASADENA)','SAM RAYBURN HIGH SCHOOL','PARKVIEW INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Parkview Estates Sec 01','5746','2.6514','Public Sewer,Public Water','1965','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:26:44.073' ,`MLSNumber` = '96579387' ,`ListAgentFullName` = 'Pamela Smartt' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641634' ,`Longitude` = '-98.114337' ,`PhotoCount` = '26' ,`PostalCode` = '78130' ,`RoomCount` = '10' ,`ListPrice` = '372900.00' ,`Status` = 'Active' ,`StreetName` = 'Legend' ,`StreetNumber` = '4047' ,`StreetSuffix` = 'Meadows' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home under $373,000 and move in ready this 4 bed 2 bath GEHAN Home features a private master bedroom with an extended walk in closet, large walk in shower, upgraded flooring throughout home, a large family room and open floor concept. The gourmet kitchen has an island, granite countertops, walk in pantry, convection oven, gas range and 42\" cabinets. The exterior is landscaped, with privacy fence and charming covered patio in back to relax after a long day. Call today and make this your new home!' ,`Acres` = '0.14' ,`Area` = '83' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LEGEND POND-LEGEND MEADOW PH #4 BLOCK 18 LOT 26 .14 AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '142 - New Braunfels' ,`SchoolElementary` = 'KLEIN ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW BRAUNFELS HIGH SCHOOL' ,`SchoolMiddle` = 'NEW BRAUNFELS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Legend Pond-Legend Mdw Ph 4' ,`TaxAmount` = '7728' ,`TaxRate` = '2.0531' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709826' WHERE `Matrix_Unique_ID` = '211357684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:15:46.010' ,`MLSNumber` = '68436902' ,`ListAgentFullName` = 'Maura Tinoco' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768758' ,`Longitude` = '-95.753571' ,`PhotoCount` = '24' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Forks' ,`StreetNumber` = '22018' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1905' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled one story Home in Cimarron Subdivision! Fresh paint throughout, Updated bathrooms, new doors, granite countertops throughout. Spacious Living room with a fireplace for those cozy winter evenings. Huge game Room/Bonus Room! No Carpet. Spacious fence Backyard allows plenty of room to entertain family and friends. GREAT Location close to shopping and dinning. Zoned to Katy ISD. Schedule your showing today!' ,`Acres` = '0.1873' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 23 CIMARRON SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Sec 06' ,`TaxAmount` = '4239' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709826' WHERE `Matrix_Unique_ID` = '211396815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:34:40.770' ,`MLSNumber` = '79638306' ,`ListAgentFullName` = 'Evan Compean' ,`ListOfficeName` = 'Compean Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740052' ,`Longitude` = '-95.343005' ,`PhotoCount` = '31' ,`PostalCode` = '77003' ,`RoomCount` = '6' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Milby' ,`StreetNumber` = '1410' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction in EaDo and just a couple blocks from the MetroRail and less than a block from the bike lanes! These 4 new homes are located in a gated enclave, with an elegant Modern Farmhouse Design, black fixtures & hardware, 8\' doors, 11\' ceilings, wood floors throughout the common areas on the 2nd floor. The kitchen is open to the dining room (with a wine bar) & living rooms, plus has an island, farmhouse sink, gas range & quartz counters. You will love the primary suite with hardwood floors, large walk-in closet & luxurious bath featuring a frameless shower, freestanding tub & dual sinks. All of this located just minutes from Metro light rail station, the theater district, Minute Maid Park, University of Houston, PNC Soccer Stadium, East River District, and many amazing restaurants, coffee shops & bars. Estimated completion in October/November' ,`Acres` = '0.0368' ,`Area` = '4' ,`BuilderName` = 'Zoe Properties, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 EAST END VILLAGE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1604' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'EAST END VILLAGE' ,`TaxAmount` = '2040' ,`TaxRate` = '2.4557' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709826' WHERE `Matrix_Unique_ID` = '211490682' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211633985','1663709826','211633985','2022-09-12T19:01:45.690','20657184','Blanca Garza','PRG, Realtors','','','30.079926','-95.167488','45','77345','9','364990.00','Active','Scenic Woods','4942','Trail','Houston','3','1','4','3172','Single-Family','NO FLOODING! Welcome to beautiful Kingwood, the livable forest! Don\'t miss 4942 Scenic Woods in the well established, peaceful subdivision of Mills Creek Village. This wonderful home boasts 4 bedrooms, 3.5 bathrooms, two living spaces, on an oversized lot with a lush private pool and yard with a detached garage, giving way to a dramatic driveway fit for a king or queen! Inside the homestead, you\'ll find dramatic two-story high ceilings with near floor to ceiling windows with views of the lush green backyard and tropical aquamarine pool. The home boasts an open floorpan with beautiful windows throughout, giving the property a bountiful veil of brightness. The large kitchen is open to the two story high living area with a large breakfast nook. The formal dining room is adjacent to the chef\'s kitchen, making Christmas and Thanksgiving dinners a breeze! The formal office is on the first floor and can easily be converted into a playroom or guest room. Make your showing appointment today!','0.176','32','','','','','No Disclosures','','Gaslog Fireplace','1','Kingwood East','Central Gas','1','LT 2 BLK 2 MILLS CREEK VILLAGE SEC 3','Subdivision Lot','7667','Appraisal District','','360','0','','2','Electric Oven','1','In Ground','','Electric Range','','Composition','29 - Humble','SHADOW FOREST ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Mills Creek Village Sec 03','7320','2.5839','Public Sewer','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T18:35:31.160' ,`MLSNumber` = '90759129' ,`ListAgentFullName` = 'Will Puente' ,`ListOfficeName` = 'SavvyWay Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700263' ,`Longitude` = '-95.542773' ,`PhotoCount` = '7' ,`PostalCode` = '77036' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Roos' ,`StreetNumber` = '9006' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled and astonishing single-family residential property in a Sharpstown area and quiet neighborhood. The property comes with 3 bedrooms and 2 bathrooms and subsequent living space with fireplace along with a specialized extra parking area in the backyard. Open kitchen with large island & granite counter, stainless steel undermounted sink, high-end dishwasher and gas stove/oven, kitchen cabinets, glass tile backsplash..all new!! Porcelain tile in living, den, entry, kitchen, dining, utility & both baths; vinyl plank in all bedroom areas. Both baths remodeled with new vanity cabinets, granite counter, tub, stone/glass tub & shower surround, shower & tub door, granite counter, sink & faucet, rain shower faucet. All bedroom with walk-in closets. Minutes to Chinatown and major highways like Beltway 8 (Sam Houston Toll Way), I-45, 610. A MUST SEE prop' ,`Acres` = '0.1986' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 18 SHARPSTOWN COUNTRY CLUB TERRACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Country Club Terrac' ,`TaxAmount` = '6243' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709826' WHERE `Matrix_Unique_ID` = '211637528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:27:01.967' ,`MLSNumber` = '30290820' ,`ListAgentFullName` = 'Randall Lewis' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658248' ,`Longitude` = '-95.068117' ,`PhotoCount` = '39' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Trail' ,`StreetNumber` = '10458' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Simply Gorgeous Updated Home w/Pool on Corner Oversized Lot with Mature Oak Trees. Laminate Flooring Thru-out. Open style Kitchen with Granite Counters, Den with Double Doors that over look the Covered Patio and Private Pool/Hot Tub area. Formal Living Room. Built-in Shelves. Many 2021 updates, some include Foundation,Roof, AC/Heat, Flooring/Paint, Fencing,Pool Tile/Equipment. Refrigerator/Washer/Dryer Included. Semi Converted Garage. Ready for Move-in and for your Memories to be made !' ,`Acres` = '0.2192' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 15 FAIRMONT PARK SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '9547' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '28' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LEO RIZZUTO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairmont Park Sec 02' ,`TaxAmount` = '6637' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709826' WHERE `Matrix_Unique_ID` = '211638310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T19:42:57.283' ,`MLSNumber` = '48827154' ,`ListAgentFullName` = 'Amy Phuong Huynh' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861684' ,`Longitude` = '-95.690992' ,`PhotoCount` = '25' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '273000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Bluff' ,`StreetNumber` = '6223' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect starter home or rental opportunity for your portfolio. Nice floor plan home, 3 bedrooms and 2 baths (master bedroom is downstairs). Granite countertop, refrigerator, brand-new electric range, washer, and dryer are all included. Well maintenance, fresh paint entire of the house. Spacious extra room for you to call as an entertainment, guest, or an office. Nice backyard with patio and lot of green. Close to shopping and major highways. It\'s vacant and ready to move-in.' ,`Acres` = '0.1056' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 6 BRENWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brenwood Sec 01' ,`TaxAmount` = '3907' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709827' WHERE `Matrix_Unique_ID` = '211662090' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211864619','1663709827','211864619','2022-09-12T19:49:21.587','5064011','Beverly Bradley','Weekley Homes','','','30.278701','-95.567934','28','77316','6','459000.00','Active','Kingsley Grove','131','Street','Montgomery','2','1','3','2420','Single-Family','Modern technique and classic appeal blend together to build the brilliant lifestyle atmosphere of The Danbridge family home plan. Entertain guests and enjoy your leisure time in the breezy comfort of your expansive covered patio. Your remarkable open floor plan has the space to create the perfect living arrangement for you and yours. Cook up culinary masterpieces in the streamlined kitchen that features plenty of storage, prep surfaces, and a family breakfast island. Design the ultimate home office, library, or art studio in the delightful study with pop-up tray. The spare bedrooms provide inspiring places for unique personalities to flourish. Retire to the effortless elegance of your Owner\'s Retreat, which offers a tray ceiling, spa-experience bathroom with super shower and tons of counter space with a deluxe walk-in closet.','','39','David Weekley Homes','','','','Home Protection Plan,Mud,No Disclosures','1','','','Conroe Southwest','Central Gas','1','Lot 3 Block 1','Cul-De-Sac,Subdivision Lot','6250','Survey','','1500','1','To Be Built/Under Construction','2','Convection Oven,Gas Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied','Builder','1','Contemporary/Modern','Woodforest - Kingsley Square','','2.793','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212146947','1663709827','212146947','2022-09-12T19:50:27.510','2032861','Holly Kaufman','Lee DeForke Jr.','Tyler Green','Krueger Real Estate','29.537251','-95.069211','35','77573','7','439000.00','Option Pending','Emerald Cloud','120','Lane','League City','3','1','4','3147','Single-Family','This gorgeous home located in the Harbour Pointe neighborhood includes 4 bedrooms, 3 and a half bathrooms, a private study enclosed with French Doors, a beautiful kitchen with granite countertops that opens to the living room, and an extra living space at the top of the stairs. Double vanity in the primary bathroom with garden tub and floating glass shower. Enjoy fun in the sun with the in-ground pool, hot tub, and covered patio--it\'s a get-away in your own backyard! Roof updated 2018, interior was re-painted in 2019, and new fence installed in 2020. Within 10min from the Kemah Boardwalk and zoned for the amazing Clear Creek ISD. Come check it out!','0.1906','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','League City','Central Gas','1','HARBOUR POINTE SEC 2 (99), BLOCK 3, LOT 12, ACRES 0.191','Subdivision Lot','8301','Appraisal District','','510','0','','2','Gas Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','9 - Clear Creek','FERGUSON ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','CLEAR CREEK INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Harbour Pointe Sec 2 99','7622','2.0697','Public Sewer,Public Water','1999','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212198171','1663709827','212198171','2022-09-12T19:29:35.127','96761700','LeSean Burren','Keller Williams Realty -SW','','','29.544353','-95.270187','32','77581','7','310000.00','Active','Wheatfield','3402','Court','Pearland','2','1','3','2334','Single-Family','Large move-in ready 2 story home in the heart of Pearland. Large formal dining/living room area in addition to a separate family room that\'s great for large gathering. Spacious game room upstairs great for kids! Close proximity fine dining, shopping, and entertainment. Walking distance to Pearland High School and Independence Park with walking trails and festivals. Centrally located with quick access to all major roads.','0.1641','5','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Pearland','Central Gas','1','RIVER MIST SEC 2 (A0507 ACH&B) PEARLAND , BLOCK 2, LOT 32','Cul-De-Sac','7148','Appraisal District','','360','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','42 - Pearland','SHADYCREST ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','River Mist Sec 1&2','6591','2.8851','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212255929','1663709827','212255929','2022-09-12T18:25:26.480','60873778','Miguel Rosales','Miguel A. Rosales, REALTOR ','Silvia Gonzalez','Vive Realty LLC','29.841761','-95.715929','28','77449','9','279000.00','Option Pending','Wind Trace','4755','Drive','Katy','2','1','4','2205','Single-Family','Vacant on combo. Shows well.','0.1146','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Bear Creek South','Central Electric','1','LT 2 BLK 1 WINDSTONE COLONY SEC 7','Subdivision Lot','4991','Appraisal District','','498','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Windstone Colony Sec 07','5961','2.781','Public Sewer,Public Water,Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212266830','1663709827','212266830','2022-09-12T18:01:09.843','65013351','Katie Long','Alpha Elite Realty','','','29.542635','-95.399686','23','77584','7','400000.00','Active','Rashell','11515','Way','Pearland','2','1','3','2552','Single-Family','OWNER IS A LICENSED REAL ESTATE AGENT IN THE STATE OF TEXAS. \r\nBeautiful one-story home on a cul-de-sac. The home offers 3-4 bedrooms &/or an office. Large kitchen that opens to family room. Kitchen has an updated walk-in pantry and an abundance of natural light. Spacious master bedroom & bathroom features updated shower & cabinets, large mirrors, his & her closets, & high ceilings. Large backyard includes fenced pool, retractable awning, custom-built playset, & gazebo with string lights & misters. Home also features a 4-car garage with an upstairs garage apt. Apt has a full bathroom & its own AC unit. The upstairs also has a large storage room beyond the apartment. Lots of possibilities with this space! The main AC unit was replaced in August 2022 & master bathroom was updated in January 2022. The home is zoned to Alvin ISD & is close to Pearland Town Center & a quick drive to the Med Center. Seller is offering $2,000 at closing to repair the damaged carpet in the master bedroom.','0.3039','5','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Pearland','Central Gas','1','SOUTHGATE SEC 4 (A0300 HT&B) (PEARLAND) BLK 1 LOT 19','Cul-De-Sac,Subdivision Lot','13238','Appraisal District','','375','0','','4','Electric Oven','1','Fiberglass,In Ground','','Electric Cooktop','','Composition','3 - Alvin','RED DUKE ELEMENTARY SCHOOL','SHADOW CREEK HIGH SCHOOL','NOLAN RYAN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Southgate Sec 4','8397','2.8209','Public Sewer,Public Water','2007','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212275328','1663709827','212275328','2022-09-12T19:53:02.620','3003818','Frank Petronella','Berkshire Hathaway HomeServices','','','30.618756','-95.068937','25','77331','7','950000.00','Active','Hilltop','88','Road','Coldspring','3','1','3','3006','Single-Family','BEAUTIFUL, CUSTOM BUILT, AUSTIN STONE, WATERFRONT FULLY FURNISHED HOME ON LAKE LIVINGSTON.\r\nHome features an open concept, one story, three bedrooms, three full bathrooms. The kitchen opens to the den and dining area, with granite countertops, custom cabinets, gas cooktop, plenty of storage. Built in oven/microwave and walk in pantry. Utility room with energy efficient, front loading washer and dryer, and built in cabinet. Beautiful view of the lake from every room! Master bedroom features sliding glass doors to the deck. The den features a stone fireplace, custom cabinets, and that awesome VIEW! Sliding door leads out to the tile floor deck with teak dining table that seats six. See the beautiful sunset from inside while cooking, or out on the deck! Staircase in garage leads to hugh game room that also is used as additional sleeping area. This custom home is wheelchair accessible, all 3 O doors, with the second bedroom large tile shower also wheelchair accessible.','0.7168','64','','','','','Sellers Disclosure','1','Gas Connections','','Lake Livingston Area','Central Gas,Propane','1','CAMILLA LAKE SITES #1, BLOCK 4, LOT 5 PT OF BLOCK 6, LOT 6,,','Water View,Waterfront','31224','Appraisal District','','100','0','','3','Gas Oven','0','','','Gas Range','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Camilla Lake Sites #1','7835','1.6254','Aerobic,Septic Tank,Water District','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212279719','1663709827','212279719','2022-09-12T18:35:23.233','65598233','Jessica Bastidas','Southern Star Realty','','','30.362339','-95.601022','29','77356','4','295000.00','Active','Golfview','124','Drive','Montgomery','2','0','3','1730','Single-Family','Welcome to this beautifully updated 3 bed 2 bath golf course patio home located behind the gates of April Sound. \r\nThis home features nice wood floors, fresh interior paint, new carpet, newer counter tops and a pot filler, nice modern appliances and is ready for immediate move in. The fenced back patio is covered and faces the golf course.\r\nA/C unit was replaced recently (2022). Enjoy the wonderful golf course amenities like tennis and pickleball courts, marina and boat launch, fitness center and dining at the country club restaurant, Phoenix Grill. This home is zoned to Montgomery ISD and Lake Creek High School.','0.0918','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','APRIL SOUND 09, BLOCK 1, LOT 51','On Golf Course,Subdivision Lot','4000','Appraisal District','','234','0','','2','Gas Oven','0','','','Gas Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','April Sound 09','4342','2.2625','Water District','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212387015','1663709827','212387015','2022-09-12T18:54:13.103','10132928','Evan Ballew','JLA Realty','','','30.362741','-95.367887','46','77303','5','565000.00','Active','Sierra Del Carmen','9114','','Conroe','3','0','4','2678','Single-Family','Don\'t miss out on this one! 4 bedrooms + an office, 3 full bath, 1 story home nestled on over an acre in highly sought after Deer Trail Two WITH a completed separate guest apartment and workshop! Inside the main dwelling is an open layout with wood flooring, elevated ceilings, granite counters and stainless steel appliances. The huge master suite leads to an ensuite with double sinks, soaking tub, standup shower and a massive walk-in closet. All 3 guest suites feature oversize closets and ceiling fans. The laundry room is oversize with room for a refrigerator or addl cabinets for storage. Out back sits an outdoor kitchen under the HUGE covered patio! The covered walkway leads to the separate guest apartment that has been 100% completed. This approximate 600 square foot apartment has 1 bedroom, 1 bath and would make an excellent guest quarters or mother-in-law quarters. A 20x20 workshop with its own half bath is attached to the back with plenty of storage space for the lawn equipment','1.1129','19','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','','Conroe Northeast','Central Electric','1','S400603 - DEER TRAIL TWO 03, BLOCK 2, LOT 2','Cleared','48479','Appraisal District','','285','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','PATTERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Deer Trail Two 03','7556','1.8488','Aerobic,Public Water','2017','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212397408','1663709827','212397408','2022-09-12T19:16:25.700','67264634','Jessica Zamarron','Nobles Realty Group, LLC','','','29.486884','-95.061416','24','77573','3','240000.00','Active','Maryland Ave','3010','','League City','2','0','3','1611','Single-Family','Corner lot Home located in the growing community of League City. Don\'t miss out on this 3 bedroom, 2 bath spacious home! Entering through the front door you are greeted with an open concept kitchen and living area. Kitchen has granite counter tops and custom made cabinets. Primary bedroom has a jetted tub/ shower combo. Some updates included in the home include a solar exhaust fan in the attic, and electrical panel. In front of the home there is an RV pad with a 30 amp plug. Shed out back for storage. Great location with easy access to 1-45. Property is being Sold AS IS. Schedule your appointment today!','0.254','33','','','','','Sellers Disclosure','','','','League City','Central Electric','0','ABST 19 PERRY & AUSTIN SUR PT OF LOT 1 & ALL OF 2 (1-0) BLK','Corner','11066','Appraisal District','','','0','','0','','0','','','Electric Cooktop','','Other','17 - Dickinson','SILBERNAGEL ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Supra Keybox','Appraisal','1','Ranch','Dickinson Townsite','','','Public Sewer,Public Water','1972','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212421140','1663709827','212421140','2022-09-12T18:03:45.030','90038645','Ashley Marquez','Nan & Company PropertiesChristie\'s International R','','','29.295508','-94.802706','32','77550','11','425000.00','Active','Avenue L','3228','','Galveston','2','1','4','3362','Single-Family','Welcome to 3228 Avenue L, situated on a magnificent corner lot with large shade trees. This beautiful brick, colonial style home is simply waiting for you to add your personal touches. With 4 generous sized bedrooms, 2.5 baths, formals, a den/library, sunroom and walk-in humidor this home has endless possibilities. Original hardwood floors have been preserved throughout both levels. AC/Furnace replaced in 2019, water heater in 2020. Centrally located and easy access to the Strand or Seawall. This could be a second home or investment property. Call to schedule your tour today!','0.1982','33','','','Electric Dryer Connections','','Sellers Disclosure','0','Gas Connections','1','East End','Central Gas','0','ABST 628 M B MENARD SUR W 83 FT OF LOTS 4 & 5 (4-2) BLK 92 G','Corner','8632','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','No Appointment Required,Supra Keybox','Appraisal District','2','Colonial','Galveston Townsite','5182','2.0662','Public Sewer,Public Water','1965','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212444810','1663709827','212444810','2022-09-12T18:35:22.063','9677273','Samantha Medve','Schultz Texas Properties','','','30.153192','-96.690400','21','78932','2','449000.00','Active','Sugar','130','Hill','Carmine','1','0','2','1080','Single-Family','This adorable barndominium is located under tree shade. There are some beautiful oak trees that frame the driveway and yard. The home was built in 2017 and remodeled in 2022. Updates include, new kitchen cabinets and hardware, new refrigerator, new dishwasher, new microwave, new range, new washer and dryer, new toilet and new water heater. Pex piping was also added and the home has had new vinyl flooring installed.\r\n\r\nBoth bedrooms have closets. The open floor plan makes the home feel larger. Some furniture can convey in the house.\r\n\r\nThis home is about 5-10 min from Round Top and located within about 1 mile of JWs in Carmine.\r\n\r\nBuyer to verify dimensions.','0.472','69','','','Electric Dryer Connections','','Sellers Disclosure','1','','','','Central Electric','0','ULLRICH ADDITION LOT 1, .472 ACRES, HSE, C/PORT','Other','20560','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Aluminum','206 - Round Top-Carmine','ROUND TOP-CARMINE ELEMENTARY SCHOOL','ROUND TOP-CARMINE HIGH SCHOOL','ROUND TOP-CARMINE HIGH SCHOOL','Appointment Required','Appraisal District','1','Barndominium','Ullrich Add','1337','1.4344','Public Sewer,Public Water','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212444925','1663709827','212444925','2022-09-12T18:46:19.690','24770122','Ryan Moody','RE/MAX Leading Edge','','','29.289021','-94.801775','19','77550','4','355000.00','Active','Avenue P','3328','','Galveston','3','0','4','2184','Single-Family','Great investment opportunity centrally located in the heart of Galveston. Property was recently updated and remodeled that included adding 2 additional bedrooms, and an additional bath in the front unit making it a full 3 bedroom, 2 bath. The other unit includes an efficiency with a full bath located in the back of the building. Efficiency unit is rented on a month to month basis. Larger unit has a 2 year lease in place commencing November 1. Located on a corner lot for easy parking and access. The property should provide great cash flow.','','33','','','','','Sellers Disclosure','1','','','East End','Central Gas','0','ABST 628 M B MENARD SUR S 1/2 OF LOT 14 (3014-1) SE BLK 62 G','Other','2580','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','1','Traditional','Galveston Outlots','2996','2.0662','Public Sewer,Public Water','1967','Appraisal District'); --> New record created successfully