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','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 = 3455 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 = 3455 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;

1540 Belfast Road
Sparks, MD 21152

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,400,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 14278 Square Feet
Agency: Berkshire Hathaway HomeServices Homesale Realty
Agency Phone: (410) 667-0801

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 69 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Grandview (circa 2003) – Everything about this 80-acre country estate reveals its bespoke origin. Absolute privacy was paramount, leading to a home that is invisible from the road. Parcels in the Maryland countryside were scoured for a decade before this specific grouping was chosen and assembled. At almost 600’ high in the Belfast Valley, the views are arresting. From the flower gardens right outside your doors - cultivated to attract certain species of butterflies - through the majesty of the Greco-Roman fountain - quenching the thirst of native birds – through the endless topography of gently rolling hills - in every color of sun-kissed green – in all directions – lies a veritable feast for your senses. You have never seen a vista this far-reaching, heard nature this deeply, or consumed the beauty of Maryland’s countryside quite like this. That’s why this property is called Grandview. The selection of the land was just the beginning of the curation process. Every aspect of the 9,000 square foot main home was custom-made. The region’s very best builder was brought to bear. Every cubic foot was imagined with the most maniacal attention to detail, gathering the most lavish and exotic of materials from all corners of the world, and calling for the most creative inspiration and execution of the skilled craftsmen and artisans assembled - all to construct such a masterpiece. And from its perch atop the grandest, natural spectacle in the Sparks countryside, a most profound sense of peace is yours. Complimenting the manor house is a charming Cottage (2BR/2BA, approx. 2,000 SF) for overflow family and friends, a Tenant House (3BR/2BA, approx. 2,000 SF) that is currently home to caretakers of the property and a Barn Complex, with ample room for grand entertainment … or farm use. 40+ acres of fenced pastures and tillable fields. Two separately deeded parcels with additional subdivision potential. The property is not encumbered by any conservation or preservation easement. If you’re looking for more than your ‘typical’ lovely Maryland estate - if you’re looking to transcend adjectives - this is The One.
MlsNumber: --
ListingId: MDBC2103340


Listing Provided By: Berkshire Hathaway HomeServices Homesale Realty, original listing
Phone: (410) 667-0801
Office Phone: (410) 667-0801
Agent Name: Thomas Moore
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