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

$4,088,000

Available Now!

1290 Curtner Rd, Fremont, CA 94539

1290 Curtner Rd, Fremont, CA 94539

8 beds  |  6 and 1/2 baths   |  6,094 sqft  |  $671 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

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

TWO HOMES ON ONE LOT!! ONE OF A KIND! A BEAUTIFUL AND YOUNG ESTATE IN THE CENTER OF THE 'MISSION' AREA! Sprawling Single Story Grande Estate! Approx 5100 square feet on one level with 6 unique and spacious suites and 5 full baths and one 1/2 bath. FEATURING A SECOND HOME!! A BEAUTIFUL BUNGALOW BUILT MANY YEARS AGO AND RUMORED TO BE THE ORIGINAL CURTNER HOME! HOW COOL IS THAT?! 2 BEDROOMS, 1 BATH AND HIGHLY UPGRADED. THE USES ARE ENDLESS. WHILE BUYER WOULD HAVE TO DETERMINE USES ON THEIR OWN, FAMILY EXTRA HOME, VRBO, AIR BNB, RENTAL INCOME, ESCAPE FROM THE REST OF THE FAMILY, AND I'M SURE MANY MORE IDEAS. THE QUALITY BUILT INTO THIS CUSTOM ESTATE IS NOT MEASURABLE IN WORDS, AND, EVEN THE PICTURES DON'T SHOW WHAT YOUR OWN EYES WILL WITNESS WHEN THEY VIEW THIS RARE AND EXQUISITE ESTATE. THIS FORMAT ONLY HOLDS 40 PICS. PLEASE SEE MEDIA LINKS IN THIS LISTING FOR 77 PICTURES AND VIDEOS AND MATTERPORT

Details

  • Alameda County
  • Detached
  • 8 Bedrooms
  • 6 and 1/2 Bathrooms
  • 1 Story
  • Built in 2012
  • 6,094 SqFt
  • 0.67 Acres
  • Style: Ranch
  • Pool, None
  • Construction: Existing
  • Exterior: Dual Pane Windows, Stucco
  • Foundation: Crawl Space
  • Roof: Tile
  • Hardwood Floors
  • Cooling: Ceiling Fan(s), Central 2 Or 2+ Zones A/C
  • Heat: Forced Air 2 Zns or More
  • Fireplace(s): Family Room, Master Bedroom
  • Sewer System - Public, Water - Public
  • Garage Door Opener, Security Alarm - Owned, Water Heater Gas, Window Coverings
  • Site Description: 2 Houses / 1 Lot, Irregular, Level, Premium Lot
  • View: Hills
  • Back Yard, Fenced, Front Yard, Garden/Play, Patio, Side Yard
  • Attached Garage, Int Access From Garage, Off Street Parking, Security, Side Yard Access, Guest Parking, Parking Area

$4,088,000

Available Now! -

MLS ID# 40846313

For more info contact

Photo Heidi Johnson
(877) 565-2010

Get more info or schedule a showing

        

Question or comment

No spam. No pressure.

PMZ Sign
http://www.scenicoaks.com
Old Republic
American Home Shield
 
 
Photo Heidi Johnson
(877) 565-2010

Get more info or schedule a showing
     

Question or comment

12:32
MLS#: 40846313
Listing Office: eXp Realty of California
Co-Listing Office: Reside Real Estate
Listing Agent: Rick Geha
Co-Listing Agent: Lorenzo Gueco
Last Updated: 12/01/2018 3:02am
Information obtained from Bay East Association of Realtors.
Information provided by seller/other sources, not verified by broker.
All interested persons should independently verify accuracy of all information.
eho
Property Views: 12
Days on Market: 32

Our Service Providers

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

We Have 27 Locations to Serve You

 
Ceres Don Pedro Escalon Fremont Gustine Hilmar
Ione Jackson Jamestown Lockeford 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