This house is in the neighborhood, just north of Castle Village. I've seen it several times from the river; it is distinctive.
Pumpkin House, a cantilever house overlooking the Hudson River at 186th street.
http://www.nytimes.com/2008/08/14/garden/14pumpkin.html