I was slightly leery about renting a car after reading some of the reviews. But then again, most people really only write bad reviews for rental car companies. I booked through Priceline and got an awesome deal for a compact car; the amount I paid for 6 days was equivalent to the amount previously paid for a 3 day airport car rental. Enterprise had no problems with my reservation and they had a driver pick me up from my apartment (providing an hour window) and straight to the rental car location.
The actual location is very clean so they apparently really stepped up their game. Its definitely not as chaotic as a airport rental company and the car they selected was clean and pretty impressive for a Hyundai. The attendant also reviewed the entire exterior of the car with me before sending me on my merry way. Returning the vehicle was also straight-forward. Since I had to catch a flight immediately after returning my rental, they gave me 2 options: (1) Call earlier that day and schedule someone to drive me to Skytrain for free, (2) Call 10 minutes beforehand and they arrange to have a taxi waiting. Since I did not want to risk taking the Skytrain for the first time, I opted for the taxi and they gave me an agreement slip which made the cab ride a $12 flat rate (the meter read around $12.60 so I saved some spare change).
Overall, everyone was professional and friendly and I would highly recommend renting a car from this location. As corny as this may sound, this is truly one of the best rental car companies I have come across.
One tip: I believe the hours listed on Yelp indicate that they open at 7:30 AM. However, when I called, they did not open/answer phones until 8:00 AM.