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 = 26 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 = 26 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 = 26 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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;

115 N Main Street
Atmore, AL 36502
Devin Schaff with KELLER WILLIAMS MOBILE, original listing - (251) 662-5660

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,900
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: KELLER WILLIAMS MOBILE
Agency Phone: (251) 662-5660

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Condominium
Year Built: 1905
Notes: Welcome to this wonderful opportunity to live in the heart historic downtown Atmore. This property creates an opportunity for mixed use and the monthly lease income from the retail shop below helps cover a portion of the monthly mortgage. This wonderful building built in 1905 has stood the test of time and has been tastefully, remodeled and ready for its next chapter. This beautiful home and retail combination features a wonderful balcony that overlooks the downtown area with views in every direction it gives a New Orleans vibe, enjoy a cup of coffee or a book on the open balcony overlooking the city, or have a place for your plants, a cookout and a great spot to entertain guests.<br /> This renovated building boast over 5400 sq ft of space. 2400 square-foot of that space is located on the 1st floor for the retail location with an additional 600 ft.² on the main level that can be a workshop or storage area that the owner of the second floor has complete access to. Or you could use this extra space as an office or work out room and it has its own entrance. Upstairs enjoy 2400 ft.² of living space. To help accommodate packages and shopping. There is an elevator that is located in the rear entrance for the home or you can choose to take stairs if you park out on the Main Street. There are also two dedicated parking spaces at the back of the home. Centrally located in downtown Atmore this would be a wonderful location to have a retail business great for clothing store, antique store, Beauty and Nail salon, ice cream shop or hardware store! The possibilities are endless. The retail portion is move in ready and is currently leased. <br /> <br /> The main home on the second level has been professionally decorated and is in move-in ready condition. Features beautifully painted walls, an open concept, living design with views to the dining room, kitchen, living area. Enjoy the gas logs on a cold evening. The home features wood floors throughout most of the main living area. The kitchen is large. It will be in chefs dream features a 36-inch cooktop 30-inch Wall oven custom cabinetry and appliances. Dishwasher refrigerator and Wall oven have been updated recently. Solid surface countertops, and an island bar make for a great opportunity to entertain guests and plenty of room also to additional entertain guests in the dining area. Great open flowing floor plan. The two bedrooms are oversized that feature large bathrooms, with each bath featuring custom built walk-in showers. Large walk-in closets, separate laundry room, and storage is at the back of the building with access to the elevator for exiting the building from the rear. Rear stairs lead to the roof area at the back of the building. Come check out this great opportunity to live in a one-of-a-kind building in historic downtown Atmore. Come check this one out today before it’s gone. Appointment is required. Please call to schedule your showing at least 24-hour notice is preferred. Buyer and Buyers Agent to confirm all information deemed important to Buyer prior to purchase.
MlsNumber: --
ListingId: 7359764


Listing Provided By: KELLER WILLIAMS MOBILE, original listing
Phone: (251) 662-5660
Office Phone: (251) 662-5660
Agent Name: Devin Schaff
Disclaimer: Copyright © 2024 Gulf Coast MLS. 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

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 = 26 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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;
Real Estate Expert Photo for Ginny Stopa, Broker/Owner, The Ginny Stopa Team
Ginny Stopa, Broker/Owner, The Ginny Stopa Team
ASCIINextHome Gulf Coast Living
Call Today!: (251) 623-0200

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App