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

2817 Saddlebred Court
Glenwood, MD 21738

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,189,000
Beds: 4
Baths: 4
Status: Active
SqFt: 5018
Agency: Berkshire Hathaway HomeServices PenFed Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1988
Notes: Nestled within the picturesque community of beautiful Glenwood, MD with idyllic water views. The gorgeous drive up gives way to this stunning two-story home located on over 4 acres at 2817 Saddlebred Ct. Built on a flag-lot, the driveway leads past the basketball court, tetherball court and heated swimming pool. The thoughtfully landscaped yard invites you down the flagstone walkway to the front door where the large foyer warmly welcomes you into a smoke- and pet-free home. The entire front of the home was redone in 2024 with fiberglass pillars and plastic wood installed with fresh paint. To the right is the office and to the left is the Living and Dining Room. The Kitchen and Family Room is straight ahead with sliding doors leading out to the 2000+ sq ft Ipe deck. The backyard is spacious for cookouts and family gatherings. There is also a heated Sunroom off the Family Room used for a quiet Sunday breakfast or just relaxing in a cool and breezy room. Upstairs there are 4 oversized bedrooms with a his and her bathroom as well as an additional bathroom. It also has its own separate heating and air conditioning unit. The basement is over half finished with new carpet and paint. There is also an oversized Water Tank and 100 Gallon Hot Water Heater for larger families. There is also two (200amp) breaker panels connected to a Generac Whole House Engine Generator. There is also a Gas Furnace (Propane) for heating (1st Floor & Lower Level). The heat pump is for the 2nd level. A new house filtration system was installed along with a Reverse Osmosis water treatment. The kitchen with new Granite Countertops, Stainless Gas Stove, Stainless Dishwasher and Stainless Refrigerator with customized backsplash. <br /> <br /> With breathtaking water views, large pool with waterfall, basketball court, tetherball, and plenty of outdoor space, you’ll feel like you’re on vacation every day. In the winter, you can even go sledding in the front yard. The exquisite lot also includes an invisible dog fence. Oversized shed can also be used for a 3rd car garage detached. From the comfort of your own home, enjoy the breathtaking scenic water view at sunrise. Situated in a great neighborhood near a park, bike path and close proximately to schools, this home is sure to go fast! Entire home has been freshly painted, hardwood floors refinished and new carpet.<br /> Don't miss the opportunity to make this your home! Schedule a tour today!
MlsNumber: MDHW2038164


Listing Provided By: Berkshire Hathaway HomeServices PenFed Realty, original listing
Name: Berkshire Hathaway HomeServices PenFed Realty
Phone: (866) 225-5778
Office Name: Berkshire Hathaway HomeServices PenFed Realty
Office Phone: (410) 465-4440
Agent Name: Bob Chew
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 = 1195 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;
Erica Washington
ASCIIKeller Williams
Call Today!: (443) 956-2660

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App