resale_prices

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

194 rows where street_name = "SMITH ST"

✎ 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
5156 5156 2025-04 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 500000.0 58 58 years 1.28211630828089 103.842845624261 335A SMITH ST
5443 5443 2025-04 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 82.0 Improved 1984 806000.0 58 58 years 1.28236449613222 103.843448181669 335B SMITH ST
29342 29342 2024-06 CENTRAL AREA 3 ROOM 335A SMITH ST 16 TO 18 60.0 Improved 1984 520000.0 58 58 years 10 months 1.28211630828089 103.842845624261 335A SMITH ST
36518 36518 2024-02 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 468000.0 59 59 years 02 months 1.28211630828089 103.842845624261 335A SMITH ST
39041 39041 2024-01 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 69.0 Improved 1984 515000.0 59 59 years 03 months 1.28211630828089 103.842845624261 335A SMITH ST
44280 44280 2023-11 CENTRAL AREA 3 ROOM 335A SMITH ST 10 TO 12 69.0 Improved 1984 528000.0 59 59 years 04 months 1.28211630828089 103.842845624261 335A SMITH ST
49533 49533 2023-08 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 530000.0 59 59 years 08 months 1.28211630828089 103.842845624261 335A SMITH ST
60883 60883 2023-03 CENTRAL AREA 3 ROOM 335A SMITH ST 13 TO 15 60.0 Improved 1984 480000.0 60 60 years 1.28211630828089 103.842845624261 335A SMITH ST
79112 79112 2022-07 CENTRAL AREA 3 ROOM 335A SMITH ST 13 TO 15 69.0 Improved 1984 540000.0 60 60 years 09 months 1.28211630828089 103.842845624261 335A SMITH ST
80612 80612 2022-06 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 73.0 Improved 1984 480000.0 60 60 years 10 months 1.28211630828089 103.842845624261 335A SMITH ST
88027 88027 2022-03 CENTRAL AREA 3 ROOM 335A SMITH ST 10 TO 12 60.0 Improved 1984 428000.0 61 61 years 1.28211630828089 103.842845624261 335A SMITH ST
89284 89284 2022-02 CENTRAL AREA 3 ROOM 335A SMITH ST 10 TO 12 70.0 Improved 1984 485000.0 61 61 years 02 months 1.28211630828089 103.842845624261 335A SMITH ST
103069 103069 2021-09 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 350000.0 61 61 years 07 months 1.28211630828089 103.842845624261 335A SMITH ST
108406 108406 2021-07 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 418000.0 61 61 years 09 months 1.28211630828089 103.842845624261 335A SMITH ST
115053 115053 2021-04 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 85.0 Improved 1984 620000.0 61 61 years 11 months 1.28236449613222 103.843448181669 335B SMITH ST
126936 126936 2020-11 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 82.0 Improved 1984 681000.0 62 62 years 05 months 1.28236449613222 103.843448181669 335B SMITH ST
131799 131799 2020-09 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 82.0 Improved 1984 590000.0 62 62 years 06 months 1.28236449613222 103.843448181669 335B SMITH ST
131825 131825 2020-09 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 390000.0 62 62 years 06 months 1.28211630828089 103.842845624261 335A SMITH ST
141969 141969 2020-03 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 370000.0 63 63 years 1.28211630828089 103.842845624261 335A SMITH ST
147422 147422 2019-12 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 399000.0 63 63 years 04 months 1.28211630828089 103.842845624261 335A SMITH ST
151452 151452 2019-10 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 82.0 Improved 1984 626000.0 63 63 years 05 months 1.28236449613222 103.843448181669 335B SMITH ST
151453 151453 2019-10 CENTRAL AREA 4 ROOM 335B SMITH ST 22 TO 24 82.0 Improved 1984 665000.0 63 63 years 05 months 1.28236449613222 103.843448181669 335B SMITH ST
157320 157320 2019-07 CENTRAL AREA 4 ROOM 335B SMITH ST 25 TO 27 82.0 Improved 1984 670000.0 63 63 years 08 months 1.28236449613222 103.843448181669 335B SMITH ST
161277 161277 2019-05 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 388000.0 63 63 years 10 months 1.28211630828089 103.842845624261 335A SMITH ST
171043 171043 2018-11 CENTRAL AREA 4 ROOM 335B SMITH ST 25 TO 27 87.0 Improved 1984 668000.0 64 64 years 04 months 1.28236449613222 103.843448181669 335B SMITH ST
173012 173012 2018-10 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 440000.0 64 64 years 06 months 1.28211630828089 103.842845624261 335A SMITH ST
177057 177057 2018-08 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 390000.0 64 64 years 07 months 1.28211630828089 103.842845624261 335A SMITH ST
179498 179498 2018-07 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 445000.0 64 64 years 10 months 1.28211630828089 103.842845624261 335A SMITH ST
185106 185106 2018-04 CENTRAL AREA 3 ROOM 335A SMITH ST 16 TO 18 60.0 Improved 1984 420000.0 64 64 years 11 months 1.28211630828089 103.842845624261 335A SMITH ST
185130 185130 2018-04 CENTRAL AREA 4 ROOM 335B SMITH ST 25 TO 27 82.0 Improved 1984 638000.0 64 64 years 11 months 1.28236449613222 103.843448181669 335B SMITH ST
194656 194656 2017-10 CENTRAL AREA 3 ROOM 335A SMITH ST 13 TO 15 60.0 Improved 1984 420000.0 65 65 years 05 months 1.28211630828089 103.842845624261 335A SMITH ST
207640 207640 2017-03 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 82.0 Improved 1984 640000.0 66 66 years 1.28236449613222 103.843448181669 335B SMITH ST
208815 208815 2017-02 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 89.0 Improved 1984 620000.0 66 66 years 01 month 1.28236449613222 103.843448181669 335B SMITH ST
212834 212834 2016-11 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 405000.0 66 66.0 1.28211630828089 103.842845624261 335A SMITH ST
214452 214452 2016-10 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 85.0 Improved 1984 625000.0 66 66.0 1.28236449613222 103.843448181669 335B SMITH ST
219621 219621 2016-07 CENTRAL AREA 3 ROOM 335A SMITH ST 13 TO 15 69.0 Improved 1984 508000.0 66 66.0 1.28211630828089 103.842845624261 335A SMITH ST
225060 225060 2016-04 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 87.0 Improved 1984 610000.0 66 66.0 1.28236449613222 103.843448181669 335B SMITH ST
226725 226725 2016-03 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 70.0 Improved 1984 510000.0 67 67.0 1.28211630828089 103.842845624261 335A SMITH ST
229480 229480 2016-01 CENTRAL AREA 4 ROOM 335B SMITH ST 16 TO 18 82.0 Improved 1984 596000.0 67 67.0 1.28236449613222 103.843448181669 335B SMITH ST
230694 230694 2015-12 CENTRAL AREA 3 ROOM 335A SMITH ST 13 TO 15 60.0 Improved 1984 433000.0 67 67.0 1.28211630828089 103.842845624261 335A SMITH ST
235420 235420 2015-09 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 82.0 Improved 1984 584000.0 67 67.0 1.28236449613222 103.843448181669 335B SMITH ST
236855 236855 2015-08 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 70.0 Improved 1984 400000.0 67 67.0 1.28211630828089 103.842845624261 335A SMITH ST
241778 241778 2015-05 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 70.0 Improved 1984 480000.0 67 67.0 1.28211630828089 103.842845624261 335A SMITH ST
258592 258592 2014-04 CENTRAL AREA 4 ROOM 335B SMITH ST 07 TO 09 82.0 Improved 1984 628000.0 69   1.28236449613222 103.843448181669 335B SMITH ST
260122 260122 2014-03 CENTRAL AREA 4 ROOM 335A SMITH ST 19 TO 21 85.0 Improved 1984 610000.0 69   1.28211630828089 103.842845624261 335A SMITH ST
260123 260123 2014-03 CENTRAL AREA 4 ROOM 335B SMITH ST 19 TO 21 85.0 Improved 1984 620018.0 69   1.28236449613222 103.843448181669 335B SMITH ST
262511 262511 2014-01 CENTRAL AREA 4 ROOM 335B SMITH ST 16 TO 18 82.0 Improved 1984 607888.0 69   1.28236449613222 103.843448181669 335B SMITH ST
264609 264609 2013-11 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 89.0 Improved 1984 565000.0 70   1.28236449613222 103.843448181669 335B SMITH ST
278648 278648 2013-01 CENTRAL AREA 4 ROOM 335B SMITH ST 16 TO 18 87.0 Improved 1984 620000.0 70   1.28236449613222 103.843448181669 335B SMITH ST
283009 283009 2012-10 CENTRAL AREA 4 ROOM 335B SMITH ST 07 TO 09 82.0 Improved 1984 560000.0 71   1.28236449613222 103.843448181669 335B SMITH ST
288794 288794 2012-07 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 455000.0 71   1.28211630828089 103.842845624261 335A SMITH ST
291628 291628 2012-06 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 450000.0 71   1.28211630828089 103.842845624261 335A SMITH ST
293750 293750 2012-05 CENTRAL AREA 4 ROOM 335B SMITH ST 06 TO 10 89.0 Improved 1984 585000.0 71   1.28236449613222 103.843448181669 335B SMITH ST
301383 301383 2012-01 CENTRAL AREA 3 ROOM 335A SMITH ST 13 TO 15 60.0 Improved 1984 480000.0 71   1.28211630828089 103.842845624261 335A SMITH ST
307908 307908 2011-09 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 82.0 Improved 1984 545000.0 72   1.28236449613222 103.843448181669 335B SMITH ST
317378 317378 2011-04 CENTRAL AREA 4 ROOM 335B SMITH ST 04 TO 06 82.0 Improved 1984 500000.0 72   1.28236449613222 103.843448181669 335B SMITH ST
321926 321926 2011-02 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 69.0 Improved 1984 400000.0 72   1.28211630828089 103.842845624261 335A SMITH ST
321944 321944 2011-02 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 87.0 Improved 1984 545000.0 72   1.28236449613222 103.843448181669 335B SMITH ST
323149 323149 2011-01 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 378000.0 72   1.28211630828089 103.842845624261 335A SMITH ST
334866 334866 2010-09 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 400000.0 73   1.28211630828089 103.842845624261 335A SMITH ST
336466 336466 2010-08 CENTRAL AREA 4 ROOM 335B SMITH ST 07 TO 09 82.0 Improved 1984 472000.0 73   1.28236449613222 103.843448181669 335B SMITH ST
338680 338680 2010-07 CENTRAL AREA 4 ROOM 335B SMITH ST 22 TO 24 82.0 Improved 1984 526000.0 73   1.28236449613222 103.843448181669 335B SMITH ST
338715 338715 2010-07 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 325000.0 73   1.28211630828089 103.842845624261 335A SMITH ST
338727 338727 2010-07 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 370000.0 73   1.28211630828089 103.842845624261 335A SMITH ST
342348 342348 2010-06 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 82.0 Improved 1984 457000.0 73   1.28236449613222 103.843448181669 335B SMITH ST
342393 342393 2010-06 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 360000.0 73   1.28211630828089 103.842845624261 335A SMITH ST
345811 345811 2010-05 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 357000.0 73   1.28211630828089 103.842845624261 335A SMITH ST
351720 351720 2010-03 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 82.0 Improved 1984 449000.0 73   1.28236449613222 103.843448181669 335B SMITH ST
355721 355721 2010-02 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 312000.0 73   1.28211630828089 103.842845624261 335A SMITH ST
360128 360128 2009-12 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 338000.0 74   1.28211630828089 103.842845624261 335A SMITH ST
365879 365879 2009-10 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 82.0 Improved 1984 460000.0 74   1.28236449613222 103.843448181669 335B SMITH ST
372111 372111 2009-08 CENTRAL AREA 4 ROOM 335B SMITH ST 07 TO 09 82.0 Improved 1984 390000.0 74   1.28236449613222 103.843448181669 335B SMITH ST
372112 372112 2009-08 CENTRAL AREA 4 ROOM 335B SMITH ST 19 TO 21 82.0 Improved 1984 460000.0 74   1.28236449613222 103.843448181669 335B SMITH ST
372139 372139 2009-08 CENTRAL AREA 4 ROOM 335B SMITH ST 16 TO 18 85.0 Improved 1984 453888.88 74   1.28236449613222 103.843448181669 335B SMITH ST
372178 372178 2009-08 CENTRAL AREA 3 ROOM 335A SMITH ST 16 TO 18 60.0 Improved 1984 350000.0 74   1.28211630828089 103.842845624261 335A SMITH ST
377374 377374 2009-06 CENTRAL AREA 4 ROOM 335B SMITH ST 19 TO 21 89.0 Improved 1984 483500.0 74   1.28236449613222 103.843448181669 335B SMITH ST
382009 382009 2009-04 CENTRAL AREA 4 ROOM 335B SMITH ST 16 TO 18 89.0 Improved 1984 431000.0 74   1.28236449613222 103.843448181669 335B SMITH ST
391308 391308 2008-12 CENTRAL AREA 4 ROOM 335B SMITH ST 16 TO 18 82.0 Improved 1984 435000.0 75   1.28236449613222 103.843448181669 335B SMITH ST
391310 391310 2008-12 CENTRAL AREA 4 ROOM 335B SMITH ST 19 TO 21 82.0 Improved 1984 465000.0 75   1.28236449613222 103.843448181669 335B SMITH ST
395095 395095 2008-10 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 325000.0 75   1.28211630828089 103.842845624261 335A SMITH ST
395097 395097 2008-10 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 285000.0 75   1.28211630828089 103.842845624261 335A SMITH ST
395104 395104 2008-10 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 69.0 Improved 1984 312800.0 75   1.28211630828089 103.842845624261 335A SMITH ST
397463 397463 2008-09 CENTRAL AREA 4 ROOM 335B SMITH ST 22 TO 24 82.0 Improved 1984 435000.0 75   1.28236449613222 103.843448181669 335B SMITH ST
399932 399932 2008-08 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 258000.0 75   1.28211630828089 103.842845624261 335A SMITH ST
413511 413511 2008-02 CENTRAL AREA 4 ROOM 335B SMITH ST 19 TO 21 87.0 Improved 1984 448000.0 75   1.28236449613222 103.843448181669 335B SMITH ST
415549 415549 2008-01 CENTRAL AREA 4 ROOM 335B SMITH ST 04 TO 06 82.0 Improved 1984 365000.0 75   1.28236449613222 103.843448181669 335B SMITH ST
415594 415594 2008-01 CENTRAL AREA 3 ROOM 335A SMITH ST 16 TO 18 60.0 Improved 1984 245000.0 75   1.28211630828089 103.842845624261 335A SMITH ST
419827 419827 2007-11 CENTRAL AREA 4 ROOM 335B SMITH ST 16 TO 18 85.0 Improved 1984 380000.0 76   1.28236449613222 103.843448181669 335B SMITH ST
431808 431808 2007-06 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 224000.0 76   1.28211630828089 103.842845624261 335A SMITH ST
431813 431813 2007-06 CENTRAL AREA 4 ROOM 335B SMITH ST 19 TO 21 82.0 Improved 1984 375000.0 76   1.28236449613222 103.843448181669 335B SMITH ST
436887 436887 2007-04 CENTRAL AREA 3 ROOM 335A SMITH ST 13 TO 15 60.0 Improved 1984 232000.0 76   1.28211630828089 103.842845624261 335A SMITH ST
446801 446801 2006-11 CENTRAL AREA 3 ROOM 335A SMITH ST 07 TO 09 60.0 Improved 1984 225000.0 77   1.28211630828089 103.842845624261 335A SMITH ST
453769 453769 2006-08 CENTRAL AREA 4 ROOM 335B SMITH ST 10 TO 12 82.0 Improved 1984 300000.0 77   1.28236449613222 103.843448181669 335B SMITH ST
453804 453804 2006-08 CENTRAL AREA 4 ROOM 335B SMITH ST 13 TO 15 82.0 Improved 1984 302000.0 77   1.28236449613222 103.843448181669 335B SMITH ST
458656 458656 2006-06 CENTRAL AREA 4 ROOM 335B SMITH ST 22 TO 24 82.0 Improved 1984 305000.0 77   1.28236449613222 103.843448181669 335B SMITH ST
461096 461096 2006-05 CENTRAL AREA 4 ROOM 335B SMITH ST 19 TO 21 89.0 Improved 1984 308000.0 77   1.28236449613222 103.843448181669 335B SMITH ST
468079 468079 2006-02 CENTRAL AREA 4 ROOM 335B SMITH ST 04 TO 06 89.0 Improved 1984 285000.0 77   1.28236449613222 103.843448181669 335B SMITH ST
470206 470206 2006-01 CENTRAL AREA 3 ROOM 335A SMITH ST 19 TO 21 60.0 Improved 1984 226000.0 77   1.28211630828089 103.842845624261 335A SMITH ST
472308 472308 2005-12 CENTRAL AREA 3 ROOM 335A SMITH ST 04 TO 06 60.0 Improved 1984 198000.0 78   1.28211630828089 103.842845624261 335A SMITH ST
474520 474520 2005-11 CENTRAL AREA 4 ROOM 335B SMITH ST 04 TO 06 82.0 Improved 1984 290000.0 78   1.28236449613222 103.843448181669 335B SMITH ST

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