Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:56:09.873' ,`MLSNumber` = '97904182' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057126' ,`Longitude` = '-95.725086' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '406144.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Horse Hollow' ,`StreetNumber` = '20103' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy peace and quiet in this lovely Beazer home in Amira, boasting a brick façade, luxury vinyl plank flooring, wrought iron spindles, an open great room, a study with French doors, and a covered patio. Spend quality time in the kitchen, complete with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The spa-like primary suite features dual vanities and a 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. You don\'t want to miss this home – call now!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 Block 2' ,`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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203253' WHERE `Matrix_Unique_ID` = '205989142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:55:29.063' ,`MLSNumber` = '37455678' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057777' ,`Longitude` = '-95.724551' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '402468.00' ,`Status` = 'Active' ,`StreetName` = 'Filly Chase' ,`StreetNumber` = '19418' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Settle into this charming Beazer home in Amira, boasting a brick façade, tile flooring, cast stone fireplace, study with French doors, sprinkler system, and covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, tile backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The tranquil primary suite features 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. You don\'t want to miss this home – call now!' ,`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 33 Block 3' ,`LotDesciption` = 'Cul-De-Sac,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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203253' WHERE `Matrix_Unique_ID` = '205991814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:54:59.953' ,`MLSNumber` = '6893815' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065174' ,`Longitude` = '-95.721911' ,`PhotoCount` = '19' ,`PostalCode` = '77377' ,`RoomCount` = '15' ,`ListPrice` = '639721.00' ,`Status` = 'Active' ,`StreetName` = 'Trotting Green' ,`StreetNumber` = '19219' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This incredible lakefront Beazer home in the amazing Amira community has it all, boasting a brick façade, tile flooring, stone fireplace, study with French doors, media room, and extended covered patio. Impress your guests in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, double wall oven, 36” built-in gas cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. Unwind in the serene primary suite, featuring dual vanities and a mud set 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 – call now!' ,`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 31 Block 3' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`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`='1666203253' WHERE `Matrix_Unique_ID` = '206001436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:59:36.120' ,`MLSNumber` = '48975007' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829287' ,`Longitude` = '-94.989884' ,`PhotoCount` = '11' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '437312.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos' ,`StreetNumber` = '9018' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Seek comfort in this charming Beazer home in Ashbel Cove, boasting a brick façade, luxury vinyl plank flooring, wrought iron spindles, a study with French doors, an open great room, and an extended covered patio. Prepare incredible feasts in the kitchen, complete with quartz countertops, mosaic backsplash, large cove molding, 36” built-in gas cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. With dual vanities and a mud set shower, the primary suite is a wonderful place to unwind. 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,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203254' WHERE `Matrix_Unique_ID` = '206023396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:59:12.670' ,`MLSNumber` = '97446446' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830960' ,`Longitude` = '-94.988883' ,`PhotoCount` = '9' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '405182.00' ,`Status` = 'Active' ,`StreetName` = 'Willowridge' ,`StreetNumber` = '9010' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This gorgeous Beazer home in Ashbel Cove is what you’re looking for, boasting a brick façade, luxury vinyl plank flooring, a fireplace, a study with French doors, an open great room, and an extended covered patio. Spend afternoons in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, pendant lighting, and under-counter lighting. With dual vanities and a mud set shower, the primary suite is a wonderful place to unwind. 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,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 2' ,`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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203254' WHERE `Matrix_Unique_ID` = '206024570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:58:49.287' ,`MLSNumber` = '25377846' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829406' ,`Longitude` = '-94.986705' ,`PhotoCount` = '9' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '399555.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Flora' ,`StreetNumber` = '4402' ,`StreetSuffix` = 'Way' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Retreat to this lovely Beazer home on a corner lot in Ashbel Cove, boasting a brick façade, tile flooring, wrought iron spindles, a fireplace, media room, study with french doors, an open great room, and an extended covered patio. Spend afternoons in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, pendant lighting, and under-counter lighting. Relax in the tranquil primary suite, featuring 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` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1' ,`LotDesciption` = 'Corner,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 Range' ,`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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203254' WHERE `Matrix_Unique_ID` = '206207959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:58:26.073' ,`MLSNumber` = '16815282' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829255' ,`Longitude` = '-94.987713' ,`PhotoCount` = '13' ,`PostalCode` = '77521' ,`RoomCount` = '14' ,`ListPrice` = '399777.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos' ,`StreetNumber` = '9031' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find total comfort in this lovely Beazer home in Ashbel Cove, boasting a brick façade, tile flooring, wrought iron spindles, a study with French doors, an open great room, and an extended covered patio. Create new dishes in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, pendant lighting, and under-counter lighting. With dual vanities and a shower, the primary suite is a perfect place to relax. 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` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashbel Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.545293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203254' WHERE `Matrix_Unique_ID` = '206221435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:54:37.617' ,`MLSNumber` = '60857802' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.067624' ,`Longitude` = '-95.723002' ,`PhotoCount` = '14' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '431976.00' ,`Status` = 'Active' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19210' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Escape the city to this lovely Beazer Home in Amira, boasting a brick façade, sloped ceilings, wood-look tile flooring, a formal dining room, an open great room, and a covered patio. Whip up meals for guests in the kitchen, equipped with quartz countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and pendant lighting. The spa-like primary suite features dual vanities and a 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. You don\'t want to miss this home – call now!' ,`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 17 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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203254' WHERE `Matrix_Unique_ID` = '207762996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:54:06.353' ,`MLSNumber` = '39418009' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058050' ,`Longitude` = '-95.723192' ,`PhotoCount` = '14' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '382059.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`='1666203254' WHERE `Matrix_Unique_ID` = '207764125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:53:16.793' ,`MLSNumber` = '24655425' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063006' ,`Longitude` = '-95.715836' ,`PhotoCount` = '12' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '547499.00' ,`Status` = 'Active' ,`StreetName` = 'Yearling Pasture' ,`StreetNumber` = '20714' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Nestled in the breathtaking 484-acre Amira community, this cul-de-sac Beazer Home is complete with wood-look tile flooring, cast stone fireplace, energy efficient features, study with French doors, game room, open great room, and an extended covered patio. Find the impressive kitchen fully equipped with quartz countertops, tile backsplash, large cove molding, 36” built-in cooktop, stainless steel appliances, 42” upper cabinets, and under-counter lighting. The tranquil primary suite features a walk-in closet, dual vanities, a tub, and a separate shower. Stroll through 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. Situated 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 25 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`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` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203255' WHERE `Matrix_Unique_ID` = '207766617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:52:56.077' ,`MLSNumber` = '37888390' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065354' ,`Longitude` = '-95.723102' ,`PhotoCount` = '11' ,`PostalCode` = '77377' ,`RoomCount` = '12' ,`ListPrice` = '587802.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`='1666203255' WHERE `Matrix_Unique_ID` = '207767639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:50:59.793' ,`MLSNumber` = '4897593' ,`ListAgentFullName` = 'Ethel Jackson' ,`ListOfficeName` = 'New Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990326' ,`Longitude` = '-95.724202' ,`PhotoCount` = '19' ,`PostalCode` = '77429' ,`RoomCount` = '5' ,`ListPrice` = '304000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypriate' ,`StreetNumber` = '19627' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COZY, BEAUTIFUL, AND COMFORTABLE, 3 BED 2 BATH 2 CAR GARAGE, BRICK HOME, ON CORNER LOT. WELL KEPT GREAT LOCATION NEARBY FREEWAYS, SHOPPING CENTERS AND MEDICAL FACILITIES. PLEASE VERIFY ROOM MEASUREMENTS.' ,`Acres` = '0.1356' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 VILLAGES OF CYPRESS LAKES SEC 17' ,`LotDesciption` = 'Corner' ,`LotSize` = '5905' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '614' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Vlgs/Cypress Lakes Sec 17' ,`TaxAmount` = '6278' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203255' WHERE `Matrix_Unique_ID` = '208812673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:52:30.507' ,`MLSNumber` = '7088080' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061593' ,`Longitude` = '-95.720845' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '352217.00' ,`Status` = 'Active' ,`StreetName` = 'Shetland Valley' ,`StreetNumber` = '20810' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Enjoy moments spent in this beautiful Beazer Home in Amira, boasting a brick façade, luxury vinyl plank flooring, sprinkler system, an open great room, and a covered patio. Spend quality time in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. 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. Call for more information 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 11 Block 3' ,`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`='1666203255' WHERE `Matrix_Unique_ID` = '208833182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:50:57.843' ,`MLSNumber` = '15965190' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.067615' ,`Longitude` = '-95.722901' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '402274.00' ,`Status` = 'Active' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19326' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2025' ,`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` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203255' WHERE `Matrix_Unique_ID` = '208834611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:49:48.707' ,`MLSNumber` = '3264520' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063842' ,`Longitude` = '-95.715847' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '498910.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`='1666203256' WHERE `Matrix_Unique_ID` = '208835599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:49:18.070' ,`MLSNumber` = '76159351' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063014' ,`Longitude` = '-95.715878' ,`PhotoCount` = '17' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '504511.00' ,`Status` = 'Active' ,`StreetName` = 'Yearling Pasture' ,`StreetNumber` = '20427' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Fall in love with this charming Beazer Home in Amira, boasting a brick façade, luxury vinyl plank flooring, wrought iron spindles, a fireplace, a study with French doors, an open great room, and an extended covered patio. Imagine up new recipes in the kitchen, equipped with quartz countertops, mosaic backsplash, 30” cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. Relax in the serene primary suite featuring a walk-in closet, dual vanities, and a mud set 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 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 15 Block 4' ,`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` = '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` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203256' WHERE `Matrix_Unique_ID` = '208837579' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:48:55.043' ,`MLSNumber` = '11738950' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061539' ,`Longitude` = '-95.720396' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '499593.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Gray' ,`StreetNumber` = '20310' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Settle into this gorgeous Beazer Home in Amira, boasting a brick façade, luxury vinyl plank flooring, wrought iron spindles, cast stone fireplace, study with French, an open great room, and an extended covered patio. Impress guests in the kitchen, equipped with quartz countertops, mosaic backsplash, 30” cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. The serene primary suite features a walk-in closet, dual vanities, and a mud set 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 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 6 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`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` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203256' WHERE `Matrix_Unique_ID` = '208838165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:48:34.013' ,`MLSNumber` = '93909918' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061539' ,`Longitude` = '-95.720396' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '499665.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Gray' ,`StreetNumber` = '20330' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Seek comfort in this lovely Beazer Home in Amira, boasting a brick façade, wood-look tile flooring, a fireplace, a study with French doors, an open great room, and an extended covered patio. Spend time in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, and pendant lighting. Complete with a walk-in closet, dual vanities, a tub, and a separate shower, the primary suite is the perfect place for unwinding. 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 11 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`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`='1666203256' WHERE `Matrix_Unique_ID` = '208838535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:48:09.960' ,`MLSNumber` = '82251333' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061651' ,`Longitude` = '-95.720267' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '499739.00' ,`Status` = 'Active' ,`StreetName` = 'Paso Fino' ,`StreetNumber` = '18918' ,`StreetSuffix` = 'Prairie' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Cherish lasting moments in this incredible Beazer Home in Amira, boasting a brick façade, luxury vinyl plank flooring, a fireplace, a study with French doors, an open great room, and an extended covered patio. Try a new recipe in the kitchen, equipped with quartz countertops, tile backsplash, 30” cooktop, stainless steel appliances, and pendant lighting. The relaxing primary suite features a walk-in closet, dual vanities, and a mud set 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 zoned to the top-rated Tomball ISD. You don’t want to miss this home!' ,`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 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`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` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203256' WHERE `Matrix_Unique_ID` = '208838872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:47:40.867' ,`MLSNumber` = '75458825' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061595' ,`Longitude` = '-95.720213' ,`PhotoCount` = '11' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '454325.00' ,`Status` = 'Active' ,`StreetName` = 'Hackney Trot' ,`StreetNumber` = '18911' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This stunning Beazer Home in Amira has it all, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, cast stone fireplace, a study with French doors, an open great room, and an extended covered patio. Whip up meals for guests in the kitchen, equipped with quartz countertops, tile backsplash, large cove molding, 30” cooktop, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Unwind in the serene primary suite, featuring a walk-in closet, dual vanities, and a mud set 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 zoned to the top-rated Tomball ISD. Call now to learn more!' ,`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 25 Block 5' ,`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` = '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` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203256' WHERE `Matrix_Unique_ID` = '208839474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:47:12.647' ,`MLSNumber` = '11480324' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066848' ,`Longitude` = '-95.724107' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '362020.00' ,`Status` = 'Active' ,`StreetName` = 'Little Sebastian' ,`StreetNumber` = '20818' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Create unforgettable memories in this amazing Beazer Home in Amira, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, a sprinkler system, an open great room, and an extended covered patio. Imagine up new recipes in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The tranquil primary suite features a walk-in closet, dual vanities, a tub, and a separate 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` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 4' ,`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' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203257' WHERE `Matrix_Unique_ID` = '209320800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:46:42.663' ,`MLSNumber` = '2768002' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066843' ,`Longitude` = '-95.724128' ,`PhotoCount` = '18' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '375360.00' ,`Status` = 'Active' ,`StreetName` = 'Little Sebastian' ,`StreetNumber` = '20815' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Be enchanted by this Beazer Home in Amira, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, a sprinkler system, an open great room, and a covered patio. Cook up new cuisines in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, and pendant lighting. Spend evenings relaxing in the primary suite, featuring a walk-in closet, dual vanities, a tub, and a separate 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. 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 4 Block 3' ,`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` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203257' WHERE `Matrix_Unique_ID` = '209332269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:46:13.680' ,`MLSNumber` = '62945675' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066987' ,`Longitude` = '-95.724107' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '357968.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`='1666203257' WHERE `Matrix_Unique_ID` = '209332387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:45:40.950' ,`MLSNumber` = '79420798' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063673' ,`Longitude` = '-95.716500' ,`PhotoCount` = '17' ,`PostalCode` = '77377' ,`RoomCount` = '12' ,`ListPrice` = '504638.00' ,`Status` = 'Active' ,`StreetName` = 'Giara Pony' ,`StreetNumber` = '18906' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This amazing Beazer Home in Amira has it all, boasting wood-look tile flooring, wrought iron spindles, a fireplace, a study with French doors, an open great room, and an extended covered patio. Imagine up new recipes in the kitchen, equipped with quartz countertops, mosaic backsplash, 30” cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. The serene primary suite features a walk-in closet, dual vanities, a tub, and a separate 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. 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 5 Block 2' ,`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` = '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.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203257' WHERE `Matrix_Unique_ID` = '209380817' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:44:49.237' ,`MLSNumber` = '24733943' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.067615' ,`Longitude` = '-95.722901' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '395897.00' ,`Status` = 'Active' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19426' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel right at home in this lovely Beazer Home on a corner lot in Amira, boasting sloped ceilings, tile flooring, a study with French doors, an open great room, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” cabinets. Spend evenings relaxing in the primary suite, featuring a walk-in closet, dual vanities, a tub, and a separate 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. You don’t want to miss this home – call now!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 2' ,`LotDesciption` = 'Corner,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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203257' WHERE `Matrix_Unique_ID` = '210406761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:43:40.660' ,`MLSNumber` = '81224831' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062454' ,`Longitude` = '-95.716855' ,`PhotoCount` = '17' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '448768.00' ,`Status` = 'Active' ,`StreetName` = 'Avelignese' ,`StreetNumber` = '20431' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Create unforgettable memories in this stunning Beazer Home in Amira, boasting wood-look tile flooring, a fireplace, study with French doors, open great room, and an extended covered patio. Spend all day in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, pendant lighting, and undercounter lighting. The spa-like primary suite features a walk-in closet, dual vanities, and a mud set 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. You don’t want to miss this home – call now' ,`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 8 Block 1' ,`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` = '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`='1666203258' WHERE `Matrix_Unique_ID` = '210412239' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:43:14.640' ,`MLSNumber` = '44146292' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061722' ,`Longitude` = '-95.722291' ,`PhotoCount` = '17' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '424526.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Gray' ,`StreetNumber` = '20327' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Seek out the peace and quiet in this charming Beazer Home in Amira, boasting luxury vinyl plank flooring, a fireplace, a study with French doors, an open great room, and an extended covered patio. Create new recipes in the kitchen, equipped with quartz countertops, mosaic backsplash, 30” cooktop, stainless steel appliances, 42” cabinets, pendant lighting, and under-counter lighting. The spa-like primary suite features a walk-in closet, dual vanities, and a mud set 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. Arrange your private showing today!' ,`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 6 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` = '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,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203258' WHERE `Matrix_Unique_ID` = '210412577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:42:48.807' ,`MLSNumber` = '9774587' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061539' ,`Longitude` = '-95.720396' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '499542.00' ,`Status` = 'Active' ,`StreetName` = 'Seabiscuit Stable' ,`StreetNumber` = '19323' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy your own slice of paradise in this beautiful Beazer Home in Amira, boasting tile flooring, a 3-car garage, cast stone fireplace, a study with French doors, an open great room, and an extended covered patio. Whip up meals for guests in the island kitchen, equipped with quartz countertops, tile backsplash, large cove molding, 30” cooktop, 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, and a mud set 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. 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 6 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`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` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203258' WHERE `Matrix_Unique_ID` = '210413215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:42:27.030' ,`MLSNumber` = '82716289' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061621' ,`Longitude` = '-95.720556' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '498985.00' ,`Status` = 'Active' ,`StreetName` = 'Secretariat Meadow' ,`StreetNumber` = '20907' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Fantastic Beazer Home on a cul-de-sac lot in Amira, boasting tile flooring, wrought iron spindles, a media room, a study with French doors, an open great room, and an extended covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, mosaic backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The tranquil primary suite features a walk-in closet, dual vanities, and a mud set 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. Arrange your private showing 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 14 Block 1' ,`LotDesciption` = 'Cul-De-Sac,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` = '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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203258' WHERE `Matrix_Unique_ID` = '210464193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:56:38.467' ,`MLSNumber` = '34198584' ,`ListAgentFullName` = 'Steven Franco' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '27.761684' ,`Longitude` = '-98.072478' ,`PhotoCount` = '19' ,`PostalCode` = '78332' ,`RoomCount` = '3' ,`ListPrice` = '32900.00' ,`Status` = 'Active' ,`StreetName` = 'Adams' ,`StreetNumber` = '917' ,`StreetSuffix` = 'Street' ,`City` = 'Alice' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely property perfect for home buyers and investors. With a little updating, surely tons of opportunities will await. Come see this lovely and spacious property in Davis Add!!' ,`Acres` = '0.178' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIS ADDN LT 11 BLK 1 0000.000' ,`LotDesciption` = 'Other' ,`LotSize` = '7754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '295 - Alice' ,`SchoolElementary` = '' ,`SchoolHigh` = 'ALICE HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Davis Add' ,`TaxAmount` = '1333' ,`TaxRate` = '2.6906' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203258' WHERE `Matrix_Unique_ID` = '210711006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:41:58.560' ,`MLSNumber` = '97854552' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.063076' ,`Longitude` = '-95.721238' ,`PhotoCount` = '40' ,`PostalCode` = '77377' ,`RoomCount` = '14' ,`ListPrice` = '574004.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Desert Foal' ,`StreetNumber` = '20307' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This impeccable former Beazer model home in the desirable 484-acre community of Amira boasts wood-look tile flooring, wrought iron spindles, a cast stone fireplace, energy efficient features, study with elegant French doors, game room, serene primary suite with dual vanities and walk-in closet, open great room with raised ceilings, and an extended covered patio. The island kitchen is equipped with granite countertops, mosaic backsplash, 30” cooktop, stainless steel Whirlpool® appliances, 42” upper cabinets, and pendant and under-counter lighting. 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. Situated 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,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 2' ,`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' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203258' WHERE `Matrix_Unique_ID` = '210893469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:41:23.537' ,`MLSNumber` = '69463035' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061746' ,`Longitude` = '-95.720553' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '392353.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage Harness' ,`StreetNumber` = '20935' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Magnificent Beazer home on a cul-de-sac in the gorgeous 484-acre community of Amira features elevated amenities, including a beautiful brick exterior, sloped ceilings, wood-look tile flooring, sprinkler system, energy-efficient features, open great room, and an extended covered patio. Entertain your guests in the kitchen, equipped with quartz countertops, tile backsplash, large cove molding, stainless steel Whirlpool® appliances, 42” upper cabinets, Silgranit® single bowl sink, and pendant lighting. The primary suite has many luxuries, complete with a walk-in closet, dual vanities, and a shower. Stroll through 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. Situated 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` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 1' ,`LotDesciption` = 'Cul-De-Sac,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' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203259' WHERE `Matrix_Unique_ID` = '211476852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:57:00.633' ,`MLSNumber` = '71073932' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.828741' ,`Longitude` = '-94.990996' ,`PhotoCount` = '11' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '309997.00' ,`Status` = 'Active' ,`StreetName` = 'Wildflower' ,`StreetNumber` = '4454' ,`StreetSuffix` = 'Way' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Create lifelong memories in this gorgeous Beazer Home in the Southwinds community, which boasts a brick exterior, sloped ceilings, open great room, and an extended covered patio. No recipe is a challenge in the island kitchen, fully equipped with a walk-in pantry, stainless steel appliances, and a dining nook. Unwind in the serene primary suite, featuring a walk-in closet, dual vanities, a tub, and separate shower. 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. Zoned to Goose Creek CISD. This could be your dream home – call now!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = '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` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203259' WHERE `Matrix_Unique_ID` = '211484633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:56:31.480' ,`MLSNumber` = '2538878' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.828722' ,`Longitude` = '-94.991007' ,`PhotoCount` = '10' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '309561.00' ,`Status` = 'Active' ,`StreetName` = 'Wildflower' ,`StreetNumber` = '4626' ,`StreetSuffix` = 'Way' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy peace and quiet in this stunning Beazer Home in Southwinds, which features a beautiful brick exterior, sloped ceilings, a sprinkler system, study with French doors, open great room, and extended covered patio. Master new recipes in the island kitchen, equipped with a walk-in pantry, stainless steel appliances, and a dining nook. Spend relaxing evenings in the primary suite, boasting a walk-in closet, dual vanities, and a shower. 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. Zoned to Goose Creek CISD. Don’t wait – call now!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = '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` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666203259' WHERE `Matrix_Unique_ID` = '211530072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:40:45.503' ,`MLSNumber` = '35097021' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066987' ,`Longitude` = '-95.724107' ,`PhotoCount` = '15' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '329079.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`='1666203259' WHERE `Matrix_Unique_ID` = '212780755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:39:22.170' ,`MLSNumber` = '83392092' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065174' ,`Longitude` = '-95.721911' ,`PhotoCount` = '18' ,`PostalCode` = '77377' ,`RoomCount` = '14' ,`ListPrice` = '649822.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`='1666203259' WHERE `Matrix_Unique_ID` = '212782092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:38:43.653' ,`MLSNumber` = '76725457' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063145' ,`Longitude` = '-95.718636' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '578308.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`='1666203260' WHERE `Matrix_Unique_ID` = '213292549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:56:08.330' ,`MLSNumber` = '28665388' ,`ListAgentFullName` = 'Awilda Gonzalez' ,`ListOfficeName` = 'Prime Realty' ,`SellingAgentFullName` = 'Ted Nguyen' ,`SellingOfficeName` = 'Century 21 ExclusiveProperties' ,`Latitude` = '29.779422' ,`Longitude` = '-95.762329' ,`PhotoCount` = '8' ,`PostalCode` = '77450' ,`RoomCount` = '8' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Provincial' ,`StreetNumber` = '22510' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS A MUST SEE!!! DON\'T WASTE ANY TIME!!\r\nGREAT LOCATION,HIGHLY ACCLAIMED KATY ISD, MINUTES FROM I -10 AND GRAND PARKWAY HWY 99.\r\nFamilies with children will love the convince of the Elementary School and Middle School at walking distance, large back yard with a beautiful shed and mature trees great for entertaining.\r\nSo many accents in this home to long to list.\r\nMake your appointment today.' ,`Acres` = '0.1961' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 18 WEST MEMORIAL SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WEST MEMORIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'West Memorial Sec 02' ,`TaxAmount` = '4437' ,`TaxRate` = '2.4233' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203260' WHERE `Matrix_Unique_ID` = '213449512' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T05:54:36.773' ,`MLSNumber` = '75925644' ,`ListAgentFullName` = 'Monica Bresofski' ,`ListOfficeName` = 'One Property Grp' ,`SellingAgentFullName` = 'Vianey Del Castillo' ,`SellingOfficeName` = 'Select Pro Realty' ,`Latitude` = '30.051460' ,`Longitude` = '-95.350614' ,`PhotoCount` = '29' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '250000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Postwood Park' ,`StreetNumber` = '23215' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2 bath, 1 story home that has nice updates in the home. This home offers stainless steel appliances, tile floors throughout, updated lighting fixtures and a open concept floorplan. Home has double pane windows, tech shield in the attic and the AC was replaced in 2020. The primary bathroom offers double vanity and the shower has been remodeled in 2020. If you like to entertain, you will enjoy the patio addition that is fully wired and offers a tv mount, Bluetooth speaker mount and a ceiling fan. Leaf filter gutters were installed in August. Don’t let this cozy home slip by, schedule your tour today. \r\n Easy access to I45, Hardy Toll Road and The Woodlands.' ,`Acres` = '0.132' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 POSTWOOD GREEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Postwood Green' ,`TaxAmount` = '3909' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203260' WHERE `Matrix_Unique_ID` = '213487767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-19T04:41:33.147' ,`MLSNumber` = '77400166' ,`ListAgentFullName` = 'Anna Young' ,`ListOfficeName` = 'Tanya Young Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807125' ,`Longitude` = '-94.816406' ,`PhotoCount` = '24' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Wildlife Way' ,`StreetNumber` = '6603' ,`StreetSuffix` = '' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in BHISD located in Plantation Subdivision! Spacious backyard with plenty of room to run in, host cookouts, or chill out at the completely fenced in pool. No back neighbors! Close proximity to the bay and private access for community for boating, fishing, or just enjoying the wonderful bay breeze. Privately owned roads to cruise up and down in a golf cart, ATV, etc. \r\n Inside hosts a living room with fireplace and open view to the kitchen and breakfast room; all with window views of the backyard/pool. The formal dining is located off the foyer. There are four bedrooms plus a game room (upstairs). The primary closets are his and hers walk in and located in the primary bathroom. Low tax rate (Chambers County) plus easy access to I10, SH 99, HWY 146, 3180, and the FM 1409 bridge.' ,`Acres` = '0.573' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 The Southern Plantation Section 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Plantation Section 2' ,`TaxAmount` = '' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666203260' WHERE `Matrix_Unique_ID` = '213672360' --> 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','213686324','1666203260','213686324','2022-10-19T05:18:37.897','13769061','Trinh Dao','Key 2 Texas Realty','','','30.001590','-95.720624','17','77429','4','395000.00','Active','Peralta Lake','19703','Circle','Cypress','3','1','4','3311','Single-Family','Beautiful home with a lakeview in Cypress, 4 bedrooms, 3 full bathrooms, and a half bathroom, formal living room, family room, game room upstair. Breakfast area, large kitchen lots of cabinets, a grand island with granite countertops. Covered patio with a big backyard. Don\'t miss this incredible deal! Need some TLC and Sell \'AS IS\' home.','0.2058','35','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','Cypress North','Central Gas','1','LT 9 BLK 5 CYPRESS LANDING EAST SEC 11','Cul-De-Sac','8965','Appraisal District','','660','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','KEITH ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','GOODSON MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Cypress Landing East Sec 11','9113','2.761','Public Sewer,Water District','2015','Appraisal District'); --> New record created successfully