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

28262 29th Lp
Branford, FL 32008
Cassie Reardon with Diamond CR Real Estate, original listing - (352) 658-7168

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1634 Square Feet
Agency: Diamond CR Real Estate
Agency Phone: (352) 658-7168

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: Discover the epitome of riverfront living in Ichetucknee River Estates, where this custom-built home seamlessly blends luxury and natural beauty. Embrace a lifestyle centered around the serene, spring-fed Ichetucknee River with this exceptional residence, featuring three spacious bedrooms, two beautifully appointed bathrooms with travertine flooring, and a charming loft. The grand living area with Rustic furnishings highlighted by a majestic real wood spiral staircase and cathedral ceilings, opens to panoramic river views that captivate from every angle. Cozy up by the gas fireplace or entertain effortlessly in the open-plan kitchen, complete with real marble counters, maple cabinets, and an island perfect for gathering. Step outside to the full wrap-around porch and fully immerse yourself in the tranquil surroundings, supported by modern comforts like a Generac generator, Pecs Waterline, power and water surrounding the home, and power and lights under the house with plenty of room for parking and storage. Follow the walkway to your private 3-tier dock, where the top deck offers breathtaking river views and encounters with playful otters, gentle manatees, and a variety of river wildlife. The middle deck is ideal for unwinding with a snack or drink, while the lower deck provides easy access for swimming, tubing down the crystal clear spring fed- river, and jumping off the dock. After a day of river adventures, head back to the yard to gather around the Tennessee slate rock fire pit area, where swings are perfect for telling campfire stories and creating lasting memories. The separate cook house, featuring a full kitchen and mini split AC systems, is perfect for hosting feasts and river adventures, with a half bathroom and outdoor shower for added convenience. Ichetucknee river estates offers 2 parks & a boat ramp. Embrace a lifestyle of endless leisure and natural beauty in this once-in-a-lifetime home, Turn key & ready for you to enjoy, where every day feels like a retreat into paradise.
MlsNumber: --
ListingId: 791229


Listing Provided By: Diamond CR Real Estate, original listing
Phone: (352) 949-5900
Office Phone: (352) 658-7168
Agent Name: Cassie Reardon
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