|
|
|
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, %Thompson / Nicola Regions%, published)[0][5]
query1->0.009017
Heirarchy0.021519 -->0.387121
|
|
Regions of
Thompson / Nicola Regions | | | | NotSold0.00069599999999992 -->0.387817
| AD #1034 | House | 3340 Roncastle Road, Blind Bay, BC | 699900 |
|
| STUNNING VIEW - BEAUTIFUL HOME
For many photos and all the details please enter this web address into your internet browser:
http://www.bcforsalebyowner.com/view/3347
Comfortable home with low maintenance lot. Private. Natural springs, ponds and streams with waterfalls, fish and water plants. Large rooms. Master bedroom has his and hers... read more |
| Top of Page View Ad Details |
NotSold0.004515 -->0.392332
| AD #1032 | Bungalow | Avola, British Columbia | $149,900 |
|
| House on large landscaped lot with cherry, apple and plum trees in quiet, small village. On town water system. Within 400 yards of river. No less than 7 good fishing lakes within 1 hour drive, excellent hunting area for mule and white tail deer and moose.
House had new roof, chimney and shop added in 2000. Hot water tank, heating system,... read more |
| Top of Page View Ad Details |
NotSold0.003425 -->0.395757
| AD #1027 | (Home) Revenue Property | 25 Clarke Street, West End (Adjacent Lower Sahali), Kamloops, BC | $519,000 $499,000
|
|
| Solid cozy bright five bedroom, two bath, four level, Split level home. Professionally renovated since original build.
Wonderful view of North, South Thompson River Valleys, Mount Peter and Mount Paul. Short walk to Royal Columbia Hospital, and down the hill to Downtown Kamloops.
Approx. 1860 sqft, large sundeck, concrete patio, private yard,... read more |
| Top of Page View Ad Details |
NotSold0.0038119999999999 -->0.399569
| AD #1004 | 2 x .21 acres
2 x 74.8' frontage x 120.00' depth = 149.6' frontage
x 120' depth or 22.8m(x2) x 36.61m | 451 - 421 22nd Street NE, Salmon Arm, BC | $249,000 $219,000
& $399,000 $369,000
entire .42 acre parcel $588,000.
|
|
| Good size lot in Westview subdivision, $219,000, reduced from $249,000. Adjacent lot .21 acres with building $369,000 as is. Level entry rancher with baylight basement, suite potential. 180 degree view incorporating Mount Ida, Fly Hills, Glen Eden, Shuswap Lake, Salmon Arm city in part, Bastion Mountain.
Property slopes to the west and has... read more |
| Top of Page View Ad Details |
NotSold0.0041960000000001 -->0.403765
| AD #1010 | Private Estate | Sorrento, B.C., V0E 2W0 | $799,000.00 |
|
| MILLION DOLLAR LAKEVIEW
Relax and Run your own Business from Home! Owners Retiring!!!
* Custom Built: 1996
* Lot Size: Just under 4 acres
* Water: Wellwater, 2 private
* Sq Ft: 7,000 sq ft
* Bedrooms: 8 bedrooms(each with own private ensuite!)
* Bathrooms: 8 1/2 baths
* (Separate Inlaw suite with Jacuzzi... 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, %Thompson / Nicola Regions%, published)[0][5]
query1->0.009017
query3->0.261256 -->0.301603
(113)
query3->0.037029 -->0.338632
(113)
query3->0.012695 -->0.351327
(113)
query3->0.0071749999999999 -->0.358502
(113)
query3->0.0071 -->0.365602
(113)+
runtime(0.412803) | | | |
|
| |
