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
X

Office Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$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] => 
)
View
$45,000
Array | 0 | 0
9304 Stern Crescent
Grande Cache, Alberta
T0E0Y0
MLS#GP215165
Christine Gallacher: 780.320.4785 / Email
Sort By
2% Realty Grande
Box 1450
10546 98 Ave
Grande Cache
T0E 0Y0
Tel: 780.533.5250
Email: gpadmin@2percentrealty.ca
This site's content is the responsibility of 2% Realty Grande | 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 © 2022 2% Realty Inc. All Rights Reserved
Site Designed and Built by Tobias Crichton Studios.