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-17T20:03:38.067' ,`MLSNumber` = '74711380' ,`ListAgentFullName` = 'Jose Zavala' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518627' ,`Longitude` = '-95.309315' ,`PhotoCount` = '23' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Tran' ,`StreetNumber` = '6335' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We are offering this 4 bedroom 3 bath home with a 2 car attached garage in Pearland.  The property  also has a separate large 2 car detached garage that you can use as extra garage/shop or hobby area.  This garage space also has the potential to be converted into a small apartment.  This one story home was built in 1988 and overall is in pretty good condition.  This property is outside of the the City of Pearland city limits. However it does fall within the Pearland ISD.  The Pearland ISD is know for its great academics, sports and cultural excellence.  Another great feature of this property is that it has no restrictions and gives you the buyer more freedom to do more things with your property. One last feature of this property is that its on a a big lot 20,647 square feet.  Make your appointment to see this home before it is gone' ,`Acres` = '0.474' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0245 H T & B R R TRACT 19A7 (CALLED TR 8) 1/10 WATER WELL S' ,`LotDesciption` = 'Other' ,`LotSize` = '20647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '2594' ,`TaxRate` = '1.9537' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699955' WHERE `Matrix_Unique_ID` = '206207430'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T20:25:06.230' ,`MLSNumber` = '80829472' ,`ListAgentFullName` = 'Lelia Aguilar' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.804381' ,`Longitude` = '-98.386110' ,`PhotoCount` = '46' ,`PostalCode` = '78611' ,`RoomCount` = '9' ,`ListPrice` = '2888000.00' ,`Status` = 'Active' ,`StreetName` = 'PENINSULA DRIVE' ,`StreetNumber` = '214' ,`StreetSuffix` = '' ,`City` = 'Burnet' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***GATED COMMUNITY ON LAKE BUCHANAN ***4 BEDROOMS ***3.5 BATHS ***4 CAR GARAGE **MEDIA ROOM *Sweeping and breathtaking views of Lake Buchanan, every detail and design on the amazing property, this expansive 3.24 acres home is designed for those who adore the hill country and peaceful views. Foyer welcomes guests with spectacular views, abundant windows delivering natural light throughout gourmet kitchen opens to a large dining room and den, new kitchen appliances, granite countertops, new Anderson custom windows and doors (A series, argon filled) Primary suite on the main level, upstairs a gameroom, media room and secondary bedrooms. 800ft driveway from one street to the other one, 4 car garage with epoxy paint (prepared with stainless steel sink designed for fish cleaning and prep)water filter Pentair and Pelican, private marina with deeded dock slip.' ,`Acres` = '3.24' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S7081 PENINSULA ON LAKE BUCHANAN LOT 73' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '141134' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '184 - Burnet Consolidated' ,`SchoolElementary` = 'RJ RICHEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BURNET HIGH SCHOOL' ,`SchoolMiddle` = 'BURNET MIDDLE SCHOOL (BURNET)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peninsula On Lake Buchanan' ,`TaxAmount` = '13046' ,`TaxRate` = '1.5834' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699955' WHERE `Matrix_Unique_ID` = '209115927'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T21:07:34.867' ,`MLSNumber` = '92146726' ,`ListAgentFullName` = 'Velma Ellison' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.934070' ,`Longitude` = '-95.030559' ,`PhotoCount` = '46' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '2998500.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 90' ,`StreetNumber` = '6400' ,`StreetSuffix` = 'Highway' ,`City` = 'Crosby' ,`BathsFull` = '1' ,`BathsHalf` = '3' ,`BedsTotal` = '4' ,`SqFtTotal` = '7200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '7200 sq ft of 24 ft high ceiling Barndominium. 3200 sq ft can be used as housing, with the downstairs builtout. Full Bath upstairs. Fully fenced and cross fenced. Electric gate. 2-20x20 ft roll up doors in the shop. 3 phase power. Low tax rate. Concrete is 6 inches thick with 7000 psi concrete. 16 SEER heat pumps. 4 horse stables & 5 dog kennels. Additional exterior storage. Can be used as residential or commercial, or both. No deed restrictions. Harris County, unincorporated. Well & aerobic septic.' ,`Acres` = '4.24' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 12A ABST 864 F A WHITAKER' ,`LotDesciption` = 'Cleared' ,`LotSize` = '184695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'Rural' ,`TaxAmount` = '18792' ,`TaxRate` = '2.1501' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699955' WHERE `Matrix_Unique_ID` = '209530950'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T21:14:08.520' ,`MLSNumber` = '9714536' ,`ListAgentFullName` = 'Renee Wicks' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667970' ,`Longitude` = '-95.220725' ,`PhotoCount` = '6' ,`PostalCode` = '77587' ,`RoomCount` = '3' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Ammons' ,`StreetNumber` = '813' ,`StreetSuffix` = 'Street' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is just waiting for your touch. This is a great little starter home or Investment property. 3 bedrooms 2 bathrooms with a nice sized backyard. The kitchen is open with a step-up dining area. Garage has been converted into the master bedroom.  Home does need a little work. Call today for a quick tour!' ,`Acres` = '0.1263' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 3 MERILYN PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'L F SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'QUEENS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Merilyn Place' ,`TaxAmount` = '2751' ,`TaxRate` = '2.8255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699955' WHERE `Matrix_Unique_ID` = '211354461'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T20:31:19.527' ,`MLSNumber` = '31694450' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432048' ,`Longitude` = '-95.460540' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '392238.00' ,`Status` = 'Active' ,`StreetName` = 'Red Hills' ,`StreetNumber` = '1221' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample VIRTUAL TOUR! Beautiful Beckenham Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Game room, 3 Bedrooms, 2 with walk in closets, & another Full Bath. You will love the Kitchen with lots of cabinets & granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Covered Patio & Fenced Backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Amenities include Playground, Dog Park, Splash Pad and Olympic size pool, Hiking/Biking Trails and 4 ACRE Lagoon coming soon. Convenient to Downtown Houston, Medical Center, Pearland, & the Beach!' ,`Acres` = '0.1435' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 3 (A0329 LAV NAV CO) BLK 3 LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6251' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '1406' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699956' WHERE `Matrix_Unique_ID` = '211429839'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T21:21:23.577' ,`MLSNumber` = '65969901' ,`ListAgentFullName` = 'Justin Pittman' ,`ListOfficeName` = 'Keller Williams Realty         - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494057' ,`Longitude` = '-94.956117' ,`PhotoCount` = '27' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = '27th' ,`StreetNumber` = '735' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy relaxing on your front porch watching the sun set at this quiet 2 acre property that holds a beautifully updated 2 story house and a 1600sqft shop. There are no back neighbors here and it is next door to the elementary school. Refrigerator and wine cooler is included in the sale of the house. Features of the house include double paned windows, large bedrooms, granite counters, large frameless shower, soaker tub, wine cooler, soft close hinges on cabinets and many other upgrades. The only thing missing is you!' ,`Acres` = '2' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 PAGE 7 PT OF LOT 8 (8-1) BLK 23 SAN LEON FM HM TRS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'San Leon Farm Home Tracts' ,`TaxAmount` = '5995' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699956' WHERE `Matrix_Unique_ID` = '211528841'  --> Updated record success<br />