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;

10570 Cogar Road
Chestertown, MD 21620

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 2862
Agency: Coldwell Banker Chesapeake Real Estate Co, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2010
Notes: Welcome to your dream country home! This charming property, nestled in a serene rural setting, offers the perfect blend of modern comfort and rustic allure. Boasting three bedrooms and two baths, this home is a haven of tranquility with a first-floor bedroom and a full bath for added convenience. The home features all new windows, new Luxury Vinyl Flooring throughout, updated bathrooms, and more. An additional office space adds functionality to the layout, catering to the demands of remote work or personal projects. The enclosed breezeway is a flexible space ready for your imagination..craft room, mudroom, playroom, sitting room, Need storage space...an oversized 2-car garage has built-in shelving, and a staircase to the walk-in attic as well as the second floor office. <br /> Relax and unwind on the deck overlooking the beautiful backyard, a perfect spot for entertaining guests or enjoying peaceful evenings surrounded by nature. Working from home is not a problem with WiFi access points on both floors, office wall jacks, and entertainment console wired jacks (for Gaming Consoles, networked entertainment centers, etc.), and a cell phone booster. The community has a voluntary HOA which covers the community common space, boat ramp, pier with boat slips. Conveniently located 15 minutes from Chestertown and Rock Hall, and a short 30 minutes to Middletown, DE and Rt. 301/Rt. 1.<br /> One Year Home Warranty is Included
MlsNumber: MDKE2003352


Listing Provided By: Coldwell Banker Chesapeake Real Estate Co, LLC, original listing
Name: Coldwell Banker Chesapeake Real Estate Co, LLC
Phone: (410) 822-9000
Office Name: Coldwell Banker Chesapeake Real Estate Compan
Office Phone: (410) 778-0330
Agent Name: Terri Kulp
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