House
Condo
Land
County/Region:
Updating Region ...
City/Area:
Min Price:
Any
$100,000
$110,000
$120,000
$130,000
$140,000
$150,000
$160,000
$170,000
$180,000
$190,000
$200,000
$225,000
$250,000
$275,000
$300,000
$325,000
$350,000
$375,000
$400,000
$450,000
$500,000
$550,000
$600,000
$650,000
$700,000
$750,000
$800,000
$850,000
$900,000
$1,000,000
$1,500,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$10,000,000
Max Price:
Any
$100,000
$110,000
$120,000
$130,000
$140,000
$150,000
$160,000
$170,000
$180,000
$190,000
$200,000
$225,000
$250,000
$275,000
$300,000
$325,000
$350,000
$375,000
$400,000
$450,000
$500,000
$550,000
$600,000
$650,000
$700,000
$750,000
$800,000
$850,000
$900,000
$1,000,000
$1,500,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$10,000,000
Bedrooms:
Any
1
2
3
4
5
6
7
Bathrooms:
Any
1
2
3
4
5
Sq Feet:
Any
500+
1000+
1500+
2000+
2500+
3000+
3500+
4000+
4500+
5000+
5500+
6000+
6500+
7000+
45671 MONTCLAIRE TERRACE, FREMONT, CA 94539
MLS: 40472843
Type: Detached
Bedrooms: 6
Bathrooms: 5 Full,2 Partial
Interior: 6250
Lot Size: 0.360000
MAGNIFICENT CUSTOM HOME WITH PANORAMIC VIEWS LOADED WITH LUXURY UPGRADES ! ALL 3 TOP MISSION SCHOOLS !MAJESTIC ENTRY !!ONE OF A KIND HUGE FAMILY ROOM / GOURMET KITCHEN , MEDIA ROOM, HOT & STEAM SAUNA, WINE CELLAR, 15 SECURITY CAMERA SYSTEM ! OPEN SAT / SUN.
MLS: 40472843
Type: Detached
Listed: 6/21/2010
Sold Date: 10/26/2010
Schools: GS Dist: Fremont (510) 657-2350 Grade School: Mission San Jose Elementary Middle School: Hopkins (William) Junior High High School: Mission San Jose High
Year Built: 2003
Garage: Attached Garage
Fireplaces
3 Family Room Gas Starter Living Room Master Bedroom
Level - Lower
Level - Upper
3 Baths 4 Bedrooms Laundry Facility Master Bedrm Suite - 1
Views
Bay City Lights Hills Panoramic
General Features
Cooling: Central 2 Or 2+ Zones A/C Exterior: Stucco Garage (Y/N): Yes Garage Spaces: 3 Garage/Parking: Attached Garage Heating: Forced Air 2 Zns or More HOA Amenities: Other LOT DESCRIPTION: Cul-De-Sac Pool (Y/N): No Pool: None Roof: Tile STYLE: Mediterranean
Flooring
Hardwood Floors Stone (Marble, Slate etc.
Laundry
220 Volt Outlet Hookups Only In Laundry Room
Level - Street
0.5 Bath 1.5 Baths 2 Bedrooms Main Entry
Room - Additional
Family Room Formal Dining Room In-Law Quarters Library Media
Yard Description
Back Yard Front Yard Patio Side Yard Sprinklers Automatic Sprinklers Back Sprinklers Front Sprinklers Side Terraced Back
Kitchen Features
220 Volt Outlet Breakfast Bar Breakfast Nook Counter - Stone Dishwasher Double Oven Electric Range/Cooktop Garbage Disposal Gas Range/Cooktop Island Microwave Oven Built-in Pantry Refrigerator Trash Compactor Updated Kitchen Wet Bar
Water/Sewer
Sewer System - Public Water - Public
Courtesy of Rajni Gupta, RE REALTY EXPERTS
Recently Viewed Homes
SP: $2,600,000 LP: $2,999,000 FREMONT,94539 SP: $2,229,000 LP: $2,600,000 FREMONT,94539 SP: $2,350,000 LP: $2,600,000 FREMONT,94539
Comparable Homes For Sale
LP: $2,463,888 FREMONT,94539 LP: $2,288,800 FREMONT,94539
All information furnished regarding property for sale, rental, comparables or financing is from sources deemed reliable, but no warranty or representation is made as to the accuracy thereof and same is submitted subject to errors, omissions, change of price, rental or other conditions, prior sale, lease or financing or withdrawal without notice.
©2012 Bay East. ©2012 CCAR. ©2012 EBRD. All rights reserved. Information deemed reliable but not guaranteed. This information is provided from three separate sources: Bay East, CCAR and EBRD. The listings presented here may or may not be listed by the Broker/Agent operating this website. Updated on 5/20/2012