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

11274 Sw 106th Avenue
Hampton, FL 32044

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $600,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1360
Agency: Florida Homes Realty and Mortgage

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 32 acre(s)
Property Type: Residential
Year Built: 2019
Notes: Welcome to the epitome of country living! This expansive 32-acre property in Hampton, Florida, offers a unique opportunity to embrace the serene beauty of rural life. With 2 homes, a spacious pole barn, RV parking, and sprawling landscapes, this listing promises an idyllic retreat for those seeking an escape from city life.<br /> <br /> The main residence, a meticulously maintained home that feels like new, welcomes you with modern amenities and a comfortable layout. The second home, awaiting your personal touch, presents an excellent opportunity for customization and creative renovation. With a bit of tender loving care, it has the potential to become your dream home or a charming guest retreat.<br /> <br /> A highlight of this property is the generous pole barn, providing ample space for storage, equipment, or even a workshop. The RV parking adds to the convenience, making it easy to accommodate guests or indulge in your passion for road travel. Explore the vast expanse of over 32 acres, offering endless possibilities for outdoor activities. Whether you're looking to roam, hunt, or simply enjoy the tranquility of nature, this property provides the perfect backdrop for your rural lifestyle aspirations.<br /> <br /> Escape the hustle and bustle of city life and immerse yourself in the tranquility of Hampton, Florida. This listing is a rare gem that combines the best of both worlds - the comfort of a well-maintained home and the potential for creative expression in a second residence. Don't miss the chance to make this picturesque property your own and create memories that will last a lifetime. Contact us to schedule a viewing and experience the allure of country living at its finest.
MlsNumber: 2007550


Listing Provided By: Florida Homes Realty and Mortgage, original listing
Name: Florida Homes Realty and Mortgage
Phone: (904) 363-8395
Office Name: FLORIDA HOMES REALTY & MTG LLC
Office Phone: (904) 996-9115
Agent Name: MIKE JONES
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