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-09-21T01:22:00.333' ,`MLSNumber` = '13176215' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942397' ,`Longitude` = '-95.205910' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '465990.00' ,`Status` = 'Active' ,`StreetName` = 'Ordie Run' ,`StreetNumber` = '15219' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 story home is CastleRock\'s San Marcos Plan at 2,697 sqft. with Elevation \"A\" for the exterior. It has an open-concept family room/gorgeous kitchen with a half spiral staircase, and includes 4 bedrooms with a computer niche, 2 and a half bathrooms, 2 car garage, and a covered patio! This home has beautiful interior upgrades from the Design Gallery that displays a black and white modern color scheme. Balmoral is known for its amazing amenities for all ages! The Crystal Clear Lagoon Beach Club yearly pass is only $300.00' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17, Block 1, Section 23' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.083253' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794286' WHERE `Matrix_Unique_ID` = '202905069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '27025063' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073699' ,`Longitude` = '-95.618688' ,`PhotoCount` = '22' ,`PostalCode` = '77375' ,`RoomCount` = '3' ,`ListPrice` = '340351.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Ann' ,`StreetNumber` = '2138' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1666' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready June 2022! Fix dinner at the sprawling kitchen island without missing any of the action in the adjacent family room. An open concept seamlessly blends this single-story layout. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0308 Plan L400D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794286' WHERE `Matrix_Unique_ID` = '203740427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '74385030' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072088' ,`Longitude` = '-95.618203' ,`PhotoCount` = '22' ,`PostalCode` = '77375' ,`RoomCount` = '3' ,`ListPrice` = '344007.00' ,`Status` = 'Active' ,`StreetName` = 'Candied' ,`StreetNumber` = '13110' ,`StreetSuffix` = 'Cove' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1666' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready June 2022! Fix dinner at the sprawling kitchen island without missing any of the action in the adjacent family room. An open concept seamlessly blends this single-story layout. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0372 Plan L400C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.46' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794287' WHERE `Matrix_Unique_ID` = '204616231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '14969347' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072616' ,`Longitude` = '-95.618927' ,`PhotoCount` = '33' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '344647.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Ann' ,`StreetNumber` = '2202' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready June 2022! Stock up on everyone’s favorites with plenty of room in the walk-in pantry. The open-concept layout and covered outdoor living space are great for entertaining. A fourth bedroom is perfect for guests or larger families. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0306 Plan 830B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794287' WHERE `Matrix_Unique_ID` = '204651396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:07:00.720' ,`MLSNumber` = '31676171' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881426' ,`Longitude` = '-95.791714' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatgrass Grove' ,`StreetNumber` = '24111' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 31676171 - Built by Highland Homes - Ready Now! ~ A stunning double door entry opens to soaring 13\' ceilings with a large open living concept. The kitchen has a large island, built-in hutch and a charming window seat. Master suite features bay windows, and the large master closet connects to the laundry room. Entertain family and friends on the covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794287' WHERE `Matrix_Unique_ID` = '205457546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '63517037' ,`ListAgentFullName` = 'Beverly Berry' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724502' ,`Longitude` = '-95.439040' ,`PhotoCount` = '39' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '1750000.00' ,`Status` = 'Active' ,`StreetName` = 'Drake' ,`StreetNumber` = '3819' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite contemporary home which has been featured in AIA Home tour in 2008. Custom built, 2nd owner. Resort-style home featuring operable window walls showcasing visual and physical connection between interior and exterior space bringing the outdoors in. More features include a gourmet kitchen with commercial grade appliances, including full size SubZero dual wine coolers with temperature controls, an elevator, a Generac Generator and bamboo and plank slate flooring. 2-story guest house (653 sq.ft. per Appraisal) has a separate entrance from the main house by a covered breezeway. It includes a large 1st floor living, kitchen, and bathrm & 2nd fl. bedrm & access to pool. Outdoor space is peaceful with heated saltwater pool and spa, surround sound speakers, and outdoor living. West University Elementary (Buyer must verify eligibility for attendance). All per Seller.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'StudioMet' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 8 MONTCLAIR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8313' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Montclair' ,`TaxAmount` = '39621' ,`TaxRate` = '2.52923' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794287' WHERE `Matrix_Unique_ID` = '205924018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '7587305' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.033880' ,`Longitude` = '-95.415491' ,`PhotoCount` = '7' ,`PostalCode` = '77531' ,`RoomCount` = '9' ,`ListPrice` = '536895.00' ,`Status` = 'Active' ,`StreetName` = 'Bentwood' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Way' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Woodshore! Anglia Homes presents the Chester! This is a beautiful two-story home with two primary bedrooms, one upstairs and one downstairs. This home backs up to the lake, therefor you won\'t have neighbors behind you! The kitchen has quartz counter tops and opens up to the breakfast room and flows into the family room. This home won\'t last long, call today for your private showing!' ,`Acres` = '0.2134' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 4 (A0066 J E GROCE) (CLUTE) BLK 1 LOT 31' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9296' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'OGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '1044' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794287' WHERE `Matrix_Unique_ID` = '206133382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '5065203' ,`ListAgentFullName` = 'Marnie Greenwood' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726822' ,`Longitude` = '-95.397768' ,`PhotoCount` = '34' ,`PostalCode` = '77006' ,`RoomCount` = '15' ,`ListPrice` = '4750000.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '1412' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live on one of Houston\'s most sought after streets: South Boulevard! The oak-lined ave will lead you to this historic home, which sits on an exceptional 38,295 SF corner lot. The charming brick colonial offers comfortable and functional living. The first floor showcases large formal living room surrounding marble fireplace, bright library with built-in bookshelves and fireplace, a designated formal dining room, island kitchen and a sunroom. The second floor includes a large primary suite and two additional bedrooms. Remarkable wrap-around porch on second floor makes outdoor/indoor living easy. Additional open concept pool house/game room located behind the home with one bedroom apartment complete with kitchenette and full bath on second floor. A pool house terrace overlooks the pool and yard. Large circle drive at the front of the home with additional parking in rear. Located in the historically preserved subdivision of Broadacres.' ,`Acres` = '0.8791' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BROADACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '38295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Broadacres' ,`TaxAmount` = '95557' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794287' WHERE `Matrix_Unique_ID` = '206213428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:07:00.720' ,`MLSNumber` = '74641869' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675368' ,`Longitude` = '-95.897809' ,`PhotoCount` = '26' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '699817.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside Passage' ,`StreetNumber` = '30322' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 74641869 - Built by Highland Homes - November completion! ~ INCREDIBLE 1.5 STORY with ENTERTAINMENT ROOM down and GAMEROOM up. PLUS, we know how important this is so YESSS, it is included --- NO CARPET IN ENTIRE HOME!!! Upstairs is basically a whole suite with private bedroom/bath/oversized closet, and a gameroom. WOW!!! We also included a HALF BATH UP so any visitors won\'t have to walk downstairs or use the private bath inside bedroom 4. This creates the perfect privacy set up for any member of the family! We know is a hassle to walk upstairs to watch your favorites movies, TV shows, etc... so as you can see, ENTERTAINMENT room is downstairs. This J-SWING elevation includes your front porch, which compliments well with the oversized driveway space. SLIDING GLASS doors by family leads you into the EXTENDED OUTDOOR living area. So if you love your patio space, this one will check that box for sure. Cannot wait to see this beauty completed!! See you soon :)' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'L5 B3 S6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8183' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794287' WHERE `Matrix_Unique_ID` = '207404107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '52826636' ,`ListAgentFullName` = 'Katherine Arcidiacono' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723051' ,`Longitude` = '-95.431444' ,`PhotoCount` = '18' ,`PostalCode` = '77005' ,`RoomCount` = '8' ,`ListPrice` = '3250000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset' ,`StreetNumber` = '3506' ,`StreetSuffix` = 'Boulevard' ,`City` = 'West University Place' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning architecturally acclaimed 2/3 bd contemporary residence designed by award-winning architect, David Heymann, is set back on a 15,000-HCAD sf prime corner lot and is surrounded by lush, native Texas landscaping designed by Will Fleming. Built in 2004 (HCAD) by Mainland Construction and featured on the 2011 Rice Design Alliance tour, this neighborhood gem is encircled by large porches and balconies providing a seamless transition from indoors to outdoors. Boasting generous, well-appointed first-floor living spaces anchored by a large double-sided stone fireplace and soaring ceilings with floor to roof line glass creating a gorgeous light-filled open-air atmosphere, this home is special in every way. Additional notable features include beautiful antique reclaimed oak flooring throughout, antique long-leaf pine kitchen island, two-story screened entry porch, elevator, geothermal heating/cooling, rainwater collection system and lovely garage apartment.' ,`Acres` = '0.3444' ,`Area` = '17' ,`BuilderName` = 'Mainland' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Other Heating,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 85 WEST UNIVERSITY PLACE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West University Place' ,`TaxAmount` = '63397' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794288' WHERE `Matrix_Unique_ID` = '207529406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '2149128' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029412' ,`Longitude` = '-95.110230' ,`PhotoCount` = '13' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '257190.00' ,`Status` = 'Active' ,`StreetName` = 'Teton Hollow' ,`StreetNumber` = '24721' ,`StreetSuffix` = 'Trail' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new 1 story home with 3 bedrooms 2 full baths. Open family room to kitchen which has 42\" cabinets, granite countertops, deep under mount sink and stainless steel appliances. Carpet only in bedrooms. Ceiling fans in master and family room, garage door opener and covered rear patio. EST COMPLETION SEPTEMBER 2022! Photos are representative' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 3 Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794288' WHERE `Matrix_Unique_ID` = '207556769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '13130138' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029430' ,`Longitude` = '-95.110445' ,`PhotoCount` = '22' ,`PostalCode` = '77336' ,`RoomCount` = '6' ,`ListPrice` = '286140.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '324' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New 2 story home with 3 bedrooms 2.5 baths with Large Gameroom. Open family room to Kitchen which has 42\" cabinets, Granite Countertops, under mount sink, and stainless-steel appliances. Master has separate shower and tub, with dual sinks. Ceiling fans in Master bedroom and family room. Garage door opener and covered rear patio. EST COMPLETION SEPTEMBER 2022! Photos are representative!!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 2 Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794288' WHERE `Matrix_Unique_ID` = '207556845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '43796118' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029439' ,`Longitude` = '-95.110467' ,`PhotoCount` = '13' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '286140.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '320' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new 1 story home with 3 bedrooms and 2 full baths. Open family room to kitchen which includes 42\" cabinets, Granite Countertops, under mount sink, and stainless steel appliances. Master bathroom has oversized shower and dual sinks. Ceiling fans in master bedroom and family room. Garage door opener and covered rear patio. EST COMPLETION OCTOBER 2022! Photos are representative' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 2 Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794288' WHERE `Matrix_Unique_ID` = '207556931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '79763959' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029445' ,`Longitude` = '-95.110419' ,`PhotoCount` = '16' ,`PostalCode` = '77336' ,`RoomCount` = '6' ,`ListPrice` = '292715.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '316' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new 2 story 4 bedrooms and 2.5 baths. Open family room to Kitchen which includes 42\" cabinets, Granite Countertops, under mount sink and stainless steel appliances. Master bathroom has separate shower and tub plus dual sinks. Ceiling fans in master bedroom and family room. Garage door opener and covered rear patio. EST COMPLETION SEPTEMBER 2022!! Photos are representative!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 2 Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794288' WHERE `Matrix_Unique_ID` = '207556960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:07:00.720' ,`MLSNumber` = '13065952' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675026' ,`Longitude` = '-95.898602' ,`PhotoCount` = '37' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '649276.00' ,`Status` = 'Active' ,`StreetName` = 'Southpoint' ,`StreetNumber` = '4718' ,`StreetSuffix` = 'Way' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 13065952 - Built by Highland Homes - September completion! ~ Incredible model home plan now available located on an great deep homesite. We added our ENHANCED patio option because we know how much you enjoy your outdoor area. Plenty of space to add that future outdoor kitchen set up and of course, the swimming pool so the whole family can enjoy your outdoor retreat. Since a plan built for entertainment was one of your main priorities, we made sure to add every single detail so we can check that box. Kitchen opens completely to family, dining, breakfast. It also includes the DOUBLE ISLAND set up adding plenty more cabinet and barstool space. The colors selected are incredible but you will have to see those yourself :) Primary bedroom was enlarged so it meets your requirement. HIS & HERS closets in your must haves? No worries, they are included here for you :) Cannot wait to see this gem completed! See you soon!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'L25 B3 S6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8973' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794288' WHERE `Matrix_Unique_ID` = '207897505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '44999603' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.035270' ,`Longitude` = '-95.416573' ,`PhotoCount` = '6' ,`PostalCode` = '77531' ,`RoomCount` = '7' ,`ListPrice` = '423018.00' ,`Status` = 'Active' ,`StreetName` = 'Bentwater' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Lane' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Woodshore! Anglia Homes presents the Reading II. This is a beautiful brick home with stone. It\'s 4 bedrooms, 2 bathrooms, and a 2 car attached garage. There are two living areas and plenty of space to spread out. Come take a look at this home today! Schedule your private showing and make this your dream home!' ,`Acres` = '0.2008' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 4 (A0066 J E GROCE) (CLUTE) BLK 2 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8747' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'OGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '900' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794289' WHERE `Matrix_Unique_ID` = '208045634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '74064452' ,`ListAgentFullName` = 'Elizabeth Robertson' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.336309' ,`Longitude` = '-95.056840' ,`PhotoCount` = '5' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '307990.00' ,`Status` = 'Active' ,`StreetName` = 'Swinley Forest' ,`StreetNumber` = '20117' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom 1 Story Home! Ridgidcore water resistant laminate wood flooring throughout. Carpet in bedrooms only! Fabulous kitchen with oversized island open to a family room with lots of windows, 42\" White Kent Moore cabinets, granite counters, custom backsplash, under mount sink, GE stainless steel appliances w/large pantry & breakfast area with access to the covered patio. Master suite w/vaulted ceiling, master bath has double sinks w/quartz countertops, garden tub and separate shower w/big walk-in closet. Secondary bedrooms feature walk-in closets. Home includes USB/Plug combo in the kitchen and primary bedroom, 6\' privacy fenced backyard & much more! Low Tax Rate! Master planned community with amenities coming soon to include spacious parks, beautiful lake, community clubhouse, swimming pool, fitness center & 9 Grand Golf Course (9 Hole)! Centrally located on Hwy 105 with easy access to Hwy 59 & 20 minutes from Grand Parkway! Call today!' ,`Acres` = '0.1377' ,`Area` = '52' ,`BuilderName` = 'Kendall Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 3, BLOCK 1, LOT 11, ACRES .1377' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Sec 3' ,`TaxAmount` = '460' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794289' WHERE `Matrix_Unique_ID` = '208135671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:07:00.720' ,`MLSNumber` = '79517619' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099434' ,`Longitude` = '-95.349580' ,`PhotoCount` = '15' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '774258.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Peak' ,`StreetNumber` = '28224' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3789' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 79517619 - Built by Toll Brothers, Inc. - November completion! ~ Entertainers dream home now available! This luxurious Warner High Plains home features impeccable finishes and inspiring spaces throughout. High 19-foot ceilings start in the foyer and lead into a two-story great room making the home feel open and bright. A 60\' linear fireplace keeps you warm on cool nights and 12-foot multi-slide doors open to the covered patio and expand your entertaining space to the outdoors. A formal dining room is easily accessed from the chef-inspired kitchen via the butlers pantry. The comfortable and relaxing primary suite boasts tray ceilings, a stunning freestanding tub that sits between individual vanities, a tiled shower and enormous walk-in closet. Take the party to the upper level to enjoy the game/flex room for friendly competition or relax with a movie in the media room. Act now and call to schedule an appointment to view this amazing home.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 8 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodson\'s Reserve Select' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794289' WHERE `Matrix_Unique_ID` = '208564179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:07:00.720' ,`MLSNumber` = '90101102' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099631' ,`Longitude` = '-95.350013' ,`PhotoCount` = '19' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '774558.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Peak' ,`StreetNumber` = '28219' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 90101102 - Built by Toll Brothers, Inc. - November completion! ~ Single-story living at it\'s finest, the Loralai High Plains plan features a stunning entry that boasts curb appeal. Friends and family are welcomed with impressive tray ceilings in the foyer which flow into the kitchen and great room. The primary bedroom displays a tray ceiling and en-suite with a luxurious freestanding tub, separate shower with beautiful floor and wall tile, and a spacious walk-in closet. The great room\'s 9-foot multi-slide doors open to the expanded covered patio which is pre-plumbed for sink and gas stub for a future outdoor kitchen. Other features include a study with sloped ceiling, and media room for entertaining.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 30 Blk 1' ,`LotDesciption` = 'Cleared,Other,Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodson\'s Reserve Select' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794289' WHERE `Matrix_Unique_ID` = '208698841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '16192869' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941964' ,`Longitude` = '-95.204719' ,`PhotoCount` = '18' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '468990.00' ,`Status` = 'Active' ,`StreetName` = 'Davan Springs' ,`StreetNumber` = '15222' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2-story home is CastleRock\'s Hayden Elevation \"A\" floor plan at 2,809 sqft. It\'s an open-concept Kitchen with gorgeous stainless steel appliances and Family Room with high ceilings. Has 5 bedrooms, 3 Bathrooms, Game Room, 2 car garage, and a Covered Patio! Also has other beautiful interior upgrades from the Design Gallery! Balmoral is known for its amazing amenities for all ages! The Crystal Clear Lagoon Beach Club yearly pass is only $300.00' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41, Block 2, Section 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.083253' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794289' WHERE `Matrix_Unique_ID` = '209008179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '77327691' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941166' ,`Longitude` = '-95.202111' ,`PhotoCount` = '22' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '462990.00' ,`Status` = 'Active' ,`StreetName` = 'Bedford Bend' ,`StreetNumber` = '12410' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2-story home is CastleRock\'s Yuma Elevation \"D\" floor plan at 2,575 sqft. It\'s an open-concept family room/kitchen with gorgeous stainless steel appliances with high ceilings in the family room. Has 4 bedrooms, three bathrooms, a 2 car garage, and a covered patio! Also has beautiful interior upgrades from the Design Gallery! Balmoral is known for its amazing amenities for all ages! The Crystal Clear Lagoon Beach Club yearly pass is only $300.00.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 66, Block 2, Section 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.083253' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794289' WHERE `Matrix_Unique_ID` = '209008741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '43456551' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942702' ,`Longitude` = '-95.199659' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '465990.00' ,`Status` = 'Active' ,`StreetName` = 'Readen Crescent' ,`StreetNumber` = '15243' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2-story home is CastleRock\'s San Marcos Plan at 2,697 sqft. with Elevation \"A\" floor plan for the exterior. It has an open-concept family room/gorgeous kitchen with stainless steel appliances and an island option with Granite countertops. Has a half spiral staircase, and includes 4 bedrooms with a computer niche, 2 and a half bathrooms, 2 car garage, and a covered patio! This home has beautiful interior upgrades from the Design Gallery that displays a black and white modern color scheme. Balmoral is known for its amazing amenities for all ages! The Crystal Clear Lagoon Beach Club yearly pass is only $300.00' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34, Block 1, Section 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.083253' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794289' WHERE `Matrix_Unique_ID` = '209011757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:00:53.373' ,`MLSNumber` = '82998095' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563469' ,`Longitude` = '-95.748083' ,`PhotoCount` = '41' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '514990.00' ,`Status` = 'Active' ,`StreetName` = 'Travers Hill' ,`StreetNumber` = '23751' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 82998095 - Built by Highland Homes - Ready Now! ~ Featuring the “Kingston” plan, 23751 Travers Hill Road includes a backyard-facing study and a separate entertainment room in this four-bedroom, three-bathroom plan. Upscale options such as 8’ doors, sliding glass patio doors, engineered wood floors in common areas and the primary bedroom, and more have been selected for the home. Thoughtful options such as a family room floor plug, entertainment room surround sound pre-wiring, and a tankless water heater are also included. Standing shower in lieu of a tub has been added at bathroom #2. 23751 Travers Hill Road is being built in our final section of 55’ homes for Veranda that is walking distance to the upcoming elementary school! Visit our model (22914 Henderson Row Drive, Richmond, TX 77469) to learn more about what this home has to offer you and to take a tour!!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Blk 2, Lot 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7618' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = '' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794290' WHERE `Matrix_Unique_ID` = '209418072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '10796674' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.100995' ,`Longitude` = '-95.700472' ,`PhotoCount` = '38' ,`PostalCode` = '77377' ,`RoomCount` = '5' ,`ListPrice` = '276005.00' ,`Status` = 'Active' ,`StreetName` = 'Rosy Heights' ,`StreetNumber` = '22623' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New 1 story home with 4 bedrooms and 2 full bath rooms. \r\nOpen family room to kitchen and dining room. \r\nKitchen has 42 inch cabinets, granite counter tops, under mount farm sink, \r\nstainless steel appliances which include a refrigerator, dishwasher, built in micro wave, and a 5 burner gas stove. \r\nMaster bath has dual sinks, and an oversize shower. \r\nThis gorgeous home includes 2inch faux wood blinds, front gutters, a tankless water heater, and a 15x15 concrete patio' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 blk 3 section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosehill Meadow' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794290' WHERE `Matrix_Unique_ID` = '209535736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:01:49.160' ,`MLSNumber` = '69839727' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212325' ,`Longitude` = '-95.342389' ,`PhotoCount` = '48' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Crimson Crest' ,`StreetNumber` = '17188' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 69839727 - Built by Highland Homes - Ready Now! ~ So much space, all on 1 floor! Beautiful one-story home with painted brick exterior. Great, spacious floor plan with high ceilings and lots of natural light throughout. Home has 4 bedrooms, 3 full baths, Entertainment room, Study, extended outdoor living area, sliding glass doors and great island kitchen.' ,`Acres` = '0.1554' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S216900 - ARTAVIA 01, BLOCK 2, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6768' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794290' WHERE `Matrix_Unique_ID` = '209599156' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:02:20.623' ,`MLSNumber` = '49078803' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674267' ,`Longitude` = '-95.897501' ,`PhotoCount` = '48' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '709601.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside Passage' ,`StreetNumber` = '30318' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3210' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 49078803 - Built by Highland Homes - December completion! ~ Dream laundry you asked? This gem will definitely check that box for you... She is a beauty! TOP FEATURES included already --- DOUBLE island in kitchen - DOUBLE WALK-IN pantry - ENHANCED LAUNDRY ROOM with full BUILT-IN cabinets, PULL-OUT IRONING BOARD, quartz countertops, sink, etc - SLIDING GLASS DOORS at patio - EXTENDED primary suite - PRIVATE FULL BATHS in each bedroom - just to mention few additions. We left no stone unturned when we picked selections for your new home. Perfect plan to gather with your loved ones anytime of the year. Home was built for entertainment. Primary bedroom and closet has NO CARPET and bathroom already includes your FREESTANDING tub. Kitchen includes way too many features to highlight here and words won\'t justify how stunning kitchen is. Insane amount of cabinet space all around with a unique DOUBLE-TONE color to compliment the selections throughout. See you soon :) !!!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'L6 B3 S6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8183' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794290' WHERE `Matrix_Unique_ID` = '209689122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '5713280' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786620' ,`Longitude` = '-94.945857' ,`PhotoCount` = '50' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Sylvan' ,`StreetNumber` = '2216' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3777' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is a must see. Curb appeal, privacy, trees, workshop, screened-in-porch, decking, storage and this is just the beginning. 1 owner Custom Southern Charm Pier and Beam home on 2.67 acres. You will enjoy being Located at the end of Sylvan Ln. with no thru traffic. 4 bedrooms and 3 full bathrooms with a 500 sq. ft. Game Room and a 600 sq. ft living room will allow plenty of elbow room. Beautiful wood look floors, granite countertops, custom wood cabinetry are just a few of the amenities of this home. this is the home for you if you are looking for a well maintained custom home with space inside and out for your kids to play and family get togethers.' ,`Acres` = '2.627' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1 THE PONDER ESTATE' ,`LotDesciption` = 'Other' ,`LotSize` = '114432' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Ponder Estate' ,`TaxAmount` = '7426' ,`TaxRate` = '2.285' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794290' WHERE `Matrix_Unique_ID` = '210529875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '30104608' ,`ListAgentFullName` = 'Lynne Sanders' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027869' ,`Longitude` = '-95.536368' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Shelburne Circle' ,`StreetNumber` = '7707' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7153' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LUXURY AT ITS FINEST! Spacious fresh & bright w low maintenance backyard, recently installed POOL & SPA and 3 CAR garage. High end finishes are perfect mix of modern & traditional: Brazilian teak & travertine flooring,soaking tub,bianco antiquo stone counters,restaurant style kitchen sink & faucet,updated lighting & hardware & the most amazing custom woodwork & architectural details. Impressive entry w exquisite curved staircase & gleaming stone instantly pull you into fabulous formal dining & living entertaining areas. Just beyond is the chef\'s style kitchen w loads of counter space & storage,breakfast bar and amazing view of the pool/spa through floor to ceiling windows. Family room down also overlooks pool with wet bar,2nd fireplace,return stairs. Up you will find massive gameroom+study/living,2NDwetbar,more closet space than you\'ll ever need & 4 huge bedrooms all w access to full bath & dressing area. Low traffic street,walk/bike to school. Quick access to I-45,99,hwy249,Belt 8.' ,`Acres` = '0.2094' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 & TR 2A BLK 9 (TR 2A E 6 FT LT 2 BLK 9) MEMORIAL NORTHW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9123' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest Sec 16' ,`TaxAmount` = '12835' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794290' WHERE `Matrix_Unique_ID` = '210832915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '75550262' ,`ListAgentFullName` = 'Jennifer Hill' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996160' ,`Longitude` = '-95.539981' ,`PhotoCount` = '37' ,`PostalCode` = '77379' ,`RoomCount` = '19' ,`ListPrice` = '1175000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypresswood' ,`StreetNumber` = '9102' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '8876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertainer’s dream home with plenty of space for family: 6 bedrooms, 6 full & 2 half baths. Grand 2-story entry leads to 2-story LR with picture windows & French doors overlooking the waterfall pool, with wet bar pass thru to patio! DR includes accent up lighting, parquet wood floors & wine room. Library/family room offers built-in bookcases & opens to covered patio. Chef’s kitchen: 8’x5’ granite island, 2 Thermador gas stoves, 2 ovens, 2 sinks, 2 dishwashers, trash compactor & more. Breakfast room holds a full-sized dining table & has two built-in desks. Quaint tea/sun room features white lattice & garden ambiance. Wood paneled study at the front of the house has plenty of built-ins, parquet floors & convenient wet bar. Workout room accessed through study or primary bathroom. You’ll love: custom crown molding, 5 gas fireplaces, zoned sound system, central vacuum system, backyard natural gas grill & fire features. Never Flooded!' ,`Acres` = '1.0199' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 6 017*C2915074-005-006-033 CHAMPION FOREST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Champion Forest' ,`TaxAmount` = '14842' ,`TaxRate` = '2.3465' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794291' WHERE `Matrix_Unique_ID` = '210971034' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '17480013' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292467' ,`Longitude` = '-95.584164' ,`PhotoCount` = '18' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Coppice Creek Lane' ,`StreetNumber` = '432' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely, one-story stone and siding home. From the porch, enter \r\nthrough the 8\' front door into the foyer. Easily entertain guests \r\nthrough the open concept floorplan with the kitchen overlooking \r\nboth the great room and casual dining area. Or enjoy a meal \r\nunder the covered outdoor living space with a casual dining \r\nspace. The kitchen features GE appliances, a 30\'\' free-standing \r\ngas range, a white tile backsplash, Woodmont Dakota Maple \r\nSmolder cabinetry, granite countertops, and a large central \r\nisland. Escape to the primary suite featuring a dual sink vanity, \r\nluxury bath, decorative shower and floor tile, and walk-in closet \r\nwith access to the utility room. Luxury silver oak vinyl plank runs\r\nthroughout the main areas of the home. Complete with a 2-bay \r\ngarage, call this home yours!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794291' WHERE `Matrix_Unique_ID` = '211029705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '34761569' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292674' ,`Longitude` = '-95.583830' ,`PhotoCount` = '17' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Coppice Creek Lane' ,`StreetNumber` = '409' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one-story brick and stone home, located on a beautiful \r\noversized, corner lot. Once inside, the gallery-style foyer will \r\nlead you into the open-concept island kitchen overlooking the \r\ncasual dining and family room. The laundry room is \r\nconveniently located at the garage entrance and next to the \r\nkitchen. In the primary suite, you will find vaulted ceilings, a \r\nwalk-in closet, dual sinks, and a luxury bath. End your day and \r\ncatch a cool breeze on the covered outdoor patio, with a vaulted \r\nceiling.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794291' WHERE `Matrix_Unique_ID` = '211029782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '62263632' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291825' ,`Longitude` = '-95.583191' ,`PhotoCount` = '11' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallorn Lane,' ,`StreetNumber` = '351' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story painted brick home. Enter through the 8\' \r\ndouble doors into the foyer showcasing a grand curved \r\nstaircase. Head over to the kitchen that overlooks both the great \r\nroom and casual dining area. Bake your favorite dessert in the \r\ngourmet kitchen that features GE appliances, a 36\'\' built-in gas \r\ncooktop, 20\'\' custom hood insert, tile backsplash, Eternal \r\nCalcatta Gold Silestone quartz countertops, white cabinetry, \r\nand stainless steel finishes. Benefit from a downstairs private \r\nhome office and save time on your commute. Head upstairs and \r\nretreat to the primary suite. The primary bath showcases a dual \r\nsink vanity, luxury bath, white cabinetry, decorative floor tiling, \r\nand an oversized walk-in closet. Benefit from an upstairs \r\nlaundry room. End your night by hosting a game night in the \r\nupstairs game room area or catching a cool summer breeze \r\nunder the covered outdoor living space.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794291' WHERE `Matrix_Unique_ID` = '211029846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '60590716' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291769' ,`Longitude` = '-95.583191' ,`PhotoCount` = '12' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallorn Lane' ,`StreetNumber` = '356' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this lovely brick two-story home. Enter from \r\nthe porch into the grand foyer with volume ceiling. Continue into \r\nthe open layout with the kitchen, casual dining, and great room \r\nflowing easily together. Entertain guests and create an \r\nelaborate meal in the gourmet kitchen showcasing GE \r\nappliances, a 36\'\' built-in gas cooktop, 20\'\' custom hood insert, \r\ntile backsplash, Dakota Maple Smoke cabinetry, Silestone \r\nQuart countertops, and stainless finishes. Enjoy your meal \r\nunder the spacious covered patio with easy access from the \r\ngreat room. Unwind in the primary suite and soak in the \r\nfreestanding tub. The primary bath features Desert Silver \r\nSilestone Quartz countertops, decorative tile flooring, Dakota \r\nMaple Smoke cabinetry, a dual sink vanity, and a large walk-in \r\ncloset. Head upstairs to the oversized loft area which can be \r\nused as a game room, playroom, and more. You will find two \r\nadditional bedrooms upstairs. Call this your new home!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794291' WHERE `Matrix_Unique_ID` = '211029954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:03:14.990' ,`MLSNumber` = '13154651' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947286' ,`Longitude` = '-95.780801' ,`PhotoCount` = '26' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '798990.00' ,`Status` = 'Active' ,`StreetName` = 'Calico Aster' ,`StreetNumber` = '21314' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 13154651 - Built by Highland Homes - Ready Now! ~ New & Fresh Design Plan 227 M by Highland Homes! Soaring Ceilings, Natural Light & Functional Design. 2 Story, 5 Bed, 5.2 Bath, 3 Car features On Suite Baths For Each Bedroom. Luxury Wood Floor Spiral Staircase. Upgraded Hard Surface Floors at Main Living Area & Study. Downstairs Media Room Pre-wired For Surround Sound. Study & Living Space features Large Windows. Kitchen Opens to Family Room w/ Uppers & Silestone Quartz Counters! Expanded Primary Suite, Dual Vanities, Freestanding Tub & Large Shower. Expanded Bedrooms Upstairs w/ Gameroom, Lifestyle Room! Expanded Outdoor Living on Lot w Full Yard Sprinkler, 4 Sides, Brick & More. HERS Energy Rated = LOW Electric Bills! Built with the Quality & Craftsmanship you expect only in a Highland Home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 BRIDGELAND PRAIRIELAND VILLAGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8995' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794291' WHERE `Matrix_Unique_ID` = '211327955' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:03:41.837' ,`MLSNumber` = '66825558' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946877' ,`Longitude` = '-95.781047' ,`PhotoCount` = '19' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '849990.00' ,`Status` = 'Active' ,`StreetName` = 'Calico Aster' ,`StreetNumber` = '21315' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 66825558 - Built by Highland Homes - September completion! ~ New & Fresh Design Plan 223 E by Highland Homes! Soaring Ceilings, Natural Light & Functional Design. 2 Story, 5 Bed, 5.1 Bath, 3 Car features On Suite Baths For Each Bedroom. Luxury Wood Floor Spiral Staircase. Upgraded Hard Surface Floors at Main Living Area & Study. Downstairs Media Room Pre-wired For Surround Sound. Study & Living Space features Large Windows. Kitchen Opens to Family Room w/ Uppers & Silestone Quartz Counters! Expanded Primary Suite, Dual Vanities, Freestanding Tub & Large Shower. Expanded Bedrooms Upstairs with Game room! Expanded Outdoor Living on Lot w Full Yard Sprinkler & No Rear Neighbors, 4 Sides, Brick & More. HERS Energy Rated = LOW Electric Bills! Built with the Quality & Craftsmanship you expect only in a Highland Home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 1, Sec 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9106' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794291' WHERE `Matrix_Unique_ID` = '211344604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '93797838' ,`ListAgentFullName` = 'Jay Schulz' ,`ListOfficeName` = 'Zarco Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.239755' ,`Longitude` = '-95.484597' ,`PhotoCount` = '21' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '791690.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Summit Dr' ,`StreetNumber` = '1010' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW EMERALD HOME located in gated section of Oak Estates at Jacobs Reserve and in the extremely sought-after Woodlands school zone! Located on NEALRY 1/4 ACRE just near Jones State Forest. 4 beds, 3.5 full bath home with MODERN charm featuring GOURMET kitchen w/ sleek quartz countertops featuring ISLAND, built-in Jenn-Aire appliances, double convection oven, & stunning grey cabinetry. Open to dining and family room w/ gas fireplace. French door office off the entryway & HIGH ceilings. HUGE 5-STAR RETREAT w/ sitting area, split vanities, oversized shower, and relaxing soaking tub. On-demand water heater and smart home features. Front porch & covered patio -- perfect for entertaining! JUST A FEW NEW HOME OPPROTUNITIES REMAIN!!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Emerald Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S748402 - Oak Estates At Jacobs Reserve 02, Block 01, Lot 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10129' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Estates at Jacob\'s Reserve' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794292' WHERE `Matrix_Unique_ID` = '211422962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '90853415' ,`ListAgentFullName` = 'Susan Vaughan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.654106' ,`Longitude` = '-95.115989' ,`PhotoCount` = '47' ,`PostalCode` = '77331' ,`RoomCount` = '7' ,`ListPrice` = '885000.00' ,`Status` = 'Active' ,`StreetName` = 'Harbour Point' ,`StreetNumber` = '141' ,`StreetSuffix` = 'Circle' ,`City` = 'Coldspring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'From the moment you enter this waterfront home in Cape Royale absorb the panoramic lake view through the wall of windows. The open concept optimizes the expansive vista of Lake Livingston from inside and extends to a large covered deck, a favorite spot for family and friends to gather. The primary suite and two guest rooms are on the main level. Downstairs has a large game room, 4th bedroom, bath and walks out to a covered porch with firepit area and is only steps from the boathouse. The boathouse has two slips and a covered deck. There is a climate controlled storage room on the ground level accessible from the porch for all the water toys and outdoor cushions, etc. The home was constructed with 12” perimeter I-beams for a solid foundation. The home is well maintained and ready to move-in.' ,`Acres` = '0.2188' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE ROYALE - HARBOUR POINT ESTATES #2, BLOCK 1, LOT 4, ACRE' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '9532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Royale' ,`TaxAmount` = '11376' ,`TaxRate` = '2.0554' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794292' WHERE `Matrix_Unique_ID` = '211473043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '38424638' ,`ListAgentFullName` = 'Elizabeth Robertson' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335853' ,`Longitude` = '-95.057585' ,`PhotoCount` = '21' ,`PostalCode` = '77327' ,`RoomCount` = '9' ,`ListPrice` = '294990.00' ,`Status` = 'Active' ,`StreetName` = 'Swinley Forest' ,`StreetNumber` = '20057' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom one story home with vinyl wood plank flooring throughout. Carpet in bedrooms only and tile floor in primary bath. Open floor with oversized island kitchen and breakfast open to the family room with lots of windows! Fabulous kitchen with gorgeous Kent Moore cabinets, custom designed backsplash, Granite countertops and stainless steel appliances. Large breakfast area with access to the covered patio. Primary suite with vaulted ceiling, primary bath with double sinks w/quartz countertops, separate tub & shower with a big walk-in\r\ncloset. Secondary bedrooms feature walk-in closets. Lot has a 6\' privacy fence in the backyard.! Low taxes and easy access to Hwy 59 and only 15 minutes to the Grand Parkway! Hurry, Call Today!' ,`Acres` = '0.1437' ,`Area` = '52' ,`BuilderName` = 'Kendall Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 3, BLOCK 1, LOT 5, ACRES .1437' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve Sec 3' ,`TaxAmount` = '480' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794292' WHERE `Matrix_Unique_ID` = '211506432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '26058173' ,`ListAgentFullName` = 'Elizabeth Robertson' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335969' ,`Longitude` = '-95.057463' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Swinley Forest' ,`StreetNumber` = '20067' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom 2 story home has vinyl wood plank flooring throughout w/carpet upstairs and bedrooms only! \r\nFabulous kitchen with White Kent Moore cabinet, granite counters w/under mount sink, designer backsplash, GE stainless steel appliances! Open floor plan has an oversized family room with lots of windows! Owners retreat has high ceilings and ensuite bath w/double sinks vanities w/granite countertops, garden tub and separate shower w/two separate walk in closets. Granite countertops in primary and secondary baths. The staircase has beautiful wrought iron spindles leading up to your second floor. Home features a fence in the backyard and so much more\r\nincluded! Grand Oaks has easy access to Hwy 59 and is only 20 minutes from the Grand Parkway. This Master planned community features coming soon are spacious parks, beautiful lake, winding trails, community clubhouse, swimming pool, fitness center and 9 Grand Golf Course(9 Hole)! Hurry, Call today before it\'s gone!' ,`Acres` = '0.1444' ,`Area` = '52' ,`BuilderName` = 'Kendall Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 3, BLOCK 1, LOT 6, ACRES .1444' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6290' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve Sec 3' ,`TaxAmount` = '482' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794292' WHERE `Matrix_Unique_ID` = '211507071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '68749537' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291769' ,`Longitude` = '-95.583191' ,`PhotoCount` = '14' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '481851.00' ,`Status` = 'Active' ,`StreetName` = 'Mallorn' ,`StreetNumber` = '352' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Finch floorplan - Charming two-story stucco and stone home. No back neighbors, beautiful views from upstairs. Be greeted by the foyer showcasing a grand curved staircase. The open floor plan is great for hosting and the central island in the kitchen is perfect for everyday use. The kitchen features include stainless steel appliances, a 30\' free-standing self-clean gas range, mosaic tile backsplash, and Silestone Quartz countertops. Retreat to the primary suite featuring a dual sink vanity, large walk-in closet, Silestone Quartz countertops, decorative tile flooring, and Woodmont cabinetry. Head upstairs and battle out over your favorite board game in the spacious game room. All bedrooms upstairs have walk-in closets. End your day under the downstairs covered patio is great for relaxation. One thing is for sure, this home is one-of-a-kind!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '01/02/13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794292' WHERE `Matrix_Unique_ID` = '211517721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:58:24.760' ,`MLSNumber` = '49392874' ,`ListAgentFullName` = 'Amy McInnis' ,`ListOfficeName` = 'Prime Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559582' ,`Longitude` = '-95.653689' ,`PhotoCount` = '33' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Morningstar' ,`StreetNumber` = '9127' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Close to highly sought-after Campbell Elementary, Greatwood parks, tennis courts, catch & release lake, & fun pool #3 w/ water slides, splash pad, & lazy river, this well-maintained one-story home offers a more modern, open floorplan with an upscale but comfortable feel featuring high ceilings, moldings, home office w/hardwoods, open dining room & gathering room/flex space, large family room with beautiful, wooded view & 3 spacious bedrooms. Kitchen features upgraded cabinets & counters, GAS range, desk, & walk-in pantry. Interior walls & exterior recently painted (8/22), recent carpet (8/22) 2013 sprinkler system, 2017 water heater, 2017 Trane HVAC w/wifi thermostat, big back yard w/updated fence, & NO BACK NEIGHBORS! You will love Greatwood, a wooded, master planned, golf course community w/a small town feel! Enjoy neighborhood restaurants, shopping at the local HEB, reasonable drive times to the Galleria, Downtown Houston, the Med Center, & all that Fort Bend County has to offer!' ,`Acres` = '0.2035' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD STONEBRIDGE SEC 3, BLOCK 2, LOT 20' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '8864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '915' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Brazos Bend' ,`TaxAmount` = '6689' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794292' WHERE `Matrix_Unique_ID` = '211530953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '12364077' ,`ListAgentFullName` = 'Eric Campbell' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698995' ,`Longitude` = '-95.444989' ,`PhotoCount` = '50' ,`PostalCode` = '77025' ,`RoomCount` = '14' ,`ListPrice` = '1985000.00' ,`Status` = 'Active' ,`StreetName` = 'Dumbarton' ,`StreetNumber` = '4122' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '6035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary luxury inside Loop 610 on a quiet horseshoe shaped street in the heart of Ayrshire. Ground floor Primary Suite features dual vanities, freestanding tub, large triple head shower, 2 large closets. One is semi secure with telephone & video monitor. Study down has an adjacent full bath which can be connected. Chef\'s kitchen features 60\" WOLF dual fuel range with twin 30\" convection ovens, SUBZERO 36\" refrigerator and freezer columns, 2 ASKO dishwashers, large prep island with additional sink and filtered water. Sun room with refreshment center overlooks back yard deck and grill area. 11 foot ceiling down. 2 of the upstairs bedrooms have private baths the other 2 share. Game room with snack bar area & refrigerator/ice maker. Large bonus room could be Gym/media or additional bedroom. Porcelain tile & Brazilian chestnut floors throughout. Security flood lighting, 9 color HD security cameras & monitor. GENERAC 22kw back-up generator. LED lighting. Double height garage. Metal roof' ,`Acres` = '0.2009' ,`Area` = '17' ,`BuilderName` = 'Omni Contractors' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 11 AYRSHIRE SEC 6' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ayrshire Sec 06' ,`TaxAmount` = '36330' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663794293' WHERE `Matrix_Unique_ID` = '211694771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:50:09.357' ,`MLSNumber` = '53924795' ,`ListAgentFullName` = 'Leonel Dubon' ,`ListOfficeName` = 'James B Chaplin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690150' ,`Longitude` = '-95.709548' ,`PhotoCount` = '28' ,`PostalCode` = '77407' ,`RoomCount` = '6' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Pinebrook Arbor Ct' ,`StreetNumber` = '8023' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over $45k in upgrades that include solar panels, wired in Ring security cameras around the whole house, keyless entry, insulated garage attic + garage door, oversized mini split AC unit, 8kwh Tesla solar panels with 2 Tesla power walls that can generate the house in case of a power outage. As if these upgrades weren\'t enough, this charming home features 3 bedrooms, an office, and 2 baths in Grand Vista neighborhood. The open layout will allow you to navigate the spacious areas of the house with ease. The kitchen features granite countertops, pendant lighting in the breakfast bar and stainless steel gas stove+microwave+dishwasher. The home is complimented with a natural paint color and engineered hardwood flooring in every room. Primary bedroom features an en-suite bath with dual vanities, a shower with floor to ceiling tile and walk-in closet. Great location with close proximity to TX 99, Westpark Tollway and 1464.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Grand Vista Sec 19, Block 2, Lot 47' ,`LotDesciption` = 'Other' ,`LotSize` = '5679' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794293' WHERE `Matrix_Unique_ID` = '211740543' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '57866810' ,`ListAgentFullName` = 'Heidi Dugan' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721772' ,`Longitude` = '-95.424096' ,`PhotoCount` = '33' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '2999000.00' ,`Status` = 'Active' ,`StreetName` = 'Quenby' ,`StreetNumber` = '2918' ,`StreetSuffix` = 'Avenue' ,`City` = 'West University Place' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4167' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bask in resort style living in West U at this incredible home on double lot with pool. An entertainer’s dream, the pool sits on 2nd lot & features fabulous gazebo w/summer kitchen, fireplace, covered sitting area, full bath & gorgeous 2022 landscaping. Built by Overstreet, this elevator capable home features 2021 updates including remodeled baths, lighting, laundry, fresh paint in & out, 2 hot water heaters & roof. Home has gorgeous first floor study w/pocket doors & fireplace, oversized dining room overlooking pool, great white porcelain & stainless kitchen w/recent gas cooktop, double ovens, subzero & 2 wine coolers open to large den with fireplace & views to fountain. Pretty 2021 powder room. Lush primary suite with windows overlooking pool boasts luxurious & spacious bath & two great closets, three secondary bedrooms, all with fabulous 2021 updated ensuite baths. Rare, large second floor gameroom. Ideal location close to Rice Village & Wier Park. All per seller.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 19 20 & TR 21A BLK 11 MONTICELLO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11655' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Monticello' ,`TaxAmount` = '43328' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794293' WHERE `Matrix_Unique_ID` = '211854341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '73683536' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691954' ,`Longitude` = '-95.447782' ,`PhotoCount` = '30' ,`PostalCode` = '77401' ,`RoomCount` = '12' ,`ListPrice` = '1145000.00' ,`Status` = 'Active' ,`StreetName` = 'Holt' ,`StreetNumber` = '4305' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous recent construction, completed in 2019 & situated inside The Loop in Bellaire! Never flooded! This home offers 5 bedrooms w/one guest bedroom down w/an en-suite bath. In addition, there is a study & a huge open floor plan w/Chef\'s kitchen & adjacent butler\'s pantry, breakfast area & family room with fireplace overlooking the backyard. The second floor features a spacious primary suite w/sitting area plus luxurious spa bath w/double sinks, a vanity, soaking tub, separate shower & large walk in closet, a huge game room & 3 other bedrooms. Fresh interior pant & new carpet in secondary bedrooms & new flooring upstairs in primary suite, hallways & game room(2022). You will love this quiet location near the end of the street w/no pass-through traffic, Zoned to Horn Elementary, Pershing Middle & newly built Bellaire High and close to Evergreen Pool, Nature Discovery Center, Evelyn\'s Park and many other wonderful Bellaire and Inner Loop attractions!' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'Kinsmen Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 37 & ADJ N 2.5 FT OF ABANDON ALLEY SOUTHDALE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southdale' ,`TaxAmount` = '' ,`TaxRate` = '2.358' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663794293' WHERE `Matrix_Unique_ID` = '211930600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '65976254' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157034' ,`Longitude` = '-95.056425' ,`PhotoCount` = '48' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '230769.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '145' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.42' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1642, ACRES 0.4200' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1083' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794293' WHERE `Matrix_Unique_ID` = '211932525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '84024526' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157082' ,`Longitude` = '-95.056628' ,`PhotoCount` = '40' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '233737.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '161' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.42' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1641, ACRES 0.4200' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1083' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794293' WHERE `Matrix_Unique_ID` = '211939300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '9156701' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157274' ,`Longitude` = '-95.056943' ,`PhotoCount` = '14' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '252985.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '177' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.42' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1640, ACRES .42' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Sec 5' ,`TaxAmount` = '704' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794294' WHERE `Matrix_Unique_ID` = '211942402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:20:40.117' ,`MLSNumber` = '38726034' ,`ListAgentFullName` = 'Gregory Sanders' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.502749' ,`Longitude` = '-95.388391' ,`PhotoCount` = '32' ,`PostalCode` = '77378' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Springs' ,`StreetNumber` = '11510' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous one-story 3 bedroom home is too marvelous to miss!!! Original owner is selling this beautiful custom built Gentry Classic home on a huge 3.396 wooded acre lot located on a quiet cul-de-sac road. Home features three Spacious Bedrooms in a split floor plan giving the owners more privacy in the primary bedroom. Each feature luxurious custom closet systems for maximum organization! Large Kitchen featuring granite tile countertops and stainless steel appliances opens up to the living room with built in fireplace. Large front and back covered porch for enjoying the outdoors. NEW roof 8/2022! Home has been updated with fresh interior paint. This home has an oversized garage with a covered back patio and no rear neighbors but your own acreage! Comes with Home Warranty. Refrigerator and piano are included. Hurry, this one won\'t last. Immaculate, easy to maintain one story home is move-in ready!!! No flooding.' ,`Acres` = '3.396' ,`Area` = '19' ,`BuilderName` = 'Gentry Classic Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S765100 - OAK SPRINGS, BLOCK 1, LOT 5, 6, ACRES 3.396' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '147930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Springs' ,`TaxAmount` = '5123' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794294' WHERE `Matrix_Unique_ID` = '211958518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '26857966' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.156755' ,`Longitude` = '-95.055323' ,`PhotoCount` = '38' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '233408.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '317' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.39' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 9, LOT 1461, ACRES .39' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '16988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1083' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794294' WHERE `Matrix_Unique_ID` = '211974635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '33716737' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157414' ,`Longitude` = '-95.057290' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '199460.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5117' ,`StreetNumber` = '18' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.35' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1639, ACRES .35' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1034' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794294' WHERE `Matrix_Unique_ID` = '211976130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:40:41.697' ,`MLSNumber` = '39455428' ,`ListAgentFullName` = 'Kristina Martinez' ,`ListOfficeName` = 'Luxe Living Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.592250' ,`Longitude` = '-95.520971' ,`PhotoCount` = '23' ,`PostalCode` = '77489' ,`RoomCount` = '5' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Fieldstone' ,`StreetNumber` = '1318' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will LOVE this adorable 1 story, 3 bedroom, 2 bath home with upgrades throughout the entire home & it\'s MOVE IN READY!!! Freshly painted exterior and interior with knockdown texture, newly painted and upgraded cozy fireplace. The home has new windows, new grey vinyl flooring throughout entire home, new light fixtures, new ceiling fans, upgraded showers with new faucets and hardware, new toilets, and granite countertops. The kitchen has new appliances, extra large stainless steel sink, and recently replaced ROOF! The school district is FORT BEND ISD. Low tax rate and HOA!' ,`Acres` = '0.1635' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS GLEN SEC 3, BLOCK 12, LOT 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7122' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '108' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Hunters Glen' ,`TaxAmount` = '4277' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794294' WHERE `Matrix_Unique_ID` = '211998523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:04:09.310' ,`MLSNumber` = '35025275' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947412' ,`Longitude` = '-95.779866' ,`PhotoCount` = '30' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '824990.00' ,`Status` = 'Active' ,`StreetName` = 'Hindwing' ,`StreetNumber` = '11115' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 35025275 - Built by Highland Homes - Ready Now! ~ Welcome to 11115 Hindwing Trail by Highland Homes. This 4 bed, 3 full / 1 half bath home features elegance in every room. Painted brick 16/12 roof pitch elevation. Hardwood Floors throughout main living area. Iron Spindle staircase. Oversized kitchen features silestone Counters, wall mount stainless steel venthood & designer backsplash. Family room features 10\' sliding glass doors to patio with tile fireplace to ceiling. Primary suite features bay window, drop in tub & large walk in shower & dual vanities with knee space. Secondary bedroom on-suite bath downstairs. Gameroom connects to large storage area. On-suite bed / bath upstairs, along with another bedroom. Oversized backyard, extended patio & no rear neighbors. Full yard sprinkler system and underground drains. HERS Energy Certified. Built with the quality you expect in a Highland Home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 1, Sec 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12833' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794294' WHERE `Matrix_Unique_ID` = '212029576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '35987074' ,`ListAgentFullName` = 'Lily Jang' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735778' ,`Longitude` = '-95.450387' ,`PhotoCount` = '30' ,`PostalCode` = '77027' ,`RoomCount` = '3' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Hackberry' ,`StreetNumber` = '1' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3091' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This meticulously-maintained beauty is situated in one of Houston\'s most sought-after neighborhoods in the heart of fine dining, shopping & easy access to all freeways, yet, tucked away in a boutique, gated enclave of just four homes in Highland Village/Mid Lane. First-floor living w/ all hardwoods in an open-concept floor plan. Spacious living room flows seamlessly into the stunning Chef\'s kitchen w/ an oversized quartz island seating 6 comfortably. Commercial-grade appliances, ample storage & a natural wood dry bar w/ wine fridge that will impress your most discerning friends & family. Wall-to-wall windows throughout the living/kitchen/dining area create a sun-filled oasis. The secluded backyard is fully-fenced w/ a green space & features a fieldstone patio w/ elegant, shrub-lined Belgian fence. Upstairs, find your second living space w/ private balcony, bright and airy primary bedroom w/ custom closet & 2 additional bedrooms (all w/ en-suite bathrooms) & utility room. HOA: $25/year.' ,`Acres` = '0.0815' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Highland Village/Midlane' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 COURTYARDS AT HACKBERRY LANE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Courtyards/Hackberry Lane' ,`TaxAmount` = '15524' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794295' WHERE `Matrix_Unique_ID` = '212067667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '44651066' ,`ListAgentFullName` = 'Sarah Powell' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.720717' ,`Longitude` = '-95.422701' ,`PhotoCount` = '22' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '1325000.00' ,`Status` = 'Active' ,`StreetName` = 'Robinhood' ,`StreetNumber` = '2817' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled by Wimmel Design & Co. West University bungalow in prime location. Updates (2014) in the main house: kitchen, baths, mechanical, electrical, plumbing, windows, insulation, appliances and fixtures. Garage converted to above grade two story pool/guest house featuring bedroom, bath and kitchenette adding on an additional 918 sqft. Total livable space 2,590 sqft per HCAD!! Landscaped yard and pool. Exclusions. All information is per Seller.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 12 & 13A BLK 15 MONTICELLO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West University Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794295' WHERE `Matrix_Unique_ID` = '212077497' --> 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','212215035','1663794295','212215035','2022-09-21T01:22:00.333','2618428','Natalie Glass','Natalie Glass Properties','','','29.725443','-95.591502','24','77082','6','575000.00','Active','Royal Oaks Run Drive','12014','Drive','Houston','2','1','3','2247','Single-Family','MODEL HOME FOR SALE IN Gated Community! New construction!!! Jefferson Plan. First floor features family room, dining room with dual sliders leading to fenced yard with turf and fountain, and island kitchen with large walk in pantry. Second floor offers 2 secondary bedrooms with full bath, laundry room, and luxurious primary suite with oversized shower with bench, two closets and separate vanities. Super convenient Westchase location is just 20 minutes from the Texas Medical Center and 10 minutes from the Galleria Area and Energy Corridor. Close-in location in a brand new, small gated community with a community pool, restrooms and central greenspace!','','31','Empire Communities','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Westchase Area','Central Gas','1','Lot 23 Block 1 Royal Oaks Landing','Subdivision Lot','3030','Survey','','2100','1','Never Lived In','2','Freestanding Oven','0','','','Gas Cooktop','','Composition','2 - Alief','OUTLEY ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Royal Oaks Landing','','2.47','Public Sewer,Public Water','2021','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212219510','1663794295','212219510','2022-09-21T01:22:00.333','15721674','Jared Turner','Tri Pointe Homes','','','30.291769','-95.583191','29','77316','4','499477.00','Active','Coppice Creek','452','Lane','Montgomery','2','0','3','1865','Single-Family','Charming one-story stone and siding home. Once inside, the gallery-style foyer will lead you into the open-concept island kitchen overlooking the casual dining and family room. The gourmet kitchen features GE stainless steel appliances, a tile backsplash, Woodmont cabinetry, and granite countertops. The laundry room is conveniently located at the garage entrance and next to the kitchen. In the primary suite, you will find vaulted ceilings, a walk-in closet, dual sinks, a luxury bath, and Silestone quartz countertops. Curl up next to the fireplace with your favorite book or watch the sunset on the covered outdoor patio, with a vaulted ceiling. No Back Neighbors!','','39','Tri Pointe Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Southwest','Heat Pump','1','01/01/02','Subdivision Lot','','','','1275','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Woodforest','','3.14','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212220300','1663794295','212220300','2022-09-21T01:22:00.333','11509308','Jared Turner','Tri Pointe Homes','','','30.291769','-95.583191','15','77316','5','515599.00','Active','Coppice Creek','428','Lane','Montgomery','2','0','3','2128','Single-Family','The Bluebird Floorplan - Charming one-story stucco and stone home. Enter through the 8\' front door into the gallery-style foyer. This floorplan is perfect for hosting guests with the kitchen overlooking both the dining area and the great room. Save time on your commute by utilizing the at home office. Whip up your favorite snacks in the gourmet kitchen featuring a large central island, tile backsplash, white cabinetry, Silestone Quartz countertops, and a 12\'\' under cabinet lighting. Host a summer BBQ outside under the spacious covered outdooring living, with access from the great room. Create your perfect oasis in the primary suite featuring a walk-in closet, dual sink vanity, luxury bath, tile flooring, white cabinetry, and Silestone Quartz countertops. Garage features a 5\'bump out, and lot features no back neighbors.','','39','Tri Pointe Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Southwest','Heat Pump','1','01/01/08','Subdivision Lot','','','','1275','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Woodforest','','3.14','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212224869','1663794295','212224869','2022-09-21T01:22:00.333','25069009','Jared Turner','Tri Pointe Homes','','','30.291769','-95.583191','31','77316','5','518955.00','Active','Coppice Creek','404','Lane','Montgomery','2','0','3','2280','Single-Family','The Starling floorplan - Beautiful, one-story stone and stucco home located on a corner lot with no back neighbors. Enter through the 8\' mahogany front door into the foyer. Host guests and have your next dinner party in a large dining room. Flow guests through the open concept floorplan with the kitchen overlooking both the great room and casual dining area. The kitchen features GE appliances, a 36\'\' built-in gas cooktop, a warm gray tile backsplash, and a large central island. Wind down in the primary suite featuring a dual sink vanity, luxury bath, decorative floor tile, and walk-in closet. Easily access the utility room through the primary walk-in closet. Benefit from luxury vinyl plank running through the main areas of the home. Catch a summer breeze on the covered outdoor patio at your new home!','','39','Tri Pointe Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Southwest','Heat Pump','1','01/01/13','Subdivision Lot','','','','1275','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Woodforest','','3.14','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212225435','1663794295','212225435','2022-09-21T01:22:00.333','68677168','Jared Turner','Tri Pointe Homes','','','30.291769','-95.583191','31','77316','5','529332.00','Active','Coppice Creek','448','Lane','Montgomery','2','0','3','2280','Single-Family','The Starling floorplan - Charming, one-story stone and siding home with no back neighbors. This open concept floorplan is ideal for entertaining with the great room open to the breakfast area, kitchen, and dining room. Get creative with the flex area, use it as a home office or playroom. The primary suite features a dual sink vanity, luxury bath, and large walk-in closet with laundry room access. Catch a cool summer breeze on the covered outdoor patio at your new home!','','39','Tri Pointe Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Southwest','Heat Pump','1','01/01/03','Subdivision Lot','','','','1275','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Woodforest','','3.14','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212225779','1663794295','212225779','2022-09-21T01:22:00.333','64685481','Jared Turner','Tri Pointe Homes','','','30.291769','-95.583191','40','77316','7','549702.00','Active','Coppice Creek','405','Lane','Montgomery','3','0','5','2678','Single-Family','The Martin Floorplan - Beautiful, two-story home. From the porch, enter into the foyer that leads to the open concept floorplan. The kitchen, dining area, and great room flow easily together. The gourmet kitchen features GE appliances, a 36\'\' gas cooktop, a 20\'\' custom hood insert, tile backsplash, and Montana Black Fox cabinetry, tied together by the Bianco Calacatta Silestone quartz countertops. Retreat to the primary suite that showcases a dual sink vanity, luxury bath, a large walk-in closet, Desert Silver quartz countertops, primary bath wall tile, and gray decorative floor tile. Upstairs you will find three additional bedrooms and a spacious loft area. End your day by catching a beautiful sunset under the covered outdoor living space at your new home.','','39','Tri Pointe Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Southwest','Heat Pump','1','01/04/12','Subdivision Lot','','','','1275','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Woodforest','','3.14','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212227054','1663794295','212227054','2022-09-21T01:22:00.333','44990771','Jared Turner','Tri Pointe Homes','','','30.291769','-95.583191','29','77316','8','584853.00','Active','Coppice Creek','401','Lane','Montgomery','3','0','4','2976','Single-Family','The Verdin Floorplan - Welcome to this stunning two-story brick home. Enjoy features such as the gourmet kitchen showcasing a large central island, GE appliances, 36\'\' built-in gas cooktop, tile backsplash, Dakota Maple Smoke cabinetry, and all tied together by Ethereal Haze Silestone quartz countertops. From the great room, head outside to the outdoor covered patio area and enjoy a cool summer breeze. Retreat to the primary suite where you will find a large walk-in closet, dual sink vanity, luxury bath, decorative floor tile, and Desert Silver Silestone quartz countertops. Head upstairs and host a game night in the spacious game room or watch your favorite movie in the media room.','','39','Tri Pointe Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Southwest','Heat Pump','1','01/04/13','Subdivision Lot','','','','1275','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Woodforest','','3.14','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212244032','1663794295','212244032','2022-09-21T01:22:00.333','96149434','Jared Turner','Tri Pointe Homes','','','30.291769','-95.583191','17','77316','6','479300.00','Active','Mallorn','355','Lane','Montgomery','3','1','4','2383','Single-Family','The Cormorant floorplan - Gorgeous two-story home with no back neighbors. Head inside and find an ideal open layout with the great room, dining, and kitchen flowing seamlessly together. The gourmet kitchen features GE appliances, a 36\'\' gas cooktop, tile backsplash, and white cabinetry, all tied together by the Ethereal Noctis Polished quartz countertops. Upstairs you will find two additional bedrooms, along with a spacious game room area. Store your toys and board games in the oversized storage area. After a long day, retreat to the downstairs primary suite that features a large walk-in closet, dual sink vanity, and tile surround at the shower. Benefit from luxury vinyl running through the main areas of the home. This home is one you don\'t want to miss!','','39','Tri Pointe Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Conroe Southwest','Heat Pump','1','01/03/09','Subdivision Lot','','','','1275','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Woodforest','','3.14','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:19:27.270' ,`MLSNumber` = '96943270' ,`ListAgentFullName` = 'Zoila Graves' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837545' ,`Longitude` = '-95.709921' ,`PhotoCount` = '22' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Canyon' ,`StreetNumber` = '19446' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One-story home in Cypress Meadows subdivision. Updated laminate flooring, kitchen countertop with stainless steel sink, and faucet. French door in the master bedroom. The water heater and HVAC system has been replaced in 2018. Plumbing was replaced in the kitchen, bathroom sinks, and master bath. Garage converted into a game room. No Flooding!!' ,`Acres` = '0.124' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 9 CYPRESS MEADOWS 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Meadow' ,`TaxAmount` = '3635' ,`TaxRate` = '2.796' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794295' WHERE `Matrix_Unique_ID` = '212329381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '15853373' ,`ListAgentFullName` = 'Cameron Ansari' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Morgan Allen Neal' ,`SellingOfficeName` = 'C & K Properties' ,`Latitude` = '29.715786' ,`Longitude` = '-95.443144' ,`PhotoCount` = '35' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '1625000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Milton' ,`StreetNumber` = '4103' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely and sensible West U brick home was built in 1990 (per HCAD) and presents a classic all-American house profile: 4 bedrooms (all up), 3 ½ baths, formals, family room and a large kitchen with eat-in breakfast area. Light-filled rooms are nicely proportioned, with crown molding, plantation shutters and hardwood floors (carpet in secondary bedrooms). The house is set on the corner lot of a tree-lined block. Out back, the two-car garage is oriented so that you pull in from Academy rather than Milton, leaving the front of the home unencumbered by a garage entrance. The garage has unfinished quarters above. Aside from the home’s versatile interior architecture – it would suit modern furniture, antiques or traditional styles equally well – the location is ideal. It’s just a few minutes to many of the city’s popular restaurants, supermarkets and shopping. It’s also zoned to West University Elementary. (Buyer must verify eligibility for attendance).' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 23 COLONIAL TERRACE SEC C' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colonial Terrace' ,`TaxAmount` = '25496' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794295' WHERE `Matrix_Unique_ID` = '212367783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:55:50.680' ,`MLSNumber` = '69582873' ,`ListAgentFullName` = 'Pamela Harris' ,`ListOfficeName` = 'Pam\'s Home Team' ,`SellingAgentFullName` = 'Patricia McCulley' ,`SellingOfficeName` = 'Country World Realty, LLC' ,`Latitude` = '30.673768' ,`Longitude` = '-94.945379' ,`PhotoCount` = '37' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lake' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.5051' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESIDE VILLAGE BLK 16 LOT 6 SEC 1' ,`LotDesciption` = 'Water View,Wooded' ,`LotSize` = '22004' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Lakeside Village' ,`TaxAmount` = '4205' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794296' WHERE `Matrix_Unique_ID` = '212375374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:22:00.333' ,`MLSNumber` = '21691458' ,`ListAgentFullName` = 'Heather Coggin' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.115024' ,`Longitude` = '-94.135664' ,`PhotoCount` = '27' ,`PostalCode` = '77703' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood' ,`StreetNumber` = '4125' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is 4/2 House plus apartment ( the apartment has one bedroom full bathroom and it\'s own living room kitchen and dining area, as well as it\'s on entrance), if interested in a rental income, this extra space could also be used as a mother-in-law suite or for overflow guests. This house also features an in ground swimming pool. Located in Beaumont within close proximity to schools.. Total bedrooms including apartment is 5, total bathrooms including apartment is 3.\r\n More pictures coming soon.' ,`Acres` = '0.2507' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PL D-14 TR 204 78.35X140 A WILLIAMS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'JONES-CLARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Williams League' ,`TaxAmount` = '3700' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794296' WHERE `Matrix_Unique_ID` = '212383409' --> 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','212487140','1663794296','212487140','2022-09-21T00:49:54.537','36180859','Lois De Armas','eXp Realty, LLC','','','29.671915','-95.737807','50','77407','10','449900.00','Active','Scoria Rock','5603','Drive','Richmond','3','1','5','3098','Single-Family','FIELDSTONE\'S FINEST! 5 BDRM/3.5 Baths! UPDATED on Texas sized cul-de-sac lot w/ample room for pool! Covered patio w/stained wood ceiling, fans, recessed lights, swings! Fine curb appeal w/rock accents! Shaded front porch! Inviting entry features high-end laminate planks thru-out downstairs! Formal dining! Wrought iron balusters! Open concept! NEW Carpet! Updated kitchen w/custom stone tile back splash, stainless appliances/GAS range, stained wood window seat, GRANITE & big walk-in pantry & counter height bar! Perfect for entertaining! Gas log fireplace! 1/2 bath w/custom sink! Primary w/coved ceiling/sitting area! Primary new tile floors, closet w/built-in\'s, DBL sinks! UPSTAIRS: BIG game room w/coved ceiling, 4 spacious bdrm/2 baths! Ceiling fans! 3 attic storages! Laundry room w/fridge! CAT 6 hardwired for high speed internet in 2 BDRMS upstairs, gameroom, kitchen, living, master! Desirable Ft. Bend schools! Fun area amenities! EZ access to Grand Parkway! Near retail, dining & MORE!','0.2434','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas,Zoned','1','FIELDSTONE SEC 6, BLOCK 1, LOT 53','Cul-De-Sac','10601','Appraisal District','','687','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','19 - Fort Bend','OAKLAND ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Fieldstone','8581','3.059','Water District','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:05:03.190' ,`MLSNumber` = '9803034' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724484' ,`Longitude` = '-95.874979' ,`PhotoCount` = '44' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '539990.00' ,`Status` = 'Active' ,`StreetName` = 'Hauter' ,`StreetNumber` = '29038' ,`StreetSuffix` = 'Way' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 9803034 - Built by Highland Homes - Ready Now! ~ This home boasts natural beauty and light! With the carefully selected natural color patterns found in the home, it\'s simple to intertwine your own style! The kitchen features an extended island and perimeter with amble cabinet space and an acclaimed dining hutch ready to entertain! The elongated windows and ceilings and open concept plan is perfect for modern day living! The home features two bedrooms down, both with walk in closets and one with a bay window, and a study with french glass doors! Upstairs, there are two bedrooms and a game room with a seated bench perfect for entertaining guests! The garage has an extra half space for ample storage!!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794296' WHERE `Matrix_Unique_ID` = '212513963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T01:35:03.727' ,`MLSNumber` = '24499891' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909136' ,`Longitude` = '-95.082271' ,`PhotoCount` = '10' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Chamfer' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautiful home with NO BACK NEIGHBOR! Enjoy the Covered back patio, 3 CAR GARAGE. This home also comes with generator!' ,`Acres` = '0.1635' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 NEWPORT SEC 8 PAR R/P' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '6146' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794296' WHERE `Matrix_Unique_ID` = '212530572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:05:50.113' ,`MLSNumber` = '93287221' ,`ListAgentFullName` = 'Monica Vaca' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671032' ,`Longitude` = '-95.371769' ,`PhotoCount` = '32' ,`PostalCode` = '77051' ,`RoomCount` = '7' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Livingston' ,`StreetNumber` = '8319' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Single Story home is one of a kind. This Traditional 3 bedroom 2 bath home boast with quality , stone in fron and sides of home. High ceilings, open concept kitchen with granite countertops. Custom cabinets & stainless steel appliances. Light and bright home with custom flooring. This split floor plan is spacious, with primary bedroom featuring high trey ceilings. Large windows in living room, overlooks into great covered patio, Primary bath has a large walk in closet. Walk in shower and large soaking tub, also his and her vanities. 2 car garage and large inside laundry in additional xtra room which could be a hobby room/study or in home gym. Large covered porch and back patio. Home located, less than a mile of the 288 expressway and within minutes to Medical Center/Downtown Houston and minutes from U of H. Do not miss out on this perfect home! Priced bellow other new construction. Take advantage today !!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Leveltex' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 6 block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794296' WHERE `Matrix_Unique_ID` = '212571555' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T00:07:28.020' ,`MLSNumber` = '21531289' ,`ListAgentFullName` = 'Issam Hazim' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826012' ,`Longitude` = '-95.801252' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '324500.00' ,`Status` = 'Active' ,`StreetName` = 'Vivaldi' ,`StreetNumber` = '3530' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Stunning two story home providing ample space with 4 bedrooms and 2 1/2 baths! Just outside your front door awaits your own oasis with picturesque lake views. Be impressed with the well-kept front yard landscaping as you make your way inside the foyer. Gleaming hard surface floors flow throughout the main level. Off to the side of the foyer is the formal living room that can also be used as an office/study. Enjoy everyday living in the gorgeous family room, flooded with natural sunlight from the large windows and high ceilings. Spacious first floor primary bedroom continues with high ceilings. Charming bath en-suite is equipped with double sinks, elegant soaking tub, separate walk-in shower and and walk-in closet. All remaining rooms are located on the second level, along with a sizable game room right off the stairs. This home checks all the boxes! An opportunity not to be missed.' ,`Acres` = '0.1527' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 5 CAMILLO LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6652' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 1' ,`TaxAmount` = '8665' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794296' WHERE `Matrix_Unique_ID` = '212684555' --> 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','212752175','1663794297','212752175','2022-09-21T00:13:01.467','73505112','Alejandra De La Campa','Keller Williams Woodlands','','','30.199953','-95.554844','48','77382','18','5499000.00','Active','Norlund','26','Way','The Woodlands','6','2','6','11716','Single-Family','**ON GOLF COURSE, right across Signature Hole 15th of Nicklaus Golf Course, with details in every corner, lots of natural light throughout. High ceilings, wide large windows for pristine views. With 2-story viewing tower. Open foyer with a floating staircase, 2 story study/library, formal living with marble fireplace, formal dining w/butler\'s pantry. Chef\'s island kitchen fully equipped with high end Wolf/Subzero appliances. Game room.Master bedroom w/marble fireplace. Luxurious master bath, with his and Hers walk-in closets. Second Master Suit with a loft on 2nd floor, full bath w/double sink and whirlpool spa. Three secondary bedrooms w/walk-in closet and full baths. Winery, Poker Room, Billiard room, Panic Room, Security System w/video surveillance, built-in pest defense, central vacuum, Equipped media room,Snack bar. Audio System throughout. Planning center and Utility Room. 6 car garage. Covered Patio deck w/Summer kitchen and fireplace. Your Dream Home for a perfect Lifestyle!!','0.7768','15','','','Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','3','The Woodlands','Central Gas,Zoned','1','WDLNDS VIL OF CARLTON WOODS 10, BLOCK 1, LOT 9','Cul-De-Sac,Greenbelt,On Golf Course','33837','Appraisal District','','4250','0','','6','Double Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Tile','11 - Conroe','TOUGH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal','2','Mediterranean','Wdlnds Village Of Carlton Woods 10','','2.1816','Public Sewer,Public Water,Water District','2015','Appraisal District'); --> New record created successfully