Sign up to get new listings emailed daily! JOIN SIGN IN
Simone Viola, DRE#01918073, REALTOR®
(805) 459-6808

34907 Limestone Ct, Union City, CA 94587

$1,560,000
  • 34907 Limestone Ct, Union City, CA 94587 Main Photo

45 Total Photos [Click to View All]

Active
BEDS4 BATHS2 full 1 partial SQUARE FEET2,146 MLS#41135729
STATUSActive PROPERTY TYPEResidential - Single Family SUBDIVISIONUNION CITY

Listing Courtesy of: Coldwell Banker Realty
Agency Phone: 510-608-7600
Associate Name: Aimee Ran Song
IDX logo


Listing Shown by: Farrell Smyth, Inc.
Associate Name: Simone Viola, DRE#01918073, REALTOR®


Property Description

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.

34907 Limestone Ct | MLS# 41135729

This single family home located at 34907 Limestone Ct, Union City, CA 94587 is currently listed for sale with an asking price of $1,560,000. This property was built in 2000 and has 4 bedrooms and 2 full and 1 partial baths with 2146 sq. ft. Limestone Ct is located in the UNION CITY subdivision. Search UNION CITY real estate on simoneviola.farrellsmyth.com today.

Property Features

Property Type: Residential - Single Family
Cooling: Central Air
Garage: 2 car attached
Heating: Forced Air
Home Style: Contemporary
Lot Size: 0.14 Acres
Roof Type: Tile
Stories: 2.0
Year Built: 2000

Amenities

Breakfast Area

Feature Descriptions

Accessibility: None
Appliances: Gas Water Heater
Days on Site: 8
Exterior: Brick, Stucco
Fireplace: Family Room, Gas
Flooring: Carpet, Laminate, Tile
Lot: Back Yard, Front Yard, Street Level, Yard
Parcel#: 8718104
Parking: Garage, Garage Door Opener
Parking Notes: Garage, Garage Door Opener
Patio/Porch: Patio

Listed By / Shown By

Listed By

Agency Name: Coldwell Banker Realty
Agent Name: Aimee Ran Song
Agency Phone: 510-608-7600

agent picture

Shown By

Agent Name: Simone Viola, DRE#01918073, REALTOR®
Agent Phone: (805) 459-6808
Agency Title: Farrell Smyth, Inc.

IDX logo

Estimate Your Payment

Estimated Payment

$ 3,926.88 per month $3,471.88 Principal & Interest $0.00 Property Tax (data not provided by mls) $455.00 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/04/2026. The listing information on this page last changed on 06/04/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 06/04/2026 12:00:20 AM EST) or CRMLS (last updated Wed 06/03/2026 11:49:32 PM EST). Real estate listings held by brokerage firms other than Farrell Smyth, Inc. may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel