Remax: Judy Dawkins

Full information about place - Establishment and real estate agency "Remax: Judy Dawkins" at 301 College Street ste 130, Asheville, NC 28801. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 828-670-1500

Address:
301 College Street ste 130, Asheville, NC 28801
Get directions

Categories:
Establishment Real estate agency

Suggest changes

Reviews about Remax: Judy Dawkins

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

Dr. Larry J. Turner, DDS
Establishment, Health, Dentist

130 Biltmore Avenue, Asheville, NC 28801

+1 828-252-3851
Martin Luther King Jr Dr at S Charlotte St
Establishment, Transit station

United States, Asheville, NC 28801
Tried Stone Missionary Baptist Church
Establishment, Church, Place of worship

100 Carroll Avenue, Asheville, NC 28801

+1 828-285-0444

triedstoneasheville.org

Closed now:
Martin Luther King Jr Dr at S Charlotte St
Establishment, Bus station, Transit station

United States, Asheville, NC 28801
S.A.F.E. Conference
Establishment, Church, Place of worship

100 Carroll Avenue, Asheville, NC 28801

+1 828-285-0444
Martin Luther King Jr Dr at S Charlotte St
Establishment, Bus station, Transit station

United States, Asheville, NC 28801

Weather in Asheville, NC

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

1	SELECT * FROM `item` WHERE url = 'remax-judy-dawkins' LIMIT 1
1	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30484') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('148083')
0	SELECT * FROM `category` WHERE id IN ('189','214') LIMIT 2
1	SELECT * FROM `locality` WHERE url = 'asheville-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 148083 AND `date` < '2024-05-09 18:57:55' ORDER BY `date` DESC
1	SELECT * FROM `photos` WHERE `item_id` IN ('148083')
4	SELECT * FROM `item` WHERE id IN ('385892','385535','386906','148269','145147','385748') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30484') LIMIT 1
1	SELECT * FROM `photos` WHERE `item_id` IN ('145147','148269','385535','385748','385892','386906')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('145147','148269','385535','385748','385892','386906')
0	SELECT * FROM `category` WHERE id IN ('189','191','217','236','200','201','235') LIMIT 7
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'
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
1	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30740','31036','31204','31170') LIMIT 4
1	SELECT * FROM `photos` WHERE `item_id` IN ('420284','420285','420286','420287','420288','420289','420290','420291')
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'