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

27500 Se Highway 42
Umatilla, FL 32784
Arial Harrington with LPT REALTY, original listing - (877) 366-2213

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,000,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 3335 Square Feet
Agency: LPT REALTY
Agency Phone: (877) 366-2213

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Welcome to Lantern Hill Farm, a 10.97-acre equestrian estate in Umatilla, ideally situated across from the 100 mile White Trail in the renowned Ocala National Forest. This prime fully-fenced property is entirely in Flood Zone X and features a custom home, oversized 3 car garage, 1 bedroom apartment, 6-stall barn, arena, metal workshop, and 8 fenced paddocks, providing everything needed for horse enthusiasts. All buildings come with metal roofs. The elegant 2 story 4-bed, 2.5-bath residence boasts a gourmet kitchen, spacious living areas, and a downstairs master suite, all with panoramic views of the lush pastures from the covered wrap-around porch. The home comes with solar panels that generally provide credits and a 2017 HVAC. A breezeway connects the main house to the 3 car garage that includes a full bath and second laundry. Take the stairs above the garage to find a spacious 898 sq ft 1-bed apartment with full kitchen and bath, and dedicated 2018 HVAC. Walk through the shade trees and past the fenced arena to the 6-stall barn complete with center aisle, overhang and cross aisle. There’s ample storage with both a feed/tack room and an office with a full bath. All your farm equipment and toys can be kept safely in the enclosed 32x32 metal workshop with 2 rolling doors, electricity and sink. An additional lean-to off the side allows for hay storage or a boat/camper. On the other side is a RV pad and 220 hook up and separate septic system. This property feels very private in its park-like setting with no neighbors in sight. Located 17.5 miles from downtown Mount Dora and 50 miles from the World Equestrian Center in Ocala. 60 miles to Orlando Intl Airport. The estate offers potential income opportunities with the apartment, stalls/pastures, and RV hookup. This farm provides the ideal blend of luxury, functionality, and natural beauty, making it a unique opportunity for those seeking a tranquil, equestrian lifestyle. Contact us today to schedule a private tour and experience this exceptional property firsthand.
MlsNumber: --
ListingId: OM681670


Listing Provided By: LPT REALTY, original listing
Phone: (352) 272-7565
Office Phone: (877) 366-2213
Agent Name: Arial Harrington
Disclaimer: Copyright © 2024 Stellar MLS. 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 = 358 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 Alan Bird - "A man of His Word."  Broker Associate/Realtor GRI, ABR
Alan Bird - "A man of His Word." Broker Associate/Realtor GRI, ABR
ASCIIThe Real Estate Firm of Orlando
Call Today!: (407) 432-8303

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App