CALL US FOR FREE SITE VISIT - +91-89395 40008 CLICK HERE FOR FREE SITE VISIT - +91-89395 40008
Array
(
    [post_type] => projects
    [orderby] => title
    [meta_key] => price_in_number
    [order] => ASC
    [meta_query] => Array
        (
            [0] => Array
                (
                    [key] => property_type
                    [value] => Residential
                    [compare] => =
                )

            [1] => Array
                (
                    [key] => project_status
                    [value] => Array
                        (
                            [0] => ongoing
                            [1] => completed
                        )

                    [compare] => IN
                )

            [2] => Array
                (
                    [key] => d_city
                    [value] => Chennai
                    [compare] => LIKE
                )

        )

    [posts_per_page] => 10
    [paged] => 5
)
WP_Query Object
(
    [query] => Array
        (
            [post_type] => projects
            [orderby] => title
            [meta_key] => price_in_number
            [order] => ASC
            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => property_type
                            [value] => Residential
                            [compare] => =
                        )

                    [1] => Array
                        (
                            [key] => project_status
                            [value] => Array
                                (
                                    [0] => ongoing
                                    [1] => completed
                                )

                            [compare] => IN
                        )

                    [2] => Array
                        (
                            [key] => d_city
                            [value] => Chennai
                            [compare] => LIKE
                        )

                )

            [posts_per_page] => 10
            [paged] => 5
        )

    [query_vars] => Array
        (
            [post_type] => projects
            [orderby] => title
            [meta_key] => price_in_number
            [order] => ASC
            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => property_type
                            [value] => Residential
                            [compare] => =
                        )

                    [1] => Array
                        (
                            [key] => project_status
                            [value] => Array
                                (
                                    [0] => ongoing
                                    [1] => completed
                                )

                            [compare] => IN
                        )

                    [2] => Array
                        (
                            [key] => d_city
                            [value] => Chennai
                            [compare] => LIKE
                        )

                )

            [posts_per_page] => 10
            [paged] => 5
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [search_columns] => Array
                (
                )

            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [update_menu_item_cache] => 
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                )

            [queried_terms] => Array
                (
                )

            [primary_table] => wp_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [key] => price_in_number
                        )

                    [1] => Array
                        (
                            [0] => Array
                                (
                                    [key] => property_type
                                    [value] => Residential
                                    [compare] => =
                                )

                            [1] => Array
                                (
                                    [key] => project_status
                                    [value] => Array
                                        (
                                            [0] => ongoing
                                            [1] => completed
                                        )

                                    [compare] => IN
                                )

                            [2] => Array
                                (
                                    [key] => d_city
                                    [value] => Chennai
                                    [compare] => LIKE
                                )

                            [relation] => AND
                        )

                    [relation] => AND
                )

            [relation] => AND
            [meta_table] => wp_postmeta
            [meta_id_column] => post_id
            [primary_table] => wp_posts
            [primary_id_column] => ID
            [table_aliases:protected] => Array
                (
                    [0] => wp_postmeta
                    [1] => mt1
                    [2] => mt2
                    [3] => mt3
                )

            [clauses:protected] => Array
                (
                    [wp_postmeta] => Array
                        (
                            [key] => price_in_number
                            [compare] => =
                            [compare_key] => =
                            [alias] => wp_postmeta
                            [cast] => CHAR
                        )

                    [mt1] => Array
                        (
                            [key] => property_type
                            [value] => Residential
                            [compare] => =
                            [compare_key] => =
                            [alias] => mt1
                            [cast] => CHAR
                        )

                    [mt2] => Array
                        (
                            [key] => project_status
                            [value] => Array
                                (
                                    [0] => ongoing
                                    [1] => completed
                                )

                            [compare] => IN
                            [compare_key] => =
                            [alias] => mt2
                            [cast] => CHAR
                        )

                    [mt3] => Array
                        (
                            [key] => d_city
                            [value] => Chennai
                            [compare] => LIKE
                            [compare_key] => =
                            [alias] => mt3
                            [cast] => CHAR
                        )

                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [request] => 
					SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )  INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )  INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id )
					WHERE 1=1  AND ( 
  wp_postmeta.meta_key = 'price_in_number' 
  AND 
  ( 
    ( mt1.meta_key = 'property_type' AND mt1.meta_value = 'Residential' ) 
    AND 
    ( mt2.meta_key = 'project_status' AND mt2.meta_value IN ('ongoing','completed') ) 
    AND 
    ( mt3.meta_key = 'd_city' AND mt3.meta_value LIKE '{7965fc4bcb26a5938f09902ca16bae76b7b16c08b104d85c820322ec263b862d}Chennai{7965fc4bcb26a5938f09902ca16bae76b7b16c08b104d85c820322ec263b862d}' )
  )
) AND ((wp_posts.post_type = 'projects' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					GROUP BY wp_posts.ID
					ORDER BY wp_posts.post_title ASC
					LIMIT 40, 10
				
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 1668
                    [post_author] => 3
                    [post_date] => 2022-05-06 15:04:30
                    [post_date_gmt] => 2022-05-06 15:04:30
                    [post_content] => Residential
                    [post_title] => G Square Triumph
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => triumph
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2024-10-22 16:42:36
                    [post_modified_gmt] => 2024-10-22 11:12:36
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://digitalkinnect.in/gsquare/?post_type=projects&p=1668
                    [menu_order] => 0
                    [post_type] => projects
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

        )

    [post_count] => 1
    [current_post] => -1
    [before_loop] => 1
    [in_the_loop] => 
    [post] => WP_Post Object
        (
            [ID] => 1668
            [post_author] => 3
            [post_date] => 2022-05-06 15:04:30
            [post_date_gmt] => 2022-05-06 15:04:30
            [post_content] => Residential
            [post_title] => G Square Triumph
            [post_excerpt] => 
            [post_status] => publish
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => triumph
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2024-10-22 16:42:36
            [post_modified_gmt] => 2024-10-22 11:12:36
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => https://digitalkinnect.in/gsquare/?post_type=projects&p=1668
            [menu_order] => 0
            [post_type] => projects
            [post_mime_type] => 
            [comment_count] => 0
            [filter] => raw
        )

    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 41
    [max_num_pages] => 5
    [max_num_comment_pages] => 0
    [is_single] => 
    [is_preview] => 
    [is_page] => 
    [is_archive] => 1
    [is_date] => 
    [is_year] => 
    [is_month] => 
    [is_day] => 
    [is_time] => 
    [is_author] => 
    [is_category] => 
    [is_tag] => 
    [is_tax] => 
    [is_search] => 
    [is_feed] => 
    [is_comment_feed] => 
    [is_trackback] => 
    [is_home] => 
    [is_privacy_policy] => 
    [is_404] => 
    [is_embed] => 
    [is_paged] => 1
    [is_admin] => 
    [is_attachment] => 
    [is_singular] => 
    [is_robots] => 
    [is_favicon] => 
    [is_posts_page] => 
    [is_post_type_archive] => 1
    [query_vars_hash:WP_Query:private] => de18d6b610ea1682163574079e838d49
    [query_vars_changed:WP_Query:private] => 
    [thumbnails_cached] => 
    [allow_query_attachment_by_filename:protected] => 
    [stopwords:WP_Query:private] => 
    [compat_fields:WP_Query:private] => Array
        (
            [0] => query_vars_hash
            [1] => query_vars_changed
        )

    [compat_methods:WP_Query:private] => Array
        (
            [0] => init_query_flags
            [1] => parse_tax_query
        )

)

₹2 Lakhs - ₹1 Crore

Project 1

Location: Madambakkam, Chennai

Price: Rs.54 Lakhs Onwards

Plot Sizes: 900-2400 Sq.Ft

Featured Commercial Projects

Ambur

Plots Starting from 2.89 Crores Onwards

Plot Size: 5769 Sq.Ft Onwards

Know More

L&T Bypass, Coimbatore

Plots Starting from Rs.3.3 Cr Onwards

Plot Size: 22 Cents Onwards

Know More

Kovaipudur,Coimbatore

Plots Starting from Rs. 75 Lakhs Onwards

Plot Size: 3 - 275.88 Cents

Know More

Featured Residential Projects

Navalur, OMR, Chennai

Plots Starting from Rs. 81.05 L Onwards

Plot Size: 1351 Sq.Ft. Onwards

Know More

Singaperumal Koil, Chennai

Plots Starting from Rs.30 Lakhs Onwards

Plot Size: 1000 Sq.Ft Onwards

Know More

Mahabalipuram ,Chennai

Plots Starting from Rs.31.5 L Onwards

Plot Size: 1800 Sq.Ft Onwards

Know More

Connect With Us

Experience our commitment to excellence, transparent processes, and customer satisfaction. Contact us now and let us turn your real estate aspirations into reality

DISCLAIMER

Thank you for visiting our website! We greatly appreciate your interest in our offerings and are here to assist with any inquiries or needs you may have. As you explore our services/products, please feel free to reach out to our support team for further assistance. We are dedicated to providing you with the best possible experience. By continuing to use our site, you agree that any details you provide may be collected and used for future communications, updates, or service enhancements. We are committed to safeguarding your privacy, and you can learn more by reviewing our Privacy Policy.