resale_prices

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

2,943 rows where street_name = "TAMPINES ST 82"

✎ 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 block_street_name
72 72 2025-06 TAMPINES 4 ROOM 834 TAMPINES ST 82 01 TO 03 89.0 Simplified 1985 620000.0 59 59 years 04 months 1.35023461141351 103.935764519889 834 TAMPINES ST 82
73 73 2025-06 TAMPINES 4 ROOM 838 TAMPINES ST 82 04 TO 06 105.0 Model A 1985 610000.0 59 59 years 02 months 1.35085325206011 103.93537992169 838 TAMPINES ST 82
240 240 2025-06 TAMPINES 4 ROOM 856 TAMPINES ST 82 01 TO 03 84.0 Simplified 1986 525000.0 59 59 years 11 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
296 296 2025-06 TAMPINES 4 ROOM 842 TAMPINES ST 82 01 TO 03 84.0 Simplified 1986 540000.0 60 60 years 1.35173850943011 103.935952386296 842 TAMPINES ST 82
448 448 2025-06 TAMPINES 3 ROOM 846 TAMPINES ST 82 07 TO 09 74.0 Model A 1986 485000.0 59 59 years 08 months 1.35215736918662 103.935923497654 846 TAMPINES ST 82
1960 1960 2025-05 TAMPINES 4 ROOM 848 TAMPINES ST 82 04 TO 06 103.0 Model A 1985 645000.0 59 59 years 05 months 1.35247582900131 103.936057412249 848 TAMPINES ST 82
2006 2006 2025-05 TAMPINES 5 ROOM 842B TAMPINES ST 82 04 TO 06 128.0 Improved 1995 888000.0 68 68 years 10 months 1.35109233984766 103.937107012124 842B TAMPINES ST 82
2041 2041 2025-05 TAMPINES 5 ROOM 842H TAMPINES ST 82 07 TO 09 124.0 Improved 1995 970000.0 69 69 years 04 months 1.35161667861579 103.937070511177 842H TAMPINES ST 82
3592 3592 2025-04 TAMPINES 5 ROOM 840 TAMPINES ST 82 10 TO 12 122.0 Improved 1986 700000.0 59 59 years 11 months 1.35114217456369 103.935616863987 840 TAMPINES ST 82
3642 3642 2025-04 TAMPINES 3 ROOM 854 TAMPINES ST 82 01 TO 03 74.0 Model A 1985 475000.0 59 59 years 06 months 1.35302683671628 103.936584448142 854 TAMPINES ST 82
4218 4218 2025-04 TAMPINES 4 ROOM 846 TAMPINES ST 82 01 TO 03 103.0 Model A 1986 615000.0 59 59 years 10 months 1.35215736918662 103.935923497654 846 TAMPINES ST 82
4223 4223 2025-04 TAMPINES 4 ROOM 842F TAMPINES ST 82 10 TO 12 108.0 Model A 1995 720000.0 69 69 years 06 months 1.35186480268899 103.937784349764 842F TAMPINES ST 82
4424 4424 2025-04 TAMPINES 4 ROOM 842E TAMPINES ST 82 10 TO 12 105.0 Model A 1995 710000.0 69 69 years 04 months 1.35157120885478 103.938444966547 842E TAMPINES ST 82
4426 4426 2025-04 TAMPINES 4 ROOM 838 TAMPINES ST 82 01 TO 03 84.0 Simplified 1985 540000.0 59 59 years 04 months 1.35085325206011 103.93537992169 838 TAMPINES ST 82
4450 4450 2025-04 TAMPINES 4 ROOM 852 TAMPINES ST 82 07 TO 09 103.0 Model A 1985 650000.0 59 59 years 02 months 1.35270378927022 103.936448526607 852 TAMPINES ST 82
9309 9309 2025-02 TAMPINES 5 ROOM 842G TAMPINES ST 82 10 TO 12 128.0 Improved 1995 906000.0 69 69 years 07 months 1.35207674741611 103.937111715862 842G TAMPINES ST 82
9797 9797 2025-02 TAMPINES 4 ROOM 842 TAMPINES ST 82 04 TO 06 84.0 Simplified 1986 530000.0 60 60 years 05 months 1.35173850943011 103.935952386296 842 TAMPINES ST 82
10002 10002 2025-01 TAMPINES 3 ROOM 834 TAMPINES ST 82 01 TO 03 64.0 Simplified 1985 448000.0 59 59 years 08 months 1.35023461141351 103.935764519889 834 TAMPINES ST 82
10003 10003 2025-01 TAMPINES 3 ROOM 848 TAMPINES ST 82 10 TO 12 74.0 Model A 1985 485000.0 59 59 years 09 months 1.35247582900131 103.936057412249 848 TAMPINES ST 82
10006 10006 2025-01 TAMPINES 3 ROOM 854 TAMPINES ST 82 10 TO 12 74.0 Model A 1985 490000.0 59 59 years 09 months 1.35302683671628 103.936584448142 854 TAMPINES ST 82
10039 10039 2025-01 TAMPINES EXECUTIVE 856F TAMPINES ST 82 07 TO 09 147.0 Apartment 1995 1108000.0 69 69 years 11 months 1.35291277412563 103.938357435494 856F TAMPINES ST 82
10816 10816 2025-01 TAMPINES 5 ROOM 842B TAMPINES ST 82 01 TO 03 132.0 Model A 1995 800000.0 69 69 years 03 months 1.35109233984766 103.937107012124 842B TAMPINES ST 82
10817 10817 2025-01 TAMPINES 5 ROOM 842D TAMPINES ST 82 10 TO 12 137.0 Model A 1995 985000.0 69 69 years 02 months 1.35059655547526 103.93755033214 842D TAMPINES ST 82
14150 14150 2024-12 TAMPINES EXECUTIVE 856B TAMPINES ST 82 01 TO 03 146.0 Apartment 1995 950000.0 70 70 years 01 month 1.35311031731217 103.937699927291 856B TAMPINES ST 82
16252 16252 2024-10 TAMPINES EXECUTIVE 856B TAMPINES ST 82 04 TO 06 145.0 Apartment 1995 900000.0 70 70 years 02 months 1.35311031731217 103.937699927291 856B TAMPINES ST 82
16253 16253 2024-10 TAMPINES EXECUTIVE 856F TAMPINES ST 82 04 TO 06 143.0 Apartment 1995 1100000.0 70 70 years 02 months 1.35291277412563 103.938357435494 856F TAMPINES ST 82
16890 16890 2024-10 TAMPINES 5 ROOM 842D TAMPINES ST 82 01 TO 03 137.0 Model A 1995 828000.0 69 69 years 04 months 1.35059655547526 103.93755033214 842D TAMPINES ST 82
16893 16893 2024-10 TAMPINES 5 ROOM 842C TAMPINES ST 82 01 TO 03 133.0 Model A 1995 800000.0 69 69 years 05 months 1.35092895351478 103.936758459605 842C TAMPINES ST 82
17491 17491 2024-10 TAMPINES 4 ROOM 842C TAMPINES ST 82 10 TO 12 108.0 Model A 1995 698800.0 69 69 years 06 months 1.35092895351478 103.936758459605 842C TAMPINES ST 82
17500 17500 2024-10 TAMPINES 4 ROOM 840 TAMPINES ST 82 01 TO 03 84.0 Simplified 1986 540000.0 60 60 years 05 months 1.35114217456369 103.935616863987 840 TAMPINES ST 82
18057 18057 2024-10 TAMPINES 3 ROOM 852 TAMPINES ST 82 10 TO 12 74.0 Model A 1985 480000.0 59 59 years 08 months 1.35270378927022 103.936448526607 852 TAMPINES ST 82
18058 18058 2024-10 TAMPINES 3 ROOM 830 TAMPINES ST 82 01 TO 03 64.0 Simplified 1986 450000.0 60 60 years 05 months 1.34984192715478 103.934817687577 830 TAMPINES ST 82
18452 18452 2024-09 TAMPINES 4 ROOM 852 TAMPINES ST 82 04 TO 06 103.0 Model A 1985 630500.0 59 59 years 09 months 1.35270378927022 103.936448526607 852 TAMPINES ST 82
18453 18453 2024-09 TAMPINES 4 ROOM 842 TAMPINES ST 82 04 TO 06 84.0 Simplified 1986 520000.0 60 60 years 09 months 1.35173850943011 103.935952386296 842 TAMPINES ST 82
18575 18575 2024-09 TAMPINES EXECUTIVE 856B TAMPINES ST 82 07 TO 09 149.0 Apartment 1995 1038000.0 70 70 years 03 months 1.35311031731217 103.937699927291 856B TAMPINES ST 82
19280 19280 2024-09 TAMPINES 3 ROOM 850 TAMPINES ST 82 01 TO 03 64.0 Simplified 1986 441000.0 61 61 years 04 months 1.35304367332026 103.935965645315 850 TAMPINES ST 82
22135 22135 2024-08 TAMPINES 4 ROOM 848 TAMPINES ST 82 10 TO 12 104.0 Model A 1985 635000.0 60 60 years 02 months 1.35247582900131 103.936057412249 848 TAMPINES ST 82
22143 22143 2024-08 TAMPINES 4 ROOM 856 TAMPINES ST 82 04 TO 06 84.0 Simplified 1986 520000.0 60 60 years 09 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
23807 23807 2024-07 TAMPINES 4 ROOM 840 TAMPINES ST 82 10 TO 12 84.0 Simplified 1986 550000.0 60 60 years 07 months 1.35114217456369 103.935616863987 840 TAMPINES ST 82
23902 23902 2024-07 TAMPINES 5 ROOM 842E TAMPINES ST 82 07 TO 09 133.0 Model A 1995 858000.0 70 70 years 02 months 1.35157120885478 103.938444966547 842E TAMPINES ST 82
24155 24155 2024-07 TAMPINES 3 ROOM 848 TAMPINES ST 82 04 TO 06 74.0 Model A 1985 457000.0 60 60 years 03 months 1.35247582900131 103.936057412249 848 TAMPINES ST 82
24242 24242 2024-07 TAMPINES 3 ROOM 852 TAMPINES ST 82 07 TO 09 74.0 Model A 1985 410000.0 59 59 years 11 months 1.35270378927022 103.936448526607 852 TAMPINES ST 82
26653 26653 2024-06 TAMPINES 5 ROOM 856 TAMPINES ST 82 07 TO 09 122.0 Improved 1986 738000.0 60 60 years 11 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
26656 26656 2024-06 TAMPINES 5 ROOM 842F TAMPINES ST 82 04 TO 06 130.0 Model A 1995 810000.0 70 70 years 03 months 1.35186480268899 103.937784349764 842F TAMPINES ST 82
26657 26657 2024-06 TAMPINES 5 ROOM 842G TAMPINES ST 82 13 TO 15 131.0 Model A 1995 915086.0 70 70 years 03 months 1.35207674741611 103.937111715862 842G TAMPINES ST 82
27083 27083 2024-06 TAMPINES 3 ROOM 830 TAMPINES ST 82 01 TO 03 70.0 Simplified 1986 405000.0 60 60 years 09 months 1.34984192715478 103.934817687577 830 TAMPINES ST 82
27833 27833 2024-06 TAMPINES 4 ROOM 838 TAMPINES ST 82 07 TO 09 84.0 Simplified 1985 552888.0 60 60 years 02 months 1.35085325206011 103.93537992169 838 TAMPINES ST 82
28244 28244 2024-06 TAMPINES 4 ROOM 852 TAMPINES ST 82 04 TO 06 104.0 Model A 1985 585000.0 60 60 years 1.35270378927022 103.936448526607 852 TAMPINES ST 82
28800 28800 2024-05 TAMPINES 4 ROOM 848 TAMPINES ST 82 07 TO 09 104.0 Model A 1985 615000.0 60 60 years 05 months 1.35247582900131 103.936057412249 848 TAMPINES ST 82
28801 28801 2024-05 TAMPINES 4 ROOM 856 TAMPINES ST 82 04 TO 06 84.0 Simplified 1986 522888.0 61 61 years 1.35344494716974 103.936557739201 856 TAMPINES ST 82
30236 30236 2024-05 TAMPINES 3 ROOM 850 TAMPINES ST 82 04 TO 06 64.0 Simplified 1986 440000.0 61 61 years 08 months 1.35304367332026 103.935965645315 850 TAMPINES ST 82
31281 31281 2024-04 TAMPINES EXECUTIVE 856D TAMPINES ST 82 04 TO 06 149.0 Maisonette 1995 1038000.0 70 70 years 08 months 1.35209728534467 103.938739396041 856D TAMPINES ST 82
31287 31287 2024-04 TAMPINES EXECUTIVE 856F TAMPINES ST 82 13 TO 15 150.0 Apartment 1995 1018000.0 70 70 years 08 months 1.35291277412563 103.938357435494 856F TAMPINES ST 82
31594 31594 2024-04 TAMPINES 3 ROOM 830 TAMPINES ST 82 01 TO 03 64.0 Simplified 1986 400000.0 60 60 years 11 months 1.34984192715478 103.934817687577 830 TAMPINES ST 82
31601 31601 2024-04 TAMPINES 3 ROOM 846 TAMPINES ST 82 01 TO 03 74.0 Model A 1986 420000.0 60 60 years 10 months 1.35215736918662 103.935923497654 846 TAMPINES ST 82
34422 34422 2024-03 TAMPINES 5 ROOM 840 TAMPINES ST 82 04 TO 06 122.0 Improved 1986 670000.0 60 60 years 11 months 1.35114217456369 103.935616863987 840 TAMPINES ST 82
34436 34436 2024-03 TAMPINES 5 ROOM 842 TAMPINES ST 82 01 TO 03 122.0 Improved 1986 650000.0 61 61 years 03 months 1.35173850943011 103.935952386296 842 TAMPINES ST 82
34475 34475 2024-03 TAMPINES 5 ROOM 842G TAMPINES ST 82 10 TO 12 128.0 Improved 1995 866000.0 70 70 years 06 months 1.35207674741611 103.937111715862 842G TAMPINES ST 82
34476 34476 2024-03 TAMPINES 5 ROOM 842G TAMPINES ST 82 01 TO 03 133.0 Model A 1995 780000.0 70 70 years 05 months 1.35207674741611 103.937111715862 842G TAMPINES ST 82
34547 34547 2024-03 TAMPINES 4 ROOM 842 TAMPINES ST 82 07 TO 09 84.0 Simplified 1986 518000.0 61 61 years 03 months 1.35173850943011 103.935952386296 842 TAMPINES ST 82
34609 34609 2024-03 TAMPINES 4 ROOM 842B TAMPINES ST 82 10 TO 12 107.0 Model A 1995 710000.0 70 70 years 1.35109233984766 103.937107012124 842B TAMPINES ST 82
36165 36165 2024-02 TAMPINES 3 ROOM 852 TAMPINES ST 82 07 TO 09 74.0 Model A 1985 455000.0 60 60 years 04 months 1.35270378927022 103.936448526607 852 TAMPINES ST 82
36579 36579 2024-02 TAMPINES 4 ROOM 844 TAMPINES ST 82 01 TO 03 84.0 Simplified 1985 518000.0 60 60 years 06 months 1.3521058353242 103.936530873323 844 TAMPINES ST 82
36994 36994 2024-02 TAMPINES 5 ROOM 840 TAMPINES ST 82 07 TO 09 122.0 Improved 1986 700000.0 61 61 years 1.35114217456369 103.935616863987 840 TAMPINES ST 82
37478 37478 2024-01 TAMPINES 4 ROOM 838 TAMPINES ST 82 04 TO 06 104.0 Model A 1985 568000.0 60 60 years 07 months 1.35085325206011 103.93537992169 838 TAMPINES ST 82
37479 37479 2024-01 TAMPINES 4 ROOM 842D TAMPINES ST 82 10 TO 12 108.0 Model A 1995 635000.0 70 70 years 02 months 1.35059655547526 103.93755033214 842D TAMPINES ST 82
38473 38473 2024-01 TAMPINES EXECUTIVE 856E TAMPINES ST 82 13 TO 15 151.0 Apartment 1995 1000000.0 70 70 years 11 months 1.35291726067425 103.938794717769 856E TAMPINES ST 82
41916 41916 2023-12 TAMPINES 4 ROOM 836 TAMPINES ST 82 07 TO 09 84.0 Simplified 1985 490000.0 60 60 years 04 months 1.35057689370412 103.935204807585 836 TAMPINES ST 82
42220 42220 2023-11 TAMPINES 5 ROOM 842H TAMPINES ST 82 13 TO 15 131.0 Model A 1995 855000.0 70 70 years 09 months 1.35161667861579 103.937070511177 842H TAMPINES ST 82
43330 43330 2023-11 TAMPINES 4 ROOM 842C TAMPINES ST 82 04 TO 06 108.0 Model A 1995 600000.0 70 70 years 04 months 1.35092895351478 103.936758459605 842C TAMPINES ST 82
43334 43334 2023-11 TAMPINES 3 ROOM 854 TAMPINES ST 82 04 TO 06 74.0 Model A 1985 450000.0 60 60 years 11 months 1.35302683671628 103.936584448142 854 TAMPINES ST 82
43401 43401 2023-11 TAMPINES 3 ROOM 844 TAMPINES ST 82 01 TO 03 64.0 Simplified 1985 370000.0 60 60 years 09 months 1.3521058353242 103.936530873323 844 TAMPINES ST 82
43556 43556 2023-11 TAMPINES 4 ROOM 856 TAMPINES ST 82 07 TO 09 84.0 Simplified 1986 568000.0 61 61 years 07 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
43582 43582 2023-11 TAMPINES 4 ROOM 838 TAMPINES ST 82 07 TO 09 84.0 Simplified 1985 530888.0 60 60 years 09 months 1.35085325206011 103.93537992169 838 TAMPINES ST 82
44125 44125 2023-10 TAMPINES 5 ROOM 856 TAMPINES ST 82 07 TO 09 122.0 Improved 1986 650000.0 61 61 years 07 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
44819 44819 2023-10 TAMPINES 4 ROOM 848 TAMPINES ST 82 07 TO 09 104.0 Model A 1985 578000.0 60 60 years 11 months 1.35247582900131 103.936057412249 848 TAMPINES ST 82
44820 44820 2023-10 TAMPINES 4 ROOM 832 TAMPINES ST 82 01 TO 03 105.0 Model A 1984 505000.0 60 60 years 02 months 1.350101714776 103.935397838075 832 TAMPINES ST 82
44862 44862 2023-10 TAMPINES 4 ROOM 850 TAMPINES ST 82 01 TO 03 84.0 Simplified 1986 510000.0 62 62 years 03 months 1.35304367332026 103.935965645315 850 TAMPINES ST 82
44864 44864 2023-10 TAMPINES 4 ROOM 832 TAMPINES ST 82 01 TO 03 84.0 Simplified 1984 505000.0 60 60 years 03 months 1.350101714776 103.935397838075 832 TAMPINES ST 82
44873 44873 2023-10 TAMPINES 4 ROOM 852 TAMPINES ST 82 10 TO 12 103.0 Model A 1985 603333.0 60 60 years 08 months 1.35270378927022 103.936448526607 852 TAMPINES ST 82
47135 47135 2023-09 TAMPINES 4 ROOM 856 TAMPINES ST 82 10 TO 12 84.0 Simplified 1986 541000.0 61 61 years 08 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
49312 49312 2023-08 TAMPINES 5 ROOM 842C TAMPINES ST 82 10 TO 12 129.0 Improved 1995 850000.0 70 70 years 07 months 1.35092895351478 103.936758459605 842C TAMPINES ST 82
49319 49319 2023-08 TAMPINES EXECUTIVE 856D TAMPINES ST 82 04 TO 06 146.0 Maisonette 1995 960000.0 71 71 years 03 months 1.35209728534467 103.938739396041 856D TAMPINES ST 82
49508 49508 2023-08 TAMPINES 5 ROOM 842B TAMPINES ST 82 04 TO 06 128.0 Improved 1995 730000.0 70 70 years 06 months 1.35109233984766 103.937107012124 842B TAMPINES ST 82
50120 50120 2023-08 TAMPINES 3 ROOM 846 TAMPINES ST 82 04 TO 06 74.0 Model A 1986 435000.0 61 61 years 06 months 1.35215736918662 103.935923497654 846 TAMPINES ST 82
51097 51097 2023-07 TAMPINES 4 ROOM 856 TAMPINES ST 82 07 TO 09 84.0 Simplified 1986 508000.0 61 61 years 11 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
51129 51129 2023-07 TAMPINES 4 ROOM 832 TAMPINES ST 82 13 TO 15 84.0 Simplified 1984 535000.0 60 60 years 06 months 1.350101714776 103.935397838075 832 TAMPINES ST 82
52478 52478 2023-07 TAMPINES 4 ROOM 832 TAMPINES ST 82 01 TO 03 84.0 Simplified 1984 495000.0 60 60 years 06 months 1.350101714776 103.935397838075 832 TAMPINES ST 82
55014 55014 2023-05 TAMPINES EXECUTIVE 856F TAMPINES ST 82 13 TO 15 148.0 Apartment 1995 976888.0 71 71 years 06 months 1.35291277412563 103.938357435494 856F TAMPINES ST 82
56426 56426 2023-05 TAMPINES 4 ROOM 842 TAMPINES ST 82 07 TO 09 84.0 Simplified 1986 485000.0 62 62 years 01 month 1.35173850943011 103.935952386296 842 TAMPINES ST 82
56433 56433 2023-05 TAMPINES 3 ROOM 854 TAMPINES ST 82 04 TO 06 74.0 Model A 1985 428000.0 61 61 years 05 months 1.35302683671628 103.936584448142 854 TAMPINES ST 82
56447 56447 2023-05 TAMPINES 4 ROOM 842H TAMPINES ST 82 01 TO 03 106.0 Model A 1995 580000.0 71 71 years 04 months 1.35161667861579 103.937070511177 842H TAMPINES ST 82
57244 57244 2023-04 TAMPINES 5 ROOM 842D TAMPINES ST 82 01 TO 03 137.0 Model A 1995 755000.0 70 70 years 11 months 1.35059655547526 103.93755033214 842D TAMPINES ST 82
58590 58590 2023-04 TAMPINES EXECUTIVE 856B TAMPINES ST 82 07 TO 09 146.0 Apartment 1995 970000.0 71 71 years 08 months 1.35311031731217 103.937699927291 856B TAMPINES ST 82
58595 58595 2023-04 TAMPINES 5 ROOM 842G TAMPINES ST 82 13 TO 15 131.0 Model A 1995 820000.0 71 71 years 04 months 1.35207674741611 103.937111715862 842G TAMPINES ST 82
58599 58599 2023-04 TAMPINES 5 ROOM 842H TAMPINES ST 82 13 TO 15 127.0 Improved 1995 850000.0 71 71 years 04 months 1.35161667861579 103.937070511177 842H TAMPINES ST 82
59964 59964 2023-03 TAMPINES 4 ROOM 842G TAMPINES ST 82 01 TO 03 108.0 Model A 1995 570000.0 71 71 years 06 months 1.35207674741611 103.937111715862 842G TAMPINES ST 82
59986 59986 2023-03 TAMPINES 3 ROOM 846 TAMPINES ST 82 10 TO 12 74.0 Model A 1986 410000.0 61 61 years 11 months 1.35215736918662 103.935923497654 846 TAMPINES ST 82
60086 60086 2023-03 TAMPINES 5 ROOM 856 TAMPINES ST 82 07 TO 09 122.0 Improved 1986 698888.0 62 62 years 02 months 1.35344494716974 103.936557739201 856 TAMPINES ST 82
62389 62389 2023-02 TAMPINES 4 ROOM 842B TAMPINES ST 82 13 TO 15 107.0 Model A 1995 630000.0 71 71 years 1.35109233984766 103.937107012124 842B TAMPINES ST 82

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,
   [block_street_name] 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]);
CREATE INDEX [idx_resale_prices_block]
    ON [resale_prices] ([block]);
CREATE INDEX [idx_resale_prices_street_name]
    ON [resale_prices] ([street_name]);