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

542284 Lem Turner Road
Callahan, FL 32011

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 5
Baths: 4
Status: Active
SqFt: 3328
Agency: INI Realty Investments, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Property Type: Residential
Year Built: 1925
Notes: ''One of a kind'' doesn't do it justice! Nestled in the serene countryside of Callahan, Florida, this 17-acre ranch offers an idyllic retreat from the hustle and bustle of city life yet is minutes away from the international airport, JAX, and the amazing Amelia Island which was awarded a Top 3 Island in the US by Conde Nast! The centerpiece of this picturesque property is a charming 100-year-old 3 BR/2 BA farmhouse (approx 2,000 sqft heated/cooled), exuding timeless elegance and rustic charm. Next to the historic farmhouse is an amazing 30' pool with an 800 sqft composite deck which the whole family will enjoy all summer long. Take the short breezeway over to the spacious 24' x 34' covered carport & the 616 sqft heated/cooled 'Man Cave' which could easily be converted to a full 1 BR apartment with mini-kitchen if desired! Got an RV, boat, extra vehicles, equipment, and storage needs? We got you covered...18'W x 18' H x 50' L Metal Pole Barn with 50 amp plug, PLUS another 24' x 50' Storage Area with 10' x 20' shed, PLUS another 36' x 16' Garage, PLUS another 34' x 46' Carport Storage Area, PLUS another 19' x 61' covered parking area!! In addition, there are other outbuildings, pole barns, workshops, and storage sheds catering to the needs of small business owners, equestrians, or those seeking ample storage space. <br /> Need an in-law suite or something multi-generational for your own little family compound? We got you covered again! There is another additional 2 BR / 2 BA home with approximately 1,400 sqft towards the back of the property! <br /> The grounds offer so much more, you'll have to see to appreciate it all...custom landscaping and stonework, rose/flower garden, & a 100 year old historic barn will have everyone coming by for pictures! Palm trees, magnolias, pecan trees, orange & azaleas, plus one of the oldest oaks in the county (over 14' in circumference)! With no other visible neighbor, you'll love the peaceful rural lifestyle & serenity that these sprawling 17 acres provide. <br /> Whatever your dreams...hobby farm, multi-family living, or space to roam, this enchanting ranch presents a rare opportunity to embrace the timeless allure of country living in Northeast Florida!
MlsNumber: 2018038


Listing Provided By: INI Realty Investments, Inc., original listing
Name: INI Realty Investments, Inc.
Phone: (904) 318-9088
Office Name: INI REALTY
Office Phone: (904) 318-9088
Agent Name: MATTHIAS BERRANG
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.


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 = 368 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 Steve Ogden
Steve Ogden
ASCIIkeller williams Atlantic Partners
Call Today!: (904) 583-4314

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App