Home | San Mateo County | Redwood City | 94062 | 904 Lakeview Way
MLS: ML82057909 | Status: Active | Price: $2,599,000
Beds/Baths: 3 / 3
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 3 | 2,170 | 7,112 | 1988 |
| Date | Time | Hosted By |
|---|---|---|
| Tuesday, August 18 | 9:30 am - 1:30 pm | Costantini Team |
| Saturday, August 22 | 1:30 pm - 4:00 pm | Costantini Team |
| Sunday, August 23 | 1:30 pm - 4:00 pm | Costantini Team |
Welcome to 904 Lakeview Way, a beautifully updated 3-bedroom, 3-bath home in one of Emerald Hills most sought-after and conveniently located neighborhoods. This inviting split-level floor plan features a dramatic high-ceiling living room with hardwood floors and a fireplace, flowing into the formal dining room where glass doors open to a serene backyard with a BBQ patio and lawn areaperfect for indoor-outdoor living and entertaining. The light-filled kitchen features granite countertops, an island with gas cooktop, and a sink overlooking the backyard. Upstairs, all three bedrooms are conveniently located together, including a spacious primary suite with high ceilings and a beautifully refreshed bath. Just a few steps down, a generous family room opens directly to a second backyard patio and is complemented by a full bath and an oversized two-car garage. With multiple outdoor spaces, abundant natural light, and a wonderfully livable floor plan, this home offers comfort and versatility in an exceptional setting. Enjoy a quick walk to Roy Cloud School, easy access to Highway 280 via the Farm Hill exit, and a convenient location just minutes from downtown Redwood City and Woodside.
| Field | Value |
|---|---|
| MLS # | ML82057909 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 2 |
| Feature | Details |
|---|---|
| Bedrooms | Primary Suite/Retreat, Walk-in Closet |
| Bathrooms | Double Sinks, Shower and Tub, Stall Shower, Full on Ground Floor |
| Kitchen | Countertop - Granite |
| Appliances | Cooktop - Gas, Dishwasher, Garbage Disposal, Microwave, Oven - Built-In, Refrigerator, Washer/Dryer |
| Dining Room | Formal Dining Room |
| Family Room | Separate Family Room |
| Fireplace | Gas Starter, Wood Burning |
| Flooring | Hardwood |
| Laundry | Inside |
| Cooling | None |
| Heating | Central Forced Air - Gas |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Concrete Perimeter and Slab |
| Style | Contemporary |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | Redwood City Elementary |
| High School District | Sequoia Union High |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | RH0S18 |
Costantini Team
Compass
License #: 01498092,01998461
Phone: (650) 430-8425
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Roy Cloud Elementary School | public | K-8 | 0.30 mi | 9 |
| Roosevelt Elementary School | public | K-5 | 1.04 mi | 4 |
| John F. Kennedy Middle School | public | 6-8 | 1.29 mi | 7 |
| Clifford Elementary School | public | K-8 | 1.41 mi | 7 |
| Orion Alternative School | public | K-5 | 1.42 mi | 9 |
| Henry Ford Elementary School | public | K-5 | 1.56 mi | 4 |
| Canyon Oaks Youth Center | public | 7-12 | 1.58 mi | N/A |
| Woodside High School | public | 9-12 | 1.96 mi | 8 |
| McKinley Institute Of Technology | public | 6-8 | 1.96 mi | 6 |
| North Star Academy | public | 3-8 | 1.96 mi | 10 |
| Sequoia High School | public | 9-12 | 2.05 mi | 7 |
| White Oaks Elementary School | public | K-3 | 2.13 mi | 10 |
| Heather Elementary School | public | K-3 | 2.24 mi | 9 |
| Adelante Selby Spanish Immersion School | public | K-5 | 2.28 mi | 6 |
| Woodside Elementary School | public | K-8 | 2.33 mi | 10 |
| Brittan Acres Elementary School | public | K-3 | 2.42 mi | 10 |
| Redwood High School | public | 9-12 | 2.56 mi | 2 |
| Arroyo School | public | 4,5 | 2.70 mi | 9 |
| Central Middle School | public | 6-8 | 2.76 mi | 10 |
| San Carlos Student Services Preschool | public | UG | 2.88 mi | N/A |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 214-214b Sequoia Ave | $2,590,000 | 6 | 3/1 | 2,747 | Active |
| 926 Iris St | $2,350,000 | 4 | 2 | 1,520 | PendingDoNotShow |
| 572 Santa Clara Ave | $2,698,000 | 4 | 4 | 2,650 | PendingDoNotShow |
| 947 Glennan Dr | $2,380,000 | 4 | 2/1 | 1,630 | PendingDoNotShow |
©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 August 17, 2026. For the most current information, please contact Costantini Team, (650) 430-8425.