Buy Used Minicity250 by Articulight

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

The new product of the "architectural" family of the Articulight fixtures is the new MiniCity 250. It has an intermediate position between the MiniCity150 and the great series of the CityBeam and of the CityColor. The fixture uses the tested CYM colorchanger system, patent pending, developed by our ...

Brand Articulight
Category Color Changers
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 = '5948' 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:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250
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 = '5948' 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:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250

Browse all Color Changers from Articulight

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 = 16 && STATUSS IN ('FOR_SALE','BSTOCK') && items.CATEGORY_MAIN = '16' 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:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250
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:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250
Database Error
Message:Result ID: could not be freed.
MySQL Error:Got error 28 from storage engine
Date:Saturday, November 25, 2017 at 12:45:36 AM
Script:/products/articulight/minicity250

Articulight | Solaris

Articulight

Articulight

Buy Articulight

Articulite makes architectural lighting, including graphic projectors, architectural color changers and searchlights.

Used Lighting Equipment Lighting Rentals