|
|
|
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, %Okanagan%, published)[0][14]
query1->0.036635
Heirarchy0.019805 -->1.108411 | | | NotSold0.021091 -->1.129502
| AD #1083 | 2 story bungelow (Recreational) | #31 - 4401 Westside Road, Kelowna, BC | 1,150,000.00 |
|
| WATERFRONT HOME FOR SALE
• 4 km north of Lake Okanagan Resort at Shelter Cove (4401 Westside Road)
• Architecturally designed home – 2200 ft.sq. – room to expand home or build additional garage, workshop, quest house, studio, etc. Engineered drawings available and show plans for future expansion.
• Approx. 0.9 acres beautifully... read more |
| Top of Page View Ad Details |
NotSold0.003049 -->1.132551
| AD #1081 | (Land) | HWY # 3 , KEREMEOS B.C | 124,890.00 |
|
| Priced BELOW recently received 2012 property assessement notice.
Fully serviced COMMERCIAL/RESIDENTIAL LOT located Amongst well-established businesses and Keremeos Medical Centre.
Endless possibilities..... Retirement homes, Bottle Depot, etc,etc,etc..
MAXIMUM exposure catching traffic from Vancouver, Penticton, Osoyoos, Apex Ski Resort, US... read more |
| Top of Page View Ad Details |
NotSold0.001693 -->1.134244
| AD #1080 | SINGLE FAMILY HOME (Recreational) | BUCHANAN RD, PEACHLAND B.C, VoH1X1 | $ 508,790 |
|
| SEE more at BUCHANAN-PEACHLAND TROVIT or Photos at FOR SALE BY OWNER.CA
Excellent mortgage helper 2 full suites w/own entrances.(one suite is presently rented. Tenants paid 50% utilities, cable/internet).
For extended family or 2 couples purchase or home-based business.
Panoramic lake view. On the FLATS of Peachland Steps to MILLION dollar... read more |
| Top of Page View Ad Details |
NotSold0.001428 -->1.135672
| AD #1078 | Apartment | B104 , 3460 Parkway Road, Enderby, BC V0E 1V5 | 299,999.00 |
|
| THOUSANDS IN UPGRADES, FOR THOUSANDS LESS THAN ANY UNIT!! Enjoy the resort lifestyle at Mabel Lake! Quality thru-out in this 2 bedroom, 2 bath condo, everything is upgraded!! Granite and cherry wood throughout and $5000.00 tile upgrade. The gorgeous high end kitchen and breakfast bar guarantees comfortable dining to entertain your guests. Master... read more |
| Top of Page View Ad Details |
NotSold0.001144 -->1.136816
| AD #1077 | |
| 200 FEET (60.96 METERS) WATERFRONT, SINGLE FAMILY HOME ON 2.41 ACRES ON OKANAGAN LAKE IN BEAUTIFUL LAKE COUNTRY BC. HOME IS 1100 SQ FT UP AND 800 SQ FT DOWN WITH EXTENSIVE USE OF CEDAR THROUGHOUT. 2 BEDROOM, 2 BATH WITH EXPANSIVE DECKS UP AND DOWN. LOTS OF WINDOWS TO ENJOY THE BEAUTIFUL LAKE VIEW. NEWER HEAT PUMP, HOT WATER TANK, PRESSURE TANK AND... read more |
| Top of Page View Ad Details |
NotSold0.001222 -->1.138038
| AD #1069 | 1.32 ACRES (Recreational) | 4040 EXPRESS POINT ROAD, SCOTCH CREEK, BC, V0E 1M5 |
|
| 1.32 ACRES OF BEAUTIFUL WATER FRONT PROPERTY ON SHUSWAP LAKE. PRIVATE DOCK, 75 FEET PRIVATE BEACH, ALL AMENITIES, NAMELY WATER, POWER AND COMPLETELY APPROVED SEPTIC SYSTEM-HAS BEEN INSTALLED. HAS A LARGE HEATED AND INSULATED GARAGE AND IS READY FOR YOUR CHOICE OF HOUSE TO BE BUILT.
2011 PROPERTY ASSESSMENT OVER $800,000.00
PHONE... read more |
| Top of Page View Ad Details |
NotSold0.00126 -->1.139298
| AD #1066 | custom built (Land) | 272 Lakehill Road, Kaleden, B.C. | $789,000 |
|
| 5 Bedroom View Home + 3.5 Fenced Acres in the beautiful Okanagan Valley.... Wine Country
FIRST TIME OFFERED: Warm and friendly Country Living in beautiful, newly renovated home on 3.5 acres of fenced property in highly desirable Kaleden, only 8 minutes from the City of Penticton. For immediate occupancy.
HOME
• Privately situated, 2... read more |
| Top of Page View Ad Details |
NotSold0.001112 -->1.14041
| AD #1061 | corner lot | old glenmore, kelowna | $434,000.00 |
|
| Beautiful old glenmore home with HUGE workshop.
This home is in a well established kelowna family nieghborhood across from an elemetary school.many parks walking trails and even a turtle sanctuary just around the corner.there are no overhead power lines in this area,with lots of mature trees.
this home sit high on a corner lot.it has... read more |
| Top of Page View Ad Details |
NotSold0.001635 -->1.142045
| AD #1058 | |
| REDUCED TO SELL!!!!!!!!
Love golf? Love wine? Love Osoyoos?
Million-dollar views -- of Osoyoos Lake, golf course, the town and Anarchist Mountain -- for less than half a million dollars!
This is a one-of-kind home in a 55-plus gated community of 74 houses on the West Bench of B.C.'s most popular resort town, Osoyoos, home of the... read more |
| Top of Page View Ad Details |
NotSold0.001799 -->1.143844
| AD #1057 | Condo | Big White Ski Resort, British Columbia | $109,900 |
|
| A fantastic buy for this one bedroom condo located in the premier seasonal ski resort of Big White. Big White is situated approximately 65 km south east of the City of Kelowna. It is one of the largest and best known ski hill developments in the BC Interior. The condo is a terrific ski in/out location with great mountain views. Heating is provided... read more |
| Top of Page View Ad Details |
NotSold0.002438 -->1.146282
| AD #1040 | Approx. 80'x 150' | 555 Mountain Drive, Westshores Estate, Kelowna, Vernon Area | $165,900 |
|
| The pictures show a 180 shot in 3 pics of the view which will improve when a house is built. The other pictures show the location in the subdivision, a map of the location of subdivision on the lake, and the 258 acre park, camping and half mile shore line with boat launch. There are 3 large trees in the centre of the view on the property which... read more |
| Top of Page View Ad Details |
NotSold0.002941 -->1.149223
| AD #1039 | 4 Acres | Idabel Lake, Lot 16, Kelowna area, Kootenay Boundary District | $540,000 |
|
| Four acre property [flat, hard surface road on 3 sides] located within a commnity of 58 lots [1/2 acres each with most having lovely homes built on them ] known as Idabel Lake Resort. School bus service. Community is accessed by FSR 201, a very wide road ploughed in the winter and graded in the summer running off of Hwy 33 just past the Big White... read more |
| Top of Page View Ad Details |
NotSold0.001303 -->1.150526
| AD #1035 | lake view property | 225 Missezula Lake Rd. | $699,000 Open To Offers |
|
| Fishing year round, water sking in
summer, atv area above, about 20sq miles of trails.
Quiet area, no hywy close, 40k from Princeton B. C... read more |
| Top of Page View Ad Details |
NotSold0.001284 -->1.15181
| AD #1008 | Printing and Copying | Osoyoos, British Columbia, Main street in a good location |
|
| BUSINESS FOR SALE
IN SUNNY OKANAGAN VALLEY
BRITISH COLUMBIA, CANADA
A well established printing and copying business in Osoyoos, British Columbia is for sale. The entire inventory of paper as well as computers, printers, scanner, fax, antique 36 inch guillotine large cutter and Xerox 7300 Color Phazer and Folder. The business is located on... 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, %Okanagan%, published)[0][14]
query1->0.036635
query3->0.038545 -->0.106974
(35)
query3->0.096066 -->0.20304
(35)
query3->0.042766 -->0.245806
(35)
query3->0.074615 -->0.320421
(35)
query3->0.301292 -->0.621713
(35)
query3->0.060445 -->0.682158
(35)
query3->0.054325 -->0.736483
(35)
query3->0.053553 -->0.790036
(35)
query3->0.050199 -->0.840235
(35)
query3->0.029235 -->0.86947
(35)
query3->0.043321 -->0.912791
(35)
query3->0.061636 -->0.974427
(35)
query3->0.055837 -->1.030264
(35)
query3->0.058342 -->1.088606
(35)+
runtime(1.179739) | | | |
|
| |
