The For Sale By Owner Canada Network For Sale By Owner Canada

For Sale By Owner Canada is a FSBO classified ads website. Dedicated to people who want to advertise their Real Estate properties for sale and save thousands of dollars in commissions upon selling!

List your Home, Business, Land or other Real Estate properties and be assured that you have a leader, in FSBO Internet Advertising, working to make your private sale a very rewarding experience!

REGION:00002Cats
Build HierarchyQUERY
SELECT l.*, t2.* FROM cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id JOIN ( SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id) t2 ON t2.hierarchy_id = h.hierarchy_id WHERE status = ? AND l.listing_date < now() group by l.id order by t2.max desc, t2.name asc, l.listing_date desc
SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max, h.extra1 as link, count(tmp.id) as count FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id order by max desc, h.name asc
(published, %Alberta%, published)[0][48]
query1->0.003842
Heirarchy0.003264 -->0.418208
Regions of
Alberta
Max Ads per page:

Edmonton And Area

NotSold0.00070499999999996 -->0.418913
AD #2142
Bungalow
28
AD # 2142
This brand new home has never been lived in for only $214,000.00.  This price is a great opportunity for  first time buyer, or downsizing retirees.  It contains many upgrades including stainless steel fridge, stove, dishwasher, microwave, cherry wood cabinetry, white crown moulding throughout, 5 inch white baseboards, 2 pce. bathroom/mudroom at... read more
NotSold0.01394 -->0.432853
AD #2141
4 - 28 ft x109 ft lots
opal alberta
50000.00 O.B.O.
AD # 2141
Price Reduced!
these lots can be sold individually or  as a whole,opal has a sewer system at property line,but no water system.these lots are zoned for mobile homes ,or houses. aprox  20 minutes from Redwater ab,and 45 minutes from Edmonton Phone for more info.

... read more
NotSold0.00079299999999993 -->0.433646
AD #2136
detatched
1727 Haswell Cove, Edmonton, AB , T6R3A9
529,000
AD # 2136
This 2288 square foot family home is located in Haddow, SW Edmonton, in a cul de sac setting within minutes of the parks, Anthony Henday and whitemud freeway. This beautifully kept 2 Storey features: 3 bedrooms, 2.5 baths, full master en suite, large bonus room above garage, maple island kitchen with pantry, bright nook, large great room with a... read more
NotSold0.000552 -->0.434198
AD #2135
House (Land) (Recreational)
51271 Range Road 30, Leduc County, Alberta, Canada
$2,500,000
AD # 2135
Visit http://www.arcticrealestate.ca for more images and full details.

This astonishing Edmonton home for sale is situated on 104 acres along the North Saskatchewan River and is 63 km west of Edmonton, Alberta. This Edmonton real estate property is a great mix of treed land, pasture, waterfront, and residence grounds making it suitable for a... read more
NotSold0.0007060000000001 -->0.434904
AD #2134
Bungalow
4521 52 Street, Leduc, AB
269,000
AD # 2134
Love living near the lake in quite Leduc.

Own your own bungalow and yard with 22 trees.

Huge double heated garage for all your toys.

Hardwood floors and a basement suite.   Rent the basement or keep
it all to yourself.

... read more
NotSold0.00050399999999995 -->0.435408
AD #2120
Condo/High Rise
#1714 13910 Stony Plain Rd., Edmonton, AB
$210,000
AD # 2120
Enjoy life at the top of this deluxe, one of a kind, residential high rise in upscale Glenora; just minutes west of downtown. This spacious 788 sq ft 1 bedroom suite is the largest floor plan for a one bedroom that Crescent Place has to offer. It gets just the right amount of sunshine year round with a truly amazing south east panoramic view, with... read more
NotSold0.00050600000000001 -->0.435914
AD #2104
Condo
107, 10730-112 Street, Edmonton, Alberta, T5H 3H1
$149,000.00
AD # 2104
Large one bedroom, one bath main floor condo completely upgraded (not a basement unit). New In-suite laundry to code, built-in vacuum system, built-in microwave/hood fan over the stove. All new appliances including dishwasher. Beautiful white New panel doors, brushed nickel door hardware, faucets and light fixtures. New plumbing. New Laminate... read more
NotSold0.00053400000000003 -->0.436448
AD #2042
116 acres
1 mile West of Stony Plain, NE-11-053-01-W5, Parkland County
$25,000/acre
AD # 2042
This Prime farmland suitable for subdividing, is located between the Yellowhead & 16A Highways. The property is 5 minutes from Stony Plain & 20 minutes from Edmonton. The access County road is paved.... read more
NotSold0.00050699999999992 -->0.436955
AD #2043
Photography
5021 50 Street, Vegreville, AB, T9C 1R3
$59 000
AD # 2043
I want to sell this business to someone who will care for it, enjoy it, and nurture it. This is an unbeatable price with instant profit making abilities. The buyer will have everything necessary to run a successful photographic business. You can be your own boss, enjoy the best job ever and encourage others in the arts. The business comes with a... read more
Sold0.000525 -->0.43748
AD #2140
39.33 Acres
Sturgeon County, Alberta
$665 000.00
AD # 2140
5 Km from city!

The 39.33 acres is located on the west side highway 28 approximately 1 Km north of the intersecting highways 28 and 37.  The municipal address of this property in the Municipal District of Sturgeon No. 90 is 55018 HWY 28.

This is 10 Km north of the Namao Shopping Centre located on 97 Street. in Edmonton. The property is less... read more
Sold0.00051600000000007 -->0.437996
AD #2137
.16 acres
Edmonton, Alberta
$250000
AD # 2137
Vacant lot in the highly sought after, mature community of Forest Heights. Minutes from downtown, moments from the beautiful river valley. Lot measures 50ft x 140ft, zoned for single family dwelling (RF1). Ideal location to build your dream home and enjoy the best of urban living.... read more
Sold0.00064900000000001 -->0.438645
AD #2122
Approx. 80 acres
North half
$195,000
AD # 2122
Private treed land just north of Edmonton.

80 acres of beautiful country property located on the western edge of Thorhild County. Quiet location, 3 km off pavement. Easy commute to Edmonton, Fort Saskatchewan, Redwater and Westlock.

A nature lover’s paradise away from city lights and city noise. A place to meander along trails through the... read more

Sponsored Links

Southeast Calgary Homes

NotSold0.004199 -->0.442844
AD #2063
Single family
82 Auburn Crest Green SE
499,999
AD # 2063
This house is 1547 sqf. it has 3 bedrooms and 2.5 bathrooms. Two bathrooms upstairs and a half downstairs. The main floor is a complete open concept, with the living room, Kitchen, and Dining room on the same floor. The house is great for entertaining family and friends. You can be sure that you will never miss the action. During summertime, you... read more
NotSold0.00066600000000006 -->0.44351
AD #2057
Acreage/bungelo
3275 88 St SE, Calgary, AB
1,398,999.00
AD # 2057


Executive Bungalow Acreage in Calgary!!
For sale only minutes from Stoney Trail and Peagan Trail

Includes 2700 sq. ft. hobby shop and 1100 Sq. ft. High End Photography Studio.

HOME
Custom Built Home. Centrally located this bright and open home is situated on a beautifully manicured 2 acre parcel that is nestled in the small... read more
Sold0.00049199999999994 -->0.444002
AD #2045
Residential Detached Single Family
SE Calgary, Alberta
319,900.00
AD # 2045
Great value in this sweet two storey home located in the heart of MckenzieTowne. Located steps from the Catholic K-9 school, and walking distance to all amenities including public transportation, shopping, restaurants, Towne Hall, and the Towne Square. The Contemporary open concept design features hardwood floors, and exceptional natural light.... read more

Sponsored Links

Outside Of Calgary Homes

NotSold0.001162 -->0.445164
AD #2010
Back Split
19 Maple Pl., Crossfield Ab.
$425,000.00
AD # 2010
Price Reduced!
Located on a quiet cul-de-sac in Crossfield 50 Km north of downtown Calgary close to schools soccer fields and playgrounds.  Main floor has den and family room with gas fireplace and laundry in the 3 pce bathroom. The upper level consists of 3 bedrooms. The large master bedroom has walk-in-closet and a 4 pc. ensuite bathroom with jetted tub.  The... read more
NotSold0.00051299999999999 -->0.445677
AD #2005
(Home) option adjacent 20 acres
30 min SW of Calgary
$ 995k with 20 acres
20 acres bare $ 549k
AD # 2005
Absolutely Awesome home on 20/40 acres only 35 min. SW of Calgary.  The complete storey is told on my website at http://www.millarvilleacreage.com.  Please cut and past to view.  Also note:  A $ 5000 SUCCESSFUL REFERRAL PRIZE!!!  You really must see the website and learn much more than any MLS listing site.... read more
Sold0.00052200000000002 -->0.446199
AD #2000
Hillside Bungalow (Land)
Cochrane, Alberta
799,000
AD # 2000
Price Reduced!
Beautiful family home with a million dollar mountain view. State of the art co-op water system guarantees great supply of water. Awesome kitchen with 2 ovens and island. 5 minutes from Cochrane, 40 minutes to downtown Calgary or the airport.

Call us for an appointment.... read more

Western Alberta

NotSold0.001266 -->0.447465
AD #2096
Bungalow
54206B Hwy 748 North, Yellowhead County, Alberta, T7E-3N6
559000
AD # 2096
This beautiful bungalow is just off the pavement with only 100 meters of gravel and only 7 Km north of Edson in the Yellowhead County.  It is fully fenced with approximately 3 acres of trees in the front, back and along the sides. The garden has a fence around it to keep the pets out. The spacious laundry room has upper and lower cup boards like... read more
NotSold0.00053599999999998 -->0.448001
AD #2092
+/- 3 acres
NE 8-32-2w5m
$204,900.
AD # 2092
Buy now, be ready to build in the spring!
The perfect Alberta view; agriculture, oil and the beloved Rocky Mountains can be seen from this acreage just minutes from Olds or Didsbury.  The three acre parcel is serviced with power and water well.  The location preserves the peace and quiet of rural living while being situated eight miles west of... read more
NotSold0.00051600000000007 -->0.448517
AD #2088
163 acres
Clearwater County, on Hwy 11, @ Range Road 5-5
350,000
AD # 2088
Farm Land For Sale – SW5-39-5W5M
$350,000
Mountain view.
Full quarter section (163.3 acres) on Hwy 11 20 km E of Rocky Mountain House.
2 accesses off Range Road 5-5.
Game fence around entire perimeter and cross-fenced.
70 acres hay, 70 acres pasture, 20 acres trees.
Spring fed water supply.
Oil & Gas Revenue $3700/yr.
Buyer could... read more
NotSold0.00053799999999993 -->0.449055
AD #2055
163 acres
Clearwater County, on Range Rd 6-0, 1.5 miles N of Hwy 11
189,000
AD # 2055
Farm Land For Sale – SE12-39-6W5M
$189,000
Mountain view.
Full quarter section (162.93 acres) 1.5 mile N of Hwy 11 on Range Road 6-0 approx 18 km east of Rocky Mountain House.
Pasture / recreational.  Cleared and broke and seeded to grass 1981-1982.
Access off secondary Range Road 6-0.
5-strand high tensile steel perimeter fence.... read more
NotSold0.00053400000000003 -->0.449589
AD #2035
Acreage
212 Clearwater Heights Place, 7 miles west of Caroline
$385000.00
AD # 2035
Beautifully located raised bungalow on 1.23 acres in the West Country 7 miles West of Caroline. Situated just 10 minutes from the foothills of the Rockies, this home could be a bed and breakfast, a family get-a-way spot or a family home. With Alford creek running just out back for fishing or just for the kids to play in during those summer days.... read more
NotSold0.00054699999999996 -->0.450136
AD #2028
4.25 acres (Recreational)
Alford Creek Road
$179,000.00
AD # 2028
Price Reduced!
This 4.25 acres of parklike property is ready for your Cabin or Home.  17 ft. RV dual axle unit could stay.  13 km's West of Caroline on Hwy 54, / becomes Hwy 591.  Fully serviced and fenced, 2 plus acres fully cleared. Ready to use power, water, and septic.  1000 gal holding tank and pressurized septic field.  Includes 16 x 64 gravel pad for... read more
Sold0.00068800000000002 -->0.450824
AD #2050
Acreage
25
$309,999
AD # 2050
SOLD
Gorgeous location in west country, only 2km of gravel on a no-exit road. Minutes to amazing trails & crown land, with springs & lakes (great hiking, biking, fishing, quadding, snowmobiling, tobogganing, picnic/bonfires right from your doorstep), just 3min to Clearwater Store, 10min to Phyllis Lake, 7min to Caroline, 10min to Burntstick Lake, 15min... read more

Sponsored Links

Southwest Calgary Homes

NotSold0.001401 -->0.452225
AD #2039
4 split level
Calgary, AB
515,000.00
AD # 2039
This no smoking 4 level split home is located in quiet neighborhood of the Braeside Estate in SW of Calgary, and offers 2,080sq.ft of developed living area. Largely renovated in the past which includes: floor replacement, kitchen replacement including appliances, renovation of all the bathrooms, replaced fixtures, some windows were replaced, new... read more
NotSold0.00075500000000006 -->0.45298
AD #2031
Bungalow
1023 Cannock Pl.S.W.
419,000
AD # 2031
New high efficiency furnace, New hot water tank, New hardwood flooring, maple kitchen cabinets, walk in closet, developed basement, deck, close to Elementary School, Junior High, High School, Fish Creek Provincial Park, Leisure Center, Shopping, this updated bungalow is in the desirable neighborhood of Canyon Meadows in the South West.
Mature... read more
NotSold0.00071699999999997 -->0.453697
AD #2026
Condo
1724-26 Ave SW, Calgary AB , T2T 1C8
280,000
AD # 2026
SELLER FINANCING

A quiet, top floor apartment in a new, concrete, 4-storied up-town building. Heated underground parking. Your private washer and dryer, stainless steel dishwasher, stove, and fridge. A carpeted balcony. Close to major roads, steps to downtown with the abundance of all the amenities. Minutes walk to schools. Beautiful window... read more
NotSold0.00079200000000001 -->0.454489
AD #2014
Condominium/Strata
309-2411 Erlton Rd SW, Calgary AB
$399,000
AD # 2014
This beautiful, upgraded 2 bedroom, 2 bathroom condo in Erlton boasts a great open-concept layout with 9 foot ceilings and luxurious finishes including Berber carpet, ceramic tile, brand new stainless steel appliances, maple cabinets, quartz counters, and newly-renovated contemporary kitchen and bathroom. Both extra-large bedrooms have walk-in... read more
NotSold0.00054900000000002 -->0.455038
AD #2020
Detached House
75 Strathridge Grove SW, Calgary, AB, Canada
$869,000
AD # 2020
This custom built immaculate four bedrooms house is located in Calgary's prestigious Strathcona Park only ten minutes to the downtown with spacious backyards and stunning views. Huge kitchen with generous cabinets and central island, formal living and dining RM, Mammoth size family room with gas fire place, tile floor in kitchen, large corner... read more
Sold0.00064799999999998 -->0.455686
AD #2038
2 storey detached
Discovery Ridge, S.W.,, Calgary, Alberta
$659,900
Reduced - owner relocating
AD # 2038
Price Reduced!
Meticulously maintained 4bed + den, 3.5 bath Morrison Home (2001) on
quiet court near park. Pie shaped lot; 2800’ of finished space; 3 levels;
backs onto treed grasslands; wildlife at your doorstep; privacy galore; rear
raised deck, mature trees, views; kitchen w/ beautiful newly installed granite counters, granite island, 5 brand new s/s... read more

Sponsored Links

Red Deer And Area

NotSold0.001277 -->0.456963
AD #2106
Bungalow 157 +/- acres
Lot 361071, Range Rd. 6-3, Clearwater County, Alberta
$875,000.00
AD # 2106
WESTCOUNTRY RANCH
Located 90 min. NW of Calgary, 157 +/- acres secluded ranch.  Tame hay, pasture, bush & yr. round, springfed creek crosses property. State of the art boiler system heats 1360 sq. ft. 2 bd. 1 1/2 bath home built in 2004, as well as 64x40 metal sided shop (inside & outside) with mezzanine which houses separate 2 bdrm, 1 bath self... read more
NotSold0.00071600000000005 -->0.457679
AD #2105
150 acres
West Central Alberta
AD # 2105
NATURE LOVER'S PARADISE!

Please visit our website for all the information on this one of a kind property and opportunity:  http://www.natureloversparadise.ca... read more
NotSold0.00066599999999994 -->0.458345
AD #2100
4-plex (1 unit)
5029 48st. Unit B, Olds AB, Canada
$205,000.00
AD # 2100
Up-graded condo unit, Teak hard-wood floors in living-room and dining area, Faux wood blinds, 5 appliances including stacked W/D and dishwasher. Bedrooms downstairs, quiet area close to down-town and Olds College. Condo fees 75.00 a month Rented at present, please phone owner for showings Beautiful tile in kitchen and entry and upstairs bathroom,... read more
Sold0.00052300000000005 -->0.458868
AD #2101
Residential Detached
Red Deer, Alberta
$418,000
AD # 2101
This home is available for immediate possession and is conveniently located near public transit. This fully fenced corner lot is located in a great neighborhood.

HOME FEATURES

MAIN FLOOR

Kitchen/Dining (14'6x19'9): Tile flooring, island with eating counter, vaulted ceiling, track lighting, ceiling fan, door to back deck, 3 sided... read more

Sponsored Links

Northwest Calgary Homes

NotSold0.001208 -->0.460076
AD #2037
two storey
Panatella square NW
$ 489.000
AD # 2037
This beautiful Triumph is under construction by Shane homes with possession in  August 2010. Two storey homes of 2055 sq., three bedrooms  with bonus room and 2 1/2 bathroom. Main floor is open concept plan with 9' ceiling, hardwood and ceramic floor. Kitchen is dark maple, with granite countertop, stainless appliances, raised breakfast... read more
NotSold0.00050600000000001 -->0.460582
AD #2027
Residential Detached
6632 Bowness Road, NW, Calgary Alberta
$419,900
AD # 2027
Four levels split home in the heart of trendy part of Bowness. Excellent location, it is a block away to the Bow River, and a few minutes to Shouldice and Bowness parks. Canada Olympic Park, the Children’s' Hospital, the University of Calgary and Downtown are all in close range as well. Convenient access to public transportation (bus stops... read more
NotSold0.00054799999999999 -->0.46113
AD #2022
RESIDENTIAL DETACHED SINGLE FAMILY HOME
88 COUNTRY HILLS GROVE NW, CALGARY AB
$439,000
AD # 2022
VERY GOOD INVESTMENT PROPERTY OR TO LIVE IN RENOVATED HOUSE NEW PAINT CARPET MOULDINGS FIXTURES 1998 BUILT IN ,IN A NICE NEIGHBORHOOD

MAIN FLOOR BIG KITCHEN FAMILY ROOM WITH FIREPLACE BIG DECK AND A LIVING ROOM .UPPER FLOOR 3 BEDROOM 2 FULL WASHROOM.
1 BEDROOM SUITE IN THE BASEMENT RENTED FOR $900 .CLOSER TO ALL AMENTIES SCHOOLS BUSES MALL... read more
Sold0.00055399999999994 -->0.461684
AD #2049
Semi-attached bungalow
Calgary, Alberta
$352,000
AD # 2049
Cambrian Heights N.W. Calgary - Semi Attached Bungalow


Centrally located and steps from Confederation Park; 1,013 sq ft on main floor; 3 bedrooms; 4 pc bath on main (recently redone by "Bathfitter"); half bath down; LR and MBR: refinished oak hardwood; 2 BRs and hall: carpet; 4 appl.; cathedral ceilings; full basement - partially... read more
Sold0.00056800000000001 -->0.462252
AD #2046
2 Story
Calgary, AB
559,900.00
AD # 2046
Price Reduced!
Attention: Realtors bring in a qualified buyer, will pay a commission

Located in the heart of beautiful Scenic Acres within walking distance of 2 schools, the Crowfoot LRT and the Crowfoot Shopping Mall.



Taking living to the next level, this Albi home located in the beautiful community of Scenic Acres offers 2064 square feet of living... read more

Sponsored Links

Outside Of Calgary Business / Land / Other

NotSold0.001202 -->0.463454
AD #2015
64 acres
Bragg Creek, Alberta
2500000.00
AD # 2015
Sixty four gorgeous acres for sale located off hi way 66 in Bragg Creek, Alta. This property offers unlimited potential for a subdivision, resort, get-away cabins or your very own dream home. With already established gas, power and telephone lines on the property. It is close to Kananaskas Country, a great place to go hiking site seeing or... read more
NotSold0.00050700000000004 -->0.463961
AD #2011
10.03 ACRES
44111 WEEDON TRAIL, ROCKYVIEW COUNTY, COCHRANE ALBERTA
$548,000
AD # 2011
Rare 10 acres mountain view, on paved road, breath taking views 360 degrees, 40 minutes to downtown Calgary and 10 minutes to Cochrane.  Well drilled. Shared paved approach.  County reserve fees paid up.  Septic field approved.  Land slopes  allow a fabulous walkout development.  Paved road plowed in winter by County. ... read more
NotSold0.00057399999999996 -->0.464535
AD #2024
5.51000 Acres
East of Okotoks overpass, on h-way 552( 5 miles) , turn left on 80th st.
390,000
AD # 2024
This Raw land parcel is located just 5 miles east of Okotoks overpass,turn left on 80th st.(north),3rd acreage on right hand side. Mountain views,services to property line,good well(well report avail.)minutes to Heritage Heights k-9 school, Rec centre is to be built nearby,close to 3 golf courses,minutes to Deerfoot Trail and City... read more
NotSold0.00051900000000005 -->0.465054
AD #2023
10 Acres
Next to Elkana Estates, Bragg Creek
$729000
AD # 2023
Mostly treed south facing slope with two elevated buidling sites.  Power, gas and phone installed to property line.  ... read more
NotSold0.00052799999999997 -->0.465582
AD #2009
15 acres
sw1/4 sec16 twp23 r5 w5
$ 649,000.00
AD # 2009
Price Reduced!
Property situated 5km west of Bragg Creek. Property abuts Bragg Creek on north side . Property has unobstructed mountain views. Power,telephone, well &septic feild, Zoned R3 with possibility of subdivision. Excellent access to property on all weather maintained MD road Adjacent property to the east is 20 acre equestrian ranch, to north and west... read more

Sponsored Links

Southern Alberta

NotSold0.0013409999999999 -->0.466923
AD #2094
Mobile Home
Claresholm, Alberta
$168,000.00
AD # 2094
Mobile home with 3 bdrms, 2 full bathrooms, laundry room, incl. all appliances, insulated garage, garden shed,landscaped and fenced lot, paved parking pad in front of garage.  Call for more information or to arrange a viewing.... read more
NotSold0.0030420000000001 -->0.469965
AD #2066
160 acres (Recreational)
NW-20-5-2-W5
$2700000
AD # 2066
This is a rare opportunity to purchase one of the best recreational properties nestled in the Rockie Mountains of Southern Alberta. Located between Castle Mountain Resort and Pincher Creek this 160 acre parcel is very secluded with great access. Being 30km from Pincher Creek, 21km to Castle Mountain and 40km to Crowsnest Pass leaves you open to... read more
NotSold0.002687 -->0.472652
AD #2139
Plumbing & Heating
Southern Alberta, Milk River, Alberta
AD # 2139
Plumbing & Heating Business with Laundromat. Servicing Southern Alberta

Small community living

Owner retiring

Includes two 50 x 100 lots, full line of plumbing and office equipment with service truck. Shop, office and laundromat on main floor, 2000 sq.ft. residence upstairs.

Reasonably Priced! ... read more

Sponsored Links

1

Debug:
REGION:00002Cats
Build HierarchyQUERY
SELECT l.*, t2.* FROM cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id JOIN ( SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id) t2 ON t2.hierarchy_id = h.hierarchy_id WHERE status = ? AND l.listing_date < now() group by l.id order by t2.max desc, t2.name asc, l.listing_date desc
SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max, h.extra1 as link, count(tmp.id) as count FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id order by max desc, h.name asc
(published, %Alberta%, published)[0][48]
query1->0.003842
query3->0.007683 -->0.016176
(28)
query3->0.011223 -->0.027399
(28)
query3->0.006027 -->0.033426
(28)
query3->0.00961 -->0.043036
(28)
query3->0.010638 -->0.053674
(28)
query3->0.009859 -->0.063533
(28)
query3->0.009301 -->0.072834
(28)
query3->0.01007 -->0.082904
(28)
query3->0.00877 -->0.091674
(28)
query3->0.008177 -->0.099851
(28)
query3->0.00916 -->0.109011
(28)
query3->0.010072 -->0.119083
(28)
query3->0.009397 -->0.12848
(107)
query3->0.006877 -->0.135357
(107)
query3->0.006813 -->0.14217
(107)
query3->0.007743 -->0.149913
(108)
query3->0.006774 -->0.156687
(108)
query3->0.006883 -->0.16357
(108)
query3->0.006825 -->0.170395
(25)
query3->0.017964 -->0.188359
(25)
query3->0.008151 -->0.19651
(25)
query3->0.008572 -->0.205082
(25)
query3->0.010526 -->0.215608
(25)
query3->0.018299 -->0.233907
(25)
query3->0.012784 -->0.246691
(25)
query3->0.009287 -->0.255978
(106)
query3->0.006752 -->0.26273
(106)
query3->0.006272 -->0.269002
(106)
query3->0.006425 -->0.275427
(106)
query3->0.006016 -->0.281443
(106)
query3->0.0062739999999999 -->0.287717
(106)
query3->0.0062920000000001 -->0.294009
(29)
query3->0.010922 -->0.304931
(29)
query3->0.007589 -->0.31252
(29)
query3->0.007224 -->0.319744
(29)
query3->0.009507 -->0.329251
(104)
query3->0.006473 -->0.335724
(104)
query3->0.006529 -->0.342253
(104)
query3->0.006437 -->0.34869
(104)
query3->0.006837 -->0.355527
(104)
query3->0.005908 -->0.361435
(110)
query3->0.0060859999999999 -->0.367521
(110)
query3->0.006282 -->0.373803
(110)
query3->0.0059790000000001 -->0.379782
(110)
query3->0.006091 -->0.385873
(110)
query3->0.005784 -->0.391657
(27)
query3->0.013998 -->0.405655
(27)
query3->0.009289 -->0.414944
(27)+
runtime(0.473656)
Canadian Maple Leaves
Canadian Maple Leaves