Clean & Quality Cars

Full information about place - Establishment and car dealer "Clean & Quality Cars" at 390 West Market Street, Smithfield, NC 27577. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 919-938-2838

Address:
390 West Market Street, Smithfield, NC 27577
Get directions

Categories:
Establishment Car dealer

Suggest changes

Reviews about Clean & Quality Cars

Sorry, but now we haven't any revews.

Add new review

Photos and maps

Nearest places

St Paul's Church
Establishment, Church, Place of worship

218 South 2nd Street, Smithfield, NC 27577

+1 919-934-2675

stpaulssmithfield.dionc.org
Riverside Realty
Establishment, Real estate agency

116 West Riverside Drive, Smithfield, NC 27577

+1 919-934-2508
Spence & Spence
Establishment, Lawyer

★ ☆ ☆ ☆ ☆

1 reviews

212 South 2nd Street, Smithfield, NC 27577

+1 919-934-1149

sstlaw.com
Riverside Resources Llc
Establishment, General contractor

101 East Riverside Drive, Smithfield, NC 27577

+1 919-989-6157

riverside-resources.com
Johnston County Human Resource
Establishment, Local government office

204 South 2nd Street, Smithfield, NC 27577

+1 919-938-4700

johnstonnc.com
Riverside Cemetery
Establishment, Cemetery

Smithfield, Smithfield, NC 27577

Weather in Smithfield, NC

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

1	SELECT * FROM `item` WHERE url = 'clean-quality-cars' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('31117') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('230716')
0	SELECT * FROM `category` WHERE id IN ('189','220') LIMIT 2
0	SELECT * FROM `locality` WHERE url = 'smithfield-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
0	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 230716 AND `date` < '2024-05-09 15:22:43' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('230716')
2	SELECT * FROM `item` WHERE id IN ('172973','304103','173058','129963','186745','263558') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('31117') LIMIT 1
0	SELECT * FROM `photos` WHERE `item_id` IN ('129963','172973','173058','186745','263558','304103')
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('129963','172973','173058','186745','263558','304103')
0	SELECT * FROM `category` WHERE id IN ('189','200','201','214','221','222','192','199') LIMIT 8
0	SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
4	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
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30783','31020','30750','30811') LIMIT 4
1	SELECT * FROM `photos` WHERE `item_id` IN ('215204','215205','215206','215207','215208','215209','215210','215211')
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'