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

4820 10th St
Bell, FL 32619
Janie Moore with Spring Time Realty LLC, original listing - (352) 463-0880

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2688 Square Feet
Agency: Spring Time Realty LLC
Agency Phone: (352) 463-0880

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 33 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Luxurious 4 bedroom pool home on 33 private acres in desirable Gilchrist County! The long tree lined private driveway leads to your country oasis, and beckons you to slow your pace, and soak up the serenity of this lovely estate. As you enter through the front door, you will be greeted with a spacious open concept floor plan which features separate living and family rooms, formal dining room, and an enclosed porch that leads to the in ground caged pool with soothing water fountain feature. The kitchen is the heart of this home, is loaded with cabinetry, and includes an island with seating, stainless steel appliances, including a 6 burner oversized gas range! There is an attached garage and separate laundry room too! The master suite is large, and features a garden tub, separate shower, and matching his and hers walk in closets. Outside you will find lovely large oak trees that add ambience to the landscape, shade, and a haven for wildlife! There is a huge 40x100 metal outbuilding that is partially enclosed and could be used for farm equipment storage, extra vehicles, or a barn for livestock/horses. The home and amenities are carefully tucked away near the center of an otherwise heavily treed property, for maximum privacy and seclusion from the outside world. Gilchrist County is a wonderful place to live, raise a family or retire, and features low property taxes, A rated schools, and numerous rivers and fresh water springs for your summertime enjoyment. The North Central Florida climate provides a nice change of seasons, without the stress and mess of snow. Located about 40 minutes west of Gainesville, about 1 hour to the Gulf Coast, about 2 hours to the Atlantic Coast, and about an hour and a half to the World Equestrian Center in Ocala. If you are looking for a private oasis, away from the hustle and bustle of city life, don't miss the opportunity to preview this lovely estate!
MlsNumber: --
ListingId: 791218


Listing Provided By: Spring Time Realty LLC, original listing
Phone: (352) 210-8038
Office Phone: (352) 463-0880
Agent Name: Janie Moore
Disclaimer: Copyright © 2024 Dixie-Gilchrist-Levy Multiple Listing Service. 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