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

775 Pine Hollow Road
Port Trevorton, PA 17864
Patti Henne with BHHS Fox & Roach New Hope, original listing - (215) 862-3385

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: --
Agency: BHHS Fox & Roach New Hope
Agency Phone: (215) 862-3385

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Other-Other
Year Built: 1995
Notes: Welcome to the beauty and artistry of this custombuilt log home, offering a unique blend of rustic elegance and modern convenience. Nestled on a serene property, located in Snyder County situatedon 11+acres, this 2- or 3-bedroom home provides ample space for living, entertaining, and relaxing, both inside and out. As you enter the custom design covered porch, the main floor welcomes you with an open-concept design, showcasingopen custom beams and cathedral ceilings, featuring ample windows with scenic views and plentyof natural light and features custom finishes throughout. The spacious living room features a beautifulcentral floor to ceiling stone hearth fireplace w/insert also additional fireplace,flows into the kitchen with plenty of custom cabinetry , with an eat-in bar,an adjoining dining area, offers a large laundry room, full bath. Features the primary bedroom with plenty of closets and custom built-ins, offers a full bath, completes the main floor. Walk out from your sliding doors to a covered front deck to enjoy thepicturesqueviews andwild life.The second floor features a loft overlooking the living room, offers a bedroom and a cozy sitting area, offering flexible spaces for family or guests. The large unfinished walk-out basement offers high ceilings, features custom beams, stone fireplace, bedroom or workshop area. sliding doors and private entry. Outsidefeatures custom landscaping, stone wall with customfencing, and a fire pit ideal for outdoor entertaining.The property also includes 20x30 square-foot 2-car garage plus a nice size workshop area that includesplenty of storage.Other upgraded features to mention recess lighting throughout, ceiling fans, includes appliances (as-is), washer & dryer (As-is), Oil Heat, and the chimney includes 3 flues. Great location close to shopping, schools, Selinsgrove, Harrisburg, State College & major roads.This home has so much to offer with its breathtaking craftsmanship, thoughtful design, and scenic surroundings, this home offers a truly unparalleled lifestyle.
MlsNumber: --
ListingId: PASY2002276


Listing Provided By: BHHS Fox & Roach New Hope, original listing
Phone: (267) 718-1571
Office Phone: (215) 862-3385
Agent Name: Patti Henne
Disclaimer: Copyright © 2024 Berkshire Hathaway HomeServices Fox & Roach, Realtors. 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