Prudential Prime Properties: Bishop Bob

Full information about place - Establishment and real estate agency "Prudential Prime Properties: Bishop Bob" at 1704 East Arlington Boulevard # E, Greenville, NC 27858. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 252-321-9907

Address:
1704 East Arlington Boulevard # E, Greenville, NC 27858
Get directions

Categories:
Establishment   Real estate agency  

Suggest changes

Click to load full map
 

Reviews about Prudential Prime Properties: Bishop Bob

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Prudential Prime Properties: Bishop Bob

Nearest places

  • Lidl
    Establishment, Home goods store, Supermarket
    ★ ★ ★ ★ ★
    1 reviews
    1800 East Fire Tower Road, Greenville, NC 27858
    +1 844-747-5435
    lidl.com
  • Shell Rapid Lube
    Establishment, Car repair, Car wash
    ★ ★ ★ ★ ★
    1 reviews
    1625 East Fire Tower Road, Greenville, NC 27858
    +1 252-321-6064
  • Sheetz
    Establishment, Gas station
    ★ ★ ★ ★ ★
    2 reviews
    2100 County Home Road, Greenville, NC 27858
    +1 252-353-9021
    sheetz.com
  • Harris Teeter Fuel
    Establishment, Gas station
    1900 East Fire Tower Road, Greenville, NC 27858
    locations.harristeeter.com
  • Arby's
    Establishment, Food, Restaurant
    ★ ★ ★ ★ ★
    1 reviews
    1884 East Fire Tower Road, Greenville, NC 27858
    +1 252-355-3706
    locations.arbys.com
  • ATM M&t Bank
    Establishment, Atm, Finance, Bank
    2100 County Home Road, Greenville, NC 27858
    +1 800-627-3999

Weather in Greenville, NC

May, 09 2024 03:00am 26 ℃
May, 09 2024 06:00am 23 ℃
May, 09 2024 09:00am 20 ℃
May, 09 2024 12:00pm 21 ℃
May, 09 2024 03:00pm 24 ℃
May, 09 2024 06:00pm 25 ℃
May, 09 2024 09:00pm 26 ℃
May, 10 2024 12:00am 21 ℃
May, 10 2024 03:00am 19 ℃
May, 10 2024 06:00am 18 ℃
May, 10 2024 09:00am 19 ℃
May, 10 2024 12:00pm 21 ℃
May, 10 2024 03:00pm 25 ℃
May, 10 2024 06:00pm 18 ℃
May, 10 2024 09:00pm 23 ℃
May, 11 2024 12:00am 20 ℃
May, 11 2024 03:00am 16 ℃
May, 11 2024 06:00am 14 ℃
May, 11 2024 09:00am 12 ℃
May, 11 2024 12:00pm 13 ℃
May, 11 2024 03:00pm 16 ℃
May, 11 2024 06:00pm 17 ℃
May, 11 2024 09:00pm 18 ℃
1SELECT * FROM `item` WHERE url = 'prudential-prime-properties-bishop-bob' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30751') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('357325')
0SELECT * FROM `category` WHERE id IN ('189','214') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'greenville-nc' LIMIT 1
0SELECT * FROM `region` WHERE id = 66 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 357325 AND `date` < '2024-05-09 15:25:36' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('357325')
1SELECT * FROM `item` WHERE id IN ('284556','209179','223527','356132','232920','223515') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30751') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('209179','223515','223527','232920','284556','356132')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('209179','223515','223527','232920','284556','356132')
0SELECT * FROM `category` WHERE id IN ('189','208','230','213','248','223','219','228','206','207','210') LIMIT 11
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
3SELECT * 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
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('31036','30795','30623') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('285887','285888','285889','285890','285891','285892','285893','285894')
0SELECT * 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
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'locality'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'item'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'reviews'
0SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos'