|
|
|
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!
|
| | | | REGION:00110Cats
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, %Outside Of Calgary Business / Land / Other%, published)[0][5]
query1->0.013957 Heirarchy0.008542 -->0.129645
|
|
Regions of
Outside Of Calgary Business / Land / Other | | | | Outside Of Calgary Business / Land / OtherNotSold0.000889 -->0.130534
| AD #2015 | 64 acres | Bragg Creek, Alberta | 2500000.00 |
|
| Sixty four gorgeous acres for sale located off hi way 66 in Bragg Creek, Alta. This property offers unlimited potential for a subdivision, resort, get-away cabins or your very own dream home. With already established gas, power and telephone lines on the property. It is close to Kananaskas Country, a great place to go hiking site seeing or... read more |
| Top of Page View Ad Details |
NotSold0.021206 -->0.15174
| AD #2011 | 10.03 ACRES | 44111 WEEDON TRAIL, ROCKYVIEW COUNTY, COCHRANE ALBERTA | $548,000 |
|
| Rare 10 acres mountain view, on paved road, breath taking views 360 degrees, 40 minutes to downtown Calgary and 10 minutes to Cochrane. Well drilled. Shared paved approach. County reserve fees paid up. Septic field approved. Land slopes allow a fabulous walkout development. Paved road plowed in winter by County. ... read more |
| Top of Page View Ad Details |
NotSold0.002658 -->0.154398
| AD #2024 | 5.51000 Acres | East of Okotoks overpass, on h-way 552( 5 miles) , turn left on 80th st. | 390,000 |
|
| This Raw land parcel is located just 5 miles east of Okotoks overpass,turn left on 80th st.(north),3rd acreage on right hand side. Mountain views,services to property line,good well(well report avail.)minutes to Heritage Heights k-9 school, Rec centre is to be built nearby,close to 3 golf courses,minutes to Deerfoot Trail and City... read more |
| Top of Page View Ad Details |
NotSold0.001503 -->0.155901
| AD #2023 | 10 Acres | Next to Elkana Estates, Bragg Creek | $729000 |
|
| Mostly treed south facing slope with two elevated buidling sites. Power, gas and phone installed to property line. ... read more |
| Top of Page View Ad Details |
NotSold0.00235 -->0.158251
| AD #2009 | 15 acres | sw1/4 sec16 twp23 r5 w5 | $ 750,000.00 |
|
| Property situated 5km west of Bragg Creek. Property abuts Bragg Creek on north side . Property has unobstructed mountain views. Power,telephone, well &septic feild, Zoned R3 with possibility of subdivision. Excellent access to property on all weather maintained MD road Adjacent property to the east is 20 acre equestrian ranch, to north and west... read more |
| Top of Page View Ad Details |
| | | 1 |
Debug:
REGION:00110Cats
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, %Outside Of Calgary Business / Land / Other%, published)[0][5]
query1->0.013957
query3->0.016788 -->0.045059
(110)
query3->0.021611 -->0.06667
(110)
query3->0.016966 -->0.083636
(110)
query3->0.020145 -->0.103781
(110)
query3->0.017322 -->0.121103
(110)+
runtime(0.194047) | | | |
|
| |
