Celebrating 10 years: fixed fees, full service, fast responses

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.

Save
Ask
Tour
Hide
Share
$1,250,000
13 Days On Site

480 Mission Bay Boulevard 917
San Francisco, CA 94158

For Sale|Condominium|Active
1
Bed
2
Total Baths
1
Full Bath
1
Partial Bath
1,195
SqFt
$1,046
/SqFt
2012
Built
County:
San Francisco
Listing courtesy of Jing Fang of Real Brokerage Technologies | Agent Phone: (415) 583-3848
Call Now: (408) 868-2620
Is this the listing for you? We can help make it yours.
(408) 868-2620
480 Mission Bay Boulevard 917480 Mission Bay Boulevard 917480 Mission Bay Boulevard 917480 Mission Bay Boulevard 917
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,250,000
Days On Site 
13 Days
Bedrooms 
1
Inside Area (SqFt) 
1,195 sqft
Total Baths 
2
Full Baths 
1
Partial Baths 
1
Lot Size 
2.8212 Acres
Year Built 
2012
MLS® Number 
426144300
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
$1,335 monthly
Sq Ft Source 
N/A
Friends & Family
Recent Activity
6 days agoListing updated with changes from the MLS®
2 weeks agoListing first seen on site
General Features
Acres 
2.8212
Cross Street 
3rd Street
Garage 
Yes
Parking 
EnclosedGarage Door OpenerSide By SideOn Site
Parking Spaces 
1
Property Sub Type 
Condominium
Special Circumstances 
Standard
SqFt Total 
1195
Interior Features
Appliances 
DishwasherGas Cooktop
Cooling 
Central Air
Heating 
Central
Living Room 
Description - View
Save
Ask
Tour
Hide
Share
Community Features
Association Amenities 
Pool
Association Dues 
1335
HOA Fee Frequency 
Monthly
MLS Area 
SF District 9
Listing courtesy of Jing Fang of Real Brokerage Technologies | Agent Phone: (415) 583-3848



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

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

*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.