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 a.type='agency' AND a.city=246 GROUP BY a.id ORDER BY total DESC limit 0,6

Our Agencies in Pakistan

106

Faisalabad
805

Lahore
26

Multan
74

Rawalpindi
496

Sargodha
16

Karachi
192

Islamabad
HH Estate & Builders

  14 Jade Commercial Park View Villas At River Edge Housing Scheme Multa Lahore

We Deals in all type of Properties like Buying, Selling, Residential plots, Apartments, Commercial and Agricultural Land and Renting of Properties. Our Prime purpose is to secure your investments. We are Honest, dedicated and motivated Real Estate Agency. Please Contact us for your Real Estate needs and Queries. We will provide you best Solution of your Queries.

More Detail
Al ARSH Enterprises

  Canal Road Lahore

More Detail
Castle Associate

  40-A Phase 6 DHA Lahore

We Deals in all type of Properties like Buying, Selling, Residential plots, Apartments, Commercial and Agricultural Land and Renting of Properties. Our Prime purpose is to secure your investments. We are Honest, dedicated and motivated Real Estate Agency. Please Contact us for your Real Estate needs and Queries. We will provide you best Solution of your Queries.

More Detail
Kirmani Marketing

  Park Veiw City Main Boulevard, Lahore

We Deals in all type of Properties like Buying, Selling, Residential plots, Apartments, Commercial and Agricultural Land and Renting of Properties. Our Prime purpose is to secure your investments. We are Honest, dedicated and motivated Real Estate Agency. Please Contact us for your Real Estate needs and Queries. We will provide you best Solution of your Queries.

More Detail
Harmain Real Estate & Builders

  DHA , Lahore

ABOUT US We Deals in all type of Properties like Buying, Selling, Residential plots, Apartments, Commercial and Agricultural Land and Renting of Properties. Our Prime purpose is to secure your investments. We are Honest, dedicated and motivated Real Estate Agency. Please Contact us for your Real Estate needs and Queries. We will provide you best Solution of your Queries.

More Detail
New Lahore Properties

  601 Block H3 Johar Town Lahore

We Deals in all type of Properties like Buying, Selling, Residential plots, Apartments, Commercial and Agricultural Land and Renting of Properties. Our Prime purpose is to secure your investments. We are Honest, dedicated and motivated Real Estate Agency. Please Contact us for your Real Estate needs and Queries. We will provide you best Solution of your Queries.

More Detail