search properties

To schedule an Open House or to request more information about this property, call Walla Walla Sotheby's Realty at 7602374092...

Significant Price Reduction! First time on the market in 49 years, this 46-unit mixed-use flagship trophy asset offers an outstanding investment opportunity in San Francisco's core corridor. Delivering an 8.37% actual in-place cap rate, the property is offered at approximately $152,174 per unit and $270 per square foot, well below estimated replacement cost. The 100% occupied asset consists of 45 studio apartments, one ground-floor commercial space, and seven garage spaces. The high-rise fire sprinkler upgrade is approximately 90% complete, with the balance to be completed prior to close of escrow. Additional value includes approximately $190,000 in annual rental upside, $46,947 in documented banked rent increases, Fannie Mae and Freddie Mac approved, no mandatory soft-story retrofit, located within a Federal New Markets Tax Credit (NMTC) Census Tract. Ideally situated near Union Square, Powell BART/MUNI, and major hotels. Offering Memorandum available upon request.

1042 Western Avenue, a well-maintained, 17-unit multifamily community located in a highly walkable Glendale neighborhood. Built in 1963, the property contains approximately 11,058 square feet of building area and features a favorable unit mix consisting of two studio apartments, ten one-bedroom/one-bathroom units, one two-bedroom/one-bathroom unit and four two-bedroom/two-bathroom units. The unit count includes one permitted accessory dwelling unit. Ownership has recently remodeled 15 of the property's 17 units, providing an investor with the opportunity to acquire a substantially renovated apartment community with limited near-term interior capital requirements. The remodeled units feature new flooring and appliances, quartz countertops and updated HVAC systems. The units also offer large closets and generous interior storage, providing residents with comfortable and functional living spaces. On-site amenities include a swimming pool and laundry facilities. The property also contains seven large storage units, which may be rented separately to generate additional income. Subject to an investor's independent investigation and applicable governmental approvals, the storage area may also present the potential for conversion into an additional accessory dwelling unit. The property is located just a short drive from Downtown Burbank, providing residents with convenient access to its extensive collection of restaurants, shopping, entertainment venues, major employers and media-industry employment centers. The property's strategic location between Glendale and Burbank, along with its proximity to neighborhood amenities and everyday services, contributes to its continued rental appeal. 1042 Western Avenue presents investors with the opportunity to acquire a substantially renovated Glendale apartment community with approximately 15% upside in rents, that also offers a diversified unit mix, attractive resident amenities and multiple potential avenues for additional income and long-term value creation.

A remarkable fusion of classic elegance and modern luxury awaits where Mission Canyon's charm meets sophistication. This 1925 estate spans a beautifully landscaped acre, offering a harmonious balance of privacy, comfort, and architectural artistry. The expansive 3-bedroom, 3.5-bathroom main house exemplifies refined living. Step into the dramatic great room, complete with soaring vaulted ceilings and a cozy fireplace, a perfect blend of living and dining. Each bedroom is thoughtfully designed as an en-suite sanctuary, offering unparalleled comfort. The primary suite boasts a sizable walk-in closet, originally a fourth bedroom. Hardwood floors provide timeless character, while central air conditioning ensures year-round comfort.Lovingly updated, this home seamlessly integrates its historic charm with modern conveniences. Key features include a copper roof, tankless water heater, cathedral ceilings, remodeled baths, and a central heating and cooling system. The chef's kitchen is equipped with high-end appliances, including double ovens and a gas range, delivering everything needed for effortless entertaining. The property features a dreamy stone guest cottage and an inviting retreat for visitors, equipped with one bedroom, one bathroom, a kitchen, and a fireplace. The outdoor amenities complete this dream lifestyle, with a serene pool and spa, meandering stone pathways, lush oak and fruit trees, and charming fountains set amidst majestic boulders. The backyard's thoughtful landscaping blends beauty and function, while the expansive patio areas invite relaxation and alfresco entertaining. Whether you dream of a serene retreat, a place to host friends and family, or a distinguished home base in Santa Barbara, 700 Mission Canyon Road delivers on every front.

**Attention Winemaker Dreamers!** We are thrilled to present an extraordinary and rare opportunity: 11.4 acres of prime land located at the entrance of Temecula Wine Country—your first and last stop for visitors, right next to the NEW Temecula Wine Country sign and Halter Ranch Winery! This exceptional estate is zoned for a winery and features an impressive 868 sq ft tasting room with a half bath, a newly planted Sangiovese vineyard with 3,200 vines, and lush olive groves with 600 trees. Imagine living in a stunning Spanish-style home with 4 bedrooms, 3 bathrooms, a loft, and 3,532 sq. ft. of living space—perfect for you to reside in while crafting your dream winery or to serve as a potential guest cottage. Additional highlights include a retail fruit stand of 356 sq ft, an outdoor patio serving area, and a planned 2,400 sq. ft. production warehouse, with grading set to begin in early 2026. This property comes fully equipped with utilities, including Rancho Water, electric and gas service through SoCal, and a septic and propane for the residential home. With a parking lot currently accommodating approximately 30 cars, plans are in place to expand to 60, ensuring ample space for your visitors. Don’t miss this rare offering—ideal for winemakers, investors, or anyone dreaming of a premier vineyard estate. Stay tuned, as this gem will go live after the first of the year. **2026 is YOUR year to own this winery dream!** Photos of the single-family home interior and the upcoming production / storage warehouse have been virtually staged to showcase the properties' potential.

Welcome to the crown jewel of Marina Pointe Drive! An extraordinary penthouse that sets the standard for luxury living. As the most coveted residence in the full-service, Azzurra, this ultra-private corner unit spans nearly 3,600 square feet, and offers 3 bedrooms, 3.5 bathrooms, and a large den/office. Every room is framed by sweeping, unobstructed views of the marina, ocean, city and mountains; views that are unmatched anywhere in Los Angeles. The grand living and dining areas are designed for both scale and intimacy, anchored by floor-to-ceiling glass that captures dynamic vistas from sunrise to sunset. At the heart of the home, a meticulously designed open-concept kitchen features an oversized island, top-of-the-line appliances, bespoke cabinetry, and a refined breakfast bar equally suited for elevated entertaining or everyday ease. The primary suite is a true sanctuary, privately situated and generously proportioned, with direct access to its own private balcony and commanding views that create a constant sense of retreat. The spa-inspired bath is appointed with dual vanities, a deep soaking tub, a separate walk-in shower overlooking the Marina, and a huge custom-built walk-in closet designed with both beauty and function in mind. Two additional en-suite bedrooms offer exceptional scale, comfort, privacy, and views. The large den/office offers equally stunning views with the opportunity to easily convert to a 4th bedroom, if needed. Throughout the home you will find rich wood flooring, soaring ceilings, and walls of glass that create a bright, open atmosphere while maintaining a sense of warmth and refinement. Two more private balconies extend the living experience outdoors, while in-unit laundry and three parking spaces provide everyday convenience without compromise. Life at Azzurra is defined by effortless luxury and full-service living. Residents enjoy a 24 hour front desk, 24 hour security, 24 hour guest valet, concierge, as well as an unmatched suite of amenities including a rooftop sky lounge with spa, a resort-style heated pool with private cabanas, media and recreation lounges, a curated art collection throughout the common areas, and an expansive indoor-outdoor fitness center with separate yoga and Pilates studio. HOA dues also include cable, internet, water, trash, and earthquake insurance. All of this while being ideally located just moments from world-class beaches, acclaimed dining and shopping, scenic bike paths, parks, movie theaters, LAX, and so much more! Come experience this exceptional penthouse and the epitome of luxury coastal Los Angeles living.

The final 01 floor plan at The Sun Rose Residences, Residence 801 offers a coveted corner residence in the heart of West Hollywood. Designed by EYRC Architects with interiors by Martin Brudnizki, this 3BR, 3.5BA home spans 3,028 interior SF with floor-to-ceiling glass, sweeping LA views and 863 exterior SF of wraparound terraces. The expansive great room features a chef's kitchen with an oversized Calacatta Borghini marble island and Sub-Zero and Wolf appliances, opening directly to outdoor living. The primary suite features a Poliform walk-in closet, spa-inspired marble bath and private terrace. Owners enjoy personalized residential services and access to The Sun Rose Hotel's amenities, including dining, wellness offerings, and a live music venue, all set along the iconic Sunset Strip.

Just one home back from the beach, this 3-bedroom, 3-bath retreat offers nearly 1,700 square feet of living space. Harbor and ocean views stretch across the main living areas, kitchen, dining space, and primary suite. The water is never out of sight whether you're cooking dinner, hosting guests, or waking up to the coastline. The primary suite complemented by dual sinks and abundant storage also captures views of the sand and harbor. Downstairs, two secondary bedrooms share a hall bath and each opens directly to the back patio. This layout gives guests or family their own private access to the outdoors, ideal for morning coffee or an easy transition from bedroom to backyard. The main level is built for taking it all in: an open living room, kitchen, and dining space flows out to a viewing deck, made for watching the boats go by on the water. When it's time to unwind further, the back patio offers even more room to stretch out, with space to dine al fresco and enjoy the coastal air. Whether you're after a laid-back beach getaway or a full-time coastal residence, 2712 Shell delivers the perfect location, the light, and the layout. The home is also elevator-ready, offering the flexibility to add one down the line.

Half an Acre of Perfection in the San Gabriel Foothills A completely reimagined NEW CONSTRUCTION contemporary masterpiece where no expense was spared. Set on half an acre with drought-friendly landscaping, PAID-OFF solar panels (nearly NET ZERO!), a backyard oasis, and a bonus ADU/pool house — all framed by stunning views of the San Gabriel Mountains. Enter through a dramatic pivot front door to wide-plank hardwood floors, double staircases, and soaring ceilings. Every room is finished with beautiful tilework, designer fixtures, and custom millwork. The open, light-filled main level centers on a chef's kitchen with sleek European cabinetry, top-of-the-line Wolf & Sub-Zero appliances, two porcelain-topped islands, and a scullery. It flows into the living and dining rooms, where a custom-built, climate-controlled wine cellar awaits. Slide open the massive glass pocket doors to seamless indoor/outdoor living. Multiple balconies overlook the lush backyard and pool. Outside, entertain under the pergola, dine in the lanai beneath built-in infrared heaters, or gather around the poolside firepit. The infinity-edge spa & pool has to be seen to be believed. The ADU/pool house offers a full kitchen, bedroom, and bathroom finished to the same high standard as the main residence. Inside, two master suites — one up, one down — feature porcelain slab walls, his & her vanities, free-standing soaking tubs, and frameless glass showers. Every guest bedroom enjoys its own private ensuite. Still want more? The lower level delivers a spacious game/rec room, a gym/home office, a home theater, a guest room, and a bathroom — with its own private outdoor space. Add a 4-bay garage and solar on Net Meter 2.0 that nearly erases your utility bills. Minutes from hiking trails, the 210 Fwy, Pasadena, Santa Anita mall, and the Arboretum, and zoned to the award-winning Arcadia School District — with all the shopping and dining of historic Route 66 close by. This is foothill luxury at its finest.