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-16T15:40:15.473' ,`MLSNumber` = '92420286' ,`ListAgentFullName` = 'April Lendo' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.083048' ,`Longitude` = '-94.005202' ,`PhotoCount` = '21' ,`PostalCode` = '75931' ,`RoomCount` = '3' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Drowsy' ,`StreetNumber` = '57' ,`StreetSuffix` = 'Lane' ,`City` = 'Brookeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! Currently under construction and in the highly sought after Rayburn Country subdivision on beautiful Lake Sam Rayburn. Nestled on a quiet street among beautiful trees and in a cul-de-sac, this property is the perfect place to call home. Within minutes to the boat ramps and just a golf cart ride away from Rayburn Country Club where you can enjoy all the amenities that the resort has to offer.' ,`Acres` = '0.22' ,`Area` = '46' ,`BuilderName` = 'Dupre' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 57 SEC 16 RAYBURN COUNTRY 1210/187 0.22 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '9583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rayburn Country' ,`TaxAmount` = '69' ,`TaxRate` = '1.6721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699483' WHERE `Matrix_Unique_ID` = '204284908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:49:24.983' ,`MLSNumber` = '22702044' ,`ListAgentFullName` = 'Kayin Lawrence' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = 'Lakira Jones' ,`SellingOfficeName` = 'Diverse City Realty' ,`Latitude` = '29.853529' ,`Longitude` = '-95.270674' ,`PhotoCount` = '31' ,`PostalCode` = '77078' ,`RoomCount` = '8' ,`ListPrice` = '245000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Claiborne' ,`StreetNumber` = '8431' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller is VERY MOTIVATED!!! PRICE REDUCTION!!!Newly remolded home. This home has several upgraded features such as granite countertops in bath and kitchen. There is fresh paint/ Exterior & Interior. New carpet in All bedrooms. There is an additional storage unit located in the backyard. Includes patio sliding doors that lead to a HUGE backyard for entertainment. Home has a fence to give you the privacy you want.' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 12 GLENWOOD FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenwood Forest Sec 03' ,`TaxAmount` = '2334' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699483' WHERE `Matrix_Unique_ID` = '206556542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:52:32.990' ,`MLSNumber` = '4993641' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.949401' ,`Longitude` = '-95.196981' ,`PhotoCount` = '32' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '558983.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Banchory Leaf' ,`StreetNumber` = '12630' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Bailey III, Elevation D) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, Formal Living room/Study and Formal Dining room. Spacious island kitchen open to Family room. Primary suite with large walk in closet. Three additional bedrooms and spacious Game room and Media room on second floor. Covered patio and attached 2 car garage. Forget the world outside and come home to Balmoral, a community surrounded by beauty and peace in the West Lake Houston area of northeast Beltway 8 in Humble, TX. Balmoral offers residents connected living with luxurious homes and many amenities to choose from, including the Houston area\'s Crystal Clear Lagoon surrounded by glistening white sand beaches. Stop by the Westin Homes model home today to find out more about Balmoral!' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1714' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699483' WHERE `Matrix_Unique_ID` = '207736733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:13:21.547' ,`MLSNumber` = '29486705' ,`ListAgentFullName` = 'Roxie Krisher Hippard' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805266' ,`Longitude` = '-95.057996' ,`PhotoCount` = '41' ,`PostalCode` = '77562' ,`RoomCount` = '11' ,`ListPrice` = '514900.00' ,`Status` = 'Active' ,`StreetName` = 'Whites Lake Estates' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'Highlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great one story home on .95 acres in a gated community**This home can be a five bedroom or a four bedroom with a gameroom**Perfect for entertaining**Kitchen has a 6 burner gas range**High ceilings**formal dining**Home office***extra large entry**Split bedroom plan**Closet in laurndry room- also plumbed for a sink**Plantation Shutters**Pool and hot tub plus 1/2 bath in 9x10 pool house**covered patio**3-car garage has a 30 and 50 amp plug** seperate 20x20 workshop**Owner is installing electrical and lights in workshop**' ,`Acres` = '0.95' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 WHITES LAKE ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '41382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '620' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Whites Lake Estates' ,`TaxAmount` = '9269' ,`TaxRate` = '2.4939' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699484' WHERE `Matrix_Unique_ID` = '208463477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:59:00.450' ,`MLSNumber` = '69362611' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.168192' ,`Longitude` = '-95.295247' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '317040.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Woodpecker' ,`StreetNumber` = '18211' ,`StreetSuffix` = 'Trail' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW D.R. Horton Home in the perfect location! Open Plan with spacious kitchen, and the oversized island perfect for entertaining! Large living room area open to both dining and kitchen. Primary suite secluded to back of the home for privacy. Other features include a full automatic sprinkler system, landscape package, granite in kitchen and water proof like wood EVP Vinyl flooring in entry, kitchen and wet areas and double sinks in the master bath with a separate tub and shower, stainless appliance package, and a tankless water heater! Porters Mill is a lovely new community located 1 mile north from The Grand Parkway off 1314 and Gene Campbell Rd. Call today to make your appointment!' ,`Acres` = '0.145' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812703 - PORTERS MILL 03, BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Porters Mill 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699484' WHERE `Matrix_Unique_ID` = '209477731' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:07:21.400' ,`MLSNumber` = '98098621' ,`ListAgentFullName` = 'Pamela Ledet' ,`ListOfficeName` = 'Texas Ethics Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801000' ,`Longitude` = '-95.454327' ,`PhotoCount` = '44' ,`PostalCode` = '77320' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 19' ,`StreetNumber` = '3015' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Business Opportunity with this Commercial and Residential property with 396 feet of Highway frontage. With almost 1 acre right off Highway 19 in Huntsville. This already established Antique and Resale Store comes fully stocked with hidden gems & a 3 bedroom 2 bath home built in November 2008 that sits behind it. Carport, multiple storage sheds, & RV Sewer & water Hookup. House could be used for residential use or turned into another shop. New Roof 2020! 50 blocks & Beams! Smart Boards w/termite protection! 3 septic tanks pumped and clean! No Carpet! All SS Appliances! The possibilities are endless! Call & schedule your showing today!' ,`Acres` = '0.97' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Heat Pump,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'MURRAY O (A-666), TRACT 6, ACRES .97' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '42253' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'MURRAY' ,`TaxAmount` = '3208' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699484' WHERE `Matrix_Unique_ID` = '209605917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:33:22.337' ,`MLSNumber` = '60781385' ,`ListAgentFullName` = 'Giang Dinh' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952166' ,`Longitude` = '-95.439663' ,`PhotoCount` = '29' ,`PostalCode` = '77067' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Coppermeade' ,`StreetNumber` = '1306' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome lovely one storey 3 bedroom home offers the perfect amount of space with peaceful living ! Stunning open kitchen with granite countertops. Come see this beauty today and get in before school starts !' ,`Acres` = '0.1326' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 1 GREEN OAK PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SPENCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Green Oak Park Sec 01' ,`TaxAmount` = '5549' ,`TaxRate` = '2.9908' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699484' WHERE `Matrix_Unique_ID` = '209988308' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:59:53.643' ,`MLSNumber` = '92518493' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503207' ,`Longitude` = '-95.446453' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Brooklyn Rose' ,`StreetNumber` = '5519' ,`StreetSuffix` = 'Drive' ,`City` = 'Arcola' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Charleston Heights in Arcola, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Grayson floorplan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage! You’ll love entertaining in this home! The gourmet kitchen is sure to please with an island overlooking the dining and family rooms, 42” cabinets, and granite countertops! Retreat to the spacious Owner’s Suite featuring a separate tub and shower, walk-in closet, and tray ceiling for some dramatic flair! Enjoy the great outdoors on the covered patio! Don’t miss your opportunity to call Charleston Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5580' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Heights' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699484' WHERE `Matrix_Unique_ID` = '210166365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:50:22.780' ,`MLSNumber` = '22326229' ,`ListAgentFullName` = 'Ann Susan Beirne' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.137477' ,`Longitude` = '-95.536981' ,`PhotoCount` = '30' ,`PostalCode` = '77389' ,`RoomCount` = '8' ,`ListPrice` = '499500.00' ,`Status` = 'Active' ,`StreetName` = 'Sagamore Ridge' ,`StreetNumber` = '95' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2437' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculately maintained 3/3/2, 1.5 story home WITH POOL AND SPA in highly desirable Creekside Park in The Woodlands. This adorable home features engineered hard wood floors throughout main living areas, super functional open floor plan with all bedrooms down and spacious game room and full bathroom up, and sparkling pool and spa! Huge lot..over a quarter of an acre, and no immediate back neighbors. Highly sought after schools and just minutes to world class dining and shopping! Easy access to I45, The Grand Parkway, Hardy Toll Road and the ExxonMobile campus!' ,`Acres` = '0.3178' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 42 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13842' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park 14' ,`TaxAmount` = '9287' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699484' WHERE `Matrix_Unique_ID` = '210221284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:25:13.490' ,`MLSNumber` = '55798367' ,`ListAgentFullName` = 'Chunyuan Ye' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698064' ,`Longitude` = '-95.769105' ,`PhotoCount` = '44' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Starbridge Lake' ,`StreetNumber` = '23502' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4141' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All you need is here: Lake View! Private pool! New Roof 2020, new paint fence. Rare chance beautifully 5 bedrooms and 3 garages, high ceiling, well maintained red brick & stone traditional home is situated on a premium lot with only one neighbor and overlooking a beautiful lake. The property\'s features include a private study/office, game room, media room on the second floor, outdoor kitchen that brings convenience for family and friends, mosquito & irrigation systems, the pool & spa with Pebble Tec,Heated function& seven water features. Low tax rate, LAMAR ISD school rated A! Make it your dream home today! House has never flooded!' ,`Acres` = '0.2135' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARKWAY LAKES SEC 2, BLOCK 3, LOT 16' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '9301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '919' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Parkway Lakes' ,`TaxAmount` = '11151' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699484' WHERE `Matrix_Unique_ID` = '210226331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:48:55.373' ,`MLSNumber` = '49523980' ,`ListAgentFullName` = 'Wendy Dozier' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.460652' ,`Longitude` = '-94.640634' ,`PhotoCount` = '47' ,`PostalCode` = '77650' ,`RoomCount` = '2' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Diamond' ,`StreetNumber` = '1100' ,`StreetSuffix` = 'Road' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home in the heart of Crystal Beach was built with love and is an IKE survivor w/new AC unit, new roof & soffits, cargo lift & custom kitchen cabinets upstairs with over 27,000 SF of land (GCAD tax# 3000-0000-0054-000 is also a part of this). The house sits on 2 lots (6,640 SF). One side, closest to the RV park, has 13,780 SF and a privacy fence. The other side of the house, going towards the bay is 6,580 SF. There is a 50 RV AMP attached to the house and the land provides enough room for RV\'s or to build your own home. The upstairs is ready to make it your own and has more space downstairs to make a game room or another couple of bedrooms. Downstairs has 2 doors that access the outside and a door that opens up to go through the garage. It is large enough for a car and/or golf cart. Most furniture is staying. Make this your dream home! Garage has 2 doors on 2 sides so the garage opens up to go through the garage. It is large enough for a car and/or golf cart. Most furniture stays.' ,`Acres` = '0.62' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 53 - 57 DIAMOND ACRES SUB' ,`LotDesciption` = 'Other' ,`LotSize` = '27310' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Diamond Acres 1' ,`TaxAmount` = '1268' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699485' WHERE `Matrix_Unique_ID` = '211180771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:56:57.637' ,`MLSNumber` = '77388092' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Adeniyi Ojo' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '30.152023' ,`Longitude` = '-95.582370' ,`PhotoCount` = '28' ,`PostalCode` = '77354' ,`RoomCount` = '17' ,`ListPrice` = '649863.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Chartres Wind' ,`StreetNumber` = '8215' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`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. NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.2187' ,`Area` = '15' ,`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` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9526' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '2250' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699485' WHERE `Matrix_Unique_ID` = '211274716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:31:46.273' ,`MLSNumber` = '16797038' ,`ListAgentFullName` = 'Claudia Babb' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.313765' ,`Longitude` = '-95.573449' ,`PhotoCount` = '9' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '876900.00' ,`Status` = 'Active' ,`StreetName` = 'Laramie' ,`StreetNumber` = '13917' ,`StreetSuffix` = 'Trail' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction to be built - Pictures are of a previous built home by the builder. Finishes will be same or similar. Just under 2.25 treed acres with convenience of city life! 4 bedrooms with a study or 5 bedrooms, 4 full baths, kitchen with soft close cabinets, large island, pantry with extra storage, stainless steel appliances. Primary Suite with walk in shower, soaker tub and a large walk-in closet with access to the laudry room. Secondary bedroom or Study downstairs with access to a full bathroom. Upstairs has 3 nice size bedrooms with 2 full baths, game room & media room. Mud space, 3 car garage with 8ft garage doors. Outside is a huge covered patio, with a extra 30x50 slab for multiple uses. HURRY there is still time to put your personal touch on this one' ,`Acres` = '2.246' ,`Area` = '39' ,`BuilderName` = 'Vuuren Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Laramie Oaks 01, Block 1, Lot 1, 2.246 acres' ,`LotDesciption` = 'Wooded' ,`LotSize` = '97835' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Laramie Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699485' WHERE `Matrix_Unique_ID` = '211304175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:07:15.833' ,`MLSNumber` = '88046295' ,`ListAgentFullName` = 'Charlene Findley' ,`ListOfficeName` = 'Boom Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880474' ,`Longitude` = '-94.874275' ,`PhotoCount` = '45' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '564000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry Point' ,`StreetNumber` = '12919' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Gorgeous home was designed with your comfort in mind, the open floor plan features a welcoming interior and includes a formal dining room, first-floor bedroom. LG. room above the garage connected via the breezeway currently used as a 5th bedroom can be used as a game room/ media room. Entertaining has never been easier thanks to this spacious kitchen which contains stainless-steel appliances, built-in oven, granite countertops, and tile backsplash. The main bedroom is an oasis of peace and relaxation and enhances a spacious bathroom, walk-in closet and serene backyard views. You\'ll enjoy being in the good-sized backyard which boasts a large patio, in-ground pool, beautifully manicured lawn and shady trees. 30x60 covered patio space, great for entertaining. Additional garage/workshop, dog run and a covered parking area for your boat or RV. 500 gallon propane tank, 24 KW Generac Guardian. Low taxes, Barbers Hill ISD. NEVER FLOODED! Call your realtor for a private tour!' ,`Acres` = '0.798' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '110 CHERRY POINT SUB' ,`LotDesciption` = 'Corner' ,`LotSize` = '34761' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Point Ranchettes' ,`TaxAmount` = '9917' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699485' WHERE `Matrix_Unique_ID` = '211449704' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:21:26.337' ,`MLSNumber` = '58982774' ,`ListAgentFullName` = 'Cecilia Pineda' ,`ListOfficeName` = 'CJM Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583141' ,`Longitude` = '-95.751620' ,`PhotoCount` = '10' ,`PostalCode` = '77406' ,`RoomCount` = '2' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Damon' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Street' ,`City` = 'Richmond' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcoming 2 bedroom one bath on a larger corner lot. This homes offers warm hardwood floors throughout and new countertops, AC was replaced in 2015, Roof replaced in 2020, blown-in insulation in 2021, Renovated Bathroom and new concrete at carports. No HOA!' ,`Acres` = '0.2537' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'EDGEWOOD ADDN, BLOCK 23, LOT 5, ACRES 0.2537' ,`LotDesciption` = 'Corner' ,`LotSize` = '11053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood Add' ,`TaxAmount` = '1888' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699485' WHERE `Matrix_Unique_ID` = '211455597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:58:16.600' ,`MLSNumber` = '24821715' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.491789' ,`Longitude` = '-95.084212' ,`PhotoCount` = '32' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Hickory' ,`StreetNumber` = '1417' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Showstopper in the beautiful Oaks of Clear Creek neighborhood in League city, Texas.\r\nThe home you’ve been waiting for is move in ready! Centrally located between Houston and Galveston. This spacious 2 story 4 bdrm/3.5 bath home has an open floor plan with kitchen and breakfast area with coffee bar, counter tops are quartz. Living room with linear gas fireplace on tiled accent wall. Formal dining with crown molding- large primary suite with bay windows, crown molding,walk in shower and large bathroom down. Upstairs has 3 bedrooms 2 baths with large game room with built in cabinets. \r\nUpdates included are HVAC,certified energy efficient windows, all stainless appliances, quartz countertops, Baldwin doorknobs and handlesets. \r\nBeautiful backyard with pergola including granite counter. Koi pond, urban barn and lush landscaping. CCISD schools, UTMB hospitals' ,`Acres` = '0.1669' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 PAGE 16 & 17 LOT 15 BLK 3 THE OAKS OF CLEAR CREEK SUB' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Oaks Of Clear Creek Sec 3' ,`TaxAmount` = '5355' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699485' WHERE `Matrix_Unique_ID` = '211475171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:21:17.587' ,`MLSNumber` = '21493281' ,`ListAgentFullName` = 'Cat Jones' ,`ListOfficeName` = 'RE/MAX Land & Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.391288' ,`Longitude` = '-96.840020' ,`PhotoCount` = '50' ,`PostalCode` = '77950' ,`RoomCount` = '3' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Bay' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Street' ,`City` = 'Austwell' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a tranquil, waterfront home with stunning bay views, superior fishing, and abundant wildlife? This newly remodeled three-bedroom three-bath home on Hynes Bay in Austwell, Texas checks every box. Built to last in 1950, this sturdy home with storm-certified windows is perched on a bluff overlooking the bay. There are hardwood floors throughout, a tiled kitchen, and two newer a/c units. Outside, a 1200 square-foot insulated metal building provides perfect shelter for a boat or RV. A lightly used public ramp offers quick bay access that will put you on the trout and redfish early, without the crowds. Many of the migratory birds that visit Aransas National Wildlife Refuge just down the road, also feed along the bay shore, and if you are lucky the sighting of an endangered Whooping Crane. The great outdoors is what this property is all about, but it is also the perfect haven after a good day fishing, hunting, or birdwatching.' ,`Acres` = '0.7576' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'W/2 HOTEL BLK AUSTWELL' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '33001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '320 - Austwell-Tivoli' ,`SchoolElementary` = 'AUSTWELL-TIVOLI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTWELL-TIVOLI HIGH SCHOOL' ,`SchoolMiddle` = 'AUSTWELL-TIVOLI HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Austwell' ,`TaxAmount` = '5030' ,`TaxRate` = '3.1597' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699485' WHERE `Matrix_Unique_ID` = '211478990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T14:48:59.247' ,`MLSNumber` = '14605849' ,`ListAgentFullName` = 'Cynthia Pierce' ,`ListOfficeName` = 'Gann Medford Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.335027' ,`Longitude` = '-94.736545' ,`PhotoCount` = '50' ,`PostalCode` = '75904' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Jefferson' ,`StreetNumber` = '476' ,`StreetSuffix` = 'Avenue' ,`City` = 'Lufkin' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Captivating from the moment you drive up! This home offers 5 bedrooms (2 down), 4 full baths and 2 half baths. The beautiful wood finishes are a common theme throughout the home. Multiple living and dining areas plus an office or flex space. Island kitchen with Butler\'s pantry. Upstairs each bedroom enjoys it\'s own bath. The primary suite has it\'s own laundry room and the bathroom measures 19x28! Additionally, a guest apartment is located over the garage with 1BR/1B, kitchen and living area (1,125 per appraisal district). Large fenced backyard, porte cochere. See in person to truly appreciate!' ,`Acres` = '0.9' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABS 0040 QUINALTY J. L.,TRACT 104,ACRES .849' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '39204' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = '' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jl Quinalty Surv Abs #40' ,`TaxAmount` = '9316' ,`TaxRate` = '2.3856' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1934' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699486' WHERE `Matrix_Unique_ID` = '211481471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:50:26.740' ,`MLSNumber` = '98555854' ,`ListAgentFullName` = 'Will Clark' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188476' ,`Longitude` = '-95.426357' ,`PhotoCount` = '5' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Gemstone' ,`StreetNumber` = '16' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2941' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! So much extra thought put into this home. Hidden walk-in pantry in a glamorous kitchen. Built in wine frig and glass front cabinets,large island with ample seating. Primary bath with chic soaking tub, dual shower heads in walk in shower for 2. Tons of closet space. Mud room /utility combo. Primary plus one bedroom downstairs, 2 large bedrooms upstairs.' ,`Acres` = '0.178' ,`Area` = '5' ,`BuilderName` = 'Heritage Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Greystone SD Blk 1 Lot 48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7772' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greystone Subdivision' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699486' WHERE `Matrix_Unique_ID` = '211482644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T15:41:36.123' ,`MLSNumber` = '45645342' ,`ListAgentFullName` = 'Tafi Daniels' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825773' ,`Longitude` = '-94.378403' ,`PhotoCount` = '33' ,`PostalCode` = '77665' ,`RoomCount` = '6' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Santa Fe' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Street' ,`City` = 'Winnie' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All brick home with aluminum roof installed less than two years ago! Easy access to Highway 73 and 124, but still cozy and quiet, with the entrance at a dead-end road. Perfect location for limitless possibilities! Living space has full glass doors giving a glance to the concrete back patio! Kitchen has island seating and abundance of cabinets and storage space! Primary bedroom has en-suite bathroom with full tile shower and separate dressing table. Formal dining could be easily converted to a fourth bedroom. A/C unit is only seven years old and breaker box is five. Great spot and great home! Superior half block lot giving you both corners facing 73. Drive out and see what you think? Schedule your private showing to see the house! You will love everything about this place!' ,`Acres` = '2.0617' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BK 1 LTS 7&8 & STIDHAM S/D LTS 10-16' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '89809' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sp Stidham Sub' ,`TaxAmount` = '3993' ,`TaxRate` = '2.1546' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699486' WHERE `Matrix_Unique_ID` = '211485215' --> Updated record success