Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:28:12.800' ,`MLSNumber` = '64030946' ,`ListAgentFullName` = 'Elizabeth Villarreal' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834518' ,`Longitude` = '-95.446358' ,`PhotoCount` = '33' ,`PostalCode` = '77018' ,`RoomCount` = '10' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'De Milo' ,`StreetNumber` = '1903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning modern farmhouse loaded with custom touches in Houston\'s favorite neighborhood. High ceilings, shiplap, exposed cedar beams, rustic cedar shelving and gorgeous light fixtures set a warm, peaceful tone. 4 sets of double French doors on the 1st floor in addition to large windows and recessed lighting allow beautiful light to flow throughout. Thoughtfully designed primary retreat has luxurious soaking tub, separate shower & custom closet leading to the laundry room. Killer kitchen! is open to the dining area and family room and is a wonderful, glowing space designed for gathering and entertaining with endless quartz countertops, hand-crafted cabinetry, walk in pantry, farmhouse sink, oversized island and stainless Thor appliances including a 48\" duel fuel range with double ovens. Just a short walk away from two outstanding parks and near the Oak Forest community\'s shops and restaurants makes living easy! Fully sodded with sprinkler system. Never flooded; NOT in flood plain.' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = 'VGC Living Designs' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 86 OAK FOREST SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '7253' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666512124' WHERE `Matrix_Unique_ID` = '206566209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:09:27.250' ,`MLSNumber` = '86139593' ,`ListAgentFullName` = 'Kay Tanner-Decuir' ,`ListOfficeName` = 'K Decuir Properties' ,`SellingAgentFullName` = 'Chawannia OConner' ,`SellingOfficeName` = 'O\'Conner Fine Properties' ,`Latitude` = '29.949974' ,`Longitude` = '-94.011592' ,`PhotoCount` = '30' ,`PostalCode` = '77640' ,`RoomCount` = '7' ,`ListPrice` = '354500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Maple Falls' ,`StreetNumber` = '10550' ,`StreetSuffix` = 'Lane' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful one owner custom-built home offers so many amenities it will please anyone. Designer touches throughout. This home is in an HOA ($275 a yr.) and the neighborhood is growing with areas to run and walk. The home comes with a generator that feeds the entire home, living room with a fireplace, totally fenced in backyard for privacy. A balcony upstairs is there to relax in the evenings and there is a covered patio downstairs. 4 large bedrooms with a bonus area. The soaring ceilings and grand entry take your eyes straight to the crown molding throughout the home. This home has a garage anyone would want with so many 220 outlets to power up your tools or toys. Call your buyer\'s agent today for a private showing. Pre-approval for showing required. Sellers are providing a one -year home security system with cameras and fire protection as a bonus.' ,`Acres` = '0.1288' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DOMINION RANCH SEC 2 LOT 1 BLOCK 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '5610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HELENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'WILSON MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dominion Ranch Sec 2' ,`TaxAmount` = '7797' ,`TaxRate` = '2.8532' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666512124' WHERE `Matrix_Unique_ID` = '208238404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:10:33.383' ,`MLSNumber` = '38442591' ,`ListAgentFullName` = 'Darrell Anderson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.365035' ,`Longitude` = '-95.667694' ,`PhotoCount` = '32' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Courteous Creek' ,`StreetNumber` = '1177' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful recent build in the Lake Conroe area! This open concept features the newest design trends! The spacious kitchen hosts sleek white cabinets with beautiful granite countertops with a subway tile backsplash. All stainless steel appliances and designer pendant lighting. The expansive primary suite has a tub, separate shower and dual sinks. Don\'t miss the fenced backyard with oversized covered patio and two ceiling fans!' ,`Acres` = '0.1489' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S503204 - FAIRWATER 04, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater 04' ,`TaxAmount` = '543' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512125' WHERE `Matrix_Unique_ID` = '209257241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:59:17.130' ,`MLSNumber` = '19236288' ,`ListAgentFullName` = 'Richard Orellana' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = 'Andy Griffin' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.528929' ,`Longitude` = '-95.168847' ,`PhotoCount` = '23' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '319000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lighthouse View' ,`StreetNumber` = '16911' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A handsome redbrick of pleasing proportions, this home is nestled on a quiet Friendswood street in a community of neighbors who care. Open-concept and effortlessly functional, the floorplan includes an office and an additional flex space. New flooring and contemporary warm/neutral paintwork are among many recent improvements. With vaulted ceilings and Palladian windows, the primary bedroom is one of several rooms to benefit from amplified light and flow. French doors open onto a leafy back yard with a large covered patio: perfect for drinks as the sun dips down behind the trees. At Heritage Park, the clue is in the name: this is where many put down roots and make memories among the well-maintained amenities, ranging from playgrounds and trails to swimming, tennis and basketball. Walking distance to some of the beloved neighborhood schools as well as an array of dining and retail, this never-flooded home is the perfect base to build a life rich in people and experience.' ,`Acres` = '0.134' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 HERITAGE PARK SEC 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5837' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park Sec 20' ,`TaxAmount` = '5718' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512125' WHERE `Matrix_Unique_ID` = '209398903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:15:42.230' ,`MLSNumber` = '61736723' ,`ListAgentFullName` = 'Deb Ambrosi' ,`ListOfficeName` = 'Ambrosi Realty INC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744797' ,`Longitude` = '-95.883995' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Zephyr Park' ,`StreetNumber` = '3106' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 2-story family home in the heart of Tamarron with the grand FOUNTAIN entrance. Why pay new home prices? Enjoy a nearly new home at a better price per square foot! This is a smart buy. Beautifully appointed home with gorgeous tall kitchen cabinetry, granite countertops, large island and stainless steel appliances has an amazing backyard with no neighbors! The oversized lot (10,453 sq/ft)is a blank slate waiting for your green thumb. You will love having two bedrooms down stairs in this great floor plan. Solar panels by Streamline Energy. We are including a 11 page document with information and contact information to discover the world of solar energy. According to Google, Solar power helps combat greenhouse gas emissions and reduces our collective dependence on fossil fuels. The obvious benefits advertised are lower electrical bills, lower carbon footprints, and added value to home. Don\'t miss this amazing opportunity!' ,`Acres` = '0.24' ,`Area` = '30' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 29, BLOCK 4, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10453' ,`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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '8637' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512125' WHERE `Matrix_Unique_ID` = '210237784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:27:48.370' ,`MLSNumber` = '77775823' ,`ListAgentFullName` = 'Jermietta Howard' ,`ListOfficeName` = 'Citiwide Alliance Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932537' ,`Longitude` = '-95.174548' ,`PhotoCount` = '14' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Magnolia' ,`StreetNumber` = '14515' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY, STUNNING 4 BEDROOM HOME LOCATED ON A CUL-DE-SAC IN ESTABLISHED NEIGHBORHOOD! Its inviting entry is great place to meet guests & welcome them into your home for the 1st of many gatherings. It has an immaculate open concept floor plan and a bright beautiful living space, perfect for entertaining! High soaring ceilings, arches, & natural stone tile are some of the architectural designs available! The Gourmet kitchen with new granite opens to the family room. The upstairs retreat opens to a private balcony and the master suite is down with jetted tub, separate shower & double sinks. Professionally painted new, updated A/C unit, water heater, landscaped tranquil yard are just a few of its amenities. A park & Lake Houston are walking distance away. COME, LOOK, BUY! Seller motivated! ALL offers considered.' ,`Acres` = '0.2003' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 LAKE FOREST VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8726' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '926' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Forest Village' ,`TaxAmount` = '6736' ,`TaxRate` = '2.793' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512125' WHERE `Matrix_Unique_ID` = '210362429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:42:48.607' ,`MLSNumber` = '22605365' ,`ListAgentFullName` = 'Gail Robinson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.061205' ,`Longitude` = '-95.434962' ,`PhotoCount` = '36' ,`PostalCode` = '77566' ,`RoomCount` = '8' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemary' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Lane' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE SUNDAY 10/9 FROM 1-3 pm. Price reduced on this beautifully maintained home in Plantation Oaks. Upon arrival, you\'ll notice the professional landscaping and nice curb appeal. The entry hall has soaring ceilings and an attractive curved staircase. The formal dining room with hardwood flooring is located to the right of the foyer and adjacent is a spacious study/home office. A cozy gas fireplace adorns the living room with high ceilings and a soothing neutral palette that continues to the gorgeous island kitchen with a professional grade Wolf Range and abundant counter space. A lovely breakfast room provides tons of natural light and views to the newly fenced backyard. The primary bedroom is located on the main level with an ensuite bath and the 2nd level provides a huge game room with stylish barn door, 3 additional nice sized bedrooms with walk in closets and full bath with double sink vanity. Many recent updates. The fridge, W & D remain. Call Today!' ,`Acres` = '0.2176' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION OAKS SEC 3 (LAKE JACKSON) BLK 2 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Oaks Sec 3 Lake Ja' ,`TaxAmount` = '7575' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512125' WHERE `Matrix_Unique_ID` = '210594284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:19:45.727' ,`MLSNumber` = '37472502' ,`ListAgentFullName` = 'Jency Medrano' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Kaela Harris' ,`SellingOfficeName` = 'CR Elite Realty' ,`Latitude` = '29.858176' ,`Longitude` = '-95.445946' ,`PhotoCount` = '31' ,`PostalCode` = '77091' ,`RoomCount` = '9' ,`ListPrice` = '354900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dalview' ,`StreetNumber` = '2409' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your brand new Home Sweet Home at 2409 Dalview Lane. Located just 25 minutes from Downtown Houston, 20 minutes from The Galleria, 25 minutes from IAH Airport, in a prime Houston location just minutes away from 610, 290 and 45. This 4 bedroom, 2 bath home has gorgeous high ceilings throughout that makes it feel extremely spacious. The kitchen features granite countertops, stainless steel appliances and is open to the family room. No detail was spared when this builder was designing the ideal home for YOU! You\'ll love the brick accent wall in the family room, wood-style tile flooring and seamless vaulted ceilings. Exterior provides an amazing curb appeal with a FULL brick exterior. Lots of great developments and improvements in the area due to location. Home is completed and ready for move in. Call us today for a private tour.' ,`Acres` = '0.1722' ,`Area` = '9' ,`BuilderName` = 'Ponce Home Creations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 9 HIGHLAND ACRE HOME ANX SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HARRIS ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Acre Home Anx Sec 05' ,`TaxAmount` = '1122' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666512126' WHERE `Matrix_Unique_ID` = '211387670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:31:45.733' ,`MLSNumber` = '83076702' ,`ListAgentFullName` = 'Rick Trevino' ,`ListOfficeName` = 'Loyal Texas Properties' ,`SellingAgentFullName` = 'Jaime Ojeda' ,`SellingOfficeName` = 'Mersaes Real Estate, Inc.' ,`Latitude` = '30.006988' ,`Longitude` = '-95.412478' ,`PhotoCount` = '28' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rock' ,`StreetNumber` = '926' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Thank you so much for viewing. Home has been recently painted and beautifully remodeled and ready for a quick move in!! Granite counter tops in kitchen with breakfast bar, new flooring throughout the home and fresh interior painting!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 13 NORTH VIEW WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5574' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North View' ,`TaxAmount` = '4611' ,`TaxRate` = '2.7292' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512126' WHERE `Matrix_Unique_ID` = '211661742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:34:20.233' ,`MLSNumber` = '2822877' ,`ListAgentFullName` = 'Kristen Novicke' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758247' ,`Longitude` = '-95.877060' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Ribbongrass' ,`StreetNumber` = '29318' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4 bedroom 3 1/2 bath home in Firethorne is in immaculate shape and well maintained by owner. With it\'s extremely functional and open floor plan it is perfect for entertaining. The backyard has a custom privacy fence with an extended covered patio. The primary bedroom is downstairs and the additional bedrooms all upstairs with two bathrooms and a spacious game room. This home is situated on one of the larger lots in a quiet section of Firethorne within walking distance to school. Easy access to I-10 and a convenient commute to Houston Business districts.' ,`Acres` = '0.1674' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 12, BLOCK 3, LOT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7294' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne West Sec 12' ,`TaxAmount` = '8108' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512126' WHERE `Matrix_Unique_ID` = '211965767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:54:31.610' ,`MLSNumber` = '67418790' ,`ListAgentFullName` = 'Andrea Buchhold' ,`ListOfficeName` = 'Realty United' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.400413' ,`Longitude` = '-95.239443' ,`PhotoCount` = '39' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '2714' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, fully remodeled Mid-Century Style Ranch home is move in ready! Complete with a large master suite, mother-in-law suite with kitchenette, living room, family room/game room, granite counter tops, large walk in closets, double pane windows, new roof, and so much more! The POOL and covered patio makes your backyard oasis perfect for entertaining. This home sits on a quiet cul-de-sac with a large driveway & plenty of parking. No HOA! Minutes away from the highway & major roads. Perfect for families, those who love to entertain, as a long term rental, or even a short term rental! So many extras you don\'t want to miss this gem!' ,`Acres` = '0.327' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MEYERLAND (ALVIN), LOT 25 SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Ranch' ,`Subdivision` = 'Meyerland Alvin' ,`TaxAmount` = '7054' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512126' WHERE `Matrix_Unique_ID` = '212021840' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:16:22.493' ,`MLSNumber` = '71613556' ,`ListAgentFullName` = 'Ashley White' ,`ListOfficeName` = 'Kimberly Beggs' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780170' ,`Longitude` = '-95.323747' ,`PhotoCount` = '22' ,`PostalCode` = '77020' ,`RoomCount` = '7' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Yates' ,`StreetNumber` = '2120' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment property in an even better location!! Surrounded by new home construction and just minutes away from Downtown Houston and the East Downtown Mix-Use Project. Home is just around the corner from the highly acclaimed Atherton Elementary school. Home has never flooded. Don\'t miss your opportunity to own a great income generating property near downtown.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 94 AUGUSTA' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Augusta' ,`TaxAmount` = '3748' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512126' WHERE `Matrix_Unique_ID` = '212045074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:49:42.870' ,`MLSNumber` = '58941954' ,`ListAgentFullName` = 'Andrew Pikoff' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542286' ,`Longitude` = '-95.358682' ,`PhotoCount` = '43' ,`PostalCode` = '77584' ,`RoomCount` = '17' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Hanberry' ,`StreetNumber` = '3919' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 5 Bedroom Home with POOL. Large primary bedroom oversees lush outdoor landscaping, pool/hot tub & covered patio. Primary bathroom has an extra-large shower w/ hot/cold fan for added comfort, double vanity w/ Quartz countertops & two walk-in closets! Expansive kitchen w/ tons of space, stainless steel appliances, new quartz countertops, new hardware & new two-tone paint on cabinets. Breakfast area w/ natural light. Office/study w/ built-in cabinets & crown molding. Formal dining room w/ custom paneling & crown molding. Family Room w/ gas log fireplace, built in shelving & bar area. Upstairs boasts a massive game room, 4 large bedrooms, each with their own walk-in closet, 2 jack & Jill bathrooms and a built-in, double desk area. Extra-large pool for entertaining or just relaxing on a hot day. Entire pool, or just the hot tub, can be heated & an outdoor music system makes for great entertainment! Oversized detached garage w/ enclosed walls & epoxy floors. Garage fridge too.' ,`Acres` = '0.2054' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEPOINTE SEC 1 AT SILVERLAKE (A0548 HT&BRR) BLK 2 LOT 17' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8947' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakepointe Sec 1 At Silverlake' ,`TaxAmount` = '9673' ,`TaxRate` = '2.3537' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512127' WHERE `Matrix_Unique_ID` = '212199733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:45:40.747' ,`MLSNumber` = '62882904' ,`ListAgentFullName` = 'Caley Crochet' ,`ListOfficeName` = 'Rachel Crochet Properties,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803161' ,`Longitude` = '-95.434695' ,`PhotoCount` = '31' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Sea King' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful remodeled 3 bedroom 2 bath home located on a corner lot in Lazybrook. 4th Bedroom, 7x10, is\r\naccessed via the primary suite area and perfect for an office/nursery. Extremely open floor plan w/ a large bonus area, butler’s pantry w/ brick wall accent & custom-made built in hall tree.House boasts an oversized kitchen, large island w/ cook top that over looks the living room. Kids play area/flex area off of the living room. New cabinetry, SS appliances & walk in pantry. Engineered hardwood floors through out living area and primary bedroom. Enormous primary closet. Primary bath has large shower & double vanity. French doors off of primary suite w/ a pathway to covered back porch. Covered porch with cedar siding & recessed lighting. Indoor laundry room House has new 30 yr old roof, 2020 Trane furnace, Trane AC unit, Trane AC coil, all new double pane windows, interior & exterior doors, light fixtures, hardware, baseboards, interior/exterior paint. Home won’t last long!' ,`Acres` = '0.1835' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 43 BLK 5 LAZYBROOK' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lazybrook' ,`TaxAmount` = '8413' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512127' WHERE `Matrix_Unique_ID` = '212326777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:49:52.120' ,`MLSNumber` = '54677083' ,`ListAgentFullName` = 'Linda Treadway' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573984' ,`Longitude` = '-95.141886' ,`PhotoCount` = '25' ,`PostalCode` = '77062' ,`RoomCount` = '13' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Lochnell' ,`StreetNumber` = '815' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in a well-established neighborhood, this 3 bedroom, 2.5 bath home has a stunning exterior and a beautiful interior. Luxury vinyl plank flooring and carpet were added in 2021. Walls were painted in 2022. The kitchen boasts stainless steel appliances and opens to the family room. The family room is bright, airy, and opens to an oversized backyard covered porch installed in 2017. Exterior siding was upgraded to cement-board and all windows were upgraded to double-hung, double-paned glass for the ultimate in energy efficiency. Gutters flow into French drains so no standing water around the property. The primary bedroom is large enough to hold a king bed and oversized furniture. The primary bath was completely remodeled from head to toe in 2020. Washer & dryer stay with full-price offer. Excellent schools and close to everything! You\'ve got to see this place!' ,`Acres` = '0.1761' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 16 MEADOW GREEN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '59' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Green Sec 03' ,`TaxAmount` = '5501' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512127' WHERE `Matrix_Unique_ID` = '212395763' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:06:20.637' ,`MLSNumber` = '71499162' ,`ListAgentFullName` = 'Ryan Gaze' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843240' ,`Longitude` = '-95.600782' ,`PhotoCount` = '50' ,`PostalCode` = '77041' ,`RoomCount` = '14' ,`ListPrice` = '865000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Bend' ,`StreetNumber` = '5203' ,`StreetSuffix` = 'Creek' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5203 Cedar Bend Creek in the well established gated community of Lakes on Eldridge! Tucked away quietly at the end of a cul-de-sac this charming 4 bedroom, 3 1/2 bath home contains all formal living spaces, a large family room with 2 story ceilings, a butlers pantry, and an expansive private retreat on the 1st floor with an oversized closet that has his and her sides. Upstairs consists of 3 bedrooms, 2 full baths, and a large multi-use space that is divided into a game room/office with built in desks. Recent updates include floors, backsplash/countertops in kitchen, and primary bath shower. The 3 1/2 car garage has a back door for rear access, a 23x7 workshop, and 37x31 flex space upstairs with a full bath, closet, and AC unit that was recently replaced. The back yard has a pool and spa, a covered patio, and a private area off to the side with a bocce ball court and private seating. Motor Court + 3 car covered parking. And, so many more great features too see for yourself!' ,`Acres` = '0.3147' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 LAKES ON ELDRIDGE SEC 6 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge Sec 06 Amd' ,`TaxAmount` = '13872' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512127' WHERE `Matrix_Unique_ID` = '212496557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:06:09.587' ,`MLSNumber` = '10222793' ,`ListAgentFullName` = 'Tracy Montgomery' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988955' ,`Longitude` = '-95.181076' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Stark Point' ,`StreetNumber` = '18423' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/4 bedroom updated home located in Eagle Springs on a quiet cul-de-sac. Never Flooded ! No carpet in home. Wood laminate floors thru out except kitchen, baths and utility is Tile. Refrigerator, Washer and Dryer included. Recently installed 8/22 Granite counters and new sinks in Kitchen and baths. Kitchen has breakfast bar, SS appliances, and a ton of counter and cabinet space for storage. Kitchen is open to the large family room that has beautiful flooring, crown molding and tile fireplace. Escape to the master suite with high ceilings and french doors that lead to a room that can be used as an office, work out area or nursery. Master bath has double his/her sinks, jetted tub, separate shower, and His and Her walk in closets. Spacious secondary bedrooms/closets and bathroom complete this home. Head outside to the backyard where there is enough room to have a swing-set and/or garden.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 3 EAGLE SPRINGS SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6929' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '6003' ,`TaxRate` = '3.2233' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512127' WHERE `Matrix_Unique_ID` = '212576069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:05:24.053' ,`MLSNumber` = '58728854' ,`ListAgentFullName` = 'Kerri Roberson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Yadira Ornelas' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.033525' ,`Longitude` = '-95.223569' ,`PhotoCount` = '22' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '440000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Trailwood Village' ,`StreetNumber` = '1302' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!! This beautiful home is ready and inviting from the moment you walk through the front door. You will love the open living area featuring large picturesque windows, craftsman mahogany and glass front door, double crown moulding, beautiful wood like porcelain tile flooring, stone fireplace & rod iron railing on staircase. The kitchen areas open concept features a large stoned kitchen island, gorgeous granite in kitchen with herringbone backsplash, stainless appliances with gas range. There is also a newly replaced roof, new Trane A/C and Heat, double wide driveway, water well for low water bills, large backyard with inviting swimming pool, oak trees. detached garage, and so much more.' ,`Acres` = '0.2784' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 31 TRAILWOOD VILLAGE SEC 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '12126' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Trailwood Village Sec 05' ,`TaxAmount` = '7439' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water,Water District,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512128' WHERE `Matrix_Unique_ID` = '212617241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:23:42.327' ,`MLSNumber` = '4600602' ,`ListAgentFullName` = 'Wanda Pink' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654423' ,`Longitude` = '-95.838221' ,`PhotoCount` = '12' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '1875000.00' ,`Status` = 'Active' ,`StreetName` = 'LEANING OAK TRAIL' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEST BUILT LUXURY HOME KNOW AS FORT KNOX. CONCERT AND STEEL. LAKE VEIW PROPERTY ON ONE ACRE NESTLED IN THE COUNTRY IN PRIVATE NEIGHBORHOOD!' ,`Acres` = '1.0234' ,`Area` = '30' ,`BuilderName` = 'ACE LIFESTYLES LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WHISPERING OAKS, BLOCK 1, LOT 13' ,`LotDesciption` = 'Water View' ,`LotSize` = '44579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Whispering Oaks' ,`TaxAmount` = '5796' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666512128' WHERE `Matrix_Unique_ID` = '212666301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:10:19.997' ,`MLSNumber` = '15728336' ,`ListAgentFullName` = 'Susan Allen' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547345' ,`Longitude` = '-95.222969' ,`PhotoCount` = '23' ,`PostalCode` = '77581' ,`RoomCount` = '15' ,`ListPrice` = '459900.00' ,`Status` = 'Active' ,`StreetName` = 'Briar View' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and spacious 2-story home with a pool & spa in the desirable Briarglen subdivision in Pearland ISD! This Cervelle Homes design boasts a generously proportioned dining room, a flex use study or 5th bedroom with French doors, a lengthy family room with gas fireplace & impressive pool views, and a sunlit kitchen with pancake island, abundant pecan cabinetry, a walk-in pantry, & updated appliances. The first-floor master retreat showcases separate his & hers vanities & sinks, a spa tub, a separate shower, a 13\'x8\' walk-in closet, & French doors for a private exit to the pool & spa. Upstairs, find a sizeable game room, 3 secondary bedrooms, and 2 full baths. The fully fenced backyard boasts a custom iron gate, 3 car garage, & oasis pool with a large spa and easy-to-maintain rockscape. The home comes complete with a washer, dryer & fridge & updates in the last 2 years include a new pool filter & lights, a new roof, kitchen appliances, downstairs and upstairs AC, plus MORE!' ,`Acres` = '0.202' ,`Area` = '5' ,`BuilderName` = 'Cervelle' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARGLEN SEC 3 (A0111 PERRY & AUSTIN)(PEARLAND) BLK 3 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarglen Sec 3' ,`TaxAmount` = '8930' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512128' WHERE `Matrix_Unique_ID` = '212794493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:01:02.160' ,`MLSNumber` = '40294568' ,`ListAgentFullName` = 'Donna Wisenbaker-Barret' ,`ListOfficeName` = 'Direct Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005491' ,`Longitude` = '-95.157649' ,`PhotoCount` = '43' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Forest' ,`StreetNumber` = '19623' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home with a spacious front and back yard, 4 bedrooms, 2.5 baths, detached 2-car garage, recent roof 2022, updated wood look tile, granite, amazing updates to kitchen and bathrooms! The 1st floor offers an in-house laundry room, 1/2 bath, den, dining room, formal living room which could also be used as a home office & primary bedroom. The spacious den boasts vaulted ceilings, exposed wood beams, & brick fireplace! The eat in kitchen features ample cabinets, upgraded granite countertops & tile backsplash, updated appliances and recent dishwasher in 2022! The primary bedroom offers an en-suite bath, updated vanities w/dual sinks & light fixtures, walk-in double shower w/floor-to-ceiling tile, & separate walk-in closets! Upstairs opens to 3 secondary bedrooms & full bath w/updated sinks, tile tub/shower! Enjoy the backyard w/outdoor patio & huge back yard that could easily accommodate a pool! Close to schools, entertainment, worship centers.' ,`Acres` = '0.2478' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 PINEHURST OF ATASCOCITA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '679' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst Atascocita Sec 01' ,`TaxAmount` = '4555' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512128' WHERE `Matrix_Unique_ID` = '212797970' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:37:00.943' ,`MLSNumber` = '64197667' ,`ListAgentFullName` = 'Wanda Pink' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782687' ,`Longitude` = '-95.829364' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '1195000.00' ,`Status` = 'Active' ,`StreetName` = 'Woods' ,`StreetNumber` = '6206' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1.14 acres with beautiful big pool! 4700 sq. Ft home approx. across from KATY HIGH SCHOOL\r\n2 min from I 10 FREEWAY. NO HOA NO DEED RESTRICTIONS NO MUD TAX. 4 BED 3 FULL BATH AND 1 HALF BATH\r\nThree car garage with a huge parking lot in basketball Court' ,`Acres` = '1.144' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'KATY TOWNSITE U/R, ACRES 1.144, TRACT 4 (PT) (PT TRACT 1C) (' ,`LotDesciption` = 'Wooded' ,`LotSize` = '49833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Katy Townsite U/R' ,`TaxAmount` = '13015' ,`TaxRate` = '2.2517' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512128' WHERE `Matrix_Unique_ID` = '213054702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:46:00.123' ,`MLSNumber` = '45638201' ,`ListAgentFullName` = 'Theresa Scheib' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.235160' ,`Longitude` = '-95.150180' ,`PhotoCount` = '43' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Splenwood' ,`StreetNumber` = '14392' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED! 2 HOMES FOR THE PRICE OF ONE! Spacious 3/2 home (approx. 1344 sq ft) plus a 1 bedroom GUEST HOUSE -approx 800 sq ft. per previous seller/builder. This home has been remodeled & offers a covered RV parking area w/electric hookup & 3+ car carport most of it covered on 3 sides, 20x15 workshop & huge covered back patio. You will love this newly remodeled home w/new luxury vinyl floors thru-out, brand new A/C system including ductwork installed 8-10-22, newly painted inside top to bottom w/new baseboards, several new ceiling fans & new counters in kitchen. Refrigerator is included as well as washer & dryer in main home. The guest home has a 20x15 living room, kitchen w/gourmet range, breakfast room & large primary bedroom. Great street & neighbors & only about a mile to I-59. Close to 99 & Kingwood & all kinds of shopping. Per previous seller/original owner old home was torn down & this home was built in 1995 were the only ones to live in the home.' ,`Acres` = '0.2638' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'SPLENWOOD, BLOCK 2, LOT 46, ACRES 0.260' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splenwood' ,`TaxAmount` = '1395' ,`TaxRate` = '2.4206' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666512129' WHERE `Matrix_Unique_ID` = '213076913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:51:30.530' ,`MLSNumber` = '60027526' ,`ListAgentFullName` = 'Bonnie Patino' ,`ListOfficeName` = 'Nydan Real Estate Group' ,`SellingAgentFullName` = 'Ady Salcido' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.589850' ,`Longitude` = '-95.456567' ,`PhotoCount` = '33' ,`PostalCode` = '77053' ,`RoomCount` = '3' ,`ListPrice` = '235000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ridgewest' ,`StreetNumber` = '4822' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1377' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for a Chip & Joanna Gaines style home, here it is! Fully renovated home completed at top quality. Crafted with top quality material and products. All new colors & fixtures chosen by design. All electrical updated, new copper wires, new breaker box, new windows, plumbing changed to PVC from galvanized. Tile wood throughout the entire house. Large lot fully fenced with beautiful, matured trees. Definitely a unique house by design. There is not another like it. Grab this gem before its gone!' ,`Acres` = '0.1045' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIDGEMONT SEC 1, BLOCK 8, LOT 25' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'RIDGEMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgemont Sec 1' ,`TaxAmount` = '2726' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512129' WHERE `Matrix_Unique_ID` = '213077843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:52:00.820' ,`MLSNumber` = '96338343' ,`ListAgentFullName` = 'David Karstedt' ,`ListOfficeName` = '1st Texas, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561920' ,`Longitude` = '-95.150721' ,`PhotoCount` = '32' ,`PostalCode` = '77598' ,`RoomCount` = '8' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Mcconn' ,`StreetNumber` = '15302' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique property with no back or side neighbors: nature abounds on the edge of the city in this secluded & well established community with only two entrances. Park like backyard-fruit trees, pond/waterfall backed up to wooded field. Located at the dead end street provides extra parking for your guests. The covered patio connects the oversized garage to the home. A pollinator side garden, full of flowering trees & roses, completes this extra large lot. Concrete and recycled glass counters sparkle in this modern white kitchen. Polished marble & concrete floors keep the home cool & easy to clean reflecting abundant light. Vaulted ceilings, fireplace in living along with lighted bar, and sliding glass patio doors. Three minutes to I-45, 30 minute commute-downtown. Close to Bay Brook mall, medical. Home zones to desirable Clear Creek ISD. The low HOA fees cover recently resurfaced tennis courts, park, and playground. There is also an indoor neighborhood pool requiring a membership fee.' ,`Acres` = '0.1942' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 STERLING KNOLL SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8460' ,`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` = '9 - Clear Creek' ,`SchoolElementary` = 'NORTH POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Knoll Sec 01' ,`TaxAmount` = '4626' ,`TaxRate` = '2.3169' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512129' WHERE `Matrix_Unique_ID` = '213127773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:05:39.950' ,`MLSNumber` = '53726202' ,`ListAgentFullName` = 'Lunguang Wat' ,`ListOfficeName` = 'RealtyOne Plus, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.496589' ,`Longitude` = '-95.776054' ,`PhotoCount` = '30' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Snowbell' ,`StreetNumber` = '6514' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2631' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come view this gorgeous freshly updated/upgraded 5-bedroom home built in 2015! Situated in large corner lot of cul-de-sac, great floor plan, kitchen open to large family room, primary suite downstairs and game room upstairs! Fresh paint throughout, new hardwood looking vinyl plank in family/dining, new carpet & cushion in bedrooms, new chandelier and vanity lights, new ceiling fan, new mirror frames in bathrooms! Kitchen features granite counter tops, breakfast bar and over-the-range microwave! Primary suite w/ large walk-in close, his & her sinks, separate shower and garden tub! Guest bathroom upstairs w/ vanity area and double sinks! Brazos Town Center and Sugar Land Town Center are nearby, very convenient to shop and commute! Low tax rate and HOA fee!' ,`Acres` = '0.1764' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE MEADOW SEC 6, BLOCK 1, LOT 6' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Meadow' ,`TaxAmount` = '6592' ,`TaxRate` = '2.8148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512129' WHERE `Matrix_Unique_ID` = '213133137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:32:14.687' ,`MLSNumber` = '78298129' ,`ListAgentFullName` = 'Maria A. Lugo' ,`ListOfficeName` = 'Sean Powers Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476937' ,`Longitude` = '-95.372997' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Water Glen' ,`StreetNumber` = '7130' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3175' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This high ceilings one and a half story Beazer home located on the larger lake just four houses from the community pool and park has lots of window view of the water and is ready for its new owners! This home offers 4 full bedrooms (one of which could be used as a study) 3 full baths and 1 half bathroom upstairs with a half story game-room. The master bedroom has a full view of the lake and a large walk in shower. The home has a large open layout in the kitchen, breakfast area, and living room making it an entertainer’s dream. The seller upgraded all cabinets and vanities, granite countertops throughout, stainless steel appliances includes, two inch mini blinds, raised ceilings, tankless water heater, and extended covered patio with an outdoor kitchen. The lot has a 25 foot easement on the side for extra room between lots. This home has super insulation for cooler living and low electric bills. Schedule your tour of this beautiful home today.' ,`Acres` = '0.186' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLUEWATER LAKES SEC 1 (MANVEL) BLK 4 LOT 3' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Blitewater Lakes Sec 1' ,`TaxAmount` = '15411' ,`TaxRate` = '3.7274' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512129' WHERE `Matrix_Unique_ID` = '213248218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:24:51.157' ,`MLSNumber` = '40895031' ,`ListAgentFullName` = 'Philip Alter' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742956' ,`Longitude` = '-95.467927' ,`PhotoCount` = '22' ,`PostalCode` = '77056' ,`RoomCount` = '13' ,`ListPrice` = '2250000.00' ,`Status` = 'Active' ,`StreetName` = 'Piping Rock' ,`StreetNumber` = '5218' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An exceptional home planned by Sherpa Builders in the Tanglewood area. Construction to begin soon. Detailed design can be found throughout this soft contemporary home featuring a first floor primary, with additional four bedrooms and a gameroom plus flex room on the second floor. Covered outdoor entertaining area. Large lot with room for a pool. Sherpa Builders’ trademark is a hands-on and closely supervised construction process that ensures a high-quality home. 5218 Piping Rock Lane is in the center of the Del Monte II subdivision off Sage Road convenient to The Galleria area and Uptown Houston with some of the best in dining and shopping that the city has to offer. Another fine home by Sherpa Builders.' ,`Acres` = '0.2408' ,`Area` = '22' ,`BuilderName` = 'Sherpa Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 DEL MONTE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11411' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Del Monte' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666512130' WHERE `Matrix_Unique_ID` = '213248899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:09:15.397' ,`MLSNumber` = '33471771' ,`ListAgentFullName` = 'Brian McCall' ,`ListOfficeName` = 'Legacy Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223263' ,`Longitude` = '-95.704738' ,`PhotoCount` = '37' ,`PostalCode` = '77354' ,`RoomCount` = '16' ,`ListPrice` = '524000.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Heights' ,`StreetNumber` = '40280' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with multiple upgrade packages. New build owner occupied less than one week, move in ready. Built on a premium lot, the home includes new washer and dryer, Security Cameras, new refrigerator, new mounted 55\" tv above fireplace. See attached documents for all upgrades. One of the larger floor plans in the area, it\'s a must see. \r\nALL MEASUREMENTS APPROXIMATE!! PLEASE CALL WITH ANY QUESTIONS!!' ,`Acres` = '0.2058' ,`Area` = '15' ,`BuilderName` = 'Devon Street' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221291 - AUDUBON CREEKSIDE NORTH 03B, BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8966' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas 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,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Audubon Creekside North 03b' ,`TaxAmount` = '539' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512130' WHERE `Matrix_Unique_ID` = '213258775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:59:44.793' ,`MLSNumber` = '5885354' ,`ListAgentFullName` = 'Jason Rodriguez' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.933089' ,`Longitude` = '-95.075320' ,`PhotoCount` = '33' ,`PostalCode` = '77532' ,`RoomCount` = '11' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Marlin Spike' ,`StreetNumber` = '17418' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF, AC SYSTEM AND PLUMBING!!! Stunning family home with just under 2,200sqft of living space that located in one of many Newport lots. Immaculately kept home. Upon entrance, you are greeted by the entryway with high ceiling and wood like laminate flooring. Fantastic natural lighting shine through the high open windows accenting the dining, living room, kitchen & breakfast area. Large eat-in kitchen with stainless steel appliances has a stunning sizable countertops wrapped with granite tops. You\'ll find plenty of space for entertaining with the large living room. The primary suite features spacious room greeted by master bath with his and her sinks as well as a standing glass shower. This massive community has plenty to do and with nearby entertainment is a plus.' ,`Acres` = '0.1687' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 15 NEWPORT SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 05' ,`TaxAmount` = '5063' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512130' WHERE `Matrix_Unique_ID` = '213336262' --> 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','213380016','1666512130','213380016','2022-10-22T20:48:18.960','81792305','Jeffrey Kastendieck','RE/MAX Universal','','','30.060892','-95.492333','5','77388','6','239990.00','Active','Larksong','4815','Lane','Spring','2','0','3','1520','Single-Family','BEAUTIFULLY UPDATED 3 BEDROOM 2 BATHS HOME IN BRIDGESTONE. Home is light and bright with a vaulted ceiling living room which is complimented by a floor to ceiling brick fireplace finished in white. New luxury vinyl hardwood flooring just installed prior to listing. Home is complete with UPDATED solid surface countertops, stainless steel appliances, remodeled Master Bath & Secondary Bath. The lush grass filled backyard is perfect for any growing or for those looking to relax on the back patio. This is a great home for entertaining or just enjoying yourself. COME SEE!','0.1848','14','','','','','Mud','','','1','Spring/Klein','Central Electric','1','LT 15 BLK 6 017*B6830749-003-006-015 BRIDGESTONE SEC 3','Subdivision Lot','8050','Appraisal District','','327','0','','2','','0','','','','','Composition','32 - Klein','ROTH ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','SCHINDEWOLF INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Seller','1','Traditional','Bridgestone Sec 03','4496','2.644','Water District','1982','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:29:36.020' ,`MLSNumber` = '20289414' ,`ListAgentFullName` = 'Christy Crow' ,`ListOfficeName` = 'Victory Properties, Inc.' ,`SellingAgentFullName` = 'Adebayo Adebowale' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.850705' ,`Longitude` = '-95.817573' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Marisol Cove' ,`StreetNumber` = '5310' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a new home but don\'t want to wait months for it to be built, stop here! This 4 bedroom 3 1/2 bath custom home with lakeview will knock your socks off! Built in 2021, this home is move-in ready! Per builder, this home is the Alder Premier edition that is no longer offered for new-builds. The primary is downstairs, with 3 spacious bedrooms upstairs (including a mother-in-law\'s suite with full bath!). There are many upgrades to this home including the built-in air fryer in in the oven, large walk-in closets and a walk-in pantry, and also has a sprinkler system. Did I mention the lake behind the house? \r\nStep outside and enjoy coffee under the covered patio while gazing at the lake behind the house. \r\nPer seller, window screens are on back order from builder. \r\nPer builder, tax rate is 3.59% before homestead exemption. \r\n\r\n\r\nRoom sizes are approximate. Buyer to verify room sizes.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 MARISOL SEC 2' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Marisol' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666512130' WHERE `Matrix_Unique_ID` = '213539089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:34:53.590' ,`MLSNumber` = '64564210' ,`ListAgentFullName` = 'Ngan Winston' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940829' ,`Longitude` = '-95.201429' ,`PhotoCount` = '42' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Starry Summer' ,`StreetNumber` = '12411' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden gem of Humble! EXQUISITE describes this immaculate home nestled in the exclusive community of Sunset Ridge and zoned to the award-winning Humble School District. Offering 2,074 square feet of living space, high ceilings throughout, 3 spacious bedrooms, 2 bathrooms, wonderfully equipped kitchen, with a plethora of cabinets and storage spaces Bright and inviting living room with extra bonus flex room. Upgraded Woodland Gathering Water-Resistant Laminate Flooring throughout main areas. Massive primary suite featuring an oversized walk-in closet, dual vanity sinks, garden tub and stand-up shower. A spacious backyard awaits family gatherings and bbq’s. Stainless steel refrigerator stays with the right offer! NO FLOODING! Schedule your showing today! Buyers to independently verify information.' ,`Acres` = '0.1333' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 SUNSET RIDGE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5807' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Ridge' ,`TaxAmount` = '7435' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512130' WHERE `Matrix_Unique_ID` = '213590281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:36:37.683' ,`MLSNumber` = '28163531' ,`ListAgentFullName` = 'Christina Brewster' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361315' ,`Longitude` = '-95.837788' ,`PhotoCount` = '50' ,`PostalCode` = '77363' ,`RoomCount` = '3' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 204' ,`StreetNumber` = '8428' ,`StreetSuffix` = '' ,`City` = 'Plantersville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2479' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for the country life with easy access to shopping, restaurants, & historic sites within a short drive then look no further! 3bd/2bath/2,471 sqft/20 acres/detached guest home/ & a covered patio to relax on & watch the wildlife. Schedule your showing today!' ,`Acres` = '20' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0063 A YEAMAN, TRACT 9-4, ACRES 20.00' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '871200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = '0' ,`TaxAmount` = '7765' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512131' WHERE `Matrix_Unique_ID` = '213591757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:49:08.447' ,`MLSNumber` = '20405187' ,`ListAgentFullName` = 'Nancy Stow' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708413' ,`Longitude` = '-95.455750' ,`PhotoCount` = '34' ,`PostalCode` = '77401' ,`RoomCount` = '12' ,`ListPrice` = '1449000.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce' ,`StreetNumber` = '4601' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated and gorgeous brick traditional in Bellaire! Situated on a corner lot with pool, covered porch and large side yard. Light-filled with modern upgrades zoned to Horn Elementary. 5 beds, 4.2 baths including attached quarters with separate entry. The spacious quarters/5th bedroom updated in 2018 w/ quartzite and marble kitchen, built-in desk area, and full bath. High ceilings and hardwoods throughout all living areas, kitchen, bedrooms and 3rd floor playroom. Beautiful kitchen features quartzite counters, SS Whirlpool refrig and dishwasher(2020), SS Bosch double ovens and Dacor 5-burner cooktop. Family room has recent built-ins with brick surround gas fireplace. Living Room/future study has a wood-burning fireplace w/marble surround. Side fence (2020); back fence (2017). 5-ton upstairs A/C (2022) downstairs A/C (2014). New water heater (2022), Roof (2011). New and recent paint throughout home. Move-in condition! Walk to Evelyn\'s Park and Betsy\'s Cafe - close to TX Med Center!' ,`Acres` = '0.2014' ,`Area` = '17' ,`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` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 HARDING PLACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Harding Place' ,`TaxAmount` = '19918' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512131' WHERE `Matrix_Unique_ID` = '213640877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:57:49.943' ,`MLSNumber` = '34415572' ,`ListAgentFullName` = 'Lina Campbell' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827454' ,`Longitude` = '-95.512069' ,`PhotoCount` = '36' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Autauga' ,`StreetNumber` = '8907' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1881' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING! 3/4 BDS, 2 FULL BTHS WITH A VERY NICE LAYOUT HOME IN THE BEAUTIFUL & HIGHLY DESIRABLE BINGLEWOOD.\r\nTHIS HOME\'S BACKYARD IS AN ENJOYABLE OASIS WITH ALL IT\'S BREEZE & SHADE OF THE TREES AND BIRDS SINGING! JUST BEAUTIFUL.\r\nTHE OFFICE/BONUS ROOM HAS THE DESIGN DIVERSITY\r\nFORM GUEST DINING, STUDY, GAME TO GUEST BEDROOM.\r\nSURROUNDED BY TRANQUILITY, THIS HOME IS BUILT\r\nWITH STRAIGHT POSITION SUN RISES ON GARAGE SIDE GIVING THE HOME A \r\nMARVELOUS AIR CIRCULATION THAT DRAWS HIGH PROFILE OF ENERGY\r\nSAVING. FROM LOADING,WASHING,COOKING TO INVENTORY ADJACENT TO\r\nKITCHEN,THERE IS A SIDE DOOR IN LAUNDRY ROOM TO\r\nEXTERIOR TRASH BEAM SAVING TIME FROM HEAVY\r\nDUTY HOUSEKEEPING.IMAGINE HAVING A PICNIC WITH FRIENDS AND FAMILY IN COMMUNITY PARK THAT TAKES TWO MINUTES BY WALKING.\r\nGREAT LIVING STYLE 15-20 MINUTES TO MEMORIAL MALL AND IKEA, COSTCO, HOME DEPOT HEB, ASIAN SUPERMARKETS, 99 RANCH & H-MART & ZEN STYLE FOOD.\r\nTHIS HOME IS THE PERFECT CHOICE FOR LIVING QUALITY ACQUIRING AND VALUE\r\nGROWING!' ,`Acres` = '0.2149' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 444 BLK 24 BINGLEWOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Binglewood Sec 04' ,`TaxAmount` = '6502' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512131' WHERE `Matrix_Unique_ID` = '213701338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:39:17.460' ,`MLSNumber` = '60850403' ,`ListAgentFullName` = 'Viviana Garcia' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874839' ,`Longitude` = '-95.708770' ,`PhotoCount` = '16' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '199500.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Village' ,`StreetNumber` = '6707' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home at this price will not last long. Seller is accepting the highest and best offer. Do not miss an opportunity to buy in this zip code as it is minutes away from 290. The home is ready to move in. \r\nCome and see this cozy one-story in this beautiful community; family will enjoy the vaulted ceilings and a traditional brick fireplace in the family room. \r\nThe buyer should independently verify all dimensions and information measurements are approximate. \r\nThe foundation was recently repaired. It has warranty and will be transferred to the new owner' ,`Acres` = '0.1446' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 8 HIGHLAND CREEK VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Creek Village Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512131' WHERE `Matrix_Unique_ID` = '213746620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:52:00.820' ,`MLSNumber` = '13841627' ,`ListAgentFullName` = 'Moira Holden' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.567949' ,`Longitude` = '-95.632120' ,`PhotoCount` = '48' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '785000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekstone' ,`StreetNumber` = '3202' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3777' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY FABULOUS!! Stunning 4/4.5 custom home with sparkling pool & spa nestled on a large Sweetwater Golf Course lot in prestigious Colony Oaks. This beautiful, open concept floorplan was built for entertaining with well proportioned living spaces flowing seamlessly together. Enter the 2 story foyer to gleaming hardwoods & breathtaking pool & golf course views. Elegant dining room can accommodate a large gathering with ease! The formal living room w/feature fireplace is a wonderful spot for conversation and relaxation. Chef\'s dream kitchen is the center of the home w/breakfast bar connecting to the family living space & casual dining nook. One secondary bedroom with ensuite on the first floor. Serene & spacious primary retreat with spa like bathroom and private balcony overlooking the golf course; two large secondary bedrooms (both w/private baths) and sitting/game room on the second level. Large covered patio, green play space and 2 car attached garage. Great schools! Hurry!!' ,`Acres` = '0.2683' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY OAKS SEC 1, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Oaks' ,`TaxAmount` = '12994' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512132' WHERE `Matrix_Unique_ID` = '213755027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:24:35.473' ,`MLSNumber` = '75490065' ,`ListAgentFullName` = 'Burke Purdie' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492387' ,`Longitude` = '-95.086934' ,`PhotoCount` = '26' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Coleman Boylan' ,`StreetNumber` = '1375' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 2-story traditional 4/2/1 located in Oaks of Clear Creek subdivision and much desired CCISD. Primary bedroom(s) /bath(s) both downstairs & upstairs. Game room. 3-car garage. Roof - 9 years, (2) 3-ton Trane XR condensers - 4 years, Trane Coils/Heater in the attic - 4 years. Water Heater - 15 years. High-corner location that did not flood during Harvey! Very close to area shopping, retail and parks.' ,`Acres` = '0.2102' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 PAGE 17 LOT 34 BLK 4 THE OAKS OF CLEAR CREEK SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9157' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'The Oaks Of Clear Creek Sec 2' ,`TaxAmount` = '7456' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512132' WHERE `Matrix_Unique_ID` = '213808854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:17:16.623' ,`MLSNumber` = '20548714' ,`ListAgentFullName` = 'Christa Hoogeboom' ,`ListOfficeName` = 'Sparrow Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540846' ,`Longitude` = '-95.311874' ,`PhotoCount` = '33' ,`PostalCode` = '77584' ,`RoomCount` = '13' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Becky' ,`StreetNumber` = '5913' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coming soon.\n' ,`Acres` = '0.4732' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WAGON WHEEL (A0509 H T & B R R) BLK 5 LOT 7-8' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Wooded' ,`LotSize` = '20613' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'H C CARLESTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Leave Business Card,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Wagon Wheel' ,`TaxAmount` = '6112' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512132' WHERE `Matrix_Unique_ID` = '213823018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:41:33.100' ,`MLSNumber` = '60004672' ,`ListAgentFullName` = 'Debbie Ashley' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571075' ,`Longitude` = '-95.333923' ,`PhotoCount` = '46' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Hills' ,`StreetNumber` = '2117' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fabulous two story features a great floorplan with high ceilings, lots of natural light, custom window covers & imported European hardwood engineered flooring. The kitchen boasts a huge island open to the family room, walk-in pantry & adjacent casual dining with sparkling chandelier. Home office/study provides privacy with its double French doors. Primary bedroom easily accommodates your king-size bed & the curved wall of windows adds elegance. Primary bath with double sinks, soaking tub, separate shower & huge walk-in closet. Upstairs, three bedrooms share two full baths. The game room provides plenty of room for all your friends! Covered back patio with built-in grill & sink. Raised garden bed is ready for planting. Storage shed. Additional fencing for dog run! Quick commute to Houston Medical Center and Museum District. Nearby shopping and restaurants. Amenities include sports complex, splash pad, pool & playgrounds. Low tax rate, affordable HOA, zoned to A-Rated Pearland ISD.' ,`Acres` = '0.1698' ,`Area` = '5' ,`BuilderName` = 'Plantation Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON TERRACE SEC 4 (A0505 H T & B) BLK 2 LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7397' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Terrace' ,`TaxAmount` = '10154' ,`TaxRate` = '2.6537' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512132' WHERE `Matrix_Unique_ID` = '213832194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:58:23.317' ,`MLSNumber` = '68723918' ,`ListAgentFullName` = 'Jaklin Alwaz' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797428' ,`Longitude` = '-95.783556' ,`PhotoCount` = '18' ,`PostalCode` = '77493' ,`RoomCount` = '2' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Tayloe House' ,`StreetNumber` = '24026' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this cute one-story home in the beautiful Williamsburg Hamlet subdivision with easy access to I10 and 99. Within a few steps to Callegari Park that has multiple playgrounds, a Pavilion, multiple Fitness Stations. This house offers 3 bedrooms ,2 bathroom with a lot of recent updates including New AC 2022, fresh paint for the entire house, new bathroom vanities and faucets, new light fixtures, new electric range, new dishwasher, new disposal, new quartz countertop, new sink and faucet in the kitchen. Schedule your private showing today!' ,`Acres` = '0.1584' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 7 WILLIAMSBURG HAMLET SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamsburg Hamlet Sec 01' ,`TaxAmount` = '4971' ,`TaxRate` = '2.5733' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512132' WHERE `Matrix_Unique_ID` = '213832612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T20:21:11.443' ,`MLSNumber` = '44159085' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014861' ,`Longitude` = '-95.503629' ,`PhotoCount` = '48' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Conners Ace' ,`StreetNumber` = '15822' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4359' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY Opportunity!!! Welcome HOME to Wimbledon Champions Estates!! Zoned to HIGHLY acclaimed Klein ISD -- Conveniently located, with EASY access to Grand Parkway, I-45, TX-249 and Beltway 8. This 4 bedroom, 3.5 bath, 2.5-car oversized garage with porte-cochère is DRENCHED in upgrades!! Featuring -- an OPEN family room with gas-log fireplace, SOARING ceilings and RICH LVP flooring throughout! GOURMET quartz island kitchen with BUILT-IN stainless steel appliances, subway tile backsplash, under-cabinet lighting and breakfast nook! PRIVATE primary retreat with DUAL granite vanities, soaking tub + glass oversized shower and WALK-IN closet! SPACIOUS secondary bedrooms, UPSTAIRS gameroom, FORMAL dining, STUDY and SO much more! RELAXING backyard oasis with COVERED patio and resort-style pool with waterfall! Make the call for your PRIVATE tour today -- This home won\'t last long!!' ,`Acres` = '0.2989' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 WIMBLEDON CHAMPIONS ESTATES 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wimbledon Champions Estates' ,`TaxAmount` = '8983' ,`TaxRate` = '2.6165' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512133' WHERE `Matrix_Unique_ID` = '213914862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:31:14.087' ,`MLSNumber` = '13732786' ,`ListAgentFullName` = 'Paulina Yakovleva' ,`ListOfficeName` = 'Prime Dwellings LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861922' ,`Longitude` = '-95.618588' ,`PhotoCount` = '45' ,`PostalCode` = '77041' ,`RoomCount` = '4' ,`ListPrice` = '369400.00' ,`Status` = 'Active' ,`StreetName` = 'Neston' ,`StreetNumber` = '13714' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated, ready to move-in, two story four bedroom house ideally situated minutes from I-10! Freshly updated finishes throughout with a high ceiling great room and grand foyer entrance. From a fresh paint makeover inside and out to a newly installed 30 year composition shingled roof (2022) and HVAC system (2022). Featuring Luxury Vinyl Plank throughout and quality newly carpeted second floor bedrooms. These are just a few of the many updates so schedule your tour before this one is gone!' ,`Acres` = '0.146' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 CONCORD BRIDGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Concord Bridge Sec 05' ,`TaxAmount` = '5750' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512133' WHERE `Matrix_Unique_ID` = '213918388' --> 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','213939641','1666512133','213939641','2022-10-22T21:27:05.907','11782283','Karen Kaman','First US Services & ChannelsLLC','','','29.693734','-95.706988','23','77407','4','349900.00','Active','Highland Chase Dr','7550','','Richmond','2','1','4','1823','Single-Family','You can\'t miss! Harris Floorplan house with one story in master community Lakeview Retreat! New appliances and new flooring, with 4 bedrooms and 2.5 bathrooms. big living room and kitchen. Formal dining included!\r\nYou will like it!','','37','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Mission Bend Area','Central Electric,Central Gas','1','Lakeview Retreat Sec 4, BLOCK 3, Lot 29','Subdivision Lot','','','','850','0','','2','','0','','','Electric Cooktop','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required,Lockbox Front','Builder','1','Traditional','Lakeview Retreat by DR Horton','','','Public Sewer,Water District','2020','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','213945785','1666512133','213945785','2022-10-22T21:42:10.260','78823045','Jeffrey Walters','Virginia Malone Realty','','','29.696604','-95.549180','31','77036','9','284880.00','Active','Sharpcrest','9414','Street','Houston','2','0','3','1899','Single-Family','This home could be a showplace with a little TLC. 3 bedrooms, 2 baths on a nice lot with detached garage. Some updates with paint and some flooring. Freshly insulated attic with low electric bills. Kitchen and baths need updating. Trying to sell without replacing some wood rot on exterior trim and painting. It is dark inside due to lots of wood paneling, but there is an easy remedy. Paint is the cheapest way to make a home gorgeous. Bonuses: insulated pex plumbing, crown molding in den, new water heater and disposal, 12\" blown R-39 in attic, new flooring and wear resistant carpet, fireplace with gas starter, covered patio and insulated detached garage.','0.1837','21','','','','','Sellers Disclosure','','','1','Sharpstown Area','Central Gas','1','TRS 27A & 28B BLK 38 SHARPSTOWN COUNTRY CLUB TERRACE SEC 3','Subdivision Lot','8004','Appraisal District','','250','0','','1','','0','','','','','Composition','27 - Houston','WHITE ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','SUGAR GROVE MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Sharpstown Country Club Terrac','4067','2.3307','Public Sewer,Public Water','1970','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','213971786','1666512133','213971786','2022-10-22T20:54:42.433','74843886','Tami Bedinger','Save 1900 Realty, LLC','','','30.094329','-94.866639','46','77535','13','899900.00','Active','County Road 6323','264','','Dayton','3','1','5','4706','Single-Family','WELCOME HOME! This home has been loved and well maintained, it is ready for the next owners love. As you walk through the front doors you will feel right at home with the beautiful Iron spiral staircase to the 4 balcony\'s looking over the entry and living room. If you love to cook and entertain you will LOVE the kitchen and the outdoor space. The pool and hot tub were added a couple of years ago and still have many years of enjoyment out of it. The primary bed room has French doors leading out to the pool/hot tub area. While upstairs there are 4 bedrooms, a media room and a large game room/living room. Bond with your children with popcorn and movie nights in the media room. The large game room can be another living space for the kids to entertain their friends, the french doors leading to a large balcony looking over the pool. The bonus with this house is that it also comes with over 8 acres of land, the possibilities are endless.','8.5421','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','2','Dayton','Central Gas','1','WHITE OAK TRAILS, SEC 3, BLOCK 1, LOT 13, ACRES 8.5421','Subdivision Lot','372094','Appraisal District','','325','0','','2','Double Oven','1','Heated,In Ground','','Gas Cooktop','','Composition','74 - Dayton','RICHTER ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','White Oak Trails, Sec 3','14613','1.7512','Aerobic,Public Water,Septic Tank','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:51:29.517' ,`MLSNumber` = '92011295' ,`ListAgentFullName` = 'Diana Contreras' ,`ListOfficeName` = 'Home Alliance Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.899065' ,`Longitude` = '-95.393590' ,`PhotoCount` = '22' ,`PostalCode` = '77037' ,`RoomCount` = '3' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Lorino' ,`StreetNumber` = '518' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home has 3 bedrooms/1 bath with large backyard perfect for entertaining. Property has a beautiful iron fence along with two gate entrances. Conveniently located near Hardy Toll Rd & 45-N. Home features two-car carport and brand-new concrete driveway. This cute cozy home is well kept and ready for new owners. No HOA! Never been flooded per seller. Please call for showing, do not disturb tenant.' ,`Acres` = '0.192' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 436A BLK 8 NORTHFIELD PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8363' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'BUSSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'GRANTHAM ACADEMY' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Unknown' ,`TaxAmount` = '1195' ,`TaxRate` = '2.1528' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512133' WHERE `Matrix_Unique_ID` = '213975012' --> 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','213976924','1666512133','213976924','2022-10-22T21:54:07.387','36484686','Vincenzo Vaccaro','Realty Associates','','','29.812484','-95.147926','23','77049','7','285000.00','Active','Krista','16010','Court','Houston','2','1','3','2251','Single-Family','Beautiful home in quiet neighborhood close to Beltway 8. This house is great for entertaining guests with large living/dining area downstairs and all bedrooms upstairs. Brand new carpet, microwave, updated paint (Oct \'22) and total fence replacement (2021). Stainless refrigerator included.','0.1389','2','','','','','Mud,Owner/Agent,Sellers Disclosure','1','','1','North Channel','Central Gas','1','LT 35 BLK 1 SONOMA RANCH SEC 1','Subdivision Lot','6050','Appraisal District','','600','0','','2','','0','','','Gas Cooktop','','Composition','8 - Channelview','Brown Elementary School (Channelview)','CHANNELVIEW HIGH SCHOOL','AGUIRRE JUNIOR HIGH','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Sonoma Ranch','4871','2.518','Water District','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T21:07:06.797' ,`MLSNumber` = '98335813' ,`ListAgentFullName` = 'Sarah Llanes' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.047805' ,`Longitude` = '-95.391515' ,`PhotoCount` = '27' ,`PostalCode` = '77531' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodridge' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Crossing' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 108 Woodridge Crossing in the highly desirable Woodshore Subdivision. A lovely neighborhood with great sidewalks for those evening strolls. This beautiful, fully bricked home features 3 bedrooms, 2 full bathrooms and a large study with all the upgrades available by the builder. Enjoy cool mornings with your coffee on the covered back porch with custom roll down shades on each side. Ensuite bath not only has a soaker tup but includes a separate walk-in super shower with built in bench. Beautiful double recessed ceilings in the dining room adds elegance the already 12 ft. ceilings throughout the home. Main living area is wired for sound and custom sound system stays. LG large capacity refrigerator with ice maker and water in the door, and bottom drawer freezer also included. Carpet in main living areas replaced in August 2022. Third car garage bay is a great upgrade to the home providing extra room for storage and leaving a full size garage for all your parking needs.' ,`Acres` = '0.1724' ,`Area` = '5' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 2 (A0066 J E GROCE) (CLUTE) BLK 1 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore Sec 2 A0066 J E Gro' ,`TaxAmount` = '8470' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666512133' WHERE `Matrix_Unique_ID` = '213977867' --> 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','213980384','1666512134','213980384','2022-10-22T20:20:12.977','60913838','Rose O\'Drobinak','UTR TEXAS, REALTORS','','','29.409130','-95.084610','24','77510','4','477900.00','Active','Avenue L','2215','','Santa Fe','2','0','4','2340','Single-Family','Hurry to see this wonderful, well-maintained home on 5 acres with beautiful mature trees and a peaceful atmosphere! This home features tile floors and granite counter tops with large bedrooms! The home boasts an awesome outdoor deck for relaxing, entertaining and family cook outs with no back neighbors! Endless possibilities await. Schedule your private showing today!','4.95','33','','','','','Sellers Disclosure','1','Mock Fireplace','1','Santa Fe','Central Electric,Central Gas','0','ABST 1 PAGE 7 N 1/2 OF LOT 68 (68-2) THAMANS 1ST SUB','Subdivision Lot','215622','Appraisal District','','','0','','2','Electric Oven','0','','','','','Composition','45 - Santa Fe','WILLIAM F BARNETT ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Thamans 1st Sub','11233','2.3536','Septic Tank,Well','1966','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','213980420','1666512134','213980420','2022-10-22T21:39:53.577','56162419','Mydasha Verrett','Jane Byrd Properties INTL.','','','29.834922','-95.324891','6','77016','4','65000.00','Active','June','4421','Street','Houston','1','0','3','924','Single-Family','Looking for a GREAT Investment!? Well, you have found it. This house sits at the end of the street with great privacy. Area has a lot of newly built homes. A lot of potential!!','0.1378','2','','','','','No Disclosures','0','','','Northside','No Heating','0','LT 43 WEAVER PLACE SEC 2 U/R ABST 32 HARRIS & WILSON','Cleared','6003','Appraisal District','','','0','','','','0','','','','','Composition','27 - Houston','COOK ELEMENTARY SCHOOL (HOUSTON)','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required,Temporarily No Showings,Vacant/Unoccupied','Appraisal District','1','Traditional','Weaver Place','981','2.3307','Public Sewer,Public Water','1952','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','213981506','1666512134','213981506','2022-10-22T20:37:52.157','63151137','Stephen Sheffer','Compass RE Texas, LLC','','','30.124236','-95.515533','32','77389','9','499999.00','Active','Holden Mills','6306','Drive','Spring','3','1','4','3562','Single-Family','Beautiful updated 4 bedroom 3.5 bath 2-story home in Auburn Lakes on a cul-de-sac lot features a 2-story entry and stunning family room w/ 18 foot ceilings & stacked windows that overlook the oasis like backyard and pool! The home features an open floor plan. Private primary suite down w/ updated primary bath, dual walk in closet & door from the sitting area to the backyard for private escapes! Large gourmet island kitchen with recently updated custom cabinets, lighting, Azurite countertops, & stainless steel appliances. Downstairs is complete with formal dining and study. Oversized game room upstairs with 3 large bedrooms & two baths. 3-car detached garage! Recent roof (\'22), pool resurface (\'22), interior paint (\'22), and new carpet! Zoned to outstanding Klein ISD schools!','0.3017','14','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein','Central Gas,Zoned','1','LT 18 BLK 2 VILLAGE OF AUBURN LAKES SEC 1','Cul-De-Sac,Subdivision Lot','13143','Appraisal District','','660','0','','3','Convection Oven,Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','32 - Klein','FRENCH ELEMENTARY SCHOOL (KLEIN)','KLEIN OAK HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Village Auburn Lakes Sec 01','10408','2.914','Water District','2003','Appraisal District'); --> New record created successfully