Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:16:14.070' ,`MLSNumber` = '64538722' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784486' ,`Longitude` = '-95.039056' ,`PhotoCount` = '20' ,`PostalCode` = '77520' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Crabapple' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This open concept plan has dramatic high ceilings, 4 bedrooms, a study, a game room, 2.5 baths, and a 3 car garage. The kitchen features Quartz countertops, an under-mount stainless sink, Gray 42\" upgraded kitchen cabinets, pendant lights, upgraded backsplash, and island! Engineered wood flooring throughout 1st-floor main living areas. Two-story ceilings in Family Room. Master bedroom on the first floor with w/upgraded separate soaker tub and shower, and walk-in closet! Includes gameroom and separate study for those who work from home!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34, Block 1, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10672' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.9705' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266434' WHERE `Matrix_Unique_ID` = '202907632' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:22:12.080' ,`MLSNumber` = '33772403' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '364995.00' ,`Status` = 'Active' ,`StreetName` = 'Lazarina' ,`StreetNumber` = '2931' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** You don’t want to miss this KB Home in the new Olympia Falls community, boasting a brick elevation, vinyl flooring, extended entry, and an open great room. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds and full gutters. The community comforts of Olympia Falls include a park with a playground and walking paths. Conveniently located near Fort Bend Pkwy. Toll Rd., and I-69, residents enjoy nearby shopping and entertainment at Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated highly-rated Fort Bend ISD schools.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266434' WHERE `Matrix_Unique_ID` = '205482941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:21:52.610' ,`MLSNumber` = '94093990' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '367995.00' ,`Status` = 'Active' ,`StreetName` = 'Lazarina' ,`StreetNumber` = '2919' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel at ease in this stunning KB home in Olympia Falls, boasting a brick front, tile flooring, extended entry, a study with French doors, and an open great room. Impress your guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Spend evenings relaxing in the primary suite, featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds and full gutters. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266434' WHERE `Matrix_Unique_ID` = '206100130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:21:24.937' ,`MLSNumber` = '60672295' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '379995.00' ,`Status` = 'Active' ,`StreetName` = 'Katalonia' ,`StreetNumber` = '2007' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel at ease in this charming KB Home in Olympia Falls, boasting a brick front, tile flooring, extended entry, and an open great room. Create new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. The serene primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include an extended covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266434' WHERE `Matrix_Unique_ID` = '206376656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:21:05.780' ,`MLSNumber` = '77948406' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '359995.00' ,`Status` = 'Active' ,`StreetName` = 'Lazarina' ,`StreetNumber` = '2935' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy peace and quiet in this charming KB home in Olympia Falls, boasting a stone veneer, vinyl flooring, extended entry, and an open great room. Create new recipes in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Relax in the tranquil primary suite, featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds and an extended covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266435' WHERE `Matrix_Unique_ID` = '206614691' --> 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','207435895','1675266435','207435895','2023-01-30T17:20:51.510','65543904','Lance Loken','KB Home Houston','','','29.553750','-95.502207','6','77459','8','346608.00','Active','Korinos','2818','Court','Fresno','2','0','3','1836','Single-Family','**Home is under construction.** Find what you’re looking for in this beautiful KB Home in Olympia Falls, boasting a brick front and open great room. Impress your guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Spend evenings relaxing in the primary suite, featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include an extended covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.','','38','KB Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Missouri City Area','Central Gas','1','Lot 9 Block 4','Subdivision Lot','','','','750','1','To Be Built/Under Construction','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','19 - Fort Bend','BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)','WILLOWRIDGE HIGH SCHOOL','MCAULIFFE MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Olympia Falls','','3.2629','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:20:37.797' ,`MLSNumber` = '66656634' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '369995.00' ,`Status` = 'Active' ,`StreetName` = 'Korinos' ,`StreetNumber` = '2819' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find total comfort in this lovely KB Home on a spacious lot in Olympia Falls, boasting a brick front, extended entry, and an open great room. Whip up meals for guests in the kitchen, equipped with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities and a shower with a Moen Seena® WaterSense Showerhead. Additional home features include faux wood blinds, full gutters, and an extended covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266435' WHERE `Matrix_Unique_ID` = '207577140' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:05:58.403' ,`MLSNumber` = '73594335' ,`ListAgentFullName` = 'Oliver Carter' ,`ListOfficeName` = 'Connected Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789514' ,`Longitude` = '-95.376668' ,`PhotoCount` = '25' ,`PostalCode` = '77009' ,`RoomCount` = '14' ,`ListPrice` = '1999900.00' ,`Status` = 'Active' ,`StreetName` = 'Redan' ,`StreetNumber` = '506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This incredible modern farmhouse from visionary builder David Gordon of Aspire Fine Homes offers a flexible layout paired with stunning design, all on an oversized lot ONE BLOCK from Travis Elementary!! With the latest in high-end features and designer finishes selected by Dandy Interiors, this remarkable residence features open-concept living, 4 bedrooms and a game room up, an en-suite office AND 5th bedroom down, and a gigantic yard! Upon entering this gorgeous residence, you are met with a grand double height entry filled with natural light! Walk past the spacious 12x15 en-suite office before the open floorplan reveals the bar, kitchen, mudroom, dining, and living! A beautiful covered back porch overlooks the oversized yard! Upstairs you’ll be immediately greeted with a 21x14 game room before finding the luxuriously appointed laundry and 3 secondaries. The palatial master suite boasts a walk-in shower, soaker tub, double vanities, private toilet, and a spectacular 21x12 closet!' ,`Acres` = '0.182' ,`Area` = '9' ,`BuilderName` = 'Aspire Fine Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 & TR 4A BLK 1 CLAYS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Woodland Heights' ,`TaxAmount` = '16439' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266435' WHERE `Matrix_Unique_ID` = '207802021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:01:01.900' ,`MLSNumber` = '51154995' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829966' ,`Longitude` = '-95.554752' ,`PhotoCount` = '29' ,`PostalCode` = '77043' ,`RoomCount` = '11' ,`ListPrice` = '474995.00' ,`Status` = 'Active' ,`StreetName` = 'Centre Green' ,`StreetNumber` = '10609' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! The Venice II plan features 2 bedrooms, 3 full baths & half bath. Flexible downstairs activity room with French doors, walk-in closet and shower only bath is perfect for an office space or guest room. The cozy valet located on first floor is great for organization. The gourmet kitchen has maple cabinets with under cabinet lighting, quartz countertops, gas cooktop & stainless steel appliances that opens into the dining and great room with linear fireplace. Balcony is accessible from the great room. Soaker tub & separate shower, dual vanity sinks and walk-in closet in owner\'s luxury bath. The 3rd floor also has 1 secondary bedroom with en-suite bath and a loft space that can be used as you wish. Community walking trail make it easy to stay active. Great location, near Beltway 8 & I-10 and within minutes of CITYCENTRE, Memorial City Mall, Energy Corridor, parks & restaurants. Must see; schedule a tour today! Offered by: K. Hovnanian Houston III, L.L.C.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '4/1/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2234' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Centrepark Terrace' ,`TaxAmount` = '' ,`TaxRate` = '2.33792' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266435' WHERE `Matrix_Unique_ID` = '208067735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:43.433' ,`MLSNumber` = '67200045' ,`ListAgentFullName` = 'Jon Skeele' ,`ListOfficeName` = 'Bayway Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.579870' ,`Longitude` = '-95.023499' ,`PhotoCount` = '23' ,`PostalCode` = '77586' ,`RoomCount` = '5' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mija' ,`StreetNumber` = '1532' ,`StreetSuffix` = 'Circle' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home will be complete in 2 weeks, so can be ready for a December closing.\r\nBig back yard & covered patio. Oversized tandem garage.' ,`Acres` = '0.2271' ,`Area` = '7' ,`BuilderName` = 'Bayway Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 LAKE MIJA VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Mija Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266436' WHERE `Matrix_Unique_ID` = '208744333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:20:22.850' ,`MLSNumber` = '40410836' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '354995.00' ,`Status` = 'Active' ,`StreetName` = 'Palamas' ,`StreetNumber` = '2830' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy peace and quiet in this charming KB Home in Olympia Falls, boasting a brick front, tile flooring, extended entry, and an open great room. Spend all day in the kitchen, equipped with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. The serene primary suite features extended dual vanities and a shower with a Moen Seena® WaterSense Showerhead. Additional home features include faux wood blinds, full gutters, and an extended covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266436' WHERE `Matrix_Unique_ID` = '210065672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:25:33.593' ,`MLSNumber` = '27090426' ,`ListAgentFullName` = 'Gregory Cordova' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.945784' ,`Longitude` = '-95.295647' ,`PhotoCount` = '30' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Angel Wing' ,`StreetNumber` = '432' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry! Beautiful beach home with 3-bedrooms, 2 bathrooms, large wrap around decks for relaxing & entertaining, and a CARGO LIFT to easily move your groceries, luggage, and bulky items between levels of your home with ease. This beautiful beach home is only 3 blocks from the relaxing Gulf where a walk over bridge provides access to the pedestrian beach. This home has extra refrigerator and freeze located in the laundry room. New roof installed October 2022. Also close is the famous Surfside fishing jetty & the Jetty Park includes covered picnic areas, children’s splash pad & nature/ fitness walk & crabbing piers east on Blue Water Highway. Ready for summertime fun! Must See! Hurry!' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GULF RIDGE (A0051 F J CALVIT TR G) BLK 1 LOT 3, SURFSIDE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '5733' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266436' WHERE `Matrix_Unique_ID` = '210305996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:19:07.507' ,`MLSNumber` = '4281196' ,`ListAgentFullName` = 'Ana De Los Reyes' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.129275' ,`Longitude` = '-95.544002' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '899500.00' ,`Status` = 'Active' ,`StreetName` = 'Piney Bend' ,`StreetNumber` = '25307' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4557' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on a sprawling half-acre corner lot in Preserve is truly one of a kind. Property is generous in scale, featuring an open floor plan with a grand 2-story foyer, crown molding and trim work throughout, built-ins, 2 staircases, plantation shutters in the formal dining room, study with French doors, game room with wet bar, media room, and a 3/4 car garage. The gourmet kitchen boasts an island with pendant lighting, granite countertops, and stainless-steel Whirlpool appliances, including a double oven. Relax in the private master suite with his & her walk-in closets, separate vanities, whirlpool tub, and shower. The backyard is an outdoor oasis complete with a spacious covered patio, pool, spa, 2 sun decks, and towering trees. Enjoy proximity to world-class shopping, popular restaurants, and entertainment, including The Woodlands Mall, Market Street, Waterway Square, and the Cynthia Woods Mitchell Pavilion.' ,`Acres` = '0.5822' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 PRESERVE SEC 1 AMEND' ,`LotDesciption` = 'Other' ,`LotSize` = '25359' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Preserve Sec 01 Amd 1' ,`TaxAmount` = '15777' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266436' WHERE `Matrix_Unique_ID` = '210819276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:32:40.697' ,`MLSNumber` = '69468069' ,`ListAgentFullName` = 'Elpidia Orantes' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774835' ,`Longitude` = '-95.424778' ,`PhotoCount` = '8' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Tyne' ,`StreetNumber` = '6126' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO SHOWINGS!!! This property is Being sold as is. Lot value only. Sale cash or investors only.' ,`Acres` = '0.092' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 13 BLK 9 ADAM CLAY SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '4008' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Adam Clay Sec 02' ,`TaxAmount` = '7150' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1927' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266437' WHERE `Matrix_Unique_ID` = '210884398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:25:50.990' ,`MLSNumber` = '8221083' ,`ListAgentFullName` = 'Jared English' ,`ListOfficeName` = 'Congress Realty, Inc.' ,`SellingAgentFullName` = 'Adrianne Twymon' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.843444' ,`Longitude` = '-95.267876' ,`PhotoCount` = '9' ,`PostalCode` = '77028' ,`RoomCount` = '4' ,`ListPrice` = '257900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Talton' ,`StreetNumber` = '8528' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of Houston is this inviting 4 bedroom, 2 bath, 2 car garage oasis that awaits you. This is an energy efficient home with durable countertops, luxury laminate flooring, ceramic tiling, contemporary carpet and a spacious kitchen. The area is quiet and gives the feel of out of the city living but it is close to everything. This home is 10 minutes from downtown Houston, Minute Maid Park and BBVA Compass Stadium. No HOA and Low taxes!!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Silver Circle Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLOCK 1 SILVER CIRCLE PLAZA HOUSTON TEXAS 77028' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5287' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Circle Plaza' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266437' WHERE `Matrix_Unique_ID` = '210896876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:19:39.093' ,`MLSNumber` = '35114588' ,`ListAgentFullName` = 'Cynthia Ramos' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804292' ,`Longitude` = '-94.893909' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '5' ,`ListPrice` = '278000.00' ,`Status` = 'Active' ,`StreetName` = 'Euros' ,`StreetNumber` = '7623' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home has a bright, open floor plan.The kitchen is stylish and functional, looking out over a spacious but cozy dining/living area. Natural light beams through the large windows featured in both the dining and living room. Perfect for entertaining, your loved ones will gather around the island and make memories! The floor plan features 4 spacious bedrooms and 2 full baths.The primary bathroom has a luxurious stand alone shower, while the secondary bathroom has a tub/shower combo.The backyard offers a covered patio that is perfect for relaxing outside at any time of the day.The front yard has easy access to shared mailboxes and a 2 car garage. This home also has Solar Panels to cut energy costs, which in this Texas heat is a plus! The community amenities include a walking trail, a unique playground, and picnic table seating. Also in construction, is a community pool with a relaxing walkable trail to access it. Schedule a showing today…. and don\'t let this one slip away!' ,`Acres` = '0.1492' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BLK 2 LOT 16 SOUTHWINDS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds Sec 1' ,`TaxAmount` = '6641' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266437' WHERE `Matrix_Unique_ID` = '210965346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:01:56.300' ,`MLSNumber` = '36994049' ,`ListAgentFullName` = 'Maria Roberts' ,`ListOfficeName` = 'Hearthstone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842739' ,`Longitude` = '-95.664500' ,`PhotoCount` = '11' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenvillage' ,`StreetNumber` = '4711' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMFORTABLE FAMILY HOME W/BEAUTIFUL ISLAND KIT FEATURES LOTS OF CABNTS & COUNTER TOPS! FORMAL DINING IS OPEN TO THE DEN W/A COZY F/P, ALSO FOR LEASE $1,595' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 GLENCAIRN VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LIEDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'GLENCAIRN VILLAGE' ,`TaxAmount` = '2990' ,`TaxRate` = '3.03336' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266437' WHERE `Matrix_Unique_ID` = '211224308' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:48:30.957' ,`MLSNumber` = '62580533' ,`ListAgentFullName` = 'Billie Harris' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763922' ,`Longitude` = '-95.041476' ,`PhotoCount` = '38' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '1275000.00' ,`Status` = 'Active' ,`StreetName` = 'Winkler' ,`StreetNumber` = '303' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3557' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom-Built Home in a private location along Burnet Bay...Upon arrival, whether you enter through the elevator, the front dual staircase, or the travertine stairs in the oversized breezeway; you\'re sure to immediately feel the quality and custom features this home offers! The first floor features a Chef\'s Kitchen, a Living Room with windows to showcase the Baytown Nature Reserve directly behind the property, two guest bedrooms and a home office. The Primary Suite resides on its own level and has a Private Balcony facing the bay, and the more than 4 acres of mature trees provide privacy that compare to none! In addition to all this, the home is built with concrete pillars instead of typical wood pillars and was built to exceed the Hurricane Standards and provide excellent peace of mind and security during our famous Texas Storms! This Custom Home is unlike any other and is sure to impress with its views, privacy, custom details, and all it has to offer! Welcome to Paradise!' ,`Acres` = '4.26' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 1 and 2 DALE MORRIS' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '185783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Pointe Royale' ,`TaxAmount` = '15069' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266438' WHERE `Matrix_Unique_ID` = '211359836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:03:42.907' ,`MLSNumber` = '66366237' ,`ListAgentFullName` = 'Shirley Kopecky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800229' ,`Longitude` = '-95.465053' ,`PhotoCount` = '42' ,`PostalCode` = '77055' ,`RoomCount` = '12' ,`ListPrice` = '597900.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6509' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why live in a cookie-cutter home when you can buy EXTRAORDINARY with PRICING FOR A QUICK SALE?! There\'s no other 3000+ sq ft home with 5 bedrooms/5 bathrooms on a FULL-SIZE lot + CLOSE location + OUTSIDE the 100 & 500 yr flood plains at this price (home structure & garage structure have NEVER BEEN FLOODED). Home has extensive additions (1999 & 2003) & updates and boasts a dramatic 2-story great room, REAL hardwood & stone floors, crown molding, a large CUSTOM closet & 3 Recent HVAC units with sanitizing UV lights! Main house has 4 bedrooms & 4 bathrooms, the kitchen has a Viking range & dishwasher, & the large office/library can double as 2nd eating area. The oversized 2 car garage has a large outside covered storage area + an upscale garage apt (rental currently allowed by Civic Assn. or use for family or ON-SITE caregiver). Aug. 2015 appraisal = $606k with lot value at $200k (lot NOW $400k-$450k) & before MANY MORE improvements!' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8956' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266438' WHERE `Matrix_Unique_ID` = '211498410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:06:12.943' ,`MLSNumber` = '94604661' ,`ListAgentFullName` = 'Gena Douglas' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.272369' ,`Longitude` = '-95.647769' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '975000.00' ,`Status` = 'Active' ,`StreetName` = 'Michaels Run' ,`StreetNumber` = '18560' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4351' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Retreat to this beautiful farmhouse style 1.5 story, 5 bedroom, 4 and a half bath home, Huge upstairs gameroom with large bedroom and bathroom up, Gorgeous kitchen open to family room, perfect for entertaining. Large open floor plan with primary bedroom and 3 bedrooms down, separate study, massive 4 car garage with storage room and brand new epoxy flooring, all of this on a 1 acre lot, covered patio, fully cross-fenced and property backs to Cook’s Branch Conservancy! Home is in sought after Grand Lake Estates with highly rated schools in Montgomery ISD, beautiful lakes, a golf course and community park. Schedule your tour today!' ,`Acres` = '1' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKE ESTATES 10, BLOCK 1, LOT 16, ACRES 1.000' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '845' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Grand Lake Estates 10' ,`TaxAmount` = '913' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266438' WHERE `Matrix_Unique_ID` = '211541162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:20:06.487' ,`MLSNumber` = '8773405' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '13' ,`ListPrice` = '431760.00' ,`Status` = 'Active' ,`StreetName` = 'Lazarina' ,`StreetNumber` = '2911' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2961' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel at ease in this charming KB Home in Olympia Falls, boasting a brick front, extended entry, and a spacious game room. Entertain your guests in the kitchen, fully equipped with granite countertops, stainless steel Energy Star® appliances, 42-in. cabinets, and undercabinet lighting. Relax in the serene primary suite, featuring extended dual vanities and a shower with a Moen Genta® WaterSense showerhead. Additional home features include an extended covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266438' WHERE `Matrix_Unique_ID` = '211826696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:09:54.783' ,`MLSNumber` = '19589645' ,`ListAgentFullName` = 'Linda Escamilla' ,`ListOfficeName` = 'Can-2 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845310' ,`Longitude` = '-95.682371' ,`PhotoCount` = '23' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Hastingwood Dr' ,`StreetNumber` = '5022' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional family home in a desirable Deerfield Village, with excellent Cyfair school district, great curb appeal, crown molding, and laminated wood floors, master bedroom down with master bath, whirlpool tub, and separate shower, inground pool with hot tub, automatic driveway gate.' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 55 Deerfield Village Sec 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266439' WHERE `Matrix_Unique_ID` = '211912023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:51:47.170' ,`MLSNumber` = '9601560' ,`ListAgentFullName` = 'Patricia Matthews' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077255' ,`Longitude` = '-95.508298' ,`PhotoCount` = '50' ,`PostalCode` = '77388' ,`RoomCount` = '9' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Wrest Point' ,`StreetNumber` = '5915' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5915 Wrest Point Court! This 4 bedroom, 2.5 bathroom home has great curb appeal with mature landscaping and sprinkler system. Inside boasts an extended entry way, spectacular 2 story ceilings in the family room, an office/study, formal dining room, eat-in kitchen and an upstairs game room. The kitchen has a breakfast bar that opens up to the family room that makes entertaining a breeze. Downstairs is the primary bedroom which features an en-suite bathroom with dual sinks and a separate shower and soaking tub. All other spacious bedrooms plus oversized game room are upstairs. Backyard has a covered patio and is ready for a BBQ. Updated laundry with storage and sink, added attic access and flooring through the garage, new carpet and wood flooring were added, fresh paint throughout the home and touch ups were done outside. This home is in a great location with easy access to the Grand Parkway, shopping, and dining. Community offers pool, clubhouse, and playground.' ,`Acres` = '0.132' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 NORTHCREST VILLAGE SEC 7 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FOX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northcrest Village Sec 7' ,`TaxAmount` = '6985' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266439' WHERE `Matrix_Unique_ID` = '212068631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:17:02.960' ,`MLSNumber` = '47166681' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749723' ,`Longitude` = '-95.407263' ,`PhotoCount` = '41' ,`PostalCode` = '77019' ,`RoomCount` = '14' ,`ListPrice` = '999900.00' ,`Status` = 'Active' ,`StreetName` = 'HAZARD' ,`StreetNumber` = '1806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MCD unveils their new “Classic Series” Home. MCD is in Houston\'s well established inner loop neighborhoods. This residence features all of the high end finishes you’ve come to expect from MCD, packaged into a smaller home to achieve an unrivaled balance of luxury & price. This new luxury home features 1st floor living, flex rm, game rm, private driveway, backyard space, & energy efficiency. Finishes include granite/quartz counters, Fisher Paykel appl, a luxurious built-in primary closet w/ private balcony, intricate trim carpentry, engineered wood floors, spray foam insulation, smart screen thermostat, variable speed furnace, and 2stage condenser w multilevel zoning. Retail, restaurants, & more are walking distance away. Major freeways, downtown, medical center, & parks are all w/in minutes. Request a private viewing. ASK ABOUT CUSTOMIZATION OPTIONS DURING CONSTRUCTION ONLY*MODEL HOME PHOTOS MAY SHOW A SIMILAR FLOOR PLAN AND/OR UPGRADED/ALTERNATIVE FINISHES Use as a guide*' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Mazzarino Cons & Dev' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 WILFRAN PLACE PARTIAL REPLAT NO 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'WILFRAN PLACE PARTIAL REPLAT NO 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266439' WHERE `Matrix_Unique_ID` = '212090465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:52:31.787' ,`MLSNumber` = '7138247' ,`ListAgentFullName` = 'Elmer Garcia' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698996' ,`Longitude` = '-95.193773' ,`PhotoCount` = '23' ,`PostalCode` = '77506' ,`RoomCount` = '10' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Alvin' ,`StreetNumber` = '920' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1359' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely beautiful, fully remodeled, and completely move-in-ready home in a great location with nearly HALF AN ACRE of land. With beautiful quartz countertops, an open floorplan, new appliances, and located in a quiet cul-de-sac, this is the perfect family home. This home is centrally located, surrounded by shopping & eatery, and only a 19-minute drive to Downtown Houston. Schedule an appointment today, you will fall in love!' ,`Acres` = '0.5051' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 2 REVELON TERRACE' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '22000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Revelon Terrace' ,`TaxAmount` = '2798' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266439' WHERE `Matrix_Unique_ID` = '212173595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:18.350' ,`MLSNumber` = '9077418' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345147' ,`Longitude` = '-95.524310' ,`PhotoCount` = '27' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '357950.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Birch' ,`StreetNumber` = '777' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home Construction will be Completed in November. The Mountain Crest Floorplan. It’s a Two Story Four Bedroom with the Master Down, three full bedrooms upstairs. Attractive Front elevation wit three-sided brick with rear covered patio. The Primary bedroom is Luxurious with its spa like Bath that has a freestanding tub with a Separate Semi Frameless Shower, Dual Vanity area with a huge walk-in closet. Nickel Plumbing fixtures. The kitchen has contemporary grey cabinets with Granite countertops. Stainless steel appliances. Blinds and Garage Door Opener included. 11’ Ceilings in the family room. The home has luxury vinyl plank flooring in all common areas and carpet in the bedrooms. It’s wired and has an Alarm system panel. Fully sodded front and back yard.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22, Block 2, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6001' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266440' WHERE `Matrix_Unique_ID` = '212474351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:55.143' ,`MLSNumber` = '78851406' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.402726' ,`Longitude` = '-95.550613' ,`PhotoCount` = '29' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '325570.00' ,`Status` = 'Active' ,`StreetName` = 'Clear View' ,`StreetNumber` = '13075' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Clear View Estates - New Construction. This floorplan is the Gardenside, Elevation C, a single-story home with a 2-car garage, and luxurious master-island kitchen. Featuring 3-sides brick on the exterior, this is a very functional floor plan, with an attractive front elevation as well as a covered back patio, a nice lot. The 1st-floor primary has a luxurious primary bath with a freestanding tub and separate semi-frameless shower, a double vanity area and great storage, big walk-in master closet. The island kitchen with its attractive cabinets and granite counter looks to the family room. Secondary bedrooms share a spacious bath and both have great closet space.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 7, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear View Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.9103' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266440' WHERE `Matrix_Unique_ID` = '212508607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:18.507' ,`MLSNumber` = '29609146' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.171212' ,`Longitude` = '-95.755117' ,`PhotoCount` = '17' ,`PostalCode` = '77355' ,`RoomCount` = '6' ,`ListPrice` = '362120.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverwood' ,`StreetNumber` = '19049' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Villages of heritage point---new construction!!---very popular garden cove plan/elevation b, 1908 sf living space, full brick with stone accents, one story floor living with much desired open floorplan, lots of natural light, 42\" upper kitchen cabinets, stainless steel appliances, vent hood with cabinet shroud, under counter pull out microwave, luxury vinyl plank in main living areas, impressive owner\'s suite, free standing tub, separate shower, carpet in bedrooms, walk in utility room. Covered back patio. Extra workspace in the garage! Fenced, full sod, a very impressive, functional home design! ,full window blinds included with purchase.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10210' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages of Heritage Point' ,`TaxAmount` = '' ,`TaxRate` = '2.9787' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266440' WHERE `Matrix_Unique_ID` = '212518435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:10:02.863' ,`MLSNumber` = '57029443' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.237672' ,`Longitude` = '-95.750273' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '612745.00' ,`Status` = 'Active' ,`StreetName` = 'Lost San Saba' ,`StreetNumber` = '40719' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! DH Homes presents this beautiful acreage wooded community. A community where homes nestle within acre+ homesites and offer privacy at its best. Very low tax rate and you have your own water well & aerobic system. Deed restrictions and thoughtfully designed floorplans. This Victoria plan offers 4 bedrooms with 2.5 baths with a 3 car attached front load garage. Very large open living area. Light & bright. Nice size rooms. Enjoy the 15x31 back porch and watch the deer! Full brick/stone w/cement board trim. Low E Vinyl windows, 16 SEER. \"Estimated\" completion 11/30/22. Magnolia ISD.the ideal setting for a relaxing lifestyle and enjoy your slice of Texas. Additional plans and lots are available, reach out for information.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '65522' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.85' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266440' WHERE `Matrix_Unique_ID` = '212525587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:57.910' ,`MLSNumber` = '50954599' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.237672' ,`Longitude` = '-95.750273' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '605205.00' ,`Status` = 'Active' ,`StreetName` = 'Lost San Saba' ,`StreetNumber` = '40725' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2597' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DH Homes presents the prestigious silver creek ranch community, a community whose homes all sit on wooded oversized acre + lots. It provides easy commute into Houston metro as well as college station work centers. Light deed restrictions and thoughtfully designed home plans. Sagewood plan features 2597s.f. of space with 3/4 generous bedrooms(study can serve double duty as 4th), it has sprawling views from every corner of the great room. Each home has a water well and aerobic system, the flexibility of this plan allows the three bedrooms plus study and 2.5 baths. The 3 car garage allows for abundance of storage and the covered oversized back patio area is the ideal setting for a relaxing lifestyle and enjoy your slice of Texas. Additional plans and lots are available, reach out for information.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '65766' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.85' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266441' WHERE `Matrix_Unique_ID` = '212526436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:18.787' ,`MLSNumber` = '26969315' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361701' ,`Longitude` = '-95.388687' ,`PhotoCount` = '28' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Hills' ,`StreetNumber` = '12230' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Deer Trail Estates -SOUGHT AFTER VALLEY BREEZE plan 1/3 acre lot-4 BEDROOMS, GAMEROOM, STUDY - island kitchen –\r\nback patio - very well-designed floorplan. It even has the all-important home office (first floor study). Attractive front elevation\r\nwith 2 and could be 3 car garage. The 2nd floor master has a lovely bathroom with a large semi frameless shower, great\r\nstorage, and a large walk-in master closet. The island kitchen has beautiful cabinets and granite countertops look towards the\r\nfamily room. 3 secondary bedrooms are located upstairs. They share a spacious bath, and both have great closet spaces. This\r\none is ready now, so come and visit the sales office (ASK ABOUT ANY BUILDER SPECIALS) at 12376 North Chestnut Hills, in\r\nConroe. The sales office is open from 10:00 AM to 6:00 PM (Mon, Thurs, Fri, Sat), and 12:00 noon to 6:00 PM on Sunday.' ,`Acres` = '0.3673' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEER TRAIL ESTATES 03, BLOCK 3, LOT 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '16000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266441' WHERE `Matrix_Unique_ID` = '212558047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:58.050' ,`MLSNumber` = '47848282' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362149' ,`Longitude` = '-95.387976' ,`PhotoCount` = '24' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '388055.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Place' ,`StreetNumber` = '6006' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home Construction will be Completed in November The New Mountain Mesa Floorplan. It’s a Two Story Four Bedroom\r\nwith the Master Down, 3 CAR GARAGE- 1/3 acre LOT-three full bedrooms upstairs with game room. Brick/Stone attractive\r\nFront elevation with three-sided Acme brick with rear covered patio. Primary bedroom is Luxurious with spa like Bath that has\r\na freestanding tub with a Separate Semi Frameless Shower, Dual Vanity area with a huge walk-in closet.. quality cabinets and\r\nattractive Granite countertops. Stainless steel appliances. Blinds and Garage Door Opener included. The home has luxury\r\nvinyl plank flooring in all common areas and carpet in the bedrooms. It’s wired for an Alarm system.' ,`Acres` = '0.3769' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, BLOCK 2, SEC 3 DEER TRAIL ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16418' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266441' WHERE `Matrix_Unique_ID` = '212558190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:58.143' ,`MLSNumber` = '34028258' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362002' ,`Longitude` = '-95.388132' ,`PhotoCount` = '8' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Place' ,`StreetNumber` = '6002' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home Construction will be Completed in September, The New Sundance Floorplan. It’s a Two Story Four Bedroom with\r\nthe Master Down, 3 CAR GARAGE- MONSTER LOT-three full bedrooms upstairs with game room. Brick/Stone attractive Front\r\nelevation with three-sided Acme brick with rear covered patio. Primary bedroom is Luxurious with spa like Bath that has a\r\nfreestanding tub with a Separate Semi Frameless Shower, Dual Vanity area with a huge walk-in closet.. quality cabinets and\r\nattractive Granite countertops. Stainless steel appliances. Blinds and Garage Door Opener included. Entry is open to below\r\nentry. The home has luxury vinyl plank flooring in all common areas and carpet in the bedrooms. It’s wired for an Alarm\r\nsystem. Ceiling fans in the family room, game room and PRIMARY bedroom.' ,`Acres` = '0.4646' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Blk 2, Sec 3 Deer Trail Estates' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20239' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266441' WHERE `Matrix_Unique_ID` = '212558270' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:18.927' ,`MLSNumber` = '58140443' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344156' ,`Longitude` = '-95.524392' ,`PhotoCount` = '21' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Birch' ,`StreetNumber` = '749' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1934' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wedgewood Forest - New Construction to be complete in December. Aspen Place Floorplan - Elevation C. Three spacious bedrooms plus study all on single floor. Fantastic kitchen - 3 side brick exterior - newly designed & very functional floorplan, home office, attractive front elevation as well as a covered back patio, big lot. The primary bedroom has a luxurious bath with freestanding tub & separate semi-frameless shower, double sink vanity, great storage & big walk-in closet. The kitchen boasts attractive cabinets & granite countertops, and it overlooks the family room. Secondary bedrooms share a spacious bath & both have great closet space. Come & visit builder sales office (ask about specials) at 302 Pitch Pine Ct, Conroe 77304.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16, BLOCK 2, WEDGEWOOD FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9020' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266442' WHERE `Matrix_Unique_ID` = '212568464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:55.300' ,`MLSNumber` = '54069796' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345403' ,`Longitude` = '-95.523572' ,`PhotoCount` = '22' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '346350.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Birch' ,`StreetNumber` = '755' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home construction complete in November. Hillcrest floorplan is a one story with 3 bedrooms, 2 full baths & a Study. The study has French doors. Open Kitchen with White cabinets, white subway tile backsplash with granite countertops overlooking family room. Stainless steel appliances, Blinds & Garage Door Opener are included. Upgraded front door with Glass inserts. The home has luxury vinyl plank flooring in all common areas & carpet in the bedrooms. The Primary bedroom is in the rear of the home for additional privacy, & the spa like bath has Freestanding tub with a Separate Semi Frameless Shower, dual vanity area with Huge closet. Ceiling fans in the Primary bedroom & Family room. Secondary bedrooms share a spacious bath, & both have great closet space. It has three-sided exterior Acme brick with a covered patio & Alarm panel. Fully sodded front and back yard. Please visit the Sales Office at 302 PITCH PINE COURT, CONROE 77304. OPEN HOUSE 10-6 (M-TUES,& FRI), 12-6 (S&S)' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17, Block 3, Wedgewood Forest Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266442' WHERE `Matrix_Unique_ID` = '212571097' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:14:16.640' ,`MLSNumber` = '58600134' ,`ListAgentFullName` = 'Denise Houser' ,`ListOfficeName` = 'Houser Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558477' ,`Longitude` = '-95.657500' ,`PhotoCount` = '22' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '427990.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Lake' ,`StreetNumber` = '1815' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '~Introducing 1815 Shadow Lake Dr located in the high demand Patio section of Greatwood Lakecrest~ EXTRORDINARY Oversize Lot with extra wide yard space directly to the left~ Enjoy the Panoramic views of the back yard from Breakfast, Living Room and Primary Bedroom~ HARDWOODS, PLANTATION SHUTTERS, DOUBLE PANE WINDOWS, SPRINKLERS FRONT & BACK~OPEN FLOWING FLOOR PLAN, Light & Bright and maintained to perfection by the original owner~ Split Floor Plan allows Privacy for all Bedrooms & the Study~ Primary Bath boasting GRANITE COUNTERS, SEAMLESS SHOWER & TILE FLOORING~ Open Kitchen to family room with STAINLESS APPLIANCES, GAS COOKTOP, Double Ovens, Built In Refrigerator, Microwave and Dishwasher~ Solid Surface Avanza Counter Tops~ AC replaced in Sept 2021 Boasting Low Electrical Bills per the Seller, Furnace replaced in 2018, Roof in 2016~ Lovely property, close proximity to fine dining, medical facilities, trails, parks, catch & release fishing, zoned to Campbell Elementary~ NEVER FLOODED' ,`Acres` = '0.2533' ,`Area` = '30' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD B-170 SEC 1, BLOCK 2, LOT 19' ,`LotDesciption` = 'In Golf Course Community,Patio Lot,Subdivision Lot' ,`LotSize` = '11032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood B-170' ,`TaxAmount` = '7811' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266442' WHERE `Matrix_Unique_ID` = '212875502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:13:42.317' ,`MLSNumber` = '92838103' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859418' ,`Longitude` = '-95.193248' ,`PhotoCount` = '41' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Cardin' ,`StreetNumber` = '9527' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super nice and spacious Hillcrest-B designed for today\'s lifestyles. Defined Entry allows easy access to a private study. Exceptional kitchen with GE appliances includes lots of cabinetry including 42\" upper cabinets, and ample granite countertop space for food prep, baking, or creating to your heart\'s content! 7\' long breakfast bar and huge walk-in pantry add the finishing touches to this designer-detailed kitchen. Open to a flexible size Dining Area and Great Room with 10\' ceilings and easy access to the covered Patio! Primary Suite gives ample bedroom space and a luxury bath including a free-standing tub, separate shower, dual vanity sinks, and large walk-in closet! Secondary bedrooms are thoughtfully designed with space in mind. Great two-car garage with garage door opener, tankless hot water heater, and easy access to the kitchen. Full sodded yard and back yard fenced including 3\' access gate. This is a fabulous home and a must-see!' ,`Acres` = '0.136' ,`Area` = '2' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 TIDWELL LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5922' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266442' WHERE `Matrix_Unique_ID` = '212883712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:58.317' ,`MLSNumber` = '93008488' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345147' ,`Longitude` = '-95.524310' ,`PhotoCount` = '10' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '389750.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Birch' ,`StreetNumber` = '740' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sundance Plan 2-story, 4 bedroom, 2.5 bath, & game room. 2463 sq ft. Beautiful entry with 18’ ceiling leading to your spacious open living/dining/kitchen. fantastic covered patio too! Lots of windows & natural lighting! Primary Suite is elegant & spacious, box framed ceiling 10’ height, large walk-in closet, dual sinks, free-standing soaker tub, over-sized separate shower, semi-frameless glass enclosure! Kitchen with 42” white cabinets, white subway tile backsplash & granite countertops, GE Energy Star Stainless Steel Appliances, Gas Range with 5 burners & griddle, electric oven, under-counter slide out microwave! 7’ Counter-top height breakfast bar gives plenty of seating & extra space! Quiet, finger-tip control dishwasher, durable stainless-steel sink with arch neck chrome faucet. Designer Vinyl Plank Flooring throughout living and wet areas, soft carpet in all bedrooms, stairs, & huge Game Room. Powder Room on first floor & storage under stair well. Gorgeous home with great value!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 3, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8359' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266443' WHERE `Matrix_Unique_ID` = '213298746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:23:53.600' ,`MLSNumber` = '17519611' ,`ListAgentFullName` = 'Kitten Leopold' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510023' ,`Longitude` = '-95.031646' ,`PhotoCount` = '38' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '267900.00' ,`Status` = 'Active' ,`StreetName` = 'Mariner' ,`StreetNumber` = '3108' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Spacious 4 Bed 2 Bath Home with Privacy Fence and Large Backyard in Clear Creek School District & walking distance to Clear Falls Education Village. The home has Ceramic Tile Wood Look Flooring and Fresh Paint throughout. The living room is very large with lots of windows for natural lighting and has high ceilings and a ceiling fan to keep the room extra cool! The kitchen has white, soft close cabinets, stainless steel appliances, refrigerator, stove/oven, built-in microwave and dishwasher, marble countertops and decorative tile backsplash, large pantry and tons of cabinet space! The laundry room is very large. The master bedroom is very large with 2 walk-in closets and a ceiling fan to keep it extra cool. The master bathroom has a beautiful white vanity with marble countertop. The spare bedrooms all have walk in closets and ceiling fans. Large backyard is fenced in with a wooden privacy fence! Won\'t last long! Schedule your showing today! Room measurements are approximate.' ,`Acres` = '0.1848' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 32 R BASQUEZ SUR LOT 9 BLK 2 BAY RIDGE SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266443' WHERE `Matrix_Unique_ID` = '213376667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:55.487' ,`MLSNumber` = '44828251' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859418' ,`Longitude` = '-95.193248' ,`PhotoCount` = '37' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Cardin' ,`StreetNumber` = '9603' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a single level home that offers an open design concept, spacious rooms, lots of natural light,\r\nwith luxury owner\'s suite including free-standing soaking tub, spacious shower and walk-in closet? Your\r\nrefuse from a busy day! This exceptional new home, designed for today\'s living, has it all! 3 bedrooms, \r\n2 baths, fabulous open kitchen with breakfast bar, lots of cabinetry and \r\ngranite countertops provide plenty of space to perform sophiticated tasks for all culinary icons! GE \r\nGas Range with 5 burners and griddle, Microwave with cabinet shroud vented to the outside, enery \r\nsavings dishwasher, stainless steel dual bowl sink with garbage disposal, over-sized area in garage \r\n for hobbies, workshop, or storage. Garage door opener and mini-blinds included!\r\nSeparate spacious laundry room inside home. One of DH Homes most popular single level \r\nhomes!' ,`Acres` = '0.136' ,`Area` = '2' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 TIDWELL LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5923' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266443' WHERE `Matrix_Unique_ID` = '213429309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:29.120' ,`MLSNumber` = '29358351' ,`ListAgentFullName` = 'Caroline Bean' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766783' ,`Longitude` = '-95.502299' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '13' ,`ListPrice` = '5995000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberglen' ,`StreetNumber` = '10803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new construction by Build 48 in Hunter\'s Creek area. This expansive home of 7,530 SF sits on a 29,750 SQFT cul-de-sac lot and features 5 bed, 5 bath plus 2 half baths. First floor primary bedroom suite with coffee bar, large walk-in closet, en-suit bathroom with double vanities, dual water closets, soaking tub and shower. Other home features include study, mud room, wine room, 3-car garage, second floor game room and much more.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'BUILD 48' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 TIMBERGLEN SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '29750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberglen' ,`TaxAmount` = '35487' ,`TaxRate` = '2.1325' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266443' WHERE `Matrix_Unique_ID` = '213472819' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:55.610' ,`MLSNumber` = '8106143' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859418' ,`Longitude` = '-95.193248' ,`PhotoCount` = '40' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Cardin' ,`StreetNumber` = '9611' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super nice and spacious Oak Forest-B designed for today\'s lifestyles. Nice, defined Entry/Foyer allows easy access to a private study. Exceptional kitchen with GE appliances and ample cabinetry including 42\" upper cabinets, and ample granite countertop space for food prep, baking, or creating to your heart\'s content! A 7\' long breakfast bar and huge walk-in pantry add the finishing touches to this designer-detailed kitchen. Open to a flexible size Dining Area and Great Room with 10\' ceilings with access to the covered Patio! Primary Suite gives ample bedroom space and a luxury bath including a freestanding tub, separate shower, dual vanity sinks, and large walk-in closet! Secondary bedrooms are thoughtfully designed with space in mind. Great two-car garage with garage door opener, tankless hot water heater, and easy access to the kitchen. Full sodded yard and back yard fenced including 3\' access gate.' ,`Acres` = '0.136' ,`Area` = '2' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 TIDWELL LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5924' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266444' WHERE `Matrix_Unique_ID` = '213512933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:15.160' ,`MLSNumber` = '26411941' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859418' ,`Longitude` = '-95.193248' ,`PhotoCount` = '41' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Cardin' ,`StreetNumber` = '9607' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New, very spacious Hillcrest-B designed for today\'s lifestyles. Defined Entry allows easy access to a private study. Exceptional kitchen with GE appliances includes lots of cabinetry including 42\" upper cabinets, and ample granite countertop space for food prep, baking, or creating to your heart\'s content! A 7\' long breakfast bar and huge walk-in pantry add the finishing touches to this designer-detailed kitchen. Open to a flexible size Dining Area and Great Room with 10\' ceilings and easy access to the covered Patio! Primary Suite gives ample bedroom space and a luxury bath including a freestanding tub, separate shower, dual vanity sinks, and large walk-in closet! Secondary bedrooms are thoughtfully designed with space in mind. Great two-car garage with garage door opener, tankless hot water heater, and easy access to the kitchen. Full sodded yard and back yard fenced including 3\' access gate. This is a fabulous home and a must-see!' ,`Acres` = '0.136' ,`Area` = '2' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 TIDWELL LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5923' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266444' WHERE `Matrix_Unique_ID` = '213577279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:23:37.067' ,`MLSNumber` = '48122826' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837728' ,`Longitude` = '-95.798196' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '344738.00' ,`Status` = 'Active' ,`StreetName` = 'Pale Fox' ,`StreetNumber` = '4419' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! This Fairbanks home design features 3 bedrooms, 2 baths and 2 car garage. Elegant dining room tucked off foyer. Beautiful maple cabinets, quartz countertops with low bar top and a farmhouse sink in kitchen. Relax in the spacious primary bedroom with walk-in closet and luxurious bath. Double sinks and shower in owner\'s bath. Covered patio in backyard, perfect for entertaining.\r\nCommunity comforts include a swimming pool, pavilion, playground, walking and bike trails. Conveniently located near Westpark Tollway and Katy Freeway for easy access to Downtown Houston and the Energy Corridor. Enjoy popular shopping, dining and entertainment. Students are zoned to Katy ISD, a TEA-rated \"Recognized\" school district. Offered by: K. Hovnanian Houston Katy Pointe II, LLC.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '12/5/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '749' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.087706' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266444' WHERE `Matrix_Unique_ID` = '213636501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:28:55.330' ,`MLSNumber` = '25621153' ,`ListAgentFullName` = 'Kathryn Larkin' ,`ListOfficeName` = 'TACK Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942021' ,`Longitude` = '-95.632083' ,`PhotoCount` = '20' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Kerman' ,`StreetNumber` = '11503' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming property on corner lot. Fresh paint, tile in all common areas with recent carpet (10/22) in all bedrooms. All water pipes replaced with pex pipes in 2020, water heater replaced in 2020. A/C Condensing unit recently replaced. Features a Kitchen Aid commercial style gas range with modern Kitchen Aid hood vent. Room for large refrigerator. Great floor plan for entertaining. Kitchen open to dining room and living room with covered back patio right off the living room. Zoned to Award winning Cypress Fairbanks School District.' ,`Acres` = '0.1768' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 36 BONAIRE SEC 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LAMKIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonaire' ,`TaxAmount` = '4130' ,`TaxRate` = '2.438' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266445' WHERE `Matrix_Unique_ID` = '213856495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:55.767' ,`MLSNumber` = '26374458' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362002' ,`Longitude` = '-95.388132' ,`PhotoCount` = '6' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '349305.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Hills' ,`StreetNumber` = '12234' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Most popular single level home with brick, stone! 3 spacious bedrooms, 3 full baths, open plan design with huge Living/Dining combination, private study, and a 3-car garage! Chefs dream kitchen with lots of storage, cabinetry has 42\" uppers, granite countertops, stainless steel dual bowl undermount sink, upgrade arch neck kitchen faucet with sprayer, fabulous walk-in pantry, and breakfast bar at the center island creating the heart of this home! Very nice sized covered patio opens to an incredibly large back yard. Primary Suite is that perfect get-away oasis with space plenitude and a luxury bath with free standing soak and relax tub, spacious separate shower, and an immense walk-in closet with two separate shelving units! Private study with closet/storage or can be used as a spacious bedroom! Lots of natural light give this home perfection!' ,`Acres` = '0.4646' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Blk 3, Sec 3 Deer Trail Estates' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '16000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266445' WHERE `Matrix_Unique_ID` = '213922147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:19:45.770' ,`MLSNumber` = '68989007' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '344995.00' ,`Status` = 'Active' ,`StreetName` = 'Mandra' ,`StreetNumber` = '2930' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Make new memories in this beautiful KB Home in Olympia Falls, which features a brick front, volume ceilings, extended entry, and an open great room. Spend all day in the kitchen, complete with Silestone countertops, stainless steel Energy Star® appliances, 42-in. cabinets, and pendant lighting. The spa-like primary suite boasts extended dual vanities and a shower with a Moen Chateau® WaterSense showerhead. Additional home features include full gutters. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266445' WHERE `Matrix_Unique_ID` = '213932831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:19:54.400' ,`MLSNumber` = '47539788' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778666' ,`Longitude` = '-95.349876' ,`PhotoCount` = '35' ,`PostalCode` = '77026' ,`RoomCount` = '14' ,`ListPrice` = '477400.00' ,`Status` = 'Active' ,`StreetName` = 'Maury' ,`StreetNumber` = '1909' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Hardy Skyline! Each of these contemporary four story homes feature downtown views from the roof deck! Located in the Historic Near Northside neighborhood and minutes from downtown on the newly completed Elysian/Hardy access bridge. Modern finishes adorn the homes with two different finish packages available. Each home features a home office with covered outdoor living space and private front yards on each unit. A select few have a private driveway. HOA Maintains all landscaping for the community. Pre-Construction pricing. Estimated completion by end of 2022. Finishes available in our showroom to view by appointment.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Cityside Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 HARDY POINT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Near Northside' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266445' WHERE `Matrix_Unique_ID` = '214052431' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:25:56.353' ,`MLSNumber` = '78823852' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778666' ,`Longitude` = '-95.349876' ,`PhotoCount` = '27' ,`PostalCode` = '77026' ,`RoomCount` = '14' ,`ListPrice` = '459990.00' ,`Status` = 'Active' ,`StreetName` = 'Maury' ,`StreetNumber` = '1909' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Hardy Skyline! Each of these contemporary four story homes feature downtown views from the roof deck! Located in the Historic Near Northside neighborhood and minutes from downtown on the newly completed Elysian/Hardy access bridge. Modern finishes adorn the homes with two different finish packages available. Each home features a home office with covered outdoor living space and private front yards on each unit. A select few have a private driveway. HOA Maintains all landscaping for the community. Pre-Construction pricing. Estimated completion by end of 2022. Finishes available in our showroom to view by appointment.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Cityside Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 HARDY POINT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Near Northside' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266446' WHERE `Matrix_Unique_ID` = '214052603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:10:34.160' ,`MLSNumber` = '63037068' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Dianna Navarro' ,`SellingOfficeName` = 'Redfin Corporation' ,`Latitude` = '30.122545' ,`Longitude` = '-95.243282' ,`PhotoCount` = '24' ,`PostalCode` = '77365' ,`RoomCount` = '5' ,`ListPrice` = '245000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Toronado Ridge' ,`StreetNumber` = '22443' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1786' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charming one story home in Valley Ranch. The home offers a split floor plan with 3 bedrooms, 2 baths, open-concept living area & high ceilings. Formal dining room upon entry could also be used as a home office. Upgraded vinyl plank & tile flooring throughout. Neutral colors. The primary suite features a soaking tub, separate shower, dual-sink vanity & walk-in closet. Covered patio & storage shed in the backyard. Community amenities include a pool, splash pad, playground, lakes & walking trails. Home is within walking/biking distance to the elementary & middle schools, and less than 3 miles from the high school. Easy access to 99 & 59. Don\'t miss this one!' ,`Acres` = '0.1612' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S941202 - VALLEY RANCH 02, BLOCK 2, LOT 46' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7021' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Valley Ranch' ,`TaxAmount` = '6737' ,`TaxRate` = '3.2331' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266446' WHERE `Matrix_Unique_ID` = '214137627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:14:12.487' ,`MLSNumber` = '26797487' ,`ListAgentFullName` = 'Ana De Los Reyes' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146644' ,`Longitude` = '-95.525793' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '1115000.00' ,`Status` = 'Active' ,`StreetName` = 'Fremont Ridge' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Loop' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning home with soaring ceiling and open floor plan! Come preview the lovely home built by Partners In Building. Home as master and guest room down, spacious kitchen with beautiful granite counters and wood cabinetry. The high ceilings and wall of windows in the family area really make this area of the home the place to be! 3 bedrooms up along with the spacious media room with includes all audio and video equipment! Outdoor kitchen under a covered roof, beautiful pool with spa and waterfall, perfect place to entertain friends and family' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 23' ,`LotDesciption` = 'Other' ,`LotSize` = '11570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park 23' ,`TaxAmount` = '20444' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266446' WHERE `Matrix_Unique_ID` = '214210135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:26:15.463' ,`MLSNumber` = '79432353' ,`ListAgentFullName` = 'Marilyn S Martinez' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758887' ,`Longitude` = '-95.531788' ,`PhotoCount` = '21' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '1099000.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial' ,`StreetNumber` = '11829' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3957' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The existing mid-century modern home with many windows is quite large and has a wonderful feel to it. This is a beautifully wooded large lot zoned to Memorial High School, Memorial Middle School, and Frostwood Elementary School to build your new home! You could live here while you plan new construction or make this into your own lovely home! You also have close proximity to St. Francis Episcopal School and The Kinkaid School, minutes from I-10, shopping, restaurants, Trader Joe\'s, Whole Foods, and more!' ,`Acres` = '0.4132' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 LAKEVIEW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lakeview' ,`TaxAmount` = '19046' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266446' WHERE `Matrix_Unique_ID` = '214294803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:40:24.830' ,`MLSNumber` = '30948076' ,`ListAgentFullName` = 'Stacey Adkins' ,`ListOfficeName` = 'One Solution Realty' ,`SellingAgentFullName` = 'Unjoo Azbill' ,`SellingOfficeName` = 'Greater Houston REP, Inc.' ,`Latitude` = '29.690618' ,`Longitude` = '-95.915114' ,`PhotoCount` = '27' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Divot' ,`StreetNumber` = '8411' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming one-story house has an attractive three-sided brick façade, an open floor plan, 9\' ceilings, an extended covered patio, 3 bedrooms, and 2 full bathrooms! Numerous additional features and finishes are available to you as well, such as tile flooring throughout the main living areas, granite countertops in the kitchen and bathrooms, stainless steel appliances, a neutral color scheme, a garden tub, and a separate shower with dual vanities in the primary bathroom, ceiling fans, Rinnai tankless water heaters, LED lighting, front and back gutters, a complete sprinkler system, 16 SEER HVAC, and a whole house water softener. The washer/Dryer and Refrigerator will stay with the home. Call today for your private tour.' ,`Acres` = '0.144' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POLO RANCH SEC 2, BLOCK 1, LOT 34' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6273' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Polo Ranch Sec 2' ,`TaxAmount` = '7100' ,`TaxRate` = '3.2779' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266447' WHERE `Matrix_Unique_ID` = '214409125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:19:30.860' ,`MLSNumber` = '56325269' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555399' ,`Longitude` = '-95.500466' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '359995.00' ,`Status` = 'Active' ,`StreetName` = 'Mandra' ,`StreetNumber` = '2922' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Cherish every moment spent in this lovely KB Home in Olympia Falls, boasting a beautiful brick front and an open great room. Try a new recipe in the kitchen, fully equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities and a shower with a Moen Seena® WaterSense showerhead. Additional home features include an extended covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266447' WHERE `Matrix_Unique_ID` = '214410755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:19:13.060' ,`MLSNumber` = '56044201' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554511' ,`Longitude` = '-95.500155' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '329995.00' ,`Status` = 'Active' ,`StreetName` = 'Damasi' ,`StreetNumber` = '2023' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Create unforgettable memories in this stunning KB Home in Olympia Falls, boasting a brick front, extended entry, and an open great room. Prepare incredible feasts in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. Complete with extended dual vanities and a shower with a Moen Chateau® WaterSense showerhead, the primary suite is ideal for relaxation. Additional home features include a covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266447' WHERE `Matrix_Unique_ID` = '214411288' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:31:02.463' ,`MLSNumber` = '98756529' ,`ListAgentFullName` = 'Richard Ray' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = 'Jason Wyche' ,`SellingOfficeName` = 'Traditions Realty' ,`Latitude` = '29.539062' ,`Longitude` = '-95.676673' ,`PhotoCount` = '22' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '479000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Yaupon Creek' ,`StreetNumber` = '623' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom home in sought after Greatwood Lakes community. 4 spacious bedrooms, 3.5 baths with an open floor-plan, high ceilings, and hardwood floors throughout living areas.Home includes a study, large living room with custom fireplace, upgraded kitchen with granite countertops, walk-in pantry, and Texas-sized island. Large Primary Bedroom with double closets, double vanities and a jacuzzi tub. Large covered patio with natural gas connection. Premier home for entertaining with easy access to US-59.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Greatwood Lakes Sec 1, Block 2, Lot 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9309' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'VELASQUEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Lakes Sec 1' ,`TaxAmount` = '10485' ,`TaxRate` = '3.1948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266447' WHERE `Matrix_Unique_ID` = '214418284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:23:48.817' ,`MLSNumber` = '12027115' ,`ListAgentFullName` = 'Emil Ramirez' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.628416' ,`Longitude` = '-96.105867' ,`PhotoCount` = '48' ,`PostalCode` = '77485' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1093' ,`StreetNumber` = '2367' ,`StreetSuffix` = 'Road' ,`City` = 'Wallis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful renovated 3 BR home on 2.5 acres in Wallis. The home has all new roof, new HVAC system, new PEX plumbing, new well pump and equipment, granite counters, updated tile bathrooms, new soft close cabinets, stainless appliances, and fresh paint throughout! The home has a shop that can be used as a 2 car garage plus 2 car carport. This home is a must see!' ,`Acres` = '2.5' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A093 J STEVENS' ,`LotDesciption` = 'Other' ,`LotSize` = '75402' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '54 - Brazos' ,`SchoolElementary` = 'BRAZOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOS HIGH SCHOOL' ,`SchoolMiddle` = 'BRAZOS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wallis' ,`TaxAmount` = '3702' ,`TaxRate` = '1.8402' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1913' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266448' WHERE `Matrix_Unique_ID` = '214425455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:37.437' ,`MLSNumber` = '75095229' ,`ListAgentFullName` = 'Nicole Shields' ,`ListOfficeName` = 'CRI Real Estate Services' ,`SellingAgentFullName` = 'Tamara Courtney' ,`SellingOfficeName` = 'CRI Real Estate Services' ,`Latitude` = '30.240707' ,`Longitude` = '-95.501654' ,`PhotoCount` = '39' ,`PostalCode` = '77384' ,`RoomCount` = '6' ,`ListPrice` = '410000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ripplewood' ,`StreetNumber` = '2474' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller!!!! Welcome home to this custom built, corner lot home in the highly desired Carriage Hills neighborhood. Situated on just under 1/2 acre, this property features a wrap around porch and great curb appeal. Step inside an open floor plan complete with formal dining room, 2 story ceilings in living room, 2 sets of French doors off kitchen for back patio and front porch access. Kitchen with ample cabinets, dishwasher a few years old, panty half bath off kitchen, laundry room with cabinets and window.Custom blinds throughout home. Recently installed carpet on the stairs and upper level. Both HVAC replaced one in 2019 other in 2022. Septic recently serviced. Zoned to The Woodlands Schools, close to many restaurants, shopping and convenient access to I-45, This is a must see!!' ,`Acres` = '0.4729' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CARRIAGE HILLS 01, BLOCK 1, LOT 39' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '20600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Carriage Hills 01' ,`TaxAmount` = '5771' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266448' WHERE `Matrix_Unique_ID` = '214458687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:59:34.640' ,`MLSNumber` = '13367575' ,`ListAgentFullName` = 'Karla Coleman Heath' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005144' ,`Longitude` = '-95.146463' ,`PhotoCount` = '35' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Summit Pines' ,`StreetNumber` = '8622' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this STUNNING home in the Pines of Atascocita of Humble. This stunning home features 4 spacious bedrooms, 2.5 bathrooms, and an attached 2-car garage. The open floorplan of this home is very functional and convenient, perfect! Enjoy your chef’s kitchen, loaded with luxe amenities. Features include high-end solid wood cabinetry, a gas range, sprawling Granite countertops, stylish backsplash, and a bright breakfast nook. The living room features a cozy fireplace, timeless tile surround and chic white mantle, large windows, and an upgraded ceiling fan. Downstairs you’ll find a dining room for entertaining & hosting and upstairs you’ll find a large game room for fun family nights! The primary suite features beautifully crafted hardwood floors, a large walk-in closet, and a luxury ensuite bathroom. Step outside and enjoy your backyard with a large covered patio, extended patio, mature trees, and pristine lawn. Zoned to Humble ISD with easy access to I-69.' ,`Acres` = '0.1641' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 5 PINES OF ATASCOCITA SEC 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '649' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pines Atascocita' ,`TaxAmount` = '5462' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266448' WHERE `Matrix_Unique_ID` = '214488312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:58.427' ,`MLSNumber` = '25727599' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.173359' ,`Longitude` = '-95.754396' ,`PhotoCount` = '6' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '533855.00' ,`Status` = 'Active' ,`StreetName` = 'Brookfield' ,`StreetNumber` = '25' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Villages of Heritage Point - NEW CONSTRUCTION! Estate Series Floorplan - Great 1 story floorplan with attached private casita quarters with their own private entrance off the front courtyard. Casita has walk in shower (not tub) in bathroom. Very open, nice size covered back porch. Large 15,200 SF lot with plenty of room for future pool. 42\" upper kitchen cabinets, stainless steel appliances, vent hood with cabinet shroud, under counter pull out microwave, full house luxury vinyl plank flooring-no carpet. Impressive owners suite, free standing tub, separate shower and large utility room. Fenced backyard, full sod, full window blinds included. Only 5 large lots! Don\'t wait. Magnolia ISD.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 1, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages of Heritage Point' ,`TaxAmount` = '' ,`TaxRate` = '2.9787' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266448' WHERE `Matrix_Unique_ID` = '214505066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:16:10.047' ,`MLSNumber` = '56301733' ,`ListAgentFullName` = 'Heather Coggin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671006' ,`Longitude` = '-94.651849' ,`PhotoCount` = '25' ,`PostalCode` = '77514' ,`RoomCount` = '4' ,`ListPrice` = '175500.00' ,`Status` = 'Active' ,`StreetName` = 'Rivers' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Road' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Huge lot with fenced in backyard! Manufactured home with kitchen Island, breakfast bar & built in appliances, huge master suite w/ office, walk in closet, dual vanity, and garden tub and shower, 2 living areas, spacious utility, thermopane windows, & fireplace. Near by hunting, fishing, boating and tons of bird watching at Anahuac Wildlife Refuge.' ,`Acres` = '1' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '464 TR 4C-0-1 G A WILSON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'G A WILSON' ,`TaxAmount` = '1170' ,`TaxRate` = '2.6602' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266449' WHERE `Matrix_Unique_ID` = '214546310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:19.083' ,`MLSNumber` = '52637834' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361412' ,`Longitude` = '-95.388688' ,`PhotoCount` = '7' ,`PostalCode` = '77303' ,`RoomCount` = '10' ,`ListPrice` = '384155.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Hills' ,`StreetNumber` = '12247' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous Community setting northeast of down-town Conroe in a wonderful country setting. If you\'re looking for spacious yards, this is for you! Most homesites are over 1/3 acre! The popular Valley Breeze two-story home is incredibly spacious with 4 ample sized bedrooms including a huge Primary Suite with all bedrooms upstairs and a fabulous game room. First floor main living with centralized kitchen opening to the huge family room and formal dining. Nice breakfast bar, pantry, and additional storage, Stainless Steel appliances include a 4-gas burner with center griddle, under-counter drawer top-load microwave, cabinet-shrouded vent-hood vents to the outside, 42\" upper kitchen cabinets with crown molding, kitchen electrical outlets positioned under upper kitchen cabinets, granite kitchen counter-tops, window blinds throughout, garage door opener, tankless hot water heater located in the huge 4 car garage! This home has it all! Energy efficiency and quality are built!' ,`Acres` = '0.3673' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric,Central Gas,Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 2, Section 3' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '13628' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266449' WHERE `Matrix_Unique_ID` = '214689513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:58.567' ,`MLSNumber` = '89101976' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.171808' ,`Longitude` = '-95.754953' ,`PhotoCount` = '5' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '409725.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverleaf' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! DH Homes beautiful Sundance 2-story floorplan. Very open plan design offering tall ceiling foyer, island kitchen w/abundant cabinet storage, huge walk-in pantry, casual dining room area, tankless water heater in the garage. Gameroom up w/all secondary bedrooms w/bath offering 2 separate vanity areas. The primary bath has a luxurious free-standing bathtub w/spacious separate shower. Full home Luxury Vinyl Plank hard surface flooring, no carpet! Very nice size 73\' wide lot w/plenty of backyard for a future swimming pool. Culdesac street and lots more to see. Hurry, don\'t miss this one. Magnolia ISD!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9293' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages of Heritage Point' ,`TaxAmount` = '' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266449' WHERE `Matrix_Unique_ID` = '214689662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:19.240' ,`MLSNumber` = '25281295' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.171717' ,`Longitude` = '-95.755252' ,`PhotoCount` = '5' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '376065.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverleaf' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! DH Homes beautiful new home design featuring 1 story Aspen Grove-C plan w/3 car \"front load\" garage (no tandem!) Full brick/stone exterior elevation. Covered back patio. Open floorplan w/ 9-10 ft ceilings and lots of natural light throughout. Island kitchen with Center Island Breakfast Bar. Cul-de-sac street. Freestanding luxury soaking tub in primary bathroom w/separate spacious shower and double vanity lavatory sinks. White shaker cabinets include 42\" uppers in Kitchen. . Full home Luxury Vinyl Plank flooring (no carpet) Full Home window blinds. Tankless water heater. The study could easily be used as a 4th bedroom w/full bath or can easily accommodate periodic guests. Don\'t miss this beauty on a 72 ft wide lot! Magnolia ISD! Zoned to Magnolia West HS. Great location and close to all conveniences!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 1, Sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9293' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages of Heritage Point' ,`TaxAmount` = '' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266450' WHERE `Matrix_Unique_ID` = '214690525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:19.380' ,`MLSNumber` = '95375318' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.171808' ,`Longitude` = '-95.754953' ,`PhotoCount` = '7' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '354375.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverleaf' ,`StreetNumber` = '22' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! DH Homes beautiful Oak Forest-A exterior, 1-story plan nestled in a quiet wooded community! 3-car garage front load (no tandem). Very open floor plan with 9-10 ft ceilings throughout. 11,951 SF Cul-de-sac lot. Full home brick/stone exterior. Full home window blinds included! Island kitchen w/white shaker cabinets w/abundant storage. Full home luxury vinyl plank flooring, no carpet. Covered back patio. The primary bath showcases a free-standing tub with double sink vanity and a separate shower. Front Study w/double french doors. Tankless water heater! Very functional living floorplan, Won\'t last. Magnolia ISD and zoned to Magnolia West High School! Great location and is convenient for shopping, parks, and recreation!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 1, Section 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11951' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Villages of Heritage Point' ,`TaxAmount` = '' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266450' WHERE `Matrix_Unique_ID` = '214692406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:07:58.690' ,`MLSNumber` = '9670849' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.172535' ,`Longitude` = '-95.754450' ,`PhotoCount` = '5' ,`PostalCode` = '77355' ,`RoomCount` = '9' ,`ListPrice` = '521455.00' ,`Status` = 'Active' ,`StreetName` = 'Brookfield' ,`StreetNumber` = '13' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! DH Homes amazing Estate series Briarwood 1 story floor plan! Elevation \"A\". This 3-car front load garage (no tandem!) is nestled in a quiet wooded community in Magnolia. Full brick/stone exterior. The grand entry foyer has 11 ft ceilings with the home having 9-10 ft ceilings throughout. Formal dining and breakfast room both for great family dinners and entertaining that could be carried out onto the large covered back patio! Cozy corner gas log fireplace in the family room. Butler\'s pantry w/wine refrigerator cutout cabinet opening for wine enthusiasts (wine fridge not included). Study w/double doors. His/Her separate closets in the primary bedroom! Freestanding bathtub with separate walk-in shower in primary bath. Oversized 15,200 SF lot 89\' wide x 170 deep! This amazing home has everything! Don\'t wait! Magnolia ISD zoned to Magnolia West High School.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Villages of Heritage Point' ,`TaxAmount` = '' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266450' WHERE `Matrix_Unique_ID` = '214754458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:05:55.890' ,`MLSNumber` = '28555163' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'DH Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345403' ,`Longitude` = '-95.523572' ,`PhotoCount` = '4' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Elm' ,`StreetNumber` = '690' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DH Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 2, Wedgewood Forest Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6076' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Wedgewood Forest' ,`TaxAmount` = '' ,`TaxRate` = '2.8863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266450' WHERE `Matrix_Unique_ID` = '214823375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:36:45.920' ,`MLSNumber` = '63779516' ,`ListAgentFullName` = 'Kimberly Weddel' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.321684' ,`Longitude` = '-95.468653' ,`PhotoCount` = '36' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Thomas' ,`StreetNumber` = '1102' ,`StreetSuffix` = 'Avenue' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will fall in love with this wonderful single family home on an oversized lot. This ranch home has 3 bedrooms and one bath; the garage has been converted and can be used as an additional family room, game room or bedroom.\r\nThis home has been very well maintained. The huge backyard has been recently fully fenced and is great for family events or just relaxing. The home has recent gutters, exterior siding, and a new front door. The interior has new paint, carpet, granite countertops, new tile in kitchen, includes a refrigerator and microwave. The seller added additional insulation and so much more. The utility room has recent paint and paneling and a small a/c to help in the summer. Located in a quiet subdivision that is close to all amenities. No HOA, No MUD, and lower taxes. Perfect for first time buyers or those looking to downsize. Hurry to see this awesome home! So much to offer for such a great price!' ,`Acres` = '0.2324' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LAWNDALE PARK, BLOCK 17, LOT 6' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10125' ,`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` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Lawndale Park' ,`TaxAmount` = '3689' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266451' WHERE `Matrix_Unique_ID` = '214825318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:18:55.900' ,`MLSNumber` = '15806751' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555372' ,`Longitude` = '-95.500386' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '349995.00' ,`Status` = 'Active' ,`StreetName` = 'Mandra' ,`StreetNumber` = '2918' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Settle down in this beautiful KB Home in Olympia Falls, complete with a stunning brick front and an open great room. Try a new recipe in the kitchen, fully equipped with granite countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. Featuring extended dual vanities and a shower with a Moen Chateau® WaterSense showerhead, the primary suite is ideal for relaxation. Additional home features include pre-wiring for flat-panel TVs, faux wood blinds, full gutters, and a covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266451' WHERE `Matrix_Unique_ID` = '215041504' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:18:38.757' ,`MLSNumber` = '63569451' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554553' ,`Longitude` = '-95.500185' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '384484.00' ,`Status` = 'Active' ,`StreetName` = 'Damasi' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Make new memories in this amazing KB Home in Olympia Falls, which boasts a beautiful brick front and open great room. Cook up new cuisines in the kitchen, complete with granite countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. Unwind in the tranquil primary suite, featuring extended dual vanities and a shower with a Moen Chateau® WaterSense showerhead. Additional home features include automatic sprinklers and faux wood blinds. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266451' WHERE `Matrix_Unique_ID` = '215041931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:26:16.387' ,`MLSNumber` = '29915230' ,`ListAgentFullName` = 'Carole Michalak' ,`ListOfficeName` = 'Coastal Dream Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578225' ,`Longitude` = '-95.041924' ,`PhotoCount` = '38' ,`PostalCode` = '77586' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Chelsea' ,`StreetNumber` = '1606' ,`StreetSuffix` = 'Place' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price reduced to BELOW appraised value due to relocation means INSTANT EQUITY!! Come see this amazing neighborhood, amazing house, and an amazing price!! These homeowners are crushed to have been relocated but hoping to find the perfect buyer for their 3 bedroom, two bath beauty. This home is located in the highly desirable neighborhood of El Lago and zoned to the magnet E-STEM elementary school, Ed White. It is steps away from a gorgeous water front park with private boat ramp, pavilion and tennis courts. The home has been updated throughout and features huge bedrooms and natural light from skylights and large beautiful windows. A huge living room, island kitchen, and breakfast bar make this home perfect for entertaining. Make an appointment to see this El Lago prize!' ,`Acres` = '0.2441' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 TAYLORCREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '97' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Taylorcrest' ,`TaxAmount` = '9565' ,`TaxRate` = '2.6666' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266451' WHERE `Matrix_Unique_ID` = '215045233' --> 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','215056387','1675266452','215056387','2023-01-30T17:22:24.950','91192119','Dee Dee Guggenheim Howes','Compass RE Texas, LLC','Stephen Hallmark','Berkshire Hathaway HomeServicePremier Properties','29.772197','-95.423147','29','77007','9','595000.00','Option Pending','Utah','1206','Street','Houston','3','1','4','3259','Single-Family','Ultimate urban lifestyle with Memorial Park, “A”-rated Memorial Elementary nearby, Starbucks and numerous dining options all within a 5-minute walk, in the highly sought-after Rice Military/Woodcrest area. You’ll enjoy understated elegance, from the high ceilings to the hardwood floors, painted millwork, and art nooks. The foyer introduces a first-floor living space along with a guest bedroom and ensuite bath. Anchored by a new, large island on the second floor, the kitchen offers breakfast bar seating, a dry bar with a 50-bottle wine fridge, and a storage pantry. Beside the kitchen is a spacious room that can be used as a formal dining room, home office, or playroom. The kitchen opens to a large family room with designer lighting, a faux fireplace, and balcony access. Upstairs, discover the large owner’s suite with a spa bath and walk-in closet. Two secondary suites with a shared bath and a utility room add convenience. Attached is a two-car garage with new custom storage solutions.','0.0463','16','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Mock Fireplace','1','Rice Military/Washington Corridor','Central Electric','0','LT 3 BLK 1 UTAH STUCCO COURT','Patio Lot','2019','Appraisal District','','','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','27 - Houston','MEMORIAL ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','HOGG MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required','Appraisal','3','Traditional','Utah Stucco Court','11687','2.3307','Public Sewer,Public Water','2008','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:18:20.880' ,`MLSNumber` = '23572424' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554443' ,`Longitude` = '-95.501022' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '347087.00' ,`Status` = 'Active' ,`StreetName` = 'Katalonia' ,`StreetNumber` = '2103' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy peace and quiet in this stunning KB Home in Olympia Falls, boasting a brick front, tile flooring, extended entry, and an open great room. Master new recipes in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. Relax in the serene primary suite, featuring extended dual vanities and a shower with a Moen Seena® WaterSense showerhead. Additional home features include faux wood blinds and a covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266452' WHERE `Matrix_Unique_ID` = '215057420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:59:10.600' ,`MLSNumber` = '28472548' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.979276' ,`Longitude` = '-95.252930' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Water Hwy' ,`StreetNumber` = '3006' ,`StreetSuffix` = '' ,`City` = 'Surfside Beach' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome home and location. Beachfront in Surfside Beach Estates II. Just Gorgeous!! Great floorplan with lots of decks windows, bathrooms, and much more. . A bedroom with a private bath downstairs, as well as a half bath off the living area. Upstairs is a large bedroom, with a closet and private bath with upper deck access, and the 3rd bedroom has a private bath and deck access. The fourth bedroom upstairs is adjacent to the hall bath. The tax account has additional property.' ,`Acres` = '0.5' ,`Area` = '5' ,`BuilderName` = 'Davison Property Dev' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 Surfside Beach Estates #2' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '10000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside Beach Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266452' WHERE `Matrix_Unique_ID` = '215069560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:29:49.630' ,`MLSNumber` = '20105344' ,`ListAgentFullName` = 'Kathy Matt' ,`ListOfficeName` = 'Elite Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003496' ,`Longitude` = '-95.643177' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '13' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Campwood' ,`StreetNumber` = '13834' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Custom Home on .3 acres in Rock Creek features 4 Bedrooms, 3.5 Baths and 4 Car Garage along with a chlorine Pool. This home also features an Elegant, two-story Foyer along with a Formal Dining Room, Butler\'s Pantry, Study/Home Office, Family Room, Game Room and a Large Media Room. Lots of Built-ins, Crown Mouldings and Walk-in Closets. The Large Kitchen features 5 Burner Gas Stove, Double Oven, Under Counter Lighting and Granite Counters. Situated in the CyFair School District this home is also conveniently located near shopping, restaurants, churches and medical facilities and offers easy access to SH 249, Hwy 290 and The Grand Parkway. Neighborhood amenities include: Fitness Center, Pool, Splash Pad, Trails, Basketball, Tennis and Pickleball Courts.' ,`Acres` = '0.3017' ,`Area` = '35' ,`BuilderName` = 'Stoneleigh' ,`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 North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 ROCK CREEK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rock Creek' ,`TaxAmount` = '16463' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266452' WHERE `Matrix_Unique_ID` = '215111397' --> 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','215165962','1675266453','215165962','2023-01-30T18:14:57.493','54680646','Yvonne Cazares','The Monarch Team, LLC','','','29.170118','-95.634009','25','77486','3','179000.00','Active','Countryside','421','Drive','West Columbia','2','0','3','1663','Single-Family','Welcome to 421 Countryside Dr, located in the Columbia Lakes community. This home offers 3 spacious bedrooms, a formal dining room, family room, and an 11,000 sqft lot. If you’ve been looking for a home to grow into and make your own, this may just be it. Contact your Realtor today to schedule a private showing.','0.2738','5','','','','','Sellers Disclosure','1','','1','West of the Brazos','Central Electric,Central Gas','1','COLUMBIA LAKES SEC 3 (A0133 M VARNER) BLK 33 LOT 6','Subdivision Lot','11927','Appraisal District','','600','0','','2','','0','','','','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Columbia Lakes Sec 1-2-3-4-5','4579','2.1863','Public Water,Septic Tank','1977','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:18:00.413' ,`MLSNumber` = '49492775' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553750' ,`Longitude` = '-95.502207' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '399995.00' ,`Status` = 'Active' ,`StreetName` = 'Domeniko' ,`StreetNumber` = '2026' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find everything you’re looking for in this gorgeous KB Home in Olympia Falls, boasting a brick front, tile flooring, extended entry, and an open great room. Whip up meals for guests in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The tranquil primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include a fully equipped security system, full gutters, and a covered patio. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia Falls' ,`TaxAmount` = '' ,`TaxRate` = '3.2629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266453' WHERE `Matrix_Unique_ID` = '215166961' --> 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','215236757','1675266453','215236757','2023-01-30T18:52:41.990','70756680','Manu Dyse','Newhomeprograms.com LLC','','','29.447966','-95.104918','16','77539','8','320000.00','Active','Strawberry Brook','6715','Lane','Dickinson','2','1','4','2280','Single-Family','Welcome home. This beautiful home is located in the Bay Colony Pointe West subdivision. Upon entry you will notice the Vaulted ceilings and updated features. The home invites you to relax and enjoy your surroundings. The upstairs entertainment area not only provides privacy but also allows for engagement as it overlooks the main floor. The large backyard has plenty of space for your options. The home has also been equipped in energy saving solar technology. Do not wait. Schedule your tour today!!!','0.1377','33','','','','','Sellers Disclosure','','','','League City','Central Gas','0','BAY COLONY POINTE WEST SEC 4 (2009) ABST 19, BLOCK 1, LOT 6,','Subdivision Lot','6000','Appraisal District','','600','0','','2','','0','','','','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany,Supra Keybox','Appraisal District','2','Traditional','Bay Colony Pointe West Sec 4','9508','3.4497','Water District','2011','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:43:39.120' ,`MLSNumber` = '24461713' ,`ListAgentFullName` = 'Patricia Himel' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.934699' ,`Longitude` = '-95.736173' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '1175000.00' ,`Status` = 'Active' ,`StreetName` = 'Onion Creek' ,`StreetNumber` = '18810' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4467' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful six bedroom home offers the best in suburban luxury living. Leading schools within one mile, world class amenities, nature, lakes, and more. Upon arrival, elegance of a grand staircase, boasting ceilings with 3 chandeliers greeting you in foyer, wood floors throughout downstairs. Impressive courtyard upon walking in with a nanowall. Kitchen offers oversized island, porcelain apron front sink with a picture window, beautiful Calacatta Quartz countertops, built-in professional refrigerator, built-in ice machine, side-by-side built-in wine fridge, professional cooktop, marble herringbone backsplash to ceiling, coffee bar and back staircase. Custom wood shutters throughout. Primary bath offers double vanity, free-standing bath, custom walk-in showers. All bathrooms have glass modern doors on tubs Stucco stone elevation, cul-de-sac lot on a-little shy of half an acre, waiting for you to build your outdoor oasis. Covered patio, a 4-car garage.' ,`Acres` = '0.4243' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 BRIDGELAND PARKLAND VILLAGE SEC 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '18481' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland Parkland Village' ,`TaxAmount` = '29193' ,`TaxRate` = '3.4929' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266453' WHERE `Matrix_Unique_ID` = '215273094' --> 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','215309594','1675266453','215309594','2023-01-30T18:05:58.170','36056728','Cheryl Ancira','SRL Fine Properties','','','29.748893','-96.046391','28','77474','8','579900.00','Active','Standing Oaks ln','207','Lane','Sealy','2','1','6','2823','Single-Family','Beautiful one story brick 6 bedroom home with metal roof, in-ground pool, 30x30 workshop/garage. Newly updated granite kitchen, tall Cathedral ceiling living room, limestone woodburning fireplace, Primary bedroom has 2 large closets, en suite bath, Formal dining room/office, large covered patio with flagstone deck, outdoor kitchen, original attached garage converted to 2 additional bedrooms. 1.115 acres in incredible subdivision of Brazos Country. Community water well, access to the Brazos River by the community park. Come by today to see this wonderful opportunity to live in a country setting only 15 minutes to Katy Amenities. NO FLOODING-NO FLOOD ZONE. Plenty of room for RV/Boat. Friendly neighbors cruise in their golf carts and ATV, Fun community activities: Holiday decorating contest, Halloween fun. Situated near Kathy\'s Korner for good food and weekend music concerts.','1.115','57','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Gas','1','BRAZOS COUNTRY SEC I BLOCK 3 LOT 10 ACRES 1.115','Cleared,Subdivision Lot','48569','Appraisal District','','150','0','','2','Gas Oven','1','Gunite,In Ground','','Gas Range','','Aluminum','109 - Sealy','SELMAN ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Brazos Country Sec I','7244','1.8995','Public Water,Septic Tank','1999','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','215325447','1675266453','215325447','2023-01-30T17:29:58.210','3286053','William Smolensky','JLA Realty','','','29.177358','-95.451532','32','77515','9','389999.00','Active','Laurel','1260','Loop','Angleton','2','0','4','2307','Single-Family','Beautiful home convenient to Angleton, Lake Jackson and surrounding amenities. This home is located in the highly sought after subdivision of Heritage Oaks and is just minutes from the 288 Freeway. The new Angleton City Park, located at the subdivision entrance, is under construction and will be open soon. Lots of windows throughout the house allows an abundance of natural light. The large family room is a great gathering place for the entire family, and the Primary Suite is a warm and comfortable space for the owners to relax. With three additional bedrooms, there is a lot of flexibility for living and at-home workspace. And, who does not like having a three car garage? A patio expansion coupled with a very spacious back yard provides a great outdoor area for relaxing or entertaining. There is plenty of room to add a pool. Come take a look at this great home!','0.3099','5','','','Electric Dryer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Angleton','Central Gas','1','HERITAGE COURT SD SEC 1 (A0380 J DE J VALDERAS) BLK 2 LOT 4','Subdivision Lot','13499','Appraisal District','','300','0','','3','Gas Oven','0','','','Gas Range','','Composition','5 - Angleton','WESTSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required,Lockbox Right Side','Appraisal District','1','Ranch,Traditional','Heritage Court SD Sec 1','7197','2.4554','Public Sewer,Public Water','2015','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','215325705','1675266453','215325705','2023-01-30T18:51:23.973','53339972','Clarissa Woodward','Keller Williams Signature','','','29.001273','-95.225957','29','77541','12','1550000.00','Active','Bluewater HWY','5151','Highway','Freeport','4','1','4','3018','Single-Family','Introducing The Dolphin plan by Seahorse Homes - a luxury bayfront oasis with 2nd row beach views in Seahorse Estates. Enjoy breathtaking views from the two levels of composite TREX decking on the front and back of the home. With 3 living areas, including a great room, game room with wet bar, and a study/loft with access to decks spanning over 1,300 sq ft, this home maximizes your indoor and outdoor living space. Designed with an angled wall of Jeld Win Level 3 Impact Windows, crown molding, and custom coffered ceilings, the great room offers stunning views from the moment you walk in. Built-in bunk beds offer incredible water views and include individual lighting, outlets, USB ports, and clothing storage. The Dolphin also includes a chef\'s kitchen, elevator, metal roof, and high-end finishes throughout. Don\'t settle for an old beach house, build your dream home with Seahorse Homes. Visit our website to discover why Seahorse Estates is the best kept secret on the Texas Gulf Coast.','0.51','5','Seahorse Homes LLC','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Surfside','Central Electric','1','SEAHORSE ESTATES (A0029 S F AUSTIN) LOT 37','Subdivision Lot,Water View,Waterfront','22400','Appraisal District','','2100','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Aluminum','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Vacant/Unoccupied','Builder','2','Other Style','Seahorse Estates','','','Septic Tank,Well','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215347708','1675266453','215347708','2023-01-30T17:17:36.497','80736003','Juan Luis Macedo','MRG Realty, LLC','','','30.226610','-95.763786','50','77354','2','450000.00','Active','Buckhorn','812','Lane','Magnolia','2','0','2','1396','Single-Family','Are you ready to live in a country home and enjoy privacy in a 2-acre land? Look no further this 2-bedroom 2-bathroom home is great home that has been fully remodeled. Granite counter tops and stainless-steel appliances. It has a very large front porch to enjoy your coffee in the morning and your wine in the afternoon. You have an oversize garage to store your boat or have a workshop away from the main home. Also have garage apartment for your guest to stay over. ONLY 7 minutes to Magnolia downtown and 20 min to Tomball. Plenty of space to grow. Call today to set up your appointment.','2','15','','','','','No Disclosures','1','','','Magnolia/1488 West','Central Electric','0','S927300 - TOBY SMITH HIGH CHAPARRAL, LOT 27-B, SERIAL # CLW0','Cleared,Subdivision Lot','87120','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','36 - Magnolia','MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Toby Smith High Chaparral','2676','1.8587','Aerobic,Well','2011','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:38:15.400' ,`MLSNumber` = '69850936' ,`ListAgentFullName` = 'Ashlee Johnston' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.289808' ,`Longitude` = '-95.166511' ,`PhotoCount` = '28' ,`PostalCode` = '77328' ,`RoomCount` = '8' ,`ListPrice` = '247900.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Maples' ,`StreetNumber` = '10623' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is only 1 year old and in a quiet, well-kept neighborhood in Cleveland. Kitchen Refrigerator included! 3 bedrooms, 2 bathrooms and no back neighbors! Pinewood Trails offers residents incredible on-site amenities, including a children\'s playground, splash pad, shaded picnic areas and walking trails.' ,`Acres` = '0.1305' ,`Area` = '40' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S800200 - PINEWOOD TRAILS 01, BLOCK 10, LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5685' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood Trails' ,`TaxAmount` = '6627' ,`TaxRate` = '2.8333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266453' WHERE `Matrix_Unique_ID` = '215370257' --> 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','215371021','1675266454','215371021','2023-01-30T18:18:39.273','32108621','Mary Vergara','Walzel Properties','','','29.765821','-95.882607','28','77494','7','464900.00','Active','Waverly Park','29815','Lane','Katy','2','1','4','2632','Single-Family','Stunning Home in Young Ranch! Former Lennar Model Home with many upgrades! Beautiful hardwood floors, white, open kitchen, custom design touches throughout home. This home has all the bells and whistles in technology-ring doorbell, wired for Amazon connect etc. This 4 bedroom, 2.5 bath home has over 2600+ sq ft of living space. Located on culdesac in the gorgeous Young Ranch community with walking trails, several pools, playgrounds, and splash pads. Easy access to I-10, Heritage Grand Parkway and Westpark Toll Road. Also close to nearby shopping and restaurants. New commercial development is currently underway with mixed use entertainment, shopping within walking distance of the community. Zoned to highly acclaimed Lamar Consolidated ISD schools. This home is better than new! Come check it out today!','0.1818','30','Village Builder','','','','Exclusions,Mud,Sellers Disclosure','','','','Katy - Southwest','Central Gas','1','YOUNG RANCH SEC 1, BLOCK 2, LOT 27','Cul-De-Sac','7965','Survey','','1090','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Builder','2','Contemporary/Modern,Mediterranean','Young Ranch Sec 1','9818','3.072','Water District','2018','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T18:21:46.077' ,`MLSNumber` = '81652033' ,`ListAgentFullName` = 'Zonia Alvarez' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.863603' ,`Longitude` = '-95.599441' ,`PhotoCount` = '36' ,`PostalCode` = '77041' ,`RoomCount` = '10' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Summerwood' ,`StreetNumber` = '12715' ,`StreetSuffix` = 'Glen' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2399' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely and spacious in the beautiful community of Villages of Lakepointe! Situated in a cul-de-sac on over a 1/4 of an acre this beauty is ready for immediate move in and features 4 bedrooms, 2.5 baths, 3 car garage, formal dining plus a study.This home offers amazing features, an abundance of natural lighting and an open concept floor plan ideal for entertaining family and friends. HUGE owners retreat provides enough room for a sitting area and the ensuite bath is equipped with dual sinks, separate shower and jetted garden tub. OVERSIZED fully fenced backyard with sprinkler system is large enough for the kids, pets and all of your gardening needs. New carpet in living area and bedrooms. Community amenities within walking distance include a pool, playground and clubhouse. Zoned to highly acclaimed Cy-Fair ISD. Conveniently located to shopping, dining and within minutes of Hwy 290, Beltway 8, I-10 and Hwy 6.' ,`Acres` = '0.2667' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 1 VILLAGES AT LAKEPOINTE SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1006' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages At Lakepointe' ,`TaxAmount` = '7040' ,`TaxRate` = '2.431' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266454' WHERE `Matrix_Unique_ID` = '215460612' --> 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','215462901','1675266454','215462901','2023-01-30T17:46:35.707','10810945','Laya Zachariah','Realty Associates','Shab Salimi','BHGRE Gary Greene','29.645475','-95.221231','30','77034','11','224900.00','Option Pending','Dalby','323','Street','Houston','2','1','6','2692','Single-Family','Stylishly renovated 6-Bed/2.5-Bath/2-Kitchen home perfect for large families. Completely upgraded main kitchen with luxurious granite countertops, backsplash, and all new stainless-steel appliances. Equipped with plenty of cabinet space and under-mount sink with garbage disposal, this kitchen is perfect for preparing meals for a full house. Fresh coat of paint interior and exterior. New porcelain tile flooring in living room, kitchen, and hallway with soft carpet in all 6-Bedrooms. All bathrooms updated with new vanities. Hallway bathroom has new frameless shower glass door. Epoxy flooring in utility room. Mother-in-law quarter with separate entrance and kitchen including bedroom/full bathroom upstairs. Spacious backyard with tool shed. Foundation repaired with transferable warranty. Home has never flooded. 1-year home warranty included.','','3','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Hobby Area','Central Gas','0','LT 7 BLK 73 FREEWAY MANOR SEC 7','Cleared','6405','Appraisal District','','','0','','0','','0','','','Gas Range','','Composition','41 - Pasadena','FREEMAN ELEMENTARY SCHOOL (PASADENA)','MEMORIAL HIGH SCHOOL (PASADENA)','MILLER INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Ranch','Freeway Manor','','2.6863','Public Sewer,Public Water','1958','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','215497696','1675266454','215497696','2023-01-30T17:44:50.863','52712271','Derek Montes','Luxely Real Estate','','','30.926923','-94.600067','34','75936','2','120000.00','Active','Private Road 6350','208','','Chester','2','0','2','2500','Single-Family','Welcome to your new home! Get this adorable and cozy home before it disappears off the market and it will go fast! This is an amazing home with many desirable features and sits on just under 3 acres of sprawling land! There are two bedrooms, each with their own full bathroom, oversized laundry room, large kitchen and dining area for family gatherings, and expansive living area for relaxing. Other desirable features include front and rear sitting porches, multiple vehicle carport with storage area, and game cleaning area with sink in front of the home.','2.783','48','','','','','No Disclosures','','','','Tyler County','Central Electric','0','A0003 G. ARAUJO,ACRES 2.783','Other,Wooded','','','','','0','','0','','0','','','','','Other','181 - Chester','CHESTER ELEMENTARY SCHOOL','CHESTER HIGH SCHOOL','CHESTER HIGH SCHOOL','Accompany,Appointment Required','Seller','1','Ranch','GAVINO ARAUJO SURVEY A 3','','','Public Water,Septic Tank','2004','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','215522629','1675266454','215522629','2023-01-30T17:08:41.980','90834308','Jose Soria','Lions Gate Realty','','','29.844336','-95.370649','36','77022','11','339900.00','Active','Wynell','324','Street','Houston','2','0','3','2822','Single-Family','Beautiful Home conveniently located near shopping centers, restaurants , easy access to hardy toll rd. or FRWY 45. House is located walking distance to schools . \r\nHouse features 3 bedrooms and an office , it also has a game room or loft, with beautiful swimming pool for the Hot summer days. Make that appointment today.','0.3257','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Probate','1','Gaslog Fireplace','1','Northwest Houston','Central Gas,Space Heater,Wall Heater','0','LTS 6 & 7 BLK 2 WYNELL TERRACE','Subdivision Lot','14189','Appraisal District','','','0','','0','Electric Oven','1','Gunite','','Electric Range','','Composition','27 - Houston','BURBANK ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','BURBANK MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Wynell Terrace','4865','2.3307','Public Sewer,Public Water','1976','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','215527593','1675266454','215527593','2023-01-30T17:19:49.483','89910127','Donna Wilson','Martha Turner Sotheby\'s International Realty','Donna Wilson','Martha Turner Sotheby\'s International Realty','29.712804','-95.452777','44','77401','14','2050000.00','Option Pending','Elm','4532','Street','Bellaire','5','0','4','5156','Single-Family','Sophisticated recent construction with high end custom finishes! Salt water pool/spa with heater/chiller, fire pit, stainless Summer Kitchen, generator and elevator capable. Covered front porch with dual Bevelo gas lanterns flanking the iron framed double door entrance. Formal Dining Room, oversized wet bar with wine chiller and ice maker. First floor Study/Bedroom w/adjoining full bath and French doors to Pool. The Gathering Room sports a wall of glass telescoping to open the room to the Pool, Summer Kitchen and outside area. The Cook’s Kitchen is designed for entertaining with oversized island, dual dishwashers, Sub Zero refrigerator, Wolf range with custom hood, and oversized Pantry, Mud Room & Office Nook. The wrought iron stairway is tucked in the corner and provides access to the Second Floor Primary Suite (steam shower/double soaking tub) & balcony w/view of pool, 3 Guest Bedrooms as well as the Media Room with artfully designed double sliding doors. Control 4 automation system.','0.186','17','','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Bellaire Area','Central Gas,Zoned','0','LT 8 BLK A WHEELER','Subdivision Lot','8100','Appraisal District','','','0','','2','Double Oven,Gas Oven','1','Heated,In Ground,Salt Water','','Gas Range','','Aluminum','27 - Houston','HORN ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Contemporary/Modern,Traditional','Wheeler Sub','34422','2.2271','Public Sewer,Public Water','2018','Seller'); --> 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','215599907','1675266454','215599907','2023-01-30T17:23:10.063','49736314','Bill Bexley','eXp Realty, LLC','','','29.680082','-95.734384','21','77407','7','395000.00','Active','Rainflower Bay','20318','Lane','Richmond','3','0','4','1855','Single-Family','New home with location and affordability in mind. Located in Grand Mission Estates, this Coventry home was bought as a new build (8 months ago) for a corporate transfer that never happened. Now offered at a discount. Home was never lived in offers an open living plan with tile throughout the continuous kitchen, breakfast room, and living areas. With that new home feel, this was home built with all the latest amenities, look, and efficiencies. The new home has 4 bedrooms with 3 full baths, master has a extended sitting area, ensuite bathroom featuring a closet, double vanity, soaking tub, and separate shower. The spacious kitchen has tons of storage & counterspace for entertaining. Laundry room has space for a mud area to drop backpacks and shoes as you enter the house. This home is a must see.','','37','Coventry Home','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend County North/Richmond','Central Gas','1','GRAND MISSION ESTATES SEC 26','Subdivision Lot','5520','','','875','0','','2','Freestanding Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Lockbox Right Side,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Grand Mission Estates','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T17:17:18.653' ,`MLSNumber` = '80145434' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555114' ,`Longitude` = '-95.499325' ,`PhotoCount` = '6' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '314995.00' ,`Status` = 'Active' ,`StreetName` = 'Domeniko' ,`StreetNumber` = '2022' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1631' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Be amazed by this fantastic KB Home in Olympia Falls, featuring a brick front, wood flooring, extended entry, and an open great room. Master new recipes in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. Unwind in the tranquil primary suite, boasting extended dual vanities and a shower with a Moen Seena® WaterSense showerhead. Additional home features include faux wood blinds. The community comforts of Olympia Falls include a park, playground, and walking trails. Conveniently located near Fort Bend Parkway Toll Rd. and I-69, residents enjoy nearby shopping and dining at the Riverstone Shopping Center, Missouri City Shopping Center, First Colony Mall, and Pearland Town Center. Students attend the highly-rated Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoM