SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, xcart_variants.avail as avail, xcart_variants.weight as weight, xcart_variants.productcode as productcode FROM xcart_products INNER JOIN xcart_featured_products ON xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.avail = 'Y' INNER JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND ( xcart_variants.avail > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, xcart_variants.avail as avail, xcart_variants.weight as weight, xcart_variants.productcode as productcode FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.avail = 'Y' INNER JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_products_categories.categoryid='5048' AND ( xcart_variants.avail > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY RAND()
Luxury Men Shoes, Women's shoes & accessories | Dellamoda.com
The website uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Click to learn more. 
    
Login or Register | (0)
?Help
  • Toll Free : 800-515-8523
  • International Calls : 310-622-4490
  • Contact Us
USD ($)

 

 

 

Perfect Gifts Trending Now!

MEZLAN
$325.00
$325.00
Available Sizes
  • 7.5
  • 8.0
  • 8.5
  • 9.0
  • 9.5
  • 10
  • 10.5
  • 11.0
  • 12
MEZLAN
$295.00
$197.00
Available Sizes
  • 9.0

Bacco Bucci
$235.00
$117.00
Available Sizes
  • 6.5
  • 7.0
  • 7.5
  • 8.0
  • 8.5
  • 9.0
  • 9.5
  • 10
  • 10.5
  • 11.0
  • 12
MEZLAN
$375.00
$251.00
Available Sizes
  • 7.0
  • 7.5
  • 8.0
  • 8.5

MEZLAN
$375.00
$225.00
Available Sizes
  • 7.0
  • 7.5
  • 8.0
  • 8.5
  • 9.0
  • 9.5
  • 10
  • 10.5
  • 11.0
  • 12

Welcome to Dellamoda. We are a luxury boutique serving our clients since 1996. We offer a unique collection of luxury Italian men's shoes, women's shoes and accessories from top Italian and European brands. We also carry a wonderful collection of exotic skin shoes as well as rare and hard to find designer collector products backed by personal service & 100% satisfaction guaranteed policy. We look forward to serving you.