Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (1349)
    Advanced Search
Rent Sell Find an Agent
LakeHouse.com LakeHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Rent
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing LakeHouse.com logo
Share
LakeHouse.com logo
Ad #7825590
MLS #41135958
Listing photo

A rare opportunity in Parkmont awaits! A Mediterranean Oasis

3249 Greenwood Dr, Fremont, California, 94536
$2,699,000
4Beds
3Baths
2,919Sqft
0.240Acres

About this property

A rare opportunity in Parkmont awaits! A Mediterranean Oasis estate on a generously deep lot completely rebuilt from the ground up. This 2.900 SF appx estate maximized for multi-generational living, situated on a deep 10,000 SF lot features wonderful ground-level comforts. A turn-key Mediterranean main home with 1st floor guest bedroom, bathroom with walk-in shower, 1st floor versatile office with closet with oversized primary suite and additional 2 bedroom upstairs. Step across the flowering backyard patio to a detached studio ADU with bathroom, kitchen & laundry amenities. Rebuilt from the ground up in 1998-2000, this turn-key contractor's property was crafted with pride of ownership, customized for multi-generational comforts, holiday gatherings, backyard entertaining, guest cottage and potential additional ADU capabilities with additional rear storage buildings and level yard. Appreciate the attention to detail in every corner with custom finishing touches throughout. Vaulted ceilings flooded with light, elegant spiral staircase foyer, chef's kitchen with pull up seating, gas range & powerful ventilation hood and warming drawer & more! Thoughtful storage spaces, oversized bedrooms, polished marble flooring and elegant marble surrounds throughout the first floor and bathrooms and quality berber carpet at bedrooms. A Primary Suite to escape to features a spacious retreat with hollywood closet, luxurious marble bathroom, walk-in shower & soaking tub. Recent added value include a brand new west fence 6/26, new furnace & AC 2025, EV Charger, Sunrun Solar system, fresh interior paint 5/26, finished main garage with flooring and laundry area. An entertainer's backyard with slate tile hardscape, cozy cabana with matching roof & outdoor kitchen with gas grill, sink &side power burner. A few steps to the studio casita ADU provides independence for all ages & needs finished with granite counters, full kitchen, washer & dryer, wood laminate flooring, and bathroom with shower and new glass door. Conveniently located near Hwy 84, markets & shopping, a short drive to Parkmont Elementary or a short walk to Centerville MS & Washington HSpletely rebuilt from 1998-2000 with permit totaling 2,919 living SF on approved plans. ADU not included in SF. To be sold *As-Is* Sale with reports & disclosures for review. Buyer to verify SF & Permit. Built with love and gratitude, this welcoming home will continue to be a blessing to many!

Property Features

4 Beds
3 Baths
2,919 Sqft
Built in 1950
0.240 Acres
2 Stories
Quarry Lakes
View Type: Hills
Garage
Siding: Stucco
Composition Roof
Has Fireplace
Forced Air
Alameda County
Parkmont Area Community

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

James Martin

Intero Real Estate Services

510-326-6194

Location

Map
Listing Agent: James Martin 510-326-6194
Broker: Intero Real Estate Services 510-673-8473 Listing Site
Copyright © 2026 Bay East. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
LakeHouse.com
Printed Jul 16, 2026

Photo Gallery

A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 1
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 2
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 3
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 4
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 5
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 6
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 7
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 8
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 9
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 10
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 11
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 12
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 13
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 14
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 15
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 16
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 17
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 18
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 19
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 20
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 21
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 22
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 23
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 24
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 25
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 26
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 27
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 28
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 29
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 30
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 31
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 32
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 33
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 34
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 35
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 36
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 37
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 38
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 39
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 40
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 41
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 42
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 43
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 44
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 45
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 46
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 47
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 48
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 49
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 50

$2,699,000

4
Beds
3
Baths
2,919
Sqft

3249 Greenwood Dr, Fremont, California, 94536

By contacting this agent you agree to these Terms and Conditions.
Home California Quarry Lakes
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 1
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 2
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 3
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 4
A rare opportunity in Parkmont awaits! A Mediterranean Oasis - photo 5
MLS# 41135958
Home For Sale

A rare opportunity in Parkmont awaits! A Mediterranean Oasis

$2,699,000

3249 Greenwood Dr, Fremont, California, 94536

4
Beds
3
Baths
2,919
Sqft
0.240
Acres
$2,699,000
3249 Greenwood Dr, Fremont, California, 94536
4 Beds
3 Baths
2,919 Sqft
0.240 Acres
A rare opportunity in Parkmont awaits! A Mediterranean Oasis estate on a generously deep lot completely rebuilt from the ground up. This 2.900 SF appx estate maximized for multi-generational living, situated on a deep 10,000 SF lot features wonderful ground-level comforts. A turn-key Mediterranean main home with 1st floor guest bedroom, bathroom with walk-in shower, 1st floor versatile office with closet with oversized primary suite and additional 2 bedroom upstairs. Step across the flowering backyard patio to a detached studio ADU with bathroom, kitchen & laundry amenities. Rebuilt from the ground up in 1998-2000, this turn-key contractor's property was crafted with pride of ownership, customized for multi-generational comforts, holiday gatherings, backyard entertaining, guest cottage and potential additional ADU capabilities with additional rear storage buildings and level yard. Appreciate the attention to detail in every corner with custom finishing touches throughout. Vaulted ceilings flooded with light, elegant spiral staircase foyer, chef's kitchen with pull up seating, gas range & powerful ventilation hood and warming drawer & more! Thoughtful storage spaces, oversized bedrooms, polished marble flooring and elegant marble surrounds throughout the first floor and bathrooms and quality berber carpet at bedrooms. A Primary Suite to escape to features a spacious retreat with hollywood closet, luxurious marble bathroom, walk-in shower & soaking tub. Recent added value include a brand new west fence 6/26, new furnace & AC 2025, EV Charger, Sunrun Solar system, fresh interior paint 5/26, finished main garage with flooring and laundry area. An entertainer's backyard with slate tile hardscape, cozy cabana with matching roof & outdoor kitchen with gas grill, sink &side power burner. A few steps to the studio casita ADU provides independence for all ages & needs finished with granite counters, full kitchen, washer & dryer, wood laminate flooring, and bathroom with shower and new glass door. Conveniently located near Hwy 84, markets & shopping, a short drive to Parkmont Elementary or a short walk to Centerville MS & Washington HSpletely rebuilt from 1998-2000 with permit totaling 2,919 living SF on approved plans. ADU not included in SF. To be sold *As-Is* Sale with reports & disclosures for review. Buyer to verify SF & Permit. Built with love and gratitude, this welcoming home will continue to be a blessing to many!
42 days
on LakeHouse.com
50
views
0
saves

Property Details

HOME DETAILS

4 Beds
3 Baths
2,919 Sqft
Built in 1950
0.240 Acres
2 Stories

WATER & VIEW

Quarry Lakes
View Type: Hills

EXTERIOR

Garage
Siding: Stucco
Composition Roof

INTERIOR

Has Fireplace
Forced Air

FINANCIAL & COMMUNITY

Alameda County
Parkmont Area Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

About Quarry Lakes

Looking for lakefront homes for sale on Quarry Lakes ? Find waterfront real estate here. Nearby cities include Fremont and Union City, Alameda County, California. Discover the best lake front listings - properties, land, and acreage to build your dream lake house, cottage or cabin on. Search for a lake real estate agent who specializes in Quarry Lakes property to help you buy or sell a home.

Ad Statistics

Ad Number
7825590
Viewed
50 times
Listing Status
Active
Added
Jun 04, 2026
Last Refresh
Jul 16, 2026 12:04:08 PM

Listing Information

Data Source
Bay East
Source Property ID
41135958
Listing Agent: James Martin 510-326-6194
Broker: Intero Real Estate Services 510-673-8473 Listing Site
Copyright © 2026 Bay East. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on LakeHouse.com
Sell Your Home

Explore Similar Properties

No similar properties found.

SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
MountainHomes.com BeachHouse.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 LakeHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.16
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Quarry Lakes

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Quarry Lakes Real Estate Agent Info

About Quarry Lakes

Click to activate
Request Information
By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
MountainHomes.com BeachHouse.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 LakeHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.16
Terms & Policy