Title Page Background
DEBUG FN args: Array ( [0] => 357 [1] => [2] => [3] => agent ) BEFORE: Site: 357 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 357 Igate: njhud LocID: 357 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 357 AND i.igate IN ('orhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 357 [1] => [2] => [3] => lender ) BEFORE: Site: 357 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 357 Igate: njhud LocID: 357 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 357 AND i.igate IN ('orhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 357 [1] => [2] => [3] => other ) BEFORE: Site: 357 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 357 Igate: njhud LocID: 357 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 357 AND i.igate IN ('orhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'orhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

006 Brushy Hammock
Mayo, FL 32066
Gary Silvernell with FARM & FOREST BROKERS, LLC, original listing - (334) 247-2005

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $245,600
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: FARM & FOREST BROKERS, LLC
Agency Phone: (334) 247-2005

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 49 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Welcome to your natural paradise! Brushy Hammock Farms is now offering multiple lot configurations for your new rural escape! Whether you're looking for peace and quiet to build your country home, adventure and recreation, or just a place to bring the camper and get away from it all, these properties have what you're looking for! Farm Lot 6 is 49.12 acres MOL with a diverse mixture of young and old planted pine, and beautiful mature hardwoods, including some ancient Old Florida live oaks. Direct access onto a county-maintained road with power makes home-site placement a breeze. The property backs up to Brushy Hammock, a natural buffer and wildlife paradise providing seclusion and natural beauty. Enjoy watching deer, turkey and more from the comfort of your back porch. A small open-water pond adds even more appeal as a fishing hole and watering source for wildlife. Brushy Hammock Farms is located in Lafayette County, FL, centrally located with easy access to the best Florida has to offer. Whether you're looking to make day trips to the Gulf of Mexico for world-class fishing and seafood, or want access to a rural lifestyle within a half-day's drive to major Florida cities like Tampa, Orlando, Gainesville, Jacksonville and Tallahassee, you can't go wrong with these properties. Give us a call today to discuss available lots and to schedule your tour!
MlsNumber: --
ListingId: 11421131


Listing Provided By: FARM & FOREST BROKERS, LLC, original listing
Phone: (334) 355-2124
Office Phone: (334) 247-2005
Agent Name: Gary Silvernell
Disclaimer: Copyright © 2025 My State 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