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

482 Foxridge Lane
Flinton, PA 16640
Bob Langton with Keller Williams Realty, original listing - (717) 657-4700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $189,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1500 Square Feet
Agency: Keller Williams Realty
Agency Phone: (717) 657-4700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Manufactured Home
Year Built: 1980
Notes: Located in Glendale Yearound recreational community, this spacious ranch home has been completely updated and expanded. This cozy two-bedroom two full bath ranch house offers a spacious family room featuring vaulted ceilings and atrium door leading to the back deck. It also has a gas stove/fireplace and additional gas fireplace; wall mount large TV an abundance of windows providing great views of the outdoors. Every room in the house features a ceiling fan and lighting. The new master bedroom with a spacious closet and seating area and new master bathroom. The second bedroom is equipped with a large closet with plenty of storage located off the kitchen area with a full bathroom attached. This addition also offers high efficient hydroelectric baseboard heating as a back up source. The den has larger windows and atrium doors lead to the large L-shaped deck at the rear of the home. It also features a gas fireplace for heating the home. There is a newly installed front porch with cozy seating area leading to the den main entrance to the home entrance. The rear deck has one of the best views in the entire complex overlooking a large field. It offers deer grazing in the morning and evening along with watching the seasons change. Enjoy cook outs or simply entertaining family and guests any day of the week. The updated kitchen and dining area combined with new counter tops back splash and paint offer a cozy area to entertain guests. New electric stove and refrigerator along with new counter tops and backsplash and small bar area that will seating two. Lots of storage as well with shelving. The premium flooring caps off a beautifully recently remolded seating area. The laundry room is equipped with new washer and dryer and plenty of storage doubling as a pantry. The spacious ½ acre yard is partially fenced in with 3 gates for access. The home features a Generac back up generator that runs the whole house in the case of a power outage. The large, shed has two work benches and plenty of storage with a golf card garage on the other side. Your outdoor firepit has an abundance split wood enough to last a couple of years located in two locations. There is room to seats at least 15 chairs around the area to enjoy evening fires with family and friends. Included is the community is a heated swimming pool. Basketball court, tennis and pickle ball court along with several pavilions that can be reserved for family outings. You can rent the club house for birthday parties along with the pool in the evenings. There are two children's playgrounds and a kiddie's pool as well. The POA puts on social events all year long ranging from breakfast, dinners and local bands in the evening. The property has an option to be purchased furnished if requested at an additional price. This is a must-see property you will love it if you see it.
MlsNumber: --
ListingId: PACA2000594


Listing Provided By: Keller Williams Realty, original listing
Phone: (717) 657-4700
Office Phone: (717) 657-4700
Agent Name: Bob Langton
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