Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T11:53:56.767' ,`MLSNumber` = '89261445' ,`ListAgentFullName` = 'Miriam Reyes' ,`ListOfficeName` = 'Texas Prominent Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192287' ,`Longitude` = '-95.125956' ,`PhotoCount` = '16' ,`PostalCode` = '77372' ,`RoomCount` = '6' ,`ListPrice` = '579608.00' ,`Status` = 'Active' ,`StreetName` = 'Leon' ,`StreetNumber` = '17111' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom built home sitting on 1.18 acres! Home features 3 bedrooms plus a study. Study could be a 4th bedroom. Beautiful updated kitchen which opens up to living area. Kitchen features custom cabinets, island with granite countertops, and large walk in pantry. Open floor plan with lots of natural lighting. Beautiful wood tile flooring throughout the house and carpet in bedrooms. Large master suite with a great sized walk in closet. Master bath features double sinks, separate shower, and tub.' ,`Acres` = '1.18' ,`Area` = '40' ,`BuilderName` = 'Sainz 3 Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 3, LOT 99, ACRES 1.18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '51401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '969' ,`TaxRate` = '2.0029' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085716' WHERE `Matrix_Unique_ID` = '203450654'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T11:24:38.650' ,`MLSNumber` = '53950225' ,`ListAgentFullName` = 'Tami Hons' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.511985' ,`Longitude` = '-96.305512' ,`PhotoCount` = '48' ,`PostalCode` = '77845' ,`RoomCount` = '8' ,`ListPrice` = '715500.00' ,`Status` = 'Active' ,`StreetName` = 'Millstone' ,`StreetNumber` = '5554' ,`StreetSuffix` = 'Drive' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable Raven-built home on 1 acre lot in new Millstone Estates - a hidden gem of a community in College Station with almost 1000 sq ft of covered porches. Popular neutral pallet, three-way split floor plan, with 4 bedrooms, 3 bathrooms, open concept living with fireplace, dining and kitchen with custom cabinets, stainless appliances, including gas cooktop and walk-in pantry. Primary suite views beautifull wooded backyard, has direct access to laundry room, separate vanities, claw-foot tub and oversized shower. Large three-car garage (1118 sq ft) has one separated bay and stair access to a second story that could simply be decked attic space or office. Quick access to area amenities but with plenty of room to breathe.' ,`Acres` = '1.014' ,`Area` = '61' ,`BuilderName` = 'Raven Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MILLSTONE ESTATES, BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44170' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'RIVER BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Millstone Estates' ,`TaxAmount` = '1055' ,`TaxRate` = '1.7344' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085717' WHERE `Matrix_Unique_ID` = '208418575'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T11:15:49.810' ,`MLSNumber` = '23718565' ,`ListAgentFullName` = 'Rosaura Arango' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771853' ,`Longitude` = '-95.402922' ,`PhotoCount` = '10' ,`PostalCode` = '77007' ,`RoomCount` = '2' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Allen' ,`StreetNumber` = '4115' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '783' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect opportunity for builders and investors!! This property is surrounded by beautiful renovated townhomes. Easy access to freeways and all of your favorite spots in the heart of downtown Houston. Also being sold as a bundle with 4113 Allen St. Both properties make a total of 14,000 SF!' ,`Acres` = '0.0803' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 241 MAGNOLIA' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia' ,`TaxAmount` = '6150' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085717' WHERE `Matrix_Unique_ID` = '212735775'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T12:11:12.450' ,`MLSNumber` = '71151320' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848552' ,`Longitude` = '-95.231242' ,`PhotoCount` = '25' ,`PostalCode` = '77078' ,`RoomCount` = '7' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Song' ,`StreetNumber` = '8623' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1673' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impress your guests in this fantastic 3-bedroom, 2-bathroom home in Parkwood East, which features wood flooring, a gas log fireplace, an open great room, a spacious primary suite, and a covered patio in the expansive backyard. Cook up new cuisines in the kitchen, complete with granite countertops, tile backsplash, gas cooktop, and stainless-steel appliances. Commuters enjoy close proximity to the Sam Houston Tollway, U.S. 90, and major business areas including Sugar Land and the Texas Medical Center. Minutes away from a variety of parks, scenic lakes, golf courses, and walking trails. Students attend schools a part of Houston ISD.' ,`Acres` = '0.202' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 105 BLK 4 PARKWOOD EAST SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`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` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood East' ,`TaxAmount` = '3532' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085717' WHERE `Matrix_Unique_ID` = '213083850'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T11:11:43.320' ,`MLSNumber` = '64219511' ,`ListAgentFullName` = 'Elaine Marie Cantu' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813000' ,`Longitude` = '-95.365044' ,`PhotoCount` = '10' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Kelley' ,`StreetNumber` = '506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further, you have found it! The perfect English cottage in revitalized neighborhood of Lindale Park. Increased popularity of this neighborhood, has made it the hot spot to call home. Enjoy morning coffee or evening wine on the front porch. Potential for landscaping and curb appeal. Schedule your tour today.' ,`Acres` = '0.1582' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 23 & 24 BLK 3 LINDALE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Lindale Park Sec 01' ,`TaxAmount` = '5798' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085717' WHERE `Matrix_Unique_ID` = '213861567'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T12:06:34.763' ,`MLSNumber` = '75188115' ,`ListAgentFullName` = 'Leslie Wilson' ,`ListOfficeName` = 'HomeSmart Stars' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937446' ,`Longitude` = '-95.593809' ,`PhotoCount` = '22' ,`PostalCode` = '77065' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenora' ,`StreetNumber` = '11210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ACTIVE MOLD - ACTIVE MOLD - ACTIVE MOLD FIXER UPPER - ON 3 Large LOTS' ,`Acres` = '1.71' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 279 BLK Q TOWER OAKS' ,`LotDesciption` = 'Wooded' ,`LotSize` = '74764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tower Oaks' ,`TaxAmount` = '1961' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085718' WHERE `Matrix_Unique_ID` = '214207894'  --> 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','214653258','1675085718','214653258','2022-11-30T11:27:37.780','93434810','Marium Imran','Pinnacle Realty Advisors','','','29.808888','-95.498362','46','77055','6','399900.00','Active','Marnel','2021','Road','Houston','2','0','5','2169','Single-Family','Recently updated single family home with 5 bedrooms 2 bathroom in the friendly community of Ridgecrest. Home features laminate wood floors throughout the house, a fresh coat of paint and so much more! The backyard is perfect for relaxing and entertaining, with ample space to enjoy the outdoors. Neighborhood has several parks, restaurants and picnic areas to enjoy.','0.2129','24','','','','','Sellers Disclosure','','','1','Spring Branch','Central Electric','0','LT 10 BLK 1 RIDGECREST SEC 4','Subdivision Lot','9272','Appraisal District','','','0','','1','Convection Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','49 - Spring Branch','RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Ridgecrest Sec 04','5385','2.4415','Public Sewer,Public Water','1954','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T11:02:47.180' ,`MLSNumber` = '29526680' ,`ListAgentFullName` = 'Kitako Kureyama' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.379350' ,`Longitude` = '-95.078173' ,`PhotoCount` = '9' ,`PostalCode` = '77510' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Oregon' ,`StreetNumber` = '11806' ,`StreetSuffix` = 'Trail' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in desirable Santa Fe school district and most wanted neighborhood in the area. Well maintained 2005 house with all desirable features...high ceiling throughout the house, no back neighbor, covered patio, split floor plan, ceramic in web areas and porcelain in living/bedrooms, separate bath/shower, his and her closets, double sink in master bath, oversized driveway/garage, new paint in all bedrooms...a lot more. Come and check it out. This one won\'t last long!!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE TRAILS PHASE 3 (2005) ABST 149, BLOCK 2, LOT 17, AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Santa Fe Trails Ph 3' ,`TaxAmount` = '4256' ,`TaxRate` = '3.06529' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085718' WHERE `Matrix_Unique_ID` = '214941506'  --> 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','215183595','1675085718','215183595','2022-11-30T12:04:55.410','83426768','Edwin Libreros','REALM Real Estate Professional','','','30.161744','-95.039440','14','77327','3','158000.00','Active','Road 5245','32','','Cleveland','2','0','3','1264','Single-Family','','0.4','52','','','','','Sellers Disclosure','','','','Cleveland Area','Central Electric','0','SANTA FE, SEC 2, BLOCK 21, LOT 3106, ACRES 0.4000','Subdivision Lot','17424','Appraisal District','','120','0','','0','','0','','','','','Aluminum','100 - Cleveland','PINE BURR ELEMENTARY SCHOOL','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Lockbox Back','Builder','1','Traditional','Santa Fe','1220','2.0417','Public Sewer,Public Water','2019','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','215186409','1675085718','215186409','2022-11-30T11:17:38.507','57947993','Cyndi Kornegay','Gatehouse Properties','','','29.983260','-95.646220','11','77429','10','599998.00','Active','Kingsford Willow','14822','Lane','Cypress','3','0','4','2616','Single-Family','Looking for a spacious, open floor plan? This stunning one-story home boasts just what you have been searching for. An extended foyer greets you as you walk through the door paving your way into the heart of the home. Featuring an open floor plan between the kitchen, family room and dining area, this space is ideal for entertaining. The gorgeous kitchen is equipped with an oversized island and stainless-steel appliances. Work from home in the spacious home office which flanks the kitchen and family room. Relax for the evening on the large covered patio and watch the sun set. Additional entertaining space is found in the game room located at the back of the home. We are proud to deliver the finest quality workmanship and we back it up with an industry leading warranty program. Come visit this stunning home today!','','10','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','1','Cypress North','Central Gas','1','Lot 14 Block 1','Greenbelt','7800','Survey','','990','1','To Be Built/Under Construction','3','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','HAMILTON ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Accompany,Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Traditional','Enclave at Longwood','','2.5','Water District','2022','Builder');  --> New record created successfully<br />