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

160 Ne 165th Terrace
Williston, FL 32696

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 2
Baths: 2
Status: Active
SqFt: 1536
Agency: TOP PERFORMANCE Real Estate Consultants

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential
Year Built: 1986
Notes: Introducing your dream oasis! A picturesque single-family home on a eight-acres with the utmost privacy. This property combines the serenity of nature with the comfort of a 2 bedroom, 2 bathroom home with a basement that could be an additional living area, a game room or extra storage. Situated amidst a lush landscape, this residence offers a retreat from the bustling world outside. As you enter this charming home, you'll immediately notice the inviting atmosphere. The spacious living area provides a warm and cozy ambiance with a wood burning fireplace. Perfect for relaxing evenings or entertaining friends and family. Lots of natural light with views of the surrounding scenery. Both bedrooms are thoughtfully designed to provide a comfortable and peaceful space to unwind. Whether you envision strolling through serene walking paths, cultivating a garden, fishing from the pond stocked with tilapia, or simply enjoying the unspoiled beauty of nature, this property has it all. Privacy is paramount, and you'll find solace in the seclusion provided by this unique property. Located in a coveted area, this home offers rural beauty with convenient access to nearby amenities and only 30 minutes to Gainesville. Whether you seek a peaceful retreat or a haven for outdoor enthusiasts, this property fulfills those desires and more. Don't miss the chance to make this remarkable property your own; it's a rare gem offering a lifestyle coveted by many. Your dream oasis awaits! Devils Den Spring only 15 minute drive for diving and snorkeling enthusiasts.
MlsNumber: 827731


Listing Provided By: TOP PERFORMANCE Real Estate Consultants, original listing
Name: TOP PERFORMANCE Real Estate Consultants
Phone: (352) 746-9924
Office Name: Top Performance Real Est. Cons
Office Phone: (352) 794-6010
Agent Name: Kristina M Kydd
Disclaimer: Copyright © 2024 REALTORS Association of Citrus County, 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