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!

REGION:00002Cats
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, %Alberta%, published)[0][48]
query1->0.018314
Heirarchy0.041897 -->2.187256
Regions of
Alberta
Max Ads per page:

Southeast Calgary Homes

NotSold0.0014380000000001 -->2.188694
AD #2063
Single family
82 Auburn Crest Green SE
499,999
AD # 2063
This house is 1547 sqf. it has 3 bedrooms and 2.5 bathrooms. Two bathrooms upstairs and a half downstairs. The main floor is a complete open concept, with the living room, Kitchen, and Dining room on the same floor. The house is great for entertaining family and friends. You can be sure that you will never miss the action. During summertime, you... read more
NotSold0.04125 -->2.229944
AD #2057
Acreage/bungelo
3275 88 St SE, Calgary, AB
1,398,999.00
AD # 2057


Executive Bungalow Acreage in Calgary!!
For sale only minutes from Stoney Trail and Peagan Trail

Includes 2700 sq. ft. hobby shop and 1100 Sq. ft. High End Photography Studio.

HOME
Custom Built Home. Centrally located this bright and open home is situated on a beautifully manicured 2 acre parcel that is nestled in the small... read more
Sold0.003065 -->2.233009
AD #2045
Residential Detached Single Family
SE Calgary, Alberta
319,900.00
AD # 2045
Great value in this sweet two storey home located in the heart of MckenzieTowne. Located steps from the Catholic K-9 school, and walking distance to all amenities including public transportation, shopping, restaurants, Towne Hall, and the Towne Square. The Contemporary open concept design features hardwood floors, and exceptional natural light.... read more

Sponsored Links

Selling Your Home Alone

Outside Of Calgary Homes

NotSold0.036348 -->2.269357
AD #2010
Back Split
19 Maple Pl., Crossfield Ab.
$456,000
AD # 2010
Located on a quiet cul-de-sac in Crossfield 50 Km north of downtown Calgary close to schools soccer fields and playgrounds.  Main floor has den and family room with gas fireplace and laundry in the 3 pce bathroom. The upper level consists of 3 bedrooms. The large master bedroom has walk-in-closet and a 4 pc. ensuite bathroom with jetted tub.  The... read more
NotSold0.001857 -->2.271214
AD #2007
Two storey
30 Tiller Place SE, Airdrie, Alberta, T4A 1S6
$459,000
AD # 2007
This home has nothing but space and is located in a quiet cul-de-sac. The yard has lots of trees and privacy, just beyond the alley is a green belt with a walking path.

When you enter this home you will see the sweeping staircase and the large living room with west facing windows and a vaulted ceiling. The living room opens up into the formal... read more
NotSold0.0012840000000001 -->2.272498
AD #2005
(Home) option adjacent 20 acres
30 min SW of Calgary
$ 995k with 20 acres
20 acres bare $ 549k
AD # 2005
Absolutely Awesome home on 20/40 acres only 35 min. SW of Calgary.  The complete storey is told on my website at http://www.millarvilleacreage.com.  Please cut and past to view.  Also note:  A $ 5000 SUCCESSFUL REFERRAL PRIZE!!!  You really must see the website and learn much more than any MLS listing site.... read more
Sold0.001225 -->2.273723
AD #2000
Hillside Bungalow (Land)
Cochrane, Alberta
799,000
AD # 2000
Price Reduced!
Beautiful family home with a million dollar mountain view. State of the art co-op water system guarantees great supply of water. Awesome kitchen with 2 ovens and island. 5 minutes from Cochrane, 40 minutes to downtown Calgary or the airport.

Call us for an appointment.... read more

Western Alberta

NotSold0.0029119999999999 -->2.276635
AD #2096
Bungalow
54206B Hwy 748 North, Yellowhead County, Alberta, T7E-3N6
559000
AD # 2096
This beautiful bungalow is just off the pavement with only 100 meters of gravel and only 7 Km north of Edson in the Yellowhead County.  It is fully fenced with approximately 3 acres of trees in the front, back and along the sides. The garden has a fence around it to keep the pets out. The spacious laundry room has upper and lower cup boards like... read more
NotSold0.0015500000000001 -->2.278185
AD #2092
+/- 3 acres
NE 8-32-2w5m
$204,900.
AD # 2092
Buy now, be ready to build in the spring!
The perfect Alberta view; agriculture, oil and the beloved Rocky Mountains can be seen from this acreage just minutes from Olds or Didsbury.  The three acre parcel is serviced with power and water well.  The location preserves the peace and quiet of rural living while being situated eight miles west of... read more
NotSold0.001403 -->2.279588
AD #2088
163 acres
Clearwater County, on Hwy 11, @ Range Road 5-5
350,000
AD # 2088
Farm Land For Sale – SW5-39-5W5M
$350,000
Mountain view.
Full quarter section (163.3 acres) on Hwy 11 20 km E of Rocky Mountain House.
2 accesses off Range Road 5-5.
Game fence around entire perimeter and cross-fenced.
70 acres hay, 70 acres pasture, 20 acres trees.
Spring fed water supply.
Oil & Gas Revenue $3700/yr.
Buyer could... read more
NotSold0.001338 -->2.280926
AD #2055
163 acres
Clearwater County, on Range Rd 6-0, 1.5 miles N of Hwy 11
189,000
AD # 2055
Farm Land For Sale – SE12-39-6W5M
$189,000
Mountain view.
Full quarter section (162.93 acres) 1.5 mile N of Hwy 11 on Range Road 6-0 approx 18 km east of Rocky Mountain House.
Pasture / recreational.  Cleared and broke and seeded to grass 1981-1982.
Access off secondary Range Road 6-0.
5-strand high tensile steel perimeter fence.... read more
NotSold0.001846 -->2.282772
AD #2035
Acreage
212 Clearwater Heights Place, 7 miles west of Caroline
$385000.00
AD # 2035
Beautifully located raised bungalow on 1.23 acres in the West Country 7 miles West of Caroline. Situated just 10 minutes from the foothills of the Rockies, this home could be a bed and breakfast, a family get-a-way spot or a family home. With Alford creek running just out back for fishing or just for the kids to play in during those summer days.... read more
NotSold0.001399 -->2.284171
AD #2075
rural acreage 80 acres
19418 Twp Rd 530, S 1/2 Sw 5 53 19 W5
$710,000
AD # 2075
This modern energy efficient home is situated on 80 acres of subdividable, fenced, rolling field and forested land with a year round flowing creek dividing the property. There is ample graze for both horses and cattle.

A fishing lake is located on the edge of the property. The lake, which is in the north half of the quarter, has been designated... read more
NotSold0.0013669999999999 -->2.285538
AD #2028
4.25 acres (Recreational)
Alford Creek Road
$179,000.00
AD # 2028
Price Reduced!
This 4.25 acres of parklike property is ready for your Cabin or Home.  17 ft. RV dual axle unit could stay.  13 km's West of Caroline on Hwy 54, / becomes Hwy 591.  Fully serviced and fenced, 2 plus acres fully cleared. Ready to use power, water, and septic.  1000 gal holding tank and pressurized septic field.  Includes 16 x 64 gravel pad for... read more
Sold0.001449 -->2.286987
AD #2050
Acreage
25
$309,999
AD # 2050
SOLD
Gorgeous location in west country, only 2km of gravel on a no-exit road. Minutes to amazing trails & crown land, with springs & lakes (great hiking, biking, fishing, quadding, snowmobiling, tobogganing, picnic/bonfires right from your doorstep), just 3min to Clearwater Store, 10min to Phyllis Lake, 7min to Caroline, 10min to Burntstick Lake, 15min... read more

Sponsored Links

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

Southwest Calgary Homes

NotSold0.0042180000000001 -->2.291205
AD #2039
4 split level
Calgary, AB
515,000.00
AD # 2039
This no smoking 4 level split home is located in quiet neighborhood of the Braeside Estate in SW of Calgary, and offers 2,080sq.ft of developed living area. Largely renovated in the past which includes: floor replacement, kitchen replacement including appliances, renovation of all the bathrooms, replaced fixtures, some windows were replaced, new... read more
NotSold0.001765 -->2.29297
AD #2036
4 level side split
243 Shawnessy Dr SW, Calgary, AB Canada, T2Y1J2
$484,700.00
AD # 2036
This home has a total of 2334 sq ft of finished floor area.Show home when built, lots of oak, Vinyl siding and brick exterior, Asphalt shingle roof replaced with lifetime shingles March 2013.  Flat fenced site, Paved lane, Playground nearby,  Shopping nearby, Schools in walking distance J Johnstone, Father Doucette. Samuel Saul. Bus stop outside... read more
NotSold0.0022989999999999 -->2.295269
AD #2031
Bungalow
1023 Cannock Pl.S.W.
419,000
AD # 2031
New high efficiency furnace, New hot water tank, New hardwood flooring, maple kitchen cabinets, walk in closet, developed basement, deck, close to Elementary School, Junior High, High School, Fish Creek Provincial Park, Leisure Center, Shopping, this updated bungalow is in the desirable neighborhood of Canyon Meadows in the South West.
Mature... read more
NotSold0.001328 -->2.296597
AD #2026
Condo
1724-26 Ave SW, Calgary AB , T2T 1C8
280,000
AD # 2026
SELLER FINANCING

A quiet, top floor apartment in a new, concrete, 4-storied up-town building. Heated underground parking. Your private washer and dryer, stainless steel dishwasher, stove, and fridge. A carpeted balcony. Close to major roads, steps to downtown with the abundance of all the amenities. Minutes walk to schools. Beautiful window... read more
NotSold0.001061 -->2.297658
AD #2014
Condominium/Strata
309-2411 Erlton Rd SW, Calgary AB
$399,000
AD # 2014
This beautiful, upgraded 2 bedroom, 2 bathroom condo in Erlton boasts a great open-concept layout with 9 foot ceilings and luxurious finishes including Berber carpet, ceramic tile, brand new stainless steel appliances, maple cabinets, quartz counters, and newly-renovated contemporary kitchen and bathroom. Both extra-large bedrooms have walk-in... read more
NotSold0.0048440000000001 -->2.302502
AD #2020
Detached House
75 Strathridge Grove SW, Calgary, AB, Canada
$869,000
AD # 2020
This custom built immaculate four bedrooms house is located in Calgary's prestigious Strathcona Park only ten minutes to the downtown with spacious backyards and stunning views. Huge kitchen with generous cabinets and central island, formal living and dining RM, Mammoth size family room with gas fire place, tile floor in kitchen, large corner... read more
Sold0.001158 -->2.30366
AD #2038
2 storey detached
Discovery Ridge, S.W.,, Calgary, Alberta
$659,900
Reduced - owner relocating
AD # 2038
Price Reduced!
Meticulously maintained 4bed + den, 3.5 bath Morrison Home (2001) on
quiet court near park. Pie shaped lot; 2800’ of finished space; 3 levels;
backs onto treed grasslands; wildlife at your doorstep; privacy galore; rear
raised deck, mature trees, views; kitchen w/ beautiful newly installed granite counters, granite island, 5 brand new s/s... read more

Sponsored Links

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

Red Deer And Area

NotSold0.004311 -->2.307971
AD #2106
Bungalow 157 +/- acres
Lot 361071, Range Rd. 6-3, Clearwater County, Alberta
$875,000.00
AD # 2106
WESTCOUNTRY RANCH
Located 90 min. NW of Calgary, 157 +/- acres secluded ranch.  Tame hay, pasture, bush & yr. round, springfed creek crosses property. State of the art boiler system heats 1360 sq. ft. 2 bd. 1 1/2 bath home built in 2004, as well as 64x40 metal sided shop (inside & outside) with mezzanine which houses separate 2 bdrm, 1 bath self... read more
NotSold0.001827 -->2.309798
AD #2105
150 acres
West Central Alberta
AD # 2105
NATURE LOVER'S PARADISE!

Please visit our website for all the information on this one of a kind property and opportunity:  http://www.natureloversparadise.ca... read more
NotSold0.002188 -->2.311986
AD #2100
4-plex (1 unit)
5029 48st. Unit B, Olds AB, Canada
$205,000.00
AD # 2100
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
Sold0.001578 -->2.313564
AD #2101
Residential Detached
Red Deer, Alberta
$418,000
AD # 2101
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

Sponsored Links

Business Valuation

Northwest Calgary Homes

NotSold0.0026630000000001 -->2.316227
AD #2037
two storey
Panatella square NW
$ 489.000
AD # 2037
This beautiful Triumph is under construction by Shane homes with possession in  August 2010. Two storey homes of 2055 sq., three bedrooms  with bonus room and 2 1/2 bathroom. Main floor is open concept plan with 9' ceiling, hardwood and ceramic floor. Kitchen is dark maple, with granite countertop, stainless appliances, raised breakfast... read more
NotSold0.001427 -->2.317654
AD #2027
Residential Detached
6632 Bowness Road, NW, Calgary Alberta
$419,900
AD # 2027
Four levels split home in the heart of trendy part of Bowness. Excellent location, it is a block away to the Bow River, and a few minutes to Shouldice and Bowness parks. Canada Olympic Park, the Children’s' Hospital, the University of Calgary and Downtown are all in close range as well. Convenient access to public transportation (bus stops... read more
NotSold0.001802 -->2.319456
AD #2022
RESIDENTIAL DETACHED SINGLE FAMILY HOME
88 COUNTRY HILLS GROVE NW, CALGARY AB
$439,000
AD # 2022
VERY GOOD INVESTMENT PROPERTY OR TO LIVE IN RENOVATED HOUSE NEW PAINT CARPET MOULDINGS FIXTURES 1998 BUILT IN ,IN A NICE NEIGHBORHOOD

MAIN FLOOR BIG KITCHEN FAMILY ROOM WITH FIREPLACE BIG DECK AND A LIVING ROOM .UPPER FLOOR 3 BEDROOM 2 FULL WASHROOM.
1 BEDROOM SUITE IN THE BASEMENT RENTED FOR $900 .CLOSER TO ALL AMENTIES SCHOOLS BUSES MALL... read more
Sold0.001213 -->2.320669
AD #2049
Semi-attached bungalow
Calgary, Alberta
$352,000
AD # 2049
Cambrian Heights N.W. Calgary - Semi Attached Bungalow


Centrally located and steps from Confederation Park; 1,013 sq ft on main floor; 3 bedrooms; 4 pc bath on main (recently redone by "Bathfitter"); half bath down; LR and MBR: refinished oak hardwood; 2 BRs and hall: carpet; 4 appl.; cathedral ceilings; full basement - partially... read more
Sold0.0013810000000001 -->2.32205
AD #2046
2 Story
Calgary, AB
559,900.00
AD # 2046
Price Reduced!
Attention: Realtors bring in a qualified buyer, will pay a commission

Located in the heart of beautiful Scenic Acres within walking distance of 2 schools, the Crowfoot LRT and the Crowfoot Shopping Mall.



Taking living to the next level, this Albi home located in the beautiful community of Scenic Acres offers 2064 square feet of living... read more

Sponsored Links

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

Edmonton And Area

NotSold0.0046529999999999 -->2.326703
AD #2141
4 - 28 ft x109 ft lots
opal alberta
50000.00 O.B.O.
AD # 2141
Price Reduced!
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.

... read more
NotSold0.001492 -->2.328195
AD #2136
detatched
1727 Haswell Cove, Edmonton, AB , T6R3A9
529,000
AD # 2136
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
NotSold0.001214 -->2.329409
AD #2135
House (Land) (Recreational)
51271 Range Road 30, Leduc County, Alberta, Canada
$2,500,000
AD # 2135
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
NotSold0.00179 -->2.331199
AD #2134
Bungalow
4521 52 Street, Leduc, AB
269,000
AD # 2134
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
NotSold0.0013069999999999 -->2.332506
AD #2120
Condo/High Rise
#1714 13910 Stony Plain Rd., Edmonton, AB
$210,000
AD # 2120
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
NotSold0.0013620000000001 -->2.333868
AD #2104
Condo
107, 10730-112 Street, Edmonton, Alberta, T5H 3H1
$149,000.00
AD # 2104
Large one bedroom, one bath main floor condo completely upgraded (not a basement unit). 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 New panel doors, brushed nickel door hardware, faucets and light fixtures. New plumbing. New Laminate... read more
NotSold0.001328 -->2.335196
AD #2042
116 acres
1 mile West of Stony Plain, NE-11-053-01-W5, Parkland County
$25,000/acre
AD # 2042
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
NotSold0.0012399999999999 -->2.336436
AD #2043
Photography
5021 50 Street, Vegreville, AB, T9C 1R3
$59 000
AD # 2043
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
Sold0.001132 -->2.337568
AD #2140
39.33 Acres
Sturgeon County, Alberta
$665 000.00
AD # 2140
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
Sold0.001348 -->2.338916
AD #2137
.16 acres
Edmonton, Alberta
$250000
AD # 2137
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
Sold0.001679 -->2.340595
AD #2122
Approx. 80 acres
North half
$195,000
AD # 2122
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

Sponsored Links

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

Northern Alberta

NotSold0.003349 -->2.343944
AD #2071
bungalow
32 Willow Creek Street, Smoky Lake, Alberta, T0A 3C0
$39,500.00
AD # 2071
Open House!
This house is a cute little bungalow situated close to the Town of Smoky Lake's downtown amenities.   It is part of an estate sale and there is motivation to sell - as is indicated by the low price.  If you are into DIY projects, this property will meet the bill!  The ideal location presents itself to many alternatives for the right buyer. ... read more
NotSold0.0017779999999999 -->2.345722
AD #2069
side-by-side duplex
Rainbow Lake, AB
299000
AD # 2069
INVESTOR ALERT!!! Having a hard time finding a revenue property that "works"? Well, THIS IS IT! This side by side duplex offers a fantastic rental income PLUS has an excellent rental history! What MORE could you ask for? Live up north and need a place to live??? No problem! Live in one side and rent out the other while PAYING OFF YOUR... read more
NotSold0.001309 -->2.347031
AD #2068
Executive Cedar Home (Recreational)
208 Centre Ave, Robb, Alberta Canada
$458,888.00
AD # 2068
Recreation or Bed and Breakfast Home in Alberta CANADA

This 3,420 sq ft Cedar Home is located in the hamlet of Robb in Yellowhead County, approximately 45 km South of Edson, Alberta. The hamlet of 400 people has a general store, hotel with restaurant, museum, a volunteer fire department and a new community hall with a curling rink. The large... read more
NotSold0.001127 -->2.348158
AD #2067
RV Park
Box 154, Enilda, Ab, T0G 0W0
$940,000
AD # 2067
This wonderful little stay at home business has been privately owned and operated since 1996. It is located on 115 acres of land which includes 30 RV sites and a Driving Range, 2 mobile home rentals and 90 acres used for haying. The RV Park is located just off of Hwy #2, 11 miles east of High Prairie in Northern Alberta.

Business has been... read more
NotSold0.0013120000000001 -->2.34947
AD #2125
Bungalow
65 Fitzsimmons Ave, Fort McMurray, Alberta
AD # 2125
LOCATION, LOCATION, ETC. : PRIME INVESTMENT PROPERTY

Retiring and moving south. Rare opportunity to own and/or invest in this very desirable -one of the few- huge 18,000 sq. ft. (60' x 300' = 0.4 acre) property at the fringe of downtown in a quiet neighborhood at 65 Fitzsimmons Ave. This park-like property is fenced and fully landscaped... read more
NotSold0.0011789999999999 -->2.350649
AD #2051
cedar log (Land) (Recreational)
Whitecourt, Alberta
$1,150,000
AD # 2051
Price Reduced!
SUPERB CANADIAN CEDAR LOG HOME
ON LAKE FRONT PROPERTY

This cedar log 3 bedroom home has spacious living area with high open beam vaulted ceilings to enjoy an abundance of natural light from the kithchen plant window and the clerestory windows in the living and dining rooms. The master bedroom also boasts an open beam ceiling.This home has a... read more

Sponsored Links

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

Debug:
REGION:00002Cats
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, %Alberta%, published)[0][48]
query1->0.018314
query3->0.032178 -->0.066274
(107)
query3->0.036935 -->0.103209
(107)
query3->0.080441 -->0.18365
(107)
query3->0.031484 -->0.215134
(108)
query3->0.033443 -->0.248577
(108)
query3->0.052042 -->0.300619
(108)
query3->0.029669 -->0.330288
(108)
query3->0.031538 -->0.361826
(25)
query3->0.104972 -->0.466798
(25)
query3->0.028538 -->0.495336
(25)
query3->0.033006 -->0.528342
(25)
query3->0.047833 -->0.576175
(25)
query3->0.09982 -->0.675995
(25)
query3->0.057638 -->0.733633
(25)
query3->0.035876 -->0.769509
(25)
query3->0.028454 -->0.797963
(106)
query3->0.058476 -->0.856439
(106)
query3->0.034169 -->0.890608
(106)
query3->0.047609 -->0.938217
(106)
query3->0.03908 -->0.977297
(106)
query3->0.038099 -->1.015396
(106)
query3->0.056243 -->1.071639
(106)
query3->0.045569 -->1.117208
(29)
query3->0.081055 -->1.198263
(29)
query3->0.033242 -->1.231505
(29)
query3->0.024396 -->1.255901
(29)
query3->0.043849 -->1.29975
(104)
query3->0.043082 -->1.342832
(104)
query3->0.063938 -->1.40677
(104)
query3->0.030011 -->1.436781
(104)
query3->0.084049 -->1.52083
(104)
query3->0.041951 -->1.562781
(28)
query3->0.014085 -->1.576866
(28)
query3->0.034931 -->1.611797
(28)
query3->0.055336 -->1.667133
(28)
query3->0.037196 -->1.704329
(28)
query3->0.034443 -->1.738772
(28)
query3->0.031184 -->1.769956
(28)
query3->0.070088 -->1.840044
(28)
query3->0.033436 -->1.87348
(28)
query3->0.041291 -->1.914771
(28)
query3->0.035605 -->1.950376
(28)
query3->0.044327 -->1.994703
(24)
query3->0.019766 -->2.014469
(24)
query3->0.035267 -->2.049736
(24)
query3->0.027416 -->2.077152
(24)
query3->0.033694 -->2.110846
(24)
query3->0.034513 -->2.145359
(24)+
runtime(2.353077)
Canadian Maple Leaves
Canadian Maple Leaves