Title Page Background
DEBUG FN args: Array ( [0] => 355 [1] => [2] => [3] => agent ) BEFORE: Site: 355 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 355 Igate: njhud LocID: 355 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 355 [1] => [2] => [3] => lender ) BEFORE: Site: 355 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 355 Igate: njhud LocID: 355 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 355 [1] => [2] => [3] => other ) BEFORE: Site: 355 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 355 Igate: njhud LocID: 355 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

537 Mcpherson Drive
Alford, FL 32420
Lauren Lyons with Chipola Realty, original listing - (850) 482-7788

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $265,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1612 Square Feet
Agency: Chipola Realty
Agency Phone: (850) 482-7788

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 2011
Notes: Stunning Waterfront Retreat on Lake Susan!Welcome to your dream home nestled on the serene shores of the picturesque 80-acre spring fed Lake Susan. This 3-bedroom, 2-bathroom gem offers a peaceful and scenic setting that is perfect for nature lovers and fishing enthusiasts. With electric motors only allowed on the lake, the tranquility and natural beauty of this pristine environment are preserved, making it a true escape from the hustle and bustle.Key Features:Spacious Living: This well-maintained home boasts a split bedroom plan, ensuring privacy and comfort for everyone. All open living space with a wood burning fireplace for ambiance and warmth. The large master bedroom features a walk-in closet and a luxurious en-suite bathroom with double vanities, a soaking tub, and a separate shower.Gourmet Kitchen: The huge kitchen is a chef's delight, complete with ample cabinetry and a cleverly designed walk-in pantry with a disguised cabinet entry.Outdoor Living: Relax and entertain on the expansive covered back deck, which offers breathtaking views of the water. The property is 1.3+/- acres and gated for added security and privacy.Additional Amenities: Enjoy the convenience of a 2-car carport with extra storage, an insulated storage room, and a versatile insulated/air-conditioned 16x20 building currently used as a home office. There is also an RV hookup for convenience or having guests. Fishing Paradise: Lake Susan is renowned for its large bass, crappy, & bream, making it a perfect spot for fishing right from your backyard. If skiing, wakeboarding, jet skiing or other water sports interest you, the public boat launch at Compass Lake is only 5 minutes away.This home is in GREAT condition and ready for you to move in and start enjoying the lakeside lifestyle. Don't miss this opportunity to own a piece of paradise on Lake Susan!Roof has been replaced in 2019Well pump & wire replaced 2018(Conveniently located 20 minutes to Marianna, 30 minutes to Panama CIty, 50 minutes to the PCB international airport, 45 minutes to Dothan, and 80 minutes to Tallahassee)
MlsNumber: --
ListingId: 767455


Listing Provided By: Chipola Realty, original listing
Phone: (850) 482-7788
Office Phone: (850) 482-7788
Agent Name: Lauren Lyons
Disclaimer: Copyright © 2025 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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => jackson [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: jackson State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: jackson State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Hardie Williams
ASCIIPro Team Realty Group, LLC
Call Today!: (850) 225-7209

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App