|
|
|
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, %Kootenay%, published)[0][21]
query1->0.066999
Heirarchy0.094018 -->1.516748 | | | NotSold0.001653 -->1.518401
| AD #1128 | 160 acres | 12789 West Wilson Creek Road | $9,000,000 |
|
| "Hidden Jewel Of The Kootenays"
Ranch Creek Flats was Slocan Lake bottom at one time. There are no rock outcroppings on the 500 acre bench which is from 2800' - 3000' Elev. and a 10% slope, and there is topsoil classified as "sandy loam" by the surveyor in 1915. Classified "rural" it is NOT in the... read more |
| Top of Page View Ad Details |
NotSold0.012261 -->1.530662 NotSold0.003564 -->1.534226
| AD #1126 | (Home) | 317 7TH Avenue, New Denver BC, V0G 1S0 | 279000 |
|
| Price reduced from 319000 to 299000 to 279000
Nice family home located in New Denver minutes from Slocan lake and Vahalla National Park.
Bi Level walkout basement to large vegetable and flower garden.
Two bedrooms and one bathroom upstairs and one bedroom downstairs
Basement partially complete with potential for ensuite.
four good... read more |
| Top of Page View Ad Details |
NotSold0.004615 -->1.538841
| AD #1125 | Single Family | 730 Nicholson Road, Golden, BC, V0A1H2 | 599,000 |
|
| Executive Home on 1.43 acres of landscape extraordinaire!
Quality finishing throughout this home with oak & white lacquered cabinets in large country kitchen with island & ceramic floors and counters. Nook with walk-outs to huge wrap around decks, hot tub, fishpond, waterfall, flowers & rock gardens galore. 4 bay 2 level garage with bonus room... read more |
| Top of Page View Ad Details |
NotSold0.004077 -->1.542918
| AD #1124 | Bungalow (Recreational) | 6876 Columbia Ridge Dr., Fairmont Hot Springs, BC., (Columbia Ridge Country Estates) | 465,000 |
|
| * 3000 sq ft bungalow (1500 sq ft above ground) built in 2008
* .5 acre lot (Lot 10 – Phase 3)
* Double attached garage
* Maple hardwood flooring and tile throughout
* Maple cabinets
* Crown moulding
* Three bedrooms / two bathrooms
* Large sunny nook area with view of mountains and treed backyard
* Includes fridge, stove, microwave,... read more |
| Top of Page View Ad Details |
NotSold0.00493 -->1.547848
| AD #1119 | storage + retail | 1884 Pass Creek Rd., Castlegar BC, V1N4S6 | 549000 |
|
| Property consists of 5 fenced acres on a beautiful secondary highway in Castlegar BC.
10,000 sq. ft. building houses a country store 41 unit mini-storage Castlegar's only U-Haul franchise. Storage has had 90% occupancy rate over the past 3 years. 50% increase in sq. footage for storage already approved as well as a vehicle storage building... read more |
| Top of Page View Ad Details |
NotSold0.005714 -->1.553562
| AD #1116 | Single Family Dwelling | 5638 Cedar Creek Road, Winlaw, BC, Canada | $269,000.00 |
|
| Newly built, never lived in 2 bedroom 1.5 bathroom beauty comes with a 10 year new home warranty. The accommodation is all on one level, the doorways are 3 ft wide, while hallways are 4 ft making it wheel chair accessible. The home has been constructed to be energy efficient and boasts energy saving windows and in-floor heating. The home is... read more |
| Top of Page View Ad Details |
NotSold0.00212 -->1.555682
| AD #1115 | 10.55 acres (Recreational) | Arrow Lake, BC, near Nakusp, BC | $89,000.00 |
|
| 1400 feet of lakefront at $89,000.00 makes this property the best deal on the Arrow Lakes. Located 25km south of Nakusp, BC on the west side of the lake. Boat access only, for now!!!! There is a road that ends very close to the property border.
Boulders the size of winnebagos make up most of the shore line, as well as sandy beaches and... read more |
| Top of Page View Ad Details |
NotSold0.003179 -->1.558861
| AD #1106 | 19 acreage lots 1.0 hectare or 2.5 acres | Castlegar, BC | $135,000 per lot |
|
| "7th Heaven" in Castlegar B.C.
This area of Western Canada is very unique in that the winters are very mild and the summers are very pleasant with excellent growing conditions. The mountains near by have a number of ski hills. Red Mountain ski area is one of the finest with all the latest skiing facilities that attract enthusiasts... read more |
| Top of Page View Ad Details |
NotSold0.002408 -->1.561269
| AD #1104 | pub | 1398 hartley road, golden brtish columbia, canada | 499,900 |
|
| unique country pub for sale 10 mins west of golden...2 bedroom suite downstairs, on 2 acres of land, known for burger night, wing night and my rib dinners..2 pool tables,table, chairs, kitchen equipment, included...some decorative items will not stay...stock not included...hours of operation are sunday 11 til midnight mon tues wed thurs 10 till... read more |
| Top of Page View Ad Details |
NotSold0.002147 -->1.563416
| AD #1102 | 3.83 acres (Recreational) | Summit Lake Provincial Park area, Nakusp BC | $169,000 |
|
| Lakefront lot For Sale
Ample privacy on 1.55 hectares (3.83 acres) of well-treed lot only 14 km south of Nakusp BC. This secluded lot corners on Summit Lake with a combination of low lying foreshore and upper terrain slopes offering fantastic lake and mountain views. Shallow drilled well with ample water.
Priced at $169,000.
... read more |
| Top of Page View Ad Details |
NotSold0.00186 -->1.565276
| AD #1091 | Bungalow | 202 Burgess Ave, Field, B.C | $229,000.00 |
|
| 20 minutes from Lake Louise, Alberta.
Gorgeous views in the heart of the rocky mountains.
Cross country sking and hiking at your door.
Enjoy the kicking horse river right in front of you.
... read more |
| Top of Page View Ad Details |
NotSold0.002656 -->1.567932
| AD #1090 | 9 acres | Bowman Falls, Arrow Lake, BC | Contact owner |
|
| Bowman Falls, Arrow Lakes, B.C.
Development Opportunity
Contact: John Oswald
Email: jakoswald@gmail.com
Phone: (250) 513-0161
Mail: #307 - 2117 Columbia Ave
Castlegar, B.C. V1N 2W9
The Bowman lots are ideal for four season development. Clean air and water, beautiful forests, hills and mountains provide ideal opportunities for... read more |
| Top of Page View Ad Details |
NotSold0.002357 -->1.570289
| AD #1089 | 80' by 284' | 217 Belmond Rd, Salmo, BC, Canada | $92,500. OBO Reduced to $85,000 until the end of April |
|
| Rural, paved frontage rd, 5 min drive to Salmo with schools, curling, park, groceries, post office etc, 5 min drive to local ski hill, 1/2 hr drive to Whitewater or Red Mountain ski hills, snowmobiling access close by, 5 min walk to river, you can hear it at night in bed, 12 mi to Nelway border crossing, 2 hrs to Spokane Washington, 1/2 hr to... read more |
| Top of Page View Ad Details |
NotSold0.003314 -->1.573603
| AD #1016 | RV/Tenting/Mobile Home | Highway 23, Nakusp, BC | $575,000.00 |
|
| This is a great opportunity for group investments. Property is zoned for recreational/motel/restaurant. Located in beautiful Nakusp BC, 6.38 acres with highway frontage, minutes from downtown and the Nakusp Hot Springs.
There are 46 campsites, 26 with full service. Two sets of washrooms with coin operated showers.
A 20 X 40 swimming pool... read more |
| Top of Page View Ad Details |
NotSold0.006936 -->1.580539
| AD #1075 | 100 lot community development | Kootenay Lake |
|
| Selling residential building lots with a spectacular southerly view of Kootenay Lake and the surrounding mountains.
Are you looking for a change in lifestyle?
This could be your view!
Grandview Properties is a 100 lot community development
offering spectacular lake and mountain views.
Fully Serviced Building Lots
Building Scheme,... read more |
| Top of Page View Ad Details |
NotSold0.001954 -->1.582493
| AD #1062 | Citation park model 38' Fully equiped mechanic's shop | 9006 Railway Ave, Yahk, BC | $350,000.00 OBO |
|
| HOME & MECHANIC SHOP - BEST OF BOTH WORLDS-RETIRED MECHANIC'S DREAM OR GREAT POTENTIAL FOR FULL-TIME BUSINESS
Located in Yahk, BC across from general store/liquor store/gas station and down the street from school and community hall
Fully equiped mechanic's shop:
-new hoist, tire machine and balancer installed in 2007
-new... read more |
| Top of Page View Ad Details |
NotSold0.002957 -->1.58545
| AD #1046 | Treed with Evergreens and Fruit trees | Centreplace Rd, Krestove BC, V0G 1H0 | $269,000. |
|
| DO YOU ENJOY ORGANIC GARDENNING? Between Nelson and Castlegar. 400 X 160 ft. of Prime Real Estate with a beautiful view. Mostly treed with a variety of fruit and evergreen trees. Very quiet and private. May be divided. New site prep with 1993 14 X 70 Mobile Home. New metal roof and wood heater in small addition. 100 X 50 fenced garden area ideal... read more |
| Top of Page View Ad Details |
NotSold0.002237 -->1.587687
| AD #1014 | (Home) (Business) | 4957 Burns Avenue, CANAL FLATS, BC, V0B 1B0 | $499,000 |
|
| 4957 BURNS AVENUE, CANAL FLATS, BC:
This spectacular residence boasts over 5000 sq.ft of executive living. Featuring an in-door heated sunken swimming pool and a dream kitchen with granite counter tops, maple cabinets and top-of-the line stainless steel appliances. The 24x36' master bedroom has an exceptionally large walk-in closet with... read more |
| Top of Page View Ad Details |
NotSold0.005235 -->1.592922
| AD #1162 | 12.75 | 3.2km Pass Creek Road | min at $15,600/ac |
|
| Southern Exposed property with a view of the Castlegar Valley, Mount Sentinel, Bombi Pass, Selkirk College, Castlegar Airport, Kinnard Bridge spanning over the Columbia River. Elevation is approx 1800ft above sea level, with ample sun to grow various crops, fertile soil, seasonal springs and wells can be drilled. Cell phones work well.
Lot... read more |
| Top of Page View Ad Details |
NotSold0.003924 -->1.596846
| AD #1060 | (Land) | Eleventh Ave. & Third Street, Castlegar, BC | $500,000.00 |
|
| Three fully operational business's, Jewelry store-846sq.feet quarter basement, Restaurant-1175sq.feet three-quarter basement, Clothing store-1410sq.feet full basement. In the heart of downtown Castlegar.
.it has changed and is fully rented with leases!... 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, %Kootenay%, published)[0][21]
query1->0.066999
query3->0.087516 -->0.175556
(36)
query3->0.143548 -->0.319104
(36)
query3->0.006066 -->0.32517
(36)
query3->0.027812 -->0.352982
(36)
query3->0.015234 -->0.368216
(36)
query3->0.006426 -->0.374642
(36)
query3->0.028945 -->0.403587
(36)
query3->0.008085 -->0.411672
(36)
query3->0.655805 -->1.067477
(36)
query3->0.011345 -->1.078822
(36)
query3->0.03666 -->1.115482
(36)
query3->0.048776 -->1.164258
(36)
query3->0.039843 -->1.204101
(36)
query3->0.006077 -->1.210178
(36)
query3->0.040945 -->1.251123
(36)
query3->0.088733 -->1.339856
(36)
query3->0.020195 -->1.360051
(36)
query3->0.005788 -->1.365839
(36)
query3->0.023168 -->1.389007
(36)
query3->0.011952 -->1.400959
(36)
query3->0.021771 -->1.42273
(36)+
runtime(1.65048) | | | |
|
| |
