|
|
|
The For Sale By Owner Canada Network 
For Sale By Owner Canada is a FSBO classified ads website.
Dedicated to people who want to advertise their Real Estate properties
for sale and save thousands of dollars in commissions upon selling!
List your Home, Business, Land or other Real Estate properties
and be assured that you have a leader, in FSBO Internet Advertising,
working to make your private sale a very rewarding experience!
|
| | | |
Build HierarchyQUERY
SELECT l.*, t2.*
FROM cms_module_listings l
JOIN cms_module_listings_prodtohier h ON 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, %Vancouver Island / Gulf Islands%, published)[0][12]
query1->0.025919
Heirarchy0.0023610000000001 -->0.204963
|
|
Regions of
Vancouver Island / Gulf Islands | | | | Vancouver Island / Gulf IslandsNotSold0.00080199999999997 -->0.205765
| AD #1028 | Residential | 1795 Warn Way | 624000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.015704 -->0.221469
| AD #1026 | 10.15 acres | 164 Pilkey Point Road, Thetis Island, British Columbia | Cdn $349,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.0027740000000001 -->0.224243
| AD #1025 | Cottage/Home (Recreational) | 268 Davis Rd, Gabriola Island, BC | 549,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.003441 -->0.227684
| AD #1018 | condominium | 137 Bushby Street, Victoria BC V8S 1B3 | $359,900 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001857 -->0.229541
| AD #1015 | Family | 78 Gordon Road, Lake Cowichan, VOR 2GO | $729,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.002065 -->0.231606
| AD #1011 | Island Farmhouse B&B | 185 Horel Road, Salt Spring Island, BC, V8K 2A4 | $795,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.003346 -->0.234952
| AD #1109 | Sportfishing Outfitter with Fly & Tackle Retail Store (Recreational) | Tofino B.C. | $595.000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.004364 -->0.239316 NotSold0.005711 -->0.245027
| AD #1099 | Ocean View Home | 3808 South Island Hwy, Campbell River | $468,888 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.006246 -->0.251273
| AD #1012 | Residential (Business) | Pender Island, Canada | $349.900.00 |
|
| Purchase this property and enjoy the income from a B&B or purchase it as your personal residential home, your choice!
Property $69K well below assessment vlaue. + self contained non conforming 1BR, den,kitchen,lounge and bathroom basement suite.
Pender Island is situated on the West Coast of British Columbia which offers a warm winter climate.... read more |
| Top of Page View Ad Details |
NotSold0.006679 -->0.257952
| 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 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.00557 -->0.263522
| AD #1121 | 18.5 acres | Pender Island, BC | $799,000 cdn |
|
| 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 |
| Top of Page View Ad Details |
| | | 1 |
Debug:
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, %Vancouver Island / Gulf Islands%, published)[0][12]
query1->0.025919
query3->0.036508 -->0.087701
(33)
query3->0.013495 -->0.101196
(33)
query3->0.011149 -->0.112345
(33)
query3->0.012191 -->0.124536
(33)
query3->0.010631 -->0.135167
(33)
query3->0.0095540000000001 -->0.144721
(33)
query3->0.0098469999999999 -->0.154568
(33)
query3->0.008409 -->0.162977
(33)
query3->0.011145 -->0.174122
(33)
query3->0.010921 -->0.185043
(33)
query3->0.009555 -->0.194598
(33)
query3->0.008004 -->0.202602
(33)+
runtime(0.312206) | | | |
|
| |
