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;

20907 Caleb Jones Road
Ewell, MD 21824

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $139,900
Beds: 4
Baths: 1
Status: Active
SqFt: 1404
Agency: Wilson Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1948
Notes: Fall in love with this meticulously maintained property located in the quaint waterman’s island found in the heart of Ewell, Smith Island, Maryland. Seller is offering $2,500.00 towards closing costs and a one year home warranty! There are so many wonderful features included in this listing. As you approach the front entrance on a lovely brick sidewalk and steps you’ll notice the beautifully landscaped yard with pomegranate, hydrangea, and rose bushes, irises, hosta lilies and mature trees. This property is situated on a prime piece of property. It has 4 bedrooms and one spacious bathroom which features a large, stand in shower with rain faucet, and the toilet even has a bidet! All of the floors are the original 1948 hardwood. Crown moldings and ceiling fans throughout the home. There is a gas fireplace in the family room and the formal dining room is located between the family room and kitchen. All appliances in the kitchen are Whirlpool except for the Maytag washing machine. The solid wood cabinets in the kitchen are numerous and offer plenty of storage. Downstairs, the basement provides plenty of additional storage. It has a workshop on one side with an outside entrance/exit through custom built double doors. A brand new sump pump has been installed. As for the exterior, the roof, siding, and windows, and doors have all been replaced. The house has smoke and carbon monoxide detectors. The home boasts multiple heat sources - there’s electric baseboard, backup forced air as well as a gas fireplace. The property also has a backup water supply in case of emergency. All of the electric has been upgraded to 200 - amp service. Everything has battery backup. This island home is top notch! It has been well maintained and care for. It is ready for the perfect buyer looking for small town America. Call and schedule an appointment today!
MlsNumber: MDSO2004444


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