|
|
|
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!
|
| | | | REGION:00034Cats
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][12]
query1->0.021128 Heirarchy0.013564 -->0.651323 | | | NotSold0.001068 -->0.652391
| AD #1135 | Single Family Home | 4312 Rumble Street, Burnaby BC | 988888 |
|
| GREAT SOUTH SLOPE LOCATION - OVER 10,000 SQ. FT LOT
Solid Rancher With Fully developed basement
Extra Large 89 X 113 Corner Lot With View
Extensively remodelled
3380 Total Square Footage
R - 2 Zoning Allowing over 4,700 SQ. FT. New Home
Solid Rancher with full basement on extra large corner lot close to Metrotown, Skytrain and... read more |
| Top of Page View Ad Details |
NotSold0.022677 -->0.675068 NotSold0.001201 -->0.676269
| AD #1122 | Condo | #1204-555 Delestre Avenue, Coquitlam, BC | 410000$ |
|
| Beautiful . 2 bdrm., 2 full baths + den corner unit. Floor to ceiling windows. Excellent floor plan. Quality finishings, granite counters, stainless appliances. 2 parking stalls & storage locker. Walking distance to skytrain, shopping & all amenities. Easy access to SFU. Very good unit rarely available.
... read more |
| Top of Page View Ad Details |
NotSold0.001152 -->0.677421
| AD #1114 | 0.8 Acre | Lot 166, Lillooet Lake Estates, Lillooet Lake, BC | $59,000 |
|
| Lillooet Lake Estates, Lot 166: $59,000
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.001058 -->0.678479
| AD #1113 | 3.89 acres (Recreational) | 2939 Stanley Rd., Pemberton, BC (Birken) | $219,000 |
|
| ** Motivated Seller **
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,... read more |
| Top of Page View Ad Details |
NotSold0.001053 -->0.679532
| 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.000957 -->0.680489
| 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.001146 -->0.681635
| AD #1070 | House | 7210 Meadowlark Street, Chilliwack, BC | 394,000 |
|
| Unique 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 home features:
*granite... read more |
| Top of Page View Ad Details |
NotSold0.000957 -->0.682592
| 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.002089 -->0.684681
| AD #1021 | Housing Development | District of North Vancouver |
|
| North Vancouver (District) B.C.
MLS# V878754
Low Density Multi-Family housing Development LAND For Sale
Priced at $1,388,000
for 9,333 sq ft suitable triplex development and with adjacent property of approximately 8,658 square feet is presently build 0.7 fsr ( floor space ratio) on community plan and will be 0.8 fsr on approval of... read more |
| Top of Page View Ad Details |
Sold0.001072 -->0.685753
| 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.001052 -->0.686805
| 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 |
| | | 1 |
Debug:
REGION:00034Cats
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][12]
query1->0.021128
query3->0.018791 -->0.059255
(34)
query3->0.033513 -->0.092768
(34)
query3->0.021804 -->0.114572
(34)
query3->0.007688 -->0.12226
(34)
query3->0.01171 -->0.13397
(34)
query3->0.020064 -->0.154034
(34)
query3->0.014736 -->0.16877
(34)
query3->0.011513 -->0.180283
(34)
query3->0.008274 -->0.188557
(34)
query3->0.418194 -->0.606751
(34)
query3->0.015199 -->0.62195
(34)
query3->0.015809 -->0.637759
(34)+
runtime(0.712396) | | | |
|
| |
