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][46]
query1->0.027374
Heirarchy0.020021 -->2.05768
Regions of
Canada
Max Ads per page:

Quebec City / Charlevoix / Chaudiere-Appalaches

NotSold0.001304 -->2.058984
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.04542 -->2.104404
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.03224 -->2.136644
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.001709 -->2.138353
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.001476 -->2.139829
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.001635 -->2.141464
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.001261 -->2.142725
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.001252 -->2.143977
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.001224 -->2.145201
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.001635 -->2.146836
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.001862 -->2.148698
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.003735 -->2.152433
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.001433 -->2.153866
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.001324 -->2.15519
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

Lower Mainland

NotSold0.006865 -->2.162055
AD #1144
Single family with suites
6388 167 street, Surrey, BC, V3S0W5
720000
AD # 1144
Here it is! HUGE 4,409 sq ft 2 storey with finished basement in West Cloverdale on a big 6749 sq ft corner lot! 8 bedrooms, 5 bathrooms, and two 2 bedroom suites (only 1 rented)! Traditional layout living/dining room + kitchen w/big eating area, spice kitchen and great room w/soaring ceiling to upstairs, laundry on main. 4 big bedrooms upstairs,... read more
NotSold0.001485 -->2.16354
AD #1140
Townhouse
19 - 2418 Avon Place, Port Coquitlam, BC, Canada V3B0C7
395,000
AD # 1140
Open House!
LINKS by Mosaic. Steps from: Carnoustie Golf & Country Club, Costco, Save on Foods,
Terry Fox Secondary, Archibishop Carney Secondary, Blakeburn Elementary, Fremont
Village, Walmart, Canadian Tire, Royal Bank, TD Bank, CIBC and many shopping stores.

Great view overlooking courtyard with a peek-a-boo view of the mountain. Bedroom with... read more
NotSold0.001307 -->2.164847
AD #1139
Townhome
210-1174 Wingtip Place, Squamish, BC
352,600
AD # 1139
Open House!
Independent buyers without agents are welcome. Lease-to-Buy (rent-to-own) option
is also possible for a qualified buyer.

This modern, lovingly maintained townhome is part of the original and tranquil
section of Eaglewind known as Talon. Friendly, quiet neighbours add to the joy
of living here. The two-story unit overlooks a large greenbelt,... read more
NotSold0.004914 -->2.169761
AD #1135
Single Family Home
4312 Rumble Street, Burnaby BC
988888
AD # 1135
GREAT SOUTH SLOPE LOCATION - OVER 10,000 SQ. FT LOT

Solid Rancher With Fully developed basement

Extra Large 89 X 113 Corner Lot With View

Extensively remodelled

3380 Total Square Footage

R - 2 Zoning Allowing over 4,700 SQ. FT. New Home

Solid Rancher with full basement on extra large corner lot close to Metrotown, Skytrain and... read more
NotSold0.001307 -->2.171068
AD #1133
GROUND CORNER UNIT
HOWIE, COQUITLAM
169000
AD # 1133
NotSold0.001153 -->2.172221
AD #1122
Condo
#1204-555 Delestre Avenue, Coquitlam, BC
410000$
AD # 1122
Beautiful . 2 bdrm., 2 full baths + den corner unit. Floor to ceiling windows. Excellent floor plan. Quality finishings, granite counters, stainless appliances. 2  parking stalls & storage locker. Walking distance to skytrain, shopping & all amenities. Easy access to SFU. Very good unit rarely available.
... read more
NotSold0.00147 -->2.173691
AD #1113
3.89 acres (Recreational)
2939 Stanley Rd., Pemberton, BC (Birken)
$219,000
AD # 1113
** Motivated Seller **


http://birkenproperty.com
Own Your Piece of Paradise near Whistler and Pemberton!
Ever dreamed about living a simple life in the country with fresh air, stunning views, rich soil for growing a garden, fishing, snowmobiling on your doorstep yet close enough to the city for occasional urban experiences like shopping,... read more
NotSold0.001317 -->2.175008
AD #1111
Detached
18410 68th Avenue, Cloverdale, BC
559,000
AD # 1111
1st time on the market!

Don't miss out on this wonderful Parklane built home fronting the Heartlands development in Cloverdale.

The home features 4 bedrooms up and another in the basement with a great open design on the main floor with the kitchen and eating area flowing into the sunken great room, plus a separate dining room or a space... read more
NotSold0.001566 -->2.176574
AD #1074
Apartment/Condo
#325-12873 Railway Ave., Richmond, B.C., V7E 6K3
528,000.-
AD # 1074
Price Reduced!
This 1284sf condo is very spacious inside. When you enter the suite, the dining area and living room area is huge. The living room features a gas fireplace and vaulted ceilings. To the left as you enter is the kitchen, with enough space for a breakfast eating nook. The kitchen has a mirrored back splash. To the right is the master bedroom and... read more
NotSold0.003052 -->2.179626
AD #1068
Mobile w/lot
#29-3931 198 St., Langley, BC, V3A 1C9
161,900
AD # 1068
What a great place to live!  A lovely 55+ park that is well run and maintained, situated in a quiet residential neighbourhood in the Brookswood area of Langley.  There is no pad rental since you OWN A SHARE OF THE PARK, so it will never be sold out from under you.  

You have only to move in, the home itself is totally renovated from the studs... read more
NotSold0.001504 -->2.18113
AD #1021
Housing Development
District of North Vancouver
AD # 1021
Price Reduced!
North Vancouver (District) B.C.
MLS# V878754

Low Density Multi-Family housing Development LAND For Sale
Priced at $1,999,000
suitable for 0.8 fsr ( floor space ratio) on approval of district North Vancouver, when combined with adjacent property, or build a Triplex at 0.5 fsr without adjacent property.


Land offered is easy to build, ... read more
Sold0.0014 -->2.18253
AD #1072
Condominium
Burnaby, BC
$358,000.00
AD # 1072
SOLD! for $350,000.00!!!!

This beautiful one bedroom condo at Centre Point is perfectly situated in the heart of Burnaby's Metrotown.  Just below is Best Buy, Shoppers Drug Mart, Moores Mens Wear and Starbucks, but across the built-in walkway over Kingsway is Metrotown, one of western Canada's largest malls.  Commuting is very... read more
Sold0.001261 -->2.183791
AD #1065
Geodesic Dome Hybrid
Abbotsford BC
335,500
AD # 1065
This delightful 1550 sq ft. house features 2 bedrooms with an office loft that can be converted to a bedroom, if desired. A large living room features a 17 foot high ceiling and feels pleasantly spacious. Also contains 1 full bathroom upstairs, 1/2 bath on main, dining room and kitchen, laundry utility room and loads of storage space. New flooring... read more

Sponsored Links

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

Lakelands

NotSold0.003741 -->2.187532
AD #5034
custom
14 Dent Rock Crescent, Carling Township, Ontario, P0G 1G0
800,000
AD # 5034
Georgian Bay waterfront.
Exclusive drive to on private road shared by 4 residences
Custom built home featuring over 2300 square feet above ground with the following features:
- open concept living.
- custom kitchen.
- 4 piece washroom off master bedroom overlooks Georgian Bay.
- heat pump.
- 2 level wrap around deck with hot tub.
- 350... read more
NotSold0.001547 -->2.189079
AD #5031
Log
Hwy 540 W, North Channel-Lake Huron, Gore Bay ON P0P 1H0
$649,000 CAD or $607,000 USD
AD # 5031
Custom designed log home with all modern conveniences. 3,400 sq ft, 4 bedrooms, 3 baths, a large living room, family room with stone fireplace, loft, open concept kitchen and dining area with cathedral ceilings, double garage. Beautiful waterfront home with mature forest privacy. 2 miles from downtown Gore Bay and 7 miles from the Gore... read more
NotSold0.001299 -->2.190378
AD #5028
ranch loft (Recreational)
M561 concession lot 3, cognashene, georgian bay on
625,000
AD # 5028
Sunset views of Georgian Bay from secluded harbour. New boat access cottage perfect for small family or empty nesters. Unique beach house design with lots of light. Approved plans for expansion available. No boat traffic. Close to open water yet accessible in any weather. 1200 foot shoreline. 10 miles north of Honey Harbour in spectacular north... read more
NotSold0.001363 -->2.191741
AD #5027
Frame
1185 Conc 6 N, Nottawasaga, Clearview , (rural Collingwood/Stayner)
1,250,000
AD # 5027
A fully renovated 1850's farmhouse. See our website at: http://1185conc6n.com ... read more
NotSold0.001398 -->2.193139
AD #5021
13.5 acres
6 km west of Barrie, Ontario
$349,000
AD # 5021
Investment Property - 13.5 acres located 6 km west of Barrie Ontario.

Property has a creek running through it.

Call for more information!... read more
NotSold0.001204 -->2.194343
AD #5037
bungalow
rr#4 Grey-Bruce region, Ontario
189,000
159,000
AD # 5037
Two-bedroom brick bungalow overlooking field on approx. 9 acres, with additional large building (built around an original stone barn foundation, includes large fieldstone fireplace) that can be renovated into a work space, storage or whatever you envision. Brick bungalow features floor to ceiling windows that face the field. Tree lined drive and... read more
Sold0.001244 -->2.195587
AD #5025
335 Acres
Sandfield Township
$350,000 Cdn
AD # 5025
SOLD
A unique block of property offering an interesting opportunity for the right person. Family owned for more than 100 years, it consists of Lots 11, 12, 13 and 14, Sandfield Township, District of Manitoulin. With a total of 335 acres, the 5280 feet of frontage along the road provides road, electrical power and telephone access to each lot. Each of... read more

Sponsored Links

Business Valuation
Sell Your Home in 21 Days

Outside Of Calgary Homes

NotSold0.003338 -->2.198925
AD #2010
Back Split
19 Maple Pl., Crossfield Ab.
$456,000
AD # 2010
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.002272 -->2.201197
AD #2007
Two storey
30 Tiller Place SE, Airdrie, Alberta, T4A 1S6
$459,000
AD # 2007
This home has nothing but space and is located in a quiet cul-de-sac. The yard has lots of trees and privacy, just beyond the alley is a green belt with a walking path.

When you enter this home you will see the sweeping staircase and the large living room with west facing windows and a vaulted ceiling. The living room opens up into the formal... read more
NotSold0.001526 -->2.202723
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.007132 -->2.209855
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

Estrie / Monteregie / Centre-du-Quebec

NotSold0.002885 -->2.21274
AD #6011
residential
151, rue Principale, Lambton, Qc, G0M 1H0
AD # 6011
At Lambton village, by the beautiful Saint-François Lake (21 km), Province of Quebec, Canada
On this property the future buyer can have multiple projects:

• Retirement
• Family
• Commercial purposes
• B & B and the like

The main house is situated at the center of the village and was built in 1959.  An original blacksmith shop... read more
NotSold0.001616 -->2.214356
AD #6009
125 acres
7040 Chem Blanchette, Sherbrooke Quebec
Auction
AD # 6009
SHERBROOKE AREA, EASTERN TOWNSHIP, LAKE MAGOG
Beautiful lake side property on Lake Magog (33 meters wide on the lake).
Offering a superb view on Mont-Orford; sold with exceptionnal 125 acres wooded estate;
also sold with main home located at 7040 Chemin Blanchette.
These properties are for sale together, though separate purchase offers can be... read more
NotSold0.001431 -->2.215787
AD #6008
200 ft. by 1000 ft
municipality of Saint Romain, Quebec
$70,000.00
AD # 6008
Land for sale

Sizable lot defined by asphalted road, front of property, and by the romaine river, back of property. 200 ft. wide by 1000 ft long. There is also a small creek on this property, leading to the river. This property can be divided into 4 smaller lots of 44000 square feet or entirely develop for one owner.

This property is... read more

Sponsored Links

Business Valuation

Near North

NotSold0.004133 -->2.21992
AD #5103
Cedar Open Concept (Recreational)
Island F, Callander Ontario
649000
AD # 5103
Private acres 7 Island on Lake Nipissing North Bay, ON
Helicopter pad, Float plane access,Secured sheltered boat dock.
1996 custom built cedar sided, 3 season cottage.
3 bedrooms, open concept living room, dinning room, kitchen. 4 pc bathroom, and large sunroom.
Flat screen TV, satellite, internet.
Massive deck, plus a sunrise deck, a sunset... read more
NotSold0.003297 -->2.223217
AD #5100
Bungalow
676 Tillicum Bay Rd., Callander Ontario
979,900
AD # 5100
Open House!Price Reduced!
Waterfront New 3 bedrooms, 3 bathrooms, large en-suite master bathroom. Open concept, 9ft. high ceiling, U shape kitchen, Granit conter top, large Island (10'x5') with a bar sink,and a wine frig.
6 New stainless steel appliances included.
80" flat screen TV, satellite dish, internet.
Napoleon wood burning fire place. Propane... read more
NotSold0.002097 -->2.225314
AD #5148
Cottage Resort (Recreational)
3271 Highway 11 North, Marten River Ontario, P0H1T0
$775,000.00
AD # 5148
Absolutely stunning True Northern Cottage Resort and Gift Shop! On the quiet bay of Marian Lake nestled in privacy sits 6 fully winterized gorgeous house keeping cottages with the ambiance of old world charm. Beautiful maintained, rustic wood interiors, screened porches, well appointed, and right on the waters edge to complete the package.... read more
NotSold0.001465 -->2.226779
AD #5129
Detached
201 Albert Street, Haileybury, ON , P0J 1K0
$589,000
AD # 5129
Price Reduced!
Beautiful two level home overlooking Lake Temiskaming - 500km north of Toronto. 4,000 sq. ft. on a large corner lot includes a semi-detached apartment. Great for a large family, income property or a summer home. $2,175 per month in rental income. Many nice extras including solid oak kitchen cabinets, sky lights throughout, French doors, whirlpool,... read more
NotSold0.001249 -->2.228028
AD #5127
bungalow
96 Sullivan pt. rd., RR # 1, Pembroke, Ont.K8A 6W2
148,500
AD # 5127
2 bedroom  house in a cottage setting on an island in the Ottawa river
Best of both worlds, live in the country and be 10 mins from Pembroke, 1 1/2 hr from Ottawa
year round access (bridge), Private sandy beach across the road
bonfire pit  double lot  wood/oil heat  tin roof  spring fed well
open concept updated kitchen and bathroom
asking... read more

Sponsored Links

Business Valuation
Sell Your Home in 21 Days
Improve the Curb Appeal of Any Home
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][46]
query1->0.027374
query3->0.045332 -->0.102173
(96)
query3->0.049085 -->0.151258
(96)
query3->0.042736 -->0.193994
(72)
query3->0.0422 -->0.236194
(72)
query3->0.034388 -->0.270582
(72)
query3->0.038529 -->0.309111
(72)
query3->0.017403 -->0.326514
(72)
query3->0.039585 -->0.366099
(72)
query3->0.015856 -->0.381955
(72)
query3->0.034473 -->0.416428
(72)
query3->0.047716 -->0.464144
(72)
query3->0.04691 -->0.511054
(107)
query3->0.106425 -->0.617479
(107)
query3->0.099817 -->0.717296
(107)
query3->0.057318 -->0.774614
(34)
query3->0.032207 -->0.806821
(34)
query3->0.029674 -->0.836495
(34)
query3->0.038284 -->0.874779
(34)
query3->0.028223 -->0.903002
(34)
query3->0.026338 -->0.92934
(34)
query3->0.044077 -->0.973417
(34)
query3->0.036166 -->1.009583
(34)
query3->0.043111 -->1.052694
(34)
query3->0.039955 -->1.092649
(34)
query3->0.063441 -->1.15609
(34)
query3->0.018967 -->1.175057
(34)
query3->0.042417 -->1.217474
(34)
query3->0.033402 -->1.250876
(54)
query3->0.017876 -->1.268752
(54)
query3->0.015704 -->1.284456
(54)
query3->0.040229 -->1.324685
(54)
query3->0.031505 -->1.35619
(54)
query3->0.072285 -->1.428475
(54)
query3->0.016455 -->1.44493
(54)
query3->0.046249 -->1.491179
(108)
query3->0.139838 -->1.631017
(108)
query3->0.059811 -->1.690828
(108)
query3->0.029388 -->1.720216
(108)
query3->0.046993 -->1.767209
(95)
query3->0.015876 -->1.783085
(95)
query3->0.054677 -->1.837762
(95)
query3->0.041423 -->1.879185
(52)
query3->0.016653 -->1.895838
(52)
query3->0.068088 -->1.963926
(52)
query3->0.026744 -->1.99067
(52)
query3->0.046989 -->2.037659
(52)+
runtime(2.231401)
Canadian Maple Leaves
Canadian Maple Leaves