UNIQUELY Jacobsen. This is a stunning modern residence with spectacular city and mountain views. THINK overheight ceilings, skylights, walls of glass, and an open floor plan with award winning design by Christopher Bozyk Architects. A corne r end unit boasting qlty throughout: Engineered teak H/W flrs, upgraded wood cabs, wool blend carpet in bdrms, a gas F/P w/ composite stone surround, sliding Raumplus frosted glass closet-doors, quartzite countertops and stainless European appls by Sub Zero, Bosch, Bloomberg, and Broan. All this and a HUGE 800 SQ FT ROOF TERRACE w/ O/D F/P overlooking mtns, Downtown and nearby Athlete's Village. 2 bedrooms and 1 den, 2 full baths, and 2 parking spaces complete this home.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and agents.active = 'y'' at line 4select * from agents join agent_sites on (agents.id = agent_sites.agent_id) where agent_sites.site_id = 2 and agents.id = and agents.active = 'y'