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;

2905 Old Court
Pikesville, MD 21208
Heidi Hawkins with Coldwell Banker Realty, original listing - (301) 718-0010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,185,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4104 Square Feet
Agency: Coldwell Banker Realty
Agency Phone: (301) 718-0010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1956
Notes: This custom Mid-Century modern marvel seamlessly blends mid-century design and luxury with functionality, offering an ideal living space for those who appreciate style and comfort. An exquisite stained glass front door sets the stage as you walk -in for this custom home and all of its wonder. The living room is lined with sweeping windows, doors, vaulted and beamed ceilings, with plenty of space for relaxation and entertaining, with custom built-in shelving and double-sided fireplace and a powder room. The open concept living and dining area is both spacious and warm and connects seamlessly into the kitchen. A chef’s dream, the custom kitchen is equipped with all of the “bells and whistles” including top-of-the-line Kenmore Pro and Kitchen Aid stainless steel appliances, large island with cooktop, double wall ovens, a bread warmer, retractable table, wet bar, coffee bar, and smartly design storage perfect for culinary enthusiasts. Built-in cabinets display your favorite treasures and keepsakes lining the kitchen and dining area. The all-season sunroom off of the kitchen bathes the space with warmth and light and is complete with built-in cabinetry. The primary suite is outfitted with custom closets with private access to the courtyard with bucolic views. The primary suite is complete with a luxurious ensuite bathroom with soaking tub, separate shower, and numerous elegant touches. Enjoy custom stained glass window and door features, stone work, heated floors, and millwork throughout the home. On the other wing of the home, three additional spacious bedrooms with large closets and pocket doors provide comfort and efficiency through smart design, as well as two full bathrooms and an office nook with a stunning mantel. The main floor laundry has plenty of additional storage and convenience to the living area. The attached three car garage with EV 220 charger and circular driveway provides plenty of parking for multiple vehicles and additional storage. The finished basement, perfect as an additional office or recreation space, has its own bathroom with large stall shower, a large cedar closet, and a storage room. The 1.43 acre grounds includes a large gazebo, cozy flagstone courtyard spaces, sculpture, and an out building/storage shed. Over $150,000+ of investments in the home are passed on to the new owner of this gem, with a new roof in 2024 (not A-frame), new furnace and HVAC system in 2023. Don't miss the opportunity to own this exquisite home. Located in the desirable area of Pikesville, MD, this home is close to top-rated schools (The Park School and Gilman schools right nearby) country clubs (Suburban Club and The Woodholme), shopping and dining destinations at Quarry Lake, commuter routes and recreational facilities. Near the Cylburn Arboretum and numerous parks. Property is sold with an additional, buildable 1.25 acre adjacent lot (2903 Old Court Rd).
MlsNumber: --
ListingId: MDBC2101728


Listing Provided By: Coldwell Banker Realty, original listing
Phone: (301) 718-0010
Office Phone: (301) 718-0010
Agent Name: Heidi Hawkins
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 = 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;
Real Estate Expert Photo for Araminta Morton
Araminta Morton
ASCIIBennett Realty Solutions
Call Today!: (202) 409-3530

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App