resale_prices
Data license: Singapore Open Data Licence · Data source: Housing and Development Board · About: hdb-resale-prices-datasette
where street_name = "YISHUN AVE 9"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20 | 20 | 2024-10 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 705000.0 | 90 | 90 years 01 month | 1.43450592896688 | 103.843292004282 |
| 21 | 21 | 2024-10 | YISHUN | 5 ROOM | 315C | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 738888.0 | 90 | 90 years 01 month | 1.43236735703997 | 103.843300870773 |
| 61 | 61 | 2024-10 | YISHUN | 4 ROOM | 316C | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 585000.0 | 90 | 90 years 01 month | 1.43292306072856 | 103.843472712009 |
| 2067 | 2067 | 2024-09 | YISHUN | 5 ROOM | 318A | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 740888.0 | 90 | 90 years 03 months | 1.43407449681869 | 103.843573649647 |
| 2068 | 2068 | 2024-09 | YISHUN | 5 ROOM | 318A | YISHUN AVE 9 | 07 TO 09 | 112.0 | Improved | 2015 | 718000.0 | 90 | 90 years 02 months | 1.43407449681869 | 103.843573649647 |
| 2069 | 2069 | 2024-09 | YISHUN | 5 ROOM | 318B | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 726000.0 | 90 | 90 years 02 months | 1.43367833611169 | 103.843871260947 |
| 2083 | 2083 | 2024-09 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 07 TO 09 | 112.0 | Improved | 2015 | 730000.0 | 90 | 90 years 02 months | 1.43450592896688 | 103.843292004282 |
| 4351 | 4351 | 2024-08 | YISHUN | 4 ROOM | 247 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1985 | 450000.0 | 60 | 60 years 02 months | 1.43499780616096 | 103.842069242281 |
| 4357 | 4357 | 2024-08 | YISHUN | 4 ROOM | 316C | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 608000.0 | 90 | 90 years 03 months | 1.43292306072856 | 103.843472712009 |
| 4378 | 4378 | 2024-08 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1985 | 455000.0 | 59 | 59 years 10 months | 1.43454219874646 | 103.842114172195 |
| 6884 | 6884 | 2024-07 | YISHUN | 5 ROOM | 315C | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 690000.0 | 90 | 90 years 04 months | 1.43236735703997 | 103.843300870773 |
| 6960 | 6960 | 2024-07 | YISHUN | 4 ROOM | 316B | YISHUN AVE 9 | 01 TO 03 | 92.0 | Model A | 2015 | 560000.0 | 90 | 90 years 05 months | 1.43286932101608 | 103.842697590791 |
| 6961 | 6961 | 2024-07 | YISHUN | 4 ROOM | 246 | YISHUN AVE 9 | 07 TO 09 | 84.0 | Simplified | 1985 | 450000.0 | 59 | 59 years 10 months | 1.43509085774181 | 103.84269104902 |
| 6994 | 6994 | 2024-07 | YISHUN | 4 ROOM | 247 | YISHUN AVE 9 | 04 TO 06 | 84.0 | Simplified | 1985 | 445000.0 | 60 | 60 years 03 months | 1.43499780616096 | 103.842069242281 |
| 9910 | 9910 | 2024-06 | YISHUN | 5 ROOM | 318A | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 712888.0 | 90 | 90 years 05 months | 1.43407449681869 | 103.843573649647 |
| 9967 | 9967 | 2024-06 | YISHUN | 4 ROOM | 316B | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 580000.0 | 90 | 90 years 05 months | 1.43286932101608 | 103.842697590791 |
| 12078 | 12078 | 2024-05 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 01 TO 03 | 112.0 | Improved | 2015 | 650000.0 | 90 | 90 years 05 months | 1.43450592896688 | 103.843292004282 |
| 12132 | 12132 | 2024-05 | YISHUN | 4 ROOM | 315C | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 588000.0 | 90 | 90 years 06 months | 1.43236735703997 | 103.843300870773 |
| 12133 | 12133 | 2024-05 | YISHUN | 4 ROOM | 315B | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 570000.0 | 90 | 90 years 06 months | 1.43193085614681 | 103.842565042895 |
| 14633 | 14633 | 2024-04 | YISHUN | 4 ROOM | 317C | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 600000.0 | 90 | 90 years 06 months | 1.43378048287839 | 103.843105705893 |
| 14634 | 14634 | 2024-04 | YISHUN | 4 ROOM | 316A | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 560000.0 | 90 | 90 years 07 months | 1.43335530681195 | 103.842705084631 |
| 14635 | 14635 | 2024-04 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 07 TO 09 | 84.0 | Simplified | 1985 | 435000.0 | 60 | 60 years 02 months | 1.43454219874646 | 103.842114172195 |
| 14636 | 14636 | 2024-04 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 01 TO 03 | 105.0 | Model A | 1985 | 495800.0 | 60 | 60 years 02 months | 1.43454219874646 | 103.842114172195 |
| 16939 | 16939 | 2024-03 | YISHUN | 5 ROOM | 315C | YISHUN AVE 9 | 10 TO 12 | 112.0 | Improved | 2015 | 712000.0 | 90 | 90 years 09 months | 1.43236735703997 | 103.843300870773 |
| 17000 | 17000 | 2024-03 | YISHUN | 4 ROOM | 248 | YISHUN AVE 9 | 01 TO 03 | 89.0 | Simplified | 1984 | 475000.0 | 59 | 59 years 09 months | 1.43566049426782 | 103.842373027861 |
| 19018 | 19018 | 2024-02 | YISHUN | 4 ROOM | 315A | YISHUN AVE 9 | 10 TO 12 | 92.0 | Model A | 2015 | 565000.0 | 90 | 90 years 09 months | 1.43238385408312 | 103.842384119393 |
| 19030 | 19030 | 2024-02 | YISHUN | 4 ROOM | 250 | YISHUN AVE 9 | 04 TO 06 | 84.0 | Simplified | 1985 | 425000.0 | 60 | 60 years 03 months | 1.43553062556873 | 103.84167355912 |
| 19032 | 19032 | 2024-02 | YISHUN | 4 ROOM | 249 | YISHUN AVE 9 | 10 TO 12 | 84.0 | Simplified | 1985 | 440888.0 | 60 | 60 years 06 months | 1.43524068670504 | 103.841852407535 |
| 21196 | 21196 | 2024-01 | YISHUN | 4 ROOM | 246 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1985 | 405000.0 | 60 | 60 years 03 months | 1.43509085774181 | 103.84269104902 |
| 21199 | 21199 | 2024-01 | YISHUN | 4 ROOM | 315A | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 605000.0 | 90 | 90 years 10 months | 1.43238385408312 | 103.842384119393 |
| 23733 | 23733 | 2023-12 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 675000.0 | 90 | 90 years 11 months | 1.43450592896688 | 103.843292004282 |
| 23734 | 23734 | 2023-12 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 07 TO 09 | 112.0 | Improved | 2015 | 680000.0 | 90 | 90 years 11 months | 1.43450592896688 | 103.843292004282 |
| 23780 | 23780 | 2023-12 | YISHUN | 4 ROOM | 315C | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 575000.0 | 90 | 90 years 11 months | 1.43236735703997 | 103.843300870773 |
| 25731 | 25731 | 2023-11 | YISHUN | 5 ROOM | 315C | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 645000.0 | 91 | 91 years | 1.43236735703997 | 103.843300870773 |
| 25794 | 25794 | 2023-11 | YISHUN | 4 ROOM | 318A | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 585000.0 | 91 | 91 years | 1.43407449681869 | 103.843573649647 |
| 25795 | 25795 | 2023-11 | YISHUN | 4 ROOM | 316B | YISHUN AVE 9 | 10 TO 12 | 92.0 | Model A | 2015 | 550000.0 | 91 | 91 years 01 month | 1.43286932101608 | 103.842697590791 |
| 27849 | 27849 | 2023-10 | YISHUN | 5 ROOM | 315C | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 708000.0 | 91 | 91 years | 1.43236735703997 | 103.843300870773 |
| 27904 | 27904 | 2023-10 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 04 TO 06 | 84.0 | Simplified | 1985 | 438000.0 | 60 | 60 years 08 months | 1.43454219874646 | 103.842114172195 |
| 27905 | 27905 | 2023-10 | YISHUN | 4 ROOM | 317C | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 590000.0 | 91 | 91 years 01 month | 1.43378048287839 | 103.843105705893 |
| 30057 | 30057 | 2023-09 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 01 TO 03 | 112.0 | Improved | 2015 | 630000.0 | 91 | 91 years 02 months | 1.43450592896688 | 103.843292004282 |
| 30099 | 30099 | 2023-09 | YISHUN | 4 ROOM | 317A | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 530888.0 | 91 | 91 years 01 month | 1.43450592896688 | 103.843292004282 |
| 30100 | 30100 | 2023-09 | YISHUN | 4 ROOM | 317B | YISHUN AVE 9 | 01 TO 03 | 92.0 | Model A | 2015 | 511000.0 | 91 | 91 years 01 month | 1.43416878511817 | 103.842950441024 |
| 30101 | 30101 | 2023-09 | YISHUN | 4 ROOM | 315B | YISHUN AVE 9 | 10 TO 12 | 92.0 | Model A | 2015 | 545000.0 | 91 | 91 years 01 month | 1.43193085614681 | 103.842565042895 |
| 30102 | 30102 | 2023-09 | YISHUN | 4 ROOM | 317B | YISHUN AVE 9 | 10 TO 12 | 92.0 | Model A | 2015 | 575000.0 | 91 | 91 years 01 month | 1.43416878511817 | 103.842950441024 |
| 30145 | 30145 | 2023-09 | YISHUN | 3 ROOM | 316A | YISHUN AVE 9 | 10 TO 12 | 67.0 | Model A | 2015 | 425000.0 | 91 | 91 years 02 months | 1.43335530681195 | 103.842705084631 |
| 32018 | 32018 | 2023-08 | YISHUN | 5 ROOM | 315A | YISHUN AVE 9 | 01 TO 03 | 112.0 | Improved | 2015 | 638000.0 | 91 | 91 years 03 months | 1.43238385408312 | 103.842384119393 |
| 32037 | 32037 | 2023-08 | YISHUN | 5 ROOM | 316C | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 610000.0 | 91 | 91 years 04 months | 1.43292306072856 | 103.843472712009 |
| 32038 | 32038 | 2023-08 | YISHUN | 5 ROOM | 316C | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 685000.0 | 91 | 91 years 03 months | 1.43292306072856 | 103.843472712009 |
| 32116 | 32116 | 2023-08 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1985 | 400000.0 | 60 | 60 years 11 months | 1.43454219874646 | 103.842114172195 |
| 32626 | 32626 | 2023-08 | YISHUN | 4 ROOM | 250 | YISHUN AVE 9 | 07 TO 09 | 84.0 | Simplified | 1985 | 422000.0 | 60 | 60 years 10 months | 1.43553062556873 | 103.84167355912 |
| 34497 | 34497 | 2023-07 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 10 TO 12 | 112.0 | Improved | 2015 | 685000.0 | 91 | 91 years 04 months | 1.43450592896688 | 103.843292004282 |
| 34546 | 34546 | 2023-07 | YISHUN | 4 ROOM | 246 | YISHUN AVE 9 | 04 TO 06 | 84.0 | Simplified | 1985 | 425000.0 | 60 | 60 years 10 months | 1.43509085774181 | 103.84269104902 |
| 34547 | 34547 | 2023-07 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 07 TO 09 | 84.0 | Simplified | 1985 | 400000.0 | 60 | 60 years 11 months | 1.43454219874646 | 103.842114172195 |
| 38398 | 38398 | 2023-05 | YISHUN | 5 ROOM | 315B | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 673000.0 | 91 | 91 years 05 months | 1.43193085614681 | 103.842565042895 |
| 38402 | 38402 | 2023-05 | YISHUN | 5 ROOM | 315C | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 696000.0 | 91 | 91 years 06 months | 1.43236735703997 | 103.843300870773 |
| 38460 | 38460 | 2023-05 | YISHUN | 4 ROOM | 315A | YISHUN AVE 9 | 10 TO 12 | 92.0 | Model A | 2015 | 540000.0 | 91 | 91 years 06 months | 1.43238385408312 | 103.842384119393 |
| 40695 | 40695 | 2023-04 | YISHUN | 4 ROOM | 246 | YISHUN AVE 9 | 04 TO 06 | 84.0 | Simplified | 1985 | 420000.0 | 61 | 61 years | 1.43509085774181 | 103.84269104902 |
| 40696 | 40696 | 2023-04 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1985 | 418000.0 | 61 | 61 years 01 month | 1.43454219874646 | 103.842114172195 |
| 40708 | 40708 | 2023-04 | YISHUN | 4 ROOM | 317C | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 570000.0 | 91 | 91 years 06 months | 1.43378048287839 | 103.843105705893 |
| 40709 | 40709 | 2023-04 | YISHUN | 4 ROOM | 316C | YISHUN AVE 9 | 10 TO 12 | 92.0 | Model A | 2015 | 546000.0 | 91 | 91 years 07 months | 1.43292306072856 | 103.843472712009 |
| 40724 | 40724 | 2023-04 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 07 TO 09 | 84.0 | Simplified | 1985 | 415000.0 | 61 | 61 years 02 months | 1.43454219874646 | 103.842114172195 |
| 42833 | 42833 | 2023-03 | YISHUN | 5 ROOM | 318B | YISHUN AVE 9 | 07 TO 09 | 112.0 | Improved | 2015 | 635000.0 | 91 | 91 years 07 months | 1.43367833611169 | 103.843871260947 |
| 42834 | 42834 | 2023-03 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 635000.0 | 91 | 91 years 07 months | 1.43450592896688 | 103.843292004282 |
| 42876 | 42876 | 2023-03 | YISHUN | 4 ROOM | 247 | YISHUN AVE 9 | 07 TO 09 | 84.0 | Simplified | 1985 | 410000.0 | 61 | 61 years 06 months | 1.43499780616096 | 103.842069242281 |
| 42882 | 42882 | 2023-03 | YISHUN | 4 ROOM | 317C | YISHUN AVE 9 | 01 TO 03 | 92.0 | Model A | 2015 | 475000.0 | 91 | 91 years 08 months | 1.43378048287839 | 103.843105705893 |
| 42885 | 42885 | 2023-03 | YISHUN | 4 ROOM | 315B | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 535000.0 | 91 | 91 years 08 months | 1.43193085614681 | 103.842565042895 |
| 45095 | 45095 | 2023-02 | YISHUN | 5 ROOM | 316C | YISHUN AVE 9 | 07 TO 09 | 112.0 | Improved | 2015 | 665000.0 | 91 | 91 years 09 months | 1.43292306072856 | 103.843472712009 |
| 45145 | 45145 | 2023-02 | YISHUN | 4 ROOM | 245 | YISHUN AVE 9 | 07 TO 09 | 105.0 | Model A | 1985 | 450000.0 | 61 | 61 years 03 months | 1.43454219874646 | 103.842114172195 |
| 45146 | 45146 | 2023-02 | YISHUN | 4 ROOM | 315A | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 512000.0 | 91 | 91 years 09 months | 1.43238385408312 | 103.842384119393 |
| 45147 | 45147 | 2023-02 | YISHUN | 4 ROOM | 317B | YISHUN AVE 9 | 01 TO 03 | 92.0 | Model A | 2015 | 508000.0 | 91 | 91 years 09 months | 1.43416878511817 | 103.842950441024 |
| 45148 | 45148 | 2023-02 | YISHUN | 4 ROOM | 317C | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 540000.0 | 91 | 91 years 09 months | 1.43378048287839 | 103.843105705893 |
| 46950 | 46950 | 2023-01 | YISHUN | 5 ROOM | 316C | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 610000.0 | 91 | 91 years 10 months | 1.43292306072856 | 103.843472712009 |
| 47016 | 47016 | 2023-01 | YISHUN | 4 ROOM | 316C | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 540000.0 | 91 | 91 years 11 months | 1.43292306072856 | 103.843472712009 |
| 47026 | 47026 | 2023-01 | YISHUN | 4 ROOM | 316B | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 545000.0 | 91 | 91 years 10 months | 1.43286932101608 | 103.842697590791 |
| 47031 | 47031 | 2023-01 | YISHUN | 4 ROOM | 317C | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 570000.0 | 91 | 91 years 10 months | 1.43378048287839 | 103.843105705893 |
| 47032 | 47032 | 2023-01 | YISHUN | 4 ROOM | 248 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1984 | 385000.0 | 61 | 61 years | 1.43566049426782 | 103.842373027861 |
| 47033 | 47033 | 2023-01 | YISHUN | 4 ROOM | 318C | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 530888.0 | 91 | 91 years 10 months | 1.43338279018701 | 103.843517908933 |
| 47107 | 47107 | 2023-01 | YISHUN | 3 ROOM | 316B | YISHUN AVE 9 | 07 TO 09 | 67.0 | Model A | 2015 | 415000.0 | 91 | 91 years 10 months | 1.43286932101608 | 103.842697590791 |
| 50174 | 50174 | 2022-12 | YISHUN | 4 ROOM | 317A | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 520000.0 | 92 | 92 years | 1.43450592896688 | 103.843292004282 |
| 50177 | 50177 | 2022-12 | YISHUN | 4 ROOM | 316B | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 525000.0 | 91 | 91 years 11 months | 1.43286932101608 | 103.842697590791 |
| 50249 | 50249 | 2022-12 | YISHUN | 5 ROOM | 315A | YISHUN AVE 9 | 10 TO 12 | 112.0 | Improved | 2015 | 660000.0 | 91 | 91 years 11 months | 1.43238385408312 | 103.842384119393 |
| 50285 | 50285 | 2022-12 | YISHUN | 4 ROOM | 316C | YISHUN AVE 9 | 04 TO 06 | 92.0 | Model A | 2015 | 485000.0 | 91 | 91 years 11 months | 1.43292306072856 | 103.843472712009 |
| 50303 | 50303 | 2022-12 | YISHUN | 5 ROOM | 317A | YISHUN AVE 9 | 01 TO 03 | 112.0 | Improved | 2015 | 608000.0 | 91 | 91 years 11 months | 1.43450592896688 | 103.843292004282 |
| 50359 | 50359 | 2022-12 | YISHUN | 3 ROOM | 316A | YISHUN AVE 9 | 10 TO 12 | 67.0 | Model A | 2015 | 410000.0 | 91 | 91 years 11 months | 1.43335530681195 | 103.842705084631 |
| 50362 | 50362 | 2022-12 | YISHUN | 4 ROOM | 246 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1985 | 413000.0 | 61 | 61 years 05 months | 1.43509085774181 | 103.84269104902 |
| 50367 | 50367 | 2022-12 | YISHUN | 4 ROOM | 250 | YISHUN AVE 9 | 04 TO 06 | 84.0 | Simplified | 1985 | 415000.0 | 61 | 61 years 06 months | 1.43553062556873 | 103.84167355912 |
| 52220 | 52220 | 2022-11 | YISHUN | 4 ROOM | 318B | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 565000.0 | 92 | 92 years | 1.43367833611169 | 103.843871260947 |
| 52873 | 52873 | 2022-11 | YISHUN | 4 ROOM | 318C | YISHUN AVE 9 | 01 TO 03 | 92.0 | Model A | 2015 | 498000.0 | 92 | 92 years | 1.43338279018701 | 103.843517908933 |
| 54693 | 54693 | 2022-10 | YISHUN | 4 ROOM | 316B | YISHUN AVE 9 | 07 TO 09 | 92.0 | Model A | 2015 | 520000.0 | 92 | 92 years 01 month | 1.43286932101608 | 103.842697590791 |
| 54709 | 54709 | 2022-10 | YISHUN | 4 ROOM | 318C | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 560000.0 | 92 | 92 years 01 month | 1.43338279018701 | 103.843517908933 |
| 54780 | 54780 | 2022-10 | YISHUN | 5 ROOM | 318B | YISHUN AVE 9 | 04 TO 06 | 112.0 | Improved | 2015 | 640888.0 | 92 | 92 years 01 month | 1.43367833611169 | 103.843871260947 |
| 55958 | 55958 | 2022-09 | YISHUN | 4 ROOM | 247 | YISHUN AVE 9 | 07 TO 09 | 105.0 | Model A | 1985 | 470000.0 | 62 | 62 years 01 month | 1.43499780616096 | 103.842069242281 |
| 55959 | 55959 | 2022-09 | YISHUN | 4 ROOM | 250 | YISHUN AVE 9 | 10 TO 12 | 104.0 | Model A | 1985 | 470000.0 | 61 | 61 years 09 months | 1.43553062556873 | 103.84167355912 |
| 56003 | 56003 | 2022-09 | YISHUN | 4 ROOM | 249 | YISHUN AVE 9 | 01 TO 03 | 84.0 | Simplified | 1985 | 363000.0 | 61 | 61 years 11 months | 1.43524068670504 | 103.841852407535 |
| 56031 | 56031 | 2022-09 | YISHUN | 3 ROOM | 316B | YISHUN AVE 9 | 04 TO 06 | 67.0 | Model A | 2015 | 390000.0 | 92 | 92 years 02 months | 1.43286932101608 | 103.842697590791 |
| 58212 | 58212 | 2022-09 | YISHUN | 5 ROOM | 318B | YISHUN AVE 9 | 07 TO 09 | 112.0 | Improved | 2015 | 655000.0 | 92 | 92 years 02 months | 1.43367833611169 | 103.843871260947 |
| 58228 | 58228 | 2022-09 | YISHUN | 5 ROOM | 316C | YISHUN AVE 9 | 13 TO 15 | 112.0 | Improved | 2015 | 643000.0 | 92 | 92 years 02 months | 1.43292306072856 | 103.843472712009 |
| 58229 | 58229 | 2022-09 | YISHUN | 5 ROOM | 316C | YISHUN AVE 9 | 07 TO 09 | 112.0 | Improved | 2015 | 642000.0 | 92 | 92 years 02 months | 1.43292306072856 | 103.843472712009 |
| 58295 | 58295 | 2022-09 | YISHUN | 4 ROOM | 318B | YISHUN AVE 9 | 13 TO 15 | 92.0 | Model A | 2015 | 540000.0 | 92 | 92 years 02 months | 1.43367833611169 | 103.843871260947 |
| 58365 | 58365 | 2022-09 | YISHUN | 4 ROOM | 316C | YISHUN AVE 9 | 01 TO 03 | 92.0 | Model A | 2015 | 500000.0 | 92 | 92 years 02 months | 1.43292306072856 | 103.843472712009 |
Advanced export
JSON shape: default, array, newline-delimited
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]);