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

3302 104th Street
Wellborn, FL 32094
Missy Zecher with REMAX PROFESSIONALS, INC., original listing - (386) 758-8900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,250,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5126 Square Feet
Agency: REMAX PROFESSIONALS, INC.
Agency Phone: (386) 758-8900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 123 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Experience the epitome of Southern living on this 123.89 +/- acre estate located in north Florida, a sanctuary where luxury, versatility, and natural beauty converge to create an unparalleled lifestyle. Entering this expansive estate, you're greeted by the majestic main home, boasting over 5,000 sq/ft. A sprawling front porch invites you to unwind in rocking chairs while soaking in the tranquil surroundings. The open-concept layout exudes a warm and cozy lodge ambiance, perfect for gatherings or quiet evenings. The owner's suite is conveniently located on the first floor. Step outside onto the spacious back deck, where a saltwater swimming pool awaits. A stroll away from the main house, a charming secondary home awaits, updated in 2004, featuring 3br/2ba. For the aviators there is a grass landing strip, and a third living area inside the airplane hangar. The 6,000 sq/ft hangar includes a 2br/2ba apartment, a safe room, and a full bath. A 2,400-square-foot workshop provides storage and activity space, a 1/2 bath and a climatized room for comfort. Equestrian enthusiasts will delight in the separate barn, offering water and power, catering to the needs of their horses. This remarkable estate doesn't stop there; it's a true investment opportunity with income-producing leases on the pines and straw. As you explore the grounds, you'll encounter pecan trees lining the drive, mature landscaping, 3 ponds and abundant wildlife. Additional 118 +/- acres available.
MlsNumber: --
ListingId: 122868


Listing Provided By: REMAX PROFESSIONALS, INC., original listing
Phone: (386) 623-0237
Office Phone: (386) 758-8900
Agent Name: Missy Zecher
Disclaimer: Copyright © 2024 North Florida 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