MYSQL ERROR : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND dealCategoryStatus='Active' AND deal.dealStatus='Active' ORDER BY ' at line 17
Query : SELECT dealToCat.dealID,deal.dealFabricImage FROM dp_deals AS deal INNER JOIN dp_deal_to_category AS dealToCat ON ( dealToCat.dealID = deal.dealID ) INNER JOIN dp_deal_categories AS dealCat ON ( dealCat.dealCategoryID = dealToCat.dealCategoryID ) WHERE dealToCat.dealCategoryID IN (SELECT dealCategoryID FROM dp_deal_categories WHERE dealCategoryParent!='0') AND dealToCat.dealCategoryID= AND dealCategoryStatus='Active' AND deal.dealStatus='Active' ORDER BY dealToCat.sortOrder ASC

Neon Green Lycra Cotton Mens Shirt - STD 39 - Short Sleeve
Size Chest Sleeve
38 21.25 24.5
39 21.75 25
40 22.25 25
41 22.75 25.5
42 23.25 25.5
44 24.75 26
46 25.75 26
48 27.5 26.5
50 29 27
52 31 27
54 33 27
More Information
Size Chest Sleeve
38 20 25
39 20.5 25.5
40 21 25.5
42 22 26
44 23 26
46 24.25 26
More Information
Size Chest Sleeve
38 18.5 25.5
39 19 26.5
40 19.5 26.5
42 20.5 26.5
More Information

Neon Green Lycra Cotton Mens Shirt - STD 39 - Short Sleeve

Rs 999
Rs 1899
Previous Next
Know the Gaps
Know the Gaps

Choose Your Size
Please Choose Your Size
Fit Guide
|   Confused?

Call Our Size Expert Now

+91-98459-43123

(9.00am to 7.00pm)

Sleeve *
Check
Quantity
-
+
Free ShippingEasy Returns

what you need to know

Made from cool, lightweight cotton, these shirts stay breathable in warmer weather But there's something to be said for that pair of comfy shirts you can laze around in on a Sunday, or wear on a long flight without feeling constricted with just a bit of comfortable stretch.
100% Cotton Lycra
Standard Fit - Not too baggy and not too slim. Meant for guys with larger arms and larger waists. Slim Fit - About an inch narrower than standard fit through the chest and 2 inches through the waist. Meant for guys with slim bodies. Extra Slim - About an inch narrower than slim fit through the chest and half an inch through the waist meant for those lean guys who like body hugging shirts.
Single button Cuffs in Full Sleeves
Button Down Collar
Mother of Pearl buttons

Testimonials

  • Good For Board Meeting

    Superb Shirt!!! Got one, good for board meeting and under the suit on special occasions.
    - Rajiah Pande -
    Tirunelveli
  • Awesome Collection & Service

    Lovely collection! Awesome service! Highly impressed with my purchase. Thank you so much!!!
    - Sneha Godase -
    Pune
  • Tops the chart with the top brands

    Product is very good, quality is outstanding and tops the chart with the top brands like LP, CK etc. They need to improve on their packaging a bit
    - Bharath Kumar -
    Chennai
  • Amazing service

    Amazing service. I will order more soon. Also will refer to most of my friends
    - Akashdeep Agarwal -
    Delhi
  • Better than Lacoste

    I wear Lacoste Shirts and I must say KAAPUS quality is better than them. The stitch and fabric quality is awesome.
    - Kirit Patil -
    Nandurbar