Home | Alameda County | Union City | 94587 | 34907 Limestone Ct
MLS: BE41135729 | Status: Active | Price: $1,560,000
Beds/Baths: 4 / 2 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 2 /1 | 2,146 | 5,975 | 2000 |
Discover the epitome of modern comfort in this lovingly cared-for home. Tucked away in a desirable court location, this spacious residence features 4 bedrooms and 2.5 bathrooms with a thoughtful layout designed for both everyday living and entertaining. Step inside to a separate living room and family room highlighted by soaring ceilings, an open staircase, and abundant natural light. The bright interior is enhanced by new laminate flooring throughout the downstairs, creating a warm and modern feel. The large kitchen features new quartz countertops, a new sink and faucet, stainless-steel appliances, a central island, and a pantry. A comfortable breakfast nook opens to the family room, making it the perfect space for casual dining and gatherings. The spacious primary suite offers a relaxing retreat with a walk-in closet and an en-suite bathroom featuring both a shower and soaking tub. Enjoy the convenience of living near a community park, shopping, dining, and Quarry Lakes. Commuters will appreciate easy access to Highways 880 and 84, BART, and nearby bridges. This home offers the ideal balance of comfort, location, and lifestyle.
| Field | Value |
|---|---|
| MLS # | BE41135729 |
| MLS Source | Bay East |
| Days on Site | 7 |
| Feature | Details |
|---|---|
| Bathrooms | Double Sinks, Primary - Shower(s) over Tub(s), Primary - Solid Surface, Primary - Split Bath, Primary - Tub, Primary - Updated Bath(s), Tile, Updated Bath(s) |
| Kitchen | Breakfast Nook, Countertop - Solid Surface / Corian, Island, Pantry, Updated |
| Appliances | Dishwasher, Garbage Disposal, Microwave, Oven Range, Oven Range - Gas |
| Dining Room | Dining Area |
| Family Room | Separate Family Room |
| Fireplace | Family Room, Gas Burning |
| Flooring | Carpet - Wall to Wall, Laminate, Tile |
| Laundry | 220 Volt Outlet, Hookup - Gas Dryer, Hookups Only, In Garage, In Laundry Room |
| Cooling | Central -1 Zone |
| Heating | Forced Air |
| Feature | Details |
|---|---|
| Roof | Tile |
| Foundation | Slab |
| Pool | None, Pool - No |
| Style | Contemporary |
| Feature | Details |
|---|---|
| Garage/Parking | Access - Interior, Attached Garage, Garage, Gate/Door Opener, Garage: 2 Car(s) |
Aimee Ran Song
Coldwell Banker Realty
License #: 01951402
Phone: (510) 990-9999
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| James Logan High School | public | 9-12 | 0.80 mi | 8 |
| New Haven Adult | public | UG | 0.80 mi | N/A |
| Guy Jr. Emanuele Elementary School | public | K-5 | 1.06 mi | 7 |
| Searles Elementary School | public | K-5 | 1.07 mi | 5 |
| Warwick Elementary School | public | TK,KG,1,2,3,4,5 | 1.15 mi | 9 |
| Brookvale Elementary School | public | TK,KG,1,2,3,4,5 | 1.16 mi | 7 |
| American High School | public | 9-12 | 1.46 mi | 10 |
| Decoto School For Independent Study | public | K-12 | 1.67 mi | 6 |
| Niles Elementary School | public | TK,KG,1,2,3,4,5 | 1.70 mi | 9 |
| Oliveira Elementary School | public | TK,KG,1,2,3,4,5 | 1.73 mi | 8 |
| Patterson Elementary School | public | TK,KG,1,2,3,4,5 | 1.91 mi | 8 |
| Thornton Middle School | public | 6-8 | 1.95 mi | 9 |
| Cesar Chavez Middle School | public | 6-8 | 1.99 mi | 4 |
| Centerville Middle School | public | 6-8 | 2.11 mi | 8 |
| Core Learning Academy At Conley-Caraballo High | public | 9-12 | 2.19 mi | 2 |
| Alternative Learning Academy At Conley-Caraballo High | public | 9-12 | 2.19 mi | N/A |
| Tom Kitayama Elementary School | public | K-5 | 2.23 mi | 8 |
| Hillview Crest Elementary School | public | K-5 | 2.31 mi | 6 |
| Ardenwood Elementary School | public | TK,KG,1,2,3,4,5 | 2.33 mi | 9 |
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 2.33 mi | 9 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 137 Tamarack Dr | $1,249,000 | 4 | 3 | 1,654 | PendingDoNotShow |
| 4290 Tiburon Dr | $1,698,000 | 3 | 2/1 | 1,988 | Active |
| 38419 Acacia St | $1,598,000 | 4 | 2/1 | 1,884 | Active |
| 221 Dutra Vernaci Dr. | $1,399,900 | 4 | 2/1 | 2,000 | Active |
| 38042 Miller Pl | $1,398,000 | 3 | 2 | 1,389 | 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 02, 2026. For the most current information, please contact Aimee Ran Song, (510) 990-9999.