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-04T16:57:07.713' ,`MLSNumber` = '21239768' ,`ListAgentFullName` = 'Ritambhara Patel' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697808' ,`Longitude` = '-95.768565' ,`PhotoCount` = '38' ,`PostalCode` = '77407' ,`RoomCount` = '14' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Starbridge Lake' ,`StreetNumber` = '23427' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME Magnificent Water lake view 6 Bedrooms (2 bedrooms on 1st floor) & 4 Bathroom Home with Soaring High Ceilings Archways, Crown Molding Flanked by FORMAL Living and FORMAL Dining Rooms Gorgeous Entryway opens Spacious Family room with Fireplace ,Abundance of Natural Light. Large Bay window Master Suite 1st floor features luxury bath & dual vanities, soaking tub with separate shower with walk in closet. Guest Bedroom with full bath also on 1st floor. Cannot miss the spacious Island Kitchen 42 inch Cabinets, microwave, oven and gas cook stove & walk-in pantry. GRAND Rod Iron, wood Spiral Staircase Leads to a large Game room and media Room includes 10 RECLINER Chairs, MOVIE PROJECTOR,120\" MOVIE SCREEN, speakers & Grand chandelier. 4 bedroom walk in closets & 2 full bathroom 2nd floor Entertain your family and friends Enjoy BBQ on large Backyard, covered Patio, Sprinkler system. MUST SEE BEFORE ITS GONE. House Sold “AS IS “.' ,`Acres` = '0.2258' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKWAY LAKES SEC 2, BLOCK 2, LOT 9' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9836' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '942' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Parkway Lakes Sec 2' ,`TaxAmount` = '9680' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694458' WHERE `Matrix_Unique_ID` = '207368838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:03:53.990' ,`MLSNumber` = '76149993' ,`ListAgentFullName` = 'Maria Williams' ,`ListOfficeName` = 'Texcom Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140939' ,`Longitude` = '-94.881953' ,`PhotoCount` = '17' ,`PostalCode` = '77535' ,`RoomCount` = '10' ,`ListPrice` = '547200.00' ,`Status` = 'Active' ,`StreetName` = 'Road 6609' ,`StreetNumber` = '1079' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! 1.5 stories with TWO primary suites, one upstairs (with its balcony) and one down! The primary downstairs suite includes a Jacuzzi tub, a separate standing shower, and a walk-in closet. This home also features a half bath and cooking area with a sink and custom BBQ grill on the covered back patio, granite throughout, stainless steel appliances, rod iron staircase, and more!' ,`Acres` = '0.689' ,`Area` = '52' ,`BuilderName` = 'Royalty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 1, BLOCK 1, LOT 13, ACRES .689' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '30013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '609' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694458' WHERE `Matrix_Unique_ID` = '207998591' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:59:25.800' ,`MLSNumber` = '69731869' ,`ListAgentFullName` = 'Gabriel Cardenas' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.056168' ,`Longitude` = '-94.096642' ,`PhotoCount` = '6' ,`PostalCode` = '77705' ,`RoomCount` = '3' ,`ListPrice` = '55000.00' ,`Status` = 'Active' ,`StreetName` = 'Euclid' ,`StreetNumber` = '1250' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR SPECIAL! Large lot and close to town! Property to be sold AS-IS. No repairs to be made.' ,`Acres` = '0.1607' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ARLINGTON L17 B14' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'PIETZSCH-MACARTHUR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTH PARK MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arlington' ,`TaxAmount` = '1058' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694458' WHERE `Matrix_Unique_ID` = '208589151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:16:00.913' ,`MLSNumber` = '71582255' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.163644' ,`Longitude` = '-95.615616' ,`PhotoCount` = '19' ,`PostalCode` = '77486' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Paradise Valley' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WHOA talk about potential! Here\'s your opportunity to put your Pinterest vision to life! Boasting over 2800 sqft- this home features a sunken living room, formal dining area, atrium, and HUGE bedrooms. Extra lot available with the home that can we replatted and sold off- or keep for yourself!' ,`Acres` = '0.4491' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 1 (A0133 M VARNER) BLK 5 LOT 9-17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'COLUMBIA LAKES ORIGINAL' ,`TaxAmount` = '4071' ,`TaxRate` = '2.186289' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694458' WHERE `Matrix_Unique_ID` = '209445537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:48:55.303' ,`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` = '239000.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`='1663694458' WHERE `Matrix_Unique_ID` = '209461872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:55:52.867' ,`MLSNumber` = '4310271' ,`ListAgentFullName` = 'Crystal Olenbush' ,`ListOfficeName` = 'AustinRealEstate.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.249326' ,`Longitude` = '-97.785374' ,`PhotoCount` = '16' ,`PostalCode` = '78704' ,`RoomCount` = '9' ,`ListPrice` = '5280000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Park' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Drive' ,`City` = 'Austin' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4359' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury at its finest with a full-size lap pool and spa, floor-to-ceiling windows, cantilevered roof line, and a grand entrance to impress all of your guests. Sophisticated architecture designed to incorporate a variety of textures, exposed beamed ceilings, and high-end finishes throughout the house, including thoughtfully selected tile design in every bathroom. A one-of-a-kind floor plan built around the pool featuring a bridge that crosses from the primary suite through sliding doors over to a studio/study/workout room/or 5th bedroom. Multiple living areas, perfect for entertaining. Complete privacy for relaxation in your pool and outdoor space. 100% walkability to bike and hike, restaurants, and bars.' ,`Acres` = '0.2919' ,`Area` = '83' ,`BuilderName` = 'Urban-ATX' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4 BLK N BARTON HILLS SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '12715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '111 - Austin' ,`SchoolElementary` = 'BARTON HILLS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (AUSTIN)' ,`SchoolMiddle` = 'O. HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Barton Hills Sec 02' ,`TaxAmount` = '44611' ,`TaxRate` = '2.1767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694458' WHERE `Matrix_Unique_ID` = '209524474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:36:37.983' ,`MLSNumber` = '40646317' ,`ListAgentFullName` = 'Laura Brown' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842517' ,`Longitude` = '-95.372015' ,`PhotoCount` = '50' ,`PostalCode` = '77022' ,`RoomCount` = '10' ,`ListPrice` = '359999.00' ,`Status` = 'Active' ,`StreetName` = 'De Boll' ,`StreetNumber` = '258' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prepare to fall in love with this tastefully completely remodeled and improved MULTI UNIT property with GUEST QUARTERS! Main house features 3 bed/2 bath open concept floorplan, great for entertaining and practical living. Kitchen has quartz counters, subway tile backsplash, s/s appliances including refrigerator, large pantry. Primary with ensuite bath featuring dual sinks, vanity area, large closet with 2 built in dressers. Great in house utility with quartz counters and lots of cabinets. Backyard with GUEST HOUSE complete with kitchen, bath, bed and storage! Rent quarters for extra income or perhaps an office? Endless possibilities! Walking distance to elementary school. Fantastic location, minutes from downtown.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 16 ELMWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`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` = 'BURBANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elmwood' ,`TaxAmount` = '2218' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694459' WHERE `Matrix_Unique_ID` = '209616454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:49:08.420' ,`MLSNumber` = '327506' ,`ListAgentFullName` = 'Nancy McDermand' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943712' ,`Longitude` = '-93.906766' ,`PhotoCount` = '10' ,`PostalCode` = '77619' ,`RoomCount` = '5' ,`ListPrice` = '143500.00' ,`Status` = 'Active' ,`StreetName` = 'Verde' ,`StreetNumber` = '6441' ,`StreetSuffix` = 'Street' ,`City` = 'Groves' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PORT NECHES I.S.D. Oversized lot 60x234. Beautiful, original hardwood floors throughout. Nice size rooms and built-in drawers & vanity in master bedroom. Carport, oversized two-car garage with 17\'x10\'8\" workshop; bathroom. Three large pecan trees at back of property. Newer Central air & heat.' ,`Acres` = '0.3223' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 3 VAL VERDE GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '233 - Port Neches-Groves' ,`SchoolElementary` = 'PORT NECHES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORT NECHES-GROVES HIGH SCHOOL' ,`SchoolMiddle` = 'GROVES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Val Verde Gardens' ,`TaxAmount` = '4465' ,`TaxRate` = '2.7694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694459' WHERE `Matrix_Unique_ID` = '209743674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:39:31.013' ,`MLSNumber` = '95833979' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624543' ,`Longitude` = '-95.378762' ,`PhotoCount` = '15' ,`PostalCode` = '77047' ,`RoomCount` = '3' ,`ListPrice` = '304545.00' ,`Status` = 'Active' ,`StreetName` = 'Harlesden' ,`StreetNumber` = '12811' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Brooke Plan, their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio, 2-car garage, updated staircase and no back neighbors! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! You won\'t have to worry about yard maintenance at City Gate, the front yard irrigation is included with the landscape package and HOA maintains the front yard! (All information provided by builder). Located in Houston’s newest D.R. Horton Community known as City Gate, this gorgeous development features walking trails, tot lot and community park!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 4 CITY GATE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City Gate' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694459' WHERE `Matrix_Unique_ID` = '209758545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:39:18.130' ,`MLSNumber` = '88644471' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624543' ,`Longitude` = '-95.378762' ,`PhotoCount` = '15' ,`PostalCode` = '77047' ,`RoomCount` = '3' ,`ListPrice` = '305245.00' ,`Status` = 'Active' ,`StreetName` = 'Barnsbury' ,`StreetNumber` = '12821' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Brooke Plan, their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio, 2-car garage, updated staircase and no back neighbors! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! You won\'t have to worry about yard maintenance at City Gate, the front yard irrigation is included with the landscape package and HOA maintains the front yard! (All information provided by builder). Located in Houston’s newest D.R. Horton Community known as City Gate, this gorgeous development features walking trails, tot lot and community park!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 5 CITY GATE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City Gate' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694459' WHERE `Matrix_Unique_ID` = '209758657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:36:28.343' ,`MLSNumber` = '48996674' ,`ListAgentFullName` = 'Victor Jaramillo' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476738' ,`Longitude` = '-95.610350' ,`PhotoCount` = '37' ,`PostalCode` = '77469' ,`RoomCount` = '12' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Calle Escondido' ,`StreetNumber` = '3127' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3391' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Find everything you’ve been dreaming of in this gorgeous 4 bedrooms, 3.5 bathrooms with an office that can be used as an additional bedroom home in the peaceful community of Sun Ranch. Resting on about 1.7 Acres spacious lot, this house boasts a premium elevation, marble tile flooring. Dream up new recipes in the kitchen, complete with granite countertops, a tile backsplash, and 42” upper cabinets. Featuring dual vanities, a 42” tub, and a separate shower, the tranquil primary suite is the ideal evening escape. if you ever dream to have a tree house, this is a dream come true place, also featuring a large 40\' by 30\' store/barn house, which can be use as storage, RV/ boat parking, or machinery, tools place. Popular restaurants and shopping centers at Brazos Town Center are only a short distance away, among the area’s stunning nature parks. Schools are zoned to the recognized Lamar Consolidated ISD. Don’t wait – call today for more information!' ,`Acres` = '1.6754' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUN RANCH SEC 1, BLOCK 2, LOT 20, ACRES 1.632' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '72982' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'VELASQUEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Sun Ranch' ,`TaxAmount` = '8984' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694459' WHERE `Matrix_Unique_ID` = '209763827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:36:23.977' ,`MLSNumber` = '27216712' ,`ListAgentFullName` = 'Genevieve Badough' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.243003' ,`Longitude` = '-95.907524' ,`PhotoCount` = '31' ,`PostalCode` = '77484' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Magan' ,`StreetNumber` = '6297' ,`StreetSuffix` = 'Road' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to country living! This 2 bedroom, 2 bath home sits on 4.75 unrestricted acres with plenty of room for livestock in beautiful West Magnolia Forest. Come enjoy the peace and quiet that this home has to offer. Your new home is 20 minutes from Magnolia and Highway 290 access. The under construction \"Aggie Highway\" is only 5 miles away, giving easy access to Highway 249 and the Grand Parkway. Don\'t wait, schedule your tour today!' ,`Acres` = '4.75' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'W MAGNOLIA FRST SEC 5, LOT 59, SERIAL # 78141131, TITLE # 09' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '206910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'W Magnolia Forest Sec 5' ,`TaxAmount` = '1016' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694459' WHERE `Matrix_Unique_ID` = '209950560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:38:55.027' ,`MLSNumber` = '83551365' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624543' ,`Longitude` = '-95.378762' ,`PhotoCount` = '12' ,`PostalCode` = '77047' ,`RoomCount` = '3' ,`ListPrice` = '302990.00' ,`Status` = 'Active' ,`StreetName` = 'Wingmore' ,`StreetNumber` = '2804' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Brooke Plan Elevation N, their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio, 2-car garage, updated staircase and no back neighbors! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! You won\'t have to worry about yard maintenance at City Gate, the front yard irrigation is included with the landscape package and HOA maintains the front yard! (All information provided by builder). Located in Houston’s newest D.R. Horton Community known as City Gate, this gorgeous development features walking trails, tot lot and community park!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 6 CITY GATE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City Gate' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694459' WHERE `Matrix_Unique_ID` = '210217930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:41:00.090' ,`MLSNumber` = '98542146' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Jason Cruz' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.624543' ,`Longitude` = '-95.378762' ,`PhotoCount` = '31' ,`PostalCode` = '77047' ,`RoomCount` = '3' ,`ListPrice` = '291990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Barnsbury' ,`StreetNumber` = '12822' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Amber Plan with Elevation M, their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! You won\'t have to worry about yard maintenance at City Gate, the front yard irrigation is included with the landscape package and HOA maintains the front yard! (All information provided by builder). Located in Houston’s newest D.R. Horton Community known as City Gate, this gorgeous development features walking trails, tot lot and community park!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 CITY GATE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'City Gate' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694460' WHERE `Matrix_Unique_ID` = '210219027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:39:27.707' ,`MLSNumber` = '91852408' ,`ListAgentFullName` = 'Thelma Yera' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738687' ,`Longitude` = '-95.342364' ,`PhotoCount` = '19' ,`PostalCode` = '77003' ,`RoomCount` = '6' ,`ListPrice` = '354700.00' ,`Status` = 'Active' ,`StreetName` = 'Hussion' ,`StreetNumber` = '1505' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location!\r\nCute 2 bedroom cottage located minutes from downtown. Perfect updated starter home!' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 W L EDMUNDSON SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edmundson Sec 03' ,`TaxAmount` = '4712' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1919' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694460' WHERE `Matrix_Unique_ID` = '210681079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T17:58:26.367' ,`MLSNumber` = '58450431' ,`ListAgentFullName` = 'Monica Martinez' ,`ListOfficeName` = 'Houston Preferred Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068211' ,`Longitude` = '-95.536732' ,`PhotoCount` = '42' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Bradley Gardens' ,`StreetNumber` = '20818' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wheeler Floorplan - Located in the beautiful community of Laurel Glen, Open design is great for entertaining, Stylish and sleek kitchen with large island with sink and Large covered patio' ,`Acres` = '0.1458' ,`Area` = '14' ,`BuilderName` = 'Princeton Classic' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 LAUREL PARK NORTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '963' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Laurel Park North Sec 3' ,`TaxAmount` = '10230' ,`TaxRate` = '3.2565' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694460' WHERE `Matrix_Unique_ID` = '210971197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:32:10.907' ,`MLSNumber` = '45241986' ,`ListAgentFullName` = 'Jayson Peoples' ,`ListOfficeName` = 'Greater Houston REP, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751012' ,`Longitude` = '-95.583132' ,`PhotoCount` = '33' ,`PostalCode` = '77077' ,`RoomCount` = '11' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookspring' ,`StreetNumber` = '11607' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!!! Freshly updated 4 bed/3.5 bath home located in the beautiful Lakeside Place neighborhood! With updated landscaping in the front and back, outdoor patio, fresh exterior and interior paint, wood and tile flooring, gutters, front door and the list goes on. This floor plan features large rooms and functionality. The office and primary suite are settled in their own section of the home for privacy. The huge family room downstairs and the large gameroom upstairs provide plenty of room for play and relaxation. Large kitchen with granite tops, ss appliances, 6 burner gas cooktop, double convection ovens and recently painted white kitchen cabinets. This home has everything you could want with tons of storage, large windows for natural light and an inviting yard to enjoy. Location is everything and this property does not disappoint with easy access to City Centre, BW8, I-10 & Westpark Tollway. Great shopping and dining options are close by. This home is ready for it\'s new family!' ,`Acres` = '0.1901' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 12 LAKESIDE PLACE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '860' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakeside Place' ,`TaxAmount` = '9690' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694460' WHERE `Matrix_Unique_ID` = '211060545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T16:49:04.830' ,`MLSNumber` = '14399317' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401404' ,`Longitude` = '-95.634611' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Fountainview' ,`StreetNumber` = '13819' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home with 3 car garage that backs up to Margaritaville Golf Course. Very private & wooded back yard. 4 bedroom, game room, study ready for Sept. 2022 move in. Gorgeous stone/brick combination.' ,`Acres` = '0.1515' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 11, BLOCK 63, LOT 30' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1061' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 11' ,`TaxAmount` = '202' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694460' WHERE `Matrix_Unique_ID` = '211063564' --> Updated record success