|
|
|
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!
|
| | | |
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, %Edmonton And Area%, published)[0][11]
query1->0.012105
Heirarchy0.056974 -->0.644113
|
|
Regions of
Edmonton And Area | | | | NotSold0.001129 -->0.645242
| 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.0036079999999999 -->0.64885
| 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.0014690000000001 -->0.650319
| 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.001848 -->0.652167
| AD #2133 | Bungalow | 5611-105A Avenue, Edmonton, AB | $435,000 |
|
| • 1120 square foot Bungalow in Fulton place, this 1956 home has had the main floor and basement fully renovated.
• The renovations include new oak hardwood flooring throughout the main floor, an upgraded main bathroom with a pedestal sink, deep tub/shower and glass block, and a newer roof.
• The kitchen offers oak cabinets, stainless... read more |
| Top of Page View Ad Details |
NotSold0.001591 -->0.653758
| 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.001345 -->0.655103
| 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.001359 -->0.656462
| 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.0013649999999999 -->0.657827
| 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.00143 -->0.659257
| 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.001297 -->0.660554
| 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.001321 -->0.661875
| 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:
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, %Edmonton And Area%, published)[0][11]
query1->0.012105
query3->0.010853 -->0.044043
(28)
query3->0.02152 -->0.065563
(28)
query3->0.060615 -->0.126178
(28)
query3->0.131278 -->0.257456
(28)
query3->0.029202 -->0.286658
(28)
query3->0.06658 -->0.353238
(28)
query3->0.097076 -->0.450314
(28)
query3->0.037849 -->0.488163
(28)
query3->0.034536 -->0.522699
(28)
query3->0.033076 -->0.555775
(28)
query3->0.031364 -->0.587139
(28)+
runtime(0.667686) | | | |
|
| |
