resale_prices

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

1,638 rows where street_name = "TAMPINES ST 34"

✎ 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
1614 1614 2025-05 TAMPINES 4 ROOM 367 TAMPINES ST 34 10 TO 12 100.0 Model A 1997 625000.0 71 71 years 1.35861946074158 103.960788620104 367 TAMPINES ST 34
1677 1677 2025-05 TAMPINES 5 ROOM 373 TAMPINES ST 34 01 TO 03 124.0 Improved 1995 728000.0 69 69 years 05 months 1.3560218473311 103.958780627307 373 TAMPINES ST 34
1678 1678 2025-05 TAMPINES 5 ROOM 372 TAMPINES ST 34 04 TO 06 124.0 Improved 1995 778000.0 69 69 years 04 months 1.35644214347401 103.958095646102 372 TAMPINES ST 34
3880 3880 2025-04 TAMPINES 5 ROOM 370 TAMPINES ST 34 01 TO 03 123.0 Improved 1997 665000.0 70 70 years 10 months 1.3580388536739 103.959670086702 370 TAMPINES ST 34
3911 3911 2025-04 TAMPINES 5 ROOM 371 TAMPINES ST 34 01 TO 03 125.0 Improved 1995 735000.0 69 69 years 05 months 1.3570908947321 103.958597718781 371 TAMPINES ST 34
7176 7176 2025-03 TAMPINES 4 ROOM 366 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 598000.0 71 71 years 01 month 1.35761758572121 103.961378989065 366 TAMPINES ST 34
7177 7177 2025-03 TAMPINES 4 ROOM 364 TAMPINES ST 34 10 TO 12 100.0 Model A 1997 642000.0 71 71 years 02 months 1.35720282099768 103.96013948983 364 TAMPINES ST 34
7179 7179 2025-03 TAMPINES 4 ROOM 369 TAMPINES ST 34 10 TO 12 100.0 Model A 1997 640000.0 71 71 years 01 month 1.35869916097949 103.960254467845 369 TAMPINES ST 34
7504 7504 2025-02 TAMPINES 5 ROOM 374 TAMPINES ST 34 04 TO 06 136.0 Model A 1995 766000.0 69 69 years 08 months 1.35643914546887 103.958623896768 374 TAMPINES ST 34
9095 9095 2025-02 TAMPINES 4 ROOM 368 TAMPINES ST 34 01 TO 03 102.0 Model A 1997 595000.0 71 71 years 04 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
9096 9096 2025-02 TAMPINES 4 ROOM 365 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 580000.0 71 71 years 01 month 1.35768611954955 103.960620745568 365 TAMPINES ST 34
9816 9816 2025-01 TAMPINES 5 ROOM 362 TAMPINES ST 34 01 TO 03 129.0 Improved 1996 695000.0 70 70 years 04 months 1.35625122843632 103.961576641177 362 TAMPINES ST 34
9817 9817 2025-01 TAMPINES 5 ROOM 370 TAMPINES ST 34 04 TO 06 121.0 Improved 1997 728000.0 71 71 years 01 month 1.3580388536739 103.959670086702 370 TAMPINES ST 34
11252 11252 2025-01 TAMPINES 4 ROOM 359 TAMPINES ST 34 07 TO 09 107.0 Model A 1996 618000.0 70 70 years 03 months 1.35588169299314 103.961638534274 359 TAMPINES ST 34
11255 11255 2025-01 TAMPINES 4 ROOM 368 TAMPINES ST 34 01 TO 03 101.0 Model A 1997 570000.0 71 71 years 06 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
13654 13654 2024-12 TAMPINES 4 ROOM 367A TAMPINES ST 34 01 TO 03 100.0 Model A 1997 612000.0 71 71 years 02 months 1.35770234108772 103.959954453114 367A TAMPINES ST 34
15515 15515 2024-11 TAMPINES 4 ROOM 368 TAMPINES ST 34 10 TO 12 102.0 Model A 1997 618000.0 71 71 years 07 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
15520 15520 2024-11 TAMPINES 5 ROOM 364 TAMPINES ST 34 04 TO 06 119.0 Improved 1997 705000.0 71 71 years 06 months 1.35720282099768 103.96013948983 364 TAMPINES ST 34
16250 16250 2024-10 TAMPINES 5 ROOM 366 TAMPINES ST 34 04 TO 06 120.0 Improved 1997 745000.0 71 71 years 06 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
17195 17195 2024-10 TAMPINES 4 ROOM 365 TAMPINES ST 34 01 TO 03 101.0 Model A 1997 610000.0 71 71 years 04 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
17202 17202 2024-10 TAMPINES 4 ROOM 368 TAMPINES ST 34 10 TO 12 102.0 Model A 1997 575000.0 71 71 years 08 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
18034 18034 2024-09 TAMPINES 5 ROOM 366 TAMPINES ST 34 04 TO 06 121.0 Improved 1997 700000.0 71 71 years 07 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
18819 18819 2024-09 TAMPINES 4 ROOM 367A TAMPINES ST 34 01 TO 03 101.0 Model A 1997 610000.0 71 71 years 05 months 1.35770234108772 103.959954453114 367A TAMPINES ST 34
20075 20075 2024-08 TAMPINES 4 ROOM 367A TAMPINES ST 34 04 TO 06 100.0 Model A 1997 598000.0 71 71 years 05 months 1.35770234108772 103.959954453114 367A TAMPINES ST 34
20076 20076 2024-08 TAMPINES 4 ROOM 365 TAMPINES ST 34 07 TO 09 102.0 Model A 1997 635000.0 71 71 years 06 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
21237 21237 2024-08 TAMPINES 5 ROOM 362 TAMPINES ST 34 07 TO 09 129.0 Improved 1996 715000.0 70 70 years 08 months 1.35625122843632 103.961576641177 362 TAMPINES ST 34
25040 25040 2024-07 TAMPINES 5 ROOM 364 TAMPINES ST 34 04 TO 06 121.0 Improved 1997 738000.0 71 71 years 10 months 1.35720282099768 103.96013948983 364 TAMPINES ST 34
25041 25041 2024-07 TAMPINES 5 ROOM 374 TAMPINES ST 34 01 TO 03 123.0 Improved 1995 700000.0 70 70 years 03 months 1.35643914546887 103.958623896768 374 TAMPINES ST 34
25297 25297 2024-07 TAMPINES 5 ROOM 367 TAMPINES ST 34 01 TO 03 121.0 Improved 1997 645000.0 71 71 years 10 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
27351 27351 2024-06 TAMPINES 5 ROOM 372 TAMPINES ST 34 07 TO 09 127.0 Improved 1995 720000.0 70 70 years 04 months 1.35644214347401 103.958095646102 372 TAMPINES ST 34
27352 27352 2024-06 TAMPINES 5 ROOM 368 TAMPINES ST 34 04 TO 06 122.0 Improved 1997 678000.0 72 72 years 1.35847458329919 103.961288498131 368 TAMPINES ST 34
27356 27356 2024-06 TAMPINES 5 ROOM 370 TAMPINES ST 34 10 TO 12 121.0 Improved 1997 718000.0 71 71 years 08 months 1.3580388536739 103.959670086702 370 TAMPINES ST 34
27370 27370 2024-06 TAMPINES 5 ROOM 371 TAMPINES ST 34 07 TO 09 123.0 Improved 1995 728000.0 70 70 years 04 months 1.3570908947321 103.958597718781 371 TAMPINES ST 34
28823 28823 2024-05 TAMPINES 4 ROOM 363 TAMPINES ST 34 07 TO 09 107.0 Model A 1996 633800.0 70 70 years 11 months 1.3555206788848 103.960860222796 363 TAMPINES ST 34
28824 28824 2024-05 TAMPINES 4 ROOM 364 TAMPINES ST 34 07 TO 09 100.0 Model A 1997 580000.0 72 72 years 1.35720282099768 103.96013948983 364 TAMPINES ST 34
32302 32302 2024-04 TAMPINES 4 ROOM 370 TAMPINES ST 34 04 TO 06 100.0 Model A 1997 568000.0 71 71 years 10 months 1.3580388536739 103.959670086702 370 TAMPINES ST 34
32841 32841 2024-03 TAMPINES 4 ROOM 361 TAMPINES ST 34 07 TO 09 107.0 Model A 1996 580000.0 71 71 years 03 months 1.35604416362237 103.962576038477 361 TAMPINES ST 34
32844 32844 2024-03 TAMPINES 4 ROOM 367 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 538000.0 72 72 years 03 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
32846 32846 2024-03 TAMPINES 4 ROOM 370 TAMPINES ST 34 07 TO 09 100.0 Model A 1997 598000.0 71 71 years 11 months 1.3580388536739 103.959670086702 370 TAMPINES ST 34
32850 32850 2024-03 TAMPINES 4 ROOM 361 TAMPINES ST 34 07 TO 09 107.0 Model A 1996 588000.0 71 71 years 03 months 1.35604416362237 103.962576038477 361 TAMPINES ST 34
35895 35895 2024-02 TAMPINES 5 ROOM 368 TAMPINES ST 34 01 TO 03 122.0 Improved 1997 648000.0 72 72 years 04 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
36757 36757 2024-02 TAMPINES 4 ROOM 369 TAMPINES ST 34 07 TO 09 100.0 Model A 1997 610000.0 72 72 years 02 months 1.35869916097949 103.960254467845 369 TAMPINES ST 34
38521 38521 2024-01 TAMPINES 4 ROOM 367 TAMPINES ST 34 10 TO 12 100.0 Model A 1997 556000.0 72 72 years 05 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
41012 41012 2023-12 TAMPINES 4 ROOM 365 TAMPINES ST 34 07 TO 09 100.0 Model A 1997 555000.0 72 72 years 02 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
41056 41056 2023-12 TAMPINES 4 ROOM 370 TAMPINES ST 34 01 TO 03 101.0 Model A 1997 565000.0 72 72 years 02 months 1.3580388536739 103.959670086702 370 TAMPINES ST 34
41323 41323 2023-12 TAMPINES 5 ROOM 372 TAMPINES ST 34 07 TO 09 123.0 Improved 1995 710000.0 70 70 years 10 months 1.35644214347401 103.958095646102 372 TAMPINES ST 34
41370 41370 2023-12 TAMPINES 5 ROOM 367 TAMPINES ST 34 07 TO 09 120.0 Improved 1997 668000.0 72 72 years 06 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
41374 41374 2023-12 TAMPINES 5 ROOM 364 TAMPINES ST 34 04 TO 06 121.0 Improved 1997 670000.0 72 72 years 06 months 1.35720282099768 103.96013948983 364 TAMPINES ST 34
41803 41803 2023-11 TAMPINES 4 ROOM 367 TAMPINES ST 34 04 TO 06 100.0 Model A 1997 543000.0 72 72 years 07 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
41814 41814 2023-11 TAMPINES 4 ROOM 361 TAMPINES ST 34 07 TO 09 107.0 Model A 1996 535000.0 71 71 years 07 months 1.35604416362237 103.962576038477 361 TAMPINES ST 34
41829 41829 2023-11 TAMPINES 4 ROOM 368 TAMPINES ST 34 04 TO 06 102.0 Model A 1997 515000.0 72 72 years 07 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
41875 41875 2023-11 TAMPINES 5 ROOM 366 TAMPINES ST 34 01 TO 03 121.0 Improved 1997 610000.0 72 72 years 05 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
41996 41996 2023-11 TAMPINES 4 ROOM 365 TAMPINES ST 34 04 TO 06 101.0 Model A 1997 535000.0 72 72 years 03 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
42979 42979 2023-11 TAMPINES 5 ROOM 361 TAMPINES ST 34 07 TO 09 128.0 Improved 1996 689888.0 71 71 years 07 months 1.35604416362237 103.962576038477 361 TAMPINES ST 34
44231 44231 2023-10 TAMPINES 4 ROOM 367 TAMPINES ST 34 04 TO 06 100.0 Model A 1997 540000.0 72 72 years 08 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
44233 44233 2023-10 TAMPINES 4 ROOM 364 TAMPINES ST 34 07 TO 09 102.0 Model A 1997 545000.0 72 72 years 06 months 1.35720282099768 103.96013948983 364 TAMPINES ST 34
44239 44239 2023-10 TAMPINES 4 ROOM 365 TAMPINES ST 34 07 TO 09 101.0 Model A 1997 560000.0 72 72 years 04 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
44357 44357 2023-10 TAMPINES 5 ROOM 368 TAMPINES ST 34 04 TO 06 122.0 Improved 1997 640000.0 72 72 years 08 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
44359 44359 2023-10 TAMPINES 5 ROOM 367 TAMPINES ST 34 07 TO 09 121.0 Improved 1997 638000.0 72 72 years 08 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
44364 44364 2023-10 TAMPINES 5 ROOM 366 TAMPINES ST 34 01 TO 03 120.0 Improved 1997 650000.0 72 72 years 05 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
48478 48478 2023-08 TAMPINES 5 ROOM 360 TAMPINES ST 34 04 TO 06 121.0 Improved 1996 640000.0 71 71 years 08 months 1.35561756499877 103.962257931593 360 TAMPINES ST 34
48927 48927 2023-08 TAMPINES 5 ROOM 367 TAMPINES ST 34 07 TO 09 120.0 Improved 1997 660000.0 72 72 years 10 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
48944 48944 2023-08 TAMPINES 5 ROOM 367 TAMPINES ST 34 04 TO 06 121.0 Improved 1997 635000.0 72 72 years 10 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
51075 51075 2023-07 TAMPINES 4 ROOM 359 TAMPINES ST 34 04 TO 06 107.0 Model A 1996 556000.0 71 71 years 08 months 1.35588169299314 103.961638534274 359 TAMPINES ST 34
51104 51104 2023-07 TAMPINES 5 ROOM 372 TAMPINES ST 34 01 TO 03 124.0 Improved 1995 660000.0 71 71 years 04 months 1.35644214347401 103.958095646102 372 TAMPINES ST 34
52557 52557 2023-06 TAMPINES 4 ROOM 369 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 535000.0 72 72 years 10 months 1.35869916097949 103.960254467845 369 TAMPINES ST 34
52651 52651 2023-06 TAMPINES 4 ROOM 366 TAMPINES ST 34 04 TO 06 100.0 Model A 1997 535000.0 72 72 years 10 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
54813 54813 2023-05 TAMPINES 4 ROOM 366 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 530000.0 72 72 years 11 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
55052 55052 2023-05 TAMPINES 5 ROOM 367 TAMPINES ST 34 01 TO 03 120.0 Improved 1997 620000.0 73 73 years 1.35861946074158 103.960788620104 367 TAMPINES ST 34
58400 58400 2023-04 TAMPINES 4 ROOM 359 TAMPINES ST 34 07 TO 09 107.0 Model A 1996 555000.0 71 71 years 11 months 1.35588169299314 103.961638534274 359 TAMPINES ST 34
58438 58438 2023-04 TAMPINES 5 ROOM 367A TAMPINES ST 34 10 TO 12 121.0 Improved 1997 630000.0 72 72 years 09 months 1.35770234108772 103.959954453114 367A TAMPINES ST 34
61904 61904 2023-02 TAMPINES 5 ROOM 373 TAMPINES ST 34 04 TO 06 124.0 Improved 1995 695000.0 71 71 years 07 months 1.3560218473311 103.958780627307 373 TAMPINES ST 34
62014 62014 2023-02 TAMPINES 4 ROOM 368 TAMPINES ST 34 04 TO 06 102.0 Model A 1997 503000.0 73 73 years 04 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
62040 62040 2023-02 TAMPINES 4 ROOM 370 TAMPINES ST 34 01 TO 03 102.0 Model A 1997 500000.0 73 73 years 1.3580388536739 103.959670086702 370 TAMPINES ST 34
64038 64038 2023-01 TAMPINES 4 ROOM 365 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 527000.0 73 73 years 01 month 1.35768611954955 103.960620745568 365 TAMPINES ST 34
64043 64043 2023-01 TAMPINES 4 ROOM 367 TAMPINES ST 34 10 TO 12 102.0 Model A 1997 532000.0 73 73 years 05 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
64799 64799 2023-01 TAMPINES 5 ROOM 359 TAMPINES ST 34 04 TO 06 121.0 Improved 1996 585000.0 72 72 years 04 months 1.35588169299314 103.961638534274 359 TAMPINES ST 34
66750 66750 2022-12 TAMPINES 5 ROOM 370 TAMPINES ST 34 04 TO 06 121.0 Improved 1997 670000.0 73 73 years 02 months 1.3580388536739 103.959670086702 370 TAMPINES ST 34
66767 66767 2022-12 TAMPINES 5 ROOM 368 TAMPINES ST 34 04 TO 06 122.0 Improved 1997 625000.0 73 73 years 07 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
66769 66769 2022-12 TAMPINES 5 ROOM 366 TAMPINES ST 34 07 TO 09 121.0 Improved 1997 610000.0 73 73 years 04 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
67427 67427 2022-12 TAMPINES 4 ROOM 367 TAMPINES ST 34 07 TO 09 102.0 Model A 1997 525000.0 73 73 years 06 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
68860 68860 2022-11 TAMPINES 4 ROOM 364 TAMPINES ST 34 04 TO 06 100.0 Model A 1997 540000.0 73 73 years 06 months 1.35720282099768 103.96013948983 364 TAMPINES ST 34
68947 68947 2022-11 TAMPINES 5 ROOM 366 TAMPINES ST 34 07 TO 09 121.0 Improved 1997 645000.0 73 73 years 06 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
69021 69021 2022-11 TAMPINES 4 ROOM 359 TAMPINES ST 34 04 TO 06 107.0 Model A 1996 503000.0 72 72 years 05 months 1.35588169299314 103.961638534274 359 TAMPINES ST 34
69072 69072 2022-11 TAMPINES 4 ROOM 361 TAMPINES ST 34 04 TO 06 107.0 Model A 1996 510000.0 72 72 years 07 months 1.35604416362237 103.962576038477 361 TAMPINES ST 34
70104 70104 2022-10 TAMPINES 4 ROOM 364 TAMPINES ST 34 04 TO 06 100.0 Model A 1997 528000.0 73 73 years 07 months 1.35720282099768 103.96013948983 364 TAMPINES ST 34
70175 70175 2022-10 TAMPINES 4 ROOM 363 TAMPINES ST 34 04 TO 06 107.0 Model A 1996 520000.0 72 72 years 05 months 1.3555206788848 103.960860222796 363 TAMPINES ST 34
70192 70192 2022-10 TAMPINES 4 ROOM 360 TAMPINES ST 34 01 TO 03 107.0 Model A 1996 512888.0 72 72 years 06 months 1.35561756499877 103.962257931593 360 TAMPINES ST 34
71284 71284 2022-10 TAMPINES 4 ROOM 368 TAMPINES ST 34 10 TO 12 102.0 Model A 1997 506000.0 73 73 years 08 months 1.35847458329919 103.961288498131 368 TAMPINES ST 34
73559 73559 2022-09 TAMPINES 5 ROOM 365 TAMPINES ST 34 04 TO 06 119.0 Improved 1997 605888.0 73 73 years 05 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
73694 73694 2022-09 TAMPINES 4 ROOM 359 TAMPINES ST 34 07 TO 09 106.0 Model A 1996 500000.0 72 72 years 07 months 1.35588169299314 103.961638534274 359 TAMPINES ST 34
73802 73802 2022-09 TAMPINES 4 ROOM 365 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 520000.0 73 73 years 05 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
73805 73805 2022-09 TAMPINES 4 ROOM 367 TAMPINES ST 34 07 TO 09 100.0 Model A 1997 518888.0 73 73 years 09 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
74306 74306 2022-08 TAMPINES 5 ROOM 366 TAMPINES ST 34 04 TO 06 121.0 Improved 1997 640000.0 73 73 years 08 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
74345 74345 2022-08 TAMPINES 4 ROOM 370 TAMPINES ST 34 07 TO 09 100.0 Model A 1997 520000.0 73 73 years 06 months 1.3580388536739 103.959670086702 370 TAMPINES ST 34
74729 74729 2022-08 TAMPINES 4 ROOM 367 TAMPINES ST 34 10 TO 12 100.0 Model A 1997 515000.0 73 73 years 10 months 1.35861946074158 103.960788620104 367 TAMPINES ST 34
75113 75113 2022-08 TAMPINES 4 ROOM 366 TAMPINES ST 34 01 TO 03 100.0 Model A 1997 500000.0 73 73 years 07 months 1.35761758572121 103.961378989065 366 TAMPINES ST 34
78233 78233 2022-07 TAMPINES 5 ROOM 365 TAMPINES ST 34 07 TO 09 119.0 Improved 1997 660000.0 73 73 years 07 months 1.35768611954955 103.960620745568 365 TAMPINES ST 34
78337 78337 2022-07 TAMPINES 4 ROOM 360 TAMPINES ST 34 04 TO 06 107.0 Model A 1996 485500.0 72 72 years 09 months 1.35561756499877 103.962257931593 360 TAMPINES ST 34
78339 78339 2022-07 TAMPINES 4 ROOM 362 TAMPINES ST 34 01 TO 03 107.0 Model A 1996 480000.0 72 72 years 09 months 1.35625122843632 103.961576641177 362 TAMPINES ST 34

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