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, %Saskatoon Area%, published)[0][2]
query1->0.008867

Heirarchy0.048262 -->0.159488

Back!

Regions of
Saskatoon Area

Saskatoon Area (2)

Ads Found: 2

Saskatoon Area

NotSold0.000691 -->0.160179

AD #3014

Bungalow

746 Lenore Drive, Saskatoon, Sask.

393,000

Hello... I have a beautifully finished bungalow in Lawson Heights area for sale... It is 5 blocks from Lawson Heights mall and only 1 block from Meewasin trail and park.. It is 2112 Sq Ft on 2 floors and is full of oak cabinetry and trim. Big Bay window in front and Bay window with door in kitchen with access to deck. Basement is finished with... read more

Top of Page View Ad Details

Sold0.004611 -->0.16479

AD #3012

tudor style 2 storey

Saskatoon, SK

397,000

Attractive custom built 2 storey in popular Silverwood w/ quality workmanship Recent renos main- bathrm, hardwd & flrg, garden door,deck basement -rumpus room, bath & den/bdrm. Dbl garage ins.& drywalled w/ nat gas heat, sink & 220 plug. Cen.vac/air.Also features undergrnd sprinklers, large backyard w/ street access and rv parking. Walking... read more

Top of Page View Ad Details

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, %Saskatoon Area%, published)[0][2]
query1->0.008867
query3->0.014611 -->0.044001
(20)
query3->0.067225 -->0.111226
(20)+
runtime(0.175169)

Saskatoon Area

Sponsored Links