Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:29:03.077' ,`MLSNumber` = '8355458' ,`ListAgentFullName` = 'Virginia Martin' ,`ListOfficeName` = 'Grove Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.062416' ,`Longitude` = '-96.241089' ,`PhotoCount` = '47' ,`PostalCode` = '77437' ,`RoomCount` = '12' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 403' ,`StreetNumber` = '8711' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your own piece of paradise--a partially restored farmhouse on 3.9 tranquil acres, complete with a pond. Shaded by mature trees, the home features large front and side porches with plenty of space to enjoy the quiet outdoors. The rest of the acreage is cleared and fenced and features a circle drive, detached carport, and large barn/workshop large enough to house RV, tractor, other equipment or use as workshop.' ,`Acres` = '3.9' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'A20550 ABST.550 TRACT 5A' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Danevang' ,`TaxAmount` = '5540' ,`TaxRate` = '1.9674' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705159' WHERE `Matrix_Unique_ID` = '203290744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:03:44.573' ,`MLSNumber` = '8438273' ,`ListAgentFullName` = 'Bradley Bevers' ,`ListOfficeName` = 'Legend Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.169510' ,`Longitude` = '-96.394884' ,`PhotoCount` = '45' ,`PostalCode` = '77833' ,`RoomCount` = '4' ,`ListPrice` = '880000.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built in 1929 by Dr. Richard Eugene Nicholson and his wife, Mary Stone Nicholson, granddaughter of J.D. Giddings.This home features living room,dining room,sunroom,game room,kitchen,utility room,4 bedrooms,4 full bathrooms,detached garage and detached bonus room(not included in the sqft).A baby grand piano is included with the sale. Sunroom was added to the original home in the 80s.Kitchen has marble countertops and backsplash. Thermador electric 4-burner range & convection double oven,and Bosch dishwasher.The master bathroom was updated in 2020 and has double vanity area of marble and brass fixtures,a glass shower,free-standing cast iron bathtub,slate floors,and walk-in closet w/ built ins.Upstairs includes large, game room with pool table and shuffleboard table.Both are included in the sale.Covered parking area behind the second building.In the second half of 2021, all interior paint was updated and landscaping redone both in the front & side yard. Updated pics available on request.' ,`Acres` = '0.63' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COTTONWOOD STREET , LOT 11A2, 12A2' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '27443' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cottonwood Street' ,`TaxAmount` = '9595' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1929' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705159' WHERE `Matrix_Unique_ID` = '203697760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:17:44.110' ,`MLSNumber` = '3510573' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480327' ,`Longitude` = '-95.174026' ,`PhotoCount` = '16' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '469990.00' ,`Status` = 'Active' ,`StreetName` = 'Campbell' ,`StreetNumber` = '507' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood features three bedrooms, two bathrooms, and a massive family room for entertaining!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15, Block 2, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7329' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705159' WHERE `Matrix_Unique_ID` = '205678134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:16:10.620' ,`MLSNumber` = '60162691' ,`ListAgentFullName` = 'Richard Bell' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.204963' ,`Longitude` = '-96.182837' ,`PhotoCount` = '26' ,`PostalCode` = '77865' ,`RoomCount` = '3' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'County Rd 436' ,`StreetNumber` = '9334' ,`StreetSuffix` = 'Road' ,`City` = 'Marquez' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bdrm ,1 bath shower only,kitchen /dinning/family room ,1 bdrm /loft upstairs.Stained concrete flooring .Custom wood thru out home.Granite counter top.Washer Dryer,Refrigerator left with accepted offer.No Dishwasher.\r\n\r\nHome is back on the market,Please show this one .' ,`Acres` = '21.05' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RURAL AB 1318 W G LEE 21.050 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '916938' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '195 - Leon' ,`SchoolElementary` = 'LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEON HIGH SCHOOL' ,`SchoolMiddle` = 'LEON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'ruralab13wglee21.050' ,`TaxAmount` = '22' ,`TaxRate` = '1.6695' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705159' WHERE `Matrix_Unique_ID` = '207410849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:18:48.050' ,`MLSNumber` = '71899919' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.201042' ,`Longitude` = '-95.407290' ,`PhotoCount` = '20' ,`PostalCode` = '77515' ,`RoomCount` = '8' ,`ListPrice` = '419990.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Meadow' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood features three bedrooms, four bathrooms, a massive family room for entertaining, and an upstairs bonus room!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 53, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Windrose Green' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705159' WHERE `Matrix_Unique_ID` = '208425433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:01:39.573' ,`MLSNumber` = '98423880' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884441' ,`Longitude` = '-95.796980' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '833000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Finch' ,`StreetNumber` = '7615' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 98423880 - Built by Highland Homes - December completion! ~ Ceilings soar and space abounds in this open floor plan. This home has an entertainment room next to the family room. There are two bedrooms downstairs plus a study. The curving staircase leads to a large game room and three more bedrooms. Relax on the covered patio at the end of the day.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705159' WHERE `Matrix_Unique_ID` = '208540410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:52:21.637' ,`MLSNumber` = '27443556' ,`ListAgentFullName` = 'Nola Lusk' ,`ListOfficeName` = 'A\'Lon Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702747' ,`Longitude` = '-95.340403' ,`PhotoCount` = '11' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Culmore' ,`StreetNumber` = '4918' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1324' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing prime location for new build. Single Family or Townhomes. There are many new constructed homes in the area. Property is conveniently located minutes from Downtown Houston, Medical Center, University of Houston, TSU, MacGregor Park, NRG Stadium, Metro rail. Easy access to 288 South, 45 South and I-69 expressways. This property is being sold as a teardown. You cannot beat the location. Get in on this up-and-coming neighborhood.' ,`Acres` = '0.1419' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 6 MACGREGOR PARK ESTATES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Park Estates Sec 03' ,`TaxAmount` = '3355' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705159' WHERE `Matrix_Unique_ID` = '208752040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:21:26.820' ,`MLSNumber` = '8724419' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.402663' ,`Longitude` = '-95.505243' ,`PhotoCount` = '17' ,`PostalCode` = '77318' ,`RoomCount` = '11' ,`ListPrice` = '556975.00' ,`Status` = 'Active' ,`StreetName` = 'Starlit Sky' ,`StreetNumber` = '611' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live your best life in the superior craftsmanship and incredible comfort of Hillmont luxury home plan. Design your ultimate home office or an innovative specialty room in the captivating front study. The epicurean kitchen provides a presentation island and ample room for food storage and meal prep. Your open-concept floor plan offers an impeccable space to play host to picture-perfect memories and brilliant social gatherings. Unique personalities and individual styles shine in the spacious spare bedrooms and guest suites. Retire to the elegance of your deluxe Owners Retreat, featuring an everyday-spa bathroom and a wardrobe-expanding walk-in closet. The upstairs retreat is the perfect space to create a family movie theater or a fun and games parlor. Cherish your relaxing sunsets and breezy weekends from the shaded bliss of your delightful front and back covered patios.' ,`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 19 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9581' ,`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,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705160' WHERE `Matrix_Unique_ID` = '208808294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:19:28.357' ,`MLSNumber` = '70449175' ,`ListAgentFullName` = 'John Lopez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679109' ,`Longitude` = '-95.111269' ,`PhotoCount` = '6' ,`PostalCode` = '77536' ,`RoomCount` = '9' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Lillie' ,`StreetNumber` = '1210' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare 5 bed, 3 bath home in Deer Park ISD. Solid wood door open to large living and formal dining room, both with high ceilings. Lots of natural light from the many windows in home. Painted in 2017 and 2\" wood blinds installed, along with updated fixtures, carpet, granite and more. Quick access to restaurants, shopping, entertainment and more. Backyard has nice deck and a pool for the hot Houston summers.' ,`Acres` = '0.1791' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 2 SAN JACINTO ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'San Jacinto Estates Sec 02' ,`TaxAmount` = '5857' ,`TaxRate` = '2.8431' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705160' WHERE `Matrix_Unique_ID` = '208932862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:25:10.300' ,`MLSNumber` = '341850' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.402998' ,`Longitude` = '-95.505126' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Starlit Sky' ,`StreetNumber` = '619' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coming home is the best part of each day in the beautiful and spacious Birkshire family home plan in The Woodlands Hills. Hone your culinary skills and explore new horizons of cuisine with the aid of split countertops, a deluxe pantry, and a full-function island in this epicurean kitchen. Your open floor plan provides a sunny and cheerful place to host family dinners, social gatherings, and your favorite times together. Assemble your ideal lounge, media room, or office in the versatile study. The spare bedrooms offer endless personalization opportunities for your growing residents. A luxurious bathroom and a bedroom-sized walk-in closet contribute to the everyday getaway of your sensational Owners Retreat. Experience all the lifestyle benefits of this new EnergySaverâ„¢ home plan.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8237' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven,Single 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,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705160' WHERE `Matrix_Unique_ID` = '209009913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:55:34.167' ,`MLSNumber` = '72873354' ,`ListAgentFullName` = 'Alexander DiSaggio' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.521798' ,`Longitude` = '-95.497631' ,`PhotoCount` = '32' ,`PostalCode` = '77545' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Long Creek' ,`StreetNumber` = '4559' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As per seller: Newly painted exterior & interior - all walls, ceilings, doors, trim, ect. As per seller: New Carpet in bedrooms. Gorgeous Leaded Glass Front Door greets you and welcomes you into the Spacious Entryway with Beautiful Tile Flooring, Tray Ceiling and Art Niche. Formal Dining Room features large Windows and Tile Flooring. Very Open Concept Floor Plan- Large Kitchen opens up to Breakfast Area and Huge Family Room-Den with a Wall of Windows Overlooking the Beautiful Back Yard!' ,`Acres` = '0.2602' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKMONT SEC 1, BLOCK 2, LOT 36' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11335' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '715' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekmont Sec 1' ,`TaxAmount` = '6080' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705160' WHERE `Matrix_Unique_ID` = '209124750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:35:08.590' ,`MLSNumber` = '72080220' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877177' ,`Longitude` = '-95.786977' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '609990.00' ,`Status` = 'Active' ,`StreetName` = 'Verbena Meadow' ,`StreetNumber` = '23715' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 72080220 - Built by Highland Homes - December completion! ~ This home has a stunning entry with soaring ceilings and open concept living. The stunning kitchen has a large island and overlooks the family room. The dining area has a beautiful hutch and sliding glass doors that open onto the covered patio. Four bedrooms and a study complete the home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 ELYSON SEC 23' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '7818' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705160' WHERE `Matrix_Unique_ID` = '209366548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:51:13.543' ,`MLSNumber` = '62867904' ,`ListAgentFullName` = 'Jennifer Jennings' ,`ListOfficeName` = 'NextHome Realty Solutions BCS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.333532' ,`Longitude` = '-97.147258' ,`PhotoCount` = '44' ,`PostalCode` = '76655' ,`RoomCount` = '4' ,`ListPrice` = '1249000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 433' ,`StreetNumber` = '300' ,`StreetSuffix` = '' ,`City` = 'Lorena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new slice of country heaven living in Central Texas! Located just 15 miles from Chip and Joanna\'s Magnolia empire and situated on fully stocked Lily Lake shared by only five homeowners, this place and all of its amenities is a sight to behold. The primary residence features massive upgrades all within the past two years. Newly remodeled bathrooms and office, as well as an air conditioned sunroom that overlooks the newly replastered pool, lake, and Saloon. The pool house includes a full bathroom, built in wooden bar, and space for beds or tables and chairs. After you\'re done with a fun filled day of swimming and grilling, fishing, or skeet shooting, make your way on over to the Hideout and entertain your family and guests in a room that also includes a built in wooden bar and separate area for dining. The land provides approximately 3 fully irrigated acres for gardening activities. The property also includes plenty of fully fenced acreage for your 4-H Project needs.' ,`Acres` = '13.14' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'A0081 ZARZA PEDRO 13.14 ACRES' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '572378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '693 - Lorena' ,`SchoolElementary` = 'LORENA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LORENA HIGH SCHOOL' ,`SchoolMiddle` = 'LORENA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Other' ,`TaxAmount` = '7319' ,`TaxRate` = '2.1604' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705160' WHERE `Matrix_Unique_ID` = '209456061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:38:48.823' ,`MLSNumber` = '8518221' ,`ListAgentFullName` = 'Chou Wey' ,`ListOfficeName` = 'The Michael Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694567' ,`Longitude` = '-95.770972' ,`PhotoCount` = '32' ,`PostalCode` = '77407' ,`RoomCount` = '13' ,`ListPrice` = '599400.00' ,`Status` = 'Active' ,`StreetName` = 'Spellbrook Bend' ,`StreetNumber` = '22911' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and updated home located at Parkway Lakes facing the beautiful Lake view. Former Royce Model with upgrades galore kitchen and bath with modern shaker cabinets. Quartz counters and high-end Appliances! Beautiful glass door, huge owner\'s retreat, lots of closet space. High ceilings, designer touches, stone fireplace, breakfast room, formal dining and sturdy, spacious game room, all new flooring and paint and so much more! Master down with the 4 spacious bedrooms up with huge game room area. The extra room upstairs can be a bedroom, home office, or media room. Huge backyard with cover patio and iron fences. Walking distance to shopping and restaurant. House is ready to move in!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 20 blk 4 Parkway Lakes addition City of Richmond' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '9733' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705160' WHERE `Matrix_Unique_ID` = '209496954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:43:03.530' ,`MLSNumber` = '33275876' ,`ListAgentFullName` = 'Rachael Garnett' ,`ListOfficeName` = 'Malone Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.292262' ,`Longitude` = '-95.740172' ,`PhotoCount` = '36' ,`PostalCode` = '77430' ,`RoomCount` = '0' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '3411' ,`StreetSuffix` = 'Street' ,`City` = 'Damon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled country-farmhouse home! With a new roof, all new appliances and interior, it\'s move in ready. The primary bedroom with ensuite bathroom is located downstairs, while three bedrooms along with a game room are located upstairs. The open concept living, kitchen and dining create a great atmosphere. Plenty of room for a fenced in yard for your furry friends. Picture perfect covered front porch welcomes you home. Within walking distance to Damon ISD.' ,`Acres` = '0.4304' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HIGH SCHOOL BLK 11 LOT 8TO10 (DAMON)' ,`LotDesciption` = 'Other' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '14 - Damon' ,`SchoolElementary` = 'DAMON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAMON HIGH SCHOOL' ,`SchoolMiddle` = 'DAMON ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'High School' ,`TaxAmount` = '3676' ,`TaxRate` = '1.5443' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '209573793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:24:04.860' ,`MLSNumber` = '6604985' ,`ListAgentFullName` = 'Michael Bigner' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.166010' ,`Longitude` = '-95.725559' ,`PhotoCount` = '46' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Post Oak Run' ,`StreetNumber` = '28713' ,`StreetSuffix` = 'Street' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful house overlooks the 10th green of the golf course. Pulling into the winding driveway you will see a stocked pond and a fountain fed by a well. The kitchen has granite countertops and is opens to the family and dining room. The family room offers a beautiful view of the golf course a gas fireplace. The primary bedroom has a seating area, a fireplace and overlooks backyard. The primary bathroom has walk in shower, garden tub and large closet. Upstairs boast a large game room/media room and another bedroom. Lots of storage throughout. The house has a recently added generator, hot water heaters, and central vacuum. The roof is approximately 7 years old. The 3 car garage has lots of extra room that could be a workshop. Come and enjoy all the great views and lifestyle that High Meadow Ranch has to offer' ,`Acres` = '1.864' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HIGH MEADOW RANCH 10, BLOCK 1, LOT 4' ,`LotDesciption` = 'On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '81196' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '729' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'High Meadow Ranch 10' ,`TaxAmount` = '12265' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '209618797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:02:07.823' ,`MLSNumber` = '83437452' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882593' ,`Longitude` = '-95.791122' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '559990.00' ,`Status` = 'Active' ,`StreetName` = 'Townsend Bunting' ,`StreetNumber` = '7530' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2341' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 83437452 - Built by Highland Homes - December completion! ~ A dramatic entry with soaring ceilings is a favorite feature of the 553 plan. This home has 4 bedrooms plus a study in the back off of the huge open concept family, kitchen, and dining area. The stunning kitchen has a large curved island, charming window seat and tall arched niche. There is plenty of storage and the bedrooms have oversized closets. Relax on the covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8875' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '209683524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:19:30.920' ,`MLSNumber` = '94846098' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881284' ,`Longitude` = '-95.792668' ,`PhotoCount` = '35' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '569990.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatgrass Grove' ,`StreetNumber` = '24107' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 94846098 - Built by Highland Homes - December completion! ~ A long arched entry with bedrooms tucked away leads the way to open family, breakfast, kitchen, and dining spaces with an offset study in the 539 plan. Relax at the end of the day on the covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '209684918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:03:51.873' ,`MLSNumber` = '2998756' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880152' ,`Longitude` = '-95.798764' ,`PhotoCount` = '33' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '755646.00' ,`Status` = 'Active' ,`StreetName` = 'Switchgrass Valley' ,`StreetNumber` = '24438' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 2998756 - Built by Highland Homes - December completion! ~ The 204 plan is a large 1-story home with 4 bedrooms, a study up front, an entertainment room, and an open living, kitchen, and dining space. You will love the soaring ceilings and enhanced gourmet kitchen. Relax on the covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 ELYSON SEC 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8510' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '209755626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:09:53.717' ,`MLSNumber` = '56605394' ,`ListAgentFullName` = 'Kyle Roesler' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774666' ,`Longitude` = '-95.693133' ,`PhotoCount` = '40' ,`PostalCode` = '77094' ,`RoomCount` = '9' ,`ListPrice` = '499950.00' ,`Status` = 'Active' ,`StreetName` = 'Parkview Point' ,`StreetNumber` = '18323' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upgrades Galore (3 Stories) Brick and stone elevation * Updated kitchen cabinets * Wood flooring downstairs * Barn wood accent in Mud area Kitchen, and Around Fireplace * Crown molding, light fixtures, hardware downstairs * Open Floorplan * Open kitchen to the family room and dining room * SS Kitchen Aid Appliances * Wall of windows looking out over covered patio and greenbelt * Huge master Bedroom with balcony looking over Greenbelt * Master Bath large enough to live in(lots of Windows) Extra Large Shower * Third story Features Large Gameroom and Media Room * Surround Sound in Family Room and Media Room * Outside Speakers and TV * Call to schedule your appointment today!' ,`Acres` = '0.0739' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 ARCADIA' ,`LotDesciption` = 'Greenbelt,Patio Lot' ,`LotSize` = '3220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2405' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Arcadia' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '209871350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:42:12.007' ,`MLSNumber` = '57357625' ,`ListAgentFullName` = 'Thuan Nguyen' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733803' ,`Longitude` = '-95.470986' ,`PhotoCount` = '45' ,`PostalCode` = '77056' ,`RoomCount` = '10' ,`ListPrice` = '945000.00' ,`Status` = 'Active' ,`StreetName` = 'Lampasas' ,`StreetNumber` = '5354' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5354 Lampasas. This AMAZING 4 bedroom 4.5 bath home located in the in the heart of the Historical Post Oak/Galleria area. This home is only a short walk away from the main the Galleria District . This stunning home features a open concept living space, large walk-in closets, and elegant hardwood floor throughout the home. The owner has recently had the entire home professionally painted. The The kitchen space features high end appliances; Double oven, built in refrigerator. Refrigerator and washer dryer are included in the sale. Each floor features a large family room. The downstairs family room features a wet bar with a wine fridge and ice maker. The Primary suite has its own private patio overlooking the pool. Additionally, there is an exquisite primary bathroom with a double vanity, double shower and built in cabinets in the closet. The backyard features a beautifully landscaped Waterfall Pool and recreational area perfect for entertaining.' ,`Acres` = '0.1515' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 5 LAMAR TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lamar Terrace' ,`TaxAmount` = '20260' ,`TaxRate` = '2.4457' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '209897300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:45:03.760' ,`MLSNumber` = '90876117' ,`ListAgentFullName` = 'Brittany Trebus' ,`ListOfficeName` = 'TexasRenters.com, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932937' ,`Longitude` = '-95.721776' ,`PhotoCount` = '15' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Paula Bluff' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom home in Cypress Lakes! Stunning archways add architectural details in the first floor, and a huge game room/flex space makes up the whole second floor. Kitchen is open to the living room and features granite counters and tons of cabinet space! The primary bedroom is spacious and the ensuite bathroom has a separate garden tub and shower. You have to see this amazing floorplan!' ,`Acres` = '0.166' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 CYPRESS CREEK LAKES SEC 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WARNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Lakes' ,`TaxAmount` = '9645' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705161' WHERE `Matrix_Unique_ID` = '210804909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:46:33.987' ,`MLSNumber` = '45775799' ,`ListAgentFullName` = 'Areli Dozal' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994268' ,`Longitude` = '-95.145756' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '383500.00' ,`Status` = 'Active' ,`StreetName` = 'Hikers Trail' ,`StreetNumber` = '19010' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this waterfront Brighton Home. Located in Walden on Lake Houston. You have access to a golf course, private boat ramp, club house restaurant, fitness center with yoga, Olympic-sized pool, tennis, racquetball courts, and much more! This gorgeous home offers 4 bedrooms and 2.5 baths and open concept floorplan. The spacious kitchen showcases granite countertops, tiled backsplash, and grey cabinets. Relax or entertain your guests with waterfront views. This home has a lot to offer!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 16 OLYMPIC VILLAGE WALDEN ON LAKE HOUSTON PH 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '9394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 02' ,`TaxAmount` = '6500' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705162' WHERE `Matrix_Unique_ID` = '210852233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:34:16.490' ,`MLSNumber` = '40479868' ,`ListAgentFullName` = 'Bonnie Schinnerer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816474' ,`Longitude` = '-94.392144' ,`PhotoCount` = '14' ,`PostalCode` = '77665' ,`RoomCount` = '6' ,`ListPrice` = '134900.00' ,`Status` = 'Active' ,`StreetName` = '9th Street' ,`StreetNumber` = '925' ,`StreetSuffix` = '' ,`City` = 'Winnie' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2022 Single wide Mobile Home with 2 bedrooms/2 bathrooms on a slab. East Chambers ISD Low Taxes.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Wright\'s Manufacture' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '14-35-11-1-3 WINNIE SUBURBS' ,`LotDesciption` = 'Corner' ,`LotSize` = '5052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winnie Suburbs' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705162' WHERE `Matrix_Unique_ID` = '210897561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:03:27.240' ,`MLSNumber` = '64580741' ,`ListAgentFullName` = 'Trung Nguyen' ,`ListOfficeName` = 'Dash Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.525024' ,`Longitude` = '-94.470422' ,`PhotoCount` = '23' ,`PostalCode` = '77617' ,`RoomCount` = '8' ,`ListPrice` = '799800.00' ,`Status` = 'Active' ,`StreetName` = 'Van Sant' ,`StreetNumber` = '1152' ,`StreetSuffix` = '' ,`City` = 'Gilchrist' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A quiet canal front getaway and outdoor paradise house to enjoy quick access to quiet beach, fishing, crabbing and more in Canal City! A recently remodeled house sitting on 2 lots complete with a cargo lift, a bulkhead and a boat slip! 2 extra lots on each of the house can be built for RV park rental for additional income stream. A beautiful pool and tons of seating make this deck one of the nicest on the peninsula! Beautiful decor on the inside. 5 bedrooms and 3 baths provides plenty of room for all your guests. Excellent short term rental history on VBRO and AirBnB' ,`Acres` = '0.7164' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 52 J DUNMAN SUR LOTS 236 THUR 239 CANAL CITY' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '31200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canal City' ,`TaxAmount` = '8020' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705162' WHERE `Matrix_Unique_ID` = '210967274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:38:18.030' ,`MLSNumber` = '94213054' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = 'La\'Rin Pierce' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.460832' ,`Longitude` = '-95.541281' ,`PhotoCount` = '22' ,`PostalCode` = '77318' ,`RoomCount` = '2' ,`ListPrice` = '149900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Andwood' ,`StreetNumber` = '12791' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '//New construction// Fall in love with this beautiful single story 2 bedroom 2 bath home featuring an open floor plan, high ceilings, granite counters, kitchen island, self closing drawers/cabinets, 42\" upper cabinets, great walk-in-pantry and stainless steel package. Ample primary bedroom with private bath and large walk-in closet. The primary bath has a large shower that gives it a spa like feel. Laundry room is also nice sized too!!! All this at a very affordable price. Come take a look soon, If you put under contract fast enough you can select from a variety of custom colors/material options to give this home your personal touch.' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = '3-G Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 01, BLOCK 12, LOT 42' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705162' WHERE `Matrix_Unique_ID` = '211207615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:44:46.380' ,`MLSNumber` = '31758244' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.460810' ,`Longitude` = '-95.541175' ,`PhotoCount` = '21' ,`PostalCode` = '77318' ,`RoomCount` = '2' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Andwood' ,`StreetNumber` = '12795' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '//New construction// Fall in love with this beautiful single story 2 bedroom 2 bath home featuring an open floor plan, high ceilings, granite counters, kitchen island, self closing drawers/cabinets, 42\" upper cabinets, great walk-in-pantry and stainless steel package. Ample primary bedroom with private bath and large walk-in closet. The primary bath has a large shower that gives it a spa like feel. Laundry room is also nice sized too!!! All this at a very affordable price. Come take a look soon, If you put under contract fast enough you can select from a variety of custom colors/material options to give this home your personal touch.' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = '3-G Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 01, BLOCK 12, LOT 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '51' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705162' WHERE `Matrix_Unique_ID` = '211208077' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:38:42.083' ,`MLSNumber` = '12518467' ,`ListAgentFullName` = 'Clayton Hays' ,`ListOfficeName` = 'RE/MAX Advanced Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.472575' ,`Longitude` = '-96.049360' ,`PhotoCount` = '19' ,`PostalCode` = '75831' ,`RoomCount` = '3' ,`ListPrice` = '149500.00' ,`Status` = 'Active' ,`StreetName` = 'Ray' ,`StreetNumber` = '528' ,`StreetSuffix` = 'Street' ,`City` = 'Buffalo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buffalo TX - 3 BED 2 BATH on 1+/-AC in Buffalo City Limits -\r\n Great location being located just at the edge of town at the end of a black top city street. This home is in a nice quiet area in a neat and clean neighborhood.\r\nThe Home sits atop a beautiful hill with a great view off the back porch overlooking a huge back yard and in ground swimming pool.\r\nA circle driveway and huge oak trees decorate the front yard creating a nice approach from the road.\r\nThis Home has had several updates throughout that includes new laminate flooring, fixtures and bathroom upgrades. \r\nThe master bedroom is very spacious and also has a huge custom shower with nice tilework.\r\nGreat place to entertain friends and family in the back yard this summer hanging out by the pool.' ,`Acres` = '0.88' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Buffalo Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BUFFALO CITY TR 9 0.8800 AB 562 S D MCKAY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '38333' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '194 - Buffalo' ,`SchoolElementary` = 'BUFFALO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUFFALO HIGH SCHOOL' ,`SchoolMiddle` = 'BUFFALO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Buffalo' ,`TaxAmount` = '2458' ,`TaxRate` = '2.2532' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705162' WHERE `Matrix_Unique_ID` = '211225869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:55:20.177' ,`MLSNumber` = '3990234' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982823' ,`Longitude` = '-95.647542' ,`PhotoCount` = '14' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '749973.00' ,`Status` = 'Active' ,`StreetName` = 'Greenwood Gable' ,`StreetNumber` = '13626' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This artfully designed home is a show stopper! Upon entry you are greeted with high ceilings and an elegant curved stair case. The foyer is flanked by the spacious home office and first floor private guest suite. The 2-story family room boasts an open-concept design and opens to the kitchen fit for a chef. The kitchen boasts built-in stainless-steel appliances, custom painted cabinets, quartz countertops, a walk-in pantry and a lux butler\'s pantry. The spacious primary bedroom is complete with double vanities, a soaking tub, and a large shower. The home includes a second-floor entertainment space with both a media room and a game room. Designer touches include wood floors, painted cabinetry, an oversized covered patio, and so much more!' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1' ,`LotDesciption` = 'Cleared,In Golf Course Community,On Golf Course' ,`LotSize` = '7680' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Enclave at Longwood' ,`TaxAmount` = '' ,`TaxRate` = '2.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705163' WHERE `Matrix_Unique_ID` = '211250721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:32:05.437' ,`MLSNumber` = '2993801' ,`ListAgentFullName` = 'Stanley Mani' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.353667' ,`Longitude` = '-95.507635' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1462' ,`StreetNumber` = '2806' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COUNTRY LIVING that\'s been Fully renovated with modern upgrades & a touch of elegance! This 4bed/4full bath home is nestled on close to 3 acres that offer comfort and cozy scenic views. The home\'s first floor is equipped with all the bedrooms/ 3 full baths downstairs, 2-car attached garage, Living, formal dining, kitchen with breakfast nook, office or study. Th second level has the gameroom with wet bar, full bath and a media room. The large open kitchen boasts stainless steel appliances, an island with cooktop & seating space as a breakfast bar, and an ample amount of counter/cabinet space. Enjoy the many Covered porches/balconies or relax on the sun deck with your favorite book. There\'s also a covered gazebo on the property great for picnics, gatherings or just to hang out and hide from the sun! Great location- not too tucked away- Only a 35-minute drive to the Galleria or Medical Center. Zoned to great schools, claim this home as yours today!!!' ,`Acres` = '2.91' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0125 A ROBINSON TRACT 15B-15C4 ACRES 2.91' ,`LotDesciption` = 'Other' ,`LotSize` = '126760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'A Robinson' ,`TaxAmount` = '5653' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705163' WHERE `Matrix_Unique_ID` = '211515319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:42:09.213' ,`MLSNumber` = '91505782' ,`ListAgentFullName` = 'Hugo Mendoza' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965345' ,`Longitude` = '-96.014260' ,`PhotoCount` = '26' ,`PostalCode` = '77484' ,`RoomCount` = '6' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Schmidt' ,`StreetNumber` = '13319' ,`StreetSuffix` = 'Road' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5 acres unrestricted land with brick home & barns. Home comes with Fridge, Washer, Dryer. Brand new fence installed and painted, as well as a brand new and freshly painted sliding gate. Great starter/weekend country living property. Property has been updated since purchased. Perfect to bring farm animals. Easy access to I-10 and Hwy 290.' ,`Acres` = '4.991' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A304100 A-41 JUSTO LIENDO TRACT 348 ACRES 4.991' ,`LotDesciption` = 'Cleared' ,`LotSize` = '217408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Justo Liendo Tr 348 A-41' ,`TaxAmount` = '5066' ,`TaxRate` = '1.8575' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705163' WHERE `Matrix_Unique_ID` = '211556639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:54:37.870' ,`MLSNumber` = '39108986' ,`ListAgentFullName` = 'Jason Muse' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784370' ,`Longitude` = '-95.823154' ,`PhotoCount` = '12' ,`PostalCode` = '77494' ,`RoomCount` = '3' ,`ListPrice` = '259990.00' ,`Status` = 'Active' ,`StreetName` = 'Roberts' ,`StreetNumber` = '5719' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '0' ,`BathsHalf` = '2' ,`BedsTotal` = '1' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available COMMERCIAL PROPERTY Located in Old Katy. Quick access to I-10, US 90, and all kinds of restaurants and shopping. Gated lot offering some extra security. Extra parking available behind building. Great Opportunity for your small business needs. Call listing agent for more info.' ,`Acres` = '0.2066' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'KATY TOWNSITE U/R, TRACT 84 (TRACT 15 (PT)) (A-393)' ,`LotDesciption` = 'Other' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Katy Townsite U/R' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705163' WHERE `Matrix_Unique_ID` = '211617949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:52:07.800' ,`MLSNumber` = '14917656' ,`ListAgentFullName` = 'Maria Tamez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821247' ,`Longitude` = '-95.278406' ,`PhotoCount` = '20' ,`PostalCode` = '77028' ,`RoomCount` = '10' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Ethel' ,`StreetNumber` = '8145' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL FRAME HOUSE IS SELLING IT IN AS IS, SELLER WILL NOT COMPLETE BUILDING THIS PROJECT, EXCEPT THE STUCCO AND PLUMBING, WE HAVE APPROVED FLOOR PLAN ATTACHED AND SURVEY ARE ATTACHED, SITUATED IN A 3 CORNER LOTS, HUGE AND BEAUTIFUL BACKYARD PORCH AND ALSO A BIG COVERED PATIO WITH CONCRETE FLOOR, 4 BEDROOMS 3 FULL BATHS, HIGH CEILINGS, FAMILY ROOM, FORMAL DINNING ROOM, OPEN KITCHEN WITH A BREAKFAST AREA, 2 PRIMARY HUGE BEDROOMS WITH A FULL BATHS\r\nIF YOU NEED MORE INFORMATION, PLEASE CALL THE LISTING AGENT' ,`Acres` = '0.3085' ,`Area` = '2' ,`BuilderName` = 'SELLER' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 14 & 15 BLK B LIBERTY ROAD MANOR SEC 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '13440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Road Manor Sec 05' ,`TaxAmount` = '1779' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705163' WHERE `Matrix_Unique_ID` = '211652496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:16:19.667' ,`MLSNumber` = '62540711' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.391667' ,`Longitude` = '-95.722434' ,`PhotoCount` = '14' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Colby\'s' ,`StreetNumber` = '120' ,`StreetSuffix` = 'Way' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming three bedroom, two bath home is known for its intelligent use of space and now features an even more open living area. The large kitchen granite-topped island opens up to your living room to provide a cozy flow throughout the home. Your dining area features the most charming window you\'ll ever see. Featuring large walk-in closets, luxury flooring, and volume ceilings - this beauty certainly delivers when it comes to affordable luxury. Additional options include: Covered porch, stainless steel appliances, dual primary bathroom vanity, and a single basin kitchen sink.' ,`Acres` = '0.172498' ,`Area` = '39' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S582404 - The Hills Of Town Creek 04, BLOCK 1, Lot 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7514' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Hills of Town Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705163' WHERE `Matrix_Unique_ID` = '211693531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:56:09.690' ,`MLSNumber` = '44357631' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681313' ,`Longitude` = '-95.736799' ,`PhotoCount` = '40' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '431645.00' ,`Status` = 'Active' ,`StreetName` = 'Laila Manor' ,`StreetNumber` = '20535' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As you walk through the front door of this beautiful 2-story home, you will be welcomed by a grand entry paved with stunning tile throughout. The open-concept design of the home boasting a spacious 2-story family room will make entertaining family and friends a breeze. After a long day retreat to the luxurious primary suite adorned with dual sinks and a walk-in closet. Upstairs, you will discover a game room overlooking the family room, ideal for entertaining the kids. This home is energy efficient and is Environments for Living certified, which includes a guaranteed utility cost in writing. Visit this beautiful home today!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5004' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Grand Mission Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.86' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705163' WHERE `Matrix_Unique_ID` = '211762296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:32:22.220' ,`MLSNumber` = '7750253' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938820' ,`Longitude` = '-96.037853' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '7' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Bonanza' ,`StreetNumber` = '12209' ,`StreetSuffix` = 'Place' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hello Pilots! Live with your Airplanes - all of them! 80 ft wide x 120 ft deep, Lighted Hangarminium at the Gated access Airpark of Fair Weather Field (TX42) in Brookshire, Texas. You\'ll own 1 acre right on the runway. The Airpark has multiple Runways with a 3,375 ft long asphalt 13/31 runway & a 2,400 ft 18/36 turf strip. Remotely operated 60 ft wide x 14.5 ft high Higher Power Hydraulic Hangar Door for your aircraft. GENERAC Backup Electric system. A 14 ft x 14 ft push button Roll Up door on the driveway side for your Cars, RV\'s and toys. Air-conditioned Aircraft Build/Work Shop with a Fold Away Wall to get airplanes in and out. Dumb waiter installed for supplies to the upstairs. 1/2 bath in the hangar area. Almost 2000 square feet of air conditioned living space upstairs. Open kitchen into the family room. 2 separate primary bedrooms, each with their own bathroom. Private Office/Study that has it\'s own external door to the balcony. Huge Utility Room and Pantry. #SearchTexasAirparks' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S474600 FAIR WEATHER FIELD BLK 1 LOT 3 ACRES 1.0' ,`LotDesciption` = 'Airpark' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Fair Weather Field' ,`TaxAmount` = '7829' ,`TaxRate` = '1.8575' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705164' WHERE `Matrix_Unique_ID` = '211762980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:54:59.007' ,`MLSNumber` = '76464294' ,`ListAgentFullName` = 'Candice Harris' ,`ListOfficeName` = 'CA Modern Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752601' ,`Longitude` = '-95.633826' ,`PhotoCount` = '49' ,`PostalCode` = '77077' ,`RoomCount` = '12' ,`ListPrice` = '999950.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Landing' ,`StreetNumber` = '1723' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mediterranean Style Custom Home on a beautifully landscaped corner lot, tucked inside Lakes of Parkway gated community! Fabulous home with spacious main living spaces with plenty of room for entertaining family and friends. This property has been completely updated with modern finishes throughout. No expense was spared. Property has a new roof, new HVAC, new energy efficient windows, custom island was added, and new wood flooring throughout. All the bathrooms were remodeled with ceramic tile, granite, and high end fixtures.' ,`Acres` = '0.1834' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 LAKES OF PARKWAY SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '7989' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Lakes Pkwy Sec 03' ,`TaxAmount` = '13849' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705164' WHERE `Matrix_Unique_ID` = '211767717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:37:54.740' ,`MLSNumber` = '9018473' ,`ListAgentFullName` = 'Clayton Hays' ,`ListOfficeName` = 'RE/MAX Advanced Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.446743' ,`Longitude` = '-96.063122' ,`PhotoCount` = '19' ,`PostalCode` = '75831' ,`RoomCount` = '3' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Acres' ,`StreetNumber` = '811' ,`StreetSuffix` = '' ,`City` = 'Buffalo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buffalo TX- 3BED 2BATH on 1 AC - Beautiful home that has been completely remodeled. This home has a big open concept kitchen/living area that features gorgeous cabinet work and granite countertops. The master bathroom has a custom walk in shower as well as a vanity that is all built in with granite.\r\nThe recessed lighting throughout gives the home an elegant look along with the huge bay window windows to let in natural light.\r\nThe back two bedrooms are on the opposite side of the home and also has a nice bathroom with granite counter tops and a custom shower.\r\nOutside the home there is an additional office that is next to the 2 car garage. This office would be great to use as a home/business or used for a hobby.\r\nOn The back of property is a huge metal shop with concrete slab that has both an enclosed area and covered area that is set up to work on cars and equipment.\r\nThis shop is well built has ample space giving it endless possibilities. \r\nNice place with numerous great features.' ,`Acres` = '1' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Buffalo Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BUFFALO CITY / SOUTH FORK RANCHETTE 1.000 AB 1112 P L KEEN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '194 - Buffalo' ,`SchoolElementary` = 'BUFFALO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUFFALO HIGH SCHOOL' ,`SchoolMiddle` = 'BUFFALO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Golden Acres' ,`TaxAmount` = '1491' ,`TaxRate` = '2.2532' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705164' WHERE `Matrix_Unique_ID` = '211842651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T11:05:03.037' ,`MLSNumber` = '97031349' ,`ListAgentFullName` = 'Nathan Haley' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.373971' ,`Longitude` = '-94.964466' ,`PhotoCount` = '11' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '214000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak' ,`StreetNumber` = '627' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful hardwood floors throughout the home. Updated kitchen which includes granite countertops. Gorgeous arch ways leading to the hallways. New Interior paint. Huge corner lot. Nice porch on the front of the home.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOTS 15,16, ADJ W 1/2 OF ALLEY BLK 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Toohey' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705164' WHERE `Matrix_Unique_ID` = '211850418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:24:41.007' ,`MLSNumber` = '65252210' ,`ListAgentFullName` = 'Kevin Vader' ,`ListOfficeName` = 'Century 21 Top Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858538' ,`Longitude` = '-95.677759' ,`PhotoCount` = '40' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Land' ,`StreetNumber` = '5806' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2144' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained brick single-story 3/2/2 home on a quiet cul-de-sac street! Light & bright with tile floors throughout (no carpet!)! Grand living/den with well-appointed gas fireplace! Huge dining area (currently used as an office). Spacious island kitchen with tons of storage space, gas range, breakfast bar AND breakfast area! Primary bedroom has vaulted ceilings & doors leading to the spacious covered back patio + generous ensuite with separate shower, soaking tub & massive walk-in closet! Recent roof & AC + landscaped to perfection on a wonderfully shady lot with mature trees! Don\'t miss out - come see it today!' ,`Acres` = '0.1708' ,`Area` = '8' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 WINDSONG SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7439' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windsong Sec 04' ,`TaxAmount` = '5721' ,`TaxRate` = '2.5618' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705164' WHERE `Matrix_Unique_ID` = '211948060' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T10:12:31.150' ,`MLSNumber` = '77353773' ,`ListAgentFullName` = 'Kelley Hitchens' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335180' ,`Longitude` = '-95.550292' ,`PhotoCount` = '27' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Roaring Timber' ,`StreetNumber` = '4306' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your Perfect Home! This Stockdale home offers five or six bedrooms, 4 full baths, entertainment-friendly Layout with Oversized, Dreamy Island with granite counter tops; Kitchen that opens to Spacious Dining Area & Family Room, plus a huge second floor game room! Perfect Open Concept! Tons of Kitchen Counter Space + Storage with Under-Cabinet Lighting! Privately Located Primary Suite with a Huge Walk-In Closet and En Suite Bathroom! Oversized Indoor Utility Room. Covered Back Patio with oversized yard to enjoy backyard family BBQ\'s!! Beautiful and well-maintained community you\'ll proud to become a member of and don\'t be shy, the neighbors are awesome with kiddo\'s everywhere. Zoned to Highly Rated Conroe Schools! Shopping and restaurants are minutes away and whoa! Lake Conroe with boating, recreation, swimming and fishing is just so close by! Don\'t miss out on this home at a great price!' ,`Acres` = '0.1807' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S974402 - THE WOODS OF CONROE 02, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7871' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woods Of Conroe' ,`TaxAmount` = '9180' ,`TaxRate` = '3.1863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705164' WHERE `Matrix_Unique_ID` = '212007632' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212012674','1663705164','212012674','2022-08-31T11:35:55.950','37397977','Paulina Espinoza','Coldwell Banker PropertiesUnlimited','','','30.335747','-96.654384','16','77879','8','189000.00','Active','Blackberry RD','367','','Somerville','2','0','3','1216','Single-Family','Come out to the country and enjoy a quiet neighborhood that\'s just a few miles from Lake Somerville. This manufactured home built in 2021 sits on 1.1acre lot. Cleared,fully fenced with a gate and has a septic. The home is well maintained with warm neutral colors throughout, an open concept, built in shelves, & black kitchen appliances. The master bath features a soaking tub, separate shower and double sinks. It has a few big trees around the home to have some shade and enjoy your outdoor entertainment. This deal won\'t last long! Schedule an appointment to view this stunning home!','1.146','59','Clayton Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','','','Central Electric','0','S2507 Enchanted Oaks Park Lot 266-267 1.146 Acres','Cleared','','','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','158 - Somerville','SOMERVILLE ELEMENTARY SCHOOL','SOMERVILLE HIGH SCHOOL','SOMERVILLE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Builder','1','Other Style','Enchanted Oaks','','','Aerobic','2021','Builder'); --> New record created successfully