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 = 1296146 LIMIT 0,1 Pressure Relief Valve from DAS ENGINEERING WORKS in Mumbai, India

Namibia Yellow Pages Online

	NAMIBIA YELLOW PAGESONLINE
	Global site for local search

DAS ENGINEERING WORKS

DAS ENGINEERING WORKS - | E-Showroom

DAS ENGINEERING WORKS
3/4, Royal Colony, Opp.raigad Military School, New Link Road, Scout Camp Road, Behram Baug Jogeshwari (W), Mumbai Pincode - 400102 (Maha) Mumbai
India