This one-of-a-kind urban oasis was completely rebuilt from the studs in 2012 and blends luxury living with versatile zoning for endless possibilities. Spanning three parcels, including two residential lots and one commercially zoned corner lot, this prime property offers the rare chance to seamlessly integrate home and business in the heart of the city.Step inside to discover a striking ultra-modern interior with high-end finishes throughout. The open-concept first floor is ideal for entertaining, featuring a custom fireplace, spa-inspired bathrooms, ductless AC, and a dream kitchen with top-of-the-line appliances. Upstairs, the lavish primary suite boasts a custom walk-in closet fit for Ken and Barbie, while the fully finished third floor adds a private guest suite, office, or creative space with its own full bath.Outdoors, serenity meets sophistication with professional landscaping, a custom-built gazebo and arbor draped in curated grapevines, and a new storage building on foundation--perfect for tools, toys, or business equipment. Enjoy peace of mind with a gated 8-car private parking lot accessed via a fob-controlled electric gate and a 12-camera security and alarm system.Additional features include a full 1,000 sq ft clean walk-out basement, dedicated laundry room, and a whole-home water filtration system.Whether you're an urban gardener, entrepreneur, entertainer, or all of the above--this property is built to impress, protect, and perform.