$3,458,000 120 Lima Terrace Fremont, CA

MLS: 40785566   Type: Single Family   County: Alameda   City: Fremont   Neighborhood: Mission Area   Zip: 94539   Style: Contemporary   # Rooms: 12    Stories: 2

Mortgage $16,235 /mo



Half Baths

Sqr Footage









MOTIVATED SELLER!! Price Lowered $130,0000!!! You MUST see this one-of-a-kind Magnificent Custom Home in Perfect Condition with Every Upgrade AND, it's located within easy walking distance to Mission San Jose High School!!!!! Included in its 4,369sf are 4 Master Suites (one downstairs) plus another 2.5 Baths. Top-grade maple hardwood, marble and high-end carpet used throughout. Spacious kitchen with Granite Counters and Center Island, S/S appliances, eating Nook and many special features too numerous to mention! Gorgeous Family Room with Gas Fireplace and Study/Office attached. Many extra rooms for buyer's needs! Beautiful Landscaping with Japanese Garden- Views - Minutes to Everything including the new BART station! DON'T MISS SEEING THIS HOME!

Elementary School

Middle School

High School

Click Here
Distance: N/A Miles
Click Here
Distance: N/A Miles
Click Here
Distance: N/A Miles

Price History

6/14/2017 Listed $3,588,000
12/12/2017 4% - $3,458,000

Age 19
Branded Virtual Tour http://tour.circlepix.com/home/86EWSX/120-Lima-Terrace-Fremont-CA
Construction Status Existing
Disabled Features None
Elementary School District Fremont (510) 657-2350
Energy Saving Feature Caulked/Sealed, Ceiling Insulation, Insulation - Per Owner, Low Flow Shower, Low Flow Toilet, Thermostat Controller, Walls Insulated, Weather Stripped Door(s), Weather Stripping
Listing Area Fremont
Listing Status Active
Pets Allowed - Yes
School District Fremont (510) 657-2350
Status Active
Stories Two Story
Style Contemporary
Subdivision Y/N MISSION AREA
Unbranded Virtual Tour http://tour.circlepix.com/home2/86EWSX/120-Lima-Terrace-Fremont-CA
Zoning SFR

Interior Features

# of Fireplaces Family Room, Gas Burning, Gas Starter, Raised Hearth, Stone
Additional Room Attic - Finished, Bonus/Plus Room, Den, Formal Dining Room, Kitchen/Family Combo, Music Room, Storage, Study, Other
Bath Include Shower Over Tub, Solid Surface, Stall Shower, Updated Baths, Other
Cooling Central 2 Or 2+ Zones A/C
Fireplace(s) 1
Flooring Hardwood Floors, Stone (Marble, Slate etc., Wall to Wall Carpeting
Half Baths 1
Heating Forced Air 2 Zns or More, Gas
Kitchen Features 220 Volt Outlet, Breakfast Bar, Breakfast Nook, Counter - Stone, Dishwasher, Double Oven, Eat In Kitchen, Garbage Disposal, Gas Range/Cooktop, Ice Maker Hookup, Island, Microwave, Oven Built-in, Pantry
Laundry 220 Volt Outlet, Dryer, Gas Dryer Hookup, In Laundry Room, Washer
Master Bath Includes Solid Surface, Stall Shower, Sunken Tub, Tub with Jets, Updated Baths, Other
Street Level 2 Baths, Master Bedrm Suite - 1, Laundry Facility, Other, Main Entry
Total Rooms 12
Upper Level 3 Bedrooms, 0.5 Bath, 4 Baths, Master Bedrm Suites - 2, Master Bedrm Retreat, Loft, Other

Exterior Features

# of Garage Spaces 3
Building Type Detached
Exterior Dual Pane Windows, Stucco
Foundation Crawl Space
Garage Attached Garage, Int Access From Garage, Other
Garage Yes
Lot Description Court, Cul-De-Sac, Irregular, Up Slope
Lot Size Area 0.42
Lot Sq Ft Apx 18225
Pool None
Roof Tile
View Bay, City Lights, Greenbelt, Hills, Valley, Other
Water/Sewer Sewer System - Public, Water - Public
Yard Description Back Yard, Fenced, Patio, Sprinklers Automatic, Sprinklers Back, Sprinklers Front, Sprinklers Side, Terraced Back, Terraced Up

Property Schools

Direct Link:


Gallery (22 photos)

Ask Your Agent a Question

Property vs Zip Code Avg (94539)

Price 3.45M Avg 2.66M

Sqr Feet 4,369 Avg 3,780

Cost / Sqr Ft $791 Avg $706

Acres 0.42 Avg 1.16

Visits 67 Avg 43

Days on Site 279 Avg 100

Ask How to Finance this Property

Download Our Mobile App

Download Millions Mapped

Listing Provided Courtesy Of: Betsy Yamasaki with Yamasaki Real Estate Srvcs.

Back to Search

Chat is Now Online! Ask Away!

In the Neighborhood

Find Your Home's Value Instantly

Saved Properties

This is a list of your favorite properties. We will email you if a property is reduced or leaves the market.

Click 'Save' to add a property to this list.

Register / Login

New & returning visitors please enter your information to login.

By clicking 'register' you are agreeing to our terms of use & giving us expressed written consent to contact you.

Questions? Comments? Complaints?

This message will go directly to the head of our team.

Location & Address

Kevin Kieffer
Offices throughout the East Bay!
Top 1% in Bay Area,

Other Locations