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-05T11:13:13.670' ,`MLSNumber` = '36646448' ,`ListAgentFullName` = 'Deborah Jamail' ,`ListOfficeName` = 'Neptune Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.330212' ,`Longitude` = '-94.940443' ,`PhotoCount` = '40' ,`PostalCode` = '77563' ,`RoomCount` = '7' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Herring' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Drive' ,`City` = 'Bayou Vista' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '2' ,`SqFtTotal` = '1431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for open spaces and waterfront this may be it! This property is 0.72 of an acre in sought after Bayou Vista. This 2 bedroom, one bath home also has a loft that can be used as office or another bedroom. Half bath in loft. Wonderful view south up the canal. Plenty of storage downstairs with another bath and laundry area. Small swimming pool on deck out the French doors from living room. Mexican tile gives this home an exotic flair. Wet bar in living room. Bedrooms are generous in size. Fully fenced property with boathouse and lift. So many possibilities for this great property.' ,`Acres` = '0.7213' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 S C BUNDICK SUR PT OF LOT 19 (19-22) S C BUNDICK SUB' ,`LotDesciption` = 'Water View,Waterfront,Wooded' ,`LotSize` = '31417' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'New Bayou vista' ,`TaxAmount` = '20825' ,`TaxRate` = '2.6699' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694743' WHERE `Matrix_Unique_ID` = '200264640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T11:33:25.567' ,`MLSNumber` = '75146220' ,`ListAgentFullName` = 'Gary Powers' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839956' ,`Longitude` = '-94.385828' ,`PhotoCount` = '13' ,`PostalCode` = '77665' ,`RoomCount` = '1' ,`ListPrice` = '95000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake' ,`StreetNumber` = '225' ,`StreetSuffix` = 'Drive' ,`City` = 'Winnie' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large, well built 30\' x 40\' building with a 2 car garage door with a plethora of additional storage. One 7.5\' x 14.5\' room that could make a small living area or the first room of a future barndominium. This would also make a great home base to be used for travelers. Enjoy the view of the neighbors pond and horses, while watching the activities of the famous Winnie Trade Days activities.' ,`Acres` = '0.2789' ,`Area` = '53' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 NORTH LAKE S/D' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'North Lake Sub' ,`TaxAmount` = '108' ,`TaxRate` = '2.1546' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694744' WHERE `Matrix_Unique_ID` = '205576988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T11:52:00.810' ,`MLSNumber` = '16791805' ,`ListAgentFullName` = 'Maria Williams' ,`ListOfficeName` = 'Texcom Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138458' ,`Longitude` = '-94.881643' ,`PhotoCount` = '12' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '515520.00' ,`Status` = 'Active' ,`StreetName` = 'Road 660' ,`StreetNumber` = '1178' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The open floor plan features a warm, welcoming interior. The kitchen boasts stainless steel appliances, granite countertops, a large island, custom cabinets, recessed lighting, a walk-in pantry, a built-in microwave, & a gas range. The main bedroom features a spacious bathroom & his and her walk-in closet. The main bathroom is beautifully appointed with a custom shower, soaking tub, double sinks, granite countertops, and tiled flooring. The home has lots of space for gatherings & covered outdoor area for entertaining guests. The large lot gives you plenty of privacy, & 2-car attached garage gives you plenty of room for parking, leaving the driveway open for plenty of parking space. Home is around the corner from restaurants, great shopping, local shops, grocery stores, supermarkets, bars, lively entertainment district, theaters, and shopping malls.' ,`Acres` = '0.788' ,`Area` = '52' ,`BuilderName` = 'EMR Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 1, BLOCK 2, LOT 3, ACRES .788' ,`LotDesciption` = 'Wooded' ,`LotSize` = '34325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '820' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694744' WHERE `Matrix_Unique_ID` = '208050773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:02:19.990' ,`MLSNumber` = '30512455' ,`ListAgentFullName` = 'Arman Jafari' ,`ListOfficeName` = 'Persepolis Realty, LLC' ,`SellingAgentFullName` = 'Pamela Helzer' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.826209' ,`Longitude` = '-94.993778' ,`PhotoCount` = '39' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '309900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Painted Bunting' ,`StreetNumber` = '4403' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this like-new home in Goose Creek Landing! This 4-bedroom, 3 full-bathroom home boasts an open, spacious floor plan, high ceilings, a large kitchen with granite counter tops, great dining area with tray ceiling detail, a sizeable master bedroom with walk-in closet and en-suite bathroom, and much more. Fresh carpet and paint throughout. Situated on a private, oversized cul-de-sac lot with no rear neighbors. Lovely community with great access to highways and neighborhood amenities.' ,`Acres` = '0.2456' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 1 GOOSE CREEK LANDING SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Crk Lndg Sec 4' ,`TaxAmount` = '9741' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694744' WHERE `Matrix_Unique_ID` = '208942112' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:36:41.420' ,`MLSNumber` = '48425450' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998623' ,`Longitude` = '-95.783421' ,`PhotoCount` = '12' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '368740.00' ,`Status` = 'Active' ,`StreetName` = 'Mersmann Ridge' ,`StreetNumber` = '16018' ,`StreetSuffix` = 'Lane' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW HOME OPPORTUNITY just minutes from GRAND PARKWAY, Houston Premium Outlets & North Cypress Med Center w/ easy access to Hwy 290. ACCLAIMED WALLER ISD schools. This 4 bed, 2 bath home on GREENBELT lot features an open layout with GRANITE kitchen with oversized island open to family room, stainless appliance package, high vaulted ceilings in kitchen and family, and vinyl plank wood floors through main living areas. Primary retreat with dual sinks and separate tub/shower, and spacious guest bedrooms. Tankless water heater, covered back patio, and a stunning exterior elevation. Call today for your tour of available homes!!!' ,`Acres` = '0.146' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 2 STONE CREEK RANCH SEC 12' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694744' WHERE `Matrix_Unique_ID` = '209688633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:32:21.283' ,`MLSNumber` = '67591597' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998449' ,`Longitude` = '-95.783539' ,`PhotoCount` = '32' ,`PostalCode` = '77447' ,`RoomCount` = '5' ,`ListPrice` = '377740.00' ,`Status` = 'Active' ,`StreetName` = 'Mersmann Ridge' ,`StreetNumber` = '16014' ,`StreetSuffix` = 'Lane' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW HOME OPPORTUNITY just minutes from GRAND PARKWAY, Houston Premium Outlets & North Cypress Med Center w/ easy access to Hwy 290. ACCLAIMED WALLER ISD schools. This 4 bed, 3 bath home on GREENBELT lot features an open layout with Kitchen featuring exotic granite, stainless appliance package, maple cabinetry, and open to HUGE family room. Vinyl plank wood floors through main living areas, baths with tile wall surrounds, UPSTAIRS GAME ROOM, and two bedrooms down. Primary retreat with dual sinks and separate tub/shower, and spacious guest bedrooms. Tankless water heater, smart home system, full sprinkler system, LED lighting, & covered back patio. Call today for your tour of available homes!!!' ,`Acres` = '0.145' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 2 STONE CREEK RANCH SEC 12' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694744' WHERE `Matrix_Unique_ID` = '209691206' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:27:12.600' ,`MLSNumber` = '15653041' ,`ListAgentFullName` = 'Jennifer Lerner' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666308' ,`Longitude` = '-95.451793' ,`PhotoCount` = '33' ,`PostalCode` = '77035' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tonawanda' ,`StreetNumber` = '4418' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4418 Tonawanda! The charming 4 bedroom, 2 bathroom home is located in the highly sought out Willow Meadows area, which is a short walk to Red Elementary School and the community pool, tennis courts and baseball fields. A short drive away is The Texas Medical Center, The Galleria and Downtown. Upon entering the home, is a very large living space and updated kitchen, which connects to an adorable sitting area with a wood burning fireplace. The kitchen has updated cabinetry and stainless steel appliances with stunning concrete floors. Updates include roof (2019), HVAC Unit (2016) and Water Heater (2021). All 4 bedrooms are in a separate wing of the house and each equipped with a nice sized closet. The outdoor living space is ideal for a family BBQ or entertaining space for friends. There is even on outdoor shower! NEVER FLOODED!' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 490 BLK 23 WILLOW BEND SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`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` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Willow Bend Sec 04' ,`TaxAmount` = '7186' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694744' WHERE `Matrix_Unique_ID` = '209823413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:34:49.883' ,`MLSNumber` = '50136786' ,`ListAgentFullName` = 'Katherine McSwane' ,`ListOfficeName` = 'McSwane Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.727764' ,`Longitude` = '-96.206193' ,`PhotoCount` = '28' ,`PostalCode` = '75840' ,`RoomCount` = '3' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Pr 1295' ,`StreetNumber` = '117' ,`StreetSuffix` = '' ,`City` = 'Fairfield' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the city life! Custom home on 2+ acres located in private subdivision. This 3 bedroom, 2 bath home nestled among mature trees at the end of a quiet cul-de-sac offers open concept living area with high ceilings and windows which provide a picturesque view of the backyard. The spacious master suite features built-in cabinetry, large en suite bathroom, jetted garden tub with separate shower, and a 10 x 14 walk-in closet with built-ins for organized storage. The 2 secondary bedrooms are generous sizes. The backyard has a gorgeous in-ground heated pool, built-in water slide with rock waterfall, custom hot tub, and beach entry. Other features: gas log fireplace, granite counters, and fantastic scored concrete floors throughout the home. Oversized attached 2-car garage with storage closets and attic access. Detached workshop on slab foundation is plumbed and insulated with AC for projects and more storage. Sprinkler system, jetted septic system, and community water supply.' ,`Acres` = '2.41' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WILLOW CREEK FARMS LOT 12' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '104980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Creek' ,`TaxAmount` = '5972' ,`TaxRate` = '1.7349' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694744' WHERE `Matrix_Unique_ID` = '210126429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T11:30:26.750' ,`MLSNumber` = '76425384' ,`ListAgentFullName` = 'Kelly Lawson' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194666' ,`Longitude` = '-95.634717' ,`PhotoCount` = '26' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '630' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape to the country on 12.87 acres tucked away yet close to shopping and entertainment in the FM 1488/FM 2978 area. The home has two bedrooms, two full baths, flex/ room off the primary bedroom for an office, exercise room, or nursery. The kitchen has granite countertops and stainless appliances—laminate flooring in the living, kitchen, dining, and bathrooms, with carpet in the bedrooms. Outside is a 30\' x 50\' workshop, 24\' x 26\' barn, various sheds, cross fencing, and livestock pens—the no flooding, even during Harvey.' ,`Acres` = '12.87' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0072 - BASS ANN, TRACT 3-C, 4, ACRES 12' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '522720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '101' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694745' WHERE `Matrix_Unique_ID` = '210786570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T11:15:24.240' ,`MLSNumber` = '83069526' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.261058' ,`Longitude` = '-95.464189' ,`PhotoCount` = '29' ,`PostalCode` = '77515' ,`RoomCount` = '11' ,`ListPrice` = '778990.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Ranch' ,`StreetNumber` = '319' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Castlerock Communities highly sought-after Frisco plan is a beautiful, spacious 5 bedroom/4 bathroom, 2 story home that is situated on 1.62 acres! Your new home greets you with a 2 story grand entry that boasts a sweeping spiral staircase! Retreat into the study through 8ft double doors! The huge eat-in island kitchen features built-in stainless steel GE appliances and a large walk-in pantry! Engineered wood flooring throughout main living areas of 1st floor. Separate media and game room upstairs. Upgraded kitchen countertops, cabinets, and appliances! Upgraded 3 car garage with 8ft garage doors and a huge dedicated area for a shop or extra storage!' ,`Acres` = '1.62' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 5, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '70567' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694745' WHERE `Matrix_Unique_ID` = '210956810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:51:56.473' ,`MLSNumber` = '30879689' ,`ListAgentFullName` = 'Suzanne Rogers' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.300709' ,`Longitude` = '-94.784494' ,`PhotoCount` = '14' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '1108' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You won\'t want to miss out on this high raised cottage. Located on East End of Galveston in Lost Bayou District. Only to have the beach close to you. This home offers 2 bedrooms, 1 bath with a one car garage. The upstairs 2 bedroom has beautiful wood floors with high ceilings. Central Air and Heat. In the afternoons you can go outside on the back deck and relax. This property also has a downstairs that has a extra living area with full bath with tile flooring.' ,`Acres` = '0.0385' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOT 1 (1-2) BLK 76 GALVESTON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1677' ,`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` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '4245' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1897' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694745' WHERE `Matrix_Unique_ID` = '211033499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T11:08:37.573' ,`MLSNumber` = '19098208' ,`ListAgentFullName` = 'David Tyer' ,`ListOfficeName` = 'Tyer Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.323494' ,`Longitude` = '-95.455790' ,`PhotoCount` = '37' ,`PostalCode` = '75835' ,`RoomCount` = '5' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '608' ,`StreetSuffix` = 'Street' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful ranch-style home with over 2,200 square feet of living! This home offers a large open concept kitchen and living areas with an eat-at bar and granite countertops. You will find a walk-in laundry room with lots of space for storage. Off of the kitchen, you will find a bonus room that can be used as an office or a 5th bedroom. The oversized master bedroom has two spacious walk-in closets and its own bathroom for the perfect ensuite and the other 3 bedrooms have ample closet space and a second bathroom with a shower/tub combo. Outside is an attached two-car garage along with a closed in storage building and a lean-to perfect for entertaining and outdoor living. This home sits on a large lot with a fenced in backyard. It is vacant and ready to see so call us to schedule today!' ,`Acres` = '0.48' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A E GOSSETT AB 423 .48 AC NEOL 154' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20909' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2894' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694745' WHERE `Matrix_Unique_ID` = '211045411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:29:15.413' ,`MLSNumber` = '87621544' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349867' ,`Longitude` = '-95.535193' ,`PhotoCount` = '10' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '336135.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '536' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME home to Hills of Westlake located just minutes from Lake Conroe and zoned to CONROE ISD. Enjoy easy access to I-45 and a quick commute to lots of great shopping and dining. Community offers a large community pool and playground. THIS NEW 4 bed, 2 bath home is loaded with LUXURY features -- GRANITE ISLAND, stainless steel appliances, breakfast bar, and 42\" modern cabinetry. Breakfast room off kitchen, open family room, Smart home package, & solid surface flooring throughout. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, large walk-in closet, frameless shower, and separate tub. Relaxing backyard featuring covered back patio!!! MAKE THE MOVE!!!' ,`Acres` = '0.148' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - Hills Of Westlake 02, BLOCK 1, Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '1297' ,`TaxRate` = '2.98' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694745' WHERE `Matrix_Unique_ID` = '211054610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:56:29.903' ,`MLSNumber` = '10372124' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.355075' ,`Longitude` = '-95.511414' ,`PhotoCount` = '17' ,`PostalCode` = '77304' ,`RoomCount` = '12' ,`ListPrice` = '1385000.00' ,`Status` = 'Active' ,`StreetName` = 'Teas Cottage' ,`StreetNumber` = '7328' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in an upscale gated community North of Houston, this beautiful new construction, scheduled to be finished by the end of October 2022, it\'s seated on 1 acre wooded lot with a view of The Community Recreational Park/Pond. The woods encapsulate the house, offering great privacy. The house was not built for builder\'s profit. Engineered framing and foundation plans were authorized by the City of Conroe. The foundation was poured way above the ground and seats on 50 9 feet deep peers. High quality Pella Cad-Wood windows were installed all around the house. Foam insulation on the walls and the ceiling brought the energy compliance above any national or local codes. 3 high efficiency HVAC units will provide a stable temperature in the house during hot summers or cold winters. The buyer has the option to choose the room colors, trimming, lights, doors and cabinets style or to take over the project and finish it (negotiated price). Endless possibilities to create your own paradise!' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'Unknown' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S922703 - Teaswood 03, BLOCK 1, Lot 36' ,`LotDesciption` = 'Water View' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Teaswood' ,`TaxAmount` = '' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694745' WHERE `Matrix_Unique_ID` = '211064418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:57:29.260' ,`MLSNumber` = '63910984' ,`ListAgentFullName` = 'Jose Barbosa' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.967248' ,`Longitude` = '-95.587127' ,`PhotoCount` = '27' ,`PostalCode` = '77070' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Sprucedale' ,`StreetNumber` = '11027' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONE STORY WITH A POOL in Anderson Woods! Never flooded. This home has great high ceilings, double pane windows, Five year old A/C . The island kitchen is open to the large main living area, and the breakfast room looks out over the pool. New ceramic tile and roof. You won\'t find this much home at this price point again...make your appointment TODAY!' ,`Acres` = '0.207' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 ANDERSON WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Woods Sec 01' ,`TaxAmount` = '6272' ,`TaxRate` = '2.5362' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694745' WHERE `Matrix_Unique_ID` = '211064938' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:08:33.893' ,`MLSNumber` = '53336715' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Houston Portfolio Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740567' ,`Longitude` = '-95.475527' ,`PhotoCount` = '50' ,`PostalCode` = '77056' ,`RoomCount` = '11' ,`ListPrice` = '1549000.00' ,`Status` = 'Active' ,`StreetName` = 'Overbrook' ,`StreetNumber` = '5637' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern Mediterranean-style home nestled in the desirable Galleria boasts endless elegant features, high ceilings, beautiful tile and wood flooring, crown molding, a large formal entry, glass fronted bar with wine racks, formal living & dining rooms, a game room, and a stone-surround fireplace and built-ins in the open great room. Unwind in the gorgeous outdoor space, complete with covered patio, private balcony, spacious backyard, and a gated detached garage and porte cochere. The incredible gourmet kitchen is complete with granite countertops, tumbled tile & stacked stone backsplash, breakfast bar, ample cabinets and lighting, and a walk-in pantry. The serene primary suite features a custom walk-in closet, dual vanities, deep tub, and shower with double rain showerheads. Mere steps from the Galleria Mall, River Oaks, The Heights, and Downtown. Enjoy nearby recreation at Memorial Park, Houston Arboretum, and the Houston Country Club. Less than 10 minutes from River Oaks Baptist School.' ,`Acres` = '0.242' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 BRAIRCROFT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarcroft Add' ,`TaxAmount` = '32654' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694746' WHERE `Matrix_Unique_ID` = '211086918' --> Updated record success