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-12-19T08:46:50.360' ,`MLSNumber` = '40396475' ,`ListAgentFullName` = 'Jewel McElreath' ,`ListOfficeName` = 'Reyes Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.512074' ,`Longitude` = '-95.408490' ,`PhotoCount` = '24' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 58' ,`StreetNumber` = '2883' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS A PRIME PIECE OF COMMERCIAL PROPERTY.....THERE IS NO HOA...OR MUD..... 5.97+/- ACRES, THIS PROPERTY IS IDEALLY SUITED FOR A NEW BUSINESS. ONE OF THE FASTEST-GROWING AREAS IN MANVEL, HIGH TRAFFIC AREA, THE PROPERTY IS CLOSE TO NEW HOPE CHURCH AND THE NEW ADDITIONS OF DEL BELLO LAKES, BLUEWATER ESTATES, NEWPORT, POMONA, AND RODEO PALMS. THE AGENT IS RELATED TO THE SELLER. ROOM MEASUREMENTS ARE APPROX PLEASE VERIFY.' ,`Acres` = '5.97' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0563 H T & B R R TRACT 30A ACRES 5.9701' ,`LotDesciption` = 'Cleared' ,`LotSize` = '260058' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '8191' ,`TaxRate` = '2.8848' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093082' WHERE `Matrix_Unique_ID` = '188106051' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T08:52:00.230' ,`MLSNumber` = '62421712' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805318' ,`Longitude` = '-94.905096' ,`PhotoCount` = '21' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '310990.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Wind' ,`StreetNumber` = '7803' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous plan greets you with three spacious bedrooms with walk-in closets and two full bathrooms. Down the hall lies the large family room, formal dining room, and huge kitchen. Privacy is no worry when it comes to the master bedroom and bath at the back of the home adjacent to the secluded home office.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 2, Section 1' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '9797' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynnwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093082' WHERE `Matrix_Unique_ID` = '195960267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T08:47:49.607' ,`MLSNumber` = '95261882' ,`ListAgentFullName` = 'Kaye Kaye Smith' ,`ListOfficeName` = 'Legacy Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.126301' ,`Longitude` = '-94.093291' ,`PhotoCount` = '28' ,`PostalCode` = '75929' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 705' ,`StreetNumber` = '21830' ,`StreetSuffix` = '' ,`City` = 'Broaddus' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute \'n Cozy home near Powell Park Marina, backs up to Corp. of Engineer land, 5.17 acres, 6\' wrap around porch, One 2 car garage plus another 2 car garage/wood working shop. One of the two car garages used to be used as an apartment and has a kitchenette and bathroom (could easily be converted back to apartment). Partially wooded giving lots of privacy, fish and deer cleaning station, boat launches nearby. Storm closet with solid concrete wall in one of the bedrooms, House roof replaced 2017. Matching Garage roof replaced 2019. Large storage building and an enclosed boat storage. SELLING AS IS' ,`Acres` = '5.17' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 40 WT SHANNON TRACT 2 & IMP - 5.17 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '232 - Broaddus' ,`SchoolElementary` = 'BROADDUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROADDUS HIGH SCHOOL' ,`SchoolMiddle` = 'BROADDUS HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093082' WHERE `Matrix_Unique_ID` = '207255200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T07:54:06.553' ,`MLSNumber` = '49315526' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225668' ,`Longitude` = '-95.701877' ,`PhotoCount` = '9' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '282990.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Warbler' ,`StreetNumber` = '40347' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Island Kitchen, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Vinyl Plank Floors in Pocket Office, Dining Room, Kitchen, Family Room and All Wet Areas, Granite Kitchen Countertops, Tile Backsplash, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, Grey 42” Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, Covered Patio, Landscaping with Full Sod and Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE SEPTEMBER/OCTOBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 3 SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093082' WHERE `Matrix_Unique_ID` = '208967571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T08:16:10.033' ,`MLSNumber` = '76675684' ,`ListAgentFullName` = 'Kimberly Peltier' ,`ListOfficeName` = 'Peltier Home And Ranch Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.003691' ,`Longitude` = '-95.333939' ,`PhotoCount` = '10' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '234000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Lane' ,`City` = 'Oyster Creek' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.161' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ALLEN (A0021 S F AUSTIN) LOT 17' ,`LotDesciption` = 'Other' ,`LotSize` = '7013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Allen' ,`TaxAmount` = '108' ,`TaxRate` = '2.2366' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093082' WHERE `Matrix_Unique_ID` = '209461872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T07:04:07.663' ,`MLSNumber` = '871247' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915023' ,`Longitude` = '-95.683543' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Borden Bluff' ,`StreetNumber` = '9402' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly renovated two story house with attached garage on oversized lot that back to green space and dog park. This charming house is located in a quiet cul-de-sac and only minutes away from Boardwalk at Towne Lake, Kroger, & Lone Star College. Brand new carpet, wood plank LVT flooring, and freshly painted wall, ceiling, trims throughout. Main floor consists of three bedrooms, study room, plus master suite complete with garden tub, enclosed toilet room, dual vanities, and ample closet space. Fully functional kitchen with pantry is right next to the breakfast and dining areas. Open living area with high ceiling & a bonus spacious game room on second floor. This house comes with large backyard and a covered patio for outdoor cooking.' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 CANYON LAKES AT STONEGATE SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '10527' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes at Stonegate' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093083' WHERE `Matrix_Unique_ID` = '212186899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T07:02:37.577' ,`MLSNumber` = '45012130' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690542' ,`Longitude` = '-95.067822' ,`PhotoCount` = '38' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '311900.00' ,`Status` = 'Active' ,`StreetName` = 'Robinson' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house with 3 beds and one extra large room that can be turned into another bedroom. This wonderful home is sitting on large lot. Previous seller said the house is 2,644 sq. ft., the garage was converted into a recreational & separate laundry room. Nice size family room with fireplace, built-in shelf, and high ceiling. Cozy screen porch/patio. Oversize carport 24X48. Quiet neighborhood. Tons of upgrade. Fresh interior & exterior paint, new roof, new bathroom tile, new vinyl flooring, new Quartz countertops and backsplash, new light fixture, new cooktop, new kitchen sink & faucet, & new mirror. Easy access to Hwy. 225 & Hwy. 146. Schedule your showing today.' ,`Acres` = '0.4289' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lomax Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 410 411 & 412 BLK 11 BATTLEGROUND ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18681' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Battleground Estates Sec 02' ,`TaxAmount` = '5812' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093083' WHERE `Matrix_Unique_ID` = '212592742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T08:58:11.063' ,`MLSNumber` = '35354157' ,`ListAgentFullName` = 'Ashley Shadbolt' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.557055' ,`Longitude` = '-95.219562' ,`PhotoCount` = '16' ,`PostalCode` = '77331' ,`RoomCount` = '2' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Dotty Creek' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Street' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 10 Dotty Creek Rd in the heart of San Jacinto County and only minutes from the town of Coldspring! This unique property sits on an oversized 1.3 acre corner lot, which can be platted into smaller parcels for resale should the buyers choose. This lot boasts gorgeous mature oak trees that keep the yard nice and shaded at all times of the day. Inside the home you have 2 bedrooms and 2 baths at opposite sides of the house for added privacy. Out back there is a stone made patio, to enjoy the Texas evenings listening to the trees sway in the wind. There is also a large storage building that the owner had an electrical panel added on to. The property offers public water, electrical, cable and internet and is on a traditional septic system. This property is perfect for anyone looking to get away from the busy city and enjoy the quiet Texas country nights.' ,`Acres` = '1.3424' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ROBIN CREEK, LOT 112, ACRES 1.3424' ,`LotDesciption` = 'Cleared,Corner,Wooded' ,`LotSize` = '58475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Robin Creek' ,`TaxAmount` = '564' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675093083' WHERE `Matrix_Unique_ID` = '213179563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T07:01:34.850' ,`MLSNumber` = '27800303' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843165' ,`Longitude` = '-95.427201' ,`PhotoCount` = '50' ,`PostalCode` = '77091' ,`RoomCount` = '8' ,`ListPrice` = '468900.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Oak' ,`StreetNumber` = '1147' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house with 3 beds and 2 bathrooms with a stunning private pool. This wonderful home is sitting on large lot. Tons of upgrade. Fresh interior & exterior paint, new double pane windows, new doors, new vanity, new bathroom tile, new shower door, new French door, new barn door, new vinyl flooring, new Quartz countertops and backsplash, new light fixture, new cooktop, new dishwasher, new disposal, new garage motor, new kitchen sink & faucet, new exhaust vent, & new mirror. New epoxy on garage. Foundation has been leveled. The pool has been re- plastered. Easy access to 610 & 45. Schedule your showing today.' ,`Acres` = '0.2066' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 61 BLK 2 SHEPHERD PARK TERRACE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Park Terrace Sec 01' ,`TaxAmount` = '5785' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093083' WHERE `Matrix_Unique_ID` = '213490427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T07:02:52.660' ,`MLSNumber` = '51490088' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663202' ,`Longitude` = '-95.077539' ,`PhotoCount` = '36' ,`PostalCode` = '77571' ,`RoomCount` = '6' ,`ListPrice` = '257900.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Brook' ,`StreetNumber` = '3206' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house on a big lot in Fairmont Park Subdivision. Tons of upgrade. Fresh interior paint, new vinyl flooring, new interior doors, new Quartz countertops and backsplash, new light fixture, new kitchen sink & faucet, new mirror, & epoxy in garage. Foundation has been leveled with lifetime warranty. Buyer needs to verify house sf. Per previous seller is 1,833 sf. Per tax record is 1,518 sf. The spacious backyard holds a gazebo, shed, fire pit, & a swing set. Recent home updates include AC replacement, new PEX plumbing, additional insulation, updated sewer lines, attic fan, & radiant barrier. Easy access to Beltway 8, Spencer Hwy., Hwy. 146, & Hwy. 225. Close to major shopping center and restaurants. Schedule your showing today.' ,`Acres` = '0.2388' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 FAIRMONT PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '41' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LEO RIZZUTO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairmont Park Sec 01' ,`TaxAmount` = '4137' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093084' WHERE `Matrix_Unique_ID` = '213583201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T08:50:09.147' ,`MLSNumber` = '49231403' ,`ListAgentFullName` = 'Robert Roca' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = 'Alyssa Marshall' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.758489' ,`Longitude` = '-94.984886' ,`PhotoCount` = '29' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '260000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Spring Hollow' ,`StreetNumber` = '2335' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this gorgeous, gently lived in home in the heart of Baytown. This home is chocked full of upgrades from the brick elevation, open concept layout, large rooms, extra large primary with en-suite bath, and a spacious kitchen ready for the aspiring chef in you. This beauty is just minutes from local schools, restaurants, hospitals, shopping and so much more. Don\'t let this one slip through your hands. Contact us today for your personal showing and find yourself celebrating the holidays in your very own gorgeous home.' ,`Acres` = '0.1241' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 ROLLINGBROOK ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5407' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CARVER ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rollingbrook Estates' ,`TaxAmount` = '5426' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093084' WHERE `Matrix_Unique_ID` = '213835291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T08:52:36.780' ,`MLSNumber` = '26316413' ,`ListAgentFullName` = 'Cesar Calderon' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974892' ,`Longitude` = '-95.526770' ,`PhotoCount` = '50' ,`PostalCode` = '77069' ,`RoomCount` = '4' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Point Clear' ,`StreetNumber` = '6503' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Roof, HVAC, New insulation and Windows replaced 2019* Water softener, Honeywell touchscreen lyric alarm system with a built-in camera, fridge, washer & dryer included. Come & see this classic Champions West, 4 bed, 2.5 bath, single story home. Boasting a 13,110 sqft lot & 2,642 sqft of living space, room for hosting family & friends will abound. This gem features a stone countertop kitchen with recently upgraded stainless steel appliances & marble-inspired tile throughout the kitchen and breakfast area. Entering the foyer you\'ll find a naturally lit family room with a gas fireplace, & to the left a living room/flex space. A dedicated formal dining room large enough to share meals & create memories with loved ones. An arterial corridor delivers you to the owner\'s suite, secondary bedrooms, bathrooms, laundry room, & garage access. Don\'t miss out, schedule your private tour now!' ,`Acres` = '0.301' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 232B BLK 11 CHAMPIONS WEST EXT & R/P' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '13110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions West Ext & R/P' ,`TaxAmount` = '6400' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093084' WHERE `Matrix_Unique_ID` = '213878106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T07:03:32.487' ,`MLSNumber` = '71736895' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887713' ,`Longitude` = '-95.436171' ,`PhotoCount` = '24' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Drayton' ,`StreetNumber` = '2123' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house with 4 beds and 2 baths. Tons of upgrade. Fresh interior paint, new roof, new HVAC, new Quartz countertops and backsplash, new gas oven, new cooktop, new light fixture, new kitchen sink & faucet, new mirror, & new dishwasher. Easy access to I-45 & Hwy. 249, & also 610. Schedule your showing today.' ,`Acres` = '0.1515' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 836 BLK 26 HEATHER GLEN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heather Glen Sec 03' ,`TaxAmount` = '3075' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093084' WHERE `Matrix_Unique_ID` = '214074036' --> Updated record success