resale_prices

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

where street_name = "CLEMENTI AVE 2"

✎ 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
1430 1430 2024-10 CLEMENTI 5 ROOM 355 CLEMENTI AVE 2 04 TO 06 117.0 Standard 1978 845000.0 52 52 years 06 months 1.3144512993879 103.769564479655
1461 1461 2024-10 CLEMENTI 3 ROOM 365 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 410000.0 52 52 years 04 months 1.3122997890586 103.769943830728
1462 1462 2024-10 CLEMENTI 3 ROOM 363 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 438000.0 52 52 years 04 months 1.31282069203581 103.768916989703
1463 1463 2024-10 CLEMENTI 3 ROOM 364 CLEMENTI AVE 2 04 TO 06 82.0 New Generation 1978 488888.0 52 52 years 04 months 1.31240641918888 103.768752275192
1464 1464 2024-10 CLEMENTI 3 ROOM 334 CLEMENTI AVE 2 04 TO 06 67.0 New Generation 1978 430000.0 52 52 years 10 months 1.31518502692041 103.768432708555
1465 1465 2024-10 CLEMENTI 3 ROOM 335 CLEMENTI AVE 2 04 TO 06 67.0 New Generation 1978 420000.0 53 53 years 02 months 1.31699411182356 103.768506615632
3594 3594 2024-09 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 426000.0 52 52 years 11 months 1.31306718149221 103.767339299757
3616 3616 2024-09 CLEMENTI 4 ROOM 329 CLEMENTI AVE 2 07 TO 09 92.0 New Generation 1978 703000.0 52 52 years 11 months 1.31306718149221 103.767339299757
3617 3617 2024-09 CLEMENTI 4 ROOM 333 CLEMENTI AVE 2 10 TO 12 92.0 New Generation 1978 673888.0 53 53 years 1.31518419506769 103.767498748964
3635 3635 2024-09 CLEMENTI 3 ROOM 351 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 415000.0 53 53 years 01 month 1.31535006995344 103.770861377512
3636 3636 2024-09 CLEMENTI 3 ROOM 362 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 423000.0 52 52 years 05 months 1.31271692776983 103.769902553813
3638 3638 2024-09 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 04 TO 06 82.0 New Generation 1978 502888.0 52 52 years 11 months 1.31306718149221 103.767339299757
6065 6065 2024-08 CLEMENTI 4 ROOM 358 CLEMENTI AVE 2 07 TO 09 92.0 New Generation 1978 562000.0 52 52 years 05 months 1.31358574940402 103.769084332627
6066 6066 2024-08 CLEMENTI 4 ROOM 332 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 605000.0 53 53 years 1.31474029464441 103.76748755096
6085 6085 2024-08 CLEMENTI 4 ROOM 350 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 573000.0 53 53 years 03 months 1.31562015307532 103.770191690378
6111 6111 2024-08 CLEMENTI 3 ROOM 363 CLEMENTI AVE 2 04 TO 06 67.0 New Generation 1978 390000.0 52 52 years 06 months 1.31282069203581 103.768916989703
6112 6112 2024-08 CLEMENTI 3 ROOM 365 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 385000.0 52 52 years 06 months 1.3122997890586 103.769943830728
6113 6113 2024-08 CLEMENTI 3 ROOM 351 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 400000.0 53 53 years 02 months 1.31535006995344 103.770861377512
8962 8962 2024-07 CLEMENTI 5 ROOM 336 CLEMENTI AVE 2 07 TO 09 119.0 Improved 1978 805000.0 53 53 years 04 months 1.31667943214563 103.769231150532
8963 8963 2024-07 CLEMENTI 5 ROOM 329 CLEMENTI AVE 2 07 TO 09 134.0 Adjoined flat 1978 970000.0 53 53 years 01 month 1.31306718149221 103.767339299757
8982 8982 2024-07 CLEMENTI 4 ROOM 351 CLEMENTI AVE 2 07 TO 09 92.0 New Generation 1978 600000.0 53 53 years 02 months 1.31535006995344 103.770861377512
8983 8983 2024-07 CLEMENTI 4 ROOM 365 CLEMENTI AVE 2 01 TO 03 90.0 New Generation 1978 500888.0 52 52 years 07 months 1.3122997890586 103.769943830728
8984 8984 2024-07 CLEMENTI 4 ROOM 350 CLEMENTI AVE 2 01 TO 03 92.0 New Generation 1978 500000.0 53 53 years 04 months 1.31562015307532 103.770191690378
9014 9014 2024-07 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 412000.0 53 53 years 01 month 1.31306718149221 103.767339299757
9018 9018 2024-07 CLEMENTI 3 ROOM 328 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 388888.0 53 53 years 02 months 1.31399161476536 103.767089003977
9019 9019 2024-07 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 418000.0 53 53 years 1.31306718149221 103.767339299757
9020 9020 2024-07 CLEMENTI 3 ROOM 331 CLEMENTI AVE 2 04 TO 06 67.0 New Generation 1978 385000.0 53 53 years 01 month 1.31413785421482 103.767942210615
9021 9021 2024-07 CLEMENTI 3 ROOM 365 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 380000.0 52 52 years 07 months 1.3122997890586 103.769943830728
11372 11372 2024-06 CLEMENTI 4 ROOM 333 CLEMENTI AVE 2 07 TO 09 92.0 New Generation 1978 645000.0 53 53 years 03 months 1.31518419506769 103.767498748964
11373 11373 2024-06 CLEMENTI 4 ROOM 349 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 550000.0 53 53 years 04 months 1.31595863810442 103.771054408276
11374 11374 2024-06 CLEMENTI 4 ROOM 359 CLEMENTI AVE 2 01 TO 03 92.0 New Generation 1978 570000.0 52 52 years 08 months 1.31349292425577 103.769854781007
11375 11375 2024-06 CLEMENTI 4 ROOM 358 CLEMENTI AVE 2 10 TO 12 92.0 New Generation 1978 608888.0 52 52 years 08 months 1.31358574940402 103.769084332627
11386 11386 2024-06 CLEMENTI 3 ROOM 362 CLEMENTI AVE 2 04 TO 06 67.0 New Generation 1978 408888.0 52 52 years 08 months 1.31271692776983 103.769902553813
11401 11401 2024-06 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 420000.0 53 53 years 02 months 1.31306718149221 103.767339299757
11403 11403 2024-06 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 408000.0 53 53 years 02 months 1.31306718149221 103.767339299757
13736 13736 2024-05 CLEMENTI 5 ROOM 357 CLEMENTI AVE 2 10 TO 12 117.0 Standard 1978 775000.0 52 52 years 11 months 1.31408279564086 103.769202736616
13765 13765 2024-05 CLEMENTI 5 ROOM 355 CLEMENTI AVE 2 07 TO 09 117.0 Standard 1978 770899.0 53 53 years 1.3144512993879 103.769564479655
13804 13804 2024-05 CLEMENTI 3 ROOM 362 CLEMENTI AVE 2 10 TO 12 82.0 New Generation 1978 478000.0 52 52 years 09 months 1.31271692776983 103.769902553813
13805 13805 2024-05 CLEMENTI 3 ROOM 334 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 392000.0 53 53 years 03 months 1.31518502692041 103.768432708555
16195 16195 2024-04 CLEMENTI 5 ROOM 338 CLEMENTI AVE 2 04 TO 06 119.0 Improved 1978 760000.0 53 53 years 08 months 1.3162903980152 103.769532089119
16203 16203 2024-04 CLEMENTI 4 ROOM 350 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 540000.0 53 53 years 06 months 1.31562015307532 103.770191690378
16207 16207 2024-04 CLEMENTI 4 ROOM 332 CLEMENTI AVE 2 13 TO 15 92.0 New Generation 1978 640000.0 53 53 years 06 months 1.31474029464441 103.76748755096
16232 16232 2024-04 CLEMENTI 3 ROOM 367 CLEMENTI AVE 2 07 TO 09 61.0 Model A 2003 500000.0 77 77 years 11 months 1.31294067164982 103.77164865498
18356 18356 2024-03 CLEMENTI 4 ROOM 358 CLEMENTI AVE 2 07 TO 09 92.0 New Generation 1978 618000.0 52 52 years 11 months 1.31358574940402 103.769084332627
18365 18365 2024-03 CLEMENTI 3 ROOM 365 CLEMENTI AVE 2 04 TO 06 81.0 New Generation 1978 485000.0 52 52 years 11 months 1.3122997890586 103.769943830728
18392 18392 2024-03 CLEMENTI 3 ROOM 363 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 400000.0 52 52 years 11 months 1.31282069203581 103.768916989703
20464 20464 2024-02 CLEMENTI 5 ROOM 355 CLEMENTI AVE 2 16 TO 18 117.0 Standard 1978 768000.0 53 53 years 01 month 1.3144512993879 103.769564479655
20495 20495 2024-02 CLEMENTI 3 ROOM 362 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 368000.0 52 52 years 11 months 1.31271692776983 103.769902553813
20529 20529 2024-02 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 04 TO 06 82.0 New Generation 1978 488000.0 53 53 years 06 months 1.31306718149221 103.767339299757
22967 22967 2024-01 CLEMENTI 5 ROOM 337 CLEMENTI AVE 2 19 TO 21 119.0 Improved 1978 850000.0 53 53 years 11 months 1.31605567747075 103.769112678697
23011 23011 2024-01 CLEMENTI 3 ROOM 334 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 450000.0 53 53 years 06 months 1.31518502692041 103.768432708555
23012 23012 2024-01 CLEMENTI 3 ROOM 366 CLEMENTI AVE 2 13 TO 15 61.0 Model A 2003 488888.0 78 78 years 03 months 1.31254953553443 103.771676380482
23013 23013 2024-01 CLEMENTI 3 ROOM 364 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 406000.0 53 53 years 01 month 1.31240641918888 103.768752275192
25128 25128 2023-12 CLEMENTI 5 ROOM 357 CLEMENTI AVE 2 22 TO 24 117.0 Standard 1978 820000.0 53 53 years 04 months 1.31408279564086 103.769202736616
25185 25185 2023-12 CLEMENTI 3 ROOM 351 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 410000.0 53 53 years 10 months 1.31535006995344 103.770861377512
27174 27174 2023-11 CLEMENTI 4 ROOM 333 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 600000.0 53 53 years 10 months 1.31518419506769 103.767498748964
27195 27195 2023-11 CLEMENTI 3 ROOM 334 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 370000.0 53 53 years 09 months 1.31518502692041 103.768432708555
27196 27196 2023-11 CLEMENTI 3 ROOM 366 CLEMENTI AVE 2 13 TO 15 61.0 Model A 2003 490000.0 78 78 years 03 months 1.31254953553443 103.771676380482
29371 29371 2023-10 CLEMENTI 5 ROOM 357 CLEMENTI AVE 2 04 TO 06 117.0 Standard 1978 738000.0 53 53 years 06 months 1.31408279564086 103.769202736616
29386 29386 2023-10 CLEMENTI 4 ROOM 350 CLEMENTI AVE 2 01 TO 03 92.0 New Generation 1978 490000.0 53 53 years 11 months 1.31562015307532 103.770191690378
29388 29388 2023-10 CLEMENTI 4 ROOM 358 CLEMENTI AVE 2 01 TO 03 92.0 New Generation 1978 525000.0 53 53 years 04 months 1.31358574940402 103.769084332627
29407 29407 2023-10 CLEMENTI 3 ROOM 351 CLEMENTI AVE 2 04 TO 06 67.0 New Generation 1978 385000.0 54 54 years 1.31535006995344 103.770861377512
29408 29408 2023-10 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 408888.0 53 53 years 09 months 1.31306718149221 103.767339299757
29409 29409 2023-10 CLEMENTI 3 ROOM 362 CLEMENTI AVE 2 10 TO 12 82.0 New Generation 1978 515000.0 53 53 years 03 months 1.31271692776983 103.769902553813
29410 29410 2023-10 CLEMENTI 3 ROOM 367 CLEMENTI AVE 2 19 TO 21 61.0 Model A 2003 500000.0 78 78 years 05 months 1.31294067164982 103.77164865498
31422 31422 2023-09 CLEMENTI 4 ROOM 359 CLEMENTI AVE 2 10 TO 12 92.0 New Generation 1978 548888.0 53 53 years 05 months 1.31349292425577 103.769854781007
31444 31444 2023-09 CLEMENTI 3 ROOM 363 CLEMENTI AVE 2 04 TO 06 82.0 New Generation 1978 442000.0 53 53 years 04 months 1.31282069203581 103.768916989703
31445 31445 2023-09 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 433000.0 53 53 years 11 months 1.31306718149221 103.767339299757
33726 33726 2023-08 CLEMENTI 4 ROOM 333 CLEMENTI AVE 2 10 TO 12 92.0 New Generation 1978 590000.0 54 54 years 1.31518419506769 103.767498748964
33730 33730 2023-08 CLEMENTI 4 ROOM 363 CLEMENTI AVE 2 04 TO 06 90.0 New Generation 1978 528000.0 53 53 years 05 months 1.31282069203581 103.768916989703
33731 33731 2023-08 CLEMENTI 4 ROOM 329 CLEMENTI AVE 2 10 TO 12 92.0 New Generation 1978 585000.0 54 54 years 1.31306718149221 103.767339299757
33732 33732 2023-08 CLEMENTI 4 ROOM 332 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 568000.0 54 54 years 01 month 1.31474029464441 103.76748755096
33733 33733 2023-08 CLEMENTI 4 ROOM 350 CLEMENTI AVE 2 10 TO 12 92.0 New Generation 1978 550000.0 54 54 years 02 months 1.31562015307532 103.770191690378
33749 33749 2023-08 CLEMENTI 3 ROOM 330 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 428000.0 53 53 years 11 months 1.31374471195404 103.767781828711
35967 35967 2023-07 CLEMENTI 4 ROOM 332 CLEMENTI AVE 2 07 TO 09 92.0 New Generation 1978 630000.0 54 54 years 02 months 1.31474029464441 103.76748755096
35969 35969 2023-07 CLEMENTI 3 ROOM 331 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 385000.0 54 54 years 01 month 1.31413785421482 103.767942210615
35982 35982 2023-07 CLEMENTI 3 ROOM 365 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 400000.0 53 53 years 07 months 1.3122997890586 103.769943830728
37853 37853 2023-06 CLEMENTI 5 ROOM 337 CLEMENTI AVE 2 16 TO 18 119.0 Improved 1978 780000.0 54 54 years 06 months 1.31605567747075 103.769112678697
37854 37854 2023-06 CLEMENTI 5 ROOM 337 CLEMENTI AVE 2 16 TO 18 119.0 Improved 1978 770000.0 54 54 years 06 months 1.31605567747075 103.769112678697
37877 37877 2023-06 CLEMENTI 3 ROOM 351 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 370000.0 54 54 years 03 months 1.31535006995344 103.770861377512
37878 37878 2023-06 CLEMENTI 3 ROOM 364 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 413000.0 53 53 years 08 months 1.31240641918888 103.768752275192
39929 39929 2023-05 CLEMENTI 4 ROOM 358 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 525000.0 53 53 years 10 months 1.31358574940402 103.769084332627
39962 39962 2023-05 CLEMENTI 3 ROOM 363 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 370000.0 53 53 years 09 months 1.31282069203581 103.768916989703
39969 39969 2023-05 CLEMENTI 3 ROOM 366 CLEMENTI AVE 2 10 TO 12 61.0 Model A 2003 495000.0 78 78 years 10 months 1.31254953553443 103.771676380482
39971 39971 2023-05 CLEMENTI 3 ROOM 351 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 380000.0 54 54 years 05 months 1.31535006995344 103.770861377512
42138 42138 2023-04 CLEMENTI 5 ROOM 356 CLEMENTI AVE 2 04 TO 06 117.0 Standard 1978 718888.0 53 53 years 11 months 1.31395967091571 103.769831365969
42150 42150 2023-04 CLEMENTI 4 ROOM 363 CLEMENTI AVE 2 07 TO 09 90.0 New Generation 1978 550000.0 53 53 years 09 months 1.31282069203581 103.768916989703
42168 42168 2023-04 CLEMENTI 3 ROOM 351 CLEMENTI AVE 2 07 TO 09 67.0 New Generation 1978 385000.0 54 54 years 05 months 1.31535006995344 103.770861377512
42169 42169 2023-04 CLEMENTI 3 ROOM 352 CLEMENTI AVE 2 04 TO 06 82.0 New Generation 1978 398888.0 54 54 years 05 months 1.31427265951788 103.771360860916
42170 42170 2023-04 CLEMENTI 3 ROOM 363 CLEMENTI AVE 2 10 TO 12 81.0 New Generation 1978 480000.0 53 53 years 09 months 1.31282069203581 103.768916989703
42259 42259 2023-04 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 423000.0 54 54 years 03 months 1.31306718149221 103.767339299757
44389 44389 2023-03 CLEMENTI 5 ROOM 338 CLEMENTI AVE 2 04 TO 06 119.0 Improved 1978 700000.0 54 54 years 08 months 1.3162903980152 103.769532089119
44390 44390 2023-03 CLEMENTI 5 ROOM 337 CLEMENTI AVE 2 13 TO 15 119.0 Improved 1978 780000.0 54 54 years 08 months 1.31605567747075 103.769112678697
44442 44442 2023-03 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 01 TO 03 67.0 New Generation 1978 380000.0 54 54 years 04 months 1.31306718149221 103.767339299757
44443 44443 2023-03 CLEMENTI 3 ROOM 329 CLEMENTI AVE 2 04 TO 06 82.0 New Generation 1978 470000.0 54 54 years 04 months 1.31306718149221 103.767339299757
44448 44448 2023-03 CLEMENTI 3 ROOM 365 CLEMENTI AVE 2 07 TO 09 81.0 New Generation 1978 468000.0 53 53 years 10 months 1.3122997890586 103.769943830728
44449 44449 2023-03 CLEMENTI 3 ROOM 330 CLEMENTI AVE 2 10 TO 12 67.0 New Generation 1978 380000.0 54 54 years 04 months 1.31374471195404 103.767781828711
46379 46379 2023-02 CLEMENTI 5 ROOM 337 CLEMENTI AVE 2 01 TO 03 119.0 Improved 1978 650000.0 54 54 years 10 months 1.31605567747075 103.769112678697
46391 46391 2023-02 CLEMENTI 4 ROOM 332 CLEMENTI AVE 2 01 TO 03 92.0 New Generation 1978 530000.0 54 54 years 07 months 1.31474029464441 103.76748755096
46392 46392 2023-02 CLEMENTI 4 ROOM 351 CLEMENTI AVE 2 04 TO 06 92.0 New Generation 1978 490000.0 54 54 years 08 months 1.31535006995344 103.770861377512

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