Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:36:20.037' ,`MLSNumber` = '46886392' ,`ListAgentFullName` = 'Blake Jessee' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698426' ,`Longitude` = '-95.367279' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '10' ,`ListPrice` = '419999.00' ,`Status` = 'Active' ,`StreetName` = 'Luca' ,`StreetNumber` = '3524' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Cadillac Towers! Located in the South Houston area, you are in a prime location to access many of Houston\'s hottest hubs: Midtown, MedCen, UH, Downtown + easy freeway access. Just south of the historic Third Ward you will have access to many locally-owned restaurants and stores. There is a ton of development happening in the immediate area, which is a great sign for homeowners! IMPORTANT NOTES: private driveway, open concept floor plans, top-of-the-line finishes, modern/contemporary design, massive bedrooms all with ensuites, covered patio, large closets and MORE!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Deeb' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Cadillac Towers Lot 01 Block 01' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2057' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cadillac Towers' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216144' WHERE `Matrix_Unique_ID` = '203692311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:36:32.390' ,`MLSNumber` = '64722590' ,`ListAgentFullName` = 'Blake Jessee' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698400' ,`Longitude` = '-95.367356' ,`PhotoCount` = '16' ,`PostalCode` = '77021' ,`RoomCount` = '10' ,`ListPrice` = '429990.00' ,`Status` = 'Active' ,`StreetName` = 'Cadillac' ,`StreetNumber` = '6707' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Cadillac Towers! Located in the South Houston area, you are in a prime location to access many of Houston\'s hottest hubs: Midtown, MedCen, UH, Downtown + easy freeway access. Just south of the historic Third Ward you will have access to many locally-owned restaurants and stores. There is a ton of development happening in the immediate area, which is a great sign for homeowners! IMPORTANT NOTES: private driveway, open concept floor plans, top-of-the-line finishes, modern/contemporary design, massive bedrooms all with ensuites, extended covered patio, large closets and MORE!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Deeb' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Cadillac Towers Lot 05 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2524' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cadillac Towers' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216145' WHERE `Matrix_Unique_ID` = '203884669' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:36:03.563' ,`MLSNumber` = '27798525' ,`ListAgentFullName` = 'Blake Jessee' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698426' ,`Longitude` = '-95.367279' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Luca' ,`StreetNumber` = '3526' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Cadillac Towers! Located in the South Houston area, you are in a prime location to access many of Houston\'s hottest hubs: Midtown, MedCen, UH, Downtown + easy freeway access. Just south of the historic Third Ward you will have access to many locally-owned restaurants and stores. There is a ton of development happening in the immediate area, which is a great sign for homeowners! IMPORTANT NOTES: private driveway, open concept floor plans, top-of-the-line finishes, modern/contemporary design, massive bedrooms all with ensuites, covered patio, large closets and MORE!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Deeb' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Cadillac Towers Lot 02 Block 01' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1547' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cadillac Towers' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216145' WHERE `Matrix_Unique_ID` = '203884754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:36:42.170' ,`MLSNumber` = '70103598' ,`ListAgentFullName` = 'Blake Jessee' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698426' ,`Longitude` = '-95.367279' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Luca' ,`StreetNumber` = '3528' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Cadillac Towers! Located in the South Houston area, you are in a prime location to access many of Houston\'s hottest hubs: Midtown, MedCen, UH, Downtown + easy freeway access. Just south of the historic Third Ward you will have access to many locally-owned restaurants and stores. There is a ton of development happening in the immediate area, which is a great sign for homeowners! IMPORTANT NOTES: private driveway, open concept floor plans, top-of-the-line finishes, modern/contemporary design, massive bedrooms all with ensuites, covered patio, large closets and MORE!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Deeb' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Cadillac Towers Lot 03 Block 01' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1649' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cadillac Towers' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216145' WHERE `Matrix_Unique_ID` = '203884798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:31:54.377' ,`MLSNumber` = '28105155' ,`ListAgentFullName` = 'Johnna Maertz' ,`ListOfficeName` = 'Blue Dolphin Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705518' ,`Longitude` = '-96.547115' ,`PhotoCount` = '23' ,`PostalCode` = '78934' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Fannin' ,`StreetNumber` = '1138' ,`StreetSuffix` = 'Street' ,`City` = 'Columbus' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING LOCATION !!! Located on the first block southwest of the Fannin Street and Walnut Street intersection (2 of the MAIN streets in Columbus)!!! Next door to a large name air/gas retailer and a name brand fuel station. Across Fannin Street is a strip center and car-wash. Across Spring Street is a Pharmacy. Lots of foot and vehicle traffic in this area. The home/building was a retail business for years. It has a recent roof, large rooms, ship-lap ceilings. There is believed to be ship-lap under the paneling and original oak flooring under the carpet. The closed in back porch is used for storage and as a utility room. Outside the back door the is a concrete driveway leading to the 20\' x 40\' metal shop. The shop has a roll up door, a walk-in door, concrete slab, and electricity in place. Come live here and possibly have your business here!!!' ,`Acres` = '0.1339' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 76 LT PT 4 COLUMBUS HOUSE & GARAGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbus' ,`TaxAmount` = '1606' ,`TaxRate` = '1.8359' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1933' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216145' WHERE `Matrix_Unique_ID` = '204095006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:36:29.350' ,`MLSNumber` = '58190704' ,`ListAgentFullName` = 'Monica Grosu' ,`ListOfficeName` = 'EVERAGENT' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.622913' ,`Longitude` = '-95.011328' ,`PhotoCount` = '13' ,`PostalCode` = '77571' ,`RoomCount` = '5' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '224' ,`StreetSuffix` = 'Avenue' ,`City` = 'Shoreacres' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this single-story home located in the quiet & beautiful Shoreacres community with access to the lighted fishing pier, & boat ramp with exclusive rights for residents. Minutes walk to The Bay! NO HOA. A golf cart ride away to the Houston Yacht Club featuring a magnificent pool and great boat slips. The inside home features neutral paint tones, an open floorplan design. The kitchen has granite countertops and opens up to the dining room. Large living room area. Carpet in all bedrooms, tile in dining, living room, kitchen @bathrooms, washer & dryer connections, 2 car garage, covered patio & porch, and a spacious partially fenced backyard. Tenant occupied.' ,`Acres` = '0.1791' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shoreacres/La Porte' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 3 SHOREACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shoreacres' ,`TaxAmount` = '4324' ,`TaxRate` = '2.8597' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216146' WHERE `Matrix_Unique_ID` = '204293607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:38:04.957' ,`MLSNumber` = '47957739' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157355' ,`Longitude` = '-95.400882' ,`PhotoCount` = '31' ,`PostalCode` = '77385' ,`RoomCount` = '7' ,`ListPrice` = '459990.00' ,`Status` = 'Active' ,`StreetName` = 'Acacia Grove' ,`StreetNumber` = '3457' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 3457 Acacia Grove Lane located in the community of The Meadows at Imperial Oaks and zoned to Conroe ISD. The Tyler floorplan features 4 bedrooms, 3 full baths, and an attached 2 car garage. The first floor includes a home office, kitchen open to the family room and breakast area, and the owner\'s retreat. Come upstairs where you will find 3 additional bedrooms and a loft space for a game room. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is November 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'The Meadows At Imperial Oaks Section 19, Block 1, Lot 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Meadows at Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216146' WHERE `Matrix_Unique_ID` = '208994685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:32:47.130' ,`MLSNumber` = '4437423' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.616301' ,`Longitude` = '-106.243159' ,`PhotoCount` = '7' ,`PostalCode` = '79927' ,`RoomCount` = '3' ,`ListPrice` = '172900.00' ,`Status` = 'Active' ,`StreetName` = 'Los Adobes' ,`StreetNumber` = '11943' ,`StreetSuffix` = 'Drive' ,`City` = 'Socorro' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity! Large home with 3 bedrooms and 1 bathroom. It\'s the perfect fixer upper! Atlmost 1 acre of land, this property is great for those that enjoy outdoor space to make their own! Easy access to I-10 off of Clint-San Elizaio and Highway 76. Give us a call today!' ,`Acres` = '0.9348' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = '2 RANCHO MIRAVAL ESTATES LOT 2 (LESS WATER RIGHTS) (40719.88' ,`LotDesciption` = 'Cleared' ,`LotSize` = '40720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '933 - Socorro' ,`SchoolElementary` = 'ROBERT R. ROJAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOCORRO HIGH SCHOOL' ,`SchoolMiddle` = 'PASO DEL NORTE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rancho Miraval Estates' ,`TaxAmount` = '6887' ,`TaxRate` = '4.5583' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675216146' WHERE `Matrix_Unique_ID` = '209016691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:37:21.857' ,`MLSNumber` = '63068381' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Heather Chavana' ,`SellingOfficeName` = 'RE/MAX Legends' ,`Latitude` = '30.201310' ,`Longitude` = '-95.338721' ,`PhotoCount` = '28' ,`PostalCode` = '77302' ,`RoomCount` = '18' ,`ListPrice` = '644853.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Blu Terrace' ,`StreetNumber` = '18014' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VII, Elevation F) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Family room, formal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Extended covered rear patio and attached 3-car garage. Artavia, a master-planned community, will thrill you with endless possibilities just minutes from your home in Conroe, Texas. You’ll enjoy wide, outdoor spaces great for an active lifestyle and its convenient location. Onsite school is currently under construction! Stop by the Westin Homes model home today to find out more about Artavia!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 35 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10660' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216146' WHERE `Matrix_Unique_ID` = '209687077' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:50:00.573' ,`MLSNumber` = '3459859' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Patricia Cruz' ,`SellingOfficeName` = 'Worth Clark Realty' ,`Latitude` = '29.958805' ,`Longitude` = '-95.197345' ,`PhotoCount` = '31' ,`PostalCode` = '77346' ,`RoomCount` = '15' ,`ListPrice` = '649836.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Drummond Maple' ,`StreetNumber` = '12218' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Rowan, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large walk-in closet and secondary bedroom on first floor. Two additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '0.1806' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7868' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '2387' ,`TaxRate` = '3.6373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216146' WHERE `Matrix_Unique_ID` = '209696522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:58:47.693' ,`MLSNumber` = '21231259' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.421113' ,`Longitude` = '-94.054596' ,`PhotoCount` = '7' ,`PostalCode` = '75501' ,`RoomCount` = '3' ,`ListPrice` = '34999.00' ,`Status` = 'Active' ,`StreetName` = '5th' ,`StreetNumber` = '1217' ,`StreetSuffix` = 'Street' ,`City` = 'Texarkana' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own this super cute fixer-upper today! The property needs some sprucing up but a great home for investors. It has a very spacious backyard for family gatherings and your furry friends. The property is near the Texarkana Country Club, Four States Auto Museum and many popular food spots! Call us today for more information! As is.' ,`Acres` = '0.17' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'T B MOORES A-398 PT LOT 9 2021-243 01/08/21 BLK/TRACT 3 0.17' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '970 - Texarkana' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (TEXARKANA)' ,`SchoolHigh` = 'TEXAS HIGH SCHOOL' ,`SchoolMiddle` = 'TEXAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tb Moores Surv Abs 398' ,`TaxAmount` = '53' ,`TaxRate` = '2.5041' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216147' WHERE `Matrix_Unique_ID` = '209726108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:29:36.820' ,`MLSNumber` = '68825338' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.901360' ,`Longitude` = '-95.735950' ,`PhotoCount` = '24' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '489940.00' ,`Status` = 'Active' ,`StreetName` = 'Alvararo Bay' ,`StreetNumber` = '8515' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'wo-story | 5 bedrooms | study & media options available| 3 baths | 3-car attached garage | covered patio\r\nFlexible plan with spacious common area, featuring 2-story family room with fireplace option, kitchen, and casual dining area. Large main suite with ample storage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7620' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216147' WHERE `Matrix_Unique_ID` = '209726560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:28:27.743' ,`MLSNumber` = '64367949' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.902080' ,`Longitude` = '-95.734193' ,`PhotoCount` = '7' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '460190.00' ,`Status` = 'Active' ,`StreetName` = 'Melshell' ,`StreetNumber` = '21122' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Single-story, Modern exterior home. This home offers 4 bedrooms, one bedroom with its own private bathroom, 3.5 baths, large Study, 3-car attached garage (Tandem) and Covered patio. This lot is large enough to add a pool in the future as well!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 16 Block: 1 Section: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216147' WHERE `Matrix_Unique_ID` = '210263576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:04:34.250' ,`MLSNumber` = '61352051' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659510' ,`Longitude` = '-95.048872' ,`PhotoCount` = '18' ,`PostalCode` = '77571' ,`RoomCount` = '12' ,`ListPrice` = '394067.00' ,`Status` = 'Active' ,`StreetName` = 'Daw Boardwalk' ,`StreetNumber` = '3042' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Feel at ease in this fantastic Beazer Home in Morgan’s Landing, boasting luxury vinyl plank flooring, a study with French doors, a vaulted ceiling in the open great room, and a covered patio. Imagine up new recipes in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Complete with a walk-in closet, dual vanities, a tub, and a separate shower, the primary suite is ideal for unwinding. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Zoned to the La Porte ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216147' WHERE `Matrix_Unique_ID` = '210521100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:13:09.723' ,`MLSNumber` = '86895028' ,`ListAgentFullName` = 'Lynette Thomas' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060053' ,`Longitude` = '-95.235282' ,`PhotoCount` = '27' ,`PostalCode` = '77339' ,`RoomCount` = '10' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Park Hollow' ,`StreetNumber` = '26869' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Inviting traditional brick home with upstairs balcony beckons to its new owner. Instantly appealing, two story home with fantastic open layout. You will never miss out on the action from the spacious kitchen overlooking the dining and living rooms! The private primary suite is located downstairs and the additional three bedrooms and bonus room are upstairs. Spend time outdoors in the charming courtyard between the detached garage and the house. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.0802' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S775600 - PARK AT KINGS MANOR 01, BLOCK 2, LOT 15' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park At Kings Manor 01' ,`TaxAmount` = '5219' ,`TaxRate` = '2.7631' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216148' WHERE `Matrix_Unique_ID` = '210810363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:47:48.337' ,`MLSNumber` = '37891654' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960478' ,`Longitude` = '-95.202928' ,`PhotoCount` = '25' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '589527.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11907' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation DP) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Primary suite downstairs with large walk-in closet. Family room and formal dining and living room/study. Spacious island kitchen. Game room and media room upstairs. Covered back patio and attached 2-car garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8218' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216148' WHERE `Matrix_Unique_ID` = '210861160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:51:51.077' ,`MLSNumber` = '42691970' ,`ListAgentFullName` = 'Sarah Underwood' ,`ListOfficeName` = 'Oro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.346355' ,`Longitude` = '-96.653399' ,`PhotoCount` = '45' ,`PostalCode` = '77879' ,`RoomCount` = '2' ,`ListPrice` = '505000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '700' ,`StreetSuffix` = 'Avenue' ,`City` = 'Somerville' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a beautiful Texas cabin located in close proximity to lake Somerville? This is the one! This secluded 2.26 acre property features a custom built 2 bed 1.5 bath home, a 1 bed 1 bath full functioning guest apartment, a 3,200 sq ft shop with an additional 1000 sq ft of carport space. The house is plumbed with pex piping, fully insulated with spray foam insulation, all upgraded industrial electrical throughout, and equipped with a tankless on demand water heater. The property is set up with 400 amp service- 200 amp to the house and 200 amp to the shop. No detail was left out with this property! Come enjoy watching the wildlife from the beautiful front or back porch. NO HOA! Somerville is located approximately 30 minutes to a&m and 25 minutes to Brenham.' ,`Acres` = '2.2679' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S2513 H&G (POST OAK HILL) LOT 29,30,31 2.2679 ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '98790' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H & G Post Oak Hill' ,`TaxAmount` = '3052' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675216148' WHERE `Matrix_Unique_ID` = '210958045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:31:13.597' ,`MLSNumber` = '58118100' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098489' ,`Longitude` = '-95.565481' ,`PhotoCount` = '29' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '313000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacy Creek' ,`StreetNumber` = '9847' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely single-story home on a cul-de-sac lot featuring 4 bedrooms, 2 bathrooms, a 2-car attached garage, a shaded front porch, and an open concept floorplan! Inside, you\'ll find a tile entry, a carpeted living room with a vaulted ceiling, a dining area, utility room, and the island kitchen that boasts granite countertops, recessed lighting, and stainless steel appliances, including a fridge! The master bedroom suite has dual sinks and a walk-in closet while the spacious backyard offers a covered patio with a ceiling fan! This home is located with no back neighbor and proximity to TX-99/Grand Pkwy, Hwy 249, and lots of shopping and dining options in Tomball and Spring!' ,`Acres` = '0.2298' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 70 BLK 1 VINTAGE CREEK' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10009' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vintage Creek' ,`TaxAmount` = '6336' ,`TaxRate` = '2.8765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216148' WHERE `Matrix_Unique_ID` = '211258226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:29:37.860' ,`MLSNumber` = '38785349' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293532' ,`Longitude` = '-95.400530' ,`PhotoCount` = '23' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '287014.00' ,`Status` = 'Active' ,`StreetName` = 'Cub' ,`StreetNumber` = '3673' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe. The Drake plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, game room, and 2-car garage. This home has it all, including vinyl plank flooring! The first floor offers the perfect space for entertaining with a bar top kitchen open to the family room! The gourmet kitchen is sure to please with 42 inch cabinets and granite countertops! Retreat to the first-floor Owner’s Suite featuring a beautiful bay window, extended shower, and a spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with a sprinkler system and covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Blk. 1 Mackenzie Creek Sec. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216149' WHERE `Matrix_Unique_ID` = '211305632' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:58:59.130' ,`MLSNumber` = '30753531' ,`ListAgentFullName` = 'Michael Magana' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775380' ,`Longitude` = '-95.414794' ,`PhotoCount` = '15' ,`PostalCode` = '77007' ,`RoomCount` = '1' ,`ListPrice` = '394950.00' ,`Status` = 'Active' ,`StreetName` = 'Inker' ,`StreetNumber` = '5223' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '1' ,`SqFtTotal` = '784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the last remaining 50X100 lots left in the area in the Rice Military/Washington Corridor. Get location with easy access to I-10, Memorial Park and the Heights. Property can be developed as townhomes or as single family. There is a small 1933 home on the property that has seen better days, but was recently rented out at $900. The value is in the lot, although some people might want to build a single family home. Great opportunity for anyone interested in inner loop living!' ,`Acres` = '0.1228' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 122 & 123 COTTAGE GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cottage Grove Sec 01' ,`TaxAmount` = '6938' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1933' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216149' WHERE `Matrix_Unique_ID` = '211679582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:48:58.920' ,`MLSNumber` = '25444034' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.878762' ,`Longitude` = '-94.884967' ,`PhotoCount` = '34' ,`PostalCode` = '77535' ,`RoomCount` = '12' ,`ListPrice` = '450415.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Spring Mist' ,`StreetNumber` = '13523' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! Stunning one-story Walden home features 4 bedrooms, 3 baths and 3 car garage. Open dining room located off foyer. Beautiful maple cabinets, under cabinet lighting, quartz countertops and farmhouse sink in gourmet kitchen. Cozy tile fireplace with maple mantel in great room. Huge owner\'s walk-in closet, separate tub and shower in owner\'s bath. Double sinks in owner\'s bath and hall bath 2. Convenient valet in HovHall with easy access to garage. Extended covered patio in backyard, perfect for entertaining. \r\nSt. Augustine Meadows is conveniently located in Mont Belvieu with easy access to I-10 and Galveston Island. Students are zoned to Barbers Hill ISD. Offered by: K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '13/3/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'St. Augustine Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.14874' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216149' WHERE `Matrix_Unique_ID` = '211721018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:21:41.717' ,`MLSNumber` = '17086463' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042191' ,`Longitude` = '-94.880670' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Young' ,`StreetNumber` = '507' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful 1 Story, The Perth Floor Plan with 3 Bedrooms, 2 Baths, with a 2 Car Garage. Open concept living with the spacious Family Room open to the Kitchen and Breakfast Room. You will love the Kitchen with lots of cabinets, breakfast bar and black appliances, and even a USB outlet. Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Located in the quaint city of Dayton, TX just east of Kingwood in Liberty County. Minutes from historic Downtown Dayton and convenient access to US-90 and FM-1960 providing nearby dining and shopping opportunities. Dayton ISD.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Brookstone' ,`TaxAmount` = '' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216149' WHERE `Matrix_Unique_ID` = '211731869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:46:53.253' ,`MLSNumber` = '40840350' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960131' ,`Longitude` = '-95.202586' ,`PhotoCount` = '29' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '619587.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11906' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Hopkins III, Elevation F) Two Story. 4 bedrooms, 3.5 baths. Elegant double front door entry. Primary suite with spacious walk-in closet. Spacious island kitchen with breakfast area is open to the family room. Formal dining room. First floor study. Second floor game room, media room and additional 3 bedrooms. Extended covered rear patio and attached 2 car garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 29 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8386' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216149' WHERE `Matrix_Unique_ID` = '211741826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:46:33.973' ,`MLSNumber` = '40574575' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960131' ,`Longitude` = '-95.202995' ,`PhotoCount` = '29' ,`PostalCode` = '77346' ,`RoomCount` = '18' ,`ListPrice` = '659853.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11902' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter IX, Elevation M) CURRENTLY BEING BUILT. Two story. 5 bedrooms, 4.5 baths. Primary suite downstairs with large walk-in closet. Secondary bedroom on first floor with private bath as well. Formal dining room and study. Spacious island kitchen with breakfast area open to family room. Upstairs game room with media room plus three secondary bedrooms. Covered patio and 2 car attached garage. Featuring new homes near Lake Houston and nearly 1,000 acres of wooded bliss, The Groves is a one-of-a-kind master-planned community. It is conveniently located in the acclaimed Humble ISD with easy access to Beltway 8 and Hwy 59. The Hearth Amenity Center is the center of this community and features a resort-style pool, an oversized hearth fireplace with cozy bistro seating and soft festoon lighting. Stop by the Westin Homes model home today to find out more about The Groves!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 30 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8147' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1056' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216150' WHERE `Matrix_Unique_ID` = '211743241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:15:21.087' ,`MLSNumber` = '71538180' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Veronica Rios' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.816346' ,`Longitude` = '-95.784454' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '456770.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Batesville' ,`StreetNumber` = '23619' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2394' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Live in total comfort in this lovely Lakewood Home in Morton Creek Ranch. Nestled on a spacious cul-de-sac lot, this 4-sided brick home boasts a premium elevation, no back neighbors, ceramic tile flooring, full gutters, sprinkler system, faux wood blinds, cast stone fireplace, a study with French doors, and a covered patio. Impress guests in the island kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Community amenities include a playground, splash pad, children’s play area, and a recreation center with a pavilion. Commuters enjoy close proximity to I-10 and the Grand Parkway. Delve into premier shopping, dining, and entertainment at the Katy Mills Mall and LaCenterra at Cinco Ranch. Zoned to the nationally recognized Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lakewood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '598' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.39' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216150' WHERE `Matrix_Unique_ID` = '212200773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:04:21.147' ,`MLSNumber` = '88218835' ,`ListAgentFullName` = 'Lance Bertolino' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403744' ,`Longitude` = '-95.796160' ,`PhotoCount` = '28' ,`PostalCode` = '77461' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Alex' ,`StreetNumber` = '10515' ,`StreetSuffix` = 'Drive' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 10515 Alex Drive! This fabulous 4 Bedroom, one-story home sits on over 1/2 acre of land and NO rear neighbors! Great LOW TAX RATE 1.8957%. The HOA here ALLOWS you to build a nice shop! Zoned to A-Rated Needville ISD. You\'ll love relaxing on the extended back patio and enjoying the country feeling while being close to amenities like Brazos Town Center. You\'ll find upgrades everywhere you look with a new roof (2021), new laminate flooring, arch doorways, vaulted family room ceiling, crown molding, and trey ceilings in each bedroom. The luxurious Primary bedroom suite features a spa-like bathroom with double sinks, walk-in bathtub and a separate shower. Washer and dryer stay with home! The Rosemeadow community is located just minutes from Hwy 36, Rosenberg, Brazos Bend State Park and George Observatory. You\'ll also be just an hour\'s drive from Surfside Beach!' ,`Acres` = '0.5806' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROSEMEADOW SEC 3, BLOCK 6, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25290' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosemeadow Sec 3' ,`TaxAmount` = '3653' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Other Water/Sewer,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216150' WHERE `Matrix_Unique_ID` = '212666700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T10:51:27.027' ,`MLSNumber` = '53867535' ,`ListAgentFullName` = 'Jeff Bulman' ,`ListOfficeName` = 'Jeff Bulman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558729' ,`Longitude` = '-95.038980' ,`PhotoCount` = '32' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '699999.00' ,`Status` = 'Active' ,`StreetName` = 'Seargent' ,`StreetNumber` = '2926' ,`StreetSuffix` = 'Street' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2633' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Seabrook with views of Clear Lake. Open floor plan with high ceilings, four bedrooms with an office and two & half baths. Spacious kitchen with large island opening to the living area. Multiple decks and outdoor spaces with water views. Primary bathroom will have double vanity sink, tub with separate shower. The second floor will have a loft with three bedrooms and two balconies. 10 ft ceilings on both floors, 8 ft doors throughout and 6 ft Hurricane Impact windows. Quartz countertops in the kitchen and bathrooms. 42” Shaker kitchen cabinets, under-mount sink with backsplash. Minutes from the Johnson Space Center, Kemah Boardwalk and walking distance to restaurants and entertainment. Estimated to be complete in Dec 2022.' ,`Acres` = '0.18' ,`Area` = '7' ,`BuilderName` = 'Innovative Const.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 SEARGENT LAKE HOMES' ,`LotDesciption` = 'Water View' ,`LotSize` = '8181' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'SEARGENT LAKE HOMES' ,`TaxAmount` = '' ,`TaxRate` = '2.29' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216150' WHERE `Matrix_Unique_ID` = '212717108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T09:31:41.690' ,`MLSNumber` = '5199039' ,`ListAgentFullName` = 'Christopher Johns' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734947' ,`Longitude` = '-95.828984' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '615000.00' ,`Status` = 'Active' ,`StreetName` = 'Bentgreen Chase' ,`StreetNumber` = '26602' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4323' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful David Weekley 5-bedroom, 4 ½ bath home in the most serene section of Silver Ranch. Home features TWO MASTER SUITES, and TWO LAUNDRY ROOMS. Upon entering, you’re met with French doors to the study and formal dining room. Laundry facilities are on both floors! Upgraded gourmet kitchen with huge, double door built-in refrigerator, breakfast area and workstation opens up to family room with gas fireplace. Ensuite primary bedroom with super-sized shower and a secondary ensuite bedroom upstairs. Upgraded hardwood flooring. Media room fully wired for a projector and 7-speaker surround sound. Adjoining game room has a wet bar for movie snack prep! Extended 3-car garage with shelving. Dual tankless water heaters. Extended deck with HOT TUB. Whole house water filtration system. Lots of storage. Set on a dead-end street and zoned to TOP KATY ISD SCHOOLS.' ,`Acres` = '0.1853' ,`Area` = '36' ,`BuilderName` = 'David Weekly Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandator