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

3207 Cool Branch Road
Churchville, MD 21028

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $700,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3154 Square Feet
Agency: Berkshire Hathaway HomeServices Homesale Realty
Agency Phone: (410) 697-8100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1975
Notes: LOCATION, LOCATION, LOCATION! GREAT OPPORTUNITY TO PURCHASE A CUSTOM BUILT 4 BEDROOM, 2.5 BATH COLONIAL ON SERENE 3.07 ACRES SURROUNDED BY AG PRESERVATION FARMS IN FRONT AND BACK. HARDWOOD ENTRY FOYER WITH CHAIR RAILING, WAINSCOTING AND CROWN MOLDING. LIVING ROOM OFFERS CUSTOM BUILT-IN CABINETRY FROM FLOOR TO CEILING, DINING ROOM WITH HARDWOOD, CHAIR RAILING AND WAINSCOTING. COUNTRY KITCHEN WITH ALL APPLIANCES, ISLAND WITH ELECTRIC, WOOD CABINETS WITH SOME PUNCHED TIN FRONTS, BUILT-IN CORNER CABINET, PANTRY, TABLE AREA WITH DOUBLE WINDOW AND TILE FLOOR. FAMILY ROOM WITH CUSTOM BUILT-IN CABINETRY ON EACH SIDE OF THE WOOD BURNING FIREPLACE WITH ORNATE MANTEL, BUILT-IN CORNER CABINET AND HARDWOOD FLOOR, POWDER ROOM, FIRST FLOOR MUDROOM WITH CLOSET, BUILT-INS AND WASHER AND DRYER HOOK-UPS, GLASS DOOR TO ENCLOSED SCREENED IN PORCH. HARDWOOD STAIRCASE WITH WAINSCOTING TO SECOND FLOOR. PRIMARY BEDROOM AND BATH WITH JETTED, SOAKING TUB, BUILT-IN SHELVING, TRIPLE CASEMENT WINDOW OVER TUB, DOUBLE SINKS, CLOSETS AND HARDWOOD FLOOR. ALL THREE BEDROOMS OFFER WALK-IN CLOSETS, BUILT-INS AND CEILING FANS. HALL BATH WITH WAINSCOTING AND CERAMIC FLOOR. HARDWOOD HALLWAY WITH PULL DOWN STAIRS TO THE ATTIC, WHOLE HOUSE FAN AND SPACIOUS LINEN CLOSET. LOWER LEVEL RECREATION ROOM WITH ALASKA WOOD STOVE, BAR, BUILT-IN CLOSETS AND DESK, POOL TABLE CONVEYS. LARGE STORAGE ROOM WITH BILCO DOOR EXIT. 46' FRONT USABLE PORCH WITH FANTASTIC VIEWS. OVERSIZED (25X22), SIDE LOAD GARAGE WITH TWO OPENERS, WORKBENCH, AND CABINETS. SCREENED-IN BACK PORCH WITH COMPLETE PRIVACY. LANDSCAPED GARDENS, MATURE TREES AND SHRUBS. LARGE CIRCULAR DRIVEWAY PROVIDING AN ABUNDANCE OF PARKING. NO HOMEOWNERS ASSOCIATION! SEE DOCUMENTS FOR BROCHURE, HEALTH DEPARTMENT RECORDS AND HOME INSPECTION REPORT. YOU BETTER BE FIRST!
MlsNumber: --
ListingId: MDHR2037226


Listing Provided By: Berkshire Hathaway HomeServices Homesale Realty, original listing
Phone: (410) 697-8100
Office Phone: (410) 697-8100
Agent Name: Regina Crabb
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 = 1194 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;
The Ritchie Group
ASCIIBerkshire Hathaway HomeServices Homesale Realty
Call Today!: (410) 215-1123

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App