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;

8251 Ne 150th Avenue
Williston, FL 32696

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1728
Agency: Homes to Ranches Realty Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 2012
Notes: Welcome to Shell Pond Plantation, where rustic elegance meets the charm of countryside living on this 20-acre property. As you enter through the majestic stone-and-timber entrance, a picturesque oak-lined drive welcomes you to a haven that seamlessly blends rustic charm and refined surroundings. The focal point of the estate is a beautiful cypress log home, featuring 1,728 sq ft of living space and 3,904 sq ft under the roof. The home boasts a warm and inviting ambiance with an open floor plan, soaring vaulted ceilings, and exquisite woodwork throughout. Stately stone steps guide you to the wraparound porch and double French door entry, setting the tone for the elegance that awaits within. Inside, the living room is bathed in morning light streaming through angled ceiling-high windows, creating an expansive atmosphere. The kitchen is a focal point with granite countertops, beautiful cabinetry, and a paneled fridge that seamlessly blends into the design. The master bedroom offers views of the surrounding countryside, and French doors lead to a screened back porch— an ideal spot to relax and witness breathtaking sunsets. The master bath features a granite-topped double vanity and an elegantly tiled walk-in shower with a glass door. The second and third bedrooms also provide scenic views of the property, and the guest full bath is adorned with a granite countertop, lovely tile work, and a glass-door walk-in shower. A convenient laundry area leads directly to the attached carport, ensuring functionality. The property extends beyond the home, featuring a four-stall center aisle wood barn with a paneled tack room, a spacious workshop/storage room, and an attached lean-to for hay or equipment storage, a large, fenced pasture, a riding arena, and the shade of live oaks contribute to the pastoral ambiance of this captivating farm. Shell Pond Plantation is conveniently located just outside of Williston, offering easy access to various amenities. Additionally, it is within 45 miles to the Gulf of Mexico, 34 miles to Ocala, 30 miles to the World Equestrian Center, 25 miles to Gainesville, and 17 miles to the HITS showgrounds. This property invites you to experience the perfect blend of rustic elegance and tranquil country living.
MlsNumber: OM674903


Listing Provided By: Homes to Ranches Realty Inc, original listing
Name: Homes to Ranches Realty Inc
Phone: (352) 266-6180
Office Name: HOMES TO RANCHES REALTY INC
Office Phone: (352) 732-3276
Agent Name: Amy Lord
Disclaimer: Copyright © 2024 Stellar 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