Sign In or Sign Up!
PMZ.com Real Estate
close

$3,850,000

Available Now!

1290 Curtner RD, Fremont, CA 94539

1290 Curtner RD, Fremont, CA 94539

8 beds  |  6 and 1/2 baths   |  5,144 sqft  |  $748 per sq. ft.

Photo
Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo

Add to Saved Folder Add to Saved folder

Add to Rejected Folder Add to Rejected folder

Print Flyer Print a flyer

Share this property:

Share this property via email Email to a friend

Monthly Payment Calculator
Year:
Interest Rate*:
Down Payment:
Monthly Payment: Loading...
 

Get Pre-approved

*Calculations for comparison purposes only. Total does not factor property taxes or insurance.

Description

Welcome to this gorgeous, one-of-kind estate with two homes on an expansive 29, 000 square foot lot, main house built in 2012. This amazing home sits on a quiet street with little traffic and creates feelings of peace and serenity, especially when coupled with the soothing sounds of water flowing in the nearby seasonal creek. Luxury is your first impression as you enter through the front gate and encounter beautiful lighting, numerous fruit trees, manicured landscaping and extensive artistic pavers. The ideal separate guest home that completes this large lot offers excellent opportunities for generating income or hosting guests. While the prime commuter location provides easy access to Highways 880, 680, BART, major transportation hubs, shopping and amenities, you can get easily get away from it all in nearby Mission Peak Regional Preserve. Located within the attendance area of highly rated Fremont schools. Don't miss this amazing opportunity!

Details

  • Alameda County
  • Single Family Home
  • 8 Bedrooms
  • 6 and 1/2 Bathrooms
  • 1 Story
  • Built in 2012
  • 5,144 SqFt
  • 29232 Acres
  • Style: Custom
  • Foundation: Concrete Slab, Crawl Space
  • Roof: Composition, Concrete, Shingle, Tile
  • Floor: Hardwood
  • Cooling: Ceiling Fan, Central AC, Multi-Zone
  • Heat: Central Forced Air
  • Fireplace(s): Family Room, Master Bedroom
  • Water: Public
  • Sewer - Public
  • Public Utilities, Solar Panels - Owned
  • Skylight, Solar Power
  • High Ceiling , Security Gate, Skylight, Walk-in Closet , Wet Bar
  • View: Hills, Neighborhood
  • Outdoor Features: Balcony / Patio, BBQ Area, Sprinklers - Auto
  • Attached Garage, Gate / Door Opener, Off-Street Parking, Parking Area

$3,850,000

Available Now! -

MLS ID# ML81731456

Listing Provided by

Photo
Lorenzo Gueco
Reside Real Estate


Hosted by PMZ Real Estate

(877) 565-2010

Get more info or schedule a showing

        

Question or comment

No spam. No pressure.

PMZ Sign
https://www.scenicoaks.com
Old Republic
American Home Shield
 
 
Photo
Lorenzo Gueco
Reside Real Estate


Hosted by PMZ Real Estate

(877) 565-2010

Get more info or schedule a showing
     

Question or comment

39:0
MLS#: ML81731456
Listing Office: Reside Real Estate
Co-Listing Office: eXp Realty of California Inc.
Listing Agent: Lorenzo Gueco
Co-Listing Agent: Rick Geha
© 2019 MLSListings Inc. All rights reserved..
The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than PMZ Real Estate are marked with the Internet Data Exchange icon and detailed information about them includes the names of the listing brokers and listing agents.
Information provided by seller/other sources, not verified by broker.
All interested persons should independently verify accuracy of all information.
eho
Property Views: 39

Our Service Providers

 
  • ScenicOaks Funding
  • PMZ Commercial
  • PMZ Agricultural
  • American Home Shield
  • Old Republic Home Protection
  • Leading Real Estate Companies of the World
  • Valley NHD

We Have 26 Locations to Serve You

 
Ceres Don Pedro Escalon Fremont Gustine Hilmar
Ione Jackson Jamestown Lodi - North Lodi - South Manteca
Merced Los Banos Modesto - Orangeburg Modesto - Carpenter Modesto - Scenic Dr Newman
Oakdale Pleasanton Ripon Sonora Stockton Tracy
Turlock - Fulkerth Turlock - Geer Customer Care