Joan Rife Real Estate

Full information about place - Establishment and real estate agency "Joan Rife Real Estate" at 419 East Chatham Street # 18, Newport, NC 28570. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 252-223-9866

Address:
419 East Chatham Street # 18, Newport, NC 28570
Get directions

Categories:
Establishment Real estate agency

Suggest changes

Reviews about Joan Rife Real Estate

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

Rivers Brothers Landscaping
Establishment, General contractor

403 East Chatham Street, Newport, NC 28570

+1 252-223-3906
Turners Computers
Establishment

★ ☆ ☆ ☆ ☆

1 reviews

354 East Chatham Street, Newport, NC 28570

+1 252-223-2300

turnerscomputers.com

Open now: Until 05:00pm
TimeOut Tavern
Establishment, Food, Bar

360 East Chatham Street, Newport, NC 28570

+1 252-223-3303

Closed now:
Leon's Upholstery
Establishment, Home goods store, Furniture store

184 Fort Benjamin Road, Newport, NC 28570

+1 252-223-5366
Sandbox Child Care & Preschool
Establishment, School

130 Fort Benjamin Road, Newport, NC 28570

+1 252-223-3432
Joan Rife Real Estate
Establishment, Real estate agency

419 East Chatham Street # 18, Newport, NC 28570

+1 252-223-9866

Weather in Newport, NC

May, 09 2024 03:00am	23 ^℃
May, 09 2024 06:00am	21 ^℃
May, 09 2024 09:00am	20 ^℃
May, 09 2024 12:00pm	20 ^℃
May, 09 2024 03:00pm	24 ^℃
May, 09 2024 06:00pm	24 ^℃
May, 09 2024 09:00pm	25 ^℃
May, 10 2024 12:00am	19 ^℃
May, 10 2024 03:00am	20 ^℃
May, 10 2024 06:00am	20 ^℃
May, 10 2024 09:00am	20 ^℃
May, 10 2024 12:00pm	21 ^℃
May, 10 2024 03:00pm	26 ^℃
May, 10 2024 06:00pm	24 ^℃
May, 10 2024 09:00pm	22 ^℃
May, 11 2024 12:00am	21 ^℃
May, 11 2024 03:00am	18 ^℃
May, 11 2024 06:00am	15 ^℃
May, 11 2024 09:00am	13 ^℃
May, 11 2024 12:00pm	14 ^℃
May, 11 2024 03:00pm	18 ^℃
May, 11 2024 06:00pm	20 ^℃
May, 11 2024 09:00pm	18 ^℃

2	SELECT * FROM `item` WHERE url = 'joan-rife-real-estate-2' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30966') LIMIT 1
8	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('150367')
1	SELECT * FROM `category` WHERE id IN ('189','214') LIMIT 2
3	SELECT * FROM `locality` WHERE url = 'newport-nc' LIMIT 1
3	SELECT * FROM `region` WHERE id = 66 LIMIT 1
0	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 150367 AND `date` < '2024-05-09 18:08:57' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('150367')
2	SELECT * FROM `item` WHERE id IN ('150369','64755','149961','148631','149403','64791') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30966') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('64755','64791','148631','149403','149961','150369')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('64755','64791','148631','149403','149961','150369')
0	SELECT * FROM `category` WHERE id IN ('189','222','219','240','208','212','190','214') 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
3	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 ('30559','31247') LIMIT 2
1	SELECT * FROM `photos` WHERE `item_id` IN ('235103','235104','235105','235106','235107','235108','235109','235110')
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
1	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'