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 (24686250,24645866,24824802,24742159) ORDER BY b.price DESC, b.mls_id ASC
X

View My Listings

Search
X
Price Range
to
Beds:
Baths:
Property Type:
Building Type:
Size:
Reset Search
Sort By 
Array
(
    [crea_id] => 24686250
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4305603
    [LASTUPDATED] => 2022-07-20
    [street_address] => 12448 81 ST NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T5B2T7
    [price] => 474900.00
    [bedroom_total] => 6
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 129.69 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637939246291900000/reb10/lowres/3/E4305603_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637939246291900000/reb10/medres/3/E4305603_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637939246291900000/reb10/highres/3/E4305603_1.jpg
)
View
$474,900
129.69 m2 | 6 | 2
12448 81 ST NW
Edmonton, Alberta
T5B2T7
MLS#E4305603
Tracy Krawchuk: 780.907.7097 / Email 
Array
(
    [crea_id] => 24645866
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4303995
    [LASTUPDATED] => 2022-09-15
    [street_address] => 11429 39 AV NW NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6J0M5
    [price] => 299900.00
    [bedroom_total] => 4
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 84.4 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637977493252530000/reb10/lowres/5/E4303995_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637977493252530000/reb10/medres/5/E4303995_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637977493252530000/reb10/highres/5/E4303995_1.jpg
)
View
$299,900
84.4 m2 | 4 | 2
11429 39 AV NW NW
Edmonton, Alberta
T6J0M5
MLS#E4303995
Tracy Krawchuk: 780.907.7097 / Email 
Array
(
    [crea_id] => 24824802
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4311427
    [LASTUPDATED] => 2022-09-08
    [street_address] => 235 GRANDIN VG
    [city] => St. Albert
    [province] => Alberta
    [postal] => T8N2J3
    [price] => 214900.00
    [bedroom_total] => 3
    [bathroom_total] => 3
    [half_bath_total] => 2
    [size_interior] => 107.86 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637982509775100000/reb10/lowres/7/E4311427_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637982509775100000/reb10/medres/7/E4311427_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637982509775100000/reb10/highres/7/E4311427_1.jpg
)
View
$214,900
107.86 m2 | 3 | 2
235 GRANDIN VG
St. Albert, Alberta
T8N2J3
MLS#E4311427
Tracy Krawchuk: 780.907.7097 / Email 
Array
(
    [crea_id] => 24742159
    [office_name] => 2% Realty Pro
    [office_id] => 272504
    [mls_id] => E4307981
    [LASTUPDATED] => 2022-08-29
    [street_address] => 537 Maple Wood CR NW
    [city] => Edmonton
    [province] => Alberta
    [postal] => T6P0B1
    [price] => 144500.00
    [bedroom_total] => 3
    [bathroom_total] => 2
    [half_bath_total] => 0
    [size_interior] => 141.42 m2
    [sequence_id] => 1
    [thumbURL] => https://ddfcdn.realtor.ca/listings/TS637953070652000000/reb10/lowres/1/E4307981_1.jpg
    [medURL] => https://ddfcdn.realtor.ca/listings/TS637953070652000000/reb10/medres/1/E4307981_1.jpg
    [largeURL] => https://ddfcdn.realtor.ca/listings/TS637953070652000000/reb10/highres/1/E4307981_1.jpg
)
View
$144,500
141.42 m2 | 3 | 2
537 Maple Wood CR NW
Edmonton, Alberta
T6P0B1
MLS#E4307981
Tracy Krawchuk: 780.907.7097 / Email
Sort By
Tracy Krawchuk
This site's content is the responsibility of Tracy Krawchuk | 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.