For investors without access to the MLS.... Which websites (Trulia, Redfin, Realtor, etc.),  are most accurate and up to date? I'm wondering expressly for these two purposes.1. Recent home sales 2. Speed of which new ...

Longmont is really up and coming; the SW side closest to Boulder is really nice and has good schools, quick access to trails, etc. 

The closest you will come to accomplishing your end goals (I'm focusing on that and ignoring the particular proposed method to get there... the end goal matters, not the method) will be some of the 95% LTV jumbo stuff that is out there. 

The closest I can find is a duplex across town sold for 130k in Jan. 2016.

When he was finally done the crash happened and the closest asking price he got was still about 2 million short of what he hoped he would sell it for.

Hit your local REI club, find someone that is actually doing deals in your market and start picking their brain, offer to take out for a steak and chat, anything you can do to get advice from someone doing deals locally.

Sometimes the opportunities that are closest to us we ignore!

The furthest is 7 minutes away, the closest is 3.

Probably closest oil is in the Giddings or Luling area.  

I'd research the area to see the closest and best area for investment (review a ULI - Urban Land Institute report or some other macro study).