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-09-06T19:52:43.993' ,`MLSNumber` = '2063589' ,`ListAgentFullName` = 'Lorannette Lewis' ,`ListOfficeName` = 'In Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819754' ,`Longitude` = '-95.430125' ,`PhotoCount` = '32' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Balzy' ,`StreetNumber` = '3506' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LARGE BACKYARD & ZONE TO OAK FOREST ELEMENTARY! \r\n\r\nThe Sterling, built by Sandcastle Homes, is a freestanding, two-story home located in Oak Forest. The popular floor plan features an open-concept layout throughout the first floor, with a large dining and living area. Step into a luxurious kitchen, complete with custom cabinets, stainless steel appliances, and quartz countertops. The primary and secondary bedrooms are on the second floor, and all have spacious walk-in closets. The game room is on the second level as well and features built-in shelves for additional storage. The home is in the initial stages of construction, allowing homebuyers to select the home\'s finishes and/or upgrades. Move-in-Ready October 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Sandcastle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 7, BLOCK 1, THE PATIO HOMES AT BALZY WEST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Judiway Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707555' WHERE `Matrix_Unique_ID` = '205402031' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:00:57.117' ,`MLSNumber` = '26614720' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Jared Turner' ,`SellingOfficeName` = 'Turner Mangum,LLC' ,`Latitude` = '30.252472' ,`Longitude` = '-95.522165' ,`PhotoCount` = '7' ,`PostalCode` = '77384' ,`RoomCount` = '4' ,`ListPrice` = '442090.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Valley Creek' ,`StreetNumber` = '14027' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New MODERN SERIES DR Horton home! Beautiful one story home with 3 car garage. This new construction home features gorgeous brick and stucco exterior and includes 4 bed/2.5 bath and a 3 Car Garage! Features include SS appliances w/gas burner cooktop, Quartz, and 36\" white cabinets in Kitchen, Separate shower, Smart Home Package, Solid Surface Flooring throughout, Tankless Water Heater, Covered Patio, and Full Sprinkler System. Fosters Ridge offers beautiful community center, playground, and pool. Zoned to The Woodlands Schools! DR Horton is America\'s #1 Homebuilder! Come out to Fosters Ridge and make this new home yours today!' ,`Acres` = '0.1981' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516422 - FOSTERS RIDGE 22, BLOCK 1, LOT 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8631' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fosters Ridge 22' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707555' WHERE `Matrix_Unique_ID` = '206986293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:13:21.103' ,`MLSNumber` = '76696754' ,`ListAgentFullName` = 'Lin Day' ,`ListOfficeName` = 'Soho USA Realty LLC' ,`SellingAgentFullName` = 'Gretchen Barrilleaux' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.574503' ,`Longitude` = '-95.589055' ,`PhotoCount` = '30' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '309900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Great Lakes' ,`StreetNumber` = '3010' ,`StreetSuffix` = 'Avenue' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1713' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPGRADED COZY NEWMARK HOME with recently remodeled master bathroom & new Jacuzzi. PLEASE ASK AGENT TO DOWNLOAD \'\'UPDATED ITEMIZED LIST\'\' FROM ML\"s TEMPLE. UPGRATED ITEMS INCLUDING: new water pipe for whole house water system, French drainage on the back yard, sprinkle system, fresh paint for whole house, new epoxy flooring for the garage, new faucet for bathroom, New 2021 TRAN Cooling System and kitchen etc.....). WALKING DISTANCE TO SHOPPING CENTER, ELEMENTARY SCHOOL, RECREATION CENTER, WATER PARK & LAKE. GREAT FLOOR PLANE W. 2FL HIGH CEILING ENTRANCE. TILE FLOOR THRU ALL 1ST FLOOR & NEW 12mm LAMINATE FLOOR ON 2ND FLOOR. LARGE KITCHEN.GRANITE COUNTERTOP FOR KITCHEN & ALL BATHROOMS. VAULTED CEILING IN MASTER BEDROOM. LARGE BACK FENCED YARD BY GREENBELT W/O ANY BACK NEIGHBOR.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'NEWMARK' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEFIELD SEC 1, BLOCK 1, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '816' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'LAKEFIELD SEC 1' ,`TaxAmount` = '3224' ,`TaxRate` = '2.33681' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707555' WHERE `Matrix_Unique_ID` = '207925290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T18:25:22.513' ,`MLSNumber` = '91547338' ,`ListAgentFullName` = 'Travis Harris' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.339950' ,`Longitude` = '-95.492052' ,`PhotoCount` = '32' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '477777.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Highlands' ,`StreetNumber` = '2513' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3157' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home on cul-de-sac in the Graystone Hills. This well-maintained home features 4 specious bedrooms, 3.5 baths, formal dining, and island kitchen, large primary bedroom on first floor. Game room, media room and secondary bedrooms on second floor. Large Kitchen w/marble herringbone backsplash. Covered & screened patio with slate tile floor, pool with slide for outdoors entertaining. Oversized garage with workspace. GE stainless side by side refrigerator, Samsung Washer/Dryer, Rain bird sprinkler system, whole home water softener system, All new custom painted walls and ceilings, Generac whole home generator. Backyard oasis features a natural stone waterfall, Pool/Spa/Slide for outdoor entertaining. Zoned to Conroe ISD and children attend Giesinger Elementary (A National Blue Ribbon School), Harold Cryar Intermediate, John Peet Junior High, & Conroe High School (School zoning subject to change by Conroe ISD.) Nearby shopping, restaurants, & Golf courses.' ,`Acres` = '0.2644' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539302 - GRAYSTONE HILLS 02, BLOCK 2, LOT 32' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11517' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '785' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Graystone Hills 02' ,`TaxAmount` = '9174' ,`TaxRate` = '2.7763' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707555' WHERE `Matrix_Unique_ID` = '209242442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:44:16.470' ,`MLSNumber` = '66516007' ,`ListAgentFullName` = 'Don Allen' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042776' ,`Longitude` = '-95.589997' ,`PhotoCount` = '29' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Dahlia Dale' ,`StreetNumber` = '11527' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than New! This Spacious Four Bedroom Home has Room for Everyone! Updates and Upgrades Everywhere! This Property Features Three Baths, one Bedroom Down and Gameroom up. All Kinds of Electrical and Security Upgrades and Cameras, even a Generator Interlock Upgrade for your Generator. Award Winning Klein ISD Schools right around the corner. A Chef\'s Kitchen with Granite Counters. This Home is a Place to Relax and Entertain!\r\nExtra Large Storage Room in the Back. Even a Veggie Garden! Close to Hwy 249 and The Grand Parkway! Shopping near by as well. Location is Great! Call today to find out more information and set up a Private Showing!' ,`Acres` = '0.1085' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 ASHFORD GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '405' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Grove Sec 1' ,`TaxAmount` = '5947' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707556' WHERE `Matrix_Unique_ID` = '209579471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T18:55:11.173' ,`MLSNumber` = '27213530' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872710' ,`Longitude` = '-94.876841' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '390542.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Forest' ,`StreetNumber` = '12115' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See Sample Virtual Tour! 2.15 TAX RATE!!! Big Lot!!! Beautiful 1 Story, The Aintree floor plan with 4 Bedrooms, 2 Baths, with a 2 CAR GARAGE. This home boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study, Primary Bedroom w/Ensuite Bath, 3 Secondary Bedrooms, and Secondary Bath. You will love the Kitchen with lots of cabinets and granite or quartz countertops with under the cabinet lighting, SS appliances, & even a USB outlet. Covered Patio & Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, Pex Hot & Cold Water Lines, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Quick commutes from Baytown, Dayton, Grand Parkway, I-10 & near a variety of local shopping, dining, & entertainment. Neighborhood access to Eagle Pointe Recreation Complex. Barber Hill ISD!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8004' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Champions Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707556' WHERE `Matrix_Unique_ID` = '209838114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T18:53:00.447' ,`MLSNumber` = '11699004' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874397' ,`Longitude` = '-94.873474' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '381617.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Forest' ,`StreetNumber` = '12119' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See Sample Virtual Tour! Welcome home to your beautiful Wetherby Floor Plan 1 Story, 3 Bedroom, 2 Bath, with an attached 2 Car Garage and Home Office. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Home Office and 2 spacious bedrooms. Primary Bedroom with large walk in closet. COVERED PATIO with fenced backyard. Tile and Carpet throughout. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, Pex Hot & Cold Water Lines, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Quick commutes from Baytown, Dayton, Grand Parkway, I-10 & near a variety of local shopping, dining, & entertainment. Neighborhood access to Eagle Pointe Recreation Complex. Barber Hill ISD!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8044' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Champions Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707556' WHERE `Matrix_Unique_ID` = '209839133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T18:58:53.080' ,`MLSNumber` = '51115400' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874653' ,`Longitude` = '-94.872989' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '10' ,`ListPrice` = '446362.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Forest' ,`StreetNumber` = '12123' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2.15 TAX RATE! Beautiful 2 Story, The Winchester Floor Plan with 4 Bedrooms, 3 1/2 Baths, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room w/Gas Log Fireplace, Kitchen, Breakfast Room, Home Office, and the Primary Bedroom downstairs. Upstairs you will find a Game Room, 1 Bedrooms with ensuite Full Bath, 2 Bedrooms, and another Full Bath. You will love the Kitchen with lots of cabinets with under the cabinet lighting, Quartz/Granite countertops, SS appliances, and even a USB outlet. Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, PEX Hot & Cold Water Lines, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Quick commutes from Baytown, Dayton, Grand Parkway, I-10 & near a variety of local shopping, dining, & entertainment. Neighborhood access to Eagle Pointe Recreation Complex. Barber Hill ISD!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8044' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707556' WHERE `Matrix_Unique_ID` = '209840709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:00:34.340' ,`MLSNumber` = '89298279' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874746' ,`Longitude` = '-94.872820' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '397364.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Forest' ,`StreetNumber` = '12127' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See Sample Virtual Tour! 2.15 TAX RATE!!! Welcome home to your beautiful 1 Story, The Brighton Floor Plan with 4 Bedrooms, 3 Baths, with an attached 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room w/Gas Log Fireplace, Kitchen, Breakfast Room, and 4 spacious bedrooms. You will love the secluded Owner’s Retreat with its oversized closet. The Kitchen has lots of cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Fenced Backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines,Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Quick commutes from Baytown, Dayton, Grand Parkway, I-10 & near a variety of local shopping, dining, & entertainment. Neighborhood access to Eagle Pointe Recreation Complex. Barber Hill ISD!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Champions Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707556' WHERE `Matrix_Unique_ID` = '209841069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:03:45.967' ,`MLSNumber` = '72510033' ,`ListAgentFullName` = 'Brittany Johnson' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043415' ,`Longitude` = '-95.451688' ,`PhotoCount` = '50' ,`PostalCode` = '77388' ,`RoomCount` = '11' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Hendricks Lakes' ,`StreetNumber` = '2614' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2883' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the highly desirable gated community of Lakes of Cypress Forest. This resort style community includes walking trails, pristine lakes, parks and a community pool with a splash feature. This one story, 4 bedroom, 2 bath home shows perfectly. The impressive primary suite includes a sitting area, hardwood flooring, two large walk-in closets, double vanity sinks, jetted tub for soaking and a separate shower. The oversized living area has high ceilings, a stone fireplace, built-in shelving and 3 floor to ceiling windows to allow all the natural light.The kitchen overlooks the breakfast and family room and includes stainless steel appliances, granite counter tops and a large island. Kitchen refrigerator and washer/dryer included. The entire home is freshly painted 6/4/22. Never flooded, Brand new AC, tankless water heater and exterior backyard fence installed. Minutes from I-45, 99, the Hardy Toll, The Woodlands, Exxon\'s campus and Bush Intercontinental Airport.' ,`Acres` = '0.1982' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 LAKES OF CYPRESS FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8633' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Cypress Forest Sec 01' ,`TaxAmount` = '8150' ,`TaxRate` = '2.484' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707556' WHERE `Matrix_Unique_ID` = '209844759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:39:53.097' ,`MLSNumber` = '39698033' ,`ListAgentFullName` = 'Lorannette Lewis' ,`ListOfficeName` = 'In Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819932' ,`Longitude` = '-95.430137' ,`PhotoCount` = '38' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '554900.00' ,`Status` = 'Active' ,`StreetName` = 'Balzy' ,`StreetNumber` = '3510' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lisbon is one of Sandcastle Homes\' specialty floor plans. The functional layout features three bedrooms, two full baths, and one-half bath. In addition to the spacious bedrooms, the home boasts a large multi-purpose game room located on the second level. This home in particular will have a large backyard the whole family, including the furry relatives, can enjoy! Future residents can park either in their two-car garage or in their private driveway. Move-In Ready October 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Sandcastle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 5, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3447' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'EastJudiway Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707556' WHERE `Matrix_Unique_ID` = '209906232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T18:34:13.000' ,`MLSNumber` = '98942647' ,`ListAgentFullName` = 'Kelsey Mccollum' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.392009' ,`Longitude` = '-95.108810' ,`PhotoCount` = '46' ,`PostalCode` = '77510' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Walker St' ,`StreetNumber` = '13455' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1671' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welome to Beautiful Santa Fe!! This spacious home has everything you need including a large family room, a bright sun room, a huge yard, and more! Minutes from Haak Winery, and local shopping. You do not want to miss out on this gorgeous country home!!' ,`Acres` = '0.739' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 PT OF LOT 230 (230-13) THAMANS 2ND SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '32191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Thamans 2nd Sub 91' ,`TaxAmount` = '5139' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707557' WHERE `Matrix_Unique_ID` = '210265752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:24:52.987' ,`MLSNumber` = '36536456' ,`ListAgentFullName` = 'Lucia Moore' ,`ListOfficeName` = 'Kino Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777506' ,`Longitude` = '-94.921432' ,`PhotoCount` = '38' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning recently remodeled colonial home sits on 3.4 acres. The grand living space w /soaring ceilings looks out onto a breathtaking view of the Cedar Bayou, swimming pool, & private creek. Elegant French doors allow abundance of natural light in & easy access to the wrapped around porch. Impressive kitchen has a double island & quartz countertops, custom cabinetry, 6 burner/2 oven Fisher & Paykel range wrapped in stone wall w/decorative backsplash & water pot filler. The cuddly master bedroom is adorned w/ double French doors allowing access to the front/side yard. Large master suite bath features his & her sinks, a large shower, & free standing soaking tub. Spacious secondary bedrooms have nice views of the property & bayou. Other highlights include & not limited to engineered wood flooring, speakers, elevator & utility elevator, extra storage. The spacious guest house is fully equipped with a living room/ breakfast area/kitchen/one bedroom w/extra room/full bathroom/storage.' ,`Acres` = '3.4403' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 5A-1 ABST 69 C SMITH' ,`LotDesciption` = 'Water View,Wooded' ,`LotSize` = '149859' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Christian Smith Surv Sec-Four' ,`TaxAmount` = '28586' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707557' WHERE `Matrix_Unique_ID` = '210549990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:17:03.620' ,`MLSNumber` = '7928593' ,`ListAgentFullName` = 'Marouane Nejmaoui' ,`ListOfficeName` = 'K & T Realty Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753305' ,`Longitude` = '-95.783086' ,`PhotoCount` = '28' ,`PostalCode` = '77494' ,`RoomCount` = '6' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Cactus Bloom' ,`StreetNumber` = '2114' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom, 3 bathroom home with open floor plan on a cul-de-sac in well established Falcon Ranch. Home is less than 75 yards from kids\' playground. Executive master bath features dual vanities, separate shower, and garden tub. Home is 10 min drive to Katy Mills mall, 5 minutes to La Cantera, and a couple of minutes to grand parkway (99) and the highly rated Katy school district.' ,`Acres` = '0.1588' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 6, BLOCK 2, LOT 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Ranch Sec 6' ,`TaxAmount` = '8181' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707557' WHERE `Matrix_Unique_ID` = '210709835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:38:20.963' ,`MLSNumber` = '39623420' ,`ListAgentFullName` = 'Lorannette Lewis' ,`ListOfficeName` = 'In Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820154' ,`Longitude` = '-95.430139' ,`PhotoCount` = '14' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '584900.00' ,`Status` = 'Active' ,`StreetName` = 'Balzy' ,`StreetNumber` = '3516' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LARGE BACKYARD & ZONE TO OAK FOREST ELEMENTARY! \r\nThe Sterling, built by Sandcastle Homes, is a freestanding, two-story home located in Oak Forest. The popular floor plan features an open-concept layout throughout the first floor, with a large dining and living area. Step into a luxurious kitchen, complete with custom cabinets, stainless steel appliances, and quartz countertops. The primary and secondary bedrooms are on the second floor, and all have spacious walk-in closets. The game room is on the second level as well and features built-in shelves for additional storage. The home is in the initial stages of construction, allowing homebuyers to select the home\'s finishes and/or upgrades. Move-in-Ready December 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Sandcastle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Judiway Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707557' WHERE `Matrix_Unique_ID` = '210842382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:15:08.257' ,`MLSNumber` = '54657017' ,`ListAgentFullName` = 'Diane Kink' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157065' ,`Longitude` = '-95.472695' ,`PhotoCount` = '28' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Amerson Bay' ,`StreetNumber` = '27' ,`StreetSuffix` = 'Way' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, David Weekley home in an OUTSTANDING LOCATION. Like new construction, convenient to all the amenities of The Woodlands. Located in the private, gated East Shore Landing community, to area shopping, dining, & year-round entertainment including art festivals, music, & culture. Experience an abundance of nature trails & welcoming activities that The Woodlands is known for nationwide. Property highlights include high ceilings, all tile flooring; custom light fixtures; a high-end kitchen w/stainless steel appliances, a large island, & custom cabinetry; generous storage throughout. The first floor includes a kitchen, dining area, great room, powder room & well-thought custom bar area. A spacious primary retreat, laundry room & two secondary suites are located on the 2nd level while a generous flex space making way for a game-room/study or home gym completes the 3rd level. HOA Amenities include Pool, Clubhouse w/gym, entertaining area w/fireplace, and full kitchen!' ,`Acres` = '0.0664' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'EAST SHORE 19, BLOCK 3, LOT' ,`LotDesciption` = 'Other' ,`LotSize` = '2893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2930' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'EAST SHORE LANDING' ,`TaxAmount` = '1209' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707557' WHERE `Matrix_Unique_ID` = '210935359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T18:42:19.823' ,`MLSNumber` = '44567604' ,`ListAgentFullName` = 'Toi Glover' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.992384' ,`Longitude` = '-95.582125' ,`PhotoCount` = '19' ,`PostalCode` = '77422' ,`RoomCount` = '3' ,`ListPrice` = '171900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 510f' ,`StreetNumber` = '20310' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly Renovated home with 3 bedrooms 1 1/2 Baths and a BONUS room!!! NEW CARPET THROUGHOUT! FRESH INTERIOR PAINT! KITCHEN CONSISTS OF NEW BUTCHER BLOCK COUNTERTOPS AND PAINTED CABINETS! NEW TILE IN RESTROOMS/BONUS ROOM! NEW DISHWASHER AND WATER HEATER!! NEW LIGHT FIXTURES THROUGHOUT! NICE SIZED LOT WITH NO RESTRICTIONS!! COME CHECK IT OUT!!' ,`Acres` = '0.1791' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HOLIDAY SHORES (A0092 JNO MCNELL), BLOCK 29, LOT 1 SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holiday Shores' ,`TaxAmount` = '1265' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707557' WHERE `Matrix_Unique_ID` = '211161200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:52:38.550' ,`MLSNumber` = '43594934' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024059' ,`Longitude` = '-95.100230' ,`PhotoCount` = '26' ,`PostalCode` = '77336' ,`RoomCount` = '8' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Ripple' ,`StreetNumber` = '1011' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED $10,000!! GREAT VALUE!! GREAT LOCATION!! HUFFMAN ISD!! Fall in love with this recently updated home on oversized lot with No Back Yard Neighbors! Recent updates include, inside paint, granite countertops, new hot water heater, stainless appliances, new replacement windows (per seller, transferrable warranty hurricane proof up to 130 mph winds). Includes 12 x12 Storage Building. Enjoy the neighborhood pool, boat launch & park. All of this in close proximity to Lake Houston and FM1960!' ,`Acres` = '0.2686' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 644 BLK 30 LAKEWOOD HEIGHTS SEC 3 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '256' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Heights Sec 03 R/P' ,`TaxAmount` = '3527' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707557' WHERE `Matrix_Unique_ID` = '211435957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T18:59:10.850' ,`MLSNumber` = '36222379' ,`ListAgentFullName` = 'Lana Hayes' ,`ListOfficeName` = 'TAS Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689459' ,`Longitude` = '-95.344387' ,`PhotoCount` = '8' ,`PostalCode` = '77021' ,`RoomCount` = '6' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Gren' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Centrally located near the University of Houston, Texas Southern University and the Texas Medical Center. Great remodeling project.' ,`Acres` = '0.1515' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 235 BLK 10 MACGREGOR TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARTSFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Terrace Sec 01' ,`TaxAmount` = '2923' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707558' WHERE `Matrix_Unique_ID` = '211467026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T19:29:25.873' ,`MLSNumber` = '30096235' ,`ListAgentFullName` = 'Christopher Tubbs' ,`ListOfficeName` = 'IDG Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159546' ,`Longitude` = '-95.500744' ,`PhotoCount` = '35' ,`PostalCode` = '77381' ,`RoomCount` = '7' ,`ListPrice` = '308000.00' ,`Status` = 'Active' ,`StreetName` = 'Early Dawn' ,`StreetNumber` = '20' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quiet cul de sac living. Nicely updated 3/2. Fresh light paint. Sparkling White quartz kitchen counters with soothing green glass and travertine splash. Updated faucets, and hardware. new LED lights in kitchen and living room. Master bath soft-close vanity, newly tiled shower, and floor. The living room vaulted ceiling-high brick fireplace is complemented by plantation-shuttered picture windows that look out to trees and greenery. The kitchen has a breakfast bar & ample table space so one can opt for a larger wraparound living room instead of a formal dining space plus a living room. The roof is 6yrs new. 2019 AC. Four great closets, utility and garage cabinets, and a backyard storage shed.' ,`Acres` = '0.1567' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S972602 - WDLNDS VIL PANTHER CK 02, BLOCK 3, LOT 77' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Panther Ck 02' ,`TaxAmount` = '3452' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707558' WHERE `Matrix_Unique_ID` = '211904368' --> 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','211967298','1663707558','211967298','2022-09-06T19:32:34.197','82192866','Yuhong Zhi','J. Lindsey Properties','','','30.074684','-95.172707','25','77345','7','279000.00','Active','Sandberry','2807','Drive','Houston','2','0','3','1964','Single-Family','Beautiful newly update, one story home in the peaceful neighbourhood of Woodspring Forest, office/work space closed, open concept kitchen with new granite island, new paint, new flooring, family room with warm fireplace welcoming all guests. Primary bedroom has walk-in closet and a separate tub and shower, house sits within walking distance to park and pool, rare pearl!','0.132','32','','','','','Owner/Agent','','','1','Kingwood East','Central Gas','1','LT 2 BLK 1 WOODSPRING FOREST SEC 1','Subdivision Lot','5750','Appraisal District','','400','0','','2','','0','','','','','Composition','29 - Humble','HIDDEN HOLLOW ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','CREEKWOOD MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal','1','Contemporary/Modern','Woodspring Forest','4875','2.5839','Public Sewer,Public Water','2004','Appraisal'); --> 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','212085033','1663707558','212085033','2022-09-06T18:53:46.390','8221962','Kimberly Newman','eXp Realty, LLC','','','30.597153','-98.418315','50','78643','7','1950000.00','Active','Princess Terrace','227','','Sunrise Beach Village','4','1','3','2780','Single-Family','Lake LBJ Living at it’s finest! Come see this one-of-a-kind Custom-Built Lakehouse on open water w/spectacular views in the Beautiful Sunrise Beach Village! This stunning hm features approx 61-ft of east facing water frontage, 54-ft. pier w/covered sitng area, approx 900+ sf of covered open area w/hand-made cedar floating bar under house w/slip proof tile thru-out, boat lift, & private swim area. Interior offers high ceilings, open concept kit w/great views of the lake, granite counters, brkfst bar, s/s apps, & soft close drs/cabs, laminate wd flrs on 1st flr, 2 oversized Primary Bdrms down & 1 up w/13x6 Balcony that overlooks the lake, 3 full bths & gmrm up. Other amenities are wrought iron fence, oversized garage w/8 ft dr to fit those Big Trucks. Bring your buyers to this magnificent prop & enjoy the incredible sunsets, endless stars on a clear night, countless deer thru-out Sunrise Beach, & soak up the peace, serenity, & great energy. This beauty won’t last long. Make Appt today!','0.1274','83','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','','Central Electric','0','Sunrise Beach II Unit A Lt 139 & Lt 3 of 125','Water View,Waterfront','5549','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Aluminum','183 - Llano','','LLANO HIGH SCHOOL','LLANO JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Other Style,Traditional','Sunrise Beach Village','9196','1.28514','Septic Tank','2014','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','212235373','1663707558','212235373','2022-09-06T19:48:35.783','32965413','Ronnie Matthews','D.R. Horton Homes','','','30.367030','-95.665467','16','77316','5','353990.00','Active','Little Rabbit','1610','','Montgomery','3','0','4','2267','Single-Family','LOVELY NEW D. R. HORTON BUILT ONE STORY! Great Interior Layout! Lovely Foyer Leads to Gourmet Island Kitchen with Big Corner Pantry, Light & Bright Dining Area, & Supersized Family Room! Privately Located Primary Suite Offers Garden Bath with Dual Sinks, Separate Tub & Shower, & Huge Walk-In Closet! Covered Patio & Sprinkler System! High Ceilings, Recessed Lighting, Linen & Coat Closets, Tons of Storage Space - Too Much to List! HURRY! Nestled in the rolling hills along FM 2854, you\'ll find FAIRWATER the NEWEST community in Montgomery, TX! Zoned to the prestigious Montgomery ISD students receive the best education in some of the HIGHEST rated schools in the state! Come see why we are the FASTEST growing community in Montgomery, TX','','39','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Lake Conroe Area','Central Gas','1','Fairwater 07, BLOCK 2, Lot 46','Subdivision Lot','7000','Other','','750','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','37 - Montgomery','KEENAN ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Fairwater','','','Water District','2022','Builder'); --> New record created successfully