Larry D. Smith, CRS, SRES Broker Associate
Phone: 925.216.1613
Office: 925.447.9000
Cell: 925.216.1613
Fax: 925.443.1904
License #: 00494661
1841 Fourth Street suite E
Livermore, CA 94550



461 Revere Ter, FREMONT, CA 94539

Property Information
  • MLS: 40788304
  • Type: Single Family (Detached)
  • Bedrooms: 5
  • Bathrooms: 4 Full,1 Partial
  • Interior: 4,632
  • Lot Size: 1.1
  • Share/Save/Bookmark
  • Calculator
  • Schedule Showing
  • Save as Favorite
One of the kind magnificent Mission executive home on top of a tranquil cul-de-sac hill. 4632sqf living space located on over one acre lot. 5 bedrooms +office / library. Custom built in 1998, and beautifully renovated in 2014 with over $350k upgrades. Prestigious Porcelanosa brand special ordered gourmet kitchen with all Sub-zero Wolf appliances. Gorgeous crystal chandeliers special ordered from overseas. Wet bar. Glamorous walk-in closets with all custom built-in shelves and racks. Park-like front and back yards with flowers blooming and birds singing. Enjoy BBQing with family and friends on the patio, take a brief walk along the trails in the natural at your own garden, watching kids climbing and laughing in your own playground, and even have a swing at your own mini golf court and many more. No HOA. Excellent schools: Mission San Jose Elementary (API: 995); Hopkins Junior High (API: 986); Mission San Jose High (API: 951).
  • MLS: 40788304
  • Type: Single Family (Detached)
  • Listed: 7/7/2017
  • Schools: GS Dist: Fremont (510) 657-2350
  • Year Built: 1998
  • Garage: Attached Garage
  • Bath Non-Mstr Include
    • Shower Over Tub
    • Stall Shower
    • Updated Baths
  • Flooring
    • Hardwood Floors
    • Wall to Wall Carpeting
  • Level - Upper
    • 3 Baths
    • 4 Bedrooms
  • Water/Sewer
    • Sewer System - Public
    • Water - Public
  • General Features
    • Cooling: Central 2 Or 2+ Zones A/C
    • EXTERIOR: Stucco
    • Foundation: Crawl Space
    • Garage (Y/N): Yes
    • Garage Spaces: 3
    • Garage/Parking: Attached Garage
    • HEATING: Forced Air 2 Zns or More
    • Laundry: In Laundry Room
    • LOT DESCRIPTION: Cul-De-Sac
    • Pool (Y/N): No
    • Pool: None
    • Roof: Tile
    • STYLE: Contemporary
  • Bath-Master Includes
    • Stall Shower
    • Tub
    • Updated Baths
  • Kitchen Features
    • Dishwasher
    • Gas Range/Cooktop
    • Island
  • Room - Additional
    • Dining Area
    • Family Room
    • Formal Dining Room
    • Library
    • Office
  • Fireplaces
    • 3
    • Family Room
    • Living Room
    • Master Bedroom
  • Level - Street
    • 1 Bedroom
    • 1.5 Baths
  • Views
    • Hills
    • Panoramic
  • Yard Description
    • Back Yard
    • Front Yard
    • Garden/Play
    • Patio
    • Side Yard

Courtesy of Mei Mei, Cal MBA Realty

 Recently Viewed Homes


LP: $3,199,950
FREMONT,94539
 Comparable Homes For Sale


LP: $2,895,000
FREMONT,94539

LP: $3,550,000
FREMONT,94539

LP: $2,895,000
FREMONT,94539
 Comparable Homes Sold


SP: $2,900,000
LP: $3,100,000
FREMONT,94539

SP: $2,800,000
LP: $2,888,000
FREMONT,94539

SP: $3,000,000
LP: $2,988,000
FREMONT,94539