- Quick Links
- Shop
- About Us
Welcome to Unlimited Beauty Care!
UNLIMITED BEAUTY CARE INC, is a company headquartered in the City of Vernon, California. With more than 20 years experience in the business. We have envisioned fashion hair accessories, jewelry, cosmetics, winter items and general merchandise where you will always find a new concept in accessories, innovation and tendencies.
We understand the importance of having excellent business relationship in order to be successful; and for that reason we are devoted to your success by giving you the largest selection of new products, variety of choices to chose from. We handle a volume of first-cost customers and retail customers with the lowest prices in the industry.
Unlimited Beauty Care, is known for its extensive selections of fashions and designs for babies, girls, ladies and also involves directly the care of your beauty. Our compromised to give you excellence in the service, We offer you quality, reasonable prices because we are completely sure that once you try our product your concept of beauty will be unlimited. - Service
Shop with Confidence
When you shop with us you can shop with confidence feeling certain your purchases and information are safe and your privacy respected.
Shipping
Unlimited Beauty Care will ship products anywhere in the United States including Alaska and Hawaii by using FedEx or USPS. We reserve the right not to ship to a location. Please Click Here for more details.
- Info
General Info
Useful Links
- Connect
-
$show_manufacturers= true;
// for large lists of manufacturers uncomment this section
/*
if (($_GET['main_page']==FILENAME_DEFAULT and ($_GET['cPath'] == '' or $_GET['cPath'] == 0)) or ($request_type == 'SSL')) {
$show_manufacturers= false;
} else {
$show_manufacturers= true;
}
*/
// Set to true to display manufacturers images in place of names
define('DISPLAY_MANUFACTURERS_IMAGES',false);
if ($show_manufacturers) {
// only check products if requested - this may slow down the processing of the manufacturers sidebox
if (PRODUCTS_MANUFACTURERS_STATUS == '1') {
$manufacturer_sidebox_query = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image
from " . TABLE_MANUFACTURERS . " m
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id
where m.manufacturers_id = p.manufacturers_id and p.products_status= 1
order by manufacturers_name";
} else {
$manufacturer_sidebox_query = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image
from " . TABLE_MANUFACTURERS . " m
order by manufacturers_name";
}
$manufacturer_sidebox = $db->Execute($manufacturer_sidebox_query);
if ($manufacturer_sidebox->RecordCount()>0) {
$number_of_rows = $manufacturer_sidebox->RecordCount()+1;
// Display a list
$manufacturer_sidebox_array = array();
// kuroi: commented out to avoid starting list with text scrolling list entries such as "reset" and "please select"
// if (!isset($_GET['manufacturers_id']) || $_GET['manufacturers_id'] == '' ) {
// $manufacturer_sidebox_array[] = array('id' => '', 'text' => PULL_DOWN_ALL);
// } else {
// $manufacturer_sidebox_array[] = array('id' => '', 'text' => PULL_DOWN_MANUFACTURERS);
// }
while (!$manufacturer_sidebox->EOF) {
$manufacturer_sidebox_name = ((strlen($manufacturer_sidebox->fields['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($manufacturer_sidebox->fields['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $manufacturer_sidebox->fields['manufacturers_name']);
$manufacturer_sidebox_image = $manufacturer_sidebox->fields['manufacturers_image'];
$manufacturer_sidebox_array[] =
array('id' => $manufacturer_sidebox->fields['manufacturers_id'],
'text' => DISPLAY_MANUFACTURERS_IMAGES ?
zen_image(DIR_WS_IMAGES . $manufacturer_sidebox_image, $manufacturer_sidebox_name) :
$manufacturer_sidebox_name);
$manufacturer_sidebox->MoveNext();
}
}
} // $show_manufacturers
for ($i=0;$i
Categories |
Home ::
Fashion Jewelry ::
Bracelets ::
CRYSTAL BRACELET VIRGEN GUADALUPE METAL SILVER ASSORTED COLORS
|
-
- Contact Information
- 323.582.0888
- Email Us
- Useful Links
- My Account
- Site Map
- Privacy Notice
- Shared
- Action DVDs


