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

21186 Chesapeake Avenue
Rock Hall, MD 21661

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $598,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1760
Agency: Coldwell Banker Chesapeake Real Estate Co, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2018
Notes: This Coastal raised custom home was built in 2018, just one block from the Chesapeake Bay. Easy access to the 12 local marinas, Ferry Park Beach, restaurants, shopping and downtown Rock Hall. Only a short car or bike ride to Eastern Neck Island National Wildlife Refuge to commune with nature by foot, kayak, bike and more. The over sized two car garage with ample parking is perfect for storing your kayaks, paddleboards, bikes, jet skis and so much more! Party in the large private back yard with fire pit, Blackstone Grill & Treager Smoker (included) or take the fun to the upper levels with over a 1,000 feet of wrap around decks, including a covered porch to take in a thunderstorm or gentle rain. Wash the Bay and sand away at the outdoor shower! Amazing hardwood floors through out and ample sized bedrooms. The primary bedroom has his and hers closets including an oversized walk in, attached full bathroom with tub/shower combo and a sliding door to your private deck area and TRX workout band area! The primary living space has a 360 view open floor plan, perfect for entertaining. Stainless steel appliance’s, granite countertops and more hardwood floors adorn the 3rd story with plenty of light coming from the walls of windows facing the Bay! Multiple sliding glass doors on each floor & bedroom open to the the wrap around decks for indoor/outdoor flow making the outside part of your living space! Offered fully furnished and turnkey complete with 3 years of returning AirBNB and VRBO guests to help fill in those weeks(ends) you simply cannot breakaway to the bay. Annual income upon request.
MlsNumber: MDKE2003808


Listing Provided By: Coldwell Banker Chesapeake Real Estate Co, LLC, original listing
Name: Coldwell Banker Chesapeake Real Estate Co, LLC
Phone: (410) 822-9000
Office Name: Coldwell Banker Chesapeake Real Estate Compan
Office Phone: (410) 778-0330
Agent Name: Kristina Hyland
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