IDI Salon Equipment
IDI Salon Equipment LogoSalon Design and Day Spa DesignCustom Water FountainsInfrared Saunas for Day Spas

The most complete source for salon equipment and spa equipment and furniture on the Internet.

Salon Furniture
» Reception Desks
» Reception Seating
» Retail Displays
» Styling Chairs
» Styling Stations
» Styling Mirrors
» All Purpose Chairs
» Rollabouts/Portable Stations
» Roller Carts/Color Trays
» Salon Floor Mats
» Dryer Chairs
» Hair Dryers
» Hair Processors/Hair Steamers/Heat Lamps
» Manicure Tables
» Stools
» Shampoo Chairs
» Shampoo Cabinets
» Shampoo Bowls
» Shampoo Backwash Units
» Pedicure Spas
» Barber Chairs
» Salon Lockers
» Wet Stations
» Dispensary/Color Centers
» Makeup Chairs
» Makeup Stools
» Kids Korner
» Clearance Center
Spa Equipment
» Roller Carts/Color Trays
» Facial Steamers
» Facial Machines
» Facial Beds
» Spa Tables
» Massage Tables
» Massage Chairs
» Hot Towel Cabinets/Sterilizers
» Massage Stones
» Retreat/Lounge Seating
» Pedicure Spas
» Hydrocollator
» Waxing/Paraffin
» Microdermabrasion
» Treatment Room Cabinetry
» Wet Tables
» Vichy Showers
» Vichy Shower/Table Combo
» Swiss Shower
» Spa Capsules
» Hydrotherapy Tubs
» Infrared Saunas
» Steam Showers
» Spray Tanning Equipment
» Clearance Center
Water Fountains
» Floor Fountains
» Wall Accents
» Wall Fountains
Medical Spa Equipment
Saunas
» Infrared Saunas
SELECT * FROM p_to_c a, products b WHERE a.cgid = 384 AND a.active = 1 AND a.pid = b.products_id AND b.products_active = 1
Array
(
    [0] => 671
    [1] => 671
    [2] => 671
    [3] => 671
    [4] => 671
    [5] => 671
    [6] => 671
    [7] => 324
    [8] => 324
    [9] => 319
    [10] => 319
    [11] => 319
    [12] => 319
    [13] => 319
    [14] => 319
    [15] => 319
    [16] => 319
    [17] => 319
    [18] => 319
    [19] => 319
    [20] => 319
    [21] => 319
    [22] => 319
    [23] => 319
    [24] => 319
    [25] => 319
    [26] => 319
    [27] => 319
    [28] => 319
    [29] => 316
    [30] => 316
    [31] => 316
    [32] => 316
    [33] => 316
    [34] => 316
    [35] => 316
    [36] => 316
    [37] => 316
    [38] => 316
    [39] => 316
    [40] => 316
    [41] => 316
    [42] => 316
    [43] => 316
    [44] => 316
    [45] => 316
    [46] => 316
    [47] => 316
    [48] => 317
    [49] => 317
    [50] => 317
    [51] => 317
    [52] => 317
    [53] => 317
    [54] => 317
    [55] => 317
    [56] => 317
    [57] => 317
    [58] => 317
    [59] => 317
    [60] => 317
    [61] => 317
    [62] => 317
    [63] => 317
    [64] => 317
    [65] => 317
    [66] => 317
    [67] => 317
    [68] => 317
    [69] => 317
    [70] => 317
    [71] => 317
    [72] => 317
    [73] => 317
    [74] => 317
    [75] => 317
    [76] => 317
    [77] => 318
    [78] => 318
    [79] => 318
    [80] => 318
    [81] => 318
    [82] => 318
    [83] => 318
    [84] => 318
    [85] => 318
    [86] => 318
    [87] => 325
    [88] => 325
    [89] => 325
    [90] => 325
    [91] => 325
    [92] => 325
    [93] => 325
    [94] => 325
    [95] => 325
    [96] => 325
    [97] => 325
    [98] => 325
    [99] => 325
    [100] => 325
    [101] => 325
    [102] => 325
    [103] => 325
    [104] => 325
    [105] => 325
    [106] => 326
    [107] => 326
    [108] => 326
    [109] => 326
    [110] => 326
    [111] => 326
    [112] => 326
    [113] => 326
    [114] => 328
    [115] => 328
    [116] => 328
    [117] => 328
    [118] => 328
    [119] => 328
    [120] => 328
    [121] => 328
    [122] => 328
    [123] => 328
    [124] => 328
    [125] => 328
    [126] => 328
    [127] => 328
    [128] => 328
    [129] => 328
    [130] => 328
    [131] => 328
    [132] => 328
    [133] => 329
    [134] => 329
    [135] => 329
    [136] => 329
    [137] => 329
    [138] => 329
    [139] => 329
    [140] => 329
    [141] => 329
    [142] => 329
    [143] => 329
    [144] => 329
    [145] => 329
    [146] => 329
    [147] => 329
    [148] => 329
    [149] => 329
    [150] => 329
    [151] => 329
    [152] => 329
    [153] => 331
    [154] => 331
    [155] => 331
    [156] => 331
    [157] => 331
    [158] => 331
    [159] => 331
    [160] => 331
    [161] => 331
    [162] => 331
    [163] => 331
    [164] => 331
    [165] => 331
    [166] => 331
    [167] => 336
    [168] => 336
    [169] => 336
    [170] => 336
    [171] => 336
    [172] => 336
    [173] => 336
    [174] => 336
    [175] => 336
    [176] => 337
    [177] => 337
    [178] => 337
    [179] => 337
    [180] => 337
    [181] => 337
    [182] => 338
    [183] => 338
    [184] => 739
    [185] => 739
    [186] => 739
    [187] => 739
    [188] => 739
    [189] => 739
    [190] => 739
    [191] => 739
    [192] => 739
    [193] => 739
    [194] => 739
    [195] => 739
    [196] => 739
    [197] => 739
    [198] => 739
    [199] => 341
    [200] => 341
    [201] => 343
    [202] => 343
    [203] => 343
    [204] => 343
    [205] => 343
    [206] => 343
    [207] => 343
    [208] => 347
    [209] => 347
    [210] => 347
    [211] => 347
    [212] => 407
    [213] => 407
    [214] => 407
    [215] => 407
    [216] => 407
    [217] => 407
    [218] => 407
    [219] => 512
    [220] => 512
    [221] => 512
    [222] => 512
    [223] => 512
    [224] => 512
    [225] => 403
    [226] => 403
    [227] => 403
    [228] => 403
    [229] => 403
    [230] => 403
    [231] => 403
    [232] => 394
    [233] => 394
    [234] => 394
    [235] => 394
    [236] => 394
    [237] => 394
    [238] => 394
    [239] => 392
    [240] => 392
    [241] => 392
    [242] => 392
    [243] => 392
    [244] => 392
    [245] => 392
    [246] => 392
    [247] => 392
    [248] => 392
    [249] => 392
    [250] => 392
    [251] => 392
    [252] => 392
    [253] => 393
    [254] => 391
    [255] => 391
    [256] => 391
    [257] => 391
    [258] => 391
    [259] => 391
    [260] => 382
    [261] => 382
    [262] => 382
    [263] => 382
    [264] => 382
    [265] => 382
    [266] => 382
    [267] => 382
    [268] => 382
    [269] => 382
    [270] => 382
    [271] => 382
    [272] => 382
    [273] => 383
    [274] => 383
    [275] => 383
    [276] => 383
    [277] => 383
    [278] => 383
    [279] => 383
    [280] => 383
    [281] => 383
    [282] => 383
    [283] => 383
    [284] => 383
    [285] => 383
    [286] => 383
    [287] => 383
    [288] => 384
    [289] => 384
    [290] => 384
    [291] => 384
    [292] => 384
    [293] => 384
    [294] => 384
    [295] => 384
    [296] => 384
    [297] => 384
    [298] => 384
    [299] => 384
    [300] => 385
    [301] => 385
    [302] => 385
    [303] => 385
    [304] => 385
    [305] => 385
    [306] => 386
    [307] => 386
    [308] => 386
    [309] => 386
    [310] => 386
    [311] => 386
    [312] => 386
    [313] => 386
    [314] => 386
    [315] => 386
    [316] => 387
    [317] => 388
    [318] => 388
    [319] => 388
    [320] => 388
    [321] => 388
    [322] => 388
    [323] => 388
    [324] => 388
    [325] => 388
    [326] => 388
    [327] => 388
    [328] => 388
    [329] => 389
    [330] => 389
    [331] => 389
    [332] => 389
    [333] => 389
    [334] => 389
    [335] => 389
    [336] => 389
    [337] => 389
    [338] => 389
    [339] => 389
    [340] => 389
    [341] => 389
    [342] => 389
    [343] => 389
    [344] => 389
    [345] => 389
    [346] => 389
    [347] => 389
    [348] => 389
    [349] => 389
    [350] => 389
    [351] => 389
    [352] => 389
    [353] => 389
    [354] => 389
    [355] => 389
    [356] => 389
    [357] => 389
    [358] => 389
    [359] => 389
    [360] => 389
    [361] => 389
    [362] => 389
    [363] => 389
    [364] => 389
    [365] => 389
    [366] => 389
    [367] => 389
    [368] => 389
    [369] => 389
    [370] => 389
    [371] => 408
    [372] => 408
    [373] => 408
    [374] => 408
    [375] => 408
    [376] => 408
    [377] => 408
    [378] => 408
    [379] => 408
    [380] => 409
    [381] => 409
    [382] => 411
    [383] => 411
    [384] => 411
    [385] => 411
    [386] => 411
    [387] => 411
    [388] => 411
    [389] => 411
    [390] => 411
    [391] => 411
    [392] => 411
    [393] => 411
    [394] => 411
    [395] => 411
    [396] => 411
    [397] => 411
    [398] => 411
    [399] => 411
    [400] => 411
    [401] => 411
    [402] => 411
    [403] => 411
    [404] => 411
    [405] => 411
    [406] => 411
    [407] => 411
    [408] => 411
    [409] => 411
    [410] => 411
    [411] => 411
    [412] => 411
    [413] => 411
    [414] => 411
    [415] => 411
    [416] => 411
    [417] => 411
    [418] => 411
    [419] => 411
    [420] => 411
    [421] => 411
    [422] => 411
    [423] => 411
    [424] => 411
    [425] => 412
    [426] => 412
    [427] => 412
    [428] => 412
    [429] => 412
    [430] => 412
    [431] => 412
    [432] => 748
    [433] => 748
    [434] => 748
    [435] => 748
    [436] => 748
    [437] => 748
    [438] => 748
    [439] => 748
    [440] => 748
    [441] => 748
    [442] => 748
    [443] => 748
    [444] => 748
    [445] => 748
    [446] => 748
    [447] => 748
    [448] => 748
    [449] => 748
    [450] => 748
    [451] => 748
    [452] => 748
    [453] => 748
    [454] => 748
    [455] => 748
    [456] => 748
    [457] => 748
    [458] => 748
    [459] => 748
    [460] => 748
    [461] => 748
    [462] => 748
    [463] => 748
    [464] => 748
    [465] => 748
    [466] => 748
    [467] => 748
    [468] => 417
    [469] => 417
    [470] => 417
    [471] => 417
    [472] => 417
    [473] => 417
    [474] => 417
    [475] => 417
    [476] => 692
    [477] => 621
    [478] => 621
    [479] => 621
    [480] => 621
    [481] => 621
    [482] => 621
    [483] => 621
    [484] => 621
    [485] => 621
    [486] => 621
    [487] => 621
    [488] => 621
    [489] => 756
    [490] => 756
    [491] => 756
    [492] => 756
    [493] => 756
    [494] => 756
    [495] => 756
    [496] => 756
    [497] => 756
    [498] => 756
    [499] => 756
    [500] => 756
    [501] => 756
    [502] => 756
    [503] => 756
    [504] => 695
    [505] => 694
    [506] => 694
    [507] => 694
    [508] => 694
    [509] => 697
    [510] => 429
    [511] => 429
    [512] => 731
    [513] => 731
    [514] => 731
    [515] => 719
    [516] => 719
    [517] => 719
    [518] => 719
    [519] => 719
    [520] => 719
    [521] => 719
    [522] => 719
    [523] => 719
    [524] => 719
    [525] => 719
    [526] => 717
    [527] => 717
    [528] => 717
    [529] => 717
    [530] => 717
    [531] => 717
    [532] => 717
    [533] => 712
    [534] => 712
    [535] => 712
    [536] => 712
    [537] => 712
    [538] => 712
    [539] => 712
    [540] => 712
    [541] => 712
    [542] => 712
    [543] => 712
    [544] => 712
    [545] => 712
    [546] => 714
    [547] => 714
    [548] => 714
    [549] => 714
    [550] => 714
    [551] => 714
    [552] => 714
    [553] => 714
    [554] => 714
    [555] => 714
    [556] => 714
    [557] => 714
    [558] => 714
    [559] => 714
    [560] => 714
    [561] => 714
    [562] => 714
    [563] => 714
    [564] => 714
    [565] => 714
    [566] => 555
    [567] => 555
    [568] => 555
    [569] => 555
    [570] => 555
    [571] => 555
    [572] => 555
    [573] => 710
    [574] => 710
    [575] => 710
    [576] => 710
    [577] => 710
    [578] => 710
    [579] => 710
    [580] => 710
    [581] => 710
    [582] => 710
    [583] => 710
    [584] => 710
    [585] => 710
    [586] => 552
    [587] => 552
    [588] => 552
    [589] => 552
    [590] => 552
    [591] => 552
    [592] => 552
    [593] => 552
    [594] => 552
    [595] => 552
    [596] => 552
    [597] => 552
    [598] => 552
    [599] => 552
    [600] => 552
    [601] => 552
    [602] => 612
    [603] => 612
    [604] => 612
    [605] => 637
    [606] => 637
    [607] => 637
    [608] => 637
    [609] => 637
    [610] => 637
    [611] => 637
    [612] => 637
    [613] => 637
    [614] => 637
    [615] => 637
    [616] => 637
    [617] => 637
    [618] => 637
    [619] => 637
    [620] => 637
    [621] => 637
    [622] => 637
    [623] => 637
    [624] => 637
    [625] => 637
    [626] => 637
    [627] => 637
    [628] => 637
    [629] => 637
    [630] => 637
    [631] => 637
    [632] => 637
    [633] => 637
    [634] => 637
    [635] => 637
    [636] => 637
    [637] => 637
    [638] => 637
    [639] => 637
    [640] => 637
    [641] => 637
    [642] => 637
    [643] => 638
    [644] => 638
    [645] => 638
    [646] => 638
    [647] => 638
    [648] => 638
    [649] => 638
    [650] => 638
    [651] => 638
    [652] => 638
    [653] => 638
    [654] => 638
    [655] => 638
    [656] => 638
    [657] => 638
    [658] => 638
    [659] => 638
    [660] => 638
    [661] => 638
    [662] => 638
    [663] => 638
    [664] => 638
    [665] => 638
    [666] => 638
    [667] => 638
    [668] => 638
    [669] => 639
    [670] => 639
    [671] => 639
    [672] => 639
    [673] => 639
    [674] => 639
    [675] => 639
    [676] => 639
    [677] => 639
    [678] => 639
    [679] => 639
    [680] => 639
    [681] => 639
    [682] => 639
    [683] => 639
    [684] => 639
    [685] => 639
    [686] => 639
    [687] => 639
    [688] => 645
    [689] => 645
    [690] => 645
    [691] => 645
    [692] => 645
    [693] => 645
    [694] => 645
    [695] => 646
    [696] => 646
    [697] => 646
    [698] => 646
    [699] => 646
    [700] => 646
    [701] => 646
    [702] => 647
    [703] => 647
    [704] => 647
    [705] => 662
    [706] => 681
    [707] => 681
    [708] => 681
    [709] => 681
    [710] => 681
    [711] => 681
    [712] => 682
    [713] => 682
    [714] => 682
    [715] => 682
    [716] => 682
    [717] => 682
    [718] => 682
    [719] => 682
    [720] => 682
    [721] => 682
    [722] => 682
    [723] => 682
    [724] => 682
    [725] => 682
    [726] => 711
    [727] => 711
    [728] => 711
    [729] => 711
    [730] => 711
    [731] => 711
    [732] => 711
    [733] => 669
    [734] => 669
    [735] => 669
    [736] => 669
    [737] => 669
    [738] => 669
    [739] => 669
    [740] => 667
    [741] => 667
    [742] => 667
    [743] => 667
    [744] => 667
    [745] => 667
    [746] => 667
    [747] => 667
    [748] => 667
    [749] => 668
    [750] => 668
    [751] => 668
    [752] => 668
    [753] => 668
    [754] => 668
    [755] => 668
    [756] => 668
    [757] => 668
    [758] => 668
    [759] => 668
    [760] => 668
    [761] => 668
    [762] => 668
    [763] => 668
    [764] => 668
    [765] => 668
    [766] => 668
    [767] => 668
    [768] => 668
    [769] => 668
    [770] => 668
    [771] => 668
    [772] => 668
    [773] => 668
    [774] => 668
    [775] => 670
    [776] => 670
    [777] => 670
    [778] => 670
    [779] => 672
    [780] => 672
    [781] => 672
    [782] => 672
    [783] => 672
    [784] => 672
    [785] => 672
    [786] => 672
    [787] => 672
    [788] => 672
    [789] => 672
    [790] => 672
    [791] => 672
    [792] => 672
    [793] => 672
    [794] => 673
    [795] => 673
    [796] => 673
    [797] => 673
    [798] => 673
    [799] => 673
    [800] => 673
    [801] => 673
    [802] => 673
    [803] => 673
    [804] => 673
    [805] => 673
    [806] => 673
    [807] => 673
    [808] => 673
    [809] => 673
    [810] => 673
    [811] => 673
    [812] => 673
    [813] => 673
    [814] => 673
    [815] => 673
    [816] => 673
    [817] => 673
    [818] => 673
    [819] => 673
    [820] => 674
    [821] => 674
    [822] => 674
    [823] => 674
    [824] => 674
    [825] => 674
    [826] => 674
    [827] => 674
    [828] => 674
    [829] => 674
    [830] => 674
    [831] => 674
    [832] => 674
    [833] => 674
    [834] => 674
    [835] => 675
    [836] => 675
    [837] => 675
    [838] => 675
    [839] => 675
    [840] => 675
    [841] => 675
    [842] => 675
    [843] => 675
    [844] => 675
    [845] => 675
    [846] => 675
    [847] => 675
    [848] => 675
    [849] => 676
    [850] => 676
    [851] => 676
    [852] => 676
    [853] => 676
    [854] => 676
    [855] => 676
    [856] => 676
    [857] => 677
    [858] => 677
    [859] => 677
    [860] => 677
    [861] => 677
    [862] => 677
    [863] => 677
    [864] => 677
    [865] => 677
    [866] => 677
    [867] => 677
    [868] => 679
    [869] => 679
    [870] => 679
    [871] => 679
    [872] => 679
    [873] => 679
    [874] => 679
    [875] => 679
    [876] => 679
    [877] => 679
    [878] => 679
    [879] => 679
    [880] => 679
    [881] => 679
    [882] => 679
    [883] => 679
    [884] => 679
    [885] => 679
    [886] => 679
    [887] => 679
    [888] => 679
    [889] => 679
    [890] => 679
    [891] => 679
    [892] => 679
    [893] => 679
    [894] => 679
    [895] => 679
    [896] => 679
    [897] => 679
    [898] => 679
    [899] => 679
    [900] => 679
    [901] => 679
    [902] => 679
    [903] => 679
    [904] => 679
    [905] => 679
    [906] => 679
    [907] => 679
    [908] => 680
    [909] => 680
    [910] => 680
    [911] => 680
    [912] => 680
    [913] => 680
    [914] => 680
    [915] => 680
    [916] => 680
    [917] => 680
    [918] => 680
    [919] => 680
    [920] => 680
    [921] => 680
    [922] => 680
    [923] => 680
    [924] => 680
    [925] => 680
    [926] => 688
    [927] => 688
    [928] => 688
    [929] => 688
    [930] => 688
    [931] => 688
    [932] => 688
    [933] => 689
    [934] => 689
    [935] => 689
    [936] => 689
    [937] => 689
    [938] => 689
    [939] => 689
    [940] => 689
    [941] => 689
    [942] => 689
    [943] => 689
    [944] => 689
    [945] => 689
    [946] => 689
    [947] => 689
    [948] => 689
    [949] => 708
    [950] => 708
    [951] => 708
    [952] => 708
    [953] => 708
    [954] => 708
    [955] => 708
    [956] => 708
    [957] => 708
    [958] => 708
    [959] => 708
    [960] => 708
    [961] => 708
    [962] => 708
    [963] => 708
    [964] => 708
    [965] => 708
    [966] => 708
    [967] => 708
    [968] => 708
    [969] => 708
    [970] => 708
    [971] => 708
    [972] => 708
    [973] => 708
    [974] => 708
    [975] => 708
    [976] => 708
    [977] => 708
    [978] => 708
    [979] => 738
    [980] => 738
    [981] => 738
    [982] => 738
    [983] => 738
    [984] => 738
    [985] => 738
    [986] => 738
    [987] => 738
    [988] => 738
    [989] => 738
    [990] => 738
    [991] => 738
    [992] => 738
    [993] => 738
    [994] => 738
    [995] => 752
    [996] => 752
    [997] => 752
    [998] => 752
    [999] => 752
    [1000] => 752
    [1001] => 752
    [1002] => 752
    [1003] => 752
    [1004] => 752
    [1005] => 752
)

 

 

Click for salon and spa design services Click to view salon equipment and furniture Click for salon and spa design services Click to view salon equipment and furniture Click to view our large selection of waterfalls Click to view our large selection of waterfalls Click to view dayspa equipment Click to view dayspa equipment Click for salon and spa design services Click to view saunas Click to view pedicure chairs Click to view our large selection of waterfalls Click to view saunas Click to view tanning beds Click to view medical spa equipment Click to view medical spa equipment Pedicure Chairs Salon Equipment, Salon Furniture