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-08-16T09:57:23.323' ,`MLSNumber` = '86408235' ,`ListAgentFullName` = 'Rosanna Hamilton' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477526' ,`Longitude` = '-95.352709' ,`PhotoCount` = '6' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Masters' ,`StreetNumber` = '6747' ,`StreetSuffix` = 'Road' ,`City` = 'Manvel' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1168' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful country land of 4.97 Acres to make your own! 2 bedroom/1 bath home with well and septic, 2 car detached and 1 car attached garage.  Zoned Mixed-use residential and commercial. APPROXIMATELY 120 FT OF FRONTAGE TO FM 1128 (MASTERS RD) Do not go on property without an agent or a required appointment. Buyer to verify all zoning and uses with the City of Manvel. Washer, dryer, garage & kitchen refrigerator included. 2021 new hot water heater. Property is being sold AS-IS.' ,`Acres` = '4.97' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'MANVEL LOT OL 201-4 ACRES 4.97' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '216493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Manvel' ,`TaxAmount` = '6024' ,`TaxRate` = '2.7874' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699367' WHERE `Matrix_Unique_ID` = '206371038'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T09:59:47.760' ,`MLSNumber` = '93810268' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801451' ,`Longitude` = '-95.112230' ,`PhotoCount` = '38' ,`PostalCode` = '77360' ,`RoomCount` = '5' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeview Wood' ,`StreetNumber` = '210' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1449' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PANORAMIC WATER VIEWS FROM EVERY ROOM! This breathtaking lake house situated on a double lot has it all! Recently upgraded, this 3-story 2 bed 2 bath home on Lake Livingston features a game room upon entrance of the second story with access to the large deck overlooking the lake. The kitchen boasts new granite countertops & tile flooring, a breakfast bar, pantry and opens up to the oversized family room. The bedrooms are generous in size and the master bedroom features an en-suite bath with a walk-in shower! Exterior features include dual boat lifts, a massive pier, covered patio, plenty of space for parking and outdoor gatherings! Recent upgrades include: New roof, AC unit, windows, wave runner, exterior paint, interior paint, steel bulkhead, granite and tile flooring, plumbing, and gutters! This home is priced to sell and won\'t last long! Schedule a private tour today!' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 4 BLK 4 LOT 24' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Impala Woods' ,`TaxAmount` = '5049' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699367' WHERE `Matrix_Unique_ID` = '208288038'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T09:40:24.893' ,`MLSNumber` = '28204614' ,`ListAgentFullName` = 'Priyan Jacob' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = 'Kristopher Saegers' ,`SellingOfficeName` = 'The Wolf Real Estate GroupSuite 106-59' ,`Latitude` = '29.352263' ,`Longitude` = '-95.460276' ,`PhotoCount` = '17' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '291990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brushwood' ,`StreetNumber` = '7727' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING D R HORTONS NEW CONSTRUCTION ASHBURN PLAN (ELEVATION N) FEATURING 3 BEDROOMS AND TWO FULL BATH READY FOR ITS NEW OWNER! WITH 42\" CABINETS,STAINLESS STEEL APPLIANCES,QUARTZ COUNTERTOPS AND INCLUDED REFRIGERATOR,THIS STUNNING KITCHEN HAS AN OPEN CONCEPT.HOME ALSO INCLUDES WASHER,DRYER, BLINDS AND GARAGE DOOR OPENERS.A LANDSCAPE PACKAGE ALONG WITH A FULL IRRIGATION IS OFFERED WITH THIS HOME.LOW UTILITY BILLS AS THIS HOME IS ENERGY RATED ALONG WITH TANKLESS WATER HEATER JUST TO NAME A FEW.AMENITY CENTRE FEATURES INCLUDE COMMUNITY POOL, WATER SLIDES, PLAYGROUND FOR KIDS,SOCCER FIELDS AND MUCH MORE.SCHEDULE YOUR PRIVATE TOUR TODAY AND LETS TALK!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D R HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'CALWELL RANCH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699368' WHERE `Matrix_Unique_ID` = '208778564'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T08:53:20.253' ,`MLSNumber` = '85837934' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409599' ,`Longitude` = '-95.050309' ,`PhotoCount` = '35' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '418642.00' ,`Status` = 'Active' ,`StreetName` = 'Table Rock' ,`StreetNumber` = '2405' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 85837934 - Built by HistoryMaker Homes - November completion! ~ Our Awesome Olive Plan, Don\'t miss out on our best selling one story with a large oversized cul-de-sac homesite.  Four bedrooms, three baths, with a guest suite.  You will love your utility bills with our standard spray foam insulation and tankless hot water heater.  Large covered back porch. Full home WiFi coverage makes working from home easier. 12 Acre Crystal Clear Lagoon, Clubhouse, Beach, Fitness Center, Splash Pad.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 BLK 1 POD 8 SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12055' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699368' WHERE `Matrix_Unique_ID` = '209418875'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T08:54:43.820' ,`MLSNumber` = '22093981' ,`ListAgentFullName` = 'Isaac Tijerina' ,`ListOfficeName` = 'Tijerina Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059978' ,`Longitude` = '-94.792821' ,`PhotoCount` = '20' ,`PostalCode` = '77575' ,`RoomCount` = '6' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = 'Centennial' ,`StreetNumber` = '2228' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedrooms, 2 bath home with garage apartment and detached 2 car garage located in established area. 2.5 bocks from Main St.' ,`Acres` = '0.1625' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PEARSON, LOT 7, ACRES .1625' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7079' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearson' ,`TaxAmount` = '3094' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699368' WHERE `Matrix_Unique_ID` = '210100146'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T09:06:15.317' ,`MLSNumber` = '69468596' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514504' ,`Longitude` = '-95.802464' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '394300.00' ,`Status` = 'Active' ,`StreetName` = 'Bartagrass' ,`StreetNumber` = '4712' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 69468596 - Built by HistoryMaker Homes - November completion! ~ 9\' Ceilings Throughout                                                                                                                                                     8\' Front Door Entry\r\nLuxury Vinyl Plank Flooring in Entry, Dining Room, \r\nKitchen, Nook & Family Room\r\n42 White Kitchen Cabinets with Crown Molding \r\nand Kitchen Island\r\nGranite Countertops with Ceramic Tile Backsplash\r\nStainless Steel Whirlpool Kitchen Appliances \r\nincluding Microwave\r\nEnergy Saving Insulation & Vinyl Windows\r\nMaster Suite with Garden Tub, Separate Shower \r\nwith Double Vanity & Second Sink\r\nFull Yard Sod with Full Irrigation with Rotary \r\nHeads\r\nCovered Patio' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35/ Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seabourne Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699368' WHERE `Matrix_Unique_ID` = '210302668'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T08:07:48.247' ,`MLSNumber` = '52307095' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511385' ,`Longitude` = '-95.729354' ,`PhotoCount` = '13' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Slate Port' ,`StreetNumber` = '5031' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!  Lennar Fairway Collection \"Cabot\" Plan with Elevation \"E\" in Walnut Creek!  The spacious single story Cabot floor plan by Lennar features a welcoming front porch and entry foyer that lead to a lovely study and a convenient powder bathroom. The open island kitchen features a generous walk-in pantry, and opens to the casual dining area and family room. The family room offers a beautiful view and access to a relaxing covered rear patio.  The large master bedroom is accessible from a secluded hallway located just off of the family room, and features an en suite master bathroom with dual sinks, a stand up shower with built-in seating, a private toilet enclosure, and access to the generous master closet.  All secondary bedrooms of the Cabot floor plan feature walk-in closets.  *HOME ESTIMATED TO BE COMPLETE, SEPTEMBER, 2022*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 001 LOT 007' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.002307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699368' WHERE `Matrix_Unique_ID` = '210948346'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T08:59:47.810' ,`MLSNumber` = '17139472' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090866' ,`Longitude` = '-94.114325' ,`PhotoCount` = '7' ,`PostalCode` = '77701' ,`RoomCount` = '6' ,`ListPrice` = '75000.00' ,`Status` = 'Active' ,`StreetName` = 'Long' ,`StreetNumber` = '1045' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING INVESTMENT OPPORTUNITY!!! PRICED TO SELL! WILL NOT LAST!!! 1,400 SQFT LIVING SQFT 7,988 SQ FT LOT SIZE!' ,`Acres` = '0.1834' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'JIROU L-11 & W 1/2 OF ALLEY B 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CALDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Jirou Add' ,`TaxAmount` = '951' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699368' WHERE `Matrix_Unique_ID` = '211462470'  --> Updated record success<br />