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

1715 Glencoe Road
Sparks Glencoe, MD 21152

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 3637
Agency: Cummings & Co. Realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 1900
Notes: Contract deadline by 12pm Sunday 4/28/24. <br /> This gracious and elegant farmhouse with approximately 3,700 sq ft exudes the warmth of a cozy English Cottage. A rare opportunity in a coveted Glencoe location, this bright airy home exudes warmth and appeal while offering generous living spaces both inside and out. The grounds are a symphony of carefully curated elements—a harmonious blend of garden beds, mature trees, and open spaces. Even as the seasons change and fall descends, the allure of this haven remains undiminished. The approximate 4-acre lot offers sweeping views through the trees to the East and picturesque sunsets from the rear. Originally built circa 1900, this stately home offers lovely architectural details, copper gutters, period moldings, wainscotting, wood flooring, custom millwork, generous room sizes, and excellent space for entertaining both indoors and outdoor living. Truly an amazing home to enjoy outdoors on a beautiful day by opening the 6 doorways and sitting on the large-screened porch with the calm breeze blowing through the home. The main level includes 3 wood burning fireplaces, custom built-in shelves & cabinets, a large living room, a formal dining room, a breakfast room, a separate den/study, a large kitchen, a powder room, and an impressive 29’ x 24’ Great Room with cherry paneling, barn beams, 10’ ceilings, expansive stone fireplace and French door to a covered porch. A front and back staircase flows to the upper level to 4 bedrooms, 2 full baths, and a sitting room. Additional highlights include Landscape design by Oehme, Van Sweden to enjoy the gardens, stone/brick walkway, and placement of the large 2-car detached garage with a great separate workshop. Truly a spectacular home to enjoy the best of indoor and outdoor living throughout all four Seasons of the year. All of this is in a wonderful location close to the Gunpowder River and NCR Hike and Bike Trail and a 30-minute drive to Penn Station in Baltimore. Zoned RC2.
MlsNumber: MDBC2094316


Listing Provided By: Cummings & Co. Realtors, original listing
Name: Cummings & Co. Realtors
Phone: (410) 675-1550
Office Name: Cummings & Co Realtors
Office Phone: (410) 823-0033
Agent Name: Stuart Frantz
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