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-20T01:22:01.110' ,`MLSNumber` = '98041103' ,`ListAgentFullName` = 'Lauren Silva' ,`ListOfficeName` = 'RE/MAX Adventure' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540508' ,`Longitude` = '-95.090809' ,`PhotoCount` = '43' ,`PostalCode` = '77058' ,`RoomCount` = '12' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Point Lookout' ,`StreetNumber` = '18519' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Nassau Bay! This oversized lot shows off a massive backyard with your own in-ground pool & KatchaKid. Home features 2 living areas, 2 dining spaces, and large bedrooms. The master bed is spacious and has french doors that open to the pool. The utility room homes a New water heater (2020), deep sink, half bath, and plenty of room for storage. Huge bonus is FEMA has given approval at 100% to elevate the home. The elevation will add an additional 572 sq ft of living space (totaling approximately 3100 sq ft inside) and give the option to design the downstairs garage/boat storage/entertaining area (designs to build an outdoor area/kitchen right by the pool!). Ask for a copy of the renderings from local company. Flood insurance will drop to state minimum immediately after lifting. Come view the home today!' ,`Acres` = '0.3214' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 23 NASSAU BAY SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nassau Bay Sec 05' ,`TaxAmount` = '7440' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700782' WHERE `Matrix_Unique_ID` = '205518732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '48555496' ,`ListAgentFullName` = 'Sal Conda' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740801' ,`Longitude` = '-95.362707' ,`PhotoCount` = '36' ,`PostalCode` = '77004' ,`RoomCount` = '4' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Hutchins' ,`StreetNumber` = '2332' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment opportunity! A free-standing building located east downtown, university areas, sport venues and minutes from the Medical Center. Big open granite island kitchen, 3 Bedrooms and 3 Full Bath and Half-Bath, Gas fireplace, Tankless water heater, front sprinklers and real sidewalks with Pavers to the private 2 car garage. HOA covers common area insurance, water/sewer, trash\r\nand landscaping. Move-in ready!! Call today to schedule a showing.' ,`Acres` = '0.0433' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 SAINT EMANUEL STREET ENCLAVE' ,`LotDesciption` = 'Corner' ,`LotSize` = '1888' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Saint Emanuel Street Enclave' ,`TaxAmount` = '8757' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700782' WHERE `Matrix_Unique_ID` = '206424869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '29538223' ,`ListAgentFullName` = 'Teresa Sanchez' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771487' ,`Longitude` = '-95.037653' ,`PhotoCount` = '20' ,`PostalCode` = '77520' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Dr' ,`StreetNumber` = '305' ,`StreetSuffix` = '' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED. NEED SPACE? Extravagant! Upgraded To The Max! Total Makeover! NO HOA! Oversized Lot With Super Long Driveway* Mature Trees Great For Those HOT Summers* Spacious Gourmet Kitchen With TONS Of Cabinets* New Stainless Steel Appliances*Light and Bright Living & Dining Room* Primary Downstairs With Huge Walk-in Closets* Double Sinks With Granite Countertops* Elegant Wide Wood Staircase Leads To The Secondary Bedrooms* 2nd Bedrooms Leads To Finished Attic Space* All-New Windows Have Great Views & Provide TONS Of Natural Light* Attached 2 Car Garage* Storage Shed* Goose Creek ISD* Won\'t Last Long! Mrs. Clean Lives Here! A Must See! Ez Access To I-10 & Burnet Bay*' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 31 BLK 9 LAKEWOOD SEC B' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '17727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Lakewood Sec B' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700782' WHERE `Matrix_Unique_ID` = '206793998' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '11909370' ,`ListAgentFullName` = 'Dave Noel' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.386509' ,`Longitude` = '-95.699254' ,`PhotoCount` = '43' ,`PostalCode` = '77316' ,`RoomCount` = '20' ,`ListPrice` = '999999.00' ,`Status` = 'Active' ,`StreetName` = 'LOUISA' ,`StreetNumber` = '509' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing property is perfect for a family. There are 3 properties on almost 2 gorgeous acres. The main house is 2,078 SF and has 2 bedrooms and 2 full baths, two living areas, dining, kitchen w/ island, fireplace and laundry room. The Guest house is prefect for a mother in law suite. It is 971 SF w/ 1 bedroom, full kitchen, living area, full bath and laundry room. Also, a half garage for a shop or golf cart. The Bunkhouse is 1,027 SF. It has a huge room perfect for a game room, parties or additional living. It has 2 full baths with large showers, 1 half bath, kitchenette w/ fridge, microwave, dishwasher and ice maker. Tankless water heater. Enjoy this peaceful property surrounded by Oak and Pecan trees. Properties have been totally renovated. Perfect for a buyer looking for a great Airbnb/VRBO business or live in one and rent the others. Downtown Old Montgomery. Great restaurants and shopping. Montgomery has the Wine and Antique Festival and weekly Sip & Stroll. MUST SEE IN PERSON' ,`Acres` = '1.739' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S728005 - MONTGOMERY TOWNSITE 05, TRACT 14-D, 14-F AREA E, A' ,`LotDesciption` = 'Wooded' ,`LotSize` = '75750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Townsite 05' ,`TaxAmount` = '9722' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700783' WHERE `Matrix_Unique_ID` = '207150252' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '16687540' ,`ListAgentFullName` = 'Lucia Moore' ,`ListOfficeName` = 'Kino Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731158' ,`Longitude` = '-95.582749' ,`PhotoCount` = '45' ,`PostalCode` = '77082' ,`RoomCount` = '8' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Plain' ,`StreetNumber` = '11515' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular Modern/Contemporary home in gated Royal Oaks Courtyard Villas awaits you. Inviting swimming pool with side yard and outdoor grill, excellent for entertaining. Open floor plan brings you to the exterior by opening the floor to ceiling glass doors. Two elegant master bedrooms, one on the first floor opens to the swimming pool. Enjoy morning coffee off of your master bedroom\'s balcony on the second floor. European finishes including Miele Appliances and cabinetry, custom lighting, tankless water heater, water softener, security system, and much more. Make it your new home. Photos are from the previous listing.' ,`Acres` = '0.0803' ,`Area` = '31' ,`BuilderName` = 'McVaugh' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 ROYAL OAKS COURTYARD VILLAS AMEND' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '6930' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Courtyard Villas' ,`TaxAmount` = '22824' ,`TaxRate` = '2.4711' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700783' WHERE `Matrix_Unique_ID` = '207366440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '26075669' ,`ListAgentFullName` = 'Maria Moore' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.373503' ,`Longitude` = '-95.698994' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '1750000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 149' ,`StreetNumber` = '13225' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity awaits with this gorgeous, lodge-like home, professional office and spacious warehouse space combined under one roof! Grow an overabundance of your own vegetables in the hydroponic greenhouse or raise livestock anywhere on this 6-acre tract. This well-appointed home designed to feel like a mountain lodge offers 3 bedrooms, 2.5 bathrooms, dining, den, a large bonus room and a loft. Three separate insulated shop spaces – two at 2,000 SF with the third bay just over 2,600 SF currently functioning as an office/studio/garage featuring a reception area, common workstation, private office, conference room, half bath and exercise area. With a total usable area of approximately 9,600+/- SF, this overengineered building boasts heavy gauge, red iron steel framing and concrete & steel piers and beams under a thick concrete slab. Plenty of room to add additional buildings for retail and/or office/warehouse, or the acreage can be utilized for equestrian/livestock needs.' ,`Acres` = '6.082' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0022 LANDRUM ZACHARIAS, TRACT 38, ACRES 6.082' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '264932' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Barndominium,Other Style' ,`Subdivision` = 'LANDRUM ZACHARIAS' ,`TaxAmount` = '5163' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700783' WHERE `Matrix_Unique_ID` = '208195729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '3818925' ,`ListAgentFullName` = 'Ken Ho' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748931' ,`Longitude` = '-95.387786' ,`PhotoCount` = '31' ,`PostalCode` = '77006' ,`RoomCount` = '9' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Fargo' ,`StreetNumber` = '512' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located the sought-after Montrose, this stunning Feng Shui oriented custom home with a unique contemporary design is sure to impress everyone. First floor hosts 2 secondary bedrooms with a Jack and Jill bathroom. Foyer with wooden-steps metal stairway that leads to the second floor where lays the kitchen, dining area and grand living area with soaring ceiling, custom built in cabinetry and a beautiful hand crafted solid hardwoods floor throughout. The dining area opens up into the gourmet kitchen with a gorgeous granite countertop, back lit cabinet, breakfast bar connected with the large butler bar with new wine cooler and mini sink. Top floor houses the home owner\'s primary bedroom and ensuite with a private balcony. The Zen theme backyard provides great space for relaxation and entertainment. Only minutes from the most famous eatery and shopping in Montrose, minutes to downtown and major freeways, this outstanding house will surely make its new owner proud to call it home this summer' ,`Acres` = '0.0555' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 5A-1 & 6B-1 BLK 5 FAIRVIEW' ,`LotDesciption` = 'Other' ,`LotSize` = '2417' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Fairview' ,`TaxAmount` = '10891' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700783' WHERE `Matrix_Unique_ID` = '208882216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '7399484' ,`ListAgentFullName` = 'Bradley Davies' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748518' ,`Longitude` = '-95.782565' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Hamilton Mill' ,`StreetNumber` = '24515' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THE VALUE IS IN THE DETAILS! LOVELY 2 STORY ON A CUL DE SAC * AMAZING SPACE - 5 BEDROOMS, ONE CAN BE USED AS A FLEX ROOM OR GAME ROOM * BREAKFAST AREA WAS EXTENDED FOR SPACE IN THE KITCHEN AREA * NEW ROOF AS OF \'20 - WATER HEATER \'21 - FULL GUTTER AND DRAINAGE SYSTEM \'20 - LANDSCAPING AND SPRINKLER SYSTEM \'15 - HIGH END TRANE HVAC \'16 - HIGH END BOSCH DISH WASHER \'18 - REMOVABLE FENCE PANEL FOR LARGER ACCESS TO THE BACKYARD * EXTERIOR PAINT/ HARDY WINDOW TRIM INSTEAD OF WOOD * 10 ZONE SPRINKLER SYSTEM * GORGEOUS BACK PATIO LEADING OUT TO A POOL SIZED BACKYARD * WORKSHOP/SHED IN THE BACKYARD HAS ELECTRICITY - THINK OF THE POSSIBILITIES * SPACE FOR A FOUNTAIN READY TO GO WITH WATER AND ELECTRIC * ATTIC DECKED FOR EXTRA STORAGE SPACE * PHOTOCELL LIGHTS ON PATIO * ADDITION BUILT TO HOUSE SPRINKLER SYSTEM AND STORAGE - ALSO PLUMBED FOR A WATER SOFTENER * THIS HOME IS JUST A BLOCK AWAY FROM WALKING AND BIKING PATHS to WILLOW FORK PARK AND LA CENTERA *SHOPPING * HIGHLY DESIRED KATY ISD *' ,`Acres` = '0.1815' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 6, BLOCK 4, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7908' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '694' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Ranch Sec 6' ,`TaxAmount` = '8075' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700783' WHERE `Matrix_Unique_ID` = '209835865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '42183986' ,`ListAgentFullName` = 'David Brown' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096852' ,`Longitude` = '-95.714741' ,`PhotoCount` = '28' ,`PostalCode` = '77377' ,`RoomCount` = '5' ,`ListPrice` = '559900.00' ,`Status` = 'Active' ,`StreetName` = 'Robin' ,`StreetNumber` = '18906' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely upgraded 3bdrm, 3 1/2 bath home on a peaceful street! This home sits on 1.1 acres. Oversized deck, open living area, perfect for entertaining! Recent improvements include upgraded bathrooms and kitchen along with luxury vinyl flooring downstairs and throughout the hall way areas on the second floor. New paint, recessed lighting, modern stair case and railing. Office/ study or another bedroom on first floor. 2 car garage plus an updated RV storage. The lot size is huge to build a pool to suit which would pair well with the updated backyard deck. Mature oak trees give you that shady suburban feel in the heart Tomball, in a walkable and dog-friendly neighborhood. This home has so much to offer-location, low tax rate, design, modern updates and newly designed layout and upgrades galore! A rare gem, come see for yourself!' ,`Acres` = '1.0031' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT C104 ROSEWOOD HILL SEC 4 U/R' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Rosewood Hill Sec 04 U/R' ,`TaxAmount` = '6291' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700783' WHERE `Matrix_Unique_ID` = '210002594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '42242800' ,`ListAgentFullName` = 'Andre Vysotskiy' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835291' ,`Longitude` = '-95.479258' ,`PhotoCount` = '42' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '476000.00' ,`Status` = 'Active' ,`StreetName` = 'Verdome' ,`StreetNumber` = '6022' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2275' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been elegantly remodeled throughout. Great open floor plan perfect for entertainment guest and keeping an eye on the kids, yet the home still maintains room separation for privacy. Gorgeous kitchen featuring Quartz countertops, cabinets, SS appliances, and champagne accent finishes. Gorgeous Oak hardwood floors throughout the home. The Dinning room opens into the beautifully landscaped backyard and deck, great design for bbq with friends and family. Great size living room and cozy den. Beautiful wood floors throughout the home. Primary bedroom with beautiful bath and closet. This home\'s tranquil backyard is an amazing escape from the busy city. Updated Windows, Kitchen, both baths, backyard, and much, much more. Primary bedroom on the first floor. Never Flooded. See list of updates. Buyer to independently verify property condition, room sizes, deed restrictions, etc...' ,`Acres` = '0.1374' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 9 FOREST PINES SEC 2B' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5987' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Pines Sec 02b' ,`TaxAmount` = '5926' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700783' WHERE `Matrix_Unique_ID` = '210032410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '53734556' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.490549' ,`Longitude` = '-95.530193' ,`PhotoCount` = '48' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '1499000.00' ,`Status` = 'Active' ,`StreetName` = 'Sanctuary' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Trail' ,`City` = 'Missouri City' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LUXURIOUS CUSTOM ESTATE LOCATED IN ONE OF SIENNA\'S PRESTIGIOUS GATED COMMUNITIES! SITUATED ON A NEARLY 3/4 ACRE LOT W/FABULOUS LAKE AND GOLF COURSE VIEWS! YOU WILL BE IMPRESSED FROM THE MOMENT YOU ARRIVE! GORGEOUS FRONT ELEVATION W/TILE ROOF AND CIRCLE DRIVEWAY. DOUBLE DOORS LEAD TO A DRAMATIC ENTRY W/SOARING CEILINGS, DOUBLE STAIRCASES, CUSTOM CEILING TREATMENTS AND GRAND CHANDELIER. TERRIFIC FLOOR PLAN W/3 BEDROOMS DOWN, 2 OFFICES, MULTIPLE LIVING AREAS, GAMEROOM, MEDIA (BONUS) RM, WINE GROTTO AND SO MUCH MORE. LUXURIOUS MASTER SUITE, SPA-LIKE MASTER BATH W/OVERSIZED SHOWER, & HIS/HERS CLOSETS. MAGAZINE WORTHY DESIGNER DETAILS THROUGHOUT! GORGEOUS, PARK-LIKE BACK YARD W/RESORT STYLE POOL & HOT TUB, MULTIPLE SEATING AREAS, OUTDOOR KITCHEN AND TONS OF LAND. TERRIFIC FORT BEND SCHOOLS! RARE OPPORTUNITY TO LIVE IN THIS UNIQUELY MAGNIFICENT HOME WHICH IS ONE OF ONLY 12 HOMES LOCATED IN THIS EXCLUSIVE GATED COMMUNITY. CALL THE AIDA YOUNIS TEAM TODAY!' ,`Acres` = '0.6099' ,`Area` = '38' ,`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` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF WATERS LAKE SEC 11, BLOCK 1, LOT 5' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '26566' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3989' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCANLAN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '28887' ,`TaxRate` = '2.6079' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210118042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '80902292' ,`ListAgentFullName` = 'Gary Stallings' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.160295' ,`Longitude` = '-95.674420' ,`PhotoCount` = '47' ,`PostalCode` = '77362' ,`RoomCount` = '14' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Creek' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Court' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3909' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST REDUCED $30K !!! Beautiful Lennar home with almost 4000 SF, 5-Bedrooms 4.1 Baths Primary bedroom down, with a second bedroom down with a full bathroom. Formal dining room, Study, large island kitchen with granite countertops, 5-burner cooktop, single double wide inlay sink, butler’s pantry, all open to the family room. Primary bath with large walk-in closet granite vanity his and hers sinks, jetted tub, large walk-in shower. Family room fireplace with gas logs surround sound. Upstairs there are 3 bedrooms, Jack & Jill and one additional full bath. Large game room, media room, Sprinkler system, extended coved patio, no rear neighbors. Located in the highly acclaimed Tomball ISD. Woodtrace is a gated master-planned community by Friendswood Development with a 23-acre catch and Release Lake, community pool & clubhouse, a winding continuous jogging/walking trail throughout the subdivision, and Central Park, the community\'s newest amenity with parks, picnic areas, and doggie walk.' ,`Acres` = '0.2226' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S959402 - WOODTRACE 02, BLOCK 2, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '13595' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210181365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '85130588' ,`ListAgentFullName` = 'Ling Gao' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542231' ,`Longitude` = '-95.585709' ,`PhotoCount` = '31' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '548880.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Brook' ,`StreetNumber` = '4631' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never flood. This delightful two story high ceiling home sitting in Riverstone features beautiful traditional detailing. This energy-efficient house with 4 bedroom,Game room, media room, and study.. Gourmet kitchen with granite counter top, custom cabinets, SS appliances. Granite counter tops, patio cover. Walk distance to new elementary school, daycare.' ,`Acres` = '0.1704' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AUBURN MANOR AT RIVERSTONE SEC 1, BLOCK 2, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone' ,`TaxAmount` = '8806' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210229707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '77524006' ,`ListAgentFullName` = 'Karen Melgar' ,`ListOfficeName` = 'Boncler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.356804' ,`Longitude` = '-94.966355' ,`PhotoCount` = '22' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Sylvia St' ,`StreetNumber` = '1506' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction ready for immediate Move- In. This 1936 Sq. Ft. home features 3 bedroom, 2 baths and 2 car garage. Open concept with high ceilings and tile. It also features a beautiful Island Kitchen with Quartz countertops, 42-inch cabinets and all appliances. All bedrooms have ceiling fans, reset hand lights and closets have built in closet space. Hall bathroom has a jacuzzi tub and master bathroom offers double sinks and tiled shower. Utility room inside the house. Garage features an 8-foot windstorm approved garage door with 2 garage controllers. Everything is electrical with option to gas. Front porch is 16x7 and back patio 22x8 both beautifully tiled. Ready for new owners to stop by, view, and make it your own!!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'J & A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'L & S' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210504652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '41984405' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805749' ,`Longitude` = '-95.376295' ,`PhotoCount` = '41' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '615000.00' ,`Status` = 'Active' ,`StreetName` = 'Louise' ,`StreetNumber` = '508' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3213' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home located in highly sought-after Brooksmith/Heights. Home features 4 bedrooms, 4 baths, crown molding, recessed lighting, surround sound, a stunning spiral staircase & wood flooring throughout!! First floor living area, dining room & kitchen. Chefs kitchen boasts white cabinetry, Stainless steel appliance, a center island with pendant lights & plenty of cabinet space! Kitchen opens to the living area that has a beautiful fireplace with built-in cabinets and shelving surrounding. Primary suite with en-suite spa like bath, dual sinks, a soaking tub, separate shower and huge closet! The main bedroom & 2 additional bedrooms are on the 2nd floor, 4th bedroom is on the 3rd floor with a bath. Fenced in back yard green space! Near The Heights restaurants, shops, parks and a convenient location to downtown. This is a must see!!' ,`Acres` = '0.0652' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 CASTONE COURT AT LOUISE STREET' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2839' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Castone Court/Louise Street' ,`TaxAmount` = '15190' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210513151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '53478079' ,`ListAgentFullName` = 'Alfred Castillo' ,`ListOfficeName` = 'Brecker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770512' ,`Longitude` = '-95.039689' ,`PhotoCount` = '41' ,`PostalCode` = '77520' ,`RoomCount` = '5' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakewood' ,`StreetNumber` = '300' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'There’s remodeling and there’s REMODELING… There’s levels to this and the quality of material and workmanship are evident in this one! Converted this 3 Bed/1.5 Bath home to 4 Bed/2 Full bath featuring NEW roof, NEW A/C, NEW windows, ALL NEW Sheetrock, ALL NEW trim/baseboards/crown-molding, NEW electrical panel AND WIRING throughout, ALL NEW PLUMBING INSIDE WALLS & UNDER FOUNDATION, CUSTOM wood cabinets w/ soft-close AND granite counters in kitchen & bathrooms, stainless steel GE appliances, recessed lighting, NEW TANKLESS WATER HEATER, all situated on a 19,000+ square foot corner lot in the UNRESTRICTED Lakewood community. No HOA. Low taxes. This is THE ONE!' ,`Acres` = '0.4461' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 LAKEWOOD SEC A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19434' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Lakewood' ,`TaxAmount` = '4798' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210581004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '45541400' ,`ListAgentFullName` = 'Andrew Githens' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072078' ,`Longitude` = '-95.165180' ,`PhotoCount` = '33' ,`PostalCode` = '77345' ,`RoomCount` = '7' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Splintwood' ,`StreetNumber` = '2534' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stately all brick home has an attached 2 car garage. You will find a well-manicured landscaped front yard and fenced in back yard. The grand entrance with ceilings and a beautiful staircase. Large living room with a gas fireplace and an entrance to the back yard. Kitchen is open to the living room and has stainless steel appliances, double sink, and plenty of counter space and cabinets. There is also a dry bar area with wine rack. The primary bedroom is on the first floor which features a primary bath with a separate tub and shower along with a large walk-in closet. There is also another good-sized bedroom on the first floor. The staircase leads to a large open area with arched windows which can be used as a second living area. There are 3 more large bedrooms and baths for guests and family. A media room for fun nights of watching TV or just enjoying the time together. Plenty of room for growth in this gorgeous house. Stop by today!' ,`Acres` = '0.1928' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 2 VILLAGES OF RIVERCHASE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Riverchase Sec 01' ,`TaxAmount` = '10780' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210693568' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '19051988' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817125' ,`Longitude` = '-95.295175' ,`PhotoCount` = '16' ,`PostalCode` = '77028' ,`RoomCount` = '3' ,`ListPrice` = '194000.00' ,`Status` = 'Active' ,`StreetName` = 'Miley' ,`StreetNumber` = '7409' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful house was remodeled in 2020, with updated kitchen and baths! It\'s a 3 Bed/ 2 Bath house with Natural Lighting, updated appliances and fixtures. Huge primary bedroom with glass shower doors. A great backyard with a cover patio perfect to spend the afternoons there.' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 9 HOMESTEAD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCGOWEN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Homestead Sec 02' ,`TaxAmount` = '1538' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700784' WHERE `Matrix_Unique_ID` = '210777080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '64046775' ,`ListAgentFullName` = 'Cynthia Cook' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671002' ,`Longitude` = '-95.469407' ,`PhotoCount` = '37' ,`PostalCode` = '77096' ,`RoomCount` = '12' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Balmforth' ,`StreetNumber` = '10106' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Mid-Century/Modern, elevated home was completely renovated in 2019. Located in the heart of Meyerland, walking distance to Kolter & Godwin Park and zoned to Bellaire High School. This 4 bedroom, 2.5 bath home has plenty of natural light with an open concept family, kitchen, & dining area with magnificent views of the backyard, patio, and pool. A gas log fireplace located in the family room is surrounded by exquisite, stacked stone. The vast primary bedroom includes a sitting area with remote control fireplace and private door to backyard deck with a luxurious ensuite boasting dual vanities with a large shower, separate soaking tub, and wonderful walk-in closet. The kitchen hosts an extra-large island, stainless steel appliances, with a generous amount of counter space for entertaining. Gold embellished backsplash enhances the beauty of the kitchen. This home is a must see!' ,`Acres` = '0.258' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 12 MEYERLAND SEC 8 R/P F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11238' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '588' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Meyerland Sec 08 R/P F' ,`TaxAmount` = '10335' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700785' WHERE `Matrix_Unique_ID` = '210894222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '66041695' ,`ListAgentFullName` = 'Lina Botero' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906570' ,`Longitude` = '-95.717149' ,`PhotoCount` = '42' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Horizon' ,`StreetNumber` = '8839' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY HOME-Zoned to acclaimed CY-FAIR SCHOOLS. BEAUTIFUL HOME ON AN EXTRA LARGE LOT OF 14186 SQFT AND LOADED with must have UPGRADES, soaring ceilings, recess lights, engineering flooring (EVP) downstairs, Open concept kitchen; granite counter tops, designed backsplash and Island seating, dining & Family room. Primary suite down; Guests/Mother-in-law down, full bath down, wrought iron spindle, gameroom up, suite with private bathroom-upstairs. SMART LOCK, SMART SECURITY SYSTEM, TANKLESS WATER HEATER, REVERSE OSMOSIS WATER SYSTEM, WATER SOFTENER-ALL INCLUDED, jellyfish-outdoor lighting INCLUDED, wrap around gutters, French drain, Covered patio with ceiling fan & extended flooring. BIG lot with enough room for a pool. -Amenities; Pool, walking trails, playground, recreation center, tennis, sand volleyball, dog park. Full access to Stone Gate/Canyon Lakes Amenities (Jr. Olympic Pools, basketball pavilion, exercise room). It has a lot to offer. A great place to call HOME.' ,`Acres` = '0.3257' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 MIRAMESA SEC 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '14186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Miramesa Sec 5' ,`TaxAmount` = '10119' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700785' WHERE `Matrix_Unique_ID` = '210908847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '46331469' ,`ListAgentFullName` = 'Cristy Campobella' ,`ListOfficeName` = 'Home Sweet Home RE Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.340545' ,`Longitude` = '-95.368117' ,`PhotoCount` = '38' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Hills' ,`StreetNumber` = '1468' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new Home Sweet Home nestled away in a country setting on just over 2 Unrestricted acres! This gorgeous property has a unique home that is ready for some TLC. It is being sold AS IS with so much potential! Significant remodeling has been completed on the first floor with an updated kitchen and bath. There is neutral paint throughout the home and a walk in closet in the master bedroom. The property has a well but public water is available if desired. Come add your finishing touches to make this peaceful setting a place to call home! Unrestricted property won\'t last long, so bring your offers quickly!' ,`Acres` = '2.074' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROLLING HILLS, LOT 47, ACRES 2.074' ,`LotDesciption` = 'Other' ,`LotSize` = '90343' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Hills' ,`TaxAmount` = '1527' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700785' WHERE `Matrix_Unique_ID` = '210920692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '65369931' ,`ListAgentFullName` = 'Christie Vu' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667705' ,`Longitude` = '-95.596073' ,`PhotoCount` = '32' ,`PostalCode` = '77099' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Longbrook' ,`StreetNumber` = '12122' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This home features 4 bedroom and 3 full baths with wood and tile flooring throughout. 3 bedrooms are located downstairs and 1 bed and 1 full bath upstairs. AC replaced in 2020, gutters with screens replaced in 2018, whole interior painted 2022, and washer and dryer included. Kitchen remodel completed in 2022 includes kitchen new countertop, backsplash, and stove. Schedule your appointment today!' ,`Acres` = '0.1742' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 7 HUNTINGTON VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '177' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Village Sec 01' ,`TaxAmount` = '4326' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700785' WHERE `Matrix_Unique_ID` = '210928739' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '36808168' ,`ListAgentFullName` = 'Natasha Simon' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462540' ,`Longitude` = '-95.247283' ,`PhotoCount` = '47' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Line' ,`StreetNumber` = '300' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'READY TO MOVE-IN! The beautiful Saratoga Homes, Rylan plan is on the water on a corner lot with almost 3000 sqft with an extended covered patio. This home features 5 bedrooms, 4 full baths and a 2 car garage. This home offers 2 bedrooms and 2 FULL bathrooms down. The open kitchen includes a large island and breakfast area that opens to the family room and great for entertaining. At the entry you will find the formal dining room for family time overflow. The primary bedroom comes standard with the separate tub and shower. Upstairs you will find 3 additional bedrooms, 2 additional full baths and an oversized gameroom. Call for your showing today it will not last long!' ,`Acres` = '0.1583' ,`Area` = '5' ,`BuilderName` = 'SARATOGA HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KENDALL LAKES SEC 2 (A0482 H T & B)(ALVIN) BLK 1 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6896' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Kendall Lakes Sec 2' ,`TaxAmount` = '1236' ,`TaxRate` = '3.5854' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700785' WHERE `Matrix_Unique_ID` = '210983302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '6320120' ,`ListAgentFullName` = 'Shana Lunsford' ,`ListOfficeName` = 'Mills Family Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599384' ,`Longitude` = '-95.227558' ,`PhotoCount` = '30' ,`PostalCode` = '77089' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkwell' ,`StreetNumber` = '11019' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful two-story home in Kirkwood South. This spacious 4 bedroom 2 1/2 bath home has high ceilings, fireplace, a beautiful kitchen open to dining and living area, even a wet bar. The covered patio, water fountain, and above ground pool in backyard makes for great entertaining. No back neighbors. Quick access to Sam Houston Tollway and Interstate 45 for your commute.' ,`Acres` = '0.1653' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 & TRS 15A & 17A KIRKWOOD SOUTH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkwood South' ,`TaxAmount` = '4671' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700785' WHERE `Matrix_Unique_ID` = '211070063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '92521997' ,`ListAgentFullName` = 'Nelda Cedeno' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152823' ,`Longitude` = '-95.165022' ,`PhotoCount` = '16' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Ada' ,`StreetNumber` = '20100' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3099' ,`Area` = '40' ,`BuilderName` = 'Hernandez Construct' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S741003 - NEW CANEY HEIGHTS 03, BLOCK B, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'New Caney Heights 03' ,`TaxAmount` = '95' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663700785' WHERE `Matrix_Unique_ID` = '211209007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T01:22:01.110' ,`MLSNumber` = '73724365' ,`ListAgentFullName` = 'Karla Arias' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707495' ,`Longitude` = '-95.674107' ,`PhotoCount` = '15' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Soledad' ,`StreetNumber` = '6419' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story, MOVE-IN ready home waiting for you! Open floor plan for entertaining and family gatherings. All new interior paint and SPC flooring throughout entire home. The kitchen is equipped with stainless steel appliances , abundant cabinet space, granite, and a breakfast bar. Easy access to Highway 6 and Westpark Tollway. Close to nearby shopping centers and restaurants. Make this house your home! SHOWINGS BEGIN AFTER THE OPEN HOUSE' ,`Acres` = '0.1268' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 2 MISSION BEND NORTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'PETROSKY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend North' ,`TaxAmount` = '3564' ,`TaxRate` = '2.312' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700786' WHERE `Matrix_Unique_ID` = '211329674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T00:08:20.770' ,`MLSNumber` = '70200232' ,`ListAgentFullName` = 'Wenrong Shi' ,`ListOfficeName` = 'Lei & Associates, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027128' ,`Longitude` = '-95.555976' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial Hills' ,`StreetNumber` = '9003' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4175' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Executive Sun-filled 6 Bedrooms 3.5 baths home in the Memorial Creek Estates. Features a 2-story foyer with an open floorplan filled with plenty of natural lighting. The 2-story entry offers views of the backyard! Entertaining is a breeze with the gracious formals, generous living spaces with fireplace! primary retreat with primary bath on the first floor.5 bedrooms with 2 full bathrooms and game room up! 3-car garage. Huge lot. Community Recreation include a pool, playground. Never flooded! Easy to access Hwy249, Must see!' ,`Acres` = '0.2354' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 MEMORIAL CREEK ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '556' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Creek Estates Sec 02' ,`TaxAmount` = '7895' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700786' WHERE `Matrix_Unique_ID` = '211544372' --> Updated record success