Features & Amenities

Interior

  • Total Bedrooms

    3

  • Bathrooms

    3

  • 1/2 Bathrooms

    1

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Forced Air

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Stucco

  • Parking

    Attached, Garage

  • Patio and Porch Features

    Patio

  • Pool

    No

Area & Lot

  • Lot Features

    Back Yard, Corner Lot, Front Yard

  • Lot Size(acres)

    0.2522

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Ranch

Price

  • Sales Price

    $2,299,000

  • Sq. Footage

    2, 055

  • Price/SqFt

    $1,118

HOA

  • Association

    YES

  • Association Fee

    $43

  • Association Fee Frequency

    Monthly

  • Association Fee Includes

    N/A

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • Stories

    1

  • Association Amenities

    Playground

  • Sewer

    Public Sewer

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

Alameda

Elementary School

Middle School

High School

Listing Courtesy of Lester Belliveau , Coldwell Banker Realty

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent LinaMirza

FOUNDER

LinaMirza

Call Lina today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
Nestled in the highly desirable Glenmoor neighborhood, this stunning home offers the ideal blend of location, space and modern upgrades around every corner! This single-story home has a masterfully designed open floor plan that features a picturesque living room with serene yard views, a gourmet kitchen and an expansive dining area. You’ll love the quality details throughout–a concrete tile roof, LVP flooring, remodeled bathrooms, central A/C, copper plumbing and Milgard windows. The gorgeously remodeled kitchen has a storage-rich island, granite counters, shaker cabinets, pantry and stainless steel appliances including a built-in gas stove. Offering rare flexibility, the home includes two spacious primary suites with ample closet space. Step into a backyard built for entertaining, including manicured landscaping, an outdoor kitchen with fire-finished granite counters plus two large sheds with electrical. This sizable lot has RV side access, space for a potential ADU or expansion. This one-of-a-kind home is in an excellent location, close to Meyer Park playground, rec courts and pool. Perfect for commuters, nearby 880, Dumbarton Bridge, BART & Centerville Station. Walking distance to great schools, shopping & local eateries. Don’t miss your chance to call this Glenmoor gem yours!

38048 Glenmoor Dr

Message successfully sent.

What would you like to know?

Related Properties

New on site 1 day ago
Welcome to this inviting and expanded, two story home that offers a balanced blend of comfort and functionality. Featuring tasteful updates that provide a move-in feel, leaving room for your personal touches. Meticulously maintained home tucked away in the highly desirable Northgate community of Fremont sought for it's top rated schools. Tiled entry to a large living room with lots of natural light, fireplace with stone facade. The huge family room offers so much space with another fireplace and sliding glass door to the rear yard. An amazing kitchen with ample wood cabinetry, Corian countertops, pots & pan drawer, 2 lazy Susan's, a decorative ledge above the cabinetry for your favorite collectables and under counter lighting. A generous sized breakfast bar for homework or company while cooking. Dining area enhanced with a decorative wainscoting. Large primary suite with 2 separate closets, large updated bathroom. 2 good sized bedrooms with spacious closets. Dual pane windows, Huge rear yard with patio, gazebo and a planter bed that surrounds the rear yard. Front features drought tolerant colorful landscaping. Near Northgate park, Almada Creek Trail, Quarry Lakes, shopping and dining too! Ideal for commuters with access to 880, 84, and Bart. Open Houses 2-4PM Sat & Sun 8-9 & 8-10
#41106391

Fremont

3291 Trafalgar Road

3 Beds

2 Baths

2,423 Sq.Ft.

$2,399,000

MLS#: 41106391

New on site 4 days ago
Spacious home.  4 large bedrooms that can fit king size beds.  Vaulted ceiling. Ceiling fans and mirrored closet doors in every bedroom. Lots of cabinet and closet space.  Central Air and Heat. Spacious Kitchen with Breakfast Bar.   Fireplace w/ Mantel and Marble Surface; Spacious Backyard.  Tile Floors in Up Stair Bathroom; Close to Fremont HUB & BART, Golf course and Lake Elizabeith.  Easy access to freeways.
#41106817

Fremont

111 Overacker Ter

4 Beds

2 Baths

2,149 Sq.Ft.

$1,899,888

MLS#: 41106817

New on site 4 days ago
Location, location, location! Highly desirable single-story home in one of Fremont’s most sought-after neighborhoods. Situated on a tree-lined street close to Mission Valley Elementary, this North-facing home was recently updated throughout. The open floor plan offers a formal front living room, a dining room and a separate family room. A permitted sunroom opens up to the private backyard pool with 100% owned solar heating. The remodeled kitchen offers oak wood cabinetry, granite slab counters and full backsplash, and updated appliances. Additional features include remodeled bathrooms, hardwood flooring, new interior paint, recessed lighting, updated dual paned white vinyl windows, sun tunnels, and solid oak 4-panel interior doors. Enjoy modern comfort with upgraded AC and furnace system, built-in vacuum system and copper plumbing. The garage has a roll-up garage door with windows. Beautifully landscaped low-maintenance front & back yards. Front yard with slate stone walkways, custom retaining walls and artificial low maintenance lawn. Large backyard patio surrounding the pool & detached office. Close to Lake Elizabeth Central Park. Walking distance to tech company shuttle bus stops. Top-ranked public schools include Mission Valley Elem, Hopkins Jr High and Mission San Jose High.
#41099288

Fremont

41519 Apricot Ln

3 Beds

2 Baths

1,758 Sq.Ft.

$2,388,000

MLS#: 41099288

Northeast facing, gorgeous hill views, top-rated schools with some of the highest test scores in all of Fremont, prime neighborhood, and beautifully renovated with almost everything brand new! Located in one of the most desirable Fremont neighborhoods (Warm Springs), this home offers a spacious, open-concept layout on a large fully usable lot, featuring a bedroom and full bath downstairs. Upstairs, it features a spacious primary suite, 2 additional bedrooms, and 2 full baths. Enjoy a light-filled living room and a separate family room with a fireplace and a glass sliding door to the backyard, enhancing the home with natural light. The heart of the home, a fully renovated kitchen, is ready for culinary adventures with new cabinets, quartz countertops, and stainless steel appliances, including a gas stove. Bathrooms have undergone renovations, featuring new vanity sets, updated light fixtures, and a renovated shower/tub! Outside, the property features updated landscaping in both front and backyard, creating a serene outdoor space for relaxation and gatherings. Other wonderful features include central heating and A/C, a well-maintained roof, dual-pane windows, new interior & exterior paint, new light fixtures, new flooring, and much more! Come check it out!
#41106716

Fremont

47267 Yucatan Dr

4 Beds

3 Baths

1,784 Sq.Ft.

$2,198,000

MLS#: 41106716

This Is the One You’ve Been Waiting for In the Quail Run Community! Beautifully Maintained Home Features Formal Living Room with Vaulted Ceilings & Stunning Mountain Views, Spacious Formal Dining Room Perfect for Gatherings. The Chef’s Kitchen Offers Custom Cabinetry, Granite Countertops, Designer Tile Backsplash, Island with Seating, 6 Burner Gas Stove, Double Oven, Walk-in Pantry & Built-in Coffee/Wine Bar ideal for Entertaining & Everyday Luxury. Family Room Includes Recessed Lighting, Fireplace Insert, Surround Sound & Sliding Door Opens to a Permitted-200 sq ft Sunroom. Primary Suite Includes Double Closets & Luxurious Bath with Dual Vanities, Soaking Tub, Stall Shower & Heated Floors. Additional Bedroom Functions as a Home Office with Custom Cabinetry & Built-in Desk. Bonus Room Offers Flexible Space, Perfect For 4th Bedroom, Movie Room/Play Area. Enjoy Low-Maintenance Backyard with~600 sq ft Trex Deck & 8x10 Storage Shed. Additional Boast: Owned Solar, Bamboo Hardwood Floors Throughout, Milgard Windows, Murano Glass Light Fixtures, Custom Window Coverings, Tesla EV Charger, Tankless Water Heater, Dual-Zone HVAC, 3-Car Garage. Community Amenities Include Pool/Tennis Courts/Clubhouse/Playground. Conveniently Located Near Top-Rated Schools & Commuter Routes 880 & 84. Come See
#41106496

Fremont

33499 Quail Run Rd

4 Beds

2 Baths

2,760 Sq.Ft.

$2,750,000

MLS#: 41106496

Located in the Lakes neighborhood of North Fremont, the property offers easy access to transportation routes like the Dumbarton Bridge and I-880, as well as nearby amenities including the Facebook campus, Ardenwood Historical Farms, and various shopping and dining options. The home features an upgraded tiles/granite flooring, crown molding, LED lights in all bedrooms. Both electric and gas appliances in kitchen and garage. Additional features includes gate in the front yard for privacy, and garage equipped for EV charger installed. Built in 1992, the home has 4 bedrooms and 3 bathrooms with 2,163 square feet of living space on a 4,777 square foot lot.  In summary, this property offers a blend of comfort, amenities, and a prime location within a desirable Fremont neighborhood, making it an appealing prospect for discerning buyers.
#41106526

Fremont

33228 Jamie Cir

4 Beds

2 Baths

2,163 Sq.Ft.

$1,999,500

MLS#: 41106526

***Fully Remodeled | Luxury Smart Home | A Must See!*** Fully Remodeled: State-of-the-art Engineered Wood Floors Throughout, Top-of-the-class Gourmet Kitchen Boasting Designer Cabinets With Pullout Drawers, A Large Pantry, High-grade Quartz Countertops,  Award-winning Thermador Appliances, High-end Glass Railing, Custom Bathroom Cabinets, Designer Tiles, Recessed Lights Throughout, Upgraded 2-Car Garage With Built-in Storage ***Smart Home With All-new Features: Wireless Blinds, Smart Switches, Ring Cameras, Energy-Efficiency Split-level HVAC System, Solar Panels, Tesla Power Wall, Water Softener, Ecobee Thermostat ***Other Killer Attractions: Corner Lot on a Cul-De-Sac, Steps Away From Kids Play Area, Basketball Ball Court, Large Backyard With Potential for an ADU, Spacious Suite With Full-bath on The First Floor Great For Elderly Parents ***Natural Light Throughout ***Located Within Well-sought-after Warm Springs and Irvington School Zones ***Close to Top-rated Employers Such as Tesla, Meta, Nvidia and Other Silicon Valley Giants  ***Breathtaking Views of Mission Hills From Every Corner of Home ***Proximity to i-680, i880, 237, Warm Springs BART, and Parks.  ***Come and See It and Act FAST!!! Open house—Today 4th Aug, 5pm to 7pm Offers due 5th August @ 8PM
#41106473

Fremont

524 Gamay Ct

5 Beds

3 Baths

2,416 Sq.Ft.

$1,998,000

MLS#: 41106473

***Charming Fremont Classic in Prime Cul-de-Sac—First Time on Market Since 1972!*** Welcome to 3526 Surry Place, a beloved family home making its debut on the market for the very first time since 1972. Impeccably maintained by its original owner, this timeless 2-story residence offers 2,340 sq. ft. of versatile living space, nestled in a quiet cul-de-sac in one of Fremont’s most desirable neighborhoods.  With 4 bedrooms and 2.5 baths, this home features a spacious layout, including formal living and dining rooms, a cozy family room, and the potential to add a downstairs bedroom or create a luxurious second master suite upstairs—ideal for multi-generational living.  Step outside to a generous backyard with room to dream. Once home to a sparkling swimming pool, this space invites your vision: revive the pool, build a modern ADU, or craft your own private oasis.  Enjoy unbeatable location perks: walk to Quarry Lakes, top-rated elementary, middle, and high schools, and benefit from quick access to shopping, BART, and major commuter routes.  This is more than a house—it’s a rare opportunity to own a piece of Fremont history and shape it into your future.  Don’t miss your chance to make 3526 Surry Place your forever home.
#41106586

Fremont

3526 Surry Pl

4 Beds

2 Baths

2,340 Sq.Ft.

$1,999,888

MLS#: 41106586

This completely renovated single-family home is located in the highly sought-after Brookvale neighborhood and falls within the American High School attendance area. The home features five bedrooms and three full bathrooms, including a convenient bedroom and full bath on the main level. Fresh paint, solid-surface flooring, recessed lighting, and all-new windows create a bright, modern, and energy-efficient living space. Renovated kitchen includes quartz countertops, stainless steel appliances, and a professional six-burner gas stove. Every bathroom has been renovated with high-end finishes, and the spacious primary suite offers a soaking tub, separate shower, and walk-in closet. With abundant natural light and an indoor laundry room, this home is both stylish and functional — truly move-in ready.
#41106346

Fremont

3304 Kemper Rd

5 Beds

3 Baths

2,368 Sq.Ft.

$2,289,000

MLS#: 41106346

 - property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to receive some additional information on this specific property or similar properties?

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here