Anomaly · Listing detail

Premium Quality | Great Location | Big Size APT

Al Furjan · 2

← BackOpen on PropertyFinder ↗
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.47
Suspicion
53%
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,685,000
Size (sqft)
936
PPSF
1,800
Type
Apartment
Bedrooms
2
Bathrooms
2
Completion
off_plan
Furnished
PARTLY
Broker
H2O Al Osool Reat Estate LLC
Agent
Ataibah Kiiza Nakitende
Listed
2026-03-10
Computed
2026-05-11 16:28:16
PDQ-256 dup detection · corpus 277,301

Photos (3)

Photo 1×1 dup1
Photo 2×3 dup2
Photo 3×1 dup3
3 photos reused on 3 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 (3)

  • High
    photo pHash duplicate cross listing
    photo_pHash_duplicate_cross_listing
    3 of this listing's photos appear on 3 other listings (Hamming ≤ 32, PDQ-256)
    evidence
    {
  "totalMatches": 5,
  "matchedListings": [
    "62079776",
    "62075997",
    "62080252"
  ],
  "photosWithMatches": 3
}
    −0.20
  • High
    Extreme price deviation
    price_deviation_extreme
    Listing is 41.2% below comp median (193 comps)
    evidence
    {
  "compCount": 193,
  "discountPct": 0.41196314160351,
  "marketMedianPpsf": 3061.032610963191
}
    −0.18
  • 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
41.1%
Median PPSF
3,058.229
Comp count
194
Scope
project
1123 chars

Description

H2O Real Estate is pleased to offer 2 bedrooms apartment at Celeste Heights, Al Furjan. Highlights: -Premium Living With Metropolitan Appeal - 10-Storey Development With Grand Lobby - Luxury Apartments With Smart Features - Exquisite Facade For High-End Lifestyle - Investment Potential In Prime Location - Proximity To Shopping, Dining, Schools Key Facilities: - Grand Lobby - Private Beach Club - The Sky Forest Trail - State-of-the-Art Gym - Retail Outlets - Kids Play Area - Swimming Pool Nearby Locations: - Expo City – 10 Minutes - Palm Jumeirah – 15 Minutes - Dubai Marina – 15 Minutes - Palm Jebel Ali – 20 Minutes - Al Maktoum International Airport – 20 Minutes - Downtown Dubai – 25 Minutes Prime Location in Al Furjan Nestled in the heart of Al Furjan, Celeste Heights provides unmatched connectivity to Dubai’s upcoming world’s largest international airport, top schools, shopping destinations, and dining options. Surrounded by lush greenery, this community offers a perfect balance of modern convenience and serene tranquility. For further details and viewing arrangement please contact H2O Real Estate.