ASSOCIATED Real Estate Brokers, Inc.

Full information about place - Establishment and real estate agency "ASSOCIATED Real Estate Brokers, Inc." at Main St, Louisburg, NC 27549. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 919-426-4695

Address:
Main St, Louisburg, NC 27549
Get directions

Categories:
Establishment Real estate agency

Suggest changes

Reviews about ASSOCIATED Real Estate Brokers, Inc.

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

Evertees Clothing
Establishment

122 Winn Drive, Louisburg, NC 27549

evertees.clothing

Closed now: Until 05:00pm
Faith Works Stonemason
Establishment, General contractor

605 Fox Ridge Road, Louisburg, NC 27549

+1 919-623-2452

Open now: Until 08:00pm
In & Out Home Maintenance
Establishment, Home goods store, General contractor

114 Winn Drive, Louisburg, NC 27549

+1 919-761-0046
DO For You Handyman Services
Establishment, General contractor

108 Briarcliff Circle, Louisburg, NC 27549

+1 919-554-2678
Dunn's Plumbing & Repair
Establishment, Plumber

125 North Creek Drive, Louisburg, NC 27549

+1 919-556-5319
Corry Tree Services
Establishment

117 South Creek Drive, Louisburg, NC 27549

+1 919-272-0407

Open now: Open 24 Hours

Weather in Louisburg, NC

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

1	SELECT * FROM `item` WHERE url = 'associated-real-estate-brokers-inc' LIMIT 1
3	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30872') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('23826')
2	SELECT * FROM `category` WHERE id IN ('189','214') LIMIT 2
2	SELECT * FROM `locality` WHERE url = 'louisburg-nc' LIMIT 1
2	SELECT * FROM `region` WHERE id = 66 LIMIT 1
0	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 23826 AND `date` < '2024-05-09 16:42:17' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('23826')
4	SELECT * FROM `item` WHERE id IN ('434894','23789','293381','157383','157794','24226') LIMIT 6
1	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30872') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('23789','24226','157383','157794','293381','434894')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('23789','24226','157383','157794','293381','434894')
0	SELECT * FROM `category` WHERE id IN ('189','222','208','255') LIMIT 4
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
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
1	SELECT * FROM `locality` WHERE id IN ('30750') LIMIT 1
1	SELECT * FROM `photos` WHERE `item_id` IN ('332494','332495','332496','332497','332498','332499','332500','332501')
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'
2	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'