Lazy Lyons Auction

Full information about place - Establishment "Lazy Lyons Auction" at 100 Lathem Street, Cedar Point, NC 28584. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Website:
auctionzip.com

Phone number:
+1 252-393-2535

Address:
100 Lathem Street, Cedar Point, NC 28584
Get directions

Categories:
Establishment

Suggest changes

Reviews about Lazy Lyons Auction

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

The Packhouse
Establishment, Home goods store

1036 Cedar Point Boulevard, Cedar Point, NC 28584

facebook.com
Boro Girl
Establishment, Home goods store

1036 Cedar Point Boulevard, Cedar Point, NC 28584

Closed now: Until 10:00am
Lazy Lyons Antiques & Auctions
Establishment, Home goods store

★ ★ ★ ★ ☆

1 reviews

1042 Cedar Point Boulevard, Swansboro, NC 28584

+1 252-393-2535

auctionzip.com

Closed now:
Sweet Potatoes Vintage
Establishment, Home goods store

1042 Cedar Point Boulevard, Cedar Point, NC 28584

+1 252-393-1200
Red House Antiques
Establishment, Shopping mall

1036 Cedar Point Boulevard, Cedar Point, NC 28584

+1 910-389-4043

Open now: Until 05:00pm
Dean's Gas Co Inc
Establishment

1026 Cedar Point Boulevard, Cedar Point, NC 28584

+1 252-393-1420

Weather in Cedar Point, NC

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

1	SELECT * FROM `item` WHERE url = 'lazy-lyons-auction' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30588') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('474419')
0	SELECT * FROM `category` WHERE id IN ('189') LIMIT 1
0	SELECT * FROM `locality` WHERE url = 'cedar-point-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 474419 AND `date` < '2024-05-09 13:10:15' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('474419')
1	SELECT * FROM `item` WHERE id IN ('199731','364203','364298','364220','364308','475807') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30588','31162') LIMIT 2
0	SELECT * FROM `photos` WHERE `item_id` IN ('199731','364203','364220','364298','364308','475807')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('199731','364203','364220','364298','364308','475807')
0	SELECT * FROM `category` WHERE id IN ('189','208','251') LIMIT 3
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 ('30780','30802','30750','30725','30972') LIMIT 5
0	SELECT * FROM `photos` WHERE `item_id` IN ('391797','391798','391799','391800','391801','391802','391803','391804')
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'