SELECT a.*,count(p.id) as total,c.name as city_name FROM agency a LEFT JOIN properties p ON a.id=p.agency_id AND p.property_status<>'rejected' LEFT JOIN cities c ON c.id=a.city WHERE a.locked='no' AND p.locked='no' AND c.name='Rawalpindi' GROUP BY a.id ORDER BY total DESC limit 0,6

Our Agencies in Pakistan

105

Faisalabad

797

Lahore

18

Multan

71

Rawalpindi

130

Sargodha

16

Karachi

148

Islamabad

Pak Kashmir Property

  Tramri Chowk Gujjar Street Near UBL Bank Rawalpindi

Pak Kashmir Property Sargodha

More Detail

Earth Connection Estate Investment Consultant

  Appartment #1, Block A Boulvard Phase 7 Bahria Town Rawalpindi

Earth Connection Estate Investment Consultant

More Detail

Right Time Property

  Rawalpindi

Right Time Property

More Detail

D3 Associate

  Suit # 2 Second Floor, Plaza# 6 Abubakar Avenue, Hub Commercial Bahira Rawalpindi

D3 Associate we Deal in all type of Properties like Buying, Selling, Residential plots, Apartments, Commercial and Agricultural Land and Renting of Properties. We are working in Real Estate Since 2015. We are passionate about helping our clients and provide the best services and consideration they deserve. 100 plus deals are secured by us. Our Real Estate Agency can make a difference and provide you the most accurate and successful solution. Please Contact us for your Real Estate Requirements.

More Detail

Shaheen Associates & Builders

  Talha Plaza Air Port Housing Society Sector 4 Rawalpindi

More Detail

Saif Real Estate & Property Advisor

  Abid Majeed Road Tench Bhata Rawalpindi

More Detail