|
|
|
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, %Sault Ste Marie Area%, published)[0][7]
query1->0.013906
Heirarchy0.001985 -->0.154154
|
|
Regions of
Sault Ste Marie Area | | | | NotSold0.00060399999999999 -->0.154758
| AD #5147 | Ranch | 2240 F&G Line, RR# 2 , Richards Landing, St Joseph Island, Ontario | $319,900.00 |
|
| Located on beautiful St. Joseph Island this like new custom built home is only forty kilometres east of Sault Ste. Marie via 4 Lane Hwy.
All interior cabinets in the home have been custom made by Island Enterprises. The spacious kitchen features maple cabinets which are highlighted by Black Galaxy granite countertops. The built in china... read more |
| Top of Page View Ad Details |
NotSold0.004855 -->0.159613
| AD #5146 | Waterfront Ranch | 50 Bruce Bay Raod, Bruce Mines, Ontario, Canada | $254,900.00 |
|
| WATERFRONT
A lovely waterfront home in the town of Bruce Mines, 40 minutes from Sault St. Marie, overlooking Bruce Bay and the gateway to the North Channel of Lake Huron. Magnificent sunrises with a private deck, lovely courtyard with a varity of perennials on the property. A perfect home for entertaining,... read more |
| Top of Page View Ad Details |
NotSold0.002329 -->0.161942
| AD #5140 | Hi- rise bungalow | East End, Sault Ste. Marie |
|
| Custom built high-rise brick bungalow, with attached garage. Two 4pc bathrooms, and hardwood and ceramics throughout. An energy efficient home, with a habitar air-exchanger.
Low maintainence Eco-Lawn.
Move in ready, a must see.
... read more |
| Top of Page View Ad Details |
NotSold0.007389 -->0.169331
| AD #5139 | COMMERCIAL ACREAGE (Land) (Business) | 898 HIGHWAY 17 NORTH, SAULT STE MARIE ONTARIO | $150,000.00 |
|
| PERFECT LOCATION FOR HIGHWAY BUSINESS
THIS PARCEL OF LAND CONSISTS OF 3 ACRES WITH 300 FT OF HIGHWAY FRONTAGE LOCATED JUST 2 MILES FROM CITY LIMITS AND 11 MILES FROM CITY OF SAULT STE MARIE ONTARIO.
THIS LOT IS SITUATED ON A STRAIGHT AWAY SECTION OF THE TRANS CANADA HIGHWAY NORTH ALLOWING SAFE AND EASY ACCESS TO PROPERTY.
LOT IS ALSO... read more |
| Top of Page View Ad Details |
NotSold0.004223 -->0.173554
| AD #5138 | Hand Crafted Timber Framed (Recreational) | Lake Matinenda, Blind River, Ontario | $495,000.00 |
|
| Our water front handcrafted Timber Framed home/cottage is truely unique. Overwhelming views of Lake Matinenda from almost every room, with 490ft. of shore line.
-Ensuite bath with therapeutic tub, granite flooring.
-Granite kitchen counters and table.
-Satellite internet, T.V., cell phone service Solar powered with generator back up, propane... read more |
| Top of Page View Ad Details |
NotSold0.001701 -->0.175255
| AD #5135 | (Business) | 813 Trans Canada Highway 17 North, Sault Ste. Marie/ Heyden/ Ontario/ Canada | $395900.00 |
|
| Quality Built ... by Master German Craftsmen.
Immaculate condition ... is TURN-KEY operation!
Location:
Trans Canada Highway 17 North of Sault Ste. Marie Ontario in Heyden. Approximately five km north of the city limits and close to Search mont Ski Resort.
Seven Buildings:
* located: on 4.59 acres of land. Very Private with... read more |
| Top of Page View Ad Details |
Sold0.004389 -->0.179644
| AD #5143 | |
| Beautiful 74 acre KOA camping resort located 15 minutes from the can/usa border in the city of sault ste marie.
With a $200000.00 downpayment you get a large home on the property and based on 2009 income you will earn a return of 45% to 60%/year
... 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, %Sault Ste Marie Area%, published)[0][7]
query1->0.013906
query3->0.046246 -->0.083531
(47)
query3->0.014667 -->0.098198
(47)
query3->0.024118 -->0.122316
(47)
query3->0.013114 -->0.13543
(47)
query3->0.00575 -->0.14118
(47)
query3->0.005985 -->0.147165
(47)
query3->0.005004 -->0.152169
(47)+
runtime(0.214012) | | | |
|
| |
