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

Pacific Blue Overdyed Shirt - STD 39
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

Pacific Blue Overdyed Shirt - STD 39

Rs 999
Rs 1999
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)

Check
Quantity
-
+
Free ShippingEasy Returns

what you need to know

At the intersection of rugged and refined we find these Overdyed shirts both Stylish & Sturdy. Work and play alike.
100% Cotton Poplin Overdyed
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 buttoned cuffs
Button Down Collar
Mother of Pearl buttons

Testimonials

  • Very good wrinkle free shirt

    Very good base fabric and the wrinkle free finish is superb. Crafted carefully. Feeling much satisfied to wear. Really a nice shirt for professional people.
    - Rajiah P -
    Tirunilveli
  • Insanely Impressed

    Highly appreciated. I once again stand by my words that the service I received from you was truly exceptional. I'm still insanely impressed by your company
    - Robin Vijeshwar -
    Delhi
  • Great Fit

    Lovely Collection and Great Fit
    - Anil Shrivastav -
    Noida
  • Good For Board Meeting

    Superb Shirt!!! Got one, good for board meeting and under the suit on special occasions.
    - Rajiah Pande -
    Tirunelveli
  • Delighted with the recent purchase

    I am delighted with the recent purchase made with Kaapus. Will definitely buy next time.
    - Unleash Zorawar -
    Jammu and Kashmir