tle, if you can get in the 2’s or even low 3’s out there, just do it, the million plus stuff has been taking a beating but horse property is very unique, I have so little experience I can barely give advice other than getting land for tract prices, that is a go in my book.
Patent-Redhawk in general is open to the public as is the golf course, there are a few gated tracts within redhawk but most is open. I have to say, with what you are looking for, bear creek might be a beeter choice, or even canyon lake. Maybe just go to San Diego itself, say carlsbad or something. 400k for 1200-1500 sq ft. is not why you come to temecula, I honestly cant think of anything that fits that bill. Smaller places are often not as nice and old bones usually means large lot out here. This is my favorite weekender house in redhawk http://www.redfin.com/CA/Temecula/45443-Callesito-Altar-92592/home/6253916 and you can walk to the bar.
For a low maintenance, smaller, weekend place, I reccomend this tract of triplexes.
but not that unit, get one that overlooks the creek, all you can hear is frogs, and get one with a driveway, most have a two car driveway and a 2 car garage, the one I linked doesn’t have a driveway. They have a high hoa but a low tax rate so it balances out, they take care of the yardwork and it is within redhawk, will only set you back 200k and will rent easily for 1500 if you go that route ever. Most occupants are 40-60 but there are no rules about age, it just doesn’t appeal to the monster truck crowd. It is also gated.
This one went pending for 177k, but not the best location within the complex.