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

2391 Stumptown Rd
Bird-in-hand, PA 17505
Elam Esh with Double E Auction Service, original listing - (717) 327-1215

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 5
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2240 Square Feet
Agency: Double E Auction Service
Agency Phone: (717) 327-1215

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1977
Notes: PUBLIC AUCTION SCHEDULED FOR DECEMBER 9, 2024 @ 4:00 PM. LISTED PRICE IS A SUGGESTED OPENING BID ONLY AND IS NOT INDICATIVE OF THE FINAL SALE PRICE.This charming 2 sty home consists of an up-to-date kitchen w/stained rsd panel cabinets w/Quartz countertops, a spacious 24"x60" kitchen island w/Quartz countertop & plenty of storage, pantry cabinetry, case openings leading into dining rm w/ext patio door access to a large patio, cheery living rm w/original hardwood flooring, cozy family rm w/brick fireplace &hardwood flooring, mudroom/laundry rm w/closets &tile flooring, foyer entry w/ext access to Victorian style porch w/pillars, partial open stairway which leads to second floor master bdrm w/closets and access to master bath w/tub/shower combo, 4 other bdrms w/closets, 2nd full bath, carpet thruout 2nd floor, hallway linen closets, Home also has a full basement w/700 sq ft finished area w/carpet flooring, family room, canned good storage/utility rm w/Bilco dr ext access, Central air, 200 amp service, forced air heat, oil furnace, water system, electric water heater. Newer 36'x40' 2 sty barn w/maintenance free exterior w/vinyl board & batton siding & beautiful stone work, 3 horse stalls w/convenient metal Dutch door pasture access, wash bay, 14'x22' shop/storage area, interior &poly exterior stairs leading to full second floor rec room/storage area w/8'x7' OH door, 10'x18' shed w/matching siding & stonework. This all is situated on 1.39 Acres w/fenced-in pastures, large lawn area, garden area, tall mature shade trees, beautiful well-kept flowerbeds & shrubbery, landscape walls, macadam driveway w/parking. Wonderful opportunity to purchase a true gem property in Bird-In-Hand area!!
MlsNumber: --
ListingId: 11363198


Listing Provided By: Double E Auction Service, original listing
Phone: (717) 327-1215
Office Phone: (717) 327-1215
Agent Name: Elam Esh
Disclaimer: Copyright © 2024 My State 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 = 2274 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 Nicole Aquilini
Nicole Aquilini
ASCIICentury 21 Home Advisors
Call Today!: (610) 780-4814

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App