Home | San Joaquin County | Mountain House | 95391 | 1556 S Oliveira Dr
MLS: BE41139213 | Status: Active | Price: $1,075,000
Beds/Baths: 6 / 4 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 6 | 4 /1 | 2,838 | 7,071 | 2020 |
Dual Addresses • Multi-Generational Luxury • Income Generating Two Distinct Street Addresses under One Roof! Welcome to this exceptional, modern multi-generational estate built in 2020, perfectly situated in the highly desirable Cordes Village. Nestled on a premium, highly coveted hill-view lot within College Park, this property offers a rare combination of contemporary luxury, flexible living, and immediate rental income. The estate is located within walking distance to top-rated K-12 schools, including Julius Cordes Elementary and Mountain House High School, making it a perfect match for growing families or savvy investors. Main Residence The light-filled main home showcases an open-concept floor plan meticulously designed with high-end finishes. It features a spacious layout with 4 bedrooms and 3.5 bathrooms, configured with a luxurious primary suite and two comfortable junior suites. The heart of the home features a chef’s kitchen anchored by an oversized island, elegant granite countertops, custom stylish backsplashes, and premium stainless steel appliances. The primary retreat offers a generous, light-filled suite complete with a massive walk-in closet and a spa-like, lavish shower. Low-maintenance, durable flooring flows seamlessly throughout the entire living space. Sep
| Field | Value |
|---|---|
| MLS # | BE41139213 |
| MLS Source | Bay East |
| Days on Site | 0 |
| Feature | Details |
|---|---|
| Bathrooms | Bidet, Primary - Bidet, Primary - Tub |
| Appliances | Microwave, Oven - Double, Oven - Self Cleaning, Oven Range - Gas, Refrigerator, Dryer, Washer, Water Softener |
| Fireplace | None |
| Flooring | Vinyl |
| Laundry | In Laundry Room |
| Cooling | Ceiling Fan, Central -1 Zone |
| Heating | Heat Pump |
| Feature | Details |
|---|---|
| Roof | Tile |
| Pool | None, Pool - No |
| Style | Traditional |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage, Gate/Door Opener, Garage: 2 Car(s) |
Karunasagar Kotha
ValleyVentures Realty Inc
License #: 02038951
Phone: (925) 231-5022
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Evelyn Costa Elementary | public | K-8 | 0.20 mi | 10 |
| Julius Cordes Elementary | public | K-8 | 0.33 mi | 10 |
| Mountain House High School | public | 9-12 | 0.54 mi | 10 |
| Hansen Elementary | public | K-8 | 0.58 mi | 10 |
| Wicklund Elementary School | public | K-8 | 0.96 mi | 9 |
| Bethany Elementary School | public | K-8 | 1.12 mi | 9 |
| Lammersville Elementary School | public | K-8 | 1.62 mi | 8 |
| Altamont Elementary School | public | K-8 | 1.73 mi | 9 |
| Sebastian Questa Elementary School | public | K-8 | 2.17 mi | 10 |
| Mountain House Elementary School | public | K-8 | 2.80 mi | 9 |
| John C. Kimball High School | public | 9-12 | 4.08 mi | 8 |
| George Kelly Elementary School | public | K-8 | 4.90 mi | 7 |
| Tracy Adult | public | UG | 4.91 mi | N/A |
| Art Freiler School | public | K-8 | 4.95 mi | 6 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 527 W Questa Trl | $1,025,000 | 3 | 3 | 2,965 | Active |
| 566 W Bonaventure Ave | $1,150,000 | 5 | 4 | 3,336 | Active |
| 700 W Esplanade | $1,250,000 | 6 | 4/1 | 4,002 | Active |
| 15659 La Paz St | $1,200,000 | 4 | 2/1 | 2,025 | Active |
©2026 Bay East. 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 Bay East.
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 22, 2026. For the most current information, please contact Karunasagar Kotha, (925) 231-5022.