info@simamehta.net

LOGIN /SIGN-UP ⁰

Home
WOMEN
MEN
- DENIM
  
  OPTION1
  
  ETHINIC
  
  FORMAL
  
  SUITS
  
  SHIRT
  
  T-SHIRTS
JEWELLERY
Kids Wear
- GIRL
  
  JEWELLERY
  
  BOY
Customized
- INDIAN DRESSES
  
  INDIAN SAREES
  
  WESTERN
  
  DRESSES
  
  LONG
  
  SHORT
  
  SKIRTS
  
  TOP
  
  PLAZO
  
  BOTTOM
  
  MEN
  
  FROCK
  
  JEWELLERY

3

Filters

Size
- S
- M
- L
- XL
- Free Size

Price Range
- Rs.0 to Rs.499
- Rs.500 to Rs.999
- Rs.1000 to Rs.3000
- Rs.3000+

Color
- WHITE
- GREEN
- SILVER
- MAROON
- CREAM
- PASTELS
- BLACK
- YELLOW
- BEIGE
- TURQUOISE BLUE
- REYON
- PRINTED
- RED
- ORANGE
- GOLDEN
- KHAKHI
- MULTICOLOR
- NUDE
- BLUE
- GREY
- PINK
- PURPLE
- BROWN
- NEON
- Test

SELECT * FROM product a , product_image b , available_prod_size c WHERE a.id = b.product_id and a.id = c.prod_id AND AND b.act = '1' AND a.act = '1' AND b.front = '1'