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-10-29T21:49:31.537' ,`MLSNumber` = '42648934' ,`ListAgentFullName` = 'Carson Deer' ,`ListOfficeName` = 'Capital Real Estate Commercial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295719' ,`Longitude` = '-94.913946' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '1249000.00' ,`Status` = 'Active' ,`StreetName` = 'Hawaii' ,`StreetNumber` = '1239' ,`StreetSuffix` = '' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing location on Tiki Island situated on the equivalent of 3 lots. Includes a convenient outdoor elevator. Side, fenced in dog yard with stairs to let the dogs out without going downstairs. Over 180\' of waterfront bulkhead! One of the last houses on 3 lots in Tiki. Huge covered downstairs area, waterfront entertaining space. There is plenty of room to build out a bar, lounge area, enclosed garages or anything else you can dream up. Cool deck recently applied to all concrete areas on the driveway and under the house.\r\n\r\nPlenty of bulkhead for up to a 70\' yacht!' ,`Acres` = '0.379' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOTS 37 THRU 39 TIKI ISLAND' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '16509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Convection Oven,Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '34 - La Marque' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118496' WHERE `Matrix_Unique_ID` = '202094643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:50:48.533' ,`MLSNumber` = '53165271' ,`ListAgentFullName` = 'Trinika Chachere' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.317268' ,`Longitude` = '-95.457249' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland' ,`StreetNumber` = '939' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*SEE ATTACHMENTS for Brochure! Gorgeous Custom New Construction on 1 Acre Lot! Located in The Oaks at Suncreek Estates, country feel with the convenient to 288 and Hwy 6. Put an Offer in Now and select from paint colors to countertops, and flooring from builder\'s selection. This Gorgeous Custom Built Home with 4 bedrooms, 3.5 bathrooms with a Grand Open Concept Kitchen and Family Room Area. Amazing fixtures and finishes. High ceiling and Grand Entrance. Oversized Master Bedroom and Bathroom made to wow with 2 primary closets. Natural light shines throughout the home with views of the acreage lot. Built with a Large Outdoor Kitchen with Grill and Sink. This home is built for entertaining, built as your 1st or last home. Come and Drive by Your Dream Home! \r\nBuilding begins October 2022.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = 'Baker\'s Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE OAKS AT SUNCREEK ESTATES (A0067 & A0068 & A0069) BLK 3 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Oaks At Suncreek Estates' ,`TaxAmount` = '755' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667118496' WHERE `Matrix_Unique_ID` = '205202295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:22:52.820' ,`MLSNumber` = '52664968' ,`ListAgentFullName` = 'Trinh Tran' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839008' ,`Longitude` = '-95.682217' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '323000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakhampton' ,`StreetNumber` = '18307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF 10/2022! Nice and cozy 4 bedrooms with primary room downstairs. 2 bathrooms upgraded 2021. House painted and new carpet replaced 2021. Plenty spaces with long driveway to detached garage for parking spaces. Hug room for outdoor party in the backyard. This house won’t last long! Call agent today to make appointment.' ,`Acres` = '0.2066' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 40 DEERFIELD VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 04' ,`TaxAmount` = '5115' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118497' WHERE `Matrix_Unique_ID` = '207160295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:01:23.150' ,`MLSNumber` = '11894569' ,`ListAgentFullName` = 'Dan Mays' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.824706' ,`Longitude` = '-95.106915' ,`PhotoCount` = '20' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'Georgia Way' ,`StreetNumber` = '179' ,`StreetSuffix` = 'Road' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1292' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained home! New Roof, Heat/AC, updates in 2020. Close to schools and Lake Livingston. Home sits on two lots with a fully fenced yard w/double gate access. Great for RV/boat parking. Inside city limits with sewer and water. Extra room could be used as office/utility/4th bedroom. Large covered deck. Great outbuilding located on front of property next to carport parking. Outbuilding is plumbed with 1/2 bath, window unit air conditioner. Could be used as a private office/getaway. This home is a must see!' ,`Acres` = '0.1722' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'PINE RIDGE LOT 5 and 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pine Ridge' ,`TaxAmount` = '1295' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118497' WHERE `Matrix_Unique_ID` = '209534607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:19:35.383' ,`MLSNumber` = '48099943' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701869' ,`Longitude` = '-95.706565' ,`PhotoCount` = '31' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '316990.00' ,`Status` = 'Active' ,`StreetName` = 'Blackpool Bend' ,`StreetNumber` = '19006' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction-The Caden Plan by D.R. Horton! Dramatic Chic Elevation! Upon Entry of this lovely 3 Bedroom 2 Full Bathroom home you are greeted with Upgraded Luxurious Wood Vinyl Plank Flooring which leads the path into the Casual Dining Room & the Gourmet Kitchen with Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in Working Island w/Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets, Subway Tile Glass Backsplash & more! Amazing Family Room w/Wall of Windows overlooking Covered Patio! The Private Owner\'s Suite with Luxurious Bath featuring Dual Sink Vanity, Huge Shower & Huge Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allowing you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & more from anywhere!! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 59 /Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667118497' WHERE `Matrix_Unique_ID` = '209702451' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:39:10.783' ,`MLSNumber` = '33050130' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701850' ,`Longitude` = '-95.706387' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '6814' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction almost Completed! The Easton by D.R.Horton! Chic Stucco & Brick Elevation! Open the door and you are greeted with High Ceilings, Grand Entry & Upgraded Vinyl Wood Plank Flooring that leads the way into your Casual Dining Room & Amazing Family Room with Wall of Windows overlooking your Covered Rear Patio! Family Room flows gracefully into the Casual Dining & Gourmet Kitchen with Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Island W/Under-mount Stainless Sink, Stainless Steel Appliances, Tall Beautiful Shaker Cabinets & Walk In Pantry! The Owner\'s Suite features Plush Carpeting & Luxurious Bath w/Cultured Marble Vanity, His & Her Undermount Sinks, Oversized Shower, Deep Soaking Tub & Walk-in Closet! 3 Guest Bedrooms! Energy Efficient Home Rated HERS Energy, Tankless/On-Demand H2O Heater! \"Smart Home Automation allows you to control lighting, deadbolt locks, thermostat & Control from anywhere! NO FLOODING! Wonderful Amenities! Just 20mins to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 19 / Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667118497' WHERE `Matrix_Unique_ID` = '209717855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:16:24.820' ,`MLSNumber` = '93009369' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702043' ,`Longitude` = '-95.706274' ,`PhotoCount` = '27' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '327990.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '6818' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New One story Ranch Style home-The Foster by D.R. Horton! Amazing Timeless Chic Elevation with Stucco & Brick Elevation! Stunning Entry W/Gorgeous Vinyl Wood Large Plank Flooring throughout! The Casual Dining Room & Family Area flows gracefully into the Fabulous Gourmet Kitchen! Gourmet Kitchen is a Chef\'s dream W/ Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Island with Deep Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets & more! The Private Owner\'s Suite with Luxurious Spa Bathroom W/Cultured Marble Vanity Counters, His & Her Undermount Sinks, Massive Shower W/Seamless Glass Door, Walk-in Closet! 3 Guest Bedrms & More! Covered Patio! Outstanding Energy Features HERS Energy Rated & Tankless/On-Demand H2O Heater that you will never run out of Hot Water! \"Smart Home Automation\" Control your home from Almost anywhere w/Echo & Dot! NO FLOODING! Amenities include: Pool, & Splash Pad! Just 20 minutes to The Galleria' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 20 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667118497' WHERE `Matrix_Unique_ID` = '209744620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:31:45.317' ,`MLSNumber` = '80690799' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = 'James Swain' ,`SellingOfficeName` = 'The Chief Realty Group' ,`Latitude` = '29.067739' ,`Longitude` = '-95.423122' ,`PhotoCount` = '25' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Candlewood' ,`StreetNumber` = '56' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bath home boasts over 1500 sqft and sits on on a cul-de-sac with a huge yard! Totally remodeled this home features wood like tile floor throughout and a large stone gas fireplace. The farmhouse kitchen showcases tons of cabinet storage, a copper sink, and all stainless steel appliances. Great sized rooms and a large covered patio with privacy fenced backyard make this the perfect hangout spot and place to entertain your guest. Schedule a tour today and take a look at all the upgrades this home has to offer.' ,`Acres` = '0.3181' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Richwood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TAMARIND WOODS (A0066 J E GROCE) BLK 1 LOT 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13857' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'SHERWOOD/TAMIRIND WDS' ,`TaxAmount` = '3651' ,`TaxRate` = '1.998124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118498' WHERE `Matrix_Unique_ID` = '210068706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:07:01.183' ,`MLSNumber` = '67946284' ,`ListAgentFullName` = 'Megan Donaldson' ,`ListOfficeName` = 'Megan Donaldson, Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945077' ,`Longitude` = '-95.201653' ,`PhotoCount` = '22' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '437000.00' ,`Status` = 'Active' ,`StreetName` = 'Falkirk Green' ,`StreetNumber` = '15403' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED! MOTIVATED SELLER! Gated Section! Beauty! Unique! Bedrooms Galore! 4 Full Baths on 10,000+ Lot sizes. 2nd Full Bedroom downstairs; optional study! Spacious for a private pool! Balmoral in Humble offers residents the exclusivity of gated living in a community where the amenities are second to none. Enjoy the world-class Crystal Lagoon, the first of its kind in TX, with a zero-entry pool, trail system, & parks throughout. This stunning 6-bedroom, 4-bath Boxwood plan is the first of its kind in Houston & has space for everyone and everything! Enjoy a movie night in the enclosed media room, host a marathon game night in the game room, or have a large dining or a large outdoor dinner under the long-strength Patio with dining. The entertainment opportunities are endless. A chef will love the stainless-steel appliances, quartz countertops, 42\" white cabinetry with crown molding, islander & walk-in corner pantry. Come and see for a private tour! Let us show you the Lagoon!' ,`Acres` = '0.2298' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 BALMORAL SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10011' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral Sec 3' ,`TaxAmount` = '10667' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118498' WHERE `Matrix_Unique_ID` = '210661841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:16:01.733' ,`MLSNumber` = '39698054' ,`ListAgentFullName` = 'Amanda Whitehorn' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.250625' ,`Longitude` = '-95.862601' ,`PhotoCount` = '32' ,`PostalCode` = '77484' ,`RoomCount` = '4' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodforest' ,`StreetNumber` = '17238' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous CUSTOM home offers upgrades galore! It sits on 2 acres in the highly sought-after neighborhood of Plantation Lakes-just enough land to offer privacy and still easily maintain. The living room is a show-stopper filled with natural light, built in cabinetry & a beautiful wood burning fireplace surrounded by floor to ceiling travertine. This kitchen is a cook\'s dream-double pantries, 6 burner stove, quartz countertops, under cabinet lighting, soft close drawers and cabinet doors. The screened in porch offers the opportunity to have your morning coffee or relax after work while enjoying the peacefulness of country living. The media room has a projector and 10x6 ft. projector screen that come with the home. The home boasts glazed porcelain tile (except in bathrooms) & wood plantation shutters throughout. Plantation Lakes features lakes, a park, a large playground, a clubhouse and covered pavilion, a horse barn and riding trails with low HOA fees. This one won\'t last!' ,`Acres` = '2.006' ,`Area` = '60' ,`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` = 'Plantersville Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S7671 - PLANTATION LAKES SEC. 4, BLOCK 1, LOT 4, ACRES 2.006' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '87381' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Lakes Sec 4' ,`TaxAmount` = '7290' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667118498' WHERE `Matrix_Unique_ID` = '210794254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:01:51.273' ,`MLSNumber` = '14571528' ,`ListAgentFullName` = 'Chase Giles' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Charlotte Vanheusden' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.219074' ,`Longitude` = '-95.426575' ,`PhotoCount` = '40' ,`PostalCode` = '77385' ,`RoomCount` = '7' ,`ListPrice` = '238000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fallen Timbers' ,`StreetNumber` = '16779' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW AC UNITS INSIDE & OUT WITH NEST THERMOSTAT, NEVER-FLOODED, WOOD-LOOK TILE FLOORS IN MAIN AREAS, NEW CARPET IN THE BEDROOMS, FRESH INTERIOR PAINT, TANKLESS WATER HEATER, WASHER/DRYER/REFRIGERATOR/MICROWAVE INCLUDED, EXTRA FRONT DRIVEWAY PARKING PAD, SMART LOCK FRONT DOOR and RING DOOR BELL, NO HOA & ZONED TO CONROE ISD. Three Bedroom Split Plan with Primary En-suite Bath, Large Eat-in Dining, Washer & Dryer inside the home, Fenced backyard, extra patio space & storage shed, and lemon & lime trees. Water Filter System is located in the garage. ** Located off FM 242 East, minutes to I-45, Hospitals, Exxon Campus, Market Street, Costco and HEB!' ,`Acres` = '0.1515' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GLENEAGLES 04, LOT 272' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleneagles 04' ,`TaxAmount` = '3571' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118498' WHERE `Matrix_Unique_ID` = '210806103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:01:11.000' ,`MLSNumber` = '89213258' ,`ListAgentFullName` = 'Ashlee Cooper' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461332' ,`Longitude` = '-95.549142' ,`PhotoCount` = '0' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Conroe Bay' ,`StreetNumber` = '12752' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1749' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1235' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S888300 - SORRENTO BAY 01, BLOCK 1, LOT 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5381' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sorrento Bay 01' ,`TaxAmount` = '3473' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667118498' WHERE `Matrix_Unique_ID` = '211194874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:56:47.100' ,`MLSNumber` = '35814820' ,`ListAgentFullName` = 'Neal Green' ,`ListOfficeName` = 'Martin & Black Real Estate LLC' ,`SellingAgentFullName` = 'Jennifer Flud' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.485476' ,`Longitude` = '-95.203243' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '12' ,`ListPrice` = '1184900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grace' ,`StreetNumber` = '1832' ,`StreetSuffix` = 'Crossing' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Sterling built home located in the Sterling Creek community! The immaculate home boast some of the best that Sterling has to offer with a lot that\'s perfectly positioned behind the acreage lots of San Joaquin, offering you additional privacy. This home is a masterpiece of elegance and livability. Features include: stucco exterior with black roof and trim accents. The interior has a two story entry ceiling & a winding staircase that leads to the study. The picture windows in the living offer a great view of the backyard from the moment you walk into the home. The chef\'s kitchen opens to the living & breakfast area and offers a large island with lots of seating, quartz countertops, 8 gas burners, built-in fridge & quartz backsplash. The breakfast offers a built-in butler\'s pantry. The primary bedroom w/accent wall with a wall insert fireplace. The primary bath offers a soaker tub, walk thru shower, double vanities, 2 walk in closets, hurricane window coverings, plus more…' ,`Acres` = '0.2789' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 1 STERLING CREEK SEC 4 (2021) ABST 69' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sterling Creek Sec 4' ,`TaxAmount` = '7505' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118499' WHERE `Matrix_Unique_ID` = '211303662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:02:38.277' ,`MLSNumber` = '52382762' ,`ListAgentFullName` = 'Mariela Knapp' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194373' ,`Longitude` = '-95.511219' ,`PhotoCount` = '22' ,`PostalCode` = '77381' ,`RoomCount` = '10' ,`ListPrice` = '835000.00' ,`Status` = 'Active' ,`StreetName` = 'Flagstone' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Path' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3367' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning house for sale, excellent update house is rare to find. 4 or 5 bedrooms and four and a half bathrooms. Three bedrooms upstairs and principal rooms downstairs. Lovely casita outside with full bathroom, close to the garage could be for the in-laws or the teenagers. This house has so many great spacious like a big backyard, the extra room upstairs you can use for office or texas baseman. The sellers need 15 days of leaseback. Great location and great schools. No carpet in the house. The AC update 2018 for both units. The kitchen was updated with appliances. Please see the list on MLS' ,`Acres` = '0.26' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S972242 - WDLNDS VIL COCHRANS CR 42, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr' ,`TaxAmount` = '10864' ,`TaxRate` = '2.1269' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118499' WHERE `Matrix_Unique_ID` = '211503073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:41:57.880' ,`MLSNumber` = '72695822' ,`ListAgentFullName` = 'Famen Wolf' ,`ListOfficeName` = 'Wolf Realty' ,`SellingAgentFullName` = 'Kalen Isas' ,`SellingOfficeName` = 'Jane Byrd Properties INTL.' ,`Latitude` = '29.736027' ,`Longitude` = '-94.838733' ,`PhotoCount` = '35' ,`PostalCode` = '77523' ,`RoomCount` = '13' ,`ListPrice` = '699900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'North Point' ,`StreetNumber` = '9071' ,`StreetSuffix` = 'Drive' ,`City` = 'Beach City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED 40k FOR QUICK SALE! Updates Galore!! Beautiful 1 story with pool on 1.95 acres. Since 2021, the owners have installed a new roof, new floors, new paint, new dishwasher, new water heaters, new water filtration system, LED lights, ceiling fans in all the rooms, new plantation shutters throughout home, solar screens, etc. The seller’s are estimating 50k-60k in improvements over the past year. Additionally, there is a pool bath adjacent to the back patio & a carport off the garage for more parking. Plenty of room to build a shop/man cave/she shed! You will love the Barbers Hill Schools, 3 car garage, cul-de-sac street and quiet gated waterfront community of North Point.' ,`Acres` = '1.954' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '18 NORTH POINT ON TRINITY BAY' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '85116' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'North Point Trinity Bay' ,`TaxAmount` = '7178' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118499' WHERE `Matrix_Unique_ID` = '211801587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:48:10.087' ,`MLSNumber` = '75101883' ,`ListAgentFullName` = 'Crystal Lucas' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054199' ,`Longitude` = '-95.567187' ,`PhotoCount` = '41' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '509900.00' ,`Status` = 'Active' ,`StreetName` = 'Empress Crossing' ,`StreetNumber` = '9634' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home located in the highly sought-after Gleannloch Farms. This wonderful 4 bedroom, 3.5 bath home has all the features you are looking for. A gourmet style kitchen with tons of countertops and cabinet space. The open floor plan was designed for entertaining. Not your standard size bedrooms on the second floor. The rooms are oversized and can hold just about any size of furniture. Why go on vacation when you have your own tropical paradise in your private backyard. Lush landscaping and no back neighbors make this place pretty private. Make sure you add this one to your list to see!' ,`Acres` = '0.1974' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 GLEANNLOCH FARMS SEC 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 38' ,`TaxAmount` = '10050' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118499' WHERE `Matrix_Unique_ID` = '211829236' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:53:29.370' ,`MLSNumber` = '75715925' ,`ListAgentFullName` = 'Tasha Bason' ,`ListOfficeName` = 'Steel Door Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.266522' ,`Longitude` = '-94.902745' ,`PhotoCount` = '29' ,`PostalCode` = '77327' ,`RoomCount` = '17' ,`ListPrice` = '1690000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2293' ,`StreetNumber` = '1270' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '11' ,`SqFtTotal` = '5729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Turn Key Assisted Living Facility! Perfect for Adult Care, Foster Care, Hospice Care, Therapy, Rehab and more! \r\n11 bedrooms that can sleep 24+ adults, 3 Full baths 2 1/2 baths, ADA compliant, wired for fire safety and sprinklered. Kitchen features double oven, 2 dishwashers, 2 refrigerators, 2 sinks and a large pantry. 2 laundry areas in facility, 3 separate gathering areas with a door to separate if desired. Zoned Commercial with sprawling 32 acres, completely fenced in with a large barn and coop, ponds, as well as 2 beautiful horses that can convey.' ,`Acres` = '32' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000407 WM WHITE, TRACT 23, ACRES 10.0' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '1393920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wm White' ,`TaxAmount` = '6914' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118499' WHERE `Matrix_Unique_ID` = '212174407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:23:20.853' ,`MLSNumber` = '60235070' ,`ListAgentFullName` = 'Alicia Grifaldo' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138876' ,`Longitude` = '-95.559964' ,`PhotoCount` = '48' ,`PostalCode` = '77375' ,`RoomCount` = '14' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Twig Corner' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3379' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous move-in ready M/I Home on a HUGE cul-de-sac lot in the friendly & quiet Woodlands community that offers great amenities, & quick access to Burroughs Park, & I45. This homes curb appeal begins w/ the manicured lawn, lush landscaping, & the stylish brick/stone elvaction. Inside find an open & airy floorplan featuring soaring ceilings, tile/wood floors, fresh paint, & an abundance of natural light throughout. A dedicated home office w/ French doors lead to the formal dining area & open to the large living room w/ floor-to-ceiling windows, a fireplace, & a half bath. The eat-in kitchen boasts granite counters, SS appliances, a pantry, & an island. The 1st floor primary bedroom includes a lux en-suite bath w/ dual vanities, modeling mirror, & a sizable walk-in closet. Upstairs find a huge game room w/ a built-in study nook, a separate media room, & 3 secondary bedrooms that share 2 full baths. Don\'t forget to see the fully fenced backyard & covered patio perfect for adding a pool!' ,`Acres` = '0.2786' ,`Area` = '14' ,`BuilderName` = 'MI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 2 THE WOODLANDS CREEKSIDE PARK WEST SEC 22' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodlands Creekside Park West' ,`TaxAmount` = '12053' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118500' WHERE `Matrix_Unique_ID` = '212210677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:45:23.873' ,`MLSNumber` = '26428562' ,`ListAgentFullName` = 'Famen Wolf' ,`ListOfficeName` = 'Wolf Realty' ,`SellingAgentFullName` = 'Robin Bailey' ,`SellingOfficeName` = 'RE/MAX Associates Northeast' ,`Latitude` = '30.049527' ,`Longitude` = '-95.141723' ,`PhotoCount` = '16' ,`PostalCode` = '77345' ,`RoomCount` = '11' ,`ListPrice` = '499900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Peachtree Hill' ,`StreetNumber` = '6106' ,`StreetSuffix` = 'Court' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kings Point! Newer Roof, Cul-de-sac street with Greenbelt entrance. Master down, 3 car garage, open floor plan, 3.5 baths, game room up, etc. Beautiful stone elevation, lush landscaping, Original Owner & well taken care of. Never flooded & flood insurance is not required.' ,`Acres` = '0.2576' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 KINGS POINT VLG 10 2ND PAR R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11221' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Point Village 10 02 Prcl' ,`TaxAmount` = '10690' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118500' WHERE `Matrix_Unique_ID` = '212293224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:31:08.613' ,`MLSNumber` = '9677273' ,`ListAgentFullName` = 'Samantha Medve' ,`ListOfficeName` = 'Schultz Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153192' ,`Longitude` = '-96.690400' ,`PhotoCount` = '21' ,`PostalCode` = '78932' ,`RoomCount` = '2' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Hill' ,`City` = 'Carmine' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable barndominium is located under tree shade. There are some beautiful oak trees that frame the driveway and yard. The home was built in 2017 and remodeled in 2022. Updates include, new kitchen cabinets and hardware, new refrigerator, new dishwasher, new microwave, new range, new washer and dryer, new toilet and new water heater. Pex piping was also added and the home has had new vinyl flooring installed.\r\n\r\nBoth bedrooms have closets. The open floor plan makes the home feel larger. Some furniture can convey in the house.\r\n\r\nThis home is about 5-10 min from Round Top and located within about 1 mile of JWs in Carmine.\r\n\r\nBuyer to verify dimensions.' ,`Acres` = '0.472' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ULLRICH ADDITION LOT 1, .472 ACRES, HSE, C/PORT' ,`LotDesciption` = 'Other' ,`LotSize` = '20560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '206 - Round Top-Carmine' ,`SchoolElementary` = 'ROUND TOP-CARMINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROUND TOP-CARMINE HIGH SCHOOL' ,`SchoolMiddle` = 'ROUND TOP-CARMINE HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Ullrich Add' ,`TaxAmount` = '1337' ,`TaxRate` = '1.4344' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118500' WHERE `Matrix_Unique_ID` = '212444810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:22:49.823' ,`MLSNumber` = '75046097' ,`ListAgentFullName` = 'Alicia Grifaldo' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.972866' ,`Longitude` = '-95.554835' ,`PhotoCount` = '29' ,`PostalCode` = '77070' ,`RoomCount` = '11' ,`ListPrice` = '287000.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Lago' ,`StreetNumber` = '8014' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Owners are selling due t moving out of the country for job relocation. They have absolutely loved to home but unfortunately have to move. Contemporary/modern Colima Homes in the quiet Villas at Willowbrook community includes a park, pool, & quick access to Houston Methodist Hospital, tons of shopping, & HWY 249. Once inside you are welcomed by an open-concept layout featuring trendy decorative lighting, recent laminate flooring, & tons of natural light. On the 1st floor find the perfect entertaining space that includes a spacious living room w/ an accent wall, a formal dining area, & a large kitchen w/ granite counters, SS gas appliances, ample cabinet storage, & bar seating. A convenient half bath & well-sized utility room complete the main floor. Upstairs offers flex space for a home office/playroom that leads into the BIG primary bedroom w/ a double sink en-suite bath & sizable walk-in closet. 3 secondary bedrooms w/ a full bath & a cozy backyard space completes this home.' ,`Acres` = '0.0546' ,`Area` = '13' ,`BuilderName` = 'Colima Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 VILLAS AT WILLOWBROOK' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Villas/Willowbrook' ,`TaxAmount` = '5207' ,`TaxRate` = '2.4087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118500' WHERE `Matrix_Unique_ID` = '212641757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:08:32.770' ,`MLSNumber` = '10260170' ,`ListAgentFullName` = 'Kenya Jackson' ,`ListOfficeName` = 'JNR' ,`SellingAgentFullName` = 'Yesica Romero' ,`SellingOfficeName` = 'Surge Realty' ,`Latitude` = '30.117545' ,`Longitude` = '-95.248931' ,`PhotoCount` = '20' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '247500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pleasant Forest' ,`StreetNumber` = '21459' ,`StreetSuffix` = 'Bend' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY 4 BEDROOM HOUSE WITH NICE BACK PATIO AREA VERY SPACIOUS. MASTER BEDROOM IN BACK OF HOUSE.' ,`Acres` = '0.1452' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S508803 - FOREST COLONY 03, BLOCK 6, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Forest Colony 03' ,`TaxAmount` = '5623' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118500' WHERE `Matrix_Unique_ID` = '212750594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:22:50.260' ,`MLSNumber` = '61101479' ,`ListAgentFullName` = 'Wesley Wilson' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120716' ,`Longitude` = '-95.560577' ,`PhotoCount` = '35' ,`PostalCode` = '77375' ,`RoomCount` = '12' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Oconee' ,`StreetNumber` = '24635' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous 2-story in Princeton Place with loads of updates and upgrades. Step inside to fresh paint and beautiful wood-look LVP flooring throughout the common spaces. Upgraded lighting and fans add to the new feeling of this stunning home. Head through the formal dining or the oversized living room into the freshly updated kitchen. You\'ll love cooking and entertaining in the stylish kitchen with new stainless appliances, new quartz countertops and tile backsplash. Relax in the luxurious primary retreat with deep soaking tub and refreshing stand-up shower in the en-suite bath, complete with dual sinks and vanity and ample walk-in closet. Upstairs you\'ll find fresh paint, new carpet, and lighting in the bedrooms and throughout. Play and entertain in the game room upstairs and read, relax, or watch movies in the separate loft/den on the second floor. Grill or dine al fresco on the back patio in the fenced, pet-friendly back yard with no rear neighbors! Check it out!' ,`Acres` = '0.1309' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 PRINCETON PLACE SEC 2' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Princeton Place' ,`TaxAmount` = '6763' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118501' WHERE `Matrix_Unique_ID` = '212827078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:15:02.573' ,`MLSNumber` = '98668175' ,`ListAgentFullName` = 'Amy Raper' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152895' ,`Longitude` = '-95.405598' ,`PhotoCount` = '36' ,`PostalCode` = '77385' ,`RoomCount` = '7' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Park' ,`StreetNumber` = '31847' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish 3 bedroom, 2 bath, one-story Perry home in popular Imperial Oaks neighborhood boasts an expansive kitchen island, high ceilings, neutral color palette, and NO REAR NEIGHBORS. Warm and inviting the home is filled with natural light beaming through beautifully designed windows with wood laminate flooring in main living areas and primary bedroom. The open floor plan is perfect for entertaining. Elegantly appointed kitchen has abundant 42\" cabinetry, tile backsplash, gas cooktop, 19\" tile flooring, and a charming window seat. Serene primary bedroom has an en-suite bath with double sinks, garden tub, separate shower, and spacious closet. Secondary bedrooms share one full bath with shower/tub combo. Gabled ceiling accentuates the study, a flex space for a formal dining, game room, fitness room, or living area. Back yard has room for play or pool! Washer, dryer, and refrigerator included. Conveniently located near shopping, dining, and entertainment. Close to 99/Hardy. Never flooded.' ,`Acres` = '0.124' ,`Area` = '15' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S612180 - IMPERIAL OAKS PARK 12A, BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Park 12a' ,`TaxAmount` = '6922' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118501' WHERE `Matrix_Unique_ID` = '212838196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:02:33.283' ,`MLSNumber` = '47030144' ,`ListAgentFullName` = 'Melissa Land' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Jaclyn Tran' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.692777' ,`Longitude` = '-95.214070' ,`PhotoCount` = '17' ,`PostalCode` = '77506' ,`RoomCount` = '8' ,`ListPrice` = '199500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Denham' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '30YR SHINGLE ROOF JUST RECENTLY INSTALLED ON 10.27.22. Must See Home w/ recently installed Central Air HVAC System in main house 3 beds 1 bath & back studio w/ 4th bedroom has AC window unit & storage that could be converted to a private bath. The back studio could be rented out for potential income. The home has just recently been renovated giving the interior of the home a modern feel. Recent updates include freshly painted interior & exterior, lighting throughout has been upgraded to LED, updated door knobs, recently installed carpet, LVT flooring, & tile. The entire bathroom has been redone: tub, tile, toilet, vanity, sink, faucet, & mirror. In the kitchen, you will find recently installed granite, backsplash, faucet, disposal, range, microwave, and hardware. For your privacy 2 “ faux wood blinds throughout. Other added features: electric hot water heater, PEX Plumbing system, & the utility room was moved inside the house. Enjoy the comforts of having a renovated home. owner/agent' ,`Acres` = '0.1896' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 33 SUNNYSLOPE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MORALES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyslope Sec 01' ,`TaxAmount` = '2358' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118501' WHERE `Matrix_Unique_ID` = '212877450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:42:14.617' ,`MLSNumber` = '22372887' ,`ListAgentFullName` = 'Coby Lewis' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.992341' ,`Longitude` = '-95.589102' ,`PhotoCount` = '50' ,`PostalCode` = '77070' ,`RoomCount` = '15' ,`ListPrice` = '1395000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Glen' ,`StreetNumber` = '11303' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '11249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked away on a quiet cul-de-sac lot sits this sprawling show stopper of a home. From the moment you pull up you will be taken back by the amazing curb appeal of the circle drive leading to this stunning waterfront home sitting on an oversized lot with access to a private lake. This massive 11,249 sqft 6 bedroom 8 bath home, has just undergone a complete remodel to include; fresh paint inside and out, beautiful new floors throughout, all bathrooms are completely remodeled, gorgeous new kitchen with 2 sinks, 2 dishwashers, 4 ovens, a wine fridge and all new appliances. Brand new AC systems with new ductwork. Pool has new plaster, with new coping and upgraded tile. The home also has its own gym, sauna, full garage apartment, office, huge game room and best of all has its own private access to a secluded lake. While it is tucked away, it is still a very convenient location with quick access to 249 and 99. Just minutes away from all the shopping and dining that Vintage Park has to offer.' ,`Acres` = '0.8035' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 41 LAKEWOOD FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '35000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Victorian' ,`Subdivision` = 'Lakewood Forest' ,`TaxAmount` = '30734' ,`TaxRate` = '2.4945' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118501' WHERE `Matrix_Unique_ID` = '213032254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:33:52.890' ,`MLSNumber` = '72154388' ,`ListAgentFullName` = 'Wesley Wilson' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813442' ,`Longitude` = '-94.835938' ,`PhotoCount` = '20' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Rainbow' ,`StreetNumber` = '5702' ,`StreetSuffix` = 'Road' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this charming 3 bedroom 2 bath single story in Cove! You\'ll love the recent upgrades to this newer home. Walk into beautiful rich wood-look laminate flooring throughout the common areas and brand new carpet and padding in the bedrooms. You\'ll love the soaring vaulted ceiling in the living area with ceiling fan and updated lighting. Fresh paint throughout the interior of this home makes it look and feel like a brand new home! Enjoy cooking and entertaining in the centrally located kitchen with stylish dark appliances and granite countertops. Play, study, or entertain in the flexible den. Relax in the primary suite with a luxurious soaking tub and separate shower. You\'ll love the upgrades to hardware, lighting, and fixtures in both bathrooms. Find plenty of space to play and entertain in the pet-friendly fenced back yard with cozy patio. This neighborhood gem is move-in ready with all the features and styling of brand new construction. You\'ll love living here!' ,`Acres` = '0.243' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 22 BK 2 JOSEPHS COVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Josephs Cove' ,`TaxAmount` = '4634' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118501' WHERE `Matrix_Unique_ID` = '213130189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:07:07.843' ,`MLSNumber` = '93408683' ,`ListAgentFullName` = 'Gada Al Edan' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529900' ,`Longitude` = '-95.403800' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '11' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayberry Ridge Lane' ,`StreetNumber` = '4435' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautiful 2-story home located in Pomona. Enter through the front door and discover a nice entrance to the dining room. The kitchen features built-in stainless steel appliances, granite counter tops, a butler\'s pantry, and an oversized island. The family room hosts a breathtaking 2-story ceiling that is sure to impress. Host a game night in the upstairs game room that overlooks the family room. There is a bedroom downstairs with a bathroom right next to it, in addition to the master bedroom. Thank you for showing our listing!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Pomona, Lot 19, Block 3' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '6522' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'POMONA SEC 4' ,`TaxAmount` = '16091' ,`TaxRate` = '3.6594' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667118502' WHERE `Matrix_Unique_ID` = '213227800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:58:16.030' ,`MLSNumber` = '59260273' ,`ListAgentFullName` = 'Roberto Villagomez' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.416154' ,`Longitude` = '-95.245919' ,`PhotoCount` = '4' ,`PostalCode` = '77511' ,`RoomCount` = '3' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Foley' ,`StreetNumber` = '306' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CALLING ALL INVESTORS! Great Home with oversized lot and pool. All offers welcomed. SOLD AS IS WHERE IS.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Disney (Alvin), Block 18, Lot 1to5' ,`LotDesciption` = 'Other' ,`LotSize` = '35000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'ALVIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Disney Alvin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118502' WHERE `Matrix_Unique_ID` = '213291056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:20:54.740' ,`MLSNumber` = '25445224' ,`ListAgentFullName` = 'Susan Matson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052897' ,`Longitude` = '-95.573681' ,`PhotoCount` = '37' ,`PostalCode` = '77379' ,`RoomCount` = '12' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Rollinson Park' ,`StreetNumber` = '9842' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A subtle breeze is felt when approaching this BRICK AND STONE Trendmaker built home in Gleannloch Farms! Nicely landscaped lot that backing to a greenbelt, meaning no back neighbors! Spacious, flexible living areas with tile and hardwood throughout. A luxurious primary suite secluded in the rear and offers a sitting area and DOUBLE CLOSETS with drawers and built ins. The stunning curved staircase rises from the rear of the foyer as it courses upward past the charming breakfast room. Open concept kitchen w/granite & stainless appls. Three bedrooms, two full bathrooms, MEDIA, AND a GAME room make up the second floor. A GATED three-car garage w/loft & built-in storage, and a PERFEC SIZED BACKYARD WITH SHED BEHIND THE GARAGE presenting countless possibilities, whether it be a swimming pool, outdoor kitchen, expanded patio, gardens, or all the above! This beauty is in the Dove Manor section offering a lake w/ walking path. Abundant amenities in Gleannloch Farms.' ,`Acres` = '0.2256' ,`Area` = '14' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 GLEANNLOCH FARMS SEC 40' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9827' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 40' ,`TaxAmount` = '' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118502' WHERE `Matrix_Unique_ID` = '213323189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:49:45.470' ,`MLSNumber` = '22075303' ,`ListAgentFullName` = 'Janna Westerbeck' ,`ListOfficeName` = 'Way Maker Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421835' ,`Longitude` = '-95.236716' ,`PhotoCount` = '25' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Shirley' ,`StreetNumber` = '335' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful three-bedroom, two bath home on over a half of an acre cul-de-sac lot! The updated kitchen boasts granite countertops, stainless steel appliances and is open to the dining room and family room. The over-sized back yard is a rare find and has so many possibilities. This home offers a split floorplan with primary bedroom suite on one side and two bedrooms on the other. Great convenient location with walking trails nearby. Low taxes, no HOA and never flooded! Call today to schedule a showing of this amazing property!' ,`Acres` = '0.567' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TOWNE OAKS NORTHEAST (ALVIN) LOT 15 ACRES .567' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '24699' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Oaks Northeast Alvin' ,`TaxAmount` = '6919' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118502' WHERE `Matrix_Unique_ID` = '213344842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:24:14.970' ,`MLSNumber` = '49584541' ,`ListAgentFullName` = 'Alicia Grifaldo' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065476' ,`Longitude` = '-95.369072' ,`PhotoCount` = '37' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Breckenridge Dale' ,`StreetNumber` = '23515' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful move-in ready home on a culdesac! Enjoy your morning coffee on the tucked away porch before stepping inside where wood-look tile floors make maintenance a breeze. Open concept living room has lots of natural light and flows easily into the kitchen with a breakfast bar, granite counters, and ample storage. All bedrooms are upstairs, including the primary separated from the secondary bedrooms and featuring dual sinks, tub, and large glassed-in shower. Enjoy time with friends and family in the game room! Garage has epoxy flooring and can be used as a gym Don\'t miss the fully fenced backyard with a covered patio and lots of green space. Conveniently located near parks with easy access to highways, shopping, and dining!' ,`Acres` = '0.1055' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 BRECKENRIDGE PARK 2ND PAR R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Breckenridge Park Prcl R/P #2' ,`TaxAmount` = '6420' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118502' WHERE `Matrix_Unique_ID` = '213423794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:38:10.787' ,`MLSNumber` = '35924456' ,`ListAgentFullName` = 'Jennifer Barnes' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572121' ,`Longitude` = '-95.138009' ,`PhotoCount` = '39' ,`PostalCode` = '77062' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Peermont' ,`StreetNumber` = '15414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Best offers due by Sunday, 10/30/22 at 6pm. Immaculate and well maintained 4 bedroom, 2 and a half bath house conveniently located in central Clear Lake. Large kitchen with plenty of storage and ample counter space opens to the living room and just a step out to the fabulous backyard patio. Great place to enjoy cool fall days and evenings. Backyard gate opens to a great walking area. Extra work and storage space backyard shed as well as the garage. Surround sound in living room and on back porch. Home has tasteful extras, like-new light features in the breakfast area and a large front porch. New 5 ton AC system installed in Sept. 2022. Never flooded and new drainage system recently completed for the street, per seller. New sidewalk and partial driveway to be completed this month. Near shopping, restaurants, entertainment, and walking trails and parks, including Exploration Green. Among the lowest HOA fees in the area. (All measurements are approximate and should be verified.)' ,`Acres` = '0.1741' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 5 MEADOWGREEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '69' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowgreen Sec 01' ,`TaxAmount` = '5863' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118503' WHERE `Matrix_Unique_ID` = '213425726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:59:17.213' ,`MLSNumber` = '12086032' ,`ListAgentFullName` = 'Mohammed Ansari' ,`ListOfficeName` = 'Greenleaf Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846707' ,`Longitude` = '-95.592811' ,`PhotoCount` = '49' ,`PostalCode` = '77041' ,`RoomCount` = '11' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Sterling' ,`StreetNumber` = '5419' ,`StreetSuffix` = 'Brook' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very Beautiful 6 Room House. Corner Lot House with no Neighbor on back side. Gated Subdivision. Modern Countertop Sink and Kitchen opens to living room. Renovated Kitchen and Master bath. Spacious house with six rooms. Comes with Washer Dryer and refrigerator. Seller willing to sell furniture at reasonable price. This house has sprinkler (Lawn), French Drain, Fully Guttered, Water Softener.\r\n\r\nDon\'t miss this Elegant Texas Size house with Shady trees with lot of water views in subdivision, provides\r\nextra outdoor entertainment.' ,`Acres` = '0.215' ,`Area` = '8' ,`BuilderName` = 'VILLAGE BUILDER' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 1 LAKES ON ELDRIDGE SEC 18' ,`LotDesciption` = 'Corner' ,`LotSize` = '9365' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes On Eldridge Sec 18' ,`TaxAmount` = '13267' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667118503' WHERE `Matrix_Unique_ID` = '213524071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:30:56.447' ,`MLSNumber` = '68320722' ,`ListAgentFullName` = 'Jessica Flowers' ,`ListOfficeName` = 'White Ivy Real Estate' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.845201' ,`Longitude` = '-95.410922' ,`PhotoCount` = '50' ,`PostalCode` = '77320' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'State Highway 19' ,`StreetNumber` = '3661' ,`StreetSuffix` = '' ,`City` = 'Riverside' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This LARGE 3 bed 2 bath has plenty of space to spread out. With the Over sized living room that surrounds the 360 fireplace you have a variety of option from a gathering to a play room! The formal dinning room right off the kitchen is ideal for sit down time together during your busy day. Enjoy your coffee on the covered back patio over looking the Large back yard that offers peaceful scenery, and room for all to play. The 2 stall garage is attached giving access directly to the living space with a private work shop off the back.' ,`Acres` = '3.067' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PORTER J (A-38), TRACT 17.1, ACRES 3.067' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '133599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'None' ,`TaxAmount` = '3880' ,`TaxRate` = '1.8224' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667118503' WHERE `Matrix_Unique_ID` = '213526751' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:38:48.903' ,`MLSNumber` = '23594175' ,`ListAgentFullName` = 'Susana Villicana' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721672' ,`Longitude` = '-95.588663' ,`PhotoCount` = '33' ,`PostalCode` = '77082' ,`RoomCount` = '7' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Louvre' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious Royal Oaks Country Club Location! just remodeled, new flooring, carpet, and painted one-story home on a golf course and pool. Contemporary 4- 5 bedrooms and 4 full baths. The home has a formal dining, study, and very spacious floor plan: Granite Counters, Stainless Appliances, Luxury Home Great for corporate.' ,`Acres` = '0.2107' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 12' ,`LotDesciption` = 'Other' ,`LotSize` = '9180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118503' WHERE `Matrix_Unique_ID` = '213558467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:41:42.887' ,`MLSNumber` = '56420600' ,`ListAgentFullName` = 'Sharla Cole' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Laura Winn' ,`SellingOfficeName` = 'Rockin 4C Properties' ,`Latitude` = '29.491084' ,`Longitude` = '-95.125505' ,`PhotoCount` = '47' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Harpers Ferry' ,`StreetNumber` = '2508' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming and recently updated home in the established community of The Landing. Welcome in and enjoy the open-concept family room and kitchen. Brand new tile flooring throughout the entire home. Brand new kitchen countertops, cabinets, microwave, and oven . Continue down the hall and find the secondary bedrooms as well as the secondary bathroom with brand new granite countertops, a brand new toilet, and tub/shower combo. Located off from the primary suite is a flex-room that would make a great home office, study, workout room, nursery, etc.! The oversized primary suite features a spacious walk-in closet, soaking tub, and access to a private patio to enjoy your morning coffee! From the kitchen you can access the covered patio and spacious backyard - a great space for entertaining! Home has never flooded.' ,`Acres` = '0.1679' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 PAGE 3 LOT 14 BLK 7 THE LANDING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'The Landing' ,`TaxAmount` = '4856' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118503' WHERE `Matrix_Unique_ID` = '213588863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:40:33.610' ,`MLSNumber` = '38540564' ,`ListAgentFullName` = 'Sophie Zhang' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728719' ,`Longitude` = '-95.848112' ,`PhotoCount` = '34' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Huggins Crest' ,`StreetNumber` = '27606' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Former BEAZER MODEL HOME in Master Planned Community in the Capri Floor plan. This 1.5 story home features 4 bedrooms, 3 baths, a study, Game room, and loft. There are 3 bedrooms downstairs! Upgrades galore with Stainless steel apliances, granite counter tops, iron spindles,and 2 master closets! There are tile and wood flooring throughout most of the home. Don\'t miss the great covered patio out back and it\'s on a CUL-DE-SAC street across from the pool! Hurry to see this gorgeous home today!' ,`Acres` = '0.1609' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CHURCHILL FARMS SEC 1, BLOCK 1, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7009' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '630' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Churchill Farms Sec 1' ,`TaxAmount` = '8511' ,`TaxRate` = '2.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118504' WHERE `Matrix_Unique_ID` = '213744258' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:29:42.077' ,`MLSNumber` = '33370855' ,`ListAgentFullName` = 'Sheriann Ramirez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869492' ,`Longitude` = '-95.291854' ,`PhotoCount` = '49' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '259500.00' ,`Status` = 'Active' ,`StreetName` = 'Nyla Spring' ,`StreetNumber` = '10723' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Towne Park Village! You’re approximately 15 minutes from Downtown Houston! This nice 2 story home offers 3 bedrooms, 2 ½ bathrooms, a spacious kitchen with beautiful espresso cabinets. The living room features a high ceiling with lots of space for family gatherings. The master bedroom features tray ceiling and his and hers walk-in closets. You’ll also enjoy a good-sized backyard with a covered patio perfect for Sunday BBQ\'s. The community also has a playground you and your children will enjoy. There\'s also the perfect dog park just right for your little pooch to run around while you relax under the gazebo. Don’t miss out! Schedule an appointment today.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 TOWN PARK DEVELOPMENT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Park Village' ,`TaxAmount` = '5285' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118504' WHERE `Matrix_Unique_ID` = '213745243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:22:07.847' ,`MLSNumber` = '28829309' ,`ListAgentFullName` = 'Alicia Grifaldo' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.125920' ,`Longitude` = '-95.406954' ,`PhotoCount` = '40' ,`PostalCode` = '77386' ,`RoomCount` = '12' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Thorsby' ,`StreetNumber` = '30114' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 2-story home on an oversize lot offering no back neighbors, a quiet street, & an adjacent small park. Located near Kroger, I45, Grand Pkwy, & more! Outside find a manicured lawn, fresh landscaping, large shade trees & a 2-car garage. Inside find an open layout featuring bamboo floors, tall ceilings, 2018 double-pane windows & on-trend paint. A formal living, formal dining, & a home office flows past a half bath into the ALL NEW kitchen w/ a new stove & pot filler, custom cabinetry w/ soft-close features, a wood-top island, & a large farmhouse sink. The great room offers a wall of windows, built-ins, & a fireplace. Upstairs is freshly painted & includes 3 bedrooms that share a full bath, & a HUGE primary bedroom w/ an en-suite bath, & a walk-in closet. Outback find a large shaded backyard w/ a covered deck that’s perfect for relaxing or outdoor fun w/ large vegetable boxes ready for a new harvest. The home also offers a NEW 2021 HVAC, extra attic insulation, & added attic fan.' ,`Acres` = '0.2052' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S611500 - IMPERIAL OAKS 01, BLOCK 3, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8937' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks' ,`TaxAmount` = '5384' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118504' WHERE `Matrix_Unique_ID` = '213751154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:00:53.357' ,`MLSNumber` = '7409860' ,`ListAgentFullName` = 'Brenton Berridge' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808636' ,`Longitude` = '-95.423421' ,`PhotoCount` = '50' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = '25th' ,`StreetNumber` = '1322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique property by a local designer located in the Houston Heights. This once classic 1940s home with great bones was moved to this site and stripped back to the studs for a rebuild. The main home features oak flooring, wainscoting, a hidden speakeasy, French doors, coffered ceilings, ample built-in storage, travertine, and tile in bathrooms. Specifically designed for practicality and beauty, it is not a cookie cutter home! Sitting on a 1/4 acre lot, this one of a kind home includes an original metal shop transformed into a bar and entertainment center. Adding to its already long list of features is a full apartment above the garage. The main home also offers a steam spa in the master shower, a Viking Chefs oven in the kitchen, a convenient pest misting system and sprinkler system. Why park on the street when this property offers a 2 car garage and 4 parking spots inside the gate? Garage currently doubles as workshop and workout room with AC. Don’t miss out on this one-of-a-kind home.' ,`Acres` = '0.25' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 134D SHADY ACRES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Shady Acres' ,`TaxAmount` = '17242' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118504' WHERE `Matrix_Unique_ID` = '213773533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:07:00.977' ,`MLSNumber` = '92799649' ,`ListAgentFullName` = 'Taylor Goldenthal' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807636' ,`Longitude` = '-95.416837' ,`PhotoCount` = '42' ,`PostalCode` = '77008' ,`RoomCount` = '5' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = '24th' ,`StreetNumber` = '1037' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Multiple offers received - Sunday Open House is cancelled***Welcome home to 1037 W 24th Street! This beautiful almost new home is simply spectacular inside & out! Featuring incredible attention to detail & an elevated fit/finish! Sleek fixtures, modern finishes, exposed wood beams are found throughout this 2k sq/ft Shady Acres gem. Highlighting 3 beautifully appointed bedrooms, a kitchen that is the home chef\'s dream w/ Calacatta Quartz countertops, cathedral arched entry, chic foyer w/imported Moroccan style tile floors, two second-story balconies, interior barn doors, & wide plank hardwood floors. Master suite has 13\' vaulted ceilings w/ exposed beam & three enlarged windows. Master bath includes marble countertops, split vanities, two walk-in closets, separate soaking tub + a lavish shower w/ imported porcelain tile! Walking distance to new Heights HEB. Many nearby restaurants/bars such as; Crisp, Cedar Creek Cafe, Rainbow Lodge, Cavatores, Tony\'s & McIntyres.' ,`Acres` = '0.0417' ,`Area` = '9' ,`BuilderName` = 'Grafton Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 CASA OF SHADY ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1815' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Casa/Shady Acres' ,`TaxAmount` = '8969' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667118504' WHERE `Matrix_Unique_ID` = '213785684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:37:49.680' ,`MLSNumber` = '7145319' ,`ListAgentFullName` = 'Mariam Hejazi' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747108' ,`Longitude` = '-95.407791' ,`PhotoCount` = '33' ,`PostalCode` = '77019' ,`RoomCount` = '6' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Mcduffie' ,`StreetNumber` = '2029' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '“Simplicity is the ultimate sophistication.” - Leonardo Da Vinci. 2029 McDuffie is in mint condition and either move in ready, or a blank canvas awaiting your thoughtful reimagination or enhancement. Clever and timeless design by Houston architect William Neuhaus, and built by Houston’s own Windham Builders in 1984. Clean lines create additional space making the home feel much larger than the already well laid out 1,784sqft. This space is ideal for both the serious and novice art enthusiast, as there is ample space for displaying a special collection. Three separate patio spaces weave the outdoor space with the indoor. And walking distance to many of our city’s best restaurants, this home is authentic Montrose. Please have your agent schedule an appointment. Room sizes approximate, buyer to independently verify.' ,`Acres` = '0.0459' ,`Area` = '16' ,`BuilderName` = 'Burke Wyndham' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1A BLK 24 SUMMIT PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summit Place' ,`TaxAmount` = '9313' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118505' WHERE `Matrix_Unique_ID` = '213867841' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213890480','1667118505','213890480','2022-10-29T20:02:32.490','89918064','Nazla Johnson','Keller Williams RealtyNortheast','','','29.649284','-95.519474','50','77071','10','399900.00','Active','Circle','12015','Drive','Houston','3','1','4','3858','Single-Family','This property is an estate sale. This property is an as is sale.','0.2475','20','','','','','Estate','','','1','Brays Oaks','Central Electric,Central Gas','0','LT 32 & N 18.75 FT OF LT 33 BLK 1 LAKES OF FONDREN SW','Cleared','10781','Appraisal District','','1300','0','','','','1','In Ground','','','','Composition','27 - Houston','GROSS ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','WELCH MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Lakes Fondren Sw','6237','2.3307','Public Water','1982','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:23:49.697' ,`MLSNumber` = '47626097' ,`ListAgentFullName` = 'Alicia Grifaldo' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.424699' ,`Longitude` = '-95.554137' ,`PhotoCount` = '28' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '336000.00' ,`Status` = 'Active' ,`StreetName` = 'Valleywood' ,`StreetNumber` = '13041' ,`StreetSuffix` = 'Circle' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prepare to fall in love with this beautiful home in a quiet community, just minutes from Lake Conroe! Situated on an oversized cul-de-sac corner lot, you will find this well-maintained home that features a freshly painted interior and new carpet. The foyer is flanked by a formal dining room to the right and soaring high ceilings. The spacious family room boasts a wood-burning fireplace and is open to the breakfast room and kitchen with granite counters and ample counter space. The first-floor primary bedroom is large and has an ensuite bathroom with double sinks, a soaking tub, and a walk-in closet. Three additional generous-sized bedrooms and a second family room / game room are located upstairs. The backyard space is HUGE with a large covered back patio, mature trees, and plenty of room to install a swimming pool, play area, or gardening. Don’t miss this opportunity to make this amazing house your home!' ,`Acres` = '0.2551' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE HILLS 01, BLOCK 6, LOT 37' ,`LotDesciption` = 'Cleared,Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11112' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '237' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Hills' ,`TaxAmount` = '5301' ,`TaxRate` = '2.2948' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118505' WHERE `Matrix_Unique_ID` = '213914018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:00:36.380' ,`MLSNumber` = '86706317' ,`ListAgentFullName` = 'Brandon Scott' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858672' ,`Longitude` = '-95.133825' ,`PhotoCount` = '26' ,`PostalCode` = '77049' ,`RoomCount` = '5' ,`ListPrice` = '197500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodburn' ,`StreetNumber` = '17003' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully updated, single story home with 3 bedrooms, 2 full bathrooms, and a 2-car garage! Come inside and find your living room with new white oak laminate flooring. Head into the fully updated kitchen and find brand new stainless steel appliances, new granite counters, new cabinets, new tile backsplash, new light fixtures, and stylish painted brick accent wall and a big island with room for seating. Your primary bedroom has a fully updated bathroom with new vanity, tub/shower, toilet, and fixtures. The secondary bathroom also has all the same upgrades! More features to love are all new electrical and plumbing fixtures, interior doors, 2 inch faux wood blinds, light fixtures, interior and exterior paint, water heater, and the HVAC has been cleaned and serviced. Welcome home!' ,`Acres` = '0.1517' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 6 SHELDON WOODS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6608' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheldon Woods' ,`TaxAmount` = '2391' ,`TaxRate` = '3.7643' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118505' WHERE `Matrix_Unique_ID` = '213929075' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:47:46.890' ,`MLSNumber` = '84422101' ,`ListAgentFullName` = 'Olena Leija' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.270690' ,`Longitude` = '-94.840907' ,`PhotoCount` = '21' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '7101' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is located less than half a mile from the beach on Galveston Island. It\'s in the quiet Gulf Village community and close to the tourist spots and schools, has no HOA. The house has an additional 4th room with a gas log fireplace which could be converted into a Primary bedroom or a Family room. The large fenced backyard includes a playground set and it\'s the perfect place for many hours of enjoyment with family and friends. Recent updates include fresh exterior paint, a new water heater, replaced partial siding, some windows, and a sliding door. One car garage opens to the street. Perfect place to call home!' ,`Acres` = '0.146' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 10 BLK 4 GULF VILLAGE ADDN' ,`LotDesciption` = 'Other' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf Village 1' ,`TaxAmount` = '4468' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118505' WHERE `Matrix_Unique_ID` = '213931754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:43:27.063' ,`MLSNumber` = '91365700' ,`ListAgentFullName` = 'Rose Gibson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832857' ,`Longitude` = '-95.785892' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Nestra' ,`StreetNumber` = '4019' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful One Story 3 Bedroom Home located in desirable Ventana Lakes. Brick and Stone clad elevation, Extended Covered Porch and Back Patio. Kitchen offering 42\" Cocoa Cabinets, Granite Countertops, Matching Frigidaire Stainless Appliances, Gas Range, and Island w/ Barstool Seating. Upgraded Neutral Tile in Living Room, Formal Dining Room, Kitchen, Laundry Room, and All Baths. Owners Retreat offers enough room for king-size furniture, has large walk-in closet and En-suite Bathroom with Dual Sinks, Oversize Walk-In Shower, and Soaking Tub. All Secondary Bedrooms are a Great size and have Excellent Closet Space. Refrigerator, Washer & Dryer Included. Easy walk to several Lakes, the Splash Pad, Park, Playground, and Swimming Pool. Excellent Katy Schools. Elementary, Middle & High School all located within Ventana Lakes - Walk or Bike-Ride to School! Put a little TLC in it to make this your Home and enjoy all this wonderful community has to offer.' ,`Acres` = '0.1578' ,`Area` = '25' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 VENTANA LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '7898' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118506' WHERE `Matrix_Unique_ID` = '214033867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:13:14.593' ,`MLSNumber` = '58497285' ,`ListAgentFullName` = 'Dana Colborn' ,`ListOfficeName` = 'Pam Westlake Realty Group' ,`SellingAgentFullName` = 'Shannon Cox' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.355102' ,`Longitude` = '-95.636862' ,`PhotoCount` = '22' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '500000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mail Route' ,`StreetNumber` = '17819' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1371' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy cottage on 3 unrestricted acres has a wide porch where you can sit in the evening & enjoy listening to the birds & watching the occasional wildlife. The inside is completely renovated open-concept living space. The kitchen is beautifully appointed w/ ample quartz countertop/workspace to include dropped-down breakfast bar, all new stainless appliances, soft closed cabinets & drawers, a deep working sink, & walk-in pantry. Bathroom gives spa-like feel with white & bright marble surround shower & lovely iron ore black cabinetry with shiplap backsplash/sink with quartz countertop. Home has been taken down to studs - new plumbing, A/C, electric replaced, spray foam insulation, living space ceiling vaulted with beams installed, roof, siding, & back deck. Move-in ready!Unrestricted acreage, this could be your commercial business/office. The lot is large enough to accommodate your larger dream home or workshop. Minutes away from Lake Conroe. In the prestigious Montgomery ISD schools.' ,`Acres` = '3' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0003 - ATKINS WM, TRACT 82, ACRES 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Abstract Area 17 (Lake Influence)' ,`TaxAmount` = '2306' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118506' WHERE `Matrix_Unique_ID` = '214044563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:41:05.730' ,`MLSNumber` = '91097450' ,`ListAgentFullName` = 'Angie McCartha' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889364' ,`Longitude` = '-95.482880' ,`PhotoCount` = '43' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '269500.00' ,`Status` = 'Active' ,`StreetName` = 'Gallant Forest' ,`StreetNumber` = '6126' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated, brick, one story 3 bed/2 bath home. The main, large, open concept living space has new tile floors, a floor to ceiling white brick gas fireplace, large windows showcasing the backyard, and tall ceilings with a central beam. The renovated kitchen features granite countertops, a center island, lots of cabinets, a double door pantry, large windows for natural light and space for dining. From the kitchen you have access to a two car garage with a side door. After entering the home, on the immediate right, there are two skylights in the ceiling, brightening up another shared living space before entering into all three bedrooms. All bedrooms feature walk in closets, a single large window to optimize wall space and new carpet. Both bathrooms feature double sinks. The primary bathroom includes two separate walk-in closets! This house has never flooded and is not in the flood zone. Easy access to both I-45 and 290 and is located northwest of the Heights. Zoned to Klein ISD.' ,`Acres` = '0.1641' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 15 INWOOD NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood North' ,`TaxAmount` = '4176' ,`TaxRate` = '2.6055' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118506' WHERE `Matrix_Unique_ID` = '214068543' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214070960','1667118506','214070960','2022-10-29T20:27:08.933','32665229','Sherae Smith','Connect Realty','','','29.484982','-95.455593','25','77583','6','303700.00','Active','Mariquita','1218','Lane','Rosharon','2','0','3','1584','Single-Family','Welcome to Glendale Lakes! The beautiful Wren floorplan is a single story with 3 spacious bedrooms and 2 baths and is ready for a November move-in. This new construction home offers a modern feel featuring an open concept floor plan with elongated foyer entryway, 42\' shaker kitchen flat panel cabinetry, Silestone quartz island and countertops with ceramic title backsplash and high quality Frigidaire satinless appliances. Energy efficient features include: 16 SEER A/C system with programmable thermostat and a 40 gallon gas water heater. Saratoga\'s landscaping package includes: full sod front and back. Brick fronts with stone accents per elevation. Glendale Lakes offers top notch school districts, easy access into the city and outstanding dining and shopping at the Rosharon City Center and the Fort Bend and Manvel Town Centers. Contact us to schedule an appointment today!','','38','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Sienna Area','Central Gas','1','Glendale Lakes Sec 9, BLOCK 2, Lot 2','Subdivision Lot','','Other','','550','1','To Be Built/Under Construction','','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required','Builder','1','Traditional','Glendale Lakes','','','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:12:33.020' ,`MLSNumber` = '29309132' ,`ListAgentFullName` = 'Stephanie McClain' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Nichol Polk' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.527045' ,`Longitude` = '-95.156323' ,`PhotoCount` = '18' ,`PostalCode` = '77598' ,`RoomCount` = '3' ,`ListPrice` = '267000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Virginia Colony' ,`StreetNumber` = '2831' ,`StreetSuffix` = 'Drive' ,`City` = 'Webster' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely updated 3 bedroom 2 bathroom house in the desirable Heritage Park community, just a short walk to one of the neighborhood parks and pools. This home has been meticulously maintained and was recently updated throughout. Upon entering, you are greeted with views of the large living room and an inviting corner fireplace. The kitchen is an entertainers\' dream as it is open to the living room and features extensive quartz countertops. Luxury vinyl flooring has recently been installed, along with new paint throughout. All rooms are accented by ample natural light. The backyard has a large concrete slab in addition to a storage shed that will stay with the property. Do not miss your chance to call this home yours!' ,`Acres` = '0.169' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 11 HERITAGE PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park Sec 04' ,`TaxAmount` = '4562' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118506' WHERE `Matrix_Unique_ID` = '214074849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T21:50:51.660' ,`MLSNumber` = '67551037' ,`ListAgentFullName` = 'Kelley Brouillette' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.623220' ,`Longitude` = '-95.751119' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '347000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Falls' ,`StreetNumber` = '2718' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF AUG 22 - Gorgeous updated one story all brick home with 4 bedrooms located in established Pecan Lakes. Home has a new roof, new hot water heater, REMODELED COMPLETELY baths and kitchen 2021. Enjoy engineered hand scraped wood floors. Separate floor plan with three bedrooms on opposite side of the home from the master. Formal dining makes the perfect cozy study or office per pictures. Extended back patio with new double fans with lights. All new hardware throughout the home. Garage has an extra 5 foot bump out and built in wood shelves along the wall of the garage that stay! This one will not last! Pride of ownership shows! LOW HOA AND NICE PARK AND POOL! Shopping and restaurants less than a mile from home.' ,`Acres` = '0.2006' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN LAKES SEC 3, BLOCK 4, LOT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8739' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pecan Lakes' ,`TaxAmount` = '5487' ,`TaxRate` = '2.3298' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118506' WHERE `Matrix_Unique_ID` = '214106927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T20:35:31.887' ,`MLSNumber` = '69224986' ,`ListAgentFullName` = 'Michael Knowles' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577670' ,`Longitude` = '-95.423005' ,`PhotoCount` = '50' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Rippling Creek' ,`StreetNumber` = '13108' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home with 3 Bedroom with 2.5 Baths is amazing and recently upgraded. Luxury Vinyl flooring downstairs in November 2021, and a New carpet upstairs in October 2022. With formal dining, large living room, island kitchen, huge backyard, and a spacious game room upstairs! Zoned to Alvin schools and easy access to the Texas Medical Center. This property you wouldn\'t want to miss! CALL NOW!' ,`Acres` = '0.1376' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-31 (PEARLAND), BLOCK 3, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WILDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '8616' ,`TaxRate` = '3.5409' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667118507' WHERE `Matrix_Unique_ID` = '214130783' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214133093','1667118507','214133093','2022-10-29T20:12:13.130','27434908','Jaime Connell','BHGRE Gary Greene','','','30.078059','-95.719966','50','77377','11','457000.00','Active','Soncy Way','21802','','Tomball','3','1','4','3079','Single-Family','This gorgeous Lennar floorplan is nothing short of perfection and is made for entertaining with it’s open floorplan and large backyard for your resort style pool! Featuring 4 bedrooms, 3 ½ baths with a spacious private study, formal dining and gameroom on a huge premium cul-de-sac lot! No back neighbors. Home has a grand entry and beautiful features, elegant gray tile flooring throughout the first floor, gray carpet, large open kitchen with oversized island with sink, perfect for extra seating, covered patio with gas stub, ready for your outdoor kitchen. Owners retreat w/soaking tub, separate vanities and large closet. Upstairs features 3 sizable secondary bedroom, one with its own bathroom! This home also comes with custom Christmas lights designed just for this house! Come see this spectacular home!','','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Tomball Southwest','Central Gas','1','LT 14 BLKI 1ROSEHILL RESERVE SEC 2','Subdivision Lot','10108','Appraisal District','','900','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','GRAND OAKS ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Rosehill Reserve','','','Water District','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214183124','1667118507','214183124','2022-10-29T21:31:34.213','79517508','James Pitman','Coldwell Banker Realty','','','29.724212','-95.367777','24','77004','6','474900.00','Active','Rosewood','2801','Street','Houston','2','0','3','1999','Single-Family','Have you ever wondered what it would be like to live within 10 minutes of everything? Herman park, the zoo, Downtown/Toyota Center, Museum District, Medical Center, Greenway Plaza, Midtown, Montrose, NRG stadium, and literally hundreds of restaurants are all within 10 minutes of this meticulously updated home. This turnkey smart home will impress from the moment you walk through the arched front door. You will love the spacious feeling you get from the 10\' ceilings and your eyes will be drawn to the designer elements throughout the kitchen and baths. The roof, HVAC, plumbing, and foundation were all replaced or upgraded during the renovation. Additionally, a new privacy fence and electric gate were just installed. May this home be your new sanctuary deep in the heart of Houston.','0.1687','4','','','','','Sellers Disclosure','','','','University Area','Central Gas','0','LT 22 & TR 21 BLK 31 WASHINGTON TERRACE','Corner','7350','Appraisal District','','','0','','0','','0','','','Gas Cooktop','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','1','Ranch','Washington Terrace','8437','2.3307','Public Sewer,Public Water','1942','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214184380','1667118507','214184380','2022-10-29T21:23:51.600','81067307','Sandra Cruz','Walzel Properties','','','29.870139','-95.709503','25','77449','12','300000.00','Active','Tahoka Springs','19419','Drive','Katy','2','1','4','2763','Single-Family','Welcome to this spacious home in the desired Bear Creek Meadow Subdivision in Katy, TX! The home sits on an extra large 9,041 square ft lot! The home features custom wood cabinetry in the kitchen and flex space, which can be used as an office. The entrance has soaring ceilings that open to a nice living room. The home includes 4 bedrooms and 2.5 bathrooms. The primary on-suite is the conveniently located in the first floor. The roof was replaced in 2022. This a must see!','0.2076','25','','','','','Mud,Sellers Disclosure','','','1','Bear Creek South','Central Electric','1','LT 10 BLK 5 BEAR CREEK MEADOWS SEC 2','Subdivision Lot','9041','Appraisal District','','435','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','JOWELL ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Bear Creek Meadows Sec 02','5850','2.671','Water District','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214202814','1667118507','214202814','2022-10-29T20:16:00.387','10435004','Allison Harcourt','RE/MAX Eastside','','','30.099900','-94.151836','44','77706','10','350000.00','Active','Galewood','4610','Lane','Beaumont','3','0','3','2582','Single-Family','This beautifully updated 3/2/2 w/ 1/1 pool house, pool, and covered patio is an entertainer\'s dream. The bright living room is large enough to create a second eating area or reading spot. The open dining room w/ Quartz & Cypress shelves, lead into the fully renovated kitchen w/ Quartz & Sycamore counters, ZLine Convection Oven, stainless hood, built-in beverage refrigerator, soft closing cabinets, pantry area, & utility room w/ tons of cabinets. Back through the kitchen & dining, head towards the back of the home to the large den w/ doors overlooking the pool and a large sunroom, currently being used as a playroom. In the backyard, you\'ll find the pool house with bunkbeds & desk, living area, & bathroom w/ shower. Ther massive in-ground pool and covered patio are perfect for those epic summer parties. Back inside you\'ll find the three main bedrooms. The two guest bedrooms have double beds that can stay with the home. The primary bedroom features a walk-in closet and en-suite bathroom.','0.2686','51','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','0','','Central Gas','0','TALL TIMBERS L1 B8','Corner,Subdivision Lot','11700','Appraisal District','','','0','','2','Convection Oven','1','In Ground','','Gas Range','','Composition','143 - Beaumont','REGINAL-HOWELL ELEMENTARY SCHOOL','WEST BROOK HIGH SCHOOL','MARSHALL MIDDLE SCHOOL (BEAUMONT)','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Tall Timbers','6699','2.645','Public Sewer,Public Water','1962','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214203741','1667118507','214203741','2022-10-29T21:16:59.220','23440771','Raenette Jones','Realty Preferred Lux Door','','','29.769537','-95.561897','24','77024','6','900000.00','Active','Traviata','12814','Drive','Houston','2','0','3','2180','Single-Family','A Mid Century Marvel located in the prestigious community of Memorial Bend. Fully renovated to bring the true essence back to the timeless style of Mid-Century Modern. Beautiful statement pieces include the black framed pivoting door and a black framed partition door upon entry. Let the sunlight guide you directly to the living space. Natural sunlight from the skylight illuminates the warm and welcoming tone of the home, with Spacious bedrooms for family and guests, and an office space/flex space. The kitchen features beautifully designed finishes with brass accents and custom cabinetry. Also including a new stainless steel gas range, wine fridge, and full-size refrigerator. In the Primary Suite, you will find your ultimate retreat in your open-concept restroom and closet with a custom-designed LED vanity, shower room, and cabinets. Located in the thriving community of Memorial City you are minutes away from the Galleria, Downtown, and highways.','0.2342','23','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','2','Memorial West','Central Gas','1','LT 10 BLK 10 MEMORIAL BEND SEC 2','Corner,Subdivision Lot','10200','Appraisal District','','365','0','','0','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Aluminum','49 - Spring Branch','RUMMEL CREEK ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)','Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern,Other Style,Traditional','Memorial Bend Sec 02','10619','2.4415','Water District','1956','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214213136','1667118507','214213136','2022-10-29T21:59:52.397','52742484','De Juanna Pulcher','REALM Real Estate Professional','','','29.820058','-95.055324','38','77562','6','260000.00','Active','Oak','401','Street','Highlands','2','0','4','1801','Single-Family','Take a look at this JEWEL located on a corner lot in a cozy neighborhood. This home checks off so many of a home buyers boxes. The back yard is certainly a place to decompress at the end of the day with a dip in the pool, or to be the go to place for all the fun. The outdoor bar will certainly come in handy for entertaining. There is small workshop for all those HONEY DO\'s. You have to come take a look for yourself.','0.1944','2','','','Electric Dryer Connections','','Sellers Disclosure','1','','0','Baytown/Harris County','Central Gas','0','LT 31 BLK 2 PRINCE','Corner,Subdivision Lot','8470','Appraisal District','','','0','','2','Double Oven','1','Gunite,In Ground','','Electric Cooktop','','Composition','23 - Goose Creek Consolidated','HOPPER/HIGHLANDS ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Prince','3667','2.575','Public Sewer,Public Water','1974','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214214217','1667118507','214214217','2022-10-29T20:32:42.350','29078408','Crystal Lucas','Weichert,REALTORS-Murray Group','','','30.365469','-95.624460','28','77316','3','209900.00','Active','Ridgeside','237','','Montgomery','2','0','3','1090','Single-Family','This stunning home is located in the Lake Conroe Village subdivision. This cute home has been barely lived in and offers a very open floor plan. You will fall in love as soon as you walk in the door. The very spacious living room is the first room you come to when you walk in. As you continue through the home you will find a generous breakfast table area, a breakfast bar that can accommodate 2-3 bar stools and a very open kitchen area. The primary bedroom offers an extra at the back that can be used for a nursery, office, closet, or workout room. The possibilities are endless in this room. You will notice the backyard offers a little more space than some of the other yards in the neighborhood. Make sure you add this one to your list of homes to see.','0.1019','39','','','Washer Connections','','Sellers Disclosure','1','','0','Lake Conroe Area','Central Electric','1','S660300 - LAKE CONROE VILLAGE, BLOCK 7, LOT 78','Subdivision Lot','4437','Appraisal District','','387','0','','0','Electric Oven','0','','','Electric Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Lake Conroe Village','3406','1.825','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214214613','1667118507','214214613','2022-10-29T21:35:44.573','10976984','Laura Estes','Laura Estes Real Estate','','','29.499224','-97.921645','22','78155','7','289000.00','Active','Schneider','1500','Road','Seguin','2','0','3','1800','Single-Family','Come see this recently updated and remodeled 3-bedroom 2 -bath house, just 6 miles from schools and shopping. Updates include flooring, bathrooms, large kitchen with granite countertops and central air and heat. Septic installed in 2021. Large workshop with drive-in access all on a little less than 1/2 acre. No HOA and No City Taxes!','0.33','83','','','','','Sellers Disclosure','','','','','Central Electric','0','ABS: 9 SUR: JESUS CANTU .3300 AC.','Cleared','14375','Survey','','','0','','0','','0','','','','','Other','157 - Seguin','KOENNECKE ELEMENTARY SCHOOL','SEGUIN HIGH SCHOOL (SEGUIN)','JIM BARNES MIDDLE SCHOOL','Appointment Required','Seller','1','Traditional','Jesus Cantu Surv 15 Abs 9','4049','1.6645','Public Sewer,Septic Tank','2009','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214214687','1667118507','214214687','2022-10-29T21:27:56.283','57426900','Michael Callihan','Riverway Properties','','','29.786460','-95.440668','33','77055','4','757000.00','Active','Eaton Estates','3504','Lane','Houston','3','1','4','2709','Single-Family','FIRST FLOOR LIVING! Built by Riverway Homes. Home will be ready in June 2022 This residence offers 2709 sf of living space on 3 floors. Perfect for families with teenagers, live-in help or multi-generational family homes (En Suite 3rd floor Game Room/Optional living area). Patio sized lot offers green space and quaint covered courtyard-like area.','0.0495','9','Riverway Properties','','','','No Disclosures','1','','','Timbergrove/Lazybrook','Central Gas','1','NA','Subdivision Lot','2585','Appraisal District','','2500','1','To Be Built/Under Construction','2','','0','','','','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Accompany','Builder','3','Other Style','Somerset Green','','2.6161','Other Water/Sewer','2022','Builder'); --> New record created successfully