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;

1137 Ne Holly Road
Branford, FL 32008
Kellie Shirah with POOLE REALTY INC., original listing - (386) 362-4539

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $639,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1504 Square Feet
Agency: POOLE REALTY INC.
Agency Phone: (386) 362-4539

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Nestled on the banks of the picturesque Suwannee River in Branford, FL, this stunning 3-bedroom, 2-bathroom home offers the perfect blend of comfort and adventure. Currently operating as a successful Airbnb, this income-producing property can be a turn-key investment & a scenic getaway. Upon entering, you are greeted by a spacious living area adorned with a charming gas fireplace and walls featuring beautiful cypress tongue and groove detailing, adding warmth and character. The home boasts covered porches both at the front and back, inviting you to relax and enjoy the breathtaking river views. One of the standout features of this property is its enclosed inground saltwater pool with a spa, ensuring year-round enjoyment and relaxation. Adjacent to the pool area, a convenient half-bath bathhouse adds to the ease and comfort of outdoor living. For those who love outdoor entertaining, a covered pavilion overlooking the river awaits, complete with a fish cleaning station nearby—perfect for preparing your fresh catch after a day on the water. A floating dock provides easy access for boating enthusiasts, making it effortless to explore the Suwannee River’s natural beauty. Inside, practicality meets convenience with amenities, including an elevator and a whole-house generator, ensuring ease of access and peace of mind for residents and guests alike. Whether you're looking for a peaceful riverside retreat, an income-producing investment, or both, this property has it!
MlsNumber: --
ListingId: 126401


Listing Provided By: POOLE REALTY INC., original listing
Phone: (386) 208-3847
Office Phone: (386) 362-4539
Agent Name: Kellie Shirah
Disclaimer: Copyright © 2025 North Florida 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