---
listing_id: ML81987702
status: Closed
price: 1750000
beds: 0
baths_full: 0
baths_half: 0
sqft_living: 4101
sqft_lot: 8646
lot_acres: 
year_built: 1961
property_type: Residential Income
property_subtype: 
address: "538 Columbia Ave"
city: Sunnyvale
state: CA
zip: 94085
county: "Santa Clara County"
lat: 37.384457
lng: -122.01946
days_on_market: 507
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Joel Stieber"
list_office: "KW Bay Area Estates"
list_agent_phone: "(408) 799-7029"
list_agent_license: 02002877
mls_source: MLSL
modified: 2026-01-30
transaction_type: recentlySold
---

Home | Santa Clara County | Sunnyvale | 94085 | 538 Columbia Ave

538 Columbia Ave, Sunnyvale, CA 94085

MLS: ML81987702 | Status: | Price: $1,750,000
Beds/Baths: – / –
Property Type: Residential Income

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4,101 8,646 1961

Remarks

Discover a lucrative investment opportunity in the heart of Sunnyvale. This 6-unit multi-family property, built in 1961, offers a versatile mix of unit sizes and exceptional potential for owner-occupancy. The property features a mix of unit sizes: Unit #1 - 3bed/ 2bath, Unit# 2 - 2bed/ 1bath, Units #3 through #6 - 1bed 1 bath each. On-site coin laundry service adds convenience for tenants. Its prime location near Downtown Sunnyvale, Levi's Stadium, and major tech employers ensures strong rental demand and long-term appreciation. Don't miss this rare chance to own a multi-family property with immediate income and significant upside potential.

MLS Listing Information

Field Value
MLS # ML81987702
MLS Source MLSListings, Inc.

Features

Interior Features

Feature Details
Cooling None
Heating Central Forced Air - Gas

Exterior Features

Feature Details
Roof Composition
Foundation Crawl Space

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Carport, Covered Parking, Off-Site Parking, Garage: 2 Car(s)
Elementary District Sunnyvale
High School District Fremont Union High
Sewer Public Sewer
Water Public
Complex Amenities Car Wash Area, Other
Zoning R3

Contact Information

Joel Stieber
KW Bay Area Estates
License #: 02002877
Phone: (408) 799-7029

Property Units

# Buildings # Leased Units # Total Units
1 6 6

Unit Details

Type Sq Ft Beds Baths Min Rent Max Rent Units Like This
1 1,100 3 2/0 $2,000 1
2 701 2 1/0 $1,550 1
3 575 1 1/0 $1,500 1
4 1 1/0 $1,750 1
5 1 1/0 $1,750 1
6 1 1/0 $1,500 1

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Bishop Elementary School public K-5 0.33 mi 7
Columbia Middle School public 6-8 0.61 mi 6
San Miguel Elementary School public K-5 0.74 mi 5
Ellis Elementary School public K-5 1.09 mi 7
Lakewood Elementary School public K-5 1.24 mi 6
Braly Elementary School public K-5 1.37 mi 9
Vargas Elementary School public K-5 1.58 mi 3
Ponderosa Elementary School public K-5 1.63 mi 9
Fairwood Elementary School public K-5 1.77 mi 9
Cumberland Elementary School public K-5 1.82 mi 10
Mission Early College High public 9-12 2.13 mi 10
Adrian Wilcox High School public 9-12 2.25 mi 8
Adult And Community Education public UG 2.34 mi N/A
Fremont High School public 9-12 2.34 mi 9
New Valley Continuation High School public 9-12 2.34 mi 1
Sunnyvale Middle School public 6-8 2.36 mi 9
Cherry Chase Elementary School public K-5 2.39 mi 10
Jose Antonio Vargas Elementary public K-5 2.39 mi 8
Community Day School public 9-12 2.40 mi N/A
North County Regional Occupational Program School public 9-12 2.40 mi N/A

Disclosures

©2026 MLSListings Inc. All rights reserved. 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. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of January 30, 2026. For the most current information, please contact Joel Stieber, (408) 799-7029.