search properties

Marcus & Millichap is pleased to present 42124218 Piedmont Avenue, a premier 10-unit mixed-use asset located in one of Oakland's most desirable and walkable neighborhoods. The property features a balanced unit mix of 6 residential apartments and 4 well-positioned ground-floor commercial suites, providing a diverse and stable income stream. Offered at an attractive 7.33% CAP rate, the asset presents investors with strong in-place cash flow and long-term upside in a high-barrier-to-entry location. Situated along the vibrant Piedmont Avenue corridor, the property benefits from exceptional foot traffic, immediate access to top-tier dining, retail, and entertainment, and proximity to major transportation corridors including Highway 24, I-580, and BART. This is a rare opportunity to acquire a high-yield, well-located asset in one of Oaklands premier submarkets.

Perched high on the hillside in Del Cerro, 6387 Dwane Avenue captures sweeping southeasterly views across rolling hills, city lights, and beyond. Spanning approximately 4,087 square feet on an expansive 0.45-acre parcel, this 5-bedroom residence, including 4 bedrooms plus an office or gym, offers impressive scale, privacy, and a lifestyle built around entertaining. The main level is anchored by connected living areas that feel open yet defined. Vaulted ceilings, exposed beams, and walls of glass frame the surrounding landscape, while the living room opens directly to an elevated view deck, allowing for a seamless indoor–outdoor flow. Off the kitchen, the family room leads to a secondary balcony, a more relaxed setting for taking in the views. The generous primary suite is also on the main level, with a walk-in closet and refined bath, creating a comfortable and private retreat. Downstairs, secondary bedrooms and a game room provide flexibility for guests, recreation, extended living, or everyday use, with views carried across both levels. Outdoor spaces stand apart, designed for hosting and daily enjoyment, with a backyard featuring a pool, spa, putting green, and built-in barbecue bar, complemented by a covered patio for lounging and gathering. Below, an extraordinary hillside sport court adds a rare recreational element. Positioned on the view side of one of Del Cerro’s most sought-after streets, this home combines scale, sweeping views, and a layout that lives as well as it entertains.

Completely Rebuilt, Expanded & Redesigned Stunning Custom Single Level Craftsman Home Situated on a Quiet Peaceful Tree Lined Street in the Highly Desirable Cambrian Park Neighborhood. Sprawling Open Flowing Floor Plan Offers (4) Bedrooms (3.5) Bathrooms w/2,517 Sq Ft in the Main House & 632 Sq Ft in the ADU Totaling 3,149 +/- Sq Ft on an Oversized 9,375 Sq Ft Lot w/Award Winning Carlton, Union & Leigh High Schools. Enjoy the Open Living Room & Separate Great Room w/Expansive Chefs Kitchen Featuring SS Appliances: Wolf Gas Cooktop, Double Oven, Dishwasher & Refrigerator, Custom Cabinetry, Granite Counters, Butlers Pantry & Large Center Island for Entertaining. Open Dining Area w/Grand Glass Slider Overlooks the Lush Backyard for Seamless Indoor/Outdoor Living. Luxurious Primary Bedroom w/En-Suite Features, Tiled Shower & Floors, Large Custom Vanity w/Ample Storage & Huge Walk-In Closet, Modern Guest Bathrooms, Indoor Laundry, European Wood Plank Flooring, Recessed Lighting, DP Windows, Modern Interior Doors, (3) Skylights, Tankless Water Heater, Central Heat & A/C. Relax & Enjoy the Inviting Landscaped Private Front & Back Yard w/Paver Stone Driveway, Walkway & Patio, Storage Sheds, Mature Landscaping, Palm & Fruit Trees, Lush Lawn & Hot Tub for Ultimate California Living.

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

Classic Palo Alto charm meets modern luxury at this reimagined California Ranch in the heart of Palo Verde. A courtyard sets a warm, welcoming tone, leading to a double-door entry that creates a true sense of arrival. Inside the formal living room features cathedral ceilings with exposed beams, a wood-burning fireplace, and a wall of windows extending to the ceiling filling the space with natural light. A formal dining room connects to the renovated kitchen with quartz countertops, beautiful cabinetry, Frigidaire appliances, and a breakfast room.The adjacent family room complete with fireplace has sliding doors opening to a spacious backyard with covered patio, sun-drenched brick terrace, and an expansive lawn framed by mature greenery creating a secret garden retreat. The private bedroom wing includes a primary suite with dual closets, backyard access, and a luxurious renovated ensuite with freestanding tub, glass shower, and marble tile. Three additional bedrooms are positioned by a renovated hall bath with dual ramp sinks and a walk-in shower. Fresh paint and new hardwood floors throughout. Ideally located near Mitchell Park, Palo Alto Baylands, and Shoreline Park, with access to acclaimed Palo Alto schools and easy connectivity to US 101 for Silicon Valley commuting.

A truly rare offering—this exceptional 38.6-acre estate showcases timeless elegance and masterful craftsmanship, set against sweeping panoramic views in one of Murrieta’s safest and most desirable areas. Blending natural beauty with refined equestrian living, the property delivers a serene and well-balanced lifestyle. Approximately 5 acres are dedicated to vineyards, while the barn features 9 horse stalls along with additional space suitable for birds or other small farm animals. A beautifully landscaped pond enhances the grand approach to the main residence. The property is further equipped with no HOA, two wells, and fully paid solar. The main home spans 4,486 square feet and offers three bedrooms, a dedicated office, an oversized laundry room, and an impressive primary suite complete with a circular spa tub, walk-in shower, and dual vanities. A separate residence, built in 2015, provides 2 bedrooms, 2 bathrooms, and an attic within its 1,064 square feet—ideal for private, independent living. Over $1.5 million has been invested into the property, including road construction, vineyard development, solar installation, irrigation systems, vehicle purchases, and additional structures. The listing includes nearly all on-site assets—what you see is what you get, with only select personal items excluded.

Perched in the coveted Kentwood Bluffs, the most sought-after nook of Westchester, this exceptional custom-built Contemporary Mediterranean residence delivers sweeping views and the effortless California lifestyle. Thoughtfully designed with impeccable attention to detail, the home is enhanced by high-end finishes and a fully integrated smart home system. Spanning five bedrooms, the residence offers an ideal layout for both refined living and everyday comfort. Rich Brazilian dark wood floors lend warmth throughout, while soaring ceilings and expansive Loewen windows flood the interiors with natural light. A gracious entry opens to an elegant, flowing floor plan with formal living and dining spaces that transition seamlessly into the heart of the home. The gourmet kitchen is both beautiful and functional, featuring Viking appliances, bespoke cabinetry, generous storage, and a breakfast bar that connects to the family room. A dramatic 10-foot bi-fold door dissolves the boundary between indoors and out, revealing a private backyard retreat. Designed for entertaining, the outdoor space features a tranquil water element, fire pit, dual built-in BBQs, and lush fruit trees, creating a serene and sophisticated setting for gatherings. Upstairs, four well-appointed bedrooms include a luxurious primary suite complete with dual walk-in closets and a spa-inspired soaking tub. A private balcony, accompanied by a wet bar, offers the perfect vantage point for sunset views. Meticulously crafted and truly turnkey, this is a rare opportunity to own a home that embodies both style and substance in one of Westchester's most desirable enclaves. Westchester was recently voted one of the friendliest neighborhoods in Los Angeles. All this, moments from Loyola Marymount, LAX, and the beach cities.

Privacy, luxury, and resort-style living in the heart of Irvine. Located on a desirable cul-de-sac corner lot, this beautifully appointed 5-bedroom, 4.5-bath luxury residence offers an exceptional blend of privacy, comfort, and elegance rarely found in such a central location. A dramatic two-story foyer crowned with a dazzling crystal chandelier welcomes you into the home, creating a grand sense of arrival and timeless sophistication. The thoughtfully designed layout features a formal living room and formal dining room, perfect for hosting gatherings, while the open-concept kitchen seamlessly connects to the spacious family room with a warm fireplace, creating an ideal setting for both everyday living and entertaining. The upgraded gourmet kitchen showcases a large center island, ample cabinetry, and generous preparation space—perfect for culinary enthusiasts. Both the family room and kitchen overlook the sparkling pool, allowing abundant natural light to fill the space while providing beautiful backyard views. A desirable first-floor bedroom suite offers flexibility and convenience for guests or multi-generational living. Upstairs, the luxurious primary suite serves as a private retreat, featuring a spa-inspired bathroom with a soaking tub, walk-in shower, dual vanities, and an oversized walk-in closet. The second level also offers three additional bedrooms, two bathrooms, and a laundry room with sink, thoughtfully designed to support comfortable everyday living. The corner lot location enhances both privacy and tranquility, creating a peaceful setting away from street noise. The backyard provides a private retreat with a pool, ideal for relaxation or entertaining. Residents enjoy access to exceptional community amenities, including resort-style pools, lagoon, sports courts, scenic trails, and beautifully maintained parks. Conveniently located near top-rated schools, premier shopping, dining, and major freeways, this home offers the perfect balance of luxury and accessibility. A rare opportunity to own a private retreat in one of Irvine’s most desirable locations.

WELCOME HOME THIS BEVERLY HILLS "GEM", 90210. IT IS TRULY A "DIAMOND IN A ROUGH" !! THIS CHARMING, 2-STORY COLONIAL MASTERPIECE, 3BR/2BA, POSSESSES THE CLASSIC BEAUTY AND ELEGANCE OF THE BY-GONE ERA OF 1930-40. ITS INTRICATE ARCHITECTURAL DETAILS: CROWN MOLDINGS, SPIRAL STAIRCASE, FIREPLACE, BEAUTIFUL HARDWOOD FLOORS, ARCH WINDOWS, TIMELESS LIGHT SCONE, VANITIESTHRU-OUT EXUDES LUXURY & SOPHISTICATION. SITUATED ON THE SIZABLE LOT AND SPACIOUS BACKYARD IDEAL FOR ENTERTAINING AND POSSIBLE ADU. TALL FRONT HEDGERS COUPLE WITH LONG DRIVEWAY & GATE, PROVIDE MORE PRIVACY & EXCLUTIVITY TO THE "90210 RESIDENCE". THE POSSIBILITY IS ENDLESS WHETHER YOU CHOOSE TO RESTORE ITS ARCHITECTURE BEAUTY OR CREATE YOUR OWN MODERN LIVINGS, EITHER WAY, YOU ARE CREATING YOUR OWN "MASTER PIECE" IN THE PRESTIGIOUS BEVERLY HILLS "FLAT", 90210. SO BRING YOUR SOPHISTICATION, YOUR IMAGINATION, YOUR BEAUTIFUL TASTES.. TO MAKE THIS HOME YOURS !! CONVENIENTLY LOCATED & WALKING DISTANCE TO BH PARKS, FAMOUS BH TRIANGLES, RENOWNED SCHOOL DISTRICT, FAME SHOPS, GORMET RESTAURANTS, HOUSES OF WORSHIP.. THIS PROPERTY HAS IT ALL!! WON'T LAST!! WELCOME HOME TO 90210!!