Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T16:18:17.950' ,`MLSNumber` = '91658222' ,`ListAgentFullName` = 'Bruce Sellers' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.968649' ,`Longitude` = '-95.423214' ,`PhotoCount` = '50' ,`PostalCode` = '77541' ,`RoomCount` = '9' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Highway 36' ,`StreetNumber` = '5003' ,`StreetSuffix` = '' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2 story home with pond situated on 4.29 Unrestricted acres. This property is fenced & crossed fenced with driveway gate, private water well, wrap around porch, shade & fruit trees. This property is encompassed by mature live oak trees for added privacy. There is a buffer of woods between you and the neighbors on one side and on the other side its all wooded and owned by the State of Texas. The interior provides a generous living room with vaulted ceiling and a wall of windows that will immediately delight.  All brick wood burning fireplace for those cold winter nights.  Formal dining, kitchen with breakfast area and 2 utility rooms, one which serves as a mud room. Two secondary bedrooms are roomy & share a hollywood bath. Spacious master bedroom w/double sinks & vanity, walk in shower, soaker tub plus a great walk-in-closet. Don\'t miss the opportunity to own a little piece of Brazoria County Country Bliss!' ,`Acres` = '4.29' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'GULF PARK ESTATES (A0020 S F AUSTIN DIV 18) LOT 1 ACRES 4.29' ,`LotDesciption` = 'Cleared,Water View,Wooded' ,`LotSize` = '186872' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf Park Estates' ,`TaxAmount` = '4594' ,`TaxRate` = '1.813' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094340' WHERE `Matrix_Unique_ID` = '207444840'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T15:14:49.537' ,`MLSNumber` = '45971849' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.166883' ,`Longitude` = '-96.397744' ,`PhotoCount` = '16' ,`PostalCode` = '77833' ,`RoomCount` = '11' ,`ListPrice` = '306900.00' ,`Status` = 'Active' ,`StreetName` = 'Old Vine Road' ,`StreetNumber` = '1014' ,`StreetSuffix` = '' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upon entering this exceptional floor plan, you\'re immediately greeted with a high ceiling foyer. Walking into the open-concept kitchen and living room, you\'ll be stunned by the amount of space you have to gather. This three bedroom, two and a half bath home has placed windows in the living room, primary bedroom, and dining room, crafting a home that is filled with natural light and charm. Granite countertops throughout and a large walk-in primary closet to top it all off and make this home exceptional. Additional options included: Stainless steel appliances, decorative tile backsplash, and dual primary bathroom vanity.' ,`Acres` = '0.152' ,`Area` = '58' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S5942 - Vintage Farms S/D # 3, BLOCK 4, Lot 2, ACRES 0.152' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6621' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vintage Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094340' WHERE `Matrix_Unique_ID` = '208203330'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T16:37:54.123' ,`MLSNumber` = '91832223' ,`ListAgentFullName` = 'Bruce Sellers' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.456095' ,`Longitude` = '-95.474627' ,`PhotoCount` = '19' ,`PostalCode` = '77378' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Coaltown' ,`StreetNumber` = '14938' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gently lived in Jim Gentry Custom Home! This 1 story  2/1/2 is located in Arrowhead Lakes. Country Living with everyday conveniences. Open floor plan with very large living area and exceptionally spacious kitchen with stainless stove, dishwasher, microwave and sink. Granite Counters with large eat in breakfast bar. Covered back porch with backyard. Just 5 minutes north of Willis and only a couple of miles to I-45 for easy access north to the amenities of Huntsville or south to Conroe and even beyond to all the shopping, dining and world-class medical facilities of The Woodlands. Welcome home neighbor! Willis ISD.' ,`Acres` = '0.155' ,`Area` = '19' ,`BuilderName` = 'Jim Gentry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S216003 - ARROWHEAD LAKES 3, BLOCK 28, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arrowhead Lakes' ,`TaxAmount` = '3649' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094341' WHERE `Matrix_Unique_ID` = '211050628'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T15:15:38.240' ,`MLSNumber` = '51103324' ,`ListAgentFullName` = 'Bobbie Poole' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.410112' ,`Longitude` = '-95.580243' ,`PhotoCount` = '42' ,`PostalCode` = '75835' ,`RoomCount` = '5' ,`ListPrice` = '562000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO DEED RESTRICTIONS!  You can have it all......Great Investment Opportunity for Airbnb, second home or your primary residence! Seller is also in process of sodding grass in front and back yard, new irrigation system!  Plus... Painting the outside and installing Garage Doors before closing!!!  This one and half story home has 5 bedrooms and 2.5 baths! With 2 bedrooms downstairs and three up.  Home, also offers a touch of elegance with Formal Living and Dining room and the back of the house has a large kitchen that opens\r\nup to a cozy den with fireplace and a wall of windows across the back with wonderful views and huge deck across the back! It has your own private boat house with the lot being completely bulkheaded. The garage and circle driveway has plenty of room for your parking and guest! Come to Houston County Lake and enjoy the beautiful sunsets and all that the Lake has to offer!' ,`Acres` = '0.48' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 21 Blk A' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '20909' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '61 - Latexo' ,`SchoolElementary` = 'LATEXO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LATEXO HIGH SCHOOL' ,`SchoolMiddle` = 'LATEXO HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Linwood Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094341' WHERE `Matrix_Unique_ID` = '211191399'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T16:24:15.927' ,`MLSNumber` = '97613046' ,`ListAgentFullName` = 'Becki McAuley' ,`ListOfficeName` = 'Greystone Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827909' ,`Longitude` = '-95.467488' ,`PhotoCount` = '39' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Chantilly' ,`StreetNumber` = '5119' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5119 Chantilly! Fully remodeled last year and beautiful. New floors throughout home, new kitchen cabinets and counters, new bathroom cabinets and counters, new doors, new interior and exterior paint. New light fixtures and ceiling fans throughout the home. Home features a large office/study space with French doors. This extra room could also be used as a dining room. Remodeling allowed for a new master bedroom with ensuite bath. Living room is open to the dining and kitchen. All secondary bedrooms are found upstairs. Home also features a built-in desk/homework area. 2 Workshops in backyard. Remodeled \"she\" shed or is it a \"he\" shed? You decide.' ,`Acres` = '0.2939' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 4 MANGUM MANOR SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mangum Manor Sec 03' ,`TaxAmount` = '5154' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094341' WHERE `Matrix_Unique_ID` = '212665226'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T15:48:19.820' ,`MLSNumber` = '78377038' ,`ListAgentFullName` = 'Bruce Sellers' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.417626' ,`Longitude` = '-95.612493' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '15' ,`ListPrice` = '1775000.00' ,`Status` = 'Active' ,`StreetName` = 'Promenade' ,`StreetNumber` = '369' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE waterfront home that\'s also on the golf course is located in the gated country club community of Bentwater on Lake Conroe with exclusive GRAND PINES MEMBERSHIP available. Completely updated traditional style with two full suites on the first floor and another two full suites upstairs plus game room and media room and additional \"bunk\" room currently set up to sleep six. Situated at the very end of a cul-de-sac, this exceptional location has a private pool, expanded dock with two boat slips, open water views and sits next to the tee box of the 3-par 14th hole of the Weiskopf course, one of 54 holes of golf available to those who opt for the Grand Pines Membership level. Your quiet lifestyle provides the privacy of a gated, golf course community on Lake Conroe yet you\'re only a short drive to all the shopping, dining and world-class medical facility amenities of The Woodlands. Exemplary Montgomery ISD.' ,`Acres` = '0.4165' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 59, BLOCK 2, LOT 1' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course,Waterfront' ,`LotSize` = '18142' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '40073' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094341' WHERE `Matrix_Unique_ID` = '213793645'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T15:30:31.330' ,`MLSNumber` = '5011591' ,`ListAgentFullName` = 'Bruce Sellers' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.422923' ,`Longitude` = '-95.612816' ,`PhotoCount` = '44' ,`PostalCode` = '77356' ,`RoomCount` = '12' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgewood' ,`StreetNumber` = '527' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the gated country club community of Bentwater on the shores of Lake Conroe, this home is uniquely situated on the golf course while also enjoying a view of the water. The updated and immaculately maintained interior has a warm, traditional feel. The exterior features a fully screened atrium (very rare in Bentwater) covering your entire pool and deck area. Your view from the pool area is exceptional, spanning the double fairway of #12 Weiskopf and looking toward the #12 green making for a very private setting since the homes behind you are perhaps 250 yards away. Back inside, you have four bedrooms, three of which are upstairs separated by a bridge which overlooks the living area below.  Unique layout provides your guests privacy. The area above the garage is massive and has been finished out. It currently serves as a combination game room, media room and craft room but the possibilities are only limited by your imagination. Exemplary Montgomery ISD.' ,`Acres` = '0.2085' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 4, BLOCK 3, LOT 30' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Water View' ,`LotSize` = '9082' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1046' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '10804' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094342' WHERE `Matrix_Unique_ID` = '214658152'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T15:19:43.540' ,`MLSNumber` = '22010961' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564408' ,`Longitude` = '-95.754272' ,`PhotoCount` = '41' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '753572.00' ,`Status` = 'Active' ,`StreetName` = 'Norwood Groves' ,`StreetNumber` = '24306' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home\'s unique touches are sure to grab your attention. Welcome to one of Coventry Homes’ best-selling floor plans. Open the stunning double front doors and enter the foyer that is sure to impress. The kitchen comes equipped with an oversized island that overlooks the family room, study and dining area, perfect for entertaining. The game room and media room offer ample amounts of additional entertaining space. The spacious covered back patio and 4 car garage completes the home. Come and see this home today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10639' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094342' WHERE `Matrix_Unique_ID` = '214661220'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215404278','1675094342','215404278','2022-12-22T16:19:43.870','89724478','Feras Rachid','Opendoor Brokerage, LLC','','','30.020917','-95.108592','18','77336','3','275000.00','Active','Corydon','711','Drive','Houston','2','0','3','2041','Single-Family','Welcome to this fabulous area! This home has fresh interior paint and partial flooring replacement. Windows create a light filled interior with well placed neutral accents. Step into the kitchen, complete with an eye catching stylish backsplash. You won’t want to leave the serene primary suite, the perfect space to relax. Other bedrooms provide nice flexible living space. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t miss this incredible opportunity.\r\nThis home has been virtually staged to illustrate its potential.','0.2865','1','','','','','Sellers Disclosure','1','','0','Huffman Area','Central Gas','1','LT 511 BLK 23 LAKEWOOD HEIGHTS SEC 3 R/P','Subdivision Lot','12480','Appraisal District','','278','0','','0','','0','','','','','Other','28 - Huffman','HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Lakewood Heights Sec 03 R/P','5634','2.4592','Public Water','1964','Seller');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215603973','1675094342','215603973','2022-12-22T16:21:59.727','47543532','Lance Loken','KB Home Houston','','','29.980388','-95.226467','7','77338','14','409809.00','Active','Soaring Legend','10742','Drive','Humble','3','0','5','3204','Single-Family','**Home is under construction.** Fall in love with in this beautiful KB Home in Estates of Tour 18, boasting a brick front, extended entry, game room, and open great room. Master new recipes in the kitchen, complete with granite countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. Spend evenings relaxing in the primary suite, featuring extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include a covered patio. This beautiful golf course community is conveniently located near Hwy 59 and Beltway 8, giving residents easy access to Downtown Houston, The Woodlands, Lake Houston, and the George Bush Intercontinental Airport. Residents are mere minutes from dining and shopping at the Atascocita Commons and Deerbrook Mall. Zoned to the highly-rated Humble ISD.','','1','KB Home','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Humble Area East','Central Gas','1','Lot 1 Block 2','Subdivision Lot','','','','748','1','To Be Built/Under Construction','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','29 - Humble','LAKELAND ELEMENTARY SCHOOL (HUMBLE)','HUMBLE HIGH SCHOOL','ROSS STERLING MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Tour 18','','2.933','Public Sewer,Public Water,Water District','2023','Builder');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215718306','1675094342','215718306','2022-12-22T15:45:40.267','80483271','Lorena Rivera','RE/MAX Pearland','','','29.532469','-95.461104','39','77545','3','349000.00','Active','Jasmine','705','Street','Fresno','2','1','3','2296','Single-Family','Welcome to this Maxwell Heights custom built home. This Beautiful two story home features 3 bedrooms, 2 full baths in a half and a 2 car garage. A lovely patio to set out and enjoy the evenings. This home is perfect, easy access to major high ways, close to shopping centers, restaurants. Make your appointment today, this is one of a kind and won\'t disappoint.','0.222','38','','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','0','Stove','1','Missouri City Area','Central Electric','0','MAXWELL HTS, BLOCK 592, LOT 7 (N 1/2)','Other','9670','Appraisal District','','260','0','','','','0','','','Electric Range','','Composition','19 - Fort Bend','GOODMAN ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Maxwell Heights','5668','2.7629','Water District','2016','Appraisal District');  --> New record created successfully<br />