Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T18:33:50.867' ,`MLSNumber` = '89865344' ,`ListAgentFullName` = 'Rick Garcia' ,`ListOfficeName` = 'Carlos Garcia Realty          ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727490' ,`Longitude` = '-95.314308' ,`PhotoCount` = '19' ,`PostalCode` = '77023' ,`RoomCount` = '6' ,`ListPrice` = '374950.00' ,`Status` = 'Active' ,`StreetName` = 'Country Club' ,`StreetNumber` = '6421' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Houston Country Club Place - Across from the Villa De Matel Convent and Newly Renovated Gus Wortham Golf Course - This 1,945 SF home was purchased from the original owner in 2010 and followed with Extensive Renovations including New Wiring, Zone control HVAC, Showcase Windows, Recessed Lighting, Wired for Camera & Alarm System, lots of Insulation, and Beautifully refinished Hardwood Floors. The Huge Master Suite was created by combining two secondary bedrooms into one 12\'x24\' room that accommodates a bedroom suite, sitting area, full-size desk, spacious walk-in closet, and separate shoe closet. The Hall Bath is now the Master Bath with a Glass Enclosed Walk-In Shower and Marble Top Vanity. The Original Master Bedroom has a newly updated bathroom & tile shower. The Kitchen was gutted & fully renovated with a Breakfast Bar, Food Prep Island, Upper & Lower Cabinets, Granite Counter Tops, Under Cabinet Lighting, & Built-In Appliances. The Big Den features a Fireplace & Wet Bar - Come See!' ,`Acres` = '0.1968' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 22A & 23 BLK 6 HOUSTON COUNTRY CLUB PL SEC 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8576' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Country Club Place' ,`TaxAmount` = '5424' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699090' WHERE `Matrix_Unique_ID` = '206629556'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T18:05:11.890' ,`MLSNumber` = '44824677' ,`ListAgentFullName` = 'Daniel Delk' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038867' ,`Longitude` = '-95.367908' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Whittaker' ,`StreetNumber` = '23031' ,`StreetSuffix` = 'Way' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Split plan, 1 story brick home on a large lot, covered front porch. 4 bedroom, 2 bath, 2 car attached garage. Living room with lots of natural light, high ceilings and fireplace. No HOA maintenance fee, new roof, never flooded, easy access to I45. Master bedroom separate from the other bedrooms, master bath with garden tub and standing shower. A MUST SEE!!' ,`Acres` = '0.185' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 3 SANDPIPER VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8059' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sandpiper Village Sec' ,`TaxAmount` = '4727' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699090' WHERE `Matrix_Unique_ID` = '209487923'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T19:37:50.580' ,`MLSNumber` = '84177838' ,`ListAgentFullName` = 'Dora Lopez' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Kendra Dempsey' ,`SellingOfficeName` = 'Willow Haven Realty' ,`Latitude` = '30.186659' ,`Longitude` = '-95.166328' ,`PhotoCount` = '16' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '379000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Four Fountains' ,`StreetNumber` = '1002' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see this one story Custom built home Under Construction. Estimated completion date Oct.2022. This property has a lake view. High ceiling in family room with FP door to back covered  patio. Patio has decked floors and will have rails around it. kitchen and dining open to family room , Primary bedroom with view of back yard. Primary bathroom with oversize shower and separate tub, two vanity, linen closet. nice size laundry room with a wash tub area. Bedrooms will have carpet, family room, kitchen and dining an hallway will have hardwood floors, wet areas will have tile. call today for your private showing.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'private' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 12 Block 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14274' ,`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` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699090' WHERE `Matrix_Unique_ID` = '209520321'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T18:09:08.910' ,`MLSNumber` = '65314927' ,`ListAgentFullName` = 'Gabriel Cadavid' ,`ListOfficeName` = 'Cadavid Properties Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853719' ,`Longitude` = '-95.637734' ,`PhotoCount` = '20' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '304000.00' ,`Status` = 'Active' ,`StreetName` = 'Blueberry Hill' ,`StreetNumber` = '5311' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled 3 bedrooms, 2 bathrooms, 2 car garage. The home that is not in a flood zone. Everything is new: Tile, berber carpet, doors, locks and frames, bathrooms, cabinets, countertops, back splash, light fixtures and appliances. Sheetrock was replaced in mostly the whole house and texture and new paint added. Roof, AC and Heater is 2 years old. Extra large backyard with covered patio deck, koi pond and hot spa (negotiable).' ,`Acres` = '0.2508' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 41 BEAR CREEK VILLAGE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10927' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BEAR CREEK ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Village Sec 08' ,`TaxAmount` = '3712' ,`TaxRate` = '2.1736' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699090' WHERE `Matrix_Unique_ID` = '210222470'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T18:19:14.127' ,`MLSNumber` = '93425174' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928141' ,`Longitude` = '-95.707922' ,`PhotoCount` = '39' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '719999.00' ,`Status` = 'Active' ,`StreetName` = 'Texas Sage' ,`StreetNumber` = '10314' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3451' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 b/3.5 bath 2 story home w porch and back patio and 2.5 car garage in Towne Lake! Three beds upstairs w/game room and master downstairs, full bath, and walk-in attic w/extensive storage up. Equipped with dual separate closets. Upscale tile floors. Gourmet kitchen has beautiful cabinets, luxury granite counters, Stainless Steel appliances, & an island. Kitchen, breakfast area and two story living room have a great flow for entertaining! Primary bath has two walk in closets, soaking tub, nice sized shower. Beautiful backyard has huge covered patio, Plenty of green space, Sprinkler system., smart home features with full wired camera and security system and a nearby lake makes this the ultimate dream home. move-in ready.Additional - Huge media room with game room, Walk-in shoe closet attached to garage. Wet bar fixtures, closets, Elevated fireplace, Pre-wired for IP cable cameras,recess lights living room, study with french door, middle school.' ,`Acres` = '0.1722' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 TOWNE LAKE SEC 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '12546' ,`TaxRate` = '3.091' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699090' WHERE `Matrix_Unique_ID` = '210678645'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T18:33:26.110' ,`MLSNumber` = '67210625' ,`ListAgentFullName` = 'Jolunda Tompkins' ,`ListOfficeName` = 'Realty Right' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099570' ,`Longitude` = '-96.091713' ,`PhotoCount` = '13' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'New Orleans' ,`StreetNumber` = '2125' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home for 1st time home owners. This could also be and great investment property. Priced To Sell\r\nVacant- Go and show' ,`Acres` = '0.1435' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S519000 HEMPSTEAD BLK 152 LOT 6 S# 12533940 HUD# PFS0616790' ,`LotDesciption` = 'Corner' ,`LotSize` = '6251' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hempstead' ,`TaxAmount` = '1436' ,`TaxRate` = '2.4184' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699091' WHERE `Matrix_Unique_ID` = '210797085'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T19:47:11.027' ,`MLSNumber` = '79593482' ,`ListAgentFullName` = 'Michelle Smith' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770557' ,`Longitude` = '-94.683423' ,`PhotoCount` = '17' ,`PostalCode` = '77514' ,`RoomCount` = '7' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '302' ,`StreetSuffix` = '' ,`City` = 'Anahuac' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is located in the heart of the up-and-coming Anahuac and ready to move in. You\'ll instantly spot a spacious front yard with a beautiful Cedar Tree along with two pathways.  Large living/Family Room equipped with brand new Double Pane Windows cascading beautiful natural light, new ceiling fans and new light fixtures throughout the entire home. Fresh new paint, updated floors, and new A/C Unit! That\'s not all! You\'ll find many upgrades as you walk through the inside of the home and outside on the property.' ,`Acres` = '0.197' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 1 & 2 23 WILLCOX PARK AD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willcox Park AD' ,`TaxAmount` = '2469' ,`TaxRate` = '2.9736' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699091' WHERE `Matrix_Unique_ID` = '211419141'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T19:07:26.887' ,`MLSNumber` = '91104758' ,`ListAgentFullName` = 'Lori Blackmon' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.286100' ,`Longitude` = '-94.856074' ,`PhotoCount` = '18' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '7615' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market after complete renovation of  the kitchen and primary bedroom suite in August 2022.  Amazing views overlooking Pelican\'s Rest Marina and Offitts Bayou. Patio wraps completely around the house. Spectacular high ceilings in the living and dining area. Wood floors. Primary bedroom downstairs and three bedrooms up. Roof replaced in Oct 2019. Room sizes are approximate. Oversized garage has room for four cars and all your toys. No disappointments with this home.' ,`Acres` = '1.173' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Teichman/Channelview Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PAGE 77 PT OF LOT 515 (515-9) TRIMBLE & LINDSEY SEC' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '51096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Trimble & Lindsey Sec 1' ,`TaxAmount` = '19362' ,`TaxRate` = '2.466' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699091' WHERE `Matrix_Unique_ID` = '211440807'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T19:57:19.907' ,`MLSNumber` = '79051503' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769040' ,`Longitude` = '-95.234020' ,`PhotoCount` = '15' ,`PostalCode` = '77029' ,`RoomCount` = '9' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Holland' ,`StreetNumber` = '1224' ,`StreetSuffix` = 'Street' ,`City` = 'Jacinto City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location!! Located on Holland Ave near I-10 East!! +/- 1,712 sq. ft. on 2 lots +/- 14,941 sq. ft. Home Office possibilities! Large fenced property with large concrete parking! Corner lot on Holland and Oswego! Lots of possibilities here! Make your appointment to see this one today!' ,`Acres` = '0.1727' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 39 BLK 4 MARKET STREET GARDENS EXTN 2' ,`LotDesciption` = 'Other' ,`LotSize` = '7524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITTIER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Market Street Gardens Ext 02' ,`TaxAmount` = '4384' ,`TaxRate` = '2.5534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699091' WHERE `Matrix_Unique_ID` = '211443408'  --> Updated record success<br />