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 = 1429416 LIMIT 0,1 Bed Linen from American Beds , BAHRAIN
Gulf Yellow Pages Online
Home » Products »  BED LINEN

BED LINEN

Add Review
Price : On Request

Sold by American Beds

Not Given
  • Product Details
  • Brand :
  • Place of Origin : Not Given
  • FOB Price : On Request
  • Minimum Order Quantity : Not Given
  • Supply Ability :
  • Packaging & Delivery
  • Packaging Detail : Not Given
  • Delivery Detail : Not Given
Not Given
Other Products