|
|
|
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, %Southern Alberta%, published)[0][6]
query1->0.009138
Heirarchy0.045662 -->0.278706
|
|
Regions of
Southern Alberta | | | | NotSold0.0011720000000001 -->0.279878
| 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.012274 -->0.292152
| 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.0034719999999999 -->0.295624
| AD #2085 | 80 acres | 8 miles west of Medicine Hat on Holsom Road | 719,000 |
|
| approximately 1650 square foot bungalow with a just renovated full basement & 3 car garage / central air conditioning/ central vacuum / wood burning stove in family room / fridge, stove, compactor, dishwasher, washer & dryer included / automatic underground sprinklers / 10 minutes from Medicine Hat on paved road / approximately 30' x 56'... read more |
| Top of Page View Ad Details |
NotSold0.004596 -->0.30022
| AD #2082 | 1 1/2 Storey House | 112 South, 1st Street East, Hill Spring | $175,000 |
|
| First storey is original log house. Main house has stucco exterior, asphalt shingles on the roof, vinyl siding on porch. Large wooden deck attached on east side of house. Yard is completely fenced and includes dog run.
Hardwood floors in living room and upstairs. Lino in rest of house.
Forced air furnace, natural gas, installed... read more |
| Top of Page View Ad Details |
NotSold0.005431 -->0.305651
| 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.004456 -->0.310107
| 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 |
| | | |
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, %Southern Alberta%, published)[0][6]
query1->0.009138
query3->0.01212 -->0.04186
(27)
query3->0.036527 -->0.078387
(27)
query3->0.057115 -->0.135502
(27)
query3->0.024195 -->0.159697
(27)
query3->0.063677 -->0.223374
(27)
query3->0.00967 -->0.233044
(27)+
runtime(0.322694) | | | |
|
| |
