Refine Search
Sort by
$3,800,000
6 Beds ML82055910 MLS
Property is currently under construction on this one-of-a-kind opportunity to live, work or rent out the entire building!! Mixed use zoning for residential and commercial!! 1 retail storefront office downstairs which is approx. 400 sq ft and 2 large 2 bedroom optional 1 bedroom 2 bath condos which are approx. 1900 sq ft.each and a large community rooftop deck which is approx. 600 sq ft. and has mountain views. 9-foot ceilings aside from the bathroom in the condos. Retail office has 12-foot ceilings. 4 parking spaces in the garage and garage has a brand new car lift and turn table. No hoa incorporated and no hoa as of now, but future buyers could create hoa, ccr's, and potentially subdivide into 3 apn's and sell separately. Final permits will be provided at time of completion. Architectural plans provided upon request. Sump pump for water. Fire sprinkler in the whole building and sewer is connected. There are 2 furnaces for 2 condos and 1 furnace for retail store - all have AC. 3 water heaters at 65 gallons each - pump heater. 1 house meter and individual meters for 1 office and 2 condos. 400-amp panel for the whole building. Entire building is electrical / no gas.

18 Visitacion AVE, Brisbane

Listed by John Pang, 650-699-2838 from Realty One Group Extreme
(If provided) CoList: from

$2,145,000
5 Beds 4 Baths CRPA26010885 MLS
Discover the pinnacle of modern luxury at 526 Klamath Street in Brisbane, a newly constructed masterpiece featuring an attached ADU with its own separate address. Designed with an emphasis on natural light and seamless indoor-outdoor living, the main residence showcases expansive panoramic sliding doors, skylights, and two generous decks on the main level that frame breathtaking views of the Bay and glittering city lights. The master bedroom and a downstairs bedroom each offer private access to an outdoor patio, creating tranquil retreats with a direct connection to nature. High-end Hansgrohe plumbing fixtures elevate every bathroom, complete with multiple shower heads for a spa-like experience. Comfort is ensured year-round with a mini-split HVAC system, while the gourmet kitchen is a chef's dream, outfitted with Thermador appliances, including a panel-ready refrigerator and dishwasher that blend seamlessly with custom cabinetry. The attached ADU adds remarkable versatility, perfect for multigenerational living, rental income, or guest accommodations, all while maintaining privacy with its own separate address. Located just minutes from San Francisco, this home offers an unmatched blend of elegance, functionality, and stunning vistas. Whether entertaining on the decks, relaxing

526 Klamath ST, Brisbane

Listed by Vladislav Okel, 916-715-2089 from CAPITAL GROUP REALTY, INC.
(If provided) CoList: from

Sold listing courtesy of Jennie Lok from

board logoThe data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than Real Estate Company are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents.
Based on information from MLSListings MLS as of . All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.


Copyright 2026 MLSListings Inc. All rights reserved