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:00003Cats
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, %British Columbia%, published)[0][48]
query1->0.0092139999999999
Heirarchy0.0022850000000001 -->1.021433
Regions of
British Columbia
Max Ads per page:

Lower Mainland

NotSold0.0020739999999999 -->1.023507
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.016006 -->1.039513
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.001363 -->1.040876
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.001091 -->1.041967
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.001119 -->1.043086
AD #1133
GROUND CORNER UNIT
HOWIE, COQUITLAM
169000
AD # 1133
NotSold0.001309 -->1.044395
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 -->1.045865
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.0010640000000001 -->1.046929
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.001213 -->1.048142
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.001908 -->1.05005
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.0011199999999999 -->1.05117
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.0012180000000001 -->1.052388
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.001072 -->1.05346
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

Vancouver Island / Gulf Islands

NotSold0.0093270000000001 -->1.062787
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.0011169999999999 -->1.063904
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.001061 -->1.064965
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.00116 -->1.066125
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.002001 -->1.068126
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.001089 -->1.069215
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.001058 -->1.070273
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.0021019999999999 -->1.072375
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.001069 -->1.073444
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.00103 -->1.074474
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.001271 -->1.075745
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.0011260000000001 -->1.076871
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.001116 -->1.077987
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.0010709999999999 -->1.079058
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.001035 -->1.080093
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
Sold0.0010560000000001 -->1.081149
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

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

Kootenay

NotSold0.003648 -->1.084797
AD #1137
Rancher
210 Hwy 21, Creston, BC, V0B 1G2
$720,000.00
AD # 1137
This designed rural property of 11 acres is conveniently located 6 miles south of
Creston with direct access off of hwy. 21 and adjacent to the Canada/U.S. border.  The home is a very unique designed rancher with 1800 sq. ft. of planned living space with 11 exterior full glass convenience doors to maximize sunlight.  Incredible finishes and... read more
NotSold0.00108 -->1.085877
AD #1130
Country Victorian Lodge (Recreational)
8271 Trans Canada Highway, 3 Valley Gap, Revelstoke, BC
1,400,000
AD # 1130
Perhaps now would be the time to diversify your portfolio and protect yourself and your family financially by investing in a Family Retreat?

Looking for a special property that has amazing unobstructed views of Glacier covered mountains and pristine lake? A unique ("One of a kind") opportunity to those interested in a "Legacy... read more
NotSold0.00104 -->1.086917
AD #1128
160 acres
12789 West Wilson Creek Road
$9,000,000 OBO
AD # 1128
Open House!Price Reduced!
"Hidden Jewel Of The  Kootenays"

Ranch Creek Flats was Slocan Lake bottom at one time. There are no rock outcroppings on the 500 acre bench which is from 2800' - 3000' Elev. and a 10% slope, and there is topsoil classified as "sandy loam" by the surveyor in 1915. Classified "rural" it is NOT in the... read more
NotSold0.0014329999999999 -->1.08835
AD #1127
2 acres
4 mile North Shore, Nelson
300,000.00
AD # 1127
4 beautiful, private, treed acres at end of quiet cul de sac 4 miles from Nelson on the north shore... read more
NotSold0.001013 -->1.089363
AD #1126
(Home)
317 7TH Avenue, New Denver BC, V0G 1S0
248,500
AD # 1126
Price Reduced!
Located in the heart of the Slocan Valley.  A great summer retreat home for the family.  There is swimming in the lake, fishing and hiking.  The winter is known for its skidooing and close proximity to the Nakusp and Halcyon hot springs.  
Nice family home located in New Denver minutes from Slocan lake and Vahalla National Park.  
Bi Level... read more
NotSold0.001034 -->1.090397
AD #1125
Single Family
730 Nicholson Road, Golden, BC, V0A1H2
599,000
AD # 1125
Executive Home on 1.43 acres of landscape extraordinaire!
Quality finishing throughout this home with oak & white lacquered cabinets in large country kitchen with island & ceramic floors and counters. Nook with walk-outs to huge wrap around decks, hot tub, fishpond, waterfall, flowers & rock gardens galore. 4 bay 2 level garage with bonus room... read more
NotSold0.0010450000000001 -->1.091442
AD #1124
Bungalow (Recreational)
6876 Columbia Ridge Dr., Fairmont Hot Springs, BC., (Columbia Ridge Country Estates)
465,000
AD # 1124
* 3000 sq ft bungalow (1500 sq ft above ground) built in 2008
* .5 acre lot (Lot 10 – Phase 3)
* Double attached garage
* Maple hardwood flooring and tile throughout
* Maple cabinets
* Crown moulding
* Three bedrooms / two bathrooms
* Large sunny nook area with view of mountains and treed backyard
* Includes fridge, stove, microwave,... read more
NotSold0.001041 -->1.092483
AD #1116
Single Family Dwelling
5638 Cedar Creek Road, Winlaw, BC, Canada
$269,000.00
AD # 1116
Newly built, never lived in 2 bedroom 1.5 bathroom beauty comes with a 10 year new home warranty. The accommodation is all on one level, the doorways are 3 ft wide, while hallways are 4 ft making it wheel chair accessible. The home has been constructed to be energy efficient and boasts energy saving windows and in-floor heating. The home is... read more
NotSold0.00112 -->1.093603
AD #1106
19 acreage lots 1.0 hectare or 2.5 acres
Castlegar, BC
$135,000 per lot
AD # 1106
"7th Heaven" in Castlegar B.C.

This area of Western Canada is very unique in that the winters are very mild and the summers are very pleasant with excellent growing conditions. The mountains near by have a number of ski hills. Red Mountain ski area is one of the finest with all the latest skiing facilities that attract enthusiasts... read more
NotSold0.001032 -->1.094635
AD #1104
pub
1398 hartley road, golden brtish columbia, canada
499,900
AD # 1104
Open House!Price Reduced!
unique country pub for sale 10 mins west of golden...2 bedroom suite downstairs, on 2 acres of land, known for burger night, wing night and my rib dinners..2 pool tables,table, chairs, kitchen equipment, included...some decorative items will not stay...stock not included...hours of operation are sunday 11 til midnight mon tues wed thurs 10 till... read more
NotSold0.0011289999999999 -->1.095764
AD #1090
9 acres
Bowman Falls, Arrow Lake, BC
Contact owner
AD # 1090
Bowman Falls, Arrow Lakes, B.C.
Development Opportunity

Contact: John Oswald
Email:    jakoswald@gmail.com
Phone:   778 968 0161
Mail:      107  -  1065   Chesterfield  Ave.
             North  Vancouver, B.C.

The Bowman lots are ideal for four season development. Clean air and water, beautiful forests, hills and mountains provide... read more
NotSold0.001259 -->1.097023
AD #1089
80' by 284'
217 Belmond Rd, Salmo, BC, Canada
$92,500. OBO Reduced to $85,000 until the end of April
AD # 1089
Price Reduced!
Rural, paved frontage rd, 5 min drive to Salmo with schools, curling, park, groceries, post office etc, 5 min drive to local ski hill, 1/2 hr drive to Whitewater or Red Mountain ski hills, snowmobiling access close by, 5 min walk to river, you can hear it at night in bed, 12 mi to Nelway border crossing, 2 hrs to Spokane Washington, 1/2 hr to... read more
NotSold0.001271 -->1.098294
AD #1075
100 lot community development
Kootenay Lake
AD # 1075
Selling residential building lots with a spectacular southerly view of Kootenay Lake and the surrounding mountains.

Are you looking for a change in lifestyle?
This could be your view!

Grandview Properties is a 100 lot community development
offering spectacular lake and mountain views.

Fully Serviced Building Lots
Building Scheme,... read more
NotSold0.001118 -->1.099412
AD #1046
Treed with Evergreens and Fruit trees
Centreplace Rd, Krestove BC, V0G 1H0
$269,000.
AD # 1046
DO YOU ENJOY ORGANIC GARDENNING? Between Nelson and Castlegar. 400 X 160 ft. of Prime Real Estate with a beautiful view. Mostly treed with a variety of fruit and evergreen trees. Very quiet and private. May be divided. New site prep with 1993 14 X 70 Mobile Home. New metal roof and wood heater in small addition. 100 X 50 fenced garden area ideal... read more
NotSold0.0010610000000001 -->1.100473
AD #1014
(Home) (Business)
4957 Burns Avenue, CANAL FLATS, BC, V0B 1B0
$499,000
AD # 1014
Price Reduced!
4957 BURNS AVENUE, CANAL FLATS, BC:

This spectacular residence boasts over 5000 sq.ft of executive living. Featuring an in-door heated sunken swimming pool and a dream kitchen with granite counter tops, maple cabinets and top-of-the line stainless steel appliances. The 24x36' master bedroom has an exceptionally large walk-in closet with... read more
NotSold0.0010509999999999 -->1.101524
AD #1162
110.63ac
3.2km Pass Creek Road
2,900,000.00
AD # 1162
Southern Exposed property. Treed. 2 residents with stream flowing through properties. Can easily be made into a *generating electricity*.
Fertile developed gardens, fruit trees. 3 Properties adjoin a larger fish bearing creek.
Several other adjoining properties have cabins on them with monthly revenue. 10 minutes to Castlegar, 45 minutes to Red... read more
NotSold0.0013460000000001 -->1.10287
AD #1060
(Land)
Eleventh Ave. & Third Street, Castlegar, BC
$500,000.00
AD # 1060
Three fully operational business's, Jewelry store-846sq.feet quarter basement, Restaurant-1175sq.feet three-quarter basement, Clothing store-1410sq.feet full basement. In the heart of downtown Castlegar.

.it has changed and is fully rented with leases!... read more
Sold0.001016 -->1.103886
AD #1138
47 Acres
Creston, BC
$599,000.00
AD # 1138
This unique rural acreage is truly one of a kind. 47 acres with easy access off of hwy. 21, adjacent to the Canada/U.S.A. border and overlooking the state of Idaho and Miniature Mauson Lake.  It's boundaries consist of 47 acres with gentle contoured slopes of 25 + acres in grassland and balance of acreage in awesome parkland trees.  There is a... read more
Sold0.0010399999999999 -->1.104926
AD #1016
RV/Tenting/Mobile Home
Nakusp, BC
$575,000.00
AD # 1016
Price Reduced!
This is a great opportunity for group investments. Property is zoned for recreational/motel/restaurant. Located in beautiful Nakusp BC, 6.38 acres with highway frontage, minutes from downtown and the Nakusp Hot Springs.

There are 46 campsites, 26 with full service. Two sets of washrooms with coin operated showers.

A 20 X 40 swimming pool... read more

Sponsored Links

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

Debug:
REGION:00003Cats
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, %British Columbia%, published)[0][48]
query1->0.0092139999999999
query3->0.017917 -->0.043919
(34)
query3->0.02035 -->0.064269
(34)
query3->0.047394 -->0.111663
(34)
query3->0.034662 -->0.146325
(34)
query3->0.035231 -->0.181556
(34)
query3->0.029398 -->0.210954
(34)
query3->0.032186 -->0.24314
(34)
query3->0.030078 -->0.273218
(34)
query3->0.044447 -->0.317665
(34)
query3->0.040555 -->0.35822
(34)
query3->0.062994 -->0.421214
(34)
query3->0.018102 -->0.439316
(34)
query3->0.042359 -->0.481675
(34)
query3->0.038093 -->0.519768
(33)
query3->0.013056 -->0.532824
(33)
query3->0.014246 -->0.54707
(33)
query3->0.016205 -->0.563275
(33)
query3->0.014381 -->0.577656
(33)
query3->0.01526 -->0.592916
(33)
query3->0.016154 -->0.60907
(33)
query3->0.015877 -->0.624947
(33)
query3->0.017674 -->0.642621
(33)
query3->0.017032 -->0.659653
(33)
query3->0.018245 -->0.677898
(33)
query3->0.014054 -->0.691952
(33)
query3->0.014667 -->0.706619
(33)
query3->0.014819 -->0.721438
(33)
query3->0.013724 -->0.735162
(33)
query3->0.0172 -->0.752362
(33)
query3->0.012583 -->0.764945
(36)
query3->0.013788 -->0.778733
(36)
query3->0.015616 -->0.794349
(36)
query3->0.013396 -->0.807745
(36)
query3->0.01273 -->0.820475
(36)
query3->0.014763 -->0.835238
(36)
query3->0.01698 -->0.852218
(36)
query3->0.013855 -->0.866073
(36)
query3->0.013105 -->0.879178
(36)
query3->0.013619 -->0.892797
(36)
query3->0.013678 -->0.906475
(36)
query3->0.01441 -->0.920885
(36)
query3->0.01338 -->0.934265
(36)
query3->0.012823 -->0.947088
(36)
query3->0.015429 -->0.962517
(36)
query3->0.015503 -->0.97802
(36)
query3->0.014487 -->0.992507
(36)
query3->0.013631 -->1.006138
(36)
query3->0.01301 -->1.019148
(36)+
runtime(1.107233)
Canadian Maple Leaves
Canadian Maple Leaves