This is a fixer-upper right near the water in Throg's Neck. No internal pics, so you know it must be a mess, but I am not sure you can get this close to the water for under $300k otherwise.
It might be worth taking a shot at this starter house and putting in some elbow grease to turn it around. The real sweet part of this listing of the day isn't even the actual house, but rather the proximity to the Sound. Click through the "map it" feature after the jump and you'll know what I mean.
You might need a car here, because there are not many subways this far east in the BoogieDown. Although, I am sure there is an express bus culture here as in most trasportationally under-served communities in the City.