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

6359 Sw County Road 307
Trenton, FL 32693
Scott Coldwell with COLDWELL REALTY SOLD GUARANTEE, original listing - (352) 209-0000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $11,900,000
Beds: --
Baths: --
Status: Active
SqFt: 13525 Square Feet
Agency: COLDWELL REALTY SOLD GUARANTEE
Agency Phone: (352) 209-0000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 192 acre(s)
Property Type: Commercial Sale-Mixed Use
Year Built: 1966
Notes: Breathtaking 192 acre Equestrian Estate and Event Center! This massive 13,500 square foot estate home is perfectly set up for either private use or as a large event facility and Inn. The exterior boasts acres of 4 board fencing that was replaced in 2017, 8 septics with lift station, 5 WELLS replaced in 2022, one of which is EPA monitored, three 500 gallon diesel fueling tanks, 2 hay barns with NEW METAL ROOFS and a 10 space RV PARK. The 7 AC UNITS were all added and replaced in 2018 and the NEW ROOF was installed in 2022. The larger center aisle barn is 23 stalls, tack room and wash areas with a 3 bedroom 2 bath apartment. The smaller barn is 16 stalls with tack room and a 1 bedroom apartment. Both barn apartments have full kitchens. There is 90 acres of coastal hay that is currently being harvested and sold. The property has also been approved for 10 additional units on the property. The main home is nothing short of spectacular! There was a nearly 6000 square foot addition added in 2018. The 12 bedrooms all have en suite baths with additional 1.5 bathrooms. The home is currently being used as an event center with a welcome center in the foyer. The entire home is beautifully adorned with imported Mexican Tile. Each bedroom is themed with different states and countries and are perfect for large parties. Three of the 3rd level rooms all have balconies and access to the 100 foot long balcony with extraordinary views! The BRIDAL SUITE is magnificent with its own private deck, small kitchen, jacuzzi tub and large walk in closets. The Dining Hall has a 100 person capacity and there is a commercial kitchen with a 1500 gallon grease trap and separate commercial kitchen storage areas which are equipped to handle large scale events. Just off of the dining hall is the outdoor Tiki Bar with beer draft, full bar and large seating capacity at the bar. There is ample amounts of covered lanai seating and a massive outdoor entertainment area that is large enough for very large events. Also, there are 2 covered 8 person Hot Tub pavilions. The propane generator is large enough to run the entire main home. Just off the outdoor area is a newly constructed event partially enclosed event center that hosts concerts, weddings and large corporate events. There is also a gift shop and an ice cream shop! The main gated entry to the property is completely lined with mature, canopied oaks for a magnificent drive down the 1/4 paved driveway. The possibilities with this property are too many to mention. All furnishings and farm equipment are included with full price offer.
MlsNumber: --
ListingId: OM690886


Listing Provided By: COLDWELL REALTY SOLD GUARANTEE, original listing
Phone: (352) 209-0000
Office Phone: (352) 209-0000
Agent Name: Scott Coldwell
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 = 344 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 Kristal Blair
Kristal Blair
ASCIIBetter Homes and Gardens Real Estate Thomas Group
Call Today!: (352) 283-5813

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App