resale_prices

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

3,056 rows where street_name = "TAMPINES ST 12"

✎ 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
1979 1979 2025-06 TAMPINES 4 ROOM 140 TAMPINES ST 12 07 TO 09 93.0 New Generation 1984 610000.0 58 58 years 06 months 1.3477319115079 103.94412402405 140 TAMPINES ST 12
2577 2577 2025-05 TAMPINES EXECUTIVE 156 TAMPINES ST 12 04 TO 06 150.0 Maisonette 1984 1050000.0 58 58 years 05 months 1.35162194359965 103.945090000876 156 TAMPINES ST 12
3265 3265 2025-05 TAMPINES 4 ROOM 144 TAMPINES ST 12 04 TO 06 103.0 Model A 1985 610000.0 58 58 years 11 months 1.34841857750645 103.943725846535 144 TAMPINES ST 12
3298 3298 2025-05 TAMPINES 4 ROOM 164 TAMPINES ST 12 07 TO 09 103.0 Model A 1984 653000.0 58 58 years 07 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
3300 3300 2025-05 TAMPINES 4 ROOM 141 TAMPINES ST 12 10 TO 12 107.0 Model A 1984 700000.0 58 58 years 05 months 1.34824895315275 103.944920713854 141 TAMPINES ST 12
3530 3530 2025-05 TAMPINES 4 ROOM 145 TAMPINES ST 12 01 TO 03 103.0 Model A 1984 630000.0 58 58 years 08 months 1.34880182138885 103.943691020379 145 TAMPINES ST 12
3531 3531 2025-05 TAMPINES 4 ROOM 159 TAMPINES ST 12 10 TO 12 91.0 New Generation 1984 650000.0 58 58 years 02 months 1.35104130847402 103.946051539375 159 TAMPINES ST 12
3532 3532 2025-05 TAMPINES 4 ROOM 166 TAMPINES ST 12 04 TO 06 107.0 Model A 1984 645000.0 58 58 years 01 month 1.34882100651553 103.946433351076 166 TAMPINES ST 12
5472 5472 2025-04 TAMPINES 4 ROOM 141 TAMPINES ST 12 04 TO 06 103.0 Model A 1984 628000.0 58 58 years 06 months 1.34824895315275 103.944920713854 141 TAMPINES ST 12
6122 6122 2025-04 TAMPINES 5 ROOM 165 TAMPINES ST 12 10 TO 12 133.0 Model A 1984 860000.0 58 58 years 05 months 1.34925962313654 103.945859451023 165 TAMPINES ST 12
6127 6127 2025-04 TAMPINES 5 ROOM 165 TAMPINES ST 12 10 TO 12 134.0 Model A 1984 885000.0 58 58 years 05 months 1.34925962313654 103.945859451023 165 TAMPINES ST 12
7203 7203 2025-03 TAMPINES 4 ROOM 145 TAMPINES ST 12 10 TO 12 103.0 Model A 1984 616888.0 58 58 years 11 months 1.34880182138885 103.943691020379 145 TAMPINES ST 12
7259 7259 2025-03 TAMPINES EXECUTIVE 149 TAMPINES ST 12 01 TO 03 142.0 Apartment 1984 968000.0 58 58 years 07 months 1.35140199155209 103.942727273621 149 TAMPINES ST 12
9387 9387 2025-02 TAMPINES EXECUTIVE 151 TAMPINES ST 12 04 TO 06 150.0 Maisonette 1984 1038000.0 58 58 years 08 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
9396 9396 2025-02 TAMPINES EXECUTIVE 149 TAMPINES ST 12 01 TO 03 150.0 Maisonette 1984 960000.0 58 58 years 09 months 1.35140199155209 103.942727273621 149 TAMPINES ST 12
9658 9658 2025-02 TAMPINES 5 ROOM 160 TAMPINES ST 12 04 TO 06 121.0 Improved 1984 778000.0 58 58 years 04 months 1.35070236635392 103.945183618846 160 TAMPINES ST 12
9818 9818 2025-02 TAMPINES 4 ROOM 164 TAMPINES ST 12 10 TO 12 103.0 Model A 1984 650000.0 58 58 years 10 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
12286 12286 2025-01 TAMPINES 3 ROOM 144 TAMPINES ST 12 10 TO 12 78.0 Model A 1985 360000.0 59 59 years 04 months 1.34841857750645 103.943725846535 144 TAMPINES ST 12
12287 12287 2025-01 TAMPINES 3 ROOM 157 TAMPINES ST 12 10 TO 12 68.0 New Generation 1985 488888.0 59 59 years 02 months 1.35107329077378 103.945003856886 157 TAMPINES ST 12
12293 12293 2025-01 TAMPINES 4 ROOM 166 TAMPINES ST 12 07 TO 09 107.0 Model A 1984 660000.0 58 58 years 06 months 1.34882100651553 103.946433351076 166 TAMPINES ST 12
12860 12860 2025-01 TAMPINES EXECUTIVE 156 TAMPINES ST 12 04 TO 06 150.0 Maisonette 1984 1108888.0 58 58 years 09 months 1.35162194359965 103.945090000876 156 TAMPINES ST 12
12863 12863 2025-01 TAMPINES EXECUTIVE 151 TAMPINES ST 12 04 TO 06 148.0 Apartment 1984 930000.0 58 58 years 08 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
12891 12891 2025-01 TAMPINES EXECUTIVE 151 TAMPINES ST 12 04 TO 06 150.0 Maisonette 1984 1050000.0 58 58 years 08 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
12892 12892 2025-01 TAMPINES EXECUTIVE 151 TAMPINES ST 12 01 TO 03 150.0 Maisonette 1984 1000000.0 58 58 years 09 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
14200 14200 2024-12 TAMPINES 4 ROOM 163 TAMPINES ST 12 04 TO 06 107.0 Model A 1984 660000.0 58 58 years 06 months 1.34953223099799 103.947459140714 163 TAMPINES ST 12
14201 14201 2024-12 TAMPINES 4 ROOM 150 TAMPINES ST 12 10 TO 12 103.0 Model A 1984 670000.0 58 58 years 07 months 1.35094609975013 103.943260115057 150 TAMPINES ST 12
14202 14202 2024-12 TAMPINES 4 ROOM 164 TAMPINES ST 12 07 TO 09 103.0 Model A 1984 643000.0 59 59 years 01 month 1.3496215142655 103.946000691097 164 TAMPINES ST 12
14434 14434 2024-12 TAMPINES EXECUTIVE 156 TAMPINES ST 12 07 TO 09 151.0 Apartment 1984 990000.0 58 58 years 10 months 1.35162194359965 103.945090000876 156 TAMPINES ST 12
15784 15784 2024-11 TAMPINES 4 ROOM 166 TAMPINES ST 12 01 TO 03 103.0 Model A 1984 610000.0 58 58 years 08 months 1.34882100651553 103.946433351076 166 TAMPINES ST 12
18437 18437 2024-10 TAMPINES 4 ROOM 140 TAMPINES ST 12 01 TO 03 93.0 New Generation 1984 540000.0 59 59 years 04 months 1.3477319115079 103.94412402405 140 TAMPINES ST 12
18449 18449 2024-10 TAMPINES 4 ROOM 158 TAMPINES ST 12 04 TO 06 91.0 New Generation 1984 628000.0 58 58 years 10 months 1.35141456108804 103.945859048593 158 TAMPINES ST 12
18964 18964 2024-10 TAMPINES 3 ROOM 161 TAMPINES ST 12 07 TO 09 74.0 Model A 1984 490000.0 59 59 years 01 month 1.35000084839602 103.945978324355 161 TAMPINES ST 12
20025 20025 2024-09 TAMPINES 3 ROOM 157 TAMPINES ST 12 04 TO 06 68.0 New Generation 1985 500088.0 59 59 years 05 months 1.35107329077378 103.945003856886 157 TAMPINES ST 12
20083 20083 2024-09 TAMPINES 3 ROOM 161 TAMPINES ST 12 04 TO 06 74.0 Model A 1984 480000.0 59 59 years 01 month 1.35000084839602 103.945978324355 161 TAMPINES ST 12
20302 20302 2024-09 TAMPINES 4 ROOM 140 TAMPINES ST 12 07 TO 09 91.0 New Generation 1984 565000.0 59 59 years 04 months 1.3477319115079 103.94412402405 140 TAMPINES ST 12
20418 20418 2024-09 TAMPINES EXECUTIVE 151 TAMPINES ST 12 10 TO 12 150.0 Maisonette 1984 1000000.0 59 59 years 1.35138611026976 103.943764586351 151 TAMPINES ST 12
20419 20419 2024-09 TAMPINES EXECUTIVE 156 TAMPINES ST 12 01 TO 03 148.0 Maisonette 1984 933000.0 59 59 years 01 month 1.35162194359965 103.945090000876 156 TAMPINES ST 12
22129 22129 2024-08 TAMPINES EXECUTIVE 151 TAMPINES ST 12 01 TO 03 142.0 Apartment 1984 900000.0 59 59 years 01 month 1.35138611026976 103.943764586351 151 TAMPINES ST 12
23436 23436 2024-08 TAMPINES 3 ROOM 164 TAMPINES ST 12 07 TO 09 74.0 Model A 1984 508000.0 59 59 years 04 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
24063 24063 2024-08 TAMPINES 4 ROOM 140 TAMPINES ST 12 04 TO 06 91.0 New Generation 1984 515000.0 59 59 years 05 months 1.3477319115079 103.94412402405 140 TAMPINES ST 12
24064 24064 2024-08 TAMPINES 4 ROOM 159 TAMPINES ST 12 01 TO 03 91.0 New Generation 1984 623800.0 58 58 years 11 months 1.35104130847402 103.946051539375 159 TAMPINES ST 12
24093 24093 2024-08 TAMPINES 4 ROOM 140 TAMPINES ST 12 04 TO 06 91.0 New Generation 1984 530000.0 59 59 years 05 months 1.3477319115079 103.94412402405 140 TAMPINES ST 12
24183 24183 2024-08 TAMPINES 5 ROOM 165 TAMPINES ST 12 10 TO 12 133.0 Model A 1984 938000.0 59 59 years 01 month 1.34925962313654 103.945859451023 165 TAMPINES ST 12
24221 24221 2024-08 TAMPINES 5 ROOM 143 TAMPINES ST 12 01 TO 03 133.0 Model A 1984 808000.0 58 58 years 10 months 1.34806952870407 103.943577088123 143 TAMPINES ST 12
24264 24264 2024-07 TAMPINES 3 ROOM 144 TAMPINES ST 12 04 TO 06 78.0 Model A 1985 470000.0 59 59 years 09 months 1.34841857750645 103.943725846535 144 TAMPINES ST 12
24662 24662 2024-07 TAMPINES EXECUTIVE 149 TAMPINES ST 12 07 TO 09 148.0 Apartment 1984 980000.0 59 59 years 04 months 1.35140199155209 103.942727273621 149 TAMPINES ST 12
25508 25508 2024-07 TAMPINES 4 ROOM 161 TAMPINES ST 12 07 TO 09 106.0 Model A 1984 685000.0 59 59 years 02 months 1.35000084839602 103.945978324355 161 TAMPINES ST 12
25514 25514 2024-07 TAMPINES 4 ROOM 158 TAMPINES ST 12 01 TO 03 91.0 New Generation 1984 618888.0 59 59 years 1.35141456108804 103.945859048593 158 TAMPINES ST 12
25744 25744 2024-07 TAMPINES 4 ROOM 162 TAMPINES ST 12 04 TO 06 103.0 Model A 1984 595000.0 59 59 years 02 months 1.34990496411198 103.947139796649 162 TAMPINES ST 12
26244 26244 2024-07 TAMPINES 5 ROOM 142 TAMPINES ST 12 01 TO 03 133.0 Model A 1984 735000.0 59 59 years 03 months 1.34869712181619 103.944859621472 142 TAMPINES ST 12
26245 26245 2024-07 TAMPINES 5 ROOM 165 TAMPINES ST 12 07 TO 09 133.0 Model A 1984 772888.0 59 59 years 02 months 1.34925962313654 103.945859451023 165 TAMPINES ST 12
27838 27838 2024-06 TAMPINES 5 ROOM 162 TAMPINES ST 12 07 TO 09 133.0 Model A 1984 795000.0 59 59 years 02 months 1.34990496411198 103.947139796649 162 TAMPINES ST 12
27842 27842 2024-06 TAMPINES 5 ROOM 143 TAMPINES ST 12 04 TO 06 134.0 Model A 1984 730000.0 59 59 years 01 month 1.34806952870407 103.943577088123 143 TAMPINES ST 12
31086 31086 2024-05 TAMPINES 5 ROOM 142 TAMPINES ST 12 07 TO 09 133.0 Model A 1984 763000.0 59 59 years 04 months 1.34869712181619 103.944859621472 142 TAMPINES ST 12
31642 31642 2024-05 TAMPINES 4 ROOM 158 TAMPINES ST 12 04 TO 06 91.0 New Generation 1984 588000.0 59 59 years 03 months 1.35141456108804 103.945859048593 158 TAMPINES ST 12
32004 32004 2024-04 TAMPINES 3 ROOM 164 TAMPINES ST 12 04 TO 06 74.0 Model A 1984 438000.0 59 59 years 08 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
32023 32023 2024-04 TAMPINES 3 ROOM 157 TAMPINES ST 12 01 TO 03 68.0 New Generation 1985 435000.0 59 59 years 10 months 1.35107329077378 103.945003856886 157 TAMPINES ST 12
32512 32512 2024-04 TAMPINES EXECUTIVE 156 TAMPINES ST 12 04 TO 06 156.0 Maisonette 1984 1020000.0 59 59 years 06 months 1.35162194359965 103.945090000876 156 TAMPINES ST 12
32915 32915 2024-04 TAMPINES 4 ROOM 161 TAMPINES ST 12 01 TO 03 106.0 Model A 1984 618000.0 59 59 years 05 months 1.35000084839602 103.945978324355 161 TAMPINES ST 12
34776 34776 2024-03 TAMPINES 3 ROOM 157 TAMPINES ST 12 07 TO 09 68.0 New Generation 1985 461000.0 59 59 years 11 months 1.35107329077378 103.945003856886 157 TAMPINES ST 12
35006 35006 2024-03 TAMPINES 4 ROOM 162 TAMPINES ST 12 04 TO 06 103.0 Model A 1984 600000.0 59 59 years 05 months 1.34990496411198 103.947139796649 162 TAMPINES ST 12
36424 36424 2024-02 TAMPINES 4 ROOM 164 TAMPINES ST 12 01 TO 03 106.0 Model A 1984 550000.0 59 59 years 10 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
36432 36432 2024-02 TAMPINES 4 ROOM 161 TAMPINES ST 12 01 TO 03 103.0 Model A 1984 590000.0 59 59 years 08 months 1.35000084839602 103.945978324355 161 TAMPINES ST 12
36702 36702 2024-02 TAMPINES 5 ROOM 165 TAMPINES ST 12 01 TO 03 133.0 Model A 1984 728888.0 59 59 years 07 months 1.34925962313654 103.945859451023 165 TAMPINES ST 12
38153 38153 2024-02 TAMPINES EXECUTIVE 151 TAMPINES ST 12 07 TO 09 148.0 Apartment 1984 980000.0 59 59 years 06 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
38154 38154 2024-02 TAMPINES EXECUTIVE 151 TAMPINES ST 12 04 TO 06 150.0 Maisonette 1984 960000.0 59 59 years 06 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
40060 40060 2024-01 TAMPINES 3 ROOM 145 TAMPINES ST 12 04 TO 06 74.0 Model A 1984 438000.0 60 60 years 01 month 1.34880182138885 103.943691020379 145 TAMPINES ST 12
40118 40118 2024-01 TAMPINES 3 ROOM 164 TAMPINES ST 12 01 TO 03 74.0 Model A 1984 430000.0 59 59 years 11 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
41700 41700 2023-12 TAMPINES 4 ROOM 166 TAMPINES ST 12 04 TO 06 107.0 Model A 1984 590000.0 59 59 years 06 months 1.34882100651553 103.946433351076 166 TAMPINES ST 12
42410 42410 2023-12 TAMPINES 5 ROOM 142 TAMPINES ST 12 07 TO 09 133.0 Model A 1984 700000.0 59 59 years 09 months 1.34869712181619 103.944859621472 142 TAMPINES ST 12
42503 42503 2023-12 TAMPINES 4 ROOM 166 TAMPINES ST 12 01 TO 03 107.0 Model A 1984 565000.0 59 59 years 07 months 1.34882100651553 103.946433351076 166 TAMPINES ST 12
42516 42516 2023-12 TAMPINES 4 ROOM 158 TAMPINES ST 12 07 TO 09 92.0 New Generation 1984 618000.0 59 59 years 08 months 1.35141456108804 103.945859048593 158 TAMPINES ST 12
42522 42522 2023-12 TAMPINES 4 ROOM 163 TAMPINES ST 12 01 TO 03 103.0 Model A 1984 545000.0 59 59 years 07 months 1.34953223099799 103.947459140714 163 TAMPINES ST 12
42526 42526 2023-12 TAMPINES 3 ROOM 157 TAMPINES ST 12 07 TO 09 68.0 New Generation 1985 448000.0 60 60 years 01 month 1.35107329077378 103.945003856886 157 TAMPINES ST 12
42617 42617 2023-12 TAMPINES 5 ROOM 142 TAMPINES ST 12 10 TO 12 133.0 Model A 1984 753000.0 59 59 years 09 months 1.34869712181619 103.944859621472 142 TAMPINES ST 12
44841 44841 2023-11 TAMPINES 5 ROOM 143 TAMPINES ST 12 10 TO 12 134.0 Model A 1984 730000.0 59 59 years 08 months 1.34806952870407 103.943577088123 143 TAMPINES ST 12
45215 45215 2023-11 TAMPINES 4 ROOM 144 TAMPINES ST 12 10 TO 12 112.0 Model A 1985 590000.0 60 60 years 05 months 1.34841857750645 103.943725846535 144 TAMPINES ST 12
45236 45236 2023-11 TAMPINES 4 ROOM 159 TAMPINES ST 12 07 TO 09 91.0 New Generation 1984 618000.0 59 59 years 08 months 1.35104130847402 103.946051539375 159 TAMPINES ST 12
45870 45870 2023-10 TAMPINES EXECUTIVE 149 TAMPINES ST 12 04 TO 06 142.0 Apartment 1984 940000.0 60 60 years 02 months 1.35140199155209 103.942727273621 149 TAMPINES ST 12
45871 45871 2023-10 TAMPINES EXECUTIVE 149 TAMPINES ST 12 07 TO 09 150.0 Maisonette 1984 940000.0 60 60 years 01 month 1.35140199155209 103.942727273621 149 TAMPINES ST 12
46005 46005 2023-10 TAMPINES 3 ROOM 157 TAMPINES ST 12 01 TO 03 68.0 New Generation 1985 430000.0 60 60 years 03 months 1.35107329077378 103.945003856886 157 TAMPINES ST 12
46041 46041 2023-10 TAMPINES 4 ROOM 141 TAMPINES ST 12 04 TO 06 106.0 Model A 1984 560000.0 60 60 years 1.34824895315275 103.944920713854 141 TAMPINES ST 12
47940 47940 2023-09 TAMPINES 3 ROOM 164 TAMPINES ST 12 10 TO 12 78.0 Model A 1984 450000.0 60 60 years 02 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
50017 50017 2023-08 TAMPINES 4 ROOM 164 TAMPINES ST 12 10 TO 12 103.0 Model A 1984 575000.0 60 60 years 04 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
50091 50091 2023-08 TAMPINES EXECUTIVE 156 TAMPINES ST 12 04 TO 06 147.0 Apartment 1984 885000.0 60 60 years 01 month 1.35162194359965 103.945090000876 156 TAMPINES ST 12
53508 53508 2023-07 TAMPINES 4 ROOM 141 TAMPINES ST 12 04 TO 06 103.0 Model A 1984 565000.0 60 60 years 03 months 1.34824895315275 103.944920713854 141 TAMPINES ST 12
53822 53822 2023-07 TAMPINES 3 ROOM 145 TAMPINES ST 12 04 TO 06 74.0 Model A 1984 440000.0 60 60 years 06 months 1.34880182138885 103.943691020379 145 TAMPINES ST 12
53867 53867 2023-07 TAMPINES 3 ROOM 145 TAMPINES ST 12 10 TO 12 74.0 Model A 1984 442500.0 60 60 years 06 months 1.34880182138885 103.943691020379 145 TAMPINES ST 12
54008 54008 2023-06 TAMPINES 4 ROOM 164 TAMPINES ST 12 10 TO 12 106.0 Model A 1984 599888.0 60 60 years 06 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
54010 54010 2023-06 TAMPINES 4 ROOM 162 TAMPINES ST 12 10 TO 12 103.0 Model A 1984 595000.0 60 60 years 02 months 1.34990496411198 103.947139796649 162 TAMPINES ST 12
54303 54303 2023-06 TAMPINES 4 ROOM 144 TAMPINES ST 12 01 TO 03 106.0 Model A 1985 545000.0 60 60 years 10 months 1.34841857750645 103.943725846535 144 TAMPINES ST 12
54310 54310 2023-06 TAMPINES 4 ROOM 164 TAMPINES ST 12 04 TO 06 106.0 Model A 1984 578000.0 60 60 years 06 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
54332 54332 2023-06 TAMPINES 4 ROOM 144 TAMPINES ST 12 10 TO 12 103.0 Model A 1985 570000.0 60 60 years 10 months 1.34841857750645 103.943725846535 144 TAMPINES ST 12
54334 54334 2023-06 TAMPINES 4 ROOM 164 TAMPINES ST 12 01 TO 03 106.0 Model A 1984 539000.0 60 60 years 05 months 1.3496215142655 103.946000691097 164 TAMPINES ST 12
55482 55482 2023-06 TAMPINES EXECUTIVE 151 TAMPINES ST 12 10 TO 12 150.0 Maisonette 1984 975000.0 60 60 years 03 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
56261 56261 2023-05 TAMPINES 4 ROOM 141 TAMPINES ST 12 04 TO 06 103.0 Model A 1984 540000.0 60 60 years 05 months 1.34824895315275 103.944920713854 141 TAMPINES ST 12
56517 56517 2023-05 TAMPINES EXECUTIVE 156 TAMPINES ST 12 07 TO 09 150.0 Maisonette 1984 1025000.0 60 60 years 04 months 1.35162194359965 103.945090000876 156 TAMPINES ST 12
56521 56521 2023-05 TAMPINES EXECUTIVE 151 TAMPINES ST 12 04 TO 06 148.0 Maisonette 1984 945000.0 60 60 years 03 months 1.35138611026976 103.943764586351 151 TAMPINES ST 12
59309 59309 2023-04 TAMPINES 4 ROOM 141 TAMPINES ST 12 10 TO 12 103.0 Model A 1984 560000.0 60 60 years 06 months 1.34824895315275 103.944920713854 141 TAMPINES ST 12
59361 59361 2023-04 TAMPINES 3 ROOM 150 TAMPINES ST 12 04 TO 06 73.0 Model A 1984 443000.0 60 60 years 03 months 1.35094609975013 103.943260115057 150 TAMPINES ST 12

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]);