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 = 368 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 = 368 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 = 368 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;

44589 Sandy Ford Road
Callahan, FL 32011

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,395,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2688 Square Feet
Agency: BERKSHIRE HATHAWAY HomeServices CWREI
Agency Phone: (904) 753-1415

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: WELCOME TO DE LUNA FARM, YOUR LUXURIOUS EQUESTRIAN ESTATE! THIS STUNNING PROPERTY SITUATED ON 1O ACRES OF SCENIC, CLEARED LAND, OFFERS AN EXPERTLY UPGRADED COUNTRY HOME AND STATE OF THE ART FULLY FUNCTIONING HORSE FACILITY, JUST 3 MILES FROM TOWN! AS YOU DRIVE UP THE LONG DRIVEWAY YOU WILL BE GREETED BY LUSH HORSE PASTURES, A STOCKED POND, AN IMPRESSIVE NO EXPENSE SPARED FULLY RENOVATED FARMHOUSE WITH UPSCALE FINISHES THROUGHOUT, A GOURMET KITCHEN WITH LARGE PANTRY, CUSTOM CABINETRY, AN OPULENT MASTER BATH WITH HEATED MARBLE FLOORS, AND A TAILOR MADE CUSTOM BUILT SPIRAL STAIRCASE. ADJACENT TO THE MAIN HOUSE IS A LAVISH HOME THEATER MEDIA ROOM AND SEPARATE PRIVATE OFFICE. STEP OUT INTO YOUR OWN OASIS WITH AN OUTDOOR RESORT STYLE ENTERTAINMENT AREA WITH PERGOLA, A SPECTACULAR CUSTOM SALT WATER POOL, AND A SPA. YOUR HORSE FACILITIES FEATURE AN AMISH BUILT BARN (2021) WITH 5 STALLS- MATTED W/DUTCH DOORS, TRIPLE WALL KICK BOARDS, 10' OVERHANG WITH 3 ATTACHED RUN OUTS-SEPARATE PADDOCKS, A TACK ROOM, CUSTOM WASH RACK STALL W/DRAIN, A LARGE LOFT LIVING SPACE, STORAGE, WI-FI, CAMERA AND AN OPEN AIR ARENA. THE PROPERTY INCLUDES 5 METICULOUSLY MAINTAINED FENCED PASTURES WITH HIGH AND DRY TOPOGRAPHY SLOPING TO THE REAR RIGHT OF THE PROPERTY FOR WET WEATHER. STRUCTURES INCLUDE 1- BARN, 1- LARGE POLE BARN, 3- EQUIPMENT SHEDS, PLUS STALLS AND RUN-INS IN THE PASTURES, EACH BUILDING HAS WATER AND ELECTRIC. ADDITIONAL AMENITIES INCLUDE 400 AMP ELECTRICAL SERVICE, NEW 30 YEAR ARCHITECTURAL ROOF (2024), DEEP WATER WELL (2021), A 2ND POTENTIAL IRRIGATION WELL, NEW EXTERIOR PAINT (2023), AND AN OVERSIZED GARAGE. THIS IS YOUR MOMENT TO OWN THIS GOLDEN HORSE FARM AND ESTATE. SCHEDULE YOUR PRIVATE TOUR TODAY!
MlsNumber: --
ListingId: 108683


Listing Provided By: BERKSHIRE HATHAWAY HomeServices CWREI, original listing
Phone: (904) 753-1415
Office Phone: (904) 753-1415
Agent Name: Eric Davis
Disclaimer: Copyright © 2024 Amelia Island-Nassau County 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.


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 = 368 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 Steve Ogden
Steve Ogden
ASCIIkeller williams Atlantic Partners
Call Today!: (904) 583-4314

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App