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` = '2023-02-01T09:33:56.150' ,`MLSNumber` = '67704742' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401106' ,`Longitude` = '-95.060799' ,`PhotoCount` = '21' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '353990.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Mallard' ,`StreetNumber` = '13517' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Spacious 3 bedroom home with beautiful brick elevation. The Covered Front Porch with 8’ Mahogany front door opens to a Study and large Kitchen/Family Room. This stunning Kitchen has Stainless Steel Whirlpool Kitchen appliances, 42\" upgraded cabinets with upgraded granite countertops complimented with a white subway tile backsplash. There is upgraded wood flooring throughout Entry, Study, Kitchen, Family Room, and Utility. The Owner\'s Bath has a garden tub with separate shower and two sinks. Enjoy your Covered Back Patio privately with NO BACK NEIGHBORS. Schedule your tour now! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5/2/24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5927' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347587' WHERE `Matrix_Unique_ID` = '196221049' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:52:07.263' ,`MLSNumber` = '46407758' ,`ListAgentFullName` = 'Diane Kink' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.185752' ,`Longitude` = '-95.546613' ,`PhotoCount` = '19' ,`PostalCode` = '77382' ,`RoomCount` = '9' ,`ListPrice` = '2450000.00' ,`Status` = 'Active' ,`StreetName` = 'Bunnelle' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Way' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Discover your dream home and enjoy resort-style living in a tranquil setting located behind the private gates of Carlton Woods. Underway by Novi Home Builders Corp, this outstanding custom home builder offers another luxury single-family residence with an ideal location, exceptional resort-style amenities, beautiful scenery, and highly rated Montgomery County Public and Private Schools. Clean lines, and contemporary/modern elements throughout. Two bedrooms down, three up all en suite baths. Spend an afternoon playing a round of golf on the Jack Nicklaus golf course or enjoy dinner at the club on the patio overlooking the green. Amenities include tennis, swimming, a workout center, walking trails, and much more! For a tour and glimpse of this beautiful custom home-to-be, don\'t forget to view the video!' ,`Acres` = '0.2888' ,`Area` = '15' ,`BuilderName` = 'Novi Home Builders' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL OF CARLTON WOODS 05, BLOCK 1, LOT 28' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '12579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wdlnds Village Of Carlton Woods' ,`TaxAmount` = '2709' ,`TaxRate` = '2.2431' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347587' WHERE `Matrix_Unique_ID` = '202119298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:33:12.033' ,`MLSNumber` = '20597112' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914890' ,`Longitude` = '-95.697077' ,`PhotoCount` = '24' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering Bald Cypress' ,`StreetNumber` = '9414' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CALDWELL HOMES NEW CONSTRUCTION - Welcome home to 9414 Whispering Bald Cypress Court! For those 55 and better, The Heritage at Towne Lake is an exclusive enclave built for active adults – with the emphasis on active This gorgeous home will feature 3 bedrooms, 2 full baths, 1 half bath and an attached 2 car garage. The open concept living room and kitchen makes for a great way to keep the party going and never miss a beat. Caldwell Homes provides an elevated quality of construction and energy efficiency that aids in the reduction of home energy expenses including spray foam insulation. Amenities in Towne Lake include a stunning 300 acre lake with boat taxi as well as the Lodge Center abuzz with activity from sun-up, to well into the night. Don\'t miss out on this last Heritage opportunity in Towne Lake. Check out the 3D tour and call to schedule your showing today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Caldwell Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Heritage Cove at Towne Lake Sec 60, Lot 43, Bock 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347588' WHERE `Matrix_Unique_ID` = '202686197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:42:46.193' ,`MLSNumber` = '31669040' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.202339' ,`Longitude` = '-96.020209' ,`PhotoCount` = '25' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '297477.00' ,`Status` = 'Active' ,`StreetName` = 'Callie' ,`StreetNumber` = '26863' ,`StreetSuffix` = 'Drive' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW, one story, 3 bedroom, 2 bath, 1,572 square foot home on A QUARTER ACRE LOT! This home features an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. Large windows for abundant natural light throughout. 3 car garage & extended covered porch. Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living.' ,`Acres` = '0.2238' ,`Area` = '26' ,`BuilderName` = 'Freedom Star' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S455200 DEERWOOD LAKES 2 LOT 164' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Deerwood Lakes 2' ,`TaxAmount` = '286' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675347588' WHERE `Matrix_Unique_ID` = '206499402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:39:20.713' ,`MLSNumber` = '66680753' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515612' ,`Longitude` = '-95.800468' ,`PhotoCount` = '17' ,`PostalCode` = '77469' ,`RoomCount` = '5' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Seabourne Landing' ,`StreetNumber` = '4423' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new community with modern farmhouse designs near the Fort Bend County Fair Grounds with large homesites conveniently located just minutes away from Seabourne County Park, Hwy. 36, and Hwy. 59. Abundant shopping is just minutes away in nearby downtown Rosenberg and Richmond. One-story | 3 bedrooms | 2 baths | Study | 2-car attached garage | covered patio.\r\nPlans, Prices & Features are subject to change w/o notice. Square Footage estimates are approximate. The home is under construction, as such, photos are REPRESENTATIVE and NOT of the actual home. For more info, contact Chesmar Homes in Seabourne Landing. AUGUST 2022 estimated completion.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Seabourne Landing Sec 2, BLOCK 1, Lot 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seabourne Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.94' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347588' WHERE `Matrix_Unique_ID` = '207260647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:33:36.603' ,`MLSNumber` = '52774302' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952682' ,`Longitude` = '-95.189908' ,`PhotoCount` = '22' ,`PostalCode` = '77396' ,`RoomCount` = '7' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Moorlands Hills' ,`StreetNumber` = '13119' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - This beautiful 2-Story home is the Brenham featuring 3 Bedrooms, 2.5 Baths, and an open-concept layout. There are 8’ interior doors throughout, vinyl flooring at the common areas, and stainless-steel appliances in kitchen. The primary bath has a separate tub and shower. This home features the stunning interior Harmony Essential collection. Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Balmoral Section 26, Block 5, Lot 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347588' WHERE `Matrix_Unique_ID` = '207400612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:33:50.083' ,`MLSNumber` = '22981157' ,`ListAgentFullName` = 'Michael Parker' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538548' ,`Longitude` = '-95.085890' ,`PhotoCount` = '43' ,`PostalCode` = '77058' ,`RoomCount` = '9' ,`ListPrice` = '538000.00' ,`Status` = 'Active' ,`StreetName` = 'Upper Bay' ,`StreetNumber` = '18706' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to wonderfully unique 18706 Upper Bay! This elevated home features a gorgeous water view! The custom kitchen is designed for the chef in mind with professional appliances, oversized stove with 2 ovens, 5 burner stove, vent hood to match. Tons of kitchen storage, built-in spice racks and pull out shelves. Granite countertops, , island, and soft closing cabinets and drawers. 4 bdrms plus a well-lit sunroom/ game room w/ skylights that looks out to patio deck & overlooks the beautiful pool & backyard. Cozy master bath includes his & hers sinks. All windows are Low-E tinted w/ lifetime warranty. Imagine the possibilities with 3000 feet paved and enclosed garages with 3 double garage doors w/ openers and 5 passage doors. Many updates include, new roof June/2022 50-year shingles with 7-year manufactures certificate, plumbing and electrical. Zoned to highly recommended CCISD! Minutes away from Johnson Space Center, Kemah Boardwalk, walking trails, dog parks & so much more!' ,`Acres` = '0.2204' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3O NASSAU BAY SEC 8' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nassau Bay Sec 08' ,`TaxAmount` = '8737' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347589' WHERE `Matrix_Unique_ID` = '209172547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:59:27.467' ,`MLSNumber` = '93770624' ,`ListAgentFullName` = 'Cody Horn' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.285306' ,`Longitude` = '-95.147977' ,`PhotoCount` = '21' ,`PostalCode` = '77328' ,`RoomCount` = '10' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn' ,`StreetNumber` = '10859' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this 3 bedroom 2 bath home on a high and dry 1.25 acres in Montgomery County. It has not been lived in long and is ready for a new owner. Not far from Hwy 59 for easy access to Houston. Come take a look before its gone.' ,`Acres` = '1.25' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S516801 - Fostoria Woods, Lot 5, SERIAL BEL014765TX, LABEL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '54450' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fostoria Woods' ,`TaxAmount` = '1031' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675347589' WHERE `Matrix_Unique_ID` = '209545651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:52:37.027' ,`MLSNumber` = '32044280' ,`ListAgentFullName` = 'Lorannette Lewis' ,`ListOfficeName` = 'In Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808763' ,`Longitude` = '-95.408765' ,`PhotoCount` = '31' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '669900.00' ,`Status` = 'Active' ,`StreetName` = '25th' ,`StreetNumber` = '627' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Sandcastle Homes, the Bordeaux floor plan features a spacious living and dining area, with large windows filling up the home with tons of natural light! The kitchen is highlighted by the quartz countertops, custom cabinets, and stainless-steel appliances. \r\n\r\nAll of the bedrooms are located on the second floor with large walk-in closets. The Primary Bedroom features a spa-like bath with a large shower and separate tub. The Bordeaux\'s large game room makes for the perfect flex space and provides plenty of storage with its built-in shelves. Come home and park in your attached 2-car garage or in your private driveway! \r\n\r\nThis home is Move In Ready!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Sandcastle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2, Blk 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3275' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347589' WHERE `Matrix_Unique_ID` = '209911960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:43:28.607' ,`MLSNumber` = '9888079' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.440415' ,`Longitude` = '-95.383805' ,`PhotoCount` = '50' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Starry Night' ,`StreetNumber` = '9906' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the built-in luxuries and limitless interior design potential of the open and bright Laport new home plan. Your open-concept living spaces features an abundance of energy-efficient windows, soaring ceilings, and the versatility to adapt to your decorative style. The gourmet kitchen is designed to support culinary masterpieces and collaborative cooking adventures and includes a dine-in island. Each upstairs bedroom offers walk-in closets and plenty of room to grow and personalize. Create the perfect specialty rooms for your family in the deluxe upstairs retreat and the brilliant downstairs study. Retire to your luxury Owner’s Retreat, which provides, a glamorous bathroom and an extended walk-in closet. The downstairs guest suite includes a private bathroom, making it the ideal arrangement for visitors and extra residents. Innovative EnergySaver™ features enhance each day in this spectacular new home plan. Ask us about our Air Conditioned Attics!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Block 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347589' WHERE `Matrix_Unique_ID` = '209948149' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:08:11.500' ,`MLSNumber` = '31240162' ,`ListAgentFullName` = 'Blythe Palamara' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994341' ,`Longitude` = '-95.517531' ,`PhotoCount` = '41' ,`PostalCode` = '77069' ,`RoomCount` = '15' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Westerham' ,`StreetNumber` = '5207' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5 or 6 bedroom home with 4.5 bathrooms is sure to entice. Located on a cul-de-sac, this Old Southern charmer offers multitudes of Luxuries + conveniences throughout its more than 5,000 square feet. With formal living and dining rooms, family room, private study, dreamy kitchen + breakfast room, game room, the largest laundry room you\'ve ever seen, two staircases, and outdoor kitchen + Spa, this home ensures ease of daily living and gracious hospitality for guests. The enormous upstairs flex room perfect for homeschooling, crafts, man cave, oversized 6th bedroom or extra office. Control4 smart home Automation system in place. Custom draperies throughout. Lovingly maintained and enhanced by its owners, this very special home is ready for you to call it yours! House was repiped (2021), Roof replaced (2019), Windows replaced. Replaced downstairs HVAC 2022, others 2019 - 2021. Mosquito misting, Gated driveway and so much more.' ,`Acres` = '0.2227' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 HUNTWICK FOREST SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '157' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest' ,`TaxAmount` = '7483' ,`TaxRate` = '2.3915' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347590' WHERE `Matrix_Unique_ID` = '210218204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:03:08.447' ,`MLSNumber` = '43838337' ,`ListAgentFullName` = 'Beth Crutcher' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.127177' ,`Longitude` = '-95.647557' ,`PhotoCount` = '22' ,`PostalCode` = '77486' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Columbia Drive' ,`StreetNumber` = '1513' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2641' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated seller!! All this home needs is some TLC and yard work. This large home offers 4 bedrooms, 3 baths, a family room, dining room, sunroom/gameroom or extra den with double French doors that overlook the beautiful back yard (almost an acre). 2 bedrooms are located on one side of the home with the other 2 bedrooms located on the other side of the sunroom with a Hollywood bathroom and an additional room for a study or 5th bedroom. The kitchen offers stainless steel appliances, a 6 burner gas stove, double oven, Corian countertops and an embossed copper farmhouse sink. Primary bath boast a tiled walk in shower. Tub/shower combo in one bathroom and walk in shower in the Hollywood bath. Two A/C units and water heater replaced in 2017. This home has so much to offer! Home is being sold \"AS-IS\"' ,`Acres` = '0.9441' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Pre-Foreclosure,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'DANCE EAST (A0040 J H BELL DIV 1) LOT 9A-10 TR 2B (WEST COLU' ,`LotDesciption` = 'Cleared' ,`LotSize` = '41125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dance East' ,`TaxAmount` = '5357' ,`TaxRate` = '2.4263' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347590' WHERE `Matrix_Unique_ID` = '210882123' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:13:04.587' ,`MLSNumber` = '39941361' ,`ListAgentFullName` = 'Elizabeth Boles' ,`ListOfficeName` = 'One10 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.448702' ,`Longitude` = '-94.652980' ,`PhotoCount` = '35' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '367720.00' ,`Status` = 'Active' ,`StreetName` = 'Sandollar' ,`StreetNumber` = '970' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy this Crystal Beach home, with less than a 10-minute walk to sandy toes. Friends and family will enjoy the Coastal Community with a laid back atmosphere. The home has open floorplan, kitchen is open to living area, 2 bedrooms, and bath. Builder that remodeled home can turn into a 3 bedroom if buyer prefers. Feel the gulf breeze on the southern-facing deck. Although this home was built in 1972 the interior has lots of improvements including completely updated kitchen, bathrooms, flooring, and paint.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 56 CLOON SUB #4' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cloon Sub 4' ,`TaxAmount` = '2513' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347590' WHERE `Matrix_Unique_ID` = '211606736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:46:13.463' ,`MLSNumber` = '44581346' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.597719' ,`Longitude` = '-95.805671' ,`PhotoCount` = '23' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '520705.00' ,`Status` = 'Active' ,`StreetName` = 'Mason' ,`StreetNumber` = '6019' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story Leo home design features 6 bedrooms, 4 baths and 2 car attached garage. Open dining room off hall. Beautiful maple cabinets, quartz countertops and farmhouse sink in gourmet kitchen. Two bedrooms, including owner\'s suite, located downstairs. Huge walk-in closet, double sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a loft space and 4 secondary bedrooms. Covered patio in backyard, perfect for entertaining. \r\nEnjoy the convenience of the community\'s Recreation Center, Lakes and Parks. Kingdom Heights in Rosenberg is conveniently located between Sugar Land and Katy/Fulshear with easy access to the major Highway 99 (Grand Pkwy). Offered by: K. Hovnanian of Houston II, L.L.C' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '10/4/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347590' WHERE `Matrix_Unique_ID` = '211819392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:45:45.727' ,`MLSNumber` = '74404297' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.598419' ,`Longitude` = '-95.805102' ,`PhotoCount` = '23' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '514153.00' ,`Status` = 'Active' ,`StreetName` = 'Mason' ,`StreetNumber` = '6002' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3211' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story Leo home design features 5 bedrooms, 4 baths and 2 car attached garage. Open dining room off hall. Beautiful maple cabinets and granite countertops in gourmet kitchen. Two bedrooms, including owner\'s suite, located downstairs. Huge walk-in closet, double sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a loft space, media room and 3 secondary bedrooms. Covered patio in backyard, perfect for entertaining. \r\nEnjoy the convenience of the community\'s Recreation Center, Lakes and Parks. Kingdom Heights in Rosenberg is conveniently located between Sugar Land and Katy/Fulshear with easy access to the major Highway 99 (Grand Pkwy). Offered by: K. Hovnanian of Houston II, L.L.C' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5/5/6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8164' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347591' WHERE `Matrix_Unique_ID` = '211825045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:11:00.503' ,`MLSNumber` = '34323698' ,`ListAgentFullName` = 'Pinky Pirani' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602542' ,`Longitude` = '-95.671000' ,`PhotoCount` = '44' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Pendelton Place' ,`StreetNumber` = '5930' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on an oversized corner lot, find this beautifully maintained 2-story home w/ lovely brick elevation for sale in Wilkins Crossing.Upon entering, you’ll be greeted by a cozy living room with dramatic wood flooring expanding to the dining room.This glides right into the kitchen which includes appliances such as gourmet food warmer and disappearing downdraft exhaust by Wolf.An entertainer’s delight,the heart of the home features a family room which boasts high ceiling w/ chandelier, and an upgraded fireplace.The 1st-floor primary suite hosts a master bath w/ a separate modern freestanding soaker tub and shower.Making your way up,find a game room w/built-in shelves and 3 more bedrooms w/ special fans.Carpet is brand new.Custom wall paint,multi-generation capable,high-end fixtures by Kichler,and crown molding in the entire house.Backyard includes lush landscaping w/ automatic app-controlled sprinkler system.Highly rated and desirable Fort Bend Schools,easy access to Hwy 90 & 99.' ,`Acres` = '0.2048' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WILKINS CROSSING SEC 1, BLOCK 3, LOT 13' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8919' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilkins Crossing Sec 1' ,`TaxAmount` = '7762' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347591' WHERE `Matrix_Unique_ID` = '211866516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:41:44.027' ,`MLSNumber` = '96831290' ,`ListAgentFullName` = 'Vicky Walberg' ,`ListOfficeName` = 'Michele Kimmons Properties,LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.936143' ,`Longitude` = '-96.065913' ,`PhotoCount` = '43' ,`PostalCode` = '77872' ,`RoomCount` = '9' ,`ListPrice` = '499000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hollis Rd' ,`StreetNumber` = '1380' ,`StreetSuffix` = 'Road' ,`City` = 'North Zulch' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful unrestricted remodeled home on just under 4 acres. Enjoy country living while being a short drive from College Station/Huntsville/Willis/Conroe. Home is bright and open & has luxury laminate flooring. Replaced doors & front windows, new AC, & PEX plumbing. Home has granite countertops, large walk in pantry, & beautiful antique built in cabinet. Fenced w/solar gate, & fiber optic available. A 25x37 outdoor living area is perfect for relaxing & cook-outs. Large insulated 65x48 garage/workshop w/14 ft. garage doors, pot belly stove, sink & plenty of storage. New above ground 24\' round & 52\" deep pool, big oak trees, mature pecan trees, a new peach tree, a 19x32 covered RV pad w/water & sewer & 50 & 30 amp hook-ups available on property. Unfinished upstairs area can be converted for additional living space. This home has it all!!!' ,`Acres` = '3.847' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Zulch Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0013 ARTER CROWNOVER TRACT 96 3.85 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '167575' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '159 - North Zulch' ,`SchoolElementary` = 'NORTH ZULCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH ZULCH HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH ZULCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Arter Crownover League A-13' ,`TaxAmount` = '2746' ,`TaxRate` = '1.7263' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347591' WHERE `Matrix_Unique_ID` = '212031862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:52:09.183' ,`MLSNumber` = '29787941' ,`ListAgentFullName` = 'Rosalinda Frias' ,`ListOfficeName` = 'Manor, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800139' ,`Longitude` = '-95.376531' ,`PhotoCount` = '6' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Walton' ,`StreetNumber` = '1003' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction in the heart of the highly-desired Brooke Smith. This 3,000 square foot home has everything including 4 bedrooms, an office on the first floor, open concept living, master bedroom on the first floor, large game room on the second floor and a large covered patio for outdoor entertaining. Home estimated to be completed January 2023.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Greyden Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 102' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347592' WHERE `Matrix_Unique_ID` = '212103604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:16:11.747' ,`MLSNumber` = '20006993' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443424' ,`Longitude` = '-95.401405' ,`PhotoCount` = '8' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '625531.00' ,`Status` = 'Active' ,`StreetName` = 'Columbus' ,`StreetNumber` = '4611' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 20006993 - Built by Drees Custom Homes - February completion! ~ The Maribelle is a highly desirable one-story plan. The open great room is spacious and bright, and includes a fireplace. The kitchen is a chef\'s dream with a working pantry, plus walk-in pantry and a generous island. The owner\'s suite is a perfect retreat with spa-like bath. This plane includes three secondary bedrooms and a media room, perfect for entertaining.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 28 / Block - 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10578' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347592' WHERE `Matrix_Unique_ID` = '212428035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:50:45.990' ,`MLSNumber` = '63305130' ,`ListAgentFullName` = 'Rosalinda Frias' ,`ListOfficeName` = 'Manor, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787728' ,`Longitude` = '-95.366785' ,`PhotoCount` = '4' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '974900.00' ,`Status` = 'Active' ,`StreetName` = 'Goldenrod' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction in Glen Park zoned to Travis Elementary. This home sits on a 6,000 square foot lot with plenty of outdoor space and a fenced back yard. The office is located on the first floor along with an open kitchen, living, and dining perfect for entertaining. Two bedrooms are located on the second floor adjacent to the game room that can be converted into a fourth bedroom. The master bedroom is privately tucked away on the fist floor with 11 foot ceilings and large ensuite bathroom.' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'Greyden Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 2 & 3A BLK 10 GLEN PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Park' ,`TaxAmount` = '5147' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347592' WHERE `Matrix_Unique_ID` = '212435159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:42:47.860' ,`MLSNumber` = '35443420' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.440611' ,`Longitude` = '-95.383516' ,`PhotoCount` = '33' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Starry Night' ,`StreetNumber` = '9903' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy living at its finest in the impeccable style and refined comfort of The Pinto family home plan. Your inspired Owner’s Retreat provides a peaceful escape from the world with a pamper-ready bathroom and paired walk-in closets. The spacious guest suite and extra bedrooms are the perfect places for personalities to grow and shine. Create your ultimate home office or social lounge in the casual elegance of the study. The epicurean\'s kitchen offers a superior storage, meal prep, and presentation experience. Explore your interior design skills in the glamorous open-concept floor plan that presents a cheerful sunroom and a scenic backyard view. Enjoy a great book and your favorite beverage from the relaxation of your covered patio. Bonus features include a powder room, built-in conveniences, and extra storage space in the 3-car garage. \r\nAsk us about our Air Conditioned Attics!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347592' WHERE `Matrix_Unique_ID` = '212609929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:57:45.057' ,`MLSNumber` = '83392092' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.065174' ,`Longitude` = '-95.721911' ,`PhotoCount` = '18' ,`PostalCode` = '77377' ,`RoomCount` = '14' ,`ListPrice` = '619725.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Dappled Mare' ,`StreetNumber` = '19034' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Your dream home awaits! This gorgeous Beazer home in the desirable Amira community features a brick exterior, luxury vinyl plank flooring, wrought iron spindles, a cast stone fireplace, study with French doors, media room, formal dining room, open great room, and extended covered patio. The lavish kitchen is fully equipped with quartz countertops, Herringbone backsplash, large cove molding, double wall oven, Jasper undermount kitchen sink, stainless steel appliances, wine rack, 42” upper cabinets, dining nook, and pendant lighting. The primary suite boasts a walk-in closet, dual vanities, a tub, and separate shower. Nestled among 100-year-old oak trees are Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Located off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Zoned to the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347593' WHERE `Matrix_Unique_ID` = '212782092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:26:28.413' ,`MLSNumber` = '42074307' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.403429' ,`Longitude` = '-95.504612' ,`PhotoCount` = '46' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '586640.00' ,`Status` = 'Active' ,`StreetName` = 'Starlit Sky' ,`StreetNumber` = '630' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle ambitions with the vibrant and innovative new home in The Woodlands Hills! The Milburn by David Weekley Homes includes Jack-and-Jill bedrooms and a separate front bedroom to offer plenty of personal space for your growing residents and overnight guests. A quiet media room and enclosed front study present unparalleled opportunities to craft the family movie theater and home office you’ve been dreaming of. The streamlined kitchen provides an easy culinary layout for the resident chef with an extended pantry and prep area and a delightful view of the sunny family and dining spaces. Spend quality time together in the shade of your covered Outdoor Living Area. Your blissful Extended Owner’s Retreat offers an everyday escape from the outside world, and includes a spa-inspired en suite bathroom and a luxury walk-in closet. Call to learn more about the stylish upgrades to the kitchen and Owner’s Bath of this new construction home in Willis, Texas!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9078' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347593' WHERE `Matrix_Unique_ID` = '213002247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:06:12.023' ,`MLSNumber` = '65563964' ,`ListAgentFullName` = 'Shannon Hall' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.513920' ,`Longitude` = '-95.090552' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '804' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2291' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is some real Southern Charm for you! Gorgeous home nestled under majestic oaks in historic Old League City on corner lot! Side entry 2 car garage, double driveways and huge covered front porch just waiting for some rocking chairs. Interior features 10\' ceilings with craftsman style trim/moulding, gorgeous hardwood floors in great condition, spacious rooms and vintage touches throughout. Kitchen includes new stainless appliances, granite counters, glass tile backsplash and breakfast area with shiplap walls. Primary bedroom with en suite on the 1st floor features french doors leading out to backyard and another door leading to front deck, perfect area for a bistro set and morning coffee. 2nd floor features game area, storage closets and two spacious bedrooms. 2nd bath includes a clawfoot tub/shower! New AC system and added insulation, never flooded. Additional lot behind the home available for purchase same sellers. Call for price!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 3 PAGE 7,14 & 15 S 90 FT LOTS 7 & 8 (7-1) BLK 15 LEAGUE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional,Victorian' ,`Subdivision` = 'League City Townsite Blk 1-48' ,`TaxAmount` = '4184' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347593' WHERE `Matrix_Unique_ID` = '213130571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:48:05.593' ,`MLSNumber` = '55387075' ,`ListAgentFullName` = 'Victor Burks' ,`ListOfficeName` = 'Buyer First Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538842' ,`Longitude` = '-95.391124' ,`PhotoCount` = '12' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Spindletop' ,`StreetNumber` = '3306' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 1 story home on cul de sac with huge backyard for pool or whatever the buyer desires. Home has 3 full baths and a 4th bedroom with French doors that can be a study/office.' ,`Acres` = '0.3' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHFORK SEC 1A (A0540 A C H & B) BLK 3 LOT 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southfork Sec 1a-1b-1c-2a-2b-2' ,`TaxAmount` = '9070' ,`TaxRate` = '2.8294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347593' WHERE `Matrix_Unique_ID` = '213238001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:19:24.277' ,`MLSNumber` = '72495135' ,`ListAgentFullName` = 'Gregory Thomas' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563036' ,`Longitude` = '-95.432330' ,`PhotoCount` = '32' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Night Song' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The two-story entry opens to a formal dining room currently used as a office while the family room features a soaring 20ft ceiling starting at the front door. The living room includes a wall of windows , corner cast-stone fireplace, granite countertops, and ceramic tile backsplash. Lighting features recessed can lighting and 42inch J-Kraft cabinets. The master bath has a separate shower and garden tub , dual vanities and a walk in closet. Large upstairs game room that overlooks the living room and the entry way. Garage is already set for an electric car charge for 200 amp service ' ,`Acres` = '0.1584' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-51B, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-51b' ,`TaxAmount` = '9266' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347594' WHERE `Matrix_Unique_ID` = '213247246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:09:58.560' ,`MLSNumber` = '73838690' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = 'Jose Soria' ,`SellingOfficeName` = 'Lions Gate Realty' ,`Latitude` = '29.929789' ,`Longitude` = '-95.512482' ,`PhotoCount` = '44' ,`PostalCode` = '77086' ,`RoomCount` = '10' ,`ListPrice` = '314900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Blue Swallow' ,`StreetNumber` = '13431' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled throughout the house. New kitchen with granite countertop with new back splash. fresh paint!. Rooms are big with many windows. No carpet!. All\r\nrooms have laminate and tile floors. EASY access to freeways, malls and shopping. Low taxes and good school district.' ,`Acres` = '0.1203' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 BLUE CREEK SEC 3 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5239' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Blue Creek Sec 03 Amd' ,`TaxAmount` = '5727' ,`TaxRate` = '2.4615' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675347594' WHERE `Matrix_Unique_ID` = '213274916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:19:36.117' ,`MLSNumber` = '32507591' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'M/I Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157098' ,`Longitude` = '-95.162389' ,`PhotoCount` = '33' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Noble Cypress' ,`StreetNumber` = '17619' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Freestone is a stunning 1-story home that boasts 4 bedrooms, 2 full bathrooms, and a 2-car garage.\r\n\r\nThis open-concept home was designed for entertaining and features a high ceiling in the family room. This chef-worthy kitchen showcases an oversized island and a walk-in pantry, and it opens to the family and dining room.\r\n\r\nIf you love to relax outdoors, the upgraded covered patio on the rear exterior will help you achieve your backyard goals. \r\n\r\nThe owner\'s suite is located at the rear of the home to provide optimal privacy. A gorgeous bay window creates the perfect spot for a cozy reading nook or sitting area while letting loads of light fill the bedroom. The spa-like feel is brought home by the deep soaking tub, oversized glass shower, and enclosed toilet area. \r\n\r\nSee how the Freestone floorplan can meet your needs. \r\n\r\nContact us today to schedule a tour and learn more!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'M/I Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 3 Pinewood at Grand Texas Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5672' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood at Grand Texas' ,`TaxAmount` = '' ,`TaxRate` = '3.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347594' WHERE `Matrix_Unique_ID` = '213372380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:47:10.200' ,`MLSNumber` = '89983014' ,`ListAgentFullName` = 'Deanna Boyer' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799177' ,`Longitude` = '-95.466135' ,`PhotoCount` = '45' ,`PostalCode` = '77055' ,`RoomCount` = '11' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'Reverse' ,`StreetNumber` = '1705' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this luxurious, contemporary, new construction home in Westview Terrace. Completed Jan 2023. This 5 bedroom, 4.5 bath home features must see finishes: 8 ft doors, wood floors, custom cabinets, quartz & marble counter tops, beautiful fixtures. As you enter, you are welcomed by a spacious feel with 11 ft ceilings, wide walkways, & bright light from oversized windows. The first floor features a formal dining room, butler\'s pantry, custom kitchen with oversized refrigerator & range with hood vent. The kitchen opens up to a huge living space & breakfast area. The primary bedroom ensuite is a first floor sanctuary that looks out on the the back yard and patio. Relax in your soaker tub or separate spa-like shower, enjoy your two vanity sinks, and walk-in closet with 3-tier clothing racks. Upstairs you will find the additional 4 bedrooms, 3 full bath, a flex room, large game room, & a separate media room. Schedule a showing today!' ,`Acres` = '0.1727' ,`Area` = '24' ,`BuilderName` = 'BHGC, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 26 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7523' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '5969' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347594' WHERE `Matrix_Unique_ID` = '213434942' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:04:27.973' ,`MLSNumber` = '24517130' ,`ListAgentFullName` = 'Sharon Strickland' ,`ListOfficeName` = 'Advantage Asset Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.203960' ,`Longitude` = '-95.535760' ,`PhotoCount` = '39' ,`PostalCode` = '77382' ,`RoomCount` = '12' ,`ListPrice` = '949000.00' ,`Status` = 'Active' ,`StreetName` = 'Argonne' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS/SUMMER 2023 MOVE IN. From the courtyard complete with fountain, to the outdoor oasis of this lovely custom home, located on a premium greenbelt lot, you will find your own piece of paradise. Custom blinds & built ins throughout. Both ACs 2019, H2O Heater 2020, Roof 2016. The gourmet kitchen, sure to please the chef in your life, boasts a walk in pantry, granite countertops & glass front cabinets. Dual sided fireplace graces dining area & den. Formal Living & Dining provide Plenty of room to entertain family & friends. Primary Retreat down. Ensuite bath with jetted tub & stand alone shower. Double Sinks make getting ready for the day a breeze! Upstairs: 3 ample secondary bedrooms, 2 well appointed baths, oversized game room & media room complete with surround sound. 3 Car Garage has epoxy floor & storage closet. The estate grounds offer an outdoor kitchen, covered patio, & heated spa surrounded by lush landscaping & fruit trees. Tenant in Place. Call Agent for Details.' ,`Acres` = '0.3141' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 44, BLOCK 2, LOT 31' ,`LotDesciption` = 'Corner,Greenbelt,Wooded' ,`LotSize` = '13684' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 44' ,`TaxAmount` = '16070' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347595' WHERE `Matrix_Unique_ID` = '213518199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:59:14.410' ,`MLSNumber` = '87712582' ,`ListAgentFullName` = 'Debbie Corder' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403404' ,`Longitude` = '-95.092286' ,`PhotoCount` = '26' ,`PostalCode` = '77510' ,`RoomCount` = '7' ,`ListPrice` = '564900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 646' ,`StreetNumber` = '2710' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at it\'s best!! Beautifully updated 3/4 bedroom 2 bath home on 4.7 manicured acres in the heart of Santa Fe. Home features open living areas with with center set fireplace with blower for additional heating in the winter. Gorgeous kitchen with quartz countertops and eat in bar with contemporary swivel bar stools. Primary suite with walk-in closet and oversized spa like shower. All bedrooms have walk-in closets. A/C, Appliances, and much more new in 2018. Property zoned residential/commercial' ,`Acres` = '4.7179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 PAGE 9 N 1/2 OF LOT 51 (51-1) THAMANS 1ST SUB' ,`LotDesciption` = 'Wooded' ,`LotSize` = '205512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Thamans 1st Sub' ,`TaxAmount` = '5399' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347595' WHERE `Matrix_Unique_ID` = '213574370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T09:50:35.473' ,`MLSNumber` = '83188430' ,`ListAgentFullName` = 'Cheryl Espiritu Belin' ,`ListOfficeName` = 'Homelove Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965155' ,`Longitude` = '-95.195808' ,`PhotoCount` = '37' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo Peak' ,`StreetNumber` = '17022' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home with a sparkling pool and spa is ideally located on a cul de sac street in the amenity-rich master planned community of Eagle Springs and is zoned to incredible schools! This Highland Home with stone and brick façade features a formal dining room, island kitchen with butler\'s pantry, wine fridge, granite counters, and stainless steel appliances, including a gas cooktop, expansive living room with soaring ceilings, hardwood floors, and stone gas fireplace, and a primary retreat with en suite bath that includes a dual vanity, separate shower, soaking tub, and walk in closet! There is a secondary bedroom and full bath on the first floor! Upstairs you will find a game room, two bedrooms, and a jack and jill bath! The pool and spa were replastered and tiled in 2020! Upgraded lighting! Fresh paint 10/22! Zoned to West Lake Middle! Neighborhood amenities include competition and resort style pools, fitness center, splash pad, sports fields, parks, and a ton of events!' ,`Acres` = '0.1567' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 EAGLE SPRINGS SEC 27 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '7228' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347595' WHERE `Matrix_Unique_ID` = '213619270' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T10:05:39.983' ,`MLSNumber` = '13816102' ,`ListAgentFullName` = 'Kim Cox' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158951' ,`Longitude` = '-95.154877' ,`PhotoCount` = '46' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Burning Tree' ,`StreetNumber` = '26675' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location!!!!! Right off Grand Parkway and close to Valley Ranch town center. A variety of restaurants, shopping, specialty stores and even a movie theatre. A music venue in Valley Ranch is being built as we speak. \r\nThree Rivers Waterpark and Go Karts are just a couple of miles away off Highway 59. \r\nIn the country but still close enough to downtown and airport.\r\n\r\nWon\'t last long. Make your appt today!!\r\n\r\n**Agents see in remarks**' ,`Acres` = '0.6061' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S781005 - PEACH CREEK FOREST 05, LOT 837,839,841, SERIAL TXF' ,`LotDesciption` = 'Cleared' ,`LotSize` = '26400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '