Play video content EXCLUSIVE TMZSports.com

They were sooooo close.

A bunch of Edmonton Oilers prospects hit the club scene in Hollywood Monday night -- but when they tried to talk a pack of smokin' hot ladies into taking the party bus back to Bakersfield, things turned ice cold.

The video is pretty hilarious ... you can see future stars like Marc-Olivier Roy (in the fur vest) and Joshua Winquist (in the backwards hat) leaving Argyle ... and the ladies were interested ... until they told 'em the final destination.

So, why Bakersfield (113 miles outside of LA)?

The guys all currently play for the Bakersfield Condors -- the Oilers' minor league team -- and clearly they were all heading back to the base camp for the night.