WordPress database error: [Unknown column 'c.builtup_area' in 'where clause']
SELECT DISTINCT post_id FROM tbl_custom c WHERE c.property_type = 'rent' AND c.property_category = 'commercial villa' AND community = 'Al Wasl' AND c.builtup_area BETWEEN 3400 AND 3600 AND c.post_id != 31214352

WordPress database error: [Unknown column 'c.builtup_area' in 'where clause']
SELECT DISTINCT post_id FROM tbl_custom c WHERE c.property_type = 'rent' AND c.property_category = 'commercial villa' AND community = 'Al Wasl' AND c.builtup_area ='3500' AND c.post_id != 31214352 ORDER BY c.Price ASC

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY c.Price ASC' at line 1]
SELECT post_id FROM tbl_custom c WHERE post_id IN () ORDER BY c.Price ASC

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1]
SELECT DISTINCT p.*,c.* FROM wp_posts p INNER JOIN tbl_custom c ON(p.ID = c.post_id) WHERE p.ID IN()

Large Commercial Villa on Al Wasl Street.

AED 300,000/ Anum

Contact us about this property

Loading...
Thank YouYour Enquiry has been sent to the agent who advertised this and they should be in-touch shortly.

Quick Stats:

AED 300,000/ Anum

3 Bed(s)3 Bath(s)3500 Sq.Ft. 4 Car Parking Ref. No: EL-R-9212
Large commercial villa with shared swimming pool available for rent onAl Wasl Roadnext to Safa Park,

This villa has 2 Large office Rooms and Huge hall on ground floor + Laundry/ Server/ Storage/Pantry room + 2 bathrooms.
1st floor comprises of 3 Large office Rooms + 1 smaller room + 2 bathrooms
Built-up area 3,500 sqft
Price: AED 400,000 Negotiable (1 cheque)

Property Feature:
- On Main Road
- Near to Safa Park
- Near to Supermarket
- Bank/ATM Facilities
- Near to Mosque
- Public Parking
- Restaurant & Cafes

RERA Permit No. 8051 valid till 11th January 2018

JUMEIRAH

In Jumeirah, you will enjoy easy access t o all amenities and commercial by car. The region as a whole are served very well by taxi, limousine service in addition to the city Jumeirah.

Constantin & Tatiana | Property Consultant - 050888 2395

BRN: 36045/36047

Elysian Real Estate Broker LLC
1602 Boulevard Plaza Tower 1, Downtown
P.O Box 114703, Dubai, UAE.
t:+971 (0) 4 323 4545
f:+971 (0) 4 341 7781
w:www.elysian.com


PROPERTY FEATURES:
-Balcony
-Built in wardrobes
-Central air conditioning
-Community View
-Driver's Room
-Maid's room
-On low floor
-Private garden
-Upgraded interior
-View of gardens
-Children's play area
-Public parking
-Recreational Facilities
-Restaurants
-Shopping mall
-Shops

Property Features

  • Balcony
  • Built in wardrobes
  • Central air conditioning
  • Community View
  • Driver's Room
  • Maid's room
  • On low floor
  • Private garden
  • Upgraded interior
  • View of gardens
  • Children's play area
  • Public parking
  • Recreational Facilities
  • Restaurants
  • Shopping mall
  • Shops

Property Location

About us and how we deal with you

Elysian Real Estate is a fully fledged one stop property solution for Dubai and Abu Dhabi. We are RERA compliant and proud to have many awards. A team of friendly agents are ready to assist you.

We Guarantee

  • No viewing fees!
  • A personal & speedy service
  • We do your running around
  • To get your paperwork done

Share this:

Similar Properties in Al Wasl

Location & Contact Details

Boulevard Plaza Tower 1 – Suite 1602 – Downtown
P.O.BOX 114703 Dubai, U.A.E

+971 (0)4 323 4545

Map & driving directions

WhatsApp us to your friends

Click to send link
Loading...
Close

Elysian Newsletter

Stay informed about upcoming investment opportunities in Abu Dhabi, Dubai and other international hot spots.

Loading...
Thank you

Your details have been sent and an elysian representitive will be in touch shortly to discuss your requirements.

Return to homepage

Email a friend

Loading...

Thank you, email(s) have been sent to your friend(s).

Choose your currency

Choose your sizing

Back top