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 Home Page
Sold for $1,300,000 Sold

38820 Buckboard Cmn
Fremont, CA 94536

4 beds, 3 baths | Single Family Home
1,527 sq ft; lot: 4356 sq ft - MLS# 40826154
Property Photo
1/40

Sold

Sold for $1,300,000 on Jul 7, 2018

Description

Meticulously upgraded home in the much sought-after Orchards development. Behind the beautifully designed pillars, iron side fencing, paver stones, and seven-foot stucco walls with a cedar entry gate, there is a 4 bedroom/3 baths one of a kind home. This magnificently landscaped residence has a private, secure courtyard with a water fountain, an outdoor kitchen, well lighted arbor covered dining area, additional counter high seating, an in-ground heated pool & oversize spa on an oversized lot. There's a second arbor covered seating area with a large gas fireplace and a putting green to allow you to improve your golf game. This two-story home has a full bedroom and bath downstairs (for in-laws or an office) with a French door & sidelight window that open to the lovely courtyard with a bubbling fountain. 3 more bedrooms and 2 baths upstairs, including the spacious master suite. Walking distance to BART and only 3 miles from 680 and 880. Excellent public schools, shops&restaurants.

Features

  • Age: 30
  • Bath Non-Mstr Include: Shower Over Tub, Tile, Updated Baths
  • Bath-Master Includes: Shower Over Tub, Tile, Tub, Updated Baths
  • Baths: 3
  • Bedrooms: 4
  • Construction Status: Existing
  • County/Area: Alameda County
  • Elementary School Distric: Fremont (510) 657-2350
  • Equipment Additional: Garage Door Opener, Mirrored Closet Door(S), Water Heater Gas
  • Exterior: Stucco
  • Fireplace: Living Room, Woodburning, Other, 1
  • Flooring: Concrete Slab, Tile, Wall To Wall Carpeting, Other
  • Foundation: Slab
  • Full Baths: 3
  • Garage: Attached Garage, Yes, 2-Car
  • Heating: Forced Air 1 Zone
  • High School: Fremont (510) 657-2350
  • HOA: Yes
  • HOA Amenities: Pool, Other
  • HOA Fee: 85
  • HOA Fees Freq: Monthly
  • HOA Fees Include: Common Area Maint, Management Fee
  • HOA Name: Orchards HOA
  • Kitchen Features: 220 Volt Outlet, Breakfast Bar, Breakfast Nook, Counter - Stone, Dishwasher, Eat In Kitchen, Garbage
  • Laundry: In Garage
  • Level - Street: 1 Bedroom, 1 Bath, Laundry Facility, No Steps To Entry, Main Entry
  • Level - Upper: 3 Bedrooms, 2 Baths, Master Bedrm Suite - 1
  • Listing Status: Pending
  • Lot Size: 0.1000
  • Lot Sq Ft Apx: 4283
  • Pool: Gas Heat, Gunite, In Ground, Pool Sweep, Yes
  • Pool or Spa: Gas Heat, Gunite, In Ground, Pool Sweep, Yes
  • Property Type: Single Family Home
  • Roof: Tile, Other
  • Room - Additional: Dining Area, Family Room
  • Sq.Ft.: 1527
  • Stories: Two Story
  • Style: Contemporary
  • Sub Type: Detached
  • Subdivision: Orchard
  • Subdivision/Neighborhood: Orchard
  • Total Rooms: 7
  • Water/Sewer: Sewer System - Public, Water - Public
  • Yard Description: Back Yard, Patio, Side Yard
  • Year Built: 1988
  • Zip Code: 94536

Video

http://wixal.com/property/38820-buckboard-cmn/

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
Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu