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

480 Blue Mountain Parkway
Harrisburg, PA 17112

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3241
Agency: RE/MAX Realty Professionals, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1987
Notes: This Canadian designed, contemporary lodge style home sits tucked back in the woods of Fishing Creek Valley. With post and beam construction this home was built to last. The exterior walls are built with 2x6 boards for better insulation... keeping you warm in the winter and cool in the summer. The design is contemporary but still has that cozy, home feeling. With its mature landscaping it's really a site to see in full spring bloom.<br /> <br /> When you enter the home you walk through the large foyer and into the main living space, covered in hardwood floors and ahead of its time, it's almost entirely an open design concept. There's no shortage of views and natural light, windows line the back of the house. If you love to entertain that won't be a problem with this many gathering spaces. The main living room has cathedral ceilings so plenty of room for that extra-large TV, perfect for game days. The kitchen has a brand new refrigerator and state-of-the-art induction cook-top. You can watch the beautiful birds fly in and enjoy their feeders out the window over the sink, making those dishes a little more bearable. The sunroom is beautiful and functional any time of the year!<br /> <br /> Upstairs is fully carpeted and features a cozy little loft that overlooks the living room. The two secondary bedrooms are to the front of the house and are of equal size. A full bath with double vanity is at the end of the hall. On the back side of the house is the primary suite complete with a shoe closet, walk-in closet, full tile walk-in shower, soaking tub and double vanity.<br /> <br /> The fully finished walk-out basement is where you'll find a second living room with a large glass sliding door with access to a patio and backyard. You'll also find a large utilities closet with the washer and dryer. The fourth bedroom, currently being used as an office is downstairs as well. Great for a guest room, it has its own entrance, a walk-in closet and attached half bath.<br /> <br /> Exit to the backyard and you'll see it's not just woods but has grass and room to play. A lovely fish pond with stone waterfall add to the perfect background noise to serene ambiance. To the very back of the property is a brand new shed with a storage loft and rot resistant flooring. The well camouflaged and beautifully landscaped sand mound flanks the right side of the home near the two car garage. Making for an extra lovely part of the yard, instead of the typical eye sore. With another utility shed attached to the garage this home has no lack of storage inside or out. If you're looking for a quiet, spacious, unique, well-built, well-maintained and manicured home... surrounded by nature, this is for you! Come make it yours.<br /> <br /> Other things to note: New Anderson Windows and Doors throughout. New water heater, water pump, refrigerator, induction cook-top, washer, dryer and shed. All replaced within the last 5 years. 12 year old roof.<br /> <br /> Listing Agent is related to sellers.
MlsNumber: PADA2032682


Listing Provided By: RE/MAX Realty Professionals, Inc., original listing
Name: RE/MAX Realty Professionals, Inc.
Phone: (717) 652-4700
Office Name: RE/MAX Realty Professionals
Office Phone: (717) 652-4700
Agent Name: Brii Reichley
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 = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;
Shantel Williams
ASCIILOAN DEPOT
Call Today!: (520) 954-2275

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App