#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-seeking-female-sublet-for-a-3-bedroom2-bath-condo-refH130820194535231.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
We are 3 female roommates looking for someone to sublet one bedroom in a 3 bed/2 bath unit. It is a beautiful condo located in the heart of Bucktown, off of Damen and Webster. The unit has Brazilian cherry-wood floors throughout the entire unit, except for the master bedroom, which is carpeted. Both bathrooms in the unit are tiled and spacious, with one bathroom located in the master bedroom. The condo includes a washer and dryer, stainless steel appliances, a fireplace (wood-burning and gas), and high-end finishes. There is gated parking in the back (each unit has 1 spot, so 3 roommates share/rotate the spot), but there is also plenty of free street parking. The unit is on the 2rd floor, and the master bedroom has a balcony that all roommates can use. There is also an alarm that we set each night. The condo is located 1 mile north of the CTA Damen Blue-Line stop, with several bus stops nearby. Close to great restaurants and retail stores down Damen and near the 6-corners intersection, Damen, North & Milwaukee. The two remaining roommates do have a small dog, a 6-year old Shih Tzu. The dog is very friendly and well-behaved. The room being subleased is a spacious room with French doors (curtains provide privacy), and it has wood floors. A large window provides plenty of light into the room. This person would pay $700/month for rent and split the gas, electric, cable/Internet, and alarm bills with the other 2 roommates. We are basically just looking for a friendly girl who needs a place to live! :)
Rooms information | |
---|---|
Bedrooms available | 1 |
Bathrooms | 2 |
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 |
ACS, spécialiste de la protection sociale pour expatriés avec plus de 20 ans d'expérience. Demandez un devis dès maintenant!
Pour aider les individus et les familles à vivre une vie plus longue, plus saine et plus heureuse.
Sélection de prestataires, produits et services relatifs à votre déménagement et votre vie à l’étranger... Logement, Finance, Assurance…
Comparez les offres. En tant qu'expatrié bénéficiez de l’exonération de droit de succession meme apres retour en France!
Transferez et changez votre argent au meilleur taux. Paiements Internationaux Importants, Transfert réguliers, Couverture Taux. Devis & Conseils Gratuits!
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...