As with many answers, it depends. Do you live out in the boonies where the roads aren't plowed? If so, AWD is the way to go. If your roads are plowed during and after snow storms, not necessary. Unless, for example, you have a long uphill/downhill driveway when AWD is very useful.
I still live in Michigan, where this winter has been comparatively mild. Wife's car is front wheel drive with a set of new and quite good all season Conti ExtremeContact DWS tires on it. When the snow is measured in inches, she takes the AWD Pilot, and I get my old CRV (driven by daughter when she's home) back. Our drive isn't that steep, but its a long uphill drive to get to the garage. AWD gets up that hill without any drama. All of the front wheel drive cars spin tires -- dating back to a '93 Plymouth minivan, a '94 Accord, a 98 Olds minivan, a 94 Buick (family pass around car), and an '06 Volvo wagon. Traction control operates via the brakes, so it doesn't really help that much. There seem to be many off lease CRV's of the current body style on the market here now. Haven't checked pricing, but you might want to do so.
Extra maintenance cost is minimal on CRV -- rear diff fluid replacement at approx 30 K intervals at about $30 per service. Fuel economy not much different, either. Resale usually higher with AWD. But so is initial cost.