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

30 Merry Hill Ct
Pikesville, MD 21208

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 5
Baths: 7
Status: Active
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1990
Notes: Perfectly situated on a premier lot overlooking Greenspring Valley, this quintessential French Manor home is encircled by seasonal blooms, expert landscaping, hardscaping, and outdoor living that, together, take full advantage of the majestic setting over which it presides. Inside, the architectural details include neutral interiors, immaculately maintained hardwood floors, arched headers, French window transoms, and spaces designed with the symmetry of French turrets. Cascading garden beds and a stately front elevation draw you into a covered brick porch, while a pair of solid wood entry doors welcome you inside.A two-story foyer unfolds into a dramatic open plan and octagonal dining room with built-in buffet cabinetry. An extended central foyer is adjacent to the formal living room defined by a soaring two-story ceiling, a wall of stacked windows, atrium French doors to the outdoor patio, and a wood-burning fireplace sided by finely finished built-ins.Exquisite French Manor Home with Premier Lot Overlooking Greenspring ValleyPerfect for main level living, a primary bedroom suite with sitting room, French doors to brick patio, an upgraded luxury bath with designer finishes, boasts an oversized walk-in shower, soaking tub, two vanities, and three walk-in closets. Adjacent to the primary suite wing is a formal study outfitted with richly finished library shelving, and a formal powder bath.Idyllic indoor and outdoor entertainment is enhanced by the serene setting and plantings outside and is supported inside by the open floor plan and circular traffic flow that continues into the family room and kitchen. Indoor entertainment in the family room offers a convenient wet bar and a commanding stone fireplace. French atrium doors in both the family room and in the adjoining breakfast room will invite friends and family to meander outside and take in the beauty of outdoor venues accessing the brick patio and the low maintenance dining deck seamlessly.The adjacent upgraded kitchen offers a spacious walk-in pantry, up-to-the-minute 12 x 24 designer floor tile, a center island, cook station, and breakfast bar wrapped in fresh white European cabinetry accented with feature designer hardware. The kitchen is purposefully designed as the heart of the home and is conveniently encircled by several important access points. In addition to the formal dining room and exterior dining deck, the kitchen offers access to the laundry room, mudroom, secondary covered entry, secondary powder bath, garage, and secondary back stair. At the top of the stairs, four additional en-suite bedrooms and a walk-in cedar closet encircle a spacious game room with two generous built-ins. Living spaces and amenities abound on all levels, including the lower level that is ready to finish. Generously sized, light-filled spaces, walk-out doors to a rear patio, daylight windows, a two-sided brick fireplace, a bath plumbed for steam shower, and an excellent waterproofing system are already in place and waiting to be finished according to your specifications. Come home to meticulously maintained luxury, a beautiful setting with serene outdoor spaces, and a very special lifestyle inside with main level living flexibility and room to grow! 5 minutes to I-695 , less than 10 min. to shopping center , Trader Joes & more. Convenient to all amenities.
MlsNumber: MDBC2093818


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Northrop - Ellicott City/Centennial
Office Phone: (888) 536-0216
Agent Name: JUNG J KIM
Disclaimer: Copyright © 2024 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 = 3256 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;
Gabe Khoshkheraman
ASCIIPickwick Realty
Call Today!: (443) 764-3056

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App