Law Offices of John A Balent at 110 West Fir Street #4, Brea, California.

We present you the complete information about the company Law Offices of John A Balent — Establishment and lawyer at 110 West Fir Street #4, Brea, California: contacts, photos, working hours, social networks and other information.

Contacts

Update

Reviews

Unfortunately, now, we have no reviews ...

Write a review

Photos

The nearest companies

Law Offices of John A Balent on the map

Opening hours

Monday 09:00 AM — 05:00 PM
Tuesday 09:00 AM — 05:00 PM
Thursday 09:00 AM — 05:00 PM

Weather in Brea, California

May, 09 2024 03:00 AM 21 ℃
May, 09 2024 06:00 AM 18 ℃
May, 09 2024 09:00 AM 15 ℃
May, 09 2024 12:00 PM 15 ℃
May, 09 2024 03:00 PM 16 ℃
May, 09 2024 06:00 PM 21 ℃
May, 09 2024 09:00 PM 25 ℃
May, 10 2024 12:00 AM 23 ℃
May, 10 2024 03:00 AM 19 ℃
May, 10 2024 06:00 AM 17 ℃
May, 10 2024 09:00 AM 16 ℃
May, 10 2024 12:00 PM 16 ℃
May, 10 2024 03:00 PM 17 ℃
May, 10 2024 06:00 PM 23 ℃
May, 10 2024 09:00 PM 26 ℃
May, 11 2024 12:00 AM 24 ℃
May, 11 2024 03:00 AM 20 ℃
May, 11 2024 06:00 AM 18 ℃
May, 11 2024 09:00 AM 17 ℃
May, 11 2024 12:00 PM 16 ℃
May, 11 2024 03:00 PM 17 ℃
May, 11 2024 06:00 PM 22 ℃
May, 11 2024 09:00 PM 26 ℃

-------------------- DUMP DATA --------------------
0.2122499942779541
---------------------------------------------------
3SELECT * FROM `item` WHERE url = 'law-offices-john-balent' LIMIT 1
5SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('12893') LIMIT 1
8SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('479177')
0SELECT * FROM `category` WHERE id IN ('189','221') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'brea-ca' LIMIT 1
0SELECT * FROM `region` WHERE id = 37 LIMIT 1
7SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 479177 AND `date` < '2024-05-09 16:56:14' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('479177')
5SELECT * FROM `item` WHERE id IN ('479041','548654','216927','216881','478520','547524') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('12893') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('216881','216927','478520','479041','547524','548654')
3SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('216881','216927','478520','479041','547524','548654')
2SELECT * FROM `category` WHERE id IN ('189','221','235','236','190','206','207') LIMIT 7
7SELECT * FROM counts where updated="2024-05-09" and table_name like 'news'
15SELECT * 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 12
1SELECT * FROM `item` WHERE `id` IN ('533379','533380','533381','533382','533383','533384','533385','533386','533387','533388','533389','533390')
0SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
11SELECT * FROM `locality` WHERE id IN ('13092','13496','13906','12844') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('533379','533380','533381','533382','533383','533384','533385','533386','533387','533388','533389','533390')
5SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('533379','533380','533381','533382','533383','533384','533385','533386','533387','533388','533389','533390')
0SELECT * FROM `category` WHERE id IN ('189','214','222','207','218','219','208','212','191','217','224') LIMIT 11
21SELECT * 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 6
3SELECT * FROM `region` WHERE id IN ('37') LIMIT 1
3SELECT * FROM `category_item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `category_item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('12806','12801','12781') LIMIT 3
0SELECT * FROM `category` WHERE id IN ('226') LIMIT 1
0SELECT * FROM ip_stat WHERE ip="3.135.200.211"
4INSERT INTO ip_stat(ip,count) VALUES("3.135.200.211",1)