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-09-21T02:44:51.050' ,`MLSNumber` = '16143169' ,`ListAgentFullName` = 'Danny Robinson' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.675550' ,`Longitude` = '-96.420446' ,`PhotoCount` = '41' ,`PostalCode` = '75126' ,`RoomCount` = '13' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Theale' ,`StreetNumber` = '6600' ,`StreetSuffix` = 'Court' ,`City` = 'Mesquite' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN-READY - Built by ALTURA HOMES.  You will love this Langford VI, PROTOTYPE PLAN Home on a 1-acre lot in the Berkshire Estates, Mesquite Texas.  Homes offers 3,103 sf, living space, 4 bedrooms, 3.5 bathrooms, game room and 3 car garage. Three bedrooms on one wing with game room.  Isolated master with large closet, his & hers vanities as well as separate tub & shower. This floor plan includes office space near the entry way. House has is new and waiting for new owners.  Crandall ISD. This Community recently was annexed by the City of Mesquite TX. \r\n\r\nThis growing community gives you that small town comfort away from the big city within close proximity to Interstate 20 and Hwy 175.   29 min (26.7 mi) via I-20 W. to Downtown Dallas.\r\n\r\n\r\n\r\n\r\n\r\n\r\nTake I 20 to to Forney Exit 471, FM 2932, Travel South to Bassett St. Rt. on Bassett. Travel 2 blocks to Emerson, turn left, 2 blocks to Theale Court, turn Right, This Gorgeous Dream Home is on your left.' ,`Acres` = '' ,`Area` = '84' ,`BuilderName` = 'Altura Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = '2021-0013425' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '1' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '520 - Forney' ,`SchoolElementary` = 'RHEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FORNEY HIGH SCHOOL' ,`SchoolMiddle` = 'WARREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Berkshire Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.68' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794320' WHERE `Matrix_Unique_ID` = '209373372'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T02:19:00.863' ,`MLSNumber` = '71389210' ,`ListAgentFullName` = 'Jesse Reza' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.373240' ,`Longitude` = '-95.500012' ,`PhotoCount` = '5' ,`PostalCode` = '77304' ,`RoomCount` = '14' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Apple Valley Dr' ,`StreetNumber` = '290' ,`StreetSuffix` = '' ,`City` = 'Panorama Village' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! This is a hard to find jewel. Custom design. Three rooms have their own full bathroom and closets. Built on 27 piers, radiant barrier on the roof, custom made windows. Great location in a Golf Course Community with parks, pool, Country Club and wonderful golf course. 5 minutes for I-45, close to Lake Conroe, shopping, medical. A Great Location.' ,`Acres` = '0.1607' ,`Area` = '39' ,`BuilderName` = 'AZER Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PANORAMA-QUAIL CREEK 01, LOT 290' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Panorama-Quail Creek 01' ,`TaxAmount` = '668' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794320' WHERE `Matrix_Unique_ID` = '209401319'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T02:25:18.737' ,`MLSNumber` = '33470674' ,`ListAgentFullName` = 'Gail Medina' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849295' ,`Longitude` = '-95.592839' ,`PhotoCount` = '18' ,`PostalCode` = '77041' ,`RoomCount` = '9' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Summerland Ridge' ,`StreetNumber` = '12210' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! NEVER flooded, not even during Harvey. Spacious 5 bedroom layout with beautiful pool in the back yard, custom removable pool-fence and a 3 car garage. Newly painted interior walls. Home comes with backyard patio furniture, kitchen refrigerator, washer, dryer and two mounted flat-screen TVs with their brackets. Professionally landscaped back and front yard. New tile back splash in the kitchen & brand new stainless steel appliances.  Located in a gated community with lakes, swans and palm trees all through out.  Primary en-suite bathroom with jetted garden tub, new tile and frameless glass shower. Second floor includes 2 full baths which includes fully tiled flooring, bathtub with sliding glass doors & Siltstone counters. LED lights throughout the home! Primary bedroom downstairs, all other bedrooms upstairs.' ,`Acres` = '0.218' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 LAKES ON ELDRIDGE SEC 19 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1690' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge' ,`TaxAmount` = '12020' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794320' WHERE `Matrix_Unique_ID` = '210243279'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T02:22:20.400' ,`MLSNumber` = '41569007' ,`ListAgentFullName` = 'Gail Medina' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663942' ,`Longitude` = '-95.465691' ,`PhotoCount` = '18' ,`PostalCode` = '77035' ,`RoomCount` = '0' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowbend' ,`StreetNumber` = '4931' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1956 Midcentury Ranch has withstood several decades of wear and tear. This home DID NOT FLOOD and sustained NO DAMAGE during Harvey nor with any other storm. Loads of historical charm, original floors, and a big bang for your buck. 2017 a/c, 2017 plumbing, custom kitchen cabinets, new light fixtures and much more! Extra parking on the grassy boulevard area across the street from the house.' ,`Acres` = '0.2516' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 5 WESTBURY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '4714' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794320' WHERE `Matrix_Unique_ID` = '210790223'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T03:06:50.640' ,`MLSNumber` = '59032278' ,`ListAgentFullName` = 'Adelina Ochoa' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073156' ,`Longitude` = '-95.456537' ,`PhotoCount` = '37' ,`PostalCode` = '77388' ,`RoomCount` = '6' ,`ListPrice` = '306000.00' ,`Status` = 'Active' ,`StreetName` = 'Delridge' ,`StreetNumber` = '21418' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home located in Hannover Forest, a Family Friendly Community with great amenities including a Clubhouse, Pool, and Parks!  Zoned to KLEIN ISD! Located just minutes to Grand Parkway Marketplace for Shopping & Restaurants! Close to The Woodlands Medical Center and all that The Woodlands has to offer. This 3-bedroom 2-Bath Single-Story Home offers a Functional Layout that is sure to Accommodate any Family. The Kitchen offers a breakfast bar, granite counters, a Stainless-steel appliance PKG including a 4-Door Refrigerator, a Reverse osmosis Water filter System. Spacious Living room with a stylish fireplace. A Grand backyard with an enclosed glass patio and storage shed, Sprinkler System, and recently added French Drains, Concrete Sidewalks on both sides of the home. Roof less than 10 yrs. Internet System Ready, Alarm and Camera system, Digital Thermostat, Smart Garage Door Opener, and TV Mounts ALL included. Fresh interior paint.' ,`Acres` = '0.198' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 HANNOVER ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8623' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hannover Estates Sec 01' ,`TaxAmount` = '5166' ,`TaxRate` = '2.854' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794320' WHERE `Matrix_Unique_ID` = '210931454'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T03:17:21.727' ,`MLSNumber` = '86625141' ,`ListAgentFullName` = 'Bernadette Blair' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726723' ,`Longitude` = '-95.362733' ,`PhotoCount` = '30' ,`PostalCode` = '77004' ,`RoomCount` = '2' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Truxillo' ,`StreetNumber` = '3015' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great area and nice sized lot for area. House can be remodeled or tare down and rebuild. Wonderful location Next to Texas Southern University. New build across the street.  Prices to sell.' ,`Acres` = '0.1326' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 34 WASHINGTON TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '3553' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794321' WHERE `Matrix_Unique_ID` = '211957904'  --> Updated record success<br />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','212550714','1663794321','212550714','2022-09-21T02:41:09.050','67238617','Trang Le','Winning Real Estate','','','29.675201','-95.690032','36','77407','3','325000.00','Active','Matilda Creek','9506','Court','Richmond','2','0','3','1701','Single-Family','This is it! Wonderful move-in ready one story home in sought after Mission Trace community. Beautiful curb appeal. Home has been meticulously maintained & updated by original owners. Open floorplan & high ceiling offers an effortless flow throughout. Numerous windows provide abundant natural lighting. Tiles run throughout common areas, family room, dining room & kitchen. Many upgrades include gutters added all around, concrete walkway added wrapping the right side of the house, extended patio & water softener. Refrigerator, washer, dryer & shed all stay.  Schedule your showing today!','0.1573','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Mission Bend Area','Central Gas','1','MISSION TRACE SEC 6, BLOCK 1, LOT 60','Cleared','6852','Appraisal District','','700','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','19 - Fort Bend','PATTERSON ELEMENTARY SCHOOL (FORT BEND)','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Supra Keybox','Appraisal District','1','Traditional','Mission Trace Sec 6','5150','2.4429','Water District','2016','Appraisal District');  --> New record created successfully<br />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','212556333','1663794321','212556333','2022-09-21T03:33:41.800','41858921','Funmi Ekundayo','Keller Williams Premier RealtyKaty','','','29.700226','-95.716122','46','77407','4','349999.00','Active','Field Cottage','19003','Lane','Richmond','2','0','3','2283','Single-Family','AMENITIES! UPGRADES! LOCATION!!!\r\nWelcome to this beautiful high quality David Weekley\'s - Hilliker Plan with office, dining/another flex room, gameroom/flex room or 4th bedroom. This beauty is being sold by original owner who took great care of it and \r\nwas COMPLETELY RENOVATED in 2018 with no expense spared to include dream master bathroom with upgraded tile work, a frameless shower and a garden tub, kitchen stainless steel appliances, cabinetry, quartz countertops, and an undermount farmhouse sink. The flooring is covered with beautiful tiles and wood laminate throughout...NO CARPETS! NEW PAINT! NEW energy efficient Lennox HVAC system (~ $8000)! NEW STAINLESS STEEL APPLIANCES!\r\nThe front porch allows for great outdoor neighborly & experience. The master planned community boasts of clubhouse, fitness center, playground, Walking path and lot of community events.\r\nIt has quick access to the Westpark Tollway, Hwy 6, 99 & a short drive I-10, and 59, Katy Mall, water parks & restaurants.','0.1451','37','David Weekley','','Washer Connections','','Mud','1','','','Fort Bend County North/Richmond','Central Gas','1','GRAND MISSION SEC 7, BLOCK 4, LOT 23','Corner','6321','Appraisal District','','995','0','','2','Convection Oven','0','','','Gas Cooktop,Gas Range','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Grand Mission','5675','2.5097','Public Sewer,Public Water,Water District','2005','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T03:22:00.777' ,`MLSNumber` = '38013977' ,`ListAgentFullName` = 'Deb Schonert' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119326' ,`Longitude` = '-95.244671' ,`PhotoCount` = '29' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Canyon' ,`StreetNumber` = '22570' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful all brick home has been very well-maintained.  Open concept living room/kitchen/dining with breakfast bar. Beautiful tile in kitchen, baths and laundry room. Farmhouse sink. Brand new stove and dishwasher. Split floorplan. Large Primary Bedroom. Added shelves in Primary Closet. New cabinets in laundry room. WiFi thermostat and some WiFi light switches. Security system with cameras. Several child safety locks. New large covered patio with remote control string lights and roll-down shade. Freshly cleaned including carpet cleaning. Convenient location close to Valley Ranch Town Center, Kingwood and Humble for dining, shopping and entertainment. Jump on the Grand Parkway and be at The Woodlands in minutes. Home has never flooded.' ,`Acres` = '0.1453' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S941205 - VALLEY RANCH 05, BLOCK 5, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6329' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Valley Ranch 05' ,`TaxAmount` = '5548' ,`TaxRate` = '3.2331' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794321' WHERE `Matrix_Unique_ID` = '212585583'  --> Updated record success<br />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','212678157','1663794321','212678157','2022-09-21T03:15:27.320','44941671','Fauzia Zaki','Key 2 Texas Realty','','','29.955601','-95.602222','50','77429','6','299999.00','Active','Cypress Crossing','12511','Drive','Cypress','2','1','3','2464','Single-Family','Immaculately remodeled four bedrooms three and a half bath Manufactured home sits on a close to half acre land. The kitchen boasts generous cabinets and granite counter space making cooking and entertaining a delight.The breakfast area  has enough space to host your guests. Primary suite is large enough for all styles of furniture with plenty of windows array natural light.Each bedroom have a comfortable space to accommodate beddings.Relax and enjoy your favorite drink at covered patio with beautiful view of the huge fully fenced backyard.The seller started remodeling the garage apartment with deck now waiting for  a new owner for their personal touches to finalize. Easy commute minutes away from US 290 and Grand Parkway and Great location close to shopping, dining, entertainment and more. A MUST SEE!!','0.54','10','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','','Cypress North','Central Electric','1','TR 43 CYPRESS CROSSING M/H PARK U/R ABST 788 T TOBY','Subdivision Lot','23522','Appraisal District','','250','0','','1','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS CREEK HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required','Appraisal District','1','Ranch','Cypress Xing Tr 43','2290','2.1637','Water District','1978','Appraisal District');  --> New record created successfully<br />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','212754611','1663794321','212754611','2022-09-21T02:30:26.680','30893867','Adelina Ochoa','Realty Associates','','','30.057953','-95.367121','41','77373','8','329900.00','Active','Sagegate','4726','Drive','Spring','2','1','4','2521','Single-Family','Welcome to this GORGEOUS 2-story, 4 bedroom, 2.5 bath HOME featuring a beautiful two-story Grand Glass entry-way with an arched window for extra elegance! iron spindles upstairs making this a grand entrance! Spacious family room w/ an oversized ceiling fan & fireplace and large windows for natural lighting. Breakfast bar & breakfast space opens to Chef\'s kitchen; boasts elegant custom Brazilian Granite countertops, 42in Cabinets, Stainless steel appliances, Refrigerator included, Formal dining/Study, first floor Primary Suite & private en-suite bath offering a garden tub w/separate shower, double sinks & walk in closet. Versatile game room up, 3 spacious bedrooms, and a secret room for extra storage. Laminate wood and Ceramic tile throughout with beautiful hardwood stairs. Large fenced in backyard with plenty of room for a pool! Storage shed and a wooden pergola. Conveniently located near shopping and major freeways (Hwy 99, I-45, and Hardy) for an easy commute.','0.206','12','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Spring East','Central Electric','1','LT 12 BLK 4 VILLAGES OF SPRING OAKS SEC 1','Subdivision Lot','8973','Appraisal District','','350','0','','2','Convection Oven','0','','','Gas Range','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Villages Spring Oaks Sec 01','5630','2.6068','Public Water','2001','Appraisal District');  --> New record created successfully<br />