SELECT CompanyID,CompanyName, ContactPerson, Add1, Add2, Add3, a.CityID, a.CountryID, Pincode, TelStdCode, TelNo, FaxStdCode, FaxNo, email, website, FreeEntry, Activities, MobileNo, isElite, eliteuserfilepath, EliteEnteredDate, EliteValidTillDate, eliteConfirmed, datarefId, entryadddate, AllUAEElite, GCCElite, internationalElite, b.CityID, CityName, b.CountryID, citycode, c.CountryID, CountryName, gulfcountry, countrycode, hostcountry, maincompanyid, branchname,hasBranches,lattitude,longitude,mapzoom, skypeid,facebookpageurl,twitterpageurl,Google_store_applink,Apple_store_applink,rating,whatsappnoforchat,noofreviews,worstrating,bestrating FROM mstcompany a LEFT JOIN mstcity b ON a.CityID = b.CityID LEFT JOIN mstcountry c ON a.CountryID = c.CountryID WHERE a.companyid = 574281 LIMIT 0,1 Product Catalog of AL HUWAIDY REAL ESTATE - Saudi Yellow Pages Online
Saudi Yellow Pages Online
AL HUWAIDY REAL ESTATE

AL HUWAIDY REAL ESTATE - | E-Showroom

Home » Catalogue
Products Catalogue

About Us

Saudi Arabia Yellow Pages Online is a Local Business to Business Directory in Saudi Arabia offering business list of more than 250,000 companies. You can find Hotels in Saudi Arabia , Companies in Saudi Arabia , Properties in Saudi Arabia , Travel info in Saudi Arabia through this Site. Yellow Pages Saudi Arabia Updated in 2025 Get Maximum Benefit for your Business Visit YP MarketPlaces

Our Policies

Privacy Policy
Refund Policy
Dispute & Resolution Policy
Terms

Follow Us

Top Brands in Saudi Arabia
Top Countries (Gulf)
Top Cities (Africa)
Top Cities (India)

Contact Saudi Yellow Pages Online

  • Ajman Free Zone, Ajman , United Arab Emirates
  • Sales & Support Contact: 00971 56 129 4091
  • support@gulfyp.com
  • India Office of Saudi Yellow Pages Online
  • Contact: +91 7977 00 5636 / 7977 08 1292
  • support@gulfyp.com
HOME l PRODUCT CATEGORIES l B2B MARKETPLACE l ADVERTISE l ADD COMPANY l ABOUT SAUDI ARABIA | CONTACT US
Privacy Policy - Terms of Use - 2020-2025 Saudi Yellow Pages Online
Copyright Notice 2020-2025 Saudi Yellow Pages Online All rights reserved.
Saudi Yellow Pages Online