2900 SOUTH QUEEN STREET
Sheriff sale York County Sheriff attorney portal · checked Aug 28, 2026
Sale dateOct 5, 2026Case #2025-SU-000668PlaintiffFREEDOM MORTGAGE CORPORATIONDefendantBRACKEN, ANDREW C.AttorneyTHE MANLEY LAW FIRM LLC · 614-767-7003Judgment$182,873Sourcecounty listing ↗
AVM value$307,000
RealEstateAPI estimate, Aug 21, 2026 — not an appraisal
Judgment$182,873
county filing
Opening bid / upset—
not published yet — most counties post near/on sale day
Title position1st? Likely senior
model from REAPI mortgage records — not a title search
Rehab (modeled)$53,000
model: medium tier · $35/sqft × 1,502 sqft — no inspection; range $37,000–$74,000
Potential profit$46,567
model — breakdown below
Title position (model): Foreclosing lien appears to be the senior mortgage (Wells Fargo Bank Na, recorded First) (matched by judgment-to-loan amount only — plaintiff name doesn't match, likely an assignment). Junior liens are typically divested; taxes/municipal claims can still prime. Inputs: the open-mortgage records shown below.
How the profit estimate is computed methodology
| Line | Source | Amount |
|---|---|---|
| AVM value | RealEstateAPI, fetched Aug 21, 2026 | $307,000 |
| Purchase basis (judgment) | county filing — actual price is set by bidding and can exceed this | − $182,873 |
| Rehab (medium tier) | model: $35/sqft × 1,502 sqft, no inspection | − $53,000 |
| Selling & holding | model: 8% of AVM value | − $24,560 |
| Potential profit | screening estimate — not underwriting | $46,567 |
Valuation RealEstateAPI · Aug 21, 2026
AVM value (estimate)$307,000Est. open loans$168,938Owner equity$155,094Assessed value$105,370County market value$105,370Annual taxes$3,617
Property RealEstateAPI (county assessor data)
TypeSingle Family ResidenceBeds3Baths1Living area1,502 sqftLot20,691 sqftYear built1950
Ownership RealEstateAPI (deed/assessor records)
OwnerAndrew BrackenOwner occupiedYesVacantNoYears owned7.2Last saleJun 10, 2019 · $163,000Distress flagsauction, preForeclosure
Flags come from RealEstateAPI's nationwide database and can miss county-level (Prothonotary) filings — treat "none" as "none reported", not clear title.
Open mortgages RealEstateAPI recorded-mortgage data — original amounts, not payoff balances
| Position | Date | Lender | Original amount | Type |
|---|---|---|---|---|
| First | May 10, 2021 | Wells Fargo Bank Na | $168,938 | Va |
Mortgage history RealEstateAPI recorded-mortgage data
| Date | Lender | Amount | Type |
|---|---|---|---|
| May 10, 2021 | Wells Fargo Bank Na | $168,938 | Va |
| Mar 6, 2015 | Gateway Funding Diversified Mtg Svcs Lp | $133,677 | FHA |
Sale history RealEstateAPI deed records
| Date | Amount | Buyer | Seller |
|---|---|---|---|
| Jun 10, 2019 | $163,000 | Andrew C Bracken | Christa M Smeltzer, Brian Wagman |
| Aug 16, 2013 | $148,800 | Christa M Smeltzer | Trusted Property Group Llc |
| Mar 22, 2013 | $69,000 | Trusted Property Group Llc | Marcelino Pala Jr, Nancy Pala |