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

Duplex Type Property

Property
Status Of Property
Search Reasults: Showing 6 Listings
New
For rent

CORNER | HIGH FLOOR | BURJ SKYLINE VIEW

Start From

$36000

Agent

Apartment for rent in Central Park Building 1, Central Park at City Walk Imagine a home nestled within the heart of Central Park, a serene retreat surrounded by the vibrant beauty of lush greenery. *Highlights* Apartment boasts a Spacious layout, Ensuite bedrooms, Spacious Balcony, Stunning Citywalk and Burj Skyline Views, Brand new - First...

  • 2 Beds
  • 2 Baths
  • 36 Sq Ft
See Details
Featured
For rent

Sea View | Unfurnished 2BR | Ready to Move

Start From

$120,000

Agent

Unit Overview: ➥Duplex Apartment for Rent in Al Raha Lofts, Al Raha Beach, Abu Dhabi. ➥Located in a well-established community, this 2-bedroom Duplex apartment comes with 2 bathrooms and 1 parking space with an area of 1003 sq. ft. Unit Features: ➥ Open kitchen ➥ Balcony ➥ Jacuzzi Property Overview: Introducing Lofts apartment in Al Rah...

  • 2 Beds
  • 1 Baths
  • 36 Sq Ft
See Details
New
For buy

Park Backing | Integrated Appliances | Brand New

Start From

$395,000

Agent

- 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 arguab...

  • 1 Beds
  • 1 Baths
  • 36 Sq Ft
See Details
New
For buy

FULL BURJ KHALIFA VIEW | BRAND NEW FURNITURE

Start From

$900,000

Agent

SB CAPITAL is delighted to extend a warm welcome to you at One Zaabeel situated in the prestigious Zaabeel Area beside DIFC This Exclusive 2 bedroom Duplex with specious maid room converted into office area. Specious living room with full length windows looking toward Burj Khalifa View Apartment Details: Full Burj Khalifa View Branded furni...

  • 1 Beds
  • 1 Baths
  • 36 Sq Ft
See Details
Featured
For rent

Price Dropped! Full Sea View | Move-in Ready

Start From

$249,000

Agent

Property Features: • Spacious Living and Dining • Modern Open-Plan Kitchen • 3 Spacious Bedrooms • Maid Room • Balcony • Bathroom • Laundry Room • Guest Powder Room • Central AC • Central Gas • Basement Parking Amenities and Facilities: • 24-hour Security/ Maintenance • Swimming Pool • Gymnasium • Health Club • Children's Playg...

  • 1 Beds
  • 1 Baths
  • 32 Sq Ft
See Details
New
For rent

VACANT - DUPLEX - 2 BEDROOM + STUDY

Start From

$178,000

Agent

AL BISHRI REAL ESTATE Pleased to offer you this stunning upgraded apartment in lofts West in mid floor and vacant. -2 Bedrooms -2 Bathrooms -UNFurnished -BLVRD VIEW -1691 sqft -Large living/dining area -Built-in kitchen appliances -One Covered Car Parking -Close to local retail outlet The Lofts, comprising three towers with studios, o...

  • 1 Beds
  • 1 Baths
  • 32 Sq Ft
See Details
Subscribe

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

MessagesTimelineExceptionsViews8RouteQueries14Models29MailsGateSessionRequest
Request history8.2.20PHP Version181msRequest Duration2MBMemory UsageGET property-type/{slug}Route
    • Booting (62.11ms)time
    • Application (119ms)time
    • 1 x Application (65.74%)
      119ms
      1 x Booting (34.25%)
      62.11ms
      8 templates were rendered
      • frontend.property-type.showshow.blade.php#?blade
      • frontend.includes.left-sidebar-searchleft-sidebar-search.blade.php#?blade
      • pagination::bootstrap-4bootstrap-4.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 property-type/{slug}
      middleware
      web
      controller
      App\Http\Controllers\Frontend\PropertyTypeController@show
      namespace
      where
      as
      property-type.show
      file
      app/Http/Controllers/Frontend/PropertyTypeController.php:11-22
      14 statements were executed, 8 of which were duplicates, 6 unique. Show only duplicated73.11ms
      • select * from `property_types` where (`slug` = 'duplex') limit 1
        6.45msrealestatePropertyTypeController.php#13
        Bindings
        • 0: duplex
        Backtrace
        • 16. app/Http/Controllers/Frontend/PropertyTypeController.php:13
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select count(*) as aggregate from `properties` where `status` = '1' and `ptype_id` = 4
        1.25msrealestatePropertyTypeController.php#15
        Bindings
        • 0: 1
        • 1: 4
        Backtrace
        • 16. app/Http/Controllers/Frontend/PropertyTypeController.php:15
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `properties` where `status` = '1' and `ptype_id` = 4 limit 15 offset 0
        950μsrealestatePropertyTypeController.php#15
        Bindings
        • 0: 1
        • 1: 4
        Backtrace
        • 16. app/Http/Controllers/Frontend/PropertyTypeController.php:15
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `states` where `country_id` = 231 and `states`.`deleted_at` is null
        3.12msrealestateState.php#28
        Bindings
        • 0: 231
        Backtrace
        • 15. app/Models/State.php:28
        • 16. app/Http/ViewComposers/Frontend/SidebarComposer.php:19
        • 17. vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:188
      • select * from `property_types` order by `created_at` desc
        2.66msrealestateSidebarComposer.php#20
        Backtrace
        • 15. app/Http/ViewComposers/Frontend/SidebarComposer.php:20
        • 16. vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:188
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:159
      • select * from `users` where `users`.`id` = 2 limit 1
        2.03msrealestateshow.blade.php#88
        Bindings
        • 0: 2
        Backtrace
        • 22. view::frontend.property-type.show:88
        • 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 `users` where `users`.`id` = 2 limit 1
        2.33msrealestateshow.blade.php#88
        Bindings
        • 0: 2
        Backtrace
        • 22. view::frontend.property-type.show:88
        • 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 `users` where `users`.`id` = 2 limit 1
        3.04msrealestateshow.blade.php#88
        Bindings
        • 0: 2
        Backtrace
        • 22. view::frontend.property-type.show:88
        • 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 `users` where `users`.`id` = 2 limit 1
        5.13msrealestateshow.blade.php#88
        Bindings
        • 0: 2
        Backtrace
        • 22. view::frontend.property-type.show:88
        • 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 `users` where `users`.`id` = 2 limit 1
        19.62msrealestateshow.blade.php#88
        Bindings
        • 0: 2
        Backtrace
        • 22. view::frontend.property-type.show:88
        • 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 `users` where `users`.`id` = 2 limit 1
        16.75msrealestateshow.blade.php#88
        Bindings
        • 0: 2
        Backtrace
        • 22. view::frontend.property-type.show:88
        • 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
        7.42msrealestateheader.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
        970μ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
        1.39msrealestatefooter.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\PropertyType
      8PropertyType.php#?
      App\Models\State
      7State.php#?
      App\Models\Properties\Property
      6Property.php#?
      App\Models\User
      6User.php#?
      App\Models\SiteSetting
      2SiteSetting.php#?
          _token
          oHAa1cr0CdP0vy4Tty7kqOLNBelnJxtaA7ISD3DU
          _previous
          array:1 [ "url" => "https://realtyflag.com/property-type/duplex" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /property-type/duplex
          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 => "Mon, 14 Apr 2025 14:21:51 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktjV0MxbnZ0T0NGUWE4Rk50RlBQZFE9PSIsInZhbHVlIjoiMURhamJvZjFoNm53Q3pHU2VobXBydFpCU1ZGOWVXb2VIL3hhb0FpQndZOHVYdE5FeURLZWNCWUk1by91bXAzTW9FbDRLY0pacW9IRWxCUmdqQW91THlrV1U3eGNRRnZaK3pEakFCQzdXYUMwdGNrZkFjY2xQS1NjT3VBM2s2aVIiLCJtYWMiOiI3Yjk3MGQwYmY4NzIzMGU0ZTdlNjE5Yjg2N2E1ODJiYjc5ZWIxMDllY2YxMjk2NjEwYWY4MjY1ODBjY2Q1ZTJkIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 16:21:51 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IktjV0MxbnZ0T0NGUWE4Rk50RlBQZFE9PSIsInZhbHVlIjoiMURhamJvZjFoNm53Q3pHU2VobXBydFpCU1ZGOWVXb2VIL3hhb0FpQndZOHVYdE5FeURLZWNCWUk1by91bXAzTW9FbDRLY ▶"
    1 => "laravel_session=eyJpdiI6InM0bGpGY0VRVm0vWXpXMnMzUWNCNmc9PSIsInZhbHVlIjoielZiNnBWSlhUZnpvSzQyUWVaWEdnTlRmbDREZjllRzZQa2Y4MHo4Z2xERDVEOWZTalVtdVl4T1N4YmRDMGQwWHFCdkVpUDVjYzZtRmhxVGUyVlNEZkFCQi9pcjJwRXR5YUpuQzgyRExneS9JVTJUaHRQRFIrVmVKa3JZQmMrUk8iLCJtYWMiOiI5MmJlYTJhOWY5ZmFiMDdmOWFkNDg5MzQ3NTA5NDViYzM5NWYwYmEzMDJkNzcxY2Y5NzMwMjIxYzM5YTEzZjU4IiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 16:21:51 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6InM0bGpGY0VRVm0vWXpXMnMzUWNCNmc9PSIsInZhbHVlIjoielZiNnBWSlhUZnpvSzQyUWVaWEdnTlRmbDREZjllRzZQa2Y4MHo4Z2xERDVEOWZTalVtdVl4T1N4YmRDMGQwWHFC ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktjV0MxbnZ0T0NGUWE4Rk50RlBQZFE9PSIsInZhbHVlIjoiMURhamJvZjFoNm53Q3pHU2VobXBydFpCU1ZGOWVXb2VIL3hhb0FpQndZOHVYdE5FeURLZWNCWUk1by91bXAzTW9FbDRLY0pacW9IRWxCUmdqQW91THlrV1U3eGNRRnZaK3pEakFCQzdXYUMwdGNrZkFjY2xQS1NjT3VBM2s2aVIiLCJtYWMiOiI3Yjk3MGQwYmY4NzIzMGU0ZTdlNjE5Yjg2N2E1ODJiYjc5ZWIxMDllY2YxMjk2NjEwYWY4MjY1ODBjY2Q1ZTJkIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 16:21:51 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IktjV0MxbnZ0T0NGUWE4Rk50RlBQZFE9PSIsInZhbHVlIjoiMURhamJvZjFoNm53Q3pHU2VobXBydFpCU1ZGOWVXb2VIL3hhb0FpQndZOHVYdE5FeURLZWNCWUk1by91bXAzTW9FbDRLY ▶"
    1 => "laravel_session=eyJpdiI6InM0bGpGY0VRVm0vWXpXMnMzUWNCNmc9PSIsInZhbHVlIjoielZiNnBWSlhUZnpvSzQyUWVaWEdnTlRmbDREZjllRzZQa2Y4MHo4Z2xERDVEOWZTalVtdVl4T1N4YmRDMGQwWHFCdkVpUDVjYzZtRmhxVGUyVlNEZkFCQi9pcjJwRXR5YUpuQzgyRExneS9JVTJUaHRQRFIrVmVKa3JZQmMrUk8iLCJtYWMiOiI5MmJlYTJhOWY5ZmFiMDdmOWFkNDg5MzQ3NTA5NDViYzM5NWYwYmEzMDJkNzcxY2Y5NzMwMjIxYzM5YTEzZjU4IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 16:21:51 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InM0bGpGY0VRVm0vWXpXMnMzUWNCNmc9PSIsInZhbHVlIjoielZiNnBWSlhUZnpvSzQyUWVaWEdnTlRmbDREZjllRzZQa2Y4MHo4Z2xERDVEOWZTalVtdVl4T1N4YmRDMGQwWHFC ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▼
  "_token" => "oHAa1cr0CdP0vy4Tty7kqOLNBelnJxtaA7ISD3DU"
  "_previous" => array:1 [▶
    "url" => "https://realtyflag.com/property-type/duplex"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-14 14:21:51GET/property-type/duplex81429