HAiCOM Hi-407BT GPS Receiver for Centro

	- Bluetooth Headsets
	- Speakerphones
	- Stereo Headphones
	- Stereo Speakers
	- Car Kits (Easy Install)
	- Car Kits (Integrated)
	- GPS
	- USB Adapters

Car Kits

Cases

Chargers & Cables

Centro Depot
is part of
Smartphone Experts

Shop with Confidence

Over 900,000 orders shipped to-date

Expert advice available weekdays 8am - 5.30pm ET at (866) 357-2146

VeriSign SGC Encryption

HackerSafe audited servers

Click to verify BBB accreditation and to see a BBB report.

Save BIG with
Open Box deals!

Visit our Outlet Store
SmartphoneOutlet.com

Our Customers Say...

"Once again thank you for your wonderful customer service. I deal in the customer service industry everyday and really appreciate it when I come across a company that does an above average job of customer service. I will give you the best compliment that I know of - I will refer you to others."
- Casey, FL

Bluetooth Centro GPS

HAiCOM Hi-407BT GPS Receiver for Centro

$89.95
Manufacturer: HAiCOM
Works with: Centro

Part# A1170 Mnf# HI-407BT
Temporarily Sold Out

30-day 100% Money Back Guarantee!

This ultra high sensitive 20 channel SiRF StarIII GPS Receiver has a convenient built-in car charger, which powers both the GPS and your smartphone without a cable mess.

Simply plug HI-407BT into any regular in car cigarette lighter outlet (can take DC12V to DC24V), and you can instantly enjoy the state of the art wireless GPS navigation.

HI-407BT Bluetooth® GPS receiver installed on cigarette lighter outletHI-407BT advantages:

1. Simply plug in the HI-407BT into the standard in car cigarette lighter outlet and as soon as the car powered on, you can start using the wireless GPS navigation without worry about the Bluetooth GPS receiver battery life.

2. Equipped with the 20 channel ultra high sensitive SiRF StarIII GPS module, HI-407BT can get 3D fixed on most cigarette lighter outlet locations and without using the external antenna.

3. Unlike normal Bluetooth GPS receiver moving around dashboard while driving, HI-407BT can fixed on the cigarette lighter outlet and without worry about where to place the unit.

4. By connecting a Sync & Charge cable (not included) on the side of the unit, the HI-407BT can also charge your smartphone. Data can also transfered over the USB connection, so you can use the receiver as a wired receiver.

ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353

SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel` FROM products_accessories WHERE a_id='1170'
Server shutdown in progress

Traceback:
/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:32
/web/store.treocentral.com/htdocs/v2_templates/gui_objects/product_specs.php:229
/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:970
/web/store.treocentral.com/htdocs/content.php:535

SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'

Where
 "a_id='1170'"

Name

ID
(a_id)
*key*

Sku
(sku)

Name
(name)

Manufacturer
(manufacturer)

ManufacturerID
(manufacturer_id_rel)

Summary
(summary)

NameFront
(name_front)

SummaryFront
(summary_front)

Description
(description)

FAQ
(faq)

ProductManual
(product_manual)

Price
(price)

Weight
(weight)

Discountinued
(discountinued)

NOOrder
(no_order)

ToBeDiscontinued
(to_be_discontinued)

DateAdded
(date_added)

MasterAccessoryID
(master_a_id_rel)

Variance
(variance)

ShowVarianceThumb
(show_variance_thumb)

VarianceAdditionalImage
(variance_additional_image)

hide_device_cpt_no_id
(hide_device_cpt_no_id)

hide_device_cpt_always
(hide_device_cpt_always)

hide_device_cpt_exception
(hide_device_cpt_exception)

hide_device_feed
(hide_device_feed)

TCReview
(tc_review)

QuantityMultiple
(qty_multiple)

VirtualItemFlag
(virtual_item_flag)

VirtualItemShowContent
(virtual_item_show_content)

todo_sort
(todo_sort)

MSRP
(msrp)

OpentBoxID
(openbox_master_aid_rel)

No results returned - Query error

ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353

SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months` FROM products_manufacturers
MySQL server has gone away

Traceback:
/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:34
/web/store.treocentral.com/htdocs/v2_templates/gui_objects/product_specs.php:229
/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:970
/web/store.treocentral.com/htdocs/content.php:535

SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers

ID
(manufacturer_id)
*key*

Name
(name)

URL
(url)

Phone
(phone)

Email
(email)

Logo
(logo_image)

Show
(show_always)

WarrantyMonths
(spe_warranty_months)

WarrantyMonthsMNF
(mnf_warranty_months)

No results returned - Query error

Sales Rank

Nav Software

Software Media

GPS Chipset

SiRF III

Vehicle Mount

Battery Time

Wall Charger

Car Charger

Included

USB Charge

Notes

Compare against other GPS

MySQL server has gone awayMySQL server has gone away

User Ratings & Opinions

total ratings

0% rated
0% rated
0% rated
0% rated
0% rated

Own this product?

Add your rating now:

ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353

Traceback:
/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:32
/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263
/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432
/web/store.treocentral.com/htdocs/content.php:535

SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





Where
 "a_id='1170'" 

ID
(a_id)
*key*Sku
(sku)Name
(name)Manufacturer
(manufacturer)ManufacturerID
(manufacturer_id_rel)Summary
(summary)NameFront
(name_front)SummaryFront
(summary_front)Description
(description)FAQ
(faq)ProductManual
(product_manual)Price
(price)Weight
(weight)Discountinued
(discountinued)NOOrder
(no_order)ToBeDiscontinued
(to_be_discontinued)DateAdded
(date_added)MasterAccessoryID
(master_a_id_rel)Variance
(variance)ShowVarianceThumb
(show_variance_thumb)VarianceAdditionalImage
(variance_additional_image)hide_device_cpt_no_id
(hide_device_cpt_no_id)hide_device_cpt_always
(hide_device_cpt_always)hide_device_cpt_exception
(hide_device_cpt_exception)hide_device_feed
(hide_device_feed)TCReview
(tc_review)QuantityMultiple
(qty_multiple)VirtualItemFlag
(virtual_item_flag)VirtualItemShowContent
(virtual_item_show_content)todo_sort
(todo_sort)MSRP
(msrp)OpentBoxID
(openbox_master_aid_rel)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:34

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







ID
(manufacturer_id)
*key*Name
(name)URL
(url)Phone
(phone)Email
(email)Logo
(logo_image)Show
(show_always)WarrantyMonths
(spe_warranty_months)WarrantyMonthsMNF
(mnf_warranty_months)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:32

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





Where
 "a_id='1170'" 

ID
(a_id)
*key*Sku
(sku)Name
(name)Manufacturer
(manufacturer)ManufacturerID
(manufacturer_id_rel)Summary
(summary)NameFront
(name_front)SummaryFront
(summary_front)Description
(description)FAQ
(faq)ProductManual
(product_manual)Price
(price)Weight
(weight)Discountinued
(discountinued)NOOrder
(no_order)ToBeDiscontinued
(to_be_discontinued)DateAdded
(date_added)MasterAccessoryID
(master_a_id_rel)Variance
(variance)ShowVarianceThumb
(show_variance_thumb)VarianceAdditionalImage
(variance_additional_image)hide_device_cpt_no_id
(hide_device_cpt_no_id)hide_device_cpt_always
(hide_device_cpt_always)hide_device_cpt_exception
(hide_device_cpt_exception)hide_device_feed
(hide_device_feed)TCReview
(tc_review)QuantityMultiple
(qty_multiple)VirtualItemFlag
(virtual_item_flag)VirtualItemShowContent
(virtual_item_show_content)todo_sort
(todo_sort)MSRP
(msrp)OpentBoxID
(openbox_master_aid_rel)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:34

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







ID
(manufacturer_id)
*key*Name
(name)URL
(url)Phone
(phone)Email
(email)Logo
(logo_image)Show
(show_always)WarrantyMonths
(spe_warranty_months)WarrantyMonthsMNF
(mnf_warranty_months)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:32

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





Where
 "a_id='1170'" 

ID
(a_id)
*key*Sku
(sku)Name
(name)Manufacturer
(manufacturer)ManufacturerID
(manufacturer_id_rel)Summary
(summary)NameFront
(name_front)SummaryFront
(summary_front)Description
(description)FAQ
(faq)ProductManual
(product_manual)Price
(price)Weight
(weight)Discountinued
(discountinued)NOOrder
(no_order)ToBeDiscontinued
(to_be_discontinued)DateAdded
(date_added)MasterAccessoryID
(master_a_id_rel)Variance
(variance)ShowVarianceThumb
(show_variance_thumb)VarianceAdditionalImage
(variance_additional_image)hide_device_cpt_no_id
(hide_device_cpt_no_id)hide_device_cpt_always
(hide_device_cpt_always)hide_device_cpt_exception
(hide_device_cpt_exception)hide_device_feed
(hide_device_feed)TCReview
(tc_review)QuantityMultiple
(qty_multiple)VirtualItemFlag
(virtual_item_flag)VirtualItemShowContent
(virtual_item_show_content)todo_sort
(todo_sort)MSRP
(msrp)OpentBoxID
(openbox_master_aid_rel)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:34

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







ID
(manufacturer_id)
*key*Name
(name)URL
(url)Phone
(phone)Email
(email)Logo
(logo_image)Show
(show_always)WarrantyMonths
(spe_warranty_months)WarrantyMonthsMNF
(mnf_warranty_months)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:32

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





Where
 "a_id='1170'" 

ID
(a_id)
*key*Sku
(sku)Name
(name)Manufacturer
(manufacturer)ManufacturerID
(manufacturer_id_rel)Summary
(summary)NameFront
(name_front)SummaryFront
(summary_front)Description
(description)FAQ
(faq)ProductManual
(product_manual)Price
(price)Weight
(weight)Discountinued
(discountinued)NOOrder
(no_order)ToBeDiscontinued
(to_be_discontinued)DateAdded
(date_added)MasterAccessoryID
(master_a_id_rel)Variance
(variance)ShowVarianceThumb
(show_variance_thumb)VarianceAdditionalImage
(variance_additional_image)hide_device_cpt_no_id
(hide_device_cpt_no_id)hide_device_cpt_always
(hide_device_cpt_always)hide_device_cpt_exception
(hide_device_cpt_exception)hide_device_feed
(hide_device_feed)TCReview
(tc_review)QuantityMultiple
(qty_multiple)VirtualItemFlag
(virtual_item_flag)VirtualItemShowContent
(virtual_item_show_content)todo_sort
(todo_sort)MSRP
(msrp)OpentBoxID
(openbox_master_aid_rel)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:34

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







ID
(manufacturer_id)
*key*Name
(name)URL
(url)Phone
(phone)Email
(email)Logo
(logo_image)Show
(show_always)WarrantyMonths
(spe_warranty_months)WarrantyMonthsMNF
(mnf_warranty_months)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:32

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `a_id`, `sku`, `name`, `manufacturer`, `manufacturer_id_rel`, `summary`, `name_front`, `summary_front`, `description`, `faq`, `product_manual`, `price`, `weight`, `discountinued`, `no_order`, `to_be_discontinued`, `date_added`, `master_a_id_rel`, `variance`, `show_variance_thumb`, `variance_additional_image`, `hide_device_cpt_no_id`, `hide_device_cpt_always`, `hide_device_cpt_exception`, `hide_device_feed`, `tc_review`, `qty_multiple`, `virtual_item_flag`, `virtual_item_show_content`, `todo_sort`, `msrp`, `openbox_master_aid_rel`
FROM products_accessories

WHERE a_id='1170'





Where
 "a_id='1170'" 

ID
(a_id)
*key*Sku
(sku)Name
(name)Manufacturer
(manufacturer)ManufacturerID
(manufacturer_id_rel)Summary
(summary)NameFront
(name_front)SummaryFront
(summary_front)Description
(description)FAQ
(faq)ProductManual
(product_manual)Price
(price)Weight
(weight)Discountinued
(discountinued)NOOrder
(no_order)ToBeDiscontinued
(to_be_discontinued)DateAdded
(date_added)MasterAccessoryID
(master_a_id_rel)Variance
(variance)ShowVarianceThumb
(show_variance_thumb)VarianceAdditionalImage
(variance_additional_image)hide_device_cpt_no_id
(hide_device_cpt_no_id)hide_device_cpt_always
(hide_device_cpt_always)hide_device_cpt_exception
(hide_device_cpt_exception)hide_device_feed
(hide_device_feed)TCReview
(tc_review)QuantityMultiple
(qty_multiple)VirtualItemFlag
(virtual_item_flag)VirtualItemShowContent
(virtual_item_show_content)todo_sort
(todo_sort)MSRP
(msrp)OpentBoxID
(openbox_master_aid_rel)
No results returned - Query error
ERROR: DGOMySQL::_Query(): The query FAILED in /web/library/DGO/dgoBase.php:353
SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







MySQL server has gone away
Traceback:

/web/orderquery.smartphoneexperts.com/functions/verbal/verbal_item_device.php:34

/web/store.treocentral.com/htdocs/v2_templates/user_reviews/user_reviews.php:263

/web/store.treocentral.com/htdocs/v2_templates/accessories/product_page.php:1432

/web/store.treocentral.com/htdocs/content.php:535

SELECT `manufacturer_id`, `name`, `url`, `phone`, `email`, `logo_image`, `show_always`, `spe_warranty_months`, `mnf_warranty_months`
FROM products_manufacturers







ID
(manufacturer_id)
*key*Name
(name)URL
(url)Phone
(phone)Email
(email)Logo
(logo_image)Show
(show_always)WarrantyMonths
(spe_warranty_months)WarrantyMonthsMNF
(mnf_warranty_months)
No results returned - Query error

No written user opinions for this product have been posted yet. Be the first! Start by rating this product using the stars above.