#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-female-roommate-1-bedroom-available-east-village-refH130806185832390.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
Female roommate- 1 bedroom available East Village $ - Contact now!

Colocation: Female roommate- 1 bedroom available East Village

Female roommate- 1 bedroom available East Village

Property ID: H130806185832390

Price: 1850 $

Adress : East Village, Manhattan, New York City, Etats-Unis

Available from : 1-Sep-2013

Full Description

$1850 (electricity and tv/internet not included, water/gas included) 1 room in a 2BR apartment in East Village starting from september 1st (6months minimum, up to 1 year) fully renovated building 6th floor with elevator doorman 24/7 (very safe) brick wall in living room, hardwood floor balcony (two chairs and a small table, really nice during summer/fall) washer/dryer/dishwasher in apartment big washers/dryers in the basement bathroom with bathtub and lots of storage space AC/Heat in all rooms (except bathroom) fully equipped kitchen (microwave, oven, big fridge, coffee machine) furnished apartment except for the room (big TV, playstation, couch, table, etc) living room has huge windows (floor to ceiling), lots of light. storage space available in living room. About the room : One window and two closets in the wall, there?s currently a queen size bed in the room that will be removed by the end of August. I would recommend to have a twin/full bed or even single bed. There?s lots of space for aditional furniture and also possibility to have a TV. The room doesn?t give on the street so you won?t be bothered by noise from the street. Window does not face a wall ! I?m a 21 year old design student at Pratt Institute looking for a female roommate. I have a cat so be sure to not be allergic. I?m looking for someone that?s in their twenties, student or working doesn?t matter as long as you?re a reliable and serious person. I have a lot of work to do for my school so I?m not always at home. You can use the tv and everything that?s in the living room/kitchen/bathroom, invite friends over and have to let me know if you intend to have a party or anything like that. The living room has a couch that opens up if you have family or friends visiting. This apartment is really nice and it?s a great deal since it?s furnished. I have myself been living in it for a year and know how hard it is to find a decent apartment in New York City that?s why I renewed my lease here for one more year ! Internet/TV/Phone and electricty are not included, it?s about $130 dollars per person per month. Be sure to send me an e-mail in which you will describe yourself, what you do for a living, etc. and then we can schedule a visit. And also let me know if you have any questions. Smokers OK (I am a smoker myself, but I smoke on the balcony) Pets depends (I have a cat) About the neighborhood : I live in a great neighborhood, the East Village (Alphabet City). Great bars, food, very safe. 10 min walk from the L train (1st avenue). There?s also a bus stop in the corner of my street. Lots of delis and supermarkets. Soho, Chinatown, LES are really close to here (15 min walk) 10 min walk from the East River The neighborhood has lots of cute gardens everywhere, really peaceful and residential.

Rooms information

Rooms information
Bedrooms available 1
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