#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-amazing-location-large-room-kitchener-oct-1-refH13082391654542.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
Amazing Location, Large Room, Kitchener, Oct 1 $ - Contact now!

Colocation: Amazing Location, Large Room, Kitchener, Oct 1

Amazing Location, Large Room, Kitchener, Oct 1

Property ID: H13082391654542

Price: 510 $

Adress : Kitchener, South West Ontario, Canada

Available from : 1-Oct-2013

Full Description

$510/month including utilities for Large (+/-)13?x11.5? Main Floor Room. · 2 Bathrooms (main floor and 2nd floor) with 2 showers (Main floor and Basement) · Parking Available with extra spots for visitors · Close to Expressway (1 min) · Walking distance to multiple restaurants and convenience store · 5 Minute drive to Walmart, Sobeys, The Beer Store and many others · Join 3 clean, easygoing, young male professionals working in the Real Estate industry, banking industry, and automotive industry. · Private, quiet, locked room · Dry basement for storage · Free Laundry · Move in October 1st Come take a look at a great place to live, with great people The Long Version (Down and Dirty) -Charming and affordable 4 bedroom Century home with a great location! -Large backyard with fire pit, clothesline, shed, and vegetable garden. -Large common living room and large dining room. -Lots of counter space in the open kitchen. -Dry basement with room for storage -Laundry is free with modern appliances -Common areas are nicely furnished -New wrap around deck to go in next spring -1 minute from highway 85 -Parking available in the HUGE (85?x18?) 6+ car Double driveway with room for visitors. People who you will live with: · 3, Single, mid 20?s young professionals in the Real Estate industry, banking industry, and automotive industry. · Landlord will be living in the house and extremely accessible for any issues that may come up during your time at 380 Lancaster. · Easy going guys that like to keep a cool, clean, relaxed living space. · Football and hockey fans. (Go Packers) · They enjoy having a few beers in front of a fire on a cool summer night and long walks on the beach. · Frequent ?family style? dinners with 2 great cooks in the house. · Each tenant has a car, but with alternating work shifts, and a huge double driveway, moving cars will rarely happen. Amenities nearby: -Forwell convenience across the street -Public Restaurant & Bar, and Kypreos (best breakfast in Kitchener) is a 9 iron away. -Need a haircut? Across the street there is a hairdresser and barbershop -Brand new office building with Dentist, City Café, Subway and Convenience Store within 3 minute walk -5 minute drive to Wal-Mart, Sobeys's, Beer Store, Shoppers Drugmart. -Within a 15 minute drive to anywhere in Kitchener or Waterloo -Feel like a drink? Go across the street, or Take a 10 min walk to the best BBQ in Waterloo Region, Lancaster Smokehouse, where they have a wide selection of craft beer, southern cocktails, and my personal favourite, the 3 meat platter. Are you the right one for this house? Would you rather have a yard and large room than a hipster condo? Are you a clean, mature, male or female in their later years in university or a young professional. Do you have a reference, proof of employment? Are you able to move in October? Are you able to pay $510 in rent? Do you have a deposit cheque? Are you cool? Student? It?s a 10 minute drive, or 25 minute bus route to Laurier and Waterloo, with a bus stop one house over. Work at Communitech or Downtown and would like to live in a house rather a hipster condo? It?s an 8 minute drive to King and Victoria, or take the 6 bus for a 15 min ride right to work. Live with Kitchener bylaws but close to waterloo. That means a fire pit, overnight parking, Saturday afternoon BBQs with friends etc. Great (under 40y/o) neighbors to both sides who are easygoing. Give me a call to coordinate a tour or for any questions.

Rooms information

Rooms information
Bedrooms available 1
Bathrooms 2

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