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

Park Backing | Integrated Appliances | Brand New

  • Home
  • Park Backing | Integrated Appliances | Brand New

Park Backing | Integrated Appliances | Brand New

Agent

$395,000

Property Description

- Triple Storey
- Pool & Park Backing
- Integrated Appliances
- Sky Suite Bedroom
- Brand New
- Closed Kitchen
- Key In Hand
- Call today to arrange your viewing

haus & haus is pleased to present this incredible - Fully Upgraded 4 Bedroom + Maid property in the highly anticipated Aura 1 community.

This closed kitchen home offers arguably the best upgrades available on the market with integrated appliances, Park & Pool Backing as well as Home Automation System.

Please call Jack Smillie +971 (0)58 587 9681 for more information, to arrange a viewing or to make an offer.

Broker fee - 5% + VAT
Security deposit - 5%

For further details, please drop into our flagship office at the Gold & Diamond Park - or browse the incredible selection of properties we maintain at the haus & haus website. Our specialist brokers will be happy to answer any industry related query you have.

Property Details

  • Property ID: PC012
  • Rooms: 1
  • Garage Size: 35 Sq Ft
  • Property Type: Duplex
  • Bathrooms: 1
  • Property Status: For buy
  • Property Size: 36 Sq Ft
  • Garage: 1

Amenities

Location

  • Address: Hassan as Saudi
  • State Ajman Emirate
  • City Ajman
  • Neighborhood:
  • 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.

Messages1TimelineExceptionsViews6RouteQueries18Models23MailsGateSessionRequest
Request history8.2.20PHP Version158msRequest Duration2MBMemory UsageGET properties/details/{id}/{slug}Route
  • warninglog[21:29:43] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • Booting (50.15ms)time
  • Application (108ms)time
  • 1 x Application (68.25%)
    108ms
    1 x Booting (31.71%)
    50.15ms
    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
    18 statements were executed, 10 of which were duplicates, 8 unique. Show only duplicated51.91ms
    • select * from `properties` where `properties`.`id` = '12' limit 1
      3.82msrealestatePropertyController.php#68
      Bindings
      • 0: 12
      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
      1.82msrealestatePropertyController.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 (14) and `cities`.`deleted_at` is null
      7.24msrealestatePropertyController.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 (12)
      5.04msrealestatePropertyController.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` = '12'
      4.68msrealestatePropertyController.php#77
      Bindings
      • 0: 12
      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` = '12'
      3.74msrealestatePropertyController.php#78
      Bindings
      • 0: 12
      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` = '4' and `id` != '12' order by `id` desc limit 3
      2.02msrealestatePropertyController.php#81
      Bindings
      • 0: 4
      • 1: 12
      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
      2.04msrealestatedetails.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` = '4' limit 1
      1.63msrealestatedetails.blade.php#63
      Bindings
      • 0: 4
      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` = '4' limit 1
      1.31msrealestatedetails.blade.php#443
      Bindings
      • 0: 4
      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.37msrealestatedetails.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` = '4' limit 1
      1.16msrealestatedetails.blade.php#443
      Bindings
      • 0: 4
      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
      2.23msrealestatedetails.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` = '4' limit 1
      990μsrealestatedetails.blade.php#443
      Bindings
      • 0: 4
      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.17msrealestatedetails.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
      4.49msrealestateheader.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
      4.17msrealestatefooter.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
      2.99msrealestatefooter.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
    5MultiImage.php#?
    App\Models\Properties\Property
    4Property.php#?
    App\Models\User
    4User.php#?
    App\Models\PropertyType
    4PropertyType.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
        7FN0cYIPIm7IfNgE4bhIqe7p9LDbiKKmQS8eqgyz
        _previous
        array:1 [ "url" => "https://realtyflag.com/properties/details/12/property-details.html" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /properties/details/12/property-details.html
        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 => "Sat, 26 Apr 2025 21:29:44 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjhlRldFZE1TeTBJLzVoc1N2Nk5jU3c9PSIsInZhbHVlIjoiMURFekZYanNrOHJPdG9kV1hnWUphYUgxL0Z0RHpzUWl0Ylk3Rk5VdFM5dlBBaXZNRU0xQ01CeWt3UVp0VDV2SjhxRXVxQXc5TmgyVFJaUnJjUWVNNDJ0N0lWUnVla0VZWFlCNkhId053VVQvQ0t3Y216d01VMmZPdElrbHhYbG4iLCJtYWMiOiJlNzIwNjQ4ZTcyMmFkNGY4NWIyMmJhNmVjMzMzZGVmMTljYjYyNzVlYzg4ZWNjNjg0YmEwOTdhOTE0YjhlNWU2IiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 23:29:44 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjhlRldFZE1TeTBJLzVoc1N2Nk5jU3c9PSIsInZhbHVlIjoiMURFekZYanNrOHJPdG9kV1hnWUphYUgxL0Z0RHpzUWl0Ylk3Rk5VdFM5dlBBaXZNRU0xQ01CeWt3UVp0VDV2SjhxRXVxQ ▶"
    1 => "laravel_session=eyJpdiI6Ims0VVBHU1dGaEJnMFdSMEJrV21PMWc9PSIsInZhbHVlIjoiYzF3NjR3YjRZTHF2REtINXpYYnFHaVhUNlBwZ3JENzE1aHNwTGdLQ243YjhoWmNBSnZOWHE3ZUJhWUNoK21pRUlGb29PcnJWZjlmeGE5eG9RdDNBTXhFTGVKRzBDTXlkVnBhenNTc1dGZUd4NDlnKy8yTlBOVUtVQ0hDWFZnL2IiLCJtYWMiOiI2MGMzYzc3MDUwYmE2NzViNTQxZTA4ZWE1NjExZTdkNTViOWM2NDIxMGMzZDFiNDc1M2U2NmFhY2Q0ODU3MmZiIiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 23:29:44 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ims0VVBHU1dGaEJnMFdSMEJrV21PMWc9PSIsInZhbHVlIjoiYzF3NjR3YjRZTHF2REtINXpYYnFHaVhUNlBwZ3JENzE1aHNwTGdLQ243YjhoWmNBSnZOWHE3ZUJhWUNoK21pRUlG ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjhlRldFZE1TeTBJLzVoc1N2Nk5jU3c9PSIsInZhbHVlIjoiMURFekZYanNrOHJPdG9kV1hnWUphYUgxL0Z0RHpzUWl0Ylk3Rk5VdFM5dlBBaXZNRU0xQ01CeWt3UVp0VDV2SjhxRXVxQXc5TmgyVFJaUnJjUWVNNDJ0N0lWUnVla0VZWFlCNkhId053VVQvQ0t3Y216d01VMmZPdElrbHhYbG4iLCJtYWMiOiJlNzIwNjQ4ZTcyMmFkNGY4NWIyMmJhNmVjMzMzZGVmMTljYjYyNzVlYzg4ZWNjNjg0YmEwOTdhOTE0YjhlNWU2IiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 23:29:44 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjhlRldFZE1TeTBJLzVoc1N2Nk5jU3c9PSIsInZhbHVlIjoiMURFekZYanNrOHJPdG9kV1hnWUphYUgxL0Z0RHpzUWl0Ylk3Rk5VdFM5dlBBaXZNRU0xQ01CeWt3UVp0VDV2SjhxRXVxQ ▶"
    1 => "laravel_session=eyJpdiI6Ims0VVBHU1dGaEJnMFdSMEJrV21PMWc9PSIsInZhbHVlIjoiYzF3NjR3YjRZTHF2REtINXpYYnFHaVhUNlBwZ3JENzE1aHNwTGdLQ243YjhoWmNBSnZOWHE3ZUJhWUNoK21pRUlGb29PcnJWZjlmeGE5eG9RdDNBTXhFTGVKRzBDTXlkVnBhenNTc1dGZUd4NDlnKy8yTlBOVUtVQ0hDWFZnL2IiLCJtYWMiOiI2MGMzYzc3MDUwYmE2NzViNTQxZTA4ZWE1NjExZTdkNTViOWM2NDIxMGMzZDFiNDc1M2U2NmFhY2Q0ODU3MmZiIiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 23:29:44 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ims0VVBHU1dGaEJnMFdSMEJrV21PMWc9PSIsInZhbHVlIjoiYzF3NjR3YjRZTHF2REtINXpYYnFHaVhUNlBwZ3JENzE1aHNwTGdLQ243YjhoWmNBSnZOWHE3ZUJhWUNoK21pRUlG ▶"
  ]
]
        session_attributes
          0 of 0   
        array:4 [▼
  "_token" => "7FN0cYIPIm7IfNgE4bhIqe7p9LDbiKKmQS8eqgyz"
  "_previous" => array:1 [▶
    "url" => "https://realtyflag.com/properties/details/12/property-details.html"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-26 21:29:44GET/properties/details/12/property-details.html161823