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.039394
Heirarchy0.002078 -->2.344072
Regions of
Canada
Max Ads per page:

Lakelands

NotSold0.005454 -->2.349526
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.059204 -->2.40873
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.003085 -->2.411815
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.001325 -->2.41314
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.0013650000000001 -->2.414505
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.004602 -->2.419107
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.0045489999999999 -->2.423656
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.086475 -->2.510131
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.001574 -->2.511705
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.00208 -->2.513785
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.003637 -->2.517422
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.00404 -->2.521462
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.001636 -->2.523098
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.004229 -->2.527327
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

Southeast Calgary Homes

NotSold0.007458 -->2.534785
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.002393 -->2.537178
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

Near North

NotSold0.004386 -->2.541564
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.002823 -->2.544387
AD #5100
Bungalow
676 Tillicum Bay Rd., Callander Ontario
999,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.009829 -->2.554216
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.0035280000000001 -->2.557744
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.0015339999999999 -->2.559278
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

Western Alberta

NotSold0.003733 -->2.563011
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.001542 -->2.564553
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.001337 -->2.56589
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.004247 -->2.570137
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.0043369999999999 -->2.574474
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.0015310000000001 -->2.576005
AD #2075
rural acreage 80 acres
19418 Twp Rd 530, S 1/2 Sw 5 53 19 W5
$710,000
AD # 2075
This modern energy efficient home is situated on 80 acres of subdividable, fenced, rolling field and forested land with a year round flowing creek dividing the property. There is ample graze for both horses and cattle.

A fishing lake is located on the edge of the property. The lake, which is in the north half of the quarter, has been designated... read more
NotSold0.001506 -->2.577511
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.001394 -->2.578905
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

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

York / Sunbury Counties

NotSold0.003844 -->2.582749
AD #7012
250 wooded acres (Recreational)
Noonan
$399,000.00
AD # 7012
This New Brunswick Canada property is located less than 10 miles from the capital city of Fredericton and consists of 250 acres of well forested land and an 8 acre lake presently stocked with 3 species of fish, speckled trout, rainbows, and Atlantic salmon. The property has a cottage (Lodge) of approximately 2000 sq ft facing the small lake. There... read more

Sponsored Links

Business Valuation

Vancouver Island / Gulf Islands

NotSold0.0054420000000001 -->2.588191
AD #1053
Rancher
3790 Burnside Place, Victoria, British Columbia, V8Z 7E5
603700
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.004489 -->2.59268
AD #1052
(Business)
441 Campbell Street, Tofino
$275,000
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.0023719999999999 -->2.595052
AD #1049
single family home
2121 Pioneer Hill Rd, Port McNeill, BC
199,000
AD # 1049
- Ocean view.
- Duroid roof.
- Freshly installed and painted cedar siding.
- Double pain thermo windows throughout the house.
- Large driveway with parking for RV.
- Fully enclosed shop.
- Modern open concept kitchen with movable island.
- Fenced backyard.
- Enclosed garage.
- Large deck with great sun exposure.
- Newly renovated... read more
NotSold0.0017590000000001 -->2.596811
AD #1030
Hotel/hostel/country inn (Recreational)
1165 Salmon River Main, Sayward BC V0P 1R0
575,000
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.004063 -->2.600874
AD #1029
7241 sq. ft.
1752 Meagan St, Crofton, BC, V0R 1R0
127900
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.005153 -->2.606027
AD #1028
Residential
1795 Warn Way
624000
AD # 1028
BREATHTAKING VIEWS of ocean, islands, mountains See the entire Strait of Georgia from Vancouver to Courtenay Private mountain retreat in gated community on acreage. West coast chalet just minutes to Village of Qualicum Beach, marinas, 6 golf courses & alpine skiing. Luxury home w/4 bed & 3 bath plus office & finished walk out basement, 8 acres, 4... read more
NotSold0.003383 -->2.60941
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
NotSold0.003223 -->2.612633
AD #1025
Cottage/Home (Recreational)
268 Davis Rd, Gabriola Island, BC
549,000
AD # 1025
GABRIOLA ISLAND OCEANFRONT

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.00313 -->2.615763
AD #1018
condominium
137 Bushby Street, Victoria BC V8S 1B3
$359,900
AD # 1018
Beautiful spacious condo in prime Fairfield location, on a quiet tree-lined street just one short block from Dallas Road and the ocean. Close to bus route and within walking distance of Fairfield shopping centre and Cook Street Village.

The unit is a bright corner suite that features SW exposures, recent updates to kitchen and bathrooms, new... read more
NotSold0.005153 -->2.620916
AD #1015
Family
78 Gordon Road, Lake Cowichan, VOR 2GO
$729,000
AD # 1015
Heritage home on .045 acres on Cowichan River. Original 1915 log cabin updated and modernized to 3/4 bedroom home. Original fir flooring. Cedar paneling. Electrics modernized. Cedar shake roof replaced with green metal. Kitchen opens onto river at secluded spot. Out cabin for potential rental. Prime location at bottom of big pool in Lake Cowichan.... read more
NotSold0.001793 -->2.622709
AD #1011
Island Farmhouse B&B
185 Horel Road, Salt Spring Island, BC, V8K 2A4
$795,000
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.00262 -->2.625329
AD #1109
Sportfishing Outfitter with Fly & Tackle Retail Store (Recreational)
Tofino B.C.
$595.000
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.00243 -->2.627759
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.001298 -->2.629057
AD #1099
Ocean View Home
3808 South Island Hwy, Campbell River
$468,888
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.004502 -->2.633559
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.004728 -->2.638287
AD #1121
18.5 acres
Pender Island, BC
$799,000 cdn
AD # 1121
LAND FOR SALE PENDER ISLAND, BC

LAND FOR SALE PENDER ISLAND, BC

LAND FOR SALE PENDER ISLAND, BC

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

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.039394
query3->0.072239 -->0.151536
(54)
query3->0.067167 -->0.218703
(54)
query3->0.059221 -->0.277924
(54)
query3->0.054167 -->0.332091
(54)
query3->0.044264 -->0.376355
(54)
query3->0.092127 -->0.468482
(54)
query3->0.035464 -->0.503946
(54)
query3->0.051389 -->0.555335
(108)
query3->0.025278 -->0.580613
(108)
query3->0.027168 -->0.607781
(108)
query3->0.025996 -->0.633777
(108)
query3->0.026933 -->0.66071
(95)
query3->0.090661 -->0.751371
(95)
query3->0.044714 -->0.796085
(95)
query3->0.057258 -->0.853343
(107)
query3->0.028435 -->0.881778
(107)
query3->0.037037 -->0.918815
(52)
query3->0.105044 -->1.023859
(52)
query3->0.105637 -->1.129496
(52)
query3->0.045265 -->1.174761
(52)
query3->0.054398 -->1.229159
(52)
query3->0.051536 -->1.280695
(25)
query3->0.135663 -->1.416358
(25)
query3->0.046909 -->1.463267
(25)
query3->0.040424 -->1.503691
(25)
query3->0.072203 -->1.575894
(25)
query3->0.101628 -->1.677522
(25)
query3->0.073337 -->1.750859
(25)
query3->0.057584 -->1.808443
(25)
query3->0.045591 -->1.854034
(61)
query3->0.152211 -->2.006245
(33)
query3->0.021865 -->2.02811
(33)
query3->0.020447 -->2.048557
(33)
query3->0.021044 -->2.069601
(33)
query3->0.021713 -->2.091314
(33)
query3->0.021376 -->2.11269
(33)
query3->0.023612 -->2.136302
(33)
query3->0.018556 -->2.154858
(33)
query3->0.028158 -->2.183016
(33)
query3->0.025811 -->2.208827
(33)
query3->0.021413 -->2.23024
(33)
query3->0.027743 -->2.257983
(33)
query3->0.021468 -->2.279451
(33)
query3->0.030024 -->2.309475
(33)
query3->0.016554 -->2.326029
(33)
query3->0.015965 -->2.341994
(33)+
runtime(2.642382)
Canadian Maple Leaves
Canadian Maple Leaves