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

391 Walker Road
Buffalo Mills, PA 15534

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3177
Agency: Howard Hanna Bardell Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 85 acre(s)
Property Type: Residential
Year Built: 2006
Notes: Check out the virtual tour! <br /> <br /> Experience the many unique 'facets' of this 'one of a kind GEM' overseeing Pennsylvania's Laurel Highlands' mountains.<br /> <br /> Perched high up, one has a commanding 360 degree view of the surrounding mountains and valleys ... some, 30 miles away! Easy access to main roads for convenience. Your own 'slice of heaven' in 'God's Country.' A masterpiece of thoughtful, intuitive design combines the ambiance of 'The Warm Hearth' meets 'Contemporary Aesthetics'. Comfort and convenience are intertwined throughout every aspect of the home and provenance abounds. Many building materials and finds (most locally sourced) are from centuries past and re-purposed in imaginative ways, contributing to the tenor of this home. Designed for the connoisseur with a discerning eye for quality and detail. Ingenuity, humor as well as functionality and comfort. Delight in the airy, sun filled open spaces enabling connectivity as well as peace and quiet. Explore from the foyer's (now interior) 'antique, 1860's, 8 foot+ high, walnut double entry doors to the 4'' level observation tower, experiencing each unique space that contributes to the home's overall continuity. <br /> <br /> The gourmet kitchen is designed for the serious chef with intuitive, convenient functional amenities. Bon Appetite! Top stainless steel appliances. The cabinets are custom built on site, hand crafted wormy chestnut, slate counter tops with antique white oak edges with antique nail heads, soapstone farmers sink. Adjacent 'butlers' cabinets are highly detailed, solid wood, painted white with antique chestnut counter. These cabinets continue into the adjoining dining room. A custom, one of a kind, china cabinet is lined with the wormy chestnut. The flooring is made from 200 + year old antique white oak beams ... exquisite. <br /> <br /> Half bath has custom wormy chestnut wainscoting and trim. Floating 3 ½' thick spalted pine counter with antique copper sink, floor is pegged antique grainery wood planks. Antique barnwood sliding door on authentic track.<br /> <br /> Careful consideration has gone into all design aspects from the imported antique French door handles/levers, the huge, bright horse stalls and management to the landscaping (including a purple beech tree). Marvel at the amazing emerging sunrise, the spectacular blazing sunsets and the expansive starry night sky complete with the Milky Way! There is still work to be completed in some rooms. Most of the materials are on site which include trim, flooring, lighting with ceiling fans to be installed. The hard parts are done.<br /> <br /> Oil, gas, and mineral rights convey with sale.<br /> <br /> Follow this link to see extra photos:<br /> https://photos.app.goo.gl/8dJf8s6PCxnmZSFs5
MlsNumber: 70171


Listing Provided By: Howard Hanna Bardell Realty, original listing
Name: Howard Hanna Bardell Realty
Phone: (814) 623-8622
Office Name: Howard Hanna Bardell Realty
Office Phone: (814) 623-8622
Agent Name: Aaron Hillegass
Disclaimer: Copyright © 2024 Allegheny Highland Association of Realtors. 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 = 2243 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 Colleen Fix
Colleen Fix
ASCIIHoward Hanna Bardell Realty
Call Today!: (814) 977-2075

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App