---
listing_id: ML82054234
status: Active
price: 1500000
beds: 0
baths_full: 0
baths_half: 0
sqft_living: 3300
sqft_lot: 5000
lot_acres: 
year_built: 1962
property_type: Residential Income
property_subtype: 
address: "557 Hampshire Ave"
city: Redwood City
state: CA
zip: 94063
county: "San Mateo County"
lat: 37.477972
lng: -122.207987
days_on_market: 1
hoa_fee: 
hoa_frequency: 
garage_spaces: 0
list_agent: "David Katz"
list_office: "Magnify Real Estate"
list_agent_phone: "(408) 438-0585"
list_agent_license: 01971921
mls_source: MLSL
modified: 2026-07-15
transaction_type: buy
---

Home | San Mateo County | Redwood City | 94063 | 557 Hampshire Ave

557 Hampshire Ave, Redwood City, CA 94063

MLS: ML82054234 | Status: Active | Price: $1,500,000
Beds/Baths: – / –
Property Type: Residential Income

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3,300 5,000 1962

Upcoming Open Houses

Date Time Hosted By
Wednesday, July 22 12:00 pm - 1:00 pm David Katz
Sunday, July 26 2:00 pm - 4:00 pm David Katz

Remarks

Magnify is pleased to present 557 Hampshire Avenue, an excellent opportunity to acquire one of the lowest-priced fourplexes on the Peninsula, offering exceptional value for investors seeking strong in-place cash flow with upside potential. Built in 1962, the building consists of approximately 3,300 square feet on a 5,000 square foot lot and features a desirable unit mix of (1) 2BD/1BA and (3) 1BD/1BA residences, offering an attractive investment in one of the Peninsula's strongest rental markets. The property generates nearly $10,000 per month in rental income with the opportunity to further increase cash flow through strategic interior improvements as units turn over. The spacious downstairs 2BD/1BA residence enjoys a large private backyard that enhances tenant appeal, and the building has completed its SB-721 inspection. Located just minutes from vibrant downtown Redwood City, the property is centrally positioned on the Peninsula with convenient access to Highway 101, El Camino Real, Caltrain, and major employment centers. Atherton, Menlo Park, Palo Alto, and Stanford University are all within approximately 15 minutes, positioning 557 Hampshire Avenue to benefit from robust rental demand, long-term income growth potential, and outstanding connectivity throughout Silicon Valley.

MLS Listing Information

Field Value
MLS # ML82054234
MLS Source MLSListings, Inc.
Days on Site 1

Features

Interior Features

Feature Details
Laundry Coin Operated
Cooling None
Heating Gas, Wall Furnace

Exterior Features

Feature Details
Roof Composition, Shingle
Foundation Pillar/Post/Pier, Wood Frame

Parking, School, and Other Information

Feature Details
Garage/Parking Covered Parking, Garage: 0 Car(s)
Elementary District Redwood City Elementary
High School District Sequoia Union High
Sewer Public Sewer
Water Public
Zoning R300S3

Contact Information

Listing Agent Co-Listing Agent
David Katz Will Tharp
Magnify Real Estate Magnify Real Estate
License #: 01971921 License #: 01984173
Phone: (408) 438-0585 Phone: (650) 918-0742

Property Units

# Buildings # Leased Units # Total Units
1 4 4

Unit Details

Unit # Sq Ft Beds Baths Rent
1 2 1/0 $2,650
2 1 1/0 $2,392
3 1 1/0 $2,175
4 1 1/0 $2,600

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Hoover Elementary School public K-8 0.46 mi 5
Sequoia District Adult Education public UG 0.52 mi N/A
Garfield Elementary School public K-5 0.65 mi 6
Taft Elementary School public K-5 0.75 mi 4
Encinal Elementary School public K-5 1.52 mi 9
Adelante Selby Spanish Immersion School public K-5 1.53 mi 6
McKinley Institute Of Technology public 6-8 1.55 mi 6
North Star Academy public 3-8 1.55 mi 10
Sequoia High School public 9-12 1.72 mi 7
Orion Alternative School public K-5 1.86 mi 9
Tide Academy public 9-12 1.89 mi 9
Henry Ford Elementary School public K-5 2.05 mi 4
John F. Kennedy Middle School public 6-8 2.08 mi 7
Roosevelt Elementary School public K-5 2.12 mi 4
Laurel Elementary School public K-5 2.14 mi 10
Menlo-Atherton High School public 9-12 2.15 mi 8
Redwood High School public 9-12 2.32 mi 2
Belle Haven Elementary School public K-5 2.56 mi 1
Woodside High School public 9-12 2.61 mi 8
White Oaks Elementary School public K-3 2.66 mi 10

Nearby Homes

Address Price Beds Baths Sq Ft Status
3085 William Ave $1,200,000 1,020 Active
114 Bonita Ave $1,295,000 2,025 PendingDoNotShow
901 Fifteenth Ave $1,599,000 2,090 Active
57 Dumbarton Ave $1,650,000 3,478 Active

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 July 15, 2026. For the most current information, please contact David Katz, (408) 438-0585.