Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40354557

Price: $2,350,000 - 5 bdrm 4.5 baths
Type: Single Family Home
Sqft: 4800
Cost / Sq Ft: $490

City: FREMONT, 94539
Subdiv: MISSION ESTATES

Remarks: Excellent Schools-Gomes Elementary School, Hopkins Middle,& Mission San Jose High School! Quality build by Robson Homes. Beautiful Hillside home w/4 car garage, secluded cul-de-sac location, has stunning views of Lake Elizabeth & the San Francisco Bay.

Details...
Listor: INTERO REAL ESTATE SERVICES
Listing Agent: GISSLER, MARKdetailfilename is 403/40354557.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40381951

Price: $2,368,000 - 6 bdrm 4.5 baths
Type: Single Family Home
Sqft: 4750
Cost / Sq Ft: $499

City: FREMONT, 94539
Subdiv: AVALON HEIGHTS

Remarks: Gorgeous Semi-Custom 4750sf home on a half-acre lot. Plantation Shutters/Custom Draperies. Two Huge Master Suites, one upstairs, one down. Designer hardwood and Limestone floors. Views from backyard and upstairs rooms of City Lights, Hills, Bay. Guarded and Gated 24/7. Close to 680,880, 237.

Details...
Listor: YAMASAKI REAL ESTATE SRVCS
Listing Agent: YAMASAKI, BETSYdetailfilename is 403/40381951.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40371077

Price: $2,398,000 - 5 bdrm 4 baths
Type: Single Family Home
Sqft: 4756
Cost / Sq Ft: $504

City: FREMONT, 94539
Subdiv: MISSION SAN JOSE

Remarks: All Mission Schools,UPDATED* HM in "Sabercat Estate" Gated Community. LARGE LOT! Approx 1.5 acres. Gourmet kit Granite counter, skylight, subzero stainless steel ref. Lrg bonus upstairs, 5th rm converted to media /Study, Mbd w/Plasma TV,HTD Pool,spa & sports co

Details...
Listor: COLDWELL BANKER
Listing Agent: RAHAN, NEERUdetailfilename is 403/40371077.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40362777

Price: $2,590,000 - 3 bdrm 2.5 baths
Type: Single Family Home
Sqft: 2542
Cost / Sq Ft: $1,019

City: FREMONT, 94539
Subdiv: MISSION

Remarks: One of kind Country living rare spanish style home close to freeway 680,Schools, shopping and etc,Panaramic view of hills and bay,updated kitchen with granite counter tops, Sep.Qtr. 2 beds 1 bath 2 gar,Sec-1 & roof cleared, indoor pool!House is very clean & ready to move in, must see to appreciate!

Details...
Listor: PAUL DEOL, BROKER
Listing Agent: DEOL, PAULdetailfilename is 403/40362777.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40379164

Price: $2,700,000 - 4 bdrm 1 baths
Type: Single Family Home
Sqft: 1320
Cost / Sq Ft: $2,045

City: FREMONT, 94539
Subdiv: Other

Remarks: ONCE IN A LIFETIME OWNERSHIP OPPORTUNITY, GREAT ORIGINAL HORSE RANCH, OVER 56 ACRES, LOCATION, LOCATION, LOCATION, BARN, EASY FREEWAY ACCESS, ORIGINAL HOME, 4 BEDROOMS, 1 BATH, EXISTING CARETAKER TRAILER, CARPORT, LEVEL ACREAGE AND HILLSIDE ACREAGE, EVEN VIEWS, THIS PROPERTY IS BEING SOLD "AS IS"...

Details...
Listor: J. ROCKCLIFF, REALTORS
Listing Agent: PEIXOTO, KRISTYdetailfilename is 403/40379164.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40358980

Price: $2,988,800 - 4 bdrm 4.5 baths
Type: Single Family Home
Sqft: 6625
Cost / Sq Ft: $451

City: FREMONT, 94539
Subdiv: MISSION SAN JOSE

Remarks: PANORAMIC VIEW FROM EVERY ROOM. LUXURIOUS LIVING SPACE. TWO KITCHENS W/PROF COOKTOPS. ALL THERMADOR APPL. RECESSED LIGHTS. BRKFST NOOK. WET BAR. FORMAL DINING. GAME ROOM. LIBRARY. INSIDE ELEVATOR. WIRED 4 ALARM, AUDIO, VIDEO, CAT5 & LIGHT CONTROLS. INTERCOM. STONE PATIO. SELLER IS WILLING TO FINANCE

Details...
Listor: TIMOTHY CROFTON, INC.
Listing Agent: CROFTON, TIMOTHYdetailfilename is 403/40358980.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40376900

Price: $3,500,000 - 5 bdrm 5 baths
Type: Single Family Home
Sqft: 5662
Cost / Sq Ft: $618

City: FREMONT, 94539
Subdiv: MISSION

Remarks: GORGEOUS CUSTOM HOME! AWESOME VIEWS!! LOTS OF UPGRADES*EXCLUSIVE NEIGHBORHOOD* TOP RATED SCHOOLS*PERFECT HOME FOR ENTERTAINING*LARGE GOURMET KITCHEN*FULL WET BAR*BUILT IN BBQ*INGROUND POOL/SPA*FORMAL DINING ROOM*EXTRA LARGE FAMILY ROOM*OFFICE/LIBRARY*LOFT W/DECK UPSTAIRS*MUST SEE!

Details...
Listor: J. ROCKCLIFF, REALTORS
Listing Agent: IVALDI, DENISEdetailfilename is 403/40376900.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40358134

Price: $3,950,000 - 5 bdrm 6 baths
Type: Single Family Home
Sqft: 7566
Cost / Sq Ft: $522

City: FREMONT, 94539
Subdiv: VINEYARD HEIGHTS

Remarks: SUPER LOCATION, 360 VIEWS, CITY LIGHTS ,AND VIEW OF BRIDGES AND MOUNTAINS. GRAND ENTRY, GRANITE FLOORING, CUSTOM LIGHTING. CHERRYWOOD FLOORING THROUGHOUT. SPACIOUS FORMAL DINING AND LIVING ROOMS WITH MAGNIFICENT VIEWS. LARGE GOURMET KITCHEN WITH ALL GRANITE COUNTERS. SIX GAS BURNER THERMADOR

Details...
Listor: EXECUTIVE HOMES REALTY
Listing Agent: SABEH JR, JOSEPHdetailfilename is 403/40358134.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40360836

Price: $4,300,000 - 4 bdrm 4.5 baths
Type: Single Family Home
Sqft: 5161
Cost / Sq Ft: $833

City: FREMONT, 94539
Subdiv: MISSION

Remarks: EXECUTIVE MISSION HOME. VIEWS OF CITY, RENOVATED 2008, ENTRY, LIBRARY W/FIREPLACE, LVING RM, OFFICE, FORMAL DINING, FAMILY RM, KITCHEN W/ GRANITE, STAINLESS STEEL APPLIANCES, HARDWOOD FLOORS, NEW CARPET, PAINT, MASTERBED RM W/RETREAT VIEWS, EACH BEDRM W/OWN BATH FULLY LANDSACPED, LOTS TO SEE.

Details...
Listor: PRUDENTIAL CALIF REALTY
Listing Agent: GILL, SURINDERdetailfilename is 403/40360836.php

Updated December 4, 2008
Includes all of the listings available for display as part of the Multiple Listing Service's Internet Data Exchange Program
MLS: 40362202

Price: $4,988,000 - 6 bdrm 5.5 baths
Type: Single Family Home
Sqft: 8201
Cost / Sq Ft: $608

City: FREMONT, 94539
Subdiv: THE VALLEY

Remarks: MAGNIFICENT LOCATION; PRIVATE SECLUDED CUSTOM BUILT HOME; HOME HAS MAGNIFICENT VIEWS; MASTER BEDROOM HAS GREAT BAY VIEWS, MOUNTAIN VIEWS , PARK-LIKE BACKYARD W/ POOL AND CEMENT WATERSLIDE; NEWLY ADDED PROFESSIONAL TENNIS COURT FOR THAT WIMBELDON ITCH!!

Details...
Listor: EXECUTIVE HOMES REALTY
Listing Agent: SABEH JR, JOSEPHdetailfilename is 403/40362202.php