I don't know if you are still looking to relocate to the Boulder, CO area. However, I would offer the following information.
You can most definitely find a property such as you are requesting with 4-5 bedrooms, 4-5 baths, and 5,000 square feet for just under 1MM.
While the city of Boulder will be out of your price range for the accomodations you are seeking, there are other neighboring communities that would fit your needs nicely.
Might I suggest, first, the community of Louisville, CO - which is located just slighly south and east of Boulder. It was voted by Money Magazine as the 3rd best community to live in the United States and the #1 best community to raise a family.
I would also suggest Lafayette, which is just slightly more east. There is a gated community called Blue Heron that would nicely fit your requirements.
Erie is another suggestion - - just further east.
Please visit my web site at http://www.vickieslade.com
for additional information about our area, area schools, biking and hiking trails, golf courses, entertainment, etc.
I would be most happy to assist you with your search. Please feel free to contact me.
Wishing you the best of luck in your search!