Finding an antenna that will receive 25 and 47 is fairly easy. The DB-8 would do well when facing 269° compass. Unfortunately, I have not seen the front/back ratio published for the DB-8 so I can't estimate if enough signal will get in the back end to offer reception of 30, 27 & 29. FWIW, the DB-8 is far more directional than is implied by some of the marketing out there.
The published specs for the
Winegard HD9095P do suggest you can expect a fair amount of signal to make it through the back. However, you will likely experience multipath problems on some or all of the signals from the rear of the antenna because the forward gain of the antenna will be aimed at potential reflected signals.
You can try a single antenna... If you are lucky you'll find a sweet spot that gives you all the stations on your wish list. If that fails, you can go to a two antenna solution using an A/B switch to select the desired antenna. The CS-2 is already proven.
A more expensive option would be to use frequency selective combiner product.
www.TinLee.com is a source. With their help you could find a way to combine two or more antennas into one coax.
A rotator is also an option... that I have gone to
some lengths to avoid.
Another FWIW, I get 90% or better reception of KVOS which is 70 miles north of my location on the back of a CM-3016. But the shot is LOS and I'm not facing a big flat reflector that would source multipath. (Point being, mileage is only a general aid to estimate signal levels, TV Fool takes into account terrain.)