Ask Us About Our Office Listings

Listed below you will see our featured properties, [area] homes that we represent. If you are curious about any of the properties below or would like a personal tour, please contact us today. We’d love to share the features that make these homes noteworthy. If you would like to see YOUR home listed below, please give us a call at [phone] to receive a personal in-home consultation or click here to get your FREE home analysis.

Featured Properties

3249 Greenwood Dr, Fremont
$2,599,000
4 Beds ⋅ 3 Baths ⋅ 41135958 MLS
A rare Multi-Generational opportunity in Parkmont awaits! A Mediterranean Oasis estate on a generously deep lot -completely rebuilt- from the slab up in 1999. This 2.900 SF appx estate maximized for multi-generational living, situated on a deep 10,000 SF lot features wonderful ground-level comforts. A turn-key Mediterranean main home with 1st floor guest bedroom, bathroom with walk-in shower, 1st floor versatile office with closet with oversized primary suite and additional 2 bedroom upstairs. Step across the flowering backyard patio to a detached studio ADU with bathroom, kitchen & laundry amenities. Rebuilt from the ground up in 1998-2000, this turn-key contractor's property was crafted with pride of ownership, customized for multi-generational comforts, holiday gatherings, backyard entertaining, guest cottage and potential additional ADU capabilities with additional rear storage buildings and level yard. Appreciate the attention to detail in every corner with custom finishing touches throughout. Vaulted ceilings flooded with light, elegant spiral staircase foyer, chef's kitchen with pull up seating, gas range & powerful ventilation hood and warming drawer & more! Thoughtful storage spaces, oversized bedrooms, polished marble flooring and elegant marble surrounds throughout the first floor and bathrooms and quality berber carpet at bedrooms. A Primary Suite to escape to features a spacious retreat with Hollywood closet, luxurious marble bathroom, walk-in shower & soaking tub. Recent added value include a brand new west fence 6/26, new furnace & AC 2025, EV Charger, Sunrun Solar system, fresh interior paint 5/26, finished main garage with laundry area. An entertainer's backyard with slate tile hardscape, cozy cabana with matching roof & outdoor kitchen with gas grill, sink &side power burner. A few steps to the studio casita ADU provides independence for loved ones or for tenants, finished with granite counters, full kitchen, washer & dryer, wood laminate flooring & bathroom with shower and new glass door. Conveniently located near Hwy 84, markets & shopping, a short drive to Parkmont Elementary or a short walk to Centerville MS & Washington HS. Completely rebuilt from 1998-2000 with permit totaling 2,919 living SF on approved plans. ADU not included in SF but included in approved plans. "As-Is" Sale with reports & disclosures for review. Buyer to verify SF & Permit. Built for love & gratitude, this welcoming home will continue to be a blessing to many!

3249 Greenwood Dr, Fremont

712 Blair Ave., Piedmont
$2,595,000
4 Beds ⋅ 3 Baths ⋅ 41152694 MLS
Thoughtfully remodeled with an emphasis on timeless design and modern comfort, 712 Blair Avenue offers beautifully appointed interiors, an exceptionally versatile floor plan, and inviting spaces for both everyday living and entertaining. The spacious living room is rich in architectural detail, with hardwood floors, an elegant, recessed ceiling, built-in bookshelves, and a classic brick fireplace. Expansive picture windows fill the room with natural light and create a warm, welcoming atmosphere. The main level encompasses all of the home's principal living spaces, including three light-filled bedrooms and a beautifully updated primary suite. The generous primary bath features marble floors, a spacious tiled shower, double vanity, and walk-in closet. A gracious dining room, complete with a built-in cabinet, picture window, and French doors opening to the sunny backyard, provides an elegant setting for gatherings. Adjacent, the newly remodeled eat-in kitchen combines sophisticated finishes with everyday functionality, featuring marble countertops, stainless steel appliances, abundant cabinetry, and generous pantry storage. A conveniently located laundry room and additional storage complete the main level. Just a short flight of stairs away, a versatile family room with a full bath offers exceptional flexibility as a guest retreat, fourth bedroom, home office, or fitness space. Additional stairs from the kitchen provide access to the garage and workshop area. The backyard is a natural extension of the home, anchored by a magnificent mature magnolia tree and featuring a generous lawn, outdoor seating area, and garden beds. Set on a peaceful street in upper Piedmont, 712 Blair Avenue combines the character and gracious proportions of a classic Piedmont home with the thoughtful updates, flexibility, and ease of living that make it particularly appealing today.

712 Blair Ave., Piedmont

5 Dunfirth Dr, Hayward
$2,550,000
4 Beds ⋅ 4.5 Baths ⋅ 41149998 MLS
Welcome to luxury living in the prestigious, gated Stonebrae Country Club! Built by Brookfield Homes in 2017, this exceptional 4-bedroom, 4.5-bath residence offers approximately 4,379 sq. ft. of beautifully designed living space and a rare, highly desirable floor plan. The main level features a private IN-LAW SUITE with its own entrance and kitchenette, plus a separate office that can easily serve as a 5th bedroom with access to a full bath. A dramatic high-ceiling foyer welcomes you into an elegant great room with a gas fireplace and a spacious formal dining room that opens to the California Room, perfect for effortless indoor-outdoor entertaining. The gourmet kitchen showcases an oversized center island, upgraded cabinetry, granite countertops, built-in stainless steel appliances, and a generous walk-in pantry. Hardwood flooring flows throughout the first level. Upstairs, retreat to the luxurious primary suite featuring an expansive walk-in closet and spa-inspired bath with a sunken tub and oversized stall shower. Two additional bedrooms share a Jack-and-Jill bath and include walk-in closets. A versatile loft with French doors opens to a private balcony, creating the perfect space to relax, work, or entertain. The professionally landscaped backyard is designed for year-round enjoyment, featuring a built-in fireplace in the California Room, a fire pit, BBQ area, and hot tub. Unwind while taking in serene surroundings and beautiful city views- a truly special setting within one of the Bay Area’s most sought-after gated communities.

5 Dunfirth Dr, Hayward

3023 Hastings Way, San Ramon
$2,499,888
5 Beds ⋅ 4 Baths ⋅ 41152421 MLS
Welcome to 3023 Hastings Way, where timeless elegance meets modern luxury and everyday comfort! Nestled in a desirable San Ramon neighborhood, this stunning northeast-facing residence offers beautiful views, an exceptional floor plan, and an impressive collection of thoughtful upgrades throughout.\ Step inside and fall in love with the beautifully updated kitchen featuring premium Thermador appliances, double ovens, an oversized island, quartz countertops, and stylish finishes—perfect for entertaining and everyday living. Additional enhancements include updated bathrooms, new carpeting, updated flooring, recessed lighting, elegant light fixtures, fresh interior paint, decorative iron stair railings, custom built-ins, California Closets, Hunter Douglas window coverings, and abundant storage. Designed for comfort and versatility, this exceptional home features a spacious downstairs guest bedroom with a full bathroom, ideal for multigenerational living, along with an upstairs bonus room offering endless possibilities. Additional highlights include solar panels, a new tankless water heater, a hot-water filtration system, and an impressive four-car tandem garage with built-in cabinetry and a dedicated workspace. Ideally situated near highly regarded schools, shopping, dining, parks, and convenient freeway access, this remarkable home offers the perfect combination of luxury, functionality, and location. BEAUTIFULLY UPDATED. EXCEPTIONALLY APPOINTED. PERFECTLY LOCATED. WELCOME HOME! Offers, if any, due Thursday, 11/12 @ 12 PM. Please refer to Offer Instructions in Disclosures.

3023 Hastings Way, San Ramon

5685 Carberry Ave., Oakland
$2,499,000
5 Beds ⋅ 3.5 Baths ⋅ 41152923 MLS
Discover an exceptional opportunity in the heart of historic Idora Park! This beautifully renovated Spanish-style property offers incredible versatility, functioning as a spacious 5-bedroom, 3.5-bath residence, a multigenerational retreat, or a duplex with income-producing potential. The larger main residence, approximately 1,971 sqft., features 3 bedrooms and 2 full baths, blending timeless architectural charm with modern upgrades. A stunning, fully remodeled kitchen showcases new cabinetry, countertops, recessed lighting, updated fixtures, and state-of-the-art appliances. Beautiful hardwood floors flow throughout much of the home, while gorgeous vaulted wood-planked ceilings create warmth and character in the family room. A formal dining room and charming breakfast nook provide inviting spaces for entertaining and everyday living. Additional highlights include remodeled bathrooms, convenient laundry facilities, and attached garage parking. The adjoining secondary residence at offers approximately 1,541 sqft. with 2 bedrooms and 1.5 baths. Equally impressive, this residence features a beautifully updated kitchen with new cabinetry, countertops, and modern finishes, hardwood flooring, recessed lighting, and a welcoming living room anchored by a gorgeous wood-burning fireplace. The main level includes a half bath and dedicated laundry room, while upstairs offers two spacious bedrooms and a stunning remodeled bathroom featuring a walk-in shower, dual vanity, and new flooring. Situated on an expansive, flat 0.24-acre lot, the outdoor possibilities are extraordinary! The generous backyard offers abundant space for entertaining, gardening, recreation, or exploring the potential for up to two additional dwelling units, subject to applicable approvals. Whether you're seeking rental income, multigenerational flexibility, or a sprawling private retreat, this property delivers endless possibilities. Ideally located in Oakland's beloved historic Idora Park neighborhood, with convenient access to North Oakland and Berkeley, the property is just moments from the vibrant shops, restaurants, and neighborhood amenities along Telegraph Avenue and Shattuck Avenue. Easy access to public transportation and major freeways adds to the appeal. Rich in history, architectural character, and modern amenities, this is a rare opportunity to enjoy flexible living and investment potential in one of North Oakland's most distinctive neighborhoods!

5685 Carberry Ave., Oakland

104 Macedon Ct, San Ramon
$2,499,000
4 Beds ⋅ 3.5 Baths ⋅ 41148256 MLS
Spectacular East facing Windemere residence ideally situated on a premium corner lot, just moments from award-winning schools, parks, and scenic hiking trails. This beautifully appointed home features 4 spacious bedrooms and 3.5 baths, including a highly desirable main-level bedroom with full bath, HUGE Master Bedroom suite plus a private downstairs office and an expansive bonus room ideal for a media room, game room, or additional living space. A grand marble entry, soaring ceilings, abundant natural light, and elegant formal living and dining spaces create an impressive first impression. The bright morning room opens effortlessly to a charming side yard, while the inviting family room with fireplace offers the perfect setting for everyday living and entertaining. At the heart of the home is a beautifully designed chef’s kitchen featuring granite countertops, designer backsplash, generous center island with breakfast bar, large pantry, stainless steel appliances, and ample cabinetry. The luxurious primary suite offers a spacious private retreat complemented by a spa-inspired marble bath with dual vanities, jetted soaking tub, separate shower, and an exceptionally large walk-in closet. An open, light-filled floor plan, warm designer-inspired interiors, recently refreshed internal paint, picturesque nearby hill views, and numerous thoughtful upgrades complete this exceptional Windemere home. A rare opportunity offering an outstanding combination of elegance, space, functionality, and an exceptional location.

104 Macedon Ct, San Ramon

Start Your Search

© 2026 BEAR, CCAR, bridgeMLS. This information is deemed reliable but not verified or guaranteed. This information is being provided by the Bay East MLS or Contra Costa MLS or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. Date and time last updated: Website provided by: Real Geeks LLC

How much is your home worth?

Get instant property value now!