For sale Home

Listed Nov 1, 2026

$1,175,000 Est. $7,772/mo

6649 Mayhews Landing Road

  • 2

    Beds

  • 2

    Baths

  • 1,167

    Sq ft

The story

A remarkable 960 sq. ft. detached shop/garage takes center stage in this one-of-a-kind property, offering exceptional flexibility for a workshop, home office, studio, gym, entertaining space, or additional family area, with potential for future conversion to separate living space or an ADU, subject to buyer verification. Paired with an authentic Craftsman home featuring 2 bedrooms and 1.5 baths, this unique property beautifully blends timeless character with thoughtful modern updates. Filled with warmth and personality, the home features an inviting oversized family room surrounded by updated windows that flood the space with natural light. Built-in cabinetry provides style and function, showcasing a dedicated office nook, bookshelves, and ample storage. High-end features include crown molding and hardwood flooring. The updated kitchen features beautiful concrete countertops, a breakfast bar with pendant lighting, a vintage 1935 Wedgewood four-burner gas stove in working condition, a Fisher & Paykel double-drawer dishwasher, and a built-in oven and microwave. The adjacent dining area provides a comfortable space for everyday meals and larger gatherings. The spacious primary bedroom offers cedar-lined built-in closets and French doors opening directly to the peaceful backyard. The versatile laundry room serves double duty as an entertaining space, easily converting to a bar with extensive cabinetry, a wet bar sink, and backyard access. Outside, discover a private garden oasis featuring a built-in spa surrounded by mature shrubs. Landscaped grounds include 10 mature fruit trees, raised garden beds, lush greenery, and a garden shed. A huge composite deck expands the outdoor living space with a natural gas fire table, gas hookup for your grill, and an exterior half-bathroom, ideal for entertaining, relaxing, and enjoying the tranquil surroundings. A cobblestone paver driveway leads to a two-car carport featuring an automatic garage door, an EV charging outlet, and additional raised planter beds. Additional highlights include owned 9.6 kW solar with valuable NEM 2.0 benefits, offering long-term energy savings. This special property offers vintage charm, modern conveniences, exceptional outdoor living, and a truly remarkable detached space that opens the door to endless possibilities.

Facts & features

Home type

Home

Year built

1972

Floors

1

Price per sq ft

$1,007

Included features

  • Cooling

    Central Air

  • Heating

    Forced Air

  • Appliances

    Range, Dryer, Dishwasher, Microwave, Oven, Refrigerator, Electric Range, Free-Standing Range, Washer, Electric Water Heater

  • Flooring

    Hardwood

  • Roof

    Composition

  • Lot Information

    Rectangular Lot

  • Exterior

    Storage

  • Water Source

    Private, Public, Well

  • Sewer

    Public Sewer

Mortgage calculator

Estimated monthly payment

$7,772 /mo

7% rate · 30-yr fixed · 20% down

  • Principal & interest $6,254
  • Property tax $1,175
  • Insurance $343

Includes principal, interest, taxes & insurance.

Your Property Journey

Interested in this, or something like it?

Submit an inquiry

Drop your details and we will help you find what you are looking for.

Not quite. Help me find the right one

Talk it through or type it out, whichever feels easiest.

Your contact details

An agent will reach out personally, no automated calls.

Smart Assistant

Hi, how can I help you find your dream home?

Tap the voice button to talk, or just start typing.

Tap anywhere to fix a word or add more

Tap stop when you’re done. You can edit the text before searching.

By submitting, you agree to our Privacy Policy and Terms.

Listing Broker

Coldwell Banker Realty

Broker Name

Coldwell Banker Realty

Agent

Brooke Crossland

Location

Fremont CA 94538