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
X

MLS® System Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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
)
View
$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
)
View
$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
)
View
$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
)
View
$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
)
View
$119,900
743 sqft | 1 | 1
206 2921 Harding STREET
Regina, Saskatchewan
S4V1B9
MLS#SK916582
Keith Britton: 306.535.7167 / Email
Sort By
Keith Britton
This site's content is the responsibility of Keith Britton | 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.