resale_prices

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

where street_name = "JURONG WEST ST 42"

✎ 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
1150 1150 2024-10 JURONG WEST 5 ROOM 559 JURONG WEST ST 42 04 TO 06 137.0 Model A-Maisonette 1985 640000.0 59 59 years 09 months 1.35457631683511 103.718900605151
1188 1188 2024-10 JURONG WEST 4 ROOM 419 JURONG WEST ST 42 10 TO 12 84.0 Simplified 1985 465000.0 59 59 years 08 months 1.3509338709282 103.727172730504
1200 1200 2024-10 JURONG WEST 4 ROOM 561B JURONG WEST ST 42 04 TO 06 93.0 Model A 2018 580000.0 92 92 years 05 months 1.35477102717501 103.71967262747
1202 1202 2024-10 JURONG WEST 4 ROOM 419 JURONG WEST ST 42 01 TO 03 84.0 Simplified 1985 460000.0 59 59 years 08 months 1.3509338709282 103.727172730504
1204 1204 2024-10 JURONG WEST 4 ROOM 413 JURONG WEST ST 42 10 TO 12 104.0 Model A 1984 485000.0 58 58 years 10 months 1.35327579127819 103.725111457509
1205 1205 2024-10 JURONG WEST 4 ROOM 448 JURONG WEST ST 42 01 TO 03 104.0 Model A 1984 505000.0 59 59 years 1.35263257879691 103.719400998152
1206 1206 2024-10 JURONG WEST 4 ROOM 417 JURONG WEST ST 42 07 TO 09 89.0 Simplified 1985 480000.0 60 60 years 03 months 1.35130933561361 103.727345002671
1207 1207 2024-10 JURONG WEST 4 ROOM 449 JURONG WEST ST 42 07 TO 09 104.0 Model A 1985 500000.0 59 59 years 05 months 1.35234799631864 103.718438388228
1208 1208 2024-10 JURONG WEST 4 ROOM 557 JURONG WEST ST 42 04 TO 06 104.0 Model A 1985 481000.0 59 59 years 05 months 1.35399275101832 103.718567124767
1209 1209 2024-10 JURONG WEST 4 ROOM 417 JURONG WEST ST 42 07 TO 09 84.0 Simplified 1985 484000.0 60 60 years 03 months 1.35130933561361 103.727345002671
1210 1210 2024-10 JURONG WEST 4 ROOM 417 JURONG WEST ST 42 01 TO 03 84.0 Simplified 1985 435000.0 60 60 years 03 months 1.35130933561361 103.727345002671
1216 1216 2024-10 JURONG WEST 4 ROOM 414 JURONG WEST ST 42 04 TO 06 104.0 Model A 1984 506000.0 59 59 years 01 month 1.35281998847227 103.726034867574
1234 1234 2024-10 JURONG WEST 3 ROOM 421 JURONG WEST ST 42 07 TO 09 64.0 Simplified 1985 388000.0 59 59 years 09 months 1.35019763757677 103.727348817983
1236 1236 2024-10 JURONG WEST 3 ROOM 560A JURONG WEST ST 42 01 TO 03 68.0 Model A 2018 438888.0 92 92 years 05 months 1.3533579932237 103.719829055981
3233 3233 2024-09 JURONG WEST EXECUTIVE 549 JURONG WEST ST 42 01 TO 03 150.0 Maisonette 1986 710000.0 60 60 years 09 months 1.35291393924454 103.716072724817
3235 3235 2024-09 JURONG WEST EXECUTIVE 405 JURONG WEST ST 42 04 TO 06 159.0 Maisonette 1985 805000.0 60 60 years 01 month 1.35422127854017 103.721439265395
3265 3265 2024-09 JURONG WEST 5 ROOM 555 JURONG WEST ST 42 07 TO 09 133.0 Model A 1985 600000.0 59 59 years 09 months 1.35366860451456 103.718853145615
3266 3266 2024-09 JURONG WEST 5 ROOM 401 JURONG WEST ST 42 04 TO 06 134.0 Model A 1984 620000.0 59 59 years 1.3534249409359 103.721442695629
3267 3267 2024-09 JURONG WEST 5 ROOM 408 JURONG WEST ST 42 04 TO 06 139.0 Model A-Maisonette 1984 675000.0 58 58 years 08 months 1.35478633435811 103.722563908677
3268 3268 2024-09 JURONG WEST 5 ROOM 404 JURONG WEST ST 42 01 TO 03 133.0 Model A 1984 570000.0 59 59 years 02 months 1.35392288813097 103.72250572335
3303 3303 2024-09 JURONG WEST 3 ROOM 561B JURONG WEST ST 42 07 TO 09 68.0 Model A 2018 471000.0 92 92 years 06 months 1.35477102717501 103.71967262747
3312 3312 2024-09 JURONG WEST 4 ROOM 435 JURONG WEST ST 42 04 TO 06 103.0 Model A 1984 470000.0 58 58 years 11 months 1.35211011264928 103.723687896053
3313 3313 2024-09 JURONG WEST 4 ROOM 550 JURONG WEST ST 42 10 TO 12 103.0 Model A 1985 420000.0 59 59 years 08 months 1.35280491257393 103.716740537175
3314 3314 2024-09 JURONG WEST 4 ROOM 561A JURONG WEST ST 42 04 TO 06 93.0 Model A 2018 560000.0 92 92 years 06 months 1.354294109695 103.719755141086
3315 3315 2024-09 JURONG WEST 4 ROOM 414 JURONG WEST ST 42 04 TO 06 104.0 Model A 1984 488000.0 59 59 years 02 months 1.35281998847227 103.726034867574
3328 3328 2024-09 JURONG WEST 4 ROOM 550 JURONG WEST ST 42 10 TO 12 103.0 Model A 1985 480000.0 59 59 years 08 months 1.35280491257393 103.716740537175
3329 3329 2024-09 JURONG WEST 4 ROOM 412 JURONG WEST ST 42 04 TO 06 103.0 Model A 1985 528888.0 59 59 years 10 months 1.35325102149052 103.726140256506
3366 3366 2024-09 JURONG WEST 2 ROOM 560A JURONG WEST ST 42 16 TO 18 47.0 Model A 2018 350000.0 92 92 years 06 months 1.3533579932237 103.719829055981
5654 5654 2024-08 JURONG WEST EXECUTIVE 549 JURONG WEST ST 42 01 TO 03 151.0 Maisonette 1986 740000.0 60 60 years 10 months 1.35291393924454 103.716072724817
5681 5681 2024-08 JURONG WEST 5 ROOM 553 JURONG WEST ST 42 01 TO 03 133.0 Model A 1985 600000.0 59 59 years 08 months 1.35313192538561 103.718943649817
5686 5686 2024-08 JURONG WEST 5 ROOM 547 JURONG WEST ST 42 07 TO 09 140.0 Model A-Maisonette 1984 675000.0 59 59 years 01 month 1.35298202689802 103.714914008213
5687 5687 2024-08 JURONG WEST 5 ROOM 559 JURONG WEST ST 42 04 TO 06 139.0 Model A-Maisonette 1985 650000.0 59 59 years 10 months 1.35457631683511 103.718900605151
5688 5688 2024-08 JURONG WEST 5 ROOM 408 JURONG WEST ST 42 04 TO 06 137.0 Model A-Maisonette 1984 660000.0 58 58 years 08 months 1.35478633435811 103.722563908677
5723 5723 2024-08 JURONG WEST 4 ROOM 557 JURONG WEST ST 42 07 TO 09 104.0 Model A 1985 488000.0 59 59 years 07 months 1.35399275101832 103.718567124767
5730 5730 2024-08 JURONG WEST 4 ROOM 419 JURONG WEST ST 42 10 TO 12 84.0 Simplified 1985 465000.0 59 59 years 10 months 1.3509338709282 103.727172730504
5731 5731 2024-08 JURONG WEST 4 ROOM 450 JURONG WEST ST 42 01 TO 03 107.0 Model A 1985 468000.0 59 59 years 10 months 1.35163889174202 103.717524141693
5733 5733 2024-08 JURONG WEST 4 ROOM 406 JURONG WEST ST 42 10 TO 12 106.0 Model A 1984 470000.0 59 59 years 01 month 1.35431435538399 103.722395940054
5734 5734 2024-08 JURONG WEST 4 ROOM 447 JURONG WEST ST 42 07 TO 09 103.0 Model A 1984 480000.0 58 58 years 11 months 1.35248124739534 103.720399429592
5735 5735 2024-08 JURONG WEST 4 ROOM 448 JURONG WEST ST 42 07 TO 09 103.0 Model A 1984 527000.0 59 59 years 02 months 1.35263257879691 103.719400998152
5758 5758 2024-08 JURONG WEST 3 ROOM 544 JURONG WEST ST 42 04 TO 06 74.0 Model A 1984 396000.0 59 59 years 04 months 1.35239358298744 103.71575950591
8517 8517 2024-07 JURONG WEST 5 ROOM 408 JURONG WEST ST 42 07 TO 09 137.0 Model A-Maisonette 1984 680000.0 58 58 years 09 months 1.35478633435811 103.722563908677
8588 8588 2024-07 JURONG WEST 4 ROOM 561A JURONG WEST ST 42 10 TO 12 93.0 Model A 2018 600000.0 92 92 years 08 months 1.354294109695 103.719755141086
8592 8592 2024-07 JURONG WEST 4 ROOM 402 JURONG WEST ST 42 10 TO 12 103.0 Model A 1984 490000.0 59 59 years 02 months 1.35336452654527 103.722562360938
8593 8593 2024-07 JURONG WEST 4 ROOM 561A JURONG WEST ST 42 07 TO 09 93.0 Model A 2018 600000.0 92 92 years 08 months 1.354294109695 103.719755141086
8594 8594 2024-07 JURONG WEST 4 ROOM 432 JURONG WEST ST 42 01 TO 03 103.0 Model A 1984 501000.0 59 59 years 04 months 1.35256372860883 103.723569457588
8595 8595 2024-07 JURONG WEST 4 ROOM 561B JURONG WEST ST 42 04 TO 06 93.0 Model A 2018 555000.0 92 92 years 08 months 1.35477102717501 103.71967262747
8596 8596 2024-07 JURONG WEST 4 ROOM 546 JURONG WEST ST 42 07 TO 09 103.0 Model A 1985 430000.0 59 59 years 09 months 1.35270020453812 103.715217116167
8597 8597 2024-07 JURONG WEST 4 ROOM 543 JURONG WEST ST 42 07 TO 09 103.0 Model A 1984 468000.0 59 59 years 06 months 1.35186325238554 103.715798646003
8637 8637 2024-07 JURONG WEST 3 ROOM 421 JURONG WEST ST 42 04 TO 06 64.0 Simplified 1985 375000.0 60 60 years 1.35019763757677 103.727348817983
8646 8646 2024-07 JURONG WEST 3 ROOM 449 JURONG WEST ST 42 04 TO 06 74.0 Model A 1985 410000.0 59 59 years 07 months 1.35234799631864 103.718438388228
8647 8647 2024-07 JURONG WEST 3 ROOM 417 JURONG WEST ST 42 04 TO 06 64.0 Simplified 1985 365000.0 60 60 years 06 months 1.35130933561361 103.727345002671
8704 8704 2024-07 JURONG WEST 2 ROOM 560A JURONG WEST ST 42 10 TO 12 47.0 Model A 2018 360000.0 92 92 years 07 months 1.3533579932237 103.719829055981
10997 10997 2024-06 JURONG WEST EXECUTIVE 548 JURONG WEST ST 42 10 TO 12 148.0 Maisonette 1985 738000.0 59 59 years 11 months 1.3536653557826 103.716101539752
11030 11030 2024-06 JURONG WEST 5 ROOM 402 JURONG WEST ST 42 01 TO 03 134.0 Model A 1984 548000.0 59 59 years 04 months 1.35336452654527 103.722562360938
11062 11062 2024-06 JURONG WEST 4 ROOM 415 JURONG WEST ST 42 04 TO 06 108.0 Model A 1985 462000.0 59 59 years 10 months 1.35282431865817 103.724982266808
11075 11075 2024-06 JURONG WEST 4 ROOM 403 JURONG WEST ST 42 01 TO 03 106.0 Model A 1984 468000.0 59 59 years 01 month 1.35383921247336 103.721479705196
11104 11104 2024-06 JURONG WEST 3 ROOM 422 JURONG WEST ST 42 04 TO 06 64.0 Simplified 1985 374000.0 60 60 years 1.3502543792217 103.726390598371
13358 13358 2024-05 JURONG WEST EXECUTIVE 407 JURONG WEST ST 42 10 TO 12 150.0 Maisonette 1985 750000.0 60 60 years 04 months 1.35489444765725 103.721256064307
13359 13359 2024-05 JURONG WEST EXECUTIVE 556 JURONG WEST ST 42 07 TO 09 148.0 Maisonette 1986 708000.0 61 61 years 02 months 1.35362210304169 103.717858506741
13391 13391 2024-05 JURONG WEST 5 ROOM 551 JURONG WEST ST 42 04 TO 06 133.0 Model A 1985 620000.0 59 59 years 10 months 1.35237770099493 103.716921171248
13392 13392 2024-05 JURONG WEST 5 ROOM 453 JURONG WEST ST 42 01 TO 03 133.0 Model A 1985 588000.0 60 60 years 1.35137070665535 103.717502209972
13393 13393 2024-05 JURONG WEST 5 ROOM 547 JURONG WEST ST 42 01 TO 03 137.0 Model A-Maisonette 1984 610000.0 59 59 years 04 months 1.35298202689802 103.714914008213
13443 13443 2024-05 JURONG WEST 4 ROOM 449 JURONG WEST ST 42 01 TO 03 104.0 Model A 1985 468500.0 59 59 years 10 months 1.35234799631864 103.718438388228
13444 13444 2024-05 JURONG WEST 4 ROOM 432 JURONG WEST ST 42 10 TO 12 103.0 Model A 1984 485000.0 59 59 years 07 months 1.35256372860883 103.723569457588
13448 13448 2024-05 JURONG WEST 4 ROOM 432 JURONG WEST ST 42 04 TO 06 104.0 Model A 1984 475000.0 59 59 years 07 months 1.35256372860883 103.723569457588
13449 13449 2024-05 JURONG WEST 4 ROOM 448 JURONG WEST ST 42 07 TO 09 103.0 Model A 1984 465000.0 59 59 years 05 months 1.35263257879691 103.719400998152
13450 13450 2024-05 JURONG WEST 4 ROOM 545 JURONG WEST ST 42 01 TO 03 103.0 Model A 1985 460000.0 59 59 years 11 months 1.35229053905004 103.715246438458
13451 13451 2024-05 JURONG WEST 4 ROOM 554 JURONG WEST ST 42 10 TO 12 104.0 Model A 1984 470000.0 59 59 years 07 months 1.35323480092319 103.71786608982
13452 13452 2024-05 JURONG WEST 4 ROOM 554 JURONG WEST ST 42 10 TO 12 104.0 Model A 1984 460000.0 59 59 years 07 months 1.35323480092319 103.71786608982
13467 13467 2024-05 JURONG WEST 3 ROOM 445 JURONG WEST ST 42 01 TO 03 77.0 Model A 1985 375000.0 60 60 years 01 month 1.35206424277749 103.720552662265
15796 15796 2024-04 JURONG WEST EXECUTIVE 405 JURONG WEST ST 42 10 TO 12 150.0 Maisonette 1985 698000.0 60 60 years 05 months 1.35422127854017 103.721439265395
15798 15798 2024-04 JURONG WEST EXECUTIVE 409 JURONG WEST ST 42 10 TO 12 150.0 Maisonette 1985 695000.0 60 60 years 05 months 1.35409792704061 103.725324736878
15893 15893 2024-04 JURONG WEST 4 ROOM 414 JURONG WEST ST 42 04 TO 06 103.0 Model A 1984 452000.0 59 59 years 07 months 1.35281998847227 103.726034867574
15894 15894 2024-04 JURONG WEST 4 ROOM 432 JURONG WEST ST 42 04 TO 06 119.0 Model A 1984 500000.0 59 59 years 08 months 1.35256372860883 103.723569457588
15895 15895 2024-04 JURONG WEST 4 ROOM 420 JURONG WEST ST 42 04 TO 06 84.0 Simplified 1985 448000.0 60 60 years 02 months 1.35057174649766 103.727172770969
15896 15896 2024-04 JURONG WEST 4 ROOM 419 JURONG WEST ST 42 04 TO 06 84.0 Simplified 1985 430000.0 60 60 years 02 months 1.3509338709282 103.727172730504
15927 15927 2024-04 JURONG WEST 3 ROOM 560A JURONG WEST ST 42 13 TO 15 68.0 Model A 2018 448888.0 92 92 years 11 months 1.3533579932237 103.719829055981
15929 15929 2024-04 JURONG WEST 3 ROOM 455 JURONG WEST ST 42 04 TO 06 74.0 Model A 1985 386000.0 59 59 years 09 months 1.35106549757433 103.718527806379
15930 15930 2024-04 JURONG WEST 3 ROOM 561A JURONG WEST ST 42 16 TO 18 68.0 Model A 2018 450000.0 92 92 years 11 months 1.354294109695 103.719755141086
15931 15931 2024-04 JURONG WEST 3 ROOM 561A JURONG WEST ST 42 04 TO 06 68.0 Model A 2018 420000.0 92 92 years 11 months 1.354294109695 103.719755141086
15932 15932 2024-04 JURONG WEST 3 ROOM 421 JURONG WEST ST 42 04 TO 06 64.0 Simplified 1985 375000.0 60 60 years 03 months 1.35019763757677 103.727348817983
15933 15933 2024-04 JURONG WEST 3 ROOM 417 JURONG WEST ST 42 07 TO 09 64.0 Simplified 1985 358000.0 60 60 years 09 months 1.35130933561361 103.727345002671
15934 15934 2024-04 JURONG WEST 3 ROOM 544 JURONG WEST ST 42 04 TO 06 74.0 Model A 1984 370000.0 59 59 years 09 months 1.35239358298744 103.71575950591
17986 17986 2024-03 JURONG WEST EXECUTIVE 558 JURONG WEST ST 42 01 TO 03 151.0 Maisonette 1985 690000.0 60 60 years 04 months 1.35419821230377 103.717344057356
17987 17987 2024-03 JURONG WEST EXECUTIVE 549 JURONG WEST ST 42 10 TO 12 149.0 Maisonette 1986 735000.0 61 61 years 02 months 1.35291393924454 103.716072724817
18030 18030 2024-03 JURONG WEST 5 ROOM 452 JURONG WEST ST 42 07 TO 09 133.0 Model A 1985 590000.0 60 60 years 1.35157800634866 103.718510889309
18031 18031 2024-03 JURONG WEST 5 ROOM 408 JURONG WEST ST 42 01 TO 03 139.0 Model A-Maisonette 1984 640000.0 59 59 years 01 month 1.35478633435811 103.722563908677
18075 18075 2024-03 JURONG WEST 4 ROOM 455 JURONG WEST ST 42 01 TO 03 104.0 Model A 1985 450000.0 59 59 years 11 months 1.35106549757433 103.718527806379
18078 18078 2024-03 JURONG WEST 4 ROOM 403 JURONG WEST ST 42 10 TO 12 106.0 Model A 1984 490000.0 59 59 years 04 months 1.35383921247336 103.721479705196
18079 18079 2024-03 JURONG WEST 4 ROOM 561A JURONG WEST ST 42 04 TO 06 93.0 Model A 2018 555000.0 93 93 years 1.354294109695 103.719755141086
18092 18092 2024-03 JURONG WEST 3 ROOM 561B JURONG WEST ST 42 07 TO 09 68.0 Model A 2018 458000.0 93 93 years 1.35477102717501 103.71967262747
18108 18108 2024-03 JURONG WEST 4 ROOM 447 JURONG WEST ST 42 10 TO 12 103.0 Model A 1984 500000.0 59 59 years 04 months 1.35248124739534 103.720399429592
18133 18133 2024-03 JURONG WEST 2 ROOM 560A JURONG WEST ST 42 07 TO 09 47.0 Model A 2018 330000.0 93 93 years 1.3533579932237 103.719829055981
18134 18134 2024-03 JURONG WEST 2 ROOM 560A JURONG WEST ST 42 07 TO 09 47.0 Model A 2018 320000.0 93 93 years 1.3533579932237 103.719829055981
20088 20088 2024-02 JURONG WEST EXECUTIVE 556 JURONG WEST ST 42 01 TO 03 150.0 Maisonette 1986 670000.0 61 61 years 05 months 1.35362210304169 103.717858506741
20089 20089 2024-02 JURONG WEST EXECUTIVE 558 JURONG WEST ST 42 10 TO 12 150.0 Maisonette 1985 780000.0 60 60 years 05 months 1.35419821230377 103.717344057356
20090 20090 2024-02 JURONG WEST EXECUTIVE 405 JURONG WEST ST 42 10 TO 12 150.0 Maisonette 1985 638000.0 60 60 years 08 months 1.35422127854017 103.721439265395
20168 20168 2024-02 JURONG WEST 4 ROOM 561B JURONG WEST ST 42 10 TO 12 93.0 Model A 2018 535000.0 93 93 years 1.35477102717501 103.71967262747
20169 20169 2024-02 JURONG WEST 4 ROOM 419 JURONG WEST ST 42 04 TO 06 88.0 Simplified 1985 450000.0 60 60 years 03 months 1.3509338709282 103.727172730504
20170 20170 2024-02 JURONG WEST 4 ROOM 447 JURONG WEST ST 42 04 TO 06 103.0 Model A 1984 470000.0 59 59 years 04 months 1.35248124739534 103.720399429592

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