Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:55:49.807' ,`MLSNumber` = '14106234' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506554' ,`Longitude` = '-95.408944' ,`PhotoCount` = '18' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Desert Spring' ,`StreetNumber` = '20' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Camden Plan with Elevation T6, their NEWEST modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio and a 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Located in Houston’s newest D.R. Horton Community known as Rodeo Palms, this gorgeous development features walking trails and easy access to major roadways like Hwy 6, FM 521 and 288!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Rodeo Palms Lot 09 Block 02 Section 06' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7408' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Rodeo Palms' ,`TaxAmount` = '' ,`TaxRate` = '3.669' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710532' WHERE `Matrix_Unique_ID` = '203602932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:48:04.017' ,`MLSNumber` = '18063882' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136496' ,`Longitude` = '-94.180916' ,`PhotoCount` = '14' ,`PostalCode` = '77708' ,`RoomCount` = '9' ,`ListPrice` = '284990.00' ,`Status` = 'Active' ,`StreetName` = 'Highpoint' ,`StreetNumber` = '6320' ,`StreetSuffix` = 'Avenue' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully crafted by D.R. Horton America\'s Builder, situated in a quaint gated community in Beaumont\'s West End. The Justin plan is a one-story home featuring 3 bedrooms with a flex space for a 4th bedroom or study, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and family room. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. The owner\'s suite features a sloped ceiling and attractive master bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the family room.' ,`Acres` = '0.1869' ,`Area` = '51' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HIGHPOINT PHASE 1 LOT 1 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highpoint Ph 1' ,`TaxAmount` = '432' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710532' WHERE `Matrix_Unique_ID` = '203841604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:34:40.640' ,`MLSNumber` = '38618669' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141946' ,`Longitude` = '-93.765205' ,`PhotoCount` = '17' ,`PostalCode` = '77632' ,`RoomCount` = '7' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '2840' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern Farmhouse with Lake front lot. New Construction in LCMISD by DR Horton. The Eureka plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. Center kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. Open concept floorplan boasts large, combined family room and dining area. Extra storage space under the stairs is a plus. The private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. Three additional bedrooms and bath. The standard rear covered patio is located off the family room' ,`Acres` = '0.318' ,`Area` = '50' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MALLARD LAKES, SECTION 1, LOT 8, ACRES 0.318' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '13852' ,`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` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Mallard Lakes' ,`TaxAmount` = '934' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710533' WHERE `Matrix_Unique_ID` = '205946145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:33:25.170' ,`MLSNumber` = '70512782' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141961' ,`Longitude` = '-93.764353' ,`PhotoCount` = '25' ,`PostalCode` = '77632' ,`RoomCount` = '8' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Allie Payne' ,`StreetNumber` = '2740' ,`StreetSuffix` = 'Road' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern Farmhouse with Lake front lot. New Construction in LCMISD. The Perry plan is a two-story home featuring 4 bedrooms, 2.5 baths, and 2 car garage. The foyer opens to a study and powder bath with linen closet. Center kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. Open concept floorplan boasts large combined family room and dining area. Extra storage space under the stairs is a plus. The private primary suite with attractive primary bath features dual vanities, water closet and his and hers walk-in closets. A versatile game room greets you at the top of the stairs and opens to three additional bedrooms and bath. The standard rear covered patio is located off the family room.' ,`Acres` = '0.338' ,`Area` = '50' ,`BuilderName` = 'DR. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MALLARD LAKES, SECTION 1, LOT 4, ACRES 0.338' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '13920' ,`LotSizeSource` = 'Other' ,`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` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'LITTLE CYPRESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'LITTLE CYPRESS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Mallard Lakes' ,`TaxAmount` = '960' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710533' WHERE `Matrix_Unique_ID` = '205946332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:48:57.383' ,`MLSNumber` = '55221382' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.137538' ,`Longitude` = '-94.182630' ,`PhotoCount` = '13' ,`PostalCode` = '77708' ,`RoomCount` = '7' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Highpoint' ,`StreetNumber` = '6465' ,`StreetSuffix` = 'Avenue' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully crafted new construction home by D.R. Horton, America\'s Builder. Located in Highpoint a quaint gated community in Beaumont. The Cali plan is a one-story home featuring 3 bedrooms with a flex space for a 4th bedroom or study, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area. Standard features include fenced backyard and front yard sprinkler system!!' ,`Acres` = '0.1848' ,`Area` = '51' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HIGHPOINT PHASE 1 LOT 15 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highpoint Ph 1' ,`TaxAmount` = '409' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1664710533' WHERE `Matrix_Unique_ID` = '205946370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:45:42.947' ,`MLSNumber` = '16671556' ,`ListAgentFullName` = 'Alma Puerto' ,`ListOfficeName` = 'Texas Fast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361641' ,`Longitude` = '-95.624396' ,`PhotoCount` = '12' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '184900.00' ,`Status` = 'Active' ,`StreetName` = 'Westchase' ,`StreetNumber` = '402' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CASA NUEVA DE DUEÑO A DUEÑO. BAJA CUOTA INICIAL. LLAMAR PARA MAS INFORMACION. OWNER FINANCING GREAT INCENTIVES EASY TO QUALIFY. BUY THIS NEW HOME BEFORE IS GONE ! CALL FOR MORE INFO' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = 'Baranda Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 19, LOT 4' ,`LotDesciption` = 'Other' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '146' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710533' WHERE `Matrix_Unique_ID` = '207547599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:04:29.563' ,`MLSNumber` = '17063663' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435481' ,`Longitude` = '-95.441343' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1230' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Caden Plan with Elevation T, their NEWEST modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 6 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6783' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710533' WHERE `Matrix_Unique_ID` = '208452877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:03:52.247' ,`MLSNumber` = '41205913' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.086224' ,`Longitude` = '-95.289159' ,`PhotoCount` = '38' ,`PostalCode` = '77541' ,`RoomCount` = '9' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Zelsky' ,`StreetNumber` = '4410' ,`StreetSuffix` = 'Road' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Have a boat and want to live near the water, without dealing with the bulkhead? Take a look at this beautiful 2 story home, including a 2 car garage with a 7\'x20\'workshop resting on over a ¼ of acre with access to the community boat ramp. Open your front door into the open floorplan with a view of the living room, den, and kitchen. Kitchen comes with upgraded appliances, quartz countertop, soft-close pan drawers & cabinets, pot filler, hands free faucet over a lovely farmhouse sink, tiled backsplash, and a large island. Find comfort in the cozy den with its electric fireplace and a door leading to garage.. Half bath with washer and dryer completes the 1st floor. Solid oak stairs leads to 4 rooms & 2 full baths with endless possibilities for offices, game, or craft rooms. Luxurious primary bath with barn door, dual sinks, soaking tub, and multi-setting rain shower. Grab your fishing pole for a short stroll to the water. Opportunity to purchase additional east side lot.' ,`Acres` = '0.265' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'GM BRYAN TRACT 27A-27G-31B2A-31B2B&THURMAN LOT 29-30(NewLot2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'G M Bryan' ,`TaxAmount` = '4738' ,`TaxRate` = '2.3589' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710533' WHERE `Matrix_Unique_ID` = '209427909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:51:05.330' ,`MLSNumber` = '42221450' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818950' ,`Longitude` = '-94.819975' ,`PhotoCount` = '19' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14919' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Caden Plan, with their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" upgraded gray cabinets, stainless steel oven, dishwasher and microwave and a large breakfast bar. As you walk into the Primary Bathroom, you will see dual sinks, separate shower, garden tub and a large walk-in closet! Step outside to enjoy a large Covered Patio with family and friends! (All information provided by builder). Located in Baytown\'s newest DR Horton Community known as Raintree this gorgeous development located off FM 565 and zoned to the highly-acclaimed Barbers Hill schools! And check out that TAX RATE! Schedule your appointment today!!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot 24 Section 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710534' WHERE `Matrix_Unique_ID` = '209545485' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:02:46.307' ,`MLSNumber` = '66772864' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435385' ,`Longitude` = '-95.441402' ,`PhotoCount` = '38' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '317990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Basin' ,`StreetNumber` = '10623' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Harris Plan with Elevation T, their NEWEST modern design offers 4 spacious bedrooms and 2.5 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 32 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10787' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710534' WHERE `Matrix_Unique_ID` = '209565760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:02:02.097' ,`MLSNumber` = '54011077' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435427' ,`Longitude` = '-95.441388' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '314990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Basin' ,`StreetNumber` = '10611' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Gaven Plan with Elevation T, their NEWEST modern design offers 4 spacious bedrooms and 2 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 35 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7172' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710534' WHERE `Matrix_Unique_ID` = '209565809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:01:25.330' ,`MLSNumber` = '83793478' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435402' ,`Longitude` = '-95.441353' ,`PhotoCount` = '34' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '313990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1414' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Easton Plan with Elevation T, their NEWEST modern design offers 4 spacious bedrooms and 2 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 24 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7167' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710534' WHERE `Matrix_Unique_ID` = '209565868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:00:36.983' ,`MLSNumber` = '73137209' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435385' ,`Longitude` = '-95.441402' ,`PhotoCount` = '38' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1502' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Harris Plan with Elevation T, their NEWEST modern design offers 4 spacious bedrooms and 2.5 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 25 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7088' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710534' WHERE `Matrix_Unique_ID` = '209565910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:59:32.353' ,`MLSNumber` = '76394090' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435481' ,`Longitude` = '-95.441343' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '306990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1506' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Caden Plan with Elevation T, their NEWEST modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 26 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6650' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710534' WHERE `Matrix_Unique_ID` = '209565957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:58:33.933' ,`MLSNumber` = '23739393' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435481' ,`Longitude` = '-95.441343' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1514' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Brooke Plan with Elevation T, their NEWEST modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 28 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6650' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710535' WHERE `Matrix_Unique_ID` = '209565999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:48:22.543' ,`MLSNumber` = '49923899' ,`ListAgentFullName` = 'Ruby Pineda Cervantes' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696651' ,`Longitude` = '-95.716435' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '3' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Stone' ,`StreetNumber` = '19107' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss out on this Gorgeous 3-bedroom, 2 bath home with Beautiful outdoor kitchen. This home features high ceilings with open layout, formal dining, and Breakfast nook.Beautiful granite counters tops & Tile flooring Throughout kitchen and breakfast nook. Hardwood floors throughout with the exception of tile flooring in kitchen and bathrooms. Primary bedroom features a large soaking tub, separate shower, double sinks, & walk-in closet. Beautiful landscaping with Sprinkler system for Hassle free lawn care. Newly replaced roof and Freshly painted kitchen cabinets and doors throughout home.This home is just minutes away from Westpark Tollway, 99 & i-10. Come out and take a look!' ,`Acres` = '0.1447' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 10, BLOCK 3, LOT 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6304' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission' ,`TaxAmount` = '4825' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710535' WHERE `Matrix_Unique_ID` = '210287744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:13:42.963' ,`MLSNumber` = '20128833' ,`ListAgentFullName` = 'Mari Lasewicz' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075569' ,`Longitude` = '-95.196430' ,`PhotoCount` = '45' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaver Glen' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom, 2 and 1/2 Bath. Master down Crown Molding throughout home. Hardwood floors, Surround sound wiring inside and out. Outdoor kitchen and Covered patio. Pool, Hot tub and waterfall. One of the bedrooms is currently set up as a workout/yoga room and another bedroom has been converted into a soundproof movie room. So many extras. Must see.' ,`Acres` = '0.1708' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 10 ELM GROVE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Elm Grove Village Sec 02' ,`TaxAmount` = '5463' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710535' WHERE `Matrix_Unique_ID` = '210370413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:54:05.133' ,`MLSNumber` = '16741659' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818950' ,`Longitude` = '-94.819975' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '307990.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '622' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Easton Plan, their NEWEST Modern design offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" upgraded gray cabinets, stainless steel oven, dishwasher and microwave and a large breakfast bar. As you walk into the Primary Bathroom, you will see dual sinks, separate shower, garden tub and a large walk-in closet! Step outside to enjoy a large Covered Patio! (All information provided by builder). Located in Baytown\'s newest DR Horton Community known as Raintree this gorgeous development located off FM 565 and zoned to the highly-acclaimed Barber Hill schools! And check out that TAX RATE! Schedule your appointment today!!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot 20 Section 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710535' WHERE `Matrix_Unique_ID` = '210888944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:52:38.507' ,`MLSNumber` = '5597426' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818950' ,`Longitude` = '-94.819975' ,`PhotoCount` = '19' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '306990.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '630' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Caden Plan, with their NEWEST Modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" upgraded gray cabinets, stainless steel oven, dishwasher and microwave and a large breakfast bar. As you walk into the Primary Bathroom, you will see dual sinks, separate shower, garden tub and a large walk-in closet! Step outside to enjoy a large Covered Patio. (All information provided by builder). Located in Baytown\'s newest DR Horton Community known as Raintree this gorgeous development located off FM 565 and zoned to the highly-acclaimed Barbers Hill schools! And check out that TAX RATE! Schedule your appointment today!!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot 22 Section 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710535' WHERE `Matrix_Unique_ID` = '210889051' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:19:52.463' ,`MLSNumber` = '53249183' ,`ListAgentFullName` = 'Lisa Davis' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.372475' ,`Longitude` = '-95.537901' ,`PhotoCount` = '29' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Masquerade' ,`StreetNumber` = '7318' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experience life on Lake Conroe in the highly sought after Lake Community of Water Crest on Lake Conroe! WHOLE HOUSE GENERATOR! Lush landscaping w/brick and stone porch with an expansive entry, security system w/cameras, water softener system, and French drains. Home has been freshly painted. Kitchen is open to living room w/an expansive island, breakfast bar, granite countertops, tile backsplash, walk-in pantry, ceramic tile flooring throughout the downstairs. Large extra storage not included in square footage under the stairs can be used as a play area or for your pets. Spacious primary bed and bath with dual sinks, garden tub & separate shower. Game room and bedrooms upstairs. Enjoy the private backyard with no neighbors, neighborhood boat launch, two resort-style pools, excellent clubhouse, fishing ponds, parks, playgrounds, hike/bike paths and so much more! Food Truck Fridays, walking trails & many more perks! Incredible neighborhood amenities. Excellent Location, close to I-45.' ,`Acres` = '0.1641' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S954408 - WATER CREST ON LAKE CONROE 08, BLOCK 1, LOT 7' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Crest On Lake Conroe 08' ,`TaxAmount` = '7880' ,`TaxRate` = '3.0823' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710535' WHERE `Matrix_Unique_ID` = '211232845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:55:55.023' ,`MLSNumber` = '29361532' ,`ListAgentFullName` = 'Darla Caldwell' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041109' ,`Longitude` = '-95.330518' ,`PhotoCount` = '29' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '252500.00' ,`Status` = 'Active' ,`StreetName` = 'Coachgate' ,`StreetNumber` = '6514' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOU\'LL JUST LOVE THIS FLOOR PLAN! 4 BEDROOM,W/ WALK IN CLOSETS,2 BATH ,JACK AND JILL BATHROOM ON SECONDARY BEDROOMS, 2 CAR ATTACHED GARAGE. BACKYARD FENCE RECENTLY REPLACE, SEASONED LANDSCAPING! LOVELY HOME HAS TEXAS PATIO ON FRONT. LEADED GLASS FRONT DOOR. FRESH PAINTED INTERIOR, LARGE BRAND NEW PRIMARY SHOWER,TILE FLOOR IN BATH VANITY AND WALK IN CLOSET. ALL BEDROOMS HAVE NEW LAMINATE WOOD FLOORS. 4TH BEDROOM HAS CUSTOM WALL OF SHELVES FOR ALL THOSE COLLECTABLES.ROOF & WATER HEATER REPLACED. ELEMENTARY SCHOOL IN NEIGHBORHOOD. MIDDLE SCHOOL CLOSE BY. EASY COMMUTE TO THE AIRPORT, HUMBLE AND 1-45 NORTH. SUBDIVISION TENNIS COURTS,PARK AND AREA POOL FACILITY. CYPRESSWOOD GOLF COURSE JUST MINUTES AWAY. READY FOR MOVE IN AND TO MAKE THOSE LIFE LONG MEMORIES!\r\nCALL TODAY FOR YOUR SHOWING WALK THROUGH!' ,`Acres` = '0.1584' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 26 GREENGATE PLACE SEC 4 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '374' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greengate Place Sec 04 R/P' ,`TaxAmount` = '4473' ,`TaxRate` = '2.6867' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664710536' WHERE `Matrix_Unique_ID` = '211453865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:56:29.633' ,`MLSNumber` = '9308682' ,`ListAgentFullName` = 'Britney Skyles' ,`ListOfficeName` = 'Purple Shirt Realty' ,`SellingAgentFullName` = 'Kristi Gray' ,`SellingOfficeName` = 'Infinity Real Estate Group' ,`Latitude` = '29.406740' ,`Longitude` = '-95.218162' ,`PhotoCount` = '26' ,`PostalCode` = '77511' ,`RoomCount` = '6' ,`ListPrice` = '417000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 719' ,`StreetNumber` = '2840' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful home that is tucked away in Alvin. This property is just under 2 acres and has plenty of open space in the front and back yard. Inside there is a huge living room to entertain and gather with family. The windows have beautiful shutter blinds throughout the home. The backyard has a big inground pool that is enclosed. There is also a 12x20 pool house to the side that has a room and restroom, the water just needs to be connected. This home is perfect for country living but still only minutes away from the city and highways. \n\n\nFYI- Loan is assumable with a lower interest !! Please call/text for more details!! Sellers are motivated.' ,`Acres` = '1.95' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0481 H T & B R R TRACT 21F ACRES 1.95' ,`LotDesciption` = 'Other' ,`LotSize` = '84942' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '7475' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710536' WHERE `Matrix_Unique_ID` = '211466954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:38:33.047' ,`MLSNumber` = '93625523' ,`ListAgentFullName` = 'Rachel Solbach-Witt' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844274' ,`Longitude` = '-95.428708' ,`PhotoCount` = '50' ,`PostalCode` = '77091' ,`RoomCount` = '9' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5418A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2153' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Sales Center at corner of Wheatley and W Tidwell open daily from 11-5*** Last \"C\" Floor Plan Available in First Phase!! Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With 91 well-designed Single Family Homes, with a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living, all with green space. The generous sized ‘C’ floor plan features FIRST FLOOR LIVING, a free-flowing cooking-dining-living space, attached 2 car garage, second floor primary w/walk-in closet, second floor central laundry room, second & third bedrooms with Hollywood bathroom. Third floor gameroom (or 4th bedroom) plus FLEX room and optional 3rd full bathroom! This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountains and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oaks Forest.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 66 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710536' WHERE `Matrix_Unique_ID` = '211969025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:25:57.530' ,`MLSNumber` = '28525336' ,`ListAgentFullName` = 'Rachel Solbach-Witt' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844499' ,`Longitude` = '-95.428707' ,`PhotoCount` = '45' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5422C' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Sales Center at corner of Ella and Wheatley open from 11-5 daily*** Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living. The generous sized ‘B’ floor plan features First floor living w/half bath for guest, a free-flowing cooking-dining-living space, attached 2 car garage, Second floor w/2 guest bedrooms with jack & jill bathroom, primary w/walk-in closet, dual sinks, separate soaking tub & shower. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountains and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '2042' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710536' WHERE `Matrix_Unique_ID` = '211969511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:16:47.057' ,`MLSNumber` = '64517107' ,`ListAgentFullName` = 'Natasha Bhakta' ,`ListOfficeName` = 'Houston Dwell Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701546' ,`Longitude` = '-95.717421' ,`PhotoCount` = '17' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '334500.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Heath' ,`StreetNumber` = '19103' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well-kept home has tile flooring throughout, ample natural light, high ceilings, extra space to design and add new homeowners personal touch. This ready to move in home has upgrades including an oversized porch, extra paved backyard, shed for storage, insulated garage door, installed water softener, pre-wired for sound and security and many more attributes. This three bedroom two bath home has an abundance of natural light to create a warm space with a convenient one story layout to access all parts of the home. Home is located in a community with plenty of amenities for families to access. Zoned to Fortbend ISD with easy routes to and from Westpark Tollway and Grand Parkway.' ,`Acres` = '0.1355' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 5, BLOCK 2, LOT 15' ,`LotDesciption` = 'Other' ,`LotSize` = '5904' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '827' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission' ,`TaxAmount` = '5184' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664710536' WHERE `Matrix_Unique_ID` = '212173118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:19:58.153' ,`MLSNumber` = '10312489' ,`ListAgentFullName` = 'Jane Draughon' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220941' ,`Longitude` = '-95.532919' ,`PhotoCount` = '42' ,`PostalCode` = '77382' ,`RoomCount` = '8' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland' ,`StreetNumber` = '112' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a fabulous, active lifestyle in the exclusive age 55 and over gated neighborhood of Del Webb The Woodlands. An amazing 14,000 sq. ft. clubhouse offers large indoor & outdoor pools, fitness center, with a full schedule of exciting social activities managed by a full-time director. This exquisite one story home features designer touches such as a custom built-in breakfast nook, natural stone mosaic tile backsplash, rich dark cabinets, huge island, silestone counter tops, and filtered water faucet. Also a 5 burner gas cooktop, stainless upgraded appliances incl. refrigerator, washer & dryer, plantation shutters, custom shades, high ceilings w/ recessed LED lighting & fans, new decorator paint, oversized 2 car garage, & custom mud room. Luxurious primary suite features a huge shower w/ silver tile, fabulous custom built vanity, large walk-in closet and beautiful cabinetry w/ double sinks. The spacious patio w/ built-in gas & water fixtures.' ,`Acres` = '0.1791' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S402304 - DEL WEBB THE WOODLANDS 04, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb The Woodlands 04' ,`TaxAmount` = '7807' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710537' WHERE `Matrix_Unique_ID` = '212193846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:31:31.363' ,`MLSNumber` = '34207343' ,`ListAgentFullName` = 'Savana Rodriguez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016175' ,`Longitude` = '-95.540635' ,`PhotoCount` = '29' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Hill' ,`StreetNumber` = '8219' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TURN KEY READY! Beautifully updated 5 Bedroom Home, 3 Car Detached Garage with Plenty of Parking Space! Take a Dip in the Heated POOL + SPA With All The Privacy You Need On A .48 ACRE LOT!! Double Door Entry, Newly Installed Flooring Throughout the Entire Home (2022)!! New Recessed Lighting and Fresh Paint (2022)!! Formal Living/Study with Built-Ins and Wood Burning Fireplace! Beautiful Bay Windows in the Breakfast Area with Pool Views! Wet Bar with Built-Ins, Recently Updated Kitchen with Granite Countertops! Spacious Utility Room with Pull-Out Drawer Cabinetry! Upstairs Contains- Large Secondary Bedrooms With Walk-In Closets! Large Primary Bedroom + Bathroom with His & Her Closet and Sink! Recent Roof, Breaker Box, and Much More! Schedule A Showing Today!' ,`Acres` = '0.4791' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 5 017*M1876900-003-005-025 MEMORIAL NORTHWEST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20870' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest Sec 03 R/P' ,`TaxAmount` = '6168' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710537' WHERE `Matrix_Unique_ID` = '212279074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:43:03.090' ,`MLSNumber` = '80315588' ,`ListAgentFullName` = 'Kenneth Li' ,`ListOfficeName` = 'Southwest Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699189' ,`Longitude` = '-95.494087' ,`PhotoCount` = '14' ,`PostalCode` = '77074' ,`RoomCount` = '5' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Rowan' ,`StreetNumber` = '6317' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great for investors. 3 beds, 1.5 baths and one attached carport. granite countertop. hardwood floors thru out. New AC, water heater and roof in 2021. Minutes away from school. shopping center, dining, and easy access to Fwy 59.' ,`Acres` = '' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 8 SHARPSTOWN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharptown' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710537' WHERE `Matrix_Unique_ID` = '212423649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:51:56.637' ,`MLSNumber` = '16233170' ,`ListAgentFullName` = 'Alexis Valentine' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751948' ,`Longitude` = '-95.413733' ,`PhotoCount` = '31' ,`PostalCode` = '77019' ,`RoomCount` = '9' ,`ListPrice` = '4100000.00' ,`Status` = 'Active' ,`StreetName` = 'Del Monte' ,`StreetNumber` = '2218' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious elegance with sophistication and function! Like NEW! 5 bedrooms, 6 full 1 half baths, professionally-equipped kitchen, study or formal sitting room, formal dining room w/ wet bar & butler\'s pantry, game room w/ full bath and mini fridge, media room, amazing master retreat w/state of the art closets, outdoor kitchen w/fireplace, pool/spa, guest quarters, glass enclosed wine room, elevator, 4 fireplaces, home automation system, driveway gate, lovely landscaped yard and so much more!' ,`Acres` = '0.2443' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace,Mock Fireplace,Stove' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 45 RIVER OAKS SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10643' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition,Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'River Oaks' ,`TaxAmount` = '91697' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710537' WHERE `Matrix_Unique_ID` = '212454520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:29:16.740' ,`MLSNumber` = '3574821' ,`ListAgentFullName` = 'Rachel Solbach-Witt' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844274' ,`Longitude` = '-95.428708' ,`PhotoCount` = '50' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5406C' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sales Center at corner of Wheatley and W Tidwell open daily from 11-5. Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living. The generous sized ‘A’ floor plan features Second floor living, a free-flowing cooking-dining-living space, attached 2 car garage, first floor guest bedroom, third floor primary w/walk-in closet, third floor central laundry room, second & third bedrooms with ensuite bathroom. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountain and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 82 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1515' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710537' WHERE `Matrix_Unique_ID` = '212455827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:32:00.663' ,`MLSNumber` = '60532391' ,`ListAgentFullName` = 'Taryn Ashley Diaz' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844274' ,`Longitude` = '-95.428708' ,`PhotoCount` = '50' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5414A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sales Center at corner of Wheatley and W Tidwell open daily from 11-5. Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living. The generous sized ‘A’ floor plan features Second floor living,, a free-flowing cooking-dining-living space, attached 2 car garage, first floor guest bedroom, third floor primary w/walk-in closet, third floor central laundry room, second & third bedrooms with ensuite bathroom. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountains and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 72 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1572' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710537' WHERE `Matrix_Unique_ID` = '212459108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:35:12.340' ,`MLSNumber` = '78550249' ,`ListAgentFullName` = 'Taryn Ashley Diaz' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844274' ,`Longitude` = '-95.428708' ,`PhotoCount` = '50' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatley' ,`StreetNumber` = '5406F' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sales Center at corner of Wheatley and W Tidwell open daily from 11-5. Welcome home to Commons at Ella Forest where you can finally check off everything on your Wishlist! With (91) well-designed Single Family Homes come in a selection of three-floor plan designs offering 2 or 3 Story options & First Floor Living. The generous sized ‘A’ floor plan features Second floor living, a free-flowing cooking-dining-living space, attached 2 car garage, first floor guest bedroom, third floor primary w/walk-in closet, third floor central laundry room, second & third bedrooms with ensuite bathroom. This exciting new gated community will provide walking paths for enjoying the outdoors along with picturesque fountain and landscaping. Located just 15 minutes from Houston’s Galleria or Downtown and just 3 blocks north of Upscale Oak Forest.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 79 BLK 1 COMMONS AT ELLA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2377' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Commons at Ella Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664710538' WHERE `Matrix_Unique_ID` = '212459274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:09:10.873' ,`MLSNumber` = '34357138' ,`ListAgentFullName` = 'Angela Chiang' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996421' ,`Longitude` = '-95.526506' ,`PhotoCount` = '29' ,`PostalCode` = '77069' ,`RoomCount` = '12' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Darschelle' ,`StreetNumber` = '14315' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4211' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A house that is sure to wow. Custom-built, 5 bedroom, 4 bath home with a 3 car tandem garage, office, and game room. Highly sought after primary bedroom and “in-law suite” secondary bedroom on the first floor. High ceilings will surely impress your guests as they enter through the front door. Excellent layout and flow. Many custom features including built-ins, large walk-in closets, spacious bedrooms, radiant barrier and more. The massive kitchen with built in refrigerator is open to the living room and perfect for entertaining. Gorgeous landscaping and grounds with two gazeboes and a serene pond with waterfall in the backyard. Low tax rate. Easy access to highway 249 and located nearby countless restaurants, shopping, entertainment and more at Vintage Park, Champions Forest, and along the bustling Willowbrook 1960 area.' ,`Acres` = '0.2287' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 3 CHAMPION FOREST SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '293' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion Forest' ,`TaxAmount` = '11475' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710538' WHERE `Matrix_Unique_ID` = '212512597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:07:01.020' ,`MLSNumber` = '22899222' ,`ListAgentFullName` = 'Wen-Ching Muzzarelli' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.078175' ,`Longitude` = '-95.173867' ,`PhotoCount` = '37' ,`PostalCode` = '77345' ,`RoomCount` = '10' ,`ListPrice` = '329500.00' ,`Status` = 'Active' ,`StreetName` = 'Windy Gorge' ,`StreetNumber` = '2914' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely single-story home located on a cul-de-sac in upfront Woodstream in Kingwood. Home features an open floor plan with 3 bedrooms, formal dining, and a study (or 4th bedroom). Unique architectural details including archways, tray ceiling, crown molding and much more. The living room features a gas-log fireplace and plenty of windows to bring in natural light. Kitchen has granite countertops and is open to living room. Spacious primary features an en-suite bathroom with dual vanities, garden soaking bathtub & separate shower, and large walk-in closet. Two additional secondary bedrooms and a fabulous Jack-N-Jill bath to share. Freshly painted inside.' ,`Acres` = '0.2202' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 3 MILLS CREEK VLG SEC 1 PAR R/P' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community' ,`LotSize` = '9592' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodstream' ,`TaxAmount` = '6437' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710538' WHERE `Matrix_Unique_ID` = '212567524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:52:01.307' ,`MLSNumber` = '87987943' ,`ListAgentFullName` = 'Justin Travis' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.292654' ,`Longitude` = '-94.817279' ,`PhotoCount` = '18' ,`PostalCode` = '77551' ,`RoomCount` = '5' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue K' ,`StreetNumber` = '4506' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home in Historical Galveston will not disappoint! Upon entry, you are greeted with plenty of natural light, high ceilings, and original hardwood floors. The living room is bright, big and perfect for entertaining guests! The upper balcony is a great getaway to enjoy a book and cup of coffee in the morning. Just off of the living room, is the formal dining area that boasts high ceilings and plenty of room for a nice gathering! The kitchen has more than enough storage and plenty of counter space for the chef in the family. Minutes away from the seawall, shopping, dining, entertainment, and many more amazing places that Galveston, TX has to offer! Call or text today for a private tour!!' ,`Acres` = '0.0799' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Space Heater,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 15 & E 4 FT OF LOT 16 BLK 12 DEN' ,`LotDesciption` = 'Other' ,`LotSize` = '3480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Denver Resurvey (Nha)-2965.1' ,`TaxAmount` = '1872' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710538' WHERE `Matrix_Unique_ID` = '212575065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:02:07.973' ,`MLSNumber` = '47874288' ,`ListAgentFullName` = 'Wendy Hanks' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.543565' ,`Longitude` = '-95.305039' ,`PhotoCount` = '46' ,`PostalCode` = '77584' ,`RoomCount` = '9' ,`ListPrice` = '749500.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside' ,`StreetNumber` = '3409' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3724' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s your chance to own your DREAM home in the highly desired gated-community of Audubon Place! This immaculately maintained home is stunning and has been updated with beautiful and timeless finishes! Featuring 4 bedrooms, 3 1/2 baths, and a 3-car tandem garage, the home has plenty of space with an open floor plan. Nothing has been left untouched from new ceiling fans and light fixtures inside & out; gorgeous quartzite counter tops & high-quality Moen and Kohler fixtures in all the bathrooms; wood flooring; Shaw carpet w/ lifetime warranty; and smart features including Nest thermostats, Ring doorbell, WiFi garage door openers, and upgraded sprinkler system with WiFi control panel which help make life a little easier & energy efficient. Your own backyard oasis awaits out back with a sparkling heated pool/spa with tranquil, sheer decent waterfalls. There is plenty outdoor living space ready for year-round family fun & entertaining. Don\'t wait; make an appointment & come see today!' ,`Acres` = '0.2845' ,`Area` = '5' ,`BuilderName` = 'David Powers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AUDUBON PLACE SEC 1 (A0509 HT&BRR) BLK 2 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1014' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon Place Sec 1' ,`TaxAmount` = '12360' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710538' WHERE `Matrix_Unique_ID` = '212771140' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:57:29.493' ,`MLSNumber` = '89909111' ,`ListAgentFullName` = 'Emil Tadros' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699426' ,`Longitude` = '-95.683883' ,`PhotoCount` = '21' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Chickory Woods' ,`StreetNumber` = '7127' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry, this one won\'t last long. Many updates!!!! Freshly painted, new bathroom fixtures on second floor. Three years ago: new roof, new A/C, new laminate on first floor, new carpet on 2nd floor, new granite and recessed lighting in kitchen.' ,`Acres` = '0.132' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREAT OAKS SOUTH SEC 1, BLOCK 2, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Great Oaks South' ,`TaxAmount` = '5336' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664710538' WHERE `Matrix_Unique_ID` = '212829733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:58:40.507' ,`MLSNumber` = '15197050' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806677' ,`Longitude` = '-94.906842' ,`PhotoCount` = '33' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Chase' ,`StreetNumber` = '10014' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Come and see this beautiful property with 4 Bedrooms with ceiling fans and 2 Full Bath. The large master bedroom is complete with on suite bath and walk-in closets. This home has a large family room that your family will enjoy. This house features 2 Car garage with recent upgrades that include large 4 inch gutters around the house, concrete patio backyard, newly painted kitchen cabinets, new front door, solar screens to all windows, and a 350 sq ft patio at back yard. Property is located in the quiet community of Lynnwood. Make an Appointment Today!' ,`Acres` = '0.126' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 1 LT 4 LYNNWOOD SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynnwood Sec 3' ,`TaxAmount` = '6559' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710539' WHERE `Matrix_Unique_ID` = '212926174' --> 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','212951036','1664710539','212951036','2022-10-01T23:12:55.120','6635160','Jonathan Denissen','FYI Realty','','','29.890527','-95.740279','5','77433','7','310400.00','Active','Cypress Juniper','21535','Drive','Cypress','2','0','4','1637','Single-Family','Beautiful New Construction 1 Story Saratoga Home, the Clover, located at Cypress Oaks North. Home has 4 bedrooms, 2 Bathrooms and a 2 car attached garage. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Master Suite complete with double sinks. Home to be complete in December','','25','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','','','','Cypress South','Central Gas','1','LT 33 BLK 1 CYPRESS OAKS NORTH SEC 1','Subdivision Lot','','','','500','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','CYPRESS OAKS NORTH','','','Public Sewer,Public Water,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','212951954','1664710539','212951954','2022-10-01T22:42:14.950','11347625','Jonathan Denissen','FYI Realty','','','29.890500','-95.740000','6','77433','8','345700.00','Active','Cypress Juniper','21559','Drive','Cypress','2','1','4','2083','Single-Family','Beautiful New Construction 2 Story Saratoga Home, the Camille, located in Cypress Oaks North. Home has 4 bedrooms, 2 1/2 Bathrooms, study and a large game room, and a 2 car attached garage. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and tile flooring. Master Suite complete with double sinks. Home to be complete in December.','','25','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','','','','Cypress South','Central Gas','0','LT 27 BLK 1 CYPRESS OAKS NORTH SEC 1','Subdivision Lot','','','','500','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Cypress Oaks North','','','Public Sewer,Public Water,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','212952731','1664710539','212952731','2022-10-01T22:46:11.663','12480779','Jonathan Denissen','FYI Realty','','','29.890500','-95.740000','5','77433','7','321400.00','Active','Cypress Myrtle','7919','Drive','Cypress','2','0','4','2013','Single-Family','Beautiful New Construction 1 Story Saratoga Home, the Oliver, located in Cypress Oaks North. Home has 4 bedrooms, 2 Bathrooms and a 2 car attached garage. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Home to be complete in December.','','25','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','','','','Cypress South','Central Gas','1','LT 22 BLK 1 CYPRESS OAKS NORTH SEC 1','Subdivision Lot','','','','500','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Cypress Oaks North','','','Public Sewer,Public Water,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','212953155','1664710539','212953155','2022-10-01T23:16:56.140','39043976','Jonathan Denissen','FYI Realty','','','29.959581','-95.679918','6','77433','8','390400.00','Active','Virginia Cypress','7922','Court','Cypress','3','1','4','2533','Single-Family','Beautiful New Construction 2 Story Saratoga Home, the Christina, located in Cypress Oaks North. Home has 4 bedrooms, 3 1/2 Bathrooms, a game room, office/study, and a 2 car attached garage. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Master Suite complete with double sinks. Home to be complete in December.','','10','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','','','','Cypress North','Central Gas','1','N/A','Subdivision Lot','','','','500','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','SAMPSON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Cypress Oak North','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T23:07:01.020' ,`MLSNumber` = '83479083' ,`ListAgentFullName` = 'Nicholas Bruns' ,`ListOfficeName` = 'Sprout Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819860' ,`Longitude` = '-95.423508' ,`PhotoCount` = '36' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Autumndale Dr' ,`StreetNumber` = '3513' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the highly sought after, gated Shepherd Oaks community. This massive 4 bed, 4.5 bath home with large backyard and patio is sure to impress. Third floor of your dreams containing theater room with 110 inch projector screen and wet bar, almost 400 sq ft bonus room and large balcony. First level contains open concept floor plan, including gourmet kitchen with large quartz island that overlooks spacious family room. Features include high ceilings, tons of natural light, crown molding, and hardwood floors. Meticulously well maintained; single owner. Second level contains fabulous master\'s suite with dual vanities, large garden tub, and separate shower with dual shower heads. Every bedroom has it\'s own full bathroom! Community area outside back gate with gazebo; ample guest parking. HOA fee covers yard maintenance and water. Right in the heart of Garden Oaks with plenty of parks, dining, shopping, and even a brewery and winery close by. Please ask about all the upgrades!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 SHEPHERD OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710539' WHERE `Matrix_Unique_ID` = '212954446' --> 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','213067917','1664710539','213067917','2022-10-01T22:52:30.270','42920390','Bruce Sellers','Keller Williams Advtge Realty','','','30.272210','-95.538208','41','77316','9','499900.00','Active','Boarsmen','108','Court','Montgomery','3','1','4','2832','Single-Family','Exquisitely maintained two-story on cul de sac in Deerbourne Ridge in Woodforest, this \"smart home\" features voice command lighting and electronic, automatic locking doors. Wood flooring throughout first floor living area, this four bedroom, 3.5 bath beauty is ready for you to call it home. Woodforest is located just south of Lake Conroe and features a broad array of retail and dining options. Located at the back of The Woodlands, you also have quick and easy access to all the shopping, dining and world class medical facility amenities of The Woodlands. Uniquely situated to offer residents their choice of Montgomery or Conroe Independent School Districts,','0.1808','39','Lennar Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','S965264 - WOODFOREST 64, BLOCK 1, LOT 75','Cul-De-Sac,In Golf Course Community','7874','Appraisal District','','1265','0','','2','Single Oven','0','','','Gas Range','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Woodforest','8640','2.6888','Water District','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213095095','1664710539','213095095','2022-10-01T23:56:56.657','61860695','Miriam Rivademar','BHGRE Gary Greene','','','29.654217','-95.365921','12','77051','6','200000.00','Active','Dawson','4219','Lane','Houston','2','0','4','1400','Single-Family','Only 5.9 miles from Houston Medical Center, Museum district, huge employment hubs & downtown. This 4 Bedroom one story is a rare find. It has a brand new roof + other new upgrades. No carpet whatsoever. Updated kitchen and bath rooms. As you enter the house you have a large family room w/ 2 large ceiling fans. House has been 100% repainted in and out in nice calm modern tones. It is clean and ready to be a home to a nice family or group of friends again. The yard is great size and it has a large covered patio. On the front you have a super sized carport and it is wheel chair accessible. House sits on a street that is a cull de sac. and it is the only house that is fully gated and has a huge carport.','0.1604','3','','','','','Sellers Disclosure','','','','Medical Center South','Central Electric','1','LT 17 BLK 4 RIVERBROOK','Cul-De-Sac','6986','Appraisal District','','600','0','','0','','0','','','','','Composition','27 - Houston','WOODSON ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','THOMAS MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Riverbrook','966','2.3307','Public Water','1955','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213112833','1664710539','213112833','2022-10-01T22:00:36.170','97481117','Irene Sadkowski','RE/MAX Real Estate Assoc.','','','29.741106','-95.569021','50','77042','13','579000.00','Active','Piping Rock','10826','Lane','Houston','2','1','5','2783','Single-Family','SOPHISITICATED buyers will ADORE JUST UPDATED 5 bed POOL GEM/Highly sought after LAKESIDE ESTATES\r\nSparkling pool/grt outdoor kitchen Large covered patio/slate. BACKYARD OASIS Entertain in style. Cul de Sac St\r\nEnormous main suite/plant shutter/updated trendy big bath. Lrg jetted tub, sep shower, his /her sinks/vanity knee space. 2 WI closets lots built ins/barn door Tiled porch Lead glass front door. Formal living & dining plantation shutters. Glass chandelier formal dining. Sizeable kitchen, sleek granite countertop, travertine tile backsplash, glass front cabinets, great gas stove/precious glass stained window. Breakfast/pretty shaped window/plant shutter.\r\nSpacious family room fireplace, French doors/dry bar.\r\nAudio stereo speaker system\r\nNEVER FLOODED\r\nRECENT ROOF/FLOORs/ DRIVEWAY/BATH UPDATES/PAINT/WATER HEATER/CEILING FANS, 2022 & MUCH MORE \r\nWash/dry/fridge\r\nClub house/tennis/pool/private park\r\nConvenient restaurants/medical/retail I-10 Belt 8/ Terry Hershey Park\r\nTOUR TODAY!','0.2039','31','','','Electric Dryer Connections,Washer Connections','','Estate,Home Protection Plan,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Briargrove Park/Walnutbend','Central Electric,Central Gas','1','LT 23 BLK 5 LAKESIDE ESTATES SEC 2','Subdivision Lot','8880','Appraisal District','','972','0','','1','Gas Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','27 - Houston','WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Lakeside Estates Sec 02','8416','2.3307','Public Sewer,Public Water','1970','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213117909','1664710539','213117909','2022-10-01T22:17:04.573','78556566','Danting Yin','Forever Realty','','','29.568977','-95.578024','22','77459','11','348000.00','Active','Lily Pond','3319','Court','Missouri City','3','1','4','3013','Single-Family','Located in prestigious Heritage Colony subdivision, super quiet Cut-De-Sac, throughly upgraded two story home. High ceiling, natural light, recent upgraded flooring, fresh paint, upstairs bedroom has its own en suite.','0.1912','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','HOA First Right of Refusal,Owner/Agent,Sellers Disclosure','1','Gas Connections','2','Missouri City Area','Central Electric,Central Gas','1','HERITAGE COLONY SEC 5, BLOCK 7, LOT 39','Cul-De-Sac','8328','Appraisal District','','790','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','AUSTIN PARKWAY ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Traditional','Heritage Colony','8272','2.71','Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:45:37.093' ,`MLSNumber` = '85433504' ,`ListAgentFullName` = 'Derek Boles' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659215' ,`Longitude` = '-95.530172' ,`PhotoCount` = '19' ,`PostalCode` = '77031' ,`RoomCount` = '3' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Torcello' ,`StreetNumber` = '8708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently built townhome in a flourishing gated community. This home is gently lived in and will feel like new when you come to visit. Located at the end of the street for additional privacy. Spacious downstairs area with an updated kitchen. Upstairs hold 3 generous sized bedrooms and no back neighbors. Community is tucked away with little traffic. This is a great option for anyone looking to have a peaceful property as your next residence.' ,`Acres` = '0.0458' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 VENETIAN LUXURY HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'VALLEY WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Venetian Luxury Homes' ,`TaxAmount` = '4170' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710539' WHERE `Matrix_Unique_ID` = '213118495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:05:41.240' ,`MLSNumber` = '8144413' ,`ListAgentFullName` = 'Patricia Fleming' ,`ListOfficeName` = 'Patricia Fleming Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853218' ,`Longitude` = '-95.694595' ,`PhotoCount` = '29' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '294800.00' ,`Status` = 'Active' ,`StreetName` = 'Esk River' ,`StreetNumber` = '5703' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO YOUR \"BETTER THAN NEW\" GORGEOUS LEGEND HOME*LOCATED IN THE HIGHLY ACCLAIMED COMMUNITY OF ADELAIDE*THIS BEAUTY SITS ON A LARGE CORNER LOT & IS \"ALL DRESSED UP AND READY TO CALL HOME!\"THIS LOVELY HOME FEATURES SOLID UPSCALE VINYL PLANK FLOORING THROUGHOUT THE MAIN LIVING AREAS*ABUNDANT STORAGE TO BE FOUND INCLUDING A LARGE CLOSET TUCKED UNDER THE STAIRS*THE GOURMET KITCHEN BOASTS PLENTY OF STORAGE SPACE WITH ITS 42\" MOCHA STAINED HARD MAPLE CABINETRY*EXPANSIVE GRANITE COUNTERS W LARGE SEATING BREAKFAST BAR*STAINLESS STEEL ENERGY STAR APPLIANCES WITH A FULL SIZED GAS RANGE*SS DISHWASHER & MICROWAVE*THE OPEN KITCHEN LEADS TO THE LARGE DEN AREA W LOTS OF NATURAL LIGHT*2\" WOOD BLINDS THROUGHOUT*THE PRIMARY SUITE IS TUCKED AWAY TOWARD THE BACK OF THE HOME FOR PEACE & PRIVACY*THE ATTACHED ENSUITE BATH W ITS OVERSIZED SOAKING TUB IS A PLUS ALONG W THE SEPARATE SHOWER & LARGE WALK IN CLOSET*THE ROOMY GUEST BEDROOMS ARE FOUND UPSTAIRS*EPOXY COATED FLOOR IN THE GARAGE IS A PLUS!' ,`Acres` = '0.0796' ,`Area` = '25' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 ADELAIDE SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '3469' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Adelaide Sec 2' ,`TaxAmount` = '5391' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710539' WHERE `Matrix_Unique_ID` = '213182592' --> 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','213184290','1664710540','213184290','2022-10-01T22:39:30.170','66193830','Maurice Belfonte','Coldwell Banker Realty','','','29.753843','-95.875225','32','77494','12','629000.00','Active','Crossvine','2526','Drive','Katy','4','1','4','4022','Single-Family','THIS is the home you have been searching for!! Builder completed this home toward the end of 2016 and it has been gently lived in by the previous owners. Front door is north facing. Nestled on a cul de sac in the desirable Firethorne West community, this home lacks nothing. With ample space spread across this 4022 sq. foot plan, the 4 bedrooms along with 4 full bathrooms and one half bath are very spacious and inviting. There is a second bedroom with a full bath on the first floor that can be used as an in-law suite or a long term guest quarters. There is a media room and a huge game room on the second floor that will make entertaining extremely easy. This home sits on a huge lot that is ready for you to add that amazing pool you\'ve been dreaming of. You\'ll be conveniently located just a few minutes walking distance to Kathleen Joerger Lindsey elementary school and a short distance away from a ton of other great amenities in the community. Don\'t wait to come see this beautiful home.','0.215','30','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - Southwest','Central Gas','1','FIRETHORNE WEST SEC 11, BLOCK 1, LOT 8','Cul-De-Sac','9366','Appraisal District','','800','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Firethorne West Sec 11','11558','2.5848','Water District','2016','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213192542','1664710540','213192542','2022-10-01T23:30:44.397','65731440','Etha Eglin','Keller Williams Metropolitan','','','30.141428','-93.786723','12','77632','6','329990.00','Active','Allie Payne','3403','Road','Orange','2','0','4','2036','Single-Family','The Eureka Plan a 2036 square foot single story home by America\'s Home Builder D.R. Horton located in Mallard Lakes, a private lake community! Tour this stunning home with front elevation divided light windows, lighted front porch / back patio. The interior includes raised panel interior doors with designer lever handles and smart door lock on front exterior door. Your gourmet kitchen includes granite countertops, stainless steel range and dishwasher. Enjoy your main bedroom suite including a large walk-in closet & ensuite. Home features a tankless water heater and a smart home package.','0.479','50','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','','Central Gas','0','OAK ALLIE, LOT 15, ACRES 0.48','Subdivision Lot','20865','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','683 - Little Cypress-Mauriceville Consolidated','LITTLE CYPRESS ELEMENTARY SCHOOL','LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL','LITTLE CYPRESS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Oak Allie','185','2.831','Public Sewer,Public Water','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','213192647','1664710540','213192647','2022-10-01T22:04:43.160','57393380','Etha Eglin','Keller Williams Metropolitan','','','30.141428','-93.786723','10','77632','7','359990.00','Active','Allie Payne','3407','Road','Orange','2','0','4','2134','Single-Family','The Holden is a single story home by America\'s Home Builder D.R. Horton located in Mallard Lakes, a private lake community! With 4bedrooms and 2 bathrooms, offering 2,394 square feet of living space. As you enter the home into the foyer, you will pass all three, spacious, a large extra bathroom, and the laundry room. Continuing down the foyer, into the home, you will enter the wide open living space with plenty of natural lighting. The spacious kitchen offers a large kitchen island, walk-in pantry, granite countertops, stainless steel appliances, and decorative tile backsplash. The kitchen island overlooks the spacious dining room that faces the covered patio and backyard. The family room is just off the dining room and provides plenty of open space, perfect for entertaining. The primary suite has a huge walk in closet and dual vanities.','0.479','50','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Gas','0','OAK ALLIE, LOT 13, ACRES 0.48','Subdivision Lot','20865','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','683 - Little Cypress-Mauriceville Consolidated','LITTLE CYPRESS ELEMENTARY SCHOOL','LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL','LITTLE CYPRESS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Oak Allie','185','2.831','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T22:22:46.383' ,`MLSNumber` = '51400474' ,`ListAgentFullName` = 'Michelle Reyna' ,`ListOfficeName` = 'The Reyna Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732879' ,`Longitude` = '-95.387721' ,`PhotoCount` = '33' ,`PostalCode` = '77006' ,`RoomCount` = '6' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Greeley' ,`StreetNumber` = '4409' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2016' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming and thoughtfully updated bungalow with 1 2/2 main house and 2 guest cottages. This home is currently being operated as an income producing Airbnb rental property. Totally updated in 2021, this property is also being offered with an option to purchase fully furnished allowing you to continue to the rental operation or make it your very own oasis in the city. Front porch, back patio with deck, laundry room in main house with access to the rear guest cottages.' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 9 FITZE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MACGREGOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fitze Homestead' ,`TaxAmount` = '12795' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1923' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710540' WHERE `Matrix_Unique_ID` = '213199766' --> 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','213208472','1664710540','213208472','2022-10-01T22:09:01.947','71303734','Andrew Codia','Ameri Choice Realty, LLC','','','30.062246','-95.524871','19','77379','9','435000.00','Active','Greencreek Meadows','6507','Lane','Spring','3','1','4','3216','Single-Family','Property located in Klein ISD. Easy access to Hwy 99 and I-45. Property features, 4 bedrooms, 3.5 baths, master down, kitchen island, walk-in pantry, formal dining, breakfast area, plantation shutters, crown molding, tile entry, fireplace, engineered wood on formal dining and office area. Low property taxes.','0.1865','14','','','','','Sellers Disclosure','','','1','Spring/Klein/Tomball','Central Gas','1','LT 23 BLK 1 WINDROSE WEST SEC 7','Subdivision Lot','8125','Appraisal District','','877','0','','2','','0','','','','','Composition','32 - Klein','BENIGNUS ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','KRIMMEL INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Windrose West Sec 07','9023','2.7066','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213209000','1664710540','213209000','2022-10-01T22:04:17.967','76711516','Raul Gonzalez','Realty Associates','','','29.112032','-95.351525','24','77515','2','193500.00','Active','Sandpiper','12107','Road','Angleton','1','0','2','1084','Single-Family','Come take a look at this two bedroom one bath canal home located on three lots. The garage is very spacious with an air conditioned workshop space. The laundry room is spacious and has a great storage area. The cargo lift will make it easy to bring groceries or any other items in. Home is located towards the end of the canal and is near Bastrop Bayou. Easy access to the Gulf of Mexico. Call today to schedule your showing appointment.','0.4304','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Surfside','Central Electric','0','BASTROP HOLIDAY BEACH (A0342 WM MCDERMOTT) LOT 18-19-20','Waterfront','18748','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','5 - Angleton','SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Bastrop Holiday Beach','2233','2.0772','Septic Tank,Well','1976','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213209948','1664710540','213209948','2022-10-01T22:14:02.103','6247544','Thomas Caine','Texas United Realty','','','29.590451','-95.238738','28','77089','3','269900.00','Active','Kirkwren Drive','10602','Drive','Houston','2','1','3','1727','Single-Family','Come cool off in your own private pool and heated Jacuzzi. This home is Beatifully remodeled, open and spacious with a contemporary flair. New LVT flooring in living area, Granite countertops in kitchen and stainless steel appliances. Bathrooms feature new faucets and fixtures, fresh paint and brand new frieze carpet.','0.1848','3','','','','','Sellers Disclosure','','','1','Southbelt/Ellington','Central Gas','0','LT 52 BLK 16 KIRKWOOD SOUTH SEC 4','Subdivision Lot','8050','Appraisal District','','','0','','2','','1','In Ground','','','','Composition','41 - Pasadena','MOORE ELEMENTARY SCHOOL (PASADENA)','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Contemporary/Modern','Kirkwood South Sec 04','5220','2.6355','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213210166','1664710540','213210166','2022-10-01T23:10:41.417','22345011','Kelley Brouillette','Berkshire Hathaway HomeServices Premier Properties','','','29.635574','-95.766749','33','77406','5','349000.00','Active','Fox Vale','2911','Court','Richmond','2','0','3','1674','Single-Family','Showings start Monday October 3 on this gently lived in Devon Builders\' home with over-sized cup-de-sac and tree lined back yard. Stone and brick front elevation, with all four sides of the home brick! New extended back patio for entertaining. Home has wood tile flooring throughout all rooms except bedrooms and office with frize carpet. Granite on all counters! Upgraded tile in bath areas and shower. Office has French doors. Island kitchen with large walk-in pantry. 5 Burner gas cooktop and all stainless appliances. Tankless hot water heater! Pride of ownership shows on this one!','0.1824','37','Devon Street','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Fort Bend County North/Richmond','Central Gas','1','MCCRARY MEADOWS SEC 2, BLOCK 1, LOT 70','Cul-De-Sac','7947','Appraisal District','','800','0','','2','Electric Oven,Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','FROST ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch','Mccrary Meadows','3060','2.8548','Public Sewer,Water District','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213210844','1664710540','213210844','2022-10-01T22:20:03.537','289723','Feras Rachid','Opendoor Brokerage, LLC','','','30.033787','-95.493729','31','77379','4','302000.00','Active','Cobble','5222','Lane','Spring','2','1','4','2491','Single-Family','Welcome to this gorgeous neighborhood! You don’t want to miss this home. The kitchen boasts generous counter space, a breakfast bar, tile backsplash, and sleek countertops, making cooking and entertaining a delight. Flow into the main living area, featuring a fireplace and well placed windows for natural lighting. The main bedroom and bathroom give you the perfect space for everyday living. Relax with your favorite drink in the fenced in backyard with a patio and lush grass. Don\'t miss this incredible opportunity.','0.2152','13','','','','','Sellers Disclosure','1','','1','Champions Area','Central Gas','1','LT 19 BLK 1 TERRANOVA SEC 1','Subdivision Lot','9374','Appraisal District','','603','0','','2','','0','','','','','Other','32 - Klein','BENFER ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Terra Nova Sec 01','5636','2.3266','Water District','1978','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213211046','1664710540','213211046','2022-10-01T22:43:20.547','67539011','Shannon Sudderth','ERA Legacy Living','','','29.270654','-94.843723','8','77551','3','375000.00','Active','Jones','7308','Drive','Galveston','2','0','3','1768','Single-Family','Come one come all... this GEM wont last! This beautiful home is located in a prime location in Galveston, less than 5 minutes away from the beach. You will find the open layout of this property inviting and full of possibilities. Over the past couple of years there have been many renovations on this property, such as; paint throughout, kitchen cabinets, back splash, countertops, light fixtures, as well as heavy duty wind storm windows were installed. If you are desiring a home with a relaxing courtyard in the back that you can kick off your shoes and relax in, well this is your opportunity to have your oasis!','0.1148','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Near West End','Central Electric','0','ABST 121 PAGE 78 LOT 5 MAGNOLIA HEIGHTS','Other','5000','Appraisal District','','','0','','2','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Contemporary/Modern','Magnolia Heights','3783','2.0662','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully