Section 8 is simply a program that Assists you with paying for items such as Rent.
Certain properties don't qualify for Sec 8 and certain landlords don't accept Sec. 8, but other than that...all REALTORS and Management Companies, such as my company participate in Sec. 8 qualified tenants.
As there are not too many Apartment Buildings in Red Hook, you will simply need to have your Real Estate agent pre check all rentals that meet your needs to see if they accept Sec. 8