you don't need a new gear set or new tranny. its just the synchro that went out, have that replaced, and it will be just fine. its expensive because they have to take the tranny out. but its still cheaper than new gears or new tranny.
Nissan Forums is the go to place to talk about your favorite Nissan model, including the Rogue, Maxima, Altima and even sports cars like the 370Z and 200SX.