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;

4689 18th Trail
Trenton, FL 32693

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2448
Agency: Deen Lancaster Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 24 acre(s)
Property Type: Residential
Year Built: 2007
Notes: FIRST TIME AVAILABLE! This custom 4 bed/3 baths Key West style home has 2450 sqft of heated & cooled area with 1100 sqft of porches. The home is nestled on 24 acres with lots of beautiful large oaks and a natural prairie. The property bustles with wildlife and is located next to a 3,000+ acre private preserve. The high ceiling porch and 8' custom double doors greet you at the entrance. The heart of the home is the great room with 10+ft ceilings, crowned by a stunning 20+ft cupola that invites the warmth of sunlight during the day and moonlight at nighttime. On cold nights enjoy the ventless gas fireplace. The kitchen features plenty of solid wood cabinets with granite counter tops. The five burner cook-top and large wall oven will please any chef. There is also a large pantry. The dining area is right off the kitchen and provides scenic views of the property. The owners' suite is oversized and includes a sitting area. Dual walk-in closets are located between the owners' bath. The owners' bath has a jetted tub, walk-in shower, linen storage and a water closet. Two of the guest bedrooms share a bath. The other has its own private bath. All of the guest bedrooms have walk-in closets. There is a half bath off of the great room for daily company. The house has a large screened lanai with French door access from the owner's bedroom, dining area and great room. This area is great for entertaining guest with ample views of the natural scenery. The immediate home site area is fully landscaped. Beyond the house there is a patio with a fire pit, an older house used for storage, a pole barn and a shed. Embrace the outdoors with every glance through the windows, a symphony of nature's beauty awaits. Covered in wildlife, this property is a sanctuary for those seeking a connection to the environment. Whether you're relaxing on the porch or exploring the acres of land, each moment is an opportunity to immerse yourself in the wonders of the wild. The property is close to many natural springs along the Santa Fe and Suwannee Rivers and less than 15 minutes to High Springs, Newberry, Ft White, Bell and of course Trenton. Gilchrist County is an “A” rated school district! Don't miss the chance to make this exceptional property yours, where the grandeur of nature meets the luxury of home. Contact us today to schedule a viewing and step into a world of unparalleled beauty and comfort.
MlsNumber: 790693


Listing Provided By: Deen Lancaster Realty, Inc., original listing
Name: Deen Lancaster Realty, Inc.
Phone: (352) 463-9494
Office Name: Deen Lancaster Realty Inc.
Office Phone: (352) 463-9494
Agent Name: Deen Lancaster
Disclaimer: Copyright © 2024 Dixie-Gilchrist-Levy Multiple Listing Service. 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