I believe the fruit is in mid to late summer, it's quite common here but I can't remember when I start seeing all the fruit. I have several but haven't gotten any fruit from them yet. My understanding is that they don't fruit until they start to fall back down, after they've gotten as high as they can. I'm not sure though. My friend has tons of fruit and blooms every year, mine have grown a lot but never bloomed.
It is said here that you plant pitahaya (that's its name here) for your neighbors because the vines always go to the top of the wall and then bloom and fruit hanging over the other side.
If so, my neighbors should be happy pretty soon as all of mine have reached the top of the 15' wall and are hanging over the other side. Maybe I should go over there and ask if I can plant some on their side
The kind grown here is red to an almost day glow burgandy on the outside, with white flesh. Farther south in Honduras and Guatemala I've had the ones with the red flesh, I don't recall much of a taste difference. The blooms are white, at night and have a good fragrance. I think they are pollinated by the large, black night moths here in the tropics, there are a lot of superstitions about those too.