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 (279278)) 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
Search
X
Sort By
Array
(
    [crea_id] => 24902010
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1258683
    [LASTUPDATED] => 2022-09-26
    [street_address] => 6108 24 Street
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V3J8
    [price] => 649900.00
    [bedroom_total] => 6
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2276.52 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637994832356830000/reb70/lowres/3/A1258683_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637994832356830000/reb70/medres/3/A1258683_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637994832356830000/reb70/highres/3/A1258683_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$649,900
2276.52 sqft | 6 | 3.5
6108 24 Street
Lloydminster, Alberta
T9V3J8
MLS#A1258683
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24473320
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1223539
    [LASTUPDATED] => 2022-09-26
    [street_address] => NE 1-48-2-W4
    [city] => Rural Vermilion River, County of
    [province] => Alberta
    [postal] => T9V3C1
    [price] => 624900.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 2525.28 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637964610775370000/reb70/lowres/9/A1223539_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637964610775370000/reb70/medres/9/A1223539_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637964610775370000/reb70/highres/9/A1223539_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$624,900
2525.28 sqft | 4 | 3.5
NE 1-48-2-W4
Rural Vermilion River, County of, Alberta
T9V3C1
MLS#A1223539
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24912327
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1259050
    [LASTUPDATED] => 2022-09-27
    [street_address] => 5301 50 Street
    [city] => Blackfoot
    [province] => Alberta
    [postal] => T0B0L0
    [price] => 474900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1493.88 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637998262694770000/reb70/lowres/0/A1259050_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637998262694770000/reb70/medres/0/A1259050_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637998262694770000/reb70/highres/0/A1259050_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$474,900
1493.88 sqft | 5 | 3
5301 50 Street
Blackfoot, Alberta
T0B0L0
MLS#A1259050
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24542641
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1229557
    [LASTUPDATED] => 2022-09-21
    [street_address] => 1406 52C Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V2Z1
    [price] => 434900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1225.62 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637993579851370000/reb70/lowres/7/A1229557_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637993579851370000/reb70/medres/7/A1229557_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637993579851370000/reb70/highres/7/A1229557_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$434,900
1225.62 sqft | 5 | 3
1406 52C Avenue
Lloydminster, Alberta
T9V2Z1
MLS#A1229557
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24671722
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1240102
    [LASTUPDATED] => 2022-09-08
    [street_address] => 3002 67 Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V3H8
    [price] => 424900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1709.87 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637964340923130000/reb70/lowres/2/A1240102_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637964340923130000/reb70/medres/2/A1240102_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637964340923130000/reb70/highres/2/A1240102_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$424,900
1709.87 sqft | 4 | 2.5
3002 67 Avenue
Lloydminster, Alberta
T9V3H8
MLS#A1240102
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24379782
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1215978
    [LASTUPDATED] => 2022-09-26
    [street_address] => 6116 17  StreetClose
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V3S1
    [price] => 419900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1431 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637937359161600000/reb70/lowres/8/A1215978_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637937359161600000/reb70/medres/8/A1215978_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637937359161600000/reb70/highres/8/A1215978_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$419,900
1431 sqft | 5 | 3
6116 17 StreetClose
Lloydminster, Alberta
T9V3S1
MLS#A1215978
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24791420
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1252929
    [LASTUPDATED] => 2022-09-26
    [street_address] => PT SE 5-51-27-W3
    [city] => Rural
    [province] => Saskatchewan
    [postal] => S9V0Z1
    [price] => 414900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1282.42 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637965455238570000/reb70/lowres/9/A1252929_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637965455238570000/reb70/medres/9/A1252929_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637965455238570000/reb70/highres/9/A1252929_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$414,900
1282.42 sqft | 4 | 2
PT SE 5-51-27-W3
Rural, Saskatchewan
S9V0Z1
MLS#A1252929
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24637405
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1237487
    [LASTUPDATED] => 2022-09-07
    [street_address] => 5407 16 Street
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V3L3
    [price] => 409900.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 1557.3 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637981633587630000/reb70/lowres/7/A1237487_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637981633587630000/reb70/medres/7/A1237487_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637981633587630000/reb70/highres/7/A1237487_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$409,900
1557.3 sqft | 4 | 3.5
5407 16 Street
Lloydminster, Alberta
T9V3L3
MLS#A1237487
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24729627
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1244893
    [LASTUPDATED] => 2022-09-08
    [street_address] => 4808 27 Street
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V1G7
    [price] => 379900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1015 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637950857272870000/reb70/lowres/3/A1244893_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637950857272870000/reb70/medres/3/A1244893_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637950857272870000/reb70/highres/3/A1244893_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$379,900
1015 sqft | 4 | 2
4808 27 Street
Lloydminster, Saskatchewan
S9V1G7
MLS#A1244893
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24816674
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A2000368
    [LASTUPDATED] => 2022-09-26
    [street_address] => 2003 47A AvenueClose
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V1N8
    [price] => 379900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1290.18 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637973869669600000/reb70/lowres/8/A2000368_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637973869669600000/reb70/medres/8/A2000368_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637973869669600000/reb70/highres/8/A2000368_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$379,900
1290.18 sqft | 5 | 3
2003 47A AvenueClose
Lloydminster, Saskatchewan
S9V1N8
MLS#A2000368
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24517222
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1227610
    [LASTUPDATED] => 2022-09-26
    [street_address] => 4617 19 Street
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V1A4
    [price] => 369900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1449.1 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637932409048100000/reb70/lowres/0/A1227610_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637932409048100000/reb70/medres/0/A1227610_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637932409048100000/reb70/highres/0/A1227610_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$369,900
1449.1 sqft | 5 | 3
4617 19 Street
Lloydminster, Saskatchewan
S9V1A4
MLS#A1227610
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24930442
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1259592
    [LASTUPDATED] => 2022-10-02
    [street_address] => 4603 38 StreetClose
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V2B9
    [price] => 359900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1071.15 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638003263212300000/reb70/lowres/2/A1259592_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638003263212300000/reb70/medres/2/A1259592_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638003263212300000/reb70/highres/2/A1259592_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$359,900
1071.15 sqft | 4 | 3
4603 38 StreetClose
Lloydminster, Saskatchewan
S9V2B9
MLS#A1259592
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24616353
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1235605
    [LASTUPDATED] => 2022-09-26
    [street_address] => 4303 34 Street Court
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0S6
    [price] => 354900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1096.52 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637993525522730000/reb70/lowres/5/A1235605_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637993525522730000/reb70/medres/5/A1235605_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637993525522730000/reb70/highres/5/A1235605_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$354,900
1096.52 sqft | 5 | 3
4303 34 Street Court
Lloydminster, Saskatchewan
S9V0S6
MLS#A1235605
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 23788136
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1158755
    [LASTUPDATED] => 2022-04-28
    [street_address] => 1320 47A  Avenue
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V2G6
    [price] => 345000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 991 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637867506779030000/reb70/lowres/5/A1158755_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637867506779030000/reb70/medres/5/A1158755_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637867506779030000/reb70/highres/5/A1158755_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$345,000
991 sqft | 4 | 2
1320 47A Avenue
Lloydminster, Saskatchewan
S9V2G6
MLS#A1158755
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24673440
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1240251
    [LASTUPDATED] => 2022-09-13
    [street_address] => 2936 67 Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V3H8
    [price] => 344900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1280.81 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637986631480070000/reb70/lowres/1/A1240251_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637986631480070000/reb70/medres/1/A1240251_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637986631480070000/reb70/highres/1/A1240251_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$344,900
1280.81 sqft | 4 | 3
2936 67 Avenue
Lloydminster, Alberta
T9V3H8
MLS#A1240251
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24729560
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1244094
    [LASTUPDATED] => 2022-09-26
    [street_address] => 3403 60 Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V2T8
    [price] => 342900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1294.03 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637998001264900000/reb70/lowres/4/A1244094_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637998001264900000/reb70/medres/4/A1244094_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637998001264900000/reb70/highres/4/A1244094_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$342,900
1294.03 sqft | 4 | 3
3403 60 Avenue
Lloydminster, Alberta
T9V2T8
MLS#A1244094
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24775213
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1251680
    [LASTUPDATED] => 2022-09-26
    [street_address] => 3808 56B Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V1Z4
    [price] => 339900.00
    [bedroom_total] => 4
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 1987.84 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637962426087170000/reb70/lowres/0/A1251680_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637962426087170000/reb70/medres/0/A1251680_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637962426087170000/reb70/highres/0/A1251680_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$339,900
1987.84 sqft | 4 | 3.5
3808 56B Avenue
Lloydminster, Alberta
T9V1Z4
MLS#A1251680
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24778143
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1252092
    [LASTUPDATED] => 2022-09-26
    [street_address] => 3205 66 Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V3H9
    [price] => 339900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1065.55 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637986631591700000/reb70/lowres/2/A1252092_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637986631591700000/reb70/medres/2/A1252092_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637986631591700000/reb70/highres/2/A1252092_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$339,900
1065.55 sqft | 4 | 2
3205 66 Avenue
Lloydminster, Alberta
T9V3H9
MLS#A1252092
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24884042
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1258356
    [LASTUPDATED] => 2022-09-18
    [street_address] => 4756  BARR CRESCENT
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0L2
    [price] => 339000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 897 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637991112884230000/reb70/lowres/6/A1258356_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637991112884230000/reb70/medres/6/A1258356_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637991112884230000/reb70/highres/6/A1258356_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$339,000
897 sqft | 4 | 2
4756 BARR CRESCENT
Lloydminster, Saskatchewan
S9V0L2
MLS#A1258356
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24884291
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A2002164
    [LASTUPDATED] => 2022-09-26
    [street_address] => 3305 46 Avenue
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V1T9
    [price] => 334900.00
    [bedroom_total] => 4
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1312.34 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637992120858230000/reb70/lowres/4/A2002164_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637992120858230000/reb70/medres/4/A2002164_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637992120858230000/reb70/highres/4/A2002164_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$334,900
1312.34 sqft | 4 | 3
3305 46 Avenue
Lloydminster, Saskatchewan
S9V1T9
MLS#A2002164
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24291963
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1208136
    [LASTUPDATED] => 2022-08-27
    [street_address] => 2908 54  Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V1N5
    [price] => 334000.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1148 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637971517168670000/reb70/lowres/6/A1208136_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637971517168670000/reb70/medres/6/A1208136_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637971517168670000/reb70/highres/6/A1208136_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$334,000
1148 sqft | 5 | 2.5
2908 54 Avenue
Lloydminster, Alberta
T9V1N5
MLS#A1208136
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24887628
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1258453
    [LASTUPDATED] => 2022-09-26
    [street_address] => 2607 47A Avenue
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V2J3
    [price] => 329900.00
    [bedroom_total] => 3
    [bathroom_total] => 4
    [half_bath_total] => 1
    [size_interior] => 1887.29 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637992053324070000/reb70/lowres/3/A1258453_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637992053324070000/reb70/medres/3/A1258453_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637992053324070000/reb70/highres/3/A1258453_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$329,900
1887.29 sqft | 3 | 3.5
2607 47A Avenue
Lloydminster, Saskatchewan
S9V2J3
MLS#A1258453
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 23613675
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1145072
    [LASTUPDATED] => 2022-08-23
    [street_address] => NE 31-49-26-W3
    [city] => Rural
    [province] => Saskatchewan
    [postal] => S0M1R0
    [price] => 319900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1560 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637968019045670000/reb70/lowres/2/A1145072_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637968019045670000/reb70/medres/2/A1145072_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637968019045670000/reb70/highres/2/A1145072_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$319,900
1560 sqft | 4 | 2
NE 31-49-26-W3
Rural, Saskatchewan
S0M1R0
MLS#A1145072
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24538628
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1229272
    [LASTUPDATED] => 2022-09-26
    [street_address] => 5124 48 Avenue
    [city] => Kitscoty
    [province] => Alberta
    [postal] => T0B2P0
    [price] => 299900.00
    [bedroom_total] => 6
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1159.57 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637908037240800000/reb70/lowres/2/A1229272_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637908037240800000/reb70/medres/2/A1229272_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637908037240800000/reb70/highres/2/A1229272_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$299,900
1159.57 sqft | 6 | 3
5124 48 Avenue
Kitscoty, Alberta
T0B2P0
MLS#A1229272
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24620879
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1236271
    [LASTUPDATED] => 2022-07-04
    [street_address] => 4608 23 Street
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0Z5
    [price] => 279900.00
    [bedroom_total] => 5
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1051 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637925526940600000/reb70/lowres/1/A1236271_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637925526940600000/reb70/medres/1/A1236271_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637925526940600000/reb70/highres/1/A1236271_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$279,900
1051 sqft | 5 | 2
4608 23 Street
Lloydminster, Saskatchewan
S9V0Z5
MLS#A1236271
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24832984
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1255931
    [LASTUPDATED] => 2022-09-26
    [street_address] => 4008 58 AvenueClose
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V2P5
    [price] => 279900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 973.91 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637977455422400000/reb70/lowres/1/A1255931_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637977455422400000/reb70/medres/1/A1255931_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637977455422400000/reb70/highres/1/A1255931_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$279,900
973.91 sqft | 4 | 2
4008 58 AvenueClose
Lloydminster, Alberta
T9V2P5
MLS#A1255931
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24696054
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1242086
    [LASTUPDATED] => 2022-07-26
    [street_address] => 4715 36 Street
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0A1
    [price] => 279000.00
    [bedroom_total] => 6
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 938 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637944475325300000/reb70/lowres/6/A1242086_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637944475325300000/reb70/medres/6/A1242086_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637944475325300000/reb70/highres/6/A1242086_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$279,000
938 sqft | 6 | 2
4715 36 Street
Lloydminster, Saskatchewan
S9V0A1
MLS#A1242086
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24646803
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1238327
    [LASTUPDATED] => 2022-09-21
    [street_address] => 3402 55  Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V1K7
    [price] => 269900.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1368 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637993657047270000/reb70/lowres/7/A1238327_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637993657047270000/reb70/medres/7/A1238327_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637993657047270000/reb70/highres/7/A1238327_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$269,900
1368 sqft | 5 | 2.5
3402 55 Avenue
Lloydminster, Alberta
T9V1K7
MLS#A1238327
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24783588
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1252608
    [LASTUPDATED] => 2022-09-22
    [street_address] => 4103 49 Avenue
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0S3
    [price] => 259900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1035 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637994443121600000/reb70/lowres/8/A1252608_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637994443121600000/reb70/medres/8/A1252608_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637994443121600000/reb70/highres/8/A1252608_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$259,900
1035 sqft | 4 | 2
4103 49 Avenue
Lloydminster, Saskatchewan
S9V0S3
MLS#A1252608
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24699319
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1241678
    [LASTUPDATED] => 2022-09-26
    [street_address] => 4711 40 Street
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0C1
    [price] => 249900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 949.12 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637994611078830000/reb70/lowres/8/A1241678_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637994611078830000/reb70/medres/8/A1241678_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637994611078830000/reb70/highres/8/A1241678_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$249,900
949.12 sqft | 4 | 2
4711 40 Street
Lloydminster, Saskatchewan
S9V0C1
MLS#A1241678
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24340600
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1212310
    [LASTUPDATED] => 2022-09-26
    [street_address] => 2909  56 Avenue
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V2B2
    [price] => 243500.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 880 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637997935213700000/reb70/lowres/0/A1212310_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637997935213700000/reb70/medres/0/A1212310_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637997935213700000/reb70/highres/0/A1212310_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$243,500
880 sqft | 4 | 2
2909 56 Avenue
Lloydminster, Alberta
T9V2B2
MLS#A1212310
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24467237
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1223225
    [LASTUPDATED] => 2022-09-26
    [street_address] => 5726 47 Street
    [city] => Lloydminster
    [province] => Alberta
    [postal] => T9V1B5
    [price] => 239900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1037.75 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637987818582870000/reb70/lowres/5/A1223225_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637987818582870000/reb70/medres/5/A1223225_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637987818582870000/reb70/highres/5/A1223225_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$239,900
1037.75 sqft | 4 | 2
5726 47 Street
Lloydminster, Alberta
T9V1B5
MLS#A1223225
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24923661
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1259398
    [LASTUPDATED] => 2022-09-29
    [street_address] => 4516 47 Street
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0J9
    [price] => 219900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 863.95 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638000665002130000/reb70/lowres/8/A1259398_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638000665002130000/reb70/medres/8/A1259398_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638000665002130000/reb70/highres/8/A1259398_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$219,900
863.95 sqft | 4 | 2
4516 47 Street
Lloydminster, Saskatchewan
S9V0J9
MLS#A1259398
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24858355
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1257427
    [LASTUPDATED] => 2022-09-11
    [street_address] => 4727 43 Street
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0E6
    [price] => 199000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 932 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637984853717930000/reb70/lowres/7/A1257427_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637984853717930000/reb70/medres/7/A1257427_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637984853717930000/reb70/highres/7/A1257427_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$199,000
932 sqft | 4 | 2
4727 43 Street
Lloydminster, Saskatchewan
S9V0E6
MLS#A1257427
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 24268459
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1205977
    [LASTUPDATED] => 2022-08-23
    [street_address] => 5215 52 Avenue
    [city] => Blackfoot
    [province] => Alberta
    [postal] => T0B0L0
    [price] => 194900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1211.82 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637968019176400000/reb70/lowres/7/A1205977_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637968019176400000/reb70/medres/7/A1205977_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637968019176400000/reb70/highres/7/A1205977_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$194,900
1211.82 sqft | 3 | 2
5215 52 Avenue
Blackfoot, Alberta
T0B0L0
MLS#A1205977
Catrina MacDonald: 306.830.7030 / Email
Tara Reiter: 780.522.7697 / Email
Array
(
    [crea_id] => 24688187
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1241443
    [LASTUPDATED] => 2022-09-08
    [street_address] => 24, 1811 49 Avenue
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0Z3
    [price] => 167000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1015.42 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637939510478570000/reb70/lowres/3/A1241443_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637939510478570000/reb70/medres/3/A1241443_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637939510478570000/reb70/highres/3/A1241443_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$167,000
1015.42 sqft | 3 | 1.5
24, 1811 49 Avenue
Lloydminster, Saskatchewan
S9V0Z3
MLS#A1241443
Catrina MacDonald: 306.830.7030 / Email
Array
(
    [crea_id] => 24640288
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => A1237801
    [LASTUPDATED] => 2022-09-08
    [street_address] => 5408 49  Avenue
    [city] => Lloydminster
    [province] => Saskatchewan
    [postal] => S9V0V3
    [price] => 159000.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 919 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637982371402700000/reb70/lowres/1/A1237801_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637982371402700000/reb70/medres/1/A1237801_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637982371402700000/reb70/highres/1/A1237801_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$159,000
919 sqft | 2 | 1
5408 49 Avenue
Lloydminster, Saskatchewan
S9V0V3
MLS#A1237801
Enya Denys: 306.830.4907 / Email
Array
(
    [crea_id] => 21967215
    [office_name] => 2 PERCENT REALTY ELITE
    [office_id] => 279278
    [mls_id] => 66833
    [LASTUPDATED] => 2020-06-13
    [street_address] => 207 1ST STREET WEST
    [city] => Lashburn
    [province] => Saskatchewan
    [postal] => S0M1H0
    [price] => 45000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 
    [thumbURL] => 
    [medURL] => 
    [largeURL] => 
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$45,000
| 0 | 0
207 1ST STREET WEST
Lashburn, Saskatchewan
S0M1H0
MLS#66833
Sort By