|
|
|
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: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][47]
query1->0.025814 Heirarchy0.001445 -->1.469513 | | | NotSold0.00083900000000003 -->1.470352
| 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.062065 -->1.532417 NotSold0.0018210000000001 -->1.534238
| 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.044392 -->1.57863
| 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.00179 -->1.58042
| 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.001241 -->1.581661
| 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.0012639999999999 -->1.582925
| 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.0015660000000001 -->1.584491
| 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.0030359999999999 -->1.587527
| 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.0013580000000001 -->1.588885
| 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.0025799999999999 -->1.591465
| 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.0025500000000001 -->1.594015
| 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.002399 -->1.596414
| 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.001215 -->1.597629
| 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.001348 -->1.598977
| 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.001827 -->1.600804
| 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 |
| | | | | |
| | | | NotSold0.004535 -->1.605339
| AD #2071 | bungalow | 32 Willow Creek Street, Smoky Lake, Alberta, T0A 3C0 | $39,500.00 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.002731 -->1.60807
| AD #2069 | side-by-side duplex | Rainbow Lake, AB | 299000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.0014719999999999 -->1.609542
| AD #2068 | Executive Cedar Home (Recreational) | 208 Centre Ave, Robb, Alberta Canada | $458,888.00 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001379 -->1.610921
| AD #2067 | RV Park | Box 154, Enilda, Ab, T0G 0W0 | $940,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.0017090000000001 -->1.61263
| AD #2125 | Bungalow | 65 Fitzsimmons Ave, Fort McMurray, Alberta |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.003485 -->1.616115
| AD #2051 | cedar log | Whitecourt, Alberta | $1,400,000 |
|
| 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 |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.004602 -->1.620717
| AD #2093 | bungalow | 3 4354 Highway 27, Westward Ho, Alberta | $239,000.00 |
|
| One acre of well treed privacy just a few walking minutes from the Little Red Deer river!!
Older small house with guest cabin situated a stones throw away from swimming, canoeing, fishing, snowmobiling. Newer flooring (laminate and lino) and appliances, including dishwasher. Newer furnace, water heater and septic system. Covered wrap... read more |
| Top of Page View Ad Details |
NotSold0.002113 -->1.62283
| AD #2092 | +/- 3 acres | NE 8-32-2w5m | $204,900. |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.0028199999999999 -->1.62565
| AD #2088 | 163 acres | Clearwater County, on Hwy 11, @ Range Road 5-5 | 350,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001567 -->1.627217
| AD #2055 | 163 acres | Clearwater County, on Range Rd 6-0, 1.5 miles N of Hwy 11 | 189,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001935 -->1.629152
| AD #2035 | Acreage | 212 Clearwater Heights Place, 7 miles west of Caroline | $365000.00 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.0012380000000001 -->1.63039
| AD #2075 | rural acreage 80 acres | 19418 Twp Rd 530, S 1/2 Sw 5 53 19 W5 | $710,000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001784 -->1.632174
| AD #2028 | 4.25 acres (Recreational) | RR7-2B (#7-Alford Creek Road), Lot 2, Plan 002-4614, sw1/4, sec5, 36-7-5 | $189,000.00 |
|
| 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 |
| Top of Page View Ad Details |
Sold0.0019499999999999 -->1.634124
| 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 |
| Top of Page View Ad Details |
| | | | | |
| | | | Outside Of Calgary Business / Land / OtherNotSold0.0034540000000001 -->1.637578
| AD #2015 | 64 acres | Bragg Creek, Alberta | 2500000.00 |
|
| Sixty four gorgeous acres for sale located off hi way 66 in Bragg Creek, Alta. This property offers unlimited potential for a subdivision, resort, get-away cabins or your very own dream home. With already established gas, power and telephone lines on the property. It is close to Kananaskas Country, a great place to go hiking site seeing or... read more |
| Top of Page View Ad Details |
NotSold0.003224 -->1.640802
| AD #2011 | 10.03 ACRES | 44111 WEEDON TRAIL, ROCKYVIEW COUNTY, COCHRANE ALBERTA | $548,000 |
|
| Rare 10 acres mountain view, on paved road, breath taking views 360 degrees, 40 minutes to downtown Calgary and 10 minutes to Cochrane. Well drilled. Shared paved approach. County reserve fees paid up. Septic field approved. Land slopes allow a fabulous walkout development. Paved road plowed in winter by County. ... read more |
| Top of Page View Ad Details |
NotSold0.002074 -->1.642876
| AD #2024 | 5.51000 Acres | East of Okotoks overpass, on h-way 552( 5 miles) , turn left on 80th st. | 390,000 |
|
| This Raw land parcel is located just 5 miles east of Okotoks overpass,turn left on 80th st.(north),3rd acreage on right hand side. Mountain views,services to property line,good well(well report avail.)minutes to Heritage Heights k-9 school, Rec centre is to be built nearby,close to 3 golf courses,minutes to Deerfoot Trail and City... read more |
| Top of Page View Ad Details |
NotSold0.0011669999999999 -->1.644043
| AD #2023 | 10 Acres | Next to Elkana Estates, Bragg Creek | $729000 |
|
| Mostly treed south facing slope with two elevated buidling sites. Power, gas and phone installed to property line. ... read more |
| Top of Page View Ad Details |
NotSold0.001316 -->1.645359
| AD #2009 | 15 acres | sw1/4 sec16 twp23 r5 w5 | $ 750,000.00 |
|
| Property situated 5km west of Bragg Creek. Property abuts Bragg Creek on north side . Property has unobstructed mountain views. Power,telephone, well &septic feild, Zoned R3 with possibility of subdivision. Excellent access to property on all weather maintained MD road Adjacent property to the east is 20 acre equestrian ranch, to north and west... read more |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.002843 -->1.648202
| AD #2095 | Acreage Land 5 Acres | 27 | $100-$150,000 $100-$150,000 |
|
| Three 5-Acre lots for sale: 1 at $100,000, 1 at $125,000, and 1 at $150,000.
All services, including City Water. Creek very close for household use.
Near paved roads and within walking distance (2 km) to the best K-9 School in Southern Alberta or buses will pull up to the door.
Near Seven Persons and 15 minutes from Medicine Hat. ... read more |
| Top of Page View Ad Details |
NotSold0.00338 -->1.651582
| AD #2094 | Mobile Home | Claresholm, Alberta | $168,000.00 |
|
| Mobile home with 3 bdrms, 2 full bathrooms, laundry room, incl. all appliances, insulated garage, garden shed,landscaped and fenced lot, paved parking pad in front of garage. Call for more information or to arrange a viewing.... read more |
| Top of Page View Ad Details |
NotSold0.0021089999999999 -->1.653691
| AD #2066 | 160 acres (Recreational) | NW-20-5-2-W5 | $2700000 |
|
| This is a rare opportunity to purchase one of the best recreational properties nestled in the Rockie Mountains of Southern Alberta. Located between Castle Mountain Resort and Pincher Creek this 160 acre parcel is very secluded with great access. Being 30km from Pincher Creek, 21km to Castle Mountain and 40km to Crowsnest Pass leaves you open to... read more |
| Top of Page View Ad Details |
NotSold0.001591 -->1.655282
| AD #2139 | Plumbing & Heating | Southern Alberta, Milk River, Alberta |
|
| Plumbing & Heating Business with Laundromat. Servicing Southern Alberta
Small community living
Owner retiring
Includes two 50 x 100 lots, full line of plumbing and office equipment with service truck. Shop, office and laundromat on main floor, 2000 sq.ft. residence upstairs.
Reasonably Priced! ... read more |
| Top of Page View Ad Details |
| | | | | |
| | | | Calgary Business / Land / OtherNotSold0.002957 -->1.658239
| AD #2041 | 3.85 acres | 55 Gray Way NW, Bearspaw | 559,500 |
|
| Rare 3.75 Acres In The Heart Of Bearspaw
An expansive 3.75 acres in the heart of Bearspaw. This sun-drenched pie-shaped lot is ready for you to build your dream home. Trees line much of the perimeter, along the quaint country-style fencing. The property is part of the Rockyview Water Co-op. No building timelines - build your dreamhome with... read more |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.0033810000000001 -->1.66162
| AD #2005 | (Home) option adjacent 20 acres | 30 min SW of Calgary | $ 995k with 20 acres 20 acres bare $ 549k |
|
| 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 |
| Top of Page View Ad Details |
Sold0.003379 -->1.664999
| AD #2000 | Hillside Bungalow (Land) | Cochrane, Alberta | 799,000 |
|
| 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 |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.002903 -->1.667902
| AD #2040 | (Home) | 131 Sandarac Place NW, Calgary, AB, T3K 2Y5 | 395,000.00 |
|
| *Please contact us at home after 5:00pm @ 403-775-7611, from Monday to Friday.
Saturday and Sunday after 9:00 am. Mountain Standard TIme.
*Cell Phone (403) 471-9459 - Monday to Friday from 9:00 am to 5:00pm.
Beautiful recently renovated house in an established NW area. Located in a quiet Cul De Sac.
-3 minutes walking distance to 2... read more |
| Top of Page View Ad Details |
NotSold0.002958 -->1.67086
| AD #2037 | two storey | Panatella square NW | $ 489.000 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.0012799999999999 -->1.67214
| AD #2027 | Residential Detached | 6632 Bowness Road, NW, Calgary Alberta | $419,900 |
|
| 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 |
| Top of Page View Ad Details |
NotSold0.001963 -->1.674103
| AD #2025 | (Home) | 7712 68th Ave NW, Calgary Alberta | $499,900 |
|
| The family home you been waiting for in Silversprings
1956 sq ft 2 story 4 bedrooms, 3.5 bathrooms, 3 gas fireplaces, and for the relaxing time after you move in a hot tub to enjoy those cold winter nights. Beautiful covered entrance way .Double heated Front Drive garage, matching shed in the back yard.
Upper floor has a Master retreat with... read more |
| Top of Page View Ad Details |
NotSold0.0013749999999999 -->1.675478
| AD #2022 | RESIDENTIAL DETACHED SINGLE FAMILY HOME | 88 COUNTRY HILLS GROVE NW, CALGARY AB | $439,000 |
|
| 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 |
| Top of Page View Ad Details |
| | | 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][47]
query1->0.025814
query3->0.315095 -->0.362746
(29)
query3->0.016486 -->0.379232
(29)
query3->0.059879 -->0.439111
(29)
query3->0.016471 -->0.455582
(28)
query3->0.0092140000000001 -->0.464796
(28)
query3->0.046028 -->0.510824
(28)
query3->0.019091 -->0.529915
(28)
query3->0.009236 -->0.539151
(28)
query3->0.020924 -->0.560075
(28)
query3->0.01328 -->0.573355
(28)
query3->0.021462 -->0.594817
(28)
query3->0.018259 -->0.613076
(28)
query3->0.036184 -->0.64926
(28)
query3->0.261594 -->0.910854
(28)
query3->0.008777 -->0.919631
(28)
query3->0.034763 -->0.954394
(28)
query3->0.044842 -->0.999236
(24)
query3->0.013778 -->1.013014
(24)
query3->0.017076 -->1.03009
(24)
query3->0.015538 -->1.045628
(24)
query3->0.015083 -->1.060711
(24)
query3->0.009505 -->1.070216
(24)
query3->0.014348 -->1.084564
(25)
query3->0.012437 -->1.097001
(25)
query3->0.016524 -->1.113525
(25)
query3->0.023001 -->1.136526
(25)
query3->0.020772 -->1.157298
(25)
query3->0.015126 -->1.172424
(25)
query3->0.01785 -->1.190274
(25)
query3->0.009076 -->1.19935
(25)
query3->0.015182 -->1.214532
(110)
query3->0.013648 -->1.22818
(110)
query3->0.015011 -->1.243191
(110)
query3->0.020556 -->1.263747
(110)
query3->0.01329 -->1.277037
(110)
query3->0.024643 -->1.30168
(27)
query3->0.020402 -->1.322082
(27)
query3->0.015485 -->1.337567
(27)
query3->0.009558 -->1.347125
(27)
query3->0.009402 -->1.356527
(109)
query3->0.020019 -->1.376546
(108)
query3->0.016415 -->1.392961
(108)
query3->0.014687 -->1.407648
(104)
query3->0.015336 -->1.422984
(104)
query3->0.010953 -->1.433937
(104)
query3->0.016474 -->1.450411
(104)
query3->0.017657 -->1.468068
(104)+
runtime(1.678442) | | | |
|
| |
