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

5490 Steel Bridge Road
Macclenny, FL 32063
JORDAN FERIA with KELLER WILLIAMS ST JOHNS, original listing - (904) 515-2700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $985,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3439 Square Feet
Agency: KELLER WILLIAMS ST JOHNS
Agency Phone: (904) 481-8078

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: 13 ACRES OF HIGH AND DRY LAND! Welcome to your dream home! Experience the perfect combination of modern luxury and rural charm in this nearly-new farmhouse. Built just two years with 4 bedrooms, 4 bathrooms, an upstairs flex space, and a downstairs office or playroom, this home is designed for large families and/or multi-generational living. Enter through the private gated entrance and take in the stunning views of your expansive property as you approach the home. Walk up to the front porch with your own custom porch swing to drink your morning coffee and listen to the birds sing. Step inside through the elegant double front doors to an open and airy interior, featuring 10-foot ceilings and panoramic views of the backyard and sparkling pool. The home is beautifully finished with custom light fixtures and luxurious 9-inch vinyl plank flooring throughout—no carpet in sight. The chef's kitchen is a showstopper, offering top-of-the-line stainless steel appliances, including a ZLINE gas range and a convenient pot filler. The farmhouse sink and open shelving add to the kitchen's charm, making it the perfect space for cooking and entertaining. The oversized owner's suite is a peaceful retreat, bathed in natural light from three large windows and offering tranquil views of the surrounding landscape. Walk into your oversized ensuite bath and be amazed at the massive soaking tub, walk through shower and separate vanities. Walk in closet offers ample space and its very own quartz top island. On the right side of the home, you'll find two Jack-and-Jill bedrooms, each with its own vanity/sink and a shared bath/shower combination. On the left side, a separate guest suite with its own ensuite bathroom featuring stylish black and white porcelain floor tiles.<br /> <br /> Additional features include a detached 30x30 garage, ideal for hobbyists or mechanics, as well as a fenced animal enclosure (approx. 50x60) and a 16x20 building for animals. Plus, enjoy fresh eggs from your own chickens, housed in a charming coop.<br /> <br /> Thoughtfully designed with every detail in mind, this property offers an unmatched living experience. Schedule a tour today to see it for yourself!
MlsNumber: --
ListingId: 2060713


Listing Provided By: KELLER WILLIAMS ST JOHNS, original listing
Phone: (904) 651-6548
Office Phone: (904) 515-2700
Agent Name: JORDAN FERIA
Disclaimer: Copyright © 2024 Northeast Florida Multiple Listing Service, Inc. 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