|
|
|
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:00001Cats
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, %Canada%, published)[0][36]
query1->0.013579 Heirarchy0.009366 -->0.511357 | | | NotSold0.001691 -->0.513048
| 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.019614 -->0.532662 NotSold0.002038 -->0.5347
| 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.00134 -->0.53604
| 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.001547 -->0.537587
| 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.002077 -->0.539664
| 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.001816 -->0.54148
| 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.001456 -->0.542936
| 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.00221 -->0.545146
| 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.002199 -->0.547345
| 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.0020520000000001 -->0.549397
| 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.00178 -->0.551177
| 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 |
| | | | | |
| | | | NotSold0.024145 -->0.575322
| AD #309 | Split Level | 3805 Tamarack Ave., Whitefish, MT 59937 | 689,000 |
|
| Reduced by $10K! Visit http://www.whitefishskihouse.com Ski access right out of your front door! This house has good bones and is one of only a few single family homes under a million dollars on the mountain that has ski in/out accessibility. Why share common walls in a condo with noisy neighbors and tourists. The location is great with friendly full... read more |
| Top of Page View Ad Details |
NotSold0.00184 -->0.577162
| AD #308 | Block and Brick Construction (Recreational) | 9060 Heckscher Drive, Jacksonville, FL, 32226 | $509,500 US |
|
| DEEP WATER DOCK with Electric BOAT LIFT
This diamond in the Rough Boaters is a Dream Come True! It sits on nearly an acre on the St Johns River minutes from the Atlantic Ocean and Intercoastal Waterway. It has a deep water dock with an electric boat lift, sandy beach, pool, 2/1 guest house. The main house sits off the road 100' and has a... read more |
| Top of Page View Ad Details |
NotSold0.001513 -->0.578675
| AD #307 | contemporary | residential Arrocito, Bahias de Huatulco, Oaxaca, Mexico | 650000 US |
|
| Architecturally designed home 3477 sq.ft.. Room to build additional guest house.Engineered drawings for future expansion available, plans approved by local autorities.
.Partly ocean-views, just 5 min. walk to three beautiful virgin beaches.
.Infinity pool 430 sq.ft.
.Very safe, quiet area, no direct neighbours, property is all gated.Electric... read more |
| Top of Page View Ad Details |
NotSold0.0020140000000001 -->0.580689
| AD #302 | Condo (Recreational) | 1400 Gulf Blvd #104, Clearwater Beach, FL, 33767 | 364,900.00 |
|
| 2 bedroom, 2 bath, fully renovated; 'custom' sliding doors and windows replaced summer, 2010- they telescope into each other; a/c replaced summer 2009, beautiful, rich granite in kitchen and bathrooms, Master Bedroom has king bed and 2nd bedroom has 2 queen beds; flat screen LED TVs in bedrooms; Kitchen has Sony CD player clock radio; ... read more |
| Top of Page View Ad Details |
NotSold0.0017579999999999 -->0.582447
| AD #305 | log cabin 160 acres | Just South of Eureka, Montana | $4,900,000.00 |
|
| This spectacular property is located in Northwest Montana, just North of Whitefish and includes 160 acres with lush green forest, flowing natural springs and several ponds with trout. This exclusive location is private, but easily accessible all year . The property is located next to the Ten Lakes Scenic area National Forest and is home to all... read more |
| Top of Page View Ad Details |
NotSold0.002185 -->0.584632
| AD #303 | (Home) | 922 Queen Rd, St, Augustine, Fl 32086 USA | 186,400 |
|
| Built……….1993 Family Room
Open Deck/enclosed porch
Area.……... 1650 Sq. Ft. Dining Room
All electric
Bedrooms….3, Split plan Eat in Kitchen
Fire Place
Bathrooms..2... read more |
| Top of Page View Ad Details |
Sold0.002201 -->0.586833
| AD #301 | Farm/Ranch | Cochise County, Arizona | $99,500US |
|
| Ten acres of flat valley bottom land with beautiful view to the South West of the Dragoon Mountains where the Indian Chief Cochise had established his Stronghold when the US Cavalry was hunting him. To the East is the Dos Cabezas Mtns. To the West and North are some smaller mountains just a few miles away.
The ten acres is quite open with,... read more |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.002766 -->0.589599
| AD #3000 | 314 acres | 14 miles South of Regina | $1800/acre |
|
| Farm land for sale, 14 miles south of Regina on Highway 6. This farm is currently being farmed under contract.
Easy access: the land is on Rouleau Road grid off the highway 1mile. Previously sewn to a variety of crops including lentils, oats, barley and wheat.
Part of: NE 1/4 of 22-14-20-W2
All of: SE 1/4 of 22-14-20-W2
Clear... read more |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.0031409999999999 -->0.59274
| AD #2101 | Residential Detached | 257 Allan Street, Red Deer, Alberta , T4R 2T7 | $418,000 |
|
| This home is available for immediate possession and is conveniently located near public transit. This fully fenced corner lot is located in a great neighborhood.
HOME FEATURES
MAIN FLOOR
Kitchen/Dining (14'6x19'9): Tile flooring, island with eating counter, vaulted ceiling, track lighting, ceiling fan, door to back deck, 3 sided... read more |
| Top of Page View Ad Details |
NotSold0.001507 -->0.594247 NotSold0.001468 -->0.595715
| AD #2100 | 4-plex (1 unit) | 5029 48st. Unit B, Olds AB, Canada | $205,000.00 |
|
| Up-graded condo unit, Teak hard-wood floors in living-room and dining area, Faux wood blinds, 5 appliances including stacked W/D and dishwasher. Bedrooms downstairs, quiet area close to down-town and Olds College. Condo fees 75.00 a month Rented at present, please phone owner for showings Beautiful tile in kitchen and entry and upstairs bathroom,... read more |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.003418 -->0.599133
| AD #2141 | 4 - 28 ft x109 ft lots | opal alberta | 50000.00 O.B.O. |
|
| these lots can be sold individually or as a whole,opal has a sewer system at property line,but no water system.these lots are zoned for mobile homes ,or houses. aprox 20 minutes from Redwater ab,and 45 minutes from Edmonton Phone for more info.
HAVE REDUCED FOR QUICK SALE... read more |
| Top of Page View Ad Details |
NotSold0.00135 -->0.600483
| AD #2140 | 39.33 Acres | 55018 Hwy 28, Sturgeon County, Alberta, T8T 1T6 | $18,500.00 per acre |
|
| 5 Km from city!
The 39.33 acres is located on the west side highway 28 approximately 1 Km north of the intersecting highways 28 and 37. The municipal address of this property in the Municipal District of Sturgeon No. 90 is 55018 HWY 28.
This is 10 Km north of the Namao Shopping Centre located on 97 Street. in Edmonton. The property is less... read more |
| Top of Page View Ad Details |
NotSold0.002244 -->0.602727
| AD #2138 | 2 storey walk-out basement | 220 kananaskis Green, Devon Alberta | $459,900.00 |
|
| This home offer 2790 sq. ft. of living area, kitchen has a walk-in pantry, island,the eating area has a bay window which looks out over a beautiful park setting yard., and a garden door out to the deck. The living room offers a large window facing the yard, a gas fireplace, recessed light, ceiling fan ,double french doors lead to the den with... read more |
| Top of Page View Ad Details |
NotSold0.002151 -->0.604878
| AD #2136 | detatched | 1727 Haswell Cove, Edmonton, AB , T6R3A9 | 529,000 |
|
| This 2288 square foot family home is located in Haddow, SW Edmonton, in a cul de sac setting within minutes of the parks, Anthony Henday and whitemud freeway. This beautifully kept 2 Storey features: 3 bedrooms, 2.5 baths, full master en suite, large bonus room above garage, maple island kitchen with pantry, bright nook, large great room with a... read more |
| Top of Page View Ad Details |
NotSold0.002837 -->0.607715
| AD #2135 | House (Land) (Recreational) | 51271 Range Road 30, Leduc County, Alberta, Canada | $2,500,000 |
|
| Visit http://www.arcticrealestate.ca for more images and full details.
This astonishing Edmonton home for sale is situated on 104 acres along the North Saskatchewan River and is 63 km west of Edmonton, Alberta. This Edmonton real estate property is a great mix of treed land, pasture, waterfront, and residence grounds making it suitable for a... read more |
| Top of Page View Ad Details |
NotSold0.0016039999999999 -->0.609319
| AD #2134 | Bungalow | 4521 52 Street, Leduc, AB | 269,000 |
|
| Love living near the lake in quite Leduc.
Own your own bungalow and yard with 22 trees.
Huge double heated garage for all your toys.
Hardwood floors and a basement suite. Rent the basement or keep
it all to yourself.
... read more |
| Top of Page View Ad Details |
NotSold0.0013920000000001 -->0.610711
| AD #2126 | Condo | Millwoods, Edmonton, AB | $298900 |
|
| maintance free adult only complex
air conditioned
top floor end unit
very bright
complex has exercise , games/billiards, movie,computer/coffee rooms
has heated underground parking with storage area
bonus outside powered parking stall that was purchased separately
close to hospital, shopping, resturants
DOESN'T THIS SOUND LIKE A PLACE... read more |
| Top of Page View Ad Details |
NotSold0.001984 -->0.612695
| AD #2120 | Condo/High Rise | #1714 13910 Stony Plain Rd., Edmonton, AB | $210,000 |
|
| Enjoy life at the top of this deluxe, one of a kind, residential high rise in upscale Glenora; just minutes west of downtown. This spacious 788 sq ft 1 bedroom suite is the largest floor plan for a one bedroom that Crescent Place has to offer. It gets just the right amount of sunshine year round with a truly amazing south east panoramic view, with... read more |
| Top of Page View Ad Details |
NotSold0.002576 -->0.615271
| AD #2104 | Condo | 107, 10730-112 Street, Edmonton, Alberta, T5H 3H1 | $149,000.00 |
|
| Large one bedroom, one bath main floor condo completely upgraded (not basement). New In-suite laundry to code, built-in vacuum system, built-in microwave/hood fan over the stove. All new appliances including dishwasher. Beautiful white panel doors, brushed nickel door hardware, faucets and light fixtures. New plumbing. Designer color paint... read more |
| Top of Page View Ad Details |
NotSold0.002856 -->0.618127
| AD #2042 | 116 acres | 1 mile West of Stony Plain, NE-11-053-01-W5, Parkland County | $25,000/acre |
|
| This Prime farmland suitable for subdividing, is located between the Yellowhead & 16A Highways. The property is 5 minutes from Stony Plain & 20 minutes from Edmonton. The access County road is paved.... read more |
| Top of Page View Ad Details |
NotSold0.001497 -->0.619624
| AD #2043 | Photography | 5021 50 Street, Vegreville, AB, T9C 1R3 | $59 000 |
|
| I want to sell this business to someone who will care for it, enjoy it, and nurture it. This is an unbeatable price with instant profit making abilities. The buyer will have everything necessary to run a successful photographic business. You can be your own boss, enjoy the best job ever and encourage others in the arts. The business comes with a... read more |
| Top of Page View Ad Details |
Sold0.0029 -->0.622524
| AD #2137 | .16 acres | Edmonton, Alberta | $250000 |
|
| Vacant lot in the highly sought after, mature community of Forest Heights. Minutes from downtown, moments from the beautiful river valley. Lot measures 50ft x 140ft, zoned for single family dwelling (RF1). Ideal location to build your dream home and enjoy the best of urban living.... read more |
| Top of Page View Ad Details |
Sold0.0020640000000001 -->0.624588
| AD #2122 | Approx. 80 acres | North half | $195,000 |
|
| Private treed land just north of Edmonton.
80 acres of beautiful country property located on the western edge of Thorhild County. Quiet location, 3 km off pavement. Easy commute to Edmonton, Fort Saskatchewan, Redwater and Westlock.
A nature lover’s paradise away from city lights and city noise. A place to meander along trails through the... read more |
| Top of Page View Ad Details |
| | | 1 |
Debug:
REGION:00001Cats
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, %Canada%, published)[0][36]
query1->0.013579
query3->0.019033 -->0.06213
(34)
query3->0.01244 -->0.07457
(34)
query3->0.015779 -->0.090349
(34)
query3->0.018144 -->0.108493
(34)
query3->0.021831 -->0.130324
(34)
query3->0.017266 -->0.14759
(34)
query3->0.015725 -->0.163315
(34)
query3->0.007739 -->0.171054
(34)
query3->0.009111 -->0.180165
(34)
query3->0.00707 -->0.187235
(34)
query3->0.012773 -->0.200008
(34)
query3->0.016965 -->0.216973
(34)
query3->0.022356 -->0.239329
(93)
query3->0.012156 -->0.251485
(93)
query3->0.006961 -->0.258446
(93)
query3->0.007823 -->0.266269
(93)
query3->0.007886 -->0.274155
(93)
query3->0.009909 -->0.284064
(93)
query3->0.011696 -->0.29576
(93)
query3->0.005593 -->0.301353
(23)
query3->0.006675 -->0.308028
(29)
query3->0.008029 -->0.316057
(29)
query3->0.015473 -->0.33153
(29)
query3->0.012503 -->0.344033
(28)
query3->0.008391 -->0.352424
(28)
query3->0.018683 -->0.371107
(28)
query3->0.017189 -->0.388296
(28)
query3->0.007908 -->0.396204
(28)
query3->0.016109 -->0.412313
(28)
query3->0.019564 -->0.431877
(28)
query3->0.026966 -->0.458843
(28)
query3->0.00639 -->0.465233
(28)
query3->0.007512 -->0.472745
(28)
query3->0.008224 -->0.480969
(28)
query3->0.007071 -->0.48804
(28)
query3->0.013951 -->0.501991
(28)+
runtime(0.628258) | | | |
|
| |
