I don't have kids, but am a dog owner. Before jumping in and getting a dog, I think it's important to check your building's rules regarding pet ownership (unless you live in a private home). There have been occasions at my co-op when residents have wanted to adopt large dogs when our rules clearly limit the breed, and weight size to 30 lbs. Of course, this can put a damper on things if you prefer a larger dog.
The puppy thing -- Can get complicated if you're working outside the home. Fortunately, I was at home during my dog's puppy years, so housebreaking was somewhat simpler. As you may know, housebreaking requires scheduled walks centered around feeding times. Also pups require lots of attention. I remember mine wanted to play all the time and then take long naps. Also, being at home helped me to train her in avoiding negative behaviors like excessive barking, or chewing on things not meant for dogs.
I know people who have adopted housebroken dogs at 1 year+ who are currently successful and happy dog owners. Perhaps that's a good solution, whereby you still get a young dog, but the work involved in housebreaking is taken care of. That said, keep in mind that dogs require an adjustment period for them to feel fully comfortable and adhere to their walking schedules. It's all about consistency.
Is it a good idea to have a dog in Jackson Heights? For me it was the right decision, as well as for many others in the neighborhood . Yes, we lack in green space, but long walks are still doable. It would be good to know the status of the
Proposed Dog Park at Landing Lights. Here's a link from the folks behind the proposal:
Landing Lights Dog Run