Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 520 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 520 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 520 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

110 Entrekin Lane
Cobb, GA 31735
Cheryl Apperson Mason with Lake Blackshear Mason Hughes Realty, Inc., original listing - (229) 273-4044

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $729,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Lake Blackshear Mason Hughes Realty, Inc.
Agency Phone: (229) 273-4044

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: If you long for exclusivity, tranquility, privacy, and luxury on an Island with main body views-a complete package with a megasized new boathouse, this is your rare opportunity! This is one of a kind dream property!! This home was custom built home was constructed with family and friends in mind!! This beautiful Louisiana Style Home with massive porches to allow for enjoyment year around, is nicely maintained and is sited on a 1.1 acre with 300 waterfront feet. The custom design allows for massive main body views. This home features, gorgeous wide plank oak flooring in the living areas, tall ceilings, beautiful custom trim, both an Open Front Porch & Back Screened Porch, deck & massive lounging & storage areas on the lower level. This gorgeous home has an open living room with gas logs with a beautiful large screened porch beyond.The large kitchen has a breakfast bar, walk in pantry, sitting area to be able to chat with guests while entertaining in the kitchen, & cheery dining nook.-This beauty has 3 bedrooms, 3 baths and a bonus room. There is a central vacuum throughout the main living area. There is a small greenhouse, a separate potting area, and lots of area for your garden or flowers. The lower level is a wonderful area as well with a full bath, a large enclosed storage room, and has approximately 2000 sq. ft of entertainment area. This home accommodates large families and event gatherings all under one roof-There is a long concrete driveway and parking area to accommodate lots of vehicles if required. Let the fun and entertaining begin now with the cooler temps-Call now!
MlsNumber: --
ListingId: 59161


Listing Provided By: Lake Blackshear Mason Hughes Realty, Inc., original listing
Phone: (229) 406-0203
Office Phone: (229) 273-4044
Agent Name: Cheryl Apperson Mason
Disclaimer: Copyright © 2024 Crisp Area Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App