The For Sale By Owner Canada Network For Sale By Owner Canada

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][13]
query1->0.020653
Heirarchy0.00461 -->0.49962
Regions of
Lower Mainland
Max Ads per page:

Lower Mainland

NotSold0.0015350000000001 -->0.501155
AD #1144
Single family with suites
6388 167 street, Surrey, BC, V3S0W5
720000
AD # 1144
Here it is! HUGE 4,409 sq ft 2 storey with finished basement in West Cloverdale on a big 6749 sq ft corner lot! 8 bedrooms, 5 bathrooms, and two 2 bedroom suites (only 1 rented)! Traditional layout living/dining room + kitchen w/big eating area, spice kitchen and great room w/soaring ceiling to upstairs, laundry on main. 4 big bedrooms upstairs,... read more
NotSold0.033111 -->0.534266
AD #1140
Townhouse
19 - 2418 Avon Place, Port Coquitlam, BC, Canada V3B0C7
395,000
AD # 1140
Open House!
LINKS by Mosaic. Steps from: Carnoustie Golf & Country Club, Costco, Save on Foods,
Terry Fox Secondary, Archibishop Carney Secondary, Blakeburn Elementary, Fremont
Village, Walmart, Canadian Tire, Royal Bank, TD Bank, CIBC and many shopping stores.

Great view overlooking courtyard with a peek-a-boo view of the mountain. Bedroom with... read more
NotSold0.002842 -->0.537108
AD #1139
Townhome
210-1174 Wingtip Place, Squamish, BC
352,600
AD # 1139
Open House!
Independent buyers without agents are welcome. Lease-to-Buy (rent-to-own) option
is also possible for a qualified buyer.

This modern, lovingly maintained townhome is part of the original and tranquil
section of Eaglewind known as Talon. Friendly, quiet neighbours add to the joy
of living here. The two-story unit overlooks a large greenbelt,... read more
NotSold0.003087 -->0.540195
AD #1135
Single Family Home
4312 Rumble Street, Burnaby BC
988888
AD # 1135
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
NotSold0.001399 -->0.541594
AD #1133
GROUND CORNER UNIT
HOWIE, COQUITLAM
169000
AD # 1133
NotSold0.001069 -->0.542663
AD #1122
Condo
#1204-555 Delestre Avenue, Coquitlam, BC
410000$
AD # 1122
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
NotSold0.0023099999999999 -->0.544973
AD #1113
3.89 acres (Recreational)
2939 Stanley Rd., Pemberton, BC (Birken)
$219,000
AD # 1113
** 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
NotSold0.001615 -->0.546588
AD #1111
Detached
18410 68th Avenue, Cloverdale, BC
559,000
AD # 1111
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
NotSold0.002162 -->0.54875
AD #1074
Apartment/Condo
#325-12873 Railway Ave., Richmond, B.C., V7E 6K3
528,000.-
AD # 1074
Price Reduced!
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
NotSold0.003464 -->0.552214
AD #1068
Mobile w/lot
#29-3931 198 St., Langley, BC, V3A 1C9
161,900
AD # 1068
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
NotSold0.003677 -->0.555891
AD #1021
Housing Development
District of North Vancouver
AD # 1021
Price Reduced!
North Vancouver (District) B.C.
MLS# V878754

Low Density Multi-Family housing Development LAND For Sale
Priced at $1,999,000
suitable for 0.8 fsr ( floor space ratio) on approval of district North Vancouver, when combined with adjacent property, or build a Triplex at 0.5 fsr without adjacent property.


Land offered is easy to build, ... read more
Sold0.00288 -->0.558771
AD #1072
Condominium
Burnaby, BC
$358,000.00
AD # 1072
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
Sold0.0022489999999999 -->0.56102
AD #1065
Geodesic Dome Hybrid
Abbotsford BC
335,500
AD # 1065
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

Sponsored Links

Business Valuation
Sell Your Home in 21 Days
Improve the Curb Appeal of Any Home
1

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][13]
query1->0.020653
query3->0.035022 -->0.069968
(34)
query3->0.018828 -->0.088796
(34)
query3->0.069942 -->0.158738
(34)
query3->0.013671 -->0.172409
(34)
query3->0.032777 -->0.205186
(34)
query3->0.0414 -->0.246586
(34)
query3->0.037403 -->0.283989
(34)
query3->0.041288 -->0.325277
(34)
query3->0.032949 -->0.358226
(34)
query3->0.024346 -->0.382572
(34)
query3->0.054435 -->0.437007
(34)
query3->0.021335 -->0.458342
(34)
query3->0.036668 -->0.49501
(34)+
runtime(0.608487)
Canadian Maple Leaves
Canadian Maple Leaves