Anomaly · Listing detail

Best Price | Luxury Apartment | Prime Location

Al Jaddaf · 3

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)
4,261,000
Size (sqft)
2,003
PPSF
2,127
Type
Apartment
Bedrooms
3
Bathrooms
3
Completion
off_plan_primary
Furnished
NO
Agent
Mohit Ramchandani
Listed
2026-02-06
Computed
2026-05-11 16:11:51
PDQ-256 dup detection · corpus 277,301

Photos (3)

Photo 11
Photo 2×2 dup2
Photo 3×4 dup3
2 photos reused on 4 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 2 other listings (Hamming ≤ 32, PDQ-256)
    evidence
    {
      "totalMatches": 4,
      "matchedListings": [
        "16257598",
        "16254998"
      ],
      "photosWithMatches": 2
    }
    0.20
  • High
    Extreme price deviation
    price_deviation_extreme
    Listing is 33.5% below comp median (65 comps)
    evidence
    {
      "compCount": 65,
      "discountPct": 0.3347332483239705,
      "marketMedianPpsf": 3197.213741166796
    }
    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
33.4%
Median PPSF
3,194.255
Comp count
66
Scope
project
1677 chars

Description

M N R Real Estate LLC is proudly presents Celeste, a boutique residential development by HRE, offering just 44 elegantly designed units on the Al Jaddaf Waterfront. This low-rise, mid-density community is crafted for those seeking a refined living experience in one of Dubai’s most promising locations. Set between Downtown Dubai and Dubai Creek, Celeste combines contemporary architecture with serene views, premium finishes, and practical layouts. The development includes a mix of 1, 2, and 3-bedroom apartments, each thoughtfully designed with natural light, privacy, and functionality in mind. Project Highlights: Limited collection of only 44 residences 1, 2, and 3-bedroom apartments ranging from 671 to 2,003 sq ft Prime waterfront location in Al Jaddaf Modern design with high-quality materials and finished Spacious layouts with panoramic windows Ground + 7 floors with 2 basement levels for parking Amenities: Swimming pool and sun deck Fully equipped gym and yoga area Landscaped courtyards and shaded walkways Children’s play area Concierge and 24/7 security Smart access control systems Payment Plan: 20% on booking + 4% DLD Staggered construction-linked payments 50% on handover Handover expected: Q2 2027 Why Choose Celeste: Celeste offers a rare opportunity to own a waterfront residence in a low-density, design-focused community. Its location, boutique scale, and thoughtful design make it ideal for both end-users and investors seeking long-term value. Note: This is an off-plan (primary market) property, and availability may vary at the time of inquiry. Flexible payment plan options are available. Contact us today to learn more about this project.