34907 Limestone Ct CT, Union City, CA 94587 (MLS # 41135729)

View Virtual Tour

Price	$1,560,000
Status	Active
Beds	4
Baths	2.5 Baths
Home size	2,146 sqft
Lot Size	5,977 sqft
Days on Market	1

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.

Property Type(s): Single Family

Last Updated	5/26/2026	Tract	UNION CITY
Year Built	2000	Garage Spaces	2.0
County	Alameda

Additional Details

AIR	Central Air
AIR CONDITIONING	Yes
APPLIANCES	Gas Water Heater
CONSTRUCTION	Brick, Stucco
FIREPLACE	Yes
GARAGE	Attached Garage, Yes
HEAT	Forced Air
LOT	5976 sq ft
LOT DESCRIPTION	Back Yard, Front Yard
LOT DIMENSIONS	5975
PARKING	Attached, Garage, Garage Door Opener
POOL DESCRIPTION	None
STORIES	2
STYLE	Contemporary
SUBDIVISION	UNION CITY

Location

Contact us about this Property

First Name
Last Name
Phone Number
Email Address
Schedule a Showing?	/
Comments


We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for Stovall Team to contact you even if your name is on a Federal or State "Do not call List".

Listed with Coldwell Banker Realty

The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing. All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional.

Based on information from California Regional Multiple Listing Service, Inc. as of 5/26/26 4:16 PM PDT and /or other sources. 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

This IDX solution is (c) Diverse Solutions 2026.