Mastaphalis Cuts & Styles

Full information about place - Establishment, health and hair care "Mastaphalis Cuts & Styles" at 509 West 2nd Street, Lumberton, NC 28358. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 910-739-5357

Address:
509 West 2nd Street, Lumberton, NC 28358
Get directions

Categories:
Establishment Health Hair care

Suggest changes

Reviews about Mastaphalis Cuts & Styles

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

Cardtronics ATM
Establishment, Atm, Finance

409 Martin Luther King Junior Drive, Lumberton, NC 28358

cardtronics.com

Open now: Open 24 Hours
Family Dollar
Establishment, Food, Clothing store, Supermarket

407 Martin Luther King Junior Drive, Lumberton, NC 28358

+1 910-671-4725

locations.familydollar.com

Open now: Until 09:00pm
J&M Cars and Service
Establishment, Car dealer

405 Martin Luther King Junior Drive, Lumberton, NC 28358

+1 910-674-3800

Open now: Until 06:00pm
Hunt's Jewelry
Establishment, Jewelry store

400 Martin Luther King Junior Drive, Lumberton, NC 28358

+1 910-737-6663
MORHA PLAZA
Establishment, Health

400 Martin Luther King Junior Drive, Lumberton, NC 28358
King's Children & Adolescents
Establishment, Health

307 Martin Luther King Junior Drive, Lumberton, NC 28358

+1 910-738-7479

Weather in Lumberton, NC

May, 09 2024 03:00am	21 ^℃
May, 09 2024 06:00am	20 ^℃
May, 09 2024 09:00am	21 ^℃
May, 09 2024 12:00pm	21 ^℃
May, 09 2024 03:00pm	26 ^℃
May, 09 2024 06:00pm	30 ^℃
May, 09 2024 09:00pm	24 ^℃
May, 10 2024 12:00am	20 ^℃
May, 10 2024 03:00am	20 ^℃
May, 10 2024 06:00am	21 ^℃
May, 10 2024 09:00am	21 ^℃
May, 10 2024 12:00pm	22 ^℃
May, 10 2024 03:00pm	23 ^℃
May, 10 2024 06:00pm	22 ^℃
May, 10 2024 09:00pm	24 ^℃
May, 11 2024 12:00am	20 ^℃
May, 11 2024 03:00am	16 ^℃
May, 11 2024 06:00am	13 ^℃
May, 11 2024 09:00am	12 ^℃
May, 11 2024 12:00pm	13 ^℃
May, 11 2024 03:00pm	18 ^℃
May, 11 2024 06:00pm	21 ^℃
May, 11 2024 09:00pm	22 ^℃

1	SELECT * FROM `item` WHERE url = 'mastaphalis-cuts-styles' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
4	SELECT * FROM `locality` WHERE id IN ('30877') LIMIT 1
2	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('143351')
0	SELECT * FROM `category` WHERE id IN ('189','191','238') LIMIT 3
0	SELECT * FROM `locality` WHERE url = 'lumberton-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
0	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 143351 AND `date` < '2024-05-09 14:56:38' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('143351')
2	SELECT * FROM `item` WHERE id IN ('144115','429511','443298','143823','142695','142822') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30877') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('142695','142822','143823','144115','429511','443298')
3	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('142695','142822','143823','144115','429511','443298')
0	SELECT * FROM `category` WHERE id IN ('189','206','207','219','229','230','220','225','191') LIMIT 9
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
0	SELECT * FROM `category` ORDER BY name
6	SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 8
2	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('31143','30998','30760','30524','30922','31151') LIMIT 6
0	SELECT * FROM `photos` WHERE `item_id` IN ('90268','90269','90270','90271','90272','90273','90274','90275')
1	SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 12
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'locality'
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'item'
1	SELECT * FROM counts where updated="2024-05-09" and table_name like 'reviews'
2	SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos'