The For Sale By Owner Canada Network For Sale By Owner Canada

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, %Northwestern Ontario%, published)[0][3]
query1->0.026938
Heirarchy0.007055 -->0.164006
Regions of
Northwestern Ontario
Max Ads per page:

Northwestern Ontario

NotSold0.00279 -->0.166796
AD #5016
25 acres. (Recreational)
Longitude, Latitude: 49.682254,-93.328514
375,000
AD # 5016
Located on Eagle Lake, in Ontario Canada, this private island is surrounded by crown land and is a one of a kind property. Viking Island is one of the few privately owned islands on Eagle Lake. Property price includes mining rights (gold location #5 on Eagle Lake). Purchased by the current owner in the 1970’s, the island is 25 acres and... read more
NotSold0.02937 -->0.196166
AD #5010
Gambrel Style 3.25 acres. (Recreational)
Longitude and latitude coordinates: 49.730634,-93.22459
375,000
AD # 5010
This beautiful lakefront property is located on Eagle Lake, in Little Neck Bay. The property has been family owned for over 30 years and the house was custom built by owner. The solidly constructed house has an open floor plan with serene waterfront views. Heated with a choice of either woodstove or electric heat, this house could be a summer... read more
Sold0.004959 -->0.201125
AD #5009
Commercial - Marina & Three-Bedroom Apartment
Keewatin (Kenora) Ontario
$995,000.00
AD # 5009
Price Reduced!
Reason for sale: Retirement

Invest in your future, running a thriving, profitable business in a North Western Ontario resort town, only a 1 3/4 hour drive east of Winnipeg, Manitoba and 2 1/2 hours north of International Falls, Minnesota. Leave your winters free to pursue other interests.

   * 226 sheltered docking spaces with six-foot wide... read more

Sponsored Links

Business Valuation
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, %Northwestern Ontario%, published)[0][3]
query1->0.026938
query3->0.041079 -->0.080283
(45)
query3->0.056104 -->0.136387
(45)
query3->0.020564 -->0.156951
(45)+
runtime(0.268187)
Canadian Maple Leaves
Canadian Maple Leaves