|
|
|
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, %Western Alberta%, published)[0][8]
query1->0.016863
Heirarchy0.005984 -->0.371985
|
|
Regions of
Western Alberta | | | | NotSold0.00067099999999998 -->0.372656
| AD #2092 | +/- 3 acres | NE 8-32-2w5m | $204,900. |
|
| Buy now, be ready to build in the spring!
The perfect Alberta view; agriculture, oil and the beloved Rocky Mountains can be seen from this acreage just minutes from Olds or Didsbury. The three acre parcel is serviced with power and water well. The location preserves the peace and quiet of rural living while being situated eight miles west of... read more |
| Top of Page View Ad Details |
NotSold0.009472 -->0.382128
| AD #2089 | Log Cabin | 213 Grouse Meadow Lane, Nordegg, Alberta | $725,000 |
|
| This beautiful log cabin sits on five acres situated at the base of Coliseum Mtn and Baldy Mtn. Nordegg is perfectly located between Lake Louise and Rocky Mountain House with either location just a scenic drive away. The cabin is finished inside with over 1900 sq ft spread across two floors of the house, while the master bedroom encompasses 300 sq... read more |
| Top of Page View Ad Details |
NotSold0.0046349999999999 -->0.386763
| AD #2088 | 163 acres | Clearwater County, on Hwy 11, @ Range Road 5-5 | 350,000 |
|
| Farm Land For Sale – SW5-39-5W5M
$350,000
Mountain view.
Full quarter section (163.3 acres) on Hwy 11 20 km E of Rocky Mountain House.
2 accesses off Range Road 5-5.
Game fence around entire perimeter and cross-fenced.
70 acres hay, 70 acres pasture, 20 acres trees.
Spring fed water supply.
Oil & Gas Revenue $3700/yr.
Buyer could... read more |
| Top of Page View Ad Details |
NotSold0.002861 -->0.389624
| AD #2055 | 163 acres | Clearwater County, on Range Rd 6-0, 1.5 miles N of Hwy 11 | 189,000 |
|
| Farm Land For Sale – SE12-39-6W5M
$189,000
Mountain view.
Full quarter section (162.93 acres) 1.5 mile N of Hwy 11 on Range Road 6-0 approx 18 km east of Rocky Mountain House.
Pasture / recreational. Cleared and broke and seeded to grass 1981-1982.
Access off secondary Range Road 6-0.
5-strand high tensile steel perimeter fence.... read more |
| Top of Page View Ad Details |
NotSold0.0035470000000001 -->0.393171
| AD #2035 | Acreage | 212 Clearwater Heights Place, 7 miles west of Caroline | $365000.00 |
|
| Beautifully located raised bungalow on 1.23 acres in the West Country 7 miles West of Caroline. Situated just 10 minutes from the foothills of the Rockies, this home could be a bed and breakfast, a family get-a-way spot or a family home. With Alford creek running just out back for fishing or just for the kids to play in during those summer days.... read more |
| Top of Page View Ad Details |
NotSold0.004625 -->0.397796
| AD #2075 | rural acreage 80 acres | 19418 Twp Rd 530, S 1/2 Sw 5 53 19 W5 | $710,000 |
|
| This modern energy efficient home is situated on 80 acres of subdividable, fenced, rolling field and forested land with a year round flowing creek dividing the property. There is ample graze for both horses and cattle.
A fishing lake is located on the edge of the property. The lake, which is in the north half of the quarter, has been designated... read more |
| Top of Page View Ad Details |
NotSold0.0047619999999999 -->0.402558
| AD #2028 | 4.25 acres (Recreational) | RR7-2B (#7-Alford Creek Road), Lot 2, Plan 002-4614, sw1/4, sec5, 36-7-5 | $197,000.00 |
|
| This 4.25 acres of parklike property is ready for your Cabin or Home. 17 ft. RV dual axle unit could stay. 13 km's West of Caroline on Hwy 54, / becomes Hwy 591. Fully serviced and fenced, 2 plus acres fully cleared. Ready to use power, water, and septic. 1000 gal holding tank and pressurized septic field. Includes 16 x 64 gravel pad for... read more |
| Top of Page View Ad Details |
Sold0.0035890000000001 -->0.406147
| AD #2050 | |
| SOLD Gorgeous location in west country, only 2km of gravel on a no-exit road. Minutes to amazing trails & crown land, with springs & lakes (great hiking, biking, fishing, quadding, snowmobiling, tobogganing, picnic/bonfires right from your doorstep), just 3min to Clearwater Store, 10min to Phyllis Lake, 7min to Caroline, 10min to Burntstick Lake, 15min... 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, %Western Alberta%, published)[0][8]
query1->0.016863
query3->0.02857 -->0.067126
(25)
query3->0.019817 -->0.086943
(25)
query3->0.01948 -->0.106423
(25)
query3->0.019133 -->0.125556
(25)
query3->0.015822 -->0.141378
(25)
query3->0.199517 -->0.340895
(25)
query3->0.013084 -->0.353979
(25)
query3->0.012022 -->0.366001
(25)+
runtime(0.435171) | | | |
|
| |
