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

5519 Oyster Shell Point Road
East New Market, MD 21631

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2300
Agency: Sharon Real Estate P.C.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Discover all the “NEW” items this house has to offer. New roof, flooring, appliances, HVAC, garage door, sump pump, salt generator, Polaris crawler for pool and the list goes on. Located in the quiet neighborhood of Johnnie Cake Acres nestled on a spacious 2 acre lot near desirable school district and easy access to Route 50, shopping and the beach. Upon entering the front door, the hallway takes you to the kitchen which boasts all new appliances, recessed lighting, storage closet and pantry. The Island provides additional prep space with cabinet storage and effortlessly connects to the family room with inviting gas fireplace. Living room with hardwood floors and pellet stove with an additional bright and sunny room that offers an array of uses such as office/den/library/exercise room/child’s playroom, etc. As you head upstairs, you will find the large primary bedroom with walk-in closet and primary bath with large tub, double vanity and a separate spacious walk-in shower. Down the wide open hallway is the laundry closet and 3 generously sized bedrooms and a full bathroom. Numerous ceiling fans throughout the house in almost every room to help with heating and cooling cost, central vac, alarm system, intercom system, and 9’ ceilings. Two car attached garage with long driveway that provides ample parking space. Step out the sliding doors from the kitchen area to the large deck overlooking the back yard and experience the joys of outdoor living. Invisible fencing in place to keep your fur babies safe. Enjoy quiet peaceful evenings on the deck or invite friends and family over for gatherings and entertain with barbecues, cook outs and outdoor activities such as a dip in the inground salt water pool. While you’re waiting for your guest to arrive, catch a breeze from the front covered porch. Relax, unwind and soak up all amenities you can ever imagine. This Eastern Shore property is conveniently located near beaches, boating, museums, hunting and fishing. Sellers are in the process of even more renovations including a new deck, pedestal sink and fixtures in the powder room downstairs and a new pool liner. Also, house is being power washer.
MlsNumber: MDDO2006734


Listing Provided By: Sharon Real Estate P.C., original listing
Name: Sharon Real Estate P.C.
Phone: (410) 228-2525
Office Name: Sharon Real Estate P.C.
Office Phone: (410) 228-2525
Agent Name: Sharon Spedden
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