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

188 Scenic Ridge Drive
Hummelstown, PA 17036
Kara Pierce with EXP Realty, LLC, original listing - (888) 397-7352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4929 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (888) 397-7352

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Home office? Check. Home gym? Check. Finished walkout basement and private fenced-in yard? Check & check! Allow this impeccable Landmark fusion of architecture, aesthetics, and function draw you in and keep you here. On an exceptional lot in the regal Ridgewood of South Hanover Township, 188 Scenic Ridge owes its namesake to the woodsy views from the privacy of your expansive deck. With almost 5,000 sq ft of living space, everyone can enjoy separation of space while working or schooling from home. On the weekends, take advantage of that functional open concept to entertain! Guests will flow easily from the expanded kitchen to the living room, up to the loft to watch movies or sports on the projector, out onto the maintenance-free deck, and further out to the fenced-in yard. You'll appreciate the spacing of the homes, designed to protect privacy without losing a sense of cohesiveness. After grilling out back this summer, take the whole crew to King Kone down the street for ice cream. You can always invest an hour later to burn off the calories in your own private gym! As the sun sets, unwind in the spacious master suite by taking a soak in the whirlpool tub, planning outfits for tomorrow in your room of a closet, then sinking into bed while dim lights on the tray ceiling soothe you to sleep. Wake up, sink your feet into the new carpet, take your coffee out to the deck to watch the sun rise, take a stroll around the walking trail, turn on the music through the built-in speakers, and start mentally preparing for the day. With 9' ceilings, Superior wall foundation, new first floor carpet, abundant natural light, tons of storage and more--you will truly enjoy the marriage of design, comfort, and amenities that this home provides. The sellers will miss the neighbors, being able to take home call for Hershey Med, and all the friendliness and safety they felt living in suburban Pennsylvania. Minutes to nearby parks and hiking trails, Giant, grocery store, shoppes, and access to major highways. Monthly electric utility cost with PP&L is $0 or + credits because of Tesla solar roof owners had installed, which is quite the advantage for an all-electric home and electric car owners. New oven, washing machine, dryer, dishwasher all stay with home.
MlsNumber: --
ListingId: PADA2040536


Listing Provided By: EXP Realty, LLC, original listing
Phone: (888) 397-7352
Office Phone: (888) 397-7352
Agent Name: Kara Pierce
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 = 2260 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 Tasha Coley
Tasha Coley
ASCIIColdwell Banker Realty
Call Today!: (717) 398-8793

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App