DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 129' at line 10
Avon, United States Two bedroom, two bath and three bedroom, two bath condominiums overlooking Nottingham Lake in Avon with spectacular views of the Beaver Creek Ski Mountain. Conveniently located 1/2 mile from the Beaver Creek entrance, the skier shuttle stops right in front of the complex every 12 minutes. Beautifully decorated, each condo features a fully equipped kitchen, wood burning fireplace, washer/dryer, patio/deck, Jacuzzi tub, stereo, TV and VCR.