604 San Nicholas LN, Foster City, CA 94404
Welcome to this exquisite "Longwater Community" & Waterfront Property! This impeccably maintained & beautifully updated home offers the perfect combination of modern luxury & a prime waterfront location with stunning Lagoon's views from the sunroom. As you step into this 3Be, 2.5Ba home, you'll be greeted by a sense of elegance and comfort. The living/dining areas are generously sized, making entertaining friends & family a breeze. The heart of this home is the light- flooded chef's kitchen, which boasts granite countertops, a large center island & top-quality appliances. Whether you're a culinary enthusiast or simply enjoy hosting gatherings, this kitchen is a dream come true. One of the unique highlights of this property is the additional nearly 300 sqft entertaining sunroom. With its seamless blend of indoor and outdoor spaces, it offers the perfect setting for hosting memorable gatherings & enjoying the natural beauty that surrounds the home. AND the location is truly unbeatable.
Features
| Additional Rooms | Laundry Room, Other |
| Cooling | None |
| Dining Room | Dining Area, Eat in Kitchen |
| Family Room | Other |
| Fireplaces | Living Room, Other |
| Flooring | Hardwood, Stone, Tile |
| Garage Parking Features | Attached Garage, Guest / Visitor Parking |
| Heating | Central Forced Air |
| Kitchen | Cooktop - Gas, Dishwasher, Island, Microwave, Oven - Gas, Refrigerator |
| Laundry | Washer / Dryer |
| Listing Class | Residential Lease/Rental |
| Listing Service | Full Service |
| No of Stories | 1 |
| Rent Includes | Gardener |
| Subclass | House for Rent |
| View | Other |
| Yard/Grounds | Back Yard |
Community Info
Local Schools | |
Local Utilities | Recreation |
Restaurants | Home and Garden |
Schools
Comments
|
Comment Type:
|
||
|
Your comment:
|
||
| Type the Code Below | ||
You will need to login to view or add any comments on this property.
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.
The data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system.
Real estate listings held by brokerage firms other than listing brokerage are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents.
© 2018 MLSListings. All rights reserved.
This data is updated every 15 minutes. Some properties appearing for sale on this display may subsequently have sold and may no longer be available.
Updated on 9/20/2024
Property Information
- MLS:
- ML81970322
- Type:
- House for Rent
- Year Built:
- 1977
- Listed:
- 6/19/2024
- Sold Date:
- 7/1/2024
- Interior:
- 1,880
- Lot Size:
- 9,599
- Bedrooms:
- 3
- Bathrooms:
- 2 Full,1 Partial
- Schools:
- GS Dist: San Mateo-Foster City Elementary District
HS Dist: San Mateo Union High District
 | LP: $7,500 Foster City,94404 |
 | SP: $6,900 LP: $6,900 Foster City,94404 |
 | SP: $7,200 LP: $7,150 Foster City,94404 |
 | SP: $6,500 LP: $6,495 Belmont,94002 |
 | SP: $7,250 LP: $6,880 Foster City,94404 |
All information furnished regarding property for sale, rental, comparables or financing is from sources deemed reliable, but no warranty or representation is made as to the accuracy thereof and same is submitted subject to errors, omissions, change of price, rental or other conditions, prior sale, lease or financing or withdrawal without notice.