#ERROR RECU:SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT Error number: HY000 Error message SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT Error SQL SELECT DISTINCT bdd_country.cny_idt, bdd_country.cny_lib_fr as cny_nam, bdd_country.cny_lib_fr as loc_name, bdd_country.cny_lib_simple FROM bdd_country INNER JOIN flatshare ON flatshare.cny_idt = bdd_country.cny_idt ORDER BY cny_lib_seo ASC Error URL /immobilier/collocation-river-s-edge-constance-bay-refH13082118727269.html 0:HY000 1:3065 2:Expression #1 of ORDER BY clause is not in SELECT list, references column 'superexpat.bdd_country.cny_lib_seo' which is not in SELECT list; this is incompatible with DISTINCT
Warning: Illegal string offset 'cny_idt' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 409

Warning: Illegal string offset 'loc_href' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380

Warning: Cannot use a scalar value as an array in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380

Warning: Illegal string offset 'cny_idt' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 409

Warning: Illegal string offset 'loc_href' in /usr/share/nginx/superexpat/www/Front/plugins/flatshare/ClassFlatshareDescriptor.php on line 380
River's Edge, Constance Bay $ - Contact now!

Colocation: River's Edge, Constance Bay

River's Edge, Constance Bay

Property ID: H13082118727269

Price: 500 $

Adress : Western Suburbs, Ottawa, Canada

Available from : 26-Aug-2013

Full Description

Description Ahhhh, the tranquility and serenity of cottage life and yet so close to the city. 2 bedroom located in the village of Constance Bay, on desirable waterfront. Vintage character cottage built in 1920s. Great deck and great swimming, boating and sand beach at your door step. Not winterized. Located on the Ottawa River and the Torbolton Forest Preserve. Close to all amenities, local store, LCBO, Bar, community center etc. Minutes away from golf, and 40 min drive to all of the tourist highlights in downtown Ottawa (Canada's Capital City). Parliament Hill, museums and the Rideau Canal. Enjoy a spectacular sun rise or the rising moon at night, or just gaze at the stars. Witness the Gatineau Hills and the Canada Geese.

Rooms information

Rooms information
Bedrooms available 2
Bathrooms 1

Flatmate information :

Flatmate information Flatmate preferences information
Gender DoesntMatter Gender DoesntMatter
Age N/A Age N/A - N/A
Smoker DoesntMatter Smoker DoesntMatter
Occupation N/A Occupation DoesntMatter
Pets N/A Couples NotDisclosed
. .
Une Assurance Santé sur Mesure
Une Assurance Santé sur Mesure

ACS, spécialiste de la protection sociale pour expatriés avec plus de 20 ans d'expérience. Demandez un devis dès maintenant!

BUPA GLOBAL
BUPA GLOBAL

Pour aider les individus et les familles à vivre une vie plus longue, plus saine et plus heureuse.

Contactez l'équipe SuperExpat
Contactez l'équipe SuperExpat

Sélection de prestataires, produits et services relatifs à votre déménagement et votre vie à l’étranger... Logement, Finance, Assurance…

Assurance Vie Pour Expatriés!
Assurance Vie Pour Expatriés!

Comparez les offres. En tant qu'expatrié bénéficiez de l’exonération de droit de succession meme apres retour en France!

Transfert Au Meilleur Taux!
Transfert Au Meilleur Taux!

Transferez et changez votre argent au meilleur taux. Paiements Internationaux Importants, Transfert réguliers, Couverture Taux. Devis & Conseils Gratuits!

Vous avez entre 58 et 65 ans?
Vous avez entre 58 et 65 ans?

Faites appel à des experts spécialisés en audit et bilan retraite: Calcul, Rachats de trimestres, Age de départ, interventions auprès des caisses de retraite...

. .

Articles & Guides

Articles & Guides