|
|
|
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, %Lakelands%, published)[0][5]
query1->0.013701
Heirarchy0.008074 -->0.179564 | | | NotSold0.0021639999999999 -->0.181728
| AD #5028 | ranch loft (Recreational) | M561 concession lot 3, cognashene, georgian bay on | 625,000 |
|
| Sunset views of Georgian Bay from secluded harbour. New boat access cottage perfect for small family or empty nesters. Unique beach house design with lots of light. Approved plans for expansion available. No boat traffic. Close to open water yet accessible in any weather. 1200 foot shoreline. 10 miles north of Honey Harbour in spectacular north... read more |
| Top of Page View Ad Details |
NotSold0.00664 -->0.188368 NotSold0.002063 -->0.190431
| AD #5021 | 13.5 acres | 6 km west of Barrie, Ontario | $349,000 |
|
| Investment Property - 13.5 acres located 6 km west of Barrie Ontario.
Property has a creek running through it.
Call for more information!... read more |
| Top of Page View Ad Details |
NotSold0.004344 -->0.194775
| AD #5019 | Auto Body Shop | 891 Gustavus St, Port Elgin, Ontario | $475,000.00 |
|
| Lot Size - 2.6 acres
Zoning - Hwy Commerical
Inclusions - Building, business and equipment including approximately $50,000 in equipment, and $13,000. in inventory.
Exclusions - 2011 Chev Suburban, 2003 JDJ dump trailer, owners personal tools, lap top computer, smallest wooden shed and 2004 Kubota lawn tractor w snow blower
Prefer to sell as... read more |
| Top of Page View Ad Details |
Sold0.00579 -->0.200565
| AD #5025 | 335 Acres | Sandfield Township | $350,000 Cdn |
|
| SOLD A unique block of property offering an interesting opportunity for the right person. Family owned for more than 100 years, it consists of Lots 11, 12, 13 and 14, Sandfield Township, District of Manitoulin. With a total of 335 acres, the 5280 feet of frontage along the road provides road, electrical power and telephone access to each lot. Each of... 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, %Lakelands%, published)[0][5]
query1->0.013701
query3->0.022081 -->0.057746
(54)
query3->0.030177 -->0.087923
(54)
query3->0.021949 -->0.109872
(54)
query3->0.03993 -->0.149802
(54)
query3->0.021688 -->0.17149
(54)+
runtime(0.210965) | | | |
|
| |
