|
|
|
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: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][6]
query1->0.018492 Heirarchy0.002921 -->0.913216 | | | NotSold0.002248 -->0.915464
| AD #5148 | Cottage Resort (Recreational) | 3271 Highway 11 North, Marten River Ontario, P0H1T0 | $775,000.00 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.019758 -->0.935222
| AD #5129 | Detached | 201 Albert Street, Haileybury, ON , P0J 1K0 | $645,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001605 -->0.936827
| AD #5128 | 210' X 210' 44,100 sq ft | 1116 Pem St East, Pembroke Ontario, K8A-7R5 | $625,000 |
|
| Location! Location! Location!
Frontage on Hwy 148
FOR SALE OR 25 YR LEASE
Property Borders Pembroke Ontario / Laurentian Valley Twp
Highest Traffic Area Volume
100,000 + Customer Volume Population
450+ Cars Every 15 min approx Weekdays/... read more |
| Top of Page View Ad Details |
NotSold0.001836 -->0.938663
| AD #5127 | bungalow | 96 Sullivan pt. rd., RR # 1, Pembroke, Ont.K8A 6W2 | 148,500 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001052 -->0.939715
| AD #5116 | TRUCK WASH | 120 ONTARIO ST., SUNDRIDGE, ONTARIO | 159900.00 |
|
| 6500 square foot truck wash with 3 bays. Presently used for private use for owners trucking business. Owners may hold mortgage with 40000.00 down to qualified purchaser. By appointment only please... read more |
| Top of Page View Ad Details |
NotSold0.001018 -->0.940733
| AD #5115 | 2 storey (Land) | 1053 forest lake road, Sundridge, Ontario | 259900.00 |
|
| 200 acres of rolling land. Approx. 70 acres cleared with the rest in mixed bush. Year round stream runs through property.
fenced and cross fenced. pond with waterfall on back hundred acres. Back up generator included. Must see... read more |
| Top of Page View Ad Details |
| | | 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][6]
query1->0.018492
query3->0.294693 -->0.327621
(52)
query3->0.108502 -->0.436123
(52)
query3->0.341886 -->0.778009
(52)
query3->0.023723 -->0.801732
(52)
query3->0.072319 -->0.874051
(52)
query3->0.036244 -->0.910295
(52)+
runtime(0.973558) | | | |
|
| |
