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

53 895th Ave
Suwannee, FL 32692
Tammy Bryan with Compass Realty, original listing - (352) 498-2400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $524,900
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 1208 Square Feet
Agency: Compass Realty
Agency Phone: (352) 498-2400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1985
Notes: Discover life on the Suwannee in this coastal retreat along the enchanting Suwannee River with Dual Accommodations! This charming waterfront plantation features two beautifully appointed homes nestled on multiple lots, creating the perfect haven for two families seeking adventure and relaxation. Enjoy riverfront living in a delightful 3-bedroom, 2-bath elevated mobile home, expertly perched on concrete pilings for peace of mind. The second site-built home, is located on grade and was immediately professionally remediated after water intrusion from Hurricane Helene, inviting your personal touch to transform it into you river life retreat. Relax and entertain in the expansive screen enclosure, capturing breathtaking river views and gentle breezes—an ideal spot for morning coffee or evening gatherings under the stars. This is a Fisherman or Water Enthusiast's Dream: The property features a convenient boat lift and a dedicated fish cleaning house, providing the ultimate setup for fishing excursions and leisurely river days. Ample storage space for freezers and gear means you're always ready for your next adventure. The two-car garage ensures plenty of room for vehicles, watercraft, and outdoor equipment, keeping your retreat organized and clutter-free. The manicured lawn is being lovingly revived post-storm, in hopes to offer a picturesque setting for family gatherings, picnics, and fun-filled days by the river. Embrace the vibrant coastal river lifestyle in this exceptional property that blends serenity and adventure. Create lifelong memories with family and friends in your very own riverfront paradise! Don't miss out—schedule your private viewing today and step into the enchanting world of Suwannee River living!
MlsNumber: --
ListingId: 793937


Listing Provided By: Compass Realty, original listing
Phone: (352) 498-2400
Office Phone: (352) 498-2400
Agent Name: Tammy Bryan
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