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 FROM tbl_CREA_0N_agents a INNER JOIN tbl_CREA_0N b ON (a.crea_id = b.crea_id) LEFT JOIN tbl_CREA_0N_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 0) WHERE a.crea_id IN (24563162,24879125,24870900,24712991,24114160,24880481) ORDER BY b.price DESC, b.mls_id ASC
Agents of Change
(204) 724 2540

MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 24563162
    [office_name] => 3 Percent Realty Solution
    [office_id] => 274710
    [mls_id] => 202213765
    [LASTUPDATED] => 2022-09-19
    [street_address] => 747 4th Avenue
    [city] => Rivers
    [province] => Manitoba
    [postal] => R0K1X0
    [price] => 199500.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 840 sqft
    [sequence_id] => 0
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637912804050200000/reb23/lowres/5/202213765_0.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637912804050200000/reb23/medres/5/202213765_0.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637912804050200000/reb23/highres/5/202213765_0.jpg
)
$199,500
840 sqft | 3 | 1
747 4th Avenue
Rivers, Manitoba
R0K1X0
MLS#202213765
Melinda McDonald: (204) 724 2540 / Email
Array
(
    [crea_id] => 24879125
    [office_name] => 3 Percent Realty Solution
    [office_id] => 274710
    [mls_id] => 202222800
    [LASTUPDATED] => 2022-09-17
    [street_address] => 609 Brentwood Village
    [city] => Brandon
    [province] => Manitoba
    [postal] => R7B1N5
    [price] => 149900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1100 sqft
    [sequence_id] => 0
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637989339431370000/reb23/lowres/0/202222800_0.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637989339431370000/reb23/medres/0/202222800_0.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637989339431370000/reb23/highres/0/202222800_0.jpg
)
$149,900
1100 sqft | 3 | 1
609 Brentwood Village
Brandon, Manitoba
R7B1N5
MLS#202222800
Melinda McDonald: (204) 724 2540 / Email
Array
(
    [crea_id] => 24870900
    [office_name] => 3 Percent Realty Solution
    [office_id] => 274710
    [mls_id] => 202222637
    [LASTUPDATED] => 2022-09-24
    [street_address] => 209 Oak Drive
    [city] => Oak Lake Beach
    [province] => Manitoba
    [postal] => R0M1P0
    [price] => 126000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 800 sqft
    [sequence_id] => 0
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637987683055000000/reb23/lowres/7/202222637_0.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637987683055000000/reb23/medres/7/202222637_0.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637987683055000000/reb23/highres/7/202222637_0.jpg
)
$126,000
800 sqft | 2 | 1
209 Oak Drive
Oak Lake Beach, Manitoba
R0M1P0
MLS#202222637
Melinda McDonald: (204) 724 2540 / Email
Tetyana Morley: (204) 720-0807 / Email
Array
(
    [crea_id] => 24712991
    [office_name] => 3 Percent Realty Solution
    [office_id] => 274710
    [mls_id] => 202218381
    [LASTUPDATED] => 2022-08-02
    [street_address] => 86 Highland Court
    [city] => Brandon
    [province] => Manitoba
    [postal] => R7A5Y5
    [price] => 119900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1152 sqft
    [sequence_id] => 0
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637945929297170000/reb23/lowres/1/202218381_0.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637945929297170000/reb23/medres/1/202218381_0.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637945929297170000/reb23/highres/1/202218381_0.jpg
)
$119,900
1152 sqft | 3 | 2
86 Highland Court
Brandon, Manitoba
R7A5Y5
MLS#202218381
Melinda McDonald: (204) 724 2540 / Email
Array
(
    [crea_id] => 24114160
    [office_name] => 3 Percent Realty Solution
    [office_id] => 274710
    [mls_id] => 202204735
    [LASTUPDATED] => 2022-09-06
    [street_address] => 503 White Swan Trailer Court
    [city] => Brandon
    [province] => Manitoba
    [postal] => R7A5Y5
    [price] => 89900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1100 sqft
    [sequence_id] => 0
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637980633117600000/reb23/lowres/5/202204735_0.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637980633117600000/reb23/medres/5/202204735_0.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637980633117600000/reb23/highres/5/202204735_0.jpg
)
$89,900
1100 sqft | 3 | 1
503 White Swan Trailer Court
Brandon, Manitoba
R7A5Y5
MLS#202204735
Melinda McDonald: (204) 724 2540 / Email
Tetyana Morley: (204) 720-0807 / Email
Array
(
    [crea_id] => 24880481
    [office_name] => 3 Percent Realty Solution
    [office_id] => 274710
    [mls_id] => 202222593
    [LASTUPDATED] => 2022-09-29
    [street_address] => 542 2nd Avenue
    [city] => Rivers
    [province] => Manitoba
    [postal] => R0K1X0
    [price] => 79900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 0
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637989375099170000/reb23/lowres/3/202222593_0.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637989375099170000/reb23/medres/3/202222593_0.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637989375099170000/reb23/highres/3/202222593_0.jpg
)
$79,900
| 0 | 0
542 2nd Avenue
Rivers, Manitoba
R0K1X0
MLS#202222593
Melinda McDonald: (204) 724 2540 / Email
Sort By