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-28T23:20:12.543' ,`MLSNumber` = '87440853' ,`ListAgentFullName` = 'Pam Durham' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Roger Pool' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.119683' ,`Longitude` = '-95.571034' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '19' ,`ListPrice` = '6750000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Saddlebrook' ,`StreetNumber` = '36' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '9' ,`BathsHalf` = '3' ,`BedsTotal` = '7' ,`SqFtTotal` = '15630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'French style and old world charm 5 minutes to The Woodlands! Quarters for multi-generational living. A timeless estate on 6+ acres in prestigious gated Saddlebrook Estates- privacy and exclusivity close to shopping, restaurants and entertainment. The unique architectural design, attention to detail & the exceptional quality of materials add to the refinement & overall appeal of this home - Entertain on a grand scale or simply enjoy all the comforts & activities the property has to offer! Limestone, marble & wood floors span the open floorplan. Grand kitchen w/ 55 sq.ft. granite island, SubZero fridge & freezer, professional range, antique wood beams, Osborne Custom cabinets, & antique French terra cotta tile floor. 7 bedrooms w/en suite baths. EXTRAORDINARY grounds designed by the esteemed McDugald Steele Landscape Architects. The stunning resort pool & spa, Pool house, sports court, fire pit, outdoor kitchen, fireplace & covered outdoor areas will provide year-round entertainment.' ,`Acres` = '6.2924' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 1F & 4V (LT 16 SADDLEBROOK ESTS U/R) ABST 50 J MILLER ABS' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '274096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Saddlebrook Estates' ,`TaxAmount` = '103850' ,`TaxRate` = '3.4683' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021283' WHERE `Matrix_Unique_ID` = '208105428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:50:33.820' ,`MLSNumber` = '22247102' ,`ListAgentFullName` = 'Kristin Carter' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = 'Ermilo Ramirez' ,`SellingOfficeName` = 'OMG Sold' ,`Latitude` = '30.174452' ,`Longitude` = '-95.580897' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '9' ,`ListPrice` = '545000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Red Adler' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1-story home is nestled on a quiet cul-de-sac lot in the prestigious neighborhood of Archwyck in Sterling Ridge area of The Woodlands. This home boasts an amazing open concept floor plan in all common living areas, archways, high ceilings, hard wood and tile flooring throughout and a spectacular view of your private backyard oasis. Covered outdoor living space with a luxurious pool/spa combo with waterslide and multiple waterfalls for those hot Texas days and nights. Private, Full outdoor bathroom for backyard entertaining convenience. This backyard is truly a dream for entertaining family and friends. Split floor plans offer separate Master bedroom with en-suite bath and closet overlooking the backyard oasis and private outdoor entry access. 3 Well appointed secondary bedrooms, one with full en-suite bath and closet, other two share a generously sized full bathroom. NEVER FLOODED!' ,`Acres` = '0.2667' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969942 - WDLNDS VIL STERLING RIDGE 42, BLOCK 1, LOT 16' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '11616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 42' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021283' WHERE `Matrix_Unique_ID` = '209395074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:05:26.690' ,`MLSNumber` = '21501589' ,`ListAgentFullName` = 'Sean Palavan' ,`ListOfficeName` = 'Urban Access Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862407' ,`Longitude` = '-95.776711' ,`PhotoCount` = '48' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Dovetail Cliff' ,`StreetNumber` = '6115' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cul-de-sac lot with LARGE BACKYARD is located in the highly desired master-planned Elyson community, with 4 bedroom, 3.5 bathroom, and is conveniently located near Katy Mills and Houston Premium Outlets shopping areas, plus nearby HEB and Target stores under construction. The spacious 1st floor has a large open floor plan and the master bedroom suite. Upstairs, there are another 3 bedrooms and 2 full baths, plus a large open game room overlooking the living area below. Also has a office/study with a closet that can also be used as a bedroom. Lots of neighborhood amenities, including a swimming pool, tennis courts, splash pad, and dog park.' ,`Acres` = '0.1372' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 3 ELYSON SEC 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`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` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson Sec 18' ,`TaxAmount` = '10922' ,`TaxRate` = '3.5368' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021283' WHERE `Matrix_Unique_ID` = '210160361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:17:08.930' ,`MLSNumber` = '61736723' ,`ListAgentFullName` = 'Deb Ambrosi' ,`ListOfficeName` = 'Ambrosi Realty INC.' ,`SellingAgentFullName` = 'Nimesh Patel' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.744797' ,`Longitude` = '-95.883995' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '330000.00' ,`Status` = 'Option Pending' ,`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 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! We HAVE MULTIPLE OFFERS- HIGHEST & BEST by FRIDAY at 5 pm.' ,`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`='1667021284' WHERE `Matrix_Unique_ID` = '210237784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:16:09.153' ,`MLSNumber` = '5540805' ,`ListAgentFullName` = 'Aadil Murad' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068883' ,`Longitude` = '-95.157473' ,`PhotoCount` = '32' ,`PostalCode` = '77345' ,`RoomCount` = '8' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Longflower' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this absolutely stunning 5 bedroom home on a quite cul-de-sac street in the heart of the masterplanned community of Kingwood, TX! Enjoy the miles of nature trails that Kingwood has to offer! This home has been beautifully upgraded with all the modern touches. Fresh new paint really gives the home a light and bright feeling. Also the newly installed lighting fixtures add an elegant modern touch. Not to mention the stainless steel appliances with granite countertops and porcelain tile make this kitchen so breathtaking! The open concept floor-plan is also ideal for entertaining with plenty of room for everyone! High ceilings in the living room with tons of natural light gives this home so much charm! Backyard has a huge covered patio and the home is dotted with mature trees providing plenty of shade! Zoned to top rated schools as well! 5 bedrooms with a gameroom and study with beautiful french doors! Whats not to like, come take a look today!!' ,`Acres` = '0.2328' ,`Area` = '32' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 RIVERCHASE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '671' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverchase Sec 01' ,`TaxAmount` = '9496' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021284' WHERE `Matrix_Unique_ID` = '210260146' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:23:15.840' ,`MLSNumber` = '36368635' ,`ListAgentFullName` = 'Pam Durham' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Rosalinda Swartz' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '30.302964' ,`Longitude` = '-95.642361' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '679000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Prince Charles' ,`StreetNumber` = '8404' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This AMAZING property has so many upgrades and inprovements you\'re not likely to find anything comparable! Impeccably maintained! New roof 2017! Built by Dunn & Stone, the open floor plan makes for easy living & entertaining! 3 BR, 2.5 baths. Study has a closet & could be 4th BR. Large family room/screened addition w/slate floors, fireplace, fans & removable windows that look out to the pool. Beautiful luxury waterproof vinyl floors and custom paint throughout the entire home (2020).Granite counters were added to the kitchen & laundry room.Primary & 2nd bath have marble counters, 1/2 bath has new vanity w/quartz. Dishwasher & cooktop replaced 2020.\r\nThis home is an outdoor lovers dream-Saltwater Pool with spa, summer kitchen w/granite counters, stainless refrigerator & gas grill +2 burners, lighted pergola & fire pit! Storage bldg w/ramp, Concrete pad for RV parking w/50 amp plug and two 6 ft gates for easy parking. Add\'l 300 sq ft of parking added(4 spaces)at front driveway.' ,`Acres` = '1.518' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S357103 - CROWN OAKS 03, BLOCK 1, LOT 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '66124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Oaks 03' ,`TaxAmount` = '7907' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021284' WHERE `Matrix_Unique_ID` = '210296715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:54:25.327' ,`MLSNumber` = '53270760' ,`ListAgentFullName` = 'Delores Ramirez' ,`ListOfficeName` = 'Reyes Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.313346' ,`Longitude` = '-95.246982' ,`PhotoCount` = '45' ,`PostalCode` = '77511' ,`RoomCount` = '10' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2917' ,`StreetNumber` = '3121' ,`StreetSuffix` = 'Road' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2445' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Tilson home on 15.8 acres along with a 36x24 workshop is the answer to all your needs. This beautiful custom home HAS NEVER FLOODED and is not located in the flood zone. NO HOA\'s and NO RESTRICTIONS !!!\r\nIt also comes with an AG EXEMPTION !!! If all this is not enough, the house is owned by it\'s original owner\'s who definitely show pride of ownership. This well maintained home has a beautiful fireplace, tile flooring, open floor concept, large island in the kitchen with it\'s granite countertops and surreal view of the backyard . Lots of natural lighting throughout. French doors welcome you into the office/library for those working at home. This property is a MUST SEE ... with all the positive benefits ... IT WILL NOT LAST LONG !!!' ,`Acres` = '15.83' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0037 S F AUSTIN TRACT 60C-84L ACRES 15.83' ,`LotDesciption` = 'Cleared' ,`LotSize` = '689555' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas 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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '5814' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021284' WHERE `Matrix_Unique_ID` = '210372478' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:37:00.310' ,`MLSNumber` = '53241488' ,`ListAgentFullName` = 'Leo Radford' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Leo Radford' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.993337' ,`Longitude` = '-95.701153' ,`PhotoCount` = '26' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grove Brook' ,`StreetNumber` = '18243' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller offering up to $10,000 dollars in concessions!! This is a lovely home meticulously designed freshly painted with hardwood flooring, Granite kitchen countertops, and stainless still appliances with a refrigerator. It also includes a game and family room with plenty of space for your family to grow and entertain.' ,`Acres` = '0.1118' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 6 VILLAGES OF CYPRESS LAKES SEC 1 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4872' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '60' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Cypress Lakes' ,`TaxAmount` = '6279' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021284' WHERE `Matrix_Unique_ID` = '210786655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:07:00.820' ,`MLSNumber` = '3877460' ,`ListAgentFullName` = 'Sylvia Reyes' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984143' ,`Longitude` = '-95.172522' ,`PhotoCount` = '26' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '434999.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Post' ,`StreetNumber` = '7007' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the house of your dreams. \r\nWith 5 bedrooms, a game room , den, nook, formal dining, formal breakfast, family room, 3 full restrooms, 1 half rest room, drive up garage, 3,852 square feet of living space , a lot of 13,648 square feet and a drive up garage. \r\nA lot of space in the back for your new pool. \r\nRecently painted , Kitchen counter tops were replaced in July and much, much more to offer. \r\nIt will not last..\r\nCall us for a personal tour.' ,`Acres` = '0.3133' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 4 ATASCA WOODS SEC 4 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13648' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods Sec 04 Amd' ,`TaxAmount` = '7805' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667021284' WHERE `Matrix_Unique_ID` = '211176916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:44:08.790' ,`MLSNumber` = '94502368' ,`ListAgentFullName` = 'Riza Tajonera' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.622099' ,`Longitude` = '-95.418080' ,`PhotoCount` = '34' ,`PostalCode` = '77045' ,`RoomCount` = '5' ,`ListPrice` = '334000.00' ,`Status` = 'Active' ,`StreetName` = 'Meandering Elm' ,`StreetNumber` = '2738' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Come home to the private, gated community of Bayou Oaks at West Orem! This spectacular, meticulously maintained home features a two-story great room, open floor plan and design. A spacious owner\'s suite is located on the first floor with a large primary bathroom and walk-in closet. A covered patio and garden pond create a relaxing oasis in your backyard! The community is conveniently located between Pearland and the Texas Medical Center, just minutes from Downtown Houston, University of Houston, Texas Southern University, and a quick hop to popular Houston destinations!' ,`Acres` = '0.1074' ,`Area` = '18' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 BAYOU OAKS AT WEST OREM SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PETERSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Bayou Oaks at West Orem' ,`TaxAmount` = '6866' ,`TaxRate` = '2.8907' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021285' WHERE `Matrix_Unique_ID` = '211279378' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:31:21.417' ,`MLSNumber` = '79296747' ,`ListAgentFullName` = 'Rodrigo Hernandez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847650' ,`Longitude` = '-95.805082' ,`PhotoCount` = '24' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Rue Dela Croix' ,`StreetNumber` = '4926' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2-story Beazer home nestled on a lot with NO REAR NEIGHBORS in the community of Kings Crossing! A covered front porch, pretty landscaping and trees offer great curb appeal! Open the door to gorgeous wood look tile flooring that flows down the hall into the main living spaces! Tucked behind French doors is a private study, ideal for a home office! A light and bright, open floor plan is ideal for entertaining! A HUGE island offers additional seating and storage! Warm 42\" cabinets adorned w/granite countertops, stainless appliances, and water softener system for kitchen finishes out the space! Serene primary suite offers peace and quiet, along w/en-suite bath w/dual sink vanity, granite countertops & enlarged steam shower w/bench seat! Upstairs boasts an airy game room, 3 secondary bedrooms & full bath! Step outside onto a covered patio overlooking the backyard space w/NO REAR NEIGHBORS! Great KATY Schools!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'BEAZER' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 KING CROSSING SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'King Crossing' ,`TaxAmount` = '8692' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021285' WHERE `Matrix_Unique_ID` = '211612630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:18:17.900' ,`MLSNumber` = '13434597' ,`ListAgentFullName` = 'Wendy Oxman' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800218' ,`Longitude` = '-95.463022' ,`PhotoCount` = '49' ,`PostalCode` = '77055' ,`RoomCount` = '10' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6405' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction!2022 Luxurious, Modern Farmhouse sophisticated simplicity by Avenue Drive Homes. Amazing home offers chic,contemporary design with high ceilings and a spacious entry. Open concept home that focuses on luxury and comfort. Impressive Gourmet Kitchen w designer fixtures & custom cabinetry. Long white quartz island. Stainless steel Gas Range w pot filler and Wine/ Beverage Refrigerator adorn the Great Room. So much Storage! Oversized utility Room with multiple extra cabinetry and Multiple Overflow Pantries and closet for storage. Enjoy every evening in a Stylish Primary Bedroom that displays wood beams mounted in High Ceilings. Primary Bathroom features long glass walled Double Shower & Freestanding, White Tub. Enormous! Walk-In His and Her Closets. All Bedrooms have private attached Bathrooms. Upstairs,l find a 2nd Living Area w a corner granite built-in Homework Bar. Bonus Bedroom#3 has 2 huge Walk-In Closets, Covered outdoor patio.Yard has plenty of room for a pool!' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = 'Avenue Drive Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3698' ,`Style` = 'Other Style' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8122' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021285' WHERE `Matrix_Unique_ID` = '211854569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:02:15.543' ,`MLSNumber` = '9497318' ,`ListAgentFullName` = 'Bao Tran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925763' ,`Longitude` = '-95.490223' ,`PhotoCount` = '44' ,`PostalCode` = '77086' ,`RoomCount` = '8' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Heather Hill' ,`StreetNumber` = '10111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 3/2/2 in a corner lot. Home has new roof, new kitchen (granite countertop, new cabinets, and new SS appliances...etc.) It has two new renovated bathrooms, new floor, new insulation, new electric panel, new plumbing and some new light fixtures. Home is ready for your family with a new added HVAC system for 10 years warranty and fresh paint inside out. It also has new trim moldings and new sidings in some wood areas. Amenities of the neighborhood include public pool, playground, tennis courts and walking trails. Home is easy access to Beltway 8 and Hwy 249. Call today to schedule your appointment.' ,`Acres` = '0.2207' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 NORTHWEST PARK SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '9612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARMICHAEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwest Park' ,`TaxAmount` = '3545' ,`TaxRate` = '2.4283' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021285' WHERE `Matrix_Unique_ID` = '211875917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:34:22.713' ,`MLSNumber` = '95718440' ,`ListAgentFullName` = 'Diane Boyd' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144090' ,`Longitude` = '-95.542220' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '14' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Sawyer Ridge' ,`StreetNumber` = '67' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2923' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious and Gorgeous hard to find Single Story home in the coveted neighborhood of Liberty Branch! The beautiful front porch welcomes you into this stunningly detailed and upgraded home. This exceptional home is rich in architectural purity with a neutral color palette and offers a culinary inspired kitchen with upgraded cabinetry, stainless appliances and granite counters. The kitchen is open to the grand family room which offers a floor to ceiling stoned gas log fireplace. You will love the open-concept floor plan that is adorned with rich hardwood floors throughout, architectural wood beams, art niches, eyebrow archways, soaring ceilings, wine room with scrolled iron door and wine fridge, home office with French doors, large laundry room with custom built-in cabinetry and a mud room. Primary retreat with tray ceilings, bay window sitting area and large relaxing primary bath. The back covered patio is one of three covered patios and features a built-in grill. Three Car Garage!' ,`Acres` = '0.1952' ,`Area` = '14' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park' ,`TaxAmount` = '13448' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021286' WHERE `Matrix_Unique_ID` = '211959934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:49:44.387' ,`MLSNumber` = '58118955' ,`ListAgentFullName` = 'Erika Hernandez' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = 'Kassieleigh Locke' ,`SellingOfficeName` = 'Locke and Key Homes' ,`Latitude` = '29.874052' ,`Longitude` = '-95.629628' ,`PhotoCount` = '39' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '299999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hertford Park' ,`StreetNumber` = '6803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This lovely & unique Hertford Home features 2 stories (1st floor has common areas- kitchen, living, dining & half bath) & 2nd floor has primary bedroom plus 2 bedrooms, Laundry and access to garage apartment via walkway outdoors. The Studio Garage Apartment is perfect for a quiet WORK FROM HOME space, maybe an extended stay by a friend/family member, maybe a second small group. The choice is all yours. Also, new paint and ALL NEW carpet upstairs and recently updated flooring in living room. DO NOT PASS THIS UP !!! Call for appointment today. Hablamos espanol, llama hoy para tu cita.' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 HEARTHSTONE PLACE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6285' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '387' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Place Sec 01' ,`TaxAmount` = '5524' ,`TaxRate` = '3.171' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021286' WHERE `Matrix_Unique_ID` = '212040400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:27:59.773' ,`MLSNumber` = '68028439' ,`ListAgentFullName` = 'Raquel Bell' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Angela Heiman' ,`SellingOfficeName` = 'Texas Premier Realty' ,`Latitude` = '28.969000' ,`Longitude` = '-95.978877' ,`PhotoCount` = '30' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '170000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Walnut' ,`StreetNumber` = '3404' ,`StreetSuffix` = 'Drive' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming & beautifully-updated single story design w/3 beds, 2 full baths, & double-wide driveway leading to 1-car attached garage w/auto-opener for ample parking. Features NEW 30-yr roof (\'21), all new gutters, vinyl plank flooring, upgraded lighting/ceiling fans, fantastic natural light, & much more! 1,400 sqft floor plan offers elegant formal dining, & spacious family room open to Chef\'s kitchen; updated w/elegant granite counters, new sink & SS appliances. Primary Suite w/large closet & private en-suite bath w/dazzling standing shower. Secondary beds are bright & spacious w/ample closet space & 2nd full bath nearby for sharing; w/updated tub/shower combo. Large covered patio for grilling & outdoor entertaining overlooks partially-fenced backyard w/tons of room to play. NO MUD tax or HOA dues! Minutes from Downtown Bay City for plenty of shopping, dining & entertainment. Approx 30 mins to Matagorda & Gulf Coast for pristine beaches & fun water activities. Zoned to Bay City ISD.' ,`Acres` = '0.184' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WHITSON HEIGHTS S/D, BLOCK 2, LOT 14 (N 30\') & LOT 15 (S-50\'' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Whitson Heights Sub' ,`TaxAmount` = '3259' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021286' WHERE `Matrix_Unique_ID` = '212073439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:24:53.387' ,`MLSNumber` = '4342085' ,`ListAgentFullName` = 'Raquel Bell' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Delecia Garvin' ,`SellingOfficeName` = 'Winhill Advisors - Kirby' ,`Latitude` = '29.831583' ,`Longitude` = '-95.849190' ,`PhotoCount` = '45' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '625000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lakehouse Landing' ,`StreetNumber` = '221' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Tri Pointe design on oversized >1/4 acre lot in the desirable Lake House community. Tons of custom features include wainscotting, multiple shiplap/accent walls, dazzling light fixtures, designer paint & more. >3,000 sqft floor plan has it all; game room, study behind French doors, formal dining, & spacious family room w/fireplace. Open-concept Chef\'s island kitchen boasts elegant quartz counters & modern SS appliances; including gas cooktop & dbl ovens. Relaxing Primary Suite offers spa-like en-suite bath w/dual sinks, spa tub + separate shower & enormous walk-in closet. Beds 2 & 3 share a well-thought Hollywood bathroom, plus 4th bed enjoys private en-suite! Large covered patio for outdoor entertaining overlooks fenced backyard w/no back neighbors. 2.5-bay oversized garage for ample parking & storage. Zoned to award-winning Katy ISD schools. Steps away from world-class amenities including clubhouse, resort-style pool, fitness center, sparkling lakes w/walking trails & more.' ,`Acres` = '0.2812' ,`Area` = '25' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S558202 LAKE HOUSE SECTION 2 BLK 1 LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakehouse' ,`TaxAmount` = '4865' ,`TaxRate` = '2.1293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021286' WHERE `Matrix_Unique_ID` = '212077110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:58:41.783' ,`MLSNumber` = '75857492' ,`ListAgentFullName` = 'Maryam Mosahab' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851564' ,`Longitude` = '-95.440561' ,`PhotoCount` = '13' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '2032' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new contemporary 2 story 3 bedroom 2.5 bathroom house in rapidly growing area with open concept design which is perfect for entertaining. The kitchen and a large size living-room are in the first floor. Upstairs, a large primary suite includes a private bathroom with double sinks, and shower, with 2 huge walk-in closets. The tow other bedrooms have also big size closets with lots of storage space. The prime location provides convenient access to The Galleria, Spring Branch, Heights and Downtown. Easy access to major highways (I-45 and 610)' ,`Acres` = '0.14' ,`Area` = '9' ,`BuilderName` = 'MB Home Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 30B ABST 110 E BENSON' ,`LotDesciption` = 'Other' ,`LotSize` = '2880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Mansfield Place' ,`TaxAmount` = '1042' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667021286' WHERE `Matrix_Unique_ID` = '212240449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:56:38.143' ,`MLSNumber` = '17244048' ,`ListAgentFullName` = 'Gary Lee' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.902758' ,`Longitude` = '-95.623449' ,`PhotoCount` = '39' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Englebrook' ,`StreetNumber` = '14727' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Copper Brook Subdivision in the Heart of Copperfield. Awesome 4 Bedroom home with 2.5 Baths. Large 3 car garage for storing your Boat. Wood flooring throughout most of downstairs. Tiled Kitchen area, Granite counters, Gas Stove and lots of storage for the Master Chef in your home. 1 Bedroom downstairs and Huge Master up with large sitting area. Master Bath with 2 Closets, Double sinks, Separate Shower and deep soaking tub. Roof replaced about 5 Years ago. Wood staircase done recently. Highly rated CY- Fair School District. Never Flooded and Access to local Restaurants, Hospitals and shopping. This is a great opportunity to live in one of the. most sought out areas in NW Houston' ,`Acres` = '0.1263' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 7 COPPERBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '585' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperbrook Sec 01' ,`TaxAmount` = '6000' ,`TaxRate` = '2.401' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667021287' WHERE `Matrix_Unique_ID` = '212412853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:19:29.847' ,`MLSNumber` = '78032185' ,`ListAgentFullName` = 'Ernest Mooney' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568969' ,`Longitude` = '-95.402198' ,`PhotoCount` = '47' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Cove' ,`StreetNumber` = '2301' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4168' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME ! To this private gated section of the Estates of Shadow Creek Ranch, This well kept one owner model home located on almost 1/2 acre (.4925) corner lot. Entire second floor recently painted and upgraded carpet stairwell included. 8 new ceiling fans/remote controls, and upgraded new lighting fixtures and chandeliers. First floor has new commercial graded vinyl wood grain flooring by Shaw. All of the first floor bathrooms are ADA compliant and have reinforced hand rails. Owners created a new first floor bedroom/office that connects to the main bathroom Kitchen has new recessed lighting w/dim or bright LED choices. Double oven & overhead microwave range installed Feb.22. Outdoor kitchen Dec.2021w/ granite counter tops & built in gas grill w/side burner with refrigerator never used.Both A/C & furnace replaced 2020. Attic has new blown in insulation August 2021. And plenty of backyard for your Pool.' ,`Acres` = '0.4925' ,`Area` = '5' ,`BuilderName` = 'Wilshire Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF6 (PEARLAND) , BLOCK 2, LOT 26' ,`LotDesciption` = 'Corner' ,`LotSize` = '21453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MAREK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '13659' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021287' WHERE `Matrix_Unique_ID` = '212485452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:30:06.943' ,`MLSNumber` = '64239367' ,`ListAgentFullName` = 'Jacqueline Dang' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = 'Milind Patel' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.679934' ,`Longitude` = '-95.598865' ,`PhotoCount` = '18' ,`PostalCode` = '77099' ,`RoomCount` = '5' ,`ListPrice` = '310000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'MAGNOLIA CANYON' ,`StreetNumber` = '12534' ,`StreetSuffix` = 'Canyon' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO FLOODING IN HURRICANE HARVEY!!! CORNER HOUSE WITH 5 OVERSIZED BEDROOMS AND 3.5 BATHS. MASTER BEDROOM, FORMAL LIVING ROOM DOWNSTAIRS WITH KITCHEN INCLUDING BREAKFAST BAR ON THE TILE FLOOR. SPACIOUS GAMEROOM UPSTAIRS BETWEEN THE 4 BEDROOMS WITH 2 FULL BATHS ON THE LAMINATE FLOOR. A SITTING AREA IN THE SECOND BATHROOM USED AS A VANITY IS CONVENIENT FOR THE SECOND AND THE THIRD BEDROOM .\r\n\r\nTHIS HOUSE IS FEW MINUTES TO SCHOOLS, RESTAURANTS AND SUPERMARKETS. EASY ACCESS TO BELTWAY 8, WEST PARK TOLLWAY AND FREEWAY 59.' ,`Acres` = '0.1447' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 REGENTS VILLAGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'REGENTS VILLAGE' ,`TaxAmount` = '5232' ,`TaxRate` = '2.7537' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021287' WHERE `Matrix_Unique_ID` = '212661706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:34:11.640' ,`MLSNumber` = '72820026' ,`ListAgentFullName` = 'Laura Parks' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.597408' ,`Longitude` = '-95.575521' ,`PhotoCount` = '37' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeside Meadow' ,`StreetNumber` = '4515' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful spacious well maintained 1 story with open concept, and high ceilings. Kitchen has stainless steel appliances, island cooktop, double oven (under 1 year old), granite, lots of cabinet space and the Refrigerator is included. Living room has high ceilings, double face fireplace with gas logs and ceiling fan. The extra room can be a study or easily converted to be a 4th bedroom. Lots of storage throughout the house. Primary bath has 2 sinks, tub and 5x5 shower. good size shower. Utility room is large enough to also have a 2nd refrigerator. Garage is oversized for a great workspace. House has brick on all 4 sides, gutters and a sprinkler system. Roof is 5 years old.' ,`Acres` = '0.1735' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESIDE MEADOW SEC 1 @ BRIGHTWATER, BLOCK 2, LOT 50' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7558' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEXINGTON CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Meadow Sec 1 Brightwater' ,`TaxAmount` = '7563' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021287' WHERE `Matrix_Unique_ID` = '212819144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:21:36.607' ,`MLSNumber` = '67416773' ,`ListAgentFullName` = 'Suk-Jun Cheng' ,`ListOfficeName` = 'Suk-Jun Cheng' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781888' ,`Longitude` = '-95.476055' ,`PhotoCount` = '15' ,`PostalCode` = '77024' ,`RoomCount` = '3' ,`ListPrice` = '786000.00' ,`Status` = 'Active' ,`StreetName` = 'Highgrove Park' ,`StreetNumber` = '735' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful brick home zoned to some of the best schools, such as Hunter Creek Elementary, Spring Branch Middle and Memorial High; Fantastic location with direct access to I-10 and 610; centrally located near Galleria, City Center and Medical Center; Nicely appointed in an upscale gated community; Freshly painted interior walls and crown mouldings. New high efficiency A/C and furnace in 2022; new frameless shower enclosure is underway; sprinkler system. Main features include hardwood floors, double-paned windows with plantation shutters, granite countertops, abundant closet space and nice finishes throughout. A large open third floor can be used as a playroom or media room; move-in condition in a great location.' ,`Acres` = '0.0553' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 HIGHGROVE PARK AMENDED' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '2409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highgrove Park Amd' ,`TaxAmount` = '13330' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021287' WHERE `Matrix_Unique_ID` = '213080800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:14:57.707' ,`MLSNumber` = '72949629' ,`ListAgentFullName` = 'Jared Fikes' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080974' ,`Longitude` = '-95.389501' ,`PhotoCount` = '32' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '282400.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Willow' ,`StreetNumber` = '25407' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional home with stunning curb appeal! Entering through the front door, your eyes are immediately drawn to the gorgeous staircase & balcony that flows into the spacious living room with high ceilings. Directly off the living room, the beautiful updated kitchen boast granite counter tops, a perfectly situated island, stainless steel appliances & plenty of natural light. Dining room is perfectly located off the kitchen & offers ample space to enjoy meals with family and friends. Roomy primary bedroom is on the first floor and located off the kitchen. Updated primary bath offers a striking granite double sink countertop & remodeled shower. The sizable upstairs game room provides the ideal place for family entertainment. Other two bedrooms are located upstairs. The back yard paradise boast an exquisite pool & hot tub, a covered deck area and backs up to a preserve. New floors in most areas of home. Community amenities include a pool, tennis courts, and clubhouse. Won\'t last long!' ,`Acres` = '0.1697' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 21 LEXINGTON WOODS SEC 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7392' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods Sec 05' ,`TaxAmount` = '4010' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021288' WHERE `Matrix_Unique_ID` = '213104931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:18:44.320' ,`MLSNumber` = '28260812' ,`ListAgentFullName` = 'Ashley Van den Heuvel' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Jeni Mitchell' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.040288' ,`Longitude` = '-95.470571' ,`PhotoCount` = '36' ,`PostalCode` = '77388' ,`RoomCount` = '13' ,`ListPrice` = '354900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fir Forest' ,`StreetNumber` = '3647' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story home in the quaint neighborhood of Cypresswood. This 4 bedroom, 2.5 bath provides for the perfect place to call home. The living room is spacious allowing for plenty of room for entertaining guests. It has large picture windows that showcases the beauty of the huge backyard. This backyard is big enough to put a pool or hot tub and make it into your own oasis! The kitchen opens up to the breakfast area and a cute coffee bar. Spacious bedrooms and a home office allow for ample room to work from home. With a large primary bedroom and his/her walk in closets, you are walking into the perfect retreat. The upstairs features a bonus room that you can make into your own game room/media room! LOTS OF UPGRADES AND UPDATES DONE. PLEASE SEE UPGRADE LIST! Enjoy the many amenities that Cypresswood has to offer; two pools, playgrounds, and a walking trail!' ,`Acres` = '0.1848' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 36 CYPRESSWOOD SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '535' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Sec 08' ,`TaxAmount` = '5194' ,`TaxRate` = '2.5715' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021288' WHERE `Matrix_Unique_ID` = '213225241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:44:37.190' ,`MLSNumber` = '30704537' ,`ListAgentFullName` = 'Paolinnie Brown' ,`ListOfficeName` = 'Realty Executives' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798971' ,`Longitude` = '-95.137526' ,`PhotoCount` = '16' ,`PostalCode` = '77530' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Bonita Grulla' ,`StreetNumber` = '15425' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located in the Rancho Verde subdivision. Don\'t miss out on this well kept 2 story beauty. Wood tile downstairs and carpet upstairs. Water filtration system installed. Window screens installed on all windows of the home. Security cameras installed on front and back of home along with a Ring doorbell.' ,`Acres` = '0.1157' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 5 RANCHO VERDE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '405' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'HAMBLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'JOHNSON JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rancho Verde Sec 7' ,`TaxAmount` = '6610' ,`TaxRate` = '2.618' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021288' WHERE `Matrix_Unique_ID` = '213225652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:22:47.337' ,`MLSNumber` = '24552193' ,`ListAgentFullName` = 'Linda Ware' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914108' ,`Longitude` = '-95.334850' ,`PhotoCount` = '18' ,`PostalCode` = '77039' ,`RoomCount` = '5' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Toyah' ,`StreetNumber` = '3902' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home at 3902 Toyah Avenue. All tile - no carpet. Featuring 3 bedrooms, 2 bathrooms, 2 car attached garage. Roof replaced in 2015. A/C replaced in 2018. Ceiling fans in bedrooms. Make your appointment to see your new home today. Buyer to purchase survey. House is sold as is. Buyer/agent to verify room sizes if important.' ,`Acres` = '0.1528' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 800 BLK 31 FAIRGREEN SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6656' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'ALDINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairgreen Sec 05' ,`TaxAmount` = '3116' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021288' WHERE `Matrix_Unique_ID` = '213400020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:54:57.567' ,`MLSNumber` = '76819080' ,`ListAgentFullName` = 'Sylvia Reyes' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986039' ,`Longitude` = '-95.195222' ,`PhotoCount` = '17' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '242900.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Crossing' ,`StreetNumber` = '12202' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully updated home has been fitted with all stainless steel appliances, along with hardwood floors, carpet, and a fresh paint job throughout! The custom touches will make you wish you had thought of It first as you tour this home. The warmth of a real fire is incomparable and with this home you can have that experience in your living room as you sit by your gas fireplace during the holidays!' ,`Acres` = '0.1085' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 CLAYTONS CORNER SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Claytons Corner Sec 3' ,`TaxAmount` = '4952' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021288' WHERE `Matrix_Unique_ID` = '213466960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:44:47.613' ,`MLSNumber` = '54771873' ,`ListAgentFullName` = 'MeiMei JamesOu' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712831' ,`Longitude` = '-95.823760' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '13' ,`ListPrice` = '1380000.00' ,`Status` = 'Active' ,`StreetName` = 'Prescott Glen' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous custom home offers a SPARKLING POOL & OUTDOOR KITCHEN With wet bar, situated on a large lot in desirable GATED community RESERVE@SPRING LAKE. Spectacular front elevation, impressive double door leads to a grand foyer with high ceilings, it is elegant & welcoming. Excellent floor plan, Many features, upgrades & updates. quality construction with attention to details. Elegant arches, tray ceilings, crown moldings & high ceilings throughout. amazing island kitchen, wood floor in the entire home except Media room &tiles in wet areas, wine cellar with iron door & cooler, two bedrooms down with 2 full bathrooms & half bath, one of the bathroom by backdoor can use as a pool bathroom. two kitchens, 4 car garages with extra big space, new interior paint & new paint in kitchen & master, new pool pump & computer control panel board. large balcony with beautiful view of pool/backyard. Big two story cover patio area, Shows beautifully like a model home. Come to see today!' ,`Acres` = '0.3535' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 21, BLOCK 4, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Cinco Ranch Southwest Sec 21' ,`TaxAmount` = '25792' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021289' WHERE `Matrix_Unique_ID` = '213468542' --> 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','213635812','1667021289','213635812','2022-10-28T22:26:28.713','91186340','Jamie Kastens','Keller Williams Realty -SW','','','29.665521','-95.690350','30','77407','7','380000.00','Active','Sauki','17410','Lane','Richmond','2','1','4','2024','Single-Family','Classic 4 bedroom 2.5 bathroom starter home in the heart of the Aliana Master Planned Community. This beautiful home is located along the serene walking trail to the private clubhouse, fitness center and resort style pools. The large covered front patio is a key feature of the home as it overlooks the pond. The entire home is freshly painted, including the ceiling, and is ready for your personal touch. A formal dining room welcomes you at the front of the home, and it’s adjacent to a large welcoming kitchen. With freshly painted wooden cabinets, S/S appliances, and plenty of granite counterspace, this kitchen is perfect for entertaining. The open concept home has a large living room with a gas fireplace and direct entry to the backyard and covered back patio. The home is hard-wired for surround sound, and the utility room comes equipped with a front loading washer and dryer. It\'s minutes from Westpark Tollway for easy commutes to Houston and is zoned to top schools in Fort Bend ISD.','0.1433','37','Onyx','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Sugar Land West','Central Gas','1','ALIANA SEC 5, BLOCK 3, LOT 27','Subdivision Lot,Water View','6240','Appraisal District','','1250','0','','2','Electric Oven','0','','','Gas Range','','Composition','19 - Fort Bend','MADDEN ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','GARCIA MIDDLE SCHOOL (FORT BEND)','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Aliana Sec 5','7706','2.9329','Water District','2011','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','213763447','1667021289','213763447','2022-10-28T22:46:49.977','39001969','Karen Gandy','BHGRE Gary Greene','','','29.587017','-95.139323','25','77062','8','319900.00','Active','Oak Chase','14327','Drive','Houston','2','0','3','2000','Single-Family','Beautiful in Bay Glen! Fabulous Kitchen is the heart of the home and offers a huge island with tons of counter space and cabinet and drawer space. Kitchen opens to the Family Room that overlooks the backyard with partially replaced fence and new gate. This home is great for entertaining! Come put your personal designer touches on this home and make it yours! Master planned community with neighborhood swimming pool, tennis courts, basketball courts, parks, and walking trails. Easy Access to NASA, Ellington, Kemah, top notch medical facilities, dining, shopping, I-45, downtown Houston, Galveston, the Port of Houston, and much more.','0.1591','7','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Clear Lake Area','Central Gas','1','LT 8 BLK 3 BAY GLEN SEC 5','Other','6932','Appraisal District','','375','0','','2','','0','','','','','Composition','9 - Clear Creek','WARD ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR BROOK HIGH SCHOOL','CLEARLAKE INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Bay Glen','6222','2.5769','Public Sewer,Public Water,Water District','1989','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','213771400','1667021289','213771400','2022-10-28T22:10:57.700','73724956','Daisy Fernandes','REALM Real Estate Professional','','','29.587669','-95.573240','34','77459','11','499000.00','Active','Westshore Drive','2023','Drive','Missouri City','3','1','4','3450','Single-Family','Spectacular 2-story home with a sparkling pool, study with a large window/double doors and formal dining has been meticulously maintained and cared for. The entire house has been freshly painted with neutral colors. The TWO AC UNITS ARE JUST REPLACED BY THE TOP RATED MANUFACTURER TRANE, which has reduced the electricity bills considerably. The open kitchen has plenty of cabinets, breakfast bar, SS appliances, gas stove, new dishwasher and soft opening drawers. Primary suite with sitting area offers luxurious bathroom with jetted tub, walk-in shower and closets. The upstairs has three spacious secondary bedrooms, two bathrooms and a huge game room that can be used as the 5th bedroom. The landing bridge overlooks the family room. The entire upstairs carpet is just replaced. Programmable outdoor lighting to illuminate the grounds in the front & drive side of the house. A covered pergola with full electric on the patio provides a scenic area to entertain. Must see to appreciate.','','29','','','','','Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','Section 1, Block 2, Lot 3','Subdivision Lot','','','','850','0','','2','Electric Oven','1','Gunite','','','','Composition','19 - Fort Bend','LEXINGTON CREEK ELEMENTARY SCHOOL','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Brightwater','','2.8693','Public Water','1994','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','213807408','1667021289','213807408','2022-10-28T22:51:09.810','33916408','Dawn Walther','HomeSmart','','','29.948330','-95.746149','41','77433','10','864999.00','Active','Covey','17111','Trail','Cypress','4','1','4','4095','Single-Family','GORGEOUS Brick/Stone/Stucco Elevation CUSTOM HOME with HEATED POOL, SPA AND WATERFALL, Porte Cochere, 4 Beds (2 Down) /4.5 Baths/3 Car Garage. Covered patio with travertine decking. Study with Ceiling Beams, Formal Dining Room with custom window treatments, game room & media room with double doors! Gourmet Island Kitchen w/ Amazing Glazed Cabinets, Customized window treatments and Granite Countertops with upgraded appliances! Family Room w/ High Ceilings & Corner Fireplace. Elegant 6 3/8\" Hickory Hardwood Floors in Dining/Entry/Family/Study. Fabulous Master Suite w/ Corner Tub, Separate 80\" Frameless Shower & Two Walk-in Closets. Covered Travertine Patio with sparkling PEBBLETEC HEATED POOL, SPA AND WATERFALLS (BUILT IN 2020) and putting green! Energy Efficient w/ 16 SEER HVAC System, Radiant Barrier, Three car garage with hanging garage storage and epoxy floors, built out storage off media room. Smaller separate garage area for golf cart. SOOO many upgrades this one will go quick!','0.2489','25','','','Electric Dryer Connections','','Mud','1','Stove,Wood Burning Fireplace','1','Cypress South','Central Electric,Central Gas','1','LT 6 BLK 2 BRIDGELAND HIDDEN CREEK SEC 25','Other','10841','Appraisal District','','1300','0','','3','Electric Oven','1','Gunite,Heated','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','2','Traditional','BRIDGELAND','18775','3.4329','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:11:51.130' ,`MLSNumber` = '80067142' ,`ListAgentFullName` = 'Nelly Montoya' ,`ListOfficeName` = 'Realty World Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818321' ,`Longitude` = '-94.826851' ,`PhotoCount` = '20' ,`PostalCode` = '77523' ,`RoomCount` = '4' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14506' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Mitchell plan is a Beautiful two-story home featuring 4 bedrooms, 3 baths, and a 2 car garage. The home opens to a downstairs guest bedroom and full bath with linen shelves. Very Open concept the kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry which connects to the split dining area and family room. The private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. A versatile game room greets you at the top of the stairs and opens to two additional bedrooms and bath. The standard rear covered patio is located off the family room' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021289' WHERE `Matrix_Unique_ID` = '213818820' --> 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','213832267','1667021289','213832267','2022-10-28T22:33:48.597','62989123','Buddy Novak','RE/MAX Lake Livingston','','','30.754875','-95.034577','50','77351','13','614900.00','Active','Southcreek','453','Park','Livingston','3','0','3','2356','Single-Family','Beautiful Custom 3 BR, 3 BA home with large 3 car attached garage on 7 wooded acres in the highly sought after Four Corners subdivision. This 2,356 square feet home features a nice kitchen with lots of counter and cabinet space & walk-in pantry that contains a wine fridge. Home has a spacious master bedroom with walk in closets, jacuzzi tub and walk in shower. Living room has an Austin stone, wood burning fireplace. Home features an office and an extra/flex room. Engineered hard-wood floors and tile throughout. Lots of wildlife to view from your fully fenced backyard - whitetail deer, squirrels, ducks, and many variety of birds. Property has a half-acre pond stocked with both large/small mouth bass & perch. Great central location to Livingston, Onalaska, & Huntsville. Home has sprinkler system for the yard & water filtering system for the entire home. Bring the kids, pets, fishing poles, binoculars and come see this serene property in the middle of a forest - it will not disappoint!','7.034','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Livingston Area','Central Electric','1','FOUR CORNER ESTATES LOT 51','Subdivision Lot,Water View,Wooded','306401','Appraisal District','','250','0','','3','Electric Oven','0','','','Electric Range','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Four Corner Estates','6431','1.8745','Aerobic,Public Water,Septic Tank','2010','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:37:41.790' ,`MLSNumber` = '13966758' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.093366' ,`Longitude` = '-95.187978' ,`PhotoCount` = '46' ,`PostalCode` = '77365' ,`RoomCount` = '13' ,`ListPrice` = '649990.00' ,`Status` = 'Active' ,`StreetName` = 'Granite Shadow' ,`StreetNumber` = '6039' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! LOCATION! LOCATION! 2.59 TAX RATE!!!Beautiful Executive Luxury home with 5 Bedrooms, 4 1/2 Baths, with an attached 3 Car Garage. You will love this OPEN CONCEPT FLOOR PLAN with HIGH CEILINGS! Downstairs you will find the Family Room, Kitchen, Study with french doors & coffered ceiling, Half Bath, 2 Bedrooms including the Primary with tray ceilings, & 2 Full Baths. Notice the wooden staircase with rod iron spindles handrail & Batten & Board DESIGNER WALL leading you UPSTAIRS to the Game Room, Media Room, and 3 bedrooms with 2 Full Baths. You will love the Gourmet Island Kitchen with Butler’s pantry with open view of the spacious family room with GAS LOG FIREPLACE. Don\'t miss the COVERED EXTENDED PATIO and OUTDOOR KITCHEN. Epoxy Garage Floors too! Come to the \"Livable Forest\" & hike & bike the 75 mile of trails, along with great shopping, & entertainment at your front door. Convenient to IAH International Airport W/easy access to Ford Road, TX 59, 99, and Bltwy 8. Humble ISD!!!' ,`Acres` = '0.1865' ,`Area` = '32' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 ROYAL BROOK AT KINGWOOD SEC 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Brook' ,`TaxAmount` = '10978' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'No Sewer,Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021289' WHERE `Matrix_Unique_ID` = '213918180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:23:11.503' ,`MLSNumber` = '37670499' ,`ListAgentFullName` = 'Joshua Olsen' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553663' ,`Longitude` = '-95.518448' ,`PhotoCount` = '35' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Cove' ,`StreetNumber` = '3635' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well maintained spacious 4 bed, 2.5 bath home sits quietly in a cul de sac with only 1 neighbor! Located in the heart of the Olympia Estates subdivision in Missouri City and Fort Bend ISD. You’ll find a massive open living layout with updated flooring and lighting. Roomy bedrooms with all closets offering ample added storage space. This home is nestled in a central location, with quick access to the Fort Bend Tollway and HWY 6.' ,`Acres` = '0.1795' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OLYMPIA ESTATES SEC 11, BLOCK 1, LOT 40' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7821' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Estates' ,`TaxAmount` = '8108' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021289' WHERE `Matrix_Unique_ID` = '214006282' --> 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','214019841','1667021290','214019841','2022-10-28T22:05:35.593','72216302','Laura Bonck','Nan & Company PropertiesChristie\'s International R','','','29.739423','-95.504962','30','77063','3','575000.00','Active','Stoney Brook','2527','Drive','Houston','2','0','3','1838','Single-Family','Welcome home to this beautiful & FULLY REMODELED home. Located in one of Houston’s most desired neighborhoods. Surrounded by mature trees, this home sits in one of the LARGEST LOTS of the subdivision. As you walk in the front door you are welcomed by modern finishes. The spacious dining and living areas open to the naturally lit kitchen. The kitchen is complete with Quartz counters, stainless appliances and new cabinets. Large windows throughout the home bring in an abundance of natural light. Step outside and imagine hosting events on the back patio or simply a quiet place to enjoy your morning coffee. The primary bedroom is the perfect place to stay tucked in and warm this winter. This home is a rare find- book your tour today!','','22','','','','','Sellers Disclosure','1','','','Charnwood/Briarbend','Central Gas','1','LT 7 BLK 8 BRIARBEND','Subdivision Lot','9360','Appraisal District','','400','0','','1','','0','','','Electric Range','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Briarbend','11835','2.3307','Public Sewer,Public Water','1956','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214042024','1667021290','214042024','2022-10-28T22:53:14.437','41446608','Shelly Green','Allegiance Realty Assoc., LLC','','','29.687827','-95.136543','38','77536','4','246900.00','Active','Tulsa','1501','Street','Deer Park','2','0','4','2096','Single-Family','Bright & Spacious! With 4 generously sized rooms, formal dining, and 2 living room spaces, this home has the room you need. New, wood-look laminate in the main areas, open concept conducive to entertaining, and new fencing adds privacy to the backyard. Great location with easy access to Beltway in the desirable DPISD school district! Schedule your in person tour today!','0.1779','6','','','Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Deer Park','Central Gas','0','LT 31 BLK 2 DEER MEADOWS SEC 1','Subdivision Lot','7750','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','16 - Deer Park','CARPENTER ELEMENTARY SCHOOL (DEER PARK)','DEER PARK HIGH SCHOOL','BONNETTE JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Deer Meadows Sec 01','5641','2.8239','Public Sewer,Public Water','1972','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','214050477','1667021290','214050477','2022-10-28T22:29:02.137','11093001','Gregory Bell','HomeSmart','','','29.561526','-95.548497','32','77459','8','399000.00','Active','Glenn Lakes','2915','Lane','Missouri City','3','1','4','2902','Single-Family','Please remove shoes when showing. Please provide feedback after showing. Make offers to: gregoryvbell2013@gmail.com \r\n\r\nAppointment Required.','0.2848','38','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Electric','1','QUAIL VALLEY THUNDERBIRD SEC 2, BLOCK 3, LOT 25, R/P','In Golf Course Community,Subdivision Lot','12406','Appraisal District','','415','0','','3','','0','','','Gas Cooktop','','Composition','19 - Fort Bend','QUAIL VALLEY ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','QUAIL VALLEY MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Quail Valley Thunderbird','8802','2.34','Public Sewer,Public Water','1999','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:14:22.540' ,`MLSNumber` = '4039783' ,`ListAgentFullName` = 'Jennifer Hansen' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752030' ,`Longitude` = '-95.848896' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinpoint Crossing' ,`StreetNumber` = '27815' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**RARE FIND 3900 sq ft+ ONE STORY**FEATURING 5 BEDROOMS 4 FULL & 2 HALF BATHS w/ POOL/SPA/OUTDOOR KITCHEN/FIRE PIT and a 3 CAR GARAGE nestled on an 11,000 sq ft+ LOT in FIRETHORNE. Upon entry you will be greeted with SOARING CEILINGS (10-13ft) & a wide entry leading to the OFFICE STUDY, ENSUITE BEDROOM 2 & FORMAL DINING. Spacious ISLE KITCHEN w/CUSTOM LIGHTING, STAINLESS APPLIANCES,REVERSE OSMOSIS WATER SYSTEM & WRAP AROUND BREAKFAST/SERVING BAR. FAMILY ROOM w/FLOOR TO CEILING TILED FIREPLACE and WINDOW WALL w/GORGEOUS POOL VIEWS & access to the GAME/MEDIA ROOM w/CUSTOM BUILT-INS.TEXAS SIZED PRIMARY SUITE w/POOL VIEWS & ENSUITE BATH w/UPGRADED WALK-IN RAIN SHOWER & 2 PRIMARY CLOSETS. CUSTOM \"MIL/GUEST WING\" added after purchase features a LARGE BEDROOM w/ENSUITE BATH (walk in shower) & POOL VIEWS. BUILT-INS in ALL CLOSETS & UTILITY ROOM. EASY COMMUTE to the ENERGY CORRIDOR. LOADS OF NEIGHBORHOOD AMENITIES. WATER SOFTENER AND TANKLESS WATER HEATER. LOW TAX RATE! KATY ISD. NEVER FLOODED.' ,`Acres` = '0.2683' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE SEC 19, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11685' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne Sec 19' ,`TaxAmount` = '13717' ,`TaxRate` = '2.6945' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021290' WHERE `Matrix_Unique_ID` = '214068457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:27:33.630' ,`MLSNumber` = '51869959' ,`ListAgentFullName` = 'Veronica Alarcon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510043' ,`Longitude` = '-95.801906' ,`PhotoCount` = '43' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Creek' ,`StreetNumber` = '5023' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2493' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Home has been refreshed and ready for the market!! If you have seen this home before you must schedule to see it again! Seller\'s have made some changes! Great size home!! 4/5 bedrooms because a closed in game room could be converted to a room and there is still an office/study room as well. Bring your offer and call your favorite realtor because this home will not last. This back yard has room for your own oasis! Large enough for a pool and much more! Huge lot! Come see for yourself as pictures do not do justice!! Buyer to verify all room measurements *seller provided estimates** New professional pictures and video tour coming 10/28 (Friday)' ,`Acres` = '0.1462' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE TRAILS AT SEABOURNE PARK SEC 1, BLOCK 7, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Trails At Seabourne Park Sec 1' ,`TaxAmount` = '4885' ,`TaxRate` = '3.0248' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021290' WHERE `Matrix_Unique_ID` = '214071238' --> 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','214093521','1667021290','214093521','2022-10-28T22:48:00.130','8803414','Greg DeGeurin','De Geurin Realty, Inc.','','','29.786958','-95.479542','38','77055','12','1995900.00','Active','Danbury','1004','Road','Houston','3','1','5','5733','Single-Family','','0.3483','24','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','2','Spring Branch','Central Gas,Zoned','0','LT 63 & S 12 FT LT 64 BLK D BRYKERWOODS SEC 2','Subdivision Lot','15173','Appraisal District','','','0','','2','Convection Oven,Double Oven','0','','','Gas Cooktop,Gas Range','','Composition','49 - Spring Branch','HUNTERS CREEK ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required','Appraisal District','2','Traditional','Brykerwoods Sec 02','37115','2.4415','Public Sewer,Public Water','2005','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','214099396','1667021290','214099396','2022-10-28T22:23:14.603','62610297','Alma Lind','Coldwell Banker Realty','','','29.670834','-95.351494','36','77033','4','435000.00','Active','Briscoe','5015','Street','Houston','2','1','3','3044','Single-Family','PRICED TO SELL! 2016-17 constructed single story home with 3,000+ SF (per HCAD) and an unrestricted 12,760 SF (Per HCAD) double lot. The home features; an open concept, wood and tile flooring throughout (Carpet Free), large kitchen with an island, granite countertops, stainless steel appliances, a large 3 car garage with space for a workshop and NO HOA. This property will also appeal to investors as a multi-family conversion, as the area is experiencing new duplex construction due to its proximity to the Med Center and Downtown Houston.','0.2929','3','','','','','Sellers Disclosure','1','','1','Medical Center South','Central Gas','0','TR 136B W 116 FT OF S 110 FT OF LT 136 SOUTHLAND ACRES','Subdivision Lot','12760','Appraisal District','','','0','','3','','0','','','','','Composition','27 - Houston','BASTIAN ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Southland Acres','10100','2.3307','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:58:50.690' ,`MLSNumber` = '10969121' ,`ListAgentFullName` = 'Edrina Fitting' ,`ListOfficeName` = 'Ladybug, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586784' ,`Longitude` = '-95.105674' ,`PhotoCount` = '41' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '438900.00' ,`Status` = 'Active' ,`StreetName` = 'Craighurst' ,`StreetNumber` = '16423' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A BEAUTIFUL CONTEMPORARY/TRADITIONAL HOME BUILT BY QUALITY KUSTOM KASTLE. CLIENTS SAY THEY JUST WANT TO LOOK AT HOUSES BUILT BY HIM! GORGEOUS HOME ON THE ESTATE STREET OF PRESTIGIOUS BROOK FOREST!! CRAIGHURST HOMES ARE UNIQUE AND ONE OF A KIND. LOOKING FOR A QUIET BUT NEIGHBORLY LOCATION...DON\'T MISS THIS ONE!!THIS HOME BOASTS W/ FAMILY AMENITIES OR AN ENTERTAINING HOME W/FRIENDS. KIDS CAN HAVE A FAMILY ROOM AT ONE END OF THE HOUSE LOOKING OVER THE POOL WHILE ADULTS CAN PLAY BRIDGE WITH THE BACKDROP OF THE OVERSIZED PRIVATE POOL.AN AMAZING FLOOR PLAN W/4 BATHROOMS, OVERSIZED KITCHEN(almost double the size of most kitchens.)\r\nKITCHEN IS ADJACENT TO THE GAME ROOM-FIREPLACE-ABUNDANCE OF BUILT-INS-DOUBLE CLOSET FOR THE WINTER JACKETS, SPORTS ITEMS,ETC.THE UPDATES...ARE TASTEFULLY DONE W/UNIQUE FEATURES..NO CARPET ON FIRST FLOOR.SELLER SAYS NO FLOODING.MOST OF THE HOUSE HAS PELLA EFFICIENT WINDOWS, 2 YEAR OLD ROOF, 2018 FENCE, $12K HI EFFICIENT PATIO DOOR.LG POOL.call re carpet allowance.' ,`Acres` = '0.2376' ,`Area` = '7' ,`BuilderName` = 'KUSTOM KASTLE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 87 BROOK FOREST SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '10350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Brook Forest Sec 01 R/P' ,`TaxAmount` = '9391' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021290' WHERE `Matrix_Unique_ID` = '214099774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:59:45.587' ,`MLSNumber` = '88579179' ,`ListAgentFullName` = 'Huy Dinh' ,`ListOfficeName` = 'The Taylor Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988282' ,`Longitude` = '-95.629402' ,`PhotoCount` = '25' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Privet' ,`StreetNumber` = '13110' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Lakewood Glen! You will start to notice the details before even walking inside from the attractive curb appeal with gorgeous landscaping. A formal entry invites you into an enchanting world of style and luxury where upscale flooring, ornate crown molding and many windows clad in plantation shutters infuse the home in timeless elegance. Unleash your cooking skills in the gourmet kitchen prepared with gleaming granite counters and custom cabinets with direct access into both the formal dining room and breakfast nook. The sophisticated living room will enchant with its custom shelving, gas log fireplace and soaring ceiling heights. Find your relaxation in the massive primary suite with bath offering double sinks, shower and separate soaking tub. The outdoor space continues to excite with spacious flagstone patio and fenced-in landscaped yard. Coming home is always a breeze with the detached garage. Call today to tour your forever home!' ,`Acres` = '0.2032' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 LAKEWOOD GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Glen' ,`TaxAmount` = '6747' ,`TaxRate` = '2.5217' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021290' WHERE `Matrix_Unique_ID` = '214109537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:09:50.183' ,`MLSNumber` = '4763655' ,`ListAgentFullName` = 'Wayne Ngo' ,`ListOfficeName` = 'The Nguyens & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.430758' ,`Longitude` = '-95.438534' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Olancha' ,`StreetNumber` = '2425' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2019 Built New House in the beautiful Sierra Visa Subdivision. New appliances include dish washer and cooktop/oven. Don\'t miss your chance on this wonderful property. Call today for your private showing!' ,`Acres` = '0.1377' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 4A (A0288 HT&BRR) BLK 1 LOT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sierra Vista Sec 4a' ,`TaxAmount` = '10875' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021291' WHERE `Matrix_Unique_ID` = '214109853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:37:36.953' ,`MLSNumber` = '10236553' ,`ListAgentFullName` = 'Joann Cardona' ,`ListOfficeName` = 'Evolve Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.104326' ,`Longitude` = '-95.544241' ,`PhotoCount` = '9' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Youpon' ,`StreetNumber` = '23615' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY RENOVATED!! Contemporary floor through out home, new fencing for extra privacy, fresh paint. A MUST SEE! Stunning gardening wraps home. Ready for Move-in! ONLY 40.00/YEARLY HOA FEE. Home sits on a private cul-de-sac on 2 lots! Nearly an Acre! Never flooded! Down the street from The Woodlands yet close to 99. Easy access to IAH Airport. Excellent School district! Underground Pool in your backyard oasis awaits!\nUnlimited free drinkable water from your very own water well! Contact listing agent for a private tour today! ' ,`Acres` = '0.88' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 CREEKWOOD ACRES U/R' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '38221' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Creekwood Acres U/R' ,`TaxAmount` = '4175' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021291' WHERE `Matrix_Unique_ID` = '214125518' --> 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','214130783','1667021291','214130783','2022-10-28T22:56:07.030','69224986','Michael Knowles','Keller Williams Realty - Memorial','','','29.577670','-95.423005','50','77584','10','315000.00','Active','Rippling Creek','13108','Lane','Pearland','2','1','3','2147','Single-Family','This home with 3 Bedroom with 2.5 Baths is amazing and recently upgraded. Luxury Vinyl flooring downstairs in November 2021, and a New carpet upstairs in October 2022. With formal dining, large living room, island kitchen, huge backyard, and a spacious game room upstairs! Zoned to Alvin schools and easy access to the Texas Medical Center. This property you wouldn\'t want to miss! CALL NOW!','0.1376','5','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Pearland','Central Gas','1','SHADOW CREEK RANCH SF-31 (PEARLAND), BLOCK 3, LOT 21','Subdivision Lot','5994','Appraisal District','','999','0','','2','Freestanding Oven','0','','','Gas Range','','Composition','3 - Alvin','WILDER ELEMENTARY SCHOOL','SHADOW CREEK HIGH SCHOOL','NOLAN RYAN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Shadow Creek Ranch Sf1-Sf2-Sf3','8616','3.5409','Water District','2005','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','214143782','1667021291','214143782','2022-10-28T23:40:27.520','38683611','Joel Rankin','J.D. Rankin and Associates ','','','29.621095','-95.015534','1','77571','7','179900.00','Active','Seagrove','608','Street','Shoreacres','3','0','4','1632','Single-Family','Charming 4 bedroom 3 bath home with 2 car attached garage. Located in the water front community of Shoreacres, the property has great access to Laporte, the Kemah Entertainment District and NASA, The home features an open living room/dining combo with multiple windows for natural lighting, French doors that open to the front porch in the living/dining room and from the primary bedroom. Beautiful backyard perfect for entertaining.','0.2984','7','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Shoreacres/La Porte','Central Electric','0','LT 12 BLK 28 SHOREACRES','Subdivision Lot','13000','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','35 - La Porte','BAYSHORE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required','Appraisal District','1','Traditional','Shoreacres','5346','2.8597','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T23:00:56.457' ,`MLSNumber` = '89627900' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.072634' ,`Longitude` = '-95.125010' ,`PhotoCount` = '45' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '739900.00' ,`Status` = 'Active' ,`StreetName` = 'Buccaneer' ,`StreetNumber` = '13002' ,`StreetSuffix` = 'Parkway' ,`City` = 'Freeport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful beach and bay views from this 4bd/3ba home resting on a palm treed landscape corner lot. Enter the home from the beach view deck into the open living room w/ vaulted ceiling with kitchen and den visibility. Spacious kitchen (see if you can find the hidden spice rack), with a dining room that sits 10+ for entertaining and family gatherings. 2 bedrooms, a full bath and laundry area are located behind the kitchen/dining. The TWO living areas are encased in blind covered windows and multiple access points to deck. The primary bedroom has closet and en-suite with deck access to enjoy the sunset. Want a bunkroom or a private retreat? \r\nThe spiral staircase leads to a bedroom w/en-suite, which is currently home to 4 bunkbeds & children play area. \r\nSchedule your Signature Property Treasure Island Home Tour today and see why this is a busy rental and a popular home for family fun.' ,`Acres` = '0.2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND (A0029 S F AUSTIN) BLK 10 LOT 1 ACRES .2' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '10023' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021291' WHERE `Matrix_Unique_ID` = '214152645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T22:19:20.123' ,`MLSNumber` = '25372914' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.960202' ,`Longitude` = '-95.295325' ,`PhotoCount` = '37' ,`PostalCode` = '77541' ,`RoomCount` = '2' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Tarpon' ,`StreetNumber` = '34' ,`StreetSuffix` = 'Lane' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Canal Front Home with Boat Lift and Easy Access to Open Water. Currently 3 boats call 34 Tarpon home. The home rest on concrete pilings, with multiple decks, golf cart storage, wide driveway to park your outdoor toys/trailers. Concrete pad makes for quiet relaxation after a fun day of boating. Enter this open floor plan home with open kitchen and living room with natural light with bedrooms located on the right side of the home. A sliding glass doors leads to the front deck from bedroom 1 and 2nd bedroom sleeps 9+ with 2 sets of bunk beds and an additional full/queen bed and still has space for dressers. The HVAC system was recently installed, Metal Roof, and home is being sold furnished. Take a Signature Property Home Tour and see if your boat will be happy at 34 Tarpon.' ,`Acres` = '0.1489' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIDGE HARBOR (A0051 DIV 8 (B C I C)) (FREEPORT) LOT 33 (N/2' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6486' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Bridge Harbor' ,`TaxAmount` = '8385' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667021291' WHERE `Matrix_Unique_ID` = '214166937' --> 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','214196795','1667021292','214196795','2022-10-28T22:31:41.630','80763647','Ashley Alexander','Nextgen Real Estate Properties','','','29.867921','-95.368896','19','77076','3','215000.00','Active','Mcgallion','11513','Road','Houston','1','0','3','1194','Single-Family','Welcome to your new home! This is the perfect starter home, ready for move in when you are. Location is a huge bonus being less than a minute away from the Hardy Toll Way, and less than 5 minutes from both I45 & I59. Let\'s talk about the amazing interior with a modern finish, and the exterior being the entertainers dream! Covered patios in the front and back of the home, along with a one car detached garage in the backyard. There are many possibilities here by either converting the garage to a garage apartment or adding to the home, remember no HOA means no asking for permission. Roof is roughly 12 years old, HVAC system is roughly 5 years old.','0.1779','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','0','','0','Northwest Houston','Central Electric,Central Gas','0','LT 1133 BLK 60 HAWTHORNE PLACE SEC 9','Other','7750','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','BARRICK ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','PATRICK HENRY MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Hawthorne Place Sec 09','1984','2.3307','Public Sewer,Public Water','1950','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','214197445','1667021292','214197445','2022-10-28T22:06:29.773','65025770','Karla Arjona','Coldwell Banker Realty','','','29.679320','-95.718327','30','77407','6','305000.00','Active','Desert Calico','19206','Lane','Richmond','2','0','4','1828','Single-Family','CLEAN AND WELL KEPT, COZY ONE STORY home with an amazing LOCATION. TILE FLOORS throughout (all the same). SELLERS aded a BEAUTIFUL, GOOD SIZE COVERED PATIO and you still have room to play or grow in the backyard. KITCHEN HAS GRANITE COUNTER TOPS. FORMAL DINING ROOM. 4 BEDROOMS AND 2 BATHS. ROOF REPLACED IN 2018. SELLER UPGRADED SECONDARY BATHROOM, NO TUB. WATER HEATER has been placed. Easy access to WEST PARK TOLL, GRAND PARKWAY. CLOSE TO SHOPPING AND ENTERTAINING. ZONED TO FBISD SCHOOLS.','0.1253','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Fort Bend County North/Richmond','Central Electric','1','BRADFORD PARK SEC 1, BLOCK 6, LOT 2','Subdivision Lot','5456','Appraisal District','','350','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','PATTERSON ELEMENTARY SCHOOL (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','1','Traditional','Bradford Park Sec 1','4567','2.3529','Public Water,Water District','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214197496','1667021292','214197496','2022-10-28T23:12:38.213','96505899','Jordan Schilleci','Jo & Co. Realty Group','','','30.362053','-95.387825','36','77303','11','451546.00','Active','Hazel Lake Drive','6134','','Conroe','3','0','5','2431','Single-Family','You have just found your dream home. This two-story, 5 bedroom, 3 bathroom home sits on almost half an acre while backing up to a small lake reserve with breathtaking views in the new community of Deer Trail Estates. This new construction home was built by Alta Homes with designer upgrades which include granite countertops and shaker-style kitchen cabinets. On the first floor of this home, you will the primary bedroom with ensuite bathroom, a study (or first-floor flex-space), a mother-in-law suite (additional full bedroom and bathroom) a formal dining room, a breakfast room, an over-sized kitchen, and a wood-burning fireplace. 2nd floor: an enclosed game room and two bedrooms + bathroom. With soaring ceilings up to 17 feet high, this is a luxurious home with plenty of room to grow! This home is ready for move-in ready! The builder is currently offering $14,500 in incentives for you to use how you like (closing cost credit or interest rate buy-down). LOW TAXES! Call or stop by today!','0.41','19','Alta Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Wood Burning Fireplace','1','Conroe Northeast','Central Electric','1','Lot 15 Blk 1','Greenbelt,Subdivision Lot,Water View,Waterfront,Wooded','18000','Survey','','','1','Never Lived In','2','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','PATTERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Lockbox Front','Builder','2','Contemporary/Modern,Craftsman,Traditional','Deer Trails Estates','','1.91','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214197661','1667021292','214197661','2022-10-28T23:23:19.897','14413286','Claudia Cooper','City Group','','','29.946264','-95.243797','28','77396','11','329999.00','Active','Clanton Pines','9723','Drive','Humble','3','0','4','2756','Single-Family','Simply GORGEOUS!! One of CastleRocks most prettiest Floor-plans located in the gated community of Canyon Gate at Park Lake. Your new 1 1/2 Story home features a GOURMET Kitchen with GRANITE counters, 42” Upper Cabinets, large pantry, tile floors, and stainless undermount sink. The open floor plan is perfect for entertaining as you have a California sweeping stairway that leads up to a HUGE Game-room that comes with a private en-suite. You will love the large primary bedroom suite that comes equipped with a LARGE walk-in closet, two vanities, garden tub with sitting bench and stand up shower. The secondary and third bedrooms are both very nice size. Covered patio with good size backyard! Amenities include community pool, splash pad, basketball courts, playground, and walking trails around the community lake. Conveniently located near Beltway 8, 59, IAH. Theaters, dining, and lots of shopping nearby! Don’t let this one get away! Schedule your private tour TODAY!','0.1458','1','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Humble Area East','Central Gas,Zoned','1','LT 32 BLK 7 CANYON GATE AT PARK LAKES SEC 16','Subdivision Lot','6351','Appraisal District','','1200','0','','2','Gas Oven','0','','','Electric Range','','Composition','29 - Humble','PARK LAKES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required','Appraisal District','1.5','Traditional','Canyon Gate/Pk Lakes Sec 16','7868','2.9873','Water District','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214197920','1667021292','214197920','2022-10-28T23:01:35.360','93556019','Leticia Balderrama','RE/MAX ONE - Premier','','','29.946327','-95.126538','7','77532','8','399999.00','Active','Deep Anchor','2723','Way','Crosby','2','0','4','2375','Single-Family','Beautiful custom home with upgrades galore with four bedrooms, formal dining room and a three car garage. This spacious home will greet you with a open foyer as you open the door and high ceilings as you walk to the formal dining and huge living room. The living room is open to the kitchen. The kitchen has a large custom island, stainless steel appliances, farmhouse sink, upgraded light fixtures and lots of cabinets for storage that will also include a built in oven and microwave. The primary bedroom is nestled in the back of the home for quietness and privacy. The primary bathroom features a claw tub, separate walk in shower and double vanities. All of the closets have built in shelves for extra space. Call and schedule your private showing today.','0.1928','1','Private','','Electric Dryer Connections','','Mud','1','Wood Burning Fireplace','1','Crosby Area','Central Electric','1','LT 11 BLK 6 LAKE SHADOWS SEC 5','Cleared','8400','Appraisal District','','50','1','To Be Built/Under Construction','','Electric Oven','0','','','Electric Cooktop','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Builder','1','Traditional','Lake Shadows Sec 05','676','2.6843','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214198087','1667021292','214198087','2022-10-28T23:54:46.713','92850769','Jordan Schilleci','Jo & Co. Realty Group','','','30.362720','-95.387631','27','77303','10','388790.00','Active','Hazel Lake Drive','6130','','Conroe','2','1','4','1968','Single-Family','You have just found your dream home. This one-story, 4 bedroom, 2.5 bathroom, 3 car garage home sits on almost half an acre while backing up to a 20-acre lake reserve with breathtaking views in the new community of Deer Trail Estates. This new construction home was built by Alta Homes with designer upgrades which include granite countertops, beautiful subway tile backsplash, tray ceilings with crown molding in the large open entry, luxury vinyl floor planking, and shaker-style kitchen cabinets. The kitchen, breakfast room, living room, and primary bedroom all overlook the backyard and lake. This home is ready for move-in ready! The builder is currently offering $14,500 in incentives for you to use how you like (closing cost credit or interest rate buy-down). LOW TAXES! Call or stop by today!','0.37','19','Alta Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Northeast','Central Electric','1','Lot 16 Block 1 Section 3','Water View,Waterfront','16000','Survey','','485','1','Never Lived In','3','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','PATTERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Contemporary/Modern,Craftsman,Ranch,Traditional','Deer Trails Estates','','','Other Water/Sewer','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214198199','1667021292','214198199','2022-10-28T23:51:48.190','51944020','Nanqing Zeng','eXp Realty, LLC','','','29.635370','-95.468414','24','77085','4','285000.00','Active','Tiger Lilly','5631','Way','Houston','2','1','4','1728','Single-Family','Welcome to this immaculate 1-story open floor home that is recently remodeled. Low HOA. Below is a list of the recent upgrades.\r\nExterior\r\n•Freshly painted exterior \r\n•Brand new HVAC system \r\nInterior\r\n•Entire house (i.e., ceiling, walls, doors, trims, and baseboards) is freshly painted\r\n•Brand new water heater installed\r\n•Brand new wood-looking tile throughout the entire 1st floor and 2nd floor bathroom.\r\n•Brand new carpet on the stairways and bedrooms. \r\n•Brand new kitchen (i.e., white cabinets (newly painted), granite countertops, stylish backsplash, undermount sink, and commercial grade faucet). \r\n•Brand new stainless-steel appliances, including microwave, dishwasher, range, and disposal. \r\n•Brand new bathrooms (i.e., newly painted vanities, granite countertops, toilets, faucets, and shower fixtures). \r\n•All light fixtures, hardware (e.g., doorknobs, cabinet handles, etc.) and plumbing fixtures are brand new. \r\n•Brand new 5.5 inches baseboard throughout the first floor.','0.1033','20','','','','','Sellers Disclosure','','','','Five Corners','Central Gas','1','LT 17 BLK 6 POST OAK PLACE SEC 4','Other','4500','Appraisal District','','275','0','','2','','0','','','','','Composition','27 - Houston','HINES-CALDWELL ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Post Oak Place Sec 04','4387','2.3307','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214198514','1667021292','214198514','2022-10-28T23:45:13.823','71938745','Hoa Cung','B & W Realty Group LLC','','','29.737362','-95.336049','29','77023','2','248000.00','Active','Bell','4333','Street','Houston','1','0','2','1120','Single-Family','Location!Location!Location! Historic 2/1 front porch home. Seller is unwilling to make repairs, Total remodel needed. Lots of potential in this downtown Houston community.','0.1458','4','','','','','Sellers Disclosure','','','','East End Revitalized','Central Gas','0','LT 14 BLK 52 EASTWOOD','Other','6350','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','LANTRIP ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','Eastwood','5450','2.3307','Public Sewer,Public Water','1936','Appraisal District'); --> New record created successfully