You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
auto_service.id | auto_service.ts | auto_service.title | auto_service.website | auto_service.telephone | auto_service.address | auto_service.postal_code | auto_service.latitude | auto_service.longitude | auto_service.email | auto_service.opening_hours | auto_service.description | auto_service.amenity | auto_service.reviews | auto_service.average_star | auto_service.service_product | auto_service.accreditation | auto_service.auto_service_detail_id | auto_service.auto_service_menu_id | auto_service.brand_x_auto_service_id | auto_service.category_x_auto_service_id | auto_service.city_x_auto_service_id | auto_service.image_slug_id | auto_service.payment_x_auto_service_id | auto_service.review_id | auto_service._image_slug_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2023-10-18 09:05:07 | Serra Toyota | http://www.serratoyota.com | 205-838-4400 | 1300 Center Point Pkwy, Birmingham, AL, 35215 | 35215 | 33.620243 | -86.685265 | sales@serratoyota.com | "Mo-Fr 08:30-19:30","Sa 08:30-19:00" | {} | {} | { "1": { "brand_x_auto_service.id": 1, "brand.id": 1, "brand.ts": "2023-10-18 09:05:07", "brand.brand": "Toyota" } } | {
"1": {
"category_x_auto_service.id": 1,
"category.id": 1,
"category.ts": "2023-10-18 09:05:07",
"category.category": "New Car Dealers"
},
"2": {
"category_x_auto_service.id": 2,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"3": {
"category_x_auto_service.id": 3,
"category.id": 3,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Car Rental"
},
"4": {
"category_x_auto_service.id": 4,
"category.id": 4,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Used Car Dealers"
}
} |
{ "1": { "city_x_auto_service.id": 1, "city.id": 1, "city.ts": "2023-10-15 04:01:17", "city.city": "Birmingham", "state.id": 1, "state.ts": "2023-10-15 03:33:45", "state.state": "Alabama" } } | {
"1": {
"image_slug.id": 1,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"1": {
"image.id": 1,
"image.ts": "2023-11-15 06:02:11",
"image.source_url": "https://i4.ypcdn.com/blob/9143df5f6ba2f6cb544a9ba71c24054ff94b7a2d_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "a82dc0e75fb4b2f2adc0aa59188a2aef5d93a5fa",
"image.size": 211994,
"image.path": "/a8/2d/c0/e7/a82dc0e75fb4b2f2adc0aa59188a2aef5d93a5fa.jpg",
"image.title": ""
}
}
}
} |
{
"1": {
"payment_x_auto_service.id": 1,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"2": {
"payment_x_auto_service.id": 2,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"3": {
"payment_x_auto_service.id": 3,
"payment.id": 3,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "FINANCING AVAILABLE"
},
"4": {
"payment_x_auto_service.id": 4,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"5": {
"payment_x_auto_service.id": 5,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"6": {
"payment_x_auto_service.id": 6,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"7": {
"payment_x_auto_service.id": 7,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"8": {
"payment_x_auto_service.id": 8,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{
"1": {
"review.id": 1,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Thanks for your help today. Morgan Smith was exceptional.",
"review.author": "Billy L.",
"review.time": "18 days ago",
"review.rating_stars": "five",
"review.collect": "1"
},
"2": {
"review.id": 2,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Morgan Smith and Serra Toyota is who you want to see and where you want to go to get your next new or preowned vehicle! Everyone was very friendly and courteous with our time and worked diligently to get me in the right vehicle at the right price!",
"review.author": "Keith C.",
"review.time": "20 days ago",
"review.rating_stars": "five",
"review.collect": "1"
},
"3": {
"review.id": 3,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Morgan in sales is the best! Also their Service department is top notch!",
"review.author": "Pam R.",
"review.time": "22 days ago",
"review.rating_stars": "five",
"review.collect": "1"
},
"4": {
"review.id": 4,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Devin Davis was a wonderful car sales represenetive! He helped during business hours and after just to make sure I had everything I needed and more! Definitely go to Serra Toyota in Birmingham! Ask for Devin!",
"review.author": "Payton B.",
"review.time": "05/02/23",
"review.rating_stars": "five",
"review.collect": "1"
},
"5": {
"review.id": 5,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Very knowledgeable, very helpful, and sweet (Aubrey Whitt). He helped me choose the right car that fit my needs. I definitely recommend him if anyone needs or want a car.",
"review.author": "Electra L.",
"review.time": "04/26/22",
"review.rating_stars": "five",
"review.collect": "1"
},
"6": {
"review.id": 6,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Highly recommend Trevor with Serra Toyota! After speaking with several dealerships across Alabama, Georgia and Tennessee- Trevor was so eager and helpful in finding exactly what I wanted. After our initial conversation, I knew I had found the right person. He got me all my “wants,” while still managing to stay within my budget. He also kept me updated while I anxiously awaited for its arrival. Less than 24 hours of my car arriving to the dealership- it was delivered to my home!",
"review.author": "Jessica T.",
"review.time": "07/27/21",
"review.rating_stars": "five",
"review.collect": "1"
},
"7": {
"review.id": 7,
"review.ts": "2023-10-18 09:05:07",
"review.review": "We use Serra Toyota for all vehicles in the family, and we have for years. We have never been disappointed in a purchase, and are always blown away by the professionalism, and the services they provide. Morgan is the man!",
"review.author": "James J.",
"review.time": "08/31/20",
"review.rating_stars": "five",
"review.collect": "1"
},
"8": {
"review.id": 8,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Michael Sides was very nice and helpful. If I ever need another car I will be back because of Michael Sides good customer service. Thank you",
"review.author": "Corolla G.",
"review.time": "04/11/20",
"review.rating_stars": "five",
"review.collect": "1"
},
"9": {
"review.id": 9,
"review.ts": "2023-10-18 09:05:07",
"review.review": "In the past, buying a car was always a painful process with an overbearing, pushy salesperson. But not this time! Ron Babice at Serra Toyota was amazing, patient & so helpful! I will definitely recommend him and Serra Toyota to my family & friends in search of buying a car. I will also be back in the future to buy another car from Ron! Thank you so much for such a pleasant car buying experience!",
"review.author": "Natalie S.",
"review.time": "02/14/20",
"review.rating_stars": "five",
"review.collect": "1"
},
"10": {
"review.id": 10,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Shaun was amazing! I knew exactly what I wanted walking in the door and he made sure that I got that by the time I walked back out the door. If you’re in the market for a car, stop by and see him. You won’t be disappointed!",
"review.author": "Amanda L.",
"review.time": "01/29/20",
"review.rating_stars": "five",
"review.collect": "1"
},
"11": {
"review.id": 11,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Michael sides made it very simple . He worked with me on my credit and I really appreciated him taking his time on helping me.",
"review.author": "Kelley G.",
"review.time": "01/15/20",
"review.rating_stars": "five",
"review.collect": "1"
},
"12": {
"review.id": 12,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Michael Sides, quick communication and professional. Does a good job finding the right car to fit your budget. Works hard to keep the process quick",
"review.author": "Allen S.",
"review.time": "01/06/20",
"review.rating_stars": "five",
"review.collect": "1"
},
"13": {
"review.id": 13,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Michael Sides works hard and will get you a great deal! He communicates fast and gets you in the vehicle you're searching for. Ask for him",
"review.author": "Alex S.",
"review.time": "01/06/20",
"review.rating_stars": "five",
"review.collect": "1"
},
"14": {
"review.id": 14,
"review.ts": "2023-10-18 09:05:07",
"review.review": "MICHAEL sides very awesome guy fits your needs for whatever car your looking into and also..he is very customer friendly best dealer I’ve dealt with in years very impressive :)Thank Serra",
"review.author": "Bobby P.",
"review.time": "11/30/19",
"review.rating_stars": "five",
"review.collect": "1"
},
"15": {
"review.id": 15,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Michael Sides, was an exceptional sales representative at Serra Toyota! Definitely referring him to my friends and family when ever anyone is looking to buy a car",
"review.author": "Jeremy P.",
"review.time": "11/30/19",
"review.rating_stars": "five",
"review.collect": "1"
},
"16": {
"review.id": 16,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Michael sides was a great salesman everyone there tooo good care of me and he got me a great dealHe made sure I got the perfect car",
"review.author": "Kolton S.",
"review.time": "11/02/19",
"review.rating_stars": "five",
"review.collect": "1"
},
"17": {
"review.id": 17,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Michael Sides was very professional and persistant with helping me getout of a junker into a nice new ride. Will recommend.",
"review.author": "Alexander N.",
"review.time": "09/27/19",
"review.rating_stars": "five",
"review.collect": "1"
},
"18": {
"review.id": 18,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Great service, Richie was very personable and went the extra mile to help us out. We were able to complete everything while out of town and he even brought the truck to my home when I wasn’t able to get to the dealership. Thank you for all of your help!",
"review.author": "Erin P.",
"review.time": "08/04/19",
"review.rating_stars": "five",
"review.collect": "1"
},
"19": {
"review.id": 19,
"review.ts": "2023-10-18 09:05:07",
"review.review": "Very happy customer Michael Sides was great Calvin Smith was also great! Really did a great job! Will i return? Yes!",
"review.author": "Peggy S.",
"review.time": "07/30/19",
"review.rating_stars": "five",
"review.collect": "1"
},
"20": {
"review.id": 20,
"review.ts": "2023-10-18 09:05:07",
"review.review": "My salesperson, Lani, was amazing! I was worried the car I wanted would sell before I could get to my appointment so she offered to do everything online and have them bring me the car almost 2 hours away. I didn’t know it was a possibility for them to bring the car to me. Great customer service and I LOVE my new car!",
"review.author": "Aaron W.",
"review.time": "05/28/19",
"review.rating_stars": "five",
"review.collect": "1"
}
} |
{ "1": { "_image_slug.id": 1, "_image_slug.ts": "2023-10-18 09:05:07" }, "2": { "_image_slug.id": 2, "_image_slug.ts": "2023-10-18 09:05:07" }, "3": { "_image_slug.id": 3, "_image_slug.ts": "2023-10-18 09:05:07" }, "4": { "_image_slug.id": 4, "_image_slug.ts": "2023-10-18 09:05:07" } } | ||||||
2 | 2023-11-06 23:37:57 | Rob'e Mans Automotive Service | http://www.robemans.com | 205-871-4712 | 2600 18th Street South, Birmingham, AL, 35209 | 35209 | 33.483524 | -86.79203 | info@robemans.com | "Mo-Th 07:00-17:30","Fr 07:00-17:00" | We are a family owned and operated Honda, Acura, Nissan, Infiniti, Toyota and Lexus repair facility with 24 month or 24,000 mile warranty on most items. We take pride in delivering a higher level of quality service. ABOUT US.....As childhood friends, Eddi | Complimentary Shuttle ServiceComplimentary Coffee from our Coffee BarFree WifiFlat Screen TV'sMonthly Promotions | 1 | 5 | Air Conditioning, Alignment, Alternator Repair, Axle and Wheel Bearings, Battery and Charging Systems, Belts and Hoses, Brakes and Tire Repair, Clutch Replacements, Coolant System Work, Electronic Diagnosis and Repair, Engine Repairs, Factory Scheduled Ma | ATIAssociationsMember of the Better Business BureauMember of the Homewood Chamber of CommerceMember of Mountain Brook Chamber of CommerceMember of Vestavia Hills Chamber of CommerceAKARob'e MansOther Linkhttp://www.robemans.comOther InformationWarranties: YesParking: LotServices: Air Conditioning & Heating, Tires, Wheels & Alignments, Fuel, Emission & Exhaust Systems, Inspection & Diagnostic Services, Transmission & Drive Train Services, Battery Services, Cooling Systems, Major Engine Repair or Replacement, Engine Service, Brake Service, Scheduled Maintenance & Tune Ups, Oil Changes, Ignition & Electrical SystemsShuttle Service: YesBrands Serviced: Lexus, Toyota, Acura, Subaru, Honda, Infiniti, Nissan, HyundaiAppointment Needed: Yes |
{
"1": {
"auto_service_detail.id": 1,
"auto_service_detail.ts": "2023-10-18 09:07:49",
"auto_service_detail.key": "Warranties",
"auto_service_detail.value": "Yes"
},
"2": {
"auto_service_detail.id": 2,
"auto_service_detail.ts": "2023-10-18 09:07:49",
"auto_service_detail.key": "Parking",
"auto_service_detail.value": "Lot"
},
"3": {
"auto_service_detail.id": 3,
"auto_service_detail.ts": "2023-10-18 09:07:49",
"auto_service_detail.key": "Services",
"auto_service_detail.value": "Air Conditioning & Heating, Tires, Wheels & Alignments, Fuel, Emission & Exhaust Systems, Inspection & Diagnostic Services, Transmission & Drive Train Services, Battery Services, Cooling Systems, Major Engine Repair or Replacement, Engine Service, Brake S"
},
"4": {
"auto_service_detail.id": 4,
"auto_service_detail.ts": "2023-10-18 09:07:49",
"auto_service_detail.key": "Shuttle Service",
"auto_service_detail.value": "Yes"
},
"5": {
"auto_service_detail.id": 5,
"auto_service_detail.ts": "2023-10-18 09:07:49",
"auto_service_detail.key": "Brands Serviced",
"auto_service_detail.value": "Lexus, Toyota, Acura, Subaru, Honda, Infiniti, Nissan, Hyundai"
},
"6": {
"auto_service_detail.id": 6,
"auto_service_detail.ts": "2023-10-18 09:07:49",
"auto_service_detail.key": "Appointment Needed",
"auto_service_detail.value": "Yes"
}
} |
{
"1": {
"auto_service_menu.id": 1,
"auto_service_menu.ts": "2023-11-12 21:55:13",
"auto_service_menu.category": "Engine and Exhaust System",
"auto_service_menu.auto_service_menu_detail_id": {
"1": {
"auto_service_menu_detail.id": 1,
"auto_service_menu_detail.ts": "2023-11-12 21:55:13",
"auto_service_menu_detail.title": "Engine Repair",
"auto_service_menu_detail.description": ""
},
"2": {
"auto_service_menu_detail.id": 2,
"auto_service_menu_detail.ts": "2023-11-12 21:55:13",
"auto_service_menu_detail.title": "Oil Change",
"auto_service_menu_detail.description": ""
},
"3": {
"auto_service_menu_detail.id": 3,
"auto_service_menu_detail.ts": "2023-11-12 21:55:13",
"auto_service_menu_detail.title": "Alternator Repair",
"auto_service_menu_detail.description": ""
},
"4": {
"auto_service_menu_detail.id": 4,
"auto_service_menu_detail.ts": "2023-11-12 21:55:13",
"auto_service_menu_detail.title": "Timing Belt/Chain Replacement",
"auto_service_menu_detail.description": ""
}
}
},
"2": {
"auto_service_menu.id": 2,
"auto_service_menu.ts": "2023-11-12 21:55:13",
"auto_service_menu.category": "Transmission and Drivetrain",
"auto_service_menu.auto_service_menu_detail_id": {
"5": {
"auto_service_menu_detail.id": 5,
"auto_service_menu_detail.ts": "2023-11-12 21:55:13",
"auto_service_menu_detail.title": "Transmission Service",
"auto_service_menu_detail.description": ""
}
}
},
"3": {
"auto_service_menu.id": 3,
"auto_service_menu.ts": "2023-11-12 21:55:13",
"auto_service_menu.category": "Brakes",
"auto_service_menu.auto_service_menu_detail_id": {
"6": {
"auto_service_menu_detail.id": 6,
"auto_service_menu_detail.ts": "2023-11-12 21:55:13",
"auto_service_menu_detail.title": "Brake Service",
"auto_service_menu_detail.description": ""
}
}
},
"4": {
"auto_service_menu.id": 4,
"auto_service_menu.ts": "2023-11-12 21:55:13",
"auto_service_menu.category": "Electrical and Electronic",
"auto_service_menu.auto_service_menu_detail_id": {
"7": {
"auto_service_menu_detail.id": 7,
"auto_service_menu_detail.ts": "2023-11-12 21:55:13",
"auto_service_menu_detail.title": "Battery Service",
"auto_service_menu_detail.description": ""
}
}
}
} |
{
"2": {
"brand_x_auto_service.id": 2,
"brand.id": 2,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "ACURA REPAIR"
},
"3": {
"brand_x_auto_service.id": 3,
"brand.id": 3,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "ACURA SERVICE"
},
"4": {
"brand_x_auto_service.id": 4,
"brand.id": 4,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "HONDA REPAIR"
},
"5": {
"brand_x_auto_service.id": 5,
"brand.id": 5,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "HONDA SERVICE"
},
"6": {
"brand_x_auto_service.id": 6,
"brand.id": 6,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "INFINITI REPAIR"
},
"7": {
"brand_x_auto_service.id": 7,
"brand.id": 7,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "INFINITI SERVICE"
},
"8": {
"brand_x_auto_service.id": 8,
"brand.id": 8,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "LEXUS REPAIR"
},
"9": {
"brand_x_auto_service.id": 9,
"brand.id": 9,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "LEXUS SERVICE"
},
"10": {
"brand_x_auto_service.id": 10,
"brand.id": 10,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "NISSAN REPAIR"
},
"11": {
"brand_x_auto_service.id": 11,
"brand.id": 11,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "NISSAN SERVICE"
},
"12": {
"brand_x_auto_service.id": 12,
"brand.id": 12,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "TOYOTA REPAIR"
},
"13": {
"brand_x_auto_service.id": 13,
"brand.id": 13,
"brand.ts": "2023-10-18 09:07:53",
"brand.brand": "TOYOTA SERVICE"
}
} |
{
"5": {
"category_x_auto_service.id": 5,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"6": {
"category_x_auto_service.id": 6,
"category.id": 6,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Auto Transmission"
},
"7": {
"category_x_auto_service.id": 7,
"category.id": 7,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Air Conditioning Equipment"
},
"8": {
"category_x_auto_service.id": 8,
"category.id": 8,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Parts & Supplies"
},
"9": {
"category_x_auto_service.id": 9,
"category.id": 9,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Brake Repair"
},
"10": {
"category_x_auto_service.id": 10,
"category.id": 10,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Recreational Vehicles & Campers-Storage"
},
"11": {
"category_x_auto_service.id": 11,
"category.id": 11,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Tire Dealers"
}
} |
{ "2": { "city_x_auto_service.id": 2, "city.id": 1, "city.ts": "2023-10-15 04:01:17", "city.city": "Birmingham", "state.id": 1, "state.ts": "2023-10-15 03:33:45", "state.state": "Alabama" } } | {
"5": {
"image_slug.id": 5,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"2": {
"image.id": 2,
"image.ts": "2023-11-15 06:03:11",
"image.source_url": "https://i1.ypcdn.com/blob/7a52c693c15c04d62ac25615116b6bcc41a7d77c_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "9fa6969e7746242877a3d335f1a14067958665de",
"image.size": 197719,
"image.path": "/9f/a6/96/9e/9fa6969e7746242877a3d335f1a14067958665de.jpg",
"image.title": ""
}
}
}
} |
{
"9": {
"payment_x_auto_service.id": 9,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"10": {
"payment_x_auto_service.id": 10,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"11": {
"payment_x_auto_service.id": 11,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"12": {
"payment_x_auto_service.id": 12,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"13": {
"payment_x_auto_service.id": 13,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"14": {
"payment_x_auto_service.id": 14,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"15": {
"payment_x_auto_service.id": 15,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{
"21": {
"review.id": 21,
"review.ts": "2023-10-18 09:07:49",
"review.review": "Fantastic service and very fast!",
"review.author": "anonymous",
"review.time": "01/15/14",
"review.rating_stars": "five",
"review.collect": ""
},
"22": {
"review.id": 22,
"review.ts": "2023-10-18 09:07:49",
"review.review": "super happy with they service thanks guys for everything.",
"review.author": "Esteban A.",
"review.time": "09/20/13",
"review.rating_stars": "five",
"review.collect": "2"
},
"23": {
"review.id": 23,
"review.ts": "2023-10-18 09:07:49",
"review.review": "The guys have taken care of my car for years with out any problems. I recently was out of town and went somewhere else and they messed up my car. When I got home and took it to Rob'e Mans, they fixed it and did not even charge me. My family and I appreciate their attention and consistent great service.Thanks again guys! See you soon.",
"review.author": "honda_chic",
"review.time": "11/03/10",
"review.rating_stars": "five",
"review.collect": "1"
},
"24": {
"review.id": 24,
"review.ts": "2023-10-18 09:07:49",
"review.review": "Rob'e Mans will not save you a lot of money over the dealer. But they will do quality work with Genuine Honda Parts every time. They worked on my 1986 Honda Accord several times and my 1988 Acura Legend. I would recommend them any time. Convenient Location just off US 31.",
"review.author": "wnedylee40",
"review.time": "07/14/10",
"review.rating_stars": "four",
"review.collect": "1"
},
"25": {
"review.id": 25,
"review.ts": "2023-10-18 09:07:49",
"review.review": "We took our Acura here because we thought it would be less expensive than the dealer. We were very happy with the service. They did everything we needed done, and without an appointment. They also got it done in a day. W",
"review.author": "tammygibson57",
"review.time": "07/14/10",
"review.rating_stars": "five",
"review.collect": "1"
}
} |
{ "5": { "_image_slug.id": 5, "_image_slug.ts": "2023-10-18 09:07:44" }, "6": { "_image_slug.id": 6, "_image_slug.ts": "2023-10-18 09:07:44" }, "7": { "_image_slug.id": 7, "_image_slug.ts": "2023-10-18 09:07:44" } } |
3 | 2023-11-06 23:38:06 | Carcare | http://www.carcarehonda.com | 205-733-8863 | 2048 Valleydale Ter, Birmingham, AL, 35244 | 35244 | 33.347824 | -86.79847 | carcare8644@bellsouth.net | "Mo-Fr 08:00-17:30" | We are a family owned and operated business, specializing in Honda, Acura , Toyota, Lexus,Hyundai, Kia, Nissan and Infiniti Maintenance and repair. We offer a two year 24.000 mile warranty on parts and labor. We offer free shuttle service within 15 miles. | We have a clean and comfortable waiting room and restroom, free bottled water and coffee and snacks, freeWi-Fi. We offer free shuttle service within 15 miles. | Brakes, air conditioning, oil and filter change, engine and transmission repair and all other needs to maintain vehicle, factory parts. 24 month/24,000 mile parts and labor warranty. Maintain your factory warranty here. | Automotive Training InstituteMembers of the Better Business BureauAssociationsASE CertifiedOther Linkhttp://www.carcarehonda.comOther InformationParking: LotWheelchair Accessible: Yes | {
"7": {
"auto_service_detail.id": 7,
"auto_service_detail.ts": "2023-10-18 09:08:06",
"auto_service_detail.key": "Parking",
"auto_service_detail.value": "Lot"
},
"8": {
"auto_service_detail.id": 8,
"auto_service_detail.ts": "2023-10-18 09:08:06",
"auto_service_detail.key": "Wheelchair Accessible",
"auto_service_detail.value": "Yes"
}
} |
{
"5": {
"auto_service_menu.id": 5,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "Engine and Exhaust System",
"auto_service_menu.auto_service_menu_detail_id": {
"8": {
"auto_service_menu_detail.id": 8,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Oil Change",
"auto_service_menu_detail.description": "From oil changes to complete engine overhaul, you can depend on our mechanics to service your Acura at a fraction of the dealership price."
},
"9": {
"auto_service_menu_detail.id": 9,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Exhaust System Repair",
"auto_service_menu_detail.description": ""
},
"10": {
"auto_service_menu_detail.id": 10,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Spark Plug Replacement",
"auto_service_menu_detail.description": ""
},
"11": {
"auto_service_menu_detail.id": 11,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Emissions Inspection",
"auto_service_menu_detail.description": ""
},
"12": {
"auto_service_menu_detail.id": 12,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Timing Belt/Chain Replacement",
"auto_service_menu_detail.description": ""
},
"13": {
"auto_service_menu_detail.id": 13,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Fuel Injection Service/Repair",
"auto_service_menu_detail.description": ""
}
}
},
"6": {
"auto_service_menu.id": 6,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "Transmission and Drivetrain",
"auto_service_menu.auto_service_menu_detail_id": {
"14": {
"auto_service_menu_detail.id": 14,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Transmission Service",
"auto_service_menu_detail.description": "Using the latest in state-of-the-art technology, we will install a safe and effective cleaner to suspend harmful varnish and sludge from the transmission valve body, torque converter and lines and install new high-tech fluid with conditioners."
},
"15": {
"auto_service_menu_detail.id": 15,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Transmission Repair",
"auto_service_menu_detail.description": "Automatic transmissions work by transmitting power from the engine to the wheels through a fluid medium. This fluid also lubricates moving parts and cools the transmission. Over time, the fluid breaks down, becomes contaminated and needs to be serviced. During an Automatic Transmission Fluid Exchange Service, nearly 100% of your used transmission fluid is exchanged and replaced with new transmission fluid."
},
"16": {
"auto_service_menu_detail.id": 16,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Clutch Service/Repair",
"auto_service_menu_detail.description": ""
},
"17": {
"auto_service_menu_detail.id": 17,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Differential Service/Repair",
"auto_service_menu_detail.description": ""
},
"18": {
"auto_service_menu_detail.id": 18,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Axle Repair",
"auto_service_menu_detail.description": "If your vehicle is not turning as smoothly as usual or you are having problems stopping your car, you might need an axle repair. Bring your vehicle to CarCare, Inc. today so our team of experts can inspect and fix your vehicle’s axles. If your vehicle’s axles need to be replaced, we can help you find the best axles in NAPA’s inventory and install them for you so you can get back on the road quickly."
}
}
},
"7": {
"auto_service_menu.id": 7,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "Steering and Suspension",
"auto_service_menu.auto_service_menu_detail_id": {
"19": {
"auto_service_menu_detail.id": 19,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Suspension Service/Repair",
"auto_service_menu_detail.description": ""
},
"20": {
"auto_service_menu_detail.id": 20,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Steering Service/Repair",
"auto_service_menu_detail.description": "Your vehicle’s axles are vital to keeping you safe on the road. They are just as important as other safety devices on your vehicle, such as brakes and tires. Axles bear all of your vehicle’s weight. They connect its wheels and help drive the vehicle. In most cars, the axles are an essential part of the steering system, working with power steering fluid and other components to ensure smooth turning."
},
"21": {
"auto_service_menu_detail.id": 21,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Steering Fluid Service",
"auto_service_menu_detail.description": "Our technicians use a powerful cleaner to dissolve gum and varnish in your car’s power steering unit. Next, we will flush old, worn-out contaminated fluid and install fresh new fluid fortified with a special antioxidant and anti-wear ingredients to prevent expensive mechanical failure."
}
}
},
"8": {
"auto_service_menu.id": 8,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "Heating and Cooling",
"auto_service_menu.auto_service_menu_detail_id": {
"22": {
"auto_service_menu_detail.id": 22,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Air Conditioning Service/Repair",
"auto_service_menu_detail.description": "When you start your vehicle’s air conditioning system, the compressor works by putting the refrigerant under pressure, sending it to the condensing coils, which are generally in front of your vehicle’s radiator. The condenser expels hot air to outside the car, cooling the air within the vehicle. When this happens, the refrigerant is cooled, and it changes form a gas to a liquid, which then passes through the expansion valve and to the evaporator."
},
"23": {
"auto_service_menu_detail.id": 23,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Radiator Service/Repair",
"auto_service_menu_detail.description": ""
},
"24": {
"auto_service_menu_detail.id": 24,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Air Filter Replacement",
"auto_service_menu_detail.description": ""
}
}
},
"9": {
"auto_service_menu.id": 9,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "Tires",
"auto_service_menu.auto_service_menu_detail_id": {
"25": {
"auto_service_menu_detail.id": 25,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Tire Rotation",
"auto_service_menu_detail.description": "Tire rotation: This helps ensure even wear on your tires, which can help prevent blowouts and leaking. It also helps make your ride smoother."
},
"26": {
"auto_service_menu_detail.id": 26,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Wheel Alignment",
"auto_service_menu_detail.description": "Follow the vehicle manufacturer’s recommendation noted in your owner’s manual. As a general rule, have your wheel alignment checked every 10,000 miles or at least once a year."
},
"27": {
"auto_service_menu_detail.id": 27,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Tire Replacement",
"auto_service_menu_detail.description": ""
},
"28": {
"auto_service_menu_detail.id": 28,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Tire Service",
"auto_service_menu_detail.description": "Improve your vehicle’s handling, increase tire life and drive with safety by checking your tires every month to ensure that they are inflated with the right amount of air pressure. We offer a wide range of tires for your vehicle. Let our professionals help you find, balance and mount the right tires for your car."
},
"29": {
"auto_service_menu_detail.id": 29,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Tire Inspection",
"auto_service_menu_detail.description": ""
},
"30": {
"auto_service_menu_detail.id": 30,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Tire Balancing",
"auto_service_menu_detail.description": "Tire balancing: Balancing your tires prevents wear, which can significantly improve their life and save you money."
}
}
},
"10": {
"auto_service_menu.id": 10,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "Brakes",
"auto_service_menu.auto_service_menu_detail_id": {
"31": {
"auto_service_menu_detail.id": 31,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Brake Service",
"auto_service_menu_detail.description": ""
},
"32": {
"auto_service_menu_detail.id": 32,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Brake Fluid Service",
"auto_service_menu_detail.description": ""
},
"33": {
"auto_service_menu_detail.id": 33,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Brake Repair",
"auto_service_menu_detail.description": "Our expert team offers brake repair in Birmingham specializing in Asian automobiles. Whether you need your brakes replaced or need a brake component repaired, you can trust us to help keep you safe on the road."
}
}
},
"11": {
"auto_service_menu.id": 11,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "Electrical and Electronic",
"auto_service_menu.auto_service_menu_detail_id": {
"34": {
"auto_service_menu_detail.id": 34,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Battery Service",
"auto_service_menu_detail.description": ""
},
"35": {
"auto_service_menu_detail.id": 35,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Electrical Service/Repair",
"auto_service_menu_detail.description": ""
}
}
},
"12": {
"auto_service_menu.id": 12,
"auto_service_menu.ts": "2023-11-12 21:55:22",
"auto_service_menu.category": "General",
"auto_service_menu.auto_service_menu_detail_id": {
"36": {
"auto_service_menu_detail.id": 36,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "General Repairs",
"auto_service_menu_detail.description": "Hondas are famous for their reliability and longevity, which may be why so many of our customers consider their Hondas to be a part of the family! Whether you’re approaching 100,000 or even 400,000 miles, our Honda specialists are here to help you get the most out of your car. We are happy to offer online scheduling, free shuttle service while your car is being serviced, after hours drop-off, and a 24 month/24,000 mile warranty on all labor and Auto Repairs."
},
"37": {
"auto_service_menu_detail.id": 37,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Auto Maintenance",
"auto_service_menu_detail.description": "The best way to prevent long-term and costly problems with your vehicle is to keep up with its preventative maintenance schedule. One major key to successfully making sure you are doing all you need to do is to read your vehicle’s owner’s manual. Regardless of your vehicle’s make or model, its owner’s manual will contain a maintenance schedule. Every make and model is different, and standby beliefs such as “You have to change your oil every 3,000 miles,” may not apply to your car."
},
"38": {
"auto_service_menu_detail.id": 38,
"auto_service_menu_detail.ts": "2023-11-12 21:55:22",
"auto_service_menu_detail.title": "Belts and Hoses Service",
"auto_service_menu_detail.description": ""
}
}
}
} |
{ "14": { "brand_x_auto_service.id": 14, "brand.id": 14, "brand.ts": "2023-10-18 09:08:06", "brand.brand": "OEM/factory parts" } } | {
"12": {
"category_x_auto_service.id": 12,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"13": {
"category_x_auto_service.id": 13,
"category.id": 13,
"category.ts": "2023-10-18 09:08:06",
"category.category": "Automobile Air Conditioning Equipment-Service & Repair"
}
} |
{
"3": {
"city_x_auto_service.id": 3,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"17810": {
"city_x_auto_service.id": 17810,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{
"8": {
"image_slug.id": 8,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"3": {
"image.id": 3,
"image.ts": "2023-11-15 06:03:28",
"image.source_url": "https://i1.ypcdn.com/blob/441b5fc19f19fdcc4f273f2bc4bace91ee836bee_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "ca240fc5a8d55cfd7a50305ae41e728cb4cbda92",
"image.size": 281032,
"image.path": "/ca/24/0f/c5/ca240fc5a8d55cfd7a50305ae41e728cb4cbda92.jpg",
"image.title": ""
}
}
}
} |
{
"16": {
"payment_x_auto_service.id": 16,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"17": {
"payment_x_auto_service.id": 17,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"18": {
"payment_x_auto_service.id": 18,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"19": {
"payment_x_auto_service.id": 19,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"20": {
"payment_x_auto_service.id": 20,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
}
} |
{} | {
"8": {
"_image_slug.id": 8,
"_image_slug.ts": "2023-10-18 09:08:06"
},
"9": {
"_image_slug.id": 9,
"_image_slug.ts": "2023-10-18 09:08:06"
},
"10": {
"_image_slug.id": 10,
"_image_slug.ts": "2023-10-18 09:08:06"
},
"11": {
"_image_slug.id": 11,
"_image_slug.ts": "2023-10-18 09:08:06"
}
} |
||
4 | 2023-10-18 09:08:42 | Mays Auto & Tire | 205-592-6078 | 5600 1st Ave S, Birmingham, AL, 35212 | 35212 | 33.540516 | -86.750565 | automays@yahoo.com | "Mo-Fr 07:00-17:00" | {} | {} | {} | {
"16": {
"category_x_auto_service.id": 16,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"14": {
"category_x_auto_service.id": 14,
"category.id": 11,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Tire Dealers"
},
"15": {
"category_x_auto_service.id": 15,
"category.id": 15,
"category.ts": "2023-10-18 09:08:42",
"category.category": "Auto Oil & Lube"
},
"17": {
"category_x_auto_service.id": 17,
"category.id": 17,
"category.ts": "2023-10-18 09:08:42",
"category.category": "Wheel Alignment-Frame & Axle Servicing-Automotive"
}
} |
{
"4": {
"city_x_auto_service.id": 4,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18622": {
"city_x_auto_service.id": 18622,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"21": {
"payment_x_auto_service.id": 21,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"22": {
"payment_x_auto_service.id": 22,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"23": {
"payment_x_auto_service.id": 23,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"24": {
"payment_x_auto_service.id": 24,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"25": {
"payment_x_auto_service.id": 25,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"26": {
"payment_x_auto_service.id": 26,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{} | {} | |||||||
5 | 2023-10-29 08:57:43 | Mtn Brook Portable Detail | http://www.mountainbrookdetail.com | 205-567-2123 | 4563 Little River Rd, Birmingham, AL, 35213 | 35213 | 33.515793 | -86.7157 | tommy.mbpd@yahoo.com | "Mo-Su 07:00-19:00" | Mountain Brook Portable Detail (M.B.P.D.) is the #1 name in high quality, on-site automotive detailing in the Birmingham area. We offer all of the same detail services of a high-end detail shop, but at your location, for your convenience. Whether it is handling the clean-up of a fleet of Porches at Barber Motor Sports for the 2013 Boxter release, detailing your vintage Dodge Charger, or giving a good cleaning to the mini-van after the Little League Championship, M.B.P.D. can handle all of your needs! Contact Us For More Information! |
FULL SERVICE MOBILE DETAILING throughout the Greater Birmingham Area! SERVICES INCLUDE: Basic Wash, Premium Wash (Vacuum & Wipe down), Hand Wax & Clay Treatment, Seat Cleaning & Conditioning, Upholstery Cleaning, Carpet & Mat Shampooing, Rim & Tire Degreasing, Door Jam Degreasing, Engine Cleaning, Headlight Restoration, Decal & Sticker Removal, Overspray Removal, Steam Cleaning, Deodorizing.BOAT & RV Detailing Also Available! |
{
"9": {
"auto_service_detail.id": 9,
"auto_service_detail.ts": "2023-10-18 09:09:09",
"auto_service_detail.key": "Appointment Needed",
"auto_service_detail.value": "Yes"
},
"10": {
"auto_service_detail.id": 10,
"auto_service_detail.ts": "2023-10-18 09:09:09",
"auto_service_detail.key": "Warranties",
"auto_service_detail.value": "Yes"
},
"11": {
"auto_service_detail.id": 11,
"auto_service_detail.ts": "2023-10-18 09:09:09",
"auto_service_detail.key": "Services",
"auto_service_detail.value": "Auto Glass, Auto Body"
}
} |
{
"13": {
"auto_service_menu.id": 13,
"auto_service_menu.ts": "2023-11-12 21:55:31",
"auto_service_menu.category": "Tires",
"auto_service_menu.auto_service_menu_detail_id": {
"39": {
"auto_service_menu_detail.id": 39,
"auto_service_menu_detail.ts": "2023-11-12 21:55:31",
"auto_service_menu_detail.title": "Tire Service",
"auto_service_menu_detail.description": ""
}
}
},
"14": {
"auto_service_menu.id": 14,
"auto_service_menu.ts": "2023-11-12 21:55:31",
"auto_service_menu.category": "Exterior/Interior",
"auto_service_menu.auto_service_menu_detail_id": {
"40": {
"auto_service_menu_detail.id": 40,
"auto_service_menu_detail.ts": "2023-11-12 21:55:31",
"auto_service_menu_detail.title": "Headlight Restoration",
"auto_service_menu_detail.description": ""
}
}
}
} |
{} | {
"18": {
"category_x_auto_service.id": 18,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"19": {
"category_x_auto_service.id": 19,
"category.id": 19,
"category.ts": "2023-10-18 09:09:06",
"category.category": "Aircraft Washing & Polishing"
},
"20": {
"category_x_auto_service.id": 20,
"category.id": 20,
"category.ts": "2023-10-18 09:09:06",
"category.category": "Automobile Detailing"
},
"21": {
"category_x_auto_service.id": 21,
"category.id": 21,
"category.ts": "2023-10-18 09:09:06",
"category.category": "Boat Cleaning"
},
"22": {
"category_x_auto_service.id": 22,
"category.id": 22,
"category.ts": "2023-10-18 09:09:06",
"category.category": "Car Wash"
},
"23": {
"category_x_auto_service.id": 23,
"category.id": 23,
"category.ts": "2023-10-18 09:09:06",
"category.category": "Recreational Vehicles & Campers"
},
"24": {
"category_x_auto_service.id": 24,
"category.id": 24,
"category.ts": "2023-10-18 09:09:06",
"category.category": "Recreational Vehicles & Campers-Repair & Service"
}
} |
{
"5": {
"city_x_auto_service.id": 5,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18623": {
"city_x_auto_service.id": 18623,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"27": {
"payment_x_auto_service.id": 27,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"28": {
"payment_x_auto_service.id": 28,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"29": {
"payment_x_auto_service.id": 29,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"30": {
"payment_x_auto_service.id": 30,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"31": {
"payment_x_auto_service.id": 31,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"32": {
"payment_x_auto_service.id": 32,
"payment.id": 32,
"payment.ts": "2023-10-18 09:09:11",
"payment.payment": "CASH"
}
} |
{} | {} | ||||
6 | 2023-11-06 23:38:40 | AAMCO Transmissions & Total Car Care | http://www.aamcobirmingham-downtown.com | 205-259-5166 | 2610 6th Ave S, Birmingham, AL, 35233 | 35233 | 33.51128 | -86.792046 | 44120@aamcoemail.com | "Mo-Fr 07:00-17:00" | We are the experts in transmission repair and complete car care - clutches, brakes, factory scheduled maintenance, electrical, check engine lights, radiators, overheating problems, a/c and more. | Transmission Shop, Auto Repair Shop, Brake Shop, Oil Change Service, Auto Service | ASE CertifiedOther Linkhttp://www.aamcobirmingham-downtown.comOther EmailEmail BusinessBanner | {} | {
"15": {
"auto_service_menu.id": 15,
"auto_service_menu.ts": "2023-11-12 21:56:28",
"auto_service_menu.category": "Engine and Exhaust System",
"auto_service_menu.auto_service_menu_detail_id": {
"41": {
"auto_service_menu_detail.id": 41,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Oil Change",
"auto_service_menu_detail.description": ""
},
"42": {
"auto_service_menu_detail.id": 42,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Engine Tune-Up",
"auto_service_menu_detail.description": ""
},
"43": {
"auto_service_menu_detail.id": 43,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Exhaust System Repair",
"auto_service_menu_detail.description": ""
},
"44": {
"auto_service_menu_detail.id": 44,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Starter Repair",
"auto_service_menu_detail.description": ""
},
"45": {
"auto_service_menu_detail.id": 45,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Engine Diagnostic",
"auto_service_menu_detail.description": ""
}
}
},
"16": {
"auto_service_menu.id": 16,
"auto_service_menu.ts": "2023-11-12 21:56:28",
"auto_service_menu.category": "Transmission and Drivetrain",
"auto_service_menu.auto_service_menu_detail_id": {
"46": {
"auto_service_menu_detail.id": 46,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Transmission Service",
"auto_service_menu_detail.description": ""
},
"47": {
"auto_service_menu_detail.id": 47,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Transmission Repair",
"auto_service_menu_detail.description": ""
},
"48": {
"auto_service_menu_detail.id": 48,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Transmission Replacement",
"auto_service_menu_detail.description": ""
},
"49": {
"auto_service_menu_detail.id": 49,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Axle Repair",
"auto_service_menu_detail.description": ""
}
}
},
"17": {
"auto_service_menu.id": 17,
"auto_service_menu.ts": "2023-11-12 21:56:28",
"auto_service_menu.category": "Steering and Suspension",
"auto_service_menu.auto_service_menu_detail_id": {
"50": {
"auto_service_menu_detail.id": 50,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Suspension Service/Repair",
"auto_service_menu_detail.description": ""
}
}
},
"18": {
"auto_service_menu.id": 18,
"auto_service_menu.ts": "2023-11-12 21:56:28",
"auto_service_menu.category": "Heating and Cooling",
"auto_service_menu.auto_service_menu_detail_id": {
"51": {
"auto_service_menu_detail.id": 51,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Air Conditioning Service/Repair",
"auto_service_menu_detail.description": ""
},
"52": {
"auto_service_menu_detail.id": 52,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Radiator Service/Repair",
"auto_service_menu_detail.description": ""
}
}
},
"19": {
"auto_service_menu.id": 19,
"auto_service_menu.ts": "2023-11-12 21:56:28",
"auto_service_menu.category": "Tires",
"auto_service_menu.auto_service_menu_detail_id": {
"53": {
"auto_service_menu_detail.id": 53,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Tire Repair",
"auto_service_menu_detail.description": ""
}
}
},
"20": {
"auto_service_menu.id": 20,
"auto_service_menu.ts": "2023-11-12 21:56:28",
"auto_service_menu.category": "Brakes",
"auto_service_menu.auto_service_menu_detail_id": {
"54": {
"auto_service_menu_detail.id": 54,
"auto_service_menu_detail.ts": "2023-11-12 21:56:28",
"auto_service_menu_detail.title": "Brake Service",
"auto_service_menu_detail.description": ""
}
}
}
} |
{
"15": {
"brand_x_auto_service.id": 15,
"brand.id": 15,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Buick"
},
"16": {
"brand_x_auto_service.id": 16,
"brand.id": 16,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Cadillac"
},
"17": {
"brand_x_auto_service.id": 17,
"brand.id": 17,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Chevrolet"
},
"18": {
"brand_x_auto_service.id": 18,
"brand.id": 18,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Chrysler"
},
"19": {
"brand_x_auto_service.id": 19,
"brand.id": 19,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Dodge"
},
"20": {
"brand_x_auto_service.id": 20,
"brand.id": 20,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Ford"
},
"21": {
"brand_x_auto_service.id": 21,
"brand.id": 21,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "GMC"
},
"22": {
"brand_x_auto_service.id": 22,
"brand.id": 22,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Honda"
},
"23": {
"brand_x_auto_service.id": 23,
"brand.id": 23,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Lincoln"
},
"24": {
"brand_x_auto_service.id": 24,
"brand.id": 24,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Mercury"
},
"25": {
"brand_x_auto_service.id": 25,
"brand.id": 25,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Mazda"
},
"26": {
"brand_x_auto_service.id": 26,
"brand.id": 26,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Nissan"
},
"27": {
"brand_x_auto_service.id": 27,
"brand.id": 27,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Oldsmobile"
},
"28": {
"brand_x_auto_service.id": 28,
"brand.id": 1,
"brand.ts": "2023-10-18 09:05:07",
"brand.brand": "Toyota"
},
"29": {
"brand_x_auto_service.id": 29,
"brand.id": 29,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Odyssey"
},
"30": {
"brand_x_auto_service.id": 30,
"brand.id": 30,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Civic"
},
"31": {
"brand_x_auto_service.id": 31,
"brand.id": 31,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Explorer"
},
"32": {
"brand_x_auto_service.id": 32,
"brand.id": 32,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "F150"
},
"33": {
"brand_x_auto_service.id": 33,
"brand.id": 33,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Blazer"
},
"34": {
"brand_x_auto_service.id": 34,
"brand.id": 34,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Town & Country"
},
"35": {
"brand_x_auto_service.id": 35,
"brand.id": 35,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Suburban"
}
} |
{
"32": {
"category_x_auto_service.id": 32,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"34": {
"category_x_auto_service.id": 34,
"category.id": 6,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Auto Transmission"
},
"36": {
"category_x_auto_service.id": 36,
"category.id": 8,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Parts & Supplies"
},
"38": {
"category_x_auto_service.id": 38,
"category.id": 9,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Brake Repair"
},
"35": {
"category_x_auto_service.id": 35,
"category.id": 13,
"category.ts": "2023-10-18 09:08:06",
"category.category": "Automobile Air Conditioning Equipment-Service & Repair"
},
"33": {
"category_x_auto_service.id": 33,
"category.id": 15,
"category.ts": "2023-10-18 09:08:42",
"category.category": "Auto Oil & Lube"
},
"37": {
"category_x_auto_service.id": 37,
"category.id": 37,
"category.ts": "2023-10-18 09:09:37",
"category.category": "Automotive Tune Up Service"
},
"39": {
"category_x_auto_service.id": 39,
"category.id": 39,
"category.ts": "2023-10-18 09:09:37",
"category.category": "Clutches"
},
"40": {
"category_x_auto_service.id": 40,
"category.id": 40,
"category.ts": "2023-10-18 09:09:37",
"category.category": "Transmissions-Other"
},
"41": {
"category_x_auto_service.id": 41,
"category.id": 41,
"category.ts": "2023-10-18 09:09:37",
"category.category": "Truck Service & Repair"
}
} |
{ "6": { "city_x_auto_service.id": 6, "city.id": 1, "city.ts": "2023-10-15 04:01:17", "city.city": "Birmingham", "state.id": 1, "state.ts": "2023-10-15 03:33:45", "state.state": "Alabama" } } | {
"12": {
"image_slug.id": 12,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"6": {
"image.id": 6,
"image.ts": "2023-11-15 06:03:40",
"image.source_url": "https://i4.ypcdn.com/blob/e5cec524bc834d693ec080c6f2960b922993395e_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "34aef534c268e15b2f7c567fd8be3194ba2489fb",
"image.size": 157847,
"image.path": "/34/ae/f5/34/34aef534c268e15b2f7c567fd8be3194ba2489fb.jpg",
"image.title": ""
}
}
}
} |
{
"33": {
"payment_x_auto_service.id": 33,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"34": {
"payment_x_auto_service.id": 34,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"35": {
"payment_x_auto_service.id": 35,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"36": {
"payment_x_auto_service.id": 36,
"payment.id": 32,
"payment.ts": "2023-10-18 09:09:11",
"payment.payment": "CASH"
},
"37": {
"payment_x_auto_service.id": 37,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"38": {
"payment_x_auto_service.id": 38,
"payment.id": 3,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "FINANCING AVAILABLE"
},
"39": {
"payment_x_auto_service.id": 39,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
}
} |
{} | {
"12": {
"_image_slug.id": 12,
"_image_slug.ts": "2023-10-18 09:09:37"
},
"13": {
"_image_slug.id": 13,
"_image_slug.ts": "2023-10-18 09:09:37"
},
"14": {
"_image_slug.id": 14,
"_image_slug.ts": "2023-10-18 09:09:37"
},
"15": {
"_image_slug.id": 15,
"_image_slug.ts": "2023-10-18 09:09:37"
}
} |
|||
7 | 2023-10-18 09:10:26 | Hatfield Auto Parts and Service | http://www.autorepairshophomewoodal.com | 205-871-9685 | 190 Oxmoor Rd, Birmingham, AL, 35209 | 35209 | 33.461754 | -86.82832 | trent312@yahoo.com | "Mo-Fr 06:30-17:30" | We have been an auto repair shop since 1958. Located in downtown Birmingham, AL, our Technicians service all types of vehicles foreign and domestic. No problem too big or small for us Call today! We do it all from oil changes, tires, air conditioning, shocks and struts, radiators, to major engine and transmission service. | {} | {} | {} | {
"64": {
"category_x_auto_service.id": 64,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"65": {
"category_x_auto_service.id": 65,
"category.id": 6,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Auto Transmission"
},
"68": {
"category_x_auto_service.id": 68,
"category.id": 8,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Parts & Supplies"
},
"70": {
"category_x_auto_service.id": 70,
"category.id": 11,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Tire Dealers"
},
"66": {
"category_x_auto_service.id": 66,
"category.id": 55,
"category.ts": "2023-10-18 09:10:18",
"category.category": "Automobile Accessories"
},
"67": {
"category_x_auto_service.id": 67,
"category.id": 67,
"category.ts": "2023-10-18 09:10:26",
"category.category": "Automobile Electric Service"
},
"69": {
"category_x_auto_service.id": 69,
"category.id": 69,
"category.ts": "2023-10-18 09:10:26",
"category.category": "Shock Absorbers & Struts"
}
} |
{
"7": {
"city_x_auto_service.id": 7,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"17820": {
"city_x_auto_service.id": 17820,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{
"20": {
"image_slug.id": 20,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"10": {
"image.id": 10,
"image.ts": "2023-11-15 06:04:20",
"image.source_url": "https://i3.ypcdn.com/blob/5f47662fb1a604e6e7f3c4aeb1e732ec2d6b69d9_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "35b29d40a86b5b6246c138afa9ab4de5f02b2673",
"image.size": 99855,
"image.path": "/35/b2/9d/40/35b29d40a86b5b6246c138afa9ab4de5f02b2673.jpg",
"image.title": ""
}
}
}
} |
{
"50": {
"payment_x_auto_service.id": 50,
"payment.id": 32,
"payment.ts": "2023-10-18 09:09:11",
"payment.payment": "CASH"
},
"51": {
"payment_x_auto_service.id": 51,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"52": {
"payment_x_auto_service.id": 52,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"53": {
"payment_x_auto_service.id": 53,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"54": {
"payment_x_auto_service.id": 54,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"55": {
"payment_x_auto_service.id": 55,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"56": {
"payment_x_auto_service.id": 56,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"57": {
"payment_x_auto_service.id": 57,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"58": {
"payment_x_auto_service.id": 58,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{} | { "20": { "_image_slug.id": 20, "_image_slug.ts": "2023-10-18 09:10:26" }, "21": { "_image_slug.id": 21, "_image_slug.ts": "2023-10-18 09:10:26" } } | |||||
8 | 2023-11-06 23:39:02 | Momentum Motorworks BMW Mercedes Porsche Service & Repair | http://www.momentummotorworks.com | 205-403-4626 | 2075 Old Montgomery Hwy, Birmingham, AL, 35244 | 35244 | 33.345184 | -86.79939 | momentum@bellsouth.net | Mercedes BMW Porsche Expert Service We offer full dealer level diagnostic capability. We accept extended warranty contracts , we offer same day service available in most cases by appointment. Large comfortable waiting area with bottled water, coffee, television, dedicated customer computer work area including free high speed internet. After hours drop off and pick-up available. We look forward to your call , Thanks. |
Factory-Trained ASE Certified Master Technicians available for all makes we service.AssociationsAuthorized Bosch Service Center BIMRS member ASE Certificate of ExcellenceAKAMomentum Motorworks Mercedes BMW Porsche Expert ServiceOther Linkhttp://www.momentummotorworks.comOther InformationServices: Air Conditioning & Heating, Major Engine Repair or Replacement, Tires, Wheels & Alignments, Inspection & Diagnostic Services, Brake Service, Transmission & Drive Train Services, Oil ChangesBrands Serviced: Audi, Mercedes-Benz, Porsche, BMWAppointment Needed: YesWarranties: Yes |
{
"14": {
"auto_service_detail.id": 14,
"auto_service_detail.ts": "2023-10-18 09:10:37",
"auto_service_detail.key": "Services",
"auto_service_detail.value": "Air Conditioning & Heating, Major Engine Repair or Replacement, Tires, Wheels & Alignments, Inspection & Diagnostic Services, Brake Service, Transmission & Drive Train Services, Oil Changes"
},
"15": {
"auto_service_detail.id": 15,
"auto_service_detail.ts": "2023-10-18 09:10:37",
"auto_service_detail.key": "Brands Serviced",
"auto_service_detail.value": "Audi, Mercedes-Benz, Porsche, BMW"
},
"16": {
"auto_service_detail.id": 16,
"auto_service_detail.ts": "2023-10-18 09:10:37",
"auto_service_detail.key": "Appointment Needed",
"auto_service_detail.value": "Yes"
},
"17": {
"auto_service_detail.id": 17,
"auto_service_detail.ts": "2023-10-18 09:10:37",
"auto_service_detail.key": "Warranties",
"auto_service_detail.value": "Yes"
}
} |
{
"21": {
"auto_service_menu.id": 21,
"auto_service_menu.ts": "2023-11-12 21:56:35",
"auto_service_menu.category": "Heating and Cooling",
"auto_service_menu.auto_service_menu_detail_id": {
"55": {
"auto_service_menu_detail.id": 55,
"auto_service_menu_detail.ts": "2023-11-12 21:56:35",
"auto_service_menu_detail.title": "Air Conditioning Service/Repair",
"auto_service_menu_detail.description": ""
}
}
}
} |
{} | { "90": { "category_x_auto_service.id": 90, "category.id": 2, "category.ts": "2023-10-18 09:05:07", "category.category": "Auto Repair & Service" } } | {
"8": {
"city_x_auto_service.id": 8,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"17821": {
"city_x_auto_service.id": 17821,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"83": {
"payment_x_auto_service.id": 83,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"84": {
"payment_x_auto_service.id": 84,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"85": {
"payment_x_auto_service.id": 85,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"86": {
"payment_x_auto_service.id": 86,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"87": {
"payment_x_auto_service.id": 87,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"88": {
"payment_x_auto_service.id": 88,
"payment.id": 47,
"payment.ts": "2023-10-18 09:10:23",
"payment.payment": "INSURANCE"
},
"89": {
"payment_x_auto_service.id": 89,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
}
} |
{} | {} | |||||
9 | 2023-10-18 09:13:27 | Green Garage | http://greengaragebham.com | 205-383-2009 | 2303 4th Ave S, Birmingham, AL, 35233 | 35233 | 33.51103 | -86.7976 | greengaragebham@gmail.com | "Mo-Fr 07:30-17:30" | { "19": { "auto_service_detail.id": 19, "auto_service_detail.ts": "2023-10-18 09:13:27", "auto_service_detail.key": "Parking", "auto_service_detail.value": "Lot" } } | {} | {} | { "130": { "category_x_auto_service.id": 130, "category.id": 2, "category.ts": "2023-10-18 09:05:07", "category.category": "Auto Repair & Service" } } | {
"9": {
"city_x_auto_service.id": 9,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18051": {
"city_x_auto_service.id": 18051,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"105": {
"payment_x_auto_service.id": 105,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"106": {
"payment_x_auto_service.id": 106,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"107": {
"payment_x_auto_service.id": 107,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"108": {
"payment_x_auto_service.id": 108,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"109": {
"payment_x_auto_service.id": 109,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{} | {} | ||||||
10 | 2023-10-29 08:59:01 | Sherrill Paint & Body Co. | http://sherrillpaintandbody.com | 205-322-5684 | 2221 3rd Ave S, Birmingham, AL, 35233 | 35233 | 33.511356 | -86.79942 | tad@sherrillpaintandbody.com | "Mo-Fr 07:00-16:00" | {
"20": {
"auto_service_detail.id": 20,
"auto_service_detail.ts": "2023-10-18 09:15:10",
"auto_service_detail.key": "Parking",
"auto_service_detail.value": "Lot"
},
"21": {
"auto_service_detail.id": 21,
"auto_service_detail.ts": "2023-10-18 09:15:10",
"auto_service_detail.key": "Classes Offered",
"auto_service_detail.value": "Painting"
}
} |
{
"23": {
"auto_service_menu.id": 23,
"auto_service_menu.ts": "2023-11-12 21:56:49",
"auto_service_menu.category": "Exterior/Interior",
"auto_service_menu.auto_service_menu_detail_id": {
"61": {
"auto_service_menu_detail.id": 61,
"auto_service_menu_detail.ts": "2023-11-12 21:56:49",
"auto_service_menu_detail.title": "Body/Collision Repair",
"auto_service_menu_detail.description": "Looking for a Certified Collision Repair Provider? Book an appointment with an independently inspected and Certified Collision Repair Provider in your area that has met or exceeded industry standards set by leading auto manufacturers and our nonprofit consumer advocacy organization, Assured Performance Collision Care. Every provider we Certify has the necessary tools, training, equipment, and customer service facilities to offer you complete repair documentation and a fully documented invoice."
}
}
}
} |
{} | {
"135": {
"category_x_auto_service.id": 135,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"136": {
"category_x_auto_service.id": 136,
"category.id": 25,
"category.ts": "2023-10-18 09:09:22",
"category.category": "Automobile Body Repairing & Painting"
}
} |
{
"10": {
"city_x_auto_service.id": 10,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18052": {
"city_x_auto_service.id": 18052,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{
"25": {
"image_slug.id": 25,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"16": {
"image.id": 16,
"image.ts": "2023-11-15 06:04:59",
"image.source_url": "https://i3.ypcdn.com/blob/d2841ead8fd6de08b56d15522a55dc35fb3f26ba_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "99f70fd35f6eeabccd5ad25dccecb626a3f5da98",
"image.size": 141441,
"image.path": "/99/f7/0f/d3/99f70fd35f6eeabccd5ad25dccecb626a3f5da98.jpg",
"image.title": ""
}
}
}
} |
{
"116": {
"payment_x_auto_service.id": 116,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"117": {
"payment_x_auto_service.id": 117,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"118": {
"payment_x_auto_service.id": 118,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"119": {
"payment_x_auto_service.id": 119,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"120": {
"payment_x_auto_service.id": 120,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{} | {
"25": {
"_image_slug.id": 25,
"_image_slug.ts": "2023-10-18 09:15:10"
},
"26": {
"_image_slug.id": 26,
"_image_slug.ts": "2023-10-18 09:15:10"
},
"27": {
"_image_slug.id": 27,
"_image_slug.ts": "2023-10-18 09:15:10"
},
"28": {
"_image_slug.id": 28,
"_image_slug.ts": "2023-10-18 09:15:10"
}
} |
||||||
11 | 2023-10-18 09:15:30 | Pro Dent Paintless Dent Repair | 205-677-3002 | 3245 Cahaba Heights Rd., Birmingham, AL, 35243 | 35243 | 33.45388 | -86.72817 | ProDentPDR@gmail.com | "Mo-Fr 08:00-18:00" | We are a mobile company specializing inthe repair of door dings, minor dents, and hail damage in vehicles. Our technicians have over 20 years of combined experience in the field of painless dent repair and alsoservice some of the largest dealerships and body shops in the greater Birmingham area.Give us a call today to schedule your repair! | {} | {} | { "82": { "brand_x_auto_service.id": 82, "brand.id": 82, "brand.ts": "2023-10-18 09:15:30", "brand.brand": "All manufacturers & models" } } | {
"151": {
"category_x_auto_service.id": 151,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"152": {
"category_x_auto_service.id": 152,
"category.id": 25,
"category.ts": "2023-10-18 09:09:22",
"category.category": "Automobile Body Repairing & Painting"
},
"153": {
"category_x_auto_service.id": 153,
"category.id": 74,
"category.ts": "2023-10-18 09:10:26",
"category.category": "Dent Removal"
},
"150": {
"category_x_auto_service.id": 150,
"category.id": 150,
"category.ts": "2023-10-18 09:15:30",
"category.category": "Commercial Auto Body Repair"
}
} |
{
"11": {
"city_x_auto_service.id": 11,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18030": {
"city_x_auto_service.id": 18030,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{
"29": {
"image_slug.id": 29,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"17": {
"image.id": 17,
"image.ts": "2023-11-15 06:05:10",
"image.source_url": "https://i4.ypcdn.com/blob/574dbb0af9d9c46bbb6b57f1ad59d6403406868c_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "7baec03753f7b034cdd6b673ea5a6bc2846f397e",
"image.size": 166323,
"image.path": "/7b/ae/c0/37/7baec03753f7b034cdd6b673ea5a6bc2846f397e.jpg",
"image.title": ""
}
}
}
} |
{
"127": {
"payment_x_auto_service.id": 127,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"128": {
"payment_x_auto_service.id": 128,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"129": {
"payment_x_auto_service.id": 129,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"130": {
"payment_x_auto_service.id": 130,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"131": {
"payment_x_auto_service.id": 131,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"132": {
"payment_x_auto_service.id": 132,
"payment.id": 32,
"payment.ts": "2023-10-18 09:09:11",
"payment.payment": "CASH"
},
"133": {
"payment_x_auto_service.id": 133,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
}
} |
{} | { "29": { "_image_slug.id": 29, "_image_slug.ts": "2023-10-18 09:15:30" }, "30": { "_image_slug.id": 30, "_image_slug.ts": "2023-10-18 09:15:30" } } | ||||||
12 | 2023-10-18 09:16:17 | Trussville Collision | 205-655-6974 | 4400 Valley Rd, Birmingham, AL, 35235 | 35235 | 33.63358 | -86.623055 | trussvillecollision@hotmail.com | "Mo-Fr 08:00-17:00" | FREE ESTIMATES! Trussville Collision is your automotive paint and body repair specialists. A commitment to excellence is our primary goal and this principle is built into everything we do. At TRUSSVILLE COLLISION INC., we have over 40 years of experience in collision repair (both paint and bodywork). Our full-service body shop is I-car and ASE certified. We assist you with your insurance claim. Insurance claim experts - foreign and domestic. We welcome all insurance claims. We work with all insurance companies. We assist you with your insurance claim. We negotiate repairs and price for you. You are not required to use a shop selected by an insurance company. However, you are required to allow your insurance company a reasonable amount of time to inspect the damages prior to repairing them. Only you, the owner, can authorize repairs on your vehicle. You always have the right to have your vehicle repaired at the shop of your choice! |
Besides our commitment to excellence we are determined to: provide you with a friendly & welcoming atmosphere; earn your trust and confidence; exceed your expectations; do that little something extra to your vehicle; provide a pleasant experience; repair you vehicle in a timely manner; repair your vehicle right the first time; complete a 10 point inspection checklist before delivery of your vehicle. |
{} | {} | {} | {
"155": {
"category_x_auto_service.id": 155,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"154": {
"category_x_auto_service.id": 154,
"category.id": 25,
"category.ts": "2023-10-18 09:09:22",
"category.category": "Automobile Body Repairing & Painting"
},
"156": {
"category_x_auto_service.id": 156,
"category.id": 28,
"category.ts": "2023-10-18 09:09:33",
"category.category": "Automobile Customizing"
},
"157": {
"category_x_auto_service.id": 157,
"category.id": 157,
"category.ts": "2023-10-18 09:16:17",
"category.category": "Automobile Repair Referral Service"
}
} |
{ "12": { "city_x_auto_service.id": 12, "city.id": 1, "city.ts": "2023-10-15 04:01:17", "city.city": "Birmingham", "state.id": 1, "state.ts": "2023-10-15 03:33:45", "state.state": "Alabama" } } | {
"31": {
"image_slug.id": 31,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"19": {
"image.id": 19,
"image.ts": "2023-11-15 06:05:17",
"image.source_url": "https://i3.ypcdn.com/blob/3a8ed8284ffcfb442c9b5e05c76ff0c67ace97f0_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "41146e972973292e998d23aec6e985f96a13960c",
"image.size": 156201,
"image.path": "/41/14/6e/97/41146e972973292e998d23aec6e985f96a13960c.jpg",
"image.title": ""
}
}
}
} |
{} | {} | { "31": { "_image_slug.id": 31, "_image_slug.ts": "2023-10-18 09:16:17" } } | |||||
13 | 2023-10-29 09:00:08 | Hoover Towing & Recovery, Inc. | http://hoovertowing.net | 205-822-5570 | 2075 Valleydale Ter. Suite B, Birmingham, AL, 35244 | 35244 | 33.34728 | -86.79886 | jeff84@bellsouth.net | "Mo-Su" | Action Towing is a full service towing and roadside assistance provider. We only use the latest, high-tech equipment operated by experienced and well trained operators to meet all your service needs. We have been servicing the residents of Jefferson & North Shelby County for over 22 years. Action Towing has built a reputation for delivering fast and affordable towing and roadside service experience. Our team of expertly trained and experienced towing operators are committed to delivering excellence on every call and are prepared to help you with all of your towing and roadside assistance needs. Call our 24-hour dispatch center now at 205-979-TOWS (8697) to experience the Action Towing 'Difference.' Here at Action, we treat our customers like family and provide them with quality services at affordable prices. We are dedicated to helping all clients for any towing issue. |
Service calls including Lock-out, Jump starts, Gas delivery and Tire changes, Auto recovery and complex winch-out’s. Most importantly, 'terrific customer service.' EVERY TIME! | {} | {
"24": {
"auto_service_menu.id": 24,
"auto_service_menu.ts": "2023-11-12 21:56:56",
"auto_service_menu.category": "Tires",
"auto_service_menu.auto_service_menu_detail_id": {
"62": {
"auto_service_menu_detail.id": 62,
"auto_service_menu_detail.ts": "2023-11-12 21:56:56",
"auto_service_menu_detail.title": "Tire Repair",
"auto_service_menu_detail.description": ""
},
"63": {
"auto_service_menu_detail.id": 63,
"auto_service_menu_detail.ts": "2023-11-12 21:56:56",
"auto_service_menu_detail.title": "Tire Replacement",
"auto_service_menu_detail.description": "To Hoover, Alabama and the surrounding cities. Whether you need assistance with roadside services, fuel recovery, a battery jump, a tire change, a breakdown tow, or accident recovery. Our team of professional wrecker specialists are extremely knowledgeable of all types of situations and are eager to serve you. If you are looking for a reliable and dependable company that will help you get your car off the roadside and on with your life, you have come to the right place! Give us a call and let us show you why we are considered to be the leading wrecker service"
}
}
},
"25": {
"auto_service_menu.id": 25,
"auto_service_menu.ts": "2023-11-12 21:56:56",
"auto_service_menu.category": "Electrical and Electronic",
"auto_service_menu.auto_service_menu_detail_id": {
"64": {
"auto_service_menu_detail.id": 64,
"auto_service_menu_detail.ts": "2023-11-12 21:56:56",
"auto_service_menu_detail.title": "Battery Service",
"auto_service_menu_detail.description": ""
}
}
},
"26": {
"auto_service_menu.id": 26,
"auto_service_menu.ts": "2023-11-12 21:56:56",
"auto_service_menu.category": "General",
"auto_service_menu.auto_service_menu_detail_id": {
"65": {
"auto_service_menu_detail.id": 65,
"auto_service_menu_detail.ts": "2023-11-12 21:56:56",
"auto_service_menu_detail.title": "Towing Service",
"auto_service_menu_detail.description": "Thank you for considering Hoover Towing & Recovery for all of your towing needs. You can reach us here..."
}
}
}
} |
{} | {
"158": {
"category_x_auto_service.id": 158,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"161": {
"category_x_auto_service.id": 161,
"category.id": 42,
"category.ts": "2023-10-18 09:09:47",
"category.category": "Towing"
},
"159": {
"category_x_auto_service.id": 159,
"category.id": 48,
"category.ts": "2023-10-18 09:09:50",
"category.category": "Automotive Roadside Service"
},
"160": {
"category_x_auto_service.id": 160,
"category.id": 160,
"category.ts": "2023-10-18 09:16:43",
"category.category": "Locks & Locksmiths"
},
"162": {
"category_x_auto_service.id": 162,
"category.id": 162,
"category.ts": "2023-10-18 09:16:43",
"category.category": "Truck Wrecking"
}
} |
{
"13": {
"city_x_auto_service.id": 13,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"17822": {
"city_x_auto_service.id": 17822,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{
"32": {
"image_slug.id": 32,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"20": {
"image.id": 20,
"image.ts": "2023-11-15 06:05:26",
"image.source_url": "https://i1.ypcdn.com/blob/c40f6ee26064e6256ff32f672e3c1cfddb0b596e_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "498f198c19300542bd6c14ded5501a8026e06536",
"image.size": 151079,
"image.path": "/49/8f/19/8c/498f198c19300542bd6c14ded5501a8026e06536.jpg",
"image.title": ""
}
}
}
} |
{
"134": {
"payment_x_auto_service.id": 134,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"135": {
"payment_x_auto_service.id": 135,
"payment.id": 32,
"payment.ts": "2023-10-18 09:09:11",
"payment.payment": "CASH"
},
"136": {
"payment_x_auto_service.id": 136,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"137": {
"payment_x_auto_service.id": 137,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"138": {
"payment_x_auto_service.id": 138,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"139": {
"payment_x_auto_service.id": 139,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"140": {
"payment_x_auto_service.id": 140,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"141": {
"payment_x_auto_service.id": 141,
"payment.id": 47,
"payment.ts": "2023-10-18 09:10:23",
"payment.payment": "INSURANCE"
},
"142": {
"payment_x_auto_service.id": 142,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{
"40": {
"review.id": 40,
"review.ts": "2023-10-18 09:16:43",
"review.review": "My car had broke down I give hoover towing a call an they took care of me so fast gave me a reasonable prize had a drive there quick an got my car to the auto shop they are a very good bissness to call",
"review.author": "Shelley W.",
"review.time": "04/13/23",
"review.rating_stars": "five",
"review.collect": "1"
},
"41": {
"review.id": 41,
"review.ts": "2023-10-18 09:16:43",
"review.review": "Hoover Towing is great to do business with - they quickly answered my call and responded quickly - even called to be sure that all was ok and I was not still stranded.",
"review.author": "Ed C.",
"review.time": "08/09/18",
"review.rating_stars": "five",
"review.collect": "2"
},
"42": {
"review.id": 42,
"review.ts": "2023-10-18 09:16:43",
"review.review": "Action Towing is fully equipped to tow all types of vehicles and equipment. Fast, Friendly, Folks. 23 years in the business and very knowledgable of the towing industry. Good People call em",
"review.author": "Jeff D.",
"review.time": "01/07/16",
"review.rating_stars": "five",
"review.collect": "1"
},
"43": {
"review.id": 43,
"review.ts": "2023-10-18 09:16:43",
"review.review": "If you need fast, reliable and friendly service, then this is the towing company for you. My family and I have used their services for 6 years. They have done nothing but provide the best possible experience. Every time.",
"review.author": "Justin shane R.",
"review.time": "12/18/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"44": {
"review.id": 44,
"review.ts": "2023-10-18 09:16:43",
"review.review": "They had great friendly service! They got to my vehicle within a great time. They were very nice while they were hooking up my vehicle and while I rode with the driver to my destination he made me feel comfortable and welcome. Any time I need assistance again I will ALWAYS call tow man service and recovery!!",
"review.author": "Heaven S.",
"review.time": "06/30/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"45": {
"review.id": 45,
"review.ts": "2023-10-18 09:16:43",
"review.review": "\"I highly recommend this company to anyone needing fast and friendly service.\"",
"review.author": "Calvin G.",
"review.time": "01/28/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"46": {
"review.id": 46,
"review.ts": "2023-10-18 09:16:43",
"review.review": "Excellent service and Proficient in every way!!!!!",
"review.author": "Jeff D.",
"review.time": "01/28/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"47": {
"review.id": 47,
"review.ts": "2023-10-18 09:16:43",
"review.review": "my truck broke down on the interstate and they took care of me in a very timely manner very friendly driver and good prices",
"review.author": "Jeff K.",
"review.time": "01/22/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"48": {
"review.id": 48,
"review.ts": "2023-10-18 09:16:43",
"review.review": "had my truck towed off 65 today, the driver showed up faster than I expected. loaded me quick and got us on our way. thanks for the speedy service and professional attention.",
"review.author": "chris.wilson.731",
"review.time": "06/05/14",
"review.rating_stars": "five",
"review.collect": "1"
},
"49": {
"review.id": 49,
"review.ts": "2023-10-18 09:16:43",
"review.review": "I would recommend this company to anyone that needs assistance!!!My vehicle broke down on the side of the highway a couple of days ago and I called Hoover Towing. They were there fast and the gentleman was polite, professional, and courteous. I would definatly use this company again!",
"review.author": "sweetcakez",
"review.time": "02/16/10",
"review.rating_stars": "five",
"review.collect": "2"
},
"50": {
"review.id": 50,
"review.ts": "2023-10-18 09:16:43",
"review.review": "If you're in need of a tow, this is the company to call! I called to have my 1968 Pontiac GTO towed and the people took care of my vehicle AND me like I have never seen with any other company. Most towing companies have grungy looking drivers and dirty, smelly trucks. NOT THIS COMPANY! The drivers are professional inside and out and the trucks are CLEAN! I would recommend this company to ANYONE that needs a tow because this company treats your vehicle as if it were their own.",
"review.author": "purty68",
"review.time": "02/16/10",
"review.rating_stars": "five",
"review.collect": "2"
}
} |
{
"32": {
"_image_slug.id": 32,
"_image_slug.ts": "2023-10-18 09:16:43"
},
"33": {
"_image_slug.id": 33,
"_image_slug.ts": "2023-10-18 09:16:43"
},
"34": {
"_image_slug.id": 34,
"_image_slug.ts": "2023-10-18 09:16:43"
},
"35": {
"_image_slug.id": 35,
"_image_slug.ts": "2023-10-18 09:16:43"
}
} |
||||
14 | 2023-10-18 09:16:57 | Exhaust Shop | http://theexhaustshop.net | 205-402-9700 | 109 David Green Rd, Birmingham, AL, 35244 | 35244 | 33.34669 | -86.80236 | "Mo-Fr 08:00-17:00" | 1 | 5 | {} | {} | { "85": { "brand_x_auto_service.id": 85, "brand.id": 20, "brand.ts": "2023-10-18 09:09:37", "brand.brand": "Ford" }, "86": { "brand_x_auto_service.id": 86, "brand.id": 86, "brand.ts": "2023-10-18 09:16:57", "brand.brand": "Dodge and Chevy" } } | {
"179": {
"category_x_auto_service.id": 179,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"181": {
"category_x_auto_service.id": 181,
"category.id": 8,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Parts & Supplies"
},
"180": {
"category_x_auto_service.id": 180,
"category.id": 55,
"category.ts": "2023-10-18 09:10:18",
"category.category": "Automobile Accessories"
},
"178": {
"category_x_auto_service.id": 178,
"category.id": 99,
"category.ts": "2023-10-18 09:11:55",
"category.category": "Mufflers & Exhaust Systems"
},
"182": {
"category_x_auto_service.id": 182,
"category.id": 182,
"category.ts": "2023-10-18 09:16:57",
"category.category": "Automobile Performance, Racing & Sports Car Equipment"
}
} |
{
"14": {
"city_x_auto_service.id": 14,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"17823": {
"city_x_auto_service.id": 17823,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {} | {
"51": {
"review.id": 51,
"review.ts": "2023-10-18 09:16:57",
"review.review": "Very reasonable, a pleasure to do business with.",
"review.author": "Ralph E.",
"review.time": "01/07/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"52": {
"review.id": 52,
"review.ts": "2023-10-18 09:16:57",
"review.review": "They do great work here.I left this shop with a great sounding truck and better fuel milage.",
"review.author": "mrbean123",
"review.time": "10/22/09",
"review.rating_stars": "five",
"review.collect": "1"
},
"53": {
"review.id": 53,
"review.ts": "2023-10-18 09:16:57",
"review.review": "Excellent work,nice clean shop with very polite employees.",
"review.author": "mufflerman1",
"review.time": "10/21/09",
"review.rating_stars": "five",
"review.collect": "1"
},
"54": {
"review.id": 54,
"review.ts": "2023-10-18 09:16:57",
"review.review": "I have used The Exhaust Shop on several vehicles that I owned and never once had a lick of trouble out of any of them and would recommend the Exhaust Shop to anyone whether it's in need of a repair or a complete exhaust system. He put an entire Magnaflow (r) System of my 05' F250 and it sounded awesome and Curtis goes the extra mile to make sure that it is installed right. This was a bolt on kit and it didn't exactly bolt-on as the manual indicated, so Curtis worked his magic and I had an awesome exhaust system that improved my torque, fuel mileage, and it sounded great. He's one of the most talented welders I've ever run across and I would recommend The Exhaust Shop to anyone in the market for repair or upgrades. He also sells upgrades besides exhaust systems (Chips, Comp Programmers, etc.) Great Guy, Great Business, A++++",
"review.author": "YPMobile User",
"review.time": "09/29/08",
"review.rating_stars": "five",
"review.collect": "5"
}
} |
{} | |||||
15 | 2023-10-18 09:17:15 | Courtesy Buick-GMC | http://www.courtesybirmingham.com | 205-836-2000 | 1857 Edwards Lake Rd, Birmingham, AL, 35235 | 35235 | 33.599766 | -86.65029 | courtesy@bellsouth.net | "Mo-Fr 08:00-19:00","Sa 08:00-18:00" | For us, "customer service" means making your car buying experience as easy and enjoyable as possible. We are proud to be General Motor's top-selling Buick GMC dealer in the state of Alabama. We believe that we are here to serve you regardless of where you live. Give us a call or come by for a test drive today. We are here to meet all your vehicle needs whether you are looking for new or pre-owned, we've got you covered. We have the largest selection of Buicks and GMC trucks in Alabama. In fact, we have over 9 acres of inventory to choose from. So come by, pick out the vehicle whether it be a car, truck, or SUV and get the best deal around. With the great factory incentives in place on all new GM models, you can save thousands of dollars. |
Auto Parts | { "22": { "auto_service_detail.id": 22, "auto_service_detail.ts": "2023-10-18 09:17:15", "auto_service_detail.key": "Parking", "auto_service_detail.value": "Lot, Free" } } | {} | { "87": { "brand_x_auto_service.id": 87, "brand.id": 15, "brand.ts": "2023-10-18 09:09:37", "brand.brand": "Buick" }, "88": { "brand_x_auto_service.id": 88, "brand.id": 21, "brand.ts": "2023-10-18 09:09:37", "brand.brand": "GMC" } } | {
"190": {
"category_x_auto_service.id": 190,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"191": {
"category_x_auto_service.id": 191,
"category.id": 25,
"category.ts": "2023-10-18 09:09:22",
"category.category": "Automobile Body Repairing & Painting"
},
"192": {
"category_x_auto_service.id": 192,
"category.id": 192,
"category.ts": "2023-10-18 09:17:15",
"category.category": "Automobile Leasing"
},
"193": {
"category_x_auto_service.id": 193,
"category.id": 193,
"category.ts": "2023-10-18 09:17:15",
"category.category": "New Truck Dealers"
},
"194": {
"category_x_auto_service.id": 194,
"category.id": 194,
"category.ts": "2023-10-18 09:17:15",
"category.category": "Used Truck Dealers"
}
} |
{ "15": { "city_x_auto_service.id": 15, "city.id": 1, "city.ts": "2023-10-15 04:01:17", "city.city": "Birmingham", "state.id": 1, "state.ts": "2023-10-15 03:33:45", "state.state": "Alabama" } } | {
"38": {
"image_slug.id": 38,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"24": {
"image.id": 24,
"image.ts": "2023-11-15 06:05:40",
"image.source_url": "https://i3.ypcdn.com/blob/5095aff77cf5b65fdeb0f57427b2792071008cc5_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "4af9f76d455f58c0a6496850786253b85cfb0db9",
"image.size": 82011,
"image.path": "/4a/f9/f7/6d/4af9f76d455f58c0a6496850786253b85cfb0db9.jpg",
"image.title": ""
}
}
}
} |
{
"147": {
"payment_x_auto_service.id": 147,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"148": {
"payment_x_auto_service.id": 148,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"149": {
"payment_x_auto_service.id": 149,
"payment.id": 3,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "FINANCING AVAILABLE"
},
"150": {
"payment_x_auto_service.id": 150,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"151": {
"payment_x_auto_service.id": 151,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"152": {
"payment_x_auto_service.id": 152,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"153": {
"payment_x_auto_service.id": 153,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
}
} |
{} | {
"38": {
"_image_slug.id": 38,
"_image_slug.ts": "2023-10-18 09:17:15"
},
"39": {
"_image_slug.id": 39,
"_image_slug.ts": "2023-10-18 09:17:15"
},
"40": {
"_image_slug.id": 40,
"_image_slug.ts": "2023-10-18 09:17:15"
},
"41": {
"_image_slug.id": 41,
"_image_slug.ts": "2023-10-18 09:17:15"
}
} |
||||
16 | 2023-10-29 09:01:05 | Precision Sales & Service Inc | http://www.workhorseservice.com | 205-591-2266 | 451 64th Pl S, Birmingham, AL, 35212 | 35212 | 33.541462 | -86.73809 | bgamel@alternatefuel.com | "Mo-Fr 07:30-17:00" | We specialize in keeping parts on hand and ship right away.We carry all many parts: Chassis parts,brake hoses, disc pads, calipers, rotors, steering, suspension,throttle sway bars,air conditioner,valves,hub caps,exhaust,drive belts & ignition switches | Auto Parts Auto Repairs | {} | {
"35": {
"auto_service_menu.id": 35,
"auto_service_menu.ts": "2023-11-12 21:57:09",
"auto_service_menu.category": "Engine and Exhaust System",
"auto_service_menu.auto_service_menu_detail_id": {
"85": {
"auto_service_menu_detail.id": 85,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Oil Change",
"auto_service_menu_detail.description": ""
},
"86": {
"auto_service_menu_detail.id": 86,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Exhaust System Repair",
"auto_service_menu_detail.description": ""
}
}
},
"36": {
"auto_service_menu.id": 36,
"auto_service_menu.ts": "2023-11-12 21:57:09",
"auto_service_menu.category": "Steering and Suspension",
"auto_service_menu.auto_service_menu_detail_id": {
"87": {
"auto_service_menu_detail.id": 87,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Suspension Service/Repair",
"auto_service_menu_detail.description": ""
},
"88": {
"auto_service_menu_detail.id": 88,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Steering Service/Repair",
"auto_service_menu_detail.description": ""
}
}
},
"37": {
"auto_service_menu.id": 37,
"auto_service_menu.ts": "2023-11-12 21:57:09",
"auto_service_menu.category": "Heating and Cooling",
"auto_service_menu.auto_service_menu_detail_id": {
"89": {
"auto_service_menu_detail.id": 89,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Air Conditioning Service/Repair",
"auto_service_menu_detail.description": ""
},
"90": {
"auto_service_menu_detail.id": 90,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Radiator Service/Repair",
"auto_service_menu_detail.description": ""
}
}
},
"38": {
"auto_service_menu.id": 38,
"auto_service_menu.ts": "2023-11-12 21:57:09",
"auto_service_menu.category": "Brakes",
"auto_service_menu.auto_service_menu_detail_id": {
"91": {
"auto_service_menu_detail.id": 91,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Brake Service",
"auto_service_menu_detail.description": ""
}
}
},
"39": {
"auto_service_menu.id": 39,
"auto_service_menu.ts": "2023-11-12 21:57:09",
"auto_service_menu.category": "Electrical and Electronic",
"auto_service_menu.auto_service_menu_detail_id": {
"92": {
"auto_service_menu_detail.id": 92,
"auto_service_menu_detail.ts": "2023-11-12 21:57:09",
"auto_service_menu_detail.title": "Battery Service",
"auto_service_menu_detail.description": ""
}
}
}
} |
{ "105": { "brand_x_auto_service.id": 105, "brand.id": 44, "brand.ts": "2023-10-18 09:12:15", "brand.brand": "AC Delco" } } | {
"226": {
"category_x_auto_service.id": 226,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"225": {
"category_x_auto_service.id": 225,
"category.id": 8,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Parts & Supplies"
},
"228": {
"category_x_auto_service.id": 228,
"category.id": 9,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Brake Repair"
},
"230": {
"category_x_auto_service.id": 230,
"category.id": 24,
"category.ts": "2023-10-18 09:09:06",
"category.category": "Recreational Vehicles & Campers-Repair & Service"
},
"231": {
"category_x_auto_service.id": 231,
"category.id": 41,
"category.ts": "2023-10-18 09:09:37",
"category.category": "Truck Service & Repair"
},
"227": {
"category_x_auto_service.id": 227,
"category.id": 55,
"category.ts": "2023-10-18 09:10:18",
"category.category": "Automobile Accessories"
},
"229": {
"category_x_auto_service.id": 229,
"category.id": 99,
"category.ts": "2023-10-18 09:11:55",
"category.category": "Mufflers & Exhaust Systems"
}
} |
{
"16": {
"city_x_auto_service.id": 16,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18626": {
"city_x_auto_service.id": 18626,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"176": {
"payment_x_auto_service.id": 176,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"177": {
"payment_x_auto_service.id": 177,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"178": {
"payment_x_auto_service.id": 178,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"179": {
"payment_x_auto_service.id": 179,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
}
} |
{} | {} | ||||
17 | 2023-10-18 09:19:48 | Huffstutler Paint & Body | 205-252-1265 | 712 Graymont Ave N, Birmingham, AL, 35203 | 35203 | 33.51148 | -86.82529 | bshop522@all.net | "Mo-Fr 06:30-16:30" | {} | {} | {
"141": {
"brand_x_auto_service.id": 141,
"brand.id": 48,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Acura"
},
"142": {
"brand_x_auto_service.id": 142,
"brand.id": 36,
"brand.ts": "2023-10-18 09:10:23",
"brand.brand": "Audi"
},
"143": {
"brand_x_auto_service.id": 143,
"brand.id": 37,
"brand.ts": "2023-10-18 09:10:23",
"brand.brand": "BMW"
},
"144": {
"brand_x_auto_service.id": 144,
"brand.id": 15,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Buick"
},
"145": {
"brand_x_auto_service.id": 145,
"brand.id": 16,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Cadillac"
},
"146": {
"brand_x_auto_service.id": 146,
"brand.id": 17,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Chevrolet"
},
"147": {
"brand_x_auto_service.id": 147,
"brand.id": 54,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Chrysler-Plymouth"
},
"148": {
"brand_x_auto_service.id": 148,
"brand.id": 19,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Dodge"
},
"149": {
"brand_x_auto_service.id": 149,
"brand.id": 20,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Ford"
},
"150": {
"brand_x_auto_service.id": 150,
"brand.id": 21,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "GMC"
},
"151": {
"brand_x_auto_service.id": 151,
"brand.id": 22,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Honda"
},
"152": {
"brand_x_auto_service.id": 152,
"brand.id": 59,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Hyundai"
},
"153": {
"brand_x_auto_service.id": 153,
"brand.id": 60,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Infiniti"
},
"154": {
"brand_x_auto_service.id": 154,
"brand.id": 61,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Isuzu"
},
"155": {
"brand_x_auto_service.id": 155,
"brand.id": 38,
"brand.ts": "2023-10-18 09:10:23",
"brand.brand": "Jaguar"
},
"156": {
"brand_x_auto_service.id": 156,
"brand.id": 63,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Jeep"
},
"157": {
"brand_x_auto_service.id": 157,
"brand.id": 64,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Kia"
},
"158": {
"brand_x_auto_service.id": 158,
"brand.id": 65,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Land Rover / Range Rover"
},
"159": {
"brand_x_auto_service.id": 159,
"brand.id": 66,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Lexus"
},
"160": {
"brand_x_auto_service.id": 160,
"brand.id": 67,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Lincoln-Mercury"
},
"161": {
"brand_x_auto_service.id": 161,
"brand.id": 25,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Mazda"
},
"162": {
"brand_x_auto_service.id": 162,
"brand.id": 69,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Mercedes-Benz"
},
"163": {
"brand_x_auto_service.id": 163,
"brand.id": 70,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Mitsubishi"
},
"164": {
"brand_x_auto_service.id": 164,
"brand.id": 26,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Nissan"
},
"165": {
"brand_x_auto_service.id": 165,
"brand.id": 27,
"brand.ts": "2023-10-18 09:09:37",
"brand.brand": "Oldsmobile"
},
"166": {
"brand_x_auto_service.id": 166,
"brand.id": 73,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Pontiac"
},
"167": {
"brand_x_auto_service.id": 167,
"brand.id": 75,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Saab"
},
"168": {
"brand_x_auto_service.id": 168,
"brand.id": 76,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Saturn"
},
"169": {
"brand_x_auto_service.id": 169,
"brand.id": 77,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Subaru"
},
"170": {
"brand_x_auto_service.id": 170,
"brand.id": 78,
"brand.ts": "2023-10-18 09:15:11",
"brand.brand": "Suzuki"
},
"171": {
"brand_x_auto_service.id": 171,
"brand.id": 1,
"brand.ts": "2023-10-18 09:05:07",
"brand.brand": "Toyota"
},
"172": {
"brand_x_auto_service.id": 172,
"brand.id": 42,
"brand.ts": "2023-10-18 09:10:23",
"brand.brand": "Volkswagen"
},
"173": {
"brand_x_auto_service.id": 173,
"brand.id": 43,
"brand.ts": "2023-10-18 09:10:23",
"brand.brand": "Volvo"
}
} |
{
"306": {
"category_x_auto_service.id": 306,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"312": {
"category_x_auto_service.id": 312,
"category.id": 11,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Tire Dealers"
},
"307": {
"category_x_auto_service.id": 307,
"category.id": 13,
"category.ts": "2023-10-18 09:08:06",
"category.category": "Automobile Air Conditioning Equipment-Service & Repair"
},
"305": {
"category_x_auto_service.id": 305,
"category.id": 25,
"category.ts": "2023-10-18 09:09:22",
"category.category": "Automobile Body Repairing & Painting"
},
"309": {
"category_x_auto_service.id": 309,
"category.id": 28,
"category.ts": "2023-10-18 09:09:33",
"category.category": "Automobile Customizing"
},
"310": {
"category_x_auto_service.id": 310,
"category.id": 37,
"category.ts": "2023-10-18 09:09:37",
"category.category": "Automotive Tune Up Service"
},
"314": {
"category_x_auto_service.id": 314,
"category.id": 41,
"category.ts": "2023-10-18 09:09:37",
"category.category": "Truck Service & Repair"
},
"311": {
"category_x_auto_service.id": 311,
"category.id": 74,
"category.ts": "2023-10-18 09:10:26",
"category.category": "Dent Removal"
},
"315": {
"category_x_auto_service.id": 315,
"category.id": 80,
"category.ts": "2023-10-18 09:10:26",
"category.category": "Windshield Repair"
},
"308": {
"category_x_auto_service.id": 308,
"category.id": 308,
"category.ts": "2023-10-18 09:19:48",
"category.category": "Automobile Body Shop Equipment & Supplies"
},
"313": {
"category_x_auto_service.id": 313,
"category.id": 313,
"category.ts": "2023-10-18 09:19:48",
"category.category": "Truck Painting & Lettering"
}
} |
{
"17": {
"city_x_auto_service.id": 17,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18056": {
"city_x_auto_service.id": 18056,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"228": {
"payment_x_auto_service.id": 228,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
},
"229": {
"payment_x_auto_service.id": 229,
"payment.id": 2,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "CHECK"
},
"230": {
"payment_x_auto_service.id": 230,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"231": {
"payment_x_auto_service.id": 231,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"232": {
"payment_x_auto_service.id": 232,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"233": {
"payment_x_auto_service.id": 233,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"234": {
"payment_x_auto_service.id": 234,
"payment.id": 8,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DINERSCLUB"
}
} |
{
"60": {
"review.id": 60,
"review.ts": "2023-10-18 09:19:48",
"review.review": "Not only did they do an excellent job on my car, but they were the lowest price out of (4) different estimates, and they completed it before anyone else could even take it. Can't recommend them enough!",
"review.author": "William M.",
"review.time": "01/15/16",
"review.rating_stars": "five",
"review.collect": "1"
},
"61": {
"review.id": 61,
"review.ts": "2023-10-18 09:19:48",
"review.review": "Huffstutler Paint & Body did an EXCELLENT job on my truck. In fact, it is better than it ever was before the wreck. Each person I dealt with was very professional and courteous. I would HIGHLY recommend them to anyone needing body work to their vehicle.",
"review.author": "Larry R.",
"review.time": "05/20/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"62": {
"review.id": 62,
"review.ts": "2023-10-18 09:19:48",
"review.review": "Just had my Toyota Tacoma repaired at Huffstutler paint and body. My insurance wanted d me to take my car to another shop that they had set up. I explained to them, that if any body was going to repair my truck it was going to be Jamie Huffstutler he's been repairing my family's cars for several years now. He's always open and always get info available even if I don't fix",
"review.author": "James H.",
"review.time": "05/16/15",
"review.rating_stars": "five",
"review.collect": "1"
},
"63": {
"review.id": 63,
"review.ts": "2023-10-18 09:19:48",
"review.review": "I WAS TRAVELING FROM TUPELO MS ON MY FAMILY VACATION FOR THANKS I ING TO SAVANNAH GA AMONGST THE WAY HAS D AN UNFORTUNATE ENCOUNTER WITH A DEER. MY INSURANCE COMPANY SUGGESTED HUFFSTUTLER PAINTED AND BODY AND THEY WE'RE OPEN OFFICE. THE THE DAY BEFORE THANKSNKSGIVING. NOT ONLY WE'RE THEY OPEN THEY HELPED ME GET A RENTAL CAR WHEN EVERYONE WAS TELLING ME THAT THIS WAS NOT POSSIBLE. IF IT HADNT BEEN FOR HUFFSTUTLER PAIINT A D BODY MY TRIP WOULD HAVE ENDED IN BIRMINGHAM 9 HOURS SHORT OF MY DESTINATION I WILL NEVER FOR GET WHAT THEY DONE FOR ME AND MY FAMILY AND BY THE WAY I HAVE MY CAR BACK NOW A 2014 CHEVY IMPALA AND ITS LOOK AS GOOD NOW AS IT EVERYONE DID. MR CARTER",
"review.author": "Jamie H.",
"review.time": "12/07/14",
"review.rating_stars": "five",
"review.collect": "1"
},
"64": {
"review.id": 64,
"review.ts": "2023-10-18 09:19:48",
"review.review": "Ridiculous body shop would never go there again.",
"review.author": "Alex S.",
"review.time": "05/10/14",
"review.rating_stars": "one",
"review.collect": "1"
},
"65": {
"review.id": 65,
"review.ts": "2023-10-18 09:19:48",
"review.review": "Hello everyone!Huffstutler body shop is unprofessional and irresponsible!I took my BMW 5 series and all needed parts for complete repair to the Huffstutler body shop on 12/09/13 and have been promised it will be repaired in aprox. two weeks. six weeks later (01/22/14) they told me I can get my car back, but when I got there my car was apart, all needed parts for repair were not in the car anymore, my steering wheel was off center, active steering light on and exterior and interior were very dirty. Jemie Huffstutler' (owner) said that technician who worked on my car quit in the middle of the repair and he was guessing that cleaning people threw all my parts away, but he said don't worry he will find or buy needed parts to complete repair. Five weeks later 02/25/14 they refuse to buy needed parts for repair and their manager said he has no time to order parts for me and he was even yelling at me at times. Jemie Huffstutler said he is not going to complete repair because he already spend to much money bying parts. So they returned my car to me after three month instead of promissed two weeks, with missing parts very dirty not aligned with active steering light on the dash. So they took my $2250 for complete repair but they never completed it and I had to spend additional $800 on parts $200 on detailing and $180 for alignment. also after diagnosis I found my active steering light was on because of the damaged module software ( my guess because they shorted or didn't maintain battery properly). fortunately I could programm module with my laptop after what my steering wheel went to center by it's self and steering light went away ( program module at the dealership could be around $200).",
"review.author": "Alexey L.",
"review.time": "04/24/14",
"review.rating_stars": "one",
"review.collect": "1"
},
"66": {
"review.id": 66,
"review.ts": "2023-10-18 09:19:48",
"review.review": "Huffstutler did a great job on my mercury grand marquis they met all factory specifications on installing my fender it looks fresh out of the factory",
"review.author": "dave1229",
"review.time": "03/08/13",
"review.rating_stars": "five",
"review.collect": "1"
},
"67": {
"review.id": 67,
"review.ts": "2023-10-18 09:19:48",
"review.review": "I have used Huffstutler Paint and Body for the last 8 years on a number of my cars and I have sent all my friends, that want there car back in a reasonable time to them. My family has been around this sort of industry for over 25 years and we have never had any , no not one single problem , from Mr Huffstutler or his staff. its very nice to go in to the front door knowing your going to see the same people every time . that's very comforting for my wife and daughters to have a nice man in the Birmingham area that will stop at a drop of the hat to help them when I'm out of town on business . People don't read or believe everything from one experience, take my advice he hasn't been there for 25 plus years doing it the wrong way COME ON",
"review.author": "bltcorn",
"review.time": "11/30/12",
"review.rating_stars": "five",
"review.collect": "1"
},
"68": {
"review.id": 68,
"review.ts": "2023-10-18 09:19:48",
"review.review": "It is bad to have a wreck, but the good thing is that Huffstutler can fix it. I have used Huffstutler to repair all four of my vehicles over the past two years and have been perfectly satisfied with every job. They have been courteous, helpful and prompt in returning our cars to us. They have at times gone beyond what was required to help us, such as in the ice storm two years ago, putting themselves at risk to tow our car in. I would highly recommend Huffstutler Paint and Body.",
"review.author": "bd1947",
"review.time": "11/29/12",
"review.rating_stars": "five",
"review.collect": "1"
},
"69": {
"review.id": 69,
"review.ts": "2023-10-18 09:19:48",
"review.review": "DO NOT USE HUFFSTULER PAINT AND BODY!!!!I took my car there for a simple repair. I hit a dog and it caused damage to the under part of my car. They had to remove the bumper to repair the damage. When I went pick up the car the crease between the bumper and the fender was big enough to put my finger in and when I pushed on it the sides of the bumper pushed out further. I asked them about this and they pushed it in with their knee. They didn't remove the bright white stickers from the black ground work on the bottom of my car. I ask them remove the stickers and they made me wait on hour and still left white bits of stickers on the car and said they repaired the bumper. I left and by the time I got home the bumper had popped back out. I called them the next day and they said that I must have hit a parking block or a curb but I could bring it back in and they would look at it. I was so mad since they knew it was doing that when I left. When I returned they wanted to charge me for clips to hold the sides of my bumper tite. I paid it after much debate but it still wasn't at tite as it was before the accident. The worse part is I know the owners family personally and I was still treated horribly. My car is all factory with no after market parts so this should have been an easy repair. My car still isn't repaired correctly but its just not worth going there and being treated poorly or telling his Mom Sandra about it. Its just sad that you get such bad service from people you thought you could trust and learn that the don't stand behind their work and have no pride in their business.",
"review.author": "encore",
"review.time": "04/03/12",
"review.rating_stars": "one",
"review.collect": "1"
},
"70": {
"review.id": 70,
"review.ts": "2023-10-18 09:19:48",
"review.review": "DO NOT TAKE YOUR CAR TO HAVE BODY FIXED!! i know i'm writing this late but i never thought of posting this to help someone until now. i was in an auto accident in sept. my car was hit from behind and was damaged pretty bad. i took it to the dealership where i bought it and had them run an estimate. they gave me the price and it was definitely a fine cost. i had to wait for the other driver's insurance company to call me though to see what i could do before i have it worked on. sure enough the insurance agent (who was just as a bad an agent as this business) told me that they could immediately take my car to be picked up from my house and taken to huffstutler to be fixed within a week. the agent persuaded me by saying the parts on my car would be guarenteed for as long as i owned the car. so i decided to take it to huffstutler because who would want to keep fixing a car for free?? i was soooo very wrong..when i got my car back in 2 weeks instead of one, i could already tell something wasn't right. say you have a piece of plastic, lets say a pen top. whenever you bend the pen top then straighten it back out, you still see where the plastic was bent at because it's white in that area. well thats how the insdie of my car looked. the plastic had all the bent white spots in it. i asked both the agent and mechanic why it was like that and they said it was because they used the original plastic. i couldnt believe it! i questioned how safe it was and they just looked at me and said it was just as good. the mechanic told me that they couldn't replace it because the plastic hadn't been punctured. so i began looking around the rest of my car and noticed that every single plastic aligning the doors could pop off with one little lift. the vehicle i own is a small suv and the back door lifts up. when i opened it, it made a real funny noise. he told me it was the pressure in the bars that open it. now i know i'm a woman and may not know much about cars but that did not sound like pressure. it sounded like a creaking noise... and also they left black glue residue all over the inside, top part of my car. luckily they got off the glue but i didn't understand why they couldn't fix that instead of leaving it there for me to see and complain about. both men kept reassuring me that this is all normal even though i don't ever remember it being like this especially since i had just bought the car 7months before.. so since i could see things that were not fixed, i was very curious to find out what other parts weren't. i went back to the dealership that originally saw my car both before i bought it and the day of the wreck... they couldn't believe what they saw. first off they didnt even attach the bumper. it was on there but it wasn't even locked in place so it just would've folded in if anyone were to hit me again. secondly, the very end of my frame was bent and instead of straightening it they simply sprayed thick black spray paint on it so it would look straight. third, my door that was making the noise was not pressure but instead the top of the door rubbing against the body of my car because they didn't align it correctly.. these were the major problems as well as many others.to put into perspective: the dealership originally told me about $7,500 worth of repair was needed. huffstutler said just barelly making $5,000 worth of repair. when i took it back to the dealership to fix what huffstutler didnt the repair cost was still $5,000 to fix what they did and didn't do. so now my car is going to show $10,000 worth of repair which makes for an awful report. i tell this story all the time and warn everyone..say NO TO HUFFSTUTLER!!",
"review.author": "absterkw",
"review.time": "08/01/11",
"review.rating_stars": "one",
"review.collect": "1"
},
"71": {
"review.id": 71,
"review.ts": "2023-10-18 09:19:48",
"review.review": "My car was taken to Huffstutler's for front end damage that occurred in an auto accident. When I got my car back there were many things that were not repaired properly. I had to take it to the dealership where I had recently purchased the car and have then do all the work over again - the correct way. The owner told me that he personally went over all the repairs \"with a fine tooth comb\" before it left his shop and that all was good. He tried to tell me that anything wrong with the car must have happened when the car was en route to my house as it was delivered by an auto transport company. I wouldn't recommend this body shop to anyone, poor workmanship",
"review.author": "bradenrice",
"review.time": "12/03/10",
"review.rating_stars": "one",
"review.collect": "1"
},
"72": {
"review.id": 72,
"review.ts": "2023-10-18 09:19:48",
"review.review": "I took my car to Huffstutler for some body work and a new paint job. I was comforted by the fact that the shop had been open since 1953 and that it was a family-run business. I was quoted a very reasonable price and left my car with the shop feeling confident and excited that my car would be taken care of and would look like new.The finished product was a disappointment. The body work was pretty decent, but the paint job left much to be desired. There was overspray on my driver's side window, moderate orange peel over the entire car, cracks in the paint by the roof trim, and pinholes in a few areas from solvent in the paint itself escaping. After a blister developed on one of my side mirrors, I decided to take the car back to see if the shop would be willing to fix the problems. The owner offered to repaint the mirror and rebuff the car (for the orange peel). I agreed and picked my car up the next day. The orange peel was slightly better and the mirror had indeed been repaired. The cracks near the roof trim had been touched up with clear coat and the owner assured me that the paint wouldn't peel. If it did, he said, he would fix it. This wasn't extremely reassuring for me, but I decided to leave well enough alone and not insist on perfection. However, over the next week or so, I noticed distinctive marks in the clear coat that are called holograms. These marks are wavy swirls left behind by the improper use of a rotary buffer. I was very frustrated, but decided at that point that taking the car back a third time probably wouldn't result in my satisfaction and would only waste everyone's time.A few weeks passed as I read about paint correction and how I could go about bringing the car's appearance up to my standards. I couldn't get past the fact that they had made such a mistake and it bothered me to think that they assumed that I was another happy customer. When I called the owner to register my disappointment with the paint job, he tried to tell me that I simply needed to wax the car and the marks would be gone. I felt insulted by this recommendation. Wax would help to mask the marring that the buffer inflicted, but the bottom line is that those marks shouldn't be there in the first place. The only way to fix them is to polish the paint down so that the tiny scratches are gone. The owner basically admitted that they applied a glaze to hide the imperfections and told me that I just needed to cover them up some more. He offered to take a look at the car to see if he thought it needed to be polished again, but I told him that I would just prefer to fix it myself at this point.All in all, I am incredibly disappointed with Huffstutler Paint and Body and would highly suggest that potential customers look elsewhere for their paint jobs.",
"review.author": "jessicah08",
"review.time": "08/11/09",
"review.rating_stars": "one",
"review.collect": "1"
}
} |
{} | |||||||
18 | 2023-10-29 09:02:12 | World Class Auto Repair | http://www.worldcarinc.com | 205-591-7990 | 4710 5th Ave S, Birmingham, AL, 35222 | 35222 | 33.528015 | -86.76125 | worldcar.bham@aol.com | "Mo-Fr 07:30-17:00" | Eureopean automobile service and repairs. We have been in business in the same location sine 1985. | Mercedes, BMW, Ferrari, Infinity, Jaguar, Lexus, Lamborghini, Lotus.Bosch Service, Bosch Automotive Systems, Automotive, A/C Heating Service & Repair, World Class Auto Repair, Tune-Ups, Brakes, Oil Change, We have dealer level diagnostics for Mercedes & BMW--Your Dealer Alternative. | {} | {
"40": {
"auto_service_menu.id": 40,
"auto_service_menu.ts": "2023-11-12 21:57:20",
"auto_service_menu.category": "Engine and Exhaust System",
"auto_service_menu.auto_service_menu_detail_id": {
"93": {
"auto_service_menu_detail.id": 93,
"auto_service_menu_detail.ts": "2023-11-12 21:57:20",
"auto_service_menu_detail.title": "Oil Change",
"auto_service_menu_detail.description": ""
}
}
},
"41": {
"auto_service_menu.id": 41,
"auto_service_menu.ts": "2023-11-12 21:57:20",
"auto_service_menu.category": "Transmission and Drivetrain",
"auto_service_menu.auto_service_menu_detail_id": {
"94": {
"auto_service_menu_detail.id": 94,
"auto_service_menu_detail.ts": "2023-11-12 21:57:20",
"auto_service_menu_detail.title": "Transmission Service",
"auto_service_menu_detail.description": ""
}
}
},
"42": {
"auto_service_menu.id": 42,
"auto_service_menu.ts": "2023-11-12 21:57:20",
"auto_service_menu.category": "Heating and Cooling",
"auto_service_menu.auto_service_menu_detail_id": {
"95": {
"auto_service_menu_detail.id": 95,
"auto_service_menu_detail.ts": "2023-11-12 21:57:20",
"auto_service_menu_detail.title": "Radiator Service/Repair",
"auto_service_menu_detail.description": ""
}
}
},
"43": {
"auto_service_menu.id": 43,
"auto_service_menu.ts": "2023-11-12 21:57:20",
"auto_service_menu.category": "Brakes",
"auto_service_menu.auto_service_menu_detail_id": {
"96": {
"auto_service_menu_detail.id": 96,
"auto_service_menu_detail.ts": "2023-11-12 21:57:20",
"auto_service_menu_detail.title": "Brake Service",
"auto_service_menu_detail.description": ""
}
}
},
"44": {
"auto_service_menu.id": 44,
"auto_service_menu.ts": "2023-11-12 21:57:20",
"auto_service_menu.category": "Electrical and Electronic",
"auto_service_menu.auto_service_menu_detail_id": {
"97": {
"auto_service_menu_detail.id": 97,
"auto_service_menu_detail.ts": "2023-11-12 21:57:20",
"auto_service_menu_detail.title": "Battery Service",
"auto_service_menu_detail.description": ""
}
}
}
} |
{ "174": { "brand_x_auto_service.id": 174, "brand.id": 174, "brand.ts": "2023-10-18 09:20:10", "brand.brand": "Bosch" } } | { "316": { "category_x_auto_service.id": 316, "category.id": 2, "category.ts": "2023-10-18 09:05:07", "category.category": "Auto Repair & Service" } } | {
"18": {
"city_x_auto_service.id": 18,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18627": {
"city_x_auto_service.id": 18627,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"235": {
"payment_x_auto_service.id": 235,
"payment.id": 17,
"payment.ts": "2023-10-18 09:08:06",
"payment.payment": "MASTER CARD"
},
"236": {
"payment_x_auto_service.id": 236,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
},
"237": {
"payment_x_auto_service.id": 237,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"238": {
"payment_x_auto_service.id": 238,
"payment.id": 1,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DEBIT"
}
} |
{} | {} | ||||
19 | 2023-10-29 09:02:24 | General Automotive Svc Co | http://www.acdelco.com | 205-788-6505 | 2316 Avenue E, Birmingham, AL, 35218 | 35218 | 33.509727 | -86.89981 | johndoe@email.com | "Mo-Fr 08:00-16:30" | Life is about choices isnt it? And some are better than others. We abide by decisions based on positive experiences and those where we gain the most trust. We not only understand this, our success depends on achieving this end goal with every customer. We put our reputation on the line each day because we know you have many choices when it comes to taking your car in for repairs or where you buy your parts. At the end of the day, its all about service. Did we deliver on meeting your needs and expectations? |
{} | {
"54": {
"auto_service_menu.id": 54,
"auto_service_menu.ts": "2023-11-12 21:57:32",
"auto_service_menu.category": "Basic Services",
"auto_service_menu.auto_service_menu_detail_id": {
"124": {
"auto_service_menu_detail.id": 124,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Lube, Oil & Filter Service",
"auto_service_menu_detail.description": ""
},
"125": {
"auto_service_menu_detail.id": 125,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Auto Transmission Service - Pan",
"auto_service_menu_detail.description": ""
},
"126": {
"auto_service_menu_detail.id": 126,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Auto Transmission Service - Flush",
"auto_service_menu_detail.description": ""
},
"127": {
"auto_service_menu_detail.id": 127,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Manual Transmission Service",
"auto_service_menu_detail.description": ""
},
"128": {
"auto_service_menu_detail.id": 128,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Differential Service",
"auto_service_menu_detail.description": ""
},
"129": {
"auto_service_menu_detail.id": 129,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Cooling System Flush with Chemical",
"auto_service_menu_detail.description": ""
},
"130": {
"auto_service_menu_detail.id": 130,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Power Steering Flush with Chemical",
"auto_service_menu_detail.description": ""
},
"131": {
"auto_service_menu_detail.id": 131,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Fuel Injection Cleaning - Flush",
"auto_service_menu_detail.description": ""
},
"132": {
"auto_service_menu_detail.id": 132,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Headlight Restoration - Both Lights",
"auto_service_menu_detail.description": ""
},
"133": {
"auto_service_menu_detail.id": 133,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Basic Brake Service",
"auto_service_menu_detail.description": ""
},
"134": {
"auto_service_menu_detail.id": 134,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Minor Tune Up - 4 Cylinder",
"auto_service_menu_detail.description": ""
},
"135": {
"auto_service_menu_detail.id": 135,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Engine Diagnostic - Minimum 1 Hour",
"auto_service_menu_detail.description": ""
},
"136": {
"auto_service_menu_detail.id": 136,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Charging System Diagnostic - Minimum 1/2 Hour",
"auto_service_menu_detail.description": ""
},
"137": {
"auto_service_menu_detail.id": 137,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Air Conditional Service - Freon Additional",
"auto_service_menu_detail.description": ""
},
"138": {
"auto_service_menu_detail.id": 138,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Smog Inspection",
"auto_service_menu_detail.description": ""
},
"139": {
"auto_service_menu_detail.id": 139,
"auto_service_menu_detail.ts": "2023-11-12 21:57:32",
"auto_service_menu_detail.title": "Comprehensive Multi Point Inspection",
"auto_service_menu_detail.description": ""
}
}
}
} |
{ "175": { "brand_x_auto_service.id": 175, "brand.id": 44, "brand.ts": "2023-10-18 09:12:15", "brand.brand": "AC Delco" }, "176": { "brand_x_auto_service.id": 176, "brand.id": 45, "brand.ts": "2023-10-18 09:12:20", "brand.brand": "acdelco" } } | {
"317": {
"category_x_auto_service.id": 317,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"318": {
"category_x_auto_service.id": 318,
"category.id": 7,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Air Conditioning Equipment"
},
"319": {
"category_x_auto_service.id": 319,
"category.id": 8,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Automobile Parts & Supplies"
},
"321": {
"category_x_auto_service.id": 321,
"category.id": 9,
"category.ts": "2023-10-18 09:07:44",
"category.category": "Brake Repair"
},
"320": {
"category_x_auto_service.id": 320,
"category.id": 320,
"category.ts": "2023-10-18 09:20:20",
"category.category": "Automobile Parts, Supplies & Accessories-Wholesale & Manufacturers"
}
} |
{
"19": {
"city_x_auto_service.id": 19,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18629": {
"city_x_auto_service.id": 18629,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{} | {
"239": {
"payment_x_auto_service.id": 239,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"240": {
"payment_x_auto_service.id": 240,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"241": {
"payment_x_auto_service.id": 241,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
}
} |
{} | {} | |||||
20 | 2023-10-18 09:20:27 | Supreme Automotive & Collision Center | https://supremeauto205.com | 205-208-7390 | 2428 Warrior Rd, Birmingham, AL, 35208 | 35208 | 33.499126 | -86.87473 | supremeauto205@yahoo.com | "Mo-Fr 08:00-17:00","Sa 09:00-14:00" | Established in 2001, Supreme Automotive is a reputable Auto Collision & Body Shop which specializes in custom paint jobs, repairs & Pre-Owned auto sales. We also offer in-house financing and insurance claims for repairs. We consistently dedicate our efforts to guiding and advising our customers of the best vehicles on the market. We offer a wide range of options, and our professional team is here for your every need. |
{} | {} | {} | {
"328": {
"category_x_auto_service.id": 328,
"category.id": 1,
"category.ts": "2023-10-18 09:05:07",
"category.category": "New Car Dealers"
},
"327": {
"category_x_auto_service.id": 327,
"category.id": 2,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Auto Repair & Service"
},
"329": {
"category_x_auto_service.id": 329,
"category.id": 4,
"category.ts": "2023-10-18 09:05:07",
"category.category": "Used Car Dealers"
},
"330": {
"category_x_auto_service.id": 330,
"category.id": 17,
"category.ts": "2023-10-18 09:08:42",
"category.category": "Wheel Alignment-Frame & Axle Servicing-Automotive"
},
"326": {
"category_x_auto_service.id": 326,
"category.id": 25,
"category.ts": "2023-10-18 09:09:22",
"category.category": "Automobile Body Repairing & Painting"
},
"331": {
"category_x_auto_service.id": 331,
"category.id": 207,
"category.ts": "2023-10-18 09:17:32",
"category.category": "Wheels-Aligning & Balancing"
}
} |
{
"20": {
"city_x_auto_service.id": 20,
"city.id": 1,
"city.ts": "2023-10-15 04:01:17",
"city.city": "Birmingham",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
},
"18058": {
"city_x_auto_service.id": 18058,
"city.id": 6,
"city.ts": "2023-10-15 09:43:35",
"city.city": "Hoover",
"state.id": 1,
"state.ts": "2023-10-15 03:33:45",
"state.state": "Alabama"
}
} |
{
"51": {
"image_slug.id": 51,
"image_slug.ts": "2023-11-15 06:01:15",
"image_slug.image_id": {
"34": {
"image.id": 34,
"image.ts": "2023-11-15 06:06:47",
"image.source_url": "https://i3.ypcdn.com/blob/cb8a1e1cd309191b40785391528fcc984f91ba05_640.jpg",
"image.source_content_type": "image/jpeg",
"image.hash_file_content": "b1c2622105855773d4013a128c68db6b4fe0af69",
"image.size": 214064,
"image.path": "/b1/c2/62/21/b1c2622105855773d4013a128c68db6b4fe0af69.jpg",
"image.title": ""
}
}
}
} |
{
"243": {
"payment_x_auto_service.id": 243,
"payment.id": 6,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "MASTERCARD"
},
"244": {
"payment_x_auto_service.id": 244,
"payment.id": 7,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "VISA"
},
"245": {
"payment_x_auto_service.id": 245,
"payment.id": 4,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "AMEX"
},
"246": {
"payment_x_auto_service.id": 246,
"payment.id": 5,
"payment.ts": "2023-10-18 09:05:07",
"payment.payment": "DISCOVER"
}
} |
{} | { "51": { "_image_slug.id": 51, "_image_slug.ts": "2023-10-18 09:20:27" }, "52": { "_image_slug.id": 52, "_image_slug.ts": "2023-10-18 09:20:27" } } | |||||
auto_service.id | auto_service.ts | auto_service.title | auto_service.website | auto_service.telephone | auto_service.address | auto_service.postal_code | auto_service.latitude | auto_service.longitude | auto_service.email | auto_service.opening_hours | auto_service.description | auto_service.amenity | auto_service.reviews | auto_service.average_star | auto_service.service_product | auto_service.accreditation | auto_service.auto_service_detail_id | auto_service.auto_service_menu_id | auto_service.brand_x_auto_service_id | auto_service.category_x_auto_service_id | auto_service.city_x_auto_service_id | auto_service.image_slug_id | auto_service.payment_x_auto_service_id | auto_service.review_id | auto_service._image_slug_id |