Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:21:32.043' ,`MLSNumber` = '87055241' ,`ListAgentFullName` = 'Abbigail Herring' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Javier Herrera' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '28.991432' ,`Longitude` = '-95.582778' ,`PhotoCount` = '16' ,`PostalCode` = '77422' ,`RoomCount` = '4' ,`ListPrice` = '194900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 510z' ,`StreetNumber` = '3031' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home offers 3 spacious bedrooms upstairs, 2 bathrooms, updates throughout, large living area right off of the open kitchen, plenty of room outdoors and not far access to the San Bernard, just in time for summer. Schedule your showing today, you don\'t want to miss this one!' ,`Acres` = '0.4242' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HOLIDAY SHORES (A0092 JNO MCNEEL), BLOCK 24, LOT 3-4 SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '18478' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Holiday Shores' ,`TaxAmount` = '2057' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710499' WHERE `Matrix_Unique_ID` = '207562793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:23:18.383' ,`MLSNumber` = '77331631' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506432' ,`Longitude` = '-95.177706' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '12' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Butler' ,`StreetNumber` = '2004' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pilots! Your opportunity to purchase a 2 story, metal roofed home & hangar that has never flooded, w/ a Beautiful pool & hot tub, on the Gorgeous Aviation Polly Ranch Estates runway. Close to dining & shopping - close to Houston & a very Active flying Community. This 1981 built home sits on .5510 acres with a 2500 sq ft, well lighted, Aircraft Hangar complete with a 45 ft x 14 high Bi-Fold Wilson Hangar Door, an automatic RV roll up door at 10Wx12H, a full bath & air conditioned pilot lounge, & concrete ramp with multiple tie downs. The Airport Identifier is 7XS0 & has a well maintained 2,700 ft asphalt, lighted 11/29 runway. This home has all of the traditional features from its era like a Formal Living & Formal Dining. A separate Family room with a gas log fireplace for comfort. Large primary bedroom & bath are down while the other 3 bedrooms are up. Huge Gameroom with half bath above the garage. Relax on the rear patio while the grand children swim. #SearchTexasAirparks' ,`Acres` = '0.551' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 11 LOT 116 POLLY RANCH ESTATES REPLAT' ,`LotDesciption` = 'Airpark,Subdivision Lot' ,`LotSize` = '24000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Polly Ranch Estates Rep' ,`TaxAmount` = '10448' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710499' WHERE `Matrix_Unique_ID` = '207751795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:21:06.580' ,`MLSNumber` = '69904080' ,`ListAgentFullName` = 'Kerrie Haskett' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Kelly Griffin' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.086381' ,`Longitude` = '-95.126140' ,`PhotoCount` = '45' ,`PostalCode` = '77336' ,`RoomCount` = '10' ,`ListPrice` = '699000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Commons Forest' ,`StreetNumber` = '29502' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Act fast - your dream home is here! Situated in the tranquil lakeside community of The Commons, this magnificent home features 4 bedrooms, 3.5 bathrooms, over 2 acres, with a 3000 sq foot shop! Leave your worries behind as you enter through the electronic gate with a driveway spanning the length of the property. This home boasts of a large primary suite with an updated master bath with a renovated shower. The primary suite has private patio access and large windows overlooking the property. This home has a home office with a closet, formal dining room, formal living room, large country kitchen, and a split plan for privacy. Updates include new fencing 2016; new driveway 2016; All new windows 2016; new roof 2021; fresh paint 2021; new AC 2019; new wood plank tile floor 2021; sprinkler system front and back 2017; updates to septic system 2017 and 2018; and laundry room extension 2015. The shop is 50x60 with 18 ft walls and a 20x20 roll top door. Schedule a showing today!!!' ,`Acres` = '2.71' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 COMMONS OF LAKE HOUSTON SEC 7' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '118047' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Commons Lake Houston Sec 07' ,`TaxAmount` = '10019' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710500' WHERE `Matrix_Unique_ID` = '208917722' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:13:36.650' ,`MLSNumber` = '67144735' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.499985' ,`Longitude` = '-95.408873' ,`PhotoCount` = '11' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '539950.00' ,`Status` = 'Active' ,`StreetName` = 'Palmero' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story new construction home for sale in Manvel, TX. Open-concept layout features an elongated foyer entryway with a breathtaking view of the over-sized family room with a full wall of windows. Our gourmet kitchen is a chef\'s dream kitchen with a large granite kitchen island, double ovens, and walk-in pantry. Formal dining room and separate breakfast area. Study on the first level allows you to work from home or for the children to do their online learning. Over-sized family room offers plenty of space for quality family time. Grand primary suite boasts a massive closet with an extra storage nook. Spacious primary bath feature his and hers sinks, sit-in vanity, separate soaking tub, and walk-in shower. Open to below makes it easy to keep an eye on the kids from the first level. 3 spacious secondary bedrooms and large game room lie upstairs. Covered back patio.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Rodeo Palms Lot 2 Block 1 Section RPL-4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms' ,`TaxAmount` = '' ,`TaxRate` = '3.82' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710500' WHERE `Matrix_Unique_ID` = '209366236' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:44:31.117' ,`MLSNumber` = '22986889' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.112367' ,`Longitude` = '-95.372799' ,`PhotoCount` = '16' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 458C' ,`StreetNumber` = '11809' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment Opportunity! Now\'s your chance to add your own personal touch and turn this home into your next dream home sitting on 1.56 acres! Generac that runs the entire property conveys. NO FLOODING' ,`Acres` = '1.57' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LANG SHORES (A0030 S F AUSTIN), BLOCK 2, LOT 10TO13-15TO19' ,`LotDesciption` = 'Cleared' ,`LotSize` = '67815' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'LANG SHORES' ,`TaxAmount` = '2363' ,`TaxRate` = '2.069588' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710500' WHERE `Matrix_Unique_ID` = '209993814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:15:07.523' ,`MLSNumber` = '77401740' ,`ListAgentFullName` = 'Jenifer Somich' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.362051' ,`Longitude` = '-94.982842' ,`PhotoCount` = '32' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '2704' ,`StreetSuffix` = 'Drive' ,`City` = 'La Marque' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding find!! 3 to 4 bedroom, 1 bath in The Highlands. Nicely sized yard, spacious driveway. Separate garage, spacious tiled entry with leaded glass door, attractive wood flooring in living room with lighted ceiling fan, updated kitchen with attractive granite countertops, stainless steel appliances, gas range & plenty of cabinet space! Indoor laundry room, great tile work in the bathroom tub / shower, backyard with storage shed!' ,`Acres` = '0.2401' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 PAGE 4 LOT 31 BLK 17 THE HIGHLANDS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highlands The' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710500' WHERE `Matrix_Unique_ID` = '210242399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:02:54.130' ,`MLSNumber` = '65362238' ,`ListAgentFullName` = 'William Lasar' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054905' ,`Longitude` = '-95.723833' ,`PhotoCount` = '27' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '357500.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Lariat' ,`StreetNumber` = '19434' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding Beazer Home with multiple upgrades. One Story, 3 Bedroom, 2 Bath 1673 SF. Gss Fireplace, Ceramic Wood Looking Floors, Carpet in bedrooms, Spacious Primary bedroom with equally spacious Primary Bathroom witha large walk-in Shower. Gourmet Island Kitchen with Quartz Countertops and Walk-in Pantry. 42\" Upper Cabinets. Stainless Steel Appliances, includes Refrigerator and Washer and Dryer. Large corner lot. Easy acess to HWY 99 Grand Parkway. The \'Armira Subdivision is close to a variety of popular restaurants and shopping centers. Tomball ISD.' ,`Acres` = '0.176' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 2 AMIRA SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '7666' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Amira Sec 3' ,`TaxAmount` = '8948' ,`TaxRate` = '3.4925' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710500' WHERE `Matrix_Unique_ID` = '210273634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:07:28.670' ,`MLSNumber` = '9166074' ,`ListAgentFullName` = 'Christian Parrado' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.353583' ,`Longitude` = '-95.017917' ,`PhotoCount` = '8' ,`PostalCode` = '77563' ,`RoomCount` = '8' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Glen' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Street' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all investors! Property sold as is. Come fall in love with this beautiful property sitting almost on an acre on the bayou! Low tax rate, NO HOA! This beautiful large 4 bedroom home is nestled in a quiet culdasac. Your new home has many opportunities to design it to your dream bayou waterfront home! The kitchen is large with pool views. The dining room views are breathtaking, so peaceful and serene! The large living area is perfect for entertaining with massive floor to ceiling windows all along the back of your home over viewing the garden and bayou. The primary bedroom also has ceiling to floor windows overviewing the bayou and a walk- in closet! There is additional storage inside the garage and has the potential to convert into a theater room/playroom/man cable. Minutes from Galveston, Kemah, Tanger Outlet Mall.' ,`Acres` = '0.7747' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 PAGE 11 LOT 32 & E PT OF LOT 33 (32-1) OAK RIDGE' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '33745' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge' ,`TaxAmount` = '6877' ,`TaxRate` = '2.3428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664710500' WHERE `Matrix_Unique_ID` = '210320868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:36:53.897' ,`MLSNumber` = '86230453' ,`ListAgentFullName` = 'Diana Ayers' ,`ListOfficeName` = 'Ayers & Associates Realtors' ,`SellingAgentFullName` = 'Joseph Licata' ,`SellingOfficeName` = 'United Real Estate' ,`Latitude` = '29.759619' ,`Longitude` = '-95.485044' ,`PhotoCount` = '10' ,`PostalCode` = '77057' ,`RoomCount` = '0' ,`ListPrice` = '1050000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Riverview' ,`StreetNumber` = '6012' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '5013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lucian Hood designed home in Tanglewood. This is a wonderful opportunity to build or restore in Tanglewood just a few blocks from the Houston Country Club!! Home has extensive water and foundation damage and is being sold for lot value although if you want a project this could again be the stately home it once was. Beautiful large trees on the perimeter of the property offer great shade and privacy. The present structure is set back from the street with a circular drive. There is an excellent public school about 10 minutes away which goes up to the of 6th grade (check school information independently). The Kinkaid School is one of the top three private schools in Houston and is a short 15 minutes away. The Houston Racquet Club is about 10 minutes away and has over 30 tennis courts, a children’s pool and an adult only pool. Drive by this beautiful building site within the neighborhood of stately homes.' ,`Acres` = '0.1845' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 64 TANGLEWOOD SEC 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Sec 19' ,`TaxAmount` = '26390' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710501' WHERE `Matrix_Unique_ID` = '210337541' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:00:00.487' ,`MLSNumber` = '24558471' ,`ListAgentFullName` = 'Martha Terry' ,`ListOfficeName` = 'Saltwater Sunrise Properites' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.359815' ,`Longitude` = '-94.975709' ,`PhotoCount` = '14' ,`PostalCode` = '77568' ,`RoomCount` = '2' ,`ListPrice` = '144999.00' ,`Status` = 'Active' ,`StreetName` = 'Pessara' ,`StreetNumber` = '2204' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is being sold as-is' ,`Acres` = '0.1617' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOT 5 PESSARA SUB' ,`LotDesciption` = 'Other' ,`LotSize` = '7042' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`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` = 'Ranch' ,`Subdivision` = 'Pessara' ,`TaxAmount` = '1670' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1903' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710501' WHERE `Matrix_Unique_ID` = '210946192' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:00:41.470' ,`MLSNumber` = '36801496' ,`ListAgentFullName` = 'Leigh Marcus' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037009' ,`Longitude` = '-95.177624' ,`PhotoCount` = '48' ,`PostalCode` = '77339' ,`RoomCount` = '11' ,`ListPrice` = '1195000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenway View' ,`StreetNumber` = '27' ,`StreetSuffix` = 'Trail' ,`City` = 'Kingwood' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CLASSIC ELEGANCE DESCRIBES THIS STUNNING MITCHELL CARROLL ESTATE*ENTER THROUGH CUSTOM CANTERA DOORS & YOU ARE FLANKED BY THE FORMAL DINING & LIVING ROOMS W/PANORAMIC VIEWS OF THE FOREST COURSE*CALIFORNIA KITCHEN IS OPEN TO THE FAMILY RM W/A RAISED BEAMED CEILING*KITCHEN BOASTS WOLF APPLIANCES, SUB ZERO FRIDGE & QUARTZ COUNTERTOPS PLUS BUTLER\'S PANTRY*LG MASTER BEDROOM DOWN W/AN ADDITIONAL SEATING AREA PLUS ONE ADDITIONAL BEDROOM/STUDY DOWN*2ND STORY HAS 2 LIVING AREAS PLUS THREE ADDITIONAL BEDROOMS, ALL W/BATHS ATTACHED*ONE W/ACCESS TO A SPACIOUS BALCONY*2 CUSTOM FIREPLACES PLUS OVERSIZED CARP DIEM CABINET PULLS THROUGHOUT+3 CAR GARAGE W/EPOXY FLOORING &PORTO COCHERE*LG COVERED PATIO PLUS GORGEOUS POOL, SPA & WATERFALL*A TIMELESS,AWARD WINNING FLOOR PLAN*ONE OF A KIND AND A GEM OF A FIND!! SHOWN BY APPOINTMENT....' ,`Acres` = '0.2705' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 4 KINGWOOD GREENS VILLAGE SEC 3' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '11782' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Greens Village Sec 03' ,`TaxAmount` = '18812' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710501' WHERE `Matrix_Unique_ID` = '210947441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:48:10.260' ,`MLSNumber` = '59216715' ,`ListAgentFullName` = 'Javier Rivera' ,`ListOfficeName` = 'Ai Realty' ,`SellingAgentFullName` = 'Brad Fleming' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.690451' ,`Longitude` = '-95.430281' ,`PhotoCount` = '29' ,`PostalCode` = '77025' ,`RoomCount` = '9' ,`ListPrice` = '589900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Braeswood' ,`StreetNumber` = '3515' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This ranch home sits on a very large 14,900 SF corner lot, never flooded (per Seller), with a whole home generator, and zoned to Bellaire High School! New Floors in family room and new carpet, fresh paint, updated PEX plumbing throughout, and updated electrical. Incredible original vintage features with an open and light-filled layout, substantial room sizes, and a stellar location in Braes Terrace. Convenient to 610 Loop and Texas Medical Center, with miles of trails along Brays Bayou at your fingertips! Large formal living and dining rooms, family room with fireplace and stone wall, breakfast room open to charming kitchen, 3 roomy bedrooms, updated baths, and tons of storage throughout, plus HUGE cedar closet. Generous patio off of the family room, and large fenced yard allowing plenty of room for a pool. 2-car attached garage with extra storage. With its fantastic curb appeal, this special home is livable, or ready to be taken to the next level.' ,`Acres` = '0.3421' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 29 BRAES TERRACE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '14900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Braes Terrace Sec 02' ,`TaxAmount` = '11040' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710501' WHERE `Matrix_Unique_ID` = '211404969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:26:43.663' ,`MLSNumber` = '90479856' ,`ListAgentFullName` = 'Jane Draughon' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147366' ,`Longitude` = '-95.478713' ,`PhotoCount` = '40' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberwagon' ,`StreetNumber` = '10712' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique updated French style home in the heart of The Woodlands. Exquisite finishes and architectural details throughout with beautiful double iron front doors. The raised grand entry descends to the family room, featuring a spectacular fireplace which extends to the ceiling, surrounded by tall, elegant arched windows. The home features double pane energy efficient Anderson windows throughout, gorgeous updated hardwood floors, and a workshop with A/C. The lifetime Mansard roof shakes, metal stair balusters, stainless steel appliances, custom cabinets and granite kitchen and bath countertops are a few of the upgrades. Game room could also be second primary ensuite bedroom. The remodeled primary bath has a huge walk-in shower, custom cabinets with quartz countertops, and new fixtures, toilet & lighting. The downstairs primary bedroom, with it\'s own cozy fireplace, has a gorgeous view of the huge, picturesque backyard oasis with multi-level decking for relaxing under the canopy of trees.' ,`Acres` = '0.4886' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 06, BLOCK 6, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '21283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Wdlnds Village Grogans Ml 06' ,`TaxAmount` = '7924' ,`TaxRate` = '2.0469' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710501' WHERE `Matrix_Unique_ID` = '211414642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:32:16.687' ,`MLSNumber` = '73711713' ,`ListAgentFullName` = 'Diane Morales' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Krystal Gutierrez' ,`SellingOfficeName` = 'Results Real Estate' ,`Latitude` = '29.512993' ,`Longitude` = '-95.814270' ,`PhotoCount` = '39' ,`PostalCode` = '77471' ,`RoomCount` = '12' ,`ListPrice` = '309999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cardinal Sky' ,`StreetNumber` = '1814' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story Postwood Home with a View! Located at the heart of the cul-de-sac with a stunning view of the lake for your evening walks around the lake with your Family and Pets! This property will mesmerize you with tall, mature shade trees and lush landscaping with a sprinkler system. Dramatic High-Ceiling in the Entry and Dining Room, stunning views of the second floor. Ceramic Tile Flooring; Spacious kitchen awaits your culinary delights, 42\" Oak Cabinets with ceramic tile backsplash and flooring. The master retreat is warm and inviting. The master bath is more than generous and boast of dual vanities. Home Office/Study can be a 5th bedroom on the first floor. On the second level you can enjoy hours of family fun in your fabulous game room. Primary Bedroom on the First Floor. Great patio and large backyard for entertaining. Kitchen Refrigerator Included. Seconds from Richmond and Sugar Land, eateries, shopping and entertainment. The only thing missing here is \"You\"!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Postwood Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FAIRPARK VILLAGE SEC 1, BLOCK 2, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6904' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '508' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairpark Village' ,`TaxAmount` = '6407' ,`TaxRate` = '3.2048' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710501' WHERE `Matrix_Unique_ID` = '211834281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:50:25.623' ,`MLSNumber` = '5992660' ,`ListAgentFullName` = 'Jessica Phillips' ,`ListOfficeName` = 'Red Shoe Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578599' ,`Longitude` = '-95.428179' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Trace' ,`StreetNumber` = '1831' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome! Gorgeous & gently lived in home that is perfect for entertaining or simply living. Located in the desired and established community of Shadow Creek Ranch. This home features a stunning entry way & foyer w/a 14’ ceiling. At the front of the house is a formal dining room & cozy study adorned w/ beautiful French doors. Kitchen is complete w/a walk-in pantry, 2 large bars which allow for additional seating, granite countertops, tile backsplash, island, gas cook top and plenty of storage & counter space. Open to the breakfast nook and living area, a wall lined w/large windows allow for lots of natural light. Two secondary bedrooms, each w/walk-in closets. A half bath for guests. Primary suite features dual vanities, separate glass enclosed shower, garden tub & bonus space that can be utilized as a customizable walk-in closet, second office, man cave or lady\'s lair (See photos for seller\'s prior customization). The possibilities are endless! . Schedule your private tour today!' ,`Acres` = '0.1719' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-63B, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-63b' ,`TaxAmount` = '11276' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664710502' WHERE `Matrix_Unique_ID` = '211902329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:07:01.350' ,`MLSNumber` = '4910514' ,`ListAgentFullName` = 'Jack Lipar' ,`ListOfficeName` = 'LGI Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182784' ,`Longitude` = '-95.799589' ,`PhotoCount` = '8' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '261900.00' ,`Status` = 'Active' ,`StreetName` = 'Shakespeare' ,`StreetNumber` = '23013' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand-new beautiful 3 bedroom, 2 bathroom, one story home showcasing an open floor plan between the entertaining areas of the home. The spacious flow between the kitchen living and dining is a true dream. The kitchen is loaded with modern upgrades including granite countertops, vinyl plank flooring, and all brand new Whirlpool appliances included. Even a refrigerator and microwave. This home also includes a 2-car garage with an automatic garage door opener. This lot features close and easy access to the on site amenities. You are short walking distance to the playground, splashpad, and shaded picnic areas in this wonderfully wooded community of Williams Trace located in Magnolia.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MGL L2, Bl2, Sec3 of Williams Trace' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Trace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710502' WHERE `Matrix_Unique_ID` = '211950959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:47:55.657' ,`MLSNumber` = '8449970' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020175' ,`Longitude` = '-95.475458' ,`PhotoCount` = '37' ,`PostalCode` = '77068' ,`RoomCount` = '10' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Encreek' ,`StreetNumber` = '2319' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grand one story newly renovated with open flowing floor plan. Faux wood porcelain tile light gray wash throughout home. This home ample over sized family/ game room with access to garage and back yard. The living room with cozy fire place with double paned sliding glass doors. The kitchen with Silestone counters and Ceiling high shaker cabinetry with soft closed drawers and modern kitchen faucet and undermount sink. \r\nThe spa inspired light and bright primary bath with quartz counter and Kholer faucets, spacious glass enclosed shower. The porcelain tile with Cearra marble inspired design. The Quartz double vanity with soft closed shaker cabinetry. Energy efficient HVAC & TRANE a/c and gas heater and low E windows and insulated doors. 2-10 Sellers Coverage Home warranty. The Seller will provide 2-10 Home Warranty for the Buyer. Appliance Pack for the home.' ,`Acres` = '0.4408' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 276 BAMMEL FOREST SEC 3' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '19200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bammel Forest Sec 03' ,`TaxAmount` = '5720' ,`TaxRate` = '2.0892' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710502' WHERE `Matrix_Unique_ID` = '211986823' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:18:58.840' ,`MLSNumber` = '27033495' ,`ListAgentFullName` = 'Lisett Labarca' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745623' ,`Longitude` = '-95.857249' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '620000.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel' ,`StreetNumber` = '28215' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KATY ISD ZONED! D.R. Horton\'s Chloe Floorplan on OVERSIZED LAKE LOT with upgraded Media Room and Refreshment Center Upgrade! \"Smart Home\" all controllable through your Hub or smartphone. This home has 4 bedrooms, 3.5 bathrooms. Kitchen with beautiful counters, 5 burner range and 42\" Cabinets! this beauty is sitting on a cul-de-sac. Master Suite featuring bath with double sinks, separate soaking tub and shower, and large walk-in closet. This home has everything you are looking for. A secondary bedroom wing for the kiddos with a study nook. Large, covered patio with plumed gas! Included is everything you are looking for in a community-The master bathroom has double vanities with a separate shower/tub and good-sized walk-in closet. Upstairs you have the large pre-wired media/theatre room and the game room along with the other bedrooms. Covered back patio and good-sized yard. HUGE BACKYARD perfect to make your own oasis with LAKEVIEW. Open House Sat. 3 -5 p.m.' ,`Acres` = '0.2028' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 27, BLOCK 2, LOT 20' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8834' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tamarron Sec 27' ,`TaxAmount` = '933' ,`TaxRate` = '3.1745' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710502' WHERE `Matrix_Unique_ID` = '212186759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:25:07.760' ,`MLSNumber` = '59229752' ,`ListAgentFullName` = 'D\'rinda Randall' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = 'Lawrence Dupas' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.961445' ,`Longitude` = '-95.622268' ,`PhotoCount` = '36' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '329900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Campsite' ,`StreetNumber` = '12511' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original homeowner is selling this beautiful house. It has been meticulously maintained and meticulously renovated! The yard is gorgeous and has received \'Yard Of The Month\' twice. Upgrades done in 2018: real stone fireplace, Italian plank tile, custom cabinetry in kitchen, family room, bathrooms, utility, and breakfast, replacement of all doors, barn door in primary, exterior and interior paint, remodeled primary bath w new shower, tub, and upgraded tile, recessed lighting, Bosch dishwasher, handpicked granite countertops in kitchen and bathrooms, exotic leather granite on kitchen island, PEX piping, blown insulation, crown molding and baseboards, blinds, high-end chandeliers (stunning!) and high-end cooking exhaust fan. Other upgrades include: metal shake roof (2001), storage shed 10X12 (2022), rain gutters (2020), double-paned windows (2014), cedar fence treated (2014). More upgrades on attachments!' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 5 SARACEN PARK SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '709' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'SARACEN PARK' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710502' WHERE `Matrix_Unique_ID` = '212208321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:10:26.073' ,`MLSNumber` = '55660412' ,`ListAgentFullName` = 'Angela Elliott' ,`ListOfficeName` = 'RE/MAX All Stars' ,`SellingAgentFullName` = 'Allison Ator' ,`SellingOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`Latitude` = '29.936853' ,`Longitude` = '-95.699426' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '915000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Timberlake Glen' ,`StreetNumber` = '19518' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why buy new when you can own this immaculate home in sought after Towne Lake? This home has ALL of the BELLS & WHISTLES! Enter to beautiful wood floors with soaring ceilings complemented by a beautiful spiral staircase. Make memories in the family room that\'s offers 19 foot ceilings that opens to a large gourmet kitchen with an oversized island, to entertain all of your guest needs. There\'s also a second bedroom downstairs with en suite bath. Step into your backyard oasis through the sliding doors to a beautiful pool/spa & outdoor kitchen that meets all of your culinary desires. So many features, please refer to upgrade list. Community offers top rated onsite elementary & middle school, resort-style waterpark with lazy river, pools, private island, parks & play grounds, tennis courts, fitness centers, hike & bike trails, community garden and onsite restaurants & shopping. All of this along with monthly resident activities make Towne Lake\'s lifestyle like no other! Hwy 99, 290 & I-10' ,`Acres` = '0.2693' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 TOWNE LAKE SEC 35' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1699' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake Sec 35' ,`TaxAmount` = '19285' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710503' WHERE `Matrix_Unique_ID` = '212224930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:25:24.760' ,`MLSNumber` = '27641122' ,`ListAgentFullName` = 'Kristin Roberts' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064643' ,`Longitude` = '-95.233035' ,`PhotoCount` = '39' ,`PostalCode` = '77339' ,`RoomCount` = '12' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingshill' ,`StreetNumber` = '26049' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You have to see this STUNNING home in Kings Mill, zoned to Porter High School! Immaculate 5 bedroom, 3.5 bath boasting formal living and dining rooms, spacious family room, large kitchen, cozy office/study, beautiful bay windows in the primary bedroom, and an AMAZING game room and media room, perfect for get-togethers with your family and friends! Not to mention the awesome backyard deck and patio for your year round cook-outs! Don’t worry about the dogs eating your steaks, they have their own space in the dog run located in the backyard! You can keep all of your lawn and garden equipment in the storage shed as well! But that’s not all! This home has a brand new roof (4/22), brand new light fixtures in the kitchen and primary bathroom, custom paints, exterior soffit lights installed around the home for your safety, high ceilings, sitting on a beautifully landscaped corner lot! Never flooded! You have to come out and see this gorgeous home ASAP!' ,`Acres` = '0.1515' ,`Area` = '40' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S642402 - KINGS MILL 02, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Mill 02' ,`TaxAmount` = '10292' ,`TaxRate` = '3.1831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664710503' WHERE `Matrix_Unique_ID` = '212237174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:07:01.350' ,`MLSNumber` = '23503922' ,`ListAgentFullName` = 'Melissa Rekoff' ,`ListOfficeName` = 'Luxe Living Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303643' ,`Longitude` = '-94.786757' ,`PhotoCount` = '32' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Ball' ,`StreetNumber` = '1728' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This East End Historic District home has been beautifully brought to life. Spanning the length of the home, this front porch is made for you to sit back in a rocker & enjoy the sunrise. Designate the back balcony for sunsets! As you enter the home\'s foyer, take a glimpse of the original hardwoods throughout, which were recently refinished. The natural light floods the home as it pours through the original beveled glass windows of the living room, formal dining, and 3 bedroom areas. The classic white kitchen has been modernized with soft-close cabinets and drawers. Installation of new Whirlpool stainless steel appliances. The previous owner built out a downstairs primary suite and utility room, which has been freshened up. The downstairs can continue to be used as a primary or can be used as a flex room. The other two bedrooms and 1 bath are on the main level. 1 car garage attached & storage! All of this, within a few minutes to Strand, UTMB, Beach, and more! Come see it for yourself!' ,`Acres` = '0.0459' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOT 14 (14-1) BLK 317 GALVESTO' ,`LotDesciption` = 'Corner' ,`LotSize` = '1998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '6640' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710503' WHERE `Matrix_Unique_ID` = '212246252' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:01:08.513' ,`MLSNumber` = '50778564' ,`ListAgentFullName` = 'Hien Luu' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799751' ,`Longitude` = '-95.495251' ,`PhotoCount` = '15' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterbury' ,`StreetNumber` = '8330' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this adorable home located in the heart of Spring Branch! Newly completed in the kitchen with new quartz countertops, freshly finished cabinets and stainless appliances. Zoned to excellent schools Valley Oaks Elementary and Memorial High School. NO HOA. NO FLOODING! New Refrigerator is included. Schedule your tour today!' ,`Acres` = '0.1767' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 8A BLK 1 E 1/2 LT 8 DANBURY PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Danbury Place' ,`TaxAmount` = '10874' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710503' WHERE `Matrix_Unique_ID` = '212281601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:44:44.920' ,`MLSNumber` = '80964441' ,`ListAgentFullName` = 'Yajaida Gravina-Fernandez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745926' ,`Longitude` = '-95.871652' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '341063.00' ,`Status` = 'Active' ,`StreetName` = 'Josephine Falls' ,`StreetNumber` = '3023' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2053' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous energy efficient freshly paint one-story house built in late 2015 in the community of Tamarron, has 4/2/2, and a flex room that can be used as an office or formal dining. Corner premium/cul-de-sac lot location ideal for the family recreation area. Open concept. The gourmet kitchen offers granite countertops, a walking pantry, stainless steel appliances, and tall cabinets. \r\nThe Tamarron Master-planned Community offers amazing amenities, including a Clubhouse, sports spaces, fitness center, resort-style pool, lap pool, splash pad, playground, dog park, nature trails, and lakes. NOTICE that this house has it all, lots of upgrades, ceramic and new laminate wood flooring, refrigerator, washer, dryer, Ring alarm system, and Ring doorbell own, kitchen ceiling recessed led lightings, and pendants lamps, fans in 3 bedrooms and living room, Epoxy painted garage floor, front & backyard sprinklers, and gutters.\r\nConvenient location to restaurants and shopping. Zoned to great schools !!' ,`Acres` = '0.1646' ,`Area` = '30' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 10, BLOCK 4, LOT 14' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '7171' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec 10' ,`TaxAmount` = '7190' ,`TaxRate` = '3.0923' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710503' WHERE `Matrix_Unique_ID` = '212346011' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:12:36.783' ,`MLSNumber` = '40344223' ,`ListAgentFullName` = 'Xiaoming Shao' ,`ListOfficeName` = '31 Realty' ,`SellingAgentFullName` = 'Perla Navarro' ,`SellingOfficeName` = 'Vive Realty LLC' ,`Latitude` = '29.869622' ,`Longitude` = '-95.205648' ,`PhotoCount` = '35' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '230000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Foliage' ,`StreetNumber` = '12711' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedrooms and 2 full bathrooms. Spacious rooms. New carpet. New paint. Move in ready.' ,`Acres` = '0.1074' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 EVERGREEN VILLAS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'CARROLL ELEMENTARY SCHOOL (SHELDON)' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'EVERGREEN VILLAS' ,`TaxAmount` = '5354' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710503' WHERE `Matrix_Unique_ID` = '212358778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:17:10.383' ,`MLSNumber` = '67194618' ,`ListAgentFullName` = 'Kimberly Bush' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747181' ,`Longitude` = '-95.786549' ,`PhotoCount` = '27' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '427000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Run' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2319' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home on a corner, cul-de-sac lot. Wait until you see this backyard! Sparkling pool/spa, tons of pool decking for all of your outdoor entertaining, but also has plenty of yard for your fur babies! This spectacular home features 4 bedrooms (or 3 bedrooms plus an office), 2 full bathrooms and a large island kitchen with granite counters, stainless steel appliances and tons of cabinet space. Gorgeous wood flooring in the primary bedroom, dining room and secondary bedrooms. En-suite primary bathroom features separate vanities, each with their own sink, granite counters, freshly painted cabinets, decorative mirrors, linen closet and a large walk-in closet. Large 2 car garage with attached porte cochere helps protect your vehicles from the elements. Front yard has gorgeous mature trees to provide shade on those hot summer days. Call today to schedule a private viewing. This home won\'t last long!' ,`Acres` = '0.2346' ,`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 - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 1, BLOCK 1, LOT 27' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10217' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Ranch' ,`TaxAmount` = '8998' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710504' WHERE `Matrix_Unique_ID` = '212363753' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:02:38.750' ,`MLSNumber` = '67723808' ,`ListAgentFullName` = 'Rosalie Stevenson' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385868' ,`Longitude` = '-94.983134' ,`PhotoCount` = '16' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Avenue' ,`StreetNumber` = '6330' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! NO HOA! LOW TAX RATE! One story 3 bedroom 2 full bath home. Open kitchen to living living room. Kitchen features quartz countertops with trendy backsplash. Primary bedroom with private bath and large walk in closet. Ample sized secondary bedrooms.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = 'Private' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 197 T TOBY SUR LOT 15 HUBBARD SUB' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hubbard' ,`TaxAmount` = '213' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710504' WHERE `Matrix_Unique_ID` = '212373442' --> 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','212410040','1664710504','212410040','2022-10-01T21:04:17.917','65646689','Rashad Garrett','Brooks & Davis Real Estate','','','29.608493','-95.376445','6','77047','5','344999.00','Active','Westwood Manor','2911','Lane','Houston','3','1','4','3082','Single-Family','','0.1432','3','','','','','Sellers Disclosure','','','3','Medical Center South','Central Gas','1','LT 3 BLK 1 BRUNSWICK MEADOWS SEC 12','Subdivision Lot','6239','Appraisal District','','0','0','','2','','0','','','','','Composition','27 - Houston','LAW ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','THOMAS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Brunswick Mdws Sec 15','7777','2.6498','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:03:32.610' ,`MLSNumber` = '54037451' ,`ListAgentFullName` = 'Diane Schiff' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654735' ,`Longitude` = '-95.060963' ,`PhotoCount` = '23' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '263000.00' ,`Status` = 'Active' ,`StreetName` = 'Redbud' ,`StreetNumber` = '3803' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home in wonderful Fairmont Park East. This is an opportunity to create your dream home. Nice layout with all bedrooms up. Spacious living/dining area. Breakfast room with windows overlooking the large backyard. Indoor laundry room and attached garage. Primary bedroom has ensuite, second bathroom located upstairs for secondary bedrooms, half bath on main level for guest. Room sizes are approximate, please verify for accuracy. \r\nOwner/Agent' ,`Acres` = '0.1653' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 FAIRMONT PARK EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LEO RIZZUTO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairmont Park East Sec 01' ,`TaxAmount` = '5836' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710504' WHERE `Matrix_Unique_ID` = '212410576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:42:29.093' ,`MLSNumber` = '20054464' ,`ListAgentFullName` = 'Tatiana Micolta' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676362' ,`Longitude` = '-95.740617' ,`PhotoCount` = '34' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Soledad Pine' ,`StreetNumber` = '6010' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do not miss out on this immaculate Ashton Woods home perfectly situated in a Cul-De-Sac with so many custom upgrades! This home features 4 bedrooms, 3.5 bathrooms, 2.5 car garage, in ground heated pool & hot tub, office, game room and a fully installed media room that includes a projector, projector screen, and surround sound throughout the home. Open kitchen concept perfect for entertainment. The living area consists of 26 ft ceilings, 8 foot doors throughout entire home. Conveniently located near Grand Parkway, Westpark Tollway, & 59. DON\'T MISS OUT ON THE CHANCE TO CALL THIS YOUR NEXT HOME! CALL US TODAY TO SCHEDULE YOUR SHOWING!' ,`Acres` = '0.2558' ,`Area` = '37' ,`BuilderName` = 'Ashton woods' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIELDSTONE SEC 11, BLOCK 1, LOT 20' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11144' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fieldstone Sec 11' ,`TaxAmount` = '10068' ,`TaxRate` = '2.8429' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710504' WHERE `Matrix_Unique_ID` = '212430303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:34:56.340' ,`MLSNumber` = '63882644' ,`ListAgentFullName` = 'Deborah Petruska' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341458' ,`Longitude` = '-95.494045' ,`PhotoCount` = '43' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Hills' ,`StreetNumber` = '1835' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'QUIET ELOQUENT NEIGHBORHOOD OF GRAYSTONE HILLS * OFFERING FULLY LOADED KITCHEN WITH LUXURY FEATURES**FABULOUS GOURMET KITCHEN WITH LARGE GRANITE COUNTERS * BREAKFAST BAR IN KITCHEN AREA***OPENS TO MASSIVE DEN W/HIGH CEILINGS* LOOK AT THE FIREPLACE WITH STONES TO THE CEILING**OPEN FORMAL DINING ROOM** NEED AN OFFICE OR CRAFT ROOM 14X13**A MEDIA ROOM TO DIE FOR 17X16**SPACIOUS SECONDARY BEDROOMS**MUCH, MUCH MORE**3 CAR GARAGE** BACK YARD IS READY FOR THE GARDNER!!** FRUIT TREES, APPLE, PEACH, PEAR, PLUM TREES*VEGETABLES GALORE ON UPPER LEVEL OF YARD..ENJOY NEIGHBORHOOD POOL, BASKETBALL COURTS, TRAILS, ETC** CLOSE TO I-45, CONROE, WOODLANDS, COLLEGES, SHOPPING. * ELEMENTARY, INTERMEDIATE AND JR HIGH LOCATED IN THE NEIGHBORHOOD***CUL DE SAC STREET!!! FRIG, SHUFFLE BOARD POOL TABLE STAY!!!' ,`Acres` = '0.2653' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539316 - GRAYSTONE HILLS 16, BLOCK 1, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11555' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Graystone Hills 16' ,`TaxAmount` = '13291' ,`TaxRate` = '2.7763' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664710504' WHERE `Matrix_Unique_ID` = '212431836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:59:08.687' ,`MLSNumber` = '5008223' ,`ListAgentFullName` = 'Isaias Contreras' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = 'Katherine Le' ,`SellingOfficeName` = '1 - Connect Realty' ,`Latitude` = '29.961073' ,`Longitude` = '-95.513798' ,`PhotoCount` = '37' ,`PostalCode` = '77066' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Marston River' ,`StreetNumber` = '6302' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6302 Marston River Lane. This very well maintained 3 bedroom 2 bathroom home, offers some of the best features available in the neighborhood. Located on a corner with one of the larger lots, Brand new 30 year roof with a 5 year warranty, Double door side gate for easy access to extended covered patio, four side brick, pre-wired for security cameras, upgraded floors, window security bars with locks, Mahogany kitchen cabinets with glass doors for a better look and design, upgraded with level 3 granite countertops with rounded corners for better look and safety, deep undermount kitchen sink and upgraded backsplash. The master bathroom offers high and low vanity cabinets, Separate tub and shower and a walking closet, big secondary bedroom. This house was just painted, professionally cleaned and is ready to move in. \r\n\r\nCall the listing agent for a private showing and more information.' ,`Acres` = '0.1576' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 CHAMPIONS CROSSING SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6866' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KLENK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Xing' ,`TaxAmount` = '6348' ,`TaxRate` = '3.3765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710505' WHERE `Matrix_Unique_ID` = '212455434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:53:57.557' ,`MLSNumber` = '83673854' ,`ListAgentFullName` = 'Michele Jacobs' ,`ListOfficeName` = 'Michele Jacobs Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.592671' ,`Longitude` = '-95.116035' ,`PhotoCount` = '34' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '399800.00' ,`Status` = 'Active' ,`StreetName` = 'Longvale' ,`StreetNumber` = '15811' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Vacation 365 days a year in your own Pool/Spa*One block to Armand Bayou Elementary School*Oversized 3 Car Garage*Large Home Office/Study*Built by famous Kustom Kastles*Total Gourmet Kitchen remodel complete with stunning Quartz countertops 2022*New Roof 2021*Total Bathroom remodel with stunning Quartz countertops 2019*Gutters 2018*PEX Plumbing Repipe 2018*Tankless Water Heater 2018*Exterior Paint, Siding,Rear Windows and Fence 2017*Pool Replaster and Tile Work 2016*New Pool Booster Pump 2022*Looks like a Model Home too many lovely updates to list you have to see this beauty! Clear Lake High School/CCISD amazing location*Be sure and click on the 3D Virtual Tour*Floor Plan online*WOW!! Open House Saturday 9/17/2022 12 Noon until 3 pm.' ,`Acres` = '0.2222' ,`Area` = '7' ,`BuilderName` = 'Kustom Kastles' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 62 BROOK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9678' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '479' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest' ,`TaxAmount` = '7852' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710505' WHERE `Matrix_Unique_ID` = '212457058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:41:17.523' ,`MLSNumber` = '11819318' ,`ListAgentFullName` = 'Jennifer Pena' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494703' ,`Longitude` = '-95.059767' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Yaletzi' ,`StreetNumber` = '2627' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful one story 3 bedroom + study home with a gorgeous pool in the sought after Tuscan Lakes Community! Enormous cul-de-sac lot with no back neighbors. As you enter the home you will immediately appreciate the abundance of natural light, high ceilings and open concept. Gourmet kitchen including stainless steel appliances, granite counter tops, ceramic tile, large island, and barstool seating. This home features a spacious family room with gas fireplace tons of windows overlooking the backyard. Primary bedroom is spacious with neutral colors and backyard/pool views. Relaxing primary bathroom with dual vanities, tile flooring, separate soaking tub and walk- in shower. Secondary bedrooms are spacious with ample closet space. The ultimate backyard oasis awaits you with your very own private pool, palapa, and plenty of yard to entertain. Community features walking trails, pool, splash pad. Prime location close to I 45, 146 & 96. Call today to schedule your showing!' ,`Acres` = '0.2898' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TUSCAN LAKES SEC SF 55-2 SE & 60-2 SE (2017) ABST 19, BLOCK' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tuscan Lakes Sec Sf 55-2 Se & 60' ,`TaxAmount` = '9216' ,`TaxRate` = '3.2297' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710505' WHERE `Matrix_Unique_ID` = '212469529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:48:12.820' ,`MLSNumber` = '62045685' ,`ListAgentFullName` = 'Eleanor Grant' ,`ListOfficeName` = 'Full Circle Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402181' ,`Longitude` = '-95.061272' ,`PhotoCount` = '38' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '368000.00' ,`Status` = 'Active' ,`StreetName` = 'Sand Lily' ,`StreetNumber` = '2213' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic opportunity to own year-old new construction home in the highly sought after Lago Mar community. This stunning corner lot home boasts beautiful brick elevation with 8\' mahogany front door and porch perfect for all your holiday decor. The bright, open kitchen features 42\" upgraded cabinets, Quartz countertops and complimentary backsplash. Stainless steel appliances - refrigerator include with sale. Conveniently located upstairs laundry room includes washer/dryer. Primary suite with dual vanity sink, large walk-in shower and separate garden tub for soaking. This upgraded corner lot provides an extensive back-yard perfect for a pool or ample room for landscaping of your choice and fully fenced for pets. A lifestyle that includes a 12-acre Crystal Lagoon pool, clubhouse and a second community center with a fitness room, pool, playground and soccer playfield. Connecting all of it is a trail system allowing easy access to all the fun. Call today to schedule a private tour!' ,`Acres` = '0.1579' ,`Area` = '33' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 5 LAGO MAR POD 4 SEC 5 (2020) ABST 11' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lago Mar Pod 4 Sec 5' ,`TaxAmount` = '1432' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710505' WHERE `Matrix_Unique_ID` = '212510645' --> 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','212611841','1664710505','212611841','2022-10-01T21:44:10.040','2911517','Tafi Daniels','RE/MAX ONE - Premier','','','29.816573','-94.849674','44','77523','4','309000.00','Active','Montego Bay','8315','Drive','Baytown','3','1','4','2223','Single-Family','This home has long lasting curb appeal with the brick and stone elevation that pops against dark cedar porch columns! Step in the front door and take a glance at all those upgrades! Painted cabinetry, granite, aged wood floor and ceramic tile all add to that beautiful first floor welcome! Foyer opens to the grand living space, flowing to a cozy breakfast nook overlooking the kitchen! Formal dining, at the front of the house, offers the option of an office space. Primary bedroom has an ensuite bathroom, with double vanity and separate bath and shower. Extended back patio over looks the cozy backyard that gives the perfect setting for early morning coffee or evening grilling. The light and bright upstairs hosts three additional bedrooms and full sized bath, along with open media area. The layout encourages family togetherness while still offering plenty of private space. A place you truly will enjoy coming home to.','0.132','53','','','','','Sellers Disclosure','','','','Chambers County West','Central Gas','1','BK 5 LT 5 LEGENDS BAY SEC 1','Cleared,Subdivision Lot','5750','Appraisal District','','350','0','','2','','0','','','','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Legends Bay Sec 01','4870','1.7058','Public Sewer,Public Water','2012','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:30:42.050' ,`MLSNumber` = '80339401' ,`ListAgentFullName` = 'Debra Dozier' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201952' ,`Longitude` = '-95.444454' ,`PhotoCount` = '34' ,`PostalCode` = '77385' ,`RoomCount` = '11' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Knoll Dale' ,`StreetNumber` = '17167' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4017' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 5-bed, 4-bath Highland Home in the master planned community of Harpers Preserve! This one-owner home is impeccably maintained and full of high-end custom touches. High ceilings throughout, a dedicated office, formal dining room, and beautiful hardwood floors. Open concept kitchen with large island and plenty of cabinet space, spacious living room with fireplace. Back yard has a covered patio, no back neighbor and a view of the pond. Primary bedroom has custom California Closet with direct access to laundry/utility room. Another large secondary bedroom located on the first floor with access to a full bath. Upstairs you will find 3 well sized bedrooms, 2 full baths and a game room. Off the game room is a top-of-the-line home theater room, equipment excluded. Harper’s Preserve offers resort-style amenities and is located just minutes from world class dining, shopping and entertainment. Easy Access to The Woodlands, Exxon Campus, and I-45. GE Café Refrigerator included.' ,`Acres` = '0.179' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572700 - HARPER\'S PRESERVE 01, BLOCK 7, LOT 12' ,`LotDesciption` = 'Greenbelt,Water View' ,`LotSize` = '7798' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve 01' ,`TaxAmount` = '11815' ,`TaxRate` = '3.0088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710505' WHERE `Matrix_Unique_ID` = '212667657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:35:58.380' ,`MLSNumber` = '60765930' ,`ListAgentFullName` = 'Debra Dozier' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984336' ,`Longitude` = '-95.515744' ,`PhotoCount` = '36' ,`PostalCode` = '77069' ,`RoomCount` = '9' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Olympia Fields' ,`StreetNumber` = '5427' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3701' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Roof!!! Spacious 4-bedroom, 3.5-bathroom custom brick home in the desirable Huntwick Forest. Located on quiet cul-de-sac, lined with grand old trees, this home includes a large primary bedroom on the first floor with a primary en-suite bathroom. Eat-in kitchen opens to oversized living room and a formal dining room. First floor also includes a flex room that can be used as a second office space or workout room. Dedicated office, utility room, and half bath also found on the first floor. Upstairs you will find a large game room and 3 large bedrooms and 2 FULL bathrooms. Backyard has a gorgeous covered patio and walkway to an extra-large 3-car detached garage! AC\'s replaced in 2018 and 2020. Smartside composite siding installed 2011 with a 50 year warranty. Dishwasher 2022. Mahogany front door 2021. Water heater 2021. Great natural light and tons of storage. Home is zoned to highly acclaimed \"A\" rated Cy-Fair ISD.' ,`Acres` = '0.2301' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 133A & 134B BLK 3 HUNTWICK FOREST SEC 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '152' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest Sec 08' ,`TaxAmount` = '6400' ,`TaxRate` = '2.4306' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710505' WHERE `Matrix_Unique_ID` = '212686382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:20:19.083' ,`MLSNumber` = '69107876' ,`ListAgentFullName` = 'Tien Nguyen' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.619819' ,`Longitude` = '-95.198951' ,`PhotoCount` = '25' ,`PostalCode` = '77034' ,`RoomCount` = '5' ,`ListPrice` = '247000.00' ,`Status` = 'Active' ,`StreetName` = 'Garlenda' ,`StreetNumber` = '13015' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2-story home with an open floor plan in Southway features community-friendly amenities such as a beautiful park, basketball court & playground for the kids! Good size backyard with no back neighbors. Minutes walk to a beautiful lake with walking trails. It is just minutes from Beltway 8, HWY 3, and I-45. Never flooded during Harvey or busted pipes during the freeze.' ,`Acres` = '0.0882' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 SOUTHWAY SEC 2 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GENOA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southway Sec 02' ,`TaxAmount` = '4766' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710506' WHERE `Matrix_Unique_ID` = '212687875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:26:41.680' ,`MLSNumber` = '96744974' ,`ListAgentFullName` = 'James Phillips' ,`ListOfficeName` = 'Phillips & Sons Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648542' ,`Longitude` = '-95.586809' ,`PhotoCount` = '19' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '393000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Crest' ,`StreetNumber` = '11930' ,`StreetSuffix` = 'Drive' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RECENTLY REMODELED, NEW ROOF, GRANITE COUNTER TOPS' ,`Acres` = '0.1225' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWGLEN SEC 1, BLOCK 4, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Meadowglen Sec 1' ,`TaxAmount` = '5719' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710506' WHERE `Matrix_Unique_ID` = '212703697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:08:31.520' ,`MLSNumber` = '17935028' ,`ListAgentFullName` = 'Cheri Melcher' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.912927' ,`Longitude` = '-95.091208' ,`PhotoCount` = '33' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Audie Lee' ,`StreetNumber` = '16014' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This 4/3.5/2 2-story has a beautiful elevation with nice curb appeal and is move-in ready. The media/game room is upstairs with a half bath. This home boasts high ceilings, easy-care flooring and upgrades throughout. The open concept and covered patio make it ideal for entertaining. Private backyard is fully fenced with no back neighbors. Located on a cul-de-sac with minimal traffic. \r\nNewport is a vibrant, growing community located just 30 minutes from downtown. Neighborhood amenities include pool, walking trails, splash pad, parks, tennis courts, golf course, gym, boat access to Lake Houston, beach area on San Jacinto River, and RV & boat storage. Schedule your tour today!' ,`Acres` = '0.1392' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 1 SEVEN OAKS SOUTH PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '6063' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Oaks South Pt Rep 1' ,`TaxAmount` = '6874' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710506' WHERE `Matrix_Unique_ID` = '212707372' --> 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','212729111','1664710506','212729111','2022-10-01T21:38:35.283','88481701','Desiree Thane','REALM Real Estate Professional','','','29.941934','-95.628564','23','77065','7','270000.00','Active','Counselor','11511','Street','Houston','2','0','3','1662','Single-Family','This delight 1 Story, 3 bedroom, 2 bath has spacious living room area with fire place, formal dinning room, kitchen, walkway to two car detached garage. Fridge, washer and dryer will stay if a new buyer wishes. Zoned to the highly acclaimed CY-Fair school district. OPEN HOUSE SATURDAY OCT 8 FROM 1 PM to 4 PM','0.1637','10','','','','','Mud,Sellers Disclosure','','','1','1960/Cypress','Central Gas','1','LT 11 BLK 9 MEISTERWOOD R/P','Subdivision Lot','7130','Appraisal District','','658','0','','2','','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','ADAM ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Meisterwood R/P','4446','2.381','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:18:33.443' ,`MLSNumber` = '18233470' ,`ListAgentFullName` = 'Dyna Rimkus' ,`ListOfficeName` = 'Rimkus Real Estate Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807527' ,`Longitude` = '-95.825505' ,`PhotoCount` = '37' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Deerfield' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1899' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Opportunity, move-In Ready! One story, corner home, located inside one of the nicest subdivisions in Old-Town Katy, conveniently located in the Award-Winning Katy ISD, with easy access to I-10 Freeway and Katy mall. This beautiful 4-bedroom home has a great floor plan w/ kitchen island facing family room, w/ living/dining combo, fireplace, laundry room with space for extra freezer or storage. Upgraded kitchen w/granite countertops, stainless steel built-in microwave/ vent/ hood, brand new dishwasher, double sink, new disposal and faucet. Two car garage with brand new door panels, new Sprinkler System Timer with Wi-Fi connection. Fresh painted walls and ceilings, wood-look tile flooring throughout. Back yard with covered patio. New roof was installed only three years ago. And all pipes changed after 2021 year\'s freeze. You will not want to miss this one!!' ,`Acres` = '0.169' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 FAWNLAKE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fawnlake Sec 01' ,`TaxAmount` = '5309' ,`TaxRate` = '2.4402' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710506' WHERE `Matrix_Unique_ID` = '212753096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:28:10.930' ,`MLSNumber` = '56256404' ,`ListAgentFullName` = 'Seth Showalter' ,`ListOfficeName` = 'First Warranty Realty' ,`SellingAgentFullName` = 'Maynor Vega' ,`SellingOfficeName` = 'Pivot Up Inc' ,`Latitude` = '29.801677' ,`Longitude` = '-95.521708' ,`PhotoCount` = '37' ,`PostalCode` = '77080' ,`RoomCount` = '3' ,`ListPrice` = '385000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Walterville' ,`StreetNumber` = '9349' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extensive remodel in 2012, that still looks fresh will impress you as you walk through the door. The garage has been converted to interior space that adds a lot of flexibility to this floorplan. Updated cabinets and huge island in the kitchen that is the heart of the home. Hardwood floors in front living room and bonus/ flex/ 3rd bedroom. This neighborhood is filled with well kept ranch style homes and is also experiencing a increase in new construction custom homes. This is a large lot with a lovely mature shade tree in the backyard. Not much available in this area that is NOT on a busy street and that does NOT back up to apartments or commercial properties. This would make a great rental until ready to build or live in as is. Great yard for the kids or pets. Rooms sizes approximate buyer to verify. Huge Lot!' ,`Acres` = '0.3134' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 132 BLK 11 SPRING BRANCH OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spring Branch Oaks Sec 02' ,`TaxAmount` = '7358' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710506' WHERE `Matrix_Unique_ID` = '212795749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:54:46.233' ,`MLSNumber` = '18463383' ,`ListAgentFullName` = 'Elizabeth Wentworth' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209510' ,`Longitude` = '-95.342177' ,`PhotoCount` = '38' ,`PostalCode` = '77302' ,`RoomCount` = '10' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Skies' ,`StreetNumber` = '17546' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better Than New! Sellers added many features to this already fantastic home. They are being transferred out of state or would never dream of leaving this beautiful home which they added so many special touches. Custom porcelain Zanzibar tile backsplash in kitchen, gutters added all around, accent walls in primary & office. Super Sized Primary Shower. RAP feature air flow w closed doors. Gorgeous backyard retreat w newly extended patio to enjoy majestic sunsets. No back neighbors, iron fence to view natural area & path. Rain barrel in back to capture and conserve water. Rare plan has suite w private entrance & full bath that could be office, mother-in-law or addtl primary bedrm. Woodworkers dream in 3rd car gar w tons of tool storage. Giant attic \"Room\" could become extra conditioned space off gamerm. Come & explore all the wonderful features of this home. Make it yours before someone else does. Enjoy fitness center, restaurant, lake & many more amenities of Artavia. Come fall in love!' ,`Acres` = '0.1623' ,`Area` = '19' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S216902 - ARTAVIA 02, BLOCK 3, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia 02' ,`TaxAmount` = '1799' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710507' WHERE `Matrix_Unique_ID` = '212810300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:48:56.433' ,`MLSNumber` = '77844278' ,`ListAgentFullName` = 'Gay Milliorn' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767867' ,`Longitude` = '-94.948782' ,`PhotoCount` = '44' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Apache' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Trail' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charmer is the home you\'ve been searching for! In addition to 3 bedrooms, 2 baths, and a 2 car garage, this home offers a great formal dining room (could also be an office or game room), high ceiling in the living area, a breakfast room, and great covered patio. Need a spot to park your boat? You\'ll love the extra driveway and gate into the spacious backyard. The roof and HVAC are less than 5 years old, and this home is brick on all 4 sides! No flooding and no HOA! Convenient location with easy access to Hwy 146, Garth Rd, and I-10. You\'ll want to see this one for yourself!' ,`Acres` = '0.1793' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 4 CHAPARRAL VILLAGE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chaparral Village Sec 01' ,`TaxAmount` = '4665' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710507' WHERE `Matrix_Unique_ID` = '212812686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:52:00.497' ,`MLSNumber` = '70392181' ,`ListAgentFullName` = 'Demetria Walker' ,`ListOfficeName` = 'CELEBS Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984139' ,`Longitude` = '-95.223887' ,`PhotoCount` = '50' ,`PostalCode` = '77338' ,`RoomCount` = '14' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Green' ,`StreetNumber` = '10702' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMPROVED PRICE! For Sale or Lease! Lease Option Possibly Avl! Call-4-Term! Perched on Championship Tour 18 Golf Course #12 T-box. A/C repaired Aug 2022 w/5-yr transferable warranty. Ideal-4-entertaining.Family living w/mucho flair!2-Bdrms+Home Office down & 3-Bdrms,convenient workstation, Gameroom+Media Room Up.Lots of pizzazz w/arches galore & granite counters.Gourmet Kitchen perfect for \'eats & treats\'. Energy efficient w/Radiant Barrier & more!2\' FAUX WOOD BLINDS throughout & black-out drapes in Primary Bdrm for day sleepers.PLANK HARDWOOD FLOORING IN STUDY,PRIMARY BDRM+ 2nd BDRM down.Fabulous landscaping= an impressive curb appeal and gorgeous golf views front and back! Enjoy the walking trails and easy access to HWY 59,Beltway 8, BUSH Airport, Award Winning-QUEST Early College High taxpayer funded school ,FM 1960, Lake Houston + plenty of shops and restaurants.This spacious and stylish home is a MUST SEE that priced to sell fast! Photos don\'t do it justice. Come see for yourself!' ,`Acres` = '0.2498' ,`Area` = '1' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 5 VILLAGES AT TOUR 18 SEC 1' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '10883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '748' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKELAND ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Traditional' ,`Subdivision` = 'Villages/Tour 18 Sec 1' ,`TaxAmount` = '10569' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710507' WHERE `Matrix_Unique_ID` = '212813651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:10:55.070' ,`MLSNumber` = '86698567' ,`ListAgentFullName` = 'Terri Clasen' ,`ListOfficeName` = 'Pat Griffin Realty ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.294005' ,`Longitude` = '-94.801415' ,`PhotoCount` = '22' ,`PostalCode` = '77550' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = '32nd' ,`StreetNumber` = '1317' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very cute, newly renovated, move-in ready home, located near Broadway with easy access to The Strand, UTMB, and beach. Outside you will note the fresh paint, new windows, new central AC/Heat and an easy to maintain yard. Once inside, you will see a thoughtfully designed space in this charming 2 bedroom, 1 bathroom home. There are new fixtures throughout the home. The kitchen boasts new counters, backsplash, appliances and cabinets. There is beautiful new vinyl plank flooring throughout the home, fresh paint and also new electrical. The roomy bathroom also has new fixtures and vanity. Both bedrooms have a nice closet space, and there are also 2 hall closets. The laundry is conveniently located just off of the kitchen with double doors to close off when not in use. Perfect starter home, or rental income. Please schedule your showing today.' ,`Acres` = '0.0305' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOT 8 (8-2) NW BLK 13 GALVESTO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '1022' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710507' WHERE `Matrix_Unique_ID` = '212835429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:02:42.520' ,`MLSNumber` = '44325807' ,`ListAgentFullName` = 'Ana Paula Perez-Abreu' ,`ListOfficeName` = 'The Realty Bridge' ,`SellingAgentFullName` = 'Janett Gutierrez' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.808687' ,`Longitude` = '-95.416641' ,`PhotoCount` = '24' ,`PostalCode` = '77008' ,`RoomCount` = '9' ,`ListPrice` = '665000.00' ,`Status` = 'Option Pending' ,`StreetName` = '25th' ,`StreetNumber` = '928' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2597' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Craftsman style home in an incredible location in the heart of The Heights! Walking distance to parks, restaurants and attractions including 19th St. shops, Heights MKT to name a few. Home has many upgrades including artificial turf backyard and brand new HVAC. Enjoy sightlines of open floor plan while entertaining or relaxing after a long day. Bright and white kitchen is perfect for cooking and baking. In cooler months, take advantage of the french doors that open up the living room to the patio area for a fantastic indoor/outdor experience. Gorgeous wood stairs lead to a large flex space that could be used as a media room, home office, or playroom. Secondary bedroom with rare, huge bay window allow light to pour into the second floor. Large laundry room offers ample storage. Natural stone countertops and flooring in bathrooms exude luxury. High ceilings throughout the home make a large home feel even bigger. Private backyard with minimal views from neighbors.' ,`Acres` = '0.0872' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 TWENTY FIFTH STREET TRAILS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Twenty 5th Street Trls' ,`TaxAmount` = '12040' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710507' WHERE `Matrix_Unique_ID` = '212843499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:49:13.627' ,`MLSNumber` = '32179807' ,`ListAgentFullName` = 'Yelena Grinina' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766424' ,`Longitude` = '-95.480206' ,`PhotoCount` = '43' ,`PostalCode` = '77057' ,`RoomCount` = '16' ,`ListPrice` = '3300000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Glen' ,`StreetNumber` = '5804' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '8788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive masterpiece by Stacey Fine Homes nestled in a beautiful & quiet part of Tanglewood. Family room with Wall of Windows and door that leads to patio; Chef\'s kitchen with full Thermador appliance package and island opens to a large living area viewing heated, salt water pool, spa, and water feature. Australian cypress flooring throughout. Central wet bar, butler’s pantry, wine room & formal dining room are designed for family gathering and entertaining. Guest bedroom, study, home office, air conditioned outdoor kitchen w/fireplace all on the first floor. Game room has powder room + wet bar, media room, and primary bedroom + 4 bedrooms up. Primary suite Includes separate coffee bar with microwave, ice maker & fridge, fireplace, two huge closets, oversized Bain Ultra Air Tub & Walk-in Shower. Fully air-conditioned sunroom features beamed ceiling, fireplace, and pool bath; air conditioned 3 car oversized garage has gated motor court. Elevator' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Stacey Fine Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 6 BLK 53 TANGLEWOOD SEC 11' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '14250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Tanglewood Sec 11' ,`TaxAmount` = '69942' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710508' WHERE `Matrix_Unique_ID` = '212848720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:18:51.423' ,`MLSNumber` = '57064715' ,`ListAgentFullName` = 'Kimberly Orbison' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813643' ,`Longitude` = '-94.996817' ,`PhotoCount` = '43' ,`PostalCode` = '77521' ,`RoomCount` = '11' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Bearberry' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! LOW TAX RATE! ONE YEAR HOME WARRANTY! OVER QUARTER ACRE LOT! This 2 Story 4 Bedroom 3.5 Bath home sits on over a quarter acre lot, no back neighbors, perfect for a pool, already has She Shed or Workshop what ever you choose equipped with electric, and the home is located in a cul-de-sac. Some of its features are granite countertops in the kitchen and primary bathroom, soaking tub, with separate shower, walk in closet, designer cabinets, gas fireplace, crown molding, private utility room, 2nd floor bonus room with a private balcony, and a private covered 18x7 patio in the oversized backyard. This is a must see!! The kitchen is an open concept with a breakfast bar/eat in kitchen with pantry, and a Formal Dining Room for entertainment or the holidays. Refrigerator is included!' ,`Acres` = '0.2722' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 BAY RIVER COLONY SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '11858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay River Colony Sec 10' ,`TaxAmount` = '7382' ,`TaxRate` = '2.705' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710508' WHERE `Matrix_Unique_ID` = '212872098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:42:41.210' ,`MLSNumber` = '36399189' ,`ListAgentFullName` = 'Lindsey Williams' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770725' ,`Longitude` = '-95.853807' ,`PhotoCount` = '17' ,`PostalCode` = '77494' ,`RoomCount` = '6' ,`ListPrice` = '630000.00' ,`Status` = 'Active' ,`StreetName` = 'Round Moon' ,`StreetNumber` = '27915' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 29715 Round Moon Lane built by Westin Homes. This gorgeous home built in 2020 has been newly upgraded. As you enter you are greeted by high rotunda ceilings in the grand foyer with a winding staircase. The abundance of natural light really highlights the homes features like the oversized kitchen island including quartz counter tops, luxurious light fixtures, and stainless steel appliances. The primary bedroom downstairs features a spacious walk-in closet with custom built-in cabinets throughout. Upstairs presents an en suite guest bedroom with a private bathroom and a size-able game room leading to a media room with custom shelving. Unwind after a long day in your large covered patio with a newly installed outdoor kitchen and gas fireplace, perfect for entertaining! No direct back neighbors! You don\'t want to miss this one!' ,`Acres` = '0.194' ,`Area` = '36' ,`BuilderName` = 'Westin' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRAILS OF KATY SEC 4, BLOCK 4, LOT 39' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Trails Of Katy' ,`TaxAmount` = '7650' ,`TaxRate` = '3.2845' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710508' WHERE `Matrix_Unique_ID` = '212882775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:46:09.937' ,`MLSNumber` = '49642441' ,`ListAgentFullName` = 'Reda Martin' ,`ListOfficeName` = 'Claridge Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764169' ,`Longitude` = '-95.552069' ,`PhotoCount` = '6' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '2600000.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial Parkview' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '4685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! Award-Winning Jeff Paul Custom Homes has created this Buckingham masterpiece which offers a great opportunity to live in the beautiful, gated Memorial Green community located in Memorial West near I-10, Beltway 8 and the Energy Corridor, near restaurants, shopping, beauty salons, etc. Wolf Range and side-by-side Sub-Zero fridge in large kitchen which opens into dining and living area with gas/wood-burning fireplace, overlooking courtyard and patio with outdoor kitchen. High ceilings, oak-engineered wood flooring throughout, outstanding primary bedroom with beautifully-designed dressing room of mirrored, armoire-style closets. Third floor offers game room with wet bar and large storage/exercise room Third-level terrace has a lovely view of the community park and reflection pool. This home has been upgraded with many additional high-end features. Elevator and generator installed. Construction was completed on 9/30, and it is ready for immediate occupancy.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Jeff Paul Custom Hom' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 MEMORIAL GREEN SEC 2 R/P & EXTH' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3993' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710508' WHERE `Matrix_Unique_ID` = '212888187' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:51:22.993' ,`MLSNumber` = '63896457' ,`ListAgentFullName` = 'Joshua Staats' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520272' ,`Longitude` = '-95.559941' ,`PhotoCount` = '48' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '589900.00' ,`Status` = 'Active' ,`StreetName` = 'Bears Path' ,`StreetNumber` = '6818' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in a convenient part of Sienna, this 4,165sqft home sits on an oversized lot with plenty of outdoor space. The love that went into maintaining this home is evident the moment you enter. The high ceilings provide feelings of grandeur while the engineered hardwood flooring creates a warm and inviting atmosphere. The first level is home to your study, formal dining, living room, and chef\'s kitchen with an entertaining island w/prep sink. The primary bedroom located off the living room boasts an owner\'s retreat with dual vanities and a spacious walk-in closet. The second level is home to additional bedrooms, bathrooms, and a media room ready for authentic movie nights! The two-car garage houses a \"Texas Basement”, large storage space, or garage workshop. Sienna is home to sprawling parks, lakes, and trails designed with you in mind. Proximity to Hwy 6 and the Fort Bend Tollway makes commuting a breeze. What are you waiting for? Phone the listing agent for your private tour today!' ,`Acres` = '0.3271' ,`Area` = '38' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF ANDERSON SPRINGS SEC 26-A, BLOCK 1, LOT 22' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCHIFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Anderson Spgs Sec 26-A' ,`TaxAmount` = '11735' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710508' WHERE `Matrix_Unique_ID` = '212891574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:35:46.833' ,`MLSNumber` = '3005597' ,`ListAgentFullName` = 'Bian Hu' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578215' ,`Longitude` = '-95.600715' ,`PhotoCount` = '11' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Fields' ,`StreetNumber` = '3331' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Cozy home in the heart of Sugar Land; Walking distance to elementary school, community pool and tennis court; Walking distance to shopping center such as 99 Ranch!' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS PARK SEC 2, BLOCK 13, LOT 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '0' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '498' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SETTLERS PARK SEC 2' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710508' WHERE `Matrix_Unique_ID` = '212917983' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:39:47.430' ,`MLSNumber` = '67163198' ,`ListAgentFullName` = 'John Green' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.574270' ,`Longitude` = '-96.229755' ,`PhotoCount` = '31' ,`PostalCode` = '77845' ,`RoomCount` = '7' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Moses Creek' ,`StreetNumber` = '2002' ,`StreetSuffix` = 'Court' ,`City` = 'College Station' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you have always wanted a quality built home on 1.0 acres with a pool, this is the house for you. This country retreat in Williams Creek offers a WOW entrance with vaulted ceilings in the living room, pine woodwork, exposed beams and a large stone fireplace. Four bedrooms and four bathrooms gives everyone the space and privacy they desire. The country kitchen offers quality appliances, an island and also offers some privacy from the living room. The home features wood floors in the living room, solar screens and 2\" blinds throughout. The master bathroom offers a jetted tub and walk in closets. The large laundry room includes a sink, granite counter tops and lots of storage. The beautiful outdoor pool and covered patio lead to a large lot with mature shade trees to complete your private hideaway. The roof was replaced in March 2022, the AC in 2019 and the home interior was repainted two years ago. Client request a leaseback thru December 7th.' ,`Acres` = '1.01' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Williams Creek Ph 1, Block 2, Lot 10, acres 1.016' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '44256' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'PEBBLE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'A & M CONSOLIDATED MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Creek' ,`TaxAmount` = '11739' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710509' WHERE `Matrix_Unique_ID` = '212921010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:48:38.577' ,`MLSNumber` = '98700740' ,`ListAgentFullName` = 'Chinonso Ochi-Okorie' ,`ListOfficeName` = 'The Goldstein Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676424' ,`Longitude` = '-95.361256' ,`PhotoCount` = '48' ,`PostalCode` = '77051' ,`RoomCount` = '8' ,`ListPrice` = '564882.00' ,`Status` = 'Active' ,`StreetName` = 'Vera Lou' ,`StreetNumber` = '1122' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*COMPLETED 9/23/22*Deed restricted Brookhaven sub(NO NEW MULTI-FAMILY DEV ALLOWED). An ideal location near med center, Dwntwn Houston,& Galleria. 4 bed 3 bath home w/2 rooms on the 1st floor w/ huge 2nd floor den on 14k sqft lot ready for pool/spa/pool house in the back yard for Airbnb. Home features: Open concept floor plan, brick/stone elevation, int/ext LED lighting pkg, 3x LED fireplaces, pre-wire for solar/EV charging, pre wired for int 5.1 surround sound & ext speakers, quartz counter tops w/waterfall, stainless steel appliances, spray foam insulation, custom cabinets w/glass soft close doors w/smart LED lighting, apron sink, pot filler, 8 ft Iron front door, 8ft int doors, architectural fence w/wrought iron gate, remote security system & camera\'s, stained hardwood ceilings in patio/porch, & much more. Attached features and amenities pdf list uploaded to har. Close to restaurants, bus stops, & brand new H-E-B grocery store. NO HOA NO MUD NOT IN A FLOOD ZONE. Measurements apprx.' ,`Acres` = '0.3085' ,`Area` = '3' ,`BuilderName` = 'GENERATIONAL HOME' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6 & 7A BLK F BROOKHAVEN R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brookhaven R/P' ,`TaxAmount` = '819' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710509' WHERE `Matrix_Unique_ID` = '212928701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:10:34.100' ,`MLSNumber` = '90713537' ,`ListAgentFullName` = 'Safa Kharsa' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860675' ,`Longitude` = '-95.424522' ,`PhotoCount` = '29' ,`PostalCode` = '77091' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Utah' ,`StreetNumber` = '6723' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an affordable home that doesn\'t feel like a box? This is the house for you! Designer finishes, 14.5\' tall vaulted ceilings, 12\' long butcherblock kitchen island, LED lighting, barn door, stainless steel appliances, modern tile, and soft close drawers/ doors! 3 bedrooms, 2.5 baths plus an attached 1 car garage. Beautifully landscaped front and back yards! Get in on the Acres Homes boom before it\'s too late. Many lots on this same street are under development!' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Green Tech Houses' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 17 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '420' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710509' WHERE `Matrix_Unique_ID` = '212962956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:49:10.193' ,`MLSNumber` = '17257886' ,`ListAgentFullName` = 'Eleni Brooks' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.912166' ,`Longitude` = '-95.639840' ,`PhotoCount` = '36' ,`PostalCode` = '77095' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Hudson Bend' ,`StreetNumber` = '9314' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPACE! SPACE! SPACE! This beautiful home boasts 5 bedrooms and 3 1/2 bathrooms. All your living spaces and the primary bedroom are on the first floor. FOUR secondary bedrooms, 2 full baths and a MASSIVE game room are on the 2nd flood. Easy to navigate with 2 staircases. Hard surface floors throughout. The home sits on a 13,500 square foot lot. This is an AS-IS sale. No repairs will be made.' ,`Acres` = '0.3099' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 1 COPPER GROVE SEC 6 AMENDED' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '872' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Grove Sec 06 Amd' ,`TaxAmount` = '7064' ,`TaxRate` = '2.441' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710509' WHERE `Matrix_Unique_ID` = '212972018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:41:08.033' ,`MLSNumber` = '49060699' ,`ListAgentFullName` = 'Ordetralynn Thompson' ,`ListOfficeName` = 'Get Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098924' ,`Longitude` = '-95.186817' ,`PhotoCount` = '21' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '344000.00' ,`Status` = 'Active' ,`StreetName` = 'Arcola Landing' ,`StreetNumber` = '4412' ,`StreetSuffix` = 'Court' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t skip over this listing!! This immaculate, cozy 2 story smart home relaxes in a cul-de-sac with amazing curb appeal! The irrigation system will definitely keep your front and back yard hydrated during those steamy hot summer days. There are also in/outdoor security cameras throughout the home. Enjoy reading a book, checking emails or having a great conversation under the covered front porch or back patio. The 1st floor is home of the primary bedroom with an en suite bathroom, private toilet enclosure, dual vanities, walk in closet, separate bath/shower. Introducing the 2nd floor, this floor is home to 2 bedrooms and a fun size game room for kids play and family bonding. Last but not least. Complete with a gourmet kitchen, astonishing granite counter tops, adjoining breakfast nook, walk-in pantry and wood cabinetry, this kitchen is the stunning center piece of the home. There\'s also plenty of cabinet space for added storage and a full suite of energy-efficient appliances.' ,`Acres` = '0.146258' ,`Area` = '40' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S349205 - Country Colony 05, BLOCK 1, Lot 24' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Colony' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710509' WHERE `Matrix_Unique_ID` = '212982619' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:10:06.723' ,`MLSNumber` = '71151002' ,`ListAgentFullName` = 'Safa Kharsa' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860675' ,`Longitude` = '-95.424522' ,`PhotoCount` = '28' ,`PostalCode` = '77091' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Utah' ,`StreetNumber` = '6721' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an affordable home that doesn\'t feel like a box? This is the house for you! Designer finishes, 14.5\' tall vaulted ceilings, 12\' long butcherblock kitchen island, LED lighting, barn door, stainless steel appliances, modern tile, and soft close drawers/ doors! 3 bedrooms, 2.5 baths plus an attached 1 car garage. Beautifully landscaped front and back yards! Get in on the Acres Homes boom before it\'s too late. Many lots on this same street are under development!' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Green Tech Houses' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 17 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '420' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710510' WHERE `Matrix_Unique_ID` = '212998987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:49:45.843' ,`MLSNumber` = '93145172' ,`ListAgentFullName` = 'Swapna Patel' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835783' ,`Longitude` = '-95.552232' ,`PhotoCount` = '37' ,`PostalCode` = '77041' ,`RoomCount` = '3' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Glen' ,`StreetNumber` = '10507' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is it! Location, Location, Location! Just minutes from the beltway, I-10 and more! This home has been lovingly remodeled and is ready for you to call home. New roof, new wood and tile flooring, new courtyard and driveway section, fresh paint, re-glazed windows, new appliances, and so much more! This wonderful home offers a light and bright layout with so much charm! The home wraps around a courtyard that is large enough to have outdoor living, dining and play area! The living room offers high ceilings, fireplace, wood floors and more. The kitchen is a dream with granite counters, upgraded tile, designer back-splash, and new appliances. Whip up great meals in this space! The large en-suite master has French doors that leads out to the courtyard and features wood floors, fresh paint, large closets. The secondary bedrooms feature great space, large closets, and bright light. Both bathrooms are elegantly renovated. This home has it all! Welcome home! This home did not flood!' ,`Acres` = '0.1625' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 WESTBRANCH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '271' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Westbranch Sec 01' ,`TaxAmount` = '5892' ,`TaxRate` = '2.5842' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710510' WHERE `Matrix_Unique_ID` = '213000354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:49:47.290' ,`MLSNumber` = '94857184' ,`ListAgentFullName` = 'Marina Gaitan' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.865615' ,`Longitude` = '-95.732521' ,`PhotoCount` = '8' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Haven' ,`StreetNumber` = '21039' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter home in a prime Katy location close to schools shopping and restaurants. Zoned to highly acclaimed Cy-Fair ISD. The primary room has an ensuite bath with tub and separate shower and a large closet. Secondary bedrooms are all well sized and also feature great closet space. Resent inside paint and wood finished vinyl throughout the house. The huge backyard is fully fenced.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7262' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village' ,`TaxAmount` = '4964' ,`TaxRate` = '6.44' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710510' WHERE `Matrix_Unique_ID` = '213012633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:40:28.680' ,`MLSNumber` = '3190241' ,`ListAgentFullName` = 'Sandy Swensen' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = 'Roxanne Sarver' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.256805' ,`Longitude` = '-95.524781' ,`PhotoCount` = '49' ,`PostalCode` = '77384' ,`RoomCount` = '4' ,`ListPrice` = '335000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Emory Peak' ,`StreetNumber` = '14133' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find in Fosters Ridge 55+ gated community! From the gorgeous curb appeal to the screened in back patio, this beautiful all brick one story will not disappoint! 2 Bedrooms, plus Study (could be 3rd BR), split floor plan and open concept. Upgrades include wood-look tile flooring, barn doors, granite counters, SS appliances, crown molding, pendant lights, speakers/sound system throughout, motorized shades, Huge walk-in shower with bench seat, walk-in closets, tiled Sun Room, extended patio, lovely landscaping, pebble-tech flooring in garage. Refrigerator, washer and dryer included. All this, plus a phenomenal location - Gated, quiet and quaint Juniper Ridge section with it\'s own private clubhouse and pickleball court, only one block away, along with access to Fosters Ridge pool and clubhouse. Convenient and close to dining, shopping and entertainment, this Gem is truly a wonderful place to call home!' ,`Acres` = '0.1828' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S516409 - FOSTERS RIDGE 09, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7963' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 09' ,`TaxAmount` = '7608' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710510' WHERE `Matrix_Unique_ID` = '213016420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:52:00.720' ,`MLSNumber` = '51457492' ,`ListAgentFullName` = 'Sara Hall-Narvacan' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.585387' ,`Longitude` = '-95.598160' ,`PhotoCount` = '38' ,`PostalCode` = '77479' ,`RoomCount` = '5' ,`ListPrice` = '305500.00' ,`Status` = 'Active' ,`StreetName` = 'Frontier' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY! Charming one story refreshed home in First Colony. In the heart of Sugar Land with quick access to Highway 6, 59, and First Colony Mall. Zoned to top rated Fort Bend ISD schools - Clements High School. Spacious with 3 bedrooms and 2 baths. House is light and bright. Foundation repair with transferrable lifetime warranty. Never flooded. Refrigerator included. This is only the second owner and has been meticulously maintained. This house won\'t last long! What are you waiting for? Schedule your showing now!' ,`Acres` = '0.145' ,`Area` = '29' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS PARK SEC 1, BLOCK 4, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '498' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Settlers Park Sec 1' ,`TaxAmount` = '5161' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710510' WHERE `Matrix_Unique_ID` = '213042440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:22:54.943' ,`MLSNumber` = '93223869' ,`ListAgentFullName` = 'Velvet Harris' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.087645' ,`Longitude` = '-95.362712' ,`PhotoCount` = '50' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '975000.00' ,`Status` = 'Active' ,`StreetName` = 'Moriah' ,`StreetNumber` = '4102' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious describes this beautiful Tuscan look home. Wood & tile flooring throughout the first floor. With tall ceilings, crown moulding & 5\" baseboards. Formal living and dining areas plus separate study with glass French doors. Primary bedroom is tucked away with plenty of space for sitting area & private door to the patio. Ensuite bath includes his/hers closets with built ins, double vanities & soaking tub, along with large walk in shower. Enjoy the beautiful island kitchen with stained cabinets, vegetable sink & recent dual fuel stove with gas cook top. There\'s a 2nd stove built in, along with recently installed microwave & dishwasher. Walk in pantry will hold it all! Open to kitchen is family room with built ins & great views of the backyard. Also downstairs there is one extra bedroom and another full bath. Upstairs is the large gameroom, plus 2 more bedrooms & 2 more full baths. The back covered patio has an outdoor kitchen and slate tile flooring. All this on one acre lot!' ,`Acres` = '1.1087' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENDERS LANDING 02, BLOCK 11, LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '48297' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '920' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Benders Landing 02' ,`TaxAmount` = '12114' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710510' WHERE `Matrix_Unique_ID` = '213067766' --> 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','213079737','1664710511','213079737','2022-10-01T20:52:40.010','48303471','Tiare Duren','Keller Williams Signature','','','29.970908','-95.222879','49','77396','6','315000.00','Active','Trinity Joe','3107','Lane','Humble','2','1','4','2454','Single-Family','Be amazed by this fantastic 4 - Bedroom, 2.5 - bathroom home in Blackstone Creek. Featuring high ceiling in living room, game room. Beautiful remodel kitchen and great room. The game room overlooks the living room area. Primary bedroom downstairs, upstairs you\'ll find 3 bedrooms, a game room area, full bath, and laundry room. Lot with oversize backyard, the backyard includes a large deck, a new storage deck and a ground basketball goal. New A/C Unit and damper. Don\'t miss your chance to see this Gem!','0.2326','1','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Mock Fireplace','1','Humble Area East','Central Gas','0','LT 9 BLK 4 BLACKSTONE CREEK SEC 1','Cul-De-Sac,Subdivision Lot','10134','Appraisal District','','','0','','2','','0','','','','','Composition','29 - Humble','RIVER PINES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment','Appraisal District','2','Traditional','Blackstone Crk Sec 1','5977','2.933','Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:15:43.187' ,`MLSNumber` = '71753074' ,`ListAgentFullName` = 'Lina Botero' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906570' ,`Longitude` = '-95.717149' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '469700.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Horizon' ,`StreetNumber` = '8839' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL HOME ON EXTRA LARGE LOT OF 14,186 SQFT-MOVE IN READY HOME-Zoned to acclaimed CY-FAIR SCHOOLS & LOADED with must have UPGRADES, soaring ceilings, recess lights, engineering flooring (EVP) downstairs, Open concept kitchen; granite counter tops, designed backsplash & Island seating, dining & Family room. Primary suite down; MOTHER IN LAW SUITE, COLLEGE STUDENT OR GUESTS SUITE (Down), full bath down, wrought iron spindle, gameroom up, SUITE WITH PRIVATE BATHROOM (up). SMART LOCK, TANKLESS WATER HEATER, REVERSE OSMOSIS WATER SYSTEM, WATER SOFTENER-ALL INCLUDED, jellyfish-outdoor lighting INCLUDED, wrap around gutters, French drain, Covered patio w/ ceiling fan & extended flooring. BIG lot with enough room for a pool. -Amenities; Pool, walking trails, playground, recreation center, tennis, sand volleyball, dog park; access to Jr. Olympic Pools, basketball pavilion, exercise room, it has a lot to offer. CHECK OUT THE PHOTOS DESCRIPTION FOR ADDITIONAL INFO. Great place to call HOME.' ,`Acres` = '0.3257' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 MIRAMESA SEC 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '14186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Miramesa Sec 5' ,`TaxAmount` = '10119' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710511' WHERE `Matrix_Unique_ID` = '213084293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:15:17.837' ,`MLSNumber` = '77860450' ,`ListAgentFullName` = 'Shary Luthe' ,`ListOfficeName` = 'Home Sweet Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.700169' ,`Longitude` = '-95.031636' ,`PhotoCount` = '40' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo' ,`StreetNumber` = '515' ,`StreetSuffix` = 'Court' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERVIEW Home Overlooking The Open Waters Of Lake Livingston. This Home Boasts Nearly A Half Acre Lot Creating Plenty Of Space Around You! Enjoy The Amazing Views From The Oversized Primary Retreat Upstairs! By Oversized- It Is HUGE With A Wall Of Windows Overlooking The Lake! Take A Swim In Your Private Inground Pool With Rock Waterfalls And Hot Tub In Your Own Tropical Oasis Backyard! The Home Features 3 Bedrooms/3 Full Bathrooms And A 2 Car Garage. WOW- WHAT A GREAT PRICE FOR A WATERVIEW HOME WITH INGROUND POOL- WON\'T LAST LONG! BRING YOUR OFFERS! Come Make This One Your Own Today!' ,`Acres` = '0.4021' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TEXAS LANDING LOT 100' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '17514' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas Landing' ,`TaxAmount` = '4670' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710511' WHERE `Matrix_Unique_ID` = '213089957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:42:07.920' ,`MLSNumber` = '79305718' ,`ListAgentFullName` = 'Shannon Hossfield' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.392012' ,`Longitude` = '-94.913168' ,`PhotoCount` = '15' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '138000.00' ,`Status` = 'Active' ,`StreetName` = '13th' ,`StreetNumber` = '706' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This large corner lot features mature trees, beautiful foliage, and a charming covered front porch. In addition to a fresh coat of paint to the entire interior and exterior of the home, you will also enjoy NEW floors and an updated kitchen! Relax in the cool shade of the covered back patio and backyard banana trees for a tropical feel. This home is close to parks and schools, and a short drive to NASA and Galveston. Come see it today!' ,`Acres` = '0.1722' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 J WELLS SUR LOT 73 SNUG HARBOR' ,`LotDesciption` = 'Corner' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'KOHFELDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Snug Harbor' ,`TaxAmount` = '1773' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710511' WHERE `Matrix_Unique_ID` = '213092161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:22:48.093' ,`MLSNumber` = '46117027' ,`ListAgentFullName` = 'Travis Bonning' ,`ListOfficeName` = 'Bonning Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019165' ,`Longitude` = '-95.745068' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Cameo Rose' ,`StreetNumber` = '20623' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2733' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautifully updated home in sought after Fairfield. You will be greeted with charm the moment you walk in. The home features an open floor plan with a cozy home office, space for entertaining and lots of natural light. The back patio provides plenty of space for seating and grilling and all landscaping has been recently updated. You will fall in love the moment you walk through the door!' ,`Acres` = '0.2378' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 FAIRFIELD VILLAGE NORTH SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10358' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '930' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Fairfield Village North Sec 7' ,`TaxAmount` = '9284' ,`TaxRate` = '2.611' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710511' WHERE `Matrix_Unique_ID` = '213097213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:53:36.403' ,`MLSNumber` = '42518866' ,`ListAgentFullName` = 'Deborah Villarreal' ,`ListOfficeName` = 'Deborah Villarreal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.650949' ,`Longitude` = '-95.485292' ,`PhotoCount` = '9' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Cartagena' ,`StreetNumber` = '5635' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated one story home. An updated dining area greets you at the entry. The backyard is peaceful with no rear neighbors.' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Short Sale' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 64 WESTBURY SEC 3 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03 R/P' ,`TaxAmount` = '6147' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710511' WHERE `Matrix_Unique_ID` = '213104372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:52:35.710' ,`MLSNumber` = '35013218' ,`ListAgentFullName` = 'Juliana Gonzalez' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = 'Yadira Cruz' ,`SellingOfficeName` = 'CR Elite Realty' ,`Latitude` = '30.045567' ,`Longitude` = '-95.341614' ,`PhotoCount` = '16' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '228000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Millgate' ,`StreetNumber` = '22851' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 1-story home on corner lot located in the established neighborhood of Postwood. This home features a large living room, formal dining, kitchen, fireplace and tile throughout entire home. Spacious backyard with above ground pool and covered patio perfect for entertaining. Garage has been converted into two additional bonus rooms. Roof only one year old. Quick access to shopping, dining, IAH, Mercer Arboretum, I45, Hardy Toll Rd, & Cypresswood Golf Course. This is a great home, come take a look!' ,`Acres` = '0.1567' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 6 POST WOOD SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Wood' ,`TaxAmount` = '5535' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710512' WHERE `Matrix_Unique_ID` = '213114212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T21:02:49.263' ,`MLSNumber` = '72421822' ,`ListAgentFullName` = 'Thomas Caine' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085977' ,`Longitude` = '-95.776587' ,`PhotoCount` = '17' ,`PostalCode` = '77447' ,`RoomCount` = '3' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Steel Blue Jaybird' ,`StreetNumber` = '22606' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Beatifully remodeld, spacious 3 bedroom higly sought after Bauer Landing. Literally the best value and lowest price in the neighborhood so this one won\'t last long. New LVT flooring in living area, Granite countertops in kitchen and stainless steel appliances. Bathrooms feature new faucets and fixtures, fresh paint and brand new frieze carpet.' ,`Acres` = '0.1159' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 BAUER LANDING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bauer Lndg Sec 5' ,`TaxAmount` = '5975' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710512' WHERE `Matrix_Unique_ID` = '213126255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:06:53.880' ,`MLSNumber` = '7563688' ,`ListAgentFullName` = 'James Phillips' ,`ListOfficeName` = 'Phillips & Sons Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638970' ,`Longitude` = '-95.353303' ,`PhotoCount` = '16' ,`PostalCode` = '77048' ,`RoomCount` = '7' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Roandale' ,`StreetNumber` = '11014' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF & NEW DECKING, RECENTLY PAINTED, INTERIOR & EXTERIOR , NEW CARPET AND FLOORING, NEW GAS FURNACE.' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'N 17 FT OF LT 4 & S 38 FT OF LT 5 BLK 2 CRESTMONT PLAZA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crestmont Plaza' ,`TaxAmount` = '2397' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710512' WHERE `Matrix_Unique_ID` = '213127459' --> 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','213193824','1664710512','213193824','2022-10-01T20:19:25.463','62564256','Marian Brown','Red Door Realty & Associates','','','30.056940','-95.222716','39','77339','8','309000.00','Active','Shadow Rock','1955','Drive','Kingwood','2','0','3','1888','Single-Family','This fabulous home will knock your socks off! The WOW factor runs throughout! From the beautiful hardwood floors to the pass through gaslog fireplace as you enter, to the built-in breakfast room benches with lighted wine storage underneath, to the exquisite primary bedroom ensuite, to the gorgeous wall trim, to the outdoor firepit, this home will not disappoint. Check out the shelving in the kitchen...amazing! Brand new roof, gorgeous landscaping, ideal location for entrance and exit out of Kingwood and all that Kingwood has to offer. A must see to appreciate all that has been done to this gem!','0.1833','32','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Kingwood West','Central Gas','1','LT 21 BLK 26 WOODLAND HILLS VLG SEC 1 R/P','In Golf Course Community,Subdivision Lot,Wooded','7986','Appraisal District','','400','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','29 - Humble','WOODLAND HILLS ELEMENTARY SCHOOL','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Appointment Required,Call Occupant,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Woodland Hills Village Sec 01','4546','2.5839','Public Sewer,Public Water','1975','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T20:28:01.083' ,`MLSNumber` = '58621296' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.574905' ,`Longitude` = '-95.063843' ,`PhotoCount` = '29' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '529500.00' ,`Status` = 'Active' ,`StreetName` = 'Highknoll' ,`StreetNumber` = '4115' ,`StreetSuffix` = 'Lane' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 5 bed/3.5 bath two-story home with 3 car garage and garage apartment on a 1/3 acre cul-de-sac lot with many kids and young families. Tastefully renovated home from plumbing to new roof. Hidden bonus Media/Playroom upstairs. Oversized bedrooms throughout with an ensuite area in the Master Bedroom. Beautiful kitchen with cabinets galore and wine refrigerator ready for dinner parties.\r\n\r\nUpgrades include: Roof, Gutters, Windows, HVAC (with UV light), Tankless Water Heater, Flooring, Hardi siding, storage shed, and fully renovated Garage Apartment. \r\nArea Amenities: Quick interstate access, major shopping areas, restaurants, and tourist attractions. Parks and water everywhere you turn.\r\n\r\nNeighborhood Highlights: Elementary School, Family-friendly, Park for fishing, kayaking, tennis, and other recreation, 2 Pools, active HOA, and neighborhood social clubs.' ,`Acres` = '0.3365' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 8 CLEAR LAKE FOREST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14659' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Clear Lake Forest' ,`TaxAmount` = '8477' ,`TaxRate` = '2.279' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710512' WHERE `Matrix_Unique_ID` = '213205461' --> 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','213207993','1664710512','213207993','2022-10-01T20:11:14.613','16805488','Yan Liu','KingFay Inc','Bian Hu','KingFay Inc','29.704832','-95.799230','17','77494','5','450000.00','Option Pending','Gillside Manor','24206','','Katy','3','1','5','2560','Single-Family','','','36','','','','','Mud','','','','Katy - Southwest','Central Gas','1','Cinco Ranch Southwest Sec 41, Block 1, Lot 3','Cul-De-Sac','9374','Appraisal District','','1200','0','','2','','0','','','','','Composition','30 - Katy','WILSON ELEMENTARY SCHOOL (KATY)','SEVEN LAKES HIGH SCHOOL','SEVEN LAKES JUNIOR HIGH SCHOOL','Appointment Required','Appraisal','2','Traditional','Cinco Ranch Southwest','','','Water District','2010','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213208749','1664710512','213208749','2022-10-01T21:40:13.097','76423827','William Shaddock','eXp Realty, LLC','','','29.692861','-95.251525','5','77017','6','150000.00','Active','Michael','4822','Drive','Houston','1','0','3','1145','Single-Family','NO SHOWINGS UNTIL OPEN HOUSE Sat Oct. 15th and Sun Oct 16th/ Home being sold EXCLUSIVELY through the ShaddockOnlineOffers Platform ALL THE INFORMATION AND DETAILED INSTRUCTIONS YOU NEED are uploaded in the MLS in the PUBLIC DOCUMENTS. Please review all the documents that have been made available. If interested, you can easily register TO SUBMIT AN OFFER for access to the ONLINE OFFERS platform GO TO ShaddockOnlineOffers. MEGA OPEN HOUSE SCHEDULED 1-6pm SAT 10/15 AND SUN 10/16 !! ON OFFER is a very rare opportunity in the 77017 zip code! Appliances included (stove, microwave, washer and dryer) ,NEVER FLOODED, New Floors! New Paint and Lighting, New A/C, New Lifetime transferable foundation Repair,Pressure test after, Recent Roof, Recent Windows and siding, Recent Driveway, New Washer/Dryer and appliances included! Super quick access to Gulf-freeway and 10 mins to HOBBY AIRPORT!! CMA sees value @ $207.57/sq/ft or $237,668.00!! Check Documents for CMA.','0.189','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Hobby Area','Central Electric','0','LT 6 BLK 26 OAK MEADOWS SEC 1','Subdivision Lot','8232','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','27 - Houston','RUCKER ELEMENTARY SCHOOL','CHAVEZ HIGH SCHOOL','STEVENSON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Ranch','Oak Meadows Sec 01','3027','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213209107','1664710512','213209107','2022-10-01T20:54:35.107','88196713','Diane Moss','BHGRE Gary Greene','','','30.101422','-95.350296','30','77386','10','635000.00','Active','Emerald','28295','Bend','Spring','3','0','4','3098','Single-Family','Picture yourself coming home to this lovely home, walking straight to the back of the house, sliding the doors open and sitting on the extended patio with your favorite beverage in hand relaxing to the sound of the lake\'s fountains right in your view. It\'s time to come back inside to continue your relaxation, turn on the fireplace. All sparkle and no heat. Just ambiance. This very lightly lived-in home has 2 bedrooms down, an office and a kitchen island. Upstairs with 2 more bedrooms, a bath and game room. All this in the lovely master planned community of Woodson\'s Reserve. Plenty of shopping and restaurants, close to schools, and a short ride to the Grand Parkway and to the Hardy Toll Road and 45. Stop by and take a look. Professional Photos will be uploaded on Tuesday. Photographer got sick and we had to reschedule. Pardon my amature shots.','0.1818','40','Toll Brothers','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Northeast','Central Gas','1','S973716 - WOODSON\'S RESERVE 16, BLOCK 1, LOT 8','Subdivision Lot,Water View,Waterfront','7920','Appraisal District','','1335','0','','2','','0','','','Gas Cooktop','','Composition','11 - Conroe','ANN K. SNYDER ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Woodsons Reserve 16','2324','3.0987','Water District','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213209257','1664710512','213209257','2022-10-01T20:14:44.150','23387517','Skyler Rogers','Houston Home Store LLC','','','29.695097','-95.168961','0','77503','6','185000.00','Active','Tanglebriar','3101','Drive','Pasadena','1','0','3','1056','Single-Family','Welcome Home! Upon entering you will find everything has been completely updated. \r\nNew fixtures, flooring, bathroom and more. \r\nLocated near Beltway 8 and HWY 225 for an easy commute to any destination.\r\nProviding a back yard perfect for a pool, shed and a play set.','0.1722','6','','','','','Sellers Disclosure','','','','Pasadena','Central Gas','0','LT 22 BLK 3 TANGLEBRIAR SEC 1','Subdivision Lot','7500','Appraisal District','','','0','','1','','0','','','','','Composition','41 - Pasadena','MCMASTERS ELEMENTARY SCHOOL','SAM RAYBURN HIGH SCHOOL','SANJACINTO INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Tanglebriar Sec 01','3458','2.6514','Public Water','1955','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213209641','1664710512','213209641','2022-10-01T21:36:47.163','50800005','Andrew Codia','Ameri Choice Realty, LLC','','','29.696950','-95.800820','12','77406','8','435000.00','Active','Barazzieh','12018','Court','Richmond','2','1','4','2308','Single-Family','This property is built by Perry Homes. Few minutes to Galleria and Houston Downtown via West Park Toll Rd. Easy access to West Park Toll Rd, Hwy 99, I-10 and Hwy 59. House feature 4 bedrooms, 2.5 bath, 2 car garage, wood looking tile in area except the rooms, high ceiling, 42\" cabinet, 2 separate vanity sink, separate shower, and sprinkler system front and back.','0.1494','37','','','','','Sellers Disclosure','','','','Fort Bend County North/Richmond','Central Gas','1','LAKES OF BELLA TERRA WEST SEC 3, BLOCK 1, LOT 71','Subdivision Lot','6507','Appraisal District','','925','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','HUBENAK ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lakes Of Bella Terra West Sec 3','9351','3.0848','Public Sewer,Public Water,Water District','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213209871','1664710512','213209871','2022-10-01T21:21:33.527','40741625','David Moosavi','Rose Above Realty','','','28.950137','-95.365088','13','77541','7','135000.00','Active','7th','1319','Street','Freeport','1','0','2','1112','Single-Family','This cute home in a quiet neighborhood is ready to make your own. There is an extra room that could be converted into another bedroom. The nice sized backyard has a large gate so you can park under the carport. Don\'t miss this opportunity!','0.1607','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','','Freeport','Central Gas','0','FREEPORT, BLOCK 139, LOT 4','Cleared','7000','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Freeport','2412','2.5981','Public Sewer,Public Water,Water District','1944','Appraisal District'); --> New record created successfully