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][47]
query1->0.066269
Heirarchy0.012265 -->1.161954
Regions of
Canada
Max Ads per page:

Foreign

NotSold0.001277 -->1.163231
AD #312
Hotel Resort
San jose de la Montana, Barva,Heredia,Costarica
1700000
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.058753 -->1.221984
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.002412 -->1.224396
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.00125 -->1.225646
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.001524 -->1.22717
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.001154 -->1.228324
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.001542 -->1.229866
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.001161 -->1.231027
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.001664 -->1.232691
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.069655 -->1.302346
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.001696 -->1.304042
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.0027779999999999 -->1.30682
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.00208 -->1.3089
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.001353 -->1.310253
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.001678 -->1.311931
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.002027 -->1.313958
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.00159 -->1.315548
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.001583 -->1.317131
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.004969 -->1.3221
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.007563 -->1.329663
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.026338 -->1.356001
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.02592 -->1.381921
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.001564 -->1.383485
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.005088 -->1.388573
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.005628 -->1.394201
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.002376 -->1.396577
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.002673 -->1.39925
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.002444 -->1.401694
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.0015529999999999 -->1.403247
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.0019800000000001 -->1.405227
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.002354 -->1.407581
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.002485 -->1.410066
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.0077780000000001 -->1.417844
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.001813 -->1.419657
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.001661 -->1.421318
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.004107 -->1.425425
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.00225 -->1.427675
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.0021870000000001 -->1.429862
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.005091 -->1.434953
AD #1133
GROUND CORNER UNIT
HOWIE, COQUITLAM
169000
AD # 1133
NotSold0.0013920000000001 -->1.436345
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.001682 -->1.438027
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.001485 -->1.439512
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.0014360000000001 -->1.440948
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.0028549999999999 -->1.443803
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.00274 -->1.446543
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.001534 -->1.448077
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.002172 -->1.450249
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
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][47]
query1->0.066269
query3->0.070367 -->0.164742
(93)
query3->0.026924 -->0.191666
(93)
query3->0.008686 -->0.200352
(93)
query3->0.080769 -->0.281121
(93)
query3->0.024736 -->0.305857
(93)
query3->0.026261 -->0.332118
(93)
query3->0.033924 -->0.366042
(93)
query3->0.052277 -->0.418319
(93)
query3->0.102965 -->0.521284
(93)
query3->0.017355 -->0.538639
(28)
query3->0.01011 -->0.548749
(28)
query3->0.010485 -->0.559234
(28)
query3->0.016586 -->0.57582
(28)
query3->0.02487 -->0.60069
(28)
query3->0.010096 -->0.610786
(28)
query3->0.010821 -->0.621607
(28)
query3->0.023598 -->0.645205
(28)
query3->0.01117 -->0.656375
(28)
query3->0.033194 -->0.689569
(28)
query3->0.014021 -->0.70359
(28)
query3->0.018436 -->0.722026
(28)
query3->0.066465 -->0.788491
(96)
query3->0.012936 -->0.801427
(96)
query3->0.024385 -->0.825812
(72)
query3->0.015314 -->0.841126
(72)
query3->0.009227 -->0.850353
(72)
query3->0.015947 -->0.8663
(72)
query3->0.0137 -->0.88
(72)
query3->0.012854 -->0.892854
(72)
query3->0.020826 -->0.91368
(72)
query3->0.0699 -->0.98358
(72)
query3->0.020165 -->1.003745
(72)
query3->0.010128 -->1.013873
(107)
query3->0.022162 -->1.036035
(107)
query3->0.006574 -->1.042609
(107)
query3->0.006217 -->1.048826
(34)
query3->0.020968 -->1.069794
(34)
query3->0.007209 -->1.077003
(34)
query3->0.005661 -->1.082664
(34)
query3->0.008038 -->1.090702
(34)
query3->0.007107 -->1.097809
(34)
query3->0.007935 -->1.105744
(34)
query3->0.007034 -->1.112778
(34)
query3->0.006629 -->1.119407
(34)
query3->0.017051 -->1.136458
(34)
query3->0.006993 -->1.143451
(34)
query3->0.006238 -->1.149689
(34)+
runtime(1.455885)
Canadian Maple Leaves
Canadian Maple Leaves