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

5624 Long Marsh Dr
Elkton, FL 32033

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $468,400
Beds: 4
Baths: 2
Status: Active
SqFt: 1948
Agency: Atlantic Partners Realty St Augustine LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2010
Notes: Nestled In A Cul-de-sac And Right On The Edge Of A Pristine Golf Course In Cypress Lakes,This Beautiful 4bd/2ba Home Offers The Perfect Blend Of Comfort And Scenic Beauty. As You Step Inside This 1948 Sf Home,You're Greeted By A Spacious And Thoughtfully Designed Interior That Is Crafted To Meet The Needs Of A Modern Lifestyle. This Concrete Built Home Features A Split Floor Plan,Ensuring Privacy And Convenience For Everyone With The Kitchen At The Heart Of This Home. The Ample Dining Area Can Easily Accommodate A Table For 8 And Seamlessly Connects To A Charming Screened Lanai At The Back. This Covered Outdoor Space Is A True Oasis,Offering A Serene Setting To Relax And Entertain While Enjoying The Picturesque Views Of The Golf Course,Without Ever Having To Worry About The Elements. Whether You're Hosting A Family Gathering Or Simply Enjoying A Quiet Evening,The Lanai Serves As The Perfect Spot For Unforgettable Moments.,A Paver Drive Leads You To The 3 Car Garage Where You Can Easily Store Your Golf Cart And Family Car. As You Step Inside,You Will Find A Bedroom Right Off The Front Entry With The Versatility To Be A Guest Bedroom Or A Home Office,Followed By Two Additional Bedrooms And A Guest Bath. The Living Room Connects The Kitchen And Dining Area Making It Easy To Entertain Family And Friends,With The Kitchen Offering Everything You Need To Whip Up A Home Cooked Meal With Ss Appliances,A Gas Range And Plenty Of Counter Space To Accommodate A Few Helpers. At The Back Of The Home You Will Find The Master Bedroom With Its Private Bath That Features Split Vanities,A Walk-in Closet,Tiled Shower And Soaking Tub To Wash The Day Away. Tile And Laminate Floors Throughout Make Cleaning Up A Breeze. This Home's Location In A Cul-de-sac Not Only Ensures Minimal Traffic And Maximum Privacy But Also Provides A Sense Of Community And Safety,Making It Ideal For Both Growing Families And Those Seeking A Peaceful Retreat. Living Here Means Being Part Of A Vibrant Neighborhood That Values Leisure And Relaxation,With The Golf Course Right At Your Doorstep,A Community Pool And Clubhouse. Located Near I-95 Makes Your Commute Easy,And You Are Just Minutes From The Grocery Store And Dining. Enjoy!
MlsNumber: 239246


Listing Provided By: Atlantic Partners Realty St Augustine LLC, original listing
Name: Atlantic Partners Realty St Augustine LLC
Phone: (904) 797-7442
Office Name: Keller Williams St Augustine
Office Phone: (904) 797-7442
Agent Name: Noah Bailey
Disclaimer: Copyright © 2024 St. Augustine & St. John's County 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.


Local Real Estate Expert

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 = 378 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Real Estate Expert Photo for Georgina Essa
Georgina Essa
ASCIIRound Table Realty
Call Today!: (904) 629-8242

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App