#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-spectacular-corner-unit-at-1010-refH130822161343740.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
Spectacular Corner Unit at 1010 $ - Contact now!

Colocation: Spectacular Corner Unit at 1010

Spectacular Corner Unit at 1010

Property ID: H130822161343740

Price: 1595 $

Adress : Midtown, Central Atlanta, Atlanta, Etats-Unis

Available from : 1-Sep-2013

Full Description

Top Floor, 2 Bedroom, 2 1/2 Bath Corner Unit 1500+ Square Feet Spectacular skyline view down Peachtree + view of Piedmont Park and Midtown The best roommate floor plan at 1010 - Midtown's most sought after luxury condo tower This well appointed coner unit condo is located on a top floor at 1010 Midtown and features a premium view on the Peachtree curve with a spectacular view of the Midtown / Downtown skyline and Piedmont Park. It has 10 foot ceilings, expansive floor to ceiling windows, an oversized wrap-around balcony, hardwood floors throughout (excluding the bedrooms, which are carpeted to reduce street noise while sleeping, and the bathrooms, which feature premium 18" tile), and upgraded lighting including remote dimmers in the main living areas. The large kitchen has wood cabinetry, granite countertops, Bosch appliances and a Breville Keurig coffee maker. The kitchen opens up to an oversized living room, which boasts three expansive window walls and features a Samsung ultra slim bezel 3D LED TV with connections to DirecTV, Apple TV and Blu-ray. Multi-zone Sonos surround sound (controllable via your iPhone / iPad) throughout condo. Laundry room features top of the line front load stainless steel steam washer/dryer with LED controls. For rent is an unfurnished bedroom with its own private bath and walk-in-closet. This bedroom features a spectacular view. Also included is your own reserved parking space (covered) and full access to all 1010 amenities - including the pool, gardens, outdoor grilling area, fitness center, club room, etc. I occupy the other bedroom and am a young professional who works in Midtown. My roommate is moving, and therefore I'm looking for a new roommate who is respectful, fun, responsible, clean, intelligent and easy to live with. The rental price for a single bedroom with private bath is $1595 per month, or best offer. If you're interested, please send me an email with your information and I'll get back to you.

Rooms information

Rooms information
Bedrooms available 1
Bathrooms 3

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