Haider, good evening. I found your question very interesting and did a bit of research. I took you literally when you asked for homes "on the water" and did not include those listed as being within walking distance or those that might have views of the ocean.
Here goes...I found 13 homes in the 02066 zip code which included one in the Humarock section of Scituate. The prices ranged from $399,900 - $2,449.00 with a median price of $699,900. Additionally, I found 4 condominiums that qualify , priced from $429,900 - $734,900. The median price condo price is $574,450. I hope the information proves helpful!