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 = 1199 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 1199 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 1199 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;

220 Fair Prospect Farm Court
Stevensville, MD 21666

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,425,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3833 Square Feet
Agency: Monument Sotheby's International Realty
Agency Phone: (410) 525-5435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Spectacular 30-Acre Waterfront Estate on Cox Creek — 5 minutes from the Chesapeake Bay Bridge:<br /> A rare opportunity to own a breathtaking 30-acre waterfront retreat with 1,000 feet of shoreline partially rip-rapped, a private dock with boat lift, ample docking area and stunning panoramic views. This exceptional property features a luxurious contemporary residence, a charming three-bedroom cottage, a massive multi-use pole barn, and a two-story event lodge, making it THE ultimate escape for entertaining, multi-generational living, a private sanctuary, a farmette…endless possibilities exist! The main residence spans across 3,800+ sq. ft. — with 4-bedrooms, 3 full and 2 half-baths — oriented to showcase the waterfront setting. The main level features a grand living area with soaring cathedral ceilings, a gas fireplace, and wall-to-wall water views. The open concept provides an easy flow to the formal dining room, the gourmet kitchen and the adjoining breakfast area. Tucked away, off the kitchen, is a three -season porch which is THE perfect spot to drink your coffee, read a book or catch up on the latest! The main floor also offers a flex room which could be used as a library/office, den or formal living room. A luxurious primary suite with stunning water views and a spa-like en-suite bath for the ultimate retreat is the grand finale to the main floor, which is serene, spacious and bathed with natural light. Upstairs, you'll find three spacious bedrooms, each with breathtaking water views, and two full baths. There are multiple closets with ample storage space. The additional buildings offer endless possibilities. The Three-Bedroom Cottage is ideal for guests, extended family, or possibly rental income. The Event Lodge is a versatile two-story space, with the main level designed for large gatherings, entertaining or a large game room, and with the upper level offering a spacious room that can be used in multiple ways. office, guest rooms, game rooms, or?? Lastly, the massive Pole Barn — currently used for farm vehicle and boat storage boasts an over-sized workshop which could stay as is or be converted to serve a number of alternative uses! <br /> A Waterfront Paradise Awaits You, call or message for a private tour!
MlsNumber: --
ListingId: MDQA2012278


Listing Provided By: Monument Sotheby's International Realty, original listing
Phone: (240) 274-1219
Office Phone: (410) 525-5435
Agent Name: Joe Petrone
Disclaimer: Copyright © 2025 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 = 1199 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;
Real Estate Expert Photo for Andrew Meikle
Andrew Meikle
ASCIIDoug Ashley Realtors LLC
Call Today!: (410) 708-5050

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App