Cheyenne Celestine
BEDS3
BATHS1 full
SQUARE FEET1,054
MLS#ML82054009
STATUSPending
PROPERTY TYPEResidential - Townhouse
SCHOOLOther
Listing Courtesy of:
KW Advisors
Agency Phone: (650) 627-3700
Associate Name: Christopher Eckert
Listing Shown by:
Farrell Smyth, Inc.
Associate Name: Cheyenne Celestine
Property Description
Welcome to this move-in ready 3-bedroom, 1-bath townhome-style condo in San Mateos desirable Lakeshore neighborhood. With no neighbors above or below, a private entrance, expansive front patio, and spacious backyard patio, it offers the privacy and feel of a single-family home. Inside, enjoy a beautifully updated kitchen, new dual-pane windows and custom plantation shutters throughout, in-unit laundry, and a bright, open floor plan designed for comfortable everyday living. Community amenities include a pool, fitness center, and beautifully maintained grounds. Just steps from Lakeshore Park, waterfront walking paths, and nearby lagoons. Walk or bike to Whole Foods, Fieldwork Brewery, Breakfast Club, and Hillsdale Shopping Center, with Bridgepointe Shopping Center, Foster City, and major commuter routes just minutes away. A wonderful opportunity to enjoy comfort, convenience, and a central Peninsula location with easy access throughout the Bay Area.
Property Features
Property Type: Residential - Townhouse
Cooling: None
Roof Type: Other
Stories: 2.0
Year Built: 1961
Feature Descriptions
Accessibility: None
Appliances: Gas Cooktop, Disposal, Gas Oven, Microwave, Refrigerator, Vented Exhaust Fan
Association Amenities: Clubhouse, Fitness Center, Hot Water, Pool, Recreation Room, Spa/Hot Tub, Trash
Community Features: Pool
Days on Site: 9
Flooring: Laminate
HOA Fee: 819/ Monthly
Parcel#: 103790450
Parking: Carport
Parking Notes: Carport
Pool: Community, Association
Sewer: Public Sewer
Spa: Community
Spa: Yes
Swimming Pool: Yes
Water: Public
Local Schools
School District: Other
Listed By / Shown By
Listed By
Agency Name: KW Advisors
Agent Name: Christopher Eckert
Agency Phone: (650) 627-3700
Shown By
Agent Name: Cheyenne Celestine
Agent Phone: (805) 543-2636 ext. 16
Agency Title: Farrell Smyth, Inc.
Estimate Your Payment
Estimated Payment
$ 1,699.13 per month $1,502.26 Principal & Interest $0.00 Property Tax (data not provided by mls) $196.88 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
1536 Day Avenue, Unit D | MLS# ML82054009
This townhouse located at 1536 Day Avenue, Unit D, San Mateo, CA 94403 is currently listed for sale with an asking price of $675,000. This property was built in 1961 and has 3 bedrooms and 1 full baths with 1054 sq. ft. Day Avenue, Unit D is located within the Other school district. Search San Mateo real estate on ccelestine.farrellsmyth.com today.