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

2139 Pike Pond Road
Alford, FL 32420

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $285,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1904
Agency: Counts Real Estate Group Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2001
Notes: Discover the perfect blend of privacy and comfort with this immaculate Fleetwood 'Harbor Springs' model mobile home. Nestled on a serene 10-acre woodland setting, this residence offers an unparalleled opportunity to enjoy the tranquility of nature combined with modern amenities. The spacious 1,904 square foot layout includes three cozy bedrooms, two updated bathrooms, and two inviting living areas, providing ample space for relaxation and entertainment.Step outside to experience the outdoor charm of three expansive decks, with the side one covered, ideal for enjoying the peaceful surroundings. A stream meanders throughout the property. The property is enhanced by a functional fireplace and wood stove that add warmth and ambiance during cooler evenings.Practicality meets convenience with four useful outbuildings, one equipped with electricity, perfect for projects or storage, or s/he shed! The landscape is adorned with 3 fruit trees, adding a touch of natural sweetness to your home environment. The essentials such as a washer, dryer, freezer, stove, and refrigerator are included, ensuring a seamless move-in experience.Significant updates include a new roof installed in 2019, luxurious new LVP flooring in 2020, a refreshed second bathroom in 2023, and a well replaced in 2014. The property has been meticulously maintained, with the mobile home recently leveled in March 2024 and the septic system serviced within the last year.Additional perks include a John Deere riding mower, dining room set with hutch, barstools, and a table on the back deck, all of which convey with the property. Located midway between Dothan and Panama City, close to Compass Lake and Chipley, this home offers both privacy and accessibility, making it a prime choice for those seeking a peaceful retreat within reach of city amenities.
MlsNumber: 756058


Listing Provided By: Counts Real Estate Group Inc, original listing
Name: Counts Real Estate Group Inc
Phone: (850) 249-3615
Office Name: Counts Real Estate Group Inc
Office Phone: (850) 249-3615
Agent Name: Dawn Dezendorf
Disclaimer: Copyright © 2024 Central Panhandle Association of REALTORS. 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