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;

3122 Bayview Drive
Church Creek, MD 21622

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2853
Agency: Sharon Real Estate P.C.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1990
Notes: Nestled beside the Chesapeake Bay lies a stunning Post & Beam home, boasting 4 bedrooms, 3.5 bathrooms, and a whopping 229 feet of rip-rapped shoreline. A grand Great Room with a vaulted wooden ceiling welcomes you with four sliding glass doors leading to the waterside deck, offering an uninterrupted view of the serene waters. Skylights, a wood-burning fireplace, and a separate wood stove add to the warmth and coziness of the space. The main floor bedroom comes with a full bath and has direct access to the deck, while the primary bedroom on the second floor offers a full bath, a waterside balcony, and a comfortable sitting area. Two additional bedrooms on the second floor also feature private balcony access.<br /> <br /> Indulge in the splendor of Tar Bay and the sandbar situated just offshore, as you access them through your very own private pier, complete with a jet-ski lift. The stunning view of the Chesapeake Bay with passing cargo and cruise ships, as well as the sight of local watermen harvesting crabs and oysters, will leave you in awe. Step outside and embrace the sounds of the shorebirds, surrounded by nature and wildlife.<br /> <br /> This history-rich area, close to Hoopers Island, offers easy access to attractions like the Harriet Tubman Visitor Center, Blackwater National Wildlife Refuge, and the Iron Man Triathlon course. The property is a lucrative investment with a successful vacation rental history.
MlsNumber: MDDO2007122


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