|
|
|
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:00072Cats
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, %Cape Breton Island%, published)[0][8]
query1->0.023363 Heirarchy0.001313 -->0.251532
|
|
Regions of
Cape Breton Island | | | | NotSold0.002011 -->0.253543
| AD #9031 | Mobile Home | Veterans Memorial Drive (Lower Rd), Arichat, Isle Madame, | $155,000. |
|
| This valuable well maintained property fronts onto Arichat Harbour and has magnificent views of Jerseyman Islands and Cape Auguet.
The whole property is cleared and flower gardens and lawns have been developed. It is 25 minutes from Port Hawkesbury and Isle Madam is connected to Cape Breton Island by a short causeway.
The Mobile Home, which... read more |
| Top of Page View Ad Details |
NotSold0.018883 -->0.272426
| AD #9029 | +/- 5 acres with 130' frontage on Bras D'or Lakes | Baddeck Bay Road, Baddeck, Cape Breton, Nova Scotia, Canada | $475,000 Cdn |
|
| Bras d’Or Lakes Waterfront Property For Sale...Baddeck Bay, Nova Scotia, Canada
Undeveloped high-potential property overlooking the renowned Bras d’Or Lakes and the hills of Beinn Bhreah (and the summer estate of the late Alexander Graham Bell). This unique woodland parcel comprises approximately 5 acres, includes cleared water frontage... read more |
| Top of Page View Ad Details |
NotSold0.00151 -->0.273936
| AD #9025 | 11 Acres | Cape Auget, Isle Madame | C$156,000 |
|
| 11 acres of undeveloped rolling hillside on beautiful Cape Auget with Water frontage on Arichat Harbour and also overlooks Forest Cove.
Excellent Views. 25 minutes from Port Hawkesbury and 1 Hour from Sydney.
Purchaser could easily divide into three generous lots, each with road access.
(other land available on Isle Madame)
Phone: ... read more |
| Top of Page View Ad Details |
NotSold0.0011099999999999 -->0.275046
| AD #9021 | 10 acres | Sight Point Road@Broad Cove Banks, Inverness, Cape Breton, Nova Scotia | 216,000.00 |
|
| Only 5 minutes off the beaten track but with ultimate privacy and seclusion.
Located in Sight Point area of Inverness, Nova Scotia on Cape Breton's Scenic Route 19 to the Cabot Trail.
The Town of Inverness has a pop. of approx 1500 and has a friendly attitude. Inverness has a Consolidated School, A Regional Centre Hospital, great food and... read more |
| Top of Page View Ad Details |
NotSold0.001165 -->0.276211
| AD #9018 | 1 & 2 acre Serviced Building Lots | Broad Cove Banks Road, Inverness, Cape Breton, Nova Scotia | 1 Acre Lots From $38,000 |
|
| If you are interested in getting off the grid to one of the least polluted environments anywhere, where the air is clear and clean and the water is clear and clean, where there is no industrial source polluting the air and water, you should take a look. This natural haven offers all the good that the outdoors have to offer with excellent hiking... read more |
| Top of Page View Ad Details |
NotSold0.001186 -->0.277397
| AD #9008 | 50 Acres | L'Ardoise Highlands Road, Lower L'Ardoise, Richmond County, Nova Scotia | 90,000.00 Cdn |
|
| Situated in the province of Nova Scotia, Canada. A 50 minute drive from the city of Sydney, 35 minutes from the town of Port Hawkesbury and 60 minutes from the Sydney airport.
Orientation: Fleur de Lis Highway, Lr. L'Ardoise,
Richmond County, Cape Breton, Nova Scotia.
Total Surface: 50 Acres
A 346 ft. lake... read more |
| Top of Page View Ad Details |
Sold0.001205 -->0.278602
| AD #9026 | Waterfront | St Peters | 490,000 for the home and 60,000 for lot next door total 550,000 (will not be sold separately). |
|
| SOLD This is a custom designed Bras D’0r lakeside home in McNab Cove on a parcel of land consisting of two lots totalling 6.013 acres. The home is built on one lot while the other is vacant and can be sold off without any severance issues if the purchaser wishes. The lake frontage is approximately 540 ft.
The home is very well built with 2x6... read more |
| Top of Page View Ad Details |
Sold0.001128 -->0.27973
| AD #9028 | Mixed-use building | Arichat, Nova Scotia | $275,000 CAD |
|
| SOLD This is a mixed-use building in the heart of historic Arichat, Nova Scotia, directly across the street from the restored waterfront district and overlooking Arichat Harbour.
The building includes three two-bedroom apartments, two bachelor suites, and one one-bedroom apartment as well as three offices and a 1500-square foot ground floor... read more |
| Top of Page View Ad Details |
| | | 1 |
Debug:
REGION:00072Cats
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, %Cape Breton Island%, published)[0][8]
query1->0.023363
query3->0.030879 -->0.069463
(72)
query3->0.039717 -->0.10918
(72)
query3->0.035999 -->0.145179
(72)
query3->0.030106 -->0.175285
(72)
query3->0.026321 -->0.201606
(72)
query3->0.017227 -->0.218833
(72)
query3->0.015673 -->0.234506
(72)
query3->0.015713 -->0.250219
(72)+
runtime(0.302587) | | | |
|
| |
