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_0_agents a INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) WHERE a.crea_id IN (25021663,25157394,25131176,24958193,25177205) ORDER BY b.price DESC, b.mls_id ASC

MLS® System Listings

Search
X
Sort By
Array
(
    [crea_id] => 25021663
    [office_name] => 2 Percent Realty Refined Inc.
    [office_id] => 293213
    [mls_id] => SK912091
    [LASTUPDATED] => 2023-01-04
    [street_address] => 3028 Montague STREET
    [city] => Regina
    [province] => Saskatchewan
    [postal] => S4S1Z5
    [price] => 534900.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 1854 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638028226552070000/reb27/lowres/1/SK912091_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638028226552070000/reb27/medres/1/SK912091_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638028226552070000/reb27/highres/1/SK912091_1.jpg
)
$534,900
1854 sqft | 4 | 4
3028 Montague STREET
Regina, Saskatchewan
S4S1Z5
MLS#SK912091
Keith Britton: 306.535.7167 / Email
Array
(
    [crea_id] => 25157394
    [office_name] => 2 Percent Realty Refined Inc.
    [office_id] => 293213
    [mls_id] => SK916081
    [LASTUPDATED] => 2023-01-16
    [street_address] => 5600 Prefontaine AVENUE
    [city] => Regina
    [province] => Saskatchewan
    [postal] => S4W0M8
    [price] => 339900.00
    [bedroom_total] => 3
    [bathroom_total] => 4
    [half_bath_total] => 0
    [size_interior] => 1220 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638083459525370000/reb27/lowres/1/SK916081_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638083459525370000/reb27/medres/1/SK916081_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638083459525370000/reb27/highres/1/SK916081_1.jpg
)
$339,900
1220 sqft | 3 | 4
5600 Prefontaine AVENUE
Regina, Saskatchewan
S4W0M8
MLS#SK916081
Keith Britton: 306.535.7167 / Email
Array
(
    [crea_id] => 25131176
    [office_name] => 2 Percent Realty Refined Inc.
    [office_id] => 293213
    [mls_id] => SK915458
    [LASTUPDATED] => 2023-01-06
    [street_address] => 1038 Mawson BAY N
    [city] => Regina
    [province] => Saskatchewan
    [postal] => S4X2P6
    [price] => 297500.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1513 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638064443885730000/reb27/lowres/8/SK915458_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638064443885730000/reb27/medres/8/SK915458_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638064443885730000/reb27/highres/8/SK915458_1.jpg
)
$297,500
1513 sqft | 3 | 1
1038 Mawson BAY N
Regina, Saskatchewan
S4X2P6
MLS#SK915458
Keith Britton: 306.535.7167 / Email
Matthew Sawyer: 306.539.4993 / Email
Array
(
    [crea_id] => 24958193
    [office_name] => 2 Percent Realty Refined Inc.
    [office_id] => 293213
    [mls_id] => SK910629
    [LASTUPDATED] => 2023-01-15
    [street_address] => 442 Connaught STREET
    [city] => Regina
    [province] => Saskatchewan
    [postal] => S4R4W9
    [price] => 259900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 840 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638093940768330000/reb27/lowres/9/SK910629_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638093940768330000/reb27/medres/9/SK910629_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638093940768330000/reb27/highres/9/SK910629_1.jpg
)
$259,900
840 sqft | 3 | 2
442 Connaught STREET
Regina, Saskatchewan
S4R4W9
MLS#SK910629
Keith Britton: 306.535.7167 / Email
Array
(
    [crea_id] => 25177205
    [office_name] => 2 Percent Realty Refined Inc.
    [office_id] => 293213
    [mls_id] => SK916582
    [LASTUPDATED] => 2023-01-10
    [street_address] => 206 2921 Harding STREET
    [city] => Regina
    [province] => Saskatchewan
    [postal] => S4V1B9
    [price] => 119900.00
    [bedroom_total] => 1
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 743 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638089723587700000/reb27/lowres/2/SK916582_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638089723587700000/reb27/medres/2/SK916582_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638089723587700000/reb27/highres/2/SK916582_1.jpg
)
$119,900
743 sqft | 1 | 1
206 2921 Harding STREET
Regina, Saskatchewan
S4V1B9
MLS#SK916582
Keith Britton: 306.535.7167 / Email
Sort By