|
|
|
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!
|
| | | | REGION:00049Cats
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, %Ottawa Area%, published)[0][6]
query1->0.027002 Heirarchy0.014197 -->0.259869 | | | NotSold0.003644 -->0.263513
| AD #5142 | Detached | 3037 Freshwater Way, Ottawa, ON, K2J 3V5 | $489,000 |
|
| A majestic, move-in ready home featuring elegant nine foot ceilings and hardwood floors in an ideal family neighbourhood. The large, beautifully lit kitchen includes modern, stainless steel appliances and opens into an inviting living area with fireplace and mantle - perfect for entertaining. Upstairs, the master suite includes walk-in closets... read more |
| Top of Page View Ad Details |
NotSold0.029817 -->0.29333
| AD #5121 | (Business) | 4993 County Road 17, Alfred ON, K0B 1A0 | 319,000 |
|
| Business property, situated at the busy intersection of County Road 17 and Station Road (County Road 15) with high traffic volume between Ottawa and Montreal. Located on a spacious lot with 225 feet of frontage and 440 feet depth, this property offers great potential.
Gas Station, Depanneur (Convenience Store), Restaurant, Auto Repair Garage... read more |
| Top of Page View Ad Details |
NotSold0.001834 -->0.295164
| AD #5094 | 2 acres (Business) | 6 Norway Lake Rd., Burnstown Ont, K0J 1G0 | $160000.00 |
|
| High profile commercial property in the Calabogie tourist area, 45 minutes from Kanata on Hwy 508, 2 acre waterfront lot with 40'x60' building with two 14 ft wide roll up doors.
400 amp electrical service, drilled well, septic system and large parking area.
Greate locatin for anyone in the tourist industry or to opperate a garage,... read more |
| Top of Page View Ad Details |
NotSold0.001208 -->0.296372
| AD #5085 | 1.34 acres | Olmstead-Jeffrey Lake Rd, Haley Station, Ontario | $144,000 |
|
| Build your dream home or get-away cottage on this very desirable, beautifully wooded lakefront property. Quiet setting great for swimming, boating, and fishing or just relaxing.
Wonderful location just 90 minutes from downtown Ottawa with year round access!
1.34 acres with 645 feet of frontage on Olmstead-Jeffrey Lake quietly located in the... read more |
| Top of Page View Ad Details |
NotSold0.001314 -->0.297686
| AD #5082 | 3.5 acres | John Aselford Drive, Ottawa, Ontario | On enquiry |
|
| Prime building lot for sale in an exclusive community west of Ottawa. 3.5 acres (1.42 hectares) on which to build your new home in Ottawa.
The rolling hills and trees of 300 acres of protected park land surround this exclusive community in the Carp Hills just minutes west of Ottawa, Canada's capital. Enjoy the convenience of nearby... read more |
| Top of Page View Ad Details |
Sold0.001749 -->0.299435
| AD #5122 | 2 Storey Detached | Stittsville, Ontario | 319900 |
|
| Holitzner built 3 bedroom home on quiet crescent, near park & schools. Fully fenced rear yard with deck, hedge and fruit trees. Gas fireplace in good size living room, dining area has patio doors to private south facing back yard. Bright eat in kitchen with bleached oak cabinetry. Master with full ensuite and walk in closet. Finished family room... read more |
| Top of Page View Ad Details |
| | | 1 |
Debug:
REGION:00049Cats
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, %Ottawa Area%, published)[0][6]
query1->0.027002
query3->0.053031 -->0.09568
(49)
query3->0.032761 -->0.128441
(49)
query3->0.023883 -->0.152324
(49)
query3->0.022235 -->0.174559
(49)
query3->0.039293 -->0.213852
(49)
query3->0.03182 -->0.245672
(49)+
runtime(0.344684) | | | |
|
| |
