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-11-09T23:23:31.157' ,`MLSNumber` = '47760832' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.814525' ,`Longitude` = '-95.112326' ,`PhotoCount` = '6' ,`PostalCode` = '77360' ,`RoomCount` = '5' ,`ListPrice` = '89450.00' ,`Status` = 'Active' ,`StreetName` = 'Seminole' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Circle' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located in Canyon Park Subdivision. This home sits on two lots. Property is OCCUPIED. PLEASE DO NOT DISTURB THE TENANTS. This property is part of a group of homes that are being sold \"AS IS\". Investment Opportunity. Dimensions to be verified.' ,`Acres` = '0.3582' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 390' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 4' ,`TaxAmount` = '88' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668118896' WHERE `Matrix_Unique_ID` = '208935273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:30:39.943' ,`MLSNumber` = '90651164' ,`ListAgentFullName` = 'Andrew Missick' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529524' ,`Longitude` = '-95.480350' ,`PhotoCount` = '45' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '319950.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage Run' ,`StreetNumber` = '1731' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2-story, 4 bedrooms, 2 ½ baths, 2 car garage single-family home sits on a quiet oversized cul-de-sac lot, located in the Teal Run Meadows subdivision in Fresno, TX. The home has an open to below floor plan with high ceilings and large windows. Many notable upgrades include granite counter tops, tiled backsplash, fixtures and faucets, interior lighting, ceiling fans, outside recess soffit lighting, and a security camera system. Upstairs has 3 bedrooms, 1 bathroom, Game room, study area, and a bonus room that can be used as an office or storage area. Downstairs has the living room, dining room, laundry room, kitchen, breakfast area, half bath, primary bedroom, primary bathroom with dual sinks, and a huge walk-in closet. The backyard has a storage shed and all new fencing around the entire property. Schedule a showing today!' ,`Acres` = '0.1935' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TEAL RUN MEADOWS SEC 2, BLOCK 2, LOT 39' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Teal Run Meadows Sec 2' ,`TaxAmount` = '4601' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118897' WHERE `Matrix_Unique_ID` = '208945707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:52:01.617' ,`MLSNumber` = '42171712' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '26' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14811' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home Ready! Best Schools! The Harris! Chic Stucco & Brick Elevation, Covered Patio, Large Backyard! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! 2 Full Baths & a Half Guest Bathroom! Huge Family Rm features Walls of Windows projecting abundance of natural light inside! Casual Dining flows gracefully into your Gourmet Kitchen features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Stainless Steel Appliances, Large Eat-in Island, Deep Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom with His & Her Undermount Sinks Vanity W/Cultured Marble Counters, deep Soaker Tub, Large Seamless Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Low Taxes! Not In Flood Zone at this time' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 33 /Block: 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`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` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118897' WHERE `Matrix_Unique_ID` = '210326509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:23:52.360' ,`MLSNumber` = '80937441' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889832' ,`Longitude` = '-95.727339' ,`PhotoCount` = '23' ,`PostalCode` = '77433' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Post' ,`StreetNumber` = '20714' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom, 2.5 bathroom home now on the market! The kitchen is equipped with ample cabinet space and updated counters. Entertaining is a breeze with this great floor plan! ?The bedrooms offer plush carpet, plenty of natural light, and sizable closets. Relax with your favorite drink on the covered back patio. Don\'t miss this incredible opportunity! This property is waiting for you to make it your forever home!' ,`Acres` = '0.0869' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 CANYON VILLAGE AT CYPRESS SPRINGS SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '3785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Village At Cypress Spgs Sec 4' ,`TaxAmount` = '4870' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668118897' WHERE `Matrix_Unique_ID` = '210948304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:14:12.897' ,`MLSNumber` = '19663584' ,`ListAgentFullName` = 'Cathy Lakey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400173' ,`Longitude` = '-95.500519' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '14' ,`ListPrice` = '729000.00' ,`Status` = 'Active' ,`StreetName` = 'Irenic Mist' ,`StreetNumber` = '337' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Abundant natural light infuses this stunning one-story home sitting on a nearly half-acre cul-de-sac lot in one of the most popular master-planned communities in Montgomery County. Same floor plan as the Highland Homes model, loaded with upgrades, and priced far less than new! The heart of the home is a fabulous white kitchen loaded with cabinet space and accented by stylish gold drawer pulls, open to the living and dining area and facing a wall of windows overlooking the extended covered patio. The primary suite offers an oversized bedroom, a sumptuous ensuite bath with double vanities flanking a soaking tub, plus a separate seated vanity, an oversized shower and a huge walk-in closet with custom built-ins. Even the secondary bedrooms are sized generously. The entertainment room has the flexibility to be a theater, billiard or game room. Also features a speaker system and private study. 13-foot ceilings and five-inch plantation shutters top off the glamorous flair of this home.' ,`Acres` = '0.4724' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927100 - THE WOODLANDS HILLS 01, BLOCK 1, LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '20576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills 01' ,`TaxAmount` = '15390' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118897' WHERE `Matrix_Unique_ID` = '210955200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:02:20.327' ,`MLSNumber` = '27673399' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.187125' ,`Longitude` = '-95.801128' ,`PhotoCount` = '25' ,`PostalCode` = '77355' ,`RoomCount` = '3' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Allan Poe' ,`StreetNumber` = '26020' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built in 2019, this Magnolia one-story home offers a patio, granite countertops, and a two-car garage. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1337' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S955200 - WILLIAMS TRACE 01, BLOCK 4, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5823' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Trace 01' ,`TaxAmount` = '3697' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668118897' WHERE `Matrix_Unique_ID` = '211159903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:02:17.707' ,`MLSNumber` = '48546959' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076371' ,`Longitude` = '-95.480935' ,`PhotoCount` = '34' ,`PostalCode` = '77388' ,`RoomCount` = '3' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Rainfall Park' ,`StreetNumber` = '21539' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built in 2016, this Spring two-story home offers granite countertops, and a two-car garage.' ,`Acres` = '0.1188' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 4 PARK AT MEADOWHILL RUN SEC 5 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '359' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park/Meadowhill Run Sec 5 Amd' ,`TaxAmount` = '5715' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668118898' WHERE `Matrix_Unique_ID` = '211160101' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:50:12.920' ,`MLSNumber` = '20698396' ,`ListAgentFullName` = 'Crystal Mason' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661389' ,`Longitude` = '-95.359853' ,`PhotoCount` = '17' ,`PostalCode` = '77051' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Larkspur' ,`StreetNumber` = '4529' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This brand new development is a 2-story, single-family home, that easily accesses 610, I-45, 288..Just minutes away from major universities and Houston Medical Center. It’s very close to Midtown for dining and entertainment, a prime location! \r\nOn the first floor there’s the grand entrance!... A beautiful 18 ft foyer leading you to the open floorplan to the living/dining area and kitchen… It houses a half-bathroom, study and laundry room as well…..Continuing up the gorgeous white oak staircase, the second story includes the primary suite and primary bath, with separate shower, a soaker tub ,and a very spacious walk-in closet with vanity and dressers. The 2nd floor also houses a game room and 2nd and 3rd bedrooms along with 2nd full bath. This home is being enhanced with modern finishes; the kitchen includes stainless steel appliances, shaker cabinets, and much more! Updated photos coming soon! To be completed mid-November! Call today to schedule a tour!' ,`Acres` = '0.1159' ,`Area` = '3' ,`BuilderName` = 'Kensli Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 2 FLOWER CITY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Flower City' ,`TaxAmount` = '956' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118898' WHERE `Matrix_Unique_ID` = '212119598' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:01:43.680' ,`MLSNumber` = '95084405' ,`ListAgentFullName` = 'Rene Ibarra' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803188' ,`Longitude` = '-95.389563' ,`PhotoCount` = '40' ,`PostalCode` = '77008' ,`RoomCount` = '13' ,`ListPrice` = '1695000.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant living awaits you! This very special LEED certified home was completed in 2010 with a focus on water/energy efficiency and sustainability. Commissioned as a custom home by Newberry-Campa, with attention to detail evident throughout including a 500++ bottle wine room, antique door from an historic schooner, custom doors in the downstairs exercise room with dry sauna, designer window coverings, well appointed outdoor kitchen for entertaining al fresco. The main floor includes a media room off the great room, an office and a guest bedroom suite. Exquisite fixtures, cabinetry and accents make this a home truly like no other. The kitchen is a work of art with professional grade appliances and luxe finishes. The comfortable den upstairs could serve as a second office. The deep front porch is the epitome of gracious Heights living, constructed of low-maintenance Ipe wood. Make this custom home yours & live in luxury & style in Houston\'s most sought after historic neighborhood.' ,`Acres` = '0.1687' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 2 BRADSHAW' ,`LotDesciption` = 'Other' ,`LotSize` = '7350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bradshaw Sub' ,`TaxAmount` = '35802' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118898' WHERE `Matrix_Unique_ID` = '212425395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:52:01.617' ,`MLSNumber` = '66458844' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '29' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14826' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning One Story Home By D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco & Brick Elevation! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! Dramatic Family Room features Walls of Windows for natural lightning & Looks out to your Huge Backyard & Covered Patio! Casual Dining flows into Gourmet Kitchen that Features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Large Eat-in Island, Undermount Stainless Sink & DuPure Drinking Water Filtration System! Private Owner\'s Suite W/High Tray Ceilings & Luxurious Bathroom W/His & Her Undermount Sinks Vanity, Deep Soaker Tub, Large Glass Shower & Huge Walk-in Closet. 2 Inches Blinds! Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time! Outstanding Schools for all Ages! More' ,`Acres` = '0.18' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 7 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7804' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`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` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118898' WHERE `Matrix_Unique_ID` = '212464255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:52:01.617' ,`MLSNumber` = '2660302' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '36' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Ready for Move In! Dramatic Chic Elevation W/Stucco & Brick! Covered Patio on a Huge Lot! Stunning Entry W/Gorgeous Luxurious Wood Vinyl Floors leading the path into the Huge Family & Casual Dining Area! Gourmet Kitchen Boast Gorgeous Quartz Countertops, Tile Back-splash, Large Eat-in Working Island w/Undermount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Stunning Tall Shaker Cabinets! Gourmet Kitchen open to the Amazing Family Rm W/High Ceilings & Wall of Windows overlooking Huge Backyard! Private Owner\'s Suite W/Luxurious Bath featuring Huge Vanity W/Cultural Marble Counters, Deep Undermount Sinks, Massive Shower & Huge Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allows you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & almost from anywhere!! 2 Inches White Blinds! NO FLOODING! LOW PROPERTY TAXES, OUTSTANDING SCHOOLS & MORE!' ,`Acres` = '0.16' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 18 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6821' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118899' WHERE `Matrix_Unique_ID` = '212465677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:16:03.357' ,`MLSNumber` = '55471584' ,`ListAgentFullName` = 'Cheryl Oldweiler' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.056247' ,`Longitude` = '-95.463890' ,`PhotoCount` = '45' ,`PostalCode` = '77388' ,`RoomCount` = '13' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Castlegreen' ,`StreetNumber` = '20011' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning, meticulously upgraded home in excellent location. Step in & you can feel that the sellers put their ‘heart and soul’ into every detail of this inviting home. Make sure you check out the upgrades list—there are too many to list. Chef’s kitchen features stainless steel appliances, beautiful granite counters, stacked stone backsplash & breakfast bar. Terrific open floor plan & downstairs Owner’s Retreat (which boasts garden tub, freestanding shower, 2 sinks & impressive walk-in closet). Enjoy premium travertine floors throughout 1st level & engineered wood floor on most of 2nd level. Fresh beautiful paint on 1st level (including garage) (9/22), generous amount of storage. In past 4 years major systems replacements include: roof, A/C & water heater. Lush landscaping & amazing up-lighting greet you when you return home in the evening. Don’t miss the opportunity to call this place home. Easy access to I-45, Grand Pkwy, & Hardy Toll. Convenient to dining & shopping' ,`Acres` = '0.1465' ,`Area` = '13' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 5 LOUETTA LAKES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '488' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Louetta Lakes Sec 03' ,`TaxAmount` = '6611' ,`TaxRate` = '2.769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118899' WHERE `Matrix_Unique_ID` = '212489473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:17:25.723' ,`MLSNumber` = '73740595' ,`ListAgentFullName` = 'Jane LeMoine' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226291' ,`Longitude` = '-95.553893' ,`PhotoCount` = '21' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'WESTWOOD NORTH' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ALL MEASUREMENTS NOT SEEMED TO BE RELIABLE. PLEASE MEASURE YOURSELF. NESTLED AMONGST TALL TREES IN THE DEIREABLE WESTWOOD SUBDIVISION, THIS BEAUTIFUL HOME HAS BEEN TASTEFULLY REDONE FRO, FLOOR TO CEILING. BRAND NEW DRIVE , LANDSCAPING W SPRINKLER STYSTEM. UPON ENTERING, YOU HAVE BEAUTIFUL WOOD FLOORS THAT STEP DOWN TO THE GRANDEOSO FAMILY ROOM. 30 FT CATHEDRAL CEILINGS WITH CAN LIGHTING AND ROWS OF SKYLIGHTS ALLOWING LOTS OF NATURAL LIGHT. A STONE FIREPLACE SETS THE ATMOSPHER OF A SKI LODGE.THE WALL OF WINDOWS AND FRENCH DOORS PRESENT A ZEN FEELING OF ALL NATURE. GREAT FOR ENTERTAINING. ALL NEW STAINLESS APPLIANCES AND BEAUTIFUL CABINETRY IN KITCHEN. FAUX WHITE WOOD BLINDS THROUGHOUT. REGROUND YOURSELF IN NATURE AND FEEL THE FLOW OF SPIRIT.))' ,`Acres` = '0.29' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'lot 155 Blk 9 Westwood Sec 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '19901' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '4089' ,`TaxRate` = '2.321' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118899' WHERE `Matrix_Unique_ID` = '212635516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:37:00.370' ,`MLSNumber` = '87212824' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '285900.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Stylish Timeless Chic 1 story home with Amazing Stucco & Brick Elevation! Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Lush Carpeting in all the Bedrms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Move-in Pkg! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 17 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118899' WHERE `Matrix_Unique_ID` = '212958850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:07:01.087' ,`MLSNumber` = '96064466' ,`ListAgentFullName` = 'Ruhina Ahmed' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572260' ,`Longitude` = '-95.644480' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '975000.00' ,`Status` = 'Active' ,`StreetName` = 'Burclare' ,`StreetNumber` = '4734' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury at its finest. Gorgeous 5 Bedroom, 4.5 baths home situated on a huge lot in the quiet, comforting neighborhood of Telfair. The home is designed to awe when entering. The first floor has a lofty entrance, formal dining, kitchen with granite countertops that opens to the dining room, a high ceiling living area. Two bedroom downstairs, a guest bedroom suite, and a lovely private master bedroom. Upstairs offers not only a game room but also a media room and three secondary bedrooms. Brace yourself to be swooned by this well-maintained house with all the space to satisfy your needs plus more in this neighborhood that is centrally located. With close access to highways and excellent schools, this home is awaiting you and your family! Build a pool in the backyard. Watch the spectacular greenery from your balcony. Home didn\'t flood during Harvey. COME AND SEE THIS BEAUTY AND CALL IT YOUR DREAM HOME!!!' ,`Acres` = '0.2881' ,`Area` = '29' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 24, BLOCK 1, LOT 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12549' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair Sec 24' ,`TaxAmount` = '19312' ,`TaxRate` = '2.9544' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118899' WHERE `Matrix_Unique_ID` = '213031956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:18:36.983' ,`MLSNumber` = '39414288' ,`ListAgentFullName` = 'Lisa Lang' ,`ListOfficeName` = 'State 28 Real Estate, PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.374053' ,`Longitude` = '-95.494068' ,`PhotoCount` = '22' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Mid Pines' ,`StreetNumber` = '167' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A great 2 bedroom in City of Panorama Village, a block from golf course. Corner lot across from park. Vaulted ceiling in LR/DR area. Beautiful mirrored built-ins on either side of brick fireplace w/gas logs. Two Bedrooms w/walk-in closets & Hollywood Bath. Master bedroom has two closets. Separate utility room w/storage inside house. Private covered patio/deck. Panorama Village is conveniently located just minutes from I-45 w/amenities: 27-hole Golf Course, clubhouse, swimming pool, 3 parks, + Pavilion. NO HOA FEES + NO MUD TAX !!! MUST SEE - WON\'T LAST LONG !!!' ,`Acres` = '0.1492' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 167 Panorama Village' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '6500' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Panorama Village' ,`TaxAmount` = '3015' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668118900' WHERE `Matrix_Unique_ID` = '213080723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:37:00.370' ,`MLSNumber` = '2600540' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14926' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story Home The Forest Plan by D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco & Brick Elevation! Stunning Entry W/High Ceilings! Luxury Carefree Vinyl Wood Floors! Lush Carpeting in all bedrooms! Huge Family Rm features Walls of Windows to bring that natural light inside & Looks out to your Huge Backyard! Casual Dining flows into your Gourmet Kitchen that Features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom W/His & Her Undermount Sinks Vanity, Large Glass Shower & Huge Walk-in Closet! 2\" Inches Blinds! Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time! AMAZING LOW Property Taxes!' ,`Acres` = '0.18' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 15 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118900' WHERE `Matrix_Unique_ID` = '213313188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:13:16.457' ,`MLSNumber` = '41833624' ,`ListAgentFullName` = 'Kayla Brisbin' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.113098' ,`Longitude` = '-95.635274' ,`PhotoCount` = '43' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Pines' ,`StreetNumber` = '14111' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CONCESSION FOR BUY DOWN AVAILABLE! Stunning custom home located in the privately gated Spring Pines Estates. Vacation all year long in your backyard oasis with a pool & spa, outdoor shower, pool bath, outdoor living & dining areas + a ton of yard left for pets & kids that MUST BE SEEN IN PERSON! Store your boat in the oversized garage built for just that. Sits on a HUGE LOT w/ 3 beds, 2 baths + 2 half baths. Study w/ French doors, formal dining & game room with built-ins. Spacious family room with soaring ceilings open to the elegant island kitchen w/ bar seating, breakfast area + walk-in pantry. Owner’s retreat features a spa-like ensuite w/ double sinks, vanity space, soaking tub, separate shower + HIS AND HER walk-in closets w/ easy asses to laundry room. Alluring front porch, crown molding, gorgeous chandeliers, full gutters, NEW ROOF & A/C & full irrigation. LOCATION LOCATION LOCATION! Zoned to the highly acclaimed Tomball ISD & less than a mile from Tomball HS.' ,`Acres` = '0.3788' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 SPRING PINES ESTATES R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Pines Estates R/P' ,`TaxAmount` = '7341' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118900' WHERE `Matrix_Unique_ID` = '213479159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:52:00.433' ,`MLSNumber` = '52182361' ,`ListAgentFullName` = 'Jimi Jordan' ,`ListOfficeName` = 'Xterra Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201507' ,`Longitude` = '-97.846506' ,`PhotoCount` = '33' ,`PostalCode` = '78749' ,`RoomCount` = '7' ,`ListPrice` = '589700.00' ,`Status` = 'Active' ,`StreetName` = 'Danli' ,`StreetNumber` = '3905' ,`StreetSuffix` = 'Lane' ,`City` = 'Austin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing reno move in ready. Remodeled, Just a few minutes from down town. New floors, carpet, counters, interior and exterior paint, new HVAC, New Primary bathroom remodeled his and her walk in shower, His and her vanities. New fence, deck and all new Landscaping make this home feel like new. Located in the Austin city limits and convenient to the hill country parks and lakes. Great for Families and Professionals alike. This Home will not last, book a showing today.' ,`Acres` = '0.1326' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 21 BLK I MAPLE RUN SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '111 - Austin' ,`SchoolElementary` = 'COWAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOWIE HIGH SCHOOL (AUSTIN)' ,`SchoolMiddle` = 'COVINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Maple Run Sec 08' ,`TaxAmount` = '7615' ,`TaxRate` = '2.1767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118900' WHERE `Matrix_Unique_ID` = '213629739' --> 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','213857600','1668118901','213857600','2022-11-10T00:20:20.517','81543601','Paula Smith','Insight Realty Network','','','29.816870','-94.978756','16','77521','5','298999.00','Active','Cinnamon Lake','5406','Drive','Baytown','2','1','4','3018','Single-Family','','0.1286','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Baytown/Harris County','Central Gas','1','LT 14 SPRINGFIELD ESTATES SEC 3','Subdivision Lot','5603','Appraisal District','','340','0','','2','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','VICTORIA WALKER ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Leave Business Card,Supra Keybox','Appraisal District','2','Contemporary/Modern','Springfield Estates Sec 3','6696','3.095','Water District','2004','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','213859159','1668118901','213859159','2022-11-10T00:53:43.750','3376761','Mary Dover','Coldwell Banker Realty, Cy-Fair Office','','','29.963967','-95.601761','39','77429','10','359900.00','Active','Lynn Haven','12919','Street','Cypress','2','1','4','2524','Single-Family','This gem has all the fixings. Featuring a newer kitchen with quartz counters on one side (Hickory Cabinets) and butcher block (White Cabinets) on the other. Modern backsplash, updated bathrooms, flooring, roof (6.5 yrs), Hardie Siding, 200 amp service 6 years ago, extended 300+ square foot patio, windows are 3 yrs old, septic is 2 yrs and the list goes on. As you walk through the front door, to the right is the office with wood tile, to the left is the large living area with shiplap in the living, tiled gas fireplace and tray ceiling with intricate design. Primary bedroom is downstairs and the bath features a freestanding tub and dual head shower with seamless shower door. NO POPCORN CEILINGS. This Open concept makes entertaining a delight. Enjoy the EXTREMELY LOW tax rate, no water bill and tranquility this community offers being tucked away! Nestled on .41 acres will make those family gatherings a delight with the HUGE patio extension. Bring your RV! You will NOT be disappointed.','0.4162','10','','','Electric Dryer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas','0','LT 347 TOWER OAKS PLAZA SEC 3 U/R','Subdivision Lot','18130','Appraisal District','','100','0','','2','Freestanding Oven','0','','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS CREEK HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Accompany,Appointment Required,Lockbox Front,Supra Keybox,Temporarily No Showings','Appraisal','2','Traditional','Tower Oaks Plaza #347 Sec 3','4380','2.1637','Aerobic,Septic Tank,Well','1976','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:06:20.840' ,`MLSNumber` = '91170212' ,`ListAgentFullName` = 'Huy Dinh' ,`ListOfficeName` = 'The Taylor Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752345' ,`Longitude` = '-95.600864' ,`PhotoCount` = '29' ,`PostalCode` = '77077' ,`RoomCount` = '12' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Stafford Springs' ,`StreetNumber` = '12411' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss out on the opportunity to own your dream home in Ashford Forest. It shines like new w/upscale finishes incl. a primary suite extension w/new windows, new roof, additional AC unit for master suite, 2nd water heater for the rain shower. There\'re front/back gutters w/leaf guards & the front gutters are routed to the street. There is a 25-year root barrier installed to protect the foundation & the barrier covers the full front of the house & the back along the side of the garage, in front of the porch & the master extension. There is a sprinkler system installed w/auxiliary tank that can be used to distribute mosquito repellent or fertilizer. There’s a is a 40 AMP circuit in the garage to charge electric vehicles. Additionally, there\'s 240 sqft TuffShed workshop w/ full, professionally done electrical & oversized mini split to cool/heat the unit. Foundation& roof repairs and repiping completed October 2022. All documents are online.' ,`Acres` = '0.2218' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 12 ASHFORD FOREST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9660' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Forest' ,`TaxAmount` = '8550' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118901' WHERE `Matrix_Unique_ID` = '213870085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:07:57.307' ,`MLSNumber` = '32292798' ,`ListAgentFullName` = 'Kayla Brisbin' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019437' ,`Longitude` = '-95.624678' ,`PhotoCount` = '32' ,`PostalCode` = '77377' ,`RoomCount` = '11' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Wandering Streams' ,`StreetNumber` = '12814' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 1 story nestled in Village Creek on a cul-de-sac street. Features 3 bedrooms, 2 baths, private home office, formal dining, soaring ceilings & open concept floor plan. The kitchen boasts abundant cabinet space, a center island, breakfast bar, walk-in pantry, planning desk & breakfast area. Enjoy relaxing in the soaking tub of your spa-like primary ensuite, also with separate shower, dual vanities & spacious walk-in closet. Elegant crown molding throughout, French drains, FRESHLY PAINTED interior & exterior! Entertain in the large yard with TV hook up on the covered patio. Village Creek has a community pond with a walking trail, parks, a basketball court, splash-pad, and a pool. LOCATION LOCATION LOCATION! Zoned to the highly acclaimed TRIPLE A RATED Tomball ISD. With easy access to 249, Grand Parkway, Tomball Tollway & IAH.' ,`Acres` = '0.1716' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 VILLAGE CREEK SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '759' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Crk Sec 08' ,`TaxAmount` = '8023' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118901' WHERE `Matrix_Unique_ID` = '213976725' --> 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','213987607','1668118901','213987607','2022-11-09T23:17:31.790','83126992','Anna Amboree','Amboree & Associates','','','29.886528','-95.455179','9','77088','5','195000.00','Active','Lonallen','10013','Street','Houston','1','0','3','1251','Single-Family','Beautifully updated 3 bedrooms home 1 bathroom home in a neighborhood with no HOA! This home offers many upgrades - floors, fresh paint, granite in the kitchen, upgraded HVAC, bathroom, condenser unit and windows. Close to all major freeways. Must see to appreciate!','0.1268','11','','','','','Sellers Disclosure','','','','Northwest Houston','Central Gas','0','LT72 BLK C 017*G0351300-000-C00-072 GARDEN CITY PARK SEC 1','Subdivision Lot','5524','Appraisal District','','','0','','0','','0','','','','','Composition','32 - Klein','NITSCH ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Colonial','Garden City Park Sec 01','2685','2.5451','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:40:12.430' ,`MLSNumber` = '62166810' ,`ListAgentFullName` = 'Tiesha Gay' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Jamie Graves' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.817392' ,`Longitude` = '-95.074503' ,`PhotoCount` = '22' ,`PostalCode` = '77562' ,`RoomCount` = '4' ,`ListPrice` = '298000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Clear Lake' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Road' ,`City` = 'Highlands' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful newly renovated Ranch Style home priced to sale. Move in with equity as this home is currently listed well below market. This home sits on a little over a 1/2 acre and is a very unique property. It has an attached guest house that can be used as rental income or extra space for the in-laws or older kids. The guest house includes its own living space, bedroom, private kitchen and full bath. Including the guest house, the home has a total of 4 bedrooms and 4 full baths with an oversized 2 car garage. Brand-new central AC unit and plumbing recently installed. The roof is only 3 years old. The grounds are nice and has plenty of space for boat and RV lovers or big family gatherings. Come out and see this property today.' ,`Acres` = '0.6887' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3A & LT 3A BLK 46 HIGHLAND TOWNSITE ABST 83 J WHITE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Highland Townsite' ,`TaxAmount` = '3337' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118901' WHERE `Matrix_Unique_ID` = '214033993' --> 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','214049375','1668118901','214049375','2022-11-09T23:49:52.530','48616879','Brandi Wade','Diverse City Realty','','','29.727074','-95.368571','21','77004','4','310000.00','Active','Eagle','2518','Street','Houston','2','0','3','1518','Single-Family','Spacious 3 bed/2 bath home with original hardwood flooring and loads of character. Home sits on an oversized corner lot in Washington Terrace...steps away from TSU & U of H. Well maintained with minor updates. Comfortably livable in its current condition, but just a bit of polish would make this gem sparkle. Well suited for an owner occupier, landlord, or investor who wants to add their own special touch. Once you walk in the door, you will be amazed!','0.1205','4','','','','','Sellers Disclosure','','','1','University Area','Central Electric','0','LT 11 BLK 11 WASHINGTON TERRACE','Corner','5250','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Washington Terrace','3869','2.3307','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:06:30.650' ,`MLSNumber` = '62846643' ,`ListAgentFullName` = 'Myrna Armendariz' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564959' ,`Longitude` = '-95.757629' ,`PhotoCount` = '24' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Richmond Place' ,`StreetNumber` = '455' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story property with three bedrooms and a study/extra room. Huge corner lot around 1/4 acre within the intimate Richmond Place neighborhood. Updated tile flooring & fresh paint throughout. Walking distance to the George Memorial Library, shopping and growth in the area. LCISD Schools. Low tax rate. Easy access to I59/FM762/Thompson Rd.' ,`Acres` = '0.2469' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RICHMOND PLACE PHASE ONE, LOT 34' ,`LotDesciption` = 'Corner' ,`LotSize` = '10753' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Richmond Place Ph One' ,`TaxAmount` = '5308' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118901' WHERE `Matrix_Unique_ID` = '214153280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:01:51.357' ,`MLSNumber` = '21715367' ,`ListAgentFullName` = 'Allison Tims' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286297' ,`Longitude` = '-95.478874' ,`PhotoCount` = '23' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Windsor' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PICTURES JUST ADDED 11/9!! KITCHEN COMPLETED UPDATED with Beautiful QUARTZ Countertops! New Backsplash. ALL NEW FLOORING Downstairs!! HUGE PRIMARY SUITE with Huge Walk-in Closet and Double Doors to In-suite Bathroom with Soaking Tub!! . All nice size BR\'s with Walk-in Closets! BRAND NEW AC!! NEW Dishwasher! NEW Fence with Double Gates! NEW push button Toilets! Kitchen has New Disposal, New Sink, Updated Lighting and New Paint! Features gas appliances and opens to breakfast and family room. Lots of windows to invite natural sunlight! Both formals. Covered Patio overlooks Large Private Backyard with a very nice sized Shed with AC! Large lot in the Beautiful neighborhood of Rivershire. Centrally located just minutes to I-45, Lake Conroe is Only 15 Minutes Away! Woodlands Mall 10 minutes away! Brand new stores all around!! You Are Going to LOVE Living Here!!' ,`Acres` = '0.2348' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSHIRE 02 BK 7 LT 35&W31\'OF LT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Rivershire 02' ,`TaxAmount` = '6586' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118902' WHERE `Matrix_Unique_ID` = '214398855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:09:31.170' ,`MLSNumber` = '61902810' ,`ListAgentFullName` = 'Katrina Lively' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999073' ,`Longitude` = '-95.179548' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Kristen Park' ,`StreetNumber` = '6222' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This beautiful property features 4 bedrooms, 2 baths, open concept living/kitchen, kitchen with an island and granite countertops, breakfast bar, formal dining room, large bedrooms with walk in closets for all the storage one could ask for. Step out the french doors to a beautiful pool with relaxing water feature and pergola covered patio. No back neighbors! Kingwood Glen is perfectly situated near great shopping, restaurants, elementary school, parks, Lake Houston and so much more! Schedule your showing soon!' ,`Acres` = '0.1389' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 KINGWOOD GLEN SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Glen Sec' ,`TaxAmount` = '6036' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118902' WHERE `Matrix_Unique_ID` = '214431734' --> 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','214453165','1668118902','214453165','2022-11-10T00:19:22.767','54118990','Martin Reyes','BHGRE Gary Greene','','','29.971981','-95.442205','39','77014','10','236000.00','Active','Ridgebriar','1623','Drive','Houston','2','0','3','1594','Single-Family','Welcome home to 1623 Ridgebriar Drive. Location, beauty and character. This beautiful 3 Bedroom home is ready to be your home! Tile and laminate flooring throughout. Split floor plan. Spacious kitchen with lots of storage, large dining room, and spacious living room with high ceiling. The master bedroom has an addition that could be used as the 4th bedroom. About 22 minutes from Downtown Houston, The Woodlands, and George Bush International Houston Airport, just 16 minutes from Willowbrook Mall, and just 4 minutes from the North Houston Skate Park. Home has an outside 9X7 shed with electricity. Beautiful front and back yards, gutters throughout and spacious double wide driveway. Come see it today!','0.1664','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','1960/Cypress Creek South','Central Gas','1','LT 135 BLK 11 CRANBROOK SEC 2 PAR R/P','Subdivision Lot','7249','Appraisal District','','400','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','CLARK ELEMENTARY SCHOOL (SPRING)','ANDY DEKANEY H S','STELLE CLAUGHTON MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Cranbrook Sec 02 Prcl R/P','4283','2.7192','Water District','1993','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','214509881','1668118902','214509881','2022-11-09T23:58:50.637','7280768','Ana Torres','REALM Real Estate Professional','','','30.616547','-95.168177','4','77331','3','130000.00','Active','Stewart','129','Street','Coldspring','2','0','2','980','Single-Family','','0.3138','64','','','','','No Disclosures,Short Sale','','','','Lake Livingston Area','Central Electric','0','CEDAR RIDGE, LOT 10, HUD# NO INFO AVAILABLE, TITLE# NO INFO','Subdivision Lot','13669','Appraisal District','','','0','','0','','0','','','','','Other','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Temporarily No Showings','Seller','1','Traditional','Cedar Ridge','318','1.6254','Septic Tank','1978','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','214519157','1668118902','214519157','2022-11-09T23:47:53.630','89639599','Keefer Grace','CB&A, Realtors','','','30.255000','-95.823620','45','77363','9','195000.00','Active','Redwood','16542','Court','Plantersville','1','0','3','1349','Single-Family','Adorable and super clean 3 bedroom one bath home on .63 acres. Situated on a beautiful and serene wooded lot, go fishing in nearby Mill Creek which is private to the neighborhood, and it\'s walking distance to the Renaissance Festival! Tons of natural light and a 2 year old HVAC!','0.62','60','','','Electric Dryer Connections','','No Disclosures','','','','Plantersville Area','Central Electric','1','MILL CREEK FRST, SEC 2, LOT 29-2, ACRES .62','Wooded','27007','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','129 - Navasota','HIGH POINT ELEMENTARY SCHOOL (Navasota)','NAVASOTA HIGH SCHOOL','NAVASOTA JUNIOR HIGH','Lockbox Front','Appraisal District','1','Traditional','Mill Creek Frst, Sec 2','2144','1.6551','Septic Tank','1970','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:23:18.197' ,`MLSNumber` = '27642719' ,`ListAgentFullName` = 'Carlos Martinez' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792652' ,`Longitude` = '-95.573064' ,`PhotoCount` = '1' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '529750.00' ,`Status` = 'Active' ,`StreetName` = 'Swang Link' ,`StreetNumber` = '10977' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brand new home at Brittmoore Crossing Community. First-floor living at its finest. Elegant wood-look flooring. Energy-efficient windows, full wall of sliding doors, create a refined foundation for your personal design style. Quartz countertops and painted cabinetry upgrades in kitchen. Upstairs spacious Owner\'s Retreat with large walk-in closet, 14\' cathedral ceiling, & delightful en suite bathroom. Two additional bedrooms with a full bath. Full-sized laundry room. Second floor landing is perfect space for home office! Guests can park in your FULL DRIVEWAY! Builders warranty and low-maintenance lifestyle. Low property taxes (2.67%). HOA includes water (no monthly water bill), trash and recycling service, pool, recreational areas, gate maintenance and basic landscape maintenance (front and back). Easy access to Main Thoroughfares, Shopping, Markets, Parks and Entertainment, Sports, Hospitals and much more.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 17 BLOCK 02' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2349' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brittmoore Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.67' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118902' WHERE `Matrix_Unique_ID` = '214535385' --> 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','214542171','1668118902','214542171','2022-11-09T23:04:12.050','71346782','Juan Carlos Say','Security American Realty, Inc.','','','29.992079','-95.503103','50','77069','7','349900.00','Active','Cashel Glen','4602','Drive','Houston','2','1','4','2450','Single-Family','WOW! Darling 4 bedroom/2.5 home with no backyard neighbors. Extended tile/wood look floors sweep you into this brand new/never live in home that boasts LOADS of wonderful upgrades! Island kitchen has white shaker cabinets with hardware, quartz counters, undermount sink, Stainless Steel Appliances including wine cooler, gas cooking, pendant lights and much more! Open floor plan! Great natural light! Private owner\'s retreat with walk-in closet, dual sinks and oversize shower! Great secondary bedrooms! Ceiling fans in all bedrooms! Easy access to freeways! Call today to see this wonderful home!','0.0922','13','Antigua GT Invst','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures,Owner/Agent','1','','','Champions Area','Central Gas','1','LT 1 BLK 4 BIG CYPRESS HILL ESTATES','Subdivision Lot','4016','Appraisal District','','600','1','Never Lived In','2','Electric Oven','0','','','Gas Range','','Composition','32 - Klein','MITTELSTADT ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required','Builder','2','Other Style','Big Cypress Hill Estates','917','2.61','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:17:19.937' ,`MLSNumber` = '75367206' ,`ListAgentFullName` = 'June Tyler' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767433' ,`Longitude` = '-95.005862' ,`PhotoCount` = '26' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Inverness' ,`StreetNumber` = '5119' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring on the holidays! If you are ready to host those endless holiday parties, then this is the perfect home for you! Situated on a large corner lot, this home has way too many upgrades to name including all new appliances, brand new quartz countertops, energy-efficient windows throughout and new showers. There is plenty of room for all of your out of town visitors, space to prepare those secret recipes and a variety of areas to play games, dance, talk quietly or enjoy the big meal. When you need to get away from it all, head outdoors, make s\'mores, stargaze or simply relax by the fire in the oversized backyard. The home is located in the very desirable Country Club Oaks subdivision right in the heart of Baytown, within close proximity to great shopping and dining while having easy access to Houston, Pasadena or Beaumont. Hurry...this one definitely won\'t last long, so call your favorite agent for a showing today!' ,`Acres` = '0.2755' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 15 COUNTRY CLUB OAKS SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Oaks Sec 05' ,`TaxAmount` = '5712' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118902' WHERE `Matrix_Unique_ID` = '214542797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:06:42.913' ,`MLSNumber` = '23122274' ,`ListAgentFullName` = 'Roxanna Plazas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861357' ,`Longitude` = '-95.199167' ,`PhotoCount` = '36' ,`PostalCode` = '77044' ,`RoomCount` = '9' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Vanessa Glen' ,`StreetNumber` = '9722' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This beautiful 4 bedroom 2 bathroom property built in 2018 is located in Hidden Meadow Subdivision. Open concept kitchen with kitchen island and 42 inch cabinets. Dining and living area have an open layout great for entertaining. Energy efficient features include insulated/low E windows, radiant attic barrier and programmable thermostat. No carpet at all, vinyl and tile throughout the house. The bedrooms are very spacious and cozy. The house is located nearby shopping and dining. Easy access to Beltway, Hwy 59 and I-10. Come make this yours!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 1, Section 12' ,`LotDesciption` = 'Other' ,`LotSize` = '5486' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'CARROLL ELEMENTARY SCHOOL (SHELDON)' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Meadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668118903' WHERE `Matrix_Unique_ID` = '214543582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-10T00:12:04.873' ,`MLSNumber` = '81081174' ,`ListAgentFullName` = 'Roxanna Plazas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045470' ,`Longitude` = '-95.599639' ,`PhotoCount` = '32' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '317000.00' ,`Status` = 'Active' ,`StreetName` = 'Lucky Meadow' ,`StreetNumber` = '11915' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom 2.5 bathroom home located in the heart of the beautiful subdivision of Pinecrest Forest & zoned for the award winning Klein Independent School District. Beautiful open floor plan perfect for entertaining, tile and hardwood floors, stunning kitchen with granite counter tops and 42 in cabinets, cozy gas log fireplace, exquisite curb appeal, formal dinning and so much more! This home also features a whirlpool tub and separate shower, large walk in closet and covered patio. This property is strategically located close to Highway 249, HWY 99, and Beltway 8. This home has never flooded. Washer and dryer included! Schedule your showing today!' ,`Acres` = '0.1416' ,`Area` = '14' ,`BuilderName` = '' ,`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 Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 PINECREST FOREST SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinecrest Forest Sec 10' ,`TaxAmount` = '5652' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668118903' WHERE `Matrix_Unique_ID` = '214544165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:22:35.390' ,`MLSNumber` = '29794973' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '36' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14814' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Ready for Move In! Dramatic Chic Elevation W/Stucco & Brick! Covered Patio on a Huge Lot! Stunning Entry W/Gorgeous Luxurious Wood Vinyl Floors leading the path into the Huge Family & Casual Dining Area! Gourmet Kitchen Boast Gorgeous Quartz Countertops, Tile Back-splash, Large Eat-in Working Island w/Undermount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Stunning Tall Shaker Cabinets! Gourmet Kitchen open to the Amazing Family Rm W/High Ceilings & Wall of Windows overlooking Huge Backyard! Private Owner\'s Suite W/Luxurious Bath featuring Huge Vanity W/Cultural Marble Counters, Deep Undermount Sinks, Massive Shower, Deep Soaker Tub & Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allows you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & almost from anywhere!! NO FLOODING! LOW PROPERTY TAXES, OUTSTANDING SCHOOLS & MORE!' ,`Acres` = '0.16' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 4 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118903' WHERE `Matrix_Unique_ID` = '214549066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T23:18:39.850' ,`MLSNumber` = '23760970' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '28' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '321990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14914' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home Ready! Best Schools! The Harris! Chic Stucco & Brick Elevation, Covered Patio, Large Backyard! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! 2 Full Baths & a Half Guest Bathroom! Huge Family Area that features Walls of Windows projecting abundance of natural light inside! Casual Dining flows gracefully into your Dramatic Gourmet Kitchen with Beautiful Stilstone Quartz Counters, Tall Gorgeous Shaker Cabinets, Stainless Appliances, Large Eat-in Island, Deep Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom with His & Her Undermount Sinks Vanity W/Cultured Marble Counters, Deep Soaker Tub, Large Seamless Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Not In Flood Zone at this time' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 12 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668118903' WHERE `Matrix_Unique_ID` = '214549199' --> 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','214586121','1668118904','214586121','2022-11-10T00:30:10.833','62523027','Natalie Glass','Natalie Glass Properties','','','28.131326','-96.979073','25','78382','3','1099000.00','Active','Foxtail','114','Lane','Rockport','2','0','3','1747','Single-Family','Amazing Coastal one story home in prestigious gated community! Premium automatic boat lift perfect for avid fisherman!! Recent construction, open floor plan with vaulted ceilings throughout great room. Island Kitchen with quartz counters, stainless appliances with gas range. Kitchen is open to dining and family room. Tons of windows and French doors overlooking canal with direct access to Aransas Bay. Sit on your covered patio with grill and watch the games. Or have coffee and cocktails with the ocean breeze, view of dolphins and breathtaking sunsets. Luxurious primary suite with dual sinks, oversized shower with bench and walk-in closet. Spacious secondary bedrooms with full bath. Private garage for golf cart or more toys. All furniture, art work, TVs and accessories included. Rockport is known for fishing, art shows, beach and seafood festivals. Charming beach community! Boat is also available for sale.','0.1304','85','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Gas','1','THE RESERVE AT ST. CHARLES BAY PHASE 3 BLK 4 LOT 33','Subdivision Lot,Waterfront','5680','Appraisal District','','1650','0','','1','Freestanding Oven','0','','','Freestanding Range,Gas Range','','Aluminum','310 - Aransas County','LIVE OAK 1-3 LEARNING CENTER','ROCKPORT-FULTON HIGH SCHOOL','ROCKPORT-FULTON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Contemporary/Modern,Craftsman,Traditional','The Reserve At St Charles Bay','16895','2.3696','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully