Located on a lovely, tree-lined street, this truly exceptional home is just a short walk to vibrant downtown San Mateo, known for its excellent restaurants, shopping & nearby Central Park. Blending timeless character with modern comfort, the home offers a spacious & highly versatile floor plan with multiple living areas. The main level welcomes you through a striking carousel-shaped entry that opens to a bright & inviting living room, a formal dining room, office, full bathroom, and laundry room. The open kitchen flows seamlessly to the beautifully landscaped backyard. Upstairs are two spacious bedrooms, an additional full bathroom & a cozy bonus room currently set up as a nursery. The lower level features an expansive bonus space with a full bathroom, dining area & a kitchenette (without stove). This flexible area is ideal for guests, a family or media room. Outside, the property offers beautifully landscaped front & back yards, along with a long, electronically gated, driveway perfect for RV parking. The driveway leads to a large two-car garage. Above the garage is a charming, light-filled one-bedroom in-law unit, adding even more flexibility to this remarkable property. With its unique character, generous space and prime location, this special home is not to be missed.