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-29T20:16:41.210' ,`MLSNumber` = '23097031' ,`ListAgentFullName` = 'Demetrice Ballenger' ,`ListOfficeName` = 'Baker & Co | Forbes Global Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834943' ,`Longitude` = '-95.415285' ,`PhotoCount` = '25' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '402900.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury awaits at this 5 home new construction development located just north of the 6-10 Loop. Homes within this community include features such as open concept living, modern finishes, spacious master suites and backyards.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Stoneworks' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5, BLK 1, MARTIN STREET TERRACE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1741' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Craftsman' ,`Subdivision` = 'Martin Street Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266051' WHERE `Matrix_Unique_ID` = '206158995'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T20:01:20.553' ,`MLSNumber` = '10613368' ,`ListAgentFullName` = 'Demetrice Ballenger' ,`ListOfficeName` = 'Baker & Co | Forbes Global Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834943' ,`Longitude` = '-95.415285' ,`PhotoCount` = '25' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury awaits at this 5 home new construction development located just north of the 6-10 Loop. Homes within this community include features such as open concept living, modern finishes, spacious master suites and backyards.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Stoneworks' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1, BLK 1, MARTIN STREET TERRACE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1896' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Craftsman' ,`Subdivision` = 'Martin Street Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266051' WHERE `Matrix_Unique_ID` = '206202839'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T20:21:05.293' ,`MLSNumber` = '68285392' ,`ListAgentFullName` = 'Silvestre Ocampo' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = 'Silvestre Ocampo' ,`SellingOfficeName` = 'CB&A, Realtors- Southeast' ,`Latitude` = '29.734165' ,`Longitude` = '-95.357419' ,`PhotoCount` = '27' ,`PostalCode` = '77004' ,`RoomCount` = '7' ,`ListPrice` = '195000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brailsfort' ,`StreetNumber` = '2712' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2712 Brailsfort St. This home is a fixer upper cozy home. Perfect for anyone looking for a property with no restrictions. Huge yard perfect for  entertaining.  In a great location near Downtown, Midtown, University of Houston, TSU and easy access to Hwy 288 and Hwy 45. Great potential for an investor, flip and to build townhouses with the 5,000sqft lot. Thank you for viewing.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 30 WILSON WM A' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilson Wm A' ,`TaxAmount` = '3499' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266052' WHERE `Matrix_Unique_ID` = '212536330'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T20:21:45.727' ,`MLSNumber` = '11484580' ,`ListAgentFullName` = 'Joe Williams' ,`ListOfficeName` = 'Wiltex Realtors' ,`SellingAgentFullName` = 'Dallas Tadlock' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.973962' ,`Longitude` = '-95.649599' ,`PhotoCount` = '34' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '485000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gleaming Rose' ,`StreetNumber` = '14418' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 14418 Gleaming Rose Dr! Fantastic place to make a home and with the open concept floor plan entertaining is easy! Kitchen features a large island with a breakfast bar. The primary bedroom has a tray ceiling and large windows bringing in ample amounts of natural light. The primary bathroom has a separate shower, soaking tub and walk in closet. Upstairs is filled with fun with a large game room and media room. The media room is all set up with visual and audio equipment that will come with the home, including the projector and screen. The front porch is the perfect place to have a hot cup of coffee each morning and the backyard is perfect for your friend and family get togethers with a large backyard and grill. Come see this beautiful home today!' ,`Acres` = '0.1616' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 COLES CROSSING SEC 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'COLES CROSSING Sec 29' ,`TaxAmount` = '8800' ,`TaxRate` = '2.531' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266052' WHERE `Matrix_Unique_ID` = '212767572'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T19:48:08.220' ,`MLSNumber` = '56648865' ,`ListAgentFullName` = 'Liliana Pena' ,`ListOfficeName` = 'Keller Williams Realty         - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654475' ,`Longitude` = '-95.151374' ,`PhotoCount` = '22' ,`PostalCode` = '77505' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Clover Meadows' ,`StreetNumber` = '3738' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE this ready to move in 4-bedroom 2.5 bath home. It is located only a few minutes away from all major shopping areas, medical facilities and zoned to Pasadena ISD. Interior of home has custom paint, texture, tile & molding touches throughout. Kitchen features a movable granite top island, granite counters, under cabinet lighting. Master bedroom downstairs. Three bedrooms upstairs and huge family/game room with bar. Glass door leading to patio/balcony overlooking the pool. Spacious back yard with no backdoor neighbors. Two car garage & large extended driveway provides plenty of extra parking. Don’t miss your chance to see this house and call it your HOME.' ,`Acres` = '0.1814' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 4 COUNTRY BRIAR SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Briar Sec 01' ,`TaxAmount` = '5940' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266053' WHERE `Matrix_Unique_ID` = '212926455'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T20:19:11.400' ,`MLSNumber` = '79945010' ,`ListAgentFullName` = 'Demetrice Ballenger' ,`ListOfficeName` = 'Baker & Co | Forbes Global Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834943' ,`Longitude` = '-95.415285' ,`PhotoCount` = '25' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '394900.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONLY 3 HOMES LEFT! Luxury awaits at this 5 home new construction development located just north of the 6-10 Loop. Homes within this community include features such as open concept living, modern finishes, spacious master suites and backyards. Great builder warranty! Estimated completion date is the end of March 2023.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Stoneworks' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2, BLK 1, MARTIN STREET TERRACE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1747' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Craftsman' ,`Subdivision` = 'Martin Street Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266053' WHERE `Matrix_Unique_ID` = '213337754'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T20:20:49.100' ,`MLSNumber` = '16261468' ,`ListAgentFullName` = 'Demetrice Ballenger' ,`ListOfficeName` = 'Baker & Co | Forbes Global Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834943' ,`Longitude` = '-95.415285' ,`PhotoCount` = '25' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '394900.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury awaits at this 5 home new construction development located just north of the 6-10 Loop. Homes within this community include features such as open concept living, modern finishes, spacious master suites and backyards. Great builder warranty!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Stoneworks' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3, BLK 1, MARTIN STREET TERRACE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1747' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Craftsman' ,`Subdivision` = 'Martin Street Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266054' WHERE `Matrix_Unique_ID` = '213338041'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T20:58:31.007' ,`MLSNumber` = '74329439' ,`ListAgentFullName` = 'Olivia Ober' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.357106' ,`Longitude` = '-96.570839' ,`PhotoCount` = '24' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '135000.00' ,`Status` = 'Active' ,`StreetName` = 'Navajo' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Road' ,`City` = 'Somerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity in Apache Hills subdivision!  Neighborhood has its own boat ramp.   Beautiful corner wooded property with two buildings under a huge porch.  One building has a living, bedroom, full bath and kitchen.  The other unit has two bedrooms, separate full bath with washer and dryer hook ups.  The property has three lots! Schedule tour with owner today!' ,`Acres` = '0.5746' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S2505 APACHE HILLS BLK B LOT 11 & 12' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '13432' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Apache Hills' ,`TaxAmount` = '734' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675266054' WHERE `Matrix_Unique_ID` = '213476411'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T19:20:36.557' ,`MLSNumber` = '78460500' ,`ListAgentFullName` = 'Laya Zachariah' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421006' ,`Longitude` = '-95.285322' ,`PhotoCount` = '30' ,`PostalCode` = '77511' ,`RoomCount` = '6' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 180' ,`StreetNumber` = '1848' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this completely remodeled 3 bedroom/2 full bath/1836 sq. ft. manufactured home. Built in 2006, this double wide sits on 2-acre fenced and gated lot with no restrictions. This home has access from the front and back. New paint interior and exterior. New soft carpet in all bedrooms. Modern premium vinyl plank flooring in living room, kitchen, dining room and den. Island kitchen with new cabinets and granite countertops with backsplash. Large living room is perfect for family gatherings with a fireplace to keep warm during winter season. Water well pump and motor just replaced with 1-year warranty. Water tank on well was also raised up 8 inches. Septic tank upgrades: new panel, new spray pump with floats, new air compressor and sprinklers. All three septic tanks recently pumped out. Bring your horse or farm animals onto this ready to move-in home. Don\'t miss the opportunity for country living at its finest. This home has FHA approved tie-down anchors installed. Survey available. ' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BLUM (A0474 H T & B R R ) LOT 24B ACRES 2.0 S# 125011008A00H' ,`LotDesciption` = 'Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Blum' ,`TaxAmount` = '2018' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266055' WHERE `Matrix_Unique_ID` = '213732261'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T20:28:28.337' ,`MLSNumber` = '35039737' ,`ListAgentFullName` = 'Elmer Garcia' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Brittany Payne' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.439964' ,`Longitude` = '-95.419995' ,`PhotoCount` = '33' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '435000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Twain' ,`StreetNumber` = '9819' ,`StreetSuffix` = 'Court' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning traditional 4BD- 3BA with an Oversize Cul-de-sac lot is nestled in the charming Master planned Community of Meridiana. This move-in ready home has granite counter tops, kitchen backsplash, blinds throughout the home and tile flooring throughout the home. Primary bedroom features gorgeous wide crown molding & double french doors leading into your master bath that has double upgraded square sinks, separate garden tub & huge doorless shower. Let\'s not forget the endless opportunities with the large back yard.' ,`Acres` = '0.3204' ,`Area` = '5' ,`BuilderName` = 'TRENDMAKER HOMES' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 4 (A0515 HT&BRR) BLK 1 LOT 19' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13957' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Meridiana Sec 4 A0515 Ht&Brr' ,`TaxAmount` = '13244' ,`TaxRate` = '3.5849' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266055' WHERE `Matrix_Unique_ID` = '214064984'  --> 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`,`SqFtTo