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-11T13:41:08.313' ,`MLSNumber` = '16306402' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874800' ,`Longitude` = '-95.723065' ,`PhotoCount` = '27' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Rusty Ridge' ,`StreetNumber` = '6822' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1026' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 HIGHLAND CREEK RANCH SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '4468' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '446' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Crk Ranch Sec 03' ,`TaxAmount` = '4209' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697118' WHERE `Matrix_Unique_ID` = '205026875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T13:29:24.307' ,`MLSNumber` = '71527372' ,`ListAgentFullName` = 'Cameron Namazi' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.109992' ,`Longitude` = '-95.259044' ,`PhotoCount` = '28' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1314' ,`StreetNumber` = '23337' ,`StreetSuffix` = 'Road' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2016' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '65,423 Sq. ft / 1.501900 acres LOT , commercial / residential use. Home previously flooded sold as-is. There is a recorded easement to the property.' ,`Acres` = '1.5019' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S846001 - ROUSE C H 01, LOT 34, ACRES 1.5019' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '65423' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rouse C H 01' ,`TaxAmount` = '4734' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697118' WHERE `Matrix_Unique_ID` = '205449663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T12:02:33.970' ,`MLSNumber` = '55880606' ,`ListAgentFullName` = 'Kelly Paul' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.418148' ,`Longitude` = '-95.004156' ,`PhotoCount` = '37' ,`PostalCode` = '77539' ,`RoomCount` = '1' ,`ListPrice` = '1389000.00' ,`Status` = 'Active' ,`StreetName` = 'Humble Camp Rd' ,`StreetNumber` = '8401' ,`StreetSuffix` = 'Road' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '1' ,`SqFtTotal` = '6000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Private multi-use property with a potential business opportunity location! Located just on the eastern edge of Dickinson where it meets Texas City but zoned Dickinson ISD. 19 + acres with Ag-expemtion, has a 60X100 metal building with stucco & stone exterior, with 50’ wide efficiency apartment. Two RV 50-amp hook ups, 4 five-ton commercial grade HVAC’s (not installed) with concrete pads on exterior. Originally building had spray foam insulation but seller recently added batt insulation throughout. Large auto doors both with Liftmaster commercial automatic openers and one side door. Most of the property is fenced with fully welded galvanized pipe, the long driveway has over 40,000 sq feet of concrete at 3500 psi/6” thick in center with beams on each side/double car width. This property would be a great option to consider if you are searching for a new business location with room to expand or a place to enjoy the slower pace of country life near Houston.' ,`Acres` = '19.13' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 180 J SELLERS SUR TRACT 36-6, 19.130 ACRES' ,`LotDesciption` = 'Cleared,Ravine' ,`LotSize` = '833303' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium,Other Style' ,`Subdivision` = 'John Sellers League Share A' ,`TaxAmount` = '3485' ,`TaxRate` = '2.5428' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697118' WHERE `Matrix_Unique_ID` = '206742088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T13:19:51.617' ,`MLSNumber` = '86808342' ,`ListAgentFullName` = 'Patricia Dajani' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732460' ,`Longitude` = '-95.408145' ,`PhotoCount` = '22' ,`PostalCode` = '77098' ,`RoomCount` = '12' ,`ListPrice` = '1849000.00' ,`Status` = 'Active' ,`StreetName` = 'Norfolk' ,`StreetNumber` = '1927' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Contemporary/Modern by Houston\'s Premier Home Builder, Croix Custom Homes! Construction is just starting and this is a fantastic opportunity to customize this cool Contemporary. Croix Homes is creating a home that offers crisp, clean moderns lines while still maintaining a feeling of warmth and comfort. The epitome of \r\nmodern luxury, this home has so much to offer. 11ft Ceilings Down, 10Ft Ceilings Up, Dramatic Two-Story Dining Area with Soaring Ceiling, Stunning staircase with Chic Railing, Wood Floors and More.. Open Floor Plan, great for entertaining with good flow and function. Wonderful natural light plus wall space for an art collector. First Floor Study/Library, Upstairs Media/Game Room and 4 Bedrooms! Elevator Capable, Covered Lanai, Outdoor Kitchen and Yard with room for a Pool! This is a Wonderful, Experienced Builder to work with, Offering 25+ Years in the Building Business with Great References! *Pool in the rendering not included with the price of home.*' ,`Acres` = '0.1435' ,`Area` = '16' ,`BuilderName` = 'Croix Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 5 RICHMOND PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Richmond Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697118' WHERE `Matrix_Unique_ID` = '207931816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T12:14:54.480' ,`MLSNumber` = '34901663' ,`ListAgentFullName` = 'Domenic Santilli' ,`ListOfficeName` = 'Capital Trust Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.485533' ,`Longitude` = '-95.508940' ,`PhotoCount` = '40' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Monarch' ,`StreetNumber` = '2827' ,`StreetSuffix` = 'Crossing' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Sienna Plantation on a very private street. No neighbors across the street or behind the house. Two story entry, formal dining, engineered wood floors, great room with lots of windows looking into the back yard, nice kitchen with breakfast area and eat in island. Two bedrooms down plus two full bathrooms down, the master suite and one mother in law bedroom. Upstairs features 3 additional bedrooms, 2 more full bathrooms and a nice sized game room. Spacious back yard with covered patio. Home DO NOT flood. Fully fenced yard, no back neighbors. Zoned to Fort Bend schools. Sienna amenities include water parks, pools, recreation centers, gym. Golf Club, walking trails.' ,`Acres` = '0.1794' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA PLANTATION SEC 20, BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7814' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Plantation Sec 20' ,`TaxAmount` = '12345' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697118' WHERE `Matrix_Unique_ID` = '208264361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T13:22:23.523' ,`MLSNumber` = '84578918' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.390113' ,`Longitude` = '-95.625844' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Grove Lane' ,`StreetNumber` = '12955' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1449' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home ready for move in July 2022. Oversized patio that is over 300 sq. ft.! Included is sprinkler system, full grass and landscaping, fenced, garage door opener, stainless appliances, ceiling fans, and window blinds. Ceramic tile flooring thru the whole house except for bedrooms. Granite counter tops in kitchen, 2 sinks master bath, garden tub and seperate walk in shower. Located in a nice quiet part of the subdivision on a cul-de-sac street.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'lot 36 block 02 section 16' ,`LotDesciption` = 'In Golf Course Community,Patio Lot,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden on Lake Conroe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697118' WHERE `Matrix_Unique_ID` = '208426280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T12:18:41.903' ,`MLSNumber` = '17875961' ,`ListAgentFullName` = 'Susan Brock' ,`ListOfficeName` = 'Brock & Foster Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.652566' ,`Longitude` = '-95.493470' ,`PhotoCount` = '31' ,`PostalCode` = '77035' ,`RoomCount` = '9' ,`ListPrice` = '398500.00' ,`Status` = 'Active' ,`StreetName` = 'Dunlap' ,`StreetNumber` = '11606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why rent when you can own! Entertain and live comfortably in this dream home on 10,000+ sf lot with gated drive, backyard can fit pool! Owners spared no expense on high end finishes! Phenomenal kitchen with custom cabs, Italian Marble counters, Samsung appls + wine fridge. Enjoy summer meals at breakfast bar w/views of picturesque lawn which is great for parties. Den w/vaulted ceiling & brick FP. Giant media rm ideal for movie nights or gamerm. Primary bedrm w/ oversized walk-in closet & room for huge dresser, dual sinks and spa-like shower. Features: great storage, plank tile flooring, solid wood doors, recent paint, HVAC, ducts, tankless wtr htr, elec panel, epoxied sewer lines, foundation repaired w/ lifetime warranty. Smart Home features, sprinkler sys, driveway gate & covered carport/patio. Low tax rate! Excellent location near Med Center, Downtown & Galleria. Walk through the 3D Matterport tour now!' ,`Acres` = '0.2465' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 86 PARKWEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10736' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwest' ,`TaxAmount` = '5048' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697119' WHERE `Matrix_Unique_ID` = '209449662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T13:02:02.597' ,`MLSNumber` = '11611265' ,`ListAgentFullName` = 'Rogelio Olivetti' ,`ListOfficeName` = 'Texas Real Estate & Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773859' ,`Longitude` = '-95.377172' ,`PhotoCount` = '31' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Silver' ,`StreetNumber` = '1807' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4-story house with street facing driveway, no HOA and a spectacular view of downtown from rooftop balcony. Beautiful oak tree provides privacy and relaxing views but still gets plenty of natural light. Beautiful modern touches and eye-catching brick wall in the living. Very open concept with amazing wood flooring throughout the home. The kitchen boasts high-end finishes along with a stainless-steel appliance. The kitchen island is ideally located and perfect in size for entertaining or family gatherings. Spacious primary bedroom retreat with a walk-in closet and a lux en-suite complete with double sinks, soaker tub and large walk-in shower. Two secondary bedrooms complete with en-suite baths conveniently located on the first and third floors. You will love living so close to the restaurants, entertainment and art scene in the nearby Sayer Yards district.' ,`Acres` = '0.0345' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 CROCKETT CITY VIEWS' ,`LotDesciption` = 'Other' ,`LotSize` = '1502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Crockett City Views' ,`TaxAmount` = '9841' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697119' WHERE `Matrix_Unique_ID` = '210214107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T12:23:24.723' ,`MLSNumber` = '56661458' ,`ListAgentFullName` = 'LaNell Shaw' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800561' ,`Longitude` = '-95.066314' ,`PhotoCount` = '39' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Goldenrod' ,`StreetNumber` = '370' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2192' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no Further for that Hard to Find 5 Bedroom Home with 3 Full Baths PLUS a Flex/Bonus Room!! This ideal property is approx 2200 sq ft and located in the Waterfront Resort Community of Cedar Point. Open Concept Living/Kitchen with sizeable Breakfast/Dining Area, large enough for huge table setting - the Flex/Bonus Room would be great for a separate Formal Dining...if not an Office. Owner\'s Suite is massive and offers Bath w/Walk-In Closet. Main Floor does have a Bedroom and Full Hallway Bath for Guests with Utility Room. The New Back Deck is huge and superb area for Grilling or Outdoor Kitchen suggestion. Cedar Point is a Gated Community and offers a Community Center, Pool, Playground Areas and Boatlaunches for Lake Access to Homeowners.' ,`Acres` = '0.1148' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 2 BLK 38 LOT 14' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '516' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point Sec 2' ,`TaxAmount` = '3592' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697119' WHERE `Matrix_Unique_ID` = '210546752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T12:03:27.147' ,`MLSNumber` = '30918155' ,`ListAgentFullName` = 'LaNell Shaw' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.671573' ,`Longitude` = '-94.943601' ,`PhotoCount` = '49' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'E Lake Dr' ,`StreetNumber` = '746' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately Waterview Home in the Select Subdivision of Lakeside Village. Towering 3-4 Bedroom/2.5 Bath Custom Home sits on a Hill w/Half Acre Overlooking the 45 Acre Private Lake. Open Concept Living/Kitchen w/Breakfast Room and separate Formal Dining Room. Bonus/Flex Room great for Office or 4th Bedroom. Recent Improvements 2021/2022 - 2 New A/C Units and Thermostats, New Front Door, Interior Paint, Light Fixtures, Stainless Appliances, Porcelain Tile Flooring, Staircase Treads, Removable Storage Booth Benches in Dining, Pro Heavy Metal Party Patio Covers with Concrete Slabs, Upper Slab w/Walkway, Dusk to Dawn Solar Lights, Gutters Leaf Filters. Custom Amenities - Crown Molding, Wood Burning Fireplace, Vaulted Ceiling in Owner\'s Suite, Utility Room in House. 2 Car Attached Garage. Brick and Hardi - Low Maintenance. Ideal Location 5 Minutes to Town. Perfect Location for Commute consideration. Great Neighbors! Enjoy the Lake w/Community Park, Fishing Piers, Kayak, Paddleboat, Fishing Boats' ,`Acres` = '0.5022' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESIDE VILLAGE BLK 15 LOT 5 SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '21875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Village' ,`TaxAmount` = '3192' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697119' WHERE `Matrix_Unique_ID` = '210547334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T13:03:30.220' ,`MLSNumber` = '2844679' ,`ListAgentFullName` = 'Jeanie Belcher' ,`ListOfficeName` = 'Integrity Real Estate Brkg LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.499867' ,`Longitude` = '-95.467657' ,`PhotoCount` = '27' ,`PostalCode` = '75844' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Finway' ,`StreetNumber` = '720' ,`StreetSuffix` = 'Drive' ,`City` = 'Grapeland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ranch style brick home for sale on private pond in East Texas. Well-maintained 3/3 home situated on two sprawling lots has access to a private lake where you can enjoy fishing and swimming with your family. Enjoy the breeze off the water on the covered back patio overlooking the pond and shady back yard. This home invites simple living with an eat in kitchen and stainless-steel appliances, a separate formal dining room, and a living room with fireplace, plantation shutters, and vaulted ceiling. The main suite has a dressing area, walk in closet, and on-suite bathroom. The large two car garage has tons of storage, work bench space, utility area and sink, plus a bonus bathroom. There are two storage buildings on the property and mature trees.' ,`Acres` = '1.329' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GRAPELAND EAST LOTS 9 & 10 1.329 AC' ,`LotDesciption` = 'Water View' ,`LotSize` = '57891' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '58 - Grapeland' ,`SchoolElementary` = 'GRAPELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAPELAND HIGH SCHOOL' ,`SchoolMiddle` = 'GRAPELAND JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Grapeland East Add' ,`TaxAmount` = '2741' ,`TaxRate` = '2.1104' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697119' WHERE `Matrix_Unique_ID` = '210629191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T13:54:04.593' ,`MLSNumber` = '79351553' ,`ListAgentFullName` = 'Robert M. Bragg' ,`ListOfficeName` = 'Bayou, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.487313' ,`Longitude` = '-94.918533' ,`PhotoCount` = '12' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pictures may look like a mobile, but this is a cute house! 1 Bedroom 1 Bathroom home features an island kitchen with tons of cabinet space and breakfast bar that is open to the large living area. Nice sized bedroom. Washer and dryer connections are inside the home. Affordable home near the bay.' ,`Acres` = '0.1469' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOTS 29 & 30 BLK 109 SAN LEON 50 X 128 FT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '1826' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697119' WHERE `Matrix_Unique_ID` = '210944678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T13:02:43.357' ,`MLSNumber` = '38371391' ,`ListAgentFullName` = 'Chris Pulse' ,`ListOfficeName` = 'Realty Preferred Clear LakeSte #180-111' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798920' ,`Longitude` = '-95.414968' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = '15th 1/2' ,`StreetNumber` = '917' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss the opportunity to own this charming house in the desirable Heights area. Amazing location on a quiet dead end street. House can be updated to your tastes or used as an investment property. Contact listing agent or your Realtor today to schedule your private tour!' ,`Acres` = '0.1931' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 11A BLK 1 SHADY ACRES ANNEX' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Acres Annex' ,`TaxAmount` = '9380' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697119' WHERE `Matrix_Unique_ID` = '211057847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T12:03:43.527' ,`MLSNumber` = '60383500' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118720' ,`Longitude` = '-95.384439' ,`PhotoCount` = '28' ,`PostalCode` = '77386' ,`RoomCount` = '5' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Fuller Bluff' ,`StreetNumber` = '3507' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1631' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1014' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688206 - LEGENDS RUN 06, BLOCK 1, LOT 18' ,`LotDesciption` = 'Other' ,`LotSize` = '4417' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Legends Run 06' ,`TaxAmount` = '4467' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697120' WHERE `Matrix_Unique_ID` = '211209901' --> Updated record success