Anomaly · Listing detail

5% Booking_40%PostHandOver_Waterfront Living

Al Jaddaf · 1

Fraud cap qualified (ceiling 0.50)
high-severity flags: price_deviation_extreme, photo_pHash_duplicate_cross_listing
quality-positive (1.0 = clean)

Risk score

0.42
Suspicion
58%
Critical severity
Absolute structural checks

Gates

Permit valid
✓ passed
Required fields
✓ passed
Photo count
✓ passed
No dup photos
null · Phase C — pHash store
Photos ↔ description
null · Phase D — multimodal LLM
From PropertyFinder

Listing facts

Price (AED)
2,299,000
Size (sqft)
1,098
PPSF
2,093
Type
Apartment
Bedrooms
1
Bathrooms
2
Completion
off_plan_primary
Furnished
YES
Agent
Hassan Mohamed
Listed
2026-03-03
Computed
2026-05-11 16:23:15
PDQ-256 dup detection · corpus 277,301

Photos (3)

Photo 1×8 dup1
Photo 2×10 dup2
Photo 3×3 dup3
3 photos reused on 18 other listings. Hover the badge to see matched listing IDs and Hamming distances.
LLM holistic analysis (Phase D) didn't fire for this listing — either it wasn't requested or returned a clean read. Re-run with --call1 to populate.
Per-signal evidence

Flags (4)

  • High
    photo pHash duplicate cross listing
    photo_pHash_duplicate_cross_listing
    2 of this listing's photos appear on 6 other listings (Hamming ≤ 32, PDQ-256)
    evidence
    {
      "totalMatches": 7,
      "matchedListings": [
        "58581576",
        "59349755",
        "59348599",
        "59349218",
        "15980908",
        "15980823"
      ],
      "photosWithMatches": 2
    }
    0.20
  • High
    Extreme price deviation
    price_deviation_extreme
    Listing is 32.3% below comp median (336 comps)
    evidence
    {
      "compCount": 336,
      "discountPct": 0.3233116127063929,
      "marketMedianPpsf": 3093.004164547414
    }
    0.18
  • Low
    Not PF-verified
    verification_missing
    Listing not marked verified by PropertyFinder
    evidence
    {
      "is_verified": false
    }
    0.05
  • Medium
    photo count low actual
    photo_count_low_actual
    Only 3 photos downloaded (claimed counts in raw can lie — this is from the actual fetch)
    evidence
    {
      "actual": 3,
      "totalRows": 3,
      "downloadOkCount": 3
    }
    0.15
From OpportunityScore

Comp context

Discount
32.3%
Median PPSF
3,093.004
Comp count
338
Scope
project
1365 chars

Description

This 1-bedroom apartment for sale in Celeste, Culture Village (Jaddaf Waterfront), Dubai, offers a practical layout in a waterfront community setting. The unit is part of a residential development positioned along the promenade, combining modern finishes with marina and city views. - Balcony/terrace with marina and skyline aspects - Open-plan living and dining area - Furnished interiors in neutral tones - Shared swimming pool - Gym/health club access - Jacuzzi, sauna and steam room in the building - Lobby and reception/waiting area - CCTV and on-site security staff - 24-hour concierge services - Broadband internet and satellite/cable TV provision Celeste features a contemporary lobby with high ceilings, decorative lighting and reception services, giving the building a modern, organised feel. Residents benefit from shared leisure facilities including pool and fitness areas, as well as landscaped outdoor spaces along the waterfront. The building sits within Culture Village (Jaddaf Waterfront), a residential district along Dubai Creek that is evolving into a mixed-use community. The area provides access to the waterfront promenade, nearby retail and dining concepts, and road links towards key parts of Dubai. Public transport options and main highways are within convenient reach, supporting daily commuting and access to the wider city.