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 = 1287903 LIMIT 0,1 Ride On Floor Cleaning Machine - Scrubber Drier from Teejan Equipment LLC in Muscat, Oman

UAE Yellow Pages Online

	UAE YELLOW PAGESONLINE
	Global site for local search

Teejan Equipment LLC
Trader Exporter

Teejan Equipment LLC - | E-Showroom

Teejan Equipment LLC
Teejan Equipment LLC, Opp. Al Tasnim Towers, Street No. 319, Building No 56, Showroom No 2-3-4, Ghala, Muscat, Oman Muscat
Oman