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

7th Pay Commission Likely to Have Ripple Effect on Real Estate Sector

images

Whenever the government decides to raise the salaries of its employees, there tends ..

Real Estate Market Slowdown Pushes Gurgaon Government to Cuts Circle Rate by 15%

images

Amid slowdown in the real estate market, the Haryana Government has decided to cut c..

Navi Mumbai Airport Construction to Start Soon

images

City and Industrial Development Corporation (CIDCO) on Monday awarded contracts for ..

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