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','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

137 Phil Jones Sr
Cobb, GA 31735
Tamie Williams with HRP Realty, original listing - (478) 901-2091

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $889,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3200 Square Feet
Agency: HRP Realty
Agency Phone: (478) 901-2091

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Welcome to your dream lakefront retreat! This stunning, totally remodeled home offers everything you need for comfortable living, entertaining and outdoor enjoyment. The inviting beam-accented dining room features a convenient beverage station/coffee bar w/mini-fridge. Throughout the hoe, you will find new LVP flooring, tongue/groove ceilings, custom woven blinds, and a fully monitored security system w/outside cameras. The modern kitchen is a chef's delight, boasting stainless steel appliances, quart countertops, and a spacious walk-in-pantry. The expansive 800 sf primary suite is a sanctuary of peach and luxury, w/two cozy sitting areas, walls of windows that showcase breathtaking views of the lake, a custom chandelier, and French doors leading to the deck overlooking our sparkling gunite pool. The spa-inspired primary bathroom offers a double vanity and a massive tiled shower with dual shower heads, including a rain head. Two additional bedrooms provide ample space for family or guests. Bedroom two is generously sized w/a great closet, while bedroom three, the original primary suite, features a private bath w/a spacious tiled shower and two closets (one a walk-in). For more versatility, a loft area houses bedroom four, offering an ideal space for additional sleeping or home office. Step outside and you will find an outdoor kitchen, hand poured concrete counter-tops, built-in appliances including: Blackstone griddle, Blaze grill, and power burner all connected to a direct gas line-perfect for summer barbeques and gatherings under the covered porch. Relax by the gunite pool with water feature and tanning ledge. Host cozy nights around the fire pit, or enjoy the boathouse for easy access to the water. This property sits on a serene cove stunning views of the main lake, making it perfect for boating and exploring. With easy boat access to four nearby restaurants, you'll never run out of convenient dining options. The detached two-car garage with a breezeway adds convenience to this extraordinary home. An outside building keeps pool and lake toys easily accessible. Ready to step right into Lake Living? Let's chat about the boat (20ft deck, 200HP, 2017 Yamaha), lake toys and some furnishings! High elevation; did not flood in 1994. Don't miss out on this rare opportunity to own a slice of paradise--where comfort meets luxury and fun!
MlsNumber: --
ListingId: 10496977


Listing Provided By: HRP Realty, original listing
Phone: (478) 901-2091
Office Phone: (478) 901-2091
Agent Name: Tamie Williams
Disclaimer: Copyright © 2025 Georgia Multiple Listing Service. 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