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

413 Harrison Avenue
Glenolden, PA 19036

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1969 Square Feet
Agency: BHHS Fox & Roach Center City-Society Hill
Agency Phone: (215) 627-6005

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Other-Other
Year Built: 1954
Notes: Welcome to 413 Harrison Ave, a charming and meticulously maintained Cape Cod style home nestled on a peaceful cul-de-sac in Glenolden. This delightful four bedroom, two-and-a-half-bathroom residence has been thoughtfully cared for by its current owners since 2006, offering a blend of comfort, character, and modern convenience. Upon entering, you'll find a spacious living room with original hardwood flooring and abundant natural light. The main floor has two bedrooms and a full bathroom providing easy access to all essential living areas, no need for the stairs! The well- appointed kitchen features modern appliances, ample cabinet space, and even offers space for a small kitchen table and chairs. Off the kitchen you will find even more living space with a huge addition that is currently being used as a family room and formal dining area. Conveniently located in the addition, you will find the washer/dryer as well. Through the doors of the addition you will find a private deck. This outdoor space offers a tranquil spot to relax, entertain, or enjoy the serene surrounding of this cul-de-sac location. Up the stairs you will find another two bedrooms, both nicely sized with hardwood flooring and ample closet space. You will also find another full bathroom on this level. Another highlight of this property is the large finished basement, which offers a custom Irish Pub style bar, fireplace, half bathroom, and a second full kitchen, creating an ideal space for gatherings and special occasions. In the basement you will also find a utility room that holds the homes mechanicals and offers a space for additional storage. Through the utility room there is a walk-out exit that leads to the properties back yard. This property offers significant updates, including new roof and windows installed in 2015 and a full back-up generator. These updates make this property an ideal low maintenance option for buyers seeking long-term value and quality. All this and located within close proximity to Philadelphia, I-95, plenty of public transit options, John Heinz, and many local Delco hot spots.
MlsNumber: --
ListingId: PADE2079402


Listing Provided By: BHHS Fox & Roach Center City-Society Hill, original listing
Phone: (484) 802-6597
Office Phone: (215) 627-6005
Agent Name: Liz LaPorta
Disclaimer: Copyright © 2024 Berkshire Hathaway HomeServices Fox & Roach, Realtors. 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 = 3443 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;
Andy Mariano
ASCIIRE/MAX Preferred
Call Today!: (484) 433-1179

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App