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-12T12:32:51.793' ,`MLSNumber` = '49748560' ,`ListAgentFullName` = 'Zachary Miller' ,`ListOfficeName` = 'Allure RE Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.172276' ,`Longitude` = '-95.175569' ,`PhotoCount` = '44' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Roman Forest' ,`StreetNumber` = '1710' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Roman Forest' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '2633' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unrestricted building with an excellent location across the street from the City Park, Pool, Splash-pad, Pavilion, and Walking Path. Very high traffic count. Great for a live/work, multi-tenant, or single tenant. 6 private rooms, large front entry, 3 half baths, 1 full bath with washer/dryer. Full kitchen plus a kitchenette. Full RV hookups with 50 amp. Outdoor shower. Great, large backyard. This is a great location for ANY business or dream! One exit away from 99 Grand Parkway/ Valley Ranch Town Center to the South. One exit away from Hwy 242/ Grand Texas Theme Park & Gator Bayou to the North. NO HOA! View the 3D Tour!' ,`Acres` = '0.729' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 01 BK 5 R-6-A, Blk 5 .729' ,`LotDesciption` = 'Wooded' ,`LotSize` = '31755' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Roman Forest 01' ,`TaxAmount` = '2936' ,`TaxRate` = '3.1696' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697583' WHERE `Matrix_Unique_ID` = '205318161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:49:31.037' ,`MLSNumber` = '94927967' ,`ListAgentFullName` = 'Peggy Renee Ferrell-Sharp' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663932' ,`Longitude` = '-95.361552' ,`PhotoCount` = '12' ,`PostalCode` = '77051' ,`RoomCount` = '7' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Alvin' ,`StreetNumber` = '4410' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home will not last. Recently renovated this home is an Investor\'s dream or a lucky family\'s great start. Plenty of space. There is a room with space next to the Primary Bedroom to place a second bathroom! Original great Hardwood floors through out. \r\nThere is lots of light and a large backyard, fenced in for the kids. The carport is adjacent to the home and houses the utility room. There is a large storage unit which is part of the property. This is a quiet community with two recently built luxury homes next door. Property home values are escalating in this area. This is a must see!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 15 Block 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Medical Center South' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697584' WHERE `Matrix_Unique_ID` = '207851781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:54:57.207' ,`MLSNumber` = '8231361' ,`ListAgentFullName` = 'Carol Gerault' ,`ListOfficeName` = 'Century 21 Olympian LakeJackson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.027447' ,`Longitude` = '-95.405439' ,`PhotoCount` = '50' ,`PostalCode` = '77531' ,`RoomCount` = '10' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Cannon' ,`StreetNumber` = '144' ,`StreetSuffix` = 'Street' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Front Room ( Entry) can be a Formal Living Room, Dining Room or Office/Study. The large Family Room can be\r\nthe dining area combo & entertainment area. The Kitchen is open to the Family Room for convenient serving.\r\nThere is a Breakfast area for those quick morning breakfasts. The bedrooms are all large and the inside Utility Room is close to the attached Sunroom in the back. The Guest Bath has a large walk-in Shower and a large\r\nMirrored Vanity area. All this on a beautiful landscaped lot.' ,`Acres` = '0.3712' ,`Area` = '5' ,`BuilderName` = 'Cut Rate - Macon' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'EMERALD FOREST (A0066 J E GROCE)(CLUTE) BLK 2 LOT 2-3 **LIFE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'OGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Emerald Forest' ,`TaxAmount` = '5651' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697584' WHERE `Matrix_Unique_ID` = '208939124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:19:39.897' ,`MLSNumber` = '45415410' ,`ListAgentFullName` = 'Craig Carver' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468715' ,`Longitude` = '-95.330065' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '15' ,`ListPrice` = '1295000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Ridge' ,`StreetNumber` = '9003' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3948' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stately masterpiece that does not come along very often. A true CUSTOM home on over 9+/- acres with a six plus attached & detached garage, pool & hot tub ~ WOW! Two story entry with custom library featuring extensive built ins, welcoming formal dining off kitchen, spacious island kitchen with solid surface counter tops & stainless steel appliances, dogie/sun room option with easy gated access outside, large two story family room, tile and wood flooring throughout along with fresh carpet, gracious primary suite down, updated primary bath w/jetted tub, separate walk in shower & a bidet, two powder rooms (one right off the pool area), game room / bedroom option up, large secondary bedrooms, huge walk out covered veranda up, spray in foam insulation, central vacuum option, excellent curb appeal, huge back yard patio, grand pool and hot tub, three car covered parking, close to Hwy 288 & a true country setting makes this property a must see.' ,`Acres` = '9.1875' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Propane,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'QUAIL VALLEY RANCHES SEC 2 (A0366 T SPRAGGINS) LOT 23A (REPL' ,`LotDesciption` = 'Wooded' ,`LotSize` = '400210' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Valley Ranches' ,`TaxAmount` = '13016' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697584' WHERE `Matrix_Unique_ID` = '209878432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T12:25:34.227' ,`MLSNumber` = '23786399' ,`ListAgentFullName` = 'Lindsey Sturrock' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144307' ,`Longitude` = '-94.328701' ,`PhotoCount` = '15' ,`PostalCode` = '77659' ,`RoomCount` = '5' ,`ListPrice` = '421000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekside' ,`StreetNumber` = '320' ,`StreetSuffix` = 'Loop' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 320 Creekside Loop, located in Country Wood Estates. \r\nThis home is settled on 1.089 acres and accompanies 4beds 2.5. baths. \r\nSitting room that can be used as a study, and a garage apartment. \r\nThe first floor has been fully renovated and has an upgraded kitchen.' ,`Acres` = '1.09' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLK 8 COUNTRY WOOD ESTATES PHASE II P# CE2-8-1 I# 2019' ,`LotDesciption` = 'Corner' ,`LotSize` = '47480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Wood Estates Ph 02' ,`TaxAmount` = '5204' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697584' WHERE `Matrix_Unique_ID` = '210781694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:01:21.783' ,`MLSNumber` = '7282663' ,`ListAgentFullName` = 'San Juanita Mena' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.445208' ,`Longitude` = '-95.103284' ,`PhotoCount` = '20' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '258900.00' ,`Status` = 'Active' ,`StreetName` = 'River Ridge' ,`StreetNumber` = '6750' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1557' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1497' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY POINTE WEST SEC 2 (2005) ABST 19, BLOCK 1, LOT 46' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6519' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Bay Colony Pointe West Sec 2' ,`TaxAmount` = '7126' ,`TaxRate` = '3.4497' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697584' WHERE `Matrix_Unique_ID` = '210894353' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T12:24:34.480' ,`MLSNumber` = '44031046' ,`ListAgentFullName` = 'Kenya Fanus' ,`ListOfficeName` = 'Elite 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783658' ,`Longitude` = '-95.041687' ,`PhotoCount` = '14' ,`PostalCode` = '77520' ,`RoomCount` = '8' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestway' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your home awaits your personal touches to make it complete! This beautiful 4/5 bedroom and 3/1 baths home has it all within its 3,515sq ft. Natural light pours into the open concept living area creating a very bright & enjoyable space to share with the family! Enjoy preparing meals in this impressive gourmet kitchen equipped with ample cabinets and generous counter space. The primary bathroom features a separate tub and shower, dual sinks, and a walk-in closetThe oversized backyard has it\'s own own basketball court and yet still enough room for that pool, which is perfect for entertaining. This one story home truly has everything that you have been dreaming of. Selling AS-IS, no repairs. Submit offer accordingly. Seller is motivated and will review all offers.' ,`Acres` = '0.4385' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 58 LAKEWOOD SEC M' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Sec M' ,`TaxAmount` = '8666' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697584' WHERE `Matrix_Unique_ID` = '211048041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:28:50.047' ,`MLSNumber` = '10887724' ,`ListAgentFullName` = 'Iordanis Toumanidis' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798132' ,`Longitude` = '-95.432862' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Droxford' ,`StreetNumber` = '1822' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly unique opportunity to own an impeccably maintained and move-in ready home in the highly coveted interior of Timbergrove Manor. This home was extremely thoughtfully designed and now it\'s ready for you to make it your own - a place where your family can grow, and new memories can be created. The kitchen opens up to a spacious breakfast area and expansive living room with luxurious wood paneling throughout. The formal sitting room near the front of the house is easily adaptable to create the perfect home office right off the kitchen. The covered patio in the back is a blank slate for a magazine-worthy outdoor living setup. The oversized garage was originally used as a work shop with overhead doors on both ends, leading out to a covered greenhouse or storage area. Cultivate the massive backyard into the garden oasis of your dreams. Room for a pool or master suite addition! Minutes to the Heights, Downtown or Galleria, numerous parks & hike/bike trails.' ,`Acres` = '0.2153' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 TIMBERGROVE MANOR SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Timbergrove Manor Sec 12' ,`TaxAmount` = '9809' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697584' WHERE `Matrix_Unique_ID` = '211186088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T12:00:32.663' ,`MLSNumber` = '54423450' ,`ListAgentFullName` = 'Lin Hutzenbiler' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.166163' ,`Longitude` = '-96.256102' ,`PhotoCount` = '50' ,`PostalCode` = '77437' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Brent' ,`StreetNumber` = '310' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVE IS Serinity, beauty and comfort. It is all here in this beautiful country home with 4 large bedrooms, including two master suites, 3 newly remodeled bathrooms cozy family area with wood burning fireplace and large living room that brings in an abundance of natural light. You will surely love this tastefully done kitchen with tons of storage, and counterspace. Stepping outside you will enjoy the covered patio, partially fenced in yard and newly built 30x40 barn. You will want to see this one!' ,`Acres` = '0.7059' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTHERN ACRES BLOCK 3 LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Southern Acres' ,`TaxAmount` = '4713' ,`TaxRate` = '1.9674' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697585' WHERE `Matrix_Unique_ID` = '211203648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:23:45.153' ,`MLSNumber` = '18796266' ,`ListAgentFullName` = 'Ashley Escandon' ,`ListOfficeName` = 'Rental Management Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827173' ,`Longitude` = '-95.737148' ,`PhotoCount` = '13' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '319995.00' ,`Status` = 'Active' ,`StreetName` = 'Imperial Landing' ,`StreetNumber` = '20823' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Near parks, country club and easy access to main roads. This beautiful spacious two-story five bedroom home features a large living room with a den that opens to the kitchen, plenty of counter space and storage. Primary bedroom includes a sitting room with two large closets. Game room is at the top of the stairs. Beautiful backyard perfect for gatherings and so much more! Don\'t wait, schedule a showing today!' ,`Acres` = '0.1187' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 BRIDGEWATER MEADOW SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5170' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCROBERTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgewater Mdw Sec 02' ,`TaxAmount` = '5930' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697585' WHERE `Matrix_Unique_ID` = '211222168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T12:47:38.160' ,`MLSNumber` = '45445828' ,`ListAgentFullName` = 'Tina Thao Nguyen' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837014' ,`Longitude` = '-95.656246' ,`PhotoCount` = '36' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Kacee' ,`StreetNumber` = '4339' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Charming 4 bedroom Home offers a Spacious Open Concept Living w/ plenty of Upgrades throughout. Home boasts a Magnificent Chef\'s Kitchen w/ custom Granite Kitchen Island, Updated Gray Cabinets w/ Gold Handles, Custom Slate Tile Surround, and Tiled Mosaic Backsplash. All bathrooms have been fully upgraded with stunning Tile Surround, Granite Vanities, and Light Fixtures. Upgraded Tile Flooring throughout the common areas, updated carpet in rooms, updated appliances including recently installed Stainless Steel Dishwasher and Modern Electric Range. This backyard Oasis is complete w/ a gorgeous Covered Back Patio and Additional Large Patio Space highlights the perfect spot for family gatherings and entertainment. The Garage has been converted to a 4th bedroom and additional storage space with built-in cabinets. Zoned to Acclaimed Cyfair ISD schools. Conveniently located next to hwy 6, i-10, and 290 along with great shops and grocery stores. Ready for a Buyer Today!' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 6 GLENCAIRN SOUTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLFE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glencairn South' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697585' WHERE `Matrix_Unique_ID` = '211335859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:27:56.010' ,`MLSNumber` = '51354447' ,`ListAgentFullName` = 'Cat Jones' ,`ListOfficeName` = 'RE/MAX Land & Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.393329' ,`Longitude` = '-96.841257' ,`PhotoCount` = '50' ,`PostalCode` = '77950' ,`RoomCount` = '4' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Bay' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Street' ,`City` = 'Austwell' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked away in the quiet fishing village of Austwell, Texas, this unique property on Hynes Bay is ideal for a corporate retreat or spacious bay home for an adventurous family. The newly renovated property features 4 bedrooms and can sleep 12. The main room has vaulted ceilings with stunning bay views. The house has a fully equipped kitchen, 2.5 baths, laundry room, hardwood floors, a newer metal roof, hurricane shutters, and a wrap-around porch with weather-proof decking. The private lighted fishing pier extends well into the bay and features running water and a fish cleaning station. Next to the main house is a substantial lighted storage building, large enough for a boat or RV, with still plenty of room for a workshop. Whether you are looking for a place to give your team some needed rest and recuperation for a job well done, or you have a family that enjoys the adventure that bay living provides, this property is truly one of a kind. Do not miss it!' ,`Acres` = '0.689' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'E/2 Hotel Blk Next to Blk 33 Austwell' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '320 - Austwell-Tivoli' ,`SchoolElementary` = 'AUSTWELL-TIVOLI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTWELL-TIVOLI HIGH SCHOOL' ,`SchoolMiddle` = 'AUSTWELL-TIVOLI HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Austwell' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697585' WHERE `Matrix_Unique_ID` = '211358637' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T13:08:56.073' ,`MLSNumber` = '10872282' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535053' ,`Longitude` = '-95.292405' ,`PhotoCount` = '8' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '4011' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD VILLAGE SEC 3 (A0508 F B DRAKE)(PEARLAND), BLOCK 1,' ,`LotDesciption` = 'Other' ,`LotSize` = '8398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Village Sec 1 5' ,`TaxAmount` = '6388' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697585' WHERE `Matrix_Unique_ID` = '211359527' --> Updated record success