hk_property_estates

PREMIUM 153 rows

HK multi-phase estates with location, price summary and new launches

Also on crescira.com →

No-code

Download a file

CSV and Parquet. Filtered exports.

See pricing
For engineers

Query with SQL

DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.

Open connection details
Agent builders

Connect to AI

MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.

See setup

Estate dimension: the TOP of the estate→phase→building→unit hierarchy — the large multi-phase Centaline development (e.g. "Ocean Shores", "Yoho Town"). Bilingual name, the stable numeric id, the building / phase footprint, and the estate-level extras: completion-date range, address, HK1980 grid centre, MTR proximity, the Centaline recent unit-price summary with its active-listing & transaction counts, neighbourhood geography, the Chinese developer legal name, and the primary-market new-launch block (new developments only). Join hk_property_phases / hk_property_buildings / hk_property_transactions on estate_code (or the numeric centa_estate_id). Standalone single-phase developments are intentionally absent — reach those through hk_property_phases.

Premium dataset

Evaluate it in full below: the evidence and a working sample are open to everyone. Buy or subscribe to unlock the complete dataset — your account is created automatically at checkout.

See access options

The evidence

Data coverage
Sep 2026 – present
Volume
153 rows
Last refreshed
12 October, 2026 (6 days ago)
Data through
12 October, 2026 (6 days ago)
Schema & column quality (44 columns)

Scroll table sideways to see more columns →

Column Type Description Populated Distinct
estate_code String Centaline estate code — primary identifier — —
centa_estate_id Nullable(Int64) Stable numeric Centaline estate id — integer alternate key (1:1 with estate_code) — —
estate_name_en Nullable(String) Estate name in English (modal across member buildings) — —
estate_name_zh Nullable(String) Estate name in Chinese (modal across member buildings) — —
building_count Int64 Distinct buildings resolved to this estate — —
phase_count Int64 Distinct phases under this estate — —
declared_building_count Nullable(Int64) Building count as declared by Centaline in the estate record (may exceed the observed building_count; a coverage cross-check, not the primary count) — —
declared_phase_count Nullable(Int64) Phase count as declared by Centaline in the estate record (cross-check against the observed phase_count) — —
estate_min_op_date Nullable(Date32) Earliest building occupation-permit (completion) date across the estate — the start of its build-out — —
estate_max_op_date Nullable(Date32) Latest building occupation-permit (completion) date across the estate — the end of its build-out — —
estate_address_en Nullable(String) Estate street address in English — —
estate_address_zh Nullable(String) Estate street address in Chinese — —
hk_grid_x Nullable(Float64) HK1980 grid easting of the estate centroid (metres; HK1980 Grid coordinate system) — —
hk_grid_y Nullable(Float64) HK1980 grid northing of the estate centroid (metres; HK1980 Grid coordinate system) — —
mtr_station Nullable(String) Name of the nearest MTR (Mass Transit Railway) station to the estate — —
mtr_walk_minutes Nullable(Int64) Walking time in minutes from the estate to the nearest MTR station — —
sale_unit_price_gross Nullable(Float64) Recent sale unit price on a gross (construction) area basis (HKD/sqft) — —
sale_unit_price_net Nullable(Float64) Recent sale unit price on a net (saleable) area basis (HKD/sqft) — the HK-standard quote; for many estates the only current sale-price signal — —
rent_unit_price_gross Nullable(Float64) Recent rent unit price on a gross (construction) area basis (HKD/sqft/month) — —
rent_unit_price_net Nullable(Float64) Recent rent unit price on a net (saleable) area basis (HKD/sqft/month) — —
sale_post_count Nullable(Int64) Number of active sale listings currently posted for the estate — —
sale_transaction_count Nullable(Int64) Number of recent sale transactions underlying the estate sale summary — —
rent_post_count Nullable(Int64) Number of active rental listings currently posted for the estate — —
rent_transaction_count Nullable(Int64) Number of recent rental transactions underlying the estate rent summary — —
summary_transaction_data_date Nullable(Date32) As-of date of the transactions underlying the price/rent/yield summary — how fresh the summarised figures are — —
summary_last_update_date Nullable(Date32) Date the estate price/rent/yield summary block was last refreshed by Centaline — —
scope_market_region Nullable(String) Centaline market-region classifier for the estate (scp_mkt) — the broad market segment — —
scope_territory Nullable(String) Centaline territory classifier for the estate (HK Island / Kowloon / New Territories grouping) — —
scope_hma_name Nullable(String) Housing Market Area (HMA) / neighbourhood name the estate belongs to — —
scope_hma_id Nullable(String) Housing Market Area (HMA) identifier — join key to hk_property_neighbourhoods — —
scope_hma_description Nullable(String) Descriptive blurb for the estate's Housing Market Area (neighbourhood) — —
scope_web_scope Nullable(String) Centaline web-scope classifier (site-navigation grouping) for the estate — —
scope_web_scope_id Nullable(String) Identifier for the Centaline web-scope grouping — —
district_code Nullable(String) Official district code for the estate (A..T; Centaline sub-areas U/V folded to Q/S) — links to hk_property_districts — —
developer_name_zh Nullable(String) Chinese legal-entity name of the estate developer — a join key to the CRHK company registry (not merely a translation of the English trade name) — —
new_prop_name_en Nullable(String) Marketing name of the new development in English (primary-market / new launches only) — —
new_prop_name_zh Nullable(String) Marketing name of the new development in Chinese (primary-market / new launches only) — —
new_prop_sales_status Nullable(String) Sales status of the new development (e.g. pre-sale / on sale / sold out) — primary-market only — —
new_prop_first_sales_date Nullable(Date32) First sales-arrangement date of the new development (primary-market only) — —
new_prop_estimated_key_date Nullable(Date32) Estimated handover (key collection) date for the new development (primary-market only) — —
new_prop_min_price_hkd Nullable(Int64) Minimum launch price of the new development in HKD (primary-market only) — —
new_prop_discount_price_hkd Nullable(Int64) Discounted launch price of the new development in HKD, where offered (primary-market only) — —
updated_at Nullable(DateTime64(3)) Timestamp of the latest source observation for this estate; null for estates with no dated source observation — —
id String Stable unique identifier for this row — the last column of every export. Use it to deduplicate, to key an incremental load, or to reference one specific row. It is additive: the entity and join keys you already use (estate_code) are unchanged. — —

Sample data

CSV Excel

Every estate in the register, full schema, no row cap. The register is small enough to ship in full.

SELECT * FROM renavon_exports.hk_property_estates LIMIT 50 0.02s
Loading data… | Click a header to sort; drag headers to reorder.

Choose your access

A Pass gives you freshness within a rolling window. The Full Archive gives you the full history we hold for the dataset, frozen at purchase. They solve different problems, and they work together.

Full refund within 14 days on subscriptions. Details →

Pass subscription

Hong Kong Property — Property Pass

Continuously updated, with API access.

View full package →
Access window
Full history (no window)
Updates
Continuous, within hours of the source
Delivery
API, SQL and downloads
Exports
1,000,000 rows/month included

Included Datasets

Hong Kong Property Buildings
Hong Kong Property Districts
Hong Kong Property Estates this dataset
Hong Kong Property Market Trends (Monthly)
Hong Kong Property Neighbourhoods
Hong Kong Property Phases
Hong Kong Points of Interest (multi-source)
Hong Kong Property Provisional Sales
Hong Kong Property Rentals
Hong Kong Property Transactions
Hong Kong Property Units
Hong Kong Property Usage Types
2 MONTHS FREE
US$1990
billed once a year
(US$165.83/month)
US$199
per month

Get notified when this dataset is updated.

Questions about this data?

Our data experts are ready to help clarify any aspects of this dataset.

Contact Our Team