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

700 Wahoo
Saint Marys, GA 31558
Sevgi Carnevale with ERA Kings Bay Realty, original listing - (912) 729-2266

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,195,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3260 Square Feet
Agency: ERA Kings Bay Realty
Agency Phone: (912) 729-2266

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: A dream home with an architectural Greek Revival look in Cumberland Harbour subdivision in St Marys, GA. This home will be beyond your expectations and will leave you speechless as you walk in the foyer facing the majestic 11' high ceilings, crown moldings, carved casings around the doorways, coffered ceilings and hand scraped hickory plank wood floors. The features and details of this home cannot be described in words, you must experience it to appreciate the architectural designs in this one-of-a-kind home. Main floor has a large foyer that leads to a formal living room on the right and formal dining room on the left. Both with coffered ceilings, crown moldings, and chair railings. From the foyer you will face the beautiful stairs that lead to the second floor which has 3 bedrooms, 3 baths and a loft area that can be used as a library. Each bedroom has private full bath. Double doors open to a true master suite with sitting area, large master bath featuring double vanity, tub, shower and walk-in closet. On the first floor a wide hallway from the foyer leads to a large family room with full masonry fireplace with gas hook up and a cook's dream kitchen with granite counters, stainless steel appliances, an island bar, gas stove and butler's pantry and overlooks the inground pool and garage apartment. Detached two car garage with a tastefully furnished 650 sqft guest room with a bath and kitchenette. Wrought iron fenced yard. Sprinkler system, water softener, plantation shutters throughout. Metal roof and porches on the front and back of the home. Gated community, agent must accompany buyers when viewing.
MlsNumber: --
ListingId: 10489502


Listing Provided By: ERA Kings Bay Realty, original listing
Phone: (912) 729-2266
Office Phone: (912) 729-2266
Agent Name: Sevgi Carnevale
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