Not waterfront but close. 10 minute walk to main street Orewa and eateries. Priced accordingly.