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][5]
query1->0.015753
Heirarchy0.002167 -->0.126778
Regions of
Near North
Max Ads per page:

Near North

NotSold0.001724 -->0.128502
AD #5103
Cedar Open Concept (Recreational)
Island F, Callander Ontario
649000
AD # 5103
Private acres 7 Island on Lake Nipissing North Bay, ON
Helicopter pad, Float plane access,Secured sheltered boat dock.
1996 custom built cedar sided, 3 season cottage.
3 bedrooms, open concept living room, dinning room, kitchen. 4 pc bathroom, and large sunroom.
Flat screen TV, satellite, internet.
Massive deck, plus a sunrise deck, a sunset... read more
NotSold0.031638 -->0.16014
AD #5100
Bungalow
676 Tillicum Bay Rd., Callander Ontario
999,900
AD # 5100
Open House!Price Reduced!
Waterfront New 3 bedrooms, 3 bathrooms, large en-suite master bathroom. Open concept, 9ft. high ceiling, U shape kitchen, Granit conter top, large Island (10'x5') with a bar sink,and a wine frig.
6 New stainless steel appliances included.
80" flat screen TV, satellite dish, internet.
Napoleon wood burning fire place. Propane... read more
NotSold0.001823 -->0.161963
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.001353 -->0.163316
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.0014 -->0.164716
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][5]
query1->0.015753
query3->0.027928 -->0.054984
(52)
query3->0.020265 -->0.075249
(52)
query3->0.015401 -->0.09065
(52)
query3->0.016212 -->0.106862
(52)
query3->0.017749 -->0.124611
(52)+
runtime(0.195941)
Canadian Maple Leaves
Canadian Maple Leaves