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 = 2239 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2239 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2239 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;

10 Woodland Trail
Fairfield, PA 17320
Brittanie Woodward with Trish Rowe Realty, LLC, original listing - (717) 642-9400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $260,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1440 Square Feet
Agency: Trish Rowe Realty, LLC
Agency Phone: (717) 642-9400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1986
Notes: Welcome to 10 Woodland Trail- A charming 3 bedroom, 2 bath Chalet, nestled in the mountains of gorgeous Carroll Valley. It's excellent location offers seclusion & tranquilly, while being only minutes from the PA/MD line and many major commuter routes providing easy travel to Gettysburg, Waynesboro, & Harrisburg in PA along with Emmitsburg, Thurmont, Frederick, Westminster, and Hagerstown in MD, as well as the regional metro areas of Washington, DC, Baltimore, and Philadelphia. The property is also close to Carroll Valley Golf Course, Liberty Mountain Ski Resort, numerous wineries (Adams County Winery and Springfield Manor) and various historical sites (Gettysburg National Park and Antietam Battlefield). Academic and employment opportunities could be pursued at several noteworthy educational institutions (Penn State Mont Alto, Gettysburg College, Mount Saint Mary University, and McDaniel College). This 3 story A-frame has been expertly placed on it's 0.48 acre corner lot- which features mature hardscaping, blooming trees, & the privacy you've been longing for. A long driveway offers plenty of parking & wraps around to the attached oversized basement garage. Plus there's an additional parking pad off of Dogwood Trail. Spacious wraparound deck- freshly repainted in 2023! Newer upper level balcony & sliding glass door. The main floor features an open floor plan, wood floors, 1 bed/1 bath, and the main living area with cozy propane fireplace- newly repointed & waterproofed in 2023. The upper level offers 2 additional bedrooms & an updated bath. Basement level consists of the oversized garage, furnace/storage room, and extra room to use as you wish! Hot water heater- less than 5 years old. New water pump in 2019. This unique property is waiting for your personal touch & a little TLC to bring it up to it's full potential.
MlsNumber: --
ListingId: PAAD2015612


Listing Provided By: Trish Rowe Realty, LLC, original listing
Phone: (717) 357-1125
Office Phone: (717) 642-9400
Agent Name: Brittanie Woodward
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 = 2239 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;
Real Estate Expert Photo for Susie Singer
Susie Singer
ASCIIeXp Realty
Call Today!: (217) 402-5108

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App