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-05T23:19:04.380' ,`MLSNumber` = '18176379' ,`ListAgentFullName` = 'Elizabeth Hewitt' ,`ListOfficeName` = 'Ward Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.975535' ,`Longitude` = '-95.965226' ,`PhotoCount` = '23' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '159000.00' ,`Status` = 'Active' ,`StreetName` = 'Rugeley' ,`StreetNumber` = '2016' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOKING FOR A FIXER UPPER? THIS HOUSE IS READY TO BE COMPLETED THE WAY YOU WANT, ALL DEMO HAS BEEN DONE, ROOF REPLACED, EXTERIOR PAINTED, GARAGE DOORS  & OPENERS REPLACED, MOST SHEETROCK WORK COMPLETE. HOME HAS BEAUTIFUL ORIGINAL WOODWORK/TRIM, TALL CEILINGS, SPLIT FLOOR PLAN, CORNER LOT& BRICK PATIO. HOME IS BEING SOLD AS IS, NO INSPECTION CONTINGENCIES.  ' ,`Acres` = '0.258' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,No Disclosures,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MOORES 2ND LOT 1 & N/2 LOT 2 BLK 8' ,`LotDesciption` = 'Corner' ,`LotSize` = '11238' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Moore 2nd' ,`TaxAmount` = '5997' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707238' WHERE `Matrix_Unique_ID` = '209804406'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T22:51:49.457' ,`MLSNumber` = '13591684' ,`ListAgentFullName` = 'Michael Nassif' ,`ListOfficeName` = 'NRE Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706942' ,`Longitude` = '-95.129176' ,`PhotoCount` = '21' ,`PostalCode` = '77536' ,`RoomCount` = '9' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Robin' ,`StreetNumber` = '334' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP fighting the traffic!  This cozy 4-bedroom Home with a beautiful glass Atrium and Huge dining room and lots of storage in the kitchen with granite countertops is located in Deer Park Terrace with great access to Hwy 225 and Beltway 8, and above all, this home also features a whole home GENERATOR.   Come to check it out, you won\'t be disappointed.' ,`Acres` = '0.1687' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 2 DEER PARK TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '7350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Park Terrace' ,`TaxAmount` = '5461' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707238' WHERE `Matrix_Unique_ID` = '211022103'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T23:23:01.680' ,`MLSNumber` = '16270755' ,`ListAgentFullName` = 'Christina Ilonzeh' ,`ListOfficeName` = 'Christina Ilonzeh' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672265' ,`Longitude` = '-95.256887' ,`PhotoCount` = '10' ,`PostalCode` = '77017' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Santa Bernadetta' ,`StreetNumber` = '5847' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice and clean move-in ready 2 story home located in an area that has no HOA and no MUD. Conveniently located near access to Downtown Houston, Pearland, Pasadena, and south I45 area. Living room and breakfast/dining areas feature open concept, great space for entertaining! First floor also features a half bath.' ,`Acres` = '0.0672' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 4 CIELO VISTA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BONNER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cielo Vista' ,`TaxAmount` = '4203' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707238' WHERE `Matrix_Unique_ID` = '211287169'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T22:06:44.257' ,`MLSNumber` = '84730840' ,`ListAgentFullName` = 'Madeline Phillips' ,`ListOfficeName` = 'Premier Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.650507' ,`Longitude` = '-94.876437' ,`PhotoCount` = '25' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '227500.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 146' ,`StreetNumber` = '6224' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUTE, CUTE, CUTE! Adorable 3bed/2bath home nestled on just under one acre! Upon arrival you’ll notice the carport and garage, oversized fenced backyard, and a covered deck perfect for entertaining! This home features a generous floor plan, tiled bathrooms, custom built ins, and much more!' ,`Acres` = '0.943' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 761 E STEPHENSON SURVEY TRACT 6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '41077' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '3648' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707238' WHERE `Matrix_Unique_ID` = '211661238'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T22:43:44.253' ,`MLSNumber` = '61835524' ,`ListAgentFullName` = 'Yolanda Graham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.489619' ,`Longitude` = '-94.962013' ,`PhotoCount` = '37' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 517' ,`StreetNumber` = '2787' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIME INVESTMENT PROPERTY THAT CAN BE ZONED COMMERCIAL OR RESIDENTIAL WITH NO RESTRICTIONS! This property fronts FM 517 on a large .79-acre lot with many possibilities. There are (3) units on the property. The small home on the right side of the property features 1 bedroom and 1 bath with an outside laundry room. The upstairs unit on the right side of the property is 2 bedrooms, 2 baths, a laundry room, and glass outside patio sunroom balcony. The downstairs unit on the right side of the property was previously a duplex and features 2 bedrooms, a Hollywood bath, 2 living areas, a kitchen, and a utility room complete with a stack washer/dryer. The property line goes far beyond the gated fence in the back of the units. TWO UNITS ARE CURRENTLY TENANT OCCUPIED. THIS IS AN EXCELLENT INCOME-PRODUCING PROPERTY WITH THE POTENTIAL TO ADD EVEN MORE FROM A PRIVATE RESIDENCE OR EVEN A BUSINESS IN THE BACK. The property will be sold as-is. MOTIVATED SELLERS WILL ENTERTAIN ALL OFFERS!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS N 286.5 OF E 120 OF W 253 FT OF LOT 1 BLK' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '34368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon Farm Home Tracts' ,`TaxAmount` = '6641' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707238' WHERE `Matrix_Unique_ID` = '211930180'  --> 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','211970976','1663707238','211970976','2022-09-05T23:44:04.107','17001421','Elida Guajardo','Houston Center Real Estate','','','29.522398','-96.068208','7','77435','2','369000.00','Active','Shan Pasha','771','Drive','East Bernard','2','1','2','2367','Single-Family','Commercial Property with extra land for development in growing East Bernard. The possibilities are endless with this one. Use it as your new Office, Retail Space, Medical Building or turn it into your Dream Home. Great location near Dairy Queen, Lowes Family Center and Amegy Bank.','0.8092','55','','','','','Sellers Disclosure','','','','','Central Electric','0','A20027 ABST.27 TRACT 31-19,31-20','Cleared','35249','Appraisal District','','','0','','0','','0','','','','','Composition','145 - East Bernard','EAST BERNARD ELEMENTARY SCHOOL','EAST BERNARD HIGH SCHOOL','EAST BERNARD J H','Accompany,Appointment Required,Request Online Appointment','Appraisal District','2','Other Style','n/a','7262','2.2866','Public Sewer,Public Water','2006','Appraisal');  --> 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','212186899','1663707238','212186899','2022-09-05T22:56:34.073','871247','Yohan Adhitama','REALM Real Estate Professional','','','29.915023','-95.683543','50','77095','10','430000.00','Active','Borden Bluff','9402','','Houston','2','0','4','3085','Single-Family','Newly renovated two story house with attached garage on oversized lot that back to green space and dog park. This charming house is located in a quiet cul-de-sac and only minutes away from Boardwalk at Towne Lake, Kroger, & Lone Star College. Brand new carpet, wood plank LVT flooring, and freshly painted wall, ceiling, trims throughout. Main floor consists of three bedrooms, study room, plus master suite complete with garden tub, enclosed toilet room, dual vanities, and ample closet space. Fully functional kitchen with pantry is right next to the breakfast and dining areas. Open living area with high ceiling & a bonus spacious game room on second floor. This house comes with large backyard and a covered patio for outdoor cooking.','','8','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Copperfield Area','Central Gas','1','LT 15 BLK 2 CANYON LAKES AT STONEGATE SEC 7','Cul-De-Sac,Greenbelt,Subdivision Lot','10527','Appraisal District','','940','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','POSTMA ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Canyon Lakes at Stonegate','','','Water District','2005','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','212198738','1663707238','212198738','2022-09-05T23:18:55.550','91003373','Derrick Love','Investment Scouts Realty','','','29.975234','-95.209445','50','77346','6','309900.00','Active','Texian Forest','4122','Trail','Humble','2','0','4','2319','Single-Family','Beautiful 4 bedroom home located in an amazing neighborhood in Humble, TX. Open concept floor plan, Large Primary Suite with a huge bathroom featuring a jacuzzi tub and separate shower, walk-in closet and double sinks. Primary bath has custom closet & flooring. Kitchen features Granite counters, Island, Gas range. Upgraded wood flooring in bedrooms. Wood burning fireplace in the living room. Secondary bathroom completely updated with double sinks and walk-in shower. Functional sprinkler system. Gutters all around the home. Lots of natural light throughout the home. Driveway was extended to add additional space for vehicles. Upgraded lighting throughout. Storage shed in backyard. Garage upgraded with epoxy flooring. Double pane windows throughout & radiant heat barrier in attic. 4th bedroom can be used as the home office. 6 camera surveillance system stays with the home. Backyard features a covered back patio with retractable screens to minimize bugs. This Home is ready to move in now.','0.1356','1','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Atascocita South','Central Electric','1','LT 14 BLK 1 ATASCOCITA FOREST SEC 23','Cleared','5906','Appraisal District','','500','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','29 - Humble','WHISPERING PINES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern','Atascocita Forest Sec 23','6229','2.773','Public Sewer,Public Water','2011','Appraisal District');  --> New record created successfully<br />