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-11-29T16:46:34.460' ,`MLSNumber` = '39978990' ,`ListAgentFullName` = 'Cyndi De Palermo' ,`ListOfficeName` = 'Red Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.458525' ,`Longitude` = '-95.076839' ,`PhotoCount` = '30' ,`PostalCode` = '77539' ,`RoomCount` = '0' ,`ListPrice` = '312000.00' ,`Status` = 'Active' ,`StreetName` = 'Colonial' ,`StreetNumber` = '2806' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Designed for Better Living! Step inside to this open floorplan that is very spacious! Nestled in a bird sanctuary this home offers 4 bedrooms and 2.5 baths with a detached garage and huge backyard.  The formal living room makes a great home office and is located off the entryway. A formal dining room is ready for holiday dinners. The expansive kitchen is truly a dream with granite countertops, tons of cabinets, a built-in desk, and a large pantry. The breakfast area is spacious as well and features a breakfast bar that can seat 6. The family room offers built-ins and a beautiful gas fireplace as the focal point of the room. Beautiful laminate wood flooring adds warmth throughout the home. The primary bedroom features 2 closets and a beautiful private bath with dual vessel sinks and a large shower. The backyard is fenced and has a large patio and is home to a large detached garage.  Come make this home yours today!' ,`Acres` = '0.2281' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 28 COLONIAL ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9938' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Colonial Estates' ,`TaxAmount` = '4771' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085402' WHERE `Matrix_Unique_ID` = '207392735'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T15:44:56.400' ,`MLSNumber` = '88826961' ,`ListAgentFullName` = 'Denise Nelson' ,`ListOfficeName` = 'Keystone Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.174262' ,`Longitude` = '-95.404613' ,`PhotoCount` = '40' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Canyon' ,`StreetNumber` = '19265' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wanting land to build your business? UNRESTRICTED area with pond. Estate sale. Sold as is - no repairs. House needs lots of work on foundation, roof, plumbing and electrical. Shop built in 1991 and is 50x30x14 with large bay doors, wash sink, test tank. Value is in UNRESTRICTED property in up and coming, growing area south of the Woodlands, east of 45 with well and septic. Lots of area growth. No HOA. No MUD. Additional concrete pad with electric stubbed on side yard. Very low tax rate. Limited showings due to occupied and work from home. Right side of house by carport took a little water during Harvey. Professional photos to be taken Friday. Do not walk property. Seller to approve showings. No Sellers Disclosure.' ,`Acres` = '2' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GREENWOOD ACRES 01, LOT 13, ACRES 2.000' ,`LotDesciption` = 'Other' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenwood Acres 01' ,`TaxAmount` = '1982' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085402' WHERE `Matrix_Unique_ID` = '208549952'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T16:08:46.053' ,`MLSNumber` = '56150258' ,`ListAgentFullName` = 'Ellen Johnston' ,`ListOfficeName` = 'BHHS Worldwide, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.319436' ,`Longitude` = '-95.361693' ,`PhotoCount` = '38' ,`PostalCode` = '75709' ,`RoomCount` = '14' ,`ListPrice` = '4100000.00' ,`Status` = 'Active' ,`StreetName` = 'Stewart' ,`StreetNumber` = '2818' ,`StreetSuffix` = 'Way' ,`City` = 'Tyler' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '10277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular golf course French Classic masterpiece designed by Fusch Architects and Connie Davis, Petals and Interiors Design. Experience the exquisite views from every major room in the home. The stunning dream kitchen has furniture quality built-ins, 2 dishwashers, Sub-zero fridge and freezer, Wolf gas cooktop, double ovens, microwave and warming drawer. Barreled vaulted entry ways with detailed layered trim lead you from space to space. Amazing quality construction and finishes such as Pearlized Lacquer Trim, hand selected granite and marble, white oak flooring, custom forged iron staircase, groin ceiling in the gallery, phantom lighting and wood-cased Weather Shield windows. The interior of this home boasts 4 bedrooms, 4 living areas, 2 studies, theatre room, game room, card room, devotional room and a huge bonus room. Many rooms will accommodate your own special use. All bedrooms have ensuite baths. Outdoor spaces abound overlooking the golf course.' ,`Acres` = '0.609' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'CASCADES ADDN BLOCK 1801-L LOT 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '26528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '255 - Tyler' ,`SchoolElementary` = 'DIXIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JOHN TYLER HIGH SCHOOL' ,`SchoolMiddle` = 'STEWART MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Cascades Add' ,`TaxAmount` = '45426' ,`TaxRate` = '2.0939' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085403' WHERE `Matrix_Unique_ID` = '209456009'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T15:46:34.337' ,`MLSNumber` = '86646691' ,`ListAgentFullName` = 'Stanley Cleberg' ,`ListOfficeName` = 'Fowler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.911221' ,`Longitude` = '-94.417082' ,`PhotoCount` = '22' ,`PostalCode` = '75938' ,`RoomCount` = '7' ,`ListPrice` = '55000.00' ,`Status` = 'Active' ,`StreetName` = 'Pitzer' ,`StreetNumber` = '607' ,`StreetSuffix` = 'Street' ,`City` = 'Colmesneil' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What could be done with a 1880\'s Dogtrot home? This 3-bedroom 1 bath house needs someone with vision to bring it to new glory. There is a lot of original flooring, ceiling and wall woodwork, some original doors, with 10 1/2-foot ceilings. Additional space added with a second floor used as a game room and multi-purpose room. The tract is within the city limits of Colmesneil, has city water, power on the property, and on septic system. The oversized lot is 1.03 acres with grand magnolias, pecan, and huge live oak trees. Come out and look so call for an appointment.' ,`Acres` = '1.03' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S5020 OGDEN ADDITION SEC 1 (A796), BLK 1, LOT 1,2,3,4,5,6,7,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44867' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '427 - Colmesneil' ,`SchoolElementary` = 'COLMESNEIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLMESNEIL HIGH SCHOOL' ,`SchoolMiddle` = 'COLMESNEIL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Craftsman' ,`Subdivision` = 'Ogden Add' ,`TaxAmount` = '1269' ,`TaxRate` = '2.0383' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1880' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675085403' WHERE `Matrix_Unique_ID` = '210548051'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T15:48:37.040' ,`MLSNumber` = '25775258' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Milagros Mancia' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.402717' ,`Longitude` = '-95.070326' ,`PhotoCount` = '31' ,`PostalCode` = '77568' ,`RoomCount` = '15' ,`ListPrice` = '449717.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sorico Bay' ,`StreetNumber` = '13621' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Alden II, Elevation BL) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room with tall ceilings and a private Study. Spacious island kitchen open to Family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious Game room, and media room on second floor. Covered patio and 2 car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085403' WHERE `Matrix_Unique_ID` = '210862301'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T15:41:48.880' ,`MLSNumber` = '27487886' ,`ListAgentFullName` = 'Lori Tribe' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.440740' ,`Longitude` = '-95.615015' ,`PhotoCount` = '40' ,`PostalCode` = '77356' ,`RoomCount` = '13' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Water St West' ,`StreetNumber` = '132' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOLIDAY SPECIAL! Reduced Price With a Holiday twist! \r\nYour Piece of Lake Conroe Paradise has arrived! MOVE IN READY! Same family has owned this home from original construction, they say it\'s time! This home has a WALL OF WINDOWS on both upper and lower levels bring in an ABUNDANCE OF NATURAL LIGHT. This OPEN CONCEPT HOME boasts not only of 3 bdrm/3 bath but an amazing lower level \"FLEX ROOM” - this is a GREAT SPACE  FOR ENTERTAINING, etc. Enter \"Flex room\" from OVER-SIZED GARAGE or backyard stairs and use the INDOOR STAIRCASE ACCESS to the \"living\" area of the home, or use the outside stairway to the upper level deck and entry through the front door or additional staircase to the flex room. Property has bulk-heading with plenty of yard space to create your own custom patio deck, fishing pier, and/or boat slip. Community has private boat ramp,& LOW HOA FEES. LET YOUR LAKE CONROE WATERFRONT DREAM BECOME A REALITY!' ,`Acres` = '0.1208' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR WATER COVE, BLOCK 2, LOT 18' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '5263' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`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` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Water Cove' ,`TaxAmount` = '6450' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085403' WHERE `Matrix_Unique_ID` = '211334462'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T15:50:18.377' ,`MLSNumber` = '58718948' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Adebayo Adebowale' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.680887' ,`Longitude` = '-95.831612' ,`PhotoCount` = '9' ,`PostalCode` = '77406' ,`RoomCount` = '17' ,`ListPrice` = '557547.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rigel Ridge' ,`StreetNumber` = '10538' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Alden, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4 baths.  First floor study. Spacious island kitchen open to family room and informal dining room. Primary suite with large walk-in closet. Upstairs game room and media room. Covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 44 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6956' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085404' WHERE `Matrix_Unique_ID` = '211351966'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T15:19:26.163' ,`MLSNumber` = '35095288' ,`ListAgentFullName` = 'Joel Arredondo' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154556' ,`Longitude` = '-95.291127' ,`PhotoCount` = '28' ,`PostalCode` = '77365' ,`RoomCount` = '2' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Hills' ,`StreetNumber` = '18462' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE!! Ready for new owner!!  House has been remodeled with a new roof, New exterior siding with windows. \r\nOpen concept kitchen view to the dining area and living area. NEW Central AC/HEAT. No carpet here!! Ceramic tile flooring throughout the house. Plumbing and wiring have been redone.\r\nNew kitchen cabinets with Granite countertops new light fixtures and ceiling fans in the bedroom.' ,`Acres` = '0.2649' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROLLING HILL OAKS 01, LOT 44' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11538' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Hill Oaks 01' ,`TaxAmount` = '1793' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085404' WHERE `Matrix_Unique_ID` = '212735161'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T16:20:53.507' ,`MLSNumber` = '89875755' ,`ListAgentFullName` = 'Robert Wood' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785706' ,`Longitude` = '-95.406386' ,`PhotoCount` = '6' ,`PostalCode` = '77007' ,`RoomCount` = '2' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Herkimer' ,`StreetNumber` = '813' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sold for lot value only...' ,`Acres` = '0.1741' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 239 HOUSTON HEIGHTS 71ST AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7582' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '9480' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085404' WHERE `Matrix_Unique_ID` = '213325097'  --> 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','213743352','1675085404','213743352','2022-11-29T15:00:38.707','47936225','Karen Flowers','Joe Tramonte Realty, Inc.','','','29.167257','-94.996438','50','77554','8','2400000.00','Active','De Vaca','18519','','Galveston','4','0','5','4758','Single-Family','Come see this luxury first-row, beachfront home with stunning views in Indian Beach!! All furnishings will convey. The gourmet Kitchen opens to the Dining and Family Rooms with Fireplace, built-ins, and floor-to-ceiling windows facing the beach. Kitchen has extra-large butcher-block island with comfortable seating for 4, Stainless Steel appliances, custom cabinetry and light fixtures. Extremely high ceilings accent the exceptional architectural design. Enjoy your morning coffee and afternoon sunsets overlooking the beach from the large deck. This 5-Bedroom, 4-Bath home makes a perfect Family Retreat. This home has electric storm shutters on all windows. 2-car garage with additional parking under the home. Outdoor shower on ground level for rinsing off after a day at the beach. This MOVE-IN READY home is perfect for all your Coastal Entertaining.','0.624','33','','','Electric Dryer Connections,Washer Connections','','Estate,No Disclosures','1','Mock Fireplace','1','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 49 BLK 1 INDIAN BEACH SEC 2','Subdivision Lot,Water View,Waterfront','27181','Appraisal District','','380','0','','2','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Back,Supra Keybox','Appraisal District','2','Contemporary/Modern','Indian Beach 2','38984','2.0324','Septic Tank','1988','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T16:34:38.957' ,`MLSNumber` = '17833367' ,`ListAgentFullName` = 'Charles Pritchett' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.162412' ,`Longitude` = '-95.615721' ,`PhotoCount` = '9' ,`PostalCode` = '77486' ,`RoomCount` = '7' ,`ListPrice` = '357500.00' ,`Status` = 'Active' ,`StreetName` = 'Merion' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Lane' ,`City` = 'Columbia Lakes' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2 Merion Lane. This charming and well-maintained two-story home is situated on a 1/2-acre lot in the gated community of Columbia Lakes. 3 bedrooms, 2 1/2 bath Includes Plantation shutters throughout, built in entertainment and fireplace, shiplap and crown molding. Bamboo and Slate flooring in living and kitchen area. Granite countertops. Bonus room could be used for office, work out or game room. New A/C in 2021, Brick and Hardy exterior, Sprinkler system throughout the yard, water softener, Security System. Garage includes extra storage. Backyard is spacious, beautifully landscaped, fenced and ready to relax and entertain. This HOA subdivision has an attended front gate, swimming pool, great walking, running, biking and golf cart riding as well as Lagoons for fishing. This remarkable home is a must see! Owners are motivated!' ,`Acres` = '0.5233' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 1 (A0133 M VARNER) BLK 3 LOT 47-48' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '22795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '205' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '5522' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085404' WHERE `Matrix_Unique_ID` = '214378550'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T16:18:52.797' ,`MLSNumber` = '95648705' ,`ListAgentFullName` = 'Vanessa Darko' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.977357' ,`Longitude` = '-95.405062' ,`PhotoCount` = '6' ,`PostalCode` = '77073' ,`RoomCount` = '4' ,`ListPrice` = '269700.00' ,`Status` = 'Active' ,`StreetName` = 'Verde Trails' ,`StreetNumber` = '1110' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking to expand your real estate portfolio? If so, then this well-maintained, 4 bedroom, 2.5 bath corner lot property would make a GREAT addition! The property is tenant-occupied, so please call for more information or to schedule a tour.' ,`Acres` = '0.0863' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 5 REMINGTON RANCH SEC 12 AMEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '570' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HOYLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch' ,`TaxAmount` = '4529' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085405' WHERE `Matrix_Unique_ID` = '214662914'  --> 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','214921605','1675085405','214921605','2022-11-29T15:42:30.407','27856997','John Bennett','UHS Properties, LLC','','','29.856692','-95.456066','16','77091','3','229000.00','Active','Garapan','3118','Street','Houston','2','0','3','1432','Single-Family','You will love this charming, 1 story Home within the Yorkdale Subdivision of Harris County Texas. No HOA. This 3 bedroom home has all the open space to move around and about. (Room sizes are approximates only) Awesome natural lighting throughout the house. Situated in a friendly community within the HISD school district. Minutes aways from major highways, quick access to Houston downtown. Seller\'s notes:  3.5 car garage. Not on HCAD. Might even qualify for a 4 car corner lot. Next to garage is backyard access for boat or trailer. Home was fully remodeled 3 years ago, New kitchens, baths, AC and ducts, flooring, tile etc...  Don\'t miss out on this opportunity!\r\nThis house is part of a larger portfolio of 20+ homes (Serious inquires only)','0.1791','9','','','','','No Disclosures','1','','','Northwest Houston','Central Gas','0','LT 19 YORKDALE TR A U/R','Other','7800','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','HARRIS ACADEMY','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Yorkdale Tr A U/R','3505','2.5119','Public Sewer,Public Water','1966','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','215166840','1675085405','215166840','2022-11-29T16:38:34.603','50014856','Nancy Lawrence','Lawrence Realty','','','31.414796','-95.596265','49','75844','3','789000.00','Active','Murray','407','Drive','Grapeland','3','0','3','1407','Single-Family','This three bedroom, three bath A-frame home has big, beautiful windows in the living area along with a stone wood-burning fireplace looking over Houston County Lake. The kitchen is open and large with nice custom cabinets and lots of countertop space for the cook in the family. There are two bedrooms downstairs; the master bedroom has a full bathroom with walk-in shower and great closet space. The guest bedroom downstairs has its own hallway bathroom. The upstairs loft has plenty of room and a full bath. In the guest home, there are two bedrooms that share a full hall bath. The oversized garage is built for the handyman in the family with great storage. On the property, you will love the outdoor porch and the grand yard overlooking the lake. This property includes one and one-half lots totaling 1.063-acres.Down by the water, you will find a boat dock and boat storage with a single boat slip and boat lift. Total living sq.:2,191 - 1,407 sq.ft. main home; 784 sq.ft. guest home.','1.063','41','','','','','Estate','','','','Grapeland Area','Central Electric','0','PINEY POINTS LOTS 24 & PT LOT 25','Subdivision Lot,Waterfront','46304','Appraisal District','','75','0','','2','','0','','','','','Aluminum','58 - Grapeland','GRAPELAND ELEMENTARY SCHOOL','GRAPELAND HIGH SCHOOL','GRAPELAND JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1.5','Traditional','Piney Point','4667','1.6377','Public Water,Septic Tank','1978','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','215169295','1675085405','215169295','2022-11-29T15:48:43.750','26462423','Cori Radley','Cori Radley & Co','','','29.207391','-96.266921','9','77437','3','235000.00','Active','Trochta','801','Street','El Campo','2','0','3','1797','Single-Family','If you are looking for a spacious home close to the center of El Campo, this is the property for you! It has only been lived in by one owner and has been very well maintained. \r\n\r\nThe primary bedroom features a walk-in closet and en-suite bathroom with a sink vanity and tub/shower combo. The two spare bedrooms are located on the opposite end of the home and share a hallway bathroom.\r\n\r\nThe kitchen sits in the center of the home between the formal living room and the larger living room and dining area near the back entrance. The laundry room offers plenty of storage space with one closet that is big enough to transform into a craft area.\r\n\r\nThe backyard features a covered patio deck and a large fenced-in backyard, but the main focal point is the detached workshop. It has running water, electricity, and is sectioned into two rooms; one side has a rolling garage door. This space can be converted into a guest suite, gym, or continued to be utilized as a shop.','0.3765','55','','','','','Other Disclosures,Sellers Disclosure','','','','','Central Gas','0','TROCHTA 2ND BLOCK 1 LOT 17,18','Other','16400','Appraisal District','','','0','','2','','0','','','','','Composition','198 - El Campo','','EL CAMPO HIGH SCHOOL','EL CAMPO MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Right Side,Vacant/Unoccupied','Appraisal District','1','Traditional','Trochta 2nd','4035','2.3981','Public Sewer,Public Water','1954','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','215173972','1675085405','215173972','2022-11-29T16:16:04.917','67763232','Nancy Lawrence','Lawrence Realty','','','31.316052','-95.441505','50','75835','4','415000.00','Active','Grace','141','Street','Crockett','4','1','4','3460','Single-Family','The welcoming front porch greets you as you enter this four bedroom, four and one-half bath, two-story home with frontage on South Grace Street and East Goliad Avenue. The owner has recently painted the exterior of the home and installed a new composition shingle roof. Downstairs, you will love the tall ceilings and brick flooring. The formal living and dining rooms have hardwood floors. The master suite boasts a full bath. There is a study and a den with lots of windows that bring the outside in, as well as another full and half bath to serves guests well. Upstairs, there are three bedrooms and two full baths – one could be as a second master suite with its private bath. Outdoors, you will find a 2-car garage with an attached 4-car carport, as well as a detached garage with a two-bedroom, one bath apartment. The apartment interior has been recently painted and has a private driveway entrance – it would rent easily if you’re looking for additional income! Call today!','1.218','41','','','','','Sellers Disclosure','','','','Crockett Area','Central Electric','0','SMITH ADD LOT 15 BLK 1','Other','','','','','0','','2','','0','','','','','Composition','57 - Crockett','CROCKETT ELEMENTARY SCHOOL (CROCKETT)','CROCKETT HIGH SCHOOL (CROCKETT)','CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)','Appointment Required','Appraisal District','1','Traditional','NONE','4767','2.3627','Public Sewer,Public Water','1950','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','215173988','1675085405','215173988','2022-11-29T16:54:30.637','90776016','Ronnie Matthews','D.R. Horton Homes','Tina Saalwaechter','Coldwell Banker Realty','30.246612','-95.200545','7','77372','3','217590.00','Pending Continue to Show','Upper Gardenia Lane','14129','','Splendora','2','0','3','1296','Single-Family','WONDERFUL NEW D.R. HORTON BUILT 1 STORY! Fantastic Open Concept Interior Layout! Beautiful Finishes with espresso colored cabinetry and Stainless Steel Appliances! Lovely Foyer Opens to Island Kitchen with Spacious Corner Pantry, Dining Area, & Large Living Room! Privately Located Primary Suite Features Oversized Shower & Walk-In Closet! Spacious Secondary Bedrooms! Great Guest Bath with Tub/Shower Combo! Indoor Utility Room! Covered Patio Overlooks Tranquil Backyard! Landscape Package Included!','','40','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 32 Block 1','Subdivision Lot','','','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','47 - Splendora','PINEY WOODS ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required','Builder','1','Traditional','Presswoods','','','Water District','2022','Builder');  --> New record created successfully<br />