Title Page Background
DEBUG FN args: Array ( [0] => 1203 [1] => [2] => [3] => agent ) BEFORE: Site: 1203 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1203 Igate: njhud LocID: 1203 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1203 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1203 [1] => [2] => [3] => lender ) BEFORE: Site: 1203 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1203 Igate: njhud LocID: 1203 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1203 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1203 [1] => [2] => [3] => other ) BEFORE: Site: 1203 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1203 Igate: njhud LocID: 1203 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1203 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

17201 Shepherdstown Pike
Sharpsburg, MD 21782
Roger Fairbourn with Roger Fairbourn Real Estate, original listing - (301) 733-4183

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,300,000
Beds: 7
Baths: Full: 2
Status: Active
SqFt: 6034 Square Feet
Agency: Roger Fairbourn Real Estate
Agency Phone: (301) 733-4183

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 29 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1813
Notes: In October 1862, following the Battle of Antietam just two weeks earlier, President Abraham Lincoln travelled to the Battlefield to survey the troops and to meet with Union General George B. Mclellan at his camp headquarters on a farm west of Sharpsburg and known locally as Mt. Airy. The historic photo of Lincoln meeting with General McClellan taken by photgrapher Alexander Gardner documents a group of people standing in front of the main house at Mt. Airy Today this farm has been lovingly and sensitively maintained as a National Treasure.<br /> <br /> Acquired by the family of the current owners in 1982, the property has been maintained with an eye on the property's historical significance while addressing the needs of contemporary comfort.<br /> <br /> The original manor house, constructed in 1813 remains essentially intact with all original mantels, doors and windows. The original floors have never been finished and a remarkable staircase is fully intact as it winds all the way to the third floor attic. This residence features tall ceilings, spacious sunny rooms and <br /> even a ballroom! Updated utilities and baths have been sensitively added to enhance the home's livability.<br /> <br /> The tenant house, constructed mid nineteenth century features a lovely addition that invites gatherings and provided very comfortable accommodations for the residents. A lovely kitchen and updated utilites bring this old home into the 21st century,<br /> <br /> The original carriage house is sited atop the stone root celler and domed ice house. This space has been re-created to be a comfortable guest house featuring cathedral ceilings and an updated chef's quality <br /> kitchen.<br /> <br /> Other buildings include the stone and frame bank-barn reconstructed in the early 20th century in the original location, as well as a recently constructed 34 foot by 100 foot metal building tucked out of view that accommodate the owner's thriving business.<br /> <br /> Given the property's National Tresure character, this sale is made subject to easements with the Maryland Environmental Trust.
MlsNumber: --
ListingId: MDWA2028888


Listing Provided By: Roger Fairbourn Real Estate, original listing
Phone: (301) 733-4183
Office Phone: (301) 733-4183
Agent Name: Roger Fairbourn
Disclaimer: Copyright © 2025 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => washington [3] => MD [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: washington State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: washington State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1203 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Carly Patla - The Carly Patla Team
Carly Patla - The Carly Patla Team
ASCIIIron Valley Real Estate
Call Today!: (717) 491-2190

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App