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 = 1403935 LIMIT 0,1 Air Compressor from Transcon Engineers Pvt. Ltd in Ludhiana, India
Algeria Yellow Pages Online
Home » Products »  AIR COMPRESSOR

Trading of Air Compressor
  • 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