Home | San Mateo County | Hillsborough | 94010 | 2140 Carmelita Ave
MLS: ML82051272 | Status: Active | Price: $5,488,000
Beds/Baths: 4 / 2 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 2 /1 | 2,910 | 24,055 | 1967 |
| Date | Time | Hosted By |
|---|---|---|
| Thursday, June 18 | 5:00 pm - 7:00 pm | Ogie Mendoza |
| Friday, June 19 | 5:00 pm - 7:00 pm | Ogie Mendoza |
| Saturday, June 20 | 2:00 pm - 4:00 pm | Samantha Cortez |
| Sunday, June 21 | 1:00 pm - 4:00 pm | James Mirt/Kyle Pruden |
| Tuesday, June 23 | 10:00 am - 12:00 pm | James Mirt |
Nestled in prestigious Lower North Hillsborough, this distinguished single level residence offers a bright, airy & luxurious living style. The over half acre level lot offers European inspired gardens with flowering plants and meandering foot paths. The impressive front courtyard enters to a grand formal living room with walls of windows overlooking the spectacular gardens & pool area. The spacious family room with fireplace also looks out to the resort style grounds. A formal dining room, ideal for entertaining, is off the beautifully updated kitchen with its comfortable eating area. The laundry room and half bath, so handy off the kitchen, leads to the oversize attached three car garage. The primary suite with access to the gardens, has multiple closets including a large walk in style, and an updated bathroom. Other bedrooms are roomy & cheerful. The grounds feature multiple inviting gathering areas & remarkable landscaping, a large level lawn area, children's play area all with charming winding footpaths throughout. The beautiful pool/spa setting offers exceptional privacy creating a serene retreat space This truly special home offers it all and is so close to all the Burlingame shops, services & restaurants, and all transportation options nearby too! An enchanting home!
| Field | Value |
|---|---|
| MLS # | ML82051272 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 0 |
| Feature | Details |
|---|---|
| Bedrooms | Reverse Floor Plan, Walk-in Closet, More than One Bedroom on Ground Floor |
| Appliances | Dishwasher |
| Dining Room | Eat in Kitchen, Formal Dining Room |
| Family Room | Separate Family Room |
| Fireplace | Family Room, Living Room |
| Flooring | Hardwood, Tile, Vinyl/Linoleum |
| Laundry | Inside, In Utility Room |
| Cooling | None |
| Heating | Central Forced Air - Gas, Heating - 2+ Zones |
| Feature | Details |
|---|---|
| Roof | Flat |
| Foundation | Other |
| Pool | Fenced, In Ground |
| Style | Ranch |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Off-Street Parking, Garage: 3 Car(s) |
| Elementary District | Hillsborough City Elementary |
| High School District | San Mateo Union High |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | R10025 |
Brian Boisson
Intero Real Estate Services
License #: 00591631
Phone: (650) 302-6458
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| BSD Preschool | public | UG | 0.12 mi | N/A |
| Roosevelt Elementary School | public | K-5 | 0.12 mi | 6 |
| McKinley Elementary School | public | K-5 | 0.68 mi | 8 |
| Hoover Elementary | public | K-5 | 0.69 mi | 8 |
| North Hillsborough School | public | K-5 | 0.75 mi | 9 |
| Crocker Middle School | public | 6-8 | 0.82 mi | 8 |
| Lincoln Elementary School | public | K-5 | 0.86 mi | 8 |
| Burlingame Intermediate School | public | 6-8 | 1.16 mi | 10 |
| Burlingame High School | public | 9-12 | 1.25 mi | 10 |
| Franklin Elementary School | public | K-5 | 1.29 mi | 10 |
| Peninsula High (Continuation) | public | 9-12 | 1.37 mi | 4 |
| Peninsula High | public | 9-12 | 1.37 mi | N/A |
| Spring Valley Elementary School | public | K-5 | 1.52 mi | 10 |
| San Mateo Park Elementary School | public | K-5 | 1.55 mi | 2 |
| Washington Elementary School | public | K-5 | 1.57 mi | 7 |
| Mills High School | public | 9-12 | 1.64 mi | 10 |
| West Hillsborough School | public | K-5 | 1.92 mi | 9 |
| South Hillsborough School | public | K-5 | 2.07 mi | 9 |
| San Mateo High School | public | 9-12 | 2.14 mi | 9 |
| San Mateo Adult | public | UG | 2.22 mi | N/A |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 1548 Cypress Ave | $5,880,000 | 4 | 4/1 | 2,647 | Active |
| 1385 Hillside Cir | $5,199,000 | 6 | 6 | 11,040 | PendingDoNotShow |
| 1472 Drake Ave | $4,998,000 | 5 | 5/1 | 3,325 | Active |
| 162 Los Robles Dr | $5,698,000 | 7 | 6 | 4,674 | Active |
©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 June 17, 2026. For the most current information, please contact Brian Boisson, (650) 302-6458.