3 BHK Furnished Apartment for Expat Rent in ECR

र 1.50 lakhs/month*

Description

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's|goods|all|security|expats') then 8 else 0 end)) as relevance ' at line 13]
SELECT wp_ruxi_posts.post_title as title, wp_ruxi_posts.ID as id, wp_ruxi_posts.post_date as date, wp_ruxi_posts.post_content as content, wp_ruxi_posts.post_excerpt as excerpt, wp_ruxi_users.user_nicename as author, wp_ruxi_posts.post_type as post_type, GROUP_CONCAT(DISTINCT wp_ruxi_terms.term_id) as terms, ((case when (lower(wp_ruxi_posts.post_title) REGEXP 'bhk|furnished|apartment') then 10 else 0 end) + (case when (lower(wp_ruxi_posts.post_content) REGEXP 'for|area|rent|and|with|kid's|goods|all|security|expats') then 8 else 0 end)) as relevance FROM wp_ruxi_posts LEFT JOIN wp_ruxi_postmeta ON wp_ruxi_postmeta.post_id = wp_ruxi_posts.ID LEFT JOIN wp_ruxi_users ON wp_ruxi_users.ID = wp_ruxi_posts.post_author LEFT JOIN wp_ruxi_term_relationships ON wp_ruxi_posts.ID = wp_ruxi_term_relationships.object_id LEFT JOIN wp_ruxi_term_taxonomy ON wp_ruxi_term_taxonomy.term_taxonomy_id = wp_ruxi_term_relationships.term_taxonomy_id LEFT JOIN wp_ruxi_terms ON wp_ruxi_term_taxonomy.term_id = wp_ruxi_terms.term_id WHERE (wp_ruxi_posts.ID <> 7765) AND (wp_ruxi_posts.post_type REGEXP 'dummy_notting|property') AND wp_ruxi_posts.ID NOT IN (-99) AND (wp_ruxi_posts.post_status = 'publish') AND ((lower(wp_ruxi_posts.post_title) REGEXP 'bhk|furnished|apartment') OR (lower(wp_ruxi_posts.post_content) REGEXP 'bhk|furnished|apartment') OR (lower(wp_ruxi_posts.post_excerpt) REGEXP 'bhk|furnished|apartment') OR (lower(wp_ruxi_posts.post_content) REGEXP 'for|area|rent|and|with|kid's|goods|all|security|expats') OR (lower(wp_ruxi_posts.post_title) REGEXP 'for|area|rent|and|with|kid's|goods|all|security|expats') OR (lower(wp_ruxi_posts.post_excerpt) REGEXP 'for|area|rent|and|with|kid's|goods|all|security|expats')) GROUP BY wp_ruxi_posts.ID ORDER BY relevance DESC, wp_ruxi_posts.post_date DESC LIMIT 10

Looking for a 3 BHK House for Rent in Chennai? This Huge Gated Luxury Apartment is available for Expat Rent in a posh area of the ECR with tight security in Chennai.

Fully Furnished with AC/s and all White Goods!

  • 2,560 Sq-Ft of built up area
  • 3 BHK Luxurious Pool facing Apartment
  • Master, Guest and Kid’s bedrooms
  • Inside a secure, gated community of expats in ECR
  • In posh surroundings, close to Thiruvanmiyur and city
  • Top class amenities – Swimming Pool + Shower rooms, Gym, Kid’s play area
  • 100% power back up
  • Air conditioned home with all white goods
  • 2 Covered car parks
  • Heavy security
  • Ready to occupy!
  • Rent: Rs 1.5 lakhs/month*

* Only for Expats. Approximate Price only. Subject to change anytime. 1 month’s Rental Brokerage payable on rent transaction. Read more on Pricing.

Property Details

  • Status
    Ready to occupy for Expats!

Virtual Tour Walkthrough & Video