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

147 Steamboat Court
North East, MD 21901
DJ Jones with Coldwell Banker Realty, original listing - (410) 740-7100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $619,999
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3828 Square Feet
Agency: Coldwell Banker Realty
Agency Phone: (410) 740-7100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: Inclusions<br /> Shed. Custom Deck. 1 year seller paid home warranty at the buyer choice of company. $2500 seller contribution towards buyers closing costs. <br /> <br /> This beautiful Ryan home is nestled in a quiet North East community that your buyer is sure to enjoy to the fullest. <br /> <br /> The curb appeal is very nice, as the interior offers over 3k sq ft of livable space which provides comfort and a realized return on investment. <br /> <br /> Spacious shed installed by the seller. (8)16x21 Model T50S garage windows installed. Recently installed asphalt driveway. Cameras and flood lights around the home to increase safety. Huge deck for entertaining. <br /> <br /> Upon entering the property, you are welcomed by a spacious formal living room. A formal dining room is just on the opposite side of the main entrance. The family room is large, the gourmet kitchen and entertainment L- Shaped granite countertops ready for parties. Morning room beautifully sits between the kitchen and exit to the deck. Nice size home office on the first floor next to the powder room and garage exit. <br /> <br /> The basement is fully finished with a nice size bar, vinyl flooring, carpet, an exercise room, and plenty of additional space for entertainment. <br /> <br /> The upstairs bolsters comfort with sizable rooms, and a laundry room conveniently located near bedrooms. <br /> <br /> This home is less than one hour away from Philadelphia and Baltimore, conveniently located near many shops, parks and restaurants. To name a couple parks: North East Community Park and Herring Snatchers Park. This home is located at the headwaters of the Chesapeake Bay, North East was the first permanent settlement in Cecil County. Main Street offers various shops full of artisanal goods and antiques, and various nice restaurants. The Upper Bay Museum is another main attraction for its historic hunting memorabilia. <br /> <br /> Other wonderful places nearby: The property is near the Northern neck of Eastern Shore, near Cecil College and Plumpton Park Zoo, Wellwood River Shack restaurant that is used to host many weddings with the backdrop of the Chesapeake Bay, Perryville Casino, Great Wolf Lodge, also The Community of Cool Springs in historic town of Charlestown.
MlsNumber: --
ListingId: MDCC2014742


Listing Provided By: Coldwell Banker Realty, original listing
Phone: (800) 913-4326
Office Phone: (410) 740-7100
Agent Name: DJ Jones
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.


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 = 1189 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;
JAMES JONES
ASCIIeXp Realty
Call Today!: (302) 559-4332

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App