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;

908 Larkspur Lane
St Marys, GA 31558

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $742,600
Beds: 4
Baths: 4
Status: Active
SqFt: 3453
Agency: DeLoach Sotheby's International Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1998
Notes: Welcome to your dream home in the gated Osprey Cove community! This stunning 2-story, completely brick residence boasts 3,454 square feet of updated living space. With 4 bedrooms and 3.5 bathrooms, this residence provides the perfect blend of luxury and comfort.<br /> You step inside, and greeted by a grand staircase, formal dining room and formal living room with soaring ceilings. The primary bedroom and bathroom, conveniently located on the first floor, serves as a relaxing oasis with a brand new soaking tub, separate shower, 2 walk in closets and double sink vanity. <br /> <br /> The kitchen offers an island, stainless steal appliances as well as a breakfast bar and eat in kitchen. <br /> <br /> The family room is adorned with a cozy fireplace, creating a warm and inviting space to relax and unwind. Additionally, an entertainment room upstairs has the ideal setting for family movie nights or gatherings with friends.<br /> <br /> This home is designed for modern convenience. The 3-car garage comes equipped with power already installed for an electric car charging port, showcasing a commitment to sustainability.<br /> Upstairs there are two walk-in attic spaces with ductwork already run to them, providing an excellent opportunity to finish them and create additional square footage tailored to your needs.<br /> <br /> Updates abound in this residence, including newer air conditioning units and a recent roof replacement, ensuring peace of mind for years to come.<br /> One of the many highlights of this property is the ability to witness both sunrise and sunset from the comfort of your own home, thanks to its location on the golf course and marsh. The views add a touch of serenity to your daily life. And on top of all this, the seller is going to give $10K credit to the buyer.<br /> Schedule a showing today and step into the luxury and comfort you've been searching for!
MlsNumber: 1645572


Listing Provided By: DeLoach Sotheby's International Realty, original listing
Name: DeLoach Sotheby's International Realty
Phone: (912) 638-0406
Office Name: DeLoach Sotheby's International Realty
Office Phone: (912) 638-0406
Agent Name: Alissa LeClair
Disclaimer: Copyright © 2024 Golden Isles Association 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