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

Townhouse Type Property

Property
Status Of Property
Search Reasults: Showing 3 Listings
Featured
For rent

Type B 3BR with Perfect Vastu Facing Garden

Start From

$190,000

Agent

RERA Permit 103261 Townhouse for Sale @ Murooj Al Furjan Vastu Compliant Type B 3 Bedrooms 4 Washrooms Built-In Wardrobes Balcony Closed Kitchen Facing Garden Parking Space Size: 2,561.81 sq.ft.

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

TOWNHOUSE FOR SALE IN AURUM VILLAS, SANCTNARY

Start From

$1,750,000

Agent

Pictures For only Marketing Purpose - Unfurnished - 3 Bedrooms - 5 Bathrooms - Maid Room - Close to the Entrance - Big Terrace - Close Kitchen - 2 Parking Space - Vacant - Back to Back

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

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

Start From

$3,700,000

Agent

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

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

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

MessagesTimelineExceptionsViews8RouteQueries11Models23MailsGateSessionRequest
Request history8.2.20PHP Version515msRequest Duration1MBMemory UsageGET property-type/{slug}Route
    • Booting (340ms)time
    • Application (175ms)time
    • 1 x Booting (65.96%)
      340ms
      1 x Application (33.96%)
      175ms
      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
      11 statements were executed, 5 of which were duplicates, 6 unique. Show only duplicated75.8ms
      • select * from `property_types` where (`slug` = 'townhouse') limit 1
        4.39msrealestatePropertyTypeController.php#13
        Bindings
        • 0: townhouse
        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` = 3
        13.43msrealestatePropertyTypeController.php#15
        Bindings
        • 0: 1
        • 1: 3
        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` = 3 limit 15 offset 0
        1.03msrealestatePropertyTypeController.php#15
        Bindings
        • 0: 1
        • 1: 3
        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
        7.93msrealestateState.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
        1.74msrealestateSidebarComposer.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
        8.07msrealestateshow.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
        1.44msrealestateshow.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
        860μsrealestateshow.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
        9.92msrealestateheader.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
        14.56msrealestatefooter.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
        12.43msrealestatefooter.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
      3Property.php#?
      App\Models\User
      3User.php#?
      App\Models\SiteSetting
      2SiteSetting.php#?
          _token
          YI6yDAtNfwhrHG3YUMa1ryRYZvmq7FDMlZRu8M1D
          _previous
          array:1 [ "url" => "https://realtyflag.com/property-type/townhouse" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /property-type/townhouse
          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 => "Sun, 13 Apr 2025 03:12:16 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InV6ckpqZ2pVNUVrc3R1V2dtVlZUelE9PSIsInZhbHVlIjoicUV5N3Uwb1NTM0wxVmtPaDh3SDlUajZ4eHBwYW5kN0RkUFBzZ25HYVBPR2NHOHRVQ1ZTZDVTc1owcklXTjRoNEJDUE1lR2VIbGd4SHMybFVzR3FaVms2UjhQVGU5TXhxa1BST0lBWW12VVhwYWw3V2pKankyUndSeThmaUoyS2IiLCJtYWMiOiIwMDgwN2U2YzZmNGNmODgwNTJlYzZkNzMxMGJkZmFmZTUzNDI2ZGQyM2EwOWY0NjQyYmI4YWRjYzc2M2U5Zjc5IiwidGFnIjoiIn0%3D; expires=Sun, 13 Apr 2025 05:12:16 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InV6ckpqZ2pVNUVrc3R1V2dtVlZUelE9PSIsInZhbHVlIjoicUV5N3Uwb1NTM0wxVmtPaDh3SDlUajZ4eHBwYW5kN0RkUFBzZ25HYVBPR2NHOHRVQ1ZTZDVTc1owcklXTjRoNEJDUE1lR ▶"
    1 => "laravel_session=eyJpdiI6IjdQWjhjUU1YOUEzWk9PWDNtaXQzekE9PSIsInZhbHVlIjoicnNQWlNRWTVoWjVicGxmQ1U0OEZjWmxvckdoTVdORko3ek90TyttcFpUUmNLbElVbDFTMnRiZlA0aFVRaUxmYnY5T0dNd1RRUkRJV2Y5bFg4NE9JM2U1NFNlOVJmQ2wvRzZmVnhCdHhPQWZ2VjhHc1k5NWJoWk5hTVlpVUEweVQiLCJtYWMiOiJkZGI4M2IxMzk4Njc4NTBjYzk5OWZiNzhkZGY2MzA3MjA1NzUzMWRjMGM0YWYyY2M1ZDM1ODY1YTQwNTAzYmU3IiwidGFnIjoiIn0%3D; expires=Sun, 13 Apr 2025 05:12:16 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjdQWjhjUU1YOUEzWk9PWDNtaXQzekE9PSIsInZhbHVlIjoicnNQWlNRWTVoWjVicGxmQ1U0OEZjWmxvckdoTVdORko3ek90TyttcFpUUmNLbElVbDFTMnRiZlA0aFVRaUxmYnY5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InV6ckpqZ2pVNUVrc3R1V2dtVlZUelE9PSIsInZhbHVlIjoicUV5N3Uwb1NTM0wxVmtPaDh3SDlUajZ4eHBwYW5kN0RkUFBzZ25HYVBPR2NHOHRVQ1ZTZDVTc1owcklXTjRoNEJDUE1lR2VIbGd4SHMybFVzR3FaVms2UjhQVGU5TXhxa1BST0lBWW12VVhwYWw3V2pKankyUndSeThmaUoyS2IiLCJtYWMiOiIwMDgwN2U2YzZmNGNmODgwNTJlYzZkNzMxMGJkZmFmZTUzNDI2ZGQyM2EwOWY0NjQyYmI4YWRjYzc2M2U5Zjc5IiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 05:12:16 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InV6ckpqZ2pVNUVrc3R1V2dtVlZUelE9PSIsInZhbHVlIjoicUV5N3Uwb1NTM0wxVmtPaDh3SDlUajZ4eHBwYW5kN0RkUFBzZ25HYVBPR2NHOHRVQ1ZTZDVTc1owcklXTjRoNEJDUE1lR ▶"
    1 => "laravel_session=eyJpdiI6IjdQWjhjUU1YOUEzWk9PWDNtaXQzekE9PSIsInZhbHVlIjoicnNQWlNRWTVoWjVicGxmQ1U0OEZjWmxvckdoTVdORko3ek90TyttcFpUUmNLbElVbDFTMnRiZlA0aFVRaUxmYnY5T0dNd1RRUkRJV2Y5bFg4NE9JM2U1NFNlOVJmQ2wvRzZmVnhCdHhPQWZ2VjhHc1k5NWJoWk5hTVlpVUEweVQiLCJtYWMiOiJkZGI4M2IxMzk4Njc4NTBjYzk5OWZiNzhkZGY2MzA3MjA1NzUzMWRjMGM0YWYyY2M1ZDM1ODY1YTQwNTAzYmU3IiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 05:12:16 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjdQWjhjUU1YOUEzWk9PWDNtaXQzekE9PSIsInZhbHVlIjoicnNQWlNRWTVoWjVicGxmQ1U0OEZjWmxvckdoTVdORko3ek90TyttcFpUUmNLbElVbDFTMnRiZlA0aFVRaUxmYnY5 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▼
  "_token" => "YI6yDAtNfwhrHG3YUMa1ryRYZvmq7FDMlZRu8M1D"
  "_previous" => array:1 [▶
    "url" => "https://realtyflag.com/property-type/townhouse"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-13 03:12:16GET/property-type/townhouse81123