TD GameChangerLoading details
Loading rows
Middletown, Pennsylvania, 17057
Opening bid
$8,663
Assessed value
$85,600
Market / AVM
$213,000
Taxes owed
—
Property facts enriched via realestateapi · 9/29/2026
Physical conditions that affect value and rarely appear on a listing.
Active freight track on a mainline. Noise, vibration and horn use at crossings — check where the nearest crossing is before assuming quiet.
Where a line crosses a parcel there is usually a recorded easement restricting what can be built under it — check the deed, not the map.
Odour travels much further than noise and is seasonal.
Truck traffic and operating hours are the usual complaint.
Meaningful grade. Site work costs rise sharply and septic approval is not automatic.
RealEstateAPI PropertyDetail · Every populated field, as returned · 259 values
| Id | 37,586,219 |
|---|---|
| Beds | 3 |
| Baths | 1 |
| Equity | $138,000 |
| Flood zone | Yes |
| Inherited | Yes |
| High equity | Yes |
| Notice type | FOR |
| Last sale date | 2021-04-06 |
| Property type | SFR |
Official appraiser / assessor — free, always available. Copy the parcel number if the link opens a search page.
No historical bucket for PA|Tax Deed
No recorded comps yet for this state/sale type. Run deedpilot-copilot import-history --deep and build-history-index.
Index 2026-08-01 · 87,879 total recorded outcomes
This record was compiled from the published sale list. Parcels are pulled, redeemed, and re-priced up to the moment of sale. Confirm the lot is still in the sale, and confirm the opening bid, directly with the county.
Dauphin County Tax Claim Bureau ↗Transformer hum, and a persistent resale objection whatever the engineering says.
Frontage or flood exposure depending on elevation and zone — read this next to the FEMA signal, not on its own.
Ground elevation at the parcel. Compare with the FEMA base flood elevation where one is published.
190 of 2,457 units vacant year-round, around or below the national tract average.
Self-reported median across the whole tract — context for whether a number is plausible, not a comparable and never a bid input.
Tract median household income. Sets what a local buyer can finance.
Outside the 1% annual chance floodplain.
A mapped public road runs along or beside the parcel.
Owner-occupied majority, which usually means a retail resale is possible.
© OpenStreetMap contributors (ODbL). Flood zones from FEMA, elevation from USGS, tract statistics from the US Census. Proximity is measured from the parcel’s recorded location, which for most parcels is an assessor centroid rather than a boundary — treat these as figures to verify on a site visit, not as survey distances.
| Absentee owner |
|---|
| Yes |
| Equity percent | 67 |
|---|
| Flood zone type | X |
|---|
| Investor buyer | Yes |
|---|
| Estimated value | $213,000 |
|---|
| Last update date | 2026-09-23 00:00:00 UTC |
|---|
| Estimated equity | $143,237 |
|---|
| Loan type code first | LOC |
|---|
| Maturity date first | 2047-12-11 |
|---|
| Open mortgage balance | $75,000 |
|---|
| Flood zone description | AREA OF MINIMAL FLOOD HAZARD |
|---|
| In state absentee owner | Yes |
|---|
| Estimated mortgage balance | $69,763 |
|---|
| Estimated mortgage payment | $450 |
|---|
| Apn | 34-031-043 |
|---|---|
| Land use | Residential |
| Lot acres | 0.50 |
| Census block | 3049 |
| Census tract | 024001 |
| Property use | Single Family Residence |
| Lot depth feet | 172.3 |
| Lot width feet | 155 |
| Lot square feet | 21,647 |
| Property class | The general use for the property is for residential purposes |
| Apn unformatted | 34031043 |
| Census block group | 9 |
| Year | 2,026 |
|---|---|
| Tax amount | $3,056 |
| Property id | 37,586,219 |
| Market value | $85,600 |
| Assessed value | $85,600 |
| Assessment year | 2,026 |
| Market land value | $13,300 |
| Assessed land value | $13,300 |
| Tax delinquent year | 2024 |
| Market improvement value | $72,300 |
| Assessed improvement value | $72,300 |
| Seq no | 1 |
|---|---|
| Sale date | 2021-04-06 |
| Buyer names | Dennis K Berstler Jr |
| Seller names | Dennis K Berstler Jr, Bobbi Jo Berstler |
| Document type | Intrafamily Transfer |
| Recording date | 2021-04-27 |
| Document number | 20210014061 |
| Purchase method | Cash Purchase |
| Owner individual | Yes |
| Transaction type | Non-Arm's Length Transactions |
| Document type code | DTIT |
| Prior owner individual | Yes |
| Prior owner months owned | 72 |
| Equity | $138,000 |
|---|---|
| Owner1 type | Individual |
| Owner2 type | Other |
| Mail address · zip | 17033 |
| Mail address · city | Hershey |
| Mail address · fips | 42043 |
| Mail address · zip4 | 2029 |
| Mail address · house | 204 |
| Mail address · label | 204 Peach Ave, Hershey, PA 17033 |
| Mail address · state | PA |
| Mail address · county | Dauphin County |
| Mail address · street | Peach |
| Mail address · address | 204 Peach Ave |
| Mail address · carrier route | C013 |
| Mail address · address format | S |
| Absentee owner | Yes |
| Owner1 full name | Dennis Berstler Jr |
| Owner1 last name | Berstler Jr |
| Owner1 first name | Dennis |
| Ownership length | 65 |
| In state absentee owner | Yes |
| Seq no | Sale date | Buyer names | Seller names | Document type | Recording date | Document number | Purchase method | Owner individual | Transaction type | Document type code | Ltv | Book | Page | Arms length | Sale amount | Down payment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2021-04-06 | Dennis K Berstler Jr | Dennis K Berstler Jr, Bobbi Jo Berstler | Intrafamily Transfer | 2021-04-27 | 20210014061 | Cash Purchase | Yes | Non-Arm's Length Transactions | DTIT | ||||||
| 2 | 2015-04-16 | Dennis Berstler Sr | Federal Home Loan Mortgage Corporation | Warranty Deed | 2015-04-28 | Cash Purchase | Yes | Arms Length Residential Transactions (Purchase/Resales) | DTWD | 100 | 2015 | 0009534 | Yes | $72,000 | $72,000 | |
| 3 | 2014-11-18 | Federal Home Loan Mortgage Corporation | J R Lotwick Sheriff, Clarence L Hanan Jr | Sheriffs Deed | 2014-11-19 | Cash Purchase | Foreclosure | DTSD | 2014 | 0027955 | Yes |
| Fmr year | 2023 |
|---|---|
| Hud area code | METRO25420M25420 |
| Hud area name | Harrisburg-Carlisle, PA MSA |
| Median income | $69,571 |
| Fmr efficiency | $847 |
| Fmr one bedroom | $975 |
| Fmr two bedroom | $1,228 |
| Suggested rent | $1,570 |
| Fmr four bedroom | $1,650 |
| Fmr three bedroom | $1,570 |
| Pool | Yes |
|---|---|
| Address · zip | 17057 |
| Address · city | Middletown |
| Address · fips | 42043 |
| Address · zip4 | 5325 |
| Address · house | 958 |
| Address · label | 958 Red Hill Plaza Rd, Middletown, PA 17057 |
| Address · state | PA |
| Address · county | Dauphin County |
| Address · street | Red Hill Plaza |
| Address · address | 958 Red Hill Plaza Rd |
| Address · street type | Rd |
| Address · carrier route | R001 |
| Address · jurisdiction | Dauphin County |
| Address · congressional district | 10 |
| Bedrooms | 3 |
| Deck area | 0 |
| Latitude | 40.14313410365034 |
| Pool area | 800 |
| Bathrooms | 1 |
| Fireplace | Yes |
| Longitude | -76.71853635057663 |
| Patio area | 0 |
| Year built | 1,961 |
| Fireplaces | 1 |
| Garage type | Attached Garage |
| Rooms count | 0 |
| Units count | 0 |
| Property use | Single Family Residence |
| Construction | Masonry |
| Lot square feet | 17,424 |
| Parking spaces | 1 |
| Buildings count | 0 |
| Property use code | 385 |
| Garage square feet | 0 |
| Living square feet | 1,232 |
| Partial bathrooms | 0 |
| Basement square feet | 1,232 |
| Building square feet | 1,232 |
| Price per square foot | 0 |
| Parcel account number | 340310430000000 |
| Utilities sewage usage | Septic |
| Utilities water source | Well |
| Plumbing fixtures count | 0 |
| Basement finished percent | 0 |
| Basement square feet finished | 0 |
| Basement square feet unfinished | 0 |
| Seq no | Lender name | Notice type | Auction date | Auction time | Document type | Judgment date | Trustee phone | Foreclosure id | Recording date | Trustee address | Trustee full name | Estimated bank value | Auction street address |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | OCWEN LOAN SERVICING LLC | FOR | 2014-07-17 | 10:00A AM | Notice of Foreclosure Sale | 2014-07-17 | 215-563-7000 | 5,716,605 | 2014-04-16 | 1617 JFK BOULEVARD SUITE 1400 PHILADELPHIA PA 19103 | PHELAN HALLINAN AND SCHMIEG LLP | $213,000 | THE DAUPHIN COUNTY COURTHOUSE, HARRISBURGPA |
| 2 | OCWEN LOAN SERVICING LLC | FOR | 2014-10-16 | 10:00A AM | Notice of Foreclosure Sale | 2014-10-16 | 215-563-7000 | 6,023,010 | 2014-08-04 | 1617 JFK BOULEVARD SUITE 1400 PHILADELPHIA PA 19103 | PHELAN HALLINAN AND SCHMIEG LLP | $213,000 | THE DAUPHIN COUNTY COURTHOUSE, HARRISBURGPA |
| 3 | OCWEN LOAN SERVICING LLC | FOR | 2014-04-17 | 10:00A AM | Notice of Foreclosure Sale | 2014-04-17 | 215-563-7000 | 5,593,078 | 2014-02-27 | 1617 JFK BOULEVARD SUITE 1400 PHILADELPHIA PA 19103 | PHELAN HALLINAN AND SCHMIEG LLP | $213,000 | THE DAUPHIN COUNTY COURTHOUSE, HARRISBURGPA |
| Open | Term | Seq no | Amount | Loan type | Position | Term type | Lender code | Lender name | Lender type | Mortgage id | Grantee name | Document date | Loan type code | Maturity date | Recording date | Document number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Yes | 300 | 1 | $75,000 | Credit Line (Revolving) / Heloc | First | Month | B | Northwest Bank | Bank | 196467 | Dennis K Berstler Jr | 2022-12-07 | LOC | 2047-12-11 | 2022-12-07 | 20220036968 |
| Term | Seq no | Amount | Loan type | Position | Term type | Lender code | Lender name | Lender type | Mortgage id | Grantee name | Document date | Loan type code | Maturity date | Recording date | Document number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 300 | 1 | $75,000 | Credit Line (Revolving) / Heloc | First | Month | B | Northwest Bank | Bank | 196467 | Dennis K Berstler Jr | 2022-12-07 | LOC | 2047-12-11 | 2022-12-07 | 20220036968 |
| Ids | 37586219, 151296857 |
|---|---|
| Total owned | 2 |
| Total value | $546,000 |
| Total equity | $335,208 |
| Purchased last6mos | 0 |
| Purchased last12mos | 0 |
| Total mortgage balance | $210,792 |