Yelton, Farfour & Bridges - Les Farfour

Full information about place - Establishment and lawyer "Yelton, Farfour & Bridges - Les Farfour" at 211 South Washington Street, Shelby, NC 28150. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Website:
shelbylawyers.com

Phone number:
+1 704-482-7718

Address:
211 South Washington Street, Shelby, NC 28150
Get directions

Categories:
Establishment Lawyer

Suggest changes

Reviews about Yelton, Farfour & Bridges - Les Farfour

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

United States Postal Service
Establishment, Post office

405 South Dekalb Street, Shelby, NC 28150

+1 800-275-8777

tools.usps.com
Diamond Pawn
Establishment, Electronics store, Home goods store, Jewelry store

417 South Lafayette Street, Shelby, NC 28150

+1 704-482-4771

diamondpawn.net
Auto Service Inc
Establishment, Car dealer

409 South Lafayette Street, Shelby, NC 28150

+1 980-404-1181

facebook.com
Alliance Bank & Trust Co
Establishment, Finance

412 South Dekalb Street, Shelby, NC 28150

+1 704-471-1500

alliancebanknc.com
M & J Loans of Shelby, Inc
Establishment, Finance

409 South Lafayette Street, Shelby, NC 28150

+1 704-487-4141

mandjloans.com
Kerry Lowery Attorney
Establishment, Lawyer

403 South Washington Street, Shelby, NC 28150

+1 704-487-5253

Weather in Shelby, NC

May, 09 2024 03:00am	20 ^℃
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	23 ^℃
May, 09 2024 09:00pm	23 ^℃
May, 10 2024 12:00am	22 ^℃
May, 10 2024 03:00am	19 ^℃
May, 10 2024 06:00am	18 ^℃
May, 10 2024 09:00am	17 ^℃
May, 10 2024 12:00pm	19 ^℃
May, 10 2024 03:00pm	22 ^℃
May, 10 2024 06:00pm	26 ^℃
May, 10 2024 09:00pm	21 ^℃
May, 11 2024 12:00am	16 ^℃
May, 11 2024 03:00am	12 ^℃
May, 11 2024 06:00am	9 ^℃
May, 11 2024 09:00am	8 ^℃
May, 11 2024 12:00pm	11 ^℃
May, 11 2024 03:00pm	16 ^℃
May, 11 2024 06:00pm	20 ^℃
May, 11 2024 09:00pm	22 ^℃

1	SELECT * FROM `item` WHERE url = 'yelton-farfour-bridges-les-farfour' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('31109') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('170589')
1	SELECT * FROM `category` WHERE id IN ('189','221') LIMIT 2
0	SELECT * FROM `locality` WHERE url = 'shelby-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
0	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 170589 AND `date` < '2024-05-09 14:14:51' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('170589')
2	SELECT * FROM `item` WHERE id IN ('377022','185100','228857','263743','263015','204099') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('31109') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('185100','204099','228857','263015','263743','377022')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('185100','204099','228857','263015','263743','377022')
0	SELECT * FROM `category` WHERE id IN ('189','245','193','208','225','220','207','221') LIMIT 8
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
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 ('31162','30680') LIMIT 2
0	SELECT * FROM `photos` WHERE `item_id` IN ('199707','199708','199709','199710','199711','199712','199713','199714')
0	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'