resale_prices

Data license: Singapore Open Data Licence · Data source: Housing and Development Board · About: hdb-resale-prices-datasette

where street_name = "BEDOK STH AVE 2"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ month town flat_type block street_name storey_range floor_area_sqm flat_model lease_commence_date resale_price remaining_lease_years remaining_lease latitude longitude
1899 1899 2024-10 BEDOK 4 ROOM 7 BEDOK STH AVE 2 04 TO 06 82.0 Improved 1976 453888.0 50 50 years 04 months 1.32281544267372 103.93545524391
1900 1900 2024-10 BEDOK 4 ROOM 34 BEDOK STH AVE 2 07 TO 09 90.0 Improved 1977 480888.0 52 52 years 1.32205652925918 103.93835472666
1931 1931 2024-10 BEDOK 3 ROOM 33 BEDOK STH AVE 2 10 TO 12 73.0 New Generation 1978 410000.0 52 52 years 06 months 1.32283703302242 103.939124525951
4088 4088 2024-09 BEDOK 5 ROOM 14 BEDOK STH AVE 2 04 TO 06 122.0 Improved 1995 835000.0 70 70 years 04 months 1.3213611911805 103.936185399688
4093 4093 2024-09 BEDOK 4 ROOM 7 BEDOK STH AVE 2 10 TO 12 82.0 Improved 1976 470000.0 50 50 years 05 months 1.32281544267372 103.93545524391
6667 6667 2024-08 BEDOK 4 ROOM 7 BEDOK STH AVE 2 13 TO 15 82.0 Improved 1976 472888.0 50 50 years 07 months 1.32281544267372 103.93545524391
9627 9627 2024-07 BEDOK EXECUTIVE 10F BEDOK STH AVE 2 13 TO 15 142.0 Apartment 1993 1180000.0 67 67 years 11 months 1.32221773472774 103.937001345916
9670 9670 2024-07 BEDOK 4 ROOM 37 BEDOK STH AVE 2 01 TO 03 84.0 Improved 1977 475000.0 52 52 years 03 months 1.32190663617287 103.939847213862
9723 9723 2024-07 BEDOK 3 ROOM 33 BEDOK STH AVE 2 07 TO 09 73.0 New Generation 1978 413000.0 52 52 years 08 months 1.32283703302242 103.939124525951
9724 9724 2024-07 BEDOK 3 ROOM 33 BEDOK STH AVE 2 13 TO 15 73.0 New Generation 1978 401000.0 52 52 years 09 months 1.32283703302242 103.939124525951
11844 11844 2024-06 BEDOK EXECUTIVE 10E BEDOK STH AVE 2 01 TO 03 143.0 Apartment 1993 910000.0 68 68 years 1.3216200934601 103.937040959341
11889 11889 2024-06 BEDOK 4 ROOM 35 BEDOK STH AVE 2 07 TO 09 90.0 Improved 1977 500000.0 52 52 years 04 months 1.32233220742919 103.939766219283
11891 11891 2024-06 BEDOK 4 ROOM 37 BEDOK STH AVE 2 04 TO 06 84.0 Improved 1977 438888.0 52 52 years 04 months 1.32190663617287 103.939847213862
11894 11894 2024-06 BEDOK 4 ROOM 37 BEDOK STH AVE 2 16 TO 18 84.0 Improved 1977 478000.0 52 52 years 04 months 1.32190663617287 103.939847213862
11921 11921 2024-06 BEDOK 3 ROOM 33 BEDOK STH AVE 2 04 TO 06 73.0 New Generation 1978 390000.0 52 52 years 10 months 1.32283703302242 103.939124525951
14303 14303 2024-05 BEDOK EXECUTIVE 10E BEDOK STH AVE 2 04 TO 06 144.0 Apartment 1993 933000.0 68 68 years 02 months 1.3216200934601 103.937040959341
14304 14304 2024-05 BEDOK EXECUTIVE 10B BEDOK STH AVE 2 04 TO 06 141.0 Apartment 1995 980000.0 70 70 years 08 months 1.32235386630343 103.936183263112
14335 14335 2024-05 BEDOK 5 ROOM 31 BEDOK STH AVE 2 10 TO 12 120.0 Standard 1978 742000.0 52 52 years 11 months 1.32301474306803 103.938165236776
14342 14342 2024-05 BEDOK 4 ROOM 35 BEDOK STH AVE 2 07 TO 09 90.0 Improved 1977 520000.0 52 52 years 05 months 1.32233220742919 103.939766219283
14343 14343 2024-05 BEDOK 4 ROOM 37 BEDOK STH AVE 2 01 TO 03 84.0 Improved 1977 442000.0 52 52 years 05 months 1.32190663617287 103.939847213862
14401 14401 2024-05 BEDOK 3 ROOM 33 BEDOK STH AVE 2 04 TO 06 73.0 New Generation 1978 378000.0 52 52 years 11 months 1.32283703302242 103.939124525951
14409 14409 2024-05 BEDOK 3 ROOM 33 BEDOK STH AVE 2 04 TO 06 88.0 New Generation 1978 470000.0 52 52 years 11 months 1.32283703302242 103.939124525951
16717 16717 2024-04 BEDOK EXECUTIVE 10B BEDOK STH AVE 2 10 TO 12 143.0 Apartment 1995 1180888.0 70 70 years 09 months 1.32235386630343 103.936183263112
16740 16740 2024-04 BEDOK 4 ROOM 36 BEDOK STH AVE 2 07 TO 09 84.0 Improved 1977 422000.0 52 52 years 06 months 1.32163299655185 103.938441289401
16753 16753 2024-04 BEDOK 4 ROOM 8 BEDOK STH AVE 2 13 TO 15 82.0 Improved 1976 436000.0 50 50 years 10 months 1.32284176978435 103.936046815062
16754 16754 2024-04 BEDOK 4 ROOM 8 BEDOK STH AVE 2 10 TO 12 82.0 Improved 1976 432000.0 50 50 years 09 months 1.32284176978435 103.936046815062
16755 16755 2024-04 BEDOK 4 ROOM 35 BEDOK STH AVE 2 04 TO 06 90.0 Improved 1977 435000.0 52 52 years 05 months 1.32233220742919 103.939766219283
16756 16756 2024-04 BEDOK 4 ROOM 8 BEDOK STH AVE 2 04 TO 06 82.0 Improved 1976 445000.0 50 50 years 10 months 1.32284176978435 103.936046815062
18811 18811 2024-03 BEDOK EXECUTIVE 10D BEDOK STH AVE 2 10 TO 12 145.0 Apartment 1995 1100000.0 70 70 years 11 months 1.3217708591015 103.936326570445
18816 18816 2024-03 BEDOK 5 ROOM 9 BEDOK STH AVE 2 04 TO 06 133.0 Model A 1993 862000.0 68 68 years 02 months 1.32320974180703 103.936904011861
18828 18828 2024-03 BEDOK EXECUTIVE 10B BEDOK STH AVE 2 10 TO 12 143.0 Apartment 1995 1150000.0 70 70 years 10 months 1.32235386630343 103.936183263112
18834 18834 2024-03 BEDOK 4 ROOM 7 BEDOK STH AVE 2 01 TO 03 82.0 Improved 1976 420000.0 51 51 years 1.32281544267372 103.93545524391
20944 20944 2024-02 BEDOK 4 ROOM 33 BEDOK STH AVE 2 01 TO 03 98.0 New Generation 1978 460000.0 53 53 years 02 months 1.32283703302242 103.939124525951
20945 20945 2024-02 BEDOK 4 ROOM 34 BEDOK STH AVE 2 04 TO 06 90.0 Improved 1977 410000.0 52 52 years 07 months 1.32205652925918 103.93835472666
20946 20946 2024-02 BEDOK 4 ROOM 35 BEDOK STH AVE 2 07 TO 09 90.0 Improved 1977 450000.0 52 52 years 08 months 1.32233220742919 103.939766219283
20982 20982 2024-02 BEDOK 3 ROOM 33 BEDOK STH AVE 2 04 TO 06 73.0 New Generation 1978 370500.0 53 53 years 01 month 1.32283703302242 103.939124525951
23512 23512 2024-01 BEDOK 5 ROOM 31 BEDOK STH AVE 2 04 TO 06 118.0 Standard 1978 575000.0 53 53 years 02 months 1.32301474306803 103.938165236776
23533 23533 2024-01 BEDOK 4 ROOM 36 BEDOK STH AVE 2 10 TO 12 84.0 Improved 1977 418000.0 52 52 years 08 months 1.32163299655185 103.938441289401
23540 23540 2024-01 BEDOK 4 ROOM 8 BEDOK STH AVE 2 01 TO 03 82.0 Improved 1976 430000.0 51 51 years 1.32284176978435 103.936046815062
23541 23541 2024-01 BEDOK 4 ROOM 37 BEDOK STH AVE 2 16 TO 18 84.0 Improved 1977 462888.0 52 52 years 09 months 1.32190663617287 103.939847213862
25516 25516 2023-12 BEDOK EXECUTIVE 10F BEDOK STH AVE 2 04 TO 06 144.0 Apartment 1993 980000.0 68 68 years 06 months 1.32221773472774 103.937001345916
25522 25522 2023-12 BEDOK 5 ROOM 31 BEDOK STH AVE 2 16 TO 18 118.0 Standard 1978 715000.0 53 53 years 04 months 1.32301474306803 103.938165236776
25523 25523 2023-12 BEDOK 5 ROOM 32 BEDOK STH AVE 2 07 TO 09 118.0 Standard 1978 670000.0 53 53 years 04 months 1.32262578075749 103.937815786523
27651 27651 2023-11 BEDOK EXECUTIVE 10D BEDOK STH AVE 2 16 TO 18 143.0 Apartment 1995 950000.0 71 71 years 02 months 1.3217708591015 103.936326570445
27661 27661 2023-11 BEDOK 5 ROOM 9 BEDOK STH AVE 2 16 TO 18 124.0 Improved 1993 928888.0 68 68 years 07 months 1.32320974180703 103.936904011861
27677 27677 2023-11 BEDOK 4 ROOM 5 BEDOK STH AVE 2 07 TO 09 82.0 Improved 1976 472500.0 51 51 years 03 months 1.32219157915726 103.934399264462
27679 27679 2023-11 BEDOK 4 ROOM 36 BEDOK STH AVE 2 04 TO 06 84.0 Improved 1977 440000.0 52 52 years 11 months 1.32163299655185 103.938441289401
29833 29833 2023-10 BEDOK 5 ROOM 14 BEDOK STH AVE 2 22 TO 24 122.0 Improved 1995 922888.0 71 71 years 03 months 1.3213611911805 103.936185399688
29847 29847 2023-10 BEDOK 5 ROOM 32 BEDOK STH AVE 2 16 TO 18 118.0 Standard 1978 675000.0 53 53 years 05 months 1.32262578075749 103.937815786523
31849 31849 2023-09 BEDOK 5 ROOM 9 BEDOK STH AVE 2 04 TO 06 133.0 Model A 1993 830000.0 68 68 years 08 months 1.32320974180703 103.936904011861
31868 31868 2023-09 BEDOK 4 ROOM 37 BEDOK STH AVE 2 10 TO 12 84.0 Improved 1977 435000.0 53 53 years 1.32190663617287 103.939847213862
31888 31888 2023-09 BEDOK 4 ROOM 7 BEDOK STH AVE 2 07 TO 09 82.0 Improved 1976 430000.0 51 51 years 04 months 1.32281544267372 103.93545524391
34236 34236 2023-08 BEDOK 5 ROOM 32 BEDOK STH AVE 2 16 TO 18 118.0 Standard 1978 668000.0 53 53 years 07 months 1.32262578075749 103.937815786523
34237 34237 2023-08 BEDOK 5 ROOM 32 BEDOK STH AVE 2 22 TO 24 115.0 Standard 1978 696000.0 53 53 years 08 months 1.32262578075749 103.937815786523
34250 34250 2023-08 BEDOK 4 ROOM 34 BEDOK STH AVE 2 10 TO 12 90.0 Improved 1977 415000.0 53 53 years 02 months 1.32205652925918 103.93835472666
34251 34251 2023-08 BEDOK 4 ROOM 6 BEDOK STH AVE 2 07 TO 09 82.0 Improved 1976 435000.0 51 51 years 06 months 1.32221710776614 103.934991224907
34264 34264 2023-08 BEDOK 4 ROOM 37 BEDOK STH AVE 2 13 TO 15 84.0 Improved 1977 449888.0 53 53 years 01 month 1.32190663617287 103.939847213862
34265 34265 2023-08 BEDOK 4 ROOM 34 BEDOK STH AVE 2 13 TO 15 90.0 Improved 1977 439000.0 53 53 years 03 months 1.32205652925918 103.93835472666
36402 36402 2023-07 BEDOK 4 ROOM 33 BEDOK STH AVE 2 13 TO 15 98.0 New Generation 1978 521000.0 53 53 years 09 months 1.32283703302242 103.939124525951
38256 38256 2023-06 BEDOK 4 ROOM 5 BEDOK STH AVE 2 01 TO 03 82.0 Improved 1976 383000.0 51 51 years 08 months 1.32219157915726 103.934399264462
38257 38257 2023-06 BEDOK 4 ROOM 36 BEDOK STH AVE 2 04 TO 06 84.0 Improved 1977 402000.0 53 53 years 04 months 1.32163299655185 103.938441289401
38258 38258 2023-06 BEDOK 4 ROOM 35 BEDOK STH AVE 2 01 TO 03 90.0 Improved 1977 398000.0 53 53 years 04 months 1.32233220742919 103.939766219283
38290 38290 2023-06 BEDOK 3 ROOM 33 BEDOK STH AVE 2 10 TO 12 73.0 New Generation 1978 385000.0 53 53 years 10 months 1.32283703302242 103.939124525951
40401 40401 2023-05 BEDOK EXECUTIVE 10B BEDOK STH AVE 2 16 TO 18 143.0 Apartment 1995 1110888.0 71 71 years 08 months 1.32235386630343 103.936183263112
40445 40445 2023-05 BEDOK 4 ROOM 36 BEDOK STH AVE 2 10 TO 12 84.0 Improved 1977 475000.0 53 53 years 05 months 1.32163299655185 103.938441289401
40446 40446 2023-05 BEDOK 4 ROOM 7 BEDOK STH AVE 2 01 TO 03 82.0 Improved 1976 368000.0 51 51 years 08 months 1.32281544267372 103.93545524391
40503 40503 2023-05 BEDOK 3 ROOM 33 BEDOK STH AVE 2 01 TO 03 73.0 New Generation 1978 365000.0 54 54 years 1.32283703302242 103.939124525951
42637 42637 2023-04 BEDOK 4 ROOM 8 BEDOK STH AVE 2 13 TO 15 82.0 Improved 1976 416000.0 51 51 years 10 months 1.32284176978435 103.936046815062
42651 42651 2023-04 BEDOK 4 ROOM 35 BEDOK STH AVE 2 10 TO 12 90.0 Improved 1977 456000.0 53 53 years 05 months 1.32233220742919 103.939766219283
42691 42691 2023-04 BEDOK 3 ROOM 33 BEDOK STH AVE 2 01 TO 03 73.0 New Generation 1978 350000.0 54 54 years 1.32283703302242 103.939124525951
42692 42692 2023-04 BEDOK 3 ROOM 33 BEDOK STH AVE 2 04 TO 06 88.0 New Generation 1978 446000.0 54 54 years 1.32283703302242 103.939124525951
44905 44905 2023-03 BEDOK 4 ROOM 36 BEDOK STH AVE 2 01 TO 03 84.0 Improved 1977 390000.0 53 53 years 07 months 1.32163299655185 103.938441289401
44907 44907 2023-03 BEDOK 4 ROOM 6 BEDOK STH AVE 2 04 TO 06 82.0 Improved 1976 418888.0 51 51 years 11 months 1.32221710776614 103.934991224907
44909 44909 2023-03 BEDOK 4 ROOM 8 BEDOK STH AVE 2 10 TO 12 82.0 Improved 1976 450000.0 51 51 years 11 months 1.32284176978435 103.936046815062
44910 44910 2023-03 BEDOK 4 ROOM 34 BEDOK STH AVE 2 04 TO 06 90.0 Improved 1977 420000.0 53 53 years 07 months 1.32205652925918 103.93835472666
44952 44952 2023-03 BEDOK 3 ROOM 33 BEDOK STH AVE 2 01 TO 03 73.0 New Generation 1978 362000.0 54 54 years 01 month 1.32283703302242 103.939124525951
46760 46760 2023-02 BEDOK 5 ROOM 32 BEDOK STH AVE 2 13 TO 15 115.0 Standard 1978 652000.0 54 54 years 01 month 1.32262578075749 103.937815786523
46784 46784 2023-02 BEDOK 4 ROOM 36 BEDOK STH AVE 2 04 TO 06 84.0 Improved 1977 418000.0 53 53 years 07 months 1.32163299655185 103.938441289401
46785 46785 2023-02 BEDOK 4 ROOM 5 BEDOK STH AVE 2 13 TO 15 82.0 Improved 1976 438000.0 52 52 years 1.32219157915726 103.934399264462
49243 49243 2023-01 BEDOK 4 ROOM 35 BEDOK STH AVE 2 07 TO 09 90.0 Improved 1977 418000.0 53 53 years 09 months 1.32233220742919 103.939766219283
49299 49299 2023-01 BEDOK 3 ROOM 33 BEDOK STH AVE 2 10 TO 12 88.0 New Generation 1978 438888.0 54 54 years 02 months 1.32283703302242 103.939124525951
50520 50520 2022-12 BEDOK 5 ROOM 32 BEDOK STH AVE 2 13 TO 15 118.0 Standard 1978 640000.0 54 54 years 04 months 1.32262578075749 103.937815786523
50538 50538 2022-12 BEDOK 4 ROOM 35 BEDOK STH AVE 2 04 TO 06 90.0 Improved 1977 435000.0 53 53 years 10 months 1.32233220742919 103.939766219283
50543 50543 2022-12 BEDOK 4 ROOM 8 BEDOK STH AVE 2 07 TO 09 82.0 Improved 1976 450000.0 52 52 years 03 months 1.32284176978435 103.936046815062
50559 50559 2022-12 BEDOK 3 ROOM 33 BEDOK STH AVE 2 04 TO 06 73.0 New Generation 1978 368000.0 54 54 years 05 months 1.32283703302242 103.939124525951
50561 50561 2022-12 BEDOK 4 ROOM 34 BEDOK STH AVE 2 07 TO 09 90.0 Improved 1977 405000.0 53 53 years 10 months 1.32205652925918 103.93835472666
52907 52907 2022-11 BEDOK 4 ROOM 34 BEDOK STH AVE 2 10 TO 12 90.0 Improved 1977 438888.0 53 53 years 11 months 1.32205652925918 103.93835472666
52922 52922 2022-11 BEDOK 3 ROOM 33 BEDOK STH AVE 2 10 TO 12 73.0 New Generation 1978 375000.0 54 54 years 06 months 1.32283703302242 103.939124525951
52926 52926 2022-11 BEDOK 3 ROOM 33 BEDOK STH AVE 2 10 TO 12 73.0 New Generation 1978 380088.0 54 54 years 05 months 1.32283703302242 103.939124525951
52976 52976 2022-11 BEDOK EXECUTIVE 10D BEDOK STH AVE 2 16 TO 18 143.0 Apartment 1995 1071888.0 72 72 years 02 months 1.3217708591015 103.936326570445
53370 53370 2022-11 BEDOK 5 ROOM 14 BEDOK STH AVE 2 22 TO 24 124.0 Improved 1995 938888.0 72 72 years 02 months 1.3213611911805 103.936185399688
53404 53404 2022-11 BEDOK 5 ROOM 9 BEDOK STH AVE 2 01 TO 03 124.0 Improved 1993 750000.0 69 69 years 07 months 1.32320974180703 103.936904011861
54217 54217 2022-10 BEDOK 4 ROOM 6 BEDOK STH AVE 2 10 TO 12 82.0 Improved 1976 433000.0 52 52 years 04 months 1.32221710776614 103.934991224907
54298 54298 2022-10 BEDOK 3 ROOM 33 BEDOK STH AVE 2 13 TO 15 88.0 New Generation 1978 448000.0 54 54 years 06 months 1.32283703302242 103.939124525951
56288 56288 2022-09 BEDOK 3 ROOM 33 BEDOK STH AVE 2 01 TO 03 73.0 New Generation 1978 360000.0 54 54 years 07 months 1.32283703302242 103.939124525951
56411 56411 2022-09 BEDOK 3 ROOM 33 BEDOK STH AVE 2 04 TO 06 88.0 New Generation 1978 390000.0 54 54 years 07 months 1.32283703302242 103.939124525951
56418 56418 2022-09 BEDOK 4 ROOM 34 BEDOK STH AVE 2 07 TO 09 90.0 Improved 1977 428000.0 54 54 years 01 month 1.32205652925918 103.93835472666
56423 56423 2022-09 BEDOK 4 ROOM 35 BEDOK STH AVE 2 13 TO 15 90.0 Improved 1977 410000.0 54 54 years 01 month 1.32233220742919 103.939766219283
56426 56426 2022-09 BEDOK 4 ROOM 5 BEDOK STH AVE 2 07 TO 09 82.0 Improved 1976 400000.0 52 52 years 05 months 1.32219157915726 103.934399264462
58642 58642 2022-08 BEDOK 4 ROOM 34 BEDOK STH AVE 2 10 TO 12 90.0 Improved 1977 432888.0 54 54 years 01 month 1.32205652925918 103.93835472666

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [resale_prices] (
   [month] TEXT,
   [town] TEXT,
   [flat_type] TEXT,
   [block] TEXT,
   [street_name] TEXT,
   [storey_range] TEXT,
   [floor_area_sqm] TEXT,
   [flat_model] TEXT,
   [lease_commence_date] TEXT,
   [resale_price] TEXT,
   [remaining_lease_years] TEXT,
   [remaining_lease] TEXT,
   [latitude] TEXT,
   [longitude] TEXT
);
CREATE INDEX [idx_resale_prices_month]
    ON [resale_prices] ([month]);
CREATE INDEX [idx_resale_prices_town]
    ON [resale_prices] ([town]);
CREATE INDEX [idx_resale_prices_flat_type]
    ON [resale_prices] ([flat_type]);
CREATE INDEX [idx_resale_prices_flat_model]
    ON [resale_prices] ([flat_model]);