Sound Advice Psychological Services

Full information about place - Establishment and health "Sound Advice Psychological Services" at Hayesville, Hayesville, NC 28904. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 828-835-0772

Address:
Hayesville, Hayesville, NC 28904
Get directions

Categories:
Establishment Health

Suggest changes

Reviews about Sound Advice Psychological Services

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

Clay County Progress
Establishment

43 Main Street, Hayesville, NC 28904

+1 828-389-8431

claycountyprogress.com

Closed now: Until 08:30am tomorrow
Old Courthouse
Establishment, Museum

33-73 Church Street, Hayesville, NC 28904

+1 828-389-3704

claychambernc.com
Clay County Building Inspector
Establishment, Local government office

33 Main Street, Hayesville, NC 28904

+1 828-389-0274

clayconc.com
Western Home Healthcare®
Establishment, Health

40 Main Street, Hayesville, NC 28904

+1 828-369-0752

Open now: Until 07:00pm
Cutworm Specialties, Inc.
Establishment

62 Church Street, Hayesville, NC 28904

+1 828-389-1999

cutwormspecialties.com
A Good Yarn
Establishment

66 Church Street, Hayesville, NC 28904

+1 828-389-2323

Weather in Hayesville, NC

May, 09 2024 03:00am	21 ^℃
May, 09 2024 06:00am	19 ^℃
May, 09 2024 09:00am	17 ^℃
May, 09 2024 12:00pm	19 ^℃
May, 09 2024 03:00pm	21 ^℃
May, 09 2024 06:00pm	18 ^℃
May, 09 2024 09:00pm	25 ^℃
May, 10 2024 12:00am	21 ^℃
May, 10 2024 03:00am	18 ^℃
May, 10 2024 06:00am	17 ^℃
May, 10 2024 09:00am	16 ^℃
May, 10 2024 12:00pm	16 ^℃
May, 10 2024 03:00pm	20 ^℃
May, 10 2024 06:00pm	20 ^℃
May, 10 2024 09:00pm	19 ^℃
May, 11 2024 12:00am	14 ^℃
May, 11 2024 03:00am	10 ^℃
May, 11 2024 06:00am	7 ^℃
May, 11 2024 09:00am	6 ^℃
May, 11 2024 12:00pm	8 ^℃
May, 11 2024 03:00pm	16 ^℃
May, 11 2024 06:00pm	20 ^℃
May, 11 2024 09:00pm	20 ^℃

2	SELECT * FROM `item` WHERE url = 'sound-advice-psychological-services' LIMIT 1
1	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30772') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('154733')
0	SELECT * FROM `category` WHERE id IN ('189','191') LIMIT 2
0	SELECT * FROM `locality` WHERE url = 'hayesville-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
0	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 154733 AND `date` < '2024-05-09 22:06:30' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('154733')
0	SELECT * FROM `item` WHERE id IN ('40636','112665','116943','151448','111640','112661') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30772') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('40636','111640','112661','112665','116943','151448')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('40636','111640','112661','112665','116943','151448')
0	SELECT * FROM `category` WHERE id IN ('189','270','192','191') LIMIT 4
1	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'
1	SELECT * FROM `category` ORDER BY name
2	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
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30661','30787') LIMIT 2
1	SELECT * FROM `photos` WHERE `item_id` IN ('425131','425132','425133','425134','425135','425136','425137','425138')
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'
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'reviews'
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos'