Verified Global supplier for ceiling fan

Save this search

Display results per page.

Name
Company
Contact Info
Contact Type

Save this search

Display results per page.

Name
Company
Contact Info
Contact Type

- Ms. Alice Chen
  (Sales Manager)
  / Mr. Shi Xiaohong
  (Legal Representative)
  
  CHINA
ZHONGSHAN KEBAISHI ELECTRIC APPLIANCE CO., LTD.
Corporate Email:

163.com
- Brief intro of company : Zhongshan Kebaishi Electric Appliance Co., Ltd., Established On February 28, 2017, Is A Professional Manufacturer Specializing In Ceiling Fans And Lighting Appliances. The Company Operates A 12,000 Square Meter Facility And Has Passed Iso 9001 Quality System Certification. Its Products Have Obtained Certifications Such As Etl, Ce, And Rohs. The Company Exports To Markets Including North America, Europe, Southeast Asia, And The Middle East.
  Actual Product : Celing Fan-kbs 5209b1-52 Inch-coffee Brown Body Walnut Blades
  Business Category : Manufacturer Of Ceiling Fans And Lighting Appliances
  ZHONGSHAN KEBAISHI ELECTRIC APPLIANCE CO., LTD.
  kbsceilingfans.com
  
  Address
  5/F-2, No. 10, Youyi 1st Road, Yongxing Industrial Park, Henglan Town, Zhongshan City, Guangdong Province, China
- Ms. Rose Wang
  (Sales Representative / Sales Director)
  / Mr. Manager
  ()
  
  CHINA
FOSHAN SHUNDE YUSHENGJIA ELECTRICAL CO., LTD.
Corporate Email:

yushengjia.com.cn
- Brief intro of company : Founded In 2008 And Based In Shunde, Foshan—china’s Renowned Electrical Appliance Hub—this Company Integrates R&d, Production And Marketing Of Luxury Decorative Ceiling Fans. It Operates A Modern Facility With Approximately 13,900 m² (or Up To 20,000 m²) Of Workshop Space, Five Production Lines And Annual Output Of Around 200,000 Units. Certified To Iso 9001, Ccc, Ce, Cb, Rohs, Etl And Other Standards, Their Brand Youkain Is Well Known Domestically And Exports Worldwide With Innovative Dc Motor Fans Offering Smart Features.
  Business Category : Manufacturer Of Decorative Ceiling Fans (luxury Ceiling Fans, With/without Lights; Brand
  FOSHAN SHUNDE YUSHENGJIA ELECTRICAL CO., LTD.
  yushengjia.com
  
  Address
  No. 3 Jin an Road, Jun an Town, Shunde District, Foshan City, Guangdong Province, 528329, China
- Mr. Brian Gong
  (Business Manager)
  / Ms. Li Juan
  (Legal Representative)
  
  CHINA
ZHONGSHAN GESHENG ELECTRIC APPLIANCE CO., LTD.
Corporate Email:

geshengfan.com
- Brief intro of company : Established In 2014, Zhongshan Gesheng Electric Appliance Co., Ltd. Is A Professional Manufacturer Specializing In The Research, Development, Production, Sales, And Service Of Ceiling Fans. The Company Offers A Wide Range Of Products Including Led Ceiling Fans, Fan Lights, And Smart Ceiling Fans. With A Monthly Output Of Over 200,000 Motors And 50,000 Ceiling Fans, Gesheng Serves Clients Across More Than 40 Countries, Including The United States, Spain, France, Israel, Australia, Singapore, South Korea, Italy, Germany, Canada, Argentina, Mexico, And India.
  Actual Product : Gs4336-ceiling Fan-5 Abs Blades, Bronze Body+wood Blade
  Business Category : Manufacturer Of Ceiling Fans And Fan Lights
  ZHONGSHAN GESHENG ELECTRIC APPLIANCE CO., LTD.
  geshengfan.com
  https://www.linkedin.com/company/geshengfan
  
  Address
  Building 1, No. 17, Fuqing 2nd Road, Henglan Town, Zhongshan City, Guangdong Province, China
- Anant Bajaj
  (Managing Director)
  
  INDIA
BAJAJ ELECTRICALS LIMITED
Corporate Email:

bajajelectricals.com
- Brief intro of company : Bajaj Electricals Limited, A Part Of The Bajaj Group, Is A Leading Manufacturer Of Consumer Electrical Products, Including Fans, Lighting, And Home Appliances. The Company Also Undertakes Epc (engineering, Procurement, And Construction) Projects In The Power Distribution And Transmission Sectors. Established In 1938, Bajaj Electricals Has A Strong Presence In India And Abroad, With A Commitment To Innovation And Quality.
  Actual Product : Stator Of Ceiling Fans (free Of Cost)
  Product Category : Air Or Vacuum Pumps, Air Or Other Gas Compressors And Fans; Ventilating Or Recycling Hoods Incorporating A Fan, Whether Or Not Fitted
  Business Category : Consumer Electricals, Lighting, Epc Projects
  HS Code Direct : 8414
  BAJAJ ELECTRICALS LIMITED
  bajajelectricals.com
  www.linkedin.com/company/bajaj-electricals-limited
  
  Address
  Bajaj Bhavan, 1st Floor, 226, Jamshedji Tata Road, Mumbai – 400 020, Maharashtra, India
- Ms. Jane Huang
  (CEO)
  / Ms. Mannie Chu
  (Regional Manager, Export Department)
  
  CHINA
JIANGMEN JINLING VENTILATING FAN MANUFACTURE LTD.
Corporate Email:

jinlingshan.com.cn
- Brief intro of company : Jiangmen Jinling Ventilating Fan Manufacture Ltd., Established In 1974, Is A Leading Manufacturer Specializing In The Development, Production, And Sales Of Environmental Electrical Appliances. The Company Produces A Wide Range Of Products Including Ventilation Fans, Electrical Fans, Ceiling Fans, Air Curtains, And Bathroom Heaters. With A Manufacturing Area Of Approximately 70,000 Square Meters, The Company Operates 16 Workshops And Employs Over 1,000 Staff. Its Products Are Exported To More Than 40 Countries And Regions, Including Europe, The United States, Japan, Southeast Asia, South America, The Middle East, And South Africa. The Company Holds Iso9001:2008 Quality Management System Certification And Various International Certifications Such As Ce, Cb, Ul, And Saso.
  Business Category : Manufacturer Of Ventilation Fans, Electrical Fans, Ceiling Fans, Air Curtains, And Bathroom Heaters
  JIANGMEN JINLING VENTILATING FAN MANUFACTURE LTD.
  jinlingshan.com.cn
  
  Address
  No. 1, Jinling Road, Binjiang Avenue, Jiangmen City, Guangdong Province, China
- Liu Shikun
  (Legal Representative, Executive Director & Manager)
  / Liu Shugen
  (Supervisor & Shareholder (30%))
  
  CHINA
FOSHAN SHUNDE YUSHENGJIA ELECTRICAL CO., LTD.
Corporate Email:

yushengjia.com
- Brief intro of company : Founded August 7, 2008, Foshan Shunde Yushengjia Electrical Co., Ltd. (brand “youkain”/“佑家”) Is A High-tech Sme Based In Shunde, Foshan, Specializing In Luxury Decorative Ceiling Fans. The Company Operates A 15,000–20,000 m² Modern Facility, Holds Iso 9001, Ccc, Ce, Rohs, Etl, Saa & Cb Certifications, And Offers Nationwide 10 Year Motor Warranty. It Owns Over 40 Patents And More Than 24 Trademarks. Yushengjia Integrates R&d, Production, Marketing, And Export, With Products Sold Domestically And Overseas Through A Global Distribution Network Under The Youkain Brand—recognized Among China’s Top 10 Ceiling Fan Brands For Seven Consecutive Years
  Actual Product : Ceiling Fans-52-yj869 (dark Wood)
  Product Category : Air Or Vacuum Pumps, Air Or Other Gas Compressors And Fans; Ventilating Or Recycling Hoods Incorporating A Fan, Whether Or Not Fitted
  Business Category : Manufacturer And Exporter Of Luxury Decorative Ceiling Fans (with/without Lights), Lighting Fixtures, Plastic Products, Home Appliances, Electronic Components; R&d, Production, Sales, Import-export
  HS Code Direct : 8414
  FOSHAN SHUNDE YUSHENGJIA ELECTRICAL CO., LTD.
  yushengjia.com
  
  Address
  Changxing Industrial Park (or Qian’an Road), Jun’an Town, Shunde District, Foshan, Guangdong Province, China, 528300
- Sungyoung lee
  (CEO)
  / Yoon‑woo lee
  (Chairman)
  
  SOUTH KOREA
DAI HAN PHARM. CO., LTD
Corporate Email:

daihan.com
- Brief intro of company : Dai Han Pharm. Co., Ltd Is A Korean Pharmaceutical Firm Established In 1945, Recognized As A Representative Infusion Manufacturer In Korea Producing A Wide Range Of Therapeutic And Otc Drugs.
  Actual Product : Industrial Ceiling Fan, Brand Kale, Diamond, Model Shvls-d8baa42, Electric, Capacity 0.4kw, No Protective Net, 100% New #&cn
  Product Category : Air Or Vacuum Pumps, Air Or Other Gas Compressors And Fans; Ventilating Or Recycling Hoods Incorporating A Fan, Whether Or Not Fitted
  Business Category : Pharmaceuticals – Manufacture & Sale Of Infusions, Injectables, Otc Drugs
  HS Code Direct : 8414
  DAI HAN PHARM. CO., LTD
  daihan.com
  
  Address
  3, Seonyu-ro 45-gil, Yeongdeungpo-gu, Seoul, 07209, Republic of Korea
- Mr. Adem Çavdar
  / Mr. Mehmet Özbayram
  
  TURKEY
AKTIF ASPIRATOR ELEKTRIKLI MOTOR LTD. STI.
Found 0 Email
- Brief intro of company : Aktif Aspirator Elektrikli Motor Ltd. Sti. Is A Turkish Manufacturer And Exporter Specializing In Various Types Of Fans And Ventilation Equipment. Their Product Range Includes Extractor Fans, Ceiling Fans, Radial Fans, Axial Extractor Fans, Plastic Fans, Domestic And Industrial Fans, And Aspirators. The Company Serves Both Domestic And International Markets.
  Business Category : Fans, Extractor Fans, Ceiling Fans, Radial Fans, Axial Extractor Fans, Plastic Fans, Domestic Fans, Industrial Fans, Aspirators, Ventilation Equipment
  AKTIF ASPIRATOR ELEKTRIKLI MOTOR LTD. STI.
  
  Address
  Terazidere Mah. Karaman Sok. No: 20, Bayrampaşa, Istanbul, Turkey
- Vương Văn Khu
  (Managing Director)
  / Mr. Manager
  ()
  
  VIETNAM
TIEN DAT MECHANICAL CO., LTD
Found 0 Email
- Actual Product : Industrial Ceiling Fans; Model: Sax-5000; Number Of Blades: 6 Aluminum Alloy Blades; Capacity: 0.75 Kw/flow: 9,000 M3/minute; Pressure: 30 - 80 Pa /power Source: 3p/380v; System Fan Vietnam; 100% New Product#&vn
  Product Category : Air Or Vacuum Pumps, Air Or Other Gas Compressors And Fans; Ventilating Or Recycling Hoods Incorporating A Fan, Whether Or Not Fitted
  HS Code Direct : 8414
  TIEN DAT MECHANICAL CO., LTD
  
  Address
  Thôn Dương Đanh, Xã Gia Lâm, Thành phố Hà Nội, Việt Nam
- Mr. Manager
  INDIA
BHARADIA & SONS
Found 0 Email
- Brief intro of company : Bharadia & Sons Is A Micro-enterprise Established On June 5, 2020, Engaged In The Manufacturing Of Machinery And Equipment, Specifically Machine Tools For Turning, Drilling, Milling, Shaping, Planning, Boring, And Grinding.
  Actual Product : Pixer 400 Brown 1200mm Ceiling Fan Infinity
  Product Category : Air Or Vacuum Pumps, Air Or Other Gas Compressors And Fans; Ventilating Or Recycling Hoods Incorporating A Fan, Whether Or Not Fitted
  Business Category : Manufacturing
  HS Code Direct : 8414
  BHARADIA & SONS
  
  Address
  Plot No 79, Part And 80 Apparel Park, Gundla Pochampally Village, Medchal Mandal, Hyderabad, Telangana, 500043

select distinct company_name_direct_supplier from gptdirectsupplierhead where 
		(company_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and company_name_direct_supplier!=''[YYYXXX]) 
		or (contact_person_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and company_name_direct_supplier!=''[YYYXXX]) 
		or (actual_product_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and company_name_direct_supplier!=''[YYYXXX]) 
		or (business_category_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and company_name_direct_supplier!=''[YYYXXX]) 
		or (hs_code_4digit_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and company_name_direct_supplier!=''[YYYXXX]) 
		or (country_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and company_name_direct_supplier!=''[YYYXXX]) 
		
		order by company_name_direct_supplier asc limit [XXYYXXYY],5

<span id="spcompanybodysup1"><i class="fa fa-user"></i> <a id="1-0" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'AKTIF ASPIRATOR ELEKTRIKLI MOTOR LTD. STI.',1,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'0')">AKTIF ASPIRATOR ELEKTRIKLI MOTOR LTD. STI.</a><br><i class="fa fa-user"></i> <a id="1-1" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'BAJAJ ELECTRICALS LIMITED',1,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'1')">BAJAJ ELECTRICALS LIMITED</a><br><i class="fa fa-user"></i> <a id="1-2" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'BHARADIA & SONS',1,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'2')">BHARADIA & SONS</a><br><i class="fa fa-user"></i> <a id="1-3" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'DAI HAN PHARM. CO., LTD',1,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'3')">DAI HAN PHARM. CO., LTD</a><br><i class="fa fa-user"></i> <a id="1-4" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Foshan Shunde Yushengjia Electrical Co., Ltd.',1,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'4')">Foshan Shunde Yushengjia Electrical Co., Ltd.</a><br></span><ul class="search-results-pagination" style="margin:0;"><li>
<button class="btn btn-shadowed btn-page btn-page-back" type="button" onClick="funsupsearchsdpagination(0,1,0)"> 
                    <i class="fa fa-chevron-left"></i> 
                    </button>
                     
                    <button class="btn btn-shadowed btn-page btn-page-forward" type="button" onClick="funsupsearchsdpagination(1,1,0)"> 
                    <i class="fa fa-chevron-right"></i> 
                    </button>
                   
</li></ul><input type="hidden" name="txtsupscompanytotpage" id="txtsupscompanytotpage" value="2"><input type="hidden" name="txtsupscompanycurrpage" id="txtsupscompanycurrpage" value="1">

select distinct contact_person_name_direct_supplier from gptdirectsupplierhead where 
		(company_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and contact_person_name_direct_supplier!=''[YYYXXX]) 
		or (contact_person_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and contact_person_name_direct_supplier!=''[YYYXXX]) 
		or (actual_product_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and contact_person_name_direct_supplier!=''[YYYXXX]) 
		or (business_category_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and contact_person_name_direct_supplier!=''[YYYXXX]) 
		or (hs_code_4digit_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and contact_person_name_direct_supplier!=''[YYYXXX]) 
		or (country_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and contact_person_name_direct_supplier!=''[YYYXXX]) 
		
		order by contact_person_name_direct_supplier asc limit [XXYYXXYY],5

<span id="spnamebodysup1"><i class="fa fa-user"></i> <a id="2-0" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Anant Bajaj',2,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'0')">Anant Bajaj</a><br><i class="fa fa-user"></i> <a id="2-1" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Liu Shikun',2,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'1')">Liu Shikun</a><br><i class="fa fa-user"></i> <a id="2-2" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Mr. Adem Çavdar',2,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'2')">Mr. Adem Çavdar</a><br><i class="fa fa-user"></i> <a id="2-3" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Mr. Brian Gong',2,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'3')">Mr. Brian Gong</a><br><i class="fa fa-user"></i> <a id="2-4" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Mr. Manager',2,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'4')">Mr. Manager</a><br></span><ul class="search-results-pagination" style="margin:0;"><li>
<button class="btn btn-shadowed btn-page btn-page-back" type="button" onClick="funsupsearchsdpagination(0,2,0)"> 
                    <i class="fa fa-chevron-left"></i> 
                    </button>
                     
                    <button class="btn btn-shadowed btn-page btn-page-forward" type="button" onClick="funsupsearchsdpagination(1,2,0)"> 
                    <i class="fa fa-chevron-right"></i> 
                    </button>
                   
</li></ul><input type="hidden" name="txtsupsnametotpage" id="txtsupsnametotpage" value="2"><input type="hidden" name="txtsupsnamecurrpage" id="txtsupsnamecurrpage" value="1">

select distinct designation_direct_supplier from gptdirectsupplierhead where 
		(company_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and designation_direct_supplier!=''[YYYXXX]) 
		or (contact_person_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and designation_direct_supplier!=''[YYYXXX]) 
		or (actual_product_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and designation_direct_supplier!=''[YYYXXX]) 
		or (business_category_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and designation_direct_supplier!=''[YYYXXX]) 
		or (hs_code_4digit_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and designation_direct_supplier!=''[YYYXXX]) 
		or (country_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and designation_direct_supplier!=''[YYYXXX]) 
		
		order by designation_direct_supplier asc limit [XXYYXXYY],5

<span id="spdestinationbodysup1"><i class="fa fa-user"></i> <a id="3-0" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Business Manager',3,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'0')">Business Manager (1)</a><br><i class="fa fa-user"></i> <a id="3-1" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'CEO',3,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'1')">CEO (2)</a><br><i class="fa fa-user"></i> <a id="3-2" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Legal Representative, Executive Director & Manager',3,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'2')">Legal Representative, Executive Director & Manager (1)</a><br><i class="fa fa-user"></i> <a id="3-3" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Managing Director',3,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'3')">Managing Director (2)</a><br><i class="fa fa-user"></i> <a id="3-4" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Sales Manager',3,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'4')">Sales Manager (1)</a><br></span><ul class="search-results-pagination" style="margin:0;"><li>
<button class="btn btn-shadowed btn-page btn-page-back" type="button" onClick="funsupsearchsdpagination(0,3,0)"> 
                    <i class="fa fa-chevron-left"></i> 
                    </button>
                     
                    <button class="btn btn-shadowed btn-page btn-page-forward" type="button" onClick="funsupsearchsdpagination(1,3,0)"> 
                    <i class="fa fa-chevron-right"></i> 
                    </button>
                   
</li></ul><input type="hidden" name="txtsupsdestinationtotpage" id="txtsupsdestinationtotpage" value="2"><input type="hidden" name="txtsupsdestinationcurrpage" id="txtsupsdestinationcurrpage" value="1">

select distinct country_name_direct_supplier from gptdirectsupplierhead where 
		(company_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and country_name_direct_supplier!=''[YYYXXX]) 
		or (contact_person_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and country_name_direct_supplier!=''[YYYXXX]) 
		or (actual_product_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and country_name_direct_supplier!=''[YYYXXX]) 
		or (business_category_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and country_name_direct_supplier!=''[YYYXXX]) 
		or (hs_code_4digit_description_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and country_name_direct_supplier!=''[YYYXXX]) 
		or (country_name_direct_supplier like '%ceiling%fan%' and email_id_direct_supplier_status not in('invalid','unknown')  and country_name_direct_supplier!=''[YYYXXX]) 
		
		order by country_name_direct_supplier asc limit [XXYYXXYY],5

<span id="spcountrybodysup1"><i class="fa fa-user"></i> <a id="4-0" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'China',4,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'0')">China (5)</a><br><i class="fa fa-user"></i> <a id="4-1" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'India',4,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'1')">India (2)</a><br><i class="fa fa-user"></i> <a id="4-2" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'South Korea',4,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'2')">South Korea (1)</a><br><i class="fa fa-user"></i> <a id="4-3" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Turkey',4,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'3')">Turkey (1)</a><br><i class="fa fa-user"></i> <a id="4-4" href="javascript:void(0)" onClick="funsupcustomsearch(11893,'Vietnam',4,0,'no','<br><br><h2>Message</h2><br><br><h3><b>Grap Direct Supplier Get Contact</b> Daily Limit Exceeded.</h3>','ceiling fan',1,'4')">Vietnam (1)</a><br></span><input type="hidden" name="txtsupscountrytotpage" id="txtsupscountrytotpage" value="1"><input type="hidden" name="txtsupscountrycurrpage" id="txtsupscountrycurrpage" value="1">

Address

Address

Address

Address

Address

Address

Address

Address

Address

Address

CREATE ACCOUNT

LOGIN

Forget Password

Create Contact List

Create Contact List

Address

Address

Address

Address

Address

Address

Address

Address

Address

Address