SELECT DISTINCT(a.crea_id), a.office_name, a.office_id, b.crea_id, b.mls_id, STR_TO_DATE(b.last_updated,'%a, %d %b %Y') AS LASTUPDATED, b.street_address, b.city, b.province, b.postal, b.price, b.bedroom_total, b.bathroom_total, b.half_bath_total, b.size_interior, c.sequence_id, c.thumbURL, c.medURL, c.largeURL, d.thumbURL AS THUMBB, d.medURL AS MEDB, d.largeURL AS LARGEB FROM tbl_CREA_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id AND a.office_id IN (284115)) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) LEFT JOIN tbl_CREA_0_photos d ON (a.crea_id = d.crea_id AND d.sequence_id = 0)ORDER BY b.price DESC, b.mls_id ASC

Office Listings

Search
X
Sort By
Array
(
    [crea_id] => 24307314
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16492
    [LASTUPDATED] => 2022-04-22
    [street_address] => Lot 1 MARINE AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => 
    [price] => 999900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637862424816330000/reb83/lowres/2/16492_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637862424816330000/reb83/medres/2/16492_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637862424816330000/reb83/highres/2/16492_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$999,900
| 0 | 0
Lot 1 MARINE AVE
Powell River, British Columbia

MLS#16492
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 25051701
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16987
    [LASTUPDATED] => 2022-11-09
    [street_address] => 5083 LEAPER ROAD
    [city] => Texada Island
    [province] => British Columbia
    [postal] => V0N3K0
    [price] => 689000.00
    [bedroom_total] => 1
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 2400 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638035999463030000/reb83/lowres/7/16987_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638035999463030000/reb83/medres/7/16987_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638035999463030000/reb83/highres/7/16987_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$689,000
2400 sqft | 1 | 2
5083 LEAPER ROAD
Texada Island, British Columbia
V0N3K0
MLS#16987
Magda Deininger: 604.578.0756 / Email
Array
(
    [crea_id] => 24940045
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16917
    [LASTUPDATED] => 2022-12-05
    [street_address] => 4737 REDONDA AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A5L7
    [price] => 679900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2084 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638005109983730000/reb83/lowres/7/16917_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638005109983730000/reb83/medres/7/16917_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638005109983730000/reb83/highres/7/16917_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$679,900
2084 sqft | 5 | 3
4737 REDONDA AVE
Powell River, British Columbia
V8A5L7
MLS#16917
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 25026644
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16978
    [LASTUPDATED] => 2022-11-14
    [street_address] => 6026 BELL ROAD
    [city] => Texada Island
    [province] => British Columbia
    [postal] => V0N3K0
    [price] => 630000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 288 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638030322640900000/reb83/lowres/8/16978_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638030322640900000/reb83/medres/8/16978_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638030322640900000/reb83/highres/8/16978_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$630,000
288 sqft | 0 | 0
6026 BELL ROAD
Texada Island, British Columbia
V0N3K0
MLS#16978
Magda Deininger: 604.578.0756 / Email
Array
(
    [crea_id] => 24307629
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16495
    [LASTUPDATED] => 2022-10-20
    [street_address] => 6231 WALNUT STREET
    [city] => Powell River
    [province] => British Columbia
    [postal] => 
    [price] => 599900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637862449636300000/reb83/lowres/5/16495_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637862449636300000/reb83/medres/5/16495_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637862449636300000/reb83/highres/5/16495_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$599,900
| 0 | 0
6231 WALNUT STREET
Powell River, British Columbia

MLS#16495
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 24846999
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16871
    [LASTUPDATED] => 2022-10-11
    [street_address] => 7052 TOBA STREET
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A1G8
    [price] => 599900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1764 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637982200417530000/reb83/lowres/1/16871_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637982200417530000/reb83/medres/1/16871_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637982200417530000/reb83/highres/1/16871_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$599,900
1764 sqft | 3 | 2
7052 TOBA STREET
Powell River, British Columbia
V8A1G8
MLS#16871
Magda Deininger: 604.578.0756 / Email
Array
(
    [crea_id] => 24661301
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16704
    [LASTUPDATED] => 2022-11-25
    [street_address] => 3617 JOYCE AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => 
    [price] => 589500.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 2576 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637993657059200000/reb83/lowres/4/16704_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637993657059200000/reb83/medres/4/16704_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637993657059200000/reb83/highres/4/16704_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$589,500
2576 sqft | 5 | 3
3617 JOYCE AVE
Powell River, British Columbia

MLS#16704
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 24991862
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16957
    [LASTUPDATED] => 2022-10-20
    [street_address] => 4781 FERNWOOD AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A3L7
    [price] => 584900.00
    [bedroom_total] => 6
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 2480 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638018773133230000/reb83/lowres/7/16957_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638018773133230000/reb83/medres/7/16957_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638018773133230000/reb83/highres/7/16957_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$584,900
2480 sqft | 6 | 2
4781 FERNWOOD AVE
Powell River, British Columbia
V8A3L7
MLS#16957
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 24930838
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16913
    [LASTUPDATED] => 2022-11-22
    [street_address] => 4792 QUEBEC AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A3G7
    [price] => 469000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1200 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638011879322070000/reb83/lowres/3/16913_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638011879322070000/reb83/medres/3/16913_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638011879322070000/reb83/highres/3/16913_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$469,000
1200 sqft | 2 | 1
4792 QUEBEC AVE
Powell River, British Columbia
V8A3G7
MLS#16913
Kaitlin Melvin: 604.578.0755 / Email
Array
(
    [crea_id] => 24302536
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16488
    [LASTUPDATED] => 2022-04-22
    [street_address] => 4893 FERNWOOD AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => 
    [price] => 399900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637861667366830000/reb83/lowres/8/16488_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637861667366830000/reb83/medres/8/16488_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637861667366830000/reb83/highres/8/16488_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$399,900
| 0 | 0
4893 FERNWOOD AVE
Powell River, British Columbia

MLS#16488
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 24939874
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16916
    [LASTUPDATED] => 2022-11-15
    [street_address] => 6816 KLAHANIE DRIVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A0C2
    [price] => 398000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1261 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638005104745130000/reb83/lowres/6/16916_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638005104745130000/reb83/medres/6/16916_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638005104745130000/reb83/highres/6/16916_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$398,000
1261 sqft | 2 | 1
6816 KLAHANIE DRIVE
Powell River, British Columbia
V8A0C2
MLS#16916
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 24302633
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16489
    [LASTUPDATED] => 2022-09-16
    [street_address] => 4572 MARINE AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => 
    [price] => 329900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637861691271230000/reb83/lowres/9/16489_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637861691271230000/reb83/medres/9/16489_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637861691271230000/reb83/highres/9/16489_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$329,900
Array | 0 | 0
4572 MARINE AVE
Powell River, British Columbia

MLS#16489
Sunny Dawn Kostelnik: 604.487.9992 / Email
Array
(
    [crea_id] => 24891813
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16889
    [LASTUPDATED] => 2022-11-24
    [street_address] => 61-7624 DUNCAN STREET
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A5L2
    [price] => 224900.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 846 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638046486996630000/reb83/lowres/9/16889_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638046486996630000/reb83/medres/9/16889_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638046486996630000/reb83/highres/9/16889_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$224,900
846 sqft | 2 | 1
61-7624 DUNCAN STREET
Powell River, British Columbia
V8A5L2
MLS#16889
Magda Deininger: 604.578.0756 / Email
Array
(
    [crea_id] => 24651730
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16693
    [LASTUPDATED] => 2022-11-25
    [street_address] => 7-4500 CLARIDGE ROAD
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A5N2
    [price] => 169900.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 655 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638036035385900000/reb83/lowres/3/16693_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638036035385900000/reb83/medres/3/16693_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638036035385900000/reb83/highres/3/16693_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$169,900
655 sqft | 2 | 1
7-4500 CLARIDGE ROAD
Powell River, British Columbia
V8A5N2
MLS#16693
Doug Daher: 604.208.2220 / Email
Sort By