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

7190 Cedar Winds Farm Lane
Hanover, MD 21076

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2668
Agency: Redfin Corporation

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Welcome to Cedar Winds Farm! This beautiful home sits on just over half an acre, boasting a two-car garage, a long driveway, and a cul-de-sac for additional parking. From the moment you step inside, the gleaming hardwood floors and abundant natural light create an inviting ambiance. The sunroom with its vaulted ceiling adds a touch of elegance and provides a serene space to unwind. With a family room adjacent to the dining room, formal gatherings are effortlessly accommodated. The open-concept kitchen with custom cabinets, Corian countertops, and stainless steel appliances is perfect for both everyday living and entertaining guests. And let's not forget the convenience of the main-level office for those who work remotely. Upstairs, the spacious primary suite offers a peaceful retreat, complete with a walk-in closet. The en suite bathroom features a double sink vanity, jacuzzi tub, and spa-like shower. The additional bedrooms offer lovely views of the surrounding landscape, and the shared bathroom and laundry room add to the practicality of the layout. The unfinished lower level presents a blank canvas for personalized expansion, with the added bonus of a walkout to the backyard oasis. Amazing patio offers a perfect spot to enjoy the outdoors with views of trees. Easy commute to Baltimore, Washington DC, Ft Meade, and historic Annapolis. Conveniently located close to I-295, the MARC train station, shopping, and dining, and more! This home offers a tranquil retreat with quick access to urban conveniences. It's a place where comfort meets convenience, making it truly a place to call home. Book your showing today!!
MlsNumber: MDAA2081326


Listing Provided By: Redfin Corporation, original listing
Name: Redfin Corporation
Phone: (571) 477-1630
Office Name: Redfin Corporation
Office Phone: (703) 665-6665
Agent Name: Denean Lee Jones
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