Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:27:12.147' ,`MLSNumber` = '3639083' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Charlotte Oldbury' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.828741' ,`Longitude` = '-94.990996' ,`PhotoCount` = '11' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '349386.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wild Flora' ,`StreetNumber` = '4442' ,`StreetSuffix` = 'Way' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This lovely Beazer Home in the tranquil community of Ashbel Cove is what you’re looking for, complete with a brick façade, wrought iron spindles, a fireplace, pendant lighting in the kitchen, and an open great room. Located off I-10 and Hwy 90, residents love the close proximity to popular dining, shopping, and entertainment in the Greater Houston area. The tranquil Ashbel Cove community amenities include a park, serene lakes, and walking trails. Schools in the area are zoned to Goose Creek CISD. Don’t miss your chance – call today to book your private showing!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700238' WHERE `Matrix_Unique_ID` = '200520297' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:50:48.960' ,`MLSNumber` = '13760286' ,`ListAgentFullName` = 'Mel Reyna' ,`ListOfficeName` = 'The Reyna Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829041' ,`Longitude` = '-95.435349' ,`PhotoCount` = '38' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '1475000.00' ,`Status` = 'Active' ,`StreetName` = 'Overhill' ,`StreetNumber` = '1417' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Oak Forest & zoned to Oak Forest Elementary School, this New Construction by Wood Custom Homes offers 4/5 beds, 5 Baths, 1st Floor Study, 2nd Floor Game Room w/ Balcony, Over-sized Garage w/ electric car outlet & workspace, Outdoor Kitchen, Temp controlled wine room & loaded w/ high-end finishes through out! Interior features include White Oak wood floors, Jeldwen widows, LED recessed lighting, Designer selected light fixtures & 8\' solid core doors. Chef\'s Kitchen offers a Large island w/ quartz/marble counter tops, Custom site-built cabinetry w/ glass fronts, Wolf/Sub Zero appliances, Panel-front Fridge & pot filler. Primary Suite features a Free standing tub, Separate walk-in shower, dual sinks & an Expansive Primary walk-in closet w/ custom built wardrobe, metal clothes rods & large mirrors. Other features include tankless water heater, 2 W/D combos, Full Sprinkler system, Full gutters, Large porch w/ swing & large backyard w/ room for a pool!' ,`Acres` = '0.1608' ,`Area` = '9' ,`BuilderName` = 'Wood Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 45 OAK FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7006' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 04' ,`TaxAmount` = '9584' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700238' WHERE `Matrix_Unique_ID` = '201660092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T15:05:12.737' ,`MLSNumber` = '8275903' ,`ListAgentFullName` = 'Christopher Webb' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.151888' ,`Longitude` = '-95.025707' ,`PhotoCount` = '35' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '1175000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewing Teal' ,`StreetNumber` = '4127' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction by Bay Point Builders. One year builders warranty is included. This canal house is located on a corner lot that has great beach and bay views. Double decks on each side will allow you to enjoy the gulf breeze and beautiful sunsets. There are four bedrooms and 3 1/2 bathrooms with one of the bedrooms located on the first floor. The interior features include tile floors throughout, quartz countertops, custom trim and cabinet work, and shiplap accents. Exterior features include a boat house, trex deck, two staircases, one car garage and an outdoor shower. Sunset Cove is a gated community that offers a swimming pool, tennis courts, boat launch and bayside nature trails. Short term rentals are not allowed in this subdivision.' ,`Acres` = '0.2403' ,`Area` = '33' ,`BuilderName` = 'Bay Point Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUNSET COVE (2005), ABST 121, BLOCK F, LOT 13, ACRES 0.240' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '10469' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sunset Cove 2005' ,`TaxAmount` = '7470' ,`TaxRate` = '2.2124' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700239' WHERE `Matrix_Unique_ID` = '208432787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:50:43.607' ,`MLSNumber` = '14509606' ,`ListAgentFullName` = 'Marilynn Green' ,`ListOfficeName` = 'Country World Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.807632' ,`Longitude` = '-99.077241' ,`PhotoCount` = '41' ,`PostalCode` = '76801' ,`RoomCount` = '9' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'SAFE HAVEN' ,`StreetNumber` = '6201' ,`StreetSuffix` = 'Lane' ,`City` = 'brownwood' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful hilltop 5 acre property overlooking the lake includes a 5 bedroom/4 bath brick home with large game room, covered deck, fire pit and more overlooking the lake, it is designed for entertaining. THIS PROPERTY WOULD MAKE A FANTASTIC VACATION RENTAL. The 30x40 steel building with 3 roll up doors has a RV covered parking area attached. Plenty of room for your boats, vehicles and toys. Covered parking for the RV and a covered deck overlooking the lake. Gorgeous view of the lake while you entertain on your large covered deck and your guests roast marshmallows at the fire ring. Bring your pickiest buyer, you won\'t be disappointed. NO RESTRICTIONS -- PERFECT VACATION RENTAL' ,`Acres` = '5' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'J M TEAGUE, SURVEY 2, ABSTRACT 1897, MATT FINCH, SURVEY 8, A' ,`LotDesciption` = 'Cleared,Water View,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '330 - Bangs' ,`SchoolElementary` = 'J B STEPHENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BANGS HIGH SCHOOL' ,`SchoolMiddle` = 'BANGS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Park Sub' ,`TaxAmount` = '6458' ,`TaxRate` = '1.5404' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700239' WHERE `Matrix_Unique_ID` = '208568291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T15:46:13.547' ,`MLSNumber` = '61802914' ,`ListAgentFullName` = 'Susan Goehrs' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.612850' ,`Longitude` = '-95.053058' ,`PhotoCount` = '16' ,`PostalCode` = '77331' ,`RoomCount` = '10' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Cove' ,`StreetNumber` = '20' ,`StreetSuffix` = 'Road' ,`City` = 'Coldspring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Get ready for lake living in this lake community of Camilla Coves. This 1536 sq/ft home sits on 3 lots. The 3/2/3 home has a large kitchen with an island and breakfast area opening to a living/dining area. The primary bedroom has an additional room great for a sitting room or study. There is a wrap-around porch that allows taking entertainment outside. There is a 625 sq/ft garage apartment and there are two separate garages (2 cars each and oversized). The home has a Generac whole home generator system which operators the garages as well. The home is surrounded by the beauty of the East Texas forest. The back of the home overlooks a neighbor\'s pond creating a peaceful country view. There is an extra building behind the garage that can be used for a craft room or hobby area.' ,`Acres` = '1.0867' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAMILLA COVES, BLOCK E, LOT 1- 3, ACRES 1.0867' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '47337' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Camilla Coves' ,`TaxAmount` = '3418' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700239' WHERE `Matrix_Unique_ID` = '208729320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:34:26.220' ,`MLSNumber` = '25822388' ,`ListAgentFullName` = 'Diana Nickell' ,`ListOfficeName` = 'Texas Palladium Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723778' ,`Longitude` = '-95.004078' ,`PhotoCount` = '33' ,`PostalCode` = '77520' ,`RoomCount` = '10' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'New Jersey' ,`StreetNumber` = '2209' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A historic beauty in Baytown close to a family friendly park and the coast. Lots of updates and NO CARPET!!! Check out the floorpan. Space for an office, dining/living combo and the primary bedroom is on the first floor. Two car detached garage with work area. Located on a large corner lot with unique garage entrance from the back of the property. Call to view this lovely home with custom cabinetry and new flooring throughout.' ,`Acres` = '0.2268' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 25 & 26 BLK 33 EAST BAYTOWN' ,`LotDesciption` = 'Corner' ,`LotSize` = '9878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Baytown' ,`TaxAmount` = '4421' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1934' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700239' WHERE `Matrix_Unique_ID` = '209233434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T15:21:30.530' ,`MLSNumber` = '43771495' ,`ListAgentFullName` = 'Waynea Sheffield' ,`ListOfficeName` = 'A Action Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800810' ,`Longitude` = '-95.167106' ,`PhotoCount` = '36' ,`PostalCode` = '77364' ,`RoomCount` = '4' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Coco Loop' ,`StreetNumber` = '340' ,`StreetSuffix` = '' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Water View! 3 bed, 2 bath home offering an open concept, island kitchen, primary suite, two guest bedrooms and additional full bath. Beautifully landscaped and fully fenced with a large deck to enjoy breathtaking lake views. Additional features include: water softener, whole house water filter system, reverse osmosis in kitchen, and sprinkler system. Community offers: Social Club, Street Dance, BBQ Cook-Off, Car Show and Poker Run, not to mention all the Subdivision Amenities, Pool, boat launch, pier, community center and playground.' ,`Acres` = '0.1219' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRINITY LAGOON, SEC I OF HVL, LOT 187, HUD# PFS1070446, HUD#' ,`LotDesciption` = 'Water View' ,`LotSize` = '5310' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '467' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Trinity Lagoon, Sec I Of Hvl' ,`TaxAmount` = '2344' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700239' WHERE `Matrix_Unique_ID` = '209355292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:33:02.513' ,`MLSNumber` = '48849191' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395062' ,`Longitude` = '-95.688840' ,`PhotoCount` = '30' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner' ,`StreetNumber` = '162' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2495' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3001' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1228' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700239' WHERE `Matrix_Unique_ID` = '209591742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T15:18:55.190' ,`MLSNumber` = '45452100' ,`ListAgentFullName` = 'Maricela Rios' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776863' ,`Longitude` = '-95.184855' ,`PhotoCount` = '17' ,`PostalCode` = '77015' ,`RoomCount` = '9' ,`ListPrice` = '254999.00' ,`Status` = 'Active' ,`StreetName` = 'Bandera' ,`StreetNumber` = '13433' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1862' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never flooded! This home has 3 bedrooms/2.5 baths and is located minutes from Downtown Houston! This well-maintained home is on a 14,000 sqft unrestricted lot! It has a large driveway and a big backyard! But wait! There\'s more...the garage can be used as a shop! It has a bathroom and an office space as well!!! Come see what this home has to offer and make it yours today!' ,`Acres` = '0.3214' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 243 & E 40 FT OF LT 242 BLK 8 HOME OWNED ESTATES SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 01' ,`TaxAmount` = '6171' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700239' WHERE `Matrix_Unique_ID` = '210224860' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:13:01.427' ,`MLSNumber` = '30070148' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.039671' ,`Longitude` = '-95.476139' ,`PhotoCount` = '26' ,`PostalCode` = '77388' ,`RoomCount` = '7' ,`ListPrice` = '257900.00' ,`Status` = 'Active' ,`StreetName` = 'Chapel Square' ,`StreetNumber` = '3815' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1909' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for a very livable 3/2 br home to raise your children in the Klein ISD with a wonderful shaded community pool and park? This home on a quiet cul-de-sac tree lined street with sidewalks on both sides might be your answer. It boasts a separate dining, living, and family room w/cathedral ceiling, extra-large kitchen overlooking the family room so you are always part of the family activities. Tons of counter space, a breakfast area, and a butler’s pantry and/ or coffee bar. The well designed floor plan separates the large primary br w/updated ensuite from the other two brs by an the updated hall bath.. The primary has a large walk-in closet. Most updates done in 2017 to include new flooring , neutral paint, large baseboards, 2” blinds, granite kitchen countertops, appliances and water heater. This house has a timeless appeal for a comfortable family lifestyle in a highly sought-after neighborhood. There is a large fenced backyard w/patio to enhance your lifestyle.' ,`Acres` = '0.1716' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 19 CYPRESSDALE SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '408' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypressdale Sec 02' ,`TaxAmount` = '4015' ,`TaxRate` = '2.4645' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700240' WHERE `Matrix_Unique_ID` = '210315316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T15:19:22.037' ,`MLSNumber` = '47872433' ,`ListAgentFullName` = 'Mario Romero' ,`ListOfficeName` = 'R3 Yes! Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818137' ,`Longitude` = '-95.279996' ,`PhotoCount` = '50' ,`PostalCode` = '77028' ,`RoomCount` = '4' ,`ListPrice` = '275800.00' ,`Status` = 'Active' ,`StreetName` = 'Filltop' ,`StreetNumber` = '8046' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION GEM! HONEY STOP THE CAR! WHAT A BEAUTIFUL NEW HOME, FILLED WITH TOP NOTCH UPGRADES, OPEN CONCEPT, GRANITE COUNTERTOPS, BEAUTIFUL KITCHEN CABINETRY, LARGE PRIMARY BEDROOM W WALK-IN CLOSET, GORGEOUS BATHROOM WITH SEPARATE SHOWER & JACUZZI BATHTUB, GREAT CENTRAL LOCATION, JUST MINUTES FROM TOWN, CLOSE TO MAJOR FREEWAYS, SHOPPING, ARTS & DINING, NEW CONSTRUCTION IN THE SURROUNDING AREA, CALL AGENT FOR PRIVATE SHOWING NOW!!!' ,`Acres` = '0.0918' ,`Area` = '2' ,`BuilderName` = 'JUAN A GUTIERREZ' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 3 LIBERTY ROAD MANOR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Road Manor Sec 01' ,`TaxAmount` = '559' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700240' WHERE `Matrix_Unique_ID` = '210623702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:59:39.483' ,`MLSNumber` = '25754542' ,`ListAgentFullName` = 'Wenjie Wang' ,`ListOfficeName` = 'Sunet Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996546' ,`Longitude` = '-95.699877' ,`PhotoCount` = '19' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '348800.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Dale' ,`StreetNumber` = '15530' ,`StreetSuffix` = 'Street' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in the highly sought after Cy-Fair school district! Lovely 4-Bedroom, 2.5 Bath, 2-car garage with opener. Living area has beautiful double-sided fireplace! Upgraded island in the kitchen and high ceilings. Spacious master bedroom with two walk-in closets! Huge secondary bedrooms! Great location!! Convenient to Hwy 290, Grand Parkway, shopping and restaurants. A Must See!!' ,`Acres` = '0.111' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 VILLAGES OF CYPRESS LAKES SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4836' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Cypress Lakes Sec 09' ,`TaxAmount` = '6051' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700240' WHERE `Matrix_Unique_ID` = '210658765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T15:50:50.830' ,`MLSNumber` = '20742373' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949644' ,`Longitude` = '-95.198320' ,`PhotoCount` = '26' ,`PostalCode` = '77346' ,`RoomCount` = '13' ,`ListPrice` = '499863.00' ,`Status` = 'Active' ,`StreetName` = 'Banchory Leaf' ,`StreetNumber` = '12607' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2901' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction. (Emmaline, Elevation AL) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3 baths. Formal dining room and breakfast area. Spacious island kitchen open to Family room. Primary suite with large walk-in closets as well as secondary bedroom downstairs. Two additional bedrooms and spacious Game room on second floor. Covered patio and 3 car tandem garage. Forget the world outside and come home to Balmoral, a community surrounded by beauty and peace in the West Lake Houston area of northeast Beltway 8 in Humble, TX. Balmoral offers residents connected living with luxurious homes and many amenities to choose from, including the Houston area\'s Crystal Clear Lagoon surrounded by glistening white sand beaches. Stop by the Westin Homes model home today to find out more about Balmoral!' ,`Acres` = '0.1856' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8084' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1912' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700240' WHERE `Matrix_Unique_ID` = '210731730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:37:58.717' ,`MLSNumber` = '13009463' ,`ListAgentFullName` = 'Ernesto Ramirez' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.623065' ,`Longitude` = '-95.215616' ,`PhotoCount` = '7' ,`PostalCode` = '77034' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Palmsprings' ,`StreetNumber` = '11610' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a great location for a commercial/residential property! This property will make an excellent location for an office, or a trucking company, construction contractor, or other similar companies due to its proximity to Interstate 45, Sam Houston Toll Road (Beltway 8) and State Highway 3. The property is located only blocks away from Interstate 45.' ,`Acres` = '0.3306' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 4 5 & 6 & TR 7 BLK 198 GENOA' ,`LotDesciption` = 'Cleared,Other,Subdivision Lot' ,`LotSize` = '14400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GENOA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Genoa' ,`TaxAmount` = '3428' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700240' WHERE `Matrix_Unique_ID` = '210942452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:38:40.337' ,`MLSNumber` = '80294941' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.394552' ,`Longitude` = '-95.688182' ,`PhotoCount` = '35' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner Lane' ,`StreetNumber` = '174' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2495' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous stunning large one story new home! Very large kitchen with tons of cabinets and kitchen island. Family room, study, formal dining and bedrooms are all large. Stunning entry that grabs your attention as soon as the front door is opened. Large covered back porch and very large rear yard. Tile plank floors everywhere but bedrooms. French doors leading into the large study. Gorgeous kitchen with white cabinets & upgraded granite countertops. Low tax base! Ready for move in!' ,`Acres` = '0.3452' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 19' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15038' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1413' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700240' WHERE `Matrix_Unique_ID` = '211046821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:03:04.010' ,`MLSNumber` = '16226873' ,`ListAgentFullName` = 'Rebecca Drake' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764574' ,`Longitude` = '-95.640233' ,`PhotoCount` = '33' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Basalt' ,`StreetNumber` = '14503' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location Location! This beautiful, well-maintained home is located in the quiet enclave of the gated neighborhood of Terraces on Memorial. This neighborhood offers use of a community pool & lovely lake & walking trail. Featuring a neutral color palette & light, bright interior, this home is ready go! Located within a 15-minute drive of schools, shops, and local restaurants, and you will enjoy the fact that there are no neighbors immediately behind this home. This special home is unique in the fact that it\'s the only one of the patio homes that has a fabulous, large, covered back porch with ceiling fans. This allows you another living area outside where you can enjoy your morning coffee or relax at the end of the day with a glass of wine. The very spacious owner\'s retreat has been put on its own HVAC zone. Sleep at your own desired temperature! Owner\'s retreat also has two great closets w/custom built-ins, lots of drawer space, and dressing mirrors, & the bath is a dream! NICE' ,`Acres` = '0.0901' ,`Area` = '31' ,`BuilderName` = 'K Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 99 BLK 4 TERRACES ON MEMORIAL AMEND' ,`LotDesciption` = 'Greenbelt,Patio Lot,Subdivision Lot,Wooded' ,`LotSize` = '3924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terraces on Memorial' ,`TaxAmount` = '10039' ,`TaxRate` = '2.7107' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700240' WHERE `Matrix_Unique_ID` = '211056713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:44:26.473' ,`MLSNumber` = '49393507' ,`ListAgentFullName` = 'Carla Nettles' ,`ListOfficeName` = 'Summit, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672262' ,`Longitude` = '-95.093832' ,`PhotoCount` = '36' ,`PostalCode` = '77536' ,`RoomCount` = '13' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Alta' ,`StreetNumber` = '4409' ,`StreetSuffix` = 'Lane' ,`City` = 'Deer Park' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Home On Corner Lot * Fabulous Gunite Pool Featuring Hot Tub, Waterfalls, Sun Deck and Stack Stone * Covered Patio * House Has Both Formals, Study and Gameroom * Leaded Glass Door * 2\" Blinds * Crown Mouldings * Wrought Iron Railing * Walk-In Pantry * Hardwood Floors * Updated Lighting * Granite Countertops * Stainless Steel Appliances * Breakfast Bar * Limestone Corner Fireplace * Art Niche * Large Bedrooms * Walk-In Closets * Great Neighborhood * 3 Car Garage *' ,`Acres` = '0.1997' ,`Area` = '6' ,`BuilderName` = 'KHovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 COTTONWOOD ESTATES SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '72' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (LA PORTE)' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cottonwood Estates Sec 2' ,`TaxAmount` = '10313' ,`TaxRate` = '2.7308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700241' WHERE `Matrix_Unique_ID` = '211326810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:57:03.270' ,`MLSNumber` = '40058602' ,`ListAgentFullName` = 'Ethan Cameron' ,`ListOfficeName` = 'Cameron Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361243' ,`Longitude` = '-94.952357' ,`PhotoCount` = '22' ,`PostalCode` = '77327' ,`RoomCount` = '10' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2218' ,`StreetNumber` = '308' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 3 bedroom, 2 bath mobile home on 1.74 acres in Tarkington ISD. Home has 2 living rooms, space used as a home office & a 10\'x12\' flex room! Shop building with apartment ready to be completed.' ,`Acres` = '1.74' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK SHADOWS, LOTS 210-212, ACRES 1.74, MH LABEL NTA0995743/' ,`LotDesciption` = 'Cleared' ,`LotSize` = '75794' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Shadows' ,`TaxAmount` = '3646' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700241' WHERE `Matrix_Unique_ID` = '211440593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:57:54.093' ,`MLSNumber` = '73142828' ,`ListAgentFullName` = 'Ansuya Hesse' ,`ListOfficeName` = 'iHouzz Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.933370' ,`Longitude` = '-95.265397' ,`PhotoCount` = '42' ,`PostalCode` = '77396' ,`RoomCount` = '13' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Placid' ,`StreetNumber` = '14714' ,`StreetSuffix` = 'Point' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME HAS IT ALL!!! 5 Bedroom 4.5 bathroom Trendmaker Home located in family friendly golf course community, short walk to highly rated elementary school, all neighborhood amenities (pool, tennis courts, fitness center…), minutes to Downtown Houston, IAH airport, shopping, and easy access to major highways. Entry with soaring ceilings, grand stairway open to study with French doors and formal dining room with hardwood floors. Gourmet island kitchen has solid countertops, stainless steel appliances open to breakfast room and den with toasty fireplace. Spacious master suite is downstairs with sitting area, fireplace, hardwood floors and XL walking closet. Upstairs: 4 secondary bedrooms + 3 full bathrooms, game room and computer nook. Extensive tile in all the living areas. Pool size private backyard with covered breezeway, long driveway with oversize detached garage. Epoxy flooring and AC in garage makes it a great space to add a workshop or home gym. NEW ROOF Aug\'2022! Must See!!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 4 Blk 2 Fall Creek Sec 2' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '10996' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700241' WHERE `Matrix_Unique_ID` = '211452449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:53:25.920' ,`MLSNumber` = '21232395' ,`ListAgentFullName` = 'Jill Aylwin' ,`ListOfficeName` = 'Texas CashBack Real Estate,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432102' ,`Longitude` = '-95.208222' ,`PhotoCount` = '21' ,`PostalCode` = '77511' ,`RoomCount` = '3' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Old Alvin' ,`StreetNumber` = '441' ,`StreetSuffix` = 'Road' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home To The Best Of Both Worlds!*This Beautiful Acreage Property Is The Right Combination Of City Meets Country With 2 Acres of Land And An Updated 3-2 Home*So Many Ammenities, You Will Want To Come Take A Look For Yourself-Including-Per Seller-A F 5 Rated Tornado Shelter Certified By Texas Tech University That Holds 6 - 8 People*Easy Access To TX-35, I-45, and 517*Don\'t Miss It!' ,`Acres` = '2' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 620 I & GN RR SUR SEC 25 PT OF LOT 1 (1-3) BLK 27 HALLS' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Halls Add To Alvin' ,`TaxAmount` = '785' ,`TaxRate` = '2.0035' ,`WaterSewer` = 'Public Sewer,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700241' WHERE `Matrix_Unique_ID` = '211488923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:16:43.860' ,`MLSNumber` = '22503892' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.392230' ,`Longitude` = '-95.600464' ,`PhotoCount` = '30' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '434000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden' ,`StreetNumber` = '11530' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2495' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning new home ready for move in! Very elegant one story floor plan. Ceramic tile plank flooring whole house except for bedrooms. Granite countertops kitchen & baths. Huge kitchen with plenty of cabinets space and a kitchen island. Covered back patio & extra concrete patio. Corner lot that is 80\' wide. Located in exemplary rated Montgomery school district! Walden amenities include large pool located on on shore of Lake Conroe, Yacht club, kiddie pools, multiple tennis & pickle ball courts, walking paths, kids park, dog park, & 2 boat ramps. Low tax rate of 2.13! Come live the Lake Life!' ,`Acres` = '0.2328' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 02, BLOCK 10, LOT 1 SEC 2' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10140' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 02' ,`TaxAmount` = '217' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700241' WHERE `Matrix_Unique_ID` = '211489144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:46:17.963' ,`MLSNumber` = '20409357' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.393865' ,`Longitude` = '-95.616408' ,`PhotoCount` = '33' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden' ,`StreetNumber` = '12629' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home ready for move in. 2 1/2 car garage located on a corner lot. 4 bedrooms, study, game room, 2 1/2 baths. Ceramic tile flooring all floors except bedrooms. Master bedroom is very large with a bay window. 3 bedrooms and a game room upstairs. Located in the exemplary rated Montgomery ISD! Walden amenities include a large water front pool, 2 kiddie pools, restaurants to dine, Yacht club, walking paths, multiple tennis & racquetball courts, 2 boat ramps, exercise room, kids park, dog park, and more. Come live the Lake Life!' ,`Acres` = '0.178' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 08 BK 30 LT 48 SECTION 8A' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7752' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 08' ,`TaxAmount` = '172' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700241' WHERE `Matrix_Unique_ID` = '211491993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T14:28:05.730' ,`MLSNumber` = '69601757' ,`ListAgentFullName` = 'Guillermo Martinez' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830539' ,`Longitude` = '-95.361054' ,`PhotoCount` = '50' ,`PostalCode` = '77022' ,`RoomCount` = '1' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Irvington' ,`StreetNumber` = '7606' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '4576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Business Opportunity! Location, Location, Location! Fully Operational. Restaurant is operating, the Sale includes the Building and Parking Lot . including the Business . Lots of parking space and great visibility, awesome location! \r\nOne year old roof, and Exhaust Kitchen Stainless Steel recently replaced. Fantastic price, great visibility and great traffic. Make an appointment to view today ! Must make an appointment , DO NOT DISTURB PATRONS.' ,`Acres` = '0.582' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 35 & 36 BLK 7 STRATTON PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '25350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JANOWSKI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'Stratton Place' ,`TaxAmount` = '14071' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700241' WHERE `Matrix_Unique_ID` = '211541862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T15:35:20.893' ,`MLSNumber` = '51260473' ,`ListAgentFullName` = 'Charity Yarborough' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832699' ,`Longitude` = '-95.404197' ,`PhotoCount` = '16' ,`PostalCode` = '77018' ,`RoomCount` = '2' ,`ListPrice` = '1550000.00' ,`Status` = 'Active' ,`StreetName` = 'Thornton' ,`StreetNumber` = '324' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sold for Lot Value, home cannot be shown.Great opportunity in the Garden Oaks/Oak Forest area! Large 43,000+ square foot lot located in the Independence Heights area. Ideal for single family, a townhome development or commercial development. No zoning leads to lots of options for this large piece of land that is surrounded by new construction. Located just north of 610. Easy freeway access and minutes to Downtown Houston. Great restaurants and shopping all around!' ,`Acres` = '0.996' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 YALE STREET ACRES SEC 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43384' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Yale Street Acres Sec 01' ,`TaxAmount` = '2272' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700242' WHERE `Matrix_Unique_ID` = '211572511' --> Updated record success