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

Our Listings

Search
X
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] => 
)
$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] => 
)
$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] => 
)
$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] => 
)
$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