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;

47 31st Ave
Old Town, FL 32680
Jennifer Collins with Pristine Properties, original listing - (352) 233-8484

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $524,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2564 Square Feet
Agency: Pristine Properties
Agency Phone: (352) 233-8484

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: This stunning waterfront retreat nestled on just over an acre along the picturesque Suwannee River offers the perfect oasis for river living. With a 2 bedroom, 2 bath upstairs and a separate full apartment downstairs, it's ideal for extended families or as a charming Airbnb. Just a half a mile from gorgeous Fanning Springs State Park that features a 2nd Magnitude Spring that produces 65 million gallons of water daily and a third of a mile from the public boat ramp. It combines privacy with convenience. Upstairs, enjoy panoramic river views from the spacious Florida room which will become one of your favorite relaxing areas. Vaulted ceilings, and a cozy fireplace in the large living room. The bright and airy kitchen boasts plenty of cabinet and counter space, while the master retreat features new vinyl plank flooring, a walk-in closet, double vanities, and a walk-in shower. With a split floor plan, the second bedroom and bath offer added privacy. The roof was replaced in 2023, and for convenience there are two sets of stairs and an elevator. The charming downstairs 1 bedroom/1 bath apartment is spacious with a large living room that is open to the dining and kitchen. Ample concrete space under the house provides parking and space for gatherings. With over 200 feet of river frontage, you can enjoy the upper dock or launch your boat from the floating dock. The sunsets are amazing! Additional storage is provided by a couple of outbuildings, and there's a detached carport for boat or RV parking with a RV hook up . Whether you're embracing river life or heading just 25 minutes to the Gulf of Mexico, this property offers a unique and perfect location. Schedule a viewing today to discover all this home has to offer!
MlsNumber: --
ListingId: 790358


Listing Provided By: Pristine Properties, original listing
Phone: (352) 233-8484
Office Phone: (352) 233-8484
Agent Name: Jennifer Collins
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