Realtor.comWho doesn't dream of a fabulous home with a spectacular view of the water? Sales of waterfront homes usually drop in the fall and pick up in the winter and spring. Pricey? Sure, sometimes astronomically so. But not always, and if a buyer is motivated to sell, the fall is a great time to snap one up. Following is a selection of some of the most sought-after residential properties on the market.