Anomaly · Listing detail

3 BR + Study | Handover Q3 2027 | Prime Location

Al Furjan · 3

Score capped at 0.50 (would have scored 0.65)
high-severity flag: photo_pHash_duplicate_cross_listing
quality-positive (1.0 = clean)

Risk score

0.50
Suspicion
50%
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)
3,152,500
Size (sqft)
4,757
PPSF
662
Type
Apartment
Bedrooms
3
Bathrooms
5
Completion
off_plan
Furnished
NO
Agent
Donna Bridget Kwera
Listed
2025-12-12
Computed
2026-05-11 16:03:44
PDQ-256 dup detection · corpus 277,301

Photos (3)

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

  • High
    photo pHash duplicate cross listing
    photo_pHash_duplicate_cross_listing
    2 of this listing's photos appear on 1 other listing (Hamming ≤ 32, PDQ-256)
    evidence
    {
      "totalMatches": 2,
      "matchedListings": [
        "15827579"
      ],
      "photosWithMatches": 2
    }
    0.20
  • 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
1874 chars

Description

Luxury Invest Group are pleased to offer this luxury 3 Bedroom Bedroom with study and access to a private pool apartment in Celeste Heights - 3 Bedrooms + Study & Pool - Private Pool access - Open-plan living & dining - Floor-to-ceiling windows - Modern kitchen & premium finishes - Spacious balcony - Rooftop infinity swimming pool - Fully equipped gym & wellness areas - Landscaped gardens & BBQ zones - Co-working spaces & residents’ lounges - EV charging, covered parking & 24/7 security AED 3,152,500 Located in the heart of Al Furjan, Celeste Heights offers exceptional connectivity to Sheikh Zayed Road, metro stations, retail hubs, schools, and major lifestyle destinations, making it ideal for both residents and tenants. Expected handover: Q3 2027.
 PAYMENT PLAN : 30/70 Step into refined urban living with this stunning 3-bedroom + maid’s residence with private pool access in Celeste Heights, Al Furjan. a premium new development designed for modern families and smart investors seeking luxury in a central, well-connected location. This spacious home features a contemporary open-plan layout with floor-to-ceiling windows, allowing natural light to flood the interiors while offering serene community views. The sleek modern kitchen connects seamlessly to the living and dining areas, perfect for entertaining or everyday comfort. All bedrooms are generously sized with built-in wardrobes, while the maid’s room adds valuable functionality. The large balcony enhances indoor-outdoor living, ideal for relaxing or hosting guests, offering private pool access . With strong rental demand in Al Furjan, flexible payment plans, and premium specifications, this unit presents an outstanding high-yield investment opportunity with long-term capital growth potential. For more details please contact: Bridget kwera Email Address: Bridget@luxuryinvestgroup.com