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

16415 River Airport Rd
Brandywine, MD 20613
Melisa Klem with Clarksville, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Clarksville
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1981
Notes: An Equestrian Dream on 6 Pristine Acres in Brandywine Farms. Experience the ultimate horse farm lifestyle on this breathtaking 6-acre property in the sought-after Brandywine Farms community of Prince George's County. Designed with equestrian enthusiasts in mind, this estate boasts unmatched facilities and stunning land, making it a true paradise for horse lovers. The property's crown jewel is the equestrian infrastructure. A spacious and well-appointed barn features six stalls, including three oversized stalls perfect for foaling or convert them to a total of nine stalls when needed. The barn also includes a tack room, a full bath, a wash stall, and a lounge area ideal for unwinding after a day of riding. The lounge could also serve as a groom's apartment. An indoor arena allows for training and riding in all seasons with custom footing, while a large outdoor riding ring and five fenced pastures provide endless opportunities for outdoor enjoyment. Loafing sheds each with their own electric and water ensure your horses' comfort and the mechanics shed with an attached run-in shed offers ample space for farm equipment, tools, or ATVs. The land is a serene and versatile canvas-rolling pastures, open skies, and plenty of space to expand, play, or simply relax. Enjoy evenings by the firepit on the rear patio, with views that stretch across your private sanctuary. Complementing the exceptional land and stables is a charming ranch-style inspired home. Inside, the open floor plan greets you with warm details like crown molding, a sunlit bay window, a brick accent wall with a wood-burning stove, and gleaming hardwood floors. The central kitchen is a chef's dream, with 42"" cabinetry, granite countertops, a center island with breakfast bar, a gas-burning stove, and stainless steel appliances. Step out onto the rear deck or wrap around screened-in deck for panoramic views of the property. Adjacent to the kitchen, the great room stuns with its knotty pine accents, ceramic tile flooring, cathedral ceiling, turret design with exposed beams, and a layout ideal for entertaining. The upper-level primary suite offers a luxurious retreat, complete with a private entrance, vaulted ceiling, skylights, an impressive walk-in closet (or convert this back to a bedroom!), access to a balcony, and a sitting room or office. The en-suite bathroom boasts dual vanities, a lighted dressing table, and a walk-in shower. Three additional bedrooms, including one with a private en-suite with a double vanity and walk-in glass door shower, and a hall bath ensure comfort for family or guests. With a two car garage and conveniently located near MD-382, US-301, and I-495, this property offers the perfect balance of country living with easy access to city conveniences. Whether you're looking to expand your equestrian pursuits or simply enjoy life on a private farm, this property is a rare find. Schedule your private tour today and step into a world of endless possibilities!
MlsNumber: --
ListingId: MDPG2132680


Listing Provided By: Clarksville, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Melisa Klem
Disclaimer: Copyright © 2025 Long & Foster Real Estate. 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 = 3265 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;
Real Estate Expert Photo for Chris Murphy
Chris Murphy
ASCIIHome Towne Real Estate
Call Today!: (443) 684-4063

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App