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;

2097 Ne 349 Highway
Old Town, FL 32680

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $229,900
Beds: 3
Baths: 2
Status: Pending
SqFt: 1568
Agency: Keller Williams Gainesville Realty Partners

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1995
Notes: Under contract-accepting backup offers. Discover Country Living at its finest!!! Located close to the Suwannee River, this nicely maintained home with 3 Bedrooms and 2 Baths is nestled on 4.82 wooded acres. The home interior offers a beautiful floorplan with Spacious kitchen featuring lots of counter space and Oak wood cabinetry. A private dining room adjoins both the Kitchen and the Livingroom. Off the kitchen is a large indoor laundry room which exits to the back porch/deck area. This is a split bedroom plan with a large Main Bedroom/Bathroom Suite to your right as you enter the home through the Large Livingroom featuring a wood burning fireplace with Built in storage on both sides of the Fireplace.<br /> At the front of the home is a screened porch facing the large front yard. The property has paved road frontage and is less than 2 miles to Shopping and Restaurants etc...in the Community of Old Town. <br /> From the Laundry room off the kitchen, you exit to a large open covered deck/porch area. Behind the home you will see a Large Metal Building 30ft x 40ft for a variety of uses...Parking/RV etc. as well as a 24ft x 24ft Concrete building used as a workshop. Both have tall roll-up doors and there is Electricity and water at both building locations.<br /> This is truly a beautiful property !! Come visit and see if this is your next home.
MlsNumber: GC521030


Listing Provided By: Keller Williams Gainesville Realty Partners, original listing
Name: Keller Williams Gainesville Realty Partners
Phone: (352) 240-0600
Office Name: KELLER WILLIAMS GAINESVILLE REALTY PARTNERS
Office Phone: (352) 240-0600
Agent Name: Tom Beasley
Disclaimer: Copyright © 2024 Stellar 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