=== All DRIVEN PROPERTIES brokers ===
  id=1020007 lic=34991 pf_lic=34991 pf_id=847 listings=2439
  id=1028498 lic=11917 pf_lic= pf_id=847 listings=0

=== INFINITE DIMENSIONS brokers (wrong pf_id=847) ===
  id=10464 name=INFINITE DIMENSIONS PROPERTY ADVISORY LLC lic=0 pf_id=0 listings=0
  id=686243 name=INFINITE DIMENSIONS PROPERTY ADVISORY LLC lic=0 pf_id=0 listings=0

=== FIX 1: Clear pf_id from INFINITE DIMENSIONS ===
  Cleared: 0 rows

=== FIX 2: Set canonical Driven Properties (id=1020007) ===
  Updated id=1020007: LicenseNumber=34991, pf_id=847

=== FIX 3: Move listings from wrong broker (id=10464) to id=1020007 ===
  Currently 0 listings on broker id=10464
  Moved: 0 listings to broker id=1020007
  0 agents on broker id=10464
  Moved: 0 agents to broker id=1020007

=== FIX 4: Agent duplicates (pf_id=114574) ===
  Found 1 records
  Keeping agent id=20795, set broker_id=1020007

=== FIX 5: Patch listing 223441447 ===
  Listing updated: 0 rows
  ad_cities id=4661 updated: 0 rows

=== Final: listing 223441447 ===
  id                       : 223441447
  price                    : 155000000
  beds                     : 5
  baths                    : 6
  agent_id                 : 20795
  broker_id                : 1020007
  lot_sqft                 : 11655
  completion_status        : off_plan
  listing_level            : premium
  price_per_sqft           : 13299
  rera_number              : 71457399371
  mortgage_monthly         : 557832
  delivery_date            : 2027-03-27
  developer_name           : Meraas Holding
  down_payment_rate        : 20
  ownership_type           : freehold
  construction_phase       : under_construction
  status                   : inactive

=== Broker state after fix ===
  id=10464 name=INFINITE DIMENSIONS PROPERTY ADVISORY LLC lic=0 pf_id=0 listings=0
  id=686243 name=INFINITE DIMENSIONS PROPERTY ADVISORY LLC lic=0 pf_id=0 listings=0
  id=1020007 name=DRIVEN PROPERTIES lic=34991 pf_id=847 listings=2439
  id=1028498 name=DRIVEN PROPERTIES lic=11917 pf_id=847 listings=0

DONE