you can try the Cameron Ave Inn, it's across the street from our house, and right on the bike path. My parents stayed there 2 years ago, 10 days for $500. don't know what the rate would be for shorter stay, or if they have availability, though...