Anomaly · Listing detail

SMART HOME | WATERFRONT LIVING | HIGH ROI

Al Jaddaf · 1

Fraud cap qualified (ceiling 0.50)
high-severity flag: 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)
1,539,500
Size (sqft)
671
PPSF
2,294
Type
Apartment
Bedrooms
1
Bathrooms
2
Completion
off_plan_primary
Furnished
NO
Agent
Nouha Lamrani
Listed
2026-01-04
Computed
2026-05-11 16:05:24
PDQ-256 dup detection · corpus 277,301

Photos (3)

Photo 1×10 dup1
Photo 2×6 dup2
Photo 3×5 dup3
3 photos reused on 12 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
    3 of this listing's photos appear on 1 other listing (Hamming ≤ 32, PDQ-256)
    evidence
    {
      "totalMatches": 3,
      "matchedListings": [
        "15980908"
      ],
      "photosWithMatches": 3
    }
    0.20
  • 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
  • Medium
    Extreme price deviation
    price_deviation_extreme
    Listing is 25.8% below comp median (336 comps)
    evidence
    {
      "compCount": 336,
      "discountPct": 0.2583262491870355,
      "marketMedianPpsf": 3093.004164547414
    }
    0.18
From OpportunityScore

Comp context

Discount
25.8%
Median PPSF
3,093.004
Comp count
338
Scope
project
1982 chars

Description

Step into a thoughtfully designed 1-bedroom residence at Celeste by HRE Development, where architecture, light, and space come together to create a calm yet connected waterfront lifestyle in Al Jaddaf. This apartment offers a total area of 671 sq.ft, with a highly efficient interior layout that feels open, airy, and beautifully proportioned. The living and dining area is generously sized and naturally illuminated through full-height glazing, seamlessly connecting indoor living with the outdoor space. One of the standout features of this home is the uniquely shaped private balcony, designed as an extension of the living area rather than an afterthought. The kitchen is semi-open and well-positioned, offering excellent workflow while remaining visually connected to the main living space. Finishes are modern and understated, allowing the apartment to feel timeless and elegant. The bedroom is quietly positioned for privacy and comfort, comfortably accommodating a king-sized bed and featuring built-in wardrobes. The bathroom is finished with refined materials and a clean, contemporary aesthetic, while a separate guest washroom adds practicality. Located within a boutique low-rise building of only 44 residences, Celeste prioritises privacy and quality over density. Residents benefit from a curated lifestyle offering including a waterfront swimming pool, modern fitness and yoga spaces, landscaped courtyards, children’s play areas, concierge services, and smart access systems. Ideally positioned just minutes from Downtown Dubai, Business Bay, DXB Airport, Dubai Creek Harbour, and cultural landmarks such as Jameel Arts Centre and Dubai Creek Golf & Yacht Club, this home is perfectly suited for both end users and investors. Price: AED 1,539,500 1 allocated parking space Completion: Q2 2027 Flexible payment plan available Interested in this apartment or want to learn more? Get in touch today to explore ownership or investment opportunities at Celeste.