|
|
|
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, %Omineca / Peace / Skeena Regions%, published)[0][9]
query1->0.009932
Heirarchy0.068032 -->0.48713
|
|
Regions of
Omineca / Peace / Skeena Regions | | | | NotSold0.00067200000000001 -->0.487802
| AD #1096 | 160 acres 1/4 section (Recreational) | 463 187a rd, Tomslake BC | Land value only 160,000.00 |
|
| 160 ac selling for land value only some buildings, fenced &x fenced, hay fields & pasture,creek thru property, excellent hunting property with bush & tree cover.
1/2 mile gravel to pavement
1 hr to Dawson Creek BC
1 hr to Grande prairie AB... read more |
| Top of Page View Ad Details |
NotSold0.008089 -->0.495891
| AD #1092 | Motel | 5207 50th Ave , Ft Nelson, BC | 490,000 |
|
| INCREDIBLE OPPORTUNITY IN FT. NELSON BC!!!
Right in the heart of this bustling town, located on the Alaskan Highway, this motel site is the only prime location available in town.
Run the motel and service the high number of long-term clients such as truckers and oil workers, or tear down and redevelop this prime commercial site.
Ft Nelson... read more |
| Top of Page View Ad Details |
NotSold0.0031289999999999 -->0.49902
| AD #1085 | Fenced Acreage and Family Home | 9570 Forest Hill Place, Prince George Rural West, 10 Mins to UNBC | $276,000 |
|
| Fantastic family home and acreage for sale just 10 minutes west of UNBC in Prince George. The home was built in 1995 and is in excellent condition inside and out. Recent upgrades include flooring and paint. Quality trim throughout. Windows, roof all in excellent condition. Excellent drainage.
The acreage is completely fenced and ready for... read more |
| Top of Page View Ad Details |
NotSold0.00429 -->0.50331
| AD #1082 | 2 storey residential/commercial | 421 Main St., McBride, BC | $159,000 |
|
| Recently reduced, owner is very motivated. Newly renovated and totally refurbished historic house for sale in beautiful McBride, BC. If you like to sled, hike, hunt, fish, or just enjoy the mountains, this is the place to do it in.
This two-storey house on a full unfinished basement, is currently being used in a commercial capacity as a... read more |
| Top of Page View Ad Details |
NotSold0.004289 -->0.507599
| AD #1157 | Restaurant -motel | 5112 50th Street, Chetwynd, BC | $595,000 |
|
| 50 heat licensed family restaurant. plus 24 room motel and 1200 sq ft living quarters. Centrally located on Junction of Hwy 29 & 97. Thriving family business, well established. Owners would like to retire.... read more |
| Top of Page View Ad Details |
NotSold0.08009 -->0.587689
| AD #1146 | Hobby Farm 62 Acres | 21891 Triad Road, Prespatou BC, Canada | $417,500.00 Package Deal |
|
| A beautiful double wrought iron gate with a high arch way at the entrance to a graveled circle driveway with a second beautiful double gate at the exit. Major renovations have been completed on the residence. Also a new Octagon Horse Corral and a new Large Root Cellar
Acres Beautiful treed valley land with very gentle slope draining into Umbach... read more |
| Top of Page View Ad Details |
NotSold0.005849 -->0.593538
| AD #1142 | Farm/Ranch 1440 acres | Fort St. John area | $1500000. |
|
| Experience country living at its finest; fresh air, blue skies, fertile soil and life out of the rat race. Get more for your dollar the rural way. This property’s investment potential includes: set-up for buffalo/feed lot (or horses, cattle, elk, llamas, etc.)and rental income off one residence.
The first residence is a 1977 mobile home... read more |
| Top of Page View Ad Details |
NotSold0.003464 -->0.597002
| AD #1076 | (Home) Fully Furnished 1/2 Duplex Revenue Property | 7143 Guelph Crescent, College Heights, Prince George, BC | $229,900 |
|
| MLS# N208553
Excellent Investment Opportunity!
Revenue, Plus!
One of a kind. Well maintained, immaculate, and recently renovated 1/2 duplex home with 'separately entranced and self contained in-law suite' in desirable College Heights. Offered at $216,880. Bright spacious layout.
Quick possession. Fully fenced (5 ft to 6 ft... read more |
| Top of Page View Ad Details |
NotSold0.0061910000000001 -->0.603193
| AD #1041 | 94.4 acres | 19180 Highway 29N, Hudson's Hope, BC, V0C 1V0 | $1,199,000 CDN |
|
| * * * * * Hugging The Peace River * * * * *
Description:
Beautiful homestead/farmstead waterfront property located in the heart of scenic Peace Valley Region. One-of-a-kind ¼ section with property on both sides of the Peace River (plenty of river frontage!). Undeveloped flat land with two upper plateaus (prime building locations!). ALR... 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, %Omineca / Peace / Skeena Regions%, published)[0][9]
query1->0.009932
query3->0.00655 -->0.040295
(111)
query3->0.049037 -->0.089332
(111)
query3->0.151909 -->0.241241
(111)
query3->0.020029 -->0.26127
(111)
query3->0.050911 -->0.312181
(111)
query3->0.053342 -->0.365523
(111)
query3->0.02741 -->0.392933
(111)
query3->0.008105 -->0.401038
(111)
query3->0.01806 -->0.419098
(111)+
runtime(0.614344) | | | |
|
| |
