SELECT DISTINCT(property_id) FROM `phase2_searchdata` WHERE 
                  (datatype IN (SELECT datatype FROM `phase2_searchdata` WHERE property_id = 826)
                    AND location IN (SELECT location FROM `phase2_searchdata` WHERE property_id = 826)
                    AND (
                          (price_from >= (SELECT MIN(price_from) FROM `phase2_searchdata` WHERE property_id = 826) 
                            AND price_from <= (SELECT MAX(price_to) FROM `phase2_searchdata` WHERE property_id = 826)
                          ) 
                          OR 
                          (price_to >= (SELECT MIN(price_from) FROM `phase2_searchdata` WHERE property_id = 826) 
                          AND price_to <= (SELECT MAX(price_to) FROM `phase2_searchdata` WHERE property_id = 826)
                          )
                        )
                    AND (
                          (pax_from >= (SELECT MIN(pax_from) FROM `phase2_searchdata` WHERE property_id = 826) 
                            AND pax_from <= (SELECT MAX(pax_to) FROM `phase2_searchdata` WHERE property_id = 826)
                          ) 
                          OR 
                          (pax_to >= (SELECT MIN(pax_from) FROM `phase2_searchdata` WHERE property_id = 826) 
                          AND pax_to <= (SELECT MAX(pax_to) FROM `phase2_searchdata` WHERE property_id = 826)
                          )
                        )
                    AND (
                          (builtup_from >= (SELECT MIN(builtup_from) FROM `phase2_searchdata` WHERE property_id = 826) 
                            AND builtup_to <= (SELECT MAX(builtup_to) FROM `phase2_searchdata` WHERE property_id = 826)
                          ) 
                          OR 
                          (builtup_from >= (SELECT MIN(builtup_from) FROM `phase2_searchdata` WHERE property_id = 826) 
                            AND builtup_to <= (SELECT MAX(builtup_to) FROM `phase2_searchdata` WHERE property_id = 826)
                          )
                        )
                      )
                  AND property_id != 826
                  LIMIT 0,3

                  
The Alcove | Sime Darby Property Skip to main content


About The Alcove

LIVE. INSPIRED.

‘The Alcove’ is a modern Low Rise Condominiums that interweave elements of open spaces or playing field to create a sustainable living environment. It consists of only 72 units of condominiums located at the North-Eastern axis within the Gated and Guarded community of ‘The Glades’.

REGISTER NOW

*required field

Floor Plan & Calculator
Type
Lot Size:
Built-Up Area:
RM
RM
RM
years
%
Reset Calculate
Monthly Repayment

per month

Download Register Now
*Figures displayed are estimations only*
Virtual Walk Through
Putra Heights Sales Gallery

The Glades Plaza
Off Persiaran Putra Perdana, Section 3, 47650 Subang Jaya, Selangor.

Monday - Sunday: 9:30 AM - 6:30 PM
Tel: +603-5198 0888
Hotline: 1-800-88-1118

Google maps
Looking for something?