|
|
|
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, %Lower Mainland%, published)[0][10]
query1->0.011294
Heirarchy0.121559 -->1.028048 | | | NotSold0.000786 -->1.028834
| AD #1114 | 0.8 Acre | Lot 166, Lillooet Lake Estates, Lillooet Lake, BC | $59,900 |
|
| Lillooet Lake Estates, Lot 166: $59,900
This property is located 25 minutes south of Pemberton by Lillooet Lake. Whistler is 45 minutes from the lot. Please go to the web site http://www.lillooetlakeestates.ca to see pictures of the beautiful mountain valley, the nearby amenities, and the subdivision details. Approximately 75% of the lots have... read more |
| Top of Page View Ad Details |
NotSold0.012969 -->1.041803
| AD #1113 | 3.89 acres (Recreational) | 2939 Stanley Rd., Pemberton, BC (Birken) | $219,000 |
|
| http://birkenproperty.com
Own Your Piece of Paradise near Whistler and Pemberton!
Ever dreamed about living a simple life in the country with fresh air, stunning views, rich soil for growing a garden, fishing, snowmobiling on your doorstep yet close enough to the city for occasional urban experiences like shopping, concerts, sporting events -... read more |
| Top of Page View Ad Details |
NotSold0.002643 -->1.044446
| AD #1111 | Detached | 18410 68th Avenue, Cloverdale, BC | 559,000 |
|
| 1st time on the market!
Don't miss out on this wonderful Parklane built home fronting the Heartlands development in Cloverdale.
The home features 4 bedrooms up and another in the basement with a great open design on the main floor with the kitchen and eating area flowing into the sunken great room, plus a separate dining room or a space... read more |
| Top of Page View Ad Details |
NotSold0.002835 -->1.047281
| AD #1074 | Apartment/Condo | #325-12873 Railway Ave., Richmond, B.C., V7E 6K3 | 528,000.- |
|
| This 1284sf condo is very spacious inside. When you enter the suite, the dining area and living room area is huge. The living room features a gas fireplace and vaulted ceilings. To the left as you enter is the kitchen, with enough space for a breakfast eating nook. The kitchen has a mirrored back splash. To the right is the master bedroom and... read more |
| Top of Page View Ad Details |
NotSold0.029432 -->1.076713
| AD #1071 | Condo/Strata | #101 1365 W 4th, Vancouver BC, V6H 3Y8 | 349 000 |
|
| Central location, just steps to great shopping! Granville Island, W4th and South Granville all within walking distance, as well as access to transit and gorgeous walks along the seawall. Fully renovated suite with designer paint colours, tile flooring in high traffic areas and wood laminate in bedroom and den. Quiet corner suite with view balcony... read more |
| Top of Page View Ad Details |
NotSold0.002572 -->1.079285
| AD #1070 | House | 7210 Meadowlark Street, Chilliwack, BC | 469,000 |
|
| BEAUTIFUL LARGE FRENCH STYLE CHARACTER HOUSE FOR SALE!
This is a beautiful character home located in the heart of Sardis, BC!
THIS IS A MUST SEE, MINUTES AWAY FROM HIGHWAY #1.
LOCATED ON CORNER LOT IN A VERY QUIET NEIGHBOURHOOD!!
With extensive use of stone, wood on stucco exterior, this... read more |
| Top of Page View Ad Details |
NotSold0.002698 -->1.081983
| AD #1068 | Mobile w/lot | #29-3931 198 St., Langley, BC, V3A 1C9 | 161,900 |
|
| What a great place to live! A lovely 55+ park that is well run and maintained, situated in a quiet residential neighbourhood in the Brookswood area of Langley. There is no pad rental since you OWN A SHARE OF THE PARK, so it will never be sold out from under you.
You have only to move in, the home itself is totally renovated from the studs... read more |
| Top of Page View Ad Details |
NotSold0.002258 -->1.084241
| AD #1021 | Housing Development | District of North Vancouver |
|
| North Vancouver (District) B.C.
MLS# V878754
Low Density Multi-Family housing Development LAND For Sale
Price reduced from $1,800,000 to $1,658,000
for 9,333 sq ft suitable triplex development and with adjacent property of approximately 8,658 square feet are suitable 0.7 fsr ( floor space ratio) townhouse development.
Alone build 0.5fsr,... read more |
| Top of Page View Ad Details |
Sold0.00137 -->1.085611
| AD #1072 | Condominium | Burnaby, BC | $358,000.00 |
|
| SOLD! for $350,000.00!!!!
This beautiful one bedroom condo at Centre Point is perfectly situated in the heart of Burnaby's Metrotown. Just below is Best Buy, Shoppers Drug Mart, Moores Mens Wear and Starbucks, but across the built-in walkway over Kingsway is Metrotown, one of western Canada's largest malls. Commuting is very... read more |
| Top of Page View Ad Details |
Sold0.002152 -->1.087763
| AD #1065 | Geodesic Dome Hybrid | Abbotsford BC | 335,500 |
|
| This delightful 1550 sq ft. house features 2 bedrooms with an office loft that can be converted to a bedroom, if desired. A large living room features a 17 foot high ceiling and feels pleasantly spacious. Also contains 1 full bathroom upstairs, 1/2 bath on main, dining room and kitchen, laundry utility room and loads of storage space. New flooring... 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, %Lower Mainland%, published)[0][10]
query1->0.011294
query3->0.023868 -->0.057969
(34)
query3->0.071778 -->0.129747
(34)
query3->0.051361 -->0.181108
(34)
query3->0.109239 -->0.290347
(34)
query3->0.15798 -->0.448327
(34)
query3->0.132557 -->0.580884
(34)
query3->0.109648 -->0.690532
(34)
query3->0.092078 -->0.78261
(34)
query3->0.106213 -->0.888823
(34)
query3->0.017666 -->0.906489
(34)+
runtime(1.118584) | | | |
|
| |
