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

20947 Caleb Jones Road
Ewell, MD 21824

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,900
Beds: 3
Baths: 4
Status: Active
SqFt: 1304
Agency: Wilson Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1900
Notes: Welcome to the enchanting Smith Island Inn! This one-of-a-kind listing is a well-maintained, established turnkey bed and breakfast business that is ready for new ownership. Located in the center of idyllic Ewell, Smith Island, Maryland, it offers quaint, simplistic charm with high quality service. Proudly featured in many top publications; Baltimore Sun, New York Times, Washington Post, Coastal Living Magazine, Southern Living Magazine, Outside Magazine, and National Geographic Magazine as one of the top places to stay/visit. It includes a one year Home Warranty and the current owners are available for training and granting website access to continue in the success of the business. It has many updated amenities while at the same time retaining the original charm of its 1900s structure. You will walk on original pine flooring and the stair casing, both retained and restored to their natural grandeur. Each of the three bedrooms have their own private bathrooms with custom tub/showers. The home features integrated smoke alarms, new 200-amp service panel upgrade. The plumbing, roof, windows, and siding have all recently been replaced as well. There is extra insulation between the first and second floors for noise reduction. Off the large, fully equipped kitchen there is a spacious pantry and laundry room with a half bath. New Refrigerator and Living Room Furniture also included. Outside in the lavishly landscaped yard, enjoy additional seating under a pergola with bistro lighting. A pathway leads to a screened in, all vinyl gazebo for dining alfresco. You will also find two sheds for additional storage. Guests are thrilled to immerse themselves in the rich culture of the island; Kayaking, bicycling, walking, fishing, crabbing, birdwatching or just experiencing the simplicity of their surroundings. This is a chance for you to own a slice of Smith Island Heaven. A perfect way too spend your days, owning an established successful business, meeting and entertaining folks while at the same time experiencing a peacefulness that only Smith Island has to offer!
MlsNumber: MDSO2003232


Listing Provided By: Wilson Realty, original listing
Name: Wilson Realty
Phone: (410) 430-1032
Office Name: Wilson Realty
Office Phone: (410) 968-1882
Agent Name: Laura Evans
Disclaimer: Copyright © 2024 Bright 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