SMART HOME | WATERFRONT LIVING | HIGH ROI

Price (AED)

1,943,000

Size (sqft)

930

PPSF

2,089

Type

Apartment

Bedrooms

2

Bathrooms

3

Completion

off_plan_primary

Furnished

NO

Broker

HOUSINOVA REAL ESTATE L.L.C

Agent

Nouha Lamrani

Listed

2026-01-04

Computed

2026-05-11 16:05:24

• 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": [
      "15980823"
    ],
    "photosWithMatches": 3
  }

  −0.20
• High
  Extreme price deviation

  price_deviation_extreme

  Listing is 31.8% below comp median (193 comps)

  evidence

  {
    "compCount": 193,
    "discountPct": 0.317550557116518,
    "marketMedianPpsf": 3061.032610963191
  }

  −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

Discount

31.7%

Median PPSF

3,058.229

Comp count

194

Scope

project

Discover refined waterfront living in this beautifully planned 2-bedroom apartment at Celeste by HRE Development, a boutique residential address. Spanning a total area of 930 sq.ft, this residence offers a highly functional layout that feels both spacious and intuitively organised. The open-plan living and dining area is bright and welcoming, framed by floor-to-ceiling glazing and seamlessly connected to the kitchen, creating a fluid space ideal for everyday living and entertaining. A key highlight of this home is its two private balconies, each thoughtfully positioned to extend the living experience outdoors. One balcony connects to the main living area, while the second, sculpted balcony adjoins the bedroom, offering a quiet outdoor retreat perfect for relaxation, reading, or morning coffee. Both bedrooms are generously sized and positioned for privacy. The master bedroom enjoys built-in wardrobes and direct access to its own balcony, creating a peaceful, hotel-like atmosphere. The second bedroom is equally well-proportioned, ideal for family members, guests, or a home office. Two modern bathrooms are finished with refined materials, while a dedicated laundry room. Celeste is a low-density building with only 44 residences, offering a calm and exclusive living environment. Residents enjoy premium amenities including a waterfront swimming pool, modern fitness and yoga spaces, landscaped courtyards, children’s play areas, concierge services, and smart access systems. Perfectly located just minutes from Downtown Dubai, Business Bay, DXB Airport, Dubai Creek Harbour, and landmarks such as Jameel Arts Centre and Dubai Creek Golf & Yacht Club, this apartment is ideal for both end users and investors seeking long-term value. Price: AED 1,943,000 1 allocated parking space Estimated 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.