You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY view_name ASC' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fitting_fixture_name ASC' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY feature_name ASC' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY view_name ASC' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY feature_name ASC' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fitting_fixture_name ASC' at line 1 with M.B.H Properties You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

1 Bedroom - -

AED 4,500/Month

  • Location
    -
  • Unit Type
    Studio
  • Approx Size
    0 sq.ft
  • Consultant's name
  • Ref. No.
    MBH0019
  • 0
  • Image
    Gallery
  • Digital Brochure
  • You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Property Details

Facilities and Amenities

Share This Property

Legal Update: Click here to learn about the recent rental cap laws and tenancy regulations.

Disclaimer
M.B.H Properties does not warrant the accuracy, adequacy, or completeness of the information presented herein and expressly disclaims liability for any errors or omissions therein. The information presented herein may include data supplied to M.B.H Propertiesby third parties. Such data may be amended or changed at any time by third parties without notice to M.B.H Properties. Accordingly, no warranties of any kind, express or statutory are given in respect of the information

Office Locations

 Location Map

Office Address

Property Consultant

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND unit_type_id=132 AND build_type_id=23 AND listing_type="rental" AND proper' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND unit_type_id=132 AND build_type_id=23 AND listing_type="rental" AND proper' at line 1