Buy Used Lu4 Downlighter by Abstract AVR

Looking for a used, new, second-hand or ex-hire Lu4 Downlighter? We may be able to help. Click here to see if we can help you find it.

The colour changing MR16 lu4 is an ideal mood light, it can be used in all types of applications. The Lu4 MR16 down lighter mixes colour using primary R/G/B/W led technology, it is controlled by processors onboard the Lud/48 driver module.. The Lud/48 driver mixes the primary colours within the Lu4 ...

Brand Abstract AVR
Category Indoor Architectural Lighting
Family/Series
Model #

Database Error
Message:MySQL Query fail: select MODEL, items.ID_REG_MODEL, registered_manufacturers.REGISTERED_MANUFACTURER, registered_models.REGISTERED_MODEL, MANUFACTURER, registered_manufacturers.ID_REG_MANUF, ID_ITEM, SUBTITLE, items.DESCRIPTION, PRICE_FINAL_US, QUANTITY, AGE_DOM, CONDITION_COSMETIC, WARRANTY_TYPE_NUMBER, WARRANTY_TYPE_UNIT, REGION_WEBSITE, CURRENCY_CODE, STATUSS, LARGE_SYSTEM, EXTRA_VAR_3, category_1.ID_CATEGORY_1, category_1.NAME_1, category_2.ID_CATEGORY_2, category_2.NAME_2, category_3.ID_CATEGORY_3, category_3.NAME_3, category_1.PRIORITY_1, category_2.PRIORITY_2, category_3.PRIORITY_3, MAKE_OFFER, CREATE_DATE, DATE_POSTED, CASE CURRENCY_CODE when 'USD' then ceiling( PRICE_FINAL_US * 1) when 'EUR' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.8372) ) * 1.025 ) when 'GBP' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.7362) ) * 1.025 ) when 'CAD' then ceiling( ( PRICE_FINAL_US * ( 1 / 1.2196) ) * 1.025 ) end as price_converted_usd from items LEFT JOIN contacts USING(ID_COMPANY) LEFT JOIN data_prefs_location_countries ON (contacts.ID_COUNTRY = data_prefs_location_countries.ID_COUNTRY) LEFT JOIN data_prefs_location_regions ON (data_prefs_location_countries.ID_REGION = data_prefs_location_regions.ID_REGION) LEFT JOIN registered_models ON ( items.ID_REG_MODEL = registered_models.ID_REG_MODEL ) LEFT JOIN registered_manufacturers ON ( registered_manufacturers.ID_REG_MANUF = registered_models.ID_REG_MANUF ) LEFT JOIN category_3 ON ( items.CATEGORY_MAIN = category_3.ID_CATEGORY_3 ) LEFT JOIN category_2 ON ( category_2.ID_CATEGORY_2 = category_3.ID_PARENT_3 ) LEFT JOIN category_1 ON ( category_1.ID_CATEGORY_1 = category_2.ID_PARENT_2 ) where PRICE_FINAL_US >0 && QUANTITY >0 && CONTACT_STANDING = 1 && STATUSS IN ('FOR_SALE','BSTOCK') && items.ID_REG_MODEL = '3303' GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'NEW','FOR_SALE','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','9','0'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 40
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter
Database Error
Message:MySQL Query fail: select MODEL, items.ID_REG_MODEL, registered_manufacturers.REGISTERED_MANUFACTURER, registered_models.REGISTERED_MODEL, MANUFACTURER, registered_manufacturers.ID_REG_MANUF, ID_ITEM, SUBTITLE, items.DESCRIPTION, PRICE_FINAL_US, QUANTITY, AGE_DOM, CONDITION_COSMETIC, WARRANTY_TYPE_NUMBER, WARRANTY_TYPE_UNIT, REGION_WEBSITE, CURRENCY_CODE, STATUSS, LARGE_SYSTEM, EXTRA_VAR_3, category_1.ID_CATEGORY_1, category_1.NAME_1, category_2.ID_CATEGORY_2, category_2.NAME_2, category_3.ID_CATEGORY_3, category_3.NAME_3, category_1.PRIORITY_1, category_2.PRIORITY_2, category_3.PRIORITY_3, MAKE_OFFER, CREATE_DATE, DATE_POSTED, CASE CURRENCY_CODE when 'USD' then ceiling( PRICE_FINAL_US * 1) when 'EUR' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.8372) ) * 1.025 ) when 'GBP' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.7362) ) * 1.025 ) when 'CAD' then ceiling( ( PRICE_FINAL_US * ( 1 / 1.2196) ) * 1.025 ) end as price_converted_usd from items LEFT JOIN contacts USING(ID_COMPANY) LEFT JOIN data_prefs_location_countries ON (contacts.ID_COUNTRY = data_prefs_location_countries.ID_COUNTRY) LEFT JOIN data_prefs_location_regions ON (data_prefs_location_countries.ID_REGION = data_prefs_location_regions.ID_REGION) LEFT JOIN registered_models ON ( items.ID_REG_MODEL = registered_models.ID_REG_MODEL ) LEFT JOIN registered_manufacturers ON ( registered_manufacturers.ID_REG_MANUF = registered_models.ID_REG_MANUF ) LEFT JOIN category_3 ON ( items.CATEGORY_MAIN = category_3.ID_CATEGORY_3 ) LEFT JOIN category_2 ON ( category_2.ID_CATEGORY_2 = category_3.ID_PARENT_3 ) LEFT JOIN category_1 ON ( category_1.ID_CATEGORY_1 = category_2.ID_PARENT_2 ) where PRICE_FINAL_US >0 && QUANTITY >0 && CONTACT_STANDING = 1 && STATUSS IN ('FOR_SALE','BSTOCK') && items.ID_REG_MODEL = '3303' GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'NEW','FOR_SALE','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','9','0'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 40
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter

Browse all Indoor Architectural Lighting from Abstract AVR

Newsletter Sign Up

Receive our Latest Deals
Sign Up Here

Featured Deals

Our Best Deals
View All

Can't Find it?

We can source it for you.
Tell Us What You Need
Database Error
Message:MySQL Query fail: select MODEL, items.ID_REG_MODEL, registered_manufacturers.REGISTERED_MANUFACTURER, registered_models.REGISTERED_MODEL, MANUFACTURER, registered_manufacturers.ID_REG_MANUF, ID_ITEM, SUBTITLE, items.DESCRIPTION, PRICE_FINAL_US, QUANTITY, AGE_DOM, CONDITION_COSMETIC, WARRANTY_TYPE_NUMBER, WARRANTY_TYPE_UNIT, REGION_WEBSITE, CURRENCY_CODE, STATUSS, LARGE_SYSTEM, EXTRA_VAR_3, category_1.ID_CATEGORY_1, category_1.NAME_1, category_2.ID_CATEGORY_2, category_2.NAME_2, category_3.ID_CATEGORY_3, category_3.NAME_3, category_1.PRIORITY_1, category_2.PRIORITY_2, category_3.PRIORITY_3, MAKE_OFFER, CREATE_DATE, DATE_POSTED, CASE CURRENCY_CODE when 'USD' then ceiling( PRICE_FINAL_US * 1) when 'EUR' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.8372) ) * 1.025 ) when 'GBP' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.7362) ) * 1.025 ) when 'CAD' then ceiling( ( PRICE_FINAL_US * ( 1 / 1.2196) ) * 1.025 ) end as price_converted_usd from items LEFT JOIN contacts USING(ID_COMPANY) LEFT JOIN data_prefs_location_countries ON (contacts.ID_COUNTRY = data_prefs_location_countries.ID_COUNTRY) LEFT JOIN data_prefs_location_regions ON (data_prefs_location_countries.ID_REGION = data_prefs_location_regions.ID_REGION) LEFT JOIN registered_models ON ( items.ID_REG_MODEL = registered_models.ID_REG_MODEL ) LEFT JOIN registered_manufacturers ON ( registered_manufacturers.ID_REG_MANUF = registered_models.ID_REG_MANUF ) LEFT JOIN category_3 ON ( items.CATEGORY_MAIN = category_3.ID_CATEGORY_3 ) LEFT JOIN category_2 ON ( category_2.ID_CATEGORY_2 = category_3.ID_PARENT_3 ) LEFT JOIN category_1 ON ( category_1.ID_CATEGORY_1 = category_2.ID_PARENT_2 ) where PRICE_FINAL_US >0 && QUANTITY >0 && CONTACT_STANDING = 1 && items.CATEGORY_MAIN = 43 && STATUSS IN ('FOR_SALE','BSTOCK') && items.CATEGORY_MAIN = '43' GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'FOR_SALE','NEW','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','0','9'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 8
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter
Database Error
Message:MySQL Query fail: select MODEL, items.ID_REG_MODEL, registered_manufacturers.REGISTERED_MANUFACTURER, registered_models.REGISTERED_MODEL, MANUFACTURER, registered_manufacturers.ID_REG_MANUF, ID_ITEM, SUBTITLE, items.DESCRIPTION, PRICE_FINAL_US, QUANTITY, AGE_DOM, CONDITION_COSMETIC, WARRANTY_TYPE_NUMBER, WARRANTY_TYPE_UNIT, REGION_WEBSITE, CURRENCY_CODE, STATUSS, LARGE_SYSTEM, EXTRA_VAR_3, category_1.ID_CATEGORY_1, category_1.NAME_1, category_2.ID_CATEGORY_2, category_2.NAME_2, category_3.ID_CATEGORY_3, category_3.NAME_3, category_1.PRIORITY_1, category_2.PRIORITY_2, category_3.PRIORITY_3, MAKE_OFFER, CREATE_DATE, DATE_POSTED, CASE CURRENCY_CODE when 'USD' then ceiling( PRICE_FINAL_US * 1) when 'EUR' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.8372) ) * 1.025 ) when 'GBP' then ceiling( ( PRICE_FINAL_US * ( 1 / 0.7362) ) * 1.025 ) when 'CAD' then ceiling( ( PRICE_FINAL_US * ( 1 / 1.2196) ) * 1.025 ) end as price_converted_usd from items LEFT JOIN contacts USING(ID_COMPANY) LEFT JOIN data_prefs_location_countries ON (contacts.ID_COUNTRY = data_prefs_location_countries.ID_COUNTRY) LEFT JOIN data_prefs_location_regions ON (data_prefs_location_countries.ID_REGION = data_prefs_location_regions.ID_REGION) LEFT JOIN registered_models ON ( items.ID_REG_MODEL = registered_models.ID_REG_MODEL ) LEFT JOIN registered_manufacturers ON ( registered_manufacturers.ID_REG_MANUF = registered_models.ID_REG_MANUF ) LEFT JOIN category_3 ON ( items.CATEGORY_MAIN = category_3.ID_CATEGORY_3 ) LEFT JOIN category_2 ON ( category_2.ID_CATEGORY_2 = category_3.ID_PARENT_3 ) LEFT JOIN category_1 ON ( category_1.ID_CATEGORY_1 = category_2.ID_PARENT_2 ) where PRICE_FINAL_US >0 && QUANTITY >0 && CONTACT_STANDING = 1 && EXTRA_VAR_3 IN ('1','2','3') && STATUSS IN ('FOR_SALE','BSTOCK') GROUP BY ID_ITEM ORDER BY FIELD(STATUSS, 'FOR_SALE','NEW','BSTOCK'), FIELD(EXTRA_VAR_3, '1','2','3','8','0','9'), FIELD(TOP_MODEL, '1','2','3','4','5','0'), PRICE_FINAL_US asc LIMIT 8
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Friday, November 24, 2017 at 3:28:46 PM
Script:/products/abstract-avr/lu4-downlighter

Abstract AVR | Solaris

Used Lighting Equipment Lighting Rentals