http://www.brokergayab.com/images/brokergayab_logo.png

Change City


select AP.adprojectId, AP.adprojName, AP.adprojBuilderNam, AP.adprojBuilderLogo, AP.adprojUserId, AP.adprojAddress, AP.adprojOptAvailable, AP.adprojPricePerSqrft, CAT.catName, AL.adLocationName, ASL.adSubLName, UD.userId, UD.userMobileNumber, PT.propertyTitle, (select adprjImgImage from adprojectimage where adprjImgProjectId=AP.adprojectId limit 1) as adprjImgImage from adproject as AP left join propertytypedetails PT on AP.adprojPropertyType=PT.propertyId left join userdeatils UD on AP.adprojUserId=UD.userId left join category CAT on AP.adprojType=CAT.catId left join adlocations AL on AP.adprojCity=AL.adLocationId left join adsublocations ASL on AP.adprojLocality=ASL.adSubLId where AP.adprojProjectStaus=1 and AP.adprojAdminStatus=1 and AP.adprojDelStatus=0 and CAT.catStatus=1 and AL.adLocationStatus=1 and ASL.adSubLStatus=1 and AP.adprojPreviewStaus=1 and AP.adprojSellStatus=0 and AP.adprojCity!='' order by AP.adprojectId desc limit 9
images




to



Advanced Search






to



Advanced Search



Featured Listings

images

Latest Projects

BREN EdgeWaters, Sarjapur Road, Bangalore

By BREN

Residential - Residential Apartment BSP ` 5,090/- per sq. ft. onwards

2BHK & 3BHK

Sahwas Apartments, Vadgaon Maval, Pune

By Rainbow Housing

Residential - Residential Apartment BSP ` 3,200/- per sq. ft. onwards

2BHK

Siddartha Srinilaya, Electronic City Phase II, Bangalore

By Siddartha Builders

Residential - Residential Apartment BSP ` 2,600/- per sq. ft. onwards

2BHK

Siddartha Sapphire, HSR Layout, Bangalore

By Siddartha Builders

Residential - Residential Apartment BSP ` 4,200/- per sq. ft. onwards

2BHK & 3BHK

Farm Hills, Vasai, Thane

By Edwise Realtors

Residential - Residential Plot BSP ` 450/- per sq. ft. onwards

2BHK & 3BHK

Xrbia - Hinjewadi Road, Maval, Pune

By Xrbia

Residential - Residential Apartment BSP ` 3,500/- per sq. ft. onwards

1BHK 2BHK & 3BHK

Pebbles II, Bavdhan, Pune

By Rainbow Housing

Residential - Residential Apartment BSP ` 6,200/- per sq. ft. onwards

2BHK & 3BHK

Velocity Hill Spring, Ghodbunder Road, Thane

By Velocity

Residential - Residential Apartment BSP ` 8,181/- per sq. ft. onwards

1BHK 2BHK & 3BHK

Atlanta's Edenworld, New Bhiwandi, Thane

By Sai Balaji Developers

Residential - Residential Apartment BSP ` 3,800/- per sq. ft. onwards

1BHK & 2BHK

Top Realty Scoops

Godrej Properties sells 1000 flats in 3 new projects; Projects in Greater Noida and Pune a hit

images

Godrej Properties has revealed that it has managed to sell over 1,000 apartments sin..

Noida Authority Plans Meetings with builders, buyers to resolve stuck projects; Starts with Amrapali

images

With the goal to resolve the issue of delaying handover of flats to thousands of hom..

DDA to Announce 2016 Housing Scheme Around Diwali

images

The Delhi Development Authority (DDA) will announce the launch of “Housing Sch..

Testimonials View More
  • images
    images BrokerGayab.com helps you find a good house by eliminating intermediate parties, that just not add to the costs but also to complexities. Overall, the website seems to be an end-to-end solution for independent property searches. images

    Charu Aggarwal - Mumbai

images