Property search · The Consumer Protection Brokerage
Every listing shows your estimated rebate.
The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.
480 Mission Bay Boulevard 917San Francisco, CA 94158




The building does not allow open house. Please contact listing agent Jing Fang 4155833848 jing@Jingfang.co for private showings. Private showings available July 18th and July 19th between2-4pm. Madrone trophy residence with panoramic city, water, and southwest views. This custom interior-designed 1BD/1.5BA showpiece offers sophisticated open-concept living with floor-to-ceiling windows, Hunter Douglas motorized shades, and premium smart-home features throughout. The spacious living and dining areas flow seamlessly to a private glass balcony, creating the perfect space for entertaining or relaxing while enjoying breathtaking views. The chef's kitchen features an oversized peninsula ideal for dining, meal prep, or working from home, complemented by Thermador and Bosch appliances, a marble mosaic tile backsplash, and an elegant adjacent bar area. Hardwood flooring extends throughout the living spaces. The spacious primary suite offers a custom California Closets walk-in closet and a spa-inspired ensuite bath with dual vanities, an oversized walk-in shower with Hansgrohe fixtures, built-in bench seating, and designer finishes. A stylish powder room and in-unit washer/dryer complete this exceptional home. Residents of Madrone enjoy resort-style amenities including a 24-hour attended lobby, state-of-the-art fitness center with steam room and sauna, heated outdoor pool and sun deck, spa, theater, resident lounge, BBQ area, and business center. Ideally located in the heart of Mission Bay, just steps from Chase Center, Thrive City, Oracle Park, Mission Creek, and San Francisco's waterfront. Enjoy acclaimed restaurants including Miller & Lux, Gott's Roadside, Dumpling Time, Harmonic Brewing, Mission Rock Resort, and SPARK Social SF, along with waterfront parks, dog parks, playgrounds, Stagecoach Greens, scenic walking and biking trails, pickleball and basketball courts, Safeway, Gus's Community Market, and the popular Mission Bay Farmers Market. Surrounded by world-class employers including UCSF Mission Bay, OpenAI, Uber, Visa, and Gap Inc., with easy access to Caltrain, MUNI, Highways 280/101/80, downtown San Francisco, Silicon Valley, and SFO.
| 6 days ago | Listing updated with changes from the MLS® | |
| 2 weeks ago | Listing first seen on site |
Listing information is provided by Participants of the San Francisco Association of Realtors MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, San Francisco Association of Realtors MLS.
Last checked: 2026-07-27 04:25 AM UTC
*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.
Found a home you love?
Schedule a free consultation to lock in your rebate before you offer.
Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.