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;

154 228th St
Suwannee, FL 32692

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $619,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1248 Square Feet
Agency: Hatcher Realty Services, Inc. Cross City
Agency Phone: (352) 498-5151

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Mobile Home
Year Built: 2004
Notes: There is a special place 24 miles south of Old Town Florida. Hwy 349 dead ends in one of Florida's best kept secrets. This small fishing community is made up of approximately 900 homes. Around 100 are primary residences with the balance being weekend retreats. Suwannee's small footprint size is locked in. The 53,000 acre Lower Suwannee Wildlife Refuge has this community well insulated from any major development or expansion. If you are looking for a great place off of the beaten path, then you owe it to yourself to see this super nice home on a freshwater canal. This beautiful home with its Caribbean flare is a must see if you are looking for a place to live or spend your weekends in Old Florida. This home has 3 bedrooms and 2 full baths. It is well-maintained and sits up high on concrete pilings offering great sunset views of the marsh from its screened in porch and deck. Don't like climbing stairs, no problem, this home also has an elevator. Many upgrades include Acacia hardwood counter tops, new A/C, new Pella Defender hurricane windows, Hardy Board siding, new paint inside and out, ionizer air purification system, 2 refrigerators, new stove and microwave, closed cell insulation under home, sheetrock interior walls, tile bathroom floors and much more! You have to see this home in person to fully appreciate it! If you like fishing and boating, you will definitely appreciate the covered boat lift with aluminum walk boards on both sides. After you come in from a day of fishing, just step into your screened fish cleaning room and take care of the days catch. If you don't want to cook, take your fish to the nearby Salt Creek Restaurant and have them prepare them for you. Two additional sheds are also included to store your tools and equipment. For your convenience, Suwannee also has 2 marinas, a fish camp, a small market, a library, post office, and several boat ramps. Come on down today and catch that Suwannee Fever!
MlsNumber: --
ListingId: 791215


Listing Provided By: Hatcher Realty Services, Inc. Cross City, original listing
Phone: (352) 498-5151
Office Phone: (352) 498-5151
Agent Name: Joel Norman
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