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:00001Cats
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, %Canada%, published)[0][45]
query1->0.01755
Heirarchy0.020695 -->1.036023
Regions of
Canada
Max Ads per page:

Omineca / Peace / Skeena Regions

NotSold0.001289 -->1.037312
AD #1103
1,280 acres Specialty Lumber Products
West of Fort St. John
Included in Land Total
$1,000.00
AD # 1103
Price Reduced!
A Business Proposition at an exceptional price for the right person.………………………………………………………………
We offer a direct sale – with negotiable conditions – of farm land with a large woodlot utilized for our own manufacture and sale of specialty wood products. All required machinery for agricultural... read more
NotSold0.029691 -->1.067003
AD #1098
rancher
3275 Bave Road, Vanderhoof BC
625000
AD # 1098
Energy-efficient gorgeous home with geothermal heating/airconditioning overlooking your own private lake! Lots of revenue potential with 50 acres in production, 30'x40' heated insulated shop w/220 wiring for your business, easily suite-able lower level or for a B&B, or just move the family in for a close-to-nature lifestyle.

Just 15... read more
NotSold0.00163 -->1.068633
AD #1096
160 acres 1/4 section (Recreational)
463 187a rd, Tomslake BC
Land value only 160,000.00
AD # 1096
160 ac  selling for land value only  some buildings, fenced &x fenced, hay fields & pasture,creek thru property, excellent hunting property with bush & tree cover.
1/2 mile gravel to pavement
1 hr to Dawson Creek BC
1 hr to Grande prairie AB... read more
NotSold0.00156 -->1.070193
AD #1082
2 storey residential/commercial
421 Main St., McBride, BC
$139,000
AD # 1082
Price Reduced!
Recently reduced, owner is very motivated. Newly renovated and totally refurbished historic house for sale in beautiful McBride, BC. If you like to sled, hike, hunt, fish, or just enjoy the mountains, this is the place to do it in.

This two-storey house on a full unfinished basement, is currently being used in a commercial capacity as a... read more
NotSold0.003251 -->1.073444
AD #1157
Restaurant -motel
5112 50th Street, Chetwynd, BC
$595,000
AD # 1157
50 heat licensed family restaurant. plus 24 room motel and 1200 sq ft living quarters. Centrally located on Junction of Hwy 29 & 97. Thriving family business, well established. Owners would like to retire.... read more
NotSold0.001412 -->1.074856
AD #1146
Hobby Farm 62 Acres
21891 Triad Road, Prespatou BC, Canada
$460,000.00
Package Deal
AD # 1146
Open House!
A beautiful double wrought iron gate with a high arch way at the entrance to a graveled circle driveway with a second beautiful double gate at the exit. Major renovations have been completed on the residence. Also a new Octagon Horse Corral and a new Large Root Cellar

Acres Beautiful treed valley land with very gentle slope draining into Umbach... read more
NotSold0.001438 -->1.076294
AD #1142
Farm/Ranch 1440 acres
Fort St. John area
$1500000.
AD # 1142
Experience country living at its finest; fresh air, blue skies, fertile soil and life out of the rat race. Get more for your dollar the rural way. This property’s investment potential includes: set-up for buffalo/feed lot (or horses, cattle, elk, llamas, etc.)and rental income off one residence.

The first residence is a 1977 mobile home... read more
NotSold0.002027 -->1.078321
AD #1076
(Home) Fully Furnished 1/2 Duplex Revenue Property
7143 Guelph Crescent, College Heights, Prince George, BC
$202,000
AD # 1076
Prime Revenue: Inquire

MLS# N208553

Excellent Investment Opportunity!
Revenue, Plus!
One of a kind. Well maintained, immaculate, and recently renovated 1/2 duplex home with  'separately entranced and self contained in-law suite'  in desirable College Heights. Offered at $202,000. Bright spacious layout.

Quick possession.  Fully... read more
NotSold0.001414 -->1.079735
AD #1041
94.4 acres
19180 Highway 29N, Hudson's Hope, BC, V0C 1V0
$1,199,000 CDN
AD # 1041
* * * * * Hugging The Peace River * * * * *

Description:
   Beautiful homestead/farmstead waterfront property located in the heart of scenic Peace Valley Region. One-of-a-kind ¼ section with property on both sides of the Peace River (plenty of river frontage!). Undeveloped flat land with two upper plateaus (prime building locations!). ALR... read more
Sold0.0013300000000001 -->1.081065
AD #1085
Fenced Acreage and Family Home
Prince George Rural West
$276,000
AD # 1085
Price Reduced!
Fantastic family home and acreage for sale just 10 minutes west of UNBC in Prince George. The home was built in 1995 and is in excellent condition inside and out. Recent upgrades include flooring and paint. Quality trim throughout. Windows, roof all in excellent condition. Excellent drainage.

The acreage is completely fenced and ready for... read more

Sponsored Links

Business Valuation
Sell Your Home in 21 Days
Improve the Curb Appeal of Any Home

Foreign

NotSold0.026698 -->1.107763
AD #312
Hotel Resort
San jose de la Montana, Barva,Heredia,Costarica
any sensible offer to be considered
AD # 312
25 ensuite rooms on 5 acres of land at 6000 feet altitude overlooking Costarica San Jose capital City
and its International Airport (SJO) Both of them at 11 miles down to the central valley.
Great night View also of Pacific Ocean.We are at just 3 miles from Braulio Carrillo National Park main entrance
The property has about 17000 sq foot under... read more
NotSold0.001438 -->1.109201
AD #311
Manufactured home (Recreational)
38551 Cactus Lane, Palm Desert, CA, USA
$249,900.00 U.S.
AD # 311
Price Reduced!
Snowbirds ! Palm Springs !  Active 55+ gated community.  Own your lot and immaculate 2009, 1404 sq. ft. Golden West home.  This home is Energy Star rated.  Furnished Two bd./ 2 bath plus office/den .  $249,900. U.S.  Low HOA's of $251./mos. include golf on your private 18 hole exec. course.  Loads of amenities in this community. Google MLS... read more
NotSold0.001336 -->1.110537
AD #310
SF
840 Tarawitt, Longboat key, Fl
1,230,000
AD # 310
THIS HOUSE SITS ON THE CANAL ENTRANCE TO SARASOTA BAY ON LONGBOAT KEY WITH FANTASTIC VIEWS FROM THE DECK OF THE CITY OF SARASOTA AND THE BAY. ELEVATOR FROM LOWER LEVEL ASSURES CONVENIENCE.  PRIVATE ENCLOSED POOL AREA.  GREAT HOME FOR ENTERTAINING.  THIS IS LIKE OWNING A CONDO WITHOUT THE HASSLES OF LIVING WITH OTHER OWNERS.  YOU CAN PURCHASE... read more
NotSold0.001314 -->1.111851
AD #309
Split Level
3805 Tamarack Ave., Whitefish, MT 59937
689,000
AD # 309
Price Reduced!
Reduced by $10K! Visit http://www.whitefishskihouse.com Ski access right out of your front door! This house has good bones and is one of only a few single family homes under a million dollars on the mountain that has ski in/out accessibility. Why share common walls in a condo with noisy neighbors and tourists. The location is great with friendly full... read more
NotSold0.001293 -->1.113144
AD #308
Block and Brick Construction (Recreational)
9060 Heckscher Drive, Jacksonville, FL, 32226
$509,500 US
AD # 308
DEEP WATER DOCK with Electric BOAT LIFT

This diamond in the Rough Boaters is a  Dream Come True! It sits on nearly an acre on the St Johns River minutes from the Atlantic Ocean and Intercoastal Waterway. It has a deep water dock with an electric boat lift, sandy beach, pool, 2/1 guest house. The main house sits off the road 100' and has a... read more
NotSold0.001357 -->1.114501
AD #302
Condo (Recreational)
1400 Gulf Blvd #104, Clearwater Beach, FL, 33767
364,900.00
AD # 302
2 bedroom, 2 bath, fully renovated; 'custom' sliding doors and windows replaced summer, 2010- they telescope into each other; a/c replaced summer 2009, beautiful, rich granite in kitchen and bathrooms, Master Bedroom has king bed and 2nd bedroom has 2 queen beds;  flat screen LED TVs in bedrooms; Kitchen has Sony CD player clock radio; ... read more
NotSold0.00142 -->1.115921
AD #303
(Home)
922 Queen Rd, St, Augustine, Fl 32086 USA
186,400
AD # 303
Price Reduced!
Built……….1993                                    Family Room                            
Open Deck/enclosed porch
Area.……... 1650 Sq. Ft.                          Dining Room                            
All electric
Bedrooms….3, Split plan                          Eat in Kitchen                            
Fire Place
Bathrooms..2... read more
Sold0.001341 -->1.117262
AD #307
contemporary
residential Arrocito, Bahias de Huatulco, Oaxaca, Mexico
650000 US
AD # 307
Architecturally designed home 3477 sq.ft.. Room to build additional guest house.Engineered drawings for future expansion available, plans approved by local autorities.
.Partly ocean-views, just 5 min. walk to three beautiful virgin beaches.
.Infinity pool 430 sq.ft.
.Very safe, quiet area, no direct neighbours, property is all gated.Electric... read more
Sold0.001301 -->1.118563
AD #301
Farm/Ranch
Cochise County, Arizona
$99,500US
AD # 301
Ten acres of flat valley bottom land with beautiful view to the South West of the Dragoon Mountains where the Indian Chief Cochise had established his Stronghold when the US Cavalry was hunting him. To the East is the Dos Cabezas Mtns. To the West and North are some smaller mountains just a few miles away.

The ten acres is quite open with,... read more

Sponsored Links

Business Valuation
Sell Your Home in 21 Days
Improve the Curb Appeal of Any Home

Edmonton And Area

NotSold0.003085 -->1.121648
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.001305 -->1.122953
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.001303 -->1.124256
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.001481 -->1.125737
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.001439 -->1.127176
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.00126 -->1.128436
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.001311 -->1.129747
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.001305 -->1.131052
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.001287 -->1.132339
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.001302 -->1.133641
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.001305 -->1.134946
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.001277 -->1.136223
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

Business Valuation
Sell Your Home in 21 Days
Improve the Curb Appeal of Any Home

Quebec City / Charlevoix / Chaudiere-Appalaches

NotSold0.00405 -->1.140273
AD #6013
Condo
96
834000
AD # 6013
English
Exceptional dual corner 2 bedroom + study (Condo).
2 bathrooms at the prestigious Summet II - Lac St –Augustin, Québec Canada. Located on the 6th floor, above the treetops.  The view is breathtaking; view over the Saint-Lawrence River, the lake and the mountains! This unique unit also offers open spaces with ample light, the patio... read more
NotSold0.001352 -->1.141625
AD #6010
3618 m2 (38 900 ft2)
Versant du Massif, , Baie-St-Paul, Quebec
249 000.$
AD # 6010
Superb land ready for construction located on a mountainside in a dead end with no neighbors facing South and overlooking the St-Laurence River and Isle-aux-Coudres. Possibility of rental income and construction turnkey. Location and maintenance services for a house in location. One of the most beautiful terrain accessible at Versant du Massif,... read more

Sponsored Links

Business Valuation

Cape Breton Island

NotSold0.00273 -->1.144355
AD #9035
Cottage (Recreational)
339 Joseph MacFarlane Drive , Portage Road, Whycocomagh, CApe Breton . Nova Scotia
269000.00
AD # 9035
Price Reduced!
2 Fully furnished waterfront cottages on 3.09 acres of land,Also 2 building lots total of 6 acres.Cottages are on frostwalls with cement floors. Both are 2 Bedrooms 1 Bathroom, Open concept overlooking the water of Whycocomagh Bay. Cottages come equipped with All handmade pine furniture, dishes , small kitchen appliances , stove , fridge ,... read more
NotSold0.001766 -->1.146121
AD #9031
Mobile Home
Veterans Memorial Drive (Lower Rd), Arichat, Isle Madame,
$155,000.
AD # 9031
This valuable well maintained property fronts onto Arichat Harbour and has magnificent views of Jerseyman Islands and Cape Auguet.

The whole property is cleared and flower gardens and lawns have been developed.  It is 25 minutes from Port Hawkesbury and Isle Madam is connected to Cape Breton Island by a short causeway.

The Mobile Home, which... read more
NotSold0.002919 -->1.14904
AD #9029
+/- 5 acres with 130' frontage on Bras D'or Lakes
Baddeck Bay Road, Baddeck, Cape Breton, Nova Scotia, Canada
$475,000 Cdn
AD # 9029
Bras d’Or Lakes Waterfront Property For Sale...Baddeck Bay, Nova Scotia, Canada

Undeveloped high-potential property overlooking the renowned Bras d’Or Lakes and the hills of Beinn Bhreah (and the summer estate of the late Alexander Graham Bell).  This unique woodland parcel comprises approximately 5 acres, includes cleared water frontage... read more
NotSold0.0024369999999999 -->1.151477
AD #9025
11 Acres
Cape Auget, Isle Madame
C$156,000
AD # 9025
11 acres of undeveloped rolling hillside on beautiful Cape Auget with Water frontage on Arichat Harbour and also overlooks Forest Cove.

Excellent Views. 25 minutes from Port Hawkesbury and 1 Hour from Sydney.
Purchaser could easily divide into three generous lots, each with road access.

(other land available on Isle Madame)

Phone: ... read more
NotSold0.0013460000000001 -->1.152823
AD #9021
10 acres
Sight Point Road@Broad Cove Banks, Inverness, Cape Breton, Nova Scotia
216,000.00
AD # 9021
Only 5 minutes off the beaten track but with ultimate privacy and seclusion.

Located in Sight Point area of Inverness, Nova Scotia on Cape Breton's Scenic Route 19 to the Cabot Trail.
The Town of Inverness has a pop. of approx 1500 and has a friendly attitude. Inverness has a Consolidated School, A Regional Centre Hospital, great food and... read more
NotSold0.001302 -->1.154125
AD #9018
1 & 2 acre Serviced Building Lots
Broad Cove Banks Road, Inverness, Cape Breton, Nova Scotia
1 Acre Lots From $38,000
AD # 9018
If you are interested in getting off the grid to one of the least polluted environments anywhere, where the air is clear and clean and the water is clear and clean, where there is no industrial source polluting the air and water, you should take a look. This natural haven offers all the good that the outdoors have to offer with excellent hiking... read more
NotSold0.0013829999999999 -->1.155508
AD #9008
50 Acres
L'Ardoise Highlands Road, Lower L'Ardoise, Richmond County, Nova Scotia
90,000.00 Cdn
AD # 9008
Situated in the province of Nova Scotia, Canada. A 50 minute drive from the city of Sydney, 35 minutes from the town of Port Hawkesbury and 60 minutes from the Sydney airport.

Orientation: Fleur de Lis Highway, Lr. L'Ardoise,
                       Richmond County, Cape Breton, Nova Scotia.

Total Surface: 50 Acres

A 346 ft. lake... read more
Sold0.0013840000000001 -->1.156892
AD #9026
Waterfront
St Peters
490,000 for the home and 60,000 for lot next door total 550,000 (will not be sold separately).
AD # 9026
SOLD
This is a custom designed Bras D’0r lakeside home in  McNab Cove on a parcel of land consisting of two lots totalling 6.013 acres. The home is built on one lot while the other is vacant and can be sold off without any severance issues if the purchaser wishes. The lake frontage is approximately 540 ft.

The home is very well built with  2x6... read more
Sold0.001359 -->1.158251
AD #9028
Mixed-use building
Arichat, Nova Scotia
$275,000 CAD
AD # 9028
SOLD
This is a mixed-use building in the heart of historic Arichat, Nova Scotia, directly across the street from the restored waterfront district and overlooking Arichat Harbour.

The building includes three two-bedroom apartments, two bachelor suites, and one one-bedroom apartment as well as three offices and a 1500-square foot ground floor... read more

Sponsored Links

Business Valuation
Sell Your Home in 21 Days
Improve the Curb Appeal of Any Home

Southeast Calgary Homes

NotSold0.003091 -->1.161342
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.001301 -->1.162643
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.0013770000000001 -->1.16402
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

Selling Your Home Alone
1

Debug:
REGION:00001Cats
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, %Canada%, published)[0][45]
query1->0.01755
query3->0.022814 -->0.067309
(111)
query3->0.018491 -->0.0858
(111)
query3->0.033548 -->0.119348
(111)
query3->0.02234 -->0.141688
(111)
query3->0.022834 -->0.164522
(111)
query3->0.017449 -->0.181971
(111)
query3->0.02096 -->0.202931
(111)
query3->0.047388 -->0.250319
(111)
query3->0.01012 -->0.260439
(111)
query3->0.045834 -->0.306273
(111)
query3->0.022587 -->0.32886
(93)
query3->0.008923 -->0.337783
(93)
query3->0.013616 -->0.351399
(93)
query3->0.01893 -->0.370329
(93)
query3->0.02462 -->0.394949
(93)
query3->0.022719 -->0.417668
(93)
query3->0.019545 -->0.437213
(93)
query3->0.01504 -->0.452253
(93)
query3->0.0197 -->0.471953
(93)
query3->0.016024 -->0.487977
(28)
query3->0.014421 -->0.502398
(28)
query3->0.007507 -->0.509905
(28)
query3->0.026423 -->0.536328
(28)
query3->0.033197 -->0.569525
(28)
query3->0.026648 -->0.596173
(28)
query3->0.028441 -->0.624614
(28)
query3->0.028211 -->0.652825
(28)
query3->0.02872 -->0.681545
(28)
query3->0.033518 -->0.715063
(28)
query3->0.017933 -->0.732996
(28)
query3->0.020244 -->0.75324
(28)
query3->0.016449 -->0.769689
(96)
query3->0.007569 -->0.777258
(96)
query3->0.015594 -->0.792852
(72)
query3->0.015855 -->0.808707
(72)
query3->0.016534 -->0.825241
(72)
query3->0.015582 -->0.840823
(72)
query3->0.025304 -->0.866127
(72)
query3->0.02075 -->0.886877
(72)
query3->0.018088 -->0.904965
(72)
query3->0.01383 -->0.918795
(72)
query3->0.019021 -->0.937816
(72)
query3->0.017373 -->0.955189
(107)
query3->0.048663 -->1.003852
(107)
query3->0.011476 -->1.015328
(107)+
runtime(1.166373)
Canadian Maple Leaves
Canadian Maple Leaves