Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '85823132' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292363' ,`Longitude` = '-95.565542' ,`PhotoCount` = '20' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '282' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at two-story entry. Open kitchen hosts inviting island with built-in seating space and a 5-burner gas cooktop. Two-story dining area opens to two-story family room with wall of windows and a wood mantel fireplace. First-floor primary suite with wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. A guest suite with full bath is downstairs. Secondary bedrooms, a game room and media room with French doors are upstairs. All bedrooms include walk-in closets. Covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965281 - Woodforest 81, BLOCK 1, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6150' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056954' WHERE `Matrix_Unique_ID` = '205094143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '62680337' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829241' ,`Longitude` = '-94.989648' ,`PhotoCount` = '10' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '299545.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos' ,`StreetNumber` = '8903' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find total comfort in this lovely Beazer home in Ashbel Cove, boasting a brick façade, study with French doors, and open an great room. Spend afternoons in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, pendant lighting, and under-counter lighting. Unwind in the serene primary suite, features dual vanities and a mud set shower. Situated near I-10 and Hwy 90, residents love the quick access to popular dining, shopping, and entertainment in the Greater Houston area. The serene Ashbel Cove community includes a park, serene lakes, and walking trails. Students attend schools zoned to Goose Creek CISD. There’s no time to lose – call today for more information!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 1' ,`LotDesciption` = 'Cul-De-Sac,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` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056954' WHERE `Matrix_Unique_ID` = '206022329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '8517951' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806614' ,`Longitude` = '-94.893404' ,`PhotoCount` = '15' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '328494.00' ,`Status` = 'Active' ,`StreetName` = 'Sirocco' ,`StreetNumber` = '7619' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Cherish lasting memories in this stunning Beazer home in Southwinds, boasting a brick façade, tile flooring, an open great room, and an extended covered patio. Create new dishes in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, and 42” upper cabinets. With dual vanities and a shower, the primary suite is a wonderful place to unwind in. With direct access to the Grand Parkway and I-10, commuters from Southwinds love the easy drive to Downtown Houston and other major business areas. A variety of popular restaurants, shops, and beaches are only a short distance away. Community comforts include a pool, recreation center, playground, and picnic area. Schools are zoned to Goose Creek CISD. Call today to learn more!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`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` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds' ,`TaxAmount` = '' ,`TaxRate` = '2.86069' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056954' WHERE `Matrix_Unique_ID` = '206142698' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:46:46.620' ,`MLSNumber` = '16534284' ,`ListAgentFullName` = 'Sonya Burnett' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773161' ,`Longitude` = '-95.238032' ,`PhotoCount` = '30' ,`PostalCode` = '77029' ,`RoomCount` = '1' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'East' ,`StreetNumber` = '10822' ,`StreetSuffix` = 'Freeway' ,`City` = 'Jacinto City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location! Property located right off of I-10 East Fwy. Has great parking in front and back of property. Billboard is not included. There is no lease income from the billboard. Previous owners have kept those leases.' ,`Acres` = '0.1061' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 13 BLK 9 MEADOWWOODS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4620' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITTIER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowwoods' ,`TaxAmount` = '2182' ,`TaxRate` = '2.5534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056955' WHERE `Matrix_Unique_ID` = '206289014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '39418009' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058050' ,`Longitude` = '-95.723192' ,`PhotoCount` = '14' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '369059.00' ,`Status` = 'Active' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19322' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy living in this stunning Beazer Home in Amira, boasting a brick façade, sloped ceilings, tile flooring open great room, a sprinkler system, and an extended covered patio. Impress your guests in the kitchen, equipped with quartz countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and pendant lighting. Unwind in the tranquil primary suite, featuring dual vanities, a tub, and a separate shower. Residents of Amira love the close proximity to a variety of popular restaurants and shopping centers, including the Houston Premium Outlets. Commuters enjoy quick access to the Grand Parkway and Highway 249. Community amenities include 100-year-old oak trees, an infinity-edge pool, dog park, playground, and fitness center. Schools are zoned to the top-rated Tomball ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 36 Block 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056955' WHERE `Matrix_Unique_ID` = '207764125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '37888390' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065354' ,`Longitude` = '-95.723102' ,`PhotoCount` = '11' ,`PostalCode` = '77377' ,`RoomCount` = '12' ,`ListPrice` = '568102.00' ,`Status` = 'Active' ,`StreetName` = 'Trotting Green' ,`StreetNumber` = '19402' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Incredible Beazer Home in the community of Amira features beautiful wood-look tile flooring, 3-car garage, cozy fireplace, energy efficient features, a study with French doors, game room, and extended covered patio. Explore new cuisines in the island kitchen, equipped with quartz countertops, mosaic backsplash, 36” built-in gas cooktop, stainless steel appliances, 42” upper cabinets, and pendant and under-counter lighting. Find a walk-in closet, dual vanities, a tub, and separate shower in the spa-like primary suite. Walk among 100-year-old oak trees to find Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Nestled off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Students attend the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 1' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056955' WHERE `Matrix_Unique_ID` = '207767639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '3264520' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063842' ,`Longitude` = '-95.715847' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '489010.00' ,`Status` = 'Active' ,`StreetName` = 'Yearling Pasture' ,`StreetNumber` = '20446' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Amazing Beazer Home in the desirable community of Amira, boasting a brick façade, sloped ceilings, wood-look tile flooring, study with French doors, an open great room, and a covered patio. Entertain guests in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Complete with a walk-in closet, dual vanities, a tub, and a separate shower, the primary suite is ideal for relaxation. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are zoned to the top-rated Tomball ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056955' WHERE `Matrix_Unique_ID` = '208835599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:46:50.283' ,`MLSNumber` = '63183901' ,`ListAgentFullName` = 'Mary Snow' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Chad Hedrick' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.112358' ,`Longitude` = '-95.466076' ,`PhotoCount` = '41' ,`PostalCode` = '77380' ,`RoomCount` = '16' ,`ListPrice` = '1570000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Angel Leaf' ,`StreetNumber` = '239' ,`StreetSuffix` = 'Road' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grogan\'s Point Gorgeous Beauty. Price Reduced! Full verandas, porches and landscaped 1.3 acre oversized corner lot with circular driveway. The Entry has a circular staircase, hand painted niche murals, high ceilings that are adorned with custom molding and millwork. LR and DR are nice sized rooms for all your events. Private Study with wall of built-ins and lots of windows to enjoy the park like setting. Primary Bedr with separate sitting area with fireplace. Primary bath gives you large walk in closets, soaking tub, separate shower and a coffee bar with a small build in refrigerator for early morning coffee time. Large FR with fireplace, built-ins and walls of windows for outdoor viewing. Kitchen has granite counter tops, large bar for guests with extra coffee bar next to DR for storage or pretty dishes. GR up with built-ins. Bedroom up has jack and jill bath, Sep staircase Bonus Room w/bath can be Media or large bedr or exercise or home school or crafts/storage/Roof 6yrs/central vac' ,`Acres` = '1.3227' ,`Area` = '15' ,`BuilderName` = 'Vintage Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 63, BLOCK 4, LOT 6' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community' ,`LotSize` = '57617' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 63' ,`TaxAmount` = '28159' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669056955' WHERE `Matrix_Unique_ID` = '209193388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '62945675' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066987' ,`Longitude` = '-95.724107' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '347968.00' ,`Status` = 'Active' ,`StreetName` = 'Little Sebastian' ,`StreetNumber` = '20822' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Cherish lasting moments in this gorgeous Beazer Home in Amira, boasting a brick façade, sloped ceilings, wood-look tile flooring, sprinkler system, an open great room, and a covered patio. Impress guests in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Relax in the tranquil primary suite, featuring a walk-in closet, dual vanities, and a shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are a part of the top-rated Tomball ISD. Call for more information today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`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` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056956' WHERE `Matrix_Unique_ID` = '209332387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:39:34.887' ,`MLSNumber` = '17970240' ,`ListAgentFullName` = 'Rhonda Berry-Pohlman' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703133' ,`Longitude` = '-95.852397' ,`PhotoCount` = '45' ,`PostalCode` = '77441' ,`RoomCount` = '12' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Mountain' ,`StreetNumber` = '27431' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAGNIFICENT Trendmaker home in Cross Creek Ranch featuring 4 bedrooms (2 DOWN), 3.5 bath and 3 car garage located on a fantastic DOUBLE CUL-DE-SAC GREENBELT LOT with no back or right side neighbors & easy access to walking trails! Huge front porch w/double doors positioned on the side for extra privacy! Rich WOOD FLOORS greet you & continue through this flowing open concept floor plan. Formal dining room w/coffered ceiling, study behind French doors & lovely gourmet kitchen w/large granite island, breakfast bar & SS appliances. Family room features beautiful ceiling high stone fireplace! Primary bedroom w/whirlpool tub in en-suite bath. Game room & media room upstairs! Venture out back to the covered patio & oversized back yard where you’ll have a clear view of Texas sunsets! Quiet neighborhood with low traffic on the street and just a short walk to Flewellen Creek pool, soccer field & dog park! Katy ISD! This master planned community is full of family friendly activities!' ,`Acres` = '0.2064' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 1, BLOCK 1, LOT 21' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '12244' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056956' WHERE `Matrix_Unique_ID` = '210016827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '69393507' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655339' ,`Longitude` = '-95.053251' ,`PhotoCount` = '19' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '334146.00' ,`Status` = 'Active' ,`StreetName` = 'Daw Boardwalk' ,`StreetNumber` = '3045' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel at ease in this amazing Beazer Home in Morgan’s Landing, which boasts sloped ceilings, tile flooring, and a cozy covered patio. Spend quality time in the island kitchen, fully equipped with quartz countertops, mosaic backsplash, Kohler® farmhouse sink, stainless steel Whirlpool® appliances, 42” upper cabinets, and pendant lighting. Relax in the serene primary suite, featuring a walk-in closet, dual vanities, and a shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Zoned to La Porte ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`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` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056956' WHERE `Matrix_Unique_ID` = '211483923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:14:52.970' ,`MLSNumber` = '24032117' ,`ListAgentFullName` = 'Bruce Palmquist' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.630719' ,`Longitude` = '-95.742871' ,`PhotoCount` = '47' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '736900.00' ,`Status` = 'Active' ,`StreetName` = 'Hopewell' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom home located in Pecan Forest section of Pecan Grove on the golf course! Oversized cul-de-sac lot with beautiful views of the first fairway! Guest quarters are above the garage and includes a kitchenette, full bathroom, & washer/dryer connections. Wonderful living area has beautiful views of the golf course. Kitchen boasts stainless steel appliances, double oven, 5 burner gas cooktop, and lots of cabinet space! Large primary bedroom w/added space for office/study/nursery plus an additional bedroom down with an en-suite bath. Upstairs features a large gameroom with a stone fireplace, office/study with a balcony overlooking the golf course, & 2 additional bedrooms that share a full bathroom. Backyard has approximately 275\' of golf course frontage and features a tropical pool and spa with an outdoor kitchen & additional yard space. Two car garage comes with a workshop and its own a/c! To many more features to mention! Make your appointment today and don\'t miss out!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 7, LOT 2 & (PT) 3, 50.0' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course' ,`LotSize` = '38036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'PECAN GROVE' ,`TaxAmount` = '6050' ,`TaxRate` = '2.2979' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056956' WHERE `Matrix_Unique_ID` = '211630592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:20:04.590' ,`MLSNumber` = '13434597' ,`ListAgentFullName` = 'Wendy Oxman' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800218' ,`Longitude` = '-95.463022' ,`PhotoCount` = '48' ,`PostalCode` = '77055' ,`RoomCount` = '10' ,`ListPrice` = '989000.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6405' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction!2022 Luxurious, Modern Farmhouse sophisticated simplicity by Avenue Drive Homes. Amazing home offers chic,contemporary design with high ceilings and a spacious entry. Open concept home that focuses on luxury and comfort. Impressive Gourmet Kitchen w designer fixtures & custom cabinetry. Long white quartz island. Stainless steel Gas Range w pot filler and Wine/ Beverage Refrigerator adorn the Great Room. So much Storage! Oversized utility Room with designer refrigerator and multiple Overflow Pantries and closet for storage. Enjoy every evening in a Stylish Primary Bedroom that displays wood beams mounted in High Ceilings. Primary Bathroom features long glass walled Double Shower & Freestanding, White Tub. Enormous! Walk-In His and Her Closets. All Bedrooms have private attached Bathrooms. Upstairs,l find a 2nd Living Area w a corner granite built-in Homework Bar. Bonus Bedroom#3 has 2 huge Walk-In Closets, Covered outdoor patio.Yard has plenty of room for a pool!' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = 'Avenue Drive Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3698' ,`Style` = 'Other Style' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8122' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056957' WHERE `Matrix_Unique_ID` = '211854569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:39:33.200' ,`MLSNumber` = '26240810' ,`ListAgentFullName` = 'Michael Vo' ,`ListOfficeName` = 'Liv Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.611683' ,`Longitude` = '-95.498713' ,`PhotoCount` = '27' ,`PostalCode` = '77071' ,`RoomCount` = '9' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Chasecreek Dr' ,`StreetNumber` = '7606' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2003' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this Charming 4 Bedroom, 2 Bathroom Home in Southwest Crossing Subdivision. Amazing location near Beltway 8, Highway 90, and Fort Bend Toll road, you have easy access to all major high ways. Newly Renovated Kitchen, Bathrooms, Floors, and Painting. With Granite Countertops, Mosaic Glass Backsplash, it gives a more contemporary feel. Master Bath w/ Dual Vanities, Granite Countertops, a Soaking Tub, Separate Shower. Large Backyard for families, Spacious Living Space. One of the few houses in the area available. Come Check it out and make an offer today before it is gone!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWEST CROSSING SEC 1, BLOCK 5, LOT 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'E A JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southwest Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056957' WHERE `Matrix_Unique_ID` = '211916552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:54:06.790' ,`MLSNumber` = '19785828' ,`ListAgentFullName` = 'Kiki Baker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747501' ,`Longitude` = '-95.785278' ,`PhotoCount` = '34' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcon Knoll' ,`StreetNumber` = '2523' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Showing paused for holidays** Yard of the Month! No back neighbors! Completely updated 5 bedroom zoned to Cinco Ranch Junior & High. Master bed-bath suite plus half-bath downstairs, with 4 beds and 2 full baths up with flexible loft area. Private pool and hot tub with wireless solar LED lighting that brings the backyard to full-color life each evening! Quartz island kitchen with herringbone backsplash, and baths ALL recently remodeled; custom fireplace in living room. Upstairs full laundry room PLUS combo washer/dryer unit in downstairs master closet; all can stay. Water resistant laminate flooring throughout, except high grade carpet on stairs, and tile in baths and laundry. New AC unit 2022 (other unit is 2018). All duct work and dryer vents cleaned. Water heater 2022. Detached garage, backs to Willow Fork bayou trail. Walk or bike the trails a short distance, 6 mins, to junior or high school quickly and safely with no street traffic. Please note: Live Camera Surveillance.' ,`Acres` = '0.194' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 4, BLOCK 5, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '594' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Falcon Ranch' ,`TaxAmount` = '9630' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056957' WHERE `Matrix_Unique_ID` = '211973447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:09:23.340' ,`MLSNumber` = '15251300' ,`ListAgentFullName` = 'Sharon Murillo' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Andrew Dillahunty' ,`SellingOfficeName` = 'RE/MAX Southwest' ,`Latitude` = '29.969663' ,`Longitude` = '-95.568970' ,`PhotoCount` = '30' ,`PostalCode` = '77070' ,`RoomCount` = '9' ,`ListPrice` = '269000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dryden Mills' ,`StreetNumber` = '13626' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GO AHEAD AND FALL IN LOVE... This time you can afford it! This 4 bedroom, 2 bathroom home will give you 1,616 sq ft of generous space to move without losing that quaint and cozy atmosphere around this house. The focal point of the living room is the fireplace adding an element of coziness. Designed to suit all occasions from entertaining guests to relaxing after a day at work. A remarkable opportunity awaits owner-occupiers and investors alike. Act quickly as you will not get a second chance at this price! Don\'t miss out on this fantastic opportunity, contact us today to schedule your private showing.' ,`Acres` = '0.1152' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 FAIRLANE VILLAGE SEC 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '552' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairlane Village Sec 01' ,`TaxAmount` = '4776' ,`TaxRate` = '2.5937' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056957' WHERE `Matrix_Unique_ID` = '212330150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:47:28.377' ,`MLSNumber` = '89185486' ,`ListAgentFullName` = 'Anup Khanal' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860372' ,`Longitude` = '-95.632499' ,`PhotoCount` = '32' ,`PostalCode` = '77084' ,`RoomCount` = '13' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Saddle Bred' ,`StreetNumber` = '5903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!!\r\nCharming updated and well maintained 2-story home located in the quite and friendly community that offers quick access to HWY 6 & tons of shopping and dining. \r\nTons of upgrades including: \r\n2 AC units were replaced 3.5 & 5 tons in 2017. \r\nNew roof was installed in 2016.\r\nWater heater was replaced in 2017/2018. \r\nNew Paint in all rooms upstairs, replaced carpet with engineered wood upstairs. \r\n\r\nBeautiful 5 bedroom 3.5 bathroom with engineered wood upstairs and tiles downstairs. Stunning granite counter tops, upgraded appliances large kitchen room with formal dining and breakfast area. Adjacent find the open living room with a fireplace. The primary bedroom is located on the first floor & includes an updated bath. 4 well-sized bedrooms that share a 2 full bath (Both Jack & Jill) upstairs completes this home. Check out the fully fenced backyard (replaced 2 years ago) & oversize patio that\'s perfect for year-round outdoor fun & entertaining.' ,`Acres` = '0.1452' ,`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 Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 SAVANNAH ESTATES' ,`LotDesciption` = 'Other' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Savannah Estates' ,`TaxAmount` = '5958' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056957' WHERE `Matrix_Unique_ID` = '212390812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:24:47.537' ,`MLSNumber` = '89054384' ,`ListAgentFullName` = 'Feixue Wang' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658841' ,`Longitude` = '-95.529393' ,`PhotoCount` = '14' ,`PostalCode` = '77031' ,`RoomCount` = '5' ,`ListPrice` = '209000.00' ,`Status` = 'Active' ,`StreetName` = 'San Biagio' ,`StreetNumber` = '8610' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price reduced for quick sale! Newley remodeled. Lovely 3 bedrooms 2.5 bathrooms. Good layout. Fresh painting throughout, new carpet, new wood flooring etc. Gated community. Good location.' ,`Acres` = '0.0467' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 VENETIAN LUXURY HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2035' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'VALLEY WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Venetian Luxury Homes' ,`TaxAmount` = '4081' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056958' WHERE `Matrix_Unique_ID` = '212507018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '35097021' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066987' ,`Longitude` = '-95.724107' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '319079.00' ,`Status` = 'Active' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19214' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Magnificent Beazer home in the gorgeous 484-acre community of Amira features elevated amenities, including a beautiful brick exterior, wood-look tile flooring, cast stone fireplace, open great room, and a covered patio. Explore new cuisines in the kitchen, equipped with granite countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” cabinets, and pendant lighting. Find a walk-in closet, dual vanities, a tub, and separate shower in the spa-like primary suite. Walk among 100-year-old oak trees to find Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Nestled off the Grand Parkway and Highway 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Students attend the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`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` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056958' WHERE `Matrix_Unique_ID` = '212780755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '83392092' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065174' ,`Longitude` = '-95.721911' ,`PhotoCount` = '18' ,`PostalCode` = '77377' ,`RoomCount` = '14' ,`ListPrice` = '629848.00' ,`Status` = 'Active' ,`StreetName` = 'Dappled Mare' ,`StreetNumber` = '19034' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Your dream home awaits! This gorgeous Beazer home in the desirable Amira community features a brick exterior, luxury vinyl plank flooring, wrought iron spindles, a cast stone fireplace, study with French doors, media room, formal dining room, open great room, and extended covered patio. The lavish kitchen is fully equipped with quartz countertops, Herringbone backsplash, large cove molding, double wall oven, Jasper undermount kitchen sink, stainless steel appliances, wine rack, 42” upper cabinets, dining nook, and pendant lighting. The primary suite boasts a walk-in closet, dual vanities, a tub, and separate shower. Nestled among 100-year-old oak trees are Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Located off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Zoned to the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056958' WHERE `Matrix_Unique_ID` = '212782092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:45:52.207' ,`MLSNumber` = '5591200' ,`ListAgentFullName` = 'Michelle Hampton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862464' ,`Longitude` = '-95.306105' ,`PhotoCount` = '13' ,`PostalCode` = '77016' ,`RoomCount` = '9' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Wolbrook' ,`StreetNumber` = '10421' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE - IN READY!! House was completely gutted and replaced with brand new everything from the slab up. Original wood floors have been saved and beautifully refurbished. Also, new Central air and heat, new water heater, all new electrical throughout the house. Open concept in kitchen and living area with recess lighting . Backyard is a huge playground for any activity or family gathering or just to enjoy the outdoors.' ,`Acres` = '0.1625' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 548 BLK 17 FONTAINE PLACE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fontaine Place Sec 04' ,`TaxAmount` = '2032' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056958' WHERE `Matrix_Unique_ID` = '212919969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:41:00.400' ,`MLSNumber` = '23934413' ,`ListAgentFullName` = 'Benny Garza' ,`ListOfficeName` = 'White Picket Realty LLC' ,`SellingAgentFullName` = 'Lucia Vazquez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.602401' ,`Longitude` = '-95.220711' ,`PhotoCount` = '9' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kirknoll' ,`StreetNumber` = '12010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this beautiful home located in the Sagemont Park subdivision. This home was previously updated with granite countertops, recessed lighting, tile throughout the home, stand-up showers, new ceiling fans, and even a cedar closet, the home is very spacious with plenty of closet space. Schedule a private showing today.' ,`Acres` = '0.1559' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 9 SAGEMONT PARK SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6790' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Park' ,`TaxAmount` = '4598' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056959' WHERE `Matrix_Unique_ID` = '212953377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:46:34.030' ,`MLSNumber` = '69812911' ,`ListAgentFullName` = 'Maria Molina-Alban' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661709' ,`Longitude` = '-95.325525' ,`PhotoCount` = '11' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Beldart' ,`StreetNumber` = '5962' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4bed / 2bath Nice FULL remodeled home! No backyard neighbors, large back yard with plenty of room for entertaining. Large driveway to park a few cars. NEW ELECTRICAL WIRE, NEW PEX PLUMBING, NEW AC AND DUCTS. RESTORED BEAUTIFUL ORIGINAL WOOD FLOORS. TILE IN WET AREAS.\r\n\r\nThe family room is opened to the NEW kitchen, new kitchen cabinets, quartz in kitchen, updated interior painting. NO CARPET AT ALL!! Kitchen is spacious enough to add an everyday dining table. This location is mins from Downtown Houston, Medical Center, Hobby Airport.' ,`Acres` = '0.1653' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 22 BELFORT PARK SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MADING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Belfort Park Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056959' WHERE `Matrix_Unique_ID` = '213128417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:53:07.950' ,`MLSNumber` = '34278550' ,`ListAgentFullName` = 'Brenda Hebert' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469143' ,`Longitude` = '-95.115400' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Amado' ,`StreetNumber` = '2001' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Plan #253 offers 4 bedrooms and 3 full bathrooms in the home, MASSIVE Bonus Room with Glass French Doors, in addition to a Formal Dining Room with dual access from different areas of the home (french doors off of the front entry and second door off of the kitchen). This plan offers a second primary suite perfect for MIL or Guests as it has its own full/private bathroom. This split floor plan has the primary suite in the back of the home and two additional bedrooms with a 3rd large bathroom at the front of the home. The kitchen is large with 42\" cherry cabinets, granite countertops, a large island, and it\'s open to the family room and breakfast area. There\'s a walk in pantry and a generously sized laundry room right off the kitchen. The garage is a 2.5 car in size with a full bathroom and a 2.5 car porte-cache provides covered parking; double wide driveway; quiet corner lot. New luxury vinyl floors throughout; new paint throughout. See Attachments for full list of updates by builder' ,`Acres` = '0.2311' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEDONA SEC 5 (2017) ABST 3, BLOCK 8, LOT 54, ACRES 0.23' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '10067' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sedona Sec 5' ,`TaxAmount` = '6067' ,`TaxRate` = '2.004626' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056959' WHERE `Matrix_Unique_ID` = '213208315' --> 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','213276224','1669056959','213276224','2022-11-20T19:06:58.603','24322845','Teresa Trueblood','Bonnie Collins Group','','','30.128814','-95.766359','50','77355','9','460000.00','Active','Wintergreen','24510','Drive','Magnolia','2','1','3','2575','Single-Family','Beautiful home on a wooded lot in Clear Creek Forest! This home features three spacious bedrooms, two full bathrooms, a half bathroom, a home office, and an open floorplan. The family room is open to the kitchen and dining area. The kitchen boasts granite counters, stainless steel appliances, and a breakfast bar. There are picture windows across the entire back of this home to watch the wildlife that visits the wooded area in the backyard. The primary bedroom has an ensuite bathroom with double sinks, a soaking tub, and separate walk in shower. Laundry room includes a sink and granite countertop. This partially wooded property has a large front yard and private backyard with a multi level deck across the entire back of the home. Clear Creek Forest has a community pack, pool, and pond. Convenient location to TX-249 and zoned to Magnolia ISD.','0.8799','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Magnolia/1488 West','Central Electric','1','S341512 - CLEAR CREEK FOREST 12, BLOCK 4, LOT 7, ACRES 0.88','Subdivision Lot,Wooded','38330','Appraisal District','','310','0','','2','','0','','','Electric Cooktop,Electric Range','','Composition','36 - Magnolia','J.L. LYON ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Clear Creek Forest','6289','1.8587','Aerobic,Public Water','2012','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '76725457' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063145' ,`Longitude` = '-95.718636' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '568608.00' ,`Status` = 'Active' ,`StreetName` = 'Dappled Mare' ,`StreetNumber` = '19039' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the amenity-rich Amira community, this exquisite Beazer Home boasts a spacious open floor plan, tile flooring, a stone fireplace, energy efficient features, game room, study with French doors, primary suite with dual vanities and mud set shower, and extended covered patio. The elevated kitchen features quartz countertops, tile backsplash, large cove molding, 36” built-in gas cooktop, stainless steel appliances, 42” upper cabinets, and pendant and under-counter lighting. Surrounded by 100-year-old oak trees are Amira’s world-class comforts, including a glistening infinity-edge pool, clubhouse, dog park, and full fitness center. Located off the Grand Parkway and Hwy 249, residents are minutes from popular restaurants, shops, and parks in central Tomball and Cypress. Zoned to the top-rated Tomball ISD.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056959' WHERE `Matrix_Unique_ID` = '213292549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:37:43.457' ,`MLSNumber` = '82618543' ,`ListAgentFullName` = 'Cindy Price' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730518' ,`Longitude` = '-95.809881' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Goldenport' ,`StreetNumber` = '26223' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this Cinco Ranch-Highland Park home that has been immaculately kept & feels like a mountain retreat. Great open, Perry One Story w/4 Beds/3 Full Baths & 3 Car Garage. Home has a Stone Fireplace, Custom Built-ins, Hardwood Floors in the Study, Custom Window Coverings & Plantation Shutters throughout. New paint & New Lighting. Kitchen has New Touch Faucet, Painted Island Cabinets, Granite Countertops, Stainless Steel Appliances, and Gas Range. Large Dining room and Breakfast Nook with 2nd Separate Living Space could be used for a Game Room or Sitting Room. Large Crafting/Sewing room behind a closed door with a window could be used for a homework or gaming area. The Primary Bed overlooks the beautiful pool and landscaped backyard. Primary Bath has a separate Soaking Tub & Shower. Oversized Primary closet w/ample Storage. 4th Bed has private bath. Huge Covered Patio & Cocktail Pool for relaxing nights or fun entertaining. Katy ISD.' ,`Acres` = '0.2084' ,`Area` = '36' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH WEST SEC 25, BLOCK 3, LOT 69' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9076' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KILPATRICK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch' ,`TaxAmount` = '9810' ,`TaxRate` = '2.6245' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056960' WHERE `Matrix_Unique_ID` = '213301155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '16821004' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655339' ,`Longitude` = '-95.053251' ,`PhotoCount` = '40' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '299388.00' ,`Status` = 'Active' ,`StreetName` = 'Gonzalez Cove' ,`StreetNumber` = '3004' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Find total comfort in this incredible Beazer Home in Morgan’s Landing, which boasts a brick exterior, sloped ceilings, tile flooring, and a covered patio. Prepare amazing feasts in the kitchen, complete with quartz countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Unwind in the tranquil primary suite, featuring a walk-in closet, dual vanities, a tub, and a separate shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Zoned to La Porte ISD. Learn more about this home today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056960' WHERE `Matrix_Unique_ID` = '213329111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:52:54.627' ,`MLSNumber` = '92258857' ,`ListAgentFullName` = 'Somer Padilla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Faith Bice' ,`SellingOfficeName` = 'One Property Grp' ,`Latitude` = '30.420885' ,`Longitude` = '-95.545119' ,`PhotoCount` = '46' ,`PostalCode` = '77318' ,`RoomCount` = '12' ,`ListPrice` = '850000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cude Cemetery' ,`StreetNumber` = '12325' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We are so excited to bring you this beautiful 6 acre property in a superb location with private gated access and close to everything. This darling one story has been updated with a gorgeous kitchen with two enormous islands that open to your picture perfect shiplapped living room with views of your completely refinished and updated pool and serene acreage. Bring your horses and livestock and enjoy country living with a perfect blend of city life. Owner\'s Suite features french doors to your covered patio, two large walk-in closets, shower, double sinks, and a stunning claw foot tub with ranch views. Property includes two barns with electricity; one is a wood 4 stall with open air stalls, and the other is a Barnmaster 3 stall shed row style with tack room. Also features a 24x36 three bay shop or garage, screened in garden beds, water well with great water pressure, new pool equipment, 4 year old roof, large round pen for horses, high speed internet, and so much more. This is a gem!!' ,`Acres` = '6' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0012 - CUDE TIMOTHY, TRACT 13-E, ACRES 6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Georgian' ,`Subdivision` = 'Timothy Cude Surv Abs #12' ,`TaxAmount` = '6296' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056960' WHERE `Matrix_Unique_ID` = '213543852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:25:35.553' ,`MLSNumber` = '65016126' ,`ListAgentFullName` = 'Esther Garcia' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801321' ,`Longitude` = '-95.067596' ,`PhotoCount` = '25' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Clover' ,`StreetNumber` = '462' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1369' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Blinds installed! Shower doors and mirrors to be installed soon. Beautiful Modern New Construction in Livingston on two lots! 3bed/2.5 bath home in gated waterfront community! Cedar Point has pool, playground, and boat launch.Open kitchen, dining, and living area great for entertaining!Kitchen boast of beautiful glass upper cabinets and under cabinet lighting.Kitchen includes beautiful countertops and backsplash, and pot filler! Stainless steel appliances are included! Smooth walls/ceilings in living room/kitchen, fireplace, charming tile wall in powder room, and wood look plank tile. Wood stairs with iron railing lead up to the second floor. Master bedroom has roaring high ceiling with large windows! Floor to ceiling tile in bathroom showers. Gorgeous over mount sinks in master bathroom with separate vanity area! Outdoor deck is excellent for entertaining! Custom garage and front door, pre-plumbing for water softener, portable generator disconnect, and stub out for future grill.' ,`Acres` = '0.2457' ,`Area` = '44' ,`BuilderName` = 'TX Home Transformers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 2 BLK 36 LOT 13 & Lot 14' ,`LotDesciption` = 'Ravine,Subdivision Lot' ,`LotSize` = '10700' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cedar Point Sec 2' ,`TaxAmount` = '258' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669056960' WHERE `Matrix_Unique_ID` = '213583962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:46:11.550' ,`MLSNumber` = '37828169' ,`ListAgentFullName` = 'Laura Westbrook' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080875' ,`Longitude` = '-95.457630' ,`PhotoCount` = '37' ,`PostalCode` = '77388' ,`RoomCount` = '9' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Hannover Valley' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This move-in-ready home with great curb appeal is located on a quiet street and just 2 miles from Springwoods Village. High ceilings and neutral colors throughout give it a spacious feel. Beyond the foyer, the home flows into an open-concept living, dining, and kitchen area, ideal for entertaining. The kitchen has GE SS appliances, walk-in pantry, ample cabinets, and a large breakfast bar. Separate from the other bedrooms, the primary sits off the breakfast room and features double vanities, a garden tub, separate shower and two closets. Enjoy a cup of coffee on the covered patio. Upgrades include roof (2022), interior paint (2022), water heater (2018), A/C (2016) and many more. Home also boasts a Generac Generator so never go without power again. Refrigerator and washer/dryer included. Children will love the neighborhood park at the end of the street and pool just a block away. Zoned to desirable Klein ISD. Short drive to the Grand Parkway, I-45, Hardy Toll Road and The Woodlands.' ,`Acres` = '0.1452' ,`Area` = '14' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 HANNOVER VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hannover Village Sec 3' ,`TaxAmount` = '6726' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056960' WHERE `Matrix_Unique_ID` = '213796482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:49:23.410' ,`MLSNumber` = '13376355' ,`ListAgentFullName` = 'Mitchell Haynes' ,`ListOfficeName` = 'BuyBroker' ,`SellingAgentFullName` = 'Jorge Llanas' ,`SellingOfficeName` = 'David Hulsey, REALTORS ' ,`Latitude` = '29.946505' ,`Longitude` = '-95.463016' ,`PhotoCount` = '17' ,`PostalCode` = '77067' ,`RoomCount` = '3' ,`ListPrice` = '224000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Paramount' ,`StreetNumber` = '11302' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY STUNNING 3 BEDROOM HOME!! COMPLETELY REMODELED in October 2022. Great commuter location with easy access to major roadways. New exterior paint, GRANITE Countertops & Fully UPDATED bathrooms. Recent HVAC and Roof. All tiles through-out and fireplace in Living room. Master bathrooms has DOUBLE SINKS. Fresh interior paint throughout entire home. New LED lights & Electrical switches! New faucets, sinks, doorknobs & cabinet hardware. Optional 4th bedroom in garage. No flooding and NO carpet!' ,`Acres` = '0.1515' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 LINCOLN GREEN EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CONLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln Green East Sec 01' ,`TaxAmount` = '3832' ,`TaxRate` = '2.8128' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056961' WHERE `Matrix_Unique_ID` = '214006532' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:25:08.997' ,`MLSNumber` = '44702546' ,`ListAgentFullName` = 'Lucas Johnson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873352' ,`Longitude` = '-95.719178' ,`PhotoCount` = '21' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Wide Creek' ,`StreetNumber` = '6647' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This delightful home sits on a spacious corner lot in the Estates of Highland Creek. Huge 5 bedroom 2.5 bathroom brick home with oversized bedrooms . The spacious family room is full of large windows that allow in tons of natural sunlight, tile floors and opens directly to a lovely open kitchen with ample storage space. The massive master suite offers vaulted ceilings, walk in closets and a master bath with a garden tub and separate shower. The fenced back yard is large flat and perfect for family activities or a pool upgrade!' ,`Acres` = '0.1584' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 ESTATES OF HIGHLAND CREEK SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '6901' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Estates Highland Creek' ,`TaxAmount` = '6475' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056961' WHERE `Matrix_Unique_ID` = '214014558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '17308466' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824355' ,`Longitude` = '-95.471470' ,`PhotoCount` = '44' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Lamonte' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcoming Front Porch perfect for “Spilling the tea” with others. The peaceful \r\n view the Landscaped Lawn.The light & bright Modern Ranch freshly painted light repose gray interior, with 2\" white blinds compliments the white base boards framing gray washed laminate floors throughout the design scheme. The bedrooms with fresh carpet & ceiling fans lights & great closets The spa inspired bathrooms: granite counter tops, shaker cabinetry, subway tile backsplash and porcelain tile. The kitchen\'s chic custom built in white cabinetry, with satin nickel pulls; salt & pepper granite counter & subway tile backsplash. The energy efficient Frigidaire stainless steel dishwasher, microwave and \"wonder stove\" with gas range and convection oven/ Air Fryer. Other energy efficient features recessed lighting, digital thermostats, insulated doors and Low E windows. Don\'t forget the exterior details fresh paint and hardi & Covered Porches and deck and storage shed. Home warranty included!!' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 11 MANGUM MANOR SEC 2 R/P' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mangum Manor Sec 02 R/P' ,`TaxAmount` = '5649' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056961' WHERE `Matrix_Unique_ID` = '214043853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '92817689' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829352' ,`Longitude` = '-94.989057' ,`PhotoCount` = '11' ,`PostalCode` = '77521' ,`RoomCount` = '11' ,`ListPrice` = '419938.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Sage' ,`StreetNumber` = '4710' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This amazing Beazer Home in Ashbel Cove truly has it all, boasting a brick exterior, wood-look tile flooring, sprinkler system, 4-car garage, cast stone fireplace, study with French doors, open great room, and extended covered patio. Dream up new recipes in the kitchen, complete with quartz countertops, mosaic backsplash, large cove molding, 36” built-in cooktop, double wall oven, built-in Whirlpool® kitchen appliances, a wine rack, 42” upper cabinets, and pendant lighting. The serene primary suite features a walk-in closet, dual vanities, and a mud-set shower. Situated near I-10 and Hwy 90, residents love the quick access to popular dining, shopping, and entertainment in the Greater Houston area. The serene Ashbel Cove community includes a park, serene lakes, and walking trails. Nearby schools are a part of Goose Creek CISD. There’s no time to lose – call now!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056961' WHERE `Matrix_Unique_ID` = '214092105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '53561490' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660705' ,`Longitude` = '-95.052874' ,`PhotoCount` = '20' ,`PostalCode` = '77571' ,`RoomCount` = '13' ,`ListPrice` = '499366.00' ,`Status` = 'Active' ,`StreetName` = 'Corbin Crest' ,`StreetNumber` = '794' ,`StreetSuffix` = 'Trail' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Make new memories in this stunning Beazer Home in Morgan’s Landing, boasting a brick exterior, wood-look tile flooring, a 3-car garage, a study with French doors, an open great room, and an extended covered patio. Prepare incredible feasts in the kitchen, equipped with quartz countertops, Herringbone backsplash, 36” built-in gas cooktop, Kohler® farmhouse kitchen sink, built-in Whirlpool® kitchen appliances, and 42” upper cabinets. The relaxing primary suite features a walk-in closet, dual vanities, and a mud-set shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Zoned to the La Porte ISD. Learn more about this home today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056962' WHERE `Matrix_Unique_ID` = '214093354' --> 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','214100579','1669056962','214100579','2022-11-20T20:53:07.653','22933253','John Pena','Indwell Companies, LLC','','','29.762472','-95.268350','14','77029','4','165000.00','Active','Josie','8734','Street','Houston','1','0','3','1150','Single-Family','Completely remodeled 3 bedroom with 1 Bath. This home is an incredible find for the first time home buyer or someone looknig for low maintenance. The mechanicals system on this home are all new. HVAC all new including new duct work. New hot water heater and electical. Plumbing fixures, paint and all floors are new as well. This home is move in ready and prefect for you and your family. Start living a better life in a home you can call your own.','0.1402','2','','','','','Sellers Disclosure','','','','Denver Harbor','Central Electric','0','LT 454 BLK 19 PLEASANTVILLE SEC 6','Other','6105','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','PLEASANTVILLE ELEMENTARY SCHOOL','FURR HIGH SCHOOL','HOLLAND MIDDLE SCHOOL (HOUSTON)','Lockbox Front','Appraisal District','1','Other Style','Pleasantville Sec 06','1641','2.3307','Public Sewer,Public Water','1954','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:29:02.453' ,`MLSNumber` = '16365110' ,`ListAgentFullName` = 'Kirk Shelton' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923156' ,`Longitude` = '-95.173297' ,`PhotoCount` = '34' ,`PostalCode` = '77044' ,`RoomCount` = '12' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Brook' ,`StreetNumber` = '15122' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home in Summerwood! This beautiful home offers spacious rooms, and an open-concept kitchen with pristine Quartz countertops that\'s perfect for entertaining guests! This home also offers a rare full brick exterior in great condition, and has a stunning interior double-sided wood-burning fireplace. The king-friendly carpeted primary suite is perfect for a weekend\'s rest, with access to the backyard through a custom-built doorway. With easy access to Lake Houston, the Houston Motorsports Track, Golf Club of Houston, not to mention so many other amenities like nature walking trails and multiple clubhouses. This home and this neighborhood have a lot to offer! Zoned to Humble ISD. Schedule your private showing today to see why this home is a winning choice for you.' ,`Acres` = '0.1756' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 SUMMERWOOD SEC 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Summerwood Sec 17' ,`TaxAmount` = '7098' ,`TaxRate` = '2.901' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056962' WHERE `Matrix_Unique_ID` = '214259586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:08:47.490' ,`MLSNumber` = '38374350' ,`ListAgentFullName` = 'Gretchen Umberger' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.497186' ,`Longitude` = '-95.153987' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Hollow' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled behind the gates of this quiet subdivision, this executive home is setback & shaded by stands of trees.Home office features wall of built-in storage & view of the front yard’s dappled sunlight.Dining with dramatic high ceilings & transom windows,perfect for any meal. Slight curve of the stairs leading from two story entry hall to family room lends to home’s understated beauty.Desirable floor plan brings together family room,breakfast room & island kitchen.Family room has gas log fireplace flanked by french doors.Island kitchen has gas cooktop, bank of drawers for cookware,abundant counters,breakfast bar & chefs desk.Primary suite has a sitting area & ensuite bath with frameless shower,jetted tub,dual sinks & vanity.Upstairs offers a gameroom with builtins, 2 bedrooms & an oversized 14x11 full bath with separate vanity.Notice that all rooms in this home are very generously sized.Massive covered back patio provides outdoor space to grill(built in) & entertain family & friends.' ,`Acres` = '0.202' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 J DICKINSON SUR LOT 37 BLK 2 OAK CREEK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Creek Sec' ,`TaxAmount` = '6059' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056962' WHERE `Matrix_Unique_ID` = '214270638' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:55:12.573' ,`MLSNumber` = '26451695' ,`ListAgentFullName` = 'Jennifer Dodds' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907801' ,`Longitude` = '-95.646424' ,`PhotoCount` = '40' ,`PostalCode` = '77095' ,`RoomCount` = '3' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Mountain' ,`StreetNumber` = '15846' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is your chance to own a piece of paradise in Copperfield! This wonderful two-story, traditional home is situated on an INCREDIBLE 18,900 SQFT LOT and offers PLENTY of space for outdoor activities and entertainment. Upon entering the home, you will be greeted by fresh paint colors, modern fixtures and beautiful hardwood and tile flooring. The first floor features an office/study space, 1/2 bath, living room with soaring ceilings and a cozy fireplace. The kitchen has been updated with new cabinets, granite countertops, marble backsplash and stainless steel appliances. A beautiful wrought-iron staircase leads up to the second floor where you will find two bedrooms, a full bathroom and the primary bedroom suite. The primary bedroom suite offers an updated Texas size shower with cabinetry and granite countertops. Exterior painted 2021, roof 2015, furnace 2015,compressor 2019.' ,`Acres` = '0.4339' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 38 COPPERFIELD NORTHMEAD VLG 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Northmead Village' ,`TaxAmount` = '4246' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056962' WHERE `Matrix_Unique_ID` = '214273723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:07:27.763' ,`MLSNumber` = '13073141' ,`ListAgentFullName` = 'Lea Jamandre' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773357' ,`Longitude` = '-95.758734' ,`PhotoCount` = '43' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'North Fork' ,`StreetNumber` = '22306' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Cimarron! A quaint Katy neighborhood nestled right off of Mason and only 1.8 miles from I-10. Convenience is king here. Mason is filled with restaurants, shops, grocery stores, and services. You won\'t have to go far to get what you need. This neighborhood is zoned to top tier Katy ISD schools including Cinco Ranch High! This home has no backyard neighbors and backs up to a hike and bike greenbelt. A simple gate modification and you\'ll be able to access miles of trails along the bayou, perfect for dog owners. The house has been installed with new electrical, plumbing, HVAC unit, water heater, carpet, and has been freshly painted. The roof is recent (2017), and the backyard has plenty of open space along with a large covered patio. The kitchen opens up to the vaulted ceiling family room with a long breakfast bar, perfect for entertaining. Most of the countertops have been replaced with granite, and the house comes with a security camera system...what more can you ask for?' ,`Acres` = '0.2032' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 CIMARRON SEC 1 R/P' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Sec 01 R/P' ,`TaxAmount` = '4356' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056963' WHERE `Matrix_Unique_ID` = '214274247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:07:01.350' ,`MLSNumber` = '64781596' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925474' ,`Longitude` = '-95.743761' ,`PhotoCount` = '47' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '467410.00' ,`Status` = 'Active' ,`StreetName` = 'Rock Quarry' ,`StreetNumber` = '18618' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Settle into this beautiful Beazer Home in the incredible Bridgeland master-planned community, boasting a brick façade, wood-look tile flooring, cast stone fireplace, open great room, and an extended covered patio. Impress your guests in the kitchen, complete with quartz countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, and pendant lighting. Seek comfort in the relaxing primary suite, featuring a walk-in closet, dual vanities, and a mud set shower. Situated off Grand Parkway & Hwy 290, the community offers thousands of acres of green space and a network of trails, bridges, lakes, and waterways. The Activity Center includes a junior Olympic-size pool, diving well, water slides, recreation pool, splash pad, tennis courts, playground, picnic areas, and fitness center. Students attend the CyFair ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,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' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.558885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056963' WHERE `Matrix_Unique_ID` = '214322238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:20:46.953' ,`MLSNumber` = '17674318' ,`ListAgentFullName` = 'Claudia Oakley' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.116657' ,`Longitude` = '-95.561289' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = 'Running Eagle Falls' ,`StreetNumber` = '9111' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charming 1.5 story Pulte home situated on a beautiful waterfront lot in the community of Wimbledon Falls! This spacious open floor plan has 4 bedrooms and 3 baths. All beds located on first floor except 4th bedroom is on second floor w/ another full bath and oversized game room. This floor plan offers the private office in the first floor, mud room and huge laundry room. You will find a pristine chef\'s kitchen with oversized island, stainless steel appliances and granite countertops all of which is open to the family room! You don\'t want to miss the quiet backyard oasis where you can sit under the covered patio or gazebo and enjoy the lush landscaping and gorgeous views of the lake! This excellent masterplan community offers resort swimming pool, clubhouse, walking trails, green space and fitness center! Wonderful location and excellent schools! OPEN HOUSE Saturday and Sunday from 1-3p MOTIVATED SELLER HAS REDUCED THE PRICE $17k Awesome opportunity! Don’t miss it!!' ,`Acres` = '0.1758' ,`Area` = '14' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 WIMBLEDON FALLS SEC 7' ,`LotDesciption` = 'Greenbelt,Water View' ,`LotSize` = '7658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wimbledon Falls Sec 7' ,`TaxAmount` = '8139' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056963' WHERE `Matrix_Unique_ID` = '214336217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:39:21.330' ,`MLSNumber` = '73236989' ,`ListAgentFullName` = 'Esmeralda Casas' ,`ListOfficeName` = 'The Patel Group,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.954122' ,`Longitude` = '-95.458711' ,`PhotoCount` = '19' ,`PostalCode` = '77067' ,`RoomCount` = '4' ,`ListPrice` = '208000.00' ,`Status` = 'Active' ,`StreetName` = 'Treadslow' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this 4 bedroom one story located in the established subdivision of Rushwood. This corner lot has a beautiful and spacious front and back yard. Back yard includes a shed that will stay with the home. Open floor plan with den, dining area and kitchen. All kitchen appliances, washer, dryer, and safe in Primary bedroom closet included at asking price. Make your appointment to view today!' ,`Acres` = '0.1768' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 8 RUSHWOOD SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '414' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOAN LINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rushwood Sec 03' ,`TaxAmount` = '4204' ,`TaxRate` = '3.0367' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056963' WHERE `Matrix_Unique_ID` = '214471359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:17:34.103' ,`MLSNumber` = '50157257' ,`ListAgentFullName` = 'Lemorra Carter' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647230' ,`Longitude` = '-95.138382' ,`PhotoCount` = '14' ,`PostalCode` = '77505' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Heathfield' ,`StreetNumber` = '4210' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful one story 3/2 home is in the sought-out Pasadena neighborhood of Village Grove. Zoned to Deer Park ISD with the elementary school within walking distance. The kitchen is spacious and open to the dining and family room. The primary suite has recently updated flooring and bathroom complete with granite countertops his/her sinks plenty of storage separate shower and jet tub. Bedrooms two and three are mirror images of each other with large bay windows and new flooring. The backyard is large with plenty of room for a pool and also has a storage building. The deck has a covered area along with an open area perfect for entertaining relaxing. A new roof and gutters were installed in 2018. The pipes and water heater in 2019 and the attic stairs were replaced in 2022 along with new flooring. It’s excellent location makes it convenient for shopping and ease of access to Beltway 8. This home has never flooded. schedule your showing today to see this beautiful home. ' ,`Acres` = '0.1663' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 VILLAGE GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove Sec 01' ,`TaxAmount` = '6053' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056964' WHERE `Matrix_Unique_ID` = '214514125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:00:09.427' ,`MLSNumber` = '57068905' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881217' ,`Longitude` = '-95.792270' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '658900.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatgrass Grove' ,`StreetNumber` = '24023' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION!!! Home office with French doors set at entry with 12-foot ceiling. Game room with French doors off extended entry. Family room with wall of windows and a wood mantel fireplace opens to kitchen and dining area. Kitchen features walk-in pantry and generous island with built-in seating space. Primary suite includes bedroom with wall of windows. Double doors lead to primary bath with dual vanities, garden tub, separate glass-enclosed shower and oversized walk-in closet. A guest suite with private bath adds to this four-bedroom home. Extended covered backyard patio. Two-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 ELYSON SEC 33' ,`LotDesciption` = 'Greenbelt,Water View' ,`LotSize` = '6820' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1344' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.39' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056964' WHERE `Matrix_Unique_ID` = '214537978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:31:16.997' ,`MLSNumber` = '90750486' ,`ListAgentFullName` = 'Melissa Whitehead' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092077' ,`Longitude` = '-95.266556' ,`PhotoCount` = '42' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Sundance Spring' ,`StreetNumber` = '24490' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Oh my goodness! Diamond in plain sight and priced to sell! Tucked away in a beautiful golf course community, walking trails and parks, this one owner home is impeccably maintained. So many updates; granite countertops and backsplash, newer flooring throughout (luxury vinyl planks, tile, carpet) the home, tile surround on fireplace, under cabinet lighting, additional cabinets added in half and master bath, climate controlled \"Texas Attic Space\" for ample storage, added energy saving features which include a solar attic ventilation fan and spray foam insulation, NEWER HVAC 2019 with transferable warranty. A home made for gatherings with an open concept kitchen/living area, loft style game room upstairs, formal dining area (can also be used as an office/study space) and a spacious backyard with no back neighbors. The yard is beautifully landscaped throughout and easily maintained with a full wifi controlled sprinkler system. A DEFINITE MUST SEE! Call today to schedule your showing!' ,`Acres` = '0.135' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S835100 - RIVERWOOD AT OAKHURST 01, BLOCK 1, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '5881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakhurst' ,`TaxAmount` = '6784' ,`TaxRate` = '3.0681' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056964' WHERE `Matrix_Unique_ID` = '214542161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:38:30.270' ,`MLSNumber` = '64917689' ,`ListAgentFullName` = 'MeiMei JamesOu' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557823' ,`Longitude` = '-95.565529' ,`PhotoCount` = '39' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Portuguese Bend' ,`StreetNumber` = '6522' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful lakefront home in a gated community. This is the dream home you have been waiting for. Don\'t miss!' ,`Acres` = '0.1494' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATER\'S EDGE AT COLONY LAKES SEC 2, BLOCK 2, LOT 3' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '853' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waters Edge At Colony Lakes Sec 2' ,`TaxAmount` = '10876' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056964' WHERE `Matrix_Unique_ID` = '214654365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:47:17.210' ,`MLSNumber` = '92084061' ,`ListAgentFullName` = 'Dena May' ,`ListOfficeName` = 'Coastal Dream Properties' ,`SellingAgentFullName` = 'Darlyn Gomez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.927868' ,`Longitude` = '-95.569641' ,`PhotoCount` = '21' ,`PostalCode` = '77064' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Waving Fields' ,`StreetNumber` = '9911' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WoW!! LOOK at that PRICE!! Almost new roof, almost new HVAC system inside and out, almost new Pex Pipes throughout house. Beautiful neighborhood with 4 bedrooms 2 bathrooms and large living space with fireplace. Priced under market value due to updates and repairs needed. All repairs are cosmetic the house has amazing square footage and layout. Refrigerator is staying with the sale. Appliances are 5 years new. This is an investor special and will be perfect for a flipper to make some money by doing a few repairs. Call for your private showing.' ,`Acres` = '0.1837' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 11 HARVEST BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Harvest Bend Sec 01' ,`TaxAmount` = '4546' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056965' WHERE `Matrix_Unique_ID` = '214664864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:53:40.693' ,`MLSNumber` = '44218236' ,`ListAgentFullName` = 'Janice Poscovsky' ,`ListOfficeName` = 'Spouses Selling Houses' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.632690' ,`Longitude` = '-95.727512' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '498000.00' ,`Status` = 'Active' ,`StreetName` = 'Cooling Breeze' ,`StreetNumber` = '2530' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovingly cared for by the original owners, this home is beautiful on the inside and outside. Located on a corner lot that\'s just under 1/3 of an acre, with a backyard paradise, this Emerald built home has many upgrades. The primary bath was recently remodeled and includes a super shower and quartz counters. The downstairs flooring is engineered wood with the exception of the wet areas that are tiled. Great storage throughout, including a kitchen pantry that seems to go on forever. The kitchen was updated in 2010; roof replaced in 2017;HVAC in 2015 and the pool resurfaced in 2020.' ,`Acres` = '0.3013' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN GROVE PLANTATION SEC 22, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '13126' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '209' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove Plantation' ,`TaxAmount` = '7556' ,`TaxRate` = '2.2979' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056965' WHERE `Matrix_Unique_ID` = '214668820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:32:39.020' ,`MLSNumber` = '68171923' ,`ListAgentFullName` = 'Venessa James' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727094' ,`Longitude` = '-95.868463' ,`PhotoCount` = '45' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Landing' ,`StreetNumber` = '4215' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new! Beautiful DR Horton Henderson floorplan which boasts over 3300 of living space, 4 bedrooms, 3.5 bathrooms a gameroom and a media room! Enjoy the formal dining room, which can also be used as an office in the front entrance of the home. \r\nThe open concept and high ceilings make this home inviting and entertaining. The primary bedroom is located on the first floor and it features a separate soaker tub and shower, dual vanities and a spacious walk-in closet! The secondary bedrooms are spacious with walk-in closets. Enjoy the jack and jill bedrooms upstairs. Live the lifestyle in Tamarron with the community resort pool, splashpad, fitness center, sports fields, lakes & walking trails. Zones to Katy ISD. You do not want to miss an opportunity to own this home that has no back neighbors and a covered rear patio. Schedule a tour today to view all that this home has to offer!' ,`Acres` = '0.1805' ,`Area` = '36' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 31, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7861' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec' ,`TaxAmount` = '11464' ,`TaxRate` = '3.3775' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056965' WHERE `Matrix_Unique_ID` = '214672278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:50:09.023' ,`MLSNumber` = '60728319' ,`ListAgentFullName` = 'Esneider Pesca' ,`ListOfficeName` = 'Olopez Properties Inc.' ,`SellingAgentFullName` = 'Ziad Al Kayali' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.813961' ,`Longitude` = '-95.679129' ,`PhotoCount` = '48' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Apple Dale' ,`StreetNumber` = '3118' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 5-bedroom, 2.5-bathroom home in Baker Crossing, which features a gorgeous brick elevation, high ceilings, carpet and tile flooring, crown molding, alarm system prewiring, game room, formal dining room, and a spacious backyard. Soft closing cabinets and drawers, a breakfast bar, dining nook, and undercabinet lighting. The relaxing primary suite boasts a walk-in closet, dual vanities, a tub, and separate shower. Strategic zoned connecting the I10 Y and HW 6.' ,`Acres` = '0.1085' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 BARKERS CROSSING SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'BARKERS CROSSING' ,`TaxAmount` = '6195' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669056965' WHERE `Matrix_Unique_ID` = '214697769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:38:31.707' ,`MLSNumber` = '73817131' ,`ListAgentFullName` = 'Emily McCollum' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Monica Foster' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.633627' ,`Longitude` = '-95.017162' ,`PhotoCount` = '39' ,`PostalCode` = '77571' ,`RoomCount` = '6' ,`ListPrice` = '240000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bay' ,`StreetNumber` = '231' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable custom built home located just a block away from the water! This home sits on a nice sized lot and has never flooded. You will love the front porch with beautiful brick columns and brick stairs leading to the front door. As you enter you will notice the vaulted ceilings & luxury vinyl floors - no carpet in this one. The gas fireplace is the focal point of the living room & is ready to be decorated for Christmas with stockings hung up on the mantle! The living room flows into the kitchen that offers an island, oak cabinets & granite countertops. The primary bath has a garden tub that’s perfect for a cold evening, a stand up shower & a walk in closet. This home truly optimizes every inch of square footage. There’s no need to worry about a power outage with the built in Generac home generator! The two car garage has a garage door that opens from the back yard area - make this a workshop or a fun place to hang out. This home is truly move in ready, come take a look for yourself!' ,`Acres` = '0.1994' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 & W 46.5 FT OF LT 8 BLK 4 OAKHURST' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '8685' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakhurst' ,`TaxAmount` = '5341' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056965' WHERE `Matrix_Unique_ID` = '214771957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:53:27.917' ,`MLSNumber` = '97164145' ,`ListAgentFullName` = 'Troy Chase' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.347717' ,`Longitude` = '-95.023948' ,`PhotoCount` = '33' ,`PostalCode` = '77563' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Smith' ,`StreetNumber` = '7003' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the beautifully custom remodeled 7003 Smith Dr! Statement making modern exterior featuring 2525 sq ft of living space, 4 massive bedrooms, 2 1/2 bathrooms, and finished 2 car garage. Grand primary bedroom complete with tall soaking tub, separate oversized walk-in shower and dual sink quartz vanity. Spacious kitchen equipped with custom quartz countertops, centered island, breakfast bar open to living room and hidden pantry door. Generous living room featuring custom under stair playroom fit for Harry Potter or a storage area. All of this and within walking distance to the schools, award-winning shopping, and just a short drive from Galveston. This home is better than new and located perfectly for all your activities! ' ,`Acres` = '0.129' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 13 S 43 FT OF LOT 3 & N 7 FT OF LOT 5 (3-1) MAINLAND SU' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5620' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Sub' ,`TaxAmount` = '3013' ,`TaxRate` = '2.2942' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056966' WHERE `Matrix_Unique_ID` = '214779084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T19:55:02.513' ,`MLSNumber` = '46914001' ,`ListAgentFullName` = 'Raquel Hernandez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708499' ,`Longitude` = '-95.302125' ,`PhotoCount` = '28' ,`PostalCode` = '77087' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Kernel' ,`StreetNumber` = '6518' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful completely renovated home, 3 bedrooms, 2 full baths. Some of the new home features include but not limited to, a new roof, new electrical service upgrade, new windows, complete new PEX plumbing throughout, new cabinets, new flooring throughout and updated bathrooms & kitchen. Easy access to I-45, I-59, 610, I-225, I-10, minutes from downtown, UH and the medical center. Priced to sell, this home is a must see, schedule your appointment today! Please check attachments for full list of renovated items.' ,`Acres` = '0.1584' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK F ENFIELD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SOUTHMAYD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enfield' ,`TaxAmount` = '2025' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056966' WHERE `Matrix_Unique_ID` = '214797327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:59:02.420' ,`MLSNumber` = '18779165' ,`ListAgentFullName` = 'Samantha Truong Williams' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479391' ,`Longitude` = '-95.122985' ,`PhotoCount` = '17' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Springs' ,`StreetNumber` = '2146' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Brittany Lakes Subdivision. Gorgeous backyard for nature lovers with amazing pool and spa and deck.The living room is open to the kitchen making it perfect for entertaining friends and family. Tavertine floors all downstairs. Upstairs feature a gameroom with three bedrooms.' ,`Acres` = '0.2037' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 S F AUSTIN SUR BRITTANY LAKES SEC 4 (99), BLOCK 1, LO' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8872' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brittany Lakes' ,`TaxAmount` = '6245' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056966' WHERE `Matrix_Unique_ID` = '214833932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T20:18:50.043' ,`MLSNumber` = '60692434' ,`ListAgentFullName` = 'Pamela McGee' ,`ListOfficeName` = 'Greater Houston REP, Inc.' ,`SellingAgentFullName` = 'Nema Ghalamdanchi' ,`SellingOfficeName` = '007 Signature Realty, LLC' ,`Latitude` = '29.752180' ,`Longitude` = '-95.731385' ,`PhotoCount` = '50' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '439500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Chadbury Park' ,`StreetNumber` = '20706' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Desirable Kelliwood Gardens, near quiet cul-de-sac, zoned to HIGHLY RATED Katy ISD schools. Impressive entry w/curved stair, natural light. Travertine, new carpet, plantation shutters/2\" blinds, crown/triple crown molding, upgraded lighting. Granite island kitchen w/wine fridge & stainless Bosch d/w, KitchenAid ovens & JennAir cooktop. Fireplace w/custom mesquite mantle & German smear bricks. Keyless entry. Sprinkler system, covered back porch w/brick floor. 3 built-in desks, built-in china cabinet, display shelves in den, office & primary bedroom. Laundry w/upper/lower cabinets, granite counter, built-in ironing board & freezer space. Granite in kitchen, laundry, breakfast room & all bathrooms for that high end feel. New A/C units \'20, coils \'19, digital thermostats w/wifi. Exterior painted 9/22. Primary bath updated w/travertine tile, granite trim & huge soaking tub. Brand new garage door/opener. NO FLOODING. One of a kind!' ,`Acres` = '0.2005' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 6 KELLIWOOD GARDENS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8735' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Gardens Sec 01' ,`TaxAmount` = '7750' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669056966' WHERE `Matrix_Unique_ID` = '214893424' --> 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','214915772','1669056967','214915772','2022-11-20T20:35:55.650','69994324','Cynthia Lapeer','RE/MAX Integrity','','','30.555884','-95.610243','38','77340','5','313500.00','Active','Lakecrest','8','Lane','Huntsville','2','0','3','1580','Single-Family','NEW CONSTRUCTION in an exclusive gated community on Lake Conroe! Simply magnificent throughout. This gorgeous 1 story offers 3 bedrooms, 2 baths, 2 car garage, modern gray tones against crisp white custom paint, SS appliances, 8\' doors, high efficiency HVAC and more! The spacious kitchen is thoughtfully designed w/custom 42\" cabinets, beautiful countertops, tile backsplash, undermount sink & is open to living & dining areas. Wood-look floor throughout... easy maintenance so you have plenty of time to enjoy the lake & the beauty surrounding you and your front or back covered areas. Privately located in a gated subdivision w/owner only amenities: 2 pools, 2 parks, tennis & basketball courts, playground, boat dock, boat launch, covered picnic areas w/grills, fish cleaning station w/running water/sink, huge pavilion for gatherings & activities for the residents. Come see Lake Conroe\'s best kept secret & contact us for a complete feature sheet.','0.1288','43','UC&R Custom Builders','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Lake Conroe Area','Central Electric','1','WILDWOOD SHORES (SEC 4), BLOCK 2, LOT 22','Subdivision Lot','5611','Appraisal District','','985','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','105 - New Waverly','NEW WAVERLY ELEMENTARY SCHOOL','NEW WAVERLY HIGH SCHOOL','NEW WAVERLY JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Traditional','Wildwood Shores Sec 4','357','1.7846','Other Water/Sewer','2022','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','214964303','1669056967','214964303','2022-11-20T19:26:26.710','16280757','Michael Rivera','eXp Realty, LLC','','','29.690071','-95.286469','2','77087','5','250000.00','Active','Greenstone','7711','Street','Houston','1','0','3','1248','Single-Family','','0.1791','3','','','','','Sellers Disclosure','','','','Hobby Area','Central Electric','0','LT 3 BLK 4 GREENWAY SEC 1','Other','7800','Appraisal District','','','0','','0','Electric Oven','0','','','Gas Range','','Composition','27 - Houston','GOLFCREST ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','HARTMAN MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Contemporary/Modern','Greenway','3606','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214980939','1669056967','214980939','2022-11-20T19:14:17.917','87232433','Bruce Palmquist','HomeSmart','','','29.628974','-95.785762','50','77406','18','849900.00','Active','Pecan Lake','2315','Drive','Richmond','4','1','6','3800','Single-Family','','2','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','PECAN LAKE U/R (A-35), LOT 1 (PT), (PT) TRACT 6, ACRES 2.00','Wooded','87120','Appraisal District','','462','0','','2','Convection Oven,Single Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','33 - Lamar Consolidated','FROST ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Seller','2','Traditional','Pecan Lake U/R A-35','9211','1.6948','Septic Tank,Well','2002','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','214982931','1669056967','214982931','2022-11-20T20:51:03.717','12832998','Diane Nicolas','UTR TEXAS, REALTORS','','','29.564304','-95.226599','40','77581','8','341750.00','Active','Palermo','1321','Drive','Pearland','2','0','2','2115','Single-Family','Beautiful well maintained, gated 55 + active adult community. This home features a 2-bedroom split plan plus a nice study with a closet which could be utilized as a 3rd bedroom. Home has a formal dining area and a breakfast \r\nroom. Kitchen has beautiful granite counter tops and large Island with tons of nice storage and large pantry. Bonus cabinets and extra storage in the utility room. Open style floor plan with new interior paint, new carpet in bedrooms, and a gorgeous extended covered patio make this a perfect home for entertaining. Main living space is large and features a gas fireplace. Washer, dryer and refrigerator stay with the house. \r\nHOA fee includes access to the beautiful clubhouse featuring heated pool/hot tub, gym, ballroom, game rooms and numerous community functions.','0.1987','3','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Estate,Mud','1','Gas Connections','1','Pearland','Central Gas','1','LT 13 BLK 3 BELLAVITA AT GREEN TEE SEC 3','Corner,Subdivision Lot','8657','Appraisal District','','262','0','','2','Electric Oven','0','','','Electric Range','','Composition','9 - Clear Creek','WEBER ELEMENTARY','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Bellavita At Green Tee Sec 3','9297','2.8854','Public Sewer,Public Water,Water District','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','214985144','1669056967','214985144','2022-11-20T19:14:03.970','91627154','Chawannia OConner','O\'Conner Fine Properties','','','29.530019','-95.470067','7','77545','8','249000.00','Active','Teal Estates','1103','Circle','Fresno','2','0','3','1730','Single-Family','Lovely open floor plan home located in the desirable community of Teal Run Estates. The primary bedroom is large with a sitting room which can be used as a workout space, a nursery, a home office or just an extention of bedroom for lounging/relaxing space. This gem is being sold AS IS! This home is as a \"blank canvas\" the potential to make it your own. Roof replaced 2021. Priced to sell; schedule your viewing today.','0.1624','38','','','','','Mud,Sellers Disclosure,Tenant Occupied','1','','1','Missouri City Area','Central Gas','1','ESTATES OF TEAL RUN SEC 4, BLOCK 4, LOT 20','Subdivision Lot','7072','Appraisal District','','450','0','','2','','0','','','','','Composition','19 - Fort Bend','GOODMAN ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Temporarily No Showings','Appraisal District','1','Ranch','Estates Of Teal Run Sec 4','4792','2.4829','Water District','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','214985498','1669056967','214985498','2022-11-20T19:40:37.720','66281487','Robert Moore','Perry Homes Realty, LLC','','','29.882137','-95.792087','11','77493','10','699900.00','Active','Spiceberry Lodge','7514','Court','Katy','3','1','4','3097','Single-Family','PERRY HOMES NEW CONSTRUCTION!!! Home office with French doors frames the 19-foot entry way. Formal dining room. Two-story family room with a wall of windows and a wood mantel fireplace. Kitchen features an island with a built-in seating space. Butler\'s pantry and a large walk-in pantry. Primary bedroom with a curved wall of windows. Primary bathroom with dual sinks, corner garden tub, separate glass-enclosed shower and a large walk-in closet. Game room and secondary bedrooms complete the second level. Extended covered backyard patio. Three-car garage.','','25','Perry Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','1','Katy - Old Towne','Central Gas','1','LT 23 BLK 1 ELYSON SEC 33','Cul-De-Sac','9184','Other','','1344','1','To Be Built/Under Construction','3','Electric Oven','0','','','Gas Range','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Elyson','','3.39','Water District','2022','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','214985984','1669056967','214985984','2022-11-20T20:38:46.933','30949333','Kevin Duc Nguyen','ABSOLUTE Realty Group Inc.','','','29.959827','-95.462800','31','77067','4','295000.00','Active','Diane','12023','Lane','Houston','2','1','4','2628','Single-Family','Beautiful brick front exterior property nested in a quiet neighborhood. Home features 4-Bedrooms, 2 & 1/2 Baths, with Primary Bed down, along with large Living area, Formal Dining, Breakfast area, and a Gameroom. Large-designed tiles layered throughout first floor, and laminated wood-flooring throughout second level. Standing shower in Primary bath with glass door and second level bath includes tub-and-shower combo with glass door add a sense of luxury in home. Home has been with one owner and well-taken care of. Refrigerator and Microwave are included with sales. Come by and check out this beautiful home!','0.122','13','','','','','Sellers Disclosure','1','','','1960/Cypress Creek South','Central Gas','1','LT 18 BLK 3 HERITAGE VILLAGE SEC 4','Subdivision Lot','5313','Appraisal District','','400','0','','2','','0','','','Gas Range','','Composition','48 - Spring','HERITAGE ELEMENTARY SCHOOL (SPRING)','WESTFIELD HIGH SCHOOL','STELLE CLAUGHTON MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Colonial','Heritage Village Sec 04','6497','3.1167','Public Sewer,Public Water,Water District','2002','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','214986194','1669056967','214986194','2022-11-20T20:50:17.277','20084057','Sonia Ponce','Houston Center Real Estate','','','29.865921','-95.435886','10','77088','2','130000.00','Active','Sandle','7336','Street','Houston','1','0','2','768','Single-Family','Home is occupied, they are MTM, no showings available. You can add sqft to the home or build new, lots of new homes or mult family in the area. Do not disturb occupants, drive by only. See agent remarks. Room size are approximate, buyer and buyer\'s agent to verify. Listing agent is related to seller.','0.1664','11','','','','','Sellers Disclosure','','','','Northwest Houston','No Heating','0','TR 8 OF LT 14 BLK 4 HIGHLAND ACRE HOMES','Subdivision Lot','7250','Appraisal District','','','0','','0','','0','','','','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Temporarily No Showings','Appraisal District','1','Traditional','Highland Acre Homes','1718','2.5119','Well','1948','Appraisal District'); --> New record created successfully