Situated in the sought-after Emerald Hills neighborhood, this custom-built modern farmhouse offers elegance and luxury. The main house spans 4,000 sq. ft. and includes 5 spacious bedrooms, 4.5 bathrooms, a separate office with an outside entrance, and a private 700+ sq. ft. cottage, all on a 17,928 sq. ft. lot. Bay views from most bedrooms and a thoughtfully designed layout perfect for both relaxation and entertaining. A grand entry with towering ceilings and a sweeping curved staircase welcomes you, complemented by a full junior suite on the main level. The recently updated kitchen, equipped with quartz countertops and premium appliances, offers an eat-in area & breakfast bar overlooking a sunlit yard with a sparkling swimming pool. The pool area has spacious patios for barbecues + an outdoor guest restroom.
For formal occasions, the separate dining room provides an elegant setting, while the living room features a cozy fireplace and bay window capturing the home's natural beauty. The expansive family room, complete with a built-in bar and large entertainment center, is perfect for movie nights or hosting guests. This home is conveniently located just minutes from 280, and both downtown Woodside and RWC. High ceiling 3 car driveway + multiple driveway spaces.
Sold for $4,899,000
$4,899,000
954 Lakeview Way, Redwood City, CA 94062
5beds
4,780sqft
Single Family Residence, Residential
Built in 1998
0.41 Acres Lot
$5,119,800 Zestimate®
$1,025/sqft
$12,283 Estimated rent
Home value
$5,119,800
$4.66M - $5.63M
$12,283/mo
Zestimate® history
Owner options
List your home for rent
$12,283/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$12,283/mo
Rent Zestimate®
Refinance and save
$31,219/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$31,219/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 startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Cozy fireplaceSparkling swimming poolLarge entertainment centerSpacious patiosSweeping curved staircaseExpansive family roomQuartz countertops
Zillow last checked:
Listing updated:
Listed by:
Costantini Team 70010227 650-430-8425,
Compass 650-529-1111
Bought with:
Vickie Burgess, 01862208
Realsmart Properties
Source: MLSListings Inc,MLS#: ML82001290
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Rooms
- Room types: Laundry, Office
Dining room
- Features: FormalDiningRoom
Family room
- Features: SeparateFamilyRoom
Heating
- Central Forced Air Gas
Cooling
- Central Air, Zoned
Appliances
- Included: Dishwasher, Disposal, Microwave, Gas Oven/Range, Refrigerator, Washer/Dryer
- Laundry: Inside
Features
- Vaulted Ceiling(s)
- Flooring: Carpet, Hardwood
- Number of fireplaces: 3
- Fireplace features: Gas Starter, Wood Burning
Interior area
- Total structure area: 4,780
- Total interior livable area: 4,780 sqft
Property
Parking
- Total spaces: 7
- Parking features: Attached, Parking Area
- Attached garage spaces: 3
Features
- Stories: 2
- Pool features: In Ground
- Spa features: Other
- Fencing: Back Yard
- Has view: Yes
- View description: Bay, Water
- Has water view: Yes
- Water view: Bay,Water
Lot
- Size: 0.41 Acres
Details
- Parcel number: 068191010
- Zoning: RH0S18
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Farm House
- Property subtype: Single Family Residence, Residential
Materials
- Foundation: Concrete Perimeter and Slab
- Roof: Composition
Condition
- New construction: No
- Year built: 1998
Utilities & green energy
- Gas: PublicUtilities
- Water: Public
- Utilities for property: Public Utilities, Water Public
Community & HOA
Location
- Region: Redwood City
Financial & listing details
- Price per square foot: $1,025/sqft
- Tax assessed value: $3,560,704
- Annual tax amount: $42,852
- Date on market: 4/6/2025
- Listing agreement: ExclusiveRightToSell
Price history
| Date | Event | Price |
|---|---|---|
| 5/12/2025 | Sold | $4,899,000$1,025/sqft |
Source:  MLSListings Inc #ML82001290 Report a problem | ||
| 4/15/2025 | Pending sale | $4,899,000$1,025/sqft |
Source: MLSListings Inc #ML82001290 Report a problem | ||
| 4/7/2025 | Listed for sale | $4,899,000+104.6%$1,025/sqft |
Source: MLSListings Inc #ML82001290 Report a problem | ||
| 5/2/2009 | Listing removed | $2,395,000$501/sqft |
Source: eWalk Virtual Tours #80901614 Report a problem | ||
| 2/13/2009 | Price change | $2,395,000-7.7%$501/sqft |
Source: eWalk Virtual Tours #80901614 Report a problem | ||
| 1/18/2009 | Listed for sale | $2,595,000+11.4%$543/sqft |
Source: eWalk Virtual Tours #80901614 Report a problem | ||
| 5/11/2001 | Sold | $2,330,000+747.3%$487/sqft |
Source: Public Record Report a problem | ||
| 10/18/1996 | Sold | $275,000+19.6%$58/sqft |
Source: Public Record Report a problem | ||
| 12/30/1993 | Sold | $230,000$48/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $42,852 +1.4% | $3,560,704 +2% |
| 2024 | $42,275 +6.7% | $3,490,887 +2% |
| 2023 | $39,636 +0.1% | $3,422,439 +2% |
| 2022 | $39,612 +1.3% | $3,355,334 +2% |
| 2021 | $39,107 +1.6% | $3,289,545 +1% |
| 2020 | $38,473 +0.7% | $3,255,816 +2% |
| 2019 | $38,192 +2.9% | $3,191,978 +2% |
| 2018 | $37,115 +10.8% | $3,129,392 +11.8% |
| 2017 | $33,511 +1.2% | $2,800,000 |
| 2016 | $33,126 +58.8% | $2,800,000 +16.7% |
| 2015 | $20,866 | $2,400,000 +37.1% |
| 2014 | $20,866 | $1,750,000 |
| 2013 | -- | $1,750,000 |
| 2012 | -- | $1,750,000 |
| 2011 | -- | $1,750,000 -12.5% |
| 2010 | -- | $2,000,000 -9.1% |
| 2009 | -- | $2,200,000 -18.8% |
| 2008 | -- | $2,710,826 +2% |
| 2007 | -- | $2,657,674 +2% |
| 2006 | -- | $2,605,564 +27.7% |
| 2005 | -- | $2,040,000 |
| 2004 | -- | $2,040,000 |
| 2003 | -- | $2,040,000 |
| 2002 | -- | $2,040,000 +151.8% |
| 2001 | -- | $810,121 +2% |
| 2000 | -- | $794,237 |
Find assessor info on the county website
Neighborhood: 94062
Nearby homes
- $2,704,6003 bd2 ba2.6k sqft950 Lakeview Way, Redwood City, CA 94062Off Market
- $3,156,8006 bd4 ba4.1k sqft3965 Jefferson Ave, Redwood City, CA 94062Off Market
- $3,570,7004 bd2 ba3.3k sqft951-955 Lakeview Dr, Redwood City, CA 94062Off Market
- $2,938,6004 bd2 ba3.3k sqft3955 Jefferson Ave, Redwood City, CA 94062Off Market
- $2,415,5004 bd2 ba2.1k sqft3951 Jefferson Ave, Redwood City, CA 94062Off Market
- $3,650,0004 bd5 ba4.4k sqft3961 Jefferson Ave, Redwood City, CA 94062Sold
- $3,128,0004 bd4 ba2.9k sqft3969 Jefferson Ave, Redwood City, CA 94062Sold
- $2,106,4003 bd2 ba1.8k sqft960 Lakeview Way, Redwood City, CA 94062Off Market
Nearby schools
GreatSchools rating
- 9/10Roy Cloud Elementary SchoolGrades: K-8Distance: 0.3 mi
- 8/10Woodside High SchoolGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Elementary: RoyCloudElementary
- High: WoodsideHigh
- 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.
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
$5,119,800
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
$5,119,800
- California
- San Mateo County
- Emerald Lake Hills
- 94062
- 954 Lakeview Way
Nearby cities
Nearby zip codes
Other Emerald Lake Hills Topics
- Apartments for Rent in 94062
- Houses for Sale in 94062
- Houses for Rent in 94062
- 94062 Real Estate
- Emerald Lake Hills Condos
- Houses for Sale in Emerald Lake Hills
- Newest Listings in Emerald Lake Hills
- Emerald Lake Hills Home Values
- Emerald Lake Hills Real Estate Agents
- Emerald Lake Hills Refinance
- Emerald Lake Hills Mortgage Rates
