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

6490 Ne 167th Avenue
Williston, FL 32696

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2280
Agency: Showcase Properties of Central Florida

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 50 acre(s)
Property Type: Residential
Year Built: 2013
Notes: A picturesque income-generating farm nestled in the serene landscapes of Central Florida, this expansive 50+ acre property in Williston offers a plethora of possibilities. Comprising two combined lots, the farm provides plenty of opportunity to multiple equine disciplines and other potential uses. Fenced and gated, a meandering tree-lined path guides you through the property's tranquil wooded areas which have abundant wildlife. Resting prominently on the property is a large central-aisle barn that features a total of 21 stalls, including three designated grooming stalls. The barn is also equipped with a feed and tack room, a convenient wash rack, and a spacious 2-bedroom barn apartment spanning 1,200 sq.ft. Adding to the equestrian appeal, the farm features 19 paddocks, each enclosed by either three-board fencing or top board and wire fencing. A 120 x 220' arena features GGT footing, perfect for year-round training and enjoyment. For additional accommodation, two charming cabins have been thoughtfully constructed. These cozy cabins, each offering 540 sq.ft. of living space. One of them features an inviting covered front porch, while the other boasts a larger wrap-around covered porch. Enhancing the versatility of the property, there are three RV hookups, complete with water and electric connections, providing an opportunity for seasonal rentals or extra accommodation when needed. Along the perimeter of the farm are bridle trails that offer a delightful opportunity to explore and experience the farm's tranquil, natural landscape. Conveniently located between Ocala and Gainesville, you'll find a variety of shopping and dining options within easy reach. This farm enjoys a countryside location that combines convenience with serenity. Just a short drive away, outdoor enthusiasts can explore nearby attractions like the Bailey Mine Trailhead, the trails of Goethe State Forest, and the Black Prong Equestrian Village. Discover a world of possibilities on this versatile farm!
MlsNumber: OM666837


Listing Provided By: Showcase Properties of Central Florida, original listing
Name: Showcase Properties of Central Florida
Phone: (352) 351-4718
Office Name: SHOWCASE PROPERTIES OF CENTRAL
Office Phone: (352) 351-4718
Agent Name: Liz Gray
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App