Property in Greater Noida

HomeAbout UsBuilders Resale CalculatorsCareer Contact Us
MediaEstate
Contact Number
You are Here:  Home > Greater Noida
Please fill up the below enquiry form and our experts will contact you
Name
Phone
Email
Query

Property By Location


I f the path is beautiful, ask where it leads to..But if the Destination is beautiful, never mind about the path..KEEP WALKING!!

SELECT pro.*, dev.*, loc.*,subloc.id,prices.*, MIN(CAST(REPLACE(prices.size,',','') AS SIGNED)) as minimumsize, MAX(CAST(REPLACE(prices.size,',','') AS SIGNED)) as maximumsize FROM med_properties pro, med_builders dev, med_location loc, med_prices prices,med_sublocation subloc WHERE pro.builder_id=dev.id AND pro.location_id=loc.id AND pro.id=prices.property_id AND pro.subloc_id=subloc.id AND loc.loc_url='property-in-greater-noida.php' GROUP BY pro.id DESC
  • Ansal API Paradise Crystal


    Ansal API 2472 Per Sqft

    Location: , Greater Noida
    Sizes     : 1060 sqft to 1315 sqft
    2 BHK Apartments