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-08-24T13:12:22.080' ,`MLSNumber` = '19893480' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.806199' ,`Longitude` = '-95.098792' ,`PhotoCount` = '16' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '135999.00' ,`Status` = 'Active' ,`StreetName` = 'Creek' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and check out this 3 bedrooms, 2 bathroom home. The primary bedroom has great views of the surrounding nature and the backyard has a large patio area for entertaining family and friends. The views are amazing from the front or backyard. You will enjoy being close to restaurants, stores, schools and hospitals. You DON\'T want to miss out on this sweet home!! AS IS with new roof.' ,`Acres` = '0.2608' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TWIN HARBORS SECTION 3 BLK 1 LOT 120' ,`LotDesciption` = 'Wooded' ,`LotSize` = '11360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Harbors Sec 3' ,`TaxAmount` = '1319' ,`TaxRate` = '2.1464' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702480' WHERE `Matrix_Unique_ID` = '197629249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:09:37.287' ,`MLSNumber` = '48373660' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706619' ,`Longitude` = '-95.332848' ,`PhotoCount` = '16' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '269999.00' ,`Status` = 'Active' ,`StreetName` = 'Nassau' ,`StreetNumber` = '5018' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Delightful home that consists of 3 bedrooms and 2 bathrooms in South East Houston! The property is fully furnished, and great for someone looking for an immediate move in. This home also has a nice backyard where your kids and furry friends can play in. Upon living here you will fall in love with the quiet neighborhood, and the closeness to the University of Houston, as well as restaurants, shops and parks within the area. Best of all, the property is approximately 15 minutes away from Downtown Houston, the Museum District and the Texas Medical Center. Add this home to your wish list! A must see home! Call us today to schedule a viewing!' ,`Acres` = '0.1578' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 2 MACGREGOR PLACE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Place Sec 01' ,`TaxAmount` = '3278' ,`TaxRate` = '2.5144' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702480' WHERE `Matrix_Unique_ID` = '201389854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:40:33.053' ,`MLSNumber` = '17855475' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768721' ,`Longitude` = '-95.325654' ,`PhotoCount` = '21' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '338999.00' ,`Status` = 'Active' ,`StreetName` = 'Gunter' ,`StreetNumber` = '4427' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brick home with 3 bedrooms, 2 bathrooms, and an attached 2-car garage. Great-sized kitchen with spacious countertops. Home features new interior paint, new carpet, and new doors in select rooms. Easy access to I-10 and a short drive away from Ea-Do Houston! Contact us today for more information!' ,`Acres` = '0.2204' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 6 & 7 BLK 3 PHILLIPS' ,`LotDesciption` = 'Other' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON N ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Phillips' ,`TaxAmount` = '4851' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702480' WHERE `Matrix_Unique_ID` = '203053851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:18:50.417' ,`MLSNumber` = '95109807' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664882' ,`Longitude` = '-95.007791' ,`PhotoCount` = '16' ,`PostalCode` = '77571' ,`RoomCount` = '3' ,`ListPrice` = '315999.00' ,`Status` = 'Active' ,`StreetName` = 'Holmes' ,`StreetNumber` = '501' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.287' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 1 2 3 & 4 BLK 36 BAY FRONT TO LA PORTE' ,`LotDesciption` = 'Other' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Front Laporte' ,`TaxAmount` = '5862' ,`TaxRate` = '2.7533' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702480' WHERE `Matrix_Unique_ID` = '203408133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:28:41.690' ,`MLSNumber` = '66533631' ,`ListAgentFullName` = 'Mark Sonnier' ,`ListOfficeName` = 'George E. Johnson Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779735' ,`Longitude` = '-95.343770' ,`PhotoCount` = '23' ,`PostalCode` = '77026' ,`RoomCount` = '5' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Stevens' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ceramic tile floors in all areas except bedrooms. Bedrooms are carpeted. Granite countertops in kitchen and both bathrooms. Large Lot with backyard for kids to play or for evening entertaining. Home is centrally located - near Downtown amenities, Medical Center, Mid-town, UofH and TSU. Public transportation nearby. MEASUREMENTS ARE ESTIMATES-RE-MEASURE IF IMPORTANT.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 14 PARKER SMITH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'PARKER SMITH' ,`TaxAmount` = '5310' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702480' WHERE `Matrix_Unique_ID` = '205099072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:49:28.197' ,`MLSNumber` = '34740918' ,`ListAgentFullName` = 'Maria Guzman' ,`ListOfficeName` = 'RE/MAX Pearland' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.487110' ,`Longitude` = '-95.426851' ,`PhotoCount` = '14' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 190' ,`StreetNumber` = '3106' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living! Gorgeous custom 4 bedroom, 3 bath home located in the Colony Trails neighborhood! Beautiful kitchen with eat-in island, granite countertops, and beautiful backsplash. Open floor plan from kitchen to living room and formal dining! Spacious living room with lots of natural light! Beautiful porcelain wood-like tile in main areas! Roomy master bedroom with separate shower and standing tub. Bonus game room perfect for hanging out with friends! Spacious backyard with covered patio, perfect for outdoor fun! Call and make your appointment today!' ,`Acres` = '0.68' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COLONY TRAILS SEC 1 (A0545 HT&BRR) LOT 19 ACRES .68' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '29621' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Trails Sec 1' ,`TaxAmount` = '5856' ,`TaxRate` = '2.1194' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702480' WHERE `Matrix_Unique_ID` = '207520232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:53:01.177' ,`MLSNumber` = '23017981' ,`ListAgentFullName` = 'Paulina Espinoza' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.508918' ,`Longitude` = '-96.781545' ,`PhotoCount` = '14' ,`PostalCode` = '77836' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '1400' ,`StreetSuffix` = 'Drive' ,`City` = 'Caldwell' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 for 1 Combo! This property features a main house including a fourth bedroom, half bath up stairs with separate entrance.There\'s a guest house next-door with 1 bed 1 bath and big living space with outdoor covered patio. Located close to Cade Lake. Main house has a septic tank, guest house not connected to septic. The two vacant lots next to the house not included in sale.Both houses need work but with lots of potential. Being sold as is.' ,`Acres` = '0.7175' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'S1820 CADE LAKE SEC. 2 LOT 306-308 .42ac' ,`LotDesciption` = 'Cleared' ,`LotSize` = '31250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '209 - Caldwell' ,`SchoolElementary` = 'CALDWELL ELEMENTARY SCHOOL (CALDWELL)' ,`SchoolHigh` = 'CALDWELL HIGH SCHOOL' ,`SchoolMiddle` = 'CALDWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cade Lake' ,`TaxAmount` = '1031' ,`TaxRate` = '1.8143' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702480' WHERE `Matrix_Unique_ID` = '207677168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:58:58.703' ,`MLSNumber` = '12693734' ,`ListAgentFullName` = 'Michael Flint' ,`ListOfficeName` = 'FIG Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.451054' ,`Longitude` = '-95.328579' ,`PhotoCount` = '31' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Crestview' ,`StreetNumber` = '8812' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous property in Manvel waiting for a Buyer to add their personal touch! This one-story home sits on a sprawling 1.4 acres. As you drive up to the home you are welcomed by a gazebo and flagpole that sit at the entrance. A beautiful, wooden porch stretches along the back of the home with unobstructed views of the backyard and the home is positioned so that you can enjoy a never ending breeze. All bedrooms are oversized providing endless opportunity for the next owner. There\'s also a bright sun room to enjoy your morning coffee! Utilities are available with electrical and plumbing connections with a propane tank and water well onsite. All of the doors and windows are equipped with storm shutters. The large garage is spacious enough for multiple vehicles. There is a bonus workshop on the property that is already equipped with electrical. This slice of paradise just out side the big city is ready for a new owner to make it their own!' ,`Acres` = '1.42' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CRESTMONT SEC 1 (A0231 H T & B R R) LOT 12 ACRES 1.42' ,`LotDesciption` = 'Other' ,`LotSize` = '61855' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Other Style,Ranch,Traditional' ,`Subdivision` = 'Crestmont Sec 1' ,`TaxAmount` = '5987' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702481' WHERE `Matrix_Unique_ID` = '207977081' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:06:57.207' ,`MLSNumber` = '85079019' ,`ListAgentFullName` = 'Calvin Kim' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788484' ,`Longitude` = '-95.580946' ,`PhotoCount` = '40' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakwood Pass' ,`StreetNumber` = '1113' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 Story David Weekley home, The Greensburg Floor Plan, first floor living, boasts with tons in upgrades. Interior features include gorgeous hardwood floors, crown molding, ceiling fans, 2” faux wood blinds, and walls of picture frame like windows brining in plenty of natural lights. Exterior features include sprinkler system, stone elevation, gutters, and covered patio. Desirable Open floor concept connects kitchen, living, and dining. The exquisite kitchen has granite counter tops, huge island, stainless steel appliances, refreshing subway tile back splash, under mount vanity sink, pantry, and excessive lighting. Extravagant master suite features vanity mirror, walk-in shower with separate oversized soak in tub, dual sinks, tile flooring, and spacious walk-in closet. The property allows easy access to the freeway, is zoned to desirable Spring Branch school district, yard maintenance and water/trash included. Close to shopping, restaurants, and hospital. Must See! No Flood.' ,`Acres` = '0.0441' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 ENCLAVE AT SHERWOOD FOREST' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1922' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave/Sherwood Forest' ,`TaxAmount` = '8210' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702481' WHERE `Matrix_Unique_ID` = '208808674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:56:50.267' ,`MLSNumber` = '87595817' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.972735' ,`Longitude` = '-95.415788' ,`PhotoCount` = '28' ,`PostalCode` = '77073' ,`RoomCount` = '9' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Remington Ridge' ,`StreetNumber` = '346' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0997' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 REMINGTON RANCH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4341' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILTON COOPER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch Sec 2' ,`TaxAmount` = '6327' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702481' WHERE `Matrix_Unique_ID` = '208901286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:34:17.600' ,`MLSNumber` = '24621764' ,`ListAgentFullName` = 'Mia Anderson' ,`ListOfficeName` = 'Mia F. Anderson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.037711' ,`Longitude` = '-95.704163' ,`PhotoCount` = '6' ,`PostalCode` = '77480' ,`RoomCount` = '2' ,`ListPrice` = '36900.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar St' ,`StreetNumber` = '408' ,`StreetSuffix` = '' ,`City` = 'Sweeny' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATED ACROSS FROM A WALKING TRAIL AND GREEN SPACE. THIS .11 ACRE LOT WITH 568 SQ FT HOUSE IS PRICED FOR THE LOT. HOUSE IS NOT HABITABLE. BEAUTIFUL MATURE TREE ON PROPERTY. GOOD LOCATION TO BUILD. PARK RIGHT DOWN THE STREET. CLOSE TO SCHOOLS.\r\n\r\nNO ASSESS TO INTERIOR OF HOUSE SELLER FELLS IT IS NOT SAFE. MAKE YOUR DECISION WISELY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SWEENY BLK 14 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sweeny' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702481' WHERE `Matrix_Unique_ID` = '208941739' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:47:26.097' ,`MLSNumber` = '69123028' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877893' ,`Longitude` = '-95.783976' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '18' ,`ListPrice` = '679432.00' ,`Status` = 'Active' ,`StreetName` = 'Woolgrass Crescent' ,`StreetNumber` = '7511' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation KP) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model home to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`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` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702481' WHERE `Matrix_Unique_ID` = '208986019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:55:39.903' ,`MLSNumber` = '74051361' ,`ListAgentFullName` = 'David Jackson' ,`ListOfficeName` = 'Loft Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145798' ,`Longitude` = '-95.391544' ,`PhotoCount` = '39' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Mineral Run' ,`StreetNumber` = '3430' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming David Weekley is sought after Falls of Imperial Oaks with inviting front porch elevation No rear neighbors and expansive back covered patio! Large flexible 2 story floorplan featuring Primary and 2 secondary bedrooms, study, dining, and flex space downstairs. Game room, media room, and additional bedroom with full bath upstairs. Kitchen features granite counter tops, gourmet island with bar seating, tons of cabinetry, cook top and open to living room with walls of windows. Minutes to The Woodlands, Grand Parkway, Exxon, CISD schools including the new Grand Oaks HS.' ,`Acres` = '0.1736' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S612118 - IMPERIAL OAKS PARK 18, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7564' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Park 18' ,`TaxAmount` = '10976' ,`TaxRate` = '3.0687' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702481' WHERE `Matrix_Unique_ID` = '209518572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:12:59.817' ,`MLSNumber` = '48223445' ,`ListAgentFullName` = 'Sheila Craniotis' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = 'Deana Fojt' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.014467' ,`Longitude` = '-95.163678' ,`PhotoCount` = '45' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '420000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wild Rye' ,`StreetNumber` = '19806' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous move-in-ready single-story home in the Kings River Village. Upon arrival find a beautifully landscaped lawn w/mature trees, NEW ROOF & HVAC. Inside offers an open floor plan featuring high ceilings, tile & wood flooring, crown molding, & an abundance of natural light throughout. A grand formal foyer with custom mural welcomes you home. Private guest suite and formal dining flank the entry. The large den w/tons of natural light anchored by beautiful built-ins & fireplace opens to the gourmet kitchen boasting granite counters, tons of cabinets, gas cooktop, double ovens and breakfast nook. A private and secluded home office or flex space convenientlytucked away off the breakfast nook. The huge primary includes en-suite bath featuring dual sink vanity & sizable walk-in closet. Additional 2 secondary bedrooms that share a full bath complete this home. Lastly check out the fully fenced backyard w/ a cozy covered patio perfect for entertaining.' ,`Acres` = '0.2124' ,`Area` = '1' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 7 KINGS RIVER VILLAGE SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Village' ,`TaxAmount` = '8412' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702481' WHERE `Matrix_Unique_ID` = '209679033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:40:55.673' ,`MLSNumber` = '21570557' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767337' ,`Longitude` = '-94.998055' ,`PhotoCount` = '30' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Dusky Goose' ,`StreetNumber` = '4015' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Goose Creek Reserve, this wonderful home features 3 bedrooms & 2 full baths with a brick & stone elevation! Open concept floor plan, neutral paint colors, wood look vinyl plank floors throughout common areas! The kitchen boasts beautiful granite countertops with plenty of counterspace, stainless steel appliances & a large island! Living room is open to kitchen & breakfast area. The primary suite has a vanity with two dual sinks, an oversized shower & walk-in closet. Spacious backyard with a covered patio! This beautiful community offers a community pool, a playground, & walking trails along the lakes. Zoned to Goose Creed ISD! Conveniently located near shopping and restaurants This home is a must see!' ,`Acres` = '0.1391' ,`Area` = '2' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 5 GOOSE CREEK RESERVE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6061' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Creek Reserve' ,`TaxAmount` = '7627' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702482' WHERE `Matrix_Unique_ID` = '209980208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:16:18.570' ,`MLSNumber` = '92469241' ,`ListAgentFullName` = 'Cassandra McHenry' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768610' ,`Longitude` = '-94.991829' ,`PhotoCount` = '50' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Andrews' ,`StreetNumber` = '4613' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy this beautiful 4 bedroom home with plenty of space for everyone! \r\nHome features a formal dining room, spacious kitchen and a large pool perfect for this summer heat!' ,`Acres` = '0.2029' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 49 COUNTRY CLUB OAKS SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Oaks Sec 06' ,`TaxAmount` = '7185' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702482' WHERE `Matrix_Unique_ID` = '210228727' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:58:23.667' ,`MLSNumber` = '28281600' ,`ListAgentFullName` = 'Linda Ferguson' ,`ListOfficeName` = 'The Ferguson Fisher Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.107386' ,`Longitude` = '-95.776479' ,`PhotoCount` = '29' ,`PostalCode` = '77447' ,`RoomCount` = '9' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Roberts Cemetery' ,`StreetNumber` = '23230' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy country home on 1.75 acres. Close to 99/249/290, central to everything with a country feel. This cedar home has oversized bedrooms and fabulous primary suite. Built with designer touches everywhere and designer paint, the kitchen has polished concrete countertops that complement the polished concrete flooring. The walk in pantry and laundry room are unbelievable. There is no garage or carport, but plenty of room build one. There is a storage building that stays on the property. There is a small creek that runs across the back of the property, but the home is high and dry. This home is a hidden jewel; a quiet retreat close to the city.' ,`Acres` = '1.75' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Stove,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S341510 - CLEAR CREEK FOREST 10, LOT 15-A, ACRES 1.75' ,`LotDesciption` = 'Wooded' ,`LotSize` = '76230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '5389' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702482' WHERE `Matrix_Unique_ID` = '210366542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:07:00.403' ,`MLSNumber` = '46300011' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708579' ,`Longitude` = '-95.299085' ,`PhotoCount` = '11' ,`PostalCode` = '77087' ,`RoomCount` = '2' ,`ListPrice` = '209999.00' ,`Status` = 'Active' ,`StreetName` = 'Linden' ,`StreetNumber` = '6705' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 bedroom, 1 bathroom home is the perfect place for you and your family. It features hard wood flooring in select areas and a large backyard for your kids and pets to play in. It presently features foundation repairs and new roof. It will soon feature interior/exterior cosmetic repairs throughout the home! This property is centered around schools, shops, eateries and plenty of parks with quick access to I-45 South. Great location just fifteen minutes away from downtown Houston and the Houston Museum District! Contact us for more information!' ,`Acres` = '0.1452' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 73 PECAN PARK PLACE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SOUTHMAYD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Park Place Sec 01' ,`TaxAmount` = '2622' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1943' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702482' WHERE `Matrix_Unique_ID` = '210525654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:03:30.260' ,`MLSNumber` = '34885384' ,`ListAgentFullName` = 'Raghda Henthorne' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677695' ,`Longitude` = '-95.942161' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '22' ,`ListPrice` = '2700000.00' ,`Status` = 'Active' ,`StreetName` = 'Haddon' ,`StreetNumber` = '33203' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '8718' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant custom-built estate designed for entertaining w/ great open spaces in beautiful setting on fully fenced 2.8-acre lot. The property incorporates 2 separate structures- a stunning house & a one of a kind guesthouse accessed by a stone bridge w/ 20-car garage. The main house 2-story reception hall is flanked by an opulent dining room and an impressive, paneled library. The domed ceiling is a reproduction of the classically inspired dome beneath the U.S. Capitol. This home is ideal as a multigenerational home with primary bedroom and 2nd bedrooms down. Kitchen is open to the family & breakfast rooms with a wall of glass windows overlooking pool & terraces. Large private primary suite w/reading/exercise room, custom closet & dressing area w/vanity. A Huge game room down, additional 2nd level game room, media, plus 3 bedrooms. Premium out-door living with summer kitchen, terraces surround the pool, outdoor pavilion with fireplace, & mosquito system. Full house Generator. Per seller.' ,`Acres` = '2.8' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WESTON LAKES SEC 4, BLOCK 14, LOT 14, R/P' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Wooded' ,`LotSize` = '122957' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3612' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'WESTON LAKES' ,`TaxAmount` = '' ,`TaxRate` = '2.299' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702482' WHERE `Matrix_Unique_ID` = '210806240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:38:56.570' ,`MLSNumber` = '65648959' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526786' ,`Longitude` = '-95.415474' ,`PhotoCount` = '43' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '424990.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Butte' ,`StreetNumber` = '4806' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely one-story home was designed with you in mind! The bold kitchen is highlighted by stunning granite countertops, stainless steel appliances and a spacious island that overlooks the casual dining area and family room. The elegant primary suite is complete with a spa-like bathroom that includes a garden tub and separate walk-in shower. Come visit this spectacular home today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5999' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '' ,`TaxRate` = '3.719' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702482' WHERE `Matrix_Unique_ID` = '210900773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:15:58.943' ,`MLSNumber` = '45325477' ,`ListAgentFullName` = 'Lacy Troutman' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.929106' ,`Longitude` = '-94.613685' ,`PhotoCount` = '41' ,`PostalCode` = '75936' ,`RoomCount` = '10' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '291' ,`StreetSuffix` = 'Loop' ,`City` = 'Chester' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 2-story farmhouse on half an acre in the heart of Chester, TX. This corner property is completely fenced, with one electric gate entrance, one front gate entrance and an additional side gate. With a total of 2,076 Sq ft. this home offers four large bedrooms, the primary located on the 1st floor, an additional 16x13 game room/ office located on the 2nd floor, two full baths and an additional half bath, updated flooring on the 1st floor, updated kitchen including granite counter tops. Outside you will find a 20x24 patio area, great for relaxing or hosting the perfect backyard BBQ! Also including a storage building wired with electricity, and recently installed solar screens on all windows. Call me to tour this beautiful home !!' ,`Acres` = '0.5196' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S5350 SUNRISE ACRES (A3), LOT 14, ACRES .5196' ,`LotDesciption` = 'Corner' ,`LotSize` = '22632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '181 - Chester' ,`SchoolElementary` = 'CHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHESTER HIGH SCHOOL' ,`SchoolMiddle` = 'CHESTER HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sunrise Acres' ,`TaxAmount` = '3349' ,`TaxRate` = '2.0365' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702482' WHERE `Matrix_Unique_ID` = '211008385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:01:28.910' ,`MLSNumber` = '2989917' ,`ListAgentFullName` = 'Tina Reynolds' ,`ListOfficeName` = 'Allsource Properties' ,`SellingAgentFullName` = 'Kelcey Andrews' ,`SellingOfficeName` = 'Krueger Real Estate' ,`Latitude` = '29.852214' ,`Longitude` = '-95.678959' ,`PhotoCount` = '17' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '274999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'LAKE BEND DRIVE' ,`StreetNumber` = '18115' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE on Sun 8/7 from 2 to 4 PM. RARE FIND!! NEVER FLOODED Turn-key smart home has been completely renovated!!! NEW laminate wood flooring throughout with tile in the wet areas; no carpet. NEW LIGHTING, FLOORING, RANGE, MICROWAVE, CUSTOM BACKSPLASH, QUARTZ COUNTERS, FAUCETS, KITCHEN SINK, BATHROOM SINKS, TOILETS, HARDWARE, AND MORE!!! Let\'s Talk TECH: Front & Garage door are smart locks, Ring doorbell installed w/ Alexa device, Touchless kitchen faucet, and Motion sensor for all closet lights! The spa-like primary bath features a wet area with a custom tile shower and freestanding soaking tub. Stunning kitchen reno offers an apron-front sink, a beautiful gas range with a matching microwave, and unique tiling behind the range; keeping with today\'s trends. All colors throughout create a cohesive, designer look. Outside enjoys a freshly sodded front yard and freshly seeded backyard. Ride your bike to the community pool and tennis courts.' ,`Acres` = '0.2032' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 22 WINDSONG SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Windsong' ,`TaxAmount` = '4012' ,`TaxRate` = '2.5618' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702483' WHERE `Matrix_Unique_ID` = '211056385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:44:10.857' ,`MLSNumber` = '65209048' ,`ListAgentFullName` = 'Alex Lyon' ,`ListOfficeName` = 'Full Circle Texas, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.382993' ,`Longitude` = '-95.001562' ,`PhotoCount` = '46' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '274900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Amburn' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Road' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 3 bedroom, 2 bath ranch home resting on almost an acre lot under fabulous mature oak trees! Main house offers a charming covered front patio, spacious open concept living, dining and kitchen areas with breakfast bar. Kitchen offers granite countertops, stainless steel appliances, double oven, updated lighting and freshly painted cabinetry. Primary bedroom has a separate on-suite bath with 2 additional bedrooms and an office off the entry. *APARTMENT* (needs a little TLC) but with kitchen and full bath areas provides great income potential, guest house or multigenerational living quarters. 2 car garage with HUGE 500 SF. workshop + an RV or Boat storage building. Excellent location with easy access to I-45, HWY 3 & 146. Peaceful county living with the convenience of city life.' ,`Acres` = '0.8384' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 S F AUSTIN SUR LOTS 1 & 2 (2-0) AMBURN PARK SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '36520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Amburn Park Sec 2' ,`TaxAmount` = '3869' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702483' WHERE `Matrix_Unique_ID` = '211110698' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:58:27.080' ,`MLSNumber` = '56321883' ,`ListAgentFullName` = 'Robbie Jansky' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.301020' ,`Longitude` = '-100.426991' ,`PhotoCount` = '21' ,`PostalCode` = '78832' ,`RoomCount` = '3' ,`ListPrice` = '76000.00' ,`Status` = 'Active' ,`StreetName` = 'Bliss' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Circle' ,`City` = 'Brackettville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to small-town country living and a slower pace of life! Your chance to own some remarkable and unique lots in Bracketville! 2 mobile homes and multiple lots convey with the sale, steps from the FORT CLARK SPRINGS GOLF COURSE! MUSEUMS, Antique shopping, historical markers, & more nearby! So much heritage V proud history in this area, with walking trails, wildlife, swimming, golf, CAMPING, OUTDOORS, & MORE! Take the short trip west into DEL RIO for even more attractions & GORGEOUS Sparkling LAKE AMISTAD RESERVOIR! The Amistad Reservoir covers 67,000 acres & includes 540 miles of shoreline on the U.S. side of the border. A portion of the Reservoir extends into Coahuila, Mexico. While boating, fishing & other water-related activities — such as SCUBA diving, swimming, tubing & waterskiing — are especially popular, numerous outdoor activities are available. Opportunities exist for bicycling, birding, camping, hunting, hiking & picnicking. Wildlife observation is also popular!' ,`Acres` = '0.2236' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'UN 15 FCS, LOT 9,10,11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '363 - Brackett' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (BRACKETT)' ,`SchoolHigh` = 'BRACKETT HIGH SCHOOL' ,`SchoolMiddle` = 'BRACKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Un 15 Fcs' ,`TaxAmount` = '150' ,`TaxRate` = '1.6713' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702483' WHERE `Matrix_Unique_ID` = '211119900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:27:15.000' ,`MLSNumber` = '64619128' ,`ListAgentFullName` = 'Christine Luong' ,`ListOfficeName` = 'Realty USA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725869' ,`Longitude` = '-95.447323' ,`PhotoCount` = '40' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Childress' ,`StreetNumber` = '4274' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3-Story stucco townhome in a the West-U area boast fresh paints, new floorings in bedrooms with first floor living, open concept with high ceilings, crown moldings, tavertine floorings, new stainless steel cooktop/microwave/dishwasher, and breakfast bar. 2nd floor has 2 bedrooms each with it\'s own bathrooms, one has a balcony/terrace, huge game room and a sunroom. Primary bedroom is located on the third floor along with another bedroom with it\'s own bathroom as well. Primary bath has double sinks, separate shower and oversize tub. Covered patio with full size sink and counterspace for outdoor cooking. Spacious side yard to enjoy your BBQ with no back neighbors. Stainless steel fridge, washer and dryer included. Minutes to 59 freeway, Westpark Tollway, a wide variety of restaurants, national retailers, shopping centers, night life, parks etc... A must see to appreciate!' ,`Acres` = '0.0623' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 YASSIR COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Yassir Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702483' WHERE `Matrix_Unique_ID` = '211199953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:58:15.020' ,`MLSNumber` = '51179575' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Femi Adebola' ,`SellingOfficeName` = 'Discovered Homes Inv. Inc.' ,`Latitude` = '29.678445' ,`Longitude` = '-95.833074' ,`PhotoCount` = '4' ,`PostalCode` = '77406' ,`RoomCount` = '15' ,`ListPrice` = '569659.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Carina Cloud' ,`StreetNumber` = '10423' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Alden II, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, Living room/Study and Dining room. Spacious island kitchen open to Family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious Game room, and media room on second floor. Covered patio and 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`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` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 3, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6890' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702483' WHERE `Matrix_Unique_ID` = '211257563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:45:44.120' ,`MLSNumber` = '91113638' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877890' ,`Longitude` = '-95.783987' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '17' ,`ListPrice` = '704587.00' ,`Status` = 'Active' ,`StreetName` = 'Aster Thicket' ,`StreetNumber` = '7410' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal 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. Attached 3-car tandem garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model home to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`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` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5, BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8030' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702483' WHERE `Matrix_Unique_ID` = '211264178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:46:18.597' ,`MLSNumber` = '53146155' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877890' ,`Longitude` = '-95.783987' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '17' ,`ListPrice` = '674917.00' ,`Status` = 'Active' ,`StreetName` = 'Aster Thicket' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal 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. Attached 3-car tandem garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model home to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`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` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7841' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702483' WHERE `Matrix_Unique_ID` = '211357956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:56:27.087' ,`MLSNumber` = '31916454' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Vincent Oyubu' ,`SellingOfficeName` = 'Delta Realty Company' ,`Latitude` = '29.681021' ,`Longitude` = '-95.833030' ,`PhotoCount` = '26' ,`PostalCode` = '77406' ,`RoomCount` = '18' ,`ListPrice` = '699452.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Aurora Valley' ,`StreetNumber` = '26206' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3773' ,`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. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmers Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Stop by the Westin Homes model home today to find out more about Candela!' ,`Acres` = '' ,`Area` = '37' ,`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` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9279' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702484' WHERE `Matrix_Unique_ID` = '211583061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:58:21.430' ,`MLSNumber` = '19442374' ,`ListAgentFullName` = 'Kelli Untermeyer' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.429471' ,`Longitude` = '-94.685516' ,`PhotoCount` = '45' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Melody' ,`StreetNumber` = '966' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1443' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just a 5 minute walk to the widest area of the beach. This 3 bedroom, 2 bath home with a split floor plan and over 1400 square feet of living space would make a nice vacation rental or full time home for your family. Nice concrete patio area, sand shower, cargo lift and covered stairs up to the large open/covered deck. Only minutes away from shopping, dining, the school and of course the sand and surf of the Gulf. Put this one on your list to see!' ,`Acres` = '0.1427' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 203 A VAN NORDSTRAND SUR LOT 15 CRENNELAND SEC B' ,`LotDesciption` = 'Water View' ,`LotSize` = '6216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Crenneland B' ,`TaxAmount` = '4949' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702484' WHERE `Matrix_Unique_ID` = '211670169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:47:25.783' ,`MLSNumber` = '13448776' ,`ListAgentFullName` = 'Jay Raman' ,`ListOfficeName` = 'Ashoka Lion' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.983052' ,`Longitude` = '-95.167939' ,`PhotoCount` = '27' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Wisteria Chase' ,`StreetNumber` = '7230' ,`StreetSuffix` = 'Place' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 4/2.5/2 two story home. Large master downstairs with 3 bedrooms up with spacious game room and study area. Formal dining room. Large kitchen which opens up to the breakfast area. Fireplace. Close to shopping and schools.' ,`Acres` = '0.1101' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 ATASCA WOODS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4798' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods Sec 05' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702484' WHERE `Matrix_Unique_ID` = '211726491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:46:45.353' ,`MLSNumber` = '67790551' ,`ListAgentFullName` = 'Thomas Saunders' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.275017' ,`Longitude` = '-95.349181' ,`PhotoCount` = '50' ,`PostalCode` = '75703' ,`RoomCount` = '6' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 192' ,`StreetNumber` = '14232' ,`StreetSuffix` = '' ,`City` = 'Tyler' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large property over an acre and half, Multiple Buildings, Circle driveway to the Main house that features 4 bedrooms and 3 full bathrooms. Long concrete driveway leads to a large covered parking space behind the house with two huge exterior storage closets. Spacious covered patio off the back of the house. Large metal building with 1 bathroom and 4 rooms (each room has it\'s own exterior door). ALSO Includes a mobile home with 3 bedrooms and 2 full bathrooms (with it\'s own power and water meters) Another large storage/metal building behind the mobile home. The property is covered with fruit trees. There\'s a lot to offer here. Lots of new construction around. NO HOA! Beautiful Area. Come see this property today.' ,`Acres` = '1.592' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A0018 T QUEVADO TRACT 21B' ,`LotDesciption` = 'Cleared' ,`LotSize` = '69348' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '255 - Tyler' ,`SchoolElementary` = 'DR BRYAN C JACK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROBERT E LEE HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (TYLER)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'T QUEVADO' ,`TaxAmount` = '5429' ,`TaxRate` = '1.8927' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702484' WHERE `Matrix_Unique_ID` = '211732200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T13:28:07.960' ,`MLSNumber` = '88710514' ,`ListAgentFullName` = 'Brenda Zambrano' ,`ListOfficeName` = 'One2Three Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817963' ,`Longitude` = '-95.391113' ,`PhotoCount` = '9' ,`PostalCode` = '77022' ,`RoomCount` = '2' ,`ListPrice` = '283000.00' ,`Status` = 'Active' ,`StreetName` = '35th' ,`StreetNumber` = '626' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We have a gorgeous two-bedroom, one bath, two car garage single family home, that is located in Independence Heights neighborhood. It has a nice open concept floor plan equipped for optimal entertainment. The neighborhood has an elementary school in walking distance, as well as a park across the street. This spacious home is deemed to being your forever home.' ,`Acres` = '0.1033' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 29 INDEPENDENCE HEIGHTS AMEND 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Independence Heights O P Kelton' ,`TaxAmount` = '5434' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702484' WHERE `Matrix_Unique_ID` = '211733344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:22:48.323' ,`MLSNumber` = '18157732' ,`ListAgentFullName` = 'Kyle Craycraft' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.308142' ,`Longitude` = '-95.434061' ,`PhotoCount` = '38' ,`PostalCode` = '75835' ,`RoomCount` = '6' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Trailwood' ,`StreetNumber` = '308' ,`StreetSuffix` = 'Drive' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this 3/2.5 two-story home on a 0.97-acre lot. In the spacious backyard, you can enjoy the in-ground swimming pool beneath the covered back porch. Upon entering the front door, you will appreciate the layout and the dual-sided fireplace. The large living area opens to a formal dining area that could be used as a den. The spacious kitchen has great cabinet and countertop space, large pantry, a wet bar for entertaining guests, and a breakfast area with French doors overlooking the pretty backyard. The handy laundry just off the kitchen has good storage and access to the garage. There is a half bath just off the kitchen and living area that serves guest well. The large master bedroom has a private bath with a separate vanity area, tub, shower, and walk-in closet. Upstairs, you will find two bedrooms, each with its own built-in desks and large closets. There is also a common area that would be perfect for a small game room and a full bath with double sinks. Call today!' ,`Acres` = '0.97' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'H MASTERS HARRISON SD AB 53 .97 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '42253' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'H Masters Harrison SD' ,`TaxAmount` = '6294' ,`TaxRate` = '2.4194' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702484' WHERE `Matrix_Unique_ID` = '211769353' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:05:34.700' ,`MLSNumber` = '58253134' ,`ListAgentFullName` = 'Susan Hutson' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801511' ,`Longitude` = '-95.531136' ,`PhotoCount` = '18' ,`PostalCode` = '77080' ,`RoomCount` = '3' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestdale' ,`StreetNumber` = '1627' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Agents do not bother home owner for questions call the listing agent. This is sold for lot value and sold as is.' ,`Acres` = '0.3276' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 113 BLK 9 PINE VILLAGE SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '14272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'PINE SHADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Village Sec 02' ,`TaxAmount` = '7525' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702484' WHERE `Matrix_Unique_ID` = '211769582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T12:51:03.323' ,`MLSNumber` = '90904787' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835844' ,`Longitude` = '-95.772694' ,`PhotoCount` = '13' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '438490.00' ,`Status` = 'Active' ,`StreetName` = 'San Leo' ,`StreetNumber` = '4222' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW MODERN DESIGN! This beautiful Two story home on a cul-da-sac street features an open concept with wonderful designer details and beautiful finishes!! Fantastic island kitchen offers great storage options, under cabinet lighting, stainless steel built-in appliances & quartz countertops! The primary bath has quartz counter tops, double sinks and a separate shower and tub!! Game room!!! Smart Home Technology, fully landscaped front & back including sprinkler system. Tankless water heater. Garage door opener. Large covered back patio. 16-SEER A/C and SO MUCH MORE!' ,`Acres` = '0.1519' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 VENTANA LAKES EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702485' WHERE `Matrix_Unique_ID` = '211772218' --> Updated record success