HOROI

Resale condo scorecard · rubric v0.3

Cairnhill Nine

Resale condo scorecard · D09/CCR · 29 resale txns 2021-06–2026-03

C
55/100
88% measured

Carried by location & connectivity (4.0/5); capped by realized price trend (1.0/5).

Best for: Own-stay buyers shopping the estate, not the spreadsheet.

Overall55C

the headline rubric: price, trend, liquidity, location, lease

Value48C-

70th pctile of D09 LH peers · 21% below new-launch psf in D09

Investment45C-

+1.3%/yr realized · 8 txns/12mo · ~87yr lease left

The rubric

How we rate →

  • Entry Price vs Peers

    20%
    computed
    2.0/5

    2509

    $2509 median psf (24mo) = 70th pctile of 17 D09 LH peers (cheaper=better)

  • Realized Price Trend

    20%
    computed
    1.0/5

    +1.3%/yr

    own resale trend +1.3%/yr = 12th pctile of 1165 condos (first-12mo vs last-12mo avg psf, annualized)

  • Transaction Liquidity

    15%
    computed
    3.0/5

    8 txns / 12mo

    trailing-12mo resale volume; universe med ~6 — thin markets price badly

  • Location & Connectivity

    15%
    computed
    4.0/5

    5.4min walk to Somerset

    5.4min to SOMERSET MRT STATION Exit B (straight-line x1.35 detour @80m/min), 6 bus stops <=400m

  • Lease Profile

    15%
    computed
    4.0/5

    ~87yr left

    ~87yr remaining on 99yr lease; universe med ~81yr; bank-financing friction starts <60yr

  • Layout & Product

    5%
    partial
    3.5/5

    avg 98sqm, 44% <70sqm

    unit-mix from txn area distn (floor plans not in DB -> partial)

  • Sentiment Signal

    10%
    manual · awaiting data
    3.0/5

    Awaiting data — neutral placeholder. manual aggregated overlay (Tier3 fragile layer)

Strongest: Location & Connectivity · Weakest: Realized Price Trend. Each category is scored 0–5 against public anchors, multiplied by its weight and scaled to 100.

Key facts

Median resale psf (24mo)
$2,509 psf
Resales recorded (12 mo)
8
District / segment
D09 · CCR
Tenure
99-yr · ~87yr left
Nearest MRT
Somerset · 5.4 min walk
Data through
Mar 2026

Data coverage

88%

88% of this rating’s weight is measured from data. The rest is a clearly-labelled placeholder or estimate — never silently blended in.

computed
— fully measured from source data (full coverage credit)
partial
— real but proxy signal (half credit)
inferred
— estimate, dampened toward neutral (no credit)
manual
— neutral 3.0 placeholder awaiting data (no credit)

Map

Price history

median $psf by month

Median secondary-transaction $psf per month from URA caveat data. Thin bars show monthly transaction counts; gaps mean no transactions that month.

  • median secondary $psf
  • transactions / month
  • trend extrapolation — not a forecast