|
|
|
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, %Cariboo Region%, published)[0][5]
query1->0.008855
Heirarchy0.045448 -->0.696047 | | | NotSold0.00058000000000002 -->0.696627
| AD #1117 | Ranch | 3292 Widgeon Drive, William Lake, B.C. | 350 000 |
|
| Home is on Botanio Lake it is fenced and cross fenced set up or horses, round pen and barn. 4 large sized bedrooms master has walk-in closet full ensuite. 3 bedroom up and 1 bedroom down. Valted ceilings, solid oak kitchen. Open living space, beautiful views, sun room, float plane dock, secure room, hot tub. Propane heater in living room,... read more |
| Top of Page View Ad Details |
NotSold0.002945 -->0.699572
| AD #1101 | manufactured | Pyper Lake Rd, Chilanko Forks, BC | $220,000 |
|
| Over 3 acres on quiet, pristine Pyper Lake. Property has 230' of waterfrontage, which includes about 100' of private sandy beach. Mountain views. Property slopes gently to lake, SE aspect. Pyper Lake is located about 2 hours west of Williams Lake on paved Highway 20.
1996 'Moduline' manufactured home on permanent... read more |
| Top of Page View Ad Details |
NotSold0.00151 -->0.701082
| AD #1094 | 2 Storey | 2621 Spout Lake Road, Lac La Hache, BC | 299,900 |
|
| This warm and cozy cariboo two story, three bedroom, log home is situated on 40 acres of
nicely treed flat land and is surrounded by 3 sides of crown land.
With lots of trails for Horseback riding, Cross-country skiing, snowmobiling and of course
Quading...this home is less then 5 minutes to Rail Lake and only 20 minutes to Timothy... read more |
| Top of Page View Ad Details |
NotSold0.004984 -->0.706066
| AD #1079 | Log Home | 151 Chignell Road, Tatla Lake, British Columbia | $475,000 |
|
| "The Balconies" $475,000 CN
A rare opportunity to own a piece of the Chilcotin! The Chilcotin is a unique area of the British Columbia Interior with very few properties available for private ownership.
This beautiful south western facing home with acreage is centrally located in recreational paradise. Surrounded by fantastic views of... read more |
| Top of Page View Ad Details |
NotSold0.006432 -->0.712498
| AD #1108 | log and stone home | 19600 Chilcotin Hwy 20, Kleena Kleene, British Columbia | 535000 $900,000 |
|
| $535,000 Price negotiable – Open to reasonable offers
Contact James King or Brenda McFetridge
250-476-1345
http://www.ForSaleRiversEdge.blogspot.com
Custom built log and stone home is bordered by Crown land, the Klinaklini River and spectacular mountain views. Two guest cabins come fully furnished.
This property lends itself very well to the... read more |
| Top of Page View Ad Details |
| | | |
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, %Cariboo Region%, published)[0][5]
query1->0.008855
query3->0.007022 -->0.036274
(112)
query3->0.007964 -->0.044238
(112)
query3->0.022012 -->0.06625
(112)
query3->0.560574 -->0.626824
(112)
query3->0.023775 -->0.650599
(112)+
runtime(0.721836) | | | |
|
| |
