First Star

Full information about place - Establishment and car dealer "First Star" at 3214 North Tryon Street, Charlotte, NC 28206. You may find here reviews, address, phone number, website, work hours and etc.

Contacts

Phone number:
+1 704-377-1077

Address:
3214 North Tryon Street, Charlotte, NC 28206
Get directions

Categories:
Establishment Car dealer

Suggest changes

Reviews about First Star

Mr. Good fella

Dec, 04 2017

★ ★ ★ ★ ★

Nice people

Add new review

Photos and maps

Nearest places

The Learning Collaborative
Establishment, School

3241 Sam Drenan Road, Charlotte, NC 28205

+1 704-377-8076

tlccharlotte.org
Fifth Third Bank & ATM
Establishment, Atm, Finance, Bank

3123 North Davidson Street, Charlotte, NC 28205

+1 704-247-2940

locations.53.com
Seigle Avenue Preschool
Establishment, School

3045 North Davidson Street, Charlotte, NC 28205

+1 704-377-8076

tlccharlotte.org
Queen City church of Christ
Establishment, Church, Place of worship

3025 North Davidson Street, Charlotte, NC 28205

qcchurch.com

Closed now:
Central Piedmont Community
Establishment

3025 North Davidson Street, Charlotte, NC 28205

+1 704-716-6350

cpcc.edu
CMC Health Ctr-Johnston YMCA
Establishment, Health

3025 North Davidson Street, Charlotte, NC 28205

+1 704-716-6385

ymcacharlotte.org

Weather in Charlotte, NC

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

1	SELECT * FROM `item` WHERE url = 'first-star' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30593') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('316043')
0	SELECT * FROM `category` WHERE id IN ('189','220') LIMIT 2
0	SELECT * FROM `locality` WHERE url = 'charlotte-nc' LIMIT 1
0	SELECT * FROM `region` WHERE id = 66 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 316043 AND `date` < '2024-05-09 12:33:16' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('316043')
2	SELECT * FROM `item` WHERE id IN ('165562','320230','485318','408841','463543','165783') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('30593') LIMIT 1
1	SELECT * FROM `photos` WHERE `item_id` IN ('165562','165783','320230','408841','463543','485318')
2	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('165562','165783','320230','408841','463543','485318')
0	SELECT * FROM `category` WHERE id IN ('189','190','206','207','210','200','201','191') LIMIT 8
4	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
4	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 ('30477','31109','30702') LIMIT 3
0	SELECT * FROM `photos` WHERE `item_id` IN ('376618','376619','376620','376621','376622','376623','376624','376625')
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'