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

1161 Nw Jersey Road
Greenville, FL 32331

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,395,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2526
Agency: Robert Slack LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 92 acre(s)
Property Type: Residential
Year Built: 1999
Notes: Welcome to this immaculately maintained gated, ranch-style home and cattle farm overlooking 92.75 acres! This custom brick home boasts of solid wood custom cabinetry, trim, and cedar lined closets, large indoor utility/laundry room, walk in kitchen pantry, sunroom, two fireplaces, and three covered porches and home to the original owners. They even have the original floor plans to give you! Formerly the home of 50 head of angus cows, this farm comes with seven pastures, hay barn, tractor barn with power, shop and a meat processing kitchen with walk in freezer. Enjoy the rolling hills with majestic oaks, pastures, creek, and even your own private secluded wooded hunting space. The farm is also home to orange, lemon, pecan, wild plum, fig, grapefruit, hickory, crepe myrtle, white oak trees and a large garden plot. Be sure to view the aerial videos of the full property! Interior videos of out buildings available upon request. Showings by appointment only. Private well is 135 feet with the 5 hp pump at 105 feet. Additional outbuildings/features include: Shop - 43'x73' with full bath and RV hook up. Tractor Barn - 24'x64' - with 8 sets of double doors Cutting Kitchen (Meat Processing) - 14.5'x30' - Fully equipped with walk-in freezer (cutting tools/saws negotiable) Hay Barn - 30'x50' - holds 100 rolls of hay Chicken Coop - 16'x24' Garden Plot - 60x60 3 RV Hook Ups including one in the shop. Just 30 minutes to Valdosta, 1 hour to Tallahassee, north Florida private farm living to it's finest! Jersey Road goes from North 53 west and up to CR 150 near Cherry Lake Crossroads.
MlsNumber: 353070


Listing Provided By: Robert Slack LLC, original listing
Name: Robert Slack LLC
Phone: (352) 363-6982
Office Name: Robert Slack LLC
Office Phone: (954) 799-5698
Agent Name: Cindy Vees
Disclaimer: Copyright © 2024 Tallahassee Board of Realtors. 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