• My test adderess
  • Mon - Sat 9.00 - 18.00
  • +055666666
Sign In
+Add Listing
+Add Listing

Pictures For only Marketing Purpose - Unfurnished - 3 Bedrooms - 5 Bathrooms - Maid Room - Close to the Entrance

  • Home
  • Pictures For only Marketing Purpose - Unfurnished - 3 Bedrooms - 5 Bathrooms - Maid Room - Close to the Entrance

Pictures For only Marketing Purpose - Unfurnished - 3 Bedrooms - 5 Bathrooms - Maid Room - Close to the Entrance

Agent

$3,700,000

Property Description

Townhouse for sale in Aura, Tilal Al Ghaf

Union Square House Real Estate Brokers is delighted to offer this beautiful 3 bedrooms Townhouse in Aura Gardens Townhouses - Tilal Al Ghaf by Majid Al Futtaim developer.

Property Details:

* 3 Bedrooms with Maids
* Built-up Area: 2169 sq ft
* Plot Area: 1512 sq ft
* Upgraded Kitchen
* Close To Crystal Lagoon
* 40% Post Handover Payment Plan
* Completion is expected in June 2025.

Amenities
* Family-oriented community
* Luxury Resort Style Living
* Recreational Lagoon
* White Sandy Beaches
* Water sports & Gym
* Outdoor Vox Cinema
* Leisure parks & Kids play areas
* Olympic size pool at Lagoon Al Ghaf
* Shopping Mall & Retail outlets
* Posh amenities and facilities

Location : Next to Sports City & Motor City / At the Exit of Al Qudra Road from Sheikh Muhammad Bin Zayed Road

Tilal Al Ghaf stands as one of Dubai's premier and highly sought-after locations for property investment. Renowned for its luxurious finishing and exquisite designs, the project epitomizes opulence and sophistication.

Please Feel Free To Contact Us For Any Further Information and Assistance on:
Hitesh Babani - 0558790033

Property Details

  • Property ID: PC024
  • Rooms: 1
  • Garage Size: 13 Sq Ft
  • Property Type: Townhouse
  • Bathrooms: 1
  • Property Status: For rent
  • Property Size: 36 Sq Ft
  • Garage: 1

Amenities

Location

  • Address: Tigran Metz
  • State Ajman Emirate
  • City Masfout
  • Neighborhood: 1
  • Zip/Postal Code: 0018

What’s Nearby?

Places:
Bank (1 km)

Property Video

Schedule A Tour

Agent

For Chat Login First

Mortgage Calculator

Similar Properties

Subscribe

Sign Up To Our Newsletter To Get The Latest News And Offers.

Messages1TimelineExceptionsViews6RouteQueries16Models19MailsGateSessionRequest
Request history8.2.20PHP Version71.46msRequest Duration2MBMemory UsageGET properties/details/{id}/{slug}Route
  • warninglog[02:47:28] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • Booting (23.25ms)time
  • Application (48.18ms)time
  • 1 x Application (67.43%)
    48.18ms
    1 x Booting (32.54%)
    23.25ms
    6 templates were rendered
    • frontend.properties.detailsdetails.blade.php#?blade
    • layouts.frontendfrontend.blade.php#?blade
    • frontend.home.preloadpreload.blade.php#?blade
    • frontend.home.headerheader.blade.php#?blade
    • frontend.home.mobile_menumobile_menu.blade.php#?blade
    • frontend.home.footerfooter.blade.php#?blade
    uri
    GET properties/details/{id}/{slug}
    middleware
    web
    controller
    App\Http\Controllers\Frontend\PropertyController@details
    namespace
    where
    as
    properties.details
    file
    app/Http/Controllers/Frontend/PropertyController.php:66-85
    16 statements were executed, 8 of which were duplicates, 8 unique. Show only duplicated19.81ms
    • select * from `properties` where `properties`.`id` = '24' limit 1
      1.21msrealestatePropertyController.php#68
      Bindings
      • 0: 24
      Backtrace
      • 18. app/Http/Controllers/Frontend/PropertyController.php:68
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `states` where `states`.`id` in (3395) and `states`.`deleted_at` is null
      930μsrealestatePropertyController.php#68
      Backtrace
      • 23. app/Http/Controllers/Frontend/PropertyController.php:68
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 27. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `cities` where `cities`.`id` in (38) and `cities`.`deleted_at` is null
      800μsrealestatePropertyController.php#68
      Backtrace
      • 23. app/Http/Controllers/Frontend/PropertyController.php:68
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 27. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `amenities`.*, `amenity_property`.`property_id` as `pivot_property_id`, `amenity_property`.`amenity_id` as `pivot_amenity_id` from `amenities` inner join `amenity_property` on `amenities`.`id` = `amenity_property`.`amenity_id` where `amenity_property`.`property_id` in (24)
      850μsrealestatePropertyController.php#68
      Backtrace
      • 22. app/Http/Controllers/Frontend/PropertyController.php:68
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `multi_images` where `property_id` = '24'
      970μsrealestatePropertyController.php#77
      Bindings
      • 0: 24
      Backtrace
      • 15. app/Http/Controllers/Frontend/PropertyController.php:77
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `facilities` where `property_id` = '24'
      1.06msrealestatePropertyController.php#78
      Bindings
      • 0: 24
      Backtrace
      • 15. app/Http/Controllers/Frontend/PropertyController.php:78
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `properties` where `ptype_id` = '3' and `id` != '24' order by `id` desc limit 3
      950μsrealestatePropertyController.php#81
      Bindings
      • 0: 3
      • 1: 24
      Backtrace
      • 15. app/Http/Controllers/Frontend/PropertyController.php:81
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `users` where `users`.`id` = 2 limit 1
      790μsrealestatedetails.blade.php#43
      Bindings
      • 0: 2
      Backtrace
      • 22. view::frontend.properties.details:43
      • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 27. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `property_types` where `property_types`.`id` = '3' limit 1
      1.55msrealestatedetails.blade.php#63
      Bindings
      • 0: 3
      Backtrace
      • 21. view::frontend.properties.details:63
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `property_types` where `property_types`.`id` = '3' limit 1
      1.47msrealestatedetails.blade.php#443
      Bindings
      • 0: 3
      Backtrace
      • 21. view::frontend.properties.details:443
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `users` where `users`.`id` = 2 limit 1
      790μsrealestatedetails.blade.php#457
      Bindings
      • 0: 2
      Backtrace
      • 22. view::frontend.properties.details:457
      • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 27. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `property_types` where `property_types`.`id` = '3' limit 1
      4.64msrealestatedetails.blade.php#443
      Bindings
      • 0: 3
      Backtrace
      • 21. view::frontend.properties.details:443
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `users` where `users`.`id` = 2 limit 1
      1.16msrealestatedetails.blade.php#457
      Bindings
      • 0: 2
      Backtrace
      • 22. view::frontend.properties.details:457
      • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 27. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `site_settings` where `site_settings`.`id` = 1 limit 1
      1.01msrealestateheader.blade.php#2
      Bindings
      • 0: 1
      Backtrace
      • 20. view::frontend.home.header:2
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `site_settings` where `site_settings`.`id` = 1 limit 1
      780μsrealestatefooter.blade.php#3
      Bindings
      • 0: 1
      Backtrace
      • 20. view::frontend.home.footer:3
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `blog_posts` order by `created_at` desc limit 2
      850μsrealestatefooter.blade.php#4
      Backtrace
      • 15. view::frontend.home.footer:4
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:207
    App\Models\MultiImage
    4MultiImage.php#?
    App\Models\Properties\Property
    3Property.php#?
    App\Models\User
    3User.php#?
    App\Models\PropertyType
    3PropertyType.php#?
    App\Models\SiteSetting
    2SiteSetting.php#?
    App\Models\State
    1State.php#?
    App\Models\City
    1City.php#?
    App\Models\Amenity
    1Amenity.php#?
    App\Models\Facility
    1Facility.php#?
        _token
        htoU8n8oO8Hw21MzAAie0S9ZXKw1pFfl3VYGJ3eY
        _previous
        array:1 [ "url" => "https://realtyflag.com/properties/details/24/pictures-for-only-marketing-purpo...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /properties/details/24/pictures-for-only-marketing-purpose----unfurnished---3-bedrooms---5-bathrooms---maid-room---close-to-the-entrance
        status_code
        200
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        request_request
        []
        request_headers
          0 of 0   
        array:15 [▼
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "realtyflag.com"
  ]
]
        request_cookies
        []
        response_headers
          0 of 0   
        array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 18 Apr 2025 02:47:28 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxoVEpleWMyMlpuZGd4REZSeGRQOGc9PSIsInZhbHVlIjoiaHpVVHc2b3UvR2VaNHRFeGlGZzRXbi9Tdzh0KzlQV0ZkM0MvRVFwTmRwNllPV2hxZ0s5SlpxSUd2RnVUNE01Q2RPSXdOc2dpTkQyL05EKzU3TUdnZGxJTHRsWGRQYjhHZ3RXOStzU2k2YzlNdXRyQUI4YUp1TFF0WENMalZPWkIiLCJtYWMiOiIxZDcxMDJlMzk2YTM5MDRlNGZjNjdlMjU2NmM5YzBjYTJiZmY5Y2FiNjIxZDY1ZWE4YTlkMzgzOGY4MTFiOTUyIiwidGFnIjoiIn0%3D; expires=Fri, 18 Apr 2025 04:47:28 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkxoVEpleWMyMlpuZGd4REZSeGRQOGc9PSIsInZhbHVlIjoiaHpVVHc2b3UvR2VaNHRFeGlGZzRXbi9Tdzh0KzlQV0ZkM0MvRVFwTmRwNllPV2hxZ0s5SlpxSUd2RnVUNE01Q2RPSXdOc ▶"
    1 => "laravel_session=eyJpdiI6IkFjTU5HSFkwZ1V4K1dIdTc4NFVSdlE9PSIsInZhbHVlIjoiVU93WVFoR1pVNzZIQUNvcVRkVnpsQVR1R2hjVU5MSjRCdzBFN0R6bDQra1ZjMThRVndqKzdSQXdETWRyUUVZKzJuaVpXY0QxNEswTUlJUDcwOG8zVERqbjZUWi9XMEVPSjcwUDBhbURaUzdpWFFrS1JWQXdCZ3FvQ2FlYVBlY0MiLCJtYWMiOiI5ZDc0NzBjMDAzOWI1YmFhZTEyY2NlMzE2OGE3ODNhOTQ4MDE4ZTdkZmZkZGVlMjkxNjI2OTA1YjgyMTA0NGY4IiwidGFnIjoiIn0%3D; expires=Fri, 18 Apr 2025 04:47:28 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkFjTU5HSFkwZ1V4K1dIdTc4NFVSdlE9PSIsInZhbHVlIjoiVU93WVFoR1pVNzZIQUNvcVRkVnpsQVR1R2hjVU5MSjRCdzBFN0R6bDQra1ZjMThRVndqKzdSQXdETWRyUUVZKzJu ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxoVEpleWMyMlpuZGd4REZSeGRQOGc9PSIsInZhbHVlIjoiaHpVVHc2b3UvR2VaNHRFeGlGZzRXbi9Tdzh0KzlQV0ZkM0MvRVFwTmRwNllPV2hxZ0s5SlpxSUd2RnVUNE01Q2RPSXdOc2dpTkQyL05EKzU3TUdnZGxJTHRsWGRQYjhHZ3RXOStzU2k2YzlNdXRyQUI4YUp1TFF0WENMalZPWkIiLCJtYWMiOiIxZDcxMDJlMzk2YTM5MDRlNGZjNjdlMjU2NmM5YzBjYTJiZmY5Y2FiNjIxZDY1ZWE4YTlkMzgzOGY4MTFiOTUyIiwidGFnIjoiIn0%3D; expires=Fri, 18-Apr-2025 04:47:28 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkxoVEpleWMyMlpuZGd4REZSeGRQOGc9PSIsInZhbHVlIjoiaHpVVHc2b3UvR2VaNHRFeGlGZzRXbi9Tdzh0KzlQV0ZkM0MvRVFwTmRwNllPV2hxZ0s5SlpxSUd2RnVUNE01Q2RPSXdOc ▶"
    1 => "laravel_session=eyJpdiI6IkFjTU5HSFkwZ1V4K1dIdTc4NFVSdlE9PSIsInZhbHVlIjoiVU93WVFoR1pVNzZIQUNvcVRkVnpsQVR1R2hjVU5MSjRCdzBFN0R6bDQra1ZjMThRVndqKzdSQXdETWRyUUVZKzJuaVpXY0QxNEswTUlJUDcwOG8zVERqbjZUWi9XMEVPSjcwUDBhbURaUzdpWFFrS1JWQXdCZ3FvQ2FlYVBlY0MiLCJtYWMiOiI5ZDc0NzBjMDAzOWI1YmFhZTEyY2NlMzE2OGE3ODNhOTQ4MDE4ZTdkZmZkZGVlMjkxNjI2OTA1YjgyMTA0NGY4IiwidGFnIjoiIn0%3D; expires=Fri, 18-Apr-2025 04:47:28 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkFjTU5HSFkwZ1V4K1dIdTc4NFVSdlE9PSIsInZhbHVlIjoiVU93WVFoR1pVNzZIQUNvcVRkVnpsQVR1R2hjVU5MSjRCdzBFN0R6bDQra1ZjMThRVndqKzdSQXdETWRyUUVZKzJu ▶"
  ]
]
        session_attributes
          0 of 0   
        array:4 [▼
  "_token" => "htoU8n8oO8Hw21MzAAie0S9ZXKw1pFfl3VYGJ3eY"
  "_previous" => array:1 [▶
    "url" => "https://realtyflag.com/properties/details/24/pictures-for-only-marketing-purpose----unfurnished---3-bedrooms---5-bathrooms---maid-room---close-to-the-entrance"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-18 02:47:28GET/properties/details/24/pictures-for-only-marketing-purpose----unfurnished---3-bedrooms---5-bathrooms---maid-room---close-to-the-entrance161619