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` = '2023-01-08T13:30:41.080' ,`MLSNumber` = '17352730' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = 'Daniel Salce' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.770208' ,`Longitude` = '-95.330139' ,`PhotoCount` = '39' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '419000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Buck' ,`StreetNumber` = '4033' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located inside of Denver Harbor with easy access to I-10 and minutes from some of EADO\'s hottest attractions such a East River, East River 9, which is downtown\'s newest 9-hole golf course, and Post HTX. This townhome is packed with amenities such as an oversized terrace, a private balcony located on the second floor, a game room, and an enormous 3rd-floor terrace with stunning views of the downtown skyline. The first floor features a secondary room on the first floor or work from home office. The second floor showcases an open floor plan design a stunning kitchen and new pendant light over a quartz island that overlooks the living and dining area. The third floor has 2 bedrooms, and the oversized primary bedroom features a recessed tray ceiling and walk-in closet. The primary ensuite features a stand-up shower, dual sinks/drop in tub. The third floor has new LVP flooring in the massive game room with full-size bathroom and a huge outdoor terrace with downtown views. Welcome Home!' ,`Acres` = '0.0442' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 VILLAGE AT THE BRYAN HEIGHTS' ,`LotDesciption` = 'Corner' ,`LotSize` = '1925' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Village/Bryan Heights' ,`TaxAmount` = '9254' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106473' WHERE `Matrix_Unique_ID` = '211754349'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-08T13:09:41.697' ,`MLSNumber` = '38739043' ,`ListAgentFullName` = 'Thor Paulsen' ,`ListOfficeName` = 'D. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866030' ,`Longitude` = '-95.378351' ,`PhotoCount` = '16' ,`PostalCode` = '77076' ,`RoomCount` = '4' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Biscayne' ,`StreetNumber` = '11310' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Beautiful big trees in front and backyard that provides lots of shade. Freshly painted and new vinyl flooring throughout.  Great location, lots of restaurants around to enjoy. Easy access to Hardy Toll freeway for your convenience.  Call to schedule your appointment soon and see everything this home has to offer!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 7 GREENFIELD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7458' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE CHAUMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'FONVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenfield Sec 02' ,`TaxAmount` = '2610' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106473' WHERE `Matrix_Unique_ID` = '212397514'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-08T14:52:47.527' ,`MLSNumber` = '62008023' ,`ListAgentFullName` = 'Kwann Boyd' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659509' ,`Longitude` = '-95.369404' ,`PhotoCount` = '6' ,`PostalCode` = '77051' ,`RoomCount` = '4' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Brandon St' ,`StreetNumber` = '9134' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully built modern new construction located only ten minutes from downtown and five minutes from the medical center. This beauty features four bedrooms and three and a half bathrooms and includes a great theater room.. It is extremely spacious and bright. The builder offers 1 year warranty and 10 years Homeowners warranty. \r\nDo not miss the opportunity of calling this amazing property home.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Devon Homes LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 BOYD ESTATES AT BRANDON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3475' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'BOYD ESTATES AT BRANDON' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675106474' WHERE `Matrix_Unique_ID` = '213030880'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-08T14:45:45.780' ,`MLSNumber` = '62330446' ,`ListAgentFullName` = 'Hong Van' ,`ListOfficeName` = 'Aimpro Realty & Management LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696860' ,`Longitude` = '-95.640360' ,`PhotoCount` = '24' ,`PostalCode` = '77083' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Crimson Sky' ,`StreetNumber` = '7223' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely renovated! Must see! Beautiful two-story with 5 bedrooms, and 3 baths, locates in a convenient location. Don\'t miss it!' ,`Acres` = '0.0803' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 6 TERRA DEL SOL SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Del Sol Sec 04' ,`TaxAmount` = '6545' ,`TaxRate` = '2.5785' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106474' WHERE `Matrix_Unique_ID` = '213464046'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-08T13:14:46.650' ,`MLSNumber` = '14616993' ,`ListAgentFullName` = 'Thor Paulsen' ,`ListOfficeName` = 'D. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784394' ,`Longitude` = '-95.204773' ,`PhotoCount` = '13' ,`PostalCode` = '77015' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Rue Fontaine' ,`StreetNumber` = '747' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BIG corner lot! Freshly painted throughout, new carpet, updated kitchen with beautiful wood cabinets and granite countertops. Bathrooms have been remodeled as well. Large covered patio, great for entertainment. Lots of green area great for kids and pets. Convenient access to major freeway, I10. Schedule your showing fast before it\'s gone!' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 4 RIVIERA EAST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORMANDY CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riviera East Sec 03' ,`TaxAmount` = '3928' ,`TaxRate` = '2.6774' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106474' WHERE `Matrix_Unique_ID` = '213890686'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-08T14:22:16.763' ,`MLSNumber` = '43883466' ,`ListAgentFullName` = 'Ashley Zuniga' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829353' ,`Longitude` = '-95.692278' ,`PhotoCount` = '26' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Glen' ,`StreetNumber` = '18711' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this three bedroom, two bathroom home. As you enter in the front door you are welcomed by open and spacious living room with natural light. In the kitchen has a gas range, refrigerator, double sink, granite counter. Big backyard with a patio porch and a newly built shed. Since the garage has central A/C it can be converted into a game room or an additional room. Zoned to Katy ISD. Home has NEVER FLOODED.!' ,`Acres` = '0.1566' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 168 BLK 6 ROLLING GREEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rolling Green Sec 01' ,`TaxAmount` = '4558' ,`TaxRate` = '2.587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675106474' WHERE `Matrix_Unique_ID` = '213982093'  --> 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','215560175','1675106475','215560175','2023-01-08T14:12:05.230','83537677','Elaine Gerren','Integrity Real Estate','','','31.168250','-96.676697','43','76629','5','210000.00','Active','Commerce','207','Street','Bremond','2','0','3','1345','Single-Family','If you are looking for a small country town with deep family roots, Bremond is your town.  The schools are superb, and the town is small enough for a country feel and close enough to the amenities of town.  College Station is app. 50 minutes away and Waco is app. 45 minutes.  The home is a 3 bedroom, 2 bath with an open living concept. There is a large, fenced backyard for large get togethers. This home has been completely remodeled with everything new right down to the insulation and sheetrock. New 30 yr. roof with 2 attic turbines, all new sheetrock & paint, new cabinets, lg. walk-in closets, open living concept, Jack & Jill bath at the secondary bedrooms. The electrical has been rewired and the panel is new. The AC system is all new. Carpet in the bedrooms and luxury waterproof Vinal in the baths and Traffic Master laminate flooring in the living areas. The hot water heater us new and there is 12” blown in Ceiling insulation and R-13 in the walls.','0.19','72','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','','Central Electric','0','N47\'OF LT 2,S1/2 OF LT 3 BLK 49 BREMOND 1491/496 0.19 ACRES','Other','8276','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','366 - Bremond','BREMOND ELEMENTARY SCHOOL','BREMOND HIGH SCHOOL','BREMOND MIDDLE SCHOOL','Appointment Required,Lockbox Back','Seller','1','Traditional','City/Bremond','883','2.3913','Public Sewer,Public Water','1960','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','215863716','1675106475','215863716','2023-01-08T13:28:10.373','16919366','Brandi Morris','Bill Bell Realty','','','28.808182','-95.963924','17','77414','2','309999.00','Active','Fm 2668','15803','','Bay City','2','0','2','1378','Single-Family','is Cozy Home Is In The Perfect Vicinity To Lyondell, STP and OQ Plants. This 2 Bedroom 2 Bath Home Is Located On 7+ Acres, So You Have Plenty Of Room To Expand. This Acreage Currently Has 5 Septic Systems And 2 Wells, If You Choose More Homes Can Be Moved To This Location Or Built. There Are Many Possibilities With This Property. The Primary Has It\'s Own En Suite, With A Spa Bathtub/Shower Combo, Also Has Exterior Access To A Private Porch. This Home Offer\'s An Open, Split Floor Plan With Nice Sized Bedrooms, Large Walk In Pantry And An Inside Laundry Room. Book Your Private Tour Today.','7.21','54','','','','','Sellers Disclosure','','','','','Central Gas','0','AB 0061, D MACFARLANE, TRACT 6, SUR 34A, ACRES 7.21','Cleared','314068','Appraisal District','','','0','','0','','0','','','','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','BAY CITY','3776','2.0354','Aerobic,Septic Tank,Well','2006','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','215890064','1675106475','215890064','2023-01-08T13:42:57.020','54862104','Edward Oregbesan','Galere Realty','','','29.687360','-95.374853','16','77021','2','200000.00','Active','Seabrook','3450','Street','Houston','1','0','2','885','Single-Family','Welcome Home! This beautiful home with lots of character. It has everything you need 2 bedrooms and 1 full bathroom completely renovated home. New appliances included with an enclosed gate for privacy. Home is being sold as is. Furniture and Refrigerator stays with the house!','0.1148','4','','','','','Other Disclosures,Sellers Disclosure','','','','University Area','Central Electric','0','LT 13 BLK 87 SOUTH UNION SEC 1','Subdivision Lot','5000','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','WHIDBY ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','South Union Sec 01','3634','2.3307','Public Sewer,Public Water','1945','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','216151427','1675106475','216151427','2023-01-08T13:18:02.363','59228609','Deborah Smith','SRC Properties','','','30.063944','-95.742175','6','77377','12','1685000.00','Active','Tealpointe Ridge','20402','Lane','Tomball','5','1','5','5367','Single-Family','Modern spacious stone and stucco one-story with high ceilings and large windows throughout.  Featuring iron double front doors.  Spacious gameroom opens via a wall of windows to a sprawling outdoor living room. Workshop area, perfect for storing tools, bikes, and more.  Two of the four bays have an extra tall door and interior, allowing for an oversized vehicle.','1.5031','35','Jamestown Estate','','','','No Disclosures','','','','Hockley','Central Gas','1','LT 3 BLK 3 TEALPOINTE LAKE ESTATES','Cleared,Greenbelt','65475','Appraisal District','','1000','1','To Be Built/Under Construction','4','','0','','','','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Tealpointe Lake Estates','3633','2.1056','Septic Tank,Well','','');  --> 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','216185535','1675106475','216185535','2023-01-08T13:36:35.533','85337718','Erika Barrera','RE/MAX The Woodlands & Spring','','','30.439529','-95.451825','23','77378','7','259000.00','Active','Buffalo','5516','Circle','Willis','2','1','3','2050','Single-Family','INCREDIBLE OPPORTUNITY!! Pristine two-story home, nestled on a premium corner lot fully fenced for maximum privacy. Boasts a natural lit open floor plan, soaring high ceilings, warm neutral tones, tile & carpet throughout.  A spacious open kitchen offers quartz countertops, a new GE range & spacious kitchen cabinets making this ideal for entertaining. Main level features a primary bedroom with a large walk in closet & en suite bathroom with dual sinks, soaking tub & separate shower.  The second floor features 2 additional bedrooms with walk-in closets, a full bathroom & a game room/loft.  Ready for summer? Step out into this oversize backyard & extended patio making this ideal for summer barbecues. As if this wasn’t enough, this home also includes a water softener. Don’t miss out on this rare opportunity BIG home for less money (per squre footage).','0.1515','19','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','','Willis Area','Central Electric','1','CADDO VILLAGE, LOT 189','Corner,Subdivision Lot','6600','Appraisal District','','300','0','','2','Electric Oven','0','','','Electric Range','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal District','2','Split Level,Traditional','Caddo Village','3780','1.8448','Public Sewer,Public Water','2016','Appraisal District');  --> New record created successfully<br />