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 10 out of 177
$2,590,000 New For Sale

860 Longfellow Dr
Fremont, CA 94539

4 beds, 3 baths | Single Family Home
3,088 sq ft; lot: 6970 sq ft - MLS# 40849642 Courtesy of Top Mission Realty & Invest, Linda Young
Property Photo
1/37

Description

View! View! View! ~ This exceptional two-story home has breathtaking views, beautiful floorplan, plus many wonderful features. Located in a highly desirable, nationally recognized and award-winning school district. ~ Built in 1989 ~ Offers 4 bedrooms &3 bathrooms, which includes first floor bedroom and full bathroom ~ Attached 2 car garage ~ Approx. 3,088sq ft of living space and approx. 7,150sq ft lot ~ No rear neighbors, lots of privacy ~ Backyard has spectacular, uninterrupted views of the city, East Bay hills, and surrounding area ~ Luxurious Master Bedroom Suite with relaxing retreat ~ Bonus Room on second floor is spacious, can be easily converted to additional bedroom ~ Updated Gourmet Chef's Kitchen ~ First floor has hardwood floor, and second floor features wall-to-wall carpet ~ Extra high ceilings, dual pane windows, recessed lighting ~ Pristine condition ~ Don't wait! Own this home today and enjoy the luxury, comfort and phenomenal sights!

Features

  • Property Type: Single Family Home
  • Sub Type: Detached
  • Listing Status: Active
  • County/Area: Alameda County
  • Zip Code: 94539
  • Year Built: 1989
  • Age: 30
  • Subdivision/Neighborhood: Mission Area
  • High School: Fremont (510) 657-2350
  • Sq.Ft.: 3,088 sq ft
  • Style: Contemporary
  • Stories: Two Story
  • Total Rooms: 10
  • Bedrooms: 4
  • Full Baths: 3
  • Garage: 2-Car
  • Fireplace: Den, Family Room, Gas Starter, Woodburning, 1
  • Lot Size: 6970 sq ft
  • Baths: 3
  • View: Bay, Hills, Panoramic
  • Bath Non-Mstr Include: Shower Over Tub, Solid Surface, Tile, Updated Baths
  • Bath-Master Includes: Solid Surface, Split Bath, Stall Shower, Sunken Tub, Tile, Updated Baths
  • Builder/Architect: Ponderosa
  • Construction Status: Existing
  • Cooling: Central 1 Zone A/C
  • Elementary School Distric: Fremont Union
  • Equipment Additional: Garage Door Opener, Mirrored Closet Door(S), Window Coverings, Other
  • Exterior: Dual Pane Windows, Stucco
  • Flooring: Hardwood Flrs Throughout, Stone (Marble, Slate Etc., Tile, Wall To Wall Carpeting, Other
  • Foundation: Crawl Space
  • Garage/Parking: Attached Garage, Side Yard Access
  • HOA: Yes
  • HOA Fee: 70
  • HOA Fees Freq: Monthly
  • HOA Fees Include: Common Area Maint, Management Fee, Other
  • Heating: Forced Air 1 Zone
  • Kitchen Features: Breakfast Nook, Counter - Solid Surface, Counter - Stone, Dishwasher, Double Oven, Eat In Kitchen, Garbage Disposal, Gas Range/Cooktop, Island, Oven Built-In, Refrigerator, Updated Kitchen, Other
  • Laundry: In Laundry Room
  • Level - Street: 1 Bedroom, 1 Bath, Laundry Facility, Other, Main Entry
  • Level - Upper: 3 Bedrooms, 2 Baths, Master Bedrm Suite - 1, Other
  • Lot Description: Premium Lot
  • Lot Sq Ft Apx: 7150
  • Model: Gorgeous
  • Roof: Tile
  • Room - Additional: Bonus/Plus Room, Family Room, Formal Dining Room
  • Water/Sewer: Sewer System - Public, Water - Public
  • Yard Description: Back Yard, Fenced, Front Yard, Patio, Side Yard, Sprinklers Automatic
Courtesy of Top Mission Realty & Invest, Linda Young

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