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

379 Walnut Street
Howard, PA 16841
Mandy Regel with United Real Estate, original listing - (484) 367-7727

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $289,900
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2121 Square Feet
Agency: United Real Estate
Agency Phone: (484) 367-7727

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1902
Notes: [[ OPEN HOUSE SUNDAY (11/3) from 2-4PM -- PLEASE FOLLOW PARKING SIGN AND PARK ALONG SCHOOL STREET & ENTER AT FRONT DOOR ]] Fully remodeled, top to bottom, in the heart of desirable Howard, PA! This gorgeously remodeled 4-bedroom, 2-bath brick 2-story is just steps from Howard Elementary School and around the corner from Foster Joseph Sayers Reservoir and Bald Eagle State Park. Imagine stepping out onto that classic, covered front porch every day — perfect for sipping your morning coffee, waving to neighbors, and enjoying quiet evenings with a book. It’s the kind of porch that just begs for a rocking chair (or two!). Step inside, and you’ll be greeted by a spacious, welcoming foyer. This traditional layout flows beautifully, guiding you right into the heart of the home: a sleek kitchen that’s been stylishly updated with stainless steel appliances and all the storage space you could dream of. The laundry room is a total game-changer —massive, with tons of storage, and ALL the room to bring your pinterest-inspired ideas to life. You won't be disappointed in the size of these bedrooms, which give you plenty of room and plenty of closet space for everyone to stretch out and make themselves at home. Level yard, perfect for your summer BBQ's, a game of catch, or just lounging around. Detached garage/shed tucked in the back yard with parking in the rear for multiple vehicles. Need a spot for tools, bikes, or that DIY project you’ve been dreaming of? You’ve got it! From the gorgeous traditional front porch to the modern vibes inside, this home has it all. It’s welcoming, it’s inviting, and it’s ready for you to make it your own. Come on over, take a look around, and picture yourself living here — you’ll know you’re home the moment you step through the door at 379 Walnut Street! Offers will be considered after open house.
MlsNumber: --
ListingId: PACE2512202


Listing Provided By: United Real Estate, original listing
Phone: (484) 367-7727
Office Phone: (484) 367-7727
Agent Name: Mandy Regel
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