|
|
|
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:00009Cats
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, %Nova Scotia%, published)[0][11]
query1->0.017428 Heirarchy0.0016080000000001 -->0.508398 | | | NotSold0.001151 -->0.509549
| 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.024664 -->0.534213
| 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.001633 -->0.535846
| 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.001359 -->0.537205
| 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.0013059999999999 -->0.538511
| 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.001102 -->0.539613
| 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.001433 -->0.541046
| 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.00103 -->0.542076
| 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 |
| | | | | |
| | | | NotSold0.025716 -->0.567792
| AD #9011 | 200 + Acres | New Ross, Nova Scotia, Canada | 495,000 CAN |
|
| 20% off this price from May 1, 2010 to July 1, 2010
Lake frontage... wilderness property, income property or recreation property... if that’s what you’re looking for , this could be for you.
Don’t miss out on your chance to own a piece of wilderness paradise in New Ross, Nova Scotia, Canada, only 60 miles ( 100 km) from Halifax.... read more |
| Top of Page View Ad Details |
NotSold0.001224 -->0.569016
| AD #9034 | 2 storey | 13152 Highway 3, Upper LaHave, Nova Scotia B4V7C6 | 189,900 $189,000 |
|
| A place to live, a place to have your own business and a rental apartment for additional income. Spacious 2-bedroom owner's living quarters upstairs. One bedroom rental apartment on side of building (presently rented). Main floor has 24'x12' storage/office space, 24'x16' retail space and laundry room; was operated as fireworks... read more |
| Top of Page View Ad Details |
| | | | | |
| | | | NotSold0.0029830000000001 -->0.571999
| AD #9016 | Century "Hobby" Farm | R.R. 4, Civic 5136, West Paradise, Annapolis Co., Nova Scotia | 220,000 |
|
| Beautiful updated Century "Hobby" Farm nestled between the North and South Mountains, West Paradise, Annapolis County. A wonderful view of the Annapolis River at your front door. Skiing and hiking trails at your backdoor. Three and one-half acreage includes large barn with workarea, animal stalls, cold storage, room to house camper,... read more |
| Top of Page View Ad Details |
| | | 1 |
Debug:
REGION:00009Cats
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, %Nova Scotia%, published)[0][11]
query1->0.017428
query3->0.035114 -->0.068063
(72)
query3->0.070199 -->0.138262
(72)
query3->0.075696 -->0.213958
(72)
query3->0.071268 -->0.285226
(72)
query3->0.031422 -->0.316648
(72)
query3->0.048997 -->0.365645
(72)
query3->0.032454 -->0.398099
(72)
query3->0.04247 -->0.440569
(72)
query3->0.030661 -->0.47123
(79)
query3->0.009791 -->0.481021
(79)
query3->0.025769 -->0.50679
(78)+
runtime(0.574038) | | | |
|
| |
