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-16T20:59:44.303' ,`MLSNumber` = '77854186' ,`ListAgentFullName` = 'Martha Smith' ,`ListOfficeName` = 'M.L. Smith & Company' ,`SellingAgentFullName` = 'Benjamin Plouvier' ,`SellingOfficeName` = 'HNB Realty, LLC' ,`Latitude` = '29.741049' ,`Longitude` = '-95.613143' ,`PhotoCount` = '27' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '299900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Jamara' ,`StreetNumber` = '2231' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED! Energy Corridor Garden Patio Home; Brick Exterior, 9 Ft High-Ceilings; Hardwoods Travertine Tile, & Commercial grade carpet Flooring. All Bedrooms Down. 2nd Floor has Large Flex Rm + Closet; LR has a Hardwoods / Woodburning Brick Fireplace; Dine under a Crystal Teardrop Chandelier; Open Bar Kitchen w/Granite-like Counters & Travertine Tile Backsplash; Designer tones; Brushed Nickel Hardware; Dbl XL Jenn-Aire Convection Ovens, 2 large Patios + Backyard Gardens; Breakfast & Den open to Kitchen; Ceiling Fans / Wood Blinds. Primary Bedroom had 2 Closets, (1 WIC), Jetted Massage Tub+Shower. 30Yr Roof (2019), Energy Efficient Air Turbines, Sliding Glass Door view Backyard Gardens; 5Ton AC&H system; Upgraded Breaker Box; Titan Lifetime Transferrable Foundation Warranty; recent Fencing; full Sprinkler system, Flagstone walkways & Patios. Back Gardens are under the shade of a Magnificent Grand Oak Tree. Low maintenance gardens. ~All information deemed accurate, but not guaranteed~' ,`Acres` = '0.1148' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 1 BRIAR WOOD SEC 1' ,`LotDesciption` = 'Patio Lot,Subdivision Lot,Wooded' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '552' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Wood' ,`TaxAmount` = '5611' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663711417' WHERE `Matrix_Unique_ID` = '207731216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:59:20.030' ,`MLSNumber` = '77331631' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = 'Rusty Shannon' ,`SellingOfficeName` = 'Patti Shannon Properties' ,`Latitude` = '29.506432' ,`Longitude` = '-95.177706' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '12' ,`ListPrice` = '899000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Butler' ,`StreetNumber` = '2004' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pilots! Your opportunity to purchase a 2 story, metal roofed home & hangar that has never flooded, w/ a Beautiful pool & hot tub, on the Gorgeous Aviation Polly Ranch Estates runway. Close to dining & shopping - close to Houston & a very Active flying Community. This 1981 built home sits on .5510 acres with a 2500 sq ft, well lighted, Aircraft Hangar complete with a 45 ft x 14 high Bi-Fold Wilson Hangar Door, an automatic RV roll up door at 10Wx12H, a full bath & air conditioned pilot lounge, & concrete ramp with multiple tie downs. The Airport Identifier is 7XS0 & has a well maintained 2,700 ft asphalt, lighted 11/29 runway. This home has all of the traditional features from its era like a Formal Living & Formal Dining. A separate Family room with a gas log fireplace for comfort. Large primary bedroom & bath are down while the other 3 bedrooms are up. Huge Gameroom with half bath above the garage. Relax on the rear patio while the grand children swim. #SearchTexasAirparks' ,`Acres` = '0.551' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 11 LOT 116 POLLY RANCH ESTATES REPLAT' ,`LotDesciption` = 'Airpark,Subdivision Lot' ,`LotSize` = '24000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Polly Ranch Estates Rep' ,`TaxAmount` = '10448' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711417' WHERE `Matrix_Unique_ID` = '207751795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:50:45.660' ,`MLSNumber` = '61155655' ,`ListAgentFullName` = 'Elissa Campbell' ,`ListOfficeName` = 'Lucid Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687168' ,`Longitude` = '-95.147636' ,`PhotoCount` = '13' ,`PostalCode` = '77503' ,`RoomCount` = '3' ,`ListPrice` = '249977.00' ,`Status` = 'Active' ,`StreetName` = 'Donerail' ,`StreetNumber` = '4127' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1261' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP THE CAR! You don’t want to miss this house. Recently updated and sure to check all the boxes. Luxury flooring throughout, beautiful fresh paint. Gorgeous updated kitchen. A backyard with endless possibilities, perfect for a game of catch or for a pool. Call to schedule your personal viewing today' ,`Acres` = '0.1636' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 1 BOWLING GREEN SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'CARPENTER ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bowling Green Sec 01' ,`TaxAmount` = '3895' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711417' WHERE `Matrix_Unique_ID` = '207897897' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:12:15.623' ,`MLSNumber` = '26561368' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.293680' ,`Longitude` = '-94.804073' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M' ,`StreetNumber` = '3411' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just blocks from the beach, this revitalized Bungalow with just the right mix of character and upgrades is an absolute treasure. The home features 3 Bedrooms, 2 Baths, a large bonus room that can be used as a 4th bedroom, front and back decks with a huge private back yard. The layout is perfect for entertaining but also to use as an income property. The Kitchen features SS Appliances, Quartz counter-tops, new Cabinets along with a walk in pantry. The Owner\'s Retreat is that of a resort with a double vanity, large Walk-In Shower and closet. Stunningly high and refurbished original ceilings will mesmerize you. Keep cool with the brand new HVAC system and Energy Efficient Windows. The home is also equipped with new plumbing and electrical including a tankless water heater. Location is just minutes away from both the Galveston Sea Wall and The Strand. Perfect getaway to enjoy your time on the Island. Don\'t miss out on this Gem!!' ,`Acres` = '0.1179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 5 NW BLK 12 GALVESTON OUTLOTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '2296' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711417' WHERE `Matrix_Unique_ID` = '208572507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:21:39.427' ,`MLSNumber` = '44340467' ,`ListAgentFullName` = 'Claudia Arauza' ,`ListOfficeName` = 'Woodrow Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341575' ,`Longitude` = '-95.438846' ,`PhotoCount` = '36' ,`PostalCode` = '77303' ,`RoomCount` = '5' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunnington' ,`StreetNumber` = '1908' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home with great curb appeal. Large fenced back yard with no back neighbors! Extended concrete patio make it great for entertaining family and friends. Quiet and well established neighborhood with great amenities; community pool/park. This home features high ceilings in living room. Spacious Game room upstairs overlooking living room. Dark wood tile floors throughout all downstairs. Modern updated kitchen. Granite countertops with back splash. Stainless steel appliances. Plenty of counter and cabinet space. Brand new carpet. Fresh new interior paint. Large stone fireplace. Coated garage floor. Ceiling fans in all rooms. Easy access to I-45, shopping and restaurants. Zone to Conroe ISD. Call to schedule your private showing today!' ,`Acres` = '0.1653' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROBINWOOD 01, BLOCK 3, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Robinwood 01' ,`TaxAmount` = '4260' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711418' WHERE `Matrix_Unique_ID` = '209198237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:52:32.410' ,`MLSNumber` = '12382133' ,`ListAgentFullName` = 'Marynes Cobo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716944' ,`Longitude` = '-95.789075' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '1130000.00' ,`Status` = 'Active' ,`StreetName` = 'Starlight Beach' ,`StreetNumber` = '23110' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with great curb appeal in desired gate community at Avalon. Backing to lake will provide hours of enjoyment, high ceilings, granite countertops. Gorgeous infinity pool/spa. Sunroom off kitchen, and kitchen with lake view. Mediaroom upstairs wired with surround sound. Roof replaced 2019. A/C units new, one from 2019 and another 2020. Totally remodeling bathrooms, kitchen, pool area. New custom shutters. Walk to elementary and Jr. high school.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Avalon at Seven Meadows Sec 5,Block 4,Lot 13' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Waterfront' ,`LotSize` = '12792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon at Seven Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711418' WHERE `Matrix_Unique_ID` = '209950289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:43:36.493' ,`MLSNumber` = '82900247' ,`ListAgentFullName` = 'James Perryman' ,`ListOfficeName` = 'First Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401265' ,`Longitude` = '-95.845780' ,`PhotoCount` = '20' ,`PostalCode` = '77461' ,`RoomCount` = '3' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Beasley' ,`StreetNumber` = '3427' ,`StreetSuffix` = 'Avenue' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home in a great school district! This home has been recently updated and includes granite countertops in the kitchen, engineered wood floors, a large family room and has just been freshly painted throughout. The home has three good sized bedrooms and includes several large mature shade trees with a backyard that overlooks Fairchilds Creek. Don\'t miss it!' ,`Acres` = '0.1585' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SKRABANEK MEADOWS , BLOCK 2, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6903' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Skrabanek Meadows' ,`TaxAmount` = '3239' ,`TaxRate` = '2.2544' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663711418' WHERE `Matrix_Unique_ID` = '210293450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:10:35.080' ,`MLSNumber` = '54800243' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745173' ,`Longitude` = '-95.875440' ,`PhotoCount` = '11' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Dripping Springs' ,`StreetNumber` = '3039' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to live on a cul-de-sac in a wonderful community! So many amenities to explore in the beautiful Tamarron subdivision including walking trails, playground, and a waterpark! This beautiful 4/2/2 split floorplan has the oversize kitchen with a large island, hugh pantry and lots of cabinet space. Freshly painted interior, newly installed upgraded carpeting, and a new stainless steel dishwasher. Don’t wait, your new home is waiting for you!' ,`Acres` = '0.1509' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 30, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6571' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '7785' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711418' WHERE `Matrix_Unique_ID` = '210518826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:47:50.597' ,`MLSNumber` = '90325681' ,`ListAgentFullName` = 'Leslie Sullivan' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281352' ,`Longitude` = '-95.554653' ,`PhotoCount` = '31' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Haven' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pristine 3 bedroom, 2 bath home in the highly sought-after Master Planned community of Woodforest! This home features wood-look tile flooring, soaring ceilings, elegant study & a spacious open floorplan allowing for easy entertaining. The stunning kitchen is sure to inspire your inner chef offering granite counters, stainless steel appliances, an island with breakfast bar & ample cabinet space! Relax in the master suite consisting of dual sinks, separate shower & soaking tub. Wonderful private backyard space with covered patio and no rear neighbors! Amazing amenities within walking distance including a resort style aquatic center, clubhouse, tennis courts, splash pads & MORE! Zoned for the highly rated Conroe ISD! Don\'t wait on this one!' ,`Acres` = '0.1503' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965265 - WOODFOREST 65, BLOCK 1, LOT 4' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '6549' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 65' ,`TaxAmount` = '7123' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711418' WHERE `Matrix_Unique_ID` = '210646878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:56:24.940' ,`MLSNumber` = '51054285' ,`ListAgentFullName` = 'Wendy Sherman' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727102' ,`Longitude` = '-95.861713' ,`PhotoCount` = '39' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Desert Springs' ,`StreetNumber` = '3811' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your practically new Perry home located on a quiet circle drive in the master planned community of Cross Creek Ranch featuring 4 bedrooms, 3.5 baths and 2 car attached garage! This home showcases elegant architecture including high ceilings and a gorgeous spiral staircase. The chef in your family will love the gourmet kitchen with stainless steel appliances with beautiful granite with a breakfast bar! Primary Suite includes sitting area plus a walk in closet that also leads to the laundry room for your convenience! Step out back to the covered patio perfect for family cook-outs and outdoor entertaining. This master planned community includes parks, hike and bike trails, 3 pools with resort style waterpark, catch and release fishing, dog park, tennis courts, volleyball and basketball courts, cafe and fitness center! Such a beautiful community, you\'ll never want to leave!' ,`Acres` = '0.1722' ,`Area` = '36' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK FALLS AT CROSS CREEK RANCH SEC 1, BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '14429' ,`TaxRate` = '3.3425' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711418' WHERE `Matrix_Unique_ID` = '210656648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:07:35.760' ,`MLSNumber` = '61097348' ,`ListAgentFullName` = 'John Crawford' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Stephanie Pribble' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.793686' ,`Longitude` = '-95.373873' ,`PhotoCount` = '24' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '479990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Archer' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location with this recently updated Victorian Home in the Heights. Updates include fence with automatic driveway gate 2018, fully updated bathroom 2018, Hardwood floors throughout the home 2018, A/C system 2020, new gas lines throughout the home from the meter 2020, gutters 2020, Pex plumbing system throughout the home 2021, updated laundry room 2020. Charming home that\'s been well maintained with front covered porch, granite counters, stainless appliances, rear deck, storage shed and big backyard. Home did not flood during Harvey.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 25 BROOKE SMITH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Victorian' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '9167' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711418' WHERE `Matrix_Unique_ID` = '210772468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:45:43.830' ,`MLSNumber` = '10497129' ,`ListAgentFullName` = 'Tara Jarrett' ,`ListOfficeName` = 'Teifke Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.124520' ,`Longitude` = '-95.412961' ,`PhotoCount` = '24' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Calmar' ,`StreetNumber` = '1722' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully Updated Home in Imperial Oaks Subdivision! This one story 4 bedroom, two bath home, is spacious with an open floor plan with large windows throughout the home. The home has an island in the kitchen with all new appliances and a breakfast area. The kitchen and bathrooms have full granite countertops replaced in 2021. The primary bedroom is on the opposite side of the house from the secondary bedrooms and consists of a large walk in closet, separate soaking tub, walk in shower, three large windows, and a sit down vanity. All blinds have are newly installed. The home has a detached 2-car garage with a large fenced in back yard and mature trees in both front and back of the home. HVAC replaced in 2018 and new coil 2022. Low tax rate. This is a must see!' ,`Acres` = '0.2081' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 02 REP# 9020713, BLOCK 9, LOT 45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9067' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Imperial Oaks 02' ,`TaxAmount` = '5420' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711419' WHERE `Matrix_Unique_ID` = '210903845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:54:24.933' ,`MLSNumber` = '63807336' ,`ListAgentFullName` = 'Leesa Ward' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = 'Alexandra Swistak' ,`SellingOfficeName` = 'Woodrow Realty' ,`Latitude` = '30.064631' ,`Longitude` = '-95.181366' ,`PhotoCount` = '13' ,`PostalCode` = '77345' ,`RoomCount` = '9' ,`ListPrice` = '309000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hill Springs' ,`StreetNumber` = '3807' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fully custom, elegant single family home is located in the heart of Kingwood. Designer choices in this stunning home set it apart from every other house in the neighborhood. The spacious living area boasts high ceilings with a beautiful brick fireplace as the centerpiece of the room. Lots of natural light brightens the living area. \r\n\r\nThe kitchen features a large composite sink and disposal, amazing granite counter tops with high-end appliances. Stunning Terrazzo flooring highlights the bright breakfast and kitchen area. Spacious bedrooms boast lots of room for comfort as well as large closets for storage. Primary bathroom has lovely tile shower. Recent A/C and heating energy efficient units with digital thermostats installed in 2018 along with new duct work throughout. Large, beautiful landscaped backyard makes for perfect entertaining with large porch and room for grilling.' ,`Acres` = '0.1873' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 9 GREENTREE VILLAGE SEC 1 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '405' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Greentree Village' ,`TaxAmount` = '5473' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711419' WHERE `Matrix_Unique_ID` = '210930005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:06:08.747' ,`MLSNumber` = '13047217' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130304' ,`Longitude` = '-95.515987' ,`PhotoCount` = '15' ,`PostalCode` = '77389' ,`RoomCount` = '4' ,`ListPrice` = '486900.00' ,`Status` = 'Active' ,`StreetName` = 'Knob Pines' ,`StreetNumber` = '25015' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4 bedroom, 2.5 bath, 2 car garage is move in ready and features a sparking pool for family time. Living room with cozy fireplace. Spacious kitchen with new granite countertops and stainless steel appliances including the fridge. Home office. Downstairs primary bedroom suite. Secondary bedrooms and gameroom upstairs. \r\nNew carpet. Backyard with shed and privacy fence. Close to Rob Fleming park, Willow creek golf course, and local farmers market. Come tour today!' ,`Acres` = '0.1716' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 AUBURN LAKES PINES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Lakes Pines' ,`TaxAmount` = '8617' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711419' WHERE `Matrix_Unique_ID` = '210959403' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:04:19.377' ,`MLSNumber` = '77768018' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876743' ,`Longitude` = '-95.455967' ,`PhotoCount` = '10' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '274500.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Ridge' ,`StreetNumber` = '3403' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful 2 story home in Inwood Pines offers three bedrooms, two baths, two car garage at the end of the cul-de-sac on a very large lot which includes a covered back porch and an additional storage building. As you enter the foyer there are both formals on the right with a bar area leading to the kitchen. The kitchen and bar area open to the living room. Living room with vaulted beam ceiling and fireplace. The kitchen has granite countertops and new stainless steel gas cooktop, range hood, dishwasher, microwave and oven. New Luxury Vinyl Plank flooring throughout all the living areas and bathrooms. New interior paint and New carpet in all bedrooms. New electrical panel. Spacious backyard to enjoy family activities. Enjoy your new home!' ,`Acres` = '0.1641' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 15 INWOOD PINES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Pines' ,`TaxAmount` = '3584' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711419' WHERE `Matrix_Unique_ID` = '210961693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:02:46.213' ,`MLSNumber` = '34583125' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820612' ,`Longitude` = '-94.973084' ,`PhotoCount` = '11' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '272900.00' ,`Status` = 'Active' ,`StreetName` = 'Caraway Lake' ,`StreetNumber` = '5806' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom, 2 bath home with 2-car garage located lakefront in Springfield Estates. This beautiful home is Move-In Ready w/new carpet in all bedrooms & freshly painted interior. Home features an oversized family room w/stunning wood floors & gas fireplace. Kitchen features new granite countertops w/stainless steel appliances including a new microwave. Adjoining breakfast room features a bay window overlooking the front yard. Formal dining room could be used as a 2nd living room or study. Primary suite features high ceilings & en-suite bathroom w/dual vanities, walk-in shower & separate soaking tub. Two additional bedrooms share a hall bath w/shower/tub combo. Fenced backyard offers plenty of space to relax & enjoy the lake view or walking trail. Community w/playground area, basketball court. Located just off Garth Road, easy access to I-10 & Hwy 330 giving residents numerous options for shopping, dining & entertainment in this expanding part of Baytown. Goose Creek ISD schools.' ,`Acres` = '0.1354' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SPRINGFIELD ESTATES' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '5898' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Estates' ,`TaxAmount` = '6073' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711419' WHERE `Matrix_Unique_ID` = '210987574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:59:42.093' ,`MLSNumber` = '71427812' ,`ListAgentFullName` = 'Tina Chovanetz' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729499' ,`Longitude` = '-95.936936' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '1475000.00' ,`Status` = 'Active' ,`StreetName` = 'Hepplewhite' ,`StreetNumber` = '32803' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location,approx 4 miles from downtown Fulshear,zoned to Fulshear Schools,&offers the country life with 9.482 acres.With wrap around porches,this property has a 3,609 sqft main house with 3 beds,3 1/2 baths,extra room upstairs with a small kitchenette that can be used as another bedroom,game/media room,etc.Upstairs you will also find a laundry chute for convenience.In the kitchen you will find a Wolf Gourmet Gas range with 6 burners, griddle,&double oven,a Thermador vent hood&a Monogram refrigerator.Outside you will see a beautiful pool&pool house.In the back yard from the carport,a barn/workshop sits.There is a 1,200sqft living quarters above the barn that has 2 beds&1 bath.Also on the property,is a large pond with concrete edging that is stocked with Bass,Catfish,Perch,&Grass Carp.Kubota Tractor to remain with the property.Don\'t miss out on this charming country property,schedule your showing today!Please note there are 2 other adjoining properties-MLS#80900111 & MLS#41466315.' ,`Acres` = '9.482' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN HILL, LOT 64 (PT), ACRES 9.482, TRACT 76' ,`LotDesciption` = 'Water View,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Hill' ,`TaxAmount` = '11971' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711419' WHERE `Matrix_Unique_ID` = '211090164' --> 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','211102182','1663711419','211102182','2022-09-16T20:34:05.160','36893689','Carol Rowley','Compass RE Texas, LLC','Vikki Evans','Compass RE Texas, LLC','29.713257','-95.412304','40','77030','8','1299000.00','Pending Continue to Show','Dryden','2245','Road','Houston','2','1','3','2472','Single-Family','This Randolph and Virginia West House was designed in a French style by Claude E. Hooton in 1936-37. Featured in several magazines and books such as Architectural Digest, Houston magazine and Houston Garden Book, Laura U of Laura U Design Collective, a luxury residential interior designer & previous owner of this home, restored it in 2012/2013. A historic landmark recognition was granted for its architectural value in 2013 which lowers property taxes each year! This beautifully proportioned home has 2472sf (per appraisal) and sits on a 7068sf (per HCAD) lot. This home offers gorgeous original parquet floors, octagonal entry hall, kitchen w/14\' vaulted ceiling, both formals as well as a 2nd living area, primary suite, luxurious spa-like primary bath, 2 walk-in closets, and laundry/storage areas that were added in 2012/13. All the modern and trending amenities abound in this very special home! Easy proximity to Med Ctr, Rice U/Village, Hermann Park, Museum District. *All Per Seller.','0.1623','17','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Rice/Museum District','Central Gas','0','TRS 2 & 3A BLK 9 SOUTHGATE','Subdivision Lot','7068','Appraisal District','','','0','','0','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','ROBERTS ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Appraisal','1','French,Traditional','Southgate','22880','2.3307','Public Sewer,Public Water','1936','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:55:38.230' ,`MLSNumber` = '43867677' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.512844' ,`Longitude` = '-95.045552' ,`PhotoCount` = '13' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '510900.00' ,`Status` = 'Active' ,`StreetName` = 'Ivory Stone' ,`StreetNumber` = '608' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story home with a beautiful pool and tropical landscaping in South Shore Harbour. Detached two car garage with a super long driveway. The house is in the Cul De Sac with plenty of street parking. Enter into the foyer with high ceilings and the living room with natural sunlight and a view of the pool. The kitchen features granite countertops, and 4 yr old stainless steel appliances (stove/range, microwave, refrigerator, and dishwasher). A covered patio plus a pergola provide additional outdoor entertainment areas. Home has had tons of updates over the last few years. Roof and water heater replaced in 2021 (per previous owner). 3 yr old pool pump (per previous owner) and filter replaced in 7/22. Move-in ready. Easy access to Kemah Boardwalk and Space Center.' ,`Acres` = '0.176' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE HARBOUR SEC SF 65-3 (2005) ABST 18, BLOCK 2, LOT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7664' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '673' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '9389' ,`TaxRate` = '2.4521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711419' WHERE `Matrix_Unique_ID` = '211175346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:00:16.907' ,`MLSNumber` = '78988807' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201513' ,`Longitude` = '-95.517371' ,`PhotoCount` = '15' ,`PostalCode` = '77381' ,`RoomCount` = '4' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Blossom' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! 4 bedroom home with a pool and hot tub on a corner lot in Woodlands Village Cochrans Crossing! Home has been updated with fresh interior paint and new LVP flooring! Beautiful kitchen with granite countertops and stainless steel appliances. Impressive updates were done over the last several years including the modern style primary bathroom and luxurious upgraded granite in the kitchen. Some of the pool equipment was replaced earlier this year. Home is located close to I-45 for easy access to local restaurants and shopping malls. The community features playground, tennis courts, and lakes. Don\'t miss this one!!' ,`Acres` = '0.1939' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL COCHRANS CR 29, BLOCK 1, LOT 44' ,`LotDesciption` = 'Corner' ,`LotSize` = '8446' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Cochrans Crossing' ,`TaxAmount` = '3350' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711420' WHERE `Matrix_Unique_ID` = '211185020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:57:08.337' ,`MLSNumber` = '46959075' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762881' ,`Longitude` = '-95.814487' ,`PhotoCount` = '13' ,`PostalCode` = '77494' ,`RoomCount` = '3' ,`ListPrice` = '347900.00' ,`Status` = 'Active' ,`StreetName` = 'Eberhart Star' ,`StreetNumber` = '1610' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one is a must see! 3 bedrooms, 2 baths and 2 car garage. The foyer offers tile floors, dining room with laminate floors and crown molding throughout. Kitchen with a beautiful island, breakfast bar, new stainless steel stove & microwave, new granite countertops and resurfaced kitchen cabinets. Freshly painted interior. Master bedroom with raised ceiling, shelves and a beautiful sitting area. Spacious secondary bedrooms with ceiling fans, spacious family room, plantation shutters throughout. Mills Pointe is conveniently located off Westheimer Parkway, minutes from Cinco Ranch, La Centerra, Katy Mills Mall and I-10. Welcome home!' ,`Acres` = '0.1306' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MILLS POINTE SEC 1, BLOCK 1, LOT 92' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Pointe' ,`TaxAmount` = '5032' ,`TaxRate` = '2.4143' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711420' WHERE `Matrix_Unique_ID` = '211186083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:05:15.187' ,`MLSNumber` = '22415442' ,`ListAgentFullName` = 'Jimmy Jones' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.563666' ,`Longitude` = '-95.126400' ,`PhotoCount` = '26' ,`PostalCode` = '77062' ,`RoomCount` = '8' ,`ListPrice` = '230000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Buccaneer' ,`StreetNumber` = '16018' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled among gorgeous, mature trees sits this quaint 1 story home in the heart of the amazing community of CLEAR LAKE CITY. Conveniently located near NASA Space Center, Baybrook Mall and much more shopping and entertainment. Featuring 3 spacious bedrooms with walk-in closets, the primary has new carpet. The large living area boasts vaulted ceilings and gorgeous laminate wood flooring. The kitchen is ready for someone to restore her to her former glory! The garage is a great place to tinker with a workbench, built-in cabinets and loft shelving. A flex room adds space just off the living room and leads to a sizeable backyard with covered patio and room to run around or entertain. CLC has a community pool, parks and walking trails. Zoned to top notch CCISD schools. Book your personal tour today!' ,`Acres` = '0.174' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 934 & 935A BLK 53 CLEAR LAKE CITY SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake City Sec 04' ,`TaxAmount` = '5251' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711420' WHERE `Matrix_Unique_ID` = '211265812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:03:09.000' ,`MLSNumber` = '28480156' ,`ListAgentFullName` = 'Tracy Montgomery' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937830' ,`Longitude` = '-95.171075' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Whisper Hollow' ,`StreetNumber` = '13318' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 5 bedroom home located in the most sought after neighborhood of Stillwater. Upon entry notice the grand 2 story entry & wood flooring that flows through the downstairs.Large formal dining room w/beautiful crown molding is to the right.Chefs dream island kitchen that offers breakfast bar, SS appliances, double ovens, beautiful granite counters, & a ton of cabinet/counter space for storage.Kitchen is open to the family room that has a tile fireplace,wall to wall & wall to ceiling windows that offers in a ton of natural light & views of the backyard. Escape to the master suite that has a recessed ceiling, sitting area, & en-suite.Master bath has double sinks, vanity, huge walk-in shower, soaker tub, & walk-in closet. Head up the iron stair-well and you will find a spacious media, game-room, jack/jill bath & very large secondary bedrooms/closets. Head outside to the pool-sized backyard that has a 2-story height covered patio & enough room for swing-set &/or garden.' ,`Acres` = '0.2418' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 STILLWATER ON LAKE HOUSTON SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stillwater' ,`TaxAmount` = '14886' ,`TaxRate` = '3.4539' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711420' WHERE `Matrix_Unique_ID` = '211303910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:58:12.030' ,`MLSNumber` = '73952300' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773451' ,`Longitude` = '-95.418653' ,`PhotoCount` = '12' ,`PostalCode` = '77007' ,`RoomCount` = '2' ,`ListPrice` = '427900.00' ,`Status` = 'Active' ,`StreetName` = 'Asbury' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Remarkable 2-story home within walking distance to Washington Ave establishments and Memorial Park. Easy access to I-10 and 610 with Downtown and the Galleria only minutes away. Rare find with private driveway and spacious backyard. Spacious primary suite on first floor with stained concrete floors. Primary ensuite features a double sink vanity, oversized spa tub and separate shower. The second floor offers a wonderful open concept. Living room w/high vaulted ceilings and large windows to let in natural light. The living room is large enough to accommodate both a living and dining space. Island kitchen is open to the living room and features custom built cabinetry with granite counters and stainless-steel Jenn Air appliances. A breakfast nook is adjacent to the kitchen. Secondary bedroom and bath share the second floor. Move-In Ready. No HOA!' ,`Acres` = '0.0574' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 8 WOODCREST' ,`LotDesciption` = 'Other' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodcrest' ,`TaxAmount` = '7719' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711420' WHERE `Matrix_Unique_ID` = '211324105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:54:23.947' ,`MLSNumber` = '44403868' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690169' ,`Longitude` = '-95.718784' ,`PhotoCount` = '12' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Mustang Pointe' ,`StreetNumber` = '19223' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come fall in love with this gorgeous home in fabulous Grand Mission in Richmond.! This 2 story, 4 bedroom, 2 1/2 bath home features spacious island kitchen with granite and 42\" maple cabinets, ceramic tile flooring downstairs, large primary bedroom with private bath with a separate tiled shower, jetted tub and dual sinks. Upstairs offers a huge game room & large secondary bedrooms. Recently painted interior, newly installed carpet. Home located on a cul-de-sac street with sprinkler systems in both front and back yards. Family gatherings & entertaining guests will be a breeze in this lovely open concept space. This home is conveniently located near Westpark Tollway, 99 Grand Parkway, and is zoned to prestigious Fort Bend ISD.' ,`Acres` = '0.1396' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 12, BLOCK 1, LOT 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission Sec 12' ,`TaxAmount` = '5434' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711420' WHERE `Matrix_Unique_ID` = '211326654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:46:58.010' ,`MLSNumber` = '28522667' ,`ListAgentFullName` = 'Francisco Chacon' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711481' ,`Longitude` = '-95.294832' ,`PhotoCount` = '41' ,`PostalCode` = '77087' ,`RoomCount` = '4' ,`ListPrice` = '309999.00' ,`Status` = 'Active' ,`StreetName` = 'Hemlock' ,`StreetNumber` = '6940' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Such an amazing property with so much potential! 3 properties in one. The main house sits on one lot, then the lot next to it is included and finally the lot behind the main house is also included. This property has a commercial aspect to it the seller would use the detached unit to sell beauty supplies. The back unit has 1 bedroom and one half bath that could be completed into a full bathroom. This property is perfect for someone with a vision. Imagine using the main house to live in, the back unit as a office space and building more units in the lot connected to Garland St. So many different possibilities to this property.' ,`Acres` = '0.3788' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 1 21 & 22 BLK 42 PECAN PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SOUTHMAYD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Park' ,`TaxAmount` = '4577' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711421' WHERE `Matrix_Unique_ID` = '211472762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:33:02.403' ,`MLSNumber` = '46674199' ,`ListAgentFullName` = 'Johnathan Simms' ,`ListOfficeName` = 'Strada' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834091' ,`Longitude` = '-95.741660' ,`PhotoCount` = '21' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '274000.00' ,`Status` = 'Active' ,`StreetName` = 'Chablis Ridge' ,`StreetNumber` = '4126' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Vineyard Meadows! This one story is nestled in a large cul-de-sac zoned to Katyisd. BRAND NEW ROOF!(not pictured, 9/15/2022) Three bedroom, two bath. Covered front & back porch. Open floor plan, tile with carpet in bedrooms. Kitchen has 42\" cabinets, granite counters & serving bar. Huge master suite & master bath w/separate shower & tub, large walk-in closet. Two guest bedrooms in private hallway w/guest bath. Ring security system. Appliances included. Never flooded. Price Reduced! This one won\'t last so schedule your appointment!' ,`Acres` = '0.1812' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 VINEYARD MEADOW SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7894' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '645' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vineyard Meadow' ,`TaxAmount` = '4809' ,`TaxRate` = '2.7857' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711421' WHERE `Matrix_Unique_ID` = '211505213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:49:32.653' ,`MLSNumber` = '8755493' ,`ListAgentFullName` = 'Benjamin Durig' ,`ListOfficeName` = 'RJB InterestsRobert J. Brock' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151854' ,`Longitude` = '-96.400062' ,`PhotoCount` = '34' ,`PostalCode` = '77833' ,`RoomCount` = '5' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Jackson Street' ,`StreetNumber` = '1707' ,`StreetSuffix` = '' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2983' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1707 S. Jackson St. - 16,117 sqft. or 0.37 acre lot. Building Sqft. - 2,983 This newly renovated home is on corner lot within walking distance of Jackson Street Park and is just over a mile away from Downtown Brenham. Home has been completely remodeled. Master Bedroom is on first floor with spacious master bathroom with walk in shower, tub and his and her sinks with marble countertops and marble tub decking and walk in closet. Spacious living room with gas fireplace. Granite countertops, gas burning range and two separate ovens in Kitchen. Two large bedrooms upstairs with bonus room & a wrap around bathroom with vanities for each bedroom. An abundance of storage space in home with walk-in closets for each bedroom equipped with Elfa Shelving from The Container Store. All new light and plumbing fixtures, windows. doors and flooring. Detached garage with covered walkway and new deck off the back of the house. Extensive landscaping work completed -new shrubs, sod and privacy fence.' ,`Acres` = '' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Jackson St. - WILKINS, W. G. , BLOCK 30, LOT PT 3 (REPLAT 3B' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'N76 - Jackson Street South' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711421' WHERE `Matrix_Unique_ID` = '211651812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T21:28:49.783' ,`MLSNumber` = '32030621' ,`ListAgentFullName` = 'Jing He' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600797' ,`Longitude` = '-95.664263' ,`PhotoCount` = '25' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '369950.00' ,`Status` = 'Active' ,`StreetName` = 'Birch Hill' ,`StreetNumber` = '510' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location!Location!Location! Walking distance to Walker Station Elem School and the community pool. Zone to Austin high. Easy Access to 4 major Highways: Grand Parkway 99, hwy 90, hwy 6 and Interstate 69. This is a well maintained home with a spacious formal living & formal dining leading to spacious kitchen which will inspire chef to cultivate their skills. Marble tile floor in the kitchen, breakfast and Lots of pretty Solid Wood floor through the house. Brand new dishwasher and one-year-old Water heater, AC equipment is still under warranty. Large primary suite and good sized secondary bedrooms with high vaulted ceilings. Extra Large patio in the backyard. HOA includes access to 4 community pools, fitness center plus more. Never flooded during hurricane and no plumbing issue during extremely cold weather. Must come to see today!' ,`Acres` = '0.1712' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ROBINSON\'S LANDING SEC 2, BLOCK 10, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7457' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Robinsons Landing Sec 2' ,`TaxAmount` = '6506' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711421' WHERE `Matrix_Unique_ID` = '211680153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:06:11.847' ,`MLSNumber` = '11784873' ,`ListAgentFullName` = 'Victor Morales' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594521' ,`Longitude` = '-95.335367' ,`PhotoCount` = '49' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '655000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunbrook' ,`StreetNumber` = '12425' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3191' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom home built in 2005 is over 3100 square feet built on a 1 1/4 acre lot. It offers 4 bedrooms, a study/office, 4 FULL baths, formal dining, a custom kitchen, breakfast area, a large living space, and a large 4th bedroom that could be used as a game room that measures 24x19, detach 2 garages with a full bathroom. 9 ft ceilings throughout out, tile in main areas/wet areas, carpet in bedrooms. The spacious kitchen has custom cabinets, stainless steel appliances, neutral colors throughout, & granite countertops. Every area in this home is spacious no wasted spaces, also comes with a large covered back patio, recently extended patio slab, expanded driveway for more parking, and storage added in 2021. Big back yard for all kinds of outdoor activities with playground included. Great size master bedroom fits large pieces of furniture. Lots of mature trees for privacy, shade, & a tranquil space to come home to. Home was built with a higher elevated foundation, & didn\'t flood during Harvey.' ,`Acres` = '1.25' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SUNBROOK PLACE (A0505 HT&BRR) (BROOKSIDE VILLAGE) BLK 3 LOT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '54450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunbrook Place' ,`TaxAmount` = '9133' ,`TaxRate` = '2.3697' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663711421' WHERE `Matrix_Unique_ID` = '211711813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:48:12.887' ,`MLSNumber` = '54621667' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996418' ,`Longitude` = '-95.144637' ,`PhotoCount` = '12' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Discus' ,`StreetNumber` = '8523' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2-story located in the Olympic Village community of Walden on Lake Houston. Open plan is perfect for entertaining both intimate gatherings or larger parties. Room at entry could be used as a formal liviing or study with a double sided fireplace separating it from the dining room. Spacious family room is open to the kitchen & breakfast room. Kitchen features granite counters with stainless steel appliances including a new dishwasher and new microwave. Private primary suite down. Ensuite features dual vanities plus a large tub & separate shower. Gameroom plus three bedrooms and a shared bath upstairs. Fenced backyard w/two covered patios, one with a summer kitchen. Move-In Ready with new carpet & fresh paint throughout the interior. Community amenities include 2 Boat Ramps, a Children\'s Baseball and Soccer Practice Field, Fitness Center, Racquet & Tennis Center and Hike & Bike Trails plus the Walden Golf Club, Marina and Yacht Club. Close to shopping, dining and major freeways.' ,`Acres` = '0.2204' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 21 OLYMPIC VILLAGE WALDEN ON LAKE HOUSTON PH 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympic Village Walden On Lake Houston' ,`TaxAmount` = '6717' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711421' WHERE `Matrix_Unique_ID` = '211736536' --> 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','211749122','1663711421','211749122','2022-09-16T20:54:05.600','12275819','Kevin Collins','BHGRE Gary Greene','','','30.213046','-95.533363','41','77382','10','439000.00','Active','Belfair','22','Place','The Woodlands','2','0','3','1984','Single-Family','Exceptional home in the 55+ patio home community of Ashley Greens with over $50,000 in updating and upgrades over the last five years. These include a 30 year roof (2019), Lennox dual-stage HVAC system (2017), high-capacity water heater (2019), dual-pane low-e windows (2018), Raccio wifi irrigation controls (2020), composite decking (2019), French drain (2017), kitchen upgrades including under and over cabinet lighting, backsplash, microwave, induction range, dishwasher, sink and faucet, and disposal (2017), bathroom renovations (2018), and carpet (2018). Popular Berkshire plan is bright and open. Move-in ready with warm neutral tones. Beautiful backyard with covered patio and deck. Ashley Greens is unique in The Woodlands as it is the only 55+ single family neighborhood that is walking distance to a village center. The $135/month HOA fees include front lawn and sprinkler maintenance, mulching, gutter cleaning, house paint, front door staining, fencing, and basic alarm monitoring.','0.1683','15','Lennar','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','The Woodlands','Central Gas','1','WDLNDS VIL ALDEN BR 53, BLOCK 1, LOT 25','Cul-De-Sac,Patio Lot,Subdivision Lot,Wooded','7332','Appraisal District','','135','0','','2','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','BUCKALEW ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','The Woodlands Alden Bridge','5623','2.1811','Public Sewer,Public Water','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:46:35.217' ,`MLSNumber` = '15872751' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985840' ,`Longitude` = '-95.167162' ,`PhotoCount` = '12' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Mabels Island' ,`StreetNumber` = '18506' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on cul-de-sac street in the beautiful community of Atasca Woods. 4 bedroom, 2.5 bath home features an amazing open floor plan with great windows & natural light! A formal entry w/soaring ceilings welcomes you & opens to a dining room & study w/French doors for privacy. New wood-look Luxury Vinyl Plank floors flow through the downstairs living spaces. The kitchen has been updated w/new granite counters & new subway tile backsplash. Stainless steel appliance package includes a new microwave & dishwasher. Kitchen opens to the breakfast & living room w/vaulted ceiling & cozy fireplace. Large, first-floor primary features an ensuite with w/double sinks, jetted tub & separate shower. Upstairs, 3 bedrooms share a bath along with a huge gameroom. New carpet in bedrooms & gameroom. Fresh interior paint plus new HVAC systems. Community amenities include a swimming pool, playground & park. Located near FM 1960 & HWY 69. Lake Houston is only minutes away. Schools are zoned to Humble ISD.' ,`Acres` = '0.1521' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 3 ATASCA WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods' ,`TaxAmount` = '6584' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711422' WHERE `Matrix_Unique_ID` = '211760509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:47:28.007' ,`MLSNumber` = '57272658' ,`ListAgentFullName` = 'Leslie Sullivan' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.236205' ,`Longitude` = '-95.669805' ,`PhotoCount` = '42' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '287500.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Hill' ,`StreetNumber` = '12525' ,`StreetSuffix` = 'Pass' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1749' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular 3 bed 2 bath home in the beautiful community of Mostyn Hills! Gorgeous LVP flooring leads to a spacious open floorplan with a light & bright living area. The stunning kitchen features stainless steel appliances, island with breakfast bar & plenty of cabinet space with a charming breakfast area sitting adjacent. Your master suite awaits boasting dual sinks, separate shower & walk-in closet! Backyard with covered patio backs up to a greenspace for extra privacy! Near shopping, dining & zoned for the highly acclaimed Magnolia ISD! Don\'t miss out on this gem of a home!' ,`Acres` = '0.1543' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S733302 - MOSTYN SPRINGS SUBDIVISION 02, BLOCK 4, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6722' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Spgs Sub 02' ,`TaxAmount` = '1672' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711422' WHERE `Matrix_Unique_ID` = '211792660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:42:38.723' ,`MLSNumber` = '35360432' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.486390' ,`Longitude` = '-95.769507' ,`PhotoCount` = '14' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '332900.00' ,`Status` = 'Active' ,`StreetName` = 'Wolf Creek' ,`StreetNumber` = '7515' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lennar home with brick elevation in Still Creek Ranch! Charming 1 story, 3 bedroom, 2 bath home. Formal dining room. Open island kitchen with designer cabinets, granite countertops, stainless steel appliances including new gas stove and breakfast nook! Kitchen overlooks large family room. Master suite offers a huge joining master bath with garden tub, separate shower, dual sinks and large walk-in closet! Wood Luxury Vinyl Plank flooring throughout main living areas, and newly installed carpet in bedrooms, 2 inch wood mini blinds, ceiling fans and energy efficient 16 CRH vac system and so much more. This home is a Wi-Fi certified smart home featuring integrated automation and voice control with Amazon Alexa. After a long day, sit back and enjoy the beautiful, Forever, above ground pool overlooking a water view in your backyard ! Don’t wait, you’ll miss this steal!' ,`Acres` = '0.1515' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STILL CREEK RANCH SEC 1, BLOCK 2, LOT 9' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Still Creek Ranch' ,`TaxAmount` = '6287' ,`TaxRate` = '2.9148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711422' WHERE `Matrix_Unique_ID` = '211795009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:45:22.647' ,`MLSNumber` = '66098878' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.623994' ,`Longitude` = '-95.341772' ,`PhotoCount` = '11' ,`PostalCode` = '77048' ,`RoomCount` = '3' ,`ListPrice` = '262900.00' ,`Status` = 'Active' ,`StreetName` = 'Almeda Crossing' ,`StreetNumber` = '12814' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location. Charming one-story home in Almeda Crossing Subdivision. Super clean and move-in ready. Fresh interior paint. Open floor plan with kitchen and living room combo. New carpet in all bedrooms. The kitchen features stainless steel dishwasher, microwave, gas range with an island and breakfast bar. Fully fenced. Conveniently located near Pearland, the Medical Center and quick access to 288 and Sam Houston Tollway.' ,`Acres` = '0.1006' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 ALMEDA CROSSING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Almeda Crossing' ,`TaxAmount` = '5141' ,`TaxRate` = '3.0707' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711422' WHERE `Matrix_Unique_ID` = '211806836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:44:06.800' ,`MLSNumber` = '51534204' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052277' ,`Longitude` = '-95.454020' ,`PhotoCount` = '12' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '343900.00' ,`Status` = 'Active' ,`StreetName` = 'Woodsboro' ,`StreetNumber` = '2715' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well appointed 2 story home offers 4 bedrooms, 2.5 baths, living room with fireplace and separate family room. All bedrooms upstairs. The spacious kitchen comes complete with a center island, granite countertops and black appliances including the fridge. Tile flooring thru out the first floor and carpet upstairs. Master bedroom has been remodeled. Freshly painted interior and new roof. Enjoy entertaining in the backyard with large deck. Located close to I45 for easy access to restaurants and local shopping centers. Come tour today!' ,`Acres` = '0.225' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 6 OAKS OF DEVONSHIRE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '488' ,`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` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oaks of Devonshire' ,`TaxAmount` = '6145' ,`TaxRate` = '2.534' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711422' WHERE `Matrix_Unique_ID` = '211831103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:21:08.523' ,`MLSNumber` = '75141743' ,`ListAgentFullName` = 'Roxanna Gross' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.617872' ,`Longitude` = '-95.724651' ,`PhotoCount` = '42' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Bend' ,`StreetNumber` = '2407' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous remodeled home on HUGE 14,000+ sf lot on cul-de-sac!!! Hardwood floors throughout downstairs and upstairs, granite & marble countertops, stainless steel appliances, freshly painted top to bottom, excellent schools, what more can you ask for!! This is the one, make your appointment today you won\'t be disappointed.' ,`Acres` = '0.3266' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE GROVE SEC 9, BLOCK 10, LOT 199' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'The Grove Sec 9' ,`TaxAmount` = '5039' ,`TaxRate` = '2.3298' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711422' WHERE `Matrix_Unique_ID` = '211954999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:38:52.073' ,`MLSNumber` = '28834533' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198364' ,`Longitude` = '-95.497469' ,`PhotoCount` = '18' ,`PostalCode` = '77381' ,`RoomCount` = '3' ,`ListPrice` = '710000.00' ,`Status` = 'Active' ,`StreetName` = 'Biscay' ,`StreetNumber` = '34' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2 story home with 3 bedrooms, 3.5 baths, home office and formal dining room located in The Woodlands. Gorgeous entry with chandelier that has a home office off the front. Two master bedrooms, one on each floor have ensuite baths with jetted tubs. Freshly painted interior including kitchen/laundry. Gourmet kitchen with a center island and stainless steel appliances including the fridge. Other updates include new tile, new luxury vinyl plank flooring, new quartz in baths and utility rooms. Two car detached garage includes portable AC unit. Backyard features sparkling pool with hot tub and includes pool fence. Located in The Woodlands across the street from the high school and easy access to I 45. Community features several parks, mystic lake, pachyderm, and summer storm park. Don\'t miss this home!' ,`Acres` = '0.2391' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL COCHRANS CROSSING 21, BLOCK 1, LOT 16' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10416' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Cochrans Crossing' ,`TaxAmount` = '9478' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711422' WHERE `Matrix_Unique_ID` = '211971981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T20:36:55.263' ,`MLSNumber` = '86293385' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791347' ,`Longitude` = '-95.814374' ,`PhotoCount` = '12' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '314000.00' ,`Status` = 'Active' ,`StreetName` = 'Inwood' ,`StreetNumber` = '5331' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1-story in Katyland has been recently updated with a NEW ROOF, new garage door openers, fresh interior paint, freshly painted cabinets, new gas range and dishwasher, new Luxury Vinyl Plank flooring and carpet, and a brand new primary bathroom complete with a gorgeous tiled shower with seamless glass door. The plan features a centrally located living room with vaulted ceilings and brick fireplace. The galley Kitchen has a pass-through bar for an open feel to the living room and features granite countertops, large sink, and stainless steel appliances. Refrigerator stays. Two secondary Bedrooms with good closet space share a full bathroom. The Primary Bedroom is spacious with a walk-in closet and private, updated Bathroom. The backyard is huge so there’s plenty of room for all of your activities and hobbies. No back neighbors. Katyland has always been a desirable place to live due to its easy access to parks, schools, library, and I-10.' ,`Acres` = '0.2273' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK A KATYLAND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HUTSELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katyland' ,`TaxAmount` = '4513' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711423' WHERE `Matrix_Unique_ID` = '211986971' --> 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','212094379','1663711423','212094379','2022-09-16T21:42:42.347','25921710','Paula Miller','JPAR - The Sears Group','Kathleen Montes','Target Realty, Inc.','30.214268','-95.429515','34','77385','9','339900.00','Option Pending','Greenhouse','16861','Street','Conroe','2','1','4','3087','Single-Family','Gorgeous, professionally updated, this 2-story home is perfect, with 4 bedrooms and a flex room. Immediately, the space and natural lighting this home has to offer is breath-taking! Step inside onto the luxurious vinyl-plank flooring that flows effortlessly throughout the first level. The open kitchen boasts immaculate white quartz counter tops, designer picked ceramic backsplash, black hardware (used throughout the home), all wrapped around brand-new stainless-steel appliances to bring it all together! It doesn\'t stop there, the Primary suite and ensuite bathroom offers the privacy you crave to unwind from any day. Upstairs is where all the action is! A spacious media room for movie night with the kids, or a lively game night in the family room. Also located upstairs is a bonus room, with its own closet that can be used as an office, study, or a 5th bedroom. The upstairs laundry room is nice convenience too. Don\'t miss this gem. It won\'t last long!','0.1149','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Mock Fireplace','1','Conroe Southeast','Central Electric','1','S720802 - MONTGOMERY CREEK RANCH 02, BLOCK 1, LOT 6','Subdivision Lot','5006','Appraisal District','','300','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Montgomery Creek Ranch 02','6899','2.6088','Water District','2009','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212101402','1663711423','212101402','2022-09-16T21:47:59.210','45335072','Nancy Barr','RE/MAX 5 Star Realty','','','29.662017','-95.052977','45','77571','11','375000.00','Active','Weimer Lagoon','390','Road','La Porte','2','1','4','2471','Single-Family','This is a lovely home less than 2 years old. Spacious open living areas with extra high ceilings. Wood grain tile flooring. Custom window shades throughout the house. Shades remote controlled in the downstairs areas except for the study. There is a large covered front porch and an even larger patio with 8 X 18 foot of it covered under the roofline. The downstairs primary bedroom has a high ceiling and oversized bath and closet. The lot is deeper than usual. Great community pool, walking trail around the lake, dog park area, and a gym are a part of this beautiful community.','0.1551','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','La Porte/Shoreacres','Central Gas','1','LT 5 BLK 2 MORGANS LANDING SEC 6','Subdivision Lot','6758','Appraisal District','','875','0','','2','Gas Oven','0','','','Gas Range','','Composition','35 - La Porte','JENNIE REID ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required,Lockbox Front,Supra Keybox','Seller','2','Traditional','Morgan\'s landing','11669','3.5108','Public Sewer,Public Water','2020','Seller'); --> 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','212134244','1663711423','212134244','2022-09-16T21:52:34.360','31287361','Darla David','RE/MAX Distinction','','','30.228191','-95.565382','46','77354','11','439600.00','Active','Weisinger','518','Drive','Magnolia','2','1','4','2198','Single-Family','Gorgeous ONE story, 1/2 acre lot in sought after Westwood!!! This Spacious beautiful 4 bedroom 2 1/2 bath 2 car garage with storage area for the RV oversized concrete pad. Plenty of counter space, granite and SS appliances, light & bright open floor plan. Spacious family room. Huge covered patio overlooks a large maintained backyard. This space is perfect for entertaining. The private primary suite is tucked away toward the back of the home featuring a spacious master bath with two walk-in closet, double sinks, a large shower and garden style tub creating a serene retreat. LOW HOA and NO MUD!! You do not want to miss this one!!!','0.4591','15','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Magnolia/1488 East','Central Electric','1','WESTWOOD 03, BLOCK 2, LOT 11','Cleared,Subdivision Lot','20000','Appraisal District','','228','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','36 - Magnolia','TOM R. ELLISOR ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required,Call Occupant,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Westwood 03','5983','1.8587','Aerobic,Public Water','2013','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','212268765','1663711423','212268765','2022-09-16T20:51:20.913','31424295','Jamie Poirier','Oak Forest Realty, LLC','','','29.725507','-95.406038','50','77005','14','1895000.00','Active','Bissonnet','1919','Street','Houston','3','1','5','5372','Single-Family','Beautiful Southampton residence, this 5 bedroom, 3-1/2 bath home is a must see in the Museum District! Downstairs features a large kitchen with granite countertops and stainless steel appliances, a separate formal dining space, and an oversized master suite. Upstairs (via stairs or 3\'x4\' elevator) boasts 2 additional bedrooms sharing a jack-and-jill bath, an additional bedroom suite, and a bonus room. This home has a unique over-sized double garage as well as a whole home generator. The property is fully fenced with a secluded courtyard that is perfect for relaxing or entertaining. Don\'t miss out - come and see this home today!','0.1377','17','Stone Acorn Builders','','','','No Disclosures','1','Gas Connections','1','Rice/Museum District','Central Gas','0','LT 14 BLK 44 SOUTHAMPTON PLACE','Other','6000','Appraisal District','','','0','','2','Gas Oven','0','','','','','Composition','27 - Houston','POE ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Appointment Required,Supra Keybox','Builder','2','Traditional','Southampton Place','31824','2.3307','Public Sewer,Public Water','2013','Builder'); --> 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','212331246','1663711423','212331246','2022-09-16T20:26:34.000','18704971','Travis Edmunds','Coldwell Banker Realty','','','30.272453','-95.477008','50','77304','16','649500.00','Active','Maple Creek','647','Court','Conroe','3','1','4','3554','Single-Family','Welcome to your new home! This certified energy-efficient, Asher II plan with 2 bedsdown boasts top-notch design features & stunning curb appeal. Enter through the beautiful 8ft entry door & you\'ll notice the architectural details that will be sure to impress. Study w/8ft double doors; Formal Dining w/deluxe crown; breathtaking tiered rotunda w/wrought iron curved staircase that will leave you & your guests \"wowed\"! Your dream open kitchen has stainless appliances, quality cabinetry & a Texas-size island. Upstairs features a large game room, high ceilings, a private surround sound wired Cinema, & secondary bedrooms. Additional upgrades include luxurious 24x12in tile floors, 8ft Doors & 8in Base trim, professional epoxy floors in the garage and more. A masterpiece of a home w/ large covered patio & 3 car tandem garage on a corner lot w/ access to the nature trails across the street. Located in the most convenient location of Grand Central Park between The Woodlands & Lake Conroe.','0.19','19','Westin Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','Grand Central Park Lot:25 /Block: 1','Corner,Subdivision Lot','8324','Appraisal District','','1073','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','WILKINSON ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Grand Central Park','','3.08','Public Sewer,Public Water,Water District','2022','Builder'); --> 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','212359727','1663711423','212359727','2022-09-16T20:09:00.683','87139131','Cindy Waters','Walzel Properties','Jamie Rodriguez','eXp Realty, LLC','30.333195','-95.495039','49','77304','11','499000.00','Option Pending','Village Hill','60','Lane','Conroe','3','1','4','3125','Single-Family','Custom, updated home on 1+ acre! Great location - close to I-45, Hwy 105, shopping and schools! This beautiful home is on corner w/circle driveway, 3 car garage, additional parking & large breeze way/patio between home and garage. Downstairs offers formal dining & breakfast area, large family room w/fireplace, laundry room w/sink, study w/built-ins, & primary bedroom w/ensuite bath, 1/2 bath, wet bar & central vac system. Upstairs offers 3 large bedrooms, game room, & 2 secondary full baths. Updates/improvements include: carpet 8/22, all bathrooms updated w/granite, sinks, tubs, toilets, tile & fixtures, primary bath remodeled w/large walk-in shower 2/22, downstairs flooring replaced w/engineered stone 9/21, water softener system 9/21, 2-water heaters 12/20, 2 garage doors 11/19, & roof 9/20. Come enjoy the mature shade trees on this 1+ acre homesite.','1.05','19','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Lake Conroe Area','Central Gas','0','VILLAGE HILLS, LOT 31','Corner','45738','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','GIESINGER ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Village Hills','6010','2.1863','Public Sewer,Public Water','1982','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','212455539','1663711423','212455539','2022-09-16T20:52:41.830','30013935','Tammi Freund','Compass RE Texas, LLC','','','29.868479','-95.497445','38','77040','7','240000.00','Active','Caracara','7218','Drive','Houston','2','1','3','1958','Single-Family','Charming two-story home on large cul-de-sac lot in Northwest Place Estates. This lovely home features an open floor plan, kitchen with ample counter space and stainless steel appliances. Large master bedroom with a private en-suite with dual sinks, large soaking tub w/separate shower. Upstairs there are two spacious bedrooms, a nice size game room and secondary bathroom. Home is zoned to Cy-Fair School district but still considered Houston. Home is conveniently located to HWY 290 with quick access to 610 loop. Book your appointment today!','0.1074','11','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Northwest Houston','Central Gas','1','LT 10 BLK 1 NORTHWEST PLACE ESTATES AMEND','Subdivision Lot','4680','Appraisal District','','390','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','HOLBROOK ELEMENTARY SCHOOL','JERSEY VILLAGE HIGH SCHOOL','DEAN MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Northwest Place Estates','5669','2.5842','Public Sewer','2010','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','212484552','1663711423','212484552','2022-09-16T21:14:43.523','75368879','Jerri Alonzo','Keller Williams Heritage','','','29.783458','-94.910652','38','77523','9','319000.00','Active','Sandy Creek','6007','Drive','Baytown','2','1','4','2493','Single-Family','This two-story dream home is simple yet elegant. A generous family room adjoins the kitchen and its breakfast nook. A spacious game room, with three additional bedrooms and additional bath is located on the second floor. The primary bedroom suite features a garden tub with sperate shower. NO backyard neighbors. It has a new roof, water heater, kitchen cabinets and granite countertops. New stove and dishwasher. Fresh paint. Did I mention, it has an Epoxy garage floor. Minutes from the elementary school. Located close to shopping, entertainment, and dining. A short drive to I-10.','0.127','53','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','','','Baytown/Chambers County','Central Gas','1','BK 1 LT 2 DEVINWOOD PHASE I','Subdivision Lot','5532','Appraisal District','','300','0','','2','Freestanding Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','CLARK ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Devinwood Ph 01','5661','2.9232','Public Sewer,Public Water','2006','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','212534082','1663711423','212534082','2022-09-16T20:53:40.080','5700923','Liliana Lezo','REAL Houston','','','29.813972','-95.155306','31','77049','6','310000.00','Active','Mountain Mist','15834','Trail','Houston','2','1','3','2253','Single-Family','Welcome to the home of your dreams! If you\'re looking for a home that has it all, this is the one for you! This home offers a study /office area that is quiet and free of distractions. The heart of the home is the stunning kitchen which is breath taking with gleaming granite counters. The inviting living room is a great place to relax and unwind after a long day. The master suite is spacious, generously sized with walk-in closet. Owner has converted the garage into two bedrooms and the game room into a 4th bedroom upstairs. In total a total of 6 bedrooms. The backyard is great for entertaining your guests! Not only can you enjoy your covered porch but also enjoy the pool area which features a spacious deck that is perfect for entertainment. Come and take a look today!','0.1085','2','','','','','Sellers Disclosure','','','1','North Channel','Central Gas','0','LT 21 BLK 2 CARPENTERS LANDING SEC 2','Cleared','4725','Appraisal District','','','0','','0','','1','Above Ground','','','','Other','8 - Channelview','Brown Elementary School (Channelview)','CHANNELVIEW HIGH SCHOOL','AGUIRRE JUNIOR HIGH','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Carpenters Lndg Sec 02','5759','2.758','Public Sewer,Public Water','2007','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','212551482','1663711423','212551482','2022-09-16T20:58:19.910','87156253','Bruce Sellers','Keller Williams Advtge Realty','','','30.417626','-95.612493','50','77356','15','1785000.00','Active','Promenade','369','Street','Montgomery','4','1','4','4912','Single-Family','RARE waterfront home that\'s also on the golf course is located in the gated country club community of Bentwater on Lake Conroe with exclusive GRAND PINES MEMBERSHIP available. Completely updated traditional style with two full suites on the first floor and another two full suites upstairs plus game room and media room and additional \"bunk\" room currently set up to sleep six. Situated at the very end of a cul-de-sac, this exceptional location has a private pool, expanded dock with two boat slips, open water views and sits next to the tee box of the 3-par 14th hole of the Weiskopf course, one of 54 holes of golf available to those who opt for the Grand Pines Membership level. Your quiet lifestyle provides the privacy of a gated, golf course community on Lake Conroe yet you\'re only a short drive to all the shopping, dining and world-class medical facility amenities of The Woodlands. Exemplary Montgomery ISD.','0.4165','39','','','Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Lake Conroe Area','Central Gas,Zoned','1','BENTWATER 59, BLOCK 2, LOT 1','Cul-De-Sac,On Golf Course,Waterfront','18142','Appraisal District','','1381','0','','3','Double Oven,Gas Oven','1','Gunite,Heated,In Ground,Salt Water','','Gas Cooktop','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Seller','2','Traditional','Bentwater','19750','2.3266','Water District','2002','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','212582683','1663711423','212582683','2022-09-16T21:01:12.317','55217150','Rochelle Rangel','REALM Real Estate Professional','','','29.876748','-95.744289','34','77449','6','302000.00','Active','Autumn Summit','21518','Street','Katy','2','0','4','1817','Single-Family','Take a look this charming 1 story home that features 4-bedroom and 2 baths. Home also includes a tankless water heater, water softener, mud room, video doorbell, and covered patio! Tile throughout most of the home with carpet in the bedrooms, granite countertops, recessed lighting in kitchen and breakfast/dining room. Kitchen is open to the living room and is great for entertaining. Spacious primary bedroom with master bathroom has a separate tub and shower, and blinds throughout home. This amazing home is minutes from retail, shopping and entertainment.','0.1738','25','','','','','Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 29 BLK 1 LANTANA SEC 1','Subdivision Lot','7569','Appraisal District','','470','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern,Ranch','Lantana Sec 1','4862','2.831','Public Sewer,Public Water','2020','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','212603030','1663711423','212603030','2022-09-16T21:08:28.240','31625560','Samantha Sloan','The Texas Living Real Estate G','','','30.234204','-95.117313','12','77372','3','365000.00','Active','County Road 3669C','00','','Splendora','2','1','3','1785','Single-Family','Custom Farmhouse with modern charm! To be built. Beautiful and wooded lot- almost half an acre- in a quiet country neighborhood! No restrictions allow for you to build your dreams! In a traditional Farmhouse style, the Board and Batten exterior is highlighted by executive stone and gorgeous windows. The open floor plan offers a private study, formal dining, and an island kitchen dreams are made of! The exquisite Owner\'s Retreat provides plenty of space with a luxurious en suite complete with his and hers vanities, large closet space, and walk in shower. Perfectly sized secondary bedrooms share a guest bath. Entertain in style on the large covered back patio! Finishes subject to buyer taste and builder approval. Incredible opportunity! LOW TAX RATE!','','52','Parks Custom Homes','','','','No Disclosures','','','','Cleveland Area','Central Electric','0','MAYWOOD ACRES, BLOCK 7, LOT 6, ACRES .436','Wooded','18969','Survey','','','1','To Be Built/Under Construction','0','','0','','','','','Composition','100 - Cleveland','SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Maywood Acres','','','Public Sewer,Public Water','2022','Builder'); --> 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','212628828','1663711423','212628828','2022-09-16T21:13:15.900','20671638','Martine Nerrant','Energy Realty','','','29.740081','-95.629264','49','77077','11','1047000.00','Active','Northwood Meadow','13703','Circle','Houston','3','1','4','4288','Single-Family','Welcome to this Modern Luxury home located in man gated community of the Parkway on Eldridge .This home boasts on trend finishes and an open floorplan with brick and stucco exterior, flat tile roof, standing seam metal roof accents. High ceilings with tons of energy efficient windows fill this home with natural light and capture the beauty of the French oak floors that flow continuously through the downstairs. Gourmet island kitchen opens to the living room with white cabinetry quartz counters, chevron style backsplash, SS appliances. Chic design for this 4BR 3.5-baths home, offers a primary bedroom and a private study downstairs, upstairs game room and separate media room, Plantation shutters throughout Just a wonderful balance of design styles that creates a relaxed yet contemporary atmosphere. Located in the heart of the Energy Corridor with top public and international schools. Neighborhood amenities include tennis, playground, and pool. No flooding in The Parkway.','0.1593','31','Kickerillo','','','','Corporate Listing,Sellers Disclosure','1','Gas Connections','1','Energy Corridor','Central Gas','1','LT 1 BLK 2 PARKWAY AT ELDRIDGE SEC 3','Subdivision Lot','6940','Appraisal District','','3460','0','','2','','0','','','','','Tile','27 - Houston','DAILY ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Contemporary/Modern','The Parkway at Eldridge','24005','3.0007','Public Sewer,Public Water','2018','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','212631428','1663711423','212631428','2022-09-16T20:33:45.227','16681328','Natalie Leal','Berkshire Hathaway HomeServicePremier Properties','','','30.041831','-95.535291','31','77379','12','356000.00','Active','Lewisham','18407','Lane','Spring','2','1','4','2545','Single-Family','If a cozy community calls to you, this 4/2.5/2 home is Perfection in a Pocket Neighborhood! A spacious 2-story situated on an interior corner lot is attraction at first sight. Upon entry is a warm and inviting flow; thanks to the combination of tile, engineered wood flooring, carpet, and recently painted walls in uniform color. Expansive Primary Bdrm down, with Primary Bath elegance / 3 Bdrms up, along with a large Gameroom which can peek down below. The home is lovely w/ a location that is prime – convenient access to shops, eateries, parks, and your routes of choice to HWY 249 and the Grand Parkway! Google Home Camera Security System is bonus addition, so smile when you arrive for a visit!','0.1421','13','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Champions Area','Central Electric','1','LT 4 BLK 2 LYNDHURST VILLAGE','Corner,Subdivision Lot','6189','Appraisal District','','525','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','32 - Klein','EHRHARDT ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Lyndhurst Village','5623','2.5085','Water District','2009','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212632349','1663711423','212632349','2022-09-16T21:02:42.360','83084341','Shelby Matthews','Surge Realty','','','30.114427','-95.361459','33','77386','6','699000.00','Active','Woodland Meadow','4018','Drive','Spring','3','1','5','3748','Single-Family','Welcome to 4018 Woodland Meadow Drive! This traditional 5 bedroom 3.5 bath home is located in the desired master planned community of Woodson\'s Reserve. This beautiful brick home with luxurious curb appeal is offering an inviting foyer, media room, open concept living and kitchen space. A courtyard leading off of the kitchen breakfast area - a gorgeous custom terrace featuring a built-in grill, mini fridge and sink that leads to a spacious backyard. The primary suite features natural lighting, ensuite bath with separate jacuzzi tub, standing shower, dual sinks and a large walk in closet with custom built-in shelving. Stairs lead you directly into the upstairs gameroom! Woodson\'s Reserve community features a clubhouse, 24 hour fitness center, pools, trails, dog parks and so much more!','0.255','40','TAYLOR MORRISON','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Mock Fireplace','1','Spring Northeast','Central Electric,Central Gas','1','S973703 - WOODSON\'S RESERVE 03, BLOCK 4, LOT 6','Other','11108','Appraisal District','','1335','0','','3','Convection Oven','0','','','Gas Range','','Composition','11 - Conroe','ANN K. SNYDER ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1.5','Traditional','Woodsons Reserve 03','16885','3.0987','Water District','2015','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','212633185','1663711423','212633185','2022-09-16T21:35:11.793','81653519','Michael Worthen','Christine Cole Realty','','','30.109777','-95.539146','15','77389','4','490000.00','Active','Creek Wood','23926','Drive','Spring','3','1','4','2363','Single-Family','Wow the Privacy on over an acre! You must see this one as there are no others like it and may never be. Fully remodeled, well taken care of, yard maintained, garage apartment, 3 car garage, granite countertops, wood flooring, huge back patio...THE WORKS!!','1.1696','14','94 237','','','','No Disclosures','0','','0','Spring/Klein','Central Electric','1','LT 57 58 & 59 017*C6651800-001-000-057-058- 059 CREEKWOOD AC','Greenbelt,Subdivision Lot,Wooded','50948','Survey','','100','0','','3','','0','','','','','Composition','32 - Klein','METZLER ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Accompany,Appointment Required,Supra Keybox','Seller','1','Traditional','Creekwood Acres U/R','6153','2.124','Well','1983','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','212633366','1663711423','212633366','2022-09-16T21:49:16.290','53085599','Christopher Case','eXp Realty, LLC','','','29.735391','-95.447541','48','77027','2','695000.00','Active','Suffolk','3310','Drive','Houston','2','1','2','1175','Single-Family','Fully upgraded 2 Bedroom / 2.5 Bath home in sought after Lynn Park! Recent upgrades include; Driveway, Roof & Gutters, Hot water heater, Kitchen Appliances, Sewer line, Rain drain (double windows), Flood prevention Level Correction, Refrigerator, Dishwasher, Kitchen Window, installation of double pane windows with screens, in the Living room, Air Conditioner, Backyard deck, Kitchen & Living Room Windows, Large backyard with new shed, upgraded gate IN LYNN PARK ADJOINING HIGHLAND VILLAGE RIVER OAK DISTRICT SHOPPING CENTER. Perfect opportunity to live now and build your dream home later in this sought after location!','0.1722','16','','','','','Sellers Disclosure','','','','Highland Village/Midlane','Central Gas','1','LT 16 BLK 1 LYNN PARK','Subdivision Lot','7500','Appraisal District','','525','0','','1','','0','','','','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lynn Park','13168','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully