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;

14295 Old Frederick Road
Cooksville, MD 21723

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 4
Baths: 4
Status: Active
SqFt: 5542
Agency: Keller Williams Integrity

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1994
Notes: Welcome to your own piece of paradise! It's not every day that a home this extraordinary comes on the market! Sitting majestically on a beautifully landscaped lot, the expansive tree-lined driveway leads you to the welcoming front entrance. The two-story foyer is illuminated with abundant natural light, courtesy of the soaring ceilings and stunning oversized windows.<br /> <br /> Continue to the expansive living/music room, flooded with natural light making it a treasured space for relaxation, entertainment, and year-round enjoyment. Imagine hosting large gatherings in the gracious formal dining room. With its generous dimensions and inviting atmosphere, this room is perfectly suited for celebratory dinners, holiday feasts, and memorable gatherings with family and friends.<br /> <br /> Prepare delectable meals in the beautifully updated kitchen featuring sparkling quartz counters, a walk-in pantry, new stainless-steel appliances, and a spacious dining area. From the kitchen, step outside onto the new sun-drenched two-tier Trex deck overlooking the gorgeously landscaped backyard. Experience the ultimate relaxation in the Swim Spa, where you can enjoy the stars and nature any time of the year. Every day will feel like a vacation in this peaceful outdoor living space.<br /> <br /> Back inside, the family room is the perfect place for intimate gatherings, warmed by a soaring two-story stone fireplace. The magnificent Palladian windows, which make this home virtually dissolve into the outdoors, allow you to enjoy serene vistas from the comfort of your couch. The main level also features an in-home office, powder room and a conveniently located mud/laundry room, complete with a handy laundry chute, connecting to the spacious two-car garage. This thoughtful addition ensures a seamless transition between chores and leisure, making daily tasks a breeze. The entire home is also equipped with Geothermal heating & cooling and passive solar features, which are both environmentally friendly & cost-efficient!<br /> <br /> The upper level boasts a lavish primary suite, with spectacular views and two large closets, one of which is a walk-in. But that's not all! A luxurious en-suite spa-like bathroom showcases separate sinks and vanities, and large windows that bathe you in light as you relax in the soaking tub. Three more generous bedrooms and another full hall bath can be found on this level.<br /> <br /> The home's basement is the ideal place to relax or entertain. This recreation space boasts a gas fireplace and has plenty of room to enjoy all kinds of activities. The space also features a full bath, a large workshop, storage room and walk-in closets, one crafted of cedar. With easy access to the patio and Swim Spa, you'll find yourself dreaming of romantic candlelit dinners on the deck or private swims under the stars.<br /> <br /> Embrace a relaxed yet elegant lifestyle within your private sanctuary, nestled alongside Farmland Forever preservation, and conveniently located near amenities and major commuting routes. Located within one of the state's highest-ranking school systems, this paradise is the perfect place to call home.
MlsNumber: MDHW2036926


Listing Provided By: Keller Williams Integrity, original listing
Name: Keller Williams Integrity
Phone: (443) 574-1600
Office Name: Keller Williams Integrity
Office Phone: (443) 574-1600
Agent Name: Lisa Kittleman
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