Skip main navigation
Under contract
  • $1,500,000

    557 Hampshire Ave, Redwood City, CA 94063

    5beds
    4baths
    3,300sqft
    : 
    $9,591/mo
    Get pre-qualified
    Quadruplex, Residential Income
    Built in 1962
    -- sqft lot
    $-- Zestimate®
    $455/sqft
    $-- HOA

    What's special

    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.
    36 days
    |
    805
    |
    42
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    David Katz 01971921 408-438-0585,

    Magnify Real Estate 877-776-7718,

    Will Tharp 01984173 650-918-0742,

    Magnify Real Estate

    Source: MLSListings Inc,MLS#: ML82054234MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      Heating
      • Gas, Wall Furnace
      Cooling
      • None
      Appliances
      • Laundry: Coin Operated
      Features
      • Doors: None
      Interior area
      • Total structure area: 3,300
      • Total interior livable area: 3,300 sqft

      Property

      Parking
      • Total spaces: 4
      • Parking features: Covered
      • Carport spaces: 4
      Accessibility
      • Accessibility features: None
      Features
      • Stories: 2
      Lot
      • Size: 5,000 Square Feet
      Details
      • Parcel number: 054246330
      • Zoning: R300S3
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: MultiFamily
      • Property subtype: Quadruplex, Residential Income
      Materials
      • Foundation: Pillar/Post/Pier, Wood Frame
      • Roof: Composition, Shingle
      Condition
      • Year built: 1962

      Utilities & green energy

      • Gas: PublicUtilities
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Public Utilities, Water Public

      Community & HOA

      Location
      • Region: Redwood City

      Financial & listing details

      • Price per square foot: $455/sqft
      • Tax assessed value: $1,127,412
      • Annual tax amount: $23,307
      • Date on market: 7/14/2026
      • Listing agreement: ExclusiveRightToSell
      • Inclusions: Building, Land
      • Lease term: Month To Month

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        8/12/2026Contingent$1,500,000$455/sqft
        Source: MLSListings Inc #ML82054234 Report a problem
        7/15/2026Listed for sale$1,500,000+81.8%$455/sqft
        Source: MLSListings Inc #ML82054234 Report a problem
        10/21/2005Sold$825,000+22.2%$250/sqft
        Source: Public Record Report a problem
        4/4/2002Sold$675,000+689.5%$205/sqft
        Source: Public Record Report a problem
        4/2/1999Sold$85,500-70.4%$26/sqft
        Source: Public Record Report a problem
        12/3/1997Sold$289,000$88/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$19,230 +2.8%$1,127,412 +2%
        2024$18,713 +3.1%$1,105,306 +2%
        2023$18,143 +4.4%$1,083,634 +2%
        2022$17,379 +1.4%$1,062,388 +2%
        2021$17,147 +1.6%$1,041,558 +1%
        2020$16,874 +1.7%$1,030,880 +2%
        2019$16,584 +4.6%$1,010,668 +2%
        2018$15,853 +5.8%$990,852 +2%
        2017$14,984 +3.3%$971,424 +2%
        2016$14,499 +19.2%$952,378 +12%
        2015$12,167 $850,000 +8.3%
        2014$12,167 $785,000 +12.1%
        2013-- $700,000 +33.3%
        2012-- $525,000
        2011-- $525,000 -8.7%
        2010-- $575,000 -17.9%
        2009-- $700,000 -18.4%
        2008-- $858,330 +2%
        2007-- $841,500 +2%
        2006-- $825,000 +13.1%
        2005-- $729,686 +4%
        2004-- $701,354 +1.9%
        2003-- $688,500 +29.8%
        2002-- $530,603 +2%
        2001-- $520,200 +2%
        2000-- $510,000
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 94063

        Getting around

        74 / 100
        Very Walkable
        73 / 100
        Very Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: RedwoodCityElementary

        Source: MLSListings Inc. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

          1. Local buyer's agents are ready to help