Home
click to activate map
 Grid  Map

Lakehouse.com has 18 lake properties for sale on Quarry Lakes , as well as lakefront homes, lots, land and acreage in Fremont, Union City. Median home price: $1,825,833, lot price: $1,299,000. 

339 I St

6 3.0   Sf: 3590   Yr: 1919  Acres: 0.250

Privacy, Charm, Space, AND Location Location Location! Don't miss this Very unique property with the best of everything. Tucked in where the end of I St meets Niles Community Park and part of the...

35849 Carnation WAY

4 2.0   Sf: 2161   Yr: 1988 

Welcome to this beautifully refreshed single-level home in the heart of Niles, one of Fremonts most charming and sought-after neighborhoods. Offering 4 bedrooms, 2 bathrooms, and a rare 3-car garage...

35968 Killorglin Cmn

4 2.0   Sf: 1824   Yr: 1989  Acres: 0.111

Welcome to your dream in Niles Garden community! Situated in a tranquil cul-de-sac with no front or rear neighbors and convenient guest parking right out front, this beautifully maintained residence...

357 Sunnyslope DR

3 3.0   Sf: 1320   Yr: 1989 

Situated in Fremonts sought-after Niles neighborhood, this move-in ready 3 bedroom, 2.5 bathrooms single-family home (No HOA) offers a thoughtful blend of comfort and modern living. Contemporary...

159 Quincy Terrance

4 3.0   Sf: 1690   Yr: 2025  Acres: 0.039

Welcome to this beautiful brand-new home featuring 4 spacious bedrooms and 2.5 modern bathrooms. Designed with comfort and functionality in mind, this home offers an open-concept layout filled with...

SPONSORED AD:

2921 Daisy CT

3 2.0   Sf: 1382   Yr: 1970 

Bright & beautifully, move-in ready! Stunning 3 bedrooms & 2 bathrooms single family home on a quiet cul-de-sac, with many upgrades and modern finishes throughout. Open & airy layout with beautiful...

38016 Vallejo St

3 2.0   Sf: 1035   Yr: 1953  Acres: 0.300

Charming fully remodeled Cottage on a multi unit lot in the Heart of Niles District. Welcome to this cozy, beautifully remodeled 3-bedroom, 2-bath home nestled in the desirable Niles District...

38016 Vallejo St

Acres: 0.300

Charming fully remodeled Cottage on a multi unit lot in the Heart of Niles District. Welcome to this cozy, beautifully remodeled 3-bedroom, 2-bath home nestled in the desirable Niles District...

3140 Blanco TER

3 3.0   Sf: 1652   Yr: 2019 

Welcome to 3140 Blanco Terrace an inviting Fremont home in a highly convenient 94536 location. This residence offers a comfortable, functional layout with bright living spaces and great everyday flow...

3517 Birchwood TER 204

2 2.0   Sf: 1083   Yr: 1984 

Meadow Brook is changing in fantastic ways! The latest building in the complex to be COMPLETED for stairs, patio compliance, gutters, and drainage improvements. This should give this unit an...

34749 Alvarado Niles Rd unit: 4

2 1.0   Sf: 798   Yr: 1972  Acres: 0.199

Welcome to Alvardo-Niles-- centrally located for a quick drive to the South Bay or the Tri Valley! Brand new carpet, freshly painted throughout, and well-maintained hardwood floors in the living room...

3232 Red Cedar Ter

0 1.0   Sf: 421   Yr: 1986 

Lovely, remodeled studio in the heart of central Fremont, overlooking the pool! This beautifully updated first-floor condo is nestled beside the pool in the desirable Baywood Villas community. The...

3159 Rowe Pl

5 3.0   Sf: 2710   Yr: 1972  Acres: 0.133

Welcome to the highly desirable Brookvale neighborhood. Beautifully upgraded 2710 sqft 5 BR/3 BA single family home. This home is perfect for families seeking space, privacy, & comfort . Lots of...

2655 Barrington Terrace

2 2.0   Sf: 1755   Yr: 1988  Acres: 0.093

One-time showing Saturday Feb 14th 11-12pm!!! Best-priced home in the neighborhood. 2-bedroom plus loft home with a large primary suite and 2.5 baths. The downstairs half bath was upgraded in 2022...

3402 Pinewood Ter unit: 111

2 2.0   Sf: 1125   Yr: 1986  Acres: 0.310

Discover this stunning GROUND-FLOOR end unit in the gated Meadowbrook community-featuring the neighborhood's largest floor plan and soaring 9-FOOT CEILINGS that fill the home with natural light...

3467 Pinewood Ter unit: 202

2 2.0   Sf: 1083   Yr: 1986  Acres: 0.320

LIMITED TIME OPPORTUNITY FOR INVESTORS AND FIRST TIME HOME BUYERS. Own the most affordable 2 bed, 2 bath condo in Fremont-perfect for first-time buyers or investors. This bright and spacious 1,080 sq...

3416 Deerwood Ter unit: 113

2 2.0   Sf: 990   Yr: 1986  Acres: 0.025

Priced to sell! This beautifully remodeled first-level 2-bedroom, 2-bath condo offers 980 sq ft of bright and open living space with vaulted ceilings that create an airy, spacious feel. The updated...

34806 Starling Dr unit: 3

2 1.0   Sf: 903   Yr: 1972  Acres: 0.190

Welcome to this beautifully updated 2-bedroom, 1-bath, two-story Townhouse-Style Condo offering approximately 903 sq. ft. of comfortable living space. Newer interior paint, updated kitchen and bath...