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] => 24897625
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2002308
    [LASTUPDATED] => 2022-09-22
    [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/TS637993980591030000/reb38/lowres/8/A2002308_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637993980591030000/reb38/medres/8/A2002308_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637993980591030000/reb38/highres/8/A2002308_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$429,000
1598 sqft | 5 | 3
406 Eaton Falls Cres
Grande Cache, Alberta
T0E0Y0
MLS#A2002308
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 25027382
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2009917
    [LASTUPDATED] => 2022-11-23
    [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/TS638048017042270000/reb38/lowres/7/A2009917_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638048017042270000/reb38/medres/7/A2009917_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638048017042270000/reb38/highres/7/A2009917_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$379,900
1388 sqft | 0 | 0
6, 712016 72A
Dimsdale, Alberta
T8W5H5
MLS#A2009917
Angela Dougall: 780.897.2994 / Email
Array
(
    [crea_id] => 24716846
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A1243299
    [LASTUPDATED] => 2022-11-23
    [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/TS638048047561700000/reb38/lowres/9/A1243299_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638048047561700000/reb38/medres/9/A1243299_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638048047561700000/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] => 25008565
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2008782
    [LASTUPDATED] => 2022-11-01
    [street_address] => 9222 111 Avenue
    [city] => Grande Prairie
    [province] => Alberta
    [postal] => T8V1G1
    [price] => 299900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 936 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638028918873330000/reb38/lowres/2/A2008782_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638028918873330000/reb38/medres/2/A2008782_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638028918873330000/reb38/highres/2/A2008782_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$299,900
936 sqft | 3 | 2
9222 111 Avenue
Grande Prairie, Alberta
T8V1G1
MLS#A2008782
Cherene Dallyn: 780.830.8866 / Email
Array
(
    [crea_id] => 23559478
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A1140508
    [LASTUPDATED] => 2022-09-29
    [street_address] => 10653 105 Ave
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 249999.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1580 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638000586593200000/reb38/lowres/8/A1140508_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638000586593200000/reb38/medres/8/A1140508_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638000586593200000/reb38/highres/8/A1140508_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$249,999
1580 sqft | 3 | 1.5
10653 105 Ave
Grande Cache, Alberta
T0E0Y0
MLS#A1140508
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 24915317
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2003446
    [LASTUPDATED] => 2022-09-27
    [street_address] => 10317 101 Ave
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 228000.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 1260 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637998953882370000/reb38/lowres/6/A2003446_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637998953882370000/reb38/medres/6/A2003446_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637998953882370000/reb38/highres/6/A2003446_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$228,000
1260 sqft | 4 | 2
10317 101 Ave
Grande Cache, Alberta
T0E0Y0
MLS#A2003446
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 23516856
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A1131958
    [LASTUPDATED] => 2022-09-27
    [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/TS637998876608030000/reb38/lowres/8/A1131958_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637998876608030000/reb38/medres/8/A1131958_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637998876608030000/reb38/highres/8/A1131958_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$199,900
1040 sqft | 3 | 1
9710 103A Street
Grande Cache, Alberta
T0E0Y0
MLS#A1131958
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 24108100
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A1187178
    [LASTUPDATED] => 2022-08-29
    [street_address] => 9825 101 St
    [city] => Grande Cache
    [province] => Alberta
    [postal] => T0E0Y0
    [price] => 182000.00
    [bedroom_total] => 4
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 1040 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637973946995700000/reb38/lowres/8/A1187178_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637973946995700000/reb38/medres/8/A1187178_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637973946995700000/reb38/highres/8/A1187178_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$182,000
1040 sqft | 4 | 1
9825 101 St
Grande Cache, Alberta
T0E0Y0
MLS#A1187178
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 24793189
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A1253306
    [LASTUPDATED] => 2022-11-19
    [street_address] => 11211 93 Street
    [city] => Grande Prairie
    [province] => Alberta
    [postal] => T8V1Y5
    [price] => 179000.00
    [bedroom_total] => 3
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 987 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638044500523730000/reb38/lowres/6/A1253306_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638044500523730000/reb38/medres/6/A1253306_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638044500523730000/reb38/highres/6/A1253306_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$179,000
987 sqft | 3 | 1
11211 93 Street
Grande Prairie, Alberta
T8V1Y5
MLS#A1253306
Angela Dougall: 780.897.2994 / Email
Array
(
    [crea_id] => 25062081
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A2011643
    [LASTUPDATED] => 2022-11-14
    [street_address] => 106B, 11018 106 Avenue
    [city] => Grande Prairie
    [province] => Alberta
    [postal] => T8V7T3
    [price] => 119500.00
    [bedroom_total] => 2
    [bathroom_total] => 1
    [half_bath_total] => 0
    [size_interior] => 895 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS638039652600000000/reb38/lowres/3/A2011643_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS638039652600000000/reb38/medres/3/A2011643_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS638039652600000000/reb38/highres/3/A2011643_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$119,500
895 sqft | 2 | 1
106B, 11018 106 Avenue
Grande Prairie, Alberta
T8V7T3
MLS#A2011643
Cherene Dallyn: 780.830.8866 / Email
Array
(
    [crea_id] => 24841452
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => A1256587
    [LASTUPDATED] => 2022-09-26
    [street_address] => 67 97 Ave
    [city] => Grande Cache
    [province] => Alberta
    [postal] => t0e0y0
    [price] => 79900.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 1
    [size_interior] => 1134 sqft
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637997442824470000/reb38/lowres/7/A1256587_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637997442824470000/reb38/medres/7/A1256587_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637997442824470000/reb38/highres/7/A1256587_1.jpg
    [THUMBB] => 
    [MEDB] => 
    [LARGEB] => 
)
$79,900
1134 sqft | 3 | 1.5
67 97 Ave
Grande Cache, Alberta
t0e0y0
MLS#A1256587
Christine Gallacher: 780.320.4785 / Email
Array
(
    [crea_id] => 22057117
    [office_name] => 2% Realty Grande
    [office_id] => 289049
    [mls_id] => GP215165
    [LASTUPDATED] => 2022-09-23
    [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/TS637995481015930000/reb38/lowres/5/GP215165_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637995481015930000/reb38/medres/5/GP215165_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637995481015930000/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