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

12623 Windy Ridge Drive
Corriganville, MD 21524

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $870,000
Beds: 4
Baths: 2
Status: Active
SqFt: 3008
Agency: Carter & Roque Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 103 acre(s)
Property Type: Residential
Year Built: 1910
Notes: Paradise! No other words to describe this gorgeous property just minutes away from I68. Bring your animals/livestock and green thumb to your own little slice of heaven. The main house, barn and pavilion sit on 103 acres, with approximately 26 acres of pasture. There is a natural spring, locally famous trout stream and plenty of timber. The property has the historic Brush Tunnel on site, giving the Great Allegheny Passage rail trail and the Western Maryland Scenic Railroad right away through the mountain. What a unique feature! The pavilion has been approved by the county for an additional building site. The main home has pride of ownership written all over it. When entering you will be greeted with sparking hardwood floors. The kitchen is large with lots of cabinet space and is centrally located. The dining room has custom built oak cabinets with glass showcase doors. Make your way into the GREAT room which is Grand by all accounts. Host all of your events and Holidays here! There are front, side and back porches, all covered and showing off the farms mountain views. All the bedrooms have new carpet and there is a main level bedroom for anyone needing to avoid stairs. Find plenty of parking in the oversized two car garage or the wrap around driveway. The roof is BRAND NEW! Don't let this amazing opportunity pass you by, call today! Two parcels in this sale. Tax id 0120001593 (the house/0.75 acres) Tax id 0120009934 (the barn, pavilion and 103 acres)
MlsNumber: MDAL2008504


Listing Provided By: Carter & Roque Real Estate, original listing
Name: Carter & Roque Real Estate
Phone: (301) 689-0100
Office Name: Carter & Roque Real Estate
Office Phone: (301) 689-0100
Agent Name: Heather Brailer
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