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!

Build HierarchyQUERY
SELECT l.*, t2.* FROM cms_module_listings l JOIN cms_module_listings_prodtohier h ON = h.listing_id JOIN ( SELECT tmp.hierarchy_id,, max( listing_date ) AS max FROM ( SELECT h.hierarchy_id,, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_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 order by t2.max desc, asc, l.listing_date desc
SELECT tmp.hierarchy_id,, max( listing_date ) AS max, h.extra1 as link, count( as count FROM ( SELECT h.hierarchy_id,, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id order by max desc, asc
(published, %Canada%, published)[0][50]
Heirarchy0.001026 -->0.381437
Regions of
Max Ads per page:

Vancouver Island / Gulf Islands

NotSold0.001395 -->0.382832
AD #1054
Large executive residence
1381 Thornberg Cresc., TOFINO, BC,
AD # 1054
This luxurious oceanfront beach retreat with it's half acre lot is located on 5 kilometers of wide open, glorious flat sandy beach within an unspoiled wilderness sanctuary. Home to Clayoqout Sound's Unesco Biosphere Reserve and the Pacific Rim National Park. Built in 2003 to very exacting standards. Includes earthquake and tsunami... read more
NotSold0.021335 -->0.404167
AD #1053
3790 Burnside Place, Victoria, British Columbia, V8Z 7E5
AD # 1053
I love my house! It's not a great drive by so you have to get inside; or walk down the Galloping Goose and look at it from the back side.  Windows, Windows Windows.  South Facing, lots of sunshine, huge deck with stairs going down to back yard. Views over to the Olympic Mountains in Washington State and Portgage Inlet.The Galloping Goose (... read more
NotSold0.001278 -->0.405445
AD #1052
441 Campbell Street, Tofino
AD # 1052
Successfully operating for over 13 years in Tofino, Vancouver Island, this cafe is popular with both locals and tourists for its excellent amazing coffee, made to order meals and its sophisticated yet relaxed atmosphere. Beginning as a small low volume cafe in 2001, the business was purchased by the current owners in 2006, and since then has... read more
NotSold0.00099499999999997 -->0.40644
AD #1030
Hotel/hostel/country inn (Recreational)
1165 Salmon River Main, Sayward BC V0P 1R0
AD # 1030
This property is situated on 20 acres of beautiful private forest in peaceful and serene surroundings, with delightful views of a waterfall, Mt. H'Kusam and the surrounding peaks. It is on a paved logging road only 5 km from the village of Sayward and the port of Kelsey Bay, with newly paved driveway to the main building. Currently operating... read more
NotSold0.000834 -->0.407274
AD #1029
7241 sq. ft.
1752 Meagan St, Crofton, BC, V0R 1R0
AD # 1029
Price Reduced!
Crofton, B.C. Ocean View Lot

This 7,241 sq. ft. ocean view lot is zoned for a legal suite. The dimensions are 66.3' wide and 109.3' long. Lot 26 has been dug down to hard pan and is ready to build on with a level driveway entry.

This lot features full underground services, including natural gas. Located in Seaview Estates, a prime... read more
NotSold0.00088999999999995 -->0.408164
AD #1025
Cottage/Home (Recreational)
268 Davis Rd, Gabriola Island, BC
AD # 1025

Located on the shores of Taylor Bay - possibly Gabriola's premier beach location! - this low-bank, walk-on w/f property will delight you with it's charming 2 BR/1Bath cottage featuring a large kitchen and open concept living and dining areas.  Extensive decking on the oceanfront side of the house for sun... read more
NotSold0.00093700000000008 -->0.409101
AD #1011
Island Farmhouse B&B
185 Horel Road, Salt Spring Island, BC, V8K 2A4
AD # 1011
Open House!
Island Farmhouse is a highly successful B&B located on Salt Spring Island - the "Jewel of the Gulf Islands" and the most popular of the Gulf Islands for visitors.

This richly developed property was constructed only 6 years ago from timbers milled on the property. It includes a 2,900 sf home with 2 B&B rooms and a self contained suite... read more
NotSold0.001072 -->0.410173
AD #1109
Sportfishing Outfitter with Fly & Tackle Retail Store (Recreational)
Tofino B.C.
AD # 1109
Price Reduced!
Tofino B.C.'s Most Recommended Sport Fishing Outfitter since 1996.

Very Established Turn Key Sportfishing Business with newly renovated Fly & Tackle/Booking location in B.C's premier Marine Tourism destination.
Business includes all vessels and equipment, marketing and database, all fixtures and displays, with options to buy or lease... read more
NotSold0.001022 -->0.411195
AD #1107
Tack Store
Duncan, B.C.
Inventory + $45,000
AD # 1107
Established Tack store for Sale in Duncan In business for over 15 years.... read more
NotSold0.00097900000000006 -->0.412174
AD #1099
Ocean View Home
3808 South Island Hwy, Campbell River
AD # 1099
Price Reduced!
Ocean Front View Property for Sale

Location: 3808 South Island Highway, Campbell River, BC.
For more information, call (250)203-3935

A unique and newly renovated split level family home with spectacular ocean view is situated on a large 3/4 acre lot. With over 2,400 square feet, this home has a lot to offer any family. This spacious lot... read more
NotSold0.00090999999999997 -->0.413084
AD #1151
17 acres
8 Mackenzie Rd, 200' from trans-Can hwy beside Humming BnB, Tofino, B.C.
$2.5 Million, now reduced from $3.5 M
AD # 1151
I will sell all for $2.5 Millions. I would prefer one family that would build only 1 home or up to to 8 homes for family and friends.

Rezoning is in progress for a residential commercial ecovillage of 17 to 23 homes on the 17 acres. This land has the original, ancient, old growth forest. There are many Cedar trees over 2 feet and up to 6 feet... read more
NotSold0.00090100000000004 -->0.413985
AD #1121
18.5 acres
Pender Island, BC
$799,000 cdn
AD # 1121



18.5 Acres of Land in the Beautiful Gulf Islands. Rich soil, artesian water source, tree lot, widened in road, public road access, several out-buildings for storage & a historical fully functioning machine & welding shop. Build your private... read more
Sold0.00093599999999994 -->0.414921
AD #1026
10.15 acres
164 Pilkey Point Road, Thetis Island, British Columbia
Cdn $324,900
AD # 1026
Beautiful treed 10.15 acres (approximately 136m wide by 350m deep) on Thetis Island, a hidden gem in the Gulf Islands of British Columbia.  Wonderful ocean views to the east and to the west.  Property sits on the second highest point of land on the island.

Driveway is roughed in to a possible building site on the highest point of the property. ... read more

Sponsored Links

Omineca / Peace / Skeena Regions

NotSold0.0087130000000001 -->0.423634
AD #1143
Cabin 1.6 Acres Retail
12 Commercial Drive, Dease Lake, B.C., V0C 1L0
$299000.00 OBO
AD # 1143
1.6 Acres of prime commercial/residential
property located in the town of Dease Lake ,
B.C. There is  a gift & souvenir store and
Tourist info center currently [and since 2004]
operating here. We are retiring and want
to close the business and move south. The
property comes with a 700 sq.ft. cottage
which has been fully renovated and... read more
NotSold0.0011129999999999 -->0.424747
AD #1110
5 acres 2.56 ha (Recreational)
Takla Lake/Narrows
contact owner
AD # 1110
300 feet of water frontage with sandy/gravely beach. The property is remote but secluded for privacy and ready to move on to place your RV or a travel trailer for instant use. The property is nicely treed with road access from back of property and is located within  a gated Community of 6... read more
NotSold0.0012420000000001 -->0.425989
AD #1103
1,280 acres Ranch - Specialty Lumber Products
West of Fort St. John
Included in Total
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.001131 -->0.42712
AD #1098
3275 Bave Road, Vanderhoof BC
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.001084 -->0.428204
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.00089700000000004 -->0.429101
AD #1082
2 storey residential/commercial
421 Main St., McBride, BC
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.000973 -->0.430074
AD #1157
Restaurant -motel
5112 50th Street, Chetwynd, BC
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.001049 -->0.431123
AD #1146
Hobby Farm 62 Acres
21891 Triad Road, Prespatou BC, Canada
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.00083699999999998 -->0.43196
AD #1142
Farm/Ranch 1440 acres
Fort St. John area
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.0012800000000001 -->0.43324
AD #1076
(Home) Fully Furnished 1/2 Duplex Revenue Property
7143 Guelph Crescent, College Heights, Prince George, BC
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 $268,000. Bright spacious layout.

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

   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.0011019999999999 -->0.435361
AD #1085
Fenced Acreage and Family Home
Prince George Rural West
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


NotSold0.0021060000000001 -->0.437467
AD #314
0.28 acres (Recreational)
49-lot development, The Palms, on Serenity Road, off Consejo Road, Corozal, Belize
18,500 USD (or nearest offer). Must sell.
AD # 314
This relatively new development is a short walk inland from the beach, on higher ground. You can build the holiday home of your dreams. Choice of local builders. Corozal Town shopping is 3-5 km away by road. Mall shopping only a few minutes’ drive away, in neighbouring Mexico. In Belize, lots of nature preserves, fruit plantations & Mayan sites... read more
NotSold0.001108 -->0.438575
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.001047 -->0.439622
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.00097499999999995 -->0.440597
AD #310
840 Tarawitt, Longboat key, Fl
AD # 310
NotSold0.00085999999999997 -->0.441457
AD #309
Split Level
3805 Tamarack Ave., Whitefish, MT 59937
AD # 309
Price Reduced!
Reduced by $10K! Visit 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.00097599999999998 -->0.442433
AD #308
Block and Brick Construction (Recreational)
9060 Heckscher Drive, Jacksonville, FL, 32226
$509,500 US
AD # 308

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.0011260000000001 -->0.443559
AD #302
Condo (Recreational)
1400 Gulf Blvd #104, Clearwater Beach, FL, 33767
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.001763 -->0.445322
AD #303
922 Queen Rd, St, Augustine, Fl 32086 USA
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.00087400000000004 -->0.446196
AD #307
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.00079899999999999 -->0.446995
AD #301
Cochise County, Arizona
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

Northwestern Ontario

NotSold0.002309 -->0.449304
AD #5017
Hunting & Fishing (Recreational)
1 Cedar Shores Road, Jellicoe, ON, P0T1V0
AD # 5017
Hunting and Fishing resort near Jellicoe, Ontario. WMU 19 and 21A. 7 cabins, 8 motel units, RV sites, some seasonal guests. Owner wants to sell due to health conditions.  Very successful business for  over 25 years.  7.75 acres deeded land with 1200 ft. waterfront. Located in the heart of Greenstone Municipality. Mining interest in the area very... read more
NotSold0.00091299999999994 -->0.450217
AD #5016
25 acres. (Recreational)
Longitude, Latitude: 49.682254,-93.328514
AD # 5016
Located on Eagle Lake, in Ontario Canada, this private island is surrounded by crown land and is a one of a kind property. Viking Island is one of the few privately owned islands on Eagle Lake. Property price includes mining rights (gold location #5 on Eagle Lake). Purchased by the current owner in the 1970’s, the island is 25 acres and... read more
NotSold0.00077400000000005 -->0.450991
AD #5010
Gambrel Style 3.25 acres. (Recreational)
Longitude and latitude coordinates: 49.730634,-93.22459
AD # 5010
This beautiful lakefront property is located on Eagle Lake, in Little Neck Bay. The property has been family owned for over 30 years and the house was custom built by owner. The solidly constructed house has an open floor plan with serene waterfront views. Heated with a choice of either woodstove or electric heat, this house could be a summer... read more
Sold0.00078400000000001 -->0.451775
AD #5009
Commercial - Marina & Three-Bedroom Apartment
Keewatin (Kenora) Ontario
AD # 5009
Price Reduced!
Reason for sale: Retirement

Invest in your future, running a thriving, profitable business in a North Western Ontario resort town, only a 1 3/4 hour drive east of Winnipeg, Manitoba and 2 1/2 hours north of International Falls, Minnesota. Leave your winters free to pursue other interests.

   * 226 sheltered docking spaces with six-foot wide... read more

Sponsored Links

Ottawa Area

NotSold0.0019509999999999 -->0.453726
AD #5150
high ranch single
608 Apple Blossom Drive, Pembroke, ON, K8A 8G1
AD # 5150
located in a sought after east end neighbourhood; loads of natural light; maple hardwood in living, dining and hall; ceramic in kitchen, entry and bathroom; carpet in bedrooms;  brick on all 4 sides; fully fenced backyard; fully insulated and gas heated workshop; basement fully insulated with large fully finished family room and spacious laundry... read more
NotSold0.00088900000000003 -->0.454615
AD #5142
3037 Freshwater Way, Ottawa, ON, K2J 3V5
AD # 5142
A majestic, move-in ready home featuring elegant nine foot ceilings and hardwood floors in an ideal family neighbourhood. The large, beautifully lit kitchen includes modern, stainless steel appliances and opens into an inviting living area with fireplace and mantle -  perfect for entertaining. Upstairs, the master suite includes walk-in closets... read more
NotSold0.00082900000000008 -->0.455444
AD #5128
210' X 210' 44,100 sq ft
1116 Pembroke St East, Pembroke Ontario, K8A-7R5
AD # 5128
Open House!
                           Location! Location! Location!

                    Frontage on Highway 148 ( Green Lake Road)

                         FOR SALE OR  25 YR LEASE

Property Borders Pembroke Ontario / Laurentian Valley Twp  

Highest Traffic Area Volume
125,000 + Customer Volume Population ( Not Including Quebec Side) ... read more
NotSold0.0007839999999999 -->0.456228
AD #5121
4993 County Road 17, Alfred ON, K0B 1A0
AD # 5121
Business property, situated at the busy intersection of County Road 17 and Station Road (County Road 15) with high traffic volume between Ottawa and Montreal. Located on a spacious lot with 225 feet of frontage and 440 feet depth, this property offers great potential.  

Gas Station, Depanneur (Convenience Store), Restaurant, Auto Repair Garage... read more
NotSold0.00093800000000011 -->0.457166
AD #5094
38 Norway Lake Rd., Burnstown Ont, K0J 1G0
AD # 5094
Custom built brick country waterfront home in park like setting in the Calabogie tourist area. 10 Min from ski hill, Calabogie Highlands Golf Club and Calabogie Motorsport Race Track. This executive home offers 3 bedrooms, 3 bathrooms and finished basement with walkout onto patio with pool. The main floor is open concept with lots of windows for... read more
NotSold0.00077899999999997 -->0.457945
AD #5085
1.34 acres
Olmstead-Jeffrey Lake Rd, Haley Station, Ontario
AD # 5085
Build your dream home or get-away cottage on this very desirable, beautifully wooded lakefront property. Quiet setting great for swimming, boating, and fishing or just relaxing.

Wonderful location just 90 minutes from downtown Ottawa with year round access!

1.34 acres with 645 feet of frontage on Olmstead-Jeffrey Lake quietly located in the... read more
NotSold0.00081999999999993 -->0.458765
AD #5082
3.5 acres
John Aselford Drive, Ottawa, Ontario
On enquiry
AD # 5082
Prime building lot for sale in an exclusive community west of Ottawa. 3.5 acres (1.42 hectares) on which to build your new home in Ottawa.

The rolling hills and trees of 300 acres of protected park land surround this exclusive community in the Carp Hills just minutes west of Ottawa, Canada's capital. Enjoy the convenience of nearby... read more
Sold0.001004 -->0.459769
AD #5122
2 Storey Detached
Stittsville, Ontario
AD # 5122
Holitzner built 3 bedroom home on quiet crescent, near park & schools. Fully fenced rear yard with deck, hedge and fruit trees. Gas fireplace in good size living room, dining area has patio doors to private south facing back yard. Bright eat in kitchen with bleached oak cabinetry. Master with full ensuite and walk in closet. Finished family room... read more

Sponsored Links

Charlotte County

NotSold0.0021610000000001 -->0.46193
AD #7018
Cape Cod Craftsman
220 Glebe Road, Chamcook, NB E5B3C5
AD # 7018
Villa Verde is an archtect designed custom home in Craftsman Cape Cod style no expense spared on finishes and craftsmanship. It was finished in 2004 by an American professional couple as their dream retirement home on 2.5 acres of landscaped gardens, wildflower meadows and evergreen forest. The property has shore access and many outdoor... read more
NotSold0.00090999999999997 -->0.46284
AD #7020
Split Entrance (Business)
874 Route 730, Scotch Ridge, Charlotte Co., NB E3L 5L2
AD # 7020
House Package includes main house 28 ft x 70 ft and (Income Property or Guest House) two-storey 20 ft x 32 ft; Garage 50 ft x 80 ft (four car bays, large truck bay and wood working shop at rear of garage. Garage has operated as an auto repair and body shop business for thirty-two years. Also included is Greenhouse with benches lights, watering and... read more
NotSold0.00093699999999997 -->0.463777
AD #7015
Camppobello Island
250,000 USD
AD # 7015
For Sale By Owner:

4 prime and private acres on Campobello Island near beach and Lubec Maine. Large Log Home in excellent condition featuring the following:

   Large great room with stone fire place, vaulted and beamed ceilings, natural knotty pine     interior throughout home, 2 1/2 baths, two main bedrooms with loft sleeping area for 6... read more

Sponsored Links

Improve the Curb Appeal of Any Home

Build HierarchyQUERY
SELECT l.*, t2.* FROM cms_module_listings l JOIN cms_module_listings_prodtohier h ON = h.listing_id JOIN ( SELECT tmp.hierarchy_id,, max( listing_date ) AS max FROM ( SELECT h.hierarchy_id,, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_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 order by t2.max desc, asc, l.listing_date desc
SELECT tmp.hierarchy_id,, max( listing_date ) AS max, h.extra1 as link, count( as count FROM ( SELECT h.hierarchy_id,, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id order by max desc, asc
(published, %Canada%, published)[0][50]
query3->0.009414 -->0.020131
query3->0.008614 -->0.028745
query3->0.005999 -->0.034744
query3->0.00641 -->0.041154
query3->0.00598 -->0.047134
query3->0.005899 -->0.053033
query3->0.006499 -->0.059532
query3->0.006466 -->0.065998
query3->0.007328 -->0.073326
query3->0.007427 -->0.080753
query3->0.007978 -->0.088731
query3->0.009562 -->0.098293
query3->0.006572 -->0.104865
query3->0.007711 -->0.112576
query3->0.007206 -->0.119782
query3->0.007159 -->0.126941
query3->0.00755 -->0.134491
query3->0.006883 -->0.141374
query3->0.006664 -->0.148038
query3->0.006497 -->0.154535
query3->0.006581 -->0.161116
query3->0.008193 -->0.169309
query3->0.008356 -->0.177665
query3->0.00735 -->0.185015
query3->0.006844 -->0.191859
query3->0.006276 -->0.198135
query3->0.008215 -->0.20635
query3->0.007523 -->0.213873
query3->0.010939 -->0.224812
query3->0.007416 -->0.232228
query3->0.007328 -->0.239556
query3->0.006864 -->0.24642
query3->0.006142 -->0.252562
query3->0.006341 -->0.258903
query3->0.006991 -->0.265894
query3->0.0072540000000001 -->0.273148
query3->0.006556 -->0.279704
query3->0.008925 -->0.288629
query3->0.00778 -->0.296409
query3->0.008788 -->0.305197
query3->0.0083989999999999 -->0.313596
query3->0.006847 -->0.320443
query3->0.0081169999999999 -->0.32856
query3->0.009128 -->0.337688
query3->0.007673 -->0.345361
query3->0.008308 -->0.353669
query3->0.006189 -->0.359858
query3->0.007255 -->0.367113
query3->0.006702 -->0.373815
query3->0.006596 -->0.380411
Canadian Maple Leaves
Canadian Maple Leaves