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 (289049)) 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

Office Listings

Search
X
Sort By
Array
(
    [crea_id] => 25154820
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2016732
    [LASTUPDATED] => 2022-12-31
    [street_address] => 406 Eaton Falls Cres
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 429000.00
    [bedroom_total] => 5
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1598 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638080883871100000/reb38/lowres/2/A2016732_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638080883871100000/reb38/medres/2/A2016732_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638080883871100000/reb38/highres/2/A2016732_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$429,000
1598 sqft | 5 | 3
406 Eaton Falls Cres
Grande Cache, Alberta
T0E0Y0
MLS#A2016732
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 25320884
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2028155
    [LASTUPDATED] => 2023-03-01
    [street_address] => #6, 712016 72A
    [city] => Dimsdale
    [province] => Alberta
    [postal] => T8W5H5
    [price] => 379900.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 1388 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638132861981930000/reb38/lowres/5/A2028155_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638132861981930000/reb38/medres/5/A2028155_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638132861981930000/reb38/highres/5/A2028155_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$379,900
1388 sqft | 0 | 0
#6, 712016 72A
Dimsdale, Alberta
T8W5H5
MLS#A2028155
Angela Dougall: 780.897.2994 / Email
Array
(
    [crea_id] => 24716846
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A1243299
    [LASTUPDATED] => 2023-01-28
    [street_address] => 11405 69 Ave
    [city] => Grande Prairie
    [province] => Alberta
    [postal] => T8W0E5
    [price] => 359900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 0
    [size_interior] => 1159 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638104488350200000/reb38/lowres/9/A1243299_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638104488350200000/reb38/medres/9/A1243299_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638104488350200000/reb38/highres/9/A1243299_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$359,900
1159 sqft | 3 | 3
11405 69 Ave
Grande Prairie, Alberta
T8W0E5
MLS#A1243299
Angela Dougall: 780.897.2994 / Email
Array
(
    [crea_id] => 25355232
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2031440
    [LASTUPDATED] => 2023-03-11
    [street_address] => 7103 93 Street
    [city] => Grande Prairie
    [province] => Alberta
    [postal] => T8V6H4
    [price] => 249900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 918 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638141538867430000/reb38/lowres/0/A2031440_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638141538867430000/reb38/medres/0/A2031440_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638141538867430000/reb38/highres/0/A2031440_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$249,900
918 sqft | 4 | 2
7103 93 Street
Grande Prairie, Alberta
T8V6H4
MLS#A2031440
Diane Cundal: 780.876.0102 / Email
Array
(
    [crea_id] => 25204032
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2020175
    [LASTUPDATED] => 2023-02-28
    [street_address] => 9003 87 Avenue
    [city] => Grande Prairie
    [province] => Alberta
    [postal] => T8X1V6
    [price] => 235000.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1216 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638131872983900000/reb38/lowres/5/A2020175_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638131872983900000/reb38/medres/5/A2020175_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638131872983900000/reb38/highres/5/A2020175_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$235,000
1216 sqft | 3 | 2
9003 87 Avenue
Grande Prairie, Alberta
T8X1V6
MLS#A2020175
Cherene Dallyn: 780.830.8866 / Email
Array
(
    [crea_id] => 25276853
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2023422
    [LASTUPDATED] => 2023-03-16
    [street_address] => 10306 Shand Ave
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 215000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1220 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638145750839500000/reb38/lowres/2/A2023422_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638145750839500000/reb38/medres/2/A2023422_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638145750839500000/reb38/highres/2/A2023422_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$215,000
1220 sqft | 4 | 1.5
10306 Shand Ave
Grande Cache, Alberta
T0E0Y0
MLS#A2023422
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 25154822
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2016460
    [LASTUPDATED] => 2022-12-31
    [street_address] => 9710 103A Street
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 199900.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1040 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638080888488430000/reb38/lowres/0/A2016460_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638080888488430000/reb38/medres/0/A2016460_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638080888488430000/reb38/highres/0/A2016460_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$199,900
1040 sqft | 3 | 1
9710 103A Street
Grande Cache, Alberta
T0E0Y0
MLS#A2016460
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 25241887
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2022870
    [LASTUPDATED] => 2023-03-10
    [street_address] => 220, 10150 121 Avenue
    [city] => Grande Prairie
    [province] => Alberta
    [postal] => T8V8H2
    [price] => 169000.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 1
    [size_interior] => 1069 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638140566589030000/reb38/lowres/0/A2022870_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638140566589030000/reb38/medres/0/A2022870_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638140566589030000/reb38/highres/0/A2022870_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$169,000
1069 sqft | 3 | 2.5
220, 10150 121 Avenue
Grande Prairie, Alberta
T8V8H2
MLS#A2022870
Cherene Dallyn: 780.830.8866 / Email
Array
(
    [crea_id] => 25208803
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2020537
    [LASTUPDATED] => 2023-02-08
    [street_address] => 216, 160 Moberly Road
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 146000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1050 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638099145149800000/reb38/lowres/7/A2020537_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638099145149800000/reb38/medres/7/A2020537_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638099145149800000/reb38/highres/7/A2020537_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$146,000
1050 sqft | 2 | 2
216, 160 Moberly Road
Grande Cache, Alberta
T0E0Y0
MLS#A2020537
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 25311732
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2027491
    [LASTUPDATED] => 2023-02-28
    [street_address] => 107, 160 Moberly Rd
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 135000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1050 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638131314399070000/reb38/lowres/1/A2027491_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638131314399070000/reb38/medres/1/A2027491_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638131314399070000/reb38/highres/1/A2027491_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$135,000
1050 sqft | 2 | 2
107, 160 Moberly Rd
Grande Cache, Alberta
T0E0Y0
MLS#A2027491
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 25120890
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2011302
    [LASTUPDATED] => 2023-02-23
    [street_address] => 307, 160 Moberly Road
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 110000.00
    [bedroom_total] => 2
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 924 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638127678771330000/reb38/lowres/2/A2011302_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638127678771330000/reb38/medres/2/A2011302_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638127678771330000/reb38/highres/2/A2011302_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$110,000
924 sqft | 2 | 2
307, 160 Moberly Road
Grande Cache, Alberta
T0E0Y0
MLS#A2011302
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 25319767
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2028692
    [LASTUPDATED] => 2023-03-01
    [street_address] => 9517 Hamel Street
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 45000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => 
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638132753877700000/reb38/lowres/2/A2028692_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638132753877700000/reb38/medres/2/A2028692_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638132753877700000/reb38/highres/2/A2028692_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$45,000
| 0 | 0
9517 Hamel Street
Grande Cache, Alberta
T0E0Y0
MLS#A2028692
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 22057117
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => GP215165
    [LASTUPDATED] => 2023-02-08
    [street_address] => 9304 Stern Crescent
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 45000.00
    [bedroom_total] => 0
    [bathroom_total] => 0
    [half_bath_total] => 0
    [size_interior] => Array
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638080884140670000/reb38/lowres/5/GP215165_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638080884140670000/reb38/medres/5/GP215165_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638080884140670000/reb38/highres/5/GP215165_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$45,000
Array | 0 | 0
9304 Stern Crescent
Grande Cache, Alberta
T0E0Y0
MLS#GP215165
Christine Gallacher: 780.320.4785 / Email
Sort By