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 (286546)) 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

Our Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 25056894
    [office_name] => 2 Percent Realty
    [office_id] => 286546
    [mls_id] => 196956
    [LASTUPDATED] => 2023-01-09
    [street_address] => 5129 9TH Avenue,
    [city] => Okanagan Falls
    [province] => British Columbia
    [postal] => V0H1R0
    [price] => 699900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638070192427700000/reb19/lowres/6/196956_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638070192427700000/reb19/medres/6/196956_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638070192427700000/reb19/highres/6/196956_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$699,900
| 0 | 0
5129 9TH Avenue,
Okanagan Falls, British Columbia
V0H1R0
MLS#196956
Brad Schedel: 250..488.2102 / Email
Brad Schedel: 250.488.2102 / Email 
Array
(
    [crea_id] => 25126120
    [office_name] => 2 Percent Realty
    [office_id] => 286546
    [mls_id] => 197223
    [LASTUPDATED] => 2023-02-05
    [street_address] => #305 2255 ATKINSON Street,
    [city] => Penticton
    [province] => British Columbia
    [postal] => V2A8R7
    [price] => 660000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1389 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638088259357230000/reb19/lowres/3/197223_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638088259357230000/reb19/medres/3/197223_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638088259357230000/reb19/highres/3/197223_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$660,000
1389 sqft | 2 | 2
#305 2255 ATKINSON Street,
Penticton, British Columbia
V2A8R7
MLS#197223
Brad Schedel: 250..488.2102 / Email
Brad Schedel: 250.488.2102 / Email
Quinton Darnell: 250.488.9521 / Email 
Array
(
    [crea_id] => 25113852
    [office_name] => 2 Percent Realty
    [office_id] => 286546
    [mls_id] => 197187
    [LASTUPDATED] => 2023-02-05
    [street_address] => #17 1302 CEDAR Street,
    [city] => Okanagan Falls
    [province] => British Columbia
    [postal] => V0h1r4
    [price] => 134000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1016 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638110554418130000/reb19/lowres/7/197187_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638110554418130000/reb19/medres/7/197187_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638110554418130000/reb19/highres/7/197187_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$134,000
1016 sqft | 2 | 1
#17 1302 CEDAR Street,
Okanagan Falls, British Columbia
V0h1r4
MLS#197187
Brad Schedel: 250..488.2102 / Email
Brad Schedel: 250.488.2102 / Email
Quinton Darnell: 250.488.9521 / Email 
Array
(
    [crea_id] => 25247000
    [office_name] => 2 Percent Realty
    [office_id] => 286546
    [mls_id] => 197697
    [LASTUPDATED] => 2023-02-05
    [street_address] => 2633 2ND Street,
    [city] => Keremeos/Olalla
    [province] => British Columbia
    [postal] => V0x1n6
    [price] => 109000.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 872 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638110531138330000/reb19/lowres/7/197697_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638110531138330000/reb19/medres/7/197697_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638110531138330000/reb19/highres/7/197697_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
View
$109,000
872 sqft | 1 | 1
2633 2ND Street,
Keremeos/Olalla, British Columbia
V0x1n6
MLS#197697
Brad Schedel: 250..488.2102 / Email
Brad Schedel: 250.488.2102 / Email
Quinton Darnell: 250.488.9521 / Email
Sort By
2% Realty Group, Penticton
Tel: 250.488.9521
Email: quintondarnell@hotmail.com
This site's content is the responsibility of 2% Realty Group, Penticton | 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.