510 RIDGEVIEW DRIVE
Sheriff sale York County Sheriff attorney portal · checked Aug 28, 2026
Sale dateOct 5, 2026Case #2023-SU-001501PlaintiffMIDFIRST BANKDefendantBURNS, ROBERT K.AttorneyTHE MANLEY LAW FIRM LLC · 614-767-7003Judgment$83,484Sourcecounty listing ↗
AVM value$394,000
RealEstateAPI estimate, Aug 21, 2026 — not an appraisal
Judgment$83,484
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)$98,000
model: heavy tier · $55/sqft × 1,773 sqft — no inspection; range $69,000–$137,000
Potential profit$180,996
model — breakdown below
Title position (model): Foreclosing lien appears to be the senior mortgage (Columbia National Inc, 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 | $394,000 |
| Purchase basis (judgment) | county filing — actual price is set by bidding and can exceed this | − $83,484 |
| Rehab (heavy tier) | model: $55/sqft × 1,773 sqft, no inspection | − $98,000 |
| Selling & holding | model: 8% of AVM value | − $31,520 |
| Potential profit | screening estimate — not underwriting | $180,996 |
Valuation RealEstateAPI · Aug 21, 2026
AVM value (estimate)$394,000Est. open loans$123,950Owner equity$366,288Assessed value$177,830County market value$177,830Annual taxes$5,318
Property RealEstateAPI (county assessor data)
TypeSingle Family ResidenceBeds3Baths3Living area1,773 sqftLot13,199 sqftYear built1994
Ownership RealEstateAPI (deed/assessor records)
OwnerRobert Burns & Lauren BurnsOwner occupiedYesVacantNoYears owned25.8Last saleNov 9, 2000 · $0Distress 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 | Nov 9, 2000 | Columbia National Inc | $123,950 | Fha |
Mortgage history RealEstateAPI recorded-mortgage data
| Date | Lender | Amount | Type |
|---|---|---|---|
| Nov 9, 2000 | Columbia National Inc | $123,950 | Fha |
Sale history RealEstateAPI deed records
| Date | Amount | Buyer | Seller |
|---|---|---|---|
| Nov 9, 2000 | $0 | Robert K Burns, Lauren A Burns | Lauren A Burns, Robert K Burns |