Jaageer-Logo
  • Home
  • Buy
  • Rent
  • Projects
  • Agencies
  • Blog
  • Events
  • Registry Calculator
  • Add Property
  • Add Property
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.city=180 GROUP BY a.id ORDER BY total DESC limit 0,6

Our Agencies in Pakistan

109

Faisalabad

925

Lahore

36

Multan

78

Rawalpindi

610

Sargodha

27

Karachi

199

Islamabad

Allied Real Estate

3 Properties

Allied Real Estate

  Peshawar

More Detail
    • 1

Head Office

2km Lahore Road, Sargodha

Lahore Office

75B Fazaia Housing scheme Raiwind Road, Lahore

UAN

(+92) 48-111-222-084

Mobile

(+92) 304-111-2627

CONNECT

  • Our Realtors
  • Our Stamp Vendors
  • Events
  • Login
  • Register

COMPANY

  • About Us
  • Terms Of Use
  • Privacy Policy
  • Careers
  • Contact Us

ADDRESS

Branch Office

731-A Gulberg City, Sargodha

Lahore Office

75B Fazaia Housing scheme Raiwind Road,
Lahore

All Rights Are Reserved. 2023 Jaageer.com - Jaageer Marketing Pvt. (Ltd)

Sorry!

Success!