$3,600,000
SOLD JUL 9, 2025
5 Beds
3.5 Baths
3,080 Sq Ft
0.28 Acres

Recently Sold

$1,169 Per Sq Ft

3% Above List Price

12 Days on Market

Highlights

  • 0.28 Acre Lot
  • Fireplace in Primary Bedroom
  • 2 Car Detached Garage
  • Foster City Elementary School Rated A
  • Formal Dining Room
  • Open to Family Room

About This Home

As of July 2025

Welcome to the ultimate waterfront retreat in Foster City! This one-of-a-kind property boasts a WIDE WATERFRONT setting, offering breathtaking views and a serene ambiance. Situated on an expansive 12,086 square foot lot, this home features a large beautifully landscaped backyard thats perfect for gatherings, play, or simply enjoying the outdoors in your private sanctuary. Inside, you'll find 3,080 square feet, all one-level living space, meticulously remodeled to blend modern elegance with comfortable living. The home includes 5 spacious bedrooms plus an office/den/gym and 3.5 bathrooms, providing ample space for everyone. High ceilings throughout enhance the open feel, while the great room with vaulted ceilings and a stunning waterfront view further elevates the living experience. Whip up your favorite meals in the sleek kitchen with quartz countertops, new stainless appliances and a handy breakfast bar, great for quick bites or chatting with friends. A security gate adds an extra layer of peace of mind. Whether you're soaking up the sun and water views on your deck or enjoying the expansive backyard, this home offers the ultimate in laid-back waterfront living, all in a serene cul-de-sac setting!

Last Agent to Sell the Property

Rico Bautista

Compass License #00898958 Listed on: 06/11/2025

Compass

Last Buyer's Agent

Julie Flouty

Compass License #01901710

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,683

Year Built

  • Built in 1977

Lot Details

  • 0.28 Acre Lot
  • Zoning described as R100PD

HOA Fees

  • $370 Monthly HOA Fees

Parking

  • 2 Car Detached Garage
  • Garage Door Opener
  • Guest Parking

Home Design

  • Slab Foundation
  • Tile Roof

Interior Spaces

  • 3,080 Sq Ft Home
  • 1-Story Property
  • Living Room with Fireplace
  • Formal Dining Room
  • Open to Family Room

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom

Utilities

  • Forced Air Heating System

Community Details

  • Longwater HOA
  • Built by Longwater HOA

Listing and Financial Details

  • Assessor Parcel Number 094-860-080

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,683

Year Built

Built in 1977

Lot Details

0

HOA Fees

$370 per month

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Age: 48
  • Listing Class: Residential
  • Structure Sq Ft: 3080
  • Complex Name: Longwater HOA
  • Year Built: 1977
  • Zoning Description: R100PD
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Living Room, Primary Bedroom
  • Dining Room: Formal Dining Room
  • Living Sq Ft: 3080
  • Stories: 1
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 5
  • Minimum Numberof Bedrooms: 5
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Slab
  • Roof: Tile

Garage/Parking

  • Garage Spaces: 2
  • Garage Max: 2
  • Garage Min: 2
  • Garage Parking Features: Detached Garage, Gate / Door Opener, Guest / Visitor Parking

Utilities

  • Heating System: Forced Air
  • Sewer/Septic System: Sewer - Public

Condo/Co-op/Association

  • HOA Fees: 370
  • HOA Fee Frequency: Monthly
  • H O A Name Text: Longwater HOA
  • H O A Exist: Yes

Schools

  • School District: San Mateo Union High
  • Elementary School: Foster City Elementary
  • Middle School: Bowditch Middle
  • Elementary School: 631
  • Middle School: 611

Lot Info

  • Parcel Number: 094-860-080
  • Lot Acres: 0.2775
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 12086.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 12086.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: San Mateo Union High
  • Elementary School Text: Foster City Elementary
  • Middle School Text: Bowditch Middle

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 11, 2025
Closed on
Jul 1, 2025
Sold by
Jose Andres Llc
Bought by
Joshi Deepark Giridhar and Joshi Archana Anil
Seller's Agent
Rico Bautista
Compass
Buyer's Agent
Julie Flouty
Compass
List Price
$3,500,000
Sold Price
$3,600,000
Premium/Discount to List
$100,000
2.86%
Views
41

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-17.25%
Original Mortgage
$1,800,000
Outstanding Balance
$1,798,167
Interest Rate
5.88%
Mortgage Type
New Conventional
Estimated Equity
$1,674,630

Purchase Details

Closed on
May 10, 2024
Sold by
Lopez Karen Coloma
Bought by
Lopez Eugenio

Purchase Details

Closed on
May 8, 2018
Sold by
Jose Andres Llc
Bought by
Lopez Eugenio

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$512,000
Interest Rate
3.87%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jan 15, 2014
Sold by
Lopez Eugenio
Bought by
Jose Andres Llc

Purchase Details

Closed on
Nov 15, 2011
Sold by
Lopez Eugenio
Bought by
Lopez Eugenio

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$722,900
Interest Rate
3.25%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 18, 2009
Sold by
Lopez Angela Maria T
Bought by
Lopez Eugenio

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$980,000
Interest Rate
5.5%
Mortgage Type
Unknown

Purchase Details

Closed on
Mar 31, 2003
Sold by
Lopez Eugenio
Bought by
Lopez Eugenio and Lopez Angela Maria T

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$260,000
Interest Rate
4.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 28, 1996
Sold by
Shu Donald G C
Bought by
Lopez Eugenio

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$388,000
Interest Rate
7.62%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Grant Deed $3,600,000 Old Republic Title
Deed -- None Listed On Document
Grant Deed -- None Listed On Document
Grant Deed -- Chicago Title Co
Grant Deed -- None Available
Interfamily Deed Transfer -- Chicago Title Company Pa
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- Fidelity National Title
Individual Deed $485,000 North American Title Co
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,800,000 New Conventional
Previous Owner $512,000 Adjustable Rate Mortgage/ARM
Previous Owner $175,000 Stand Alone Second
Previous Owner $805,000 Adjustable Rate Mortgage/ARM
Previous Owner $811,000 Adjustable Rate Mortgage/ARM
Previous Owner $722,900 New Conventional
Previous Owner $301,500 Future Advance Clause Open End Mortgage
Previous Owner $729,750 New Conventional
Previous Owner $980,000 Unknown
Previous Owner $260,000 Purchase Money Mortgage
Previous Owner $379,088 Unknown
Previous Owner $388,000 No Value Available
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/09/2025 07/09/25 Sold $3,600,000 +2.9% $1,169 / Sq Ft
06/24/2025 06/24/25 Pending -- -- --
06/11/2025 06/11/25 For Sale $3,500,000 -- $1,136 / Sq Ft
Source: MLSListings

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $11,683 $989,222 $402,852 $586,370
2023 $11,683 $950,812 $387,209 $563,603
2022 $11,288 $932,170 $379,617 $552,553
2021 $11,140 $913,894 $372,174 $541,720
2020 $10,835 $904,524 $368,358 $536,166
2019 $10,270 $886,790 $361,136 $525,654
2018 $9,795 $869,404 $354,055 $515,349
2017 $9,686 $852,358 $347,113 $505,245
2016 $9,691 $835,647 $340,307 $495,340
2015 $9,466 $823,097 $335,196 $487,901
2014 $9,226 $806,974 $328,630 $478,344
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML82010664

MLSListings

APN: 094-860-080