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-11-28T12:50:16.620' ,`MLSNumber` = '23786399' ,`ListAgentFullName` = 'Lindsey Sturrock' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144307' ,`Longitude` = '-94.328701' ,`PhotoCount` = '36' ,`PostalCode` = '77659' ,`RoomCount` = '6' ,`ListPrice` = '421000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekside' ,`StreetNumber` = '320' ,`StreetSuffix` = 'Loop' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Countrywood Estates, Sour Lake, Texas\nThis corner lot home settled on 1.098 acres has open space with unobstructed views of\nWestern sky, glowing orange and pink sunsets and trees. Quiet street with long-time neighbors.\n First floor has been fully renovated with new floor, new kitchen appliances, and soft close cabinetry.  New chandelier light fixture over kitchen sink and custom lighted display cabinets for trinket displays.Kitchen and dining room windows open to views of trees, birds and deer all year long.\nFront formal entry opens to grand room with molded ceiling and full light doors leading to large patio for easy entertaining and fenced back yard.\n Master bedroom and ensuite bath with double sinks, large walk in shower with added hand held shower head, his and her’s closets.\nFull height attic extends length of house with sub-flooring. Two car garage attached to back covered patio has central air and heat.\nAttached garage apartment with full bath also has central air and heat' ,`Acres` = '1.09' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLK 8 COUNTRY WOOD ESTATES PHASE II P# CE2-8-1 I# 2019' ,`LotDesciption` = 'Corner' ,`LotSize` = '47480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Wood Estates Ph 02' ,`TaxAmount` = '5204' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084966' WHERE `Matrix_Unique_ID` = '210781694'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T12:24:29.380' ,`MLSNumber` = '86993616' ,`ListAgentFullName` = 'Lynnette Gronewold' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.993121' ,`Longitude` = '-95.517194' ,`PhotoCount` = '50' ,`PostalCode` = '77069' ,`RoomCount` = '12' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Balmore' ,`StreetNumber` = '13803' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Home located on huge corner lot with circular drive, back entry driveway to a three car garage and pool surrounded by brick wall to ensure privacy. Loaded with updates and features including a completely renovated kitchen featuring new appliances, double ovens, custom open island with pendant lighting, granite c-tops, & walk in pantry. Huge living room with custom built-ins, impressive crown molding, and beautiful seamless hardwood floors throughout the 1st floor. Massive Primary Suite with spa-style bath. Private office features custom built-in cabinets providing excellent storage. Second floor provides 4 spacious secondary bedrooms, game & media room and two full baths! To complete this amazing home your very own private oasis with sparkling pool, hot tub, low maintenance yard, extended deck, all enclosed for your enjoyment. Other features are new A/C unit, roof, carpet, updated light fixtures, plantation shutters and more!' ,`Acres` = '0.25' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 HUNTWICK FOREST SEC 5' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '152' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest' ,`TaxAmount` = '9884' ,`TaxRate` = '2.3915' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084967' WHERE `Matrix_Unique_ID` = '213367280'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T11:14:59.947' ,`MLSNumber` = '69402232' ,`ListAgentFullName` = 'Michelle Cannon' ,`ListOfficeName` = 'RE/MAX Distinction' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293873' ,`Longitude` = '-95.807801' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '17' ,`ListPrice` = '1099000.00' ,`Status` = 'Active' ,`StreetName` = 'Victoria Trace' ,`StreetNumber` = '12986' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite custom 5 bedroom home nestled among the trees in the very popular master-planned gated community of Crown Ranch! This 1 acre property has an amazing 60x50 garage/shop with RV parking and RV plug and automatic doors. The outdoor kitchen has a wood burning fireplace, grill, burner, sink and a mounted TV perfect for entertaining. The terraced backyard has a large covered patio and plenty of room for a pool. Full house generator. The interior boasts of 2 primary bedrooms and bathrooms with one downstairs and the other upstairs. Fabulous gameroom downstairs with beautiful stone gaslog fireplace and drybar. 2nd bedroom and full bath down as well. Island kitchen and breakfast room are open to the huge family room surrounded by windows. This home offers an amazing tranquil lifestyle!' ,`Acres` = '1' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Block 1, Lot 15, Crown Ranch Sec 2, Acres 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084967' WHERE `Matrix_Unique_ID` = '213830348'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T12:14:44.083' ,`MLSNumber` = '60774309' ,`ListAgentFullName` = 'Thelma Yera' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677421' ,`Longitude` = '-95.187815' ,`PhotoCount` = '32' ,`PostalCode` = '77502' ,`RoomCount` = '8' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Peach' ,`StreetNumber` = '2223' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Move in Ready just  in time for the Holidays  !! Completely Remodeled,  Roof replaced 2022, New Carpet on second floor ,  title  through the first floor, new kitchen  cabinets and counter tops, plumbing replaced with Flex pipes, bathrooms, all electrical , all doors replaced, Paint exterior/interior. All wood paneling was replaced with sheet rock too many things to list this is a must see home.' ,`Acres` = '0.1671' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 2 SAM RAYBURN HEIGHTS R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MAE SMYTHE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Rayburn Heights R/P' ,`TaxAmount` = '4242' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084967' WHERE `Matrix_Unique_ID` = '213970393'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T11:44:49.013' ,`MLSNumber` = '49806086' ,`ListAgentFullName` = 'Daniel Loria' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150048' ,`Longitude` = '-94.027820' ,`PhotoCount` = '39' ,`PostalCode` = '77662' ,`RoomCount` = '3' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Wexford' ,`StreetNumber` = '1785' ,`StreetSuffix` = 'Drive' ,`City` = 'Vidor' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home sits on a large corner lot, offers lovely landscaping and a private front patio, excellent for relaxing, gardening, etc...\r\nThe inside offers a cozy fireplace, lovely tile, a breakfast area and a beautifully upgraded kitchen with granite countertops, bar top, under cabinet lighting and more. There is a fantastic flex room that could be used as a dining room, office space or library. All bathrooms have been beautifully modeled with granite countertops, wallpaper, and tiled shower. The back yard offers plenty of space and a beautiful covered patio with ceiling fan. The mature trees in the back make it easy to host events, even in the heat of the summer. \r\nYou wont want to miss this home.' ,`Acres` = '0.371' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4 BLK 8 WEXFORD PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1005 - Vidor' ,`SchoolElementary` = 'VIDOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VIDOR HIGH SCHOOL' ,`SchoolMiddle` = 'VIDOR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wexford Park' ,`TaxAmount` = '4041' ,`TaxRate` = '2.2389' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084967' WHERE `Matrix_Unique_ID` = '214134712'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T11:30:59.460' ,`MLSNumber` = '89371233' ,`ListAgentFullName` = 'Holly Sewell' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.708074' ,`Longitude` = '-95.181804' ,`PhotoCount` = '6' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '149000.00' ,`Status` = 'Active' ,`StreetName` = 'Blanks Bend' ,`StreetNumber` = '70' ,`StreetSuffix` = 'Road' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located in Holiday Shores II subdivision, with lake access to beautiful Lake Livingston.  Four bedrooms and two full baths.  The home has new laminate flooring throughout the kitchen, living room, and hallway.  The metal roof is less than a year old.  Mature trees throughout the property.' ,`Acres` = '0.1928' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY SHORES SUB 2, LOT 557, SECTION 3, ACRES .1928' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Holiday Shores Sub 2' ,`TaxAmount` = '1623' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084968' WHERE `Matrix_Unique_ID` = '214230420'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T11:55:11.980' ,`MLSNumber` = '97547713' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833099' ,`Longitude` = '-95.855751' ,`PhotoCount` = '15' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Eliana Shores' ,`StreetNumber` = '101' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SUNTERRA IS NOW OPEN!! KATY ISD-  HUGE BACK YARD in a Cul-De-Sac street with No Back Neighbors! Estimated Completion DATE IS November. Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 3 Full Baths at a price you CAN afford! Come see this open-concept home (with space in all the right places.)This beautiful Kitchen features Espresso 42” Cabinets + Luxury Dark Granite + Tile Backsplash + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a walk-in Closet, 42\"-High Cabinets with Double, & 5’ Spacious Separate Shower, 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System, Covered Back Patio much more! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY. Come visit the model home located at 105 Eliana Shores.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Blk 1 Sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675084968' WHERE `Matrix_Unique_ID` = '214335582'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T11:13:54.583' ,`MLSNumber` = '23920570' ,`ListAgentFullName` = 'Ann Kulhanek' ,`ListOfficeName` = 'Waller County Land Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.094806' ,`Longitude` = '-96.078318' ,`PhotoCount` = '20' ,`PostalCode` = '77445' ,`RoomCount` = '5' ,`ListPrice` = '148000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '1040' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great first home or investment property in the heart of Hempstead!  Home features 2 bedrooms and 1 bath along with a large dining room and Family room.' ,`Acres` = '0.2152' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S519000 HEMPSTEAD BLK 244 LOT S/2 OF 4 & ALL OF 5' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'French' ,`Subdivision` = 'Hempstead' ,`TaxAmount` = '2442' ,`TaxRate` = '2.4184' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084968' WHERE `Matrix_Unique_ID` = '214650324'  --> 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','214721726','1675084968','214721726','2022-11-28T11:53:31.970','18649456','Justin Dickey','Keller Williams Professionals','','','29.837897','-95.852245','18','77493','8','349990.00','Active','Sunray Lake','400','','Katy','2','1','3','1988','Single-Family','Throw on your swimming trunks and get ready to live in Katy\'s most amazing community, Sunterra.  This community is the one that will have the famous \"Crystal Lagoon Beach Club\".  Colina Homes is proud to offer \"Pre-Construction\" pricing and availability.  Lots are limited so hurry in to secure your dream home location.  As expected with a Colina Home you not only get some of the best prices but also some of the best features included:  Upscale kitchen with Granite counter tops, stainless appliances to include 5 burner stove, 42\" Birch wood cabinets, and tile or vinyl plank flooring, 2\" blinds, PEX plumbing, tile or vinyl in living room, 2 fans, and so much more.   Photos are representative. This is a wonderful Lake Lot located in a Cul-De-Sac!  EST COMPLETION IS FOR November 2022!','','25','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','Lot 24 Block 2 Sec 1','Subdivision Lot','4830','Survey','','1330','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany','Builder','2','Traditional','Sunterra','','3.5','Water District','2022','Builder');  --> 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','214760694','1675084968','214760694','2022-11-28T11:16:21.533','37591684','Justin Dickey','Keller Williams Professionals','','','29.405789','-95.059789','39','77568','7','298990.00','Active','Dalvay Beach','13301','Drive','Texas City','3','0','4','1759','Single-Family','BRAND NEW COLINA HOME- 1 STORY OFFERS 4 BEDROOMS, 3 FULL BATHS, OPEN CONCEPT INCLUDES UPGRADED 42\" KITCHEN CABINETS WITH CROWN MOLDING; UPGRADED KITCHEN GRANITE COUNTERTOPS; BEAUTIFUL TRAY CEILING IN FOYER; TILE FLOORING EVERYWHERE EXCEPT BEDROOMS; SINGLE BOWL 9\" KITCHEN SINK; BUILT IN TAEXX PEST CONTROL; FRONT GUTTERS, PEX PLUMBING; 16 SEER LENNOX A/C; BACK COVERED PORCH; RINNAI TANKLESS WATER HEATER; CORDLESS FAUX WOOD BLINDS, DOUBLE SINKS IN MASTER BATH AND MUCH MORE!  HOME SITE WITH NO BACK NEIGHBORS!','','33','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Texas City','Central Gas','1','Lot 9 Block 1 Section 3','Subdivision Lot','5600','Survey','','1330','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','1','Traditional','Lago Mar','0','3.55','Public Sewer,Public Water','2022','Builder');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T11:51:30.047' ,`MLSNumber` = '60760154' ,`ListAgentFullName` = 'Lowell Smith' ,`ListOfficeName` = 'Criswell & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799925' ,`Longitude` = '-95.413414' ,`PhotoCount` = '31' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '825' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If custom luxury is what you are looking for this gorgeous Hearthstone Home is for you.  This recently built property has all the comforts you can imagine.  From the light and bright open concept to the custom kitchen with the top of line appliances you will want to come inside to see the perfect floorplan for entertaining.  Have friends over to watch movie in the theater room or enjoy a glass of wine from the wine cellar while enjoying the beautiful view of downtown on your large balcony. This home is centrally located giving you easy access to fine dining and shopping.  Come tour your future home \r\nTODAY!!!' ,`Acres` = '0.1613' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 30 & 31 BLK 126 TR L (ABANDONED ALLEYWAY) HOUSTON HEIGHT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7025' ,`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` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '35545' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675084968' WHERE `Matrix_Unique_ID` = '214778085'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T12:40:27.003' ,`MLSNumber` = '67370179' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600484' ,`Longitude` = '-95.443619' ,`PhotoCount` = '23' ,`PostalCode` = '77053' ,`RoomCount` = '8' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Islandview' ,`StreetNumber` = '15430' ,`StreetSuffix` = 'Lane' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, ON THE LAKE! Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Rectangle Sinks at Primary and Secondary Baths, Granite Kitchen Countertops, 42” Upper Kitchen Cabinets, Tile Floors in Kitchen/Dining, Family and all Wet Areas, Rocker Switches, Covered Patio, Full Sod, Irrigation, Tech Shield Roof, Corner Lot, Environments for Living Home, plus more…AVAILABLE NOW.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 2 SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675084969' WHERE `Matrix_Unique_ID` = '214817582'  --> 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','215013900','1675084969','215013900','2022-11-28T12:19:45.967','26930866','Cyndi Kornegay','Gatehouse Properties','','','29.471800','-95.532493','11','77459','10','568510.00','Active','Fox Trail','8726','Drive','Missouri City','3','1','5','2859','Single-Family','This elegant 2-story home boasts a modern brick and stucco elevation. Upon entry, you will be greeted by a grand foyer with 18\' ceilings and a breathtaking view of the 2-floor game room. The gourmet kitchen is open to the family room, ideal for entertaining. It boasts an abundance of countertop space, built-in stainless-steel appliances, and a walk-in pantry. Relax in the exquisite primary suite, complete with a bowed window. The primary bath features double vanities, a walk-in shower, and a stunning freestanding bathtub. Upstairs, an open-to-below game room makes it easy to keep an eye on the children from the 1st floor. The extended covered patio is the perfect place to relax and entertain guests. Come and visit this luxurious home today!','','38','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Sienna Area','Central Gas,Zoned','1','Lot 6 Block 3','Corner','7394','Survey','','1229','1','To Be Built/Under Construction','2','Single Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Accompany,Appointment Required,No Supra Keybox','Builder','2','Contemporary/Modern,Traditional','Sienna','','3.19','Public Sewer','2022','Builder');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T12:06:55.427' ,`MLSNumber` = '58091747' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679668' ,`Longitude` = '-95.737071' ,`PhotoCount` = '39' ,`PostalCode` = '77407' ,`RoomCount` = '6' ,`ListPrice` = '433166.00' ,`Status` = 'Active' ,`StreetName` = 'Scout Landing' ,`StreetNumber` = '20411' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spectacular 1-story home was designed with you in mind. The bold kitchen comes complete with gorgeous granite countertops, stainless steel appliances, 42-inch cabinets and an island that overlooks the family room. The primary bathroom boasts a separate tub and shower and a nicely sized walk-in closet. Overall, the house comes with three full bathrooms for comfort. You will definitely enjoy this space. The Texas-sized covered patio is perfect for outdoor entertainment. Come visit this luxurious home today!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5111' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Grand Mission Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.86' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675084969' WHERE `Matrix_Unique_ID` = '215026222'  --> 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','215129072','1675084969','215129072','2022-11-28T12:32:58.080','39888514','Kimberly Price','Coldwell Banker Southern Homes','','','30.090028','-94.121219','18','77702','8','167400.00','Active','Harrison','2330','Street','Beaumont','2','0','3','1619','Single-Family','This charming \"gem\" in the Oaks Historic District has been lovingly renovated and offers a lot for its size! Totally updated kitchen with custom cabinets and stainless-steel appliances, Quartz countertops, spacious primary bedroom with huge primary bath that has separate tiled shower. Large gameroom/bonus features beamed ceiling and spacious utility room. New outdoor AC condenser, new ductwork in attic. Warranty on outdoor condenser and indoor coil. The long driveway is brand new and offers ample parking. Schedule your showing today!','0.2583','51','','','','','Other Disclosures','','','','','Central Gas','0','AVERILL L24 E1/2 L23 B 17','Other','11250','Appraisal District','','','0','','0','','0','','','','','Other','143 - Beaumont','CALDWOOD ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','ODOM MIDDLE SCHOOL','Vacant/Unoccupied','Appraisal District','1','Traditional','Averill 1','1458','2.6134','Public Sewer,Public Water','1962','Appraisal District');  --> New record created successfully<br />