We live in Fort Collins, and rental rates are RIDICULOUS. I just saw an article that said rental vacancy rates for the city are just over 3%, but in the areas close to campus, the vacancy rate is <1%. We closed on our house in Feb 2013 for $200,000, and according to the internet (Zillow, redfin, realtor.com, etc), it's worth ~ $300,000 by now. We're getting an appraisal to get rid of our PMI in the next month or two, so I'll have a better idea after that. Zillow seems to be a little optimistic.
If you're planning on buying a house ever, winter is definitely a better time. People don't want to move in the winter or something, so the market is significantly less cutthroat and prices are a little bit lower. We took a week to decide on our house, then offered 10k less than the listing, while friends who bought later in the year were making backup offers on multiple houses literally as soon as they did a walk-through, on the off chance someone's offer would fall through and they'd get an opportunity.
Overall, prices are a little cheaper in Wellington, Severance, Timnath, and Windsor. Probably Greeley, too. If you want less expensive places, you're going to have to either get out of town a little, or hope for someone with a basement apartment they're renting out :( I have no specific recommendations for Longmont specifically, though. Almost all of the new houses in Fort Collins are $400k +, and the apartments are going for upwards of $800/bedroom in 3 br units, and $1200 for studios. It's a little nuts.
Good luck!