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-23T19:48:17.447' ,`MLSNumber` = '5076635' ,`ListAgentFullName` = 'Alexander DiSaggio' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000611' ,`Longitude` = '-95.141254' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Camp Lillie' ,`StreetNumber` = '327' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedroom 3 Bathrooms with Family room, Livingroom, Dining room, Kitchen, Breakfast room, Laundry room, Large closets. Brand new Appliances included in the house. Great view of Lake Houston. Lot size is 27,132 Square feet, the seller combined the lots and re-listed at the price including the larger lot size. Built up is 3100 square feet. The house was originally built in 1963, and completely renovated in 2020.' ,`Acres` = '0.6228' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2G ABST 26 D HARRIS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '27132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'David Harris Surv Abs #26' ,`TaxAmount` = '1822' ,`TaxRate` = '2.7108' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702198' WHERE `Matrix_Unique_ID` = '187134242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T19:18:40.717' ,`MLSNumber` = '18866826' ,`ListAgentFullName` = 'Crystal Herman' ,`ListOfficeName` = 'Southern Style Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461438' ,`Longitude` = '-94.793722' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2146' ,`StreetNumber` = '208' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, quite country setting with an adorable home that has much potential! Original home built in 86\' is set atop stilts to enjoy the wooded views and includes the primary bedroom (laundry on this level), large living area with woodburning fireplace and cute, and sunny kitchen! Second bedroom on ground floor with stand-up shower was added in the 90\'s. The additional small mobile home includes one bedroom with stand-up handicap accessible shower, with living/kitchen combo. Mobile home will convey with property (WILL NOT BE MOVED) A beautifully constructed covered porch and ramp make this space easy to navigate. *All appliances will stay.* Bring your pets, family and friends to enjoy the country life!' ,`Acres` = '0.855' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric,Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'BAR-D-RANCHETTS, LOT 25-A, ACRES .855' ,`LotDesciption` = 'Cleared' ,`LotSize` = '37244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bar-D-Ranchetts' ,`TaxAmount` = '1190' ,`TaxRate` = '1.7656' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702198' WHERE `Matrix_Unique_ID` = '206035841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T18:26:54.987' ,`MLSNumber` = '943975' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361642' ,`Longitude` = '-95.390869' ,`PhotoCount` = '19' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '366817.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Hills' ,`StreetNumber` = '12259' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIME LOCATION in DEER TRAIL ESTATES! Only minutes to I-45, Lake Conroe, and the new upcoming Sam Houston shopping center, and all THE WOODLANDS has to offer. ZONED to the highly sought after Conroe ISD. New 3 Beds, 2 baths w/ STUDY on just over a 1/3 ACRE LOT. GOURMET island kitchen featuring 36\" cabinets, GRANITE, & stainless steel gas appliances, SPACIOUS primary retreat w/ dual sinks, separate shower, and relaxing garden tub. WOOD vinyl plank flooring in all the main living areas, sprinkler system, COVERED patio, & MUCH MORE! Plenty of backyard space for a future pool or just relaxing the weekends away. Community features a super low 2% TAX RATE and LOW HOA dues. Make the move today...the decision is easy.' ,`Acres` = '0.3444' ,`Area` = '19' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Section 03, BLOCK 02 LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702198' WHERE `Matrix_Unique_ID` = '206251714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T19:27:19.000' ,`MLSNumber` = '86236159' ,`ListAgentFullName` = 'Marisol Diaz' ,`ListOfficeName` = 'Greg Flaniken & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.035682' ,`Longitude` = '-95.622628' ,`PhotoCount` = '39' ,`PostalCode` = '77422' ,`RoomCount` = '7' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 945C' ,`StreetNumber` = '3273' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors come and make this project yours! This 2277 sf home is full of potential and located on a beautiful 1.153 acre corner lot near the San Bernard River. Open floor plan in this spacious home and ready for someone to make her beautiful again! Great country living but yet still close to town. Home also has a pond with decking that needs some TLC. Large metal workshop great for storing or vehicle parking. Call and schedule your appointment today!' ,`Acres` = '1.153' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0138 S M WILLIAMS, TRACT 7B39 (LOT 36) UNRECD SHADY ACRES (' ,`LotDesciption` = 'Corner' ,`LotSize` = '50225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'S M Williams' ,`TaxAmount` = '4934' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702198' WHERE `Matrix_Unique_ID` = '207036043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T18:41:30.870' ,`MLSNumber` = '55983932' ,`ListAgentFullName` = 'Mike Canary' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.454909' ,`Longitude` = '-95.295825' ,`PhotoCount` = '50' ,`PostalCode` = '77511' ,`RoomCount` = '13' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 949b' ,`StreetNumber` = '3755' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opportunity is Knocking! Business Owners, Car Collectors, Hobbyist or Investors check out this beautiful custom home w/Professional Grade 60X80 Metal building located on unrestricted 3 acres near Alvin & Manvel. The 22 car+ shop has kitchen, bathroom & could be built out into a rental property or Barndominium. The home w/31\'x12\' covered porch w/Limestone arched entry w/beautiful double doors. Inside has vaulted ceilings w/double sided fireplace in family room flanked by study, dining room & kitchen. The island kitchen has vaulted ceiling, custom cabinets & granite counters. There are 2 guest bedroom & baths, one down & one upstairs. Owners Retreat downstairs has fireplace, walk-in closet, bathroom w/big walk-in shower, jetted tub & his & her vanities. Upstairs also has a big game room. This could easily be converted to a private suite. A 2 car garage & 2 car carport are attached to home. A covered 39x12 rear porch w/2 fireplace & bar adjoins a pavilion in this pool sized yard. NO HOA.' ,`Acres` = '3.09' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Heat Pump,Propane,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'REGENCY HEIGHTS SEC 1 (A0230 H T & B R R), LOT 17-18-18A, AC' ,`LotDesciption` = 'Ravine,Subdivision Lot,Wooded' ,`LotSize` = '134600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '22' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Georgian,Ranch,Traditional' ,`Subdivision` = 'Regency Heights' ,`TaxAmount` = '8205' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702198' WHERE `Matrix_Unique_ID` = '208830062' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T19:34:16.430' ,`MLSNumber` = '3070570' ,`ListAgentFullName` = 'Angela Knee' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.224334' ,`Longitude` = '-95.765534' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Brenda' ,`StreetNumber` = '41517 (2)' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity for a multi-generational family! Two homes nestled beneath towering trees on 1.07 +/- with room to grow. Adjacent 1.85 +/- acres is for sale next to this tract available for $185,000. (ML# 40012739) The two properties currently share a concrete driveway. Buyer may opt to put in a separate driveway in the future at buyers expense. New aerobic septic installed 2019. Great opportunity for rental investment property - or live in one, rent out the other. Plenty of room for a garden, chickens, pets or FFH/4H project. Light restrictions recorded, but no HOA.' ,`Acres` = '1.077' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S927300 - TOBY SMITH HIGH CHAPARRAL, LOT 13-D, SERIAL # TXCT' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '46914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Toby Smith High Chaparral' ,`TaxAmount` = '1322' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702198' WHERE `Matrix_Unique_ID` = '209878658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T18:34:46.437' ,`MLSNumber` = '88530849' ,`ListAgentFullName` = 'Josh Rodriguez' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.603593' ,`Longitude` = '-95.749896' ,`PhotoCount` = '42' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Drs' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2703 DRS Drive! Belle Ranch encompasses approximately 18 acres located directly on the historical and stunning \"bend\" of the Brazos River in desirable Ft. Bend County. Located at the end of elite DRS Drive, Belle Ranch has by far the largest acreage of any estate on the street. A custom built 2,800 sq. ft. main house is carefully situated to take advantage of the sun to maximize energy efficiency to stay cool in the summer and warm in the sinter. Boasting a huge kitchen with French cabinets and granite, this house is sure to please the most discerning chef. There is also a guest house of 1,160 sq. ft., tastefully finished with custom cabinets and granite in the kitchen. The property included stables with tack shed and various outbuildings with electrical power. There is a private stocked pond. There is also a large orchard with producing fruit and pecan trees. All appliances stay, as well as other amenities, including a 48HP tractor, garden tiller, and more. C\'mon over!' ,`Acres` = '17.9953' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '0042 R JONES, TRACT 1 (PT), ACRES 17.9953, U/R BASSETT S/D' ,`LotDesciption` = 'Cul-De-Sac,Other' ,`LotSize` = '783875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'R Jones' ,`TaxAmount` = '10508' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702198' WHERE `Matrix_Unique_ID` = '209891424' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T19:54:51.460' ,`MLSNumber` = '78659048' ,`ListAgentFullName` = 'Adrian Anguiano' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956006' ,`Longitude` = '-94.977409' ,`PhotoCount` = '40' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 48761' ,`StreetNumber` = '449' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional remodeled home at the end of a quiet cul-de-sac. Drive up into this beautiful porte-cochère with stamped concrete and stained ceilings. Front of the house offers plenty of charm with a hand laid brick porch, wrought iron railing and French doors. Upon entry, past this inviting foyer sits your magnificent kitchen with granite countertops, stainless steel appliances and a lovely full brick backsplash. The dining rooms immense windows let you gaze into your enormous backyard and offer an abundance of natural lighting. Spacious family room comes with a wood burning fireplace, gorgeous stone and a live edge mantle. Split floor plan features a primary bedroom with solid wood doors, walk in closet and large bathroom with double sinks. Secondary bedroom offers en suite bathroom with fantastic tile finishes. Backyard has plenty of space and two covered patios to host BBQ’s with family and friends. Conveniently located minutes from Highway 90 and the new Grand Parkway SH-99.' ,`Acres` = '1.1389' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE LAND, BLOCK 1, LOT 17, ACRES 1.1389, MH LABEL# TEX05093' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '49610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Land' ,`TaxAmount` = '2527' ,`TaxRate` = '1.9062' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702199' WHERE `Matrix_Unique_ID` = '210017888' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T18:59:33.180' ,`MLSNumber` = '56600593' ,`ListAgentFullName` = 'Derek Montes' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.391197' ,`Longitude` = '-94.899186' ,`PhotoCount` = '24' ,`PostalCode` = '77590' ,`RoomCount` = '2' ,`ListPrice` = '119900.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '805' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated with new updates: kitchen, bath, HVAC, plumbing, electric, range, dishwasher, flooring, sheetrock, paint, fixtures, water heater, windows, doors, and more. This home has been brought back to life and it is perfect for a starter home or for a rental property. Close to all local amenities including the refineries. Come check this one out, IT WILL NOT LAST LONG!' ,`Acres` = '0.0631' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 LOT 3 BLK 127 TEXAS CITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '2149' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702199' WHERE `Matrix_Unique_ID` = '211453878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T18:47:53.183' ,`MLSNumber` = '44821940' ,`ListAgentFullName` = 'Kimberly Thorpe' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = 'Cynthia Trevino' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.776164' ,`Longitude` = '-94.989921' ,`PhotoCount` = '27' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Country Club Cove' ,`StreetNumber` = '1927' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate 4-3 1/2-2 with a swim/play spa/pool. Updates include carpet replaced 2022, Inside and outside paint 2022, This is home features 4 bedrooms, 3 full baths and 1/2 bath, formal dining, and den. The kitchen has an island with tile flooring. The back yard is nice sized with 2 patio areas and a Gunite swim/spa with water feature. The swim spa has a place for a shade cover. It has a detached garage. Located on a corner lot.' ,`Acres` = '0.169' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 COUNTRY CLUB COVE SEC 1 AMEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Cove Sec 01 Amd' ,`TaxAmount` = '7121' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702199' WHERE `Matrix_Unique_ID` = '211468615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T19:18:17.707' ,`MLSNumber` = '59110850' ,`ListAgentFullName` = 'Luis Ramirez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427580' ,`Longitude` = '-95.256826' ,`PhotoCount` = '50' ,`PostalCode` = '77511' ,`RoomCount` = '3' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '519' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic curb appeal home w/lush green landscape, shade trees, & new interior. Trending palette, impressive wood look tile floors t/o, baseboards, recessed lighting, & window blinds. This open floor plan offers a new stunning eat-in kitchen w/white upper cabinets, gray lower cabinets, stylish hardware, SS appliances, & quartz counters. Perfect for entertaining. 3 Generous size bedrooms, ample closets, & 2 new pristine baths. The primary bedrooms has it\'s own en suite. Plenty of natural light & ceiling fans w/lighting. Incredible fenced backyard boasts lush green grass, large deck, & a storage shed. Room for a pool or toys! Convenient location to Shopping. Take a tour today & stop renting! Will not disappoint!' ,`Acres` = '0.1435' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'EASTON (ALVIN), BLOCK 15, LOT 1-2 (N/2)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6251' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MELBA PASSMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Easton Alvin' ,`TaxAmount` = '2357' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702199' WHERE `Matrix_Unique_ID` = '211475982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T18:32:55.850' ,`MLSNumber` = '31507427' ,`ListAgentFullName` = 'Hai Huynh' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820827' ,`Longitude` = '-94.980956' ,`PhotoCount` = '32' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Taro' ,`StreetNumber` = '8410' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2073' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful renovated home with 4 bedrooms, 2 bathrooms and 1-story with 3 sides brick located in highly desirable neighborhood of Springfield Estates. This Baytown home has Easy access to I-10 and Highway 330. This open concept floor plan is perfect for your family gathering. Spacious primary bedroom and primary bathroom with double sink, garden tub and standing shower. New Luxury vinyl throughout and Fresh paint. Schedule your showing today!' ,`Acres` = '0.155' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 65 SPRINGFIELD ESTATES SEC 1 AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6753' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Estates Sec 01 Amd' ,`TaxAmount` = '6126' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702199' WHERE `Matrix_Unique_ID` = '211743595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T19:46:05.897' ,`MLSNumber` = '61176290' ,`ListAgentFullName` = 'Angela Zapata' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705076' ,`Longitude` = '-95.319652' ,`PhotoCount` = '18' ,`PostalCode` = '77023' ,`RoomCount` = '4' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Slumber' ,`StreetNumber` = '3527' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely CUSTOM REMODELED home in Gulfgate/ university area . This house is immaculate and someone\'s dream home with no detail overlooked! everything is new!! LED lighting, new cabinets and quartz counter tops, new HVAC, electrical system and plumbing, big backyard. This is the ultimate home investment for whoever is lucky enough to own this house, it will not last long!' ,`Acres` = '0.154' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 13 PINE VALLEY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROOKLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Valley' ,`TaxAmount` = '1706' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702199' WHERE `Matrix_Unique_ID` = '211745510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-23T19:17:35.900' ,`MLSNumber` = '24399074' ,`ListAgentFullName` = 'Ravyn Neubauer' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.686852' ,`Longitude` = '-96.452737' ,`PhotoCount` = '18' ,`PostalCode` = '77979' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 309' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Corner' ,`City` = 'Port Lavaca' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy your coastal oasis completed with everything you need to enjoy hunting and fishing on the bay! After a day on the water, park your boat in the barn, clean your catch at your very own station, and enjoy some great company on the back patio equipped with a dry bar! This gorgeous 2b/2b home can accommodate all your guest with plenty parking, huge newly fenced in yard and a wraparound deck for enjoying the breeze. Brand new central air and heat installed last year and the roof is only 5 years old! Perfect weekend getaway or home sweet home, this property will not disappoint. Located on a corner lot 20 minutes from Port Lavaca (15 minutes from Formosa Plastics Corp.), 24 minutes from Palacios, and 4 minutes from the nearest public boat ramp!' ,`Acres` = '0.603' ,`Area` = '65' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COASTAL ACRES, BLOCK 2, LOT 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '26267' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '169 - Calhoun County' ,`SchoolElementary` = 'HARRISON/JEFFERSON/MADISON eLEMENTARY SCHOOL' ,`SchoolHigh` = 'CALHOUN HIGH SCHOOL' ,`SchoolMiddle` = 'TRAVIS MIDDLE SCHOOL (CALHOUN COUNTY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Coastal Acres' ,`TaxAmount` = '1039' ,`TaxRate` = '1.7153' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702199' WHERE `Matrix_Unique_ID` = '211747280' --> Updated record success