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!

REGION:00052Cats
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, %Near North%, published)[0][3]
query1->0.018862
Heirarchy0.013823 -->0.111709
Regions of
Near North
Max Ads per page:

Near North

NotSold0.001033 -->0.112742
AD #5148
Cottage Resort (Recreational)
3271 Highway 11 North, Marten River Ontario, P0H1T0
$775,000.00
AD # 5148
Absolutely stunning True Northern Cottage Resort and Gift Shop! On the quiet bay of Marian Lake nestled in privacy sits 6 fully winterized gorgeous house keeping cottages with the ambiance of old world charm. Beautiful maintained, rustic wood interiors, screened porches, well appointed, and right on the waters edge to complete the package.... read more
NotSold0.020888 -->0.13363
AD #5129
Detached
201 Albert Street, Haileybury, ON , P0J 1K0
$589,000
AD # 5129
Price Reduced!
Beautiful two level home overlooking Lake Temiskaming - 500km north of Toronto. 4,000 sq. ft. on a large corner lot includes a semi-detached apartment. Great for a large family, income property or a summer home. $2,175 per month in rental income. Many nice extras including solid oak kitchen cabinets, sky lights throughout, French doors, whirlpool,... read more
NotSold0.001665 -->0.135295
AD #5127
bungalow
96 Sullivan pt. rd., RR # 1, Pembroke, Ont.K8A 6W2
148,500
AD # 5127
2 bedroom  house in a cottage setting on an island in the Ottawa river
Best of both worlds, live in the country and be 10 mins from Pembroke, 1 1/2 hr from Ottawa
year round access (bridge), Private sandy beach across the road
bonfire pit  double lot  wood/oil heat  tin roof  spring fed well
open concept updated kitchen and bathroom
asking... read more

Sponsored Links

Business Valuation
Sell Your Home in 21 Days
Improve the Curb Appeal of Any Home
1

Debug:
REGION:00052Cats
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, %Near North%, published)[0][3]
query1->0.018862
query3->0.034629 -->0.065918
(52)
query3->0.017375 -->0.083293
(52)
query3->0.014593 -->0.097886
(52)+
runtime(0.167588)
Canadian Maple Leaves
Canadian Maple Leaves