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-11-19T22:18:29.600' ,`MLSNumber` = '70589519' ,`ListAgentFullName` = 'Sarah Hartwell' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.420870' ,`Longitude` = '-95.251669' ,`PhotoCount` = '31' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Beauregard' ,`StreetNumber` = '404' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is your opportunity to own a piece of history! Welcome to Twin Oaks, a beautiful Victorian home built by A.J. Birchfield, the first editor of the Alvin Sun. Also dubbed Birchfield-McCown House, this is one of only two Historic Homes in Alvin with a Texas Historical Marker beside the front door. Often a storm refuge, the home kept over 100 safe in the famed 1900 coastal hurricane. Four leading townspeople have owned this 12-room Victorian structure. Enjoy the lush oversized corner lot from the upper and lower wrapping porches. The driveway is flanked by 100+ year old twin oak trees. Much of the interior is painted with traditional Victorian era colors. Original stairway & crown moldings, some original hardwoods, high ceilings, en-suite bath in Primary. Updated kitchen with granite and island opens to the side & back decks. Close proximity to Sealy Park, the community garden, & Alvin High! This is an as-is sale; no repairs to be made by Seller. Inspection and HVAC estimate in Docs.' ,`Acres` = '0.287' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas,No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ALVIN NO 1 (ALVIN), BLOCK 56, LOT 9-10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'ALVIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Alvin 1 Alvin' ,`TaxAmount` = '8522' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1901' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054541' WHERE `Matrix_Unique_ID` = '208253770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:26:25.870' ,`MLSNumber` = '82609825' ,`ListAgentFullName` = 'Theresa Churgin' ,`ListOfficeName` = 'Churgin Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872092' ,`Longitude` = '-93.942091' ,`PhotoCount` = '17' ,`PostalCode` = '77640' ,`RoomCount` = '3' ,`ListPrice` = '69000.00' ,`Status` = 'Active' ,`StreetName` = '9th' ,`StreetNumber` = '131' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment opportunity, property needs a complete remodel and is priced accordingly. Schedule your showing today, property is priced to sell quickly!' ,`Acres` = '0.1607' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 44 CITY OF PORT ARTHUR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'DEQUEEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Arthur City' ,`TaxAmount` = '1333' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054542' WHERE `Matrix_Unique_ID` = '210504342' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:52:12.890' ,`MLSNumber` = '95718440' ,`ListAgentFullName` = 'Diane Boyd' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144090' ,`Longitude` = '-95.542220' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '14' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Sawyer Ridge' ,`StreetNumber` = '67' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2923' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Showings Start Tuesday, Nov 1st. Luxurious and Gorgeous hard to find Single Story home in the coveted neighborhood of Liberty Branch! The beautiful front porch welcomes you into this stunningly detailed and upgraded home. This exceptional home is rich in architectural purity with a neutral color palette and offers a culinary inspired kitchen with upgraded cabinetry, stainless appliances and granite counters. The kitchen is open to the grand family room which offers a floor to ceiling stoned gas log fireplace. You will love the open-concept floor plan that is adorned with rich hardwood floors throughout, architectural wood beams, art niches, eyebrow archways, soaring ceilings, wine room with scrolled iron door and wine fridge, home office with French doors. Primary retreat with tray ceilings, bay window sitting area and large relaxing primary bath. The back covered patio is one of three covered patios and features a built-in grill. Three Car Garage!' ,`Acres` = '0.1952' ,`Area` = '14' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park' ,`TaxAmount` = '13448' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054542' WHERE `Matrix_Unique_ID` = '211959934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:10:14.750' ,`MLSNumber` = '76364221' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.946471' ,`Longitude` = '-95.295190' ,`PhotoCount` = '34' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Seabean' ,`StreetNumber` = '445' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom Surfside Beach House for under $400K!! The \"Sunset Odyssey\" has an open floorplan, upgraded flooring, extended deck for entertaining friends and family and a back deck for your Sunsets. The updated kitchen with quartz countertops, induction range w/ air fryer, undercabinet lighting, freshly installed cabinets, upgraded lighting fixtures, and home water filtration system with make you and your guest smile. After a long day at the beach relax & stay cool with recently installed AC, and shower with the on-demand tankless water-heater. Furry family members have access to multiple fenced areas and driveway to park beach toys or hang a hammock for an afternoon nap in the shade. Looking to store your beach toys.... there are 2, the louvered storage on concrete pad and 2nd storage bldg in the backyard surrounded by chain-link fenced yard. Upgraded wiring on the ground floor. View the back deck sunsets and live your best beach life at the Sunset Odyssey a Signature Property.' ,`Acres` = '0.18' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GULF RIDGE (A0051 F J CALVIT TR G) BLK 1 LOT 10-10A SURFSIDE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Gulf Ridge' ,`TaxAmount` = '5667' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054542' WHERE `Matrix_Unique_ID` = '212351717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:09:00.700' ,`MLSNumber` = '22064120' ,`ListAgentFullName` = 'Casey Waters' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '32.072414' ,`Longitude` = '-96.800255' ,`PhotoCount` = '29' ,`PostalCode` = '76641' ,`RoomCount` = '5' ,`ListPrice` = '155000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fm 667' ,`StreetNumber` = '8281' ,`StreetSuffix` = '' ,`City` = 'Frost' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious home lies just outside the city limits of the quiet town of Frost, TX. The massive back yard pairs wonderfully with the spacious home to breath in the fresh Texas air. The open kitchen features lots of counter space and a coveted double oven. The huge garage accommodates a variety and combination of uses. The home has a storm shelter for added safety when the storms come through. If you’re ready to slow down and enjoy the sunsets over your back yard, this great home is ready for you.' ,`Acres` = '1' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A10286 J FRENCH ABST TRACT 9 1.0 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '532 - Frost' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (FROST)' ,`SchoolHigh` = 'FROST HIGH SCHOOL' ,`SchoolMiddle` = 'FROST HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'J French Abst' ,`TaxAmount` = '2088' ,`TaxRate` = '1.9576' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054542' WHERE `Matrix_Unique_ID` = '212376445' --> 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','213319167','1669054542','213319167','2022-11-19T22:06:47.603','39761743','Ken Luu','RE/MAX Fine Properties','','','29.690557','-95.602311','50','77072','11','300000.00','Active','Ashford Trace','7911','Drive','Houston','3','0','4','2262','Single-Family','Lovely 4/3/2 in a gated community features two story foyer entry, open concept living, Tile floor on the ground floor and Engineer wood floor on the second floor, Kitchen with granite counters, stainless steel appliances and large kitchen island opens to Family room with fireplace, One bedroom & a full bath on the first floor is convenient for the older parents, Spacious private master on the floor with large garden tub, separate shower, dual vanities, and walk-in closet together with two other secondary bedrooms and a game room. The house is located near many Great restaurants and Supermarkets. Minutes from Westpark Tollway, the Beltway and US 59. WATER & SEWER, TRASH PICKUP, AND LAWN SERVICES FOR FRONT AND SIDE YARD ARE INCLUDED IN THE HOA FEE.','0.0595','28','','','','','Sellers Disclosure','1','Gas Connections','1','Alief','Central Gas','1','LT 13 BLK 1 ASHFORD TERRACE 2ND AMEND','Patio Lot','2593','Appraisal District','','2100','0','','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Gas Range','','Composition','2 - Alief','LIESTMAN ELEMENTARY SCHOOL','AISD DRAW','KILLOUGH MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Ashford Terrace Amd 2','5262','2.4411','Public Sewer,Public Water','2016','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T22:37:00.240' ,`MLSNumber` = '7717586' ,`ListAgentFullName` = 'Victor Burks' ,`ListOfficeName` = 'Buyer First Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670376' ,`Longitude` = '-95.380607' ,`PhotoCount` = '9' ,`PostalCode` = '77051' ,`RoomCount` = '5' ,`ListPrice` = '205990.00' ,`Status` = 'Active' ,`StreetName` = 'Bassett' ,`StreetNumber` = '8414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home remodeled. Updated in and out. Media Room and 3 bedrooms.' ,`Acres` = '0.1148' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 12 SOUTHERLAND PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Southerland Place' ,`TaxAmount` = '1624' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054543' WHERE `Matrix_Unique_ID` = '213326401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:01:59.417' ,`MLSNumber` = '87568512' ,`ListAgentFullName` = 'Katy Pugh' ,`ListOfficeName` = 'Hodde Real Estate Company' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.169618' ,`Longitude` = '-96.392202' ,`PhotoCount` = '22' ,`PostalCode` = '77833' ,`RoomCount` = '5' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '704' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 1920\'s restored Craftsman is 1516 Sq/Ft, 3 beds-2 baths, with garage & garden shed, & big backyard with deck & privacy fence. Currently an Airbnb, \"Sugarlumps Guesthouse\" is named after Sugarlump, a sweet lady who lived there for many years. Gorgeous original wood floors, claw-foot bathtubs in bathrooms, antique doors, & original shiplap are a few of the details we love about the house. \r\nA unique Butler’s Pantry with antique pine sink base opens into a sunny & bright kitchen with butcher block counters, nice sized island with sink, & plenty of cabinets for storage. Lovely double antique doors lead into the utility room. Front two bedrooms share bath suite with antique pine door, antique sink, clawfoot tub & charming tile. Third bedroom located off the kitchen offers it\'s own bathroom with antique sink & clawfoot tub.\r\nA short walk to Downtown Brenham & a 20 minute drive to Round Top make the location ideal for antique shopping. Please call Katy to see this darling home.' ,`Acres` = '0.2284' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DAYS , LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9951' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Days' ,`TaxAmount` = '3510' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669054543' WHERE `Matrix_Unique_ID` = '213475221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:01:57.000' ,`MLSNumber` = '60558940' ,`ListAgentFullName` = 'Andrew Bearden' ,`ListOfficeName` = 'Insight Realty Network' ,`SellingAgentFullName` = 'Rizwan Adenwalla' ,`SellingOfficeName` = 'Welcome Home Residential, LLC' ,`Latitude` = '29.643404' ,`Longitude` = '-95.711182' ,`PhotoCount` = '35' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '455000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tranquil Harvest' ,`StreetNumber` = '3451' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Former David Weekley Model Home in one of the best neighborhoods. New construction with every upgrade imaginable. Open. Light and Bright. Gourmet kitchen with stainless appliances and huge island. Spa-like primary bath with the oversized shower of your dreams. Upgraded tile and wood throughout with high-end carpet in the bedrooms. Many energy efficiency features. Secondary bedrooms are separated from the primary bedroom. Lush landscaping and a lovely covered patio.' ,`Acres` = '0.1258' ,`Area` = '37' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HARVEST GREEN SEC 30, BLOCK 4, LOT 8' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5482' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Green Sec 30' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054543' WHERE `Matrix_Unique_ID` = '213610282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:51:56.420' ,`MLSNumber` = '22453853' ,`ListAgentFullName` = 'Richard Boyd' ,`ListOfficeName` = 'Paul Lindsey Carlson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647187' ,`Longitude` = '-95.140100' ,`PhotoCount` = '25' ,`PostalCode` = '77505' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Cross' ,`StreetNumber` = '4210' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home. Must see 3 bed 2 bath move in ready home located in Deer Park ISD. Single story with split floor plan. Formal dining and living rooms. Living room has a nice gas log fireplace with granite step-out and beautiful brick pillars. Primary bath has decorative dual vanities and a garden tub. Wood laminate flooring throughout. Located within walking distance from community pool. Reserve your showing now, house will not last long.' ,`Acres` = '0.1663' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 93 BLK 3 VILLAGE GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove Sec 01' ,`TaxAmount` = '6218' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054543' WHERE `Matrix_Unique_ID` = '213778691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T22:54:48.373' ,`MLSNumber` = '58082939' ,`ListAgentFullName` = 'Kurt Kopczynski' ,`ListOfficeName` = 'Oak Story Realty, LLC.' ,`SellingAgentFullName` = 'Sandra Lewis' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.654688' ,`Longitude` = '-95.537016' ,`PhotoCount` = '30' ,`PostalCode` = '77031' ,`RoomCount` = '8' ,`ListPrice` = '219900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Haverstock' ,`StreetNumber` = '8704' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impeccably maintained 2-story patio home located in desirable Glenshire East! 3 bed, 2 bath house with large family room featuring a gas fireplace, spacious bedrooms, and plenty of natural light throughout. The primary suite features a large window, tub/shower combo, and a walk-in closet. Two spacious secondary bedrooms featuring walk-in closets in each and a full bathroom with a bonus secret room are on the second floor. The kitchen has painted cabinetry, pristine condition harvest gold appliances, a double sink, and the fridge stays! The large garage has plenty of room for two cars and additional storage. Washer/dryer are included! The generously sized side yard with two included storage sheds is perfect for entertaining, playing, or relaxing. Fresh landscaping and a beautiful courtyard outside of the home. HOA dues cover courtyard lawn care, trash, pool access, and security patrol. Low tax rate and a great location to major highways. Make your appointment today!' ,`Acres` = '0.0732' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 62 1/94 INT COMMON LAND & ELE RES A BLK 9 GLENSHIRE PATIO' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenshire Patio Homes' ,`TaxAmount` = '3745' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054544' WHERE `Matrix_Unique_ID` = '213833686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:14:50.673' ,`MLSNumber` = '8850033' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047674' ,`Longitude` = '-95.394133' ,`PhotoCount` = '28' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '219800.00' ,`Status` = 'Active' ,`StreetName` = 'Earlmist' ,`StreetNumber` = '23326' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3-bedroom, 2 baths and 2 garage one story home!. Recently updated with tile flooring and new carpets. Fresh paint throughout inside and outside of the home. New appliances and new fans/lights. High vaulted ceiling family room with wood burning fire place and spacious kitchen/dining area. Huge backyard ready to entertain! Move in ready. Great schools nearby with awesome shopping centers down the road. Close to 1960 W, tollway, and near 45 N. Schedule your show today!' ,`Acres` = '0.168' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 5 TIMBER LANE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane Sec 6' ,`TaxAmount` = '3914' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054544' WHERE `Matrix_Unique_ID` = '213904211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:08:15.803' ,`MLSNumber` = '91097450' ,`ListAgentFullName` = 'Angie McCartha' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Luis Zelaya' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.889364' ,`Longitude` = '-95.482880' ,`PhotoCount` = '44' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '267500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gallant Forest' ,`StreetNumber` = '6126' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated, brick, one story 3 bed/2 bath home. The main, large, open concept living space has new tile floors, a floor to ceiling white brick gas fireplace, large windows showcasing the backyard, and tall ceilings with a central beam. The renovated kitchen features granite countertops, a center island, lots of cabinets, a double door pantry, large windows for natural light and space for dining. From the kitchen you have access to a two car garage with a side door. After entering the home, on the immediate right, there are two skylights in the ceiling, brightening up another shared living space before entering into all three bedrooms. All bedrooms feature walk in closets, a single large window to optimize wall space and new carpet. Both bathrooms feature double sinks. The primary bathroom includes two separate walk-in closets! This house has never flooded and is not in the flood zone. Easy access to both I-45 and 290 and is located northwest of the Heights. Zoned to Klein ISD.' ,`Acres` = '0.1641' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 15 INWOOD NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood North' ,`TaxAmount` = '4176' ,`TaxRate` = '2.6055' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054544' WHERE `Matrix_Unique_ID` = '214068543' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T22:27:08.457' ,`MLSNumber` = '32825581' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508515' ,`Longitude` = '-95.732768' ,`PhotoCount` = '13' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Madera Landing' ,`StreetNumber` = '2450' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Wildflower Collection \"Brenham II\" Plan with Elevation \"A\" in Walnut Creek! This spacious, single-story home features a large family room, a kitchen with a center island and an adjoining breakfast space that overlooks a covered patio. The owner’s suite enjoys a large walk-in closet and a private entry that leads to a second walk-in closet and a laundry room. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 002 LOT 001' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Creek at Stone Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.002307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054544' WHERE `Matrix_Unique_ID` = '214098861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:31:58.793' ,`MLSNumber` = '43007879' ,`ListAgentFullName` = 'Alma Martinez' ,`ListOfficeName` = 'Rice Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835959' ,`Longitude` = '-95.458727' ,`PhotoCount` = '32' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Verdome' ,`StreetNumber` = '4510' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home! Brand new baths with new plumbing, custom made kitchen cabinets, granite countertops, tile floors in the kitchen plus all new plumbing.The rest of the home comes with the original wood floors, professionally refurbished to maintain that beautiful look. Brand new roof installed in Dec 2021, Brand new HVAC system, New Tankless water heater, Brand new double-wide driveway, New gutters system throughout the house NOT only the front. Never flooded.' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 6 OAK FOREST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 15' ,`TaxAmount` = '5419' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054544' WHERE `Matrix_Unique_ID` = '214153719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:51:31.537' ,`MLSNumber` = '49495813' ,`ListAgentFullName` = 'Tony Foster' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = 'Hongyan Liu' ,`SellingOfficeName` = 'AlphaMax Realty Inc.' ,`Latitude` = '29.956805' ,`Longitude` = '-95.731266' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '394900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Raven Shore' ,`StreetNumber` = '12302' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2284' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'How would you like to own this lovely home on a large, oversized lot in the desirable Lakeland Village of Bridgeland? Great curb appeal with open front porch leading from the separate pathway and nestled in a cul-de-sac. Kitchen with RO filter system with plenty of countertop space and a large island is open to the living area. Wired ethernet/cable to every room and built-in surround sound. 3 good sized bedrooms and office for working from home plus a bonus game room. Custom built-ins throughout for much needed storage. Covered patio in the pool-sized backyard which backs up to a hiking/biking trail. New flooring, granite countertops and freshly painted interior in 2022, roof and water softener in 2021. Spacious decked attic space above entire garage. With over 250 miles of trails, numerous parks and playgrounds, leisure pools and heated lap pools open year-round, this community has something to offer everyone. Zoned to Bridgeland High School in the highly acclaimed Cy-Fair ISD.' ,`Acres` = '0.2817' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 4 SHORES SEC 1 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '12271' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POPE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '8810' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054545' WHERE `Matrix_Unique_ID` = '214174319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:19:51.370' ,`MLSNumber` = '14445431' ,`ListAgentFullName` = 'Joe LaBorde' ,`ListOfficeName` = 'Green Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.031311' ,`Longitude` = '-95.484782' ,`PhotoCount` = '18' ,`PostalCode` = '77379' ,`RoomCount` = '7' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Villas' ,`StreetNumber` = '4476' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT LOCATION!! Spacious 4 Bedroom home with 2 1/2 baths on a quiet cul-de-sac. Fresh paint throughout and new carpet upstairs. Primary Bedroom features a vaulted ceiling and updated ensuite. Home features a spacious living room, as well as a den with fireplace. Large backyard with wood deck. Home is zoned to award winning Klein ISD, and minutes away from great shopping & dining. Easy access to HWY249, 99 and BLTWY 8. Never Flooded!!' ,`Acres` = '0.1763' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 27 BLK 1 R/S RES A CYPRESS VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '513' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Villas' ,`TaxAmount` = '3353' ,`TaxRate` = '2.4145' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054545' WHERE `Matrix_Unique_ID` = '214375692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:27:37.783' ,`MLSNumber` = '82002994' ,`ListAgentFullName` = 'Deborah Pye Thompson' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895282' ,`Longitude` = '-95.493039' ,`PhotoCount` = '20' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Wildspruce' ,`StreetNumber` = '8902' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedrooms, 2 1/2 baths, 2 story; loft/gameroom; corner lot; spacious yard; indoor laundry room; covered patio' ,`Acres` = '0.1683' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,No Disclosures,Probate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 10 INWOOD NORTHWEST SEC 1 PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '7331' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '40' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EILAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Northwest Sec 01 Prcl R' ,`TaxAmount` = '3772' ,`TaxRate` = '2.6055' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054545' WHERE `Matrix_Unique_ID` = '214459978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:31:13.040' ,`MLSNumber` = '16960617' ,`ListAgentFullName` = 'Linda Jamail Marshall' ,`ListOfficeName` = 'Linda Marshall, Realtors Inc.' ,`SellingAgentFullName` = 'Ibrahim Massoud' ,`SellingOfficeName` = 'Vive Realty LLC' ,`Latitude` = '29.808828' ,`Longitude` = '-95.380242' ,`PhotoCount` = '28' ,`PostalCode` = '77009' ,`RoomCount` = '9' ,`ListPrice` = '329900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Link Road' ,`StreetNumber` = '738' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly added luxury vinyl floors, paint, some newly replaced appliances HEIGHTS PATIO HOME-1ST FLR LIVING, NEWLY REDONE KITCHEN AND LUXURY VINYL FLOORS FIRST AND 2ND FLOORS. FREESTANDING-IN GATED DEVELOPMENT, Available November 30th , THIS PATIO HOME HAS 2 LIVING AREAS, 1 is a GAMEROOM w/full bath, 3/4 Bedrooms, 3 1/2 Baths- Attractive floorplan with Kitchen looking to Living & Dining, Granite Breakfast bar, BIG MASTER BEDROOM WITH GREAT MASTER BATH, DOUBLE VANITY, SEPARATE SHOWER and TUB, GOOD CLOSET SPACE, Energy Efficient features(Low E-Windows, Radiant Barrier & smart home wiring), ALL APPLIANCES INCLUDED, corporate rental is allowed in this subdivision' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'ANC HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLOCK 1' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'Traditional' ,`Subdivision` = 'ENCLAVE AT NEW HEIGHTS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054545' WHERE `Matrix_Unique_ID` = '214500595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T22:10:59.897' ,`MLSNumber` = '33589132' ,`ListAgentFullName` = 'Caroline Gonzales' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.375655' ,`Longitude` = '-97.650806' ,`PhotoCount` = '35' ,`PostalCode` = '78754' ,`RoomCount` = '4' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Gossamer' ,`StreetNumber` = '11508' ,`StreetSuffix` = 'Drive' ,`City` = 'Austin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1799' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story 3 bedroom home nestled on an oversized (11,522 sqft lot) cul-de-sac lot with inviting curb appeal & an expansive backyard with deck in the desired neighborhood of Pioneer Crossing West. Showcasing upgrades throughout the interior and exterior of the home that include NEW top quality Anderson windows, double hinged, NEW blinds, NEW irrigation system, NEW AC/Furnace with updated duct work, NEWer Roof, NEWer water heater, NEWer Oven, Ceramic tile throughout living spaces, solar panels, 42\" cherry finish kitchen cabinets, Corian counters, stainless appliances & more. Highly desired floor plan offers an open concept with kitchen opening to the dining room, breakfast nook & living room. Primary suite offers a fantastic flex room which could be a study, nursery, or reading room. Primary bathroom showcases a separate shower/tub & walk-in closet. This home is a must see!' ,`Acres` = '' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 25 BLK Y PIONEER CROSSING SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '39' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '116 - Manor' ,`SchoolElementary` = 'PIONEER CROSSING ELEMENTARY' ,`SchoolHigh` = 'MANOR HIGH SCHOOL' ,`SchoolMiddle` = 'DECKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pioneer Crossing West' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054546' WHERE `Matrix_Unique_ID` = '214530644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T22:07:00.380' ,`MLSNumber` = '78634582' ,`ListAgentFullName` = 'Polina Vasilyeva' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.715383' ,`Longitude` = '-95.446622' ,`PhotoCount` = '50' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '1225000.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '4230' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury, class, and charm fill the walls of this meticulously designed 4 bed 3 and a half bath beautiful home in Colonial Terrace. It is located in a highly desired neighborhood, assigned to exemplary schools. This stunning home is unique in its architectural design and interior renovation featuring open concept living area, high ceilings, fireplace, custom built cabinets and granite countertops in the kitchen, custom built - in shelves in the living area and hardwood floor throughout. Large primary bedroom with sitting area and stylish bath featuring a tub, separate shower, dual sinks, and walk-in closet. Two secondary bedrooms and a sunroom. Updates include fresh paint throughout, new floor in sunroom and half bath, refinished hardwood floors, new designer choice lightings just to new a few. This gorgeous home stands out, provides luxury and comfort of the place to be called home.\r\nEasy access to downtown, Texas Medical Center, Greenway Plaza and Rice University.' ,`Acres` = '0.1148' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 13 COLONIAL TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Colonial Terrace' ,`TaxAmount` = '22718' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054546' WHERE `Matrix_Unique_ID` = '214586268' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:51:36.467' ,`MLSNumber` = '58294128' ,`ListAgentFullName` = 'Joseph Huber' ,`ListOfficeName` = 'Alchemist Real Estate' ,`SellingAgentFullName` = 'Vanessa Valderrama' ,`SellingOfficeName` = 'Compass RE Texas, LLCKaty' ,`Latitude` = '30.047648' ,`Longitude` = '-95.362540' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '155000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wintergate' ,`StreetNumber` = '23318' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing opportunity and perfect for a first time home buyer. Home features vaulted ceilings in the living room and tile flooring throughout, kitchen is light and bright with great cabinet space and refrigerator is included. With minor TLC you can bring this home to top of the market. Fully fenced private backyard with no back neighbors on a quiet street. Easy access to hardy toll road and zoned to Spring ISD. Easy to show so don\'t wait this home wont last long!' ,`Acres` = '0.1584' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 8 BIRNAM WOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Birnam Wood Sec 04' ,`TaxAmount` = '2990' ,`TaxRate` = '2.6068' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054546' WHERE `Matrix_Unique_ID` = '214632846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:19:32.420' ,`MLSNumber` = '30197175' ,`ListAgentFullName` = 'Kaitlin Jaschek' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = 'Arti Solanki' ,`SellingOfficeName` = 'Livin Large Realty, LLC' ,`Latitude` = '29.540888' ,`Longitude` = '-95.199738' ,`PhotoCount` = '28' ,`PostalCode` = '77546' ,`RoomCount` = '13' ,`ListPrice` = '509000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cherry Tree' ,`StreetNumber` = '134' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3351' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious, updated, & stunning open-concept single-story home where the design & details set it apart from the rest! Enter directly into the main living space that encompasses the family room with hardwood floors & a charming brick fireplace with custom built-ins, an inviting dining room, & a statement kitchen with a massive quartz island, a large fireclay farmhouse sink, updated soft-close cabinetry, matte black appliances, & leathered granite counters. The master suite is breathtaking with separate his & hers vanities & closets with built-ins and a large walk-in shower with dual shower heads & a rain-shower feature. This home boasts a unique flex space with both interior & exterior access, making it useable as a massive game room, a mother-in-law suite, or an income-producing rental space that offers a stone fireplace, a bonus kitchen, a private bath, & the 4th bedroom. Outdoors, the concrete patio overlooks the park-like yard with mature trees. It\'s a must-see in FISD!' ,`Acres` = '0.2541' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 20 PERRY & AUSTIN SUR LOT 37 ENCHANTED WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Enchanted Woods' ,`TaxAmount` = '9483' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054546' WHERE `Matrix_Unique_ID` = '214668608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:24:03.070' ,`MLSNumber` = '78476379' ,`ListAgentFullName` = 'Manuel Castro' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681589' ,`Longitude` = '-95.112636' ,`PhotoCount` = '35' ,`PostalCode` = '77536' ,`RoomCount` = '9' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Luella' ,`StreetNumber` = '3305' ,`StreetSuffix` = 'Avenue' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nothing like living in the birthplace of Texas, look no further and come check out this one of a kind property in the heart of Deer park Tx. About 1 1/2 acres of land this beautiful home sits on, packed with 3 bedrooms and 2 baths and a open floor plan for the living area and dining room, and kitchen has a touch of a ranch style kitchen that i\'m sure will love. The driveway leads to the back where the detached two car garage is located. A very spacious backyard that contains a cabana located in the center of the backyard to enjoy your weekends with family and friends, but if you think we are done, not even close because this property continues beyond the backyard for nearly an acre of land and has a ranch style barn perfect for farm animals. Don\'t miss out on Country living in the city. All Amenities available mere minutes away (Foodtown, Deer Park food mart, Square D food market, Dutch Bros. Coffee) so come and check it out and see why this home and land is the perfect place for you' ,`Acres` = '1.3495' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 12E & 12 1/2C DEER PARK OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '58785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Deer Park Outlots' ,`TaxAmount` = '7563' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054547' WHERE `Matrix_Unique_ID` = '214758247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:00:10.627' ,`MLSNumber` = '34812103' ,`ListAgentFullName` = 'Kelly Schmigel' ,`ListOfficeName` = 'Tramco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.050430' ,`Longitude` = '-95.445452' ,`PhotoCount` = '23' ,`PostalCode` = '77388' ,`RoomCount` = '8' ,`ListPrice` = '309500.00' ,`Status` = 'Active' ,`StreetName` = 'Teller' ,`StreetNumber` = '19711' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely updated 3 bedroom, 2 bath home available in Klein ISD! Conveniently split floorplan with both formal dining and living areas. Home has been extensively remodeled with new flooring, doors, bathrooms, lighting, countertops, fixtures, blinds and more with fresh paint throughout. Gourmet island kitchen with gorgeous countertops, new appliances, and gas cooking which overlooks family room with a cozy fireplace. Oversized master bedroom with en-suite bath featuring double sinks, soaking tub and separate shower with a huge walk-in closet. Home is perfectly located with easy access to 45 and 99. Call to schedule a viewing today - won\'t last long!' ,`Acres` = '0.2057' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 DEVONSHIRE WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Devonshire Woods Sec 01' ,`TaxAmount` = '4870' ,`TaxRate` = '2.534' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054547' WHERE `Matrix_Unique_ID` = '214830505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T21:17:44.627' ,`MLSNumber` = '9340896' ,`ListAgentFullName` = 'Shadrick Bogany' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710244' ,`Longitude` = '-95.291469' ,`PhotoCount` = '32' ,`PostalCode` = '77087' ,`RoomCount` = '7' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Japonica' ,`StreetNumber` = '7139' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful home is simply a stunning Modern home in Pecan Park. Its an open floor plan with an island kitchen and quartz countertop and stainless steel appliances. Self-closing cabinets and drawers come with a refrigerator. Split floor plan with lots of windows and a front porch and huge back yard with large cover patio. A very unique home and style close to shopping and near downtown and the University of Houston. If living inside the loop is important then this is the right home. It has a simple wow factor and a yard big enough for a pool.' ,`Acres` = '0.1263' ,`Area` = '4' ,`BuilderName` = 'Hatteras Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 50 PECAN PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SOUTHMAYD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pecan Park' ,`TaxAmount` = '897' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054547' WHERE `Matrix_Unique_ID` = '214839103' --> 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','214904130','1669054547','214904130','2022-11-19T22:40:06.763','21860895','Nena Hernandez','House Matchmaker Group','','','29.874843','-95.505185','20','77040','7','275000.00','Active','Williams','7618','Street','Houston','2','0','3','1426','Single-Family','This is the one you been waiting for , Welcome Home .This 3 bedroom, 2 full bathroom home has amazing natural light through out .As you walk in ,you will notice the beautiful porcelain tile floors .Step into the kitchen ,ample and eye catching stylish backsplash with quartz Countertops and stain steel appliances .The Primary suite offers a large walk in closet, you will fall in love with .This home features Wood tile floors through out the home. This Property is completely renovated .Some Upgrades include brand new HVAC Unit , new roofing and new water heater . Large Backyard for your outdoor fun including a cover sitting area .Home sweet Home!','0.1515','11','','','','','Sellers Disclosure','1','','','Northwest Houston','Central Electric','1','LT 9 BLK 7 WOODLAND TRAILS NORTH SEC 4','Subdivision Lot','6600','Appraisal District','','155','0','','0','','0','','','Gas Range','','Wood Shingle','1 - Aldine','ERMEL ELEMENTARY SCHOOL','EISENHOWER HIGH SCHOOL','GARCIA MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Right Side,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Woodland Trails North Sec 04','3327','2.5119','Public Water','1973','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','214943418','1669054547','214943418','2022-11-19T22:45:59.580','82277650','Jennie Green-Prats','1st Choice Realty','','','28.945369','-95.358073','3','77541','3','91500.00','Active','10th','723','Street','Freeport','1','0','3','1028','Single-Family','Home needs TLC. Needs new flooring. 3 large bedrooms and 1 bath. Large fenced back yard. Large bathroom','0.14','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Freeport','Central Electric','0','SOUTH VIEW GARDENS (FREEPORT), BLOCK 6, LOT 9','Cleared','6098','Appraisal District','','','0','','0','Freestanding Oven','0','','','Electric Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch','South View Gardens Freeport','2865','2.5981','Public Sewer,Public Water','1955','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','214946346','1669054547','214946346','2022-11-19T22:12:28.423','39139697','Robert Peltier','Bob Peltier & Associates','','','29.190548','-95.418552','17','77515','3','179900.00','Active','Heather','1220','Lane','Angleton','2','0','3','1347','Single-Family','Cute 3/2/2 brick on slab, in an established neighborhood. A screened-in patio and a fenced backyard. Grades 1-12 in walking distance, as well as Brushy Bayou Park and Freedom Park. Restaurants and shopping just a few minutes away.','0.1816','5','','','','','No Disclosures','','','','Angleton','Central Electric','0','MEADOW CREEK (ANGLETON) BLK 5 LOT 6 (E/2) - LOT 7 (W/2)','Subdivision Lot','7910','Appraisal District','','','0','','2','','0','','','','','Composition','5 - Angleton','NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Meadow Creek Angleton','3833','2.6102','Public Sewer,Public Water','1994','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','214959191','1669054547','214959191','2022-11-19T22:37:47.430','50482387','Cindi Rickman','ROCK REALTY','','','29.385168','-94.921099','10','77590','6','234900.00','Active','Wayside','1726','','Texas City','3','0','4','2216','Single-Family','Super cute 3/2/2 with MANY updates. Fenced backyard. Spacious living room and 2 primary bedrooms. Fireplace with gas lighter. Great home family home!','0.1584','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Texas City','Central Gas','0','ABST 205 PAGE 3 LOT 9 BLK 17 WAYSIDE PLACE SEC 2','Subdivision Lot','6900','Appraisal District','','','0','','1','','0','','','','','Composition','52 - Texas City','KOHFELDT ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','1','Traditional','Wayside Place 2','4312','2.5335','Public Sewer,Public Water','1974','Appraisal'); --> 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','214968622','1669054548','214968622','2022-11-19T22:31:34.257','42947342','Alex Westbrook-McCollum','Swede\'s Real Estate LLC','','','29.401185','-94.713302','27','77650','5','839000.00','Active','Marble','3802','Street','Port Bolivar','2','1','3','1500','Single-Family','Welcome to Luxury on the Peninsula! This 3 bedroom and 2.5 bathroom is nestled on the slough in the highly sought after Biscayne subdivision. Enjoy the stunning views of the Gulf of Mexico on this beautiful deck!! The home features amazing high end finishes such as glass backsplash, shiplap walls, a huge walk in shower for the primary bathroom, fabulous LED lit mirrors, stainless steel appliances, and a bunk room to fit all of your guests. There is an attached garage to fit all of your beach toys and an outdoor shower to wash off the sand before coming inside. The Biscayne is a gated community with limited beach access by walkover to avoid traffic from non-property owners. Call for your private showing!','0.2056','33','NXT Properties LLC','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Port Bolivar','Central Electric','1','THE BISCAYNE SEC 3 (2006), ABST 162, BLOCK 1, LOT 81, ACRES','Corner,Water View,Waterfront','8954','Appraisal District','','1000','0','','1','Single Oven','0','','','Electric Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Builder','1','Other Style','The Biscayne Sec 3 2006','577','1.6103','Public Sewer,Public Water','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','214976663','1669054548','214976663','2022-11-19T22:11:59.113','10665862','Vi Tran','JPAR-The Sears Group','','','30.071915','-95.618679','16','77375','3','335000.00','Active','ROYAL ANN WAY','2214','','Tomball','2','0','3','1668','Single-Family','Brand NEW energy-efficient home ready TO MOVE IN. Fix dinner at the sprawling kitchen island without missing any of the action in the adjacent family room. An open concept seamlessly blends this single-story layout. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. STAINLESS STEER APPLIANCES. TANKLESS WATER HEATER. GARAGE EXPOSY','','14','Merritage','','','','Owner/Agent','','','','Tomball','Central Gas','1','SF 0303 Plan L400B','Subdivision Lot','','','','875','1','Never Lived In','2','','0','','','','','Composition','53 - Tomball','TOMBALL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Call Occupant','Builder','1','Traditional','CHERRY PINES','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully