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-2018 & 2019 YTD. 

  • Significant web partnerships with ColdwellBanker.com, CaliforniaMoves.com, Realtor.com, Zillow.com plus distribution to over 900 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.
  • Named the Number One Team for Coldwell Banker Real Estate Company for the San Francisco Bay Area in 2008-2018.
  • 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 8 out of 177
Sold for $1,530,000 Sold

40424 La Jolla Ct
Fremont, CA 94539

4 beds, 2 baths | Single Family Home
1,899 sq ft; lot: 6098 sq ft lot - MLS# 40849702 Courtesy of Coldwell Banker Res. Broker, Jeff Pereyda
Property Photo

Sold

Sold for $1,530,000 on Feb 15, 2019

Description

Thousands in upgrades to this four bedroom, two bath beauty, make this a must see. It has newly re-surfaced original hardwood floors, new tile entry, new master bathroom, new shared bathroom and newly textured ceilings and walls throughout the entire home. All old insulation was vacuumed out of attic and replaced with new insulation. It has dual pane windows and a high-efficiency furnace and air-conditioning to make it all just right. What's more, an exclusive walkway connects your La Jolla home directly to Gomes Elementary, Hopkins Junior High and Mission San Jose High School. This walkway also allows you to walk or stroll without the use of streets to Fremont Park Golf and Lake Elizabeth--just blocks away. The kitchen's original cabinets are in place. They are durable oak, that can last for quite some time longer until you may feel it's time for a change, and place your signature on this Mission home when you are ready.

Features

  • Property Type: Single Family Home
  • Sub Type: Detached
  • Listing Status: Sold
  • Listing Price: $1,499,995
  • County/Area: Alameda County
  • Zip Code: 94539
  • Year Built: 1966
  • Age: 53
  • Subdivision/Neighborhood: Mission Area
  • Sq.Ft.: 1,899 sq ft
  • Style: Ranch
  • Stories: One Story
  • Total Rooms: 8
  • Bedrooms: 4
  • Full Baths: 2
  • Garage: 2-Car
  • Fireplace: Brick, Family Room, 1
  • Lot Size: 6098 sq ft lot
  • Baths: 2
  • Bath Non-Mstr Include: Shower Over Tub, Solid Surface, Tile, Updated Baths
  • Bath-Master Includes: Stall Shower, Tile
  • Construction Status: Existing
  • Cooling: Central 1 Zone A/C
  • Equipment Additional: Dryer, Washer
  • Exterior: Wood Siding, Brick Veneer
  • Flooring: Wood
  • Foundation: Crawl Space, Raised
  • Garage/Parking: Attached Garage
  • Heating: Forced Air 1 Zone
  • Kitchen Features: 220 Volt Outlet, Counter - Solid Surface, Dishwasher, Electric Range/Cooktop, Garbage Disposal, Microwave, Refrigerator
  • Laundry: 220 Volt Outlet, Dryer, In Laundry Room, Washer
  • Level - Street: 4 Bedrooms, 2 Baths
  • Lot Description: Court
  • Lot Sq Ft Apx: 6200
  • Pets: Allowed - Yes
  • Roof: Tile
  • Room - Additional: Dining Area
  • Unit Feature: Levels In Unit - 1
  • Water/Sewer: Sewer System - Public, Water - Public
  • Yard Description: Back Yard, Fenced, Front Yard, Patio Covered
  • Sold Price: 1530000
  • Sold Date: 2019-02-15
Courtesy of Coldwell Banker Res. Broker, Jeff Pereyda

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-2018 & 2019 YTD. 

  • Significant web partnerships with ColdwellBanker.com, CaliforniaMoves.com, Realtor.com, Zillow.com plus distribution to over 900 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.
  • Named the Number One Team for Coldwell Banker Real Estate Company for the San Francisco Bay Area in 2008-2018.
  • 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