34905 Limestone Ct

Discover the epitome of modern comfort in this lovingly cared-for home, offered for the first time ever on the market. 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.

Current Status

Active - Coming Soon

Original Price

$1,490,000

List Price

$1,490,000

On Market Date

May 22, 2026

Property Type

Detached

D/N/S

Union City

Zip Code

94587

MLS ID

41135730

APN

8718103

Year Built

1999

Stories in Building

2

Possession

Close Of Escrow

Data Source

MAXEBRDI

Origin MLS System

BAY EAST

Bed

4

Bath

2.5 (2/1)

Parking

2

Attached, Int Access From Garage, Garage Faces Front, Garage Door Opener

SQ FT

2,008

SQ FT Source

Public Records

Lot SQ FT

4,102.0

Lot Acres

0.09 Acres

Pool Info

None

Kitchen

Dishwasher, Gas Range, Microwave, Free-Standing Range, Gas Water Heater, Counter - Solid Surface, Gas Range/Cooktop, Kitchen Island, Range/Oven Free Standing, Updated Kitchen

Cooling

Central Air

Disclosures

Nat Hazard Disclosure, Disclosure Package Avail

Entry Level

Exterior Details

Back Yard, Front Yard, Side Yard

Flooring

Laminate, Tile, Carpet

Foundation

Fire Place

Family Room, Gas

Heating

Forced Air

Laundry

220 Volt Outlet, Gas Dryer Hookup, Hookups Only, Laundry Room, Upper Level

Upper Level

4 Bedrooms, Primary Bedrm Suite - 1, Laundry Facility

Main Level

0.5 Bath, Main Entry

Possession

Close Of Escrow

Architectural Style

Contemporary

Non-Master Bathroom Includes

Shower Over Tub, Updated Baths, Double Vanity

Construction Status

Existing

Additional Miscellaneous Features

Back Yard, Front Yard, Side Yard

Location

Level, Back Yard

Roof

Tile

Water and Sewer

Public

Fee

Unavailable

MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.

School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.