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
X

Office Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 24307314
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16492
    [LASTUPDATED] => 2022-12-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] => 
)
View
$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] => 2023-01-09
    [street_address] => 5083 LEAPER ROAD
    [city] => Texada Island
    [province] => British Columbia
    [postal] => V0N3K0
    [price] => 659000.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] => 
)
View
$659,000
2400 sqft | 1 | 2
5083 LEAPER ROAD
Texada Island, British Columbia
V0N3K0
MLS#16987
Magda Deininger: 604.578.0756 / Email 
Array
(
    [crea_id] => 25026644
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16978
    [LASTUPDATED] => 2023-02-03
    [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] => 
)
View
$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-12-06
    [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] => 
)
View
$599,900
| 0 | 0
6231 WALNUT STREET
Powell River, British Columbia

MLS#16495
Sunny Dawn Kostelnik: 604.487.9992 / Email 
Array
(
    [crea_id] => 24991862
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 16957
    [LASTUPDATED] => 2023-01-28
    [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/TS638094186606470000/reb83/lowres/7/16957_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638094186606470000/reb83/medres/7/16957_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638094186606470000/reb83/highres/7/16957_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$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] => 25247515
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 17083
    [LASTUPDATED] => 2023-02-04
    [street_address] => 3332 MARINE AVE
    [city] => Powell River
    [province] => British Columbia
    [postal] => V8A2G8
    [price] => 569000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 2187 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638110555313600000/reb83/lowres/3/17083_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638110555313600000/reb83/medres/3/17083_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638110555313600000/reb83/highres/3/17083_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$569,000
2187 sqft | 3 | 2
3332 MARINE AVE
Powell River, British Columbia
V8A2G8
MLS#17083
Kaitlin Melvin: 604.578.0755 / 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] => 
)
View
$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] => 25243847
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 17075
    [LASTUPDATED] => 2023-02-03
    [street_address] => Lot 11 GILLIES BAY ROAD
    [city] => Texada Island
    [province] => British Columbia
    [postal] => 
    [price] => 395000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638110434634900000/reb83/lowres/5/17075_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638110434634900000/reb83/medres/5/17075_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638110434634900000/reb83/highres/5/17075_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$395,000
Array | 0 | 0
Lot 11 GILLIES BAY ROAD
Texada Island, British Columbia

MLS#17075
Magda Deininger: 604.578.0756 / Email 
Array
(
    [crea_id] => 25165641
    [office_name] => 2% REALTY SUNSHINE COAST
    [office_id] => 284115
    [mls_id] => 17045
    [LASTUPDATED] => 2023-01-29
    [street_address] => 8639 MYRTLE POINT ROAD
    [city] => Powell River
    [province] => British Columbia
    [postal] => 
    [price] => 329000.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 316 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638088811001230000/reb83/lowres/5/17045_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638088811001230000/reb83/medres/5/17045_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638088811001230000/reb83/highres/5/17045_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$329,000
316 sqft | 1 | 1
8639 MYRTLE POINT ROAD
Powell River, British Columbia

MLS#17045
Kaitlin Melvin: 604.578.0755 / 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] => 
)
View
$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] => 2023-02-03
    [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] => 
)
View
$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
2% Realty Sunshine Coast, Powell River
4726 Marine Avenue
Powell River, BC
V8A 2L4
Tel: 604.413.7222
Email: 2percentrealtysc@gmail.com
This site's content is the responsibility of 2% Realty Sunshine Coast, Powell River | 2018 Privacy Policy
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.
Copyright © 2023 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.