Stay at the owners house in the private Granny Suite! New construction, full kitchen, separate private entrance, one bedroom with with queen size bed, modern bathroom with soaker tub and a separate shower, internet, couch, fire pit. Homeaway.com #9419602. 
Hotels: http://standrewsbythesea.ca/directory/category/accommodations/resorts/
Inns: http://standrewsbythesea.ca/directory/category/accommodations/inns/
Motels: http://standrewsbythesea.ca/directory/category/accommodations/motels/
B&B: http://standrewsbythesea.ca/directory/category/accommodations/bandb/
Cottages and Vacation Rentals: http://standrewsbythesea.ca/directory/category/accommodations/cottages/
Oceanfront Kiwanis Campground: 506-529-3439
Island View Campground: 506-529-3787
Oak Bay Campground: 506-466-4999
New River Beach Provincial Park
(Approx. 25 minute drive)
Information: https://www.tripadvisor.ca/Tourism-g499185-St_Stephen_New_Brunswick-Vacations.html
(Approx. 20 minute drive)
Accommodation: http://town.stgeorge.nb.ca/visitor-information/accommodations/