Majestic Styles

Full information about place - Establishment and beauty salon "Majestic Styles" at 10653 US 70 Business Hwy W, Clayton, NC 27520. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 919-553-5491

Address:
10653 US 70 Business Hwy W, Clayton, NC 27520
Get directions

Categories:
Establishment   Beauty salon  

Suggest changes

Click to load full map
 

Reviews about Majestic Styles

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Majestic Styles

Nearest places

  • West Coast Insurance Co
    Establishment, Insurance agency
    9257 Us 70 Bus Hwy W, Clayton, NC 27520
    +1 919-359-0520
  • Sterling-Ascott Realty
    Establishment, Real estate agency
    Us 70 Bus Hwy W, Clayton, NC 27520
    +1 866-422-0915
  • Lindsay Brittany DC
    Establishment, Health
    6838 US 70 Bus Hwy W # 700, Clayton, NC 27520
    +1 919-553-5505
  • T A Bevlin Inc
    Establishment, General contractor
    8368 Us 70 Bus Hwy w # B, Clayton, NC 27520
    +1 919-553-7720
  • Perfect Portrait Inc
    Establishment
    11649 US 70 Business Hwy W, Clayton, NC 27520
    +1 919-359-8602
  • Carolina Children's Therapy
    Establishment, Health
    8031 Us 70 Bus Hwy W, Clayton, NC 27520
    +1 919-359-0589

Weather in Clayton, NC

1SELECT * FROM `item` WHERE url = 'majestic-styles' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30604') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('46205')
0SELECT * FROM `category` WHERE id IN ('189','243') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'clayton-nc' LIMIT 1
5SELECT * FROM `region` WHERE id = 66 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 46205 AND `date` < '2024-05-10 02:17:22' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('46205')
1SELECT * FROM `item` WHERE id IN ('46214','46252','46262','46335','46340','46341') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30604') LIMIT 1
1SELECT * FROM `photos` WHERE `item_id` IN ('46214','46252','46262','46335','46340','46341')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('46214','46252','46262','46335','46340','46341')
2SELECT * FROM `category` WHERE id IN ('189','209','214','191','222') LIMIT 5
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'news'
4SELECT * FROM counts where updated="2024-05-10" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
3SELECT * 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
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30578','31036') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('339220','339221','339222','339223','339224','339225','339226','339227')
0SELECT * 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
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'locality'
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'item'
0SELECT * FROM counts where updated="2024-05-10" and table_name like 'reviews'
3SELECT * FROM counts where updated="2024-05-10" and table_name like 'photos'