|
|
|
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, %Northern Alberta%, published)[0][5]
query1->0.012887
Heirarchy0.012748 -->0.164282
|
|
Regions of
Northern Alberta | | | | NotSold0.00098100000000001 -->0.165263
| AD #2069 | side-by-side duplex | Rainbow Lake, AB | 299000 |
|
| INVESTOR ALERT!!! Having a hard time finding a revenue property that "works"? Well, THIS IS IT! This side by side duplex offers a fantastic rental income PLUS has an excellent rental history! What MORE could you ask for? Live up north and need a place to live??? No problem! Live in one side and rent out the other while PAYING OFF YOUR... read more |
| Top of Page View Ad Details |
NotSold0.004961 -->0.170224
| AD #2068 | Executive Cedar Home (Recreational) | 208 Centre Ave, Robb, Alberta Canada | $458,888.00 |
|
| Recreation or Bed and Breakfast Home in Alberta CANADA
This 3,420 sq ft Cedar Home is located in the hamlet of Robb in Yellowhead County, approximately 45 km South of Edson, Alberta. The hamlet of 400 people has a general store, hotel with restaurant, museum, a volunteer fire department and a new community hall with a curling rink. The large... read more |
| Top of Page View Ad Details |
NotSold0.011067 -->0.181291
| AD #2067 | RV Park | Box 154, Enilda, Ab, T0G 0W0 | $940,000 |
|
| This wonderful little stay at home business has been privately owned and operated since 1996. It is located on 115 acres of land which includes 30 RV sites and a Driving Range, 2 mobile home rentals and 90 acres used for haying. The RV Park is located just off of Hwy #2, 11 miles east of High Prairie in Northern Alberta.
Business has been... read more |
| Top of Page View Ad Details |
NotSold0.002275 -->0.183566
| AD #2125 | Bungalow | 65 Fitzsimmons Ave, Fort McMurray, Alberta |
|
| LOCATION, LOCATION, ETC. : PRIME INVESTMENT PROPERTY
Retiring and moving south. Rare opportunity to own and/or invest in this very desirable -one of the few- huge 18,000 sq. ft. (60' x 300' = 0.4 acre) property at the fringe of downtown in a quiet neighborhood at 65 Fitzsimmons Ave. This park-like property is fenced and fully landscaped... read more |
| Top of Page View Ad Details |
NotSold0.016331 -->0.199897
| AD #2051 | cedar log | Whitecourt, Alberta | $1,400,000 |
|
| SUPERB CANADIAN CEDAR LOG HOME
ON LAKE FRONT PROPERTY
This cedar log 3 bedroom home has spacious living area with high open beam vaulted ceilings to enjoy an abundance of natural light from the kithchen plant window and the clerestory windows in the living and dining rooms. The master bedroom also boasts an open beam ceiling.This home has a... 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, %Northern Alberta%, published)[0][5]
query1->0.012887
query3->0.015683 -->0.052271
(24)
query3->0.024783 -->0.077054
(24)
query3->0.027301 -->0.104355
(24)
query3->0.020135 -->0.12449
(24)
query3->0.027044 -->0.151534
(24)+
runtime(0.225222) | | | |
|
| |
