Title Page Background
DEBUG FN args: Array ( [0] => 2252 [1] => [2] => [3] => agent ) BEFORE: Site: 2252 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2252 Igate: njhud LocID: 2252 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 = 2252 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2252 [1] => [2] => [3] => lender ) BEFORE: Site: 2252 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2252 Igate: njhud LocID: 2252 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 = 2252 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2252 [1] => [2] => [3] => other ) BEFORE: Site: 2252 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2252 Igate: njhud LocID: 2252 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 = 2252 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

130 Aspen Drive
Boalsburg, PA 16827
Steven Bodner with RE/MAX Centre Realty, original listing - (814) 231-8200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4754 Square Feet
Agency: RE/MAX Centre Realty
Agency Phone: (814) 231-8200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Beautiful brick two story built by Paul Stumpf on 2 acres in wonderful Aspen Heights! With an impressive circular driveway and a welcoming covered front porch with lit slate steps, you'll feel at home pulling up. Enter into a two story foyer with a turned staircase and expansive hardwood flooring on the main floor. The large front office provides a great view while the sizable front dining room, currently used as a music room, will accommodate large dinner parties. Cooking is a delight in the enormous, remodeled chef's kitchen complete with plentiful quality cabinetry, granite countertops, a large island with cabinets on both sides, two pantry cabinets with pullouts, newer stainless steel appliances including a double oven and gas cooktop, and ample lighting. The spacious great room boasts a vaulted ceiling, a gas fireplace, and access to the partially covered rear patio, while the generously sized main floor primary suite boasts a sitting area with patio and hot tub access, a spa like bath with a walk-in shower and jetted tub, and a large walk-in closet. A main floor laundry/mudroom with storage cabinets and a utility sink and a half bath complete the main floor. Upstairs you'll find four bedrooms with two Jack-and-Jill style baths giving each bedroom their own sink area. Have fun in the sprawling finished lower level featuring built-ins in the family room, a hobby space, an office/guest room, a half bath, and a large storage and utility room. Relax on the expansive rear paver patio taking in the private and nicely landscaped & fenced yard or get loose in the hot tub. With a three car garage and extra driveway space you'll have plenty of room for cars and toys. Situated on a very private lot in an upscale neighborhood that's close to the shops, restaurants and parks of Boalsburg, Mountain View Country Club, Rothrock State Forest and Tussey Mountain Ski and Fun area, yet not far from downtown State College and Penn State via the highway, you'll love the location. Luxury living awaits you!
MlsNumber: --
ListingId: PACE2514506


Listing Provided By: RE/MAX Centre Realty, original listing
Phone: (814) 231-8200
Office Phone: (814) 231-8200
Agent Name: Steven Bodner
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] => centre [3] => PA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: centre State: PA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: centre State: PA 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 = 2252 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Jordan McCracken
ASCIIRE/MAX Centre Realty - The Linda & Ryan Lowe Team
Call Today!: (814) 762-4970

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App