There's Absolutely No Comparison!

Ranked in the top 1% percent of 1.2 million agents in the United States! Uniquely connected to the highest net worth clients in the world!

The Joe Schembri Team is recognized as one of the TOP 100 Teams for Coldwell Banker Real Estate Nationwide out of 1,400 teams!

We will not rest until your home is sold for the highest price!

   Over 3,100 homes sold YTD!!!

Coldwell Banker is the Largest Real Estate Firm in the Bay Area!

Recently named the #1 Team for Coldwell Banker Real Estate Company for the San Francisco Bay Area Region in 2008-2017 & 2018 YTD. 

  • Significant web partnerships with ColdwellBanker.com, CaliforniaMoves.com, Realtor.com, Zillow.com plus distribution to over 300 additional real estate websites.
  • Maximum exposure of your home through a network of over 3000 Realtors in Northern California.
  • Relocation division which showcases your home to active buyers moving to Northern California.
  • Customized property marketing plan including YouTube videos, Craigslist ads, just listed announcements, professionally designed brochures plus much more.
  • Recently named the Number One Team for Coldwell Banker Real Estate Company for the San Francisco Bay Area in 2008-2017.
  • Ranked the #1 Coldwell Banker real estate team for the San Francisco Bay region for 2008 and 2009 with over 80 listings sold in 2009.
  • Coldwell Banker’s #1 real estate agent of the entire East Bay for 2003-2013 & 2017 YTD.
  • Recently named the #1 Residential real estate agent for the entire East Bay for 2006 and 2007 by the East Bay Business Times
  • Named #1 of NRT's Top 100 Team's 2009-2016!
  • No other agent has sold more homes in Fremont, Newark, and Union City combined in the Tri-City Marketplace and the East Bay than Joe Schembri!
  • Ranked #105 for all of California and #10 for the San Francisco-Oakland-Hayward Metro Area(Bay Area) by transaction as one of Real Trends Best Real Estate Agents in America for 2013
  • Ranked #137 by Volume & #108 by Sides for all of California Teams as one of Real Trends Best Real Estate Teams in America for 2014
agent photo
Joe Schembri
3340 Walnut Ave, Suite 110
Fremont, CA 94538
Phone: 510 608-7667
Cell: 510-774-4328
Email: joe@joeschembri.com
CalBRE # 00890599
 
Bedrooms
Baths
Min Price
Max Price
Back to Saved Search
Listing 2 out of 4
$2,588,000 Pending

901 Owhanee Ct
Fremont, CA 94539

4 beds, 3 full, 1 partial baths | Single Family Home
3,506 sq ft; lot: 21344 sq ft - MLS# 40824073 Courtesy of Coldwell Banker Res. Broker, Joe Schembri
Property Photo
1/40

Description

Magnificent Mission Hills views surround this custom residence. Located on a approx. half acre premium lot in one of the most prestigious neighborhoods in Fremont, this Italian villa is the perfect home - sophisticated, warm and comfortable. The home features many designer details throughout including large custom picture view windows to the North and East. Floor plan includes formal living room, dining room w/ vaulted ceilings, custom kitchen that opens to the family room with a fabulously designed fireplace and a built-in entertainment center with surround sound and projector. One bedroom w/ full bath plus a separate office downstairs. Upstairs, 3 more bedrooms including the master suite, a loft/library, and 2 more full baths. Outside amenities include pebble tec pool, detached pool house w/kitchen and bath plus outside shower, travertine paver walkways, patio areas, a spectacular covered patio for entertainment and a sport court. Located in the Weibel elemen. school attendance area.

Features

  • Property Type: Single Family Home
  • Sub Type: Detached
  • Listing Status: Pending
  • County/Area: Alameda County
  • Zip Code: 94539
  • Year Built: 1985
  • Age: 33
  • Subdivision/Neighborhood: Mission Foothill
  • Sq.Ft.: 3,506 sq ft
  • Style: Custom, Mediterranean, Spanish
  • Stories: Two Story
  • Total Rooms: 9
  • Bedrooms: 4
  • Full Baths: 3
  • Half Baths: 1
  • Garage: Attached Garage, Garage Parking, Workshop In Garage, Parking Area, Yes, 3-Car
  • Fireplace: Family Room, Stone, Woodburning, 1
  • Lot Size: 21344 sq ft
  • Baths: 3.5 baths
  • Pool or Spa: In Ground, Solar Heat, Spa, Yes
  • View: Hills, Mountains, Pasture
  • Bath Non-Mstr Include: Stall Shower, Tile, Tub, Other
  • Bath-Master Includes: Skylight, Stall Shower, Other
  • Builder/Architect: Custom
  • Construction Status: Existing
  • Cooling: Ceiling Fan(S), Central 1 Zone A/C
  • Elementary School Distric: Fremont (510) 657-2350
  • Equipment Additional: Central Vacuum, Garage Door Opener, Intercom, Security Alarm - Owned, Stereo Speakers Built-In, Water Heater Gas, Window Coverings
  • Exterior: Dual Pane Windows, Stucco
  • Flooring: Hardwood Floors, Hardwood Flrs Throughout, Tile, Other
  • Foundation: Crawl Space
  • Heating: Forced Air 1 Zone, Gas
  • Kitchen Features: Breakfast Bar, Breakfast Nook, Counter - Solid Surface, Counter - Stone, Dishwasher, Eat In Kitchen, Garbage Disposal, Gas Range/Cooktop, Grill Built-In, Ice Maker Hookup, Island, Microwave, Oven Built-In, Pantry, Range/Oven Built-In, Refrigerator, Self-Cleaning Oven, Skylight(S), Updated Kitchen
  • Laundry: 220 Volt Outlet, In Laundry Room
  • Level - Street: 1 Bedroom, 1 Bath, Laundry Facility, Other, Main Entry
  • Level - Upper: 3 Bedrooms, 2 Baths, Master Bedrm Suite - 1, Loft
  • Lot Description: Court, Cul-De-Sac, Premium Lot, Secluded, Up Slope
  • Lot Sq Ft Apx: 21292
  • Model: Beautiful
  • Roof: Tile
  • Room - Additional: Den, Dining Area, Family Room, Formal Dining Room, Guest House, In-Law Quarters, Kitchen/Family Combo, Library, Media, Music Room, Office, Study
  • Water/Sewer: Sewer System - Public, Water - Public
  • Yard Description: Back Yard, Deck(S), Fenced, Front Yard, Garden/Play, Patio, Patio Covered, Side Yard, Sprinklers Automatic, Sprinklers Back, Sprinklers Front, Sprinklers Side, Terraced Back, Terraced Up, Other
Courtesy of Coldwell Banker Res. Broker, Joe Schembri

There's Absolutely No Comparison!

Ranked in the top 1% percent of 1.2 million agents in the United States! Uniquely connected to the highest net worth clients in the world!

The Joe Schembri Team is recognized as one of the TOP 100 Teams for Coldwell Banker Real Estate Nationwide out of 1,400 teams!

We will not rest until your home is sold for the highest price!

   Over 3,100 homes sold YTD!!!

Coldwell Banker is the Largest Real Estate Firm in the Bay Area!

Recently named the #1 Team for Coldwell Banker Real Estate Company for the San Francisco Bay Area Region in 2008-2017 & 2018 YTD. 

  • Significant web partnerships with ColdwellBanker.com, CaliforniaMoves.com, Realtor.com, Zillow.com plus distribution to over 300 additional real estate websites.
  • Maximum exposure of your home through a network of over 3000 Realtors in Northern California.
  • Relocation division which showcases your home to active buyers moving to Northern California.
  • Customized property marketing plan including YouTube videos, Craigslist ads, just listed announcements, professionally designed brochures plus much more.
  • Recently named the Number One Team for Coldwell Banker Real Estate Company for the San Francisco Bay Area in 2008-2017.
  • Ranked the #1 Coldwell Banker real estate team for the San Francisco Bay region for 2008 and 2009 with over 80 listings sold in 2009.
  • Coldwell Banker’s #1 real estate agent of the entire East Bay for 2003-2013 & 2017 YTD.
  • Recently named the #1 Residential real estate agent for the entire East Bay for 2006 and 2007 by the East Bay Business Times
  • Named #1 of NRT's Top 100 Team's 2009-2016!
  • No other agent has sold more homes in Fremont, Newark, and Union City combined in the Tri-City Marketplace and the East Bay than Joe Schembri!
  • Ranked #105 for all of California and #10 for the San Francisco-Oakland-Hayward Metro Area(Bay Area) by transaction as one of Real Trends Best Real Estate Agents in America for 2013
  • Ranked #137 by Volume & #108 by Sides for all of California Teams as one of Real Trends Best Real Estate Teams in America for 2014