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-09-13T01:22:01.273' ,`MLSNumber` = '93380959' ,`ListAgentFullName` = 'Wendy Baty' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.127689' ,`Longitude` = '-95.575148' ,`PhotoCount` = '48' ,`PostalCode` = '77515' ,`RoomCount` = '9' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Pony Trail' ,`StreetNumber` = '172' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paradise found!  Gorgeous, Modern Farmhouse home on peaceful, Eagle Lake in the wildlife friendly community of Bar X Ranch.  If you love to fish, this one\'s for you!  You can fish from your very own backyard or put the boat in to go out a little further on the lake. There are Ducks, Eagles & even a few Pelicans seen on the lake, & the lake sunsets...WOW!  There\'s plenty of room for outside activities with 1.54 acres of your very own. You\'ll have a 1040 square foot barn/garage/man cave to store all those grown up toys as well as to park your car or truck.  There\'s also a two car carport attached. Enjoy the spring weather on your front or back porch, or on one of the two porches offered by the garage/barn. Inside, this beautiful home is open concept with 8\' doors, high ceilings, granite countertops in the kitchen & a gas log fireplace in the living area.  Two possible master bedrooms; one up & one down.  Very well appointed with an oversized front door good for moving in!  Never flooded.' ,`Acres` = '1.54' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Sec 10 (A0053 S Carter) Blk 1 Lot 35A (Replat \'15)' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '67082' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bar X Ranch' ,`TaxAmount` = '7079' ,`TaxRate` = '1.636' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709916' WHERE `Matrix_Unique_ID` = '205113560'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-13T01:22:01.273' ,`MLSNumber` = '7397497' ,`ListAgentFullName` = 'Michael Brombacher' ,`ListOfficeName` = 'Brombacher & Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717525' ,`Longitude` = '-95.420651' ,`PhotoCount` = '20' ,`PostalCode` = '77005' ,`RoomCount` = '7' ,`ListPrice` = '1880000.00' ,`Status` = 'Active' ,`StreetName` = 'Annapolis' ,`StreetNumber` = '6031' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6031 Annapolis! Another spectacular new construction by Laird Custom Homes features 4 bedrooms, 3.5 baths. Beautiful wide-plank oak floors throughout. Downstairs features an expansive family room overlooking the backyard, study, bar, and mudroom off the garage. Bright spacious kitchen includes Thermador appliances, large Calacatta island, and walk-in pantry. Primary suite with vaulted ceilings, double vanities, oversized marble shower, and luxurious freestanding bathtub. Walk-in-closet-space galore (two of them in the primary bedroom)! Elevator capable and EV charging outlet in the garage. Located so close to Rice Village (where you can try a new restaurant every evening!) and a hop, skip, and jump to highly rated West U Elementary and Weir Park. AND so close to the Medical Center, Greenway Plaza, and Downtown. Builder and designer are finalizing selections, but there\'s still the opportunity to select your favorite finishes! Please inquire for more details.' ,`Acres` = '0.1148' ,`Area` = '17' ,`BuilderName` = 'Laird Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 3 VIRGINIA COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Virginia Court' ,`TaxAmount` = '13409' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709916' WHERE `Matrix_Unique_ID` = '207239277'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-13T01:22:01.273' ,`MLSNumber` = '68791531' ,`ListAgentFullName` = 'Michael Brombacher' ,`ListOfficeName` = 'Brombacher & Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702490' ,`Longitude` = '-95.442955' ,`PhotoCount` = '18' ,`PostalCode` = '77025' ,`RoomCount` = '9' ,`ListPrice` = '1880000.00' ,`Status` = 'Active' ,`StreetName` = 'Lanark' ,`StreetNumber` = '4102' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This spectacular new construction by Laird Custom Homes features 4 bedrooms, 4 baths, with a BRICK exterior in charming tree-lined Ayrshire. Beautiful wide-plank oak floors throughout. Downstairs features an expansive family room overlooking the sideyard, study, and dining room. Bright spacious kitchen includes Thermador appliances, beautiful Calacatta island, and walk-in pantry. Come & go through the oversized 3-car garage and mud room. Guest suite with full bath down. Upstairs is your private primary suite with vaulted ceilings, double vanities, oversized marble shower, and luxurious freestanding bathtub. Walk-in-closet-space galore (two of them in the primary bedroom)! Located so close to Twain Elementary, Palace Social, Weekley YMCA, & much more. AND so close to the Medical Center, Downtown, and Greenway. Builder and designer are finalizing selections, but there\'s still the opportunity to select your favorite finishes! Please inquire for more details.' ,`Acres` = '0.2169' ,`Area` = '17' ,`BuilderName` = 'Laird Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 28 BLK 3 AYRSHIRE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Ayrshire Sec 01' ,`TaxAmount` = '11616' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709916' WHERE `Matrix_Unique_ID` = '207453227'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-13T00:03:18.770' ,`MLSNumber` = '75566991' ,`ListAgentFullName` = 'Diane Driscoll' ,`ListOfficeName` = 'Rock Edwards & Associates,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.639598' ,`Longitude` = '-95.488929' ,`PhotoCount` = '24' ,`PostalCode` = '77035' ,`RoomCount` = '9' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Southminster' ,`StreetNumber` = '5803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOUR NEXT HOME AWAITS!  3/2/2 on CORNER LOT in Westbury South.  NO CARPET anywhere!  Kitchen has GLASS TOP COOKTOP, DOUBLE-OVEN, GRANITE COUNTERTOPS, SOFT-CLOSE DRAWERS & CABINETS and a WALK-IN-PANTRY! EXTRA-WIDE DOORS (most wheelchairs will fit). There is a STUDY/OFFICE/CRAFT ROOM/FLEX ROOM up front. DECKED ATTIC in house and garage. OVERSIZED GARAGE for plenty of storage space! FENCED BACKYARD has MATURE SHADE TREES on the South and a spacious patio.  EASY ACCESS TO TEXAS MEDICAL CENTER! HAVE YOUR AGENT SCHEDULE A SHOWING TODAY! CHOICE HOME PROTECTION PLAN INCLUDED THROUGH 7-1-2025!!' ,`Acres` = '0.1846' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E 67 FT OF LT 15 BLK 141 WESTBURY SOUTH' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westbury South' ,`TaxAmount` = '4814' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709916' WHERE `Matrix_Unique_ID` = '210700806'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-13T01:22:01.273' ,`MLSNumber` = '19361615' ,`ListAgentFullName` = 'Lanita Koppe' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.117442' ,`Longitude` = '-95.562471' ,`PhotoCount` = '30' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Bronco' ,`StreetNumber` = '1408' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HONEY STOP THE CAR! This beautiful 3 bedroom, 2.5 bathroom waterfront property sits on almost 3 acres.  The inside offers a split bedroom floorplan, a family room with a beautiful fireplace, an office as well as a formal dining room.  Outside you will find a 1500 sq foot shop (30x50) with double doors, a covered patio perfect for watching the wildlife, an oversized detached garage as well as extra parking.  Community amenities include access to the clubhouse, pools, as well as playgrounds. Call today to schedule your private viewing on this home that hasn\'t ever flooded.' ,`Acres` = '2.93' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 3 (A0038 J B BAILEY) BLK 4 LOT 278-279 ACRES' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '84942' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar X Ranch Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709917' WHERE `Matrix_Unique_ID` = '211277398'  --> 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','212428945','1663709917','212428945','2022-09-13T00:07:34.793','30452738','Myra Arenas','Coldwell Banker Realty','','','29.611204','-95.537466','38','77489','9','359000.00','Active','Martin','730','Lane','Missouri City','3','0','6','2436','Single-Family','Beautiful traditional 6 bed and 3 full baths with an extra full bed and bathroom. As well as an optional home office/ bedroom. Very spacious backyard that wraps around entire home. Home also has a detached 2 car garage.','0.2534','38','','','','','Mud,Sellers Disclosure','1','','1','Missouri City Area','Central Gas','0','WOODLAND WEST SEC 1, BLOCK 7, LOT 8 (SE 35\') & LOT 9, R/P','Corner','11039','Appraisal District','','','0','','2','','0','','','','','Composition','19 - Fort Bend','E A JONES ELEMENTARY SCHOOL','MARSHALL HIGH SCHOOL (FORT BEND)','MISSOURI CITY MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Woodland West Sec 1','2466','2.5525','Water District','1969','Appraisal District');  --> 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','212450785','1663709917','212450785','2022-09-13T01:59:01.990','19996521','Nazrin Jahangirova','The Agency Texas Inc','','','30.073744','-95.585750','20','77375','7','480000.00','Active','Alpenhorn','11131','Place','Tomball','3','1','4','3105','Single-Family','Spacious 2 story house built in the Alexander Estates offers a highly accessible location in a charming neighborhood. This house has everything a buyer would look for- first floor office space, lots of storage, media room, separate floorplan, huge backyard and innovative energy efficient home features. \r\nAssigned to Klein ISD.','0.1952','14','','','','','Sellers Disclosure','','','1','Spring/Klein/Tomball','Central Gas','1','LT 5 BLK 4 ALEXANDER ESTATES','Other','8501','Appraisal District','','875','0','','2','','0','','','','','Composition','32 - Klein','BERNSHAUSEN ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Supra Keybox','Appraisal','2','Traditional','Alexander Estates','5228','2.4218','Water District','2020','Appraisal');  --> New record created successfully<br />