Skip main navigation
Off market
  • $2,750,000

    623 28th Ave, San Mateo, CA 94403

    5beds
    4baths
    2,350sqft
    SingleFamily
    Built in 1999
    5,488 Square Feet Lot
    $2,750,000 Zestimate®
    $1,170/sqft
    $7,194 Estimated rent

    Home value

    $2,750,000

    $2.53M - $3.00M

    $7,194/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $7,194/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,194/mo

    Rent Zestimate®

    Refinance and save

    $17,118/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $17,118/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Welcome to your future residence nestled in one of San Mateo's most desirable neighborhoods. This stunning property consists of five (5) large bedrooms and four (4) bathrooms with approximately 2,350 square feet of livable area. The property has been completely renovated with an enormous backyard for endless year long enjoyment. With a world-class location in the heart of Silicon Valley, 623 28th Avenue is a highly coveted place to call home for Peninsula renters due to the close proximity to major employers, transportation corridors, shopping, dining and entertainment options. The property is conveniently located across the street from Beresford park which offers many family-orientated amenities such as a Community center, tennis courts, bocce ball, newly renovated playground, ample open grass areas, and much more. Additionally, Downtown San Mateo is a short drive/Shared-App away which boasts more than 150 restaurants and bars, nearly 100 shops, a dozen specialty grocers, a movie theater, and the San Mateo Caltrain Station. The downtown area is a cultural, entertainment and economic hub on the Peninsula, offering a vibrant setting for locals and visitors alike to enjoy the weekend farmers markets, destination restaurants, and exciting entertainment. Interior Amenities: -California Closets in All Bedrooms -Separate Living Room and Dining Room -Custom Master Bathroom with Heated Floors (Master Bathroom) -New Washer & Dryer -Two Gas Fireplaces -Stainless Steel Appliances -Kitchen has granite counters -Kitchen has updated white wood cabinets -Designer Neutral Interior Color Schemes -Dual Pane Windows (Savings on Energy Expenses) -Hardwood Flooring Downstairs -Newly painted garage with epoxy coating -New second refrigerator in the garage Exterior Amenities: -New Insulated Hot Tub -Large Secured Storage Shed -Refinished Hardwood Backyard Deck -Herb Garden and Landscaped Backyard -Pet Friendly with Separate Dog Run -Two Car Garage Surrounding Neighborhood Amenities: -Beresford Park (Family-friendly: Tennis courts, Bocce ball, Basketball, renovated playground, Baseball fields) -Newly Designed Hillsdale Shopping Center (Movie Theater, Culinary Inspired Restaurants, Shopping Destination) -Located within 1 Mile from Caltrain Station -Convenient Ingress/Egress to State Route 92 onto Hwy 280 & 101. -Top Ranked Schools (Walking Distance) Terms of lease: -Length (Minimum 12-month Term Required) -Owner Pays Monthly Gardener -Monthly Rent: $7,200 (Equal Security Deposit Required) -Non Smoking -Pet Friendly *Please call or email to make an appointment. Equal Housing Opportunity

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    Heating
    • Forced air
    Cooling
    • None
    Appliances
    • Included: Dryer, Washer
    • Laundry: In Unit
    Features
    • Flooring: Hardwood
    • Basement: Unfinished
    Interior area
    • Total interior livable area: 2,350 sqft

    Property

    Parking
    • Parking features: Garage - Detached, Off-street
    Features
    • Has spa: Yes
    Lot
    • Size: 5,488 sqft
    Details
    • Parcel number: 039281040

    Construction

    Type & style
    • Home type: SingleFamily
    Condition
    • Year built: 1999

    Community & neighborhood

    Location
    • Region: San Mateo

    Other

    Other facts
    • Across the street from Beresford park
    • Balcony
    • Dual Pane Windows
    • Heated Bathroom Floor
    • Large Secured Storage Shed
    • Laundry: In Unit
    • Parking Type: Garage
    • Separate Living Room and Dinning Room
    • Stainless Steal Appliances
    • Two Gas Fireplaces

    Price history

    DateEventPrice
    8/14/2022Listing removed--
    Source: Zillow Rental Manager
    7/8/2022Listed for rent$7,200+5.9%$3/sqft
    Source: Zillow Rental Manager
    3/4/2021Listing removed--
    Source: Owner
    1/21/2020Listing removed$6,800$3/sqft
    Source: Owner
    12/13/2019Price change$6,800-5.6%$3/sqft
    Source: Owner

    Public tax history

    YearProperty taxesTax assessment
    2024$14,195 -1.2%$979,034 +2%
    2023$14,369 +4%$959,838 +2%
    2022$13,817 +5.1%$941,018 +2%

    Find assessor info on the county website

    Neighborhood: Northwest Hillsdale

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes

    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.

    Estimated market value

    $2,750,000

    Get a cash offer in 3 minutes

    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.

    Estimated market value

    $2,750,000