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 on 05/12/25
$4,899,000
954 Lakeview Way, Redwood City, CA 94062
5beds
4,780sqft
Single Family Residence,
Built in 1998
0.41 Acres Lot
$4,930,700 Zestimate®
$1,025/sqft
$12,283 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: May 12, 2025 at 09:32am
Listed by:
Costantini Team 70010227 650-430-8425,
Compass
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
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,
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 & neighborhood
Location
- Region: Redwood City
Other
Other facts
- Listing agreement: ExclusiveRightToSell
Services availability
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
$4,930,700