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

28874 Waller Road
Delmar, MD 21875

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 3221
Agency: Atlantic Shores Sotheby's International Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Farm And Agriculture
Year Built: 1991
Notes: Nestled on a sprawling 12-acre parcel of pristine Delmar, Maryland countryside, this property is a horse lover's dream. With its unique remodeled home, refreshing inground pool, and equestrian amenities, this estate offers a lifestyle of unparalleled luxury and tranquility.<br /> <br /> 12 acres of meticulously maintained grounds, perfect for horse enthusiasts. Expansive pastures, lush paddocks, and a charming barn with stalls, tack room, and storage space.<br /> This one-of-a-kind, three-bedroom, three-bathroom home has been thoughtfully remodeled to blend modern comforts with rustic charm. Vaulted ceilings, exposed wooden beams, and a stone fireplace create a warm and inviting ambiance in the living area. The gourmet kitchen features high-end appliances. A sunroom/office bathes the home in natural light and offers views of the property. An owner suite with an ensuite bathroom and walk-in closet. Two additional bedrooms and bathrooms ensure ample space for guests or family.<br /> Outdoor Oasis provides endless summer days by the inviting inground pool, surrounded by a spacious patio. The pool area is ideal for entertaining, with plenty of room for lounging, barbecues, and outdoor dining. Mature landscaping, including flowering gardens and shade trees, adds to the property's allure. Don't forget the outdoor kitchen, large outdoor bar and pavilion style roof.<br /> <br /> Situated in Delmar, Maryland, offering a serene rural setting while still being close to urban amenities. Convenient access to nearby equestrian trails and parks, making it easy to explore the surrounding natural beauty.<br /> This property offers a unique blend of luxury, comfort, and equestrian facilities that will appeal to horse lovers, nature enthusiasts, and those seeking a peaceful retreat. Whether you're an avid rider or simply seeking a picturesque retreat, this property has endless possibilities.<br /> Don't miss this rare opportunity to own a 12-acre horse-friendly estate with a unique remodeled home and an inviting inground pool in Delmar, Maryland. Experience the epitome of luxurious country living and schedule your private tour today!
MlsNumber: MDWC2011410


Listing Provided By: Atlantic Shores Sotheby's International Realty, original listing
Name: Atlantic Shores Sotheby's International Realty
Phone: (410) 524-0919
Office Name: Atlantic Shores Sotheby's International Realt
Office Phone: (410) 524-0919
Agent Name: Craig Lynch
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 = 1204 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;
Lynnette Roscoe
ASCIILong and Foster
Call Today!: (443) 513-0818

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App