Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:55:43.767' ,`MLSNumber` = '55341194' ,`ListAgentFullName` = 'Dena Williams' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.631165' ,`Longitude` = '-95.117863' ,`PhotoCount` = '48' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Place' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'There\'s room for everyone in this multi-generation home. Move to the lake and work from home with fiber broadband internet services available. Unbeatable privacy, yet walking distance from the 3rd largest lake in Texas and/or the community pool Two houses in one. Full kitchen and living room on both floors with a separate upstairs entrance. Downstairs kitchen & bath completely updated with large nicely tiled shower, pretty white granite countertops and stainless appliances. Fireplace and chimney recently professionally reconstructed with firebrick. Recent water heater. Lots of decks and porches surrounding this house on four lots, almost an acre. Large double detached garage. Large out building for future guest cottage or bunkhouse. Coldspring Terrace is a pretty Lake Livingston community with boat launch, fishing pier and community swimming pool and park. All just 3 miles from the charming little town of Coldspring. 30 minute drive to Conroe. About an hour drive to Houston.' ,`Acres` = '0.8219' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLDSPRING TERRACE #3, BLOCK 7, LOT 19 - 22, ACRES 0.8219' ,`LotDesciption` = 'Corner' ,`LotSize` = '35802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coldspring Terrace #3' ,`TaxAmount` = '1989' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696257' WHERE `Matrix_Unique_ID` = '207324771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:47:54.097' ,`MLSNumber` = '17040418' ,`ListAgentFullName` = 'Andre Tolbert' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.023687' ,`Longitude` = '-95.435431' ,`PhotoCount` = '28' ,`PostalCode` = '77566' ,`RoomCount` = '9' ,`ListPrice` = '277900.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '941' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What an opportunity? This type of home! This size yard! This price. Come check out this home which is located in a very central part of Lake Jackson. It features 2 living areas for those large gatherings and a kitchen designed for person who truly enjoys entertaining. Very large yard with ample parking and as a getaway there\'s a sunroom/sitting area just between the dining room. Come look today.' ,`Acres` = '0.4078' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'AREA H (LAKE JACKSON), BLOCK 6, LOT 21' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '17764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Area B-C-D-E-G-H-J-K-L Etc La' ,`TaxAmount` = '7433' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696257' WHERE `Matrix_Unique_ID` = '207897247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:35:41.637' ,`MLSNumber` = '55239642' ,`ListAgentFullName` = 'Lou Rosas' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.603630' ,`Longitude` = '-95.458097' ,`PhotoCount` = '50' ,`PostalCode` = '77053' ,`RoomCount` = '8' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Long Look' ,`StreetNumber` = '15330' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location makes for easy access to Medical Center, Beltway 8, 288, 610 Loop. 3 bedroom/2 bath/2 car garage home on a half Acre Lot (21,780 sf). Office/Study can be converted to 4th Bedroom/Game Room/Hobby room, etc. \r\n Completely remodeled - driveway can accommodate 8 cars (measurements in the aerial picture outlines are approximate - see Survey for Exact measurements)' ,`Acres` = '0.5' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S 1/2 OF LT 9 BLK 1 NEDERHUT' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REAGAN K-8 EDUCATION CENTER' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'REAGAN K-8 EDUCATION CENTER' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nederhut' ,`TaxAmount` = '3183' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696257' WHERE `Matrix_Unique_ID` = '207931234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T10:45:35.043' ,`MLSNumber` = '18780191' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895895' ,`Longitude` = '-95.072333' ,`PhotoCount` = '18' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '355990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaska Cedar' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood is one of our most popular plans. Beautiful 12-foot ceilings with a double Tray in the Dining room reaching to 16\'. Large Living area and a Study!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27, Block 1, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696257' WHERE `Matrix_Unique_ID` = '209179676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:15:24.700' ,`MLSNumber` = '50348825' ,`ListAgentFullName` = 'Patricia Ann Anderson' ,`ListOfficeName` = 'Bay Prairie Investment Inc,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.975120' ,`Longitude` = '-95.968831' ,`PhotoCount` = '7' ,`PostalCode` = '77414' ,`RoomCount` = '2' ,`ListPrice` = '89000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue G' ,`StreetNumber` = '2816' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has great potential. It sits on two separate lots and has a detached garage that has been converted into a workshop. There is space in the back to add another rental unit.' ,`Acres` = '0.4362' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Short Sale' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MOORE 2ND, BLOCK 13, LOT 5A (REPLAT OF LTS 4 & 5)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Moore 2nd' ,`TaxAmount` = '2096' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696257' WHERE `Matrix_Unique_ID` = '209307175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:48:39.570' ,`MLSNumber` = '81672382' ,`ListAgentFullName` = 'Jessica Tant' ,`ListOfficeName` = 'Fowler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.526864' ,`Longitude` = '-94.443150' ,`PhotoCount` = '25' ,`PostalCode` = '77663' ,`RoomCount` = '7' ,`ListPrice` = '184500.00' ,`Status` = 'Active' ,`StreetName` = 'Wildwood' ,`StreetNumber` = '909' ,`StreetSuffix` = '' ,`City` = 'Village Mills' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 3/2/2 home with open concept living and an island style kitchen. Relax and unwind in your sunroom and enjoy the privacy in your backyard, with no neighbors in sight. This place has had some really lovely updates and is move in ready. Located in a 24/7 gated community with an 18-hole golf course and several amenities. Community lake is currently drained in preparation for re-construction of dam.' ,`Acres` = '0.2096' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S6200 WILDWOOD BLOCK S LOT 17 ACRES 0.2096' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1012 - Warren' ,`SchoolElementary` = 'WARREN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KOUNTZE HIGH SCHOOL' ,`SchoolMiddle` = 'KOUNTZE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood' ,`TaxAmount` = '1467' ,`TaxRate` = '2.4438' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696258' WHERE `Matrix_Unique_ID` = '209795734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T10:41:48.507' ,`MLSNumber` = '69514453' ,`ListAgentFullName` = 'Jose Pablo Martinez' ,`ListOfficeName` = 'JPMG Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.257277' ,`Longitude` = '-95.115403' ,`PhotoCount` = '34' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 373' ,`StreetNumber` = '1030' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and look at this gorgeous, fully remodeled home. Sited on a 1.7-acre lot, this fantastic property is located just a short drive from Interstate 69 North. There is fast and easy access to many popular stores, restaurants, and businesses, including the Grand Parkway. Splendora is a great place to live. It has a strong community where people help out each other. With the expansion of I-69, it\'s becoming a fast-growing area, which makes this property an excellent opportunity to have a spectacular home with lots of space to enjoy country-style living.' ,`Acres` = '1.6818' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODLANE, BLOCK 2 SEC J, LOT 17, ACRES 1.6818' ,`LotDesciption` = 'Corner' ,`LotSize` = '73260' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'Woodlane' ,`TaxAmount` = '3453' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696258' WHERE `Matrix_Unique_ID` = '210883778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:49:30.127' ,`MLSNumber` = '22860241' ,`ListAgentFullName` = 'Carol Wolfe' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831798' ,`Longitude` = '-95.194838' ,`PhotoCount` = '6' ,`PostalCode` = '77049' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Shelburne' ,`StreetNumber` = '13206' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1377' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great new build opportunity, over an acre of desired land available. Great for investors and builders, or if you want to build your own home with plenty of land or split into multiple properties. Just down the street from tons of builder development, and easy access to beltway 8. Lot has two has two septic tank systems. Harris County has announced that all culverts will be removed and replaced. Roof was replaced two years ago, per seller.' ,`Acres` = '1.0468' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 257 258 259 & 260 BLK 21 BEAUMONT PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '45600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beaumont Place Sec 02' ,`TaxAmount` = '1979' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696258' WHERE `Matrix_Unique_ID` = '210955834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T10:30:47.977' ,`MLSNumber` = '25304108' ,`ListAgentFullName` = 'Julian Kwok' ,`ListOfficeName` = 'Regal Realty International, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847310' ,`Longitude` = '-95.354460' ,`PhotoCount` = '23' ,`PostalCode` = '77093' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'TIDWELL' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare investment property for sale on Tidwell - unrestricted store front with 1 bedroom condo above. Perfect for small business owner to live and grow.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 8M ABST 329 J T HARRELL' ,`LotDesciption` = 'Corner' ,`LotSize` = '3615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARCIA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'PATRICK HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Harrell - Tidwell' ,`TaxAmount` = '1979' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696258' WHERE `Matrix_Unique_ID` = '210963785' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T10:09:56.643' ,`MLSNumber` = '20828518' ,`ListAgentFullName` = 'Cynthia Trahan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788470' ,`Longitude` = '-95.580051' ,`PhotoCount` = '37' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Oakmont Glen' ,`StreetNumber` = '1107' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FIRST FLOOR LIVING AT IT\'S FINEST! BEAUTIFUL DAVID WEEKLY HOME LOCATED IN A SMALL GATED COMMUNITY IN THE ENERGY CORRIDOR.HOME BACKS TO A LARGE PARK WITH BIG TREES AND LUSH LANDSCAPING. BEAUTIFUL WOOD FLOORING THROUGHOUT THE FIRST FLOOR. KITCHEN WITH SS APPLIANCES AND GRANITE COUNTERS IS OPEN TO THE FAMILY ROOM AND HAS A LARGE ISLAND, LOTS OF CABINETS AND COUNTERSPACE. DOWNSTAIRS ALSO FEATURES A STUDY/OFFICE THAT IS CURRENTLY BEING USED AS A DINING ROOM. ALL BEDROOMS ON THE 2ND FLOOR. 2ND FLOOR ALSO HAS A LOFT AREA FOR STUDY/LIBRARY OR DEN. 3RD FLOOR IS A VERY LARGE OPEN GAMEROOM/FLEX ROOM. EASY ACCESS TO I-10, CLOSE TO CITY CENTRE, TOWN & COUNTRY AND MEMORIAL CITY MALL.' ,`Acres` = '0.046' ,`Area` = '24' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 ENCLAVE AT SHERWOOD FOREST' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '2002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave/Sherwood Forest' ,`TaxAmount` = '7663' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696258' WHERE `Matrix_Unique_ID` = '210988575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:06:12.103' ,`MLSNumber` = '59466308' ,`ListAgentFullName` = 'Grecia Berrios' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990837' ,`Longitude` = '-95.444199' ,`PhotoCount` = '50' ,`PostalCode` = '77090' ,`RoomCount` = '5' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Reedpoint' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ON THE MARKET! BEAUTIFUL, looking for space? Look no further! Welcome home to this meticulously maintained 4 BEDROOM, 2 AND HALF BATH HOME READY FOR YOUR FAMILY TO ENJOY. Situated off I-45 and FM 1960, residents are close to shopping and dining in Cypresswood Court, Old Town Spring, and Cypress Station. The Woodlands and Market Street are only a short drive up the highway! Multiple nature parks and golf courses surround the area. Close to schools in Spring ISD. 1st floor primary bedroom with ensuite bath, formal dining, large kitchen with extensive breakfast area. The kitchen opens to casual living space. This home provides enough space for everyone with three secondary bedrooms on the 2nd floor, full bath, large media room, full size utility area and HUGE game room, it’s truly an entertainment’s dream.' ,`Acres` = '0.1969' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 4 EAGLE LANDING SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8575' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Lndg Sec 03' ,`TaxAmount` = '6466' ,`TaxRate` = '2.9767' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696258' WHERE `Matrix_Unique_ID` = '211183527' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T11:35:49.340' ,`MLSNumber` = '4732654' ,`ListAgentFullName` = 'Selena Choi' ,`ListOfficeName` = 'F1T Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385192' ,`Longitude` = '-94.917319' ,`PhotoCount` = '8' ,`PostalCode` = '77590' ,`RoomCount` = '3' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Wayside' ,`StreetNumber` = '1518' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom home is ready for your finishing touches! So much potential sitting on this 6,900 SF lot! Close proximity to the bay, parks, and golf courses. Don\'t miss out! Schedule your showing today! Buyer to verify all information.' ,`Acres` = '0.1584' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 3 LOT 6 BLK 6 WAYSIDE PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'KOHFELDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wayside Place 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696258' WHERE `Matrix_Unique_ID` = '211210615' --> Updated record success