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:00029Cats
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, %Red Deer And Area%, published)[0][4]
query1->0.014775
Heirarchy0.030694 -->0.248533
Regions of
Red Deer And Area
Max Ads per page:

Red Deer And Area

NotSold0.001363 -->0.249896
AD #2106
Bungalow 157 +/- acres
Lot 361071, Range Rd. 6-3, Clearwater County, Alberta
$875,000.00
AD # 2106
WESTCOUNTRY RANCH
Located 90 min. NW of Calgary, 157 +/- acres secluded ranch.  Tame hay, pasture, bush & yr. round, springfed creek crosses property. State of the art boiler system heats 1360 sq. ft. 2 bd. 1 1/2 bath home built in 2004, as well as 64x40 metal sided shop (inside & outside) with mezzanine which houses separate 2 bdrm, 1 bath self... read more
NotSold0.075663 -->0.325559
AD #2105
150 acres
West Central Alberta
AD # 2105
NATURE LOVER'S PARADISE!

Please visit our website for all the information on this one of a kind property and opportunity:  http://www.natureloversparadise.ca... read more
NotSold0.002768 -->0.328327
AD #2100
4-plex (1 unit)
5029 48st. Unit B, Olds AB, Canada
$205,000.00
AD # 2100
Up-graded condo unit, Teak hard-wood floors in living-room and dining area, Faux wood blinds, 5 appliances including stacked W/D and dishwasher. Bedrooms downstairs, quiet area close to down-town and Olds College. Condo fees 75.00 a month Rented at present, please phone owner for showings Beautiful tile in kitchen and entry and upstairs bathroom,... read more
Sold0.001677 -->0.330004
AD #2101
Residential Detached
Red Deer, Alberta
$418,000
AD # 2101
This home is available for immediate possession and is conveniently located near public transit. This fully fenced corner lot is located in a great neighborhood.

HOME FEATURES

MAIN FLOOR

Kitchen/Dining (14'6x19'9): Tile flooring, island with eating counter, vaulted ceiling, track lighting, ceiling fan, door to back deck, 3 sided... read more

Sponsored Links

Business Valuation
1

Debug:
REGION:00029Cats
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, %Red Deer And Area%, published)[0][4]
query1->0.014775
query3->0.029462 -->0.057622
(29)
query3->0.078159 -->0.135781
(29)
query3->0.03987 -->0.175651
(29)
query3->0.042188 -->0.217839
(29)+
runtime(0.382327)
Canadian Maple Leaves
Canadian Maple Leaves