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

8757 Orchard Drive
Chestertown, MD 21620

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $498,000
Beds: 2
Baths: 3
Status: Pending
SqFt: 2210
Agency: Chesapeake Real Estate Associates, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1992
Notes: Welcome to your tranquil retreat at Orchard Hill, where modern sophistication meets peaceful living on 1.89 acres of beautifully landscaped grounds. This stunning Cape Cod style home offers an abundance of amenities and thoughtful details throughout.<br /> <br /> As you step inside, you're greeted by the grandeur of vaulted ceilings that create an open and airy atmosphere. The ground floor primary bedroom provides convenience and luxury, complete with a upgraded kitchen featuring granite countertops, quality stainless steel appliances, an island with a gas cooktop, and a built-in wine refrigerator.<br /> <br /> The primary bedroom is a true sanctuary, featuring a luxury primary bath with a jetted tub and a stylish tile shower with glass doors. The main level's open layout is perfect for entertaining, with the added convenience of a bar with a sink.<br /> <br /> The second floor offers a guest bedroom, a full bath, and a loft that could easily be converted into a third bedroom or utilized as a versatile space according to your needs.<br /> <br /> Outdoor living is equally impressive, with a screened porch, large composite deck with a retractable canopy, a gazebo, and beautiful English cottage gardens featuring many native plants. The expansive outdoor space is perfect for gardening, outdoor activities, or simply enjoying the serene surroundings.<br /> <br /> Backing to trees and farmland, this property provides a peaceful backdrop and ample privacy. It's truly a must-see for those seeking a blend of modern luxury and peaceful countryside living. Schedule a showing today to experience the beauty and serenity of this exceptional property at Orchard Hill.
MlsNumber: MDKE2003556


Listing Provided By: Chesapeake Real Estate Associates, LLC, original listing
Name: Chesapeake Real Estate Associates, LLC
Phone: (410) 643-4663
Office Name: Chesapeake Real Estate Associates, LLC
Office Phone: (443) 215-4663
Agent Name: Kenneth Roderick
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