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

1290 Egypt Hollow Road
Julian, PA 16844
Brian Rater with RE/MAX Centre Realty, original listing - (814) 231-8200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2788 Square Feet
Agency: RE/MAX Centre Realty
Agency Phone: (814) 231-8200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 94 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1958
Notes: Welcome to the ultimate nature lover’s paradise with incredible mountaintop views on 94 secluded acres! Live life to the fullest and embrace nature and all its glory every day! Experience the change in seasons and be in harmony with all the beauty undisturbed nature provides. Watch the amazing wildlife outside your door like never before. Experience the best “radio station” known to man by simply listening to the choir of Bluejays, Cardinals, Morning Doves, and Whipoorwills just to name a few. Ignore the minor interruptions from Frogs, Coyotes and Turkeys as they have a voice too! This home is intended to be shared with tons of friends that have four legs, possibly two, friends with feathers, gills, and paws! These friends appreciate life's simple treasures and don’t participate in modern world issues. These friends keep you grounded. <br /> <br /> Step inside, and nothing needs to be updated; it’s all DONE, emphasizing quality and timeless style! With 2,788 of above-grade finished space, we have all kinds of options and rooms to appreciate. The two staircases provide flexibility to the 3 bedroom, 2.5 bath layout. Dramatic wall-to-ceiling windows in the great room with an open staircase brings nature inside. Pamper yourself in the new, top-of-the-line kitchen boasting custom-made cabinets, pull-out drawers, a huge island, a beautiful backsplash, granite, and a farm sink. When it is time to “clean up” after roaming the 94 acres, do so in luxury with the beautiful baths. The owner's suite steps out on a private covered porch. Work from home with ease with a host of indoor and outdoor covered options. Hardwood and laminate floors throughout for easy maintenance. Enjoy your favorite beverage at each end of the day on the screen on the porch overlooking the ever-changing valley as trees and fields tell their own story! Stop paying for hunting excursions when you have ample options at home that you enjoy watching all year. Outbuildings and two-car garages keep vehicles secure and out of nature's elements and space to tinker. Endless hiking trails eliminate the need for a gym membership. Don’t miss out on any Penn State happenings, as everything is within reach via a 30-minute drive!
MlsNumber: --
ListingId: PACE2511538


Listing Provided By: RE/MAX Centre Realty, original listing
Phone: (814) 231-8200
Office Phone: (814) 231-8200
Agent Name: Brian Rater
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