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-07T21:23:12.717' ,`MLSNumber` = '93220913' ,`ListAgentFullName` = 'MaLisa Hampton' ,`ListOfficeName` = 'Town & Country Realty and Mortgage' ,`SellingAgentFullName` = 'MaLisa Hampton' ,`SellingOfficeName` = 'Town & Country Realty and Mortgage' ,`Latitude` = '30.162358' ,`Longitude` = '-96.430513' ,`PhotoCount` = '28' ,`PostalCode` = '77833' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Country Place West' ,`StreetNumber` = '475' ,`StreetSuffix` = 'Drive' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Best Lot in the Subdivision! Beautiful wooded 1.76 acre lot situated in Country Place West. The back yard is a peaceful park like setting with open views of the countryside. The home has a huge 24X12 master bedroom downstairs with it\'s own fireplace! The attached master bath has double sinks, a shower/tub combination and a large walk in closet. There are an additional three bedroom and a full bathroom upstairs. Each bedroom has a built in desk and large closets. Two of the bedroom have built in bookcases and additional attic storage. The 2 AC\'s are zoned for upstairs and down. The living area boasts another wood burning heatilator fireplace as the focal point in the room. There is a wet bar pass through into the kitchen with built in bookcases on each side. The formal dining room splits the family room and kitchen. Other features are a breakfast room with a breakfast bar and built in bench seating. Atrium doors open on to the patio from the breakfast room for al fresco dining.' ,`Acres` = '1.76' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY PLACE WEST , LOT 7, ACRES 1.76' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '76666' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Country Place West' ,`TaxAmount` = '4824' ,`TaxRate` = '1.5429' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088505' WHERE `Matrix_Unique_ID` = '208666010'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T22:51:05.783' ,`MLSNumber` = '15703855' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.439041' ,`Longitude` = '-95.615434' ,`PhotoCount` = '27' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Water' ,`StreetNumber` = '109' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home with 4 bedrooms, game room, & study & 2 1/2 baths.. Ceramic tile all down stairs except the primary bedroom. View virtual tour online, 3D floor plan image, & pics. Stainless appliances, fenced, grassed, sprinkler system, ceiling fans, garage door opener, window blinds all included. Located in sought after Montgomery schools & in a low tax rate & low HOA dues! Subdivision does have a boat ramp with Lake Conroe access. Ready for move in now!' ,`Acres` = '0.1278' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S341700 - CLEAR WATER COVE, BLOCK 5, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Water Cove' ,`TaxAmount` = '381' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088505' WHERE `Matrix_Unique_ID` = '211067860'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T22:35:10.950' ,`MLSNumber` = '20409357' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.393865' ,`Longitude` = '-95.616408' ,`PhotoCount` = '30' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden' ,`StreetNumber` = '12629' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home ready for move in. 2 1/2 car garage located on a corner lot. 4 bedrooms, study, game room, 2 1/2 baths. Ceramic tile flooring all floors except bedrooms. Master bedroom is very large with a bay window. 3 bedrooms and a game room upstairs. Located in the exemplary rated Montgomery ISD & in a low tax rate! Walden amenities include water front swimming pools over looking Lake Conroe, Yacht club, walking paths, multiple tennis & pickle ball courts, 2 boat ramps, exercise room, exercise pool, parks, dog park, playground, soccer & baseball field. Located in sought after exemplary rated Montgomery schools! Low tax rate!    See virtual tour, 3D floor plan image, & pics.' ,`Acres` = '0.178' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 08 BK 30 LT 48 SECTION 8A' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7752' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 08' ,`TaxAmount` = '172' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088505' WHERE `Matrix_Unique_ID` = '211491993'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T22:28:25.020' ,`MLSNumber` = '17217230' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.394188' ,`Longitude` = '-95.621950' ,`PhotoCount` = '27' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden' ,`StreetNumber` = '12914' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home in Walden on Lake Conroe.  3 bedroom, 2 bath, 2 car garage with formal dining, which could easily be a home office/study.  Open kitchen flows to family room and breakfast area.  Plank wood tile in all main living areas/baths, carpet in bedrooms.  Utility room in house with washer/dryer connections.  Included with home are electric cooktop/stove combo, microwave and dishwasher.  Ceiling fans in bedrooms and family room.  Granite counter tops and 42\" upper cabinets.  Community amenities include swimming pools over looking Lake Conroe, yacht club, multiple tennis courts & pickle ball courts, exercise room, exercise pool, 2 boat ramps, walking trails, parks, dog park, soccer & baseball field. Also within the subdivision is a golf course, marina, restaurants, sheriff office, & fire department.  View virtual tour, 3D floor plan, & pics.    Home is zoned to highly acclaimed Montgomery ISD schools. Low tax rate!' ,`Acres` = '0.1824' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S945518 - WALDEN 18, BLOCK 1, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 18' ,`TaxAmount` = '177' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088506' WHERE `Matrix_Unique_ID` = '212599955'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T22:18:23.877' ,`MLSNumber` = '61046900' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.396103' ,`Longitude` = '-95.623951' ,`PhotoCount` = '32' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '334000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden' ,`StreetNumber` = '13002' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home with 3 bedroom, 2 bath, 2 car garage.  Ceramic tile all flooring except for the bedrooms. See virtual tour, 3D floor plan image, & pics.  Walden has numerous amenities including waterfront swimming pools over looking Lake Conroe, yacht club, multiple tennis & pickle ball courts, exercise room, 2 boat ramps, exercise pool, walking trails, parks, dog park, & soccer & baseball field. Also in the subdivision there is restaurants, sheriff office, fire dept., marina, & golf course.  Sought after exemplary rated Montgomery schools & a low tax rate!\r\nView virtual tour, 3D image of floor plan, & pics.' ,`Acres` = '0.1824' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 18, BLOCK 1, LOT 15' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '7944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 18' ,`TaxAmount` = '177' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088506' WHERE `Matrix_Unique_ID` = '212603532'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T22:08:42.903' ,`MLSNumber` = '800215' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.396214' ,`Longitude` = '-95.624012' ,`PhotoCount` = '34' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden' ,`StreetNumber` = '13006' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home in Walden on Lake Conroe.  2 story, 4 bedroom, 2.5 bath, 2 car gaarge with extra storage spaces in the garage. Open living space on first floor with under stairs closet for added storage.  Ceiling fans in all bedrooms and family room with tile flooring in all main living areas and baths; carpet flooring in bedrooms.  Kitchen has granite counter tops, tile backsplash, 42\" upper cabinets, electric stove/oven combo, microwave and dishwasher.  Utility room is in house with electric washer/dryer connections. See professional virtual tour, 3D floor plan image, & pics. \r\n Walden community amenities to include waterfront swimming pools over looking Lake Conroe, exercise pool, multiple tennis courts & pickle ball courts, exercise room, parks, walking trails, 2 boat ramps, dog park, baseball & soccer field, & yacht club. Also within the subdivision is a golf course, marina, restaurants, sheriff office, & fire department. Zoned to highly acclaimed Montgomery ISD schools & a low tax rate!' ,`Acres` = '0.1824' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 18, BLOCK 1, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 18' ,`TaxAmount` = '177' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088506' WHERE `Matrix_Unique_ID` = '212606818'  --> 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','215330223','1675088506','215330223','2022-12-07T22:41:45.980','91190582','Daniel Lokey','RE/MAX Integrity','','','30.147171','-95.717178','32','77355','11','680000.00','Active','Lone Shadow','16021','Trail','Stagecoach','2','2','4','4516','Single-Family','Nestled in the picturesque community of Stagecoach Farms in Magnolia, this gorgeous custom home is a rare find! Very close proximity to TX-249 & SH99 allows for quick access to downtown Tomball, Magnolia and the Woodlands. This impressive home features 4 bedrooms, 2 full and 2 half baths, a three-car garage, elegant front entrance, high ceilings and beautiful moldings throughout. The primary bedroom suite offers ample room with two walk-in closets. The open concept living and dining room are ideal for entertaining your family as well as large gatherings. Available for build out is an additional 750 sqft located above the garage, a perfect space for a game room or an extra living area. Large corner lot consists of 2.75 acres, giving the entire family space to roam. Stagecoach offers its own police department, lakes, parks and numerous wonderful community events throughout the year! New roof & new A/C systems (2021), fresh paint, updated flooring, granite countertops, low taxes & HOA!','2.7548','15','','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','Gas Connections','1','Tomball','Central Electric','1','S902009 - STAGECOACH FARMS 09, LOT 395, 396, 397, ACRES 2.75','Cleared,Corner,Wooded','120000','Appraisal District','','50','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','36 - Magnolia','J.L. LYON ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal','2','Colonial','Stagecoach Farms 09','8332','2.2954','Aerobic,Public Water','1998','Appraisal District');  --> New record created successfully<br />