Flats with Attractive Rent for in Deira residential or commercial Frij Murar Dubai

Price: AED 24,000 24000 AED
Contact 042712323
Created by
Guest

Description

Studio Rent AED 24000 to 36000
Location
Al Khaleej Street
Walking distance to Gold Souq
Mobile Market Metro Station
Walking distance to RTA Bus Stop
Walking distance to supermarket and restaurants
Walking distance to Burj Nahar Bus Stop
Opposite to Latifa Mosque

IMPORTANT!

Before you contact the advertiser, do a payment or make a deal, please read our SAFETY TIPS.

Help us and report scams, don't forget to read vivaUAE TERMS AND CONDITIONS.

Specific details

Property type Apartment
Bedrooms Studio
Bathroom 1
Furniture Unfurnished
Security Deposit Yes
No of Cheques 4
Ad owner type Landlord

Location

Deira, Dubai
Firj al murar deira dubai uae

Advert details

Advert ID 271409
Displayed 255
Added 2025-06-20 15:26:52
Expires never expire
Settings64.523MBMemory Usage2.44sRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.3
PHP Version8.2.29
Identityguest
Response200
Templateja_essence
Database
Server
mysql
Version
8.0.43
Collation
utf8mb4_0900_ai_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "USER" => "vivauae" "HOME" => "/home/vivauae" "SCRIPT_NAME" => "/index.php" "REQU...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1759335360 "last" => 1759335360...
registry
array:3 [ "data" => array:1 [ "djcf" => array:1 [ "pre_edit_page" => array:3 [ "...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.52MB) (39.04ms)
  • afterInitialise (9.44MB) (120ms)
  • Before Access::preloadComponents (all components) (3.19MB) (24.14ms)
  • After Access::preloadComponents (all components) (129.91KB) (1.42ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1.32KB) (28μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.26KB) (448μs)
  • afterRoute (131.22KB) (12.52ms)
  • beforeRenderComponent com_djclassifieds (456.63KB) (4.48ms)
  • Before Access::getAssetRules (id:212 name:com_djclassifieds) (1.92MB) (24.45ms)
  • After Access::getAssetRules (id:212 name:com_djclassifieds) (1.98KB) (14μs)
  • beforeRenderRawModule mod_custom (Scam Warning - Stay Safe) (3.38MB) (60.99ms)
  • afterRenderRawModule mod_custom (Scam Warning - Stay Safe) (106.26KB) (1.83ms)
  • beforeRenderModule mod_custom (Scam Warning - Stay Safe) (736B) (8μs)
  • afterRenderModule mod_custom (Scam Warning - Stay Safe) (14.02KB) (684μs)
  • afterRenderComponent com_djclassifieds (141.75KB) (2.67ms)
  • afterDispatch (31.13KB) (865μs)
  • beforeRenderRawModule mod_menu (mainmenu) (1.26MB) (2.08s)
  • afterRenderRawModule mod_menu (mainmenu) (1.77MB) (44.68ms)
  • beforeRenderModule mod_menu (mainmenu) (704B) (13μs)
  • afterRenderModule mod_menu (mainmenu) (27.7KB) (559μs)
  • afterRender (601.75KB) (21.97ms)
  • 1 x beforeRenderRawModule mod_menu (mainmenu) (1.26MB) (85.1%)
    2.08s
    1 x afterInitialise (9.44MB) (4.92%)
    120ms
    1 x beforeRenderRawModule mod_custom (Scam Warning - Stay Safe) (3.38MB) (2.5%)
    60.99ms
    1 x afterRenderRawModule mod_menu (mainmenu) (1.77MB) (1.83%)
    44.68ms
    1 x afterLoad (3.52MB) (1.6%)
    39.04ms
    1 x Before Access::getAssetRules (id:212 name:com_djclassifieds) (1.92MB) (1%)
    24.45ms
    1 x Before Access::preloadComponents (all components) (3.19MB) (0.99%)
    24.14ms
    1 x afterRender (601.75KB) (0.9%)
    21.97ms
    1 x afterRoute (131.22KB) (0.51%)
    12.52ms
    1 x beforeRenderComponent com_djclassifieds (456.63KB) (0.18%)
    4.48ms
    1 x afterRenderComponent com_djclassifieds (141.75KB) (0.11%)
    2.67ms
    1 x afterRenderRawModule mod_custom (Scam Warning - Stay Safe) (106.26KB) (0.07%)
    1.83ms
    1 x After Access::preloadComponents (all components) (129.91KB) (0.06%)
    1.42ms
    1 x afterDispatch (31.13KB) (0.04%)
    865μs
    1 x afterRenderModule mod_custom (Scam Warning - Stay Safe) (14.02KB) (0.03%)
    684μs
    1 x afterRenderModule mod_menu (mainmenu) (27.7KB) (0.02%)
    559μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.26KB) (0.02%)
    448μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (1.32KB) (0%)
    28μs
    1 x After Access::getAssetRules (id:212 name:com_djclassifieds) (1.98KB) (0%)
    14μs
    1 x beforeRenderModule mod_menu (mainmenu) (704B) (0%)
    13μs
    1 x beforeRenderModule mod_custom (Scam Warning - Stay Safe) (736B) (0%)
    8μs
52 statements were executed, 3 of which were duplicates, 49 unique37.75ms258.78KB
  • SELECT @@SESSION.sql_mode;184μs968B/libraries/src/Session/MetadataManager.php:184Copy
  • SELECT `session_id` FROM `xgmwj_session` WHERE `session_id` = :session_id LIMIT 1203μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `xgmwj_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.22ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `xgmwj_viewlevels`176μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `xgmwj_usergroups` AS `a` LEFT JOIN `xgmwj_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest336μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `path` FROM xgmwj_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'205μs520B/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM xgmwj_rsfirewall_hashes WHERE `type`='protect'518μs520B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM xgmwj_rsfirewall_configuration268μs1.63KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `xgmwj_rsfirewall_logs`1.23ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT `value` FROM `xgmwj_admintools_storage` WHERE `key` = 'cparams'427μs520B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `xgmwj_admintools_wafexceptions`157μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `xgmwj_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'308μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • UPDATE xgmwj_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'1.44ms48B/plugins/system/jacontenttype/jacontenttype.php:76Copy
  • SELECT * FROM xgmwj_menu WHERE alias ='all-classifieds-ads' AND published=1639μs2.8KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352Copy
  • SELECT `id` FROM `xgmwj_usergroups`346μs712B/administrator/components/com_rsfirewall/helpers/users.php:28Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `xgmwj_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)879μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT DISTINCT(`user_id`) FROM `xgmwj_usergroups` AS `ug1` INNER JOIN `xgmwj_usergroups` AS `ug2` ON `ug2`.`lft` >= `ug1`.`lft` AND `ug1`.`rgt` >= `ug2`.`rgt` INNER JOIN `xgmwj_user_usergroup_map` AS `m` ON `ug2`.`id` = `m`.`group_id` WHERE `ug1`.`id` = :groupId1.71ms2.55KBParams/libraries/src/Access/Access.php:922Copy
  • SELECT DISTINCT(`user_id`) FROM `xgmwj_usergroups` AS `ug1` INNER JOIN `xgmwj_usergroups` AS `ug2` ON `ug2`.`lft` >= `ug1`.`lft` AND `ug1`.`rgt` >= `ug2`.`rgt` INNER JOIN `xgmwj_user_usergroup_map` AS `m` ON `ug2`.`id` = `m`.`group_id` WHERE `ug1`.`id` = :groupId1.49ms1.31KBParams/libraries/src/Access/Access.php:922Copy
  • SELECT u.* FROM xgmwj_users u WHERE u.id IN (995) ORDER BY u.username ASC249μs2.38KB/administrator/components/com_rsfirewall/helpers/users.php:61Copy
  • SELECT * FROM xgmwj_rsfirewall_hashes WHERE (`type`='5.3.3' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)631μs816B/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM xgmwj_rsfirewall_snapshots WHERE `type`='protect'178μs704B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT * FROM `xgmwj_users` WHERE `id` = '995'213μs2.38KB/plugins/system/rsfirewall/rsfirewall.php:1145Copy
  • SELECT group_id FROM xgmwj_user_usergroup_map WHERE `user_id`=995177μs536B/administrator/components/com_rsfirewall/helpers/snapshot.php:70Copy
  • SELECT `ip`,`reason` FROM xgmwj_rsfirewall_lists WHERE (`ip`='216.73.216.133' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'247μs576B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM xgmwj_rsfirewall_lists WHERE (`ip`='216.73.216.133' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'258μs576B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM xgmwj_rsfirewall_exceptions WHERE `published`='1'202μs1.42KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT item_id FROM xgmwj_djcf_items_promotions WHERE date_exp <= '2025-10-01 16:16:00' AND updated=0 GROUP BY item_id631μs520B/administrator/components/com_djclassifieds/lib/djpayment.php:819Copy
  • SELECT * FROM xgmwj_djcf_items WHERE id=271409421μs21.97KB/components/com_djclassifieds/controllers/item.php:29Copy
  • SELECT c.*, ic.item_id, ic.cat_id FROM xgmwj_djcf_items_categories ic INNER JOIN xgmwj_djcf_categories c ON ic.cat_id=c.id WHERE ic.item_id = 271409 ORDER BY ic.ordering459μs3.08KB/plugins/djclassifieds/multicategories/multicategories.php:181Copy
  • SELECT * FROM xgmwj_djcf_categories WHERE id=129 LIMIT 1301μs3.03KB/components/com_djclassifieds/controllers/item.php:55Copy
  • UPDATE xgmwj_djcf_items SET display=display+1 WHERE id=2714091.68ms48B/components/com_djclassifieds/controllers/item.php:133Copy
  • SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, c.access_view as c_access_view, c.access_item_view as c_access_item_view, c.rev_group_id, r.id r_id, r.name as r_name, r.alias as r_alias, u.name u_name, u.username, u.name as authorname, u.email as u_email, p.group_id, iu.name as unit_name , t.id as t_id, t.name as t_name, t.params as t_params FROM xgmwj_djcf_items i LEFT JOIN xgmwj_djcf_categories c ON i.cat_id=c.id LEFT JOIN xgmwj_djcf_types t ON t.id = i.type_id LEFT JOIN xgmwj_users u ON u.id = i.user_id LEFT JOIN xgmwj_djcf_profiles p ON i.user_id = p.user_id LEFT JOIN xgmwj_djcf_regions r ON r.id = i.region_id LEFT JOIN xgmwj_djcf_items_units iu ON iu.id = i.unit_id WHERE i.id = 271409 LIMIT 1639μs9.48KB/components/com_djclassifieds/models/item.php:35Copy
  • SELECT fv.*,f.* FROM xgmwj_djcf_fields f INNER JOIN xgmwj_djcf_fields_values fv ON f.id = fv.field_id AND fv.item_id = 271409 WHERE f.source IN (0,1) AND f.published = 1 AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') AND f.name NOT IN ("type_id","region_id")693μs7.97KB/administrator/components/com_djclassifieds/lib/djfield.php:1060Copy
  • SELECT * FROM xgmwj_djcf_categories WHERE published=1 AND access_view IN (1,5) ORDER BY parent_id, ordering ASC1.72ms59.02KB/administrator/components/com_djclassifieds/lib/djcategory.php:538Copy
  • SELECT r.* FROM xgmwj_djcf_regions r WHERE published=1 ORDER BY r.parent_id, name ASC2.94ms58.36KB/administrator/components/com_djclassifieds/lib/djregion.php:380Copy
  • SELECT c.*, ic.item_id, ic.cat_id FROM xgmwj_djcf_items_categories ic INNER JOIN xgmwj_djcf_categories c ON ic.cat_id=c.id WHERE ic.item_id = 271409 ORDER BY ic.ordering349μs3.08KB/plugins/djclassifieds/multicategories/multicategories.php:181Copy
  • SELECT c.*, ic.item_id, ic.cat_id FROM xgmwj_djcf_items_categories ic INNER JOIN xgmwj_djcf_categories c ON ic.cat_id=c.id WHERE ic.item_id = 271409 ORDER BY ic.ordering232μs3.08KB/plugins/djclassifieds/multicategories/multicategories.php:181Copy
  • SELECT * FROM xgmwj_djcf_categories WHERE id=129 AND published=1 LIMIT 1265μs3.03KB/components/com_djclassifieds/model.php:300Copy
  • SELECT * FROM xgmwj_djcf_regions WHERE id=158 AND published=1 LIMIT 1169μs2.38KB/components/com_djclassifieds/model.php:347Copy
  • SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, c.autopublish as c_autopublish, c.price as c_price, c.points as c_points, c.access_view as c_access_view, c.access_item_view as c_access_item_view, iu.name as unit_name, r.id as r_id, r.name as r_name, r.alias as r_alias, u.name as authorname, u.name as u_name, u.username, u.username as u_username, u.email as u_email, p.group_id, t.name as t_name, t.id as t_id, t.params as t_params FROM xgmwj_djcf_items i LEFT JOIN xgmwj_djcf_categories c ON c.id=i.cat_id LEFT JOIN xgmwj_djcf_regions r ON r.id=i.region_id LEFT JOIN xgmwj_djcf_types t ON t.id=i.type_id LEFT JOIN xgmwj_users u ON u.id=i.user_id LEFT JOIN xgmwj_djcf_profiles p ON i.user_id=p.user_id LEFT JOIN xgmwj_djcf_items_units iu ON iu.id = i.unit_id WHERE i.id=271409 LIMIT 1419μs9.62KB/components/com_djclassifieds/model.php:42Copy
  • SELECT fv.*,f.* FROM xgmwj_djcf_fields f INNER JOIN xgmwj_djcf_fields_xref fx ON f.id = fx.field_id AND fx.cat_id IN (SELECT cat_id FROM xgmwj_djcf_items_categories WHERE item_id=271409 UNION SELECT 129) LEFT JOIN xgmwj_djcf_fields_values fv ON fv.field_id = fx.field_id AND fv.item_id = 271409 LEFT JOIN xgmwj_djcf_conditionalfields cf ON f.id = cf.field_id WHERE f.source = 0 AND f.published = 1 AND f.access IN (1,5) AND f.name NOT IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') AND (cf.id IS NULL OR fv.id IS NOT NULL) ORDER BY fx.ordering, f.ordering, f.label6.97ms21.77KB/components/com_djclassifieds/models/item.php:89Copy
  • SELECT fv.*,f.* FROM xgmwj_djcf_fields f LEFT JOIN xgmwj_djcf_fields_values fv ON f.id = fv.field_id AND fv.item_id = 271409 LEFT JOIN xgmwj_djcf_conditionalfields cf ON f.id = cf.field_id WHERE f.source = 1 AND f.published = 1 AND f.access IN (1,5) AND f.name NOT IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') AND (cf.id IS NULL OR fv.id IS NOT NULL) ORDER BY f.ordering, f.label658μs5.48KB/components/com_djclassifieds/models/item.php:117Copy
  • SELECT s.plan_id FROM xgmwj_djcf_plans_subscr_items si INNER JOIN xgmwj_djcf_plans_subscr s ON si.subscr_id=s.id WHERE si.item_id=271409209μs520B/components/com_djclassifieds/models/item.php:143Copy
  • SELECT COUNT(id) FROM xgmwj_djcf_payments WHERE price>0 AND item_id=271409 AND type=0 AND status='Completed'253μs536B/components/com_djclassifieds/models/item.php:151Copy
  • SELECT a.*, u.name as u_name FROM xgmwj_djcf_auctions a LEFT JOIN xgmwj_users u ON a.user_id=u.id LEFT JOIN xgmwj_djcf_items i ON a.item_id=i.id WHERE a.item_id=271409 AND (CASE WHEN i.date_renew IS NOT NULL AND i.date_renew!='0000-00-00 00:00:00' THEN a.date>i.date_renew ELSE 1=1 END) ORDER BY a.date DESC, a.id DESC292μs1.33KB/components/com_djclassifieds/model.php:810Copy
  • SELECT img.* FROM xgmwj_djcf_images img WHERE img.item_id IN (271409) AND img.type='item' ORDER BY img.item_id, img.ordering364μs1.34KB/administrator/components/com_djclassifieds/lib/djimage.php:265Copy
  • UPDATE xgmwj_djcf_items SET last_view='2025-10-01 16:16:00' WHERE id=2714091.56ms48B/components/com_djclassifieds/models/item.php:165Copy
  • SELECT hide_on_start FROM xgmwj_djcf_fields WHERE name='contact' AND published=1299μs472B/components/com_djclassifieds/models/item.php:130Copy
  • SELECT a.id, a.alias, a.catid, c.alias as c_alias FROM xgmwj_content a LEFT JOIN xgmwj_categories c ON c.id=a.catid WHERE a.state=1 AND a.id=69268μs704B/components/com_djclassifieds/model.php:749Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `xgmwj_categories` AS `s` INNER JOIN `xgmwj_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`959μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT a.id, a.alias, a.catid, c.alias as c_alias FROM xgmwj_content a LEFT JOIN xgmwj_categories c ON c.id=a.catid WHERE a.state=1 AND a.id=71236μs704B/components/com_djclassifieds/model.php:749Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `xgmwj_scheduler_tasks` AS `a` WHERE `a`.`state` = 1890μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy