Beam Fraley Realty

Full information about place - Establishment and real estate agency "Beam Fraley Realty" at 301 East Main Street, Cherryville, NC 28021. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 704-435-1026

Address:
301 East Main Street, Cherryville, NC 28021
Get directions

Categories:
Establishment Real estate agency

Suggest changes

Reviews about Beam Fraley Realty

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

Cherryville Chamber of Commerce
Establishment

220 East Main Street, Cherryville, NC 28021

+1 704-435-3451

cherryvillechamber.com
Vickie Spurling Realty
Establishment, Real estate agency

211 East Main Street, Cherryville, NC 28021

+1 704-769-0841

spurlingrealty.com

Open now: Until 06:00pm
Rocky Mountain Music Company
Establishment, School

203 East Main Street, Cherryville, NC 28021

+1 828-428-2551

rockymountainmusiccompany.weebly.com

Closed now:
Main Street BP
Establishment, Atm, Finance, Gas station

300 East Main Street, Cherryville, NC 28021

+1 704-435-9003
Vickie's
Establishment, Food

119 South Mountain Street, Cherryville, NC 28021

+1 704-435-4782

Open now: Until 01:00pm
Heritage Park Art Center
Establishment, Art gallery

214 East Main Street, Cherryville, NC 28021

+1 704-718-3103

Weather in Cherryville, NC

May, 09 2024 03:00pm	18 ^℃
May, 09 2024 06:00pm	20 ^℃
May, 09 2024 09:00pm	24 ^℃
May, 10 2024 12:00am	21 ^℃
May, 10 2024 03:00am	18 ^℃
May, 10 2024 06:00am	18 ^℃
May, 10 2024 09:00am	15 ^℃
May, 10 2024 12:00pm	17 ^℃
May, 10 2024 03:00pm	22 ^℃
May, 10 2024 06:00pm	27 ^℃
May, 10 2024 09:00pm	26 ^℃
May, 11 2024 12:00am	18 ^℃
May, 11 2024 03:00am	13 ^℃
May, 11 2024 06:00am	10 ^℃
May, 11 2024 09:00am	9 ^℃
May, 11 2024 12:00pm	12 ^℃
May, 11 2024 03:00pm	18 ^℃
May, 11 2024 06:00pm	22 ^℃
May, 11 2024 09:00pm	22 ^℃

1	SELECT * FROM `item` WHERE url = 'beam-fraley-realty' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30595') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('142675')
0	SELECT * FROM `category` WHERE id IN ('189','214') LIMIT 2
0	SELECT * FROM `locality` WHERE url = 'cherryville-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
4	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 142675 AND `date` < '2024-05-09 13:14:22' ORDER BY `date` DESC
1	SELECT * FROM `photos` WHERE `item_id` IN ('142675')
2	SELECT * FROM `item` WHERE id IN ('13221','14310','142261','13240','142516','13502') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
1	SELECT * FROM `locality` WHERE id IN ('30595') LIMIT 1
1	SELECT * FROM `photos` WHERE `item_id` IN ('13221','13240','13502','14310','142261','142516')
5	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('13221','13240','13502','14310','142261','142516')
0	SELECT * FROM `category` WHERE id IN ('189','214','190','206','207','223','219','263') 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'
1	SELECT * FROM `category` ORDER BY name
4	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 ('30724','30905','31050','30882','31149') LIMIT 5
0	SELECT * FROM `photos` WHERE `item_id` IN ('196647','196648','196649','196650','196651','196652','196653','196654')
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'