North Berwick is ok. Downtown is about 5 buildings. Pizza place, town hall, convenience store, maybe video rental? Not much to do there or eat. You can always travel to Wells (25 min) to find a nice dinner. I cant think of any areas in that town to stay away from. Its all pretty much the same.
Real estate is affordable, but.... real estate prices are very high right now. Not a good time to buy if you plan on living there short term.
Waterfront, hmmm. there is Bauneg Beg Pond. But very small.
Bauneg Beg Lake1
15 acres, cant subdivide? or not subdivided yet? If it "can" be subdivided, it sounds like it could be a good deal. At least when you retire or move you could sell off the lots. If its wetland, you'll never get it subdivided. If you cant subdivide, the taxes on 15.5 acres with a nice house and tons of water front frontage will be very, very expensive.
Another important thing to ask about land in southern maine is if it comes with a building permit. People in southern maine (anything south of sanford) sometimes wait 5 years (sometimes longer) to get a building permit because of town growth controls. If it can be subdivided, start immediately. Might take 10 years to go through the process.
This the property?
If yes, this pond is very small. I drove by it a couple of times.
Cider Mill Pond
Just my 2 cents.