Schmoos of Swansea Ltd

Full information about Establishment and bicycle store Schmoos of Swansea Ltd at 7A-9A Humphrey Street, Swansea, Wales SA1 6BG. Find the address of the company, the phone for communication, opening hours, feedback from customers and employees, as well as other information.

Contacts

Address:
7A-9A Humphrey Street, Swansea, Wales SA1 6BG
Get directions

Phone number:
+44 1792 467070

Website:
schmooscycles.org.uk

Types:
Establishment   Bicycle store  

Suggest changes

Click to view full map
 

Images of Schmoos of Swansea Ltd

Schmoos of Swansea Ltd

Reviews about Schmoos of Swansea Ltd

  • kevin ellacott
    20.10.2018
    ★ ★ ★ ★ ★
    Took my broken bike to Schmoos cycles, it was repaired quickly, it was cheap, he knew what he was talking bout, he gave great bike maintenance advice. I couldn't ask for more. Will def be using again. Schmoos cycles are well recommended.
Add new review

About schmooscycles.org.uk

Please Wait

The nearest companies

Weather in Swansea, Wales

23.10.2020 04:00 9
23.10.2020 07:00 10
23.10.2020 10:00 11
23.10.2020 13:00 11
23.10.2020 16:00 11
23.10.2020 19:00 10
23.10.2020 22:00 10
24.10.2020 01:00 10
24.10.2020 04:00 11
24.10.2020 07:00 12
24.10.2020 10:00 14
24.10.2020 13:00 14
24.10.2020 16:00 13
24.10.2020 19:00 12
24.10.2020 22:00 11
25.10.2020 01:00 11
25.10.2020 04:00 10
25.10.2020 07:00 10
25.10.2020 10:00 11
25.10.2020 13:00 12
25.10.2020 16:00 11
25.10.2020 19:00 10
25.10.2020 22:00 9
1SELECT * FROM `item` WHERE url = 'schmoos-swansea-ltd' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('4') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('11838') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('305908')
0SELECT * FROM `category` WHERE id IN ('1','50') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'swansea-wls' LIMIT 1
0SELECT * FROM `region` WHERE id = 4 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 305908 AND `date` < '2020-10-23 11:50:47' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('305908')
5SELECT * FROM `item` WHERE id IN ('394117','915981','145767','915668','915984','4472') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('4') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('11838') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('4472','145767','394117','915668','915981','915984')
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('4472','145767','394117','915668','915981','915984')
0SELECT * FROM `category` WHERE id IN ('1','2','3','4') LIMIT 4
0SELECT * FROM counts where updated="2020-10-23" and table_name like 'news'
0SELECT * FROM counts where updated="2020-10-23" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
3SELECT * FROM `item` WHERE `id` IN ('139829','732420','823950','2633','556801','59140','435525','259040','52174','134701','880350','348521')
0SELECT * FROM `region` WHERE id IN ('1','3') LIMIT 2
1SELECT * FROM `locality` WHERE id IN ('9076','4419','2731','4266','5601','8586','3446','9919','7729','1115','8856','6732') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('2633','52174','59140','134701','139829','259040','348521','435525','556801','732420','823950','880350')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('2633','52174','59140','134701','139829','259040','348521','435525','556801','732420','823950','880350')
0SELECT * FROM `category` WHERE id IN ('1','3','9','35','46','4','6') LIMIT 7
0SELECT * FROM counts where updated="2020-10-23" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('3186','6732','11234','5197','6750','3252','7472','6483','6827','5559','10619','706','6371','8219','2244','8471','10099','7731','8047','6964','240','2710') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-10-23" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-10-23" and table_name like 'item'
0SELECT * FROM counts where updated="2020-10-23" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-10-23" and table_name like 'photos'