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-12-09T12:47:20.967' ,`MLSNumber` = '81314264' ,`ListAgentFullName` = 'Sergio De La Llata Jr.' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649259' ,`Longitude` = '-95.373505' ,`PhotoCount` = '6' ,`PostalCode` = '77051' ,`RoomCount` = '4' ,`ListPrice` = '100000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairland' ,`StreetNumber` = '10013' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1325' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 21 BLUERIDGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5770' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Blueridge Sec 02' ,`TaxAmount` = '1617' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089106' WHERE `Matrix_Unique_ID` = '205243668'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T12:44:06.033' ,`MLSNumber` = '55047287' ,`ListAgentFullName` = 'John Smither' ,`ListOfficeName` = 'Smither Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.711694' ,`Longitude` = '-95.553740' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '8' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue N' ,`StreetNumber` = '2017' ,`StreetSuffix` = 'Avenue' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.343' ,`Area` = '43' ,`BuilderName` = 'Dan Phillips' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'HUNTSVILLE TOWNSITE, BLOCK 148, LOT 2, ACRES .343' ,`LotDesciption` = 'Wooded' ,`LotSize` = '14941' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Huntsville Townsite' ,`TaxAmount` = '4360' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089106' WHERE `Matrix_Unique_ID` = '212265081'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T12:58:34.350' ,`MLSNumber` = '58887945' ,`ListAgentFullName` = 'Rebecca Hamilton' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404258' ,`Longitude` = '-95.707502' ,`PhotoCount` = '9' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Baja Street' ,`StreetNumber` = '1115' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful New Home in the country.  Well built 3 bedroom 2 bath home, with large yard for kids and pets.  So close to town and all the amenities but still very country. Come take a look today.' ,`Acres` = '0.351' ,`Area` = '39' ,`BuilderName` = 'Walker Montgomery CD' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S555690 - GULF COAST ESTATES 02 REPLAT NO 1, BLOCK 1, LOT 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15290' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf Coast Estates 02 Rep 1' ,`TaxAmount` = '156' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089107' WHERE `Matrix_Unique_ID` = '213243290'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T12:35:10.953' ,`MLSNumber` = '10984919' ,`ListAgentFullName` = 'Erick Harbert' ,`ListOfficeName` = 'Realty Right' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.181328' ,`Longitude` = '-95.159277' ,`PhotoCount` = '50' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Parthenon' ,`StreetNumber` = '714' ,`StreetSuffix` = 'Place' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2275' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 714 Parthenon Place, you\'ll love this single story home! Notice the great curb appeal right away. This home has neutral tones and beautiful updates to make it easier for you to just move right in! The formal dining is connected to the spacious eat in kitchen that features stainless steel appliances, a gas cooktop, and ample storage. The large living space has a lovely fireplace. Into the primary suite you\'ll find vaulted ceilings, double vanity, a separate soaking tub, and custom closet. There are 3 spacious secondary bedrooms and a full bath, perfect for your family or guests. Head out back to the patio and envision all the fun you could have in the huge back yard! Don\'t miss out on this great home!' ,`Acres` = '0.4591' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 02, BLOCK 3, LOT 12' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest 02' ,`TaxAmount` = '8871' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089107' WHERE `Matrix_Unique_ID` = '213772289'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T12:33:04.927' ,`MLSNumber` = '84692464' ,`ListAgentFullName` = 'Marcus Rankin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.725863' ,`Longitude` = '-95.099956' ,`PhotoCount` = '6' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '107000.00' ,`Status` = 'Active' ,`StreetName` = 'Jill' ,`StreetNumber` = '149' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to peaceful living. This property is located right in the great neighborhood of Commodore Cape within walking distance to Lake Livingston. This property features 2 bedrooms, 1 bath and comes with a covered patio, a spacious living room for entertaining guests, a huge front yard, plenty of space for outdoor activities and is situated on a cul-de-sac. Come see this property today!' ,`Acres` = '0.1768' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COMMODORE CAPE SECTION 3 LOT 162' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '107' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Commodore Cape Sec 3' ,`TaxAmount` = '1240' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089107' WHERE `Matrix_Unique_ID` = '214679196'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T12:07:49.570' ,`MLSNumber` = '96930521' ,`ListAgentFullName` = 'Christopher Almaraz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '36' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '276990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 51024' ,`StreetNumber` = '84' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.16' ,`Area` = '52' ,`BuilderName` = 'Casas Houston LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 3, BLOCK 50, LOT 6418, ACRES 0.1600' ,`LotDesciption` = 'Other' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Sec 3' ,`TaxAmount` = '672' ,`TaxRate` = '2.0417' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089107' WHERE `Matrix_Unique_ID` = '215056553'  --> 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','215096020','1675089108','215096020','2022-12-09T11:39:33.620','86316421','Daphne Brown','Beyond the Home Realty, LLC','','','29.432800','-95.458267','21','77583','5','315000.00','Active','Owens Lake','10421','Drive','Rosharon','2','0','3','1614','Single-Family','This is your Home for the holidays!!!  This like-new 2021 one story is located on a 12,000+ sq. ft. lot (one of the largest in the area) AND it is in a cul-de-sac. This beautiful home features an open and central great room, and kitchen with oversized island. The spacious primary bedroom and bathroom offers tons of natural light, double vanities, stand up shower, water closet, as well as large- walk in closet. The spacious backyard is a clear winner in this home! The possibilities are endless in this backyard... imagine adding a pool, playground, basketball court, or outdoor kitchen. This home is definitely an entertainer\'s dream! With super quick access to HWY 288 and even quicker access to the amazing lagoon being built in this master planned community, this won\'t last long! Call to schedule an appointment today!','0.2976','5','Anglia Homes','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','','Alvin North','Central Electric','1','SIERRA VISTA WEST SEC 3 (A0329 LAV NAV CO) BLK 3 LOT 54','Cul-De-Sac','12963','Appraisal District','','1450','0','','2','Gas Oven','0','','','','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Builder','1','Ranch','Sierra Vista West Sec 3','9553','3.6007','Public Sewer,Public Water','2021','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','215335851','1675089108','215335851','2022-12-09T12:46:36.663','74167491','Jose Portillo','HomeSmart','','','29.672348','-95.304203','23','77087','6','310000.00','Active','Ridgeway','6839','Drive','Houston','2','0','4','2359','Single-Family','Wow!!! This house has four bedrooms and a huge den!!!!  Enough room to accommodate!!! Remodeled house/updated house!!! Some outstanding updates include kitchen cabinets, granite counter, appliances, gorgeous waterproof vinyl laminate planks, interior/exterior paint, doors, baseboards, spotlights, lights, carpet and many more. NEW ROOF AND NEW AIR HANDLER SYSTEM were installed!!!!!!!!!!','0.1675','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Hobby Area','Central Electric','0','LT 21 BLK 11 ANDOVER PLACE SEC 3','Subdivision Lot','7296','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','GREGG ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','HARTMAN MIDDLE SCHOOL','No Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Andover Place','3345','2.3307','Public Sewer,Public Water','1957','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','215403926','1675089108','215403926','2022-12-09T12:19:04.967','3819110','Dawn Bajalieh','RE/MAX Integrity','','','29.917665','-95.497352','21','77086','4','214900.00','Active','Pinole','9435','Lane','Houston','2','0','3','1391','Single-Family','Welcome Home! This 3 bedroom 2 Bath is waiting for the perfect homeowner. Home has been painted inside and out July 2022. Granite in kitchen,. recent dishwasher.\r\n Priced to sell. Plenty of room for family gatherings. Yard is big enough for a pool, outdoor kitchen, and a puppy!','0.1446','11','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Freestanding,Wood Burning Fireplace','1','Northwest Houston','Central Electric','1','LT 20 BLK 5 017*W3466200-008-005-020 WILLOWOOD SEC 8','Subdivision Lot','6300','Appraisal District','','250','0','','2','Electric Oven,Freestanding Oven','0','','','Freestanding Range','','Composition','32 - Klein','EPPS ISLAND ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Willowood Sec 08','4366','2.8555','Water District','1978','Appraisal District');  --> New record created successfully<br />