Refine Search
Sort by
131 J St, Fremont
$1,200,000
2 Beds ⋅ BE41057837 MLS
Prime location in the Niles historic downtown, a vibrant area with quaint shops, restaurants, a local supermarket, a weekly farmers market, and Town Plaza! This unique property offers 3 units and a mixed use of residential, commercial and office. On the ground level, there is a retail space of approx. 1,220 sq ft currently used as a beauty salon. The beauty salon has its own bathroom plus 118 sq ft storage space. Upstairs, there is a 2 bedroom 2 bathroom apartment of approx. 1,283 sq ft plus a separate 2-car garage. The third unit is an office space of approx. 295 sq ft which is currently rented out of the tenant of the beauty salon. All three units are currently rented. The property has a 2-car garage with a private driveway. Excellent location with great foot traffic and visibility. The property's strategic positioning near the BART station, 84/Dumbarton Bridge, and 880 (through Niles Canyon) ensures a hassle-free commute to San Francisco, Silicon Valley, and the Facebook and Google Headquarters. Don't miss this opportunity!

131 J St, Fremont

Listed by Joe Schembri, (510) 608-7667 from Coldwell Banker Realty
(If provided) CoList: from

Sold listing courtesy of Joe Schembri from SCCB02

37076 2nd, Fremont
$1,960,000
3 Beds ⋅ 2 Baths ⋅ BE41058235 MLS
Welcome to this meticulously maintained, updated residence boasting newer electrical and plumbing systems. Experience luxury in the master bath featuring radiant heat flooring and a temperature-controlled shower. This home is fortified with earthquake retrofitting and adorned with hardwood floors, complemented by fresh interior and exterior paint and a newer tile roof.Enhanced with smart technology including a Nest thermostat, smoke detectors/CO2 sensors, and OWNED SOLAR along with a Tesla Charger, this home exemplifies modern living. Entertain effortlessly in the expansive backyard, complete with an outdoor kitchen equipped with a refrigerator, BBQ, and hot water sink, as well as an outdoor movie theater. Cultivate your own garden oasis with over 13 varieties of fruit trees and garden beds managed by a Racchio system, ensuring a perpetual farmers market experience. Located near the esteemed Niles Elementary school, parks, Alameda Creek trails, and within walking distance to downtown Niles, renowned for its vibrant array of shops and restaurants, this home offers unparalleled convenience.

37076 2nd, Fremont

Listed by Pamela Gyi, (510) 825-0896 from Redfin
(If provided) CoList: from

Sold listing courtesy of Prerana Saraiya from SHGM15

394 L St, Fremont
$1,600,000
6 Beds ⋅ BE41054953 MLS
DO NOT DISTURB TENANTS! Not your usual Duplex! Live in one home or rent them both out in this Iconic Niles neighborhood in a quiet court location with minimal vehicle traffic. All just mere steps from the Alameda Creek off leash Trail all the way to the bay and an ez stroll to the Shinn Pond Dog Park https://dogtrekker.com/directories/shinn-pond/ as well as the pioneering annual Niles Dog Show https://nilesdogshow.org/ with a short stroll from the historic Niles Downtown, the gateway to 23 weekend events https://www.niles.org/ and featuring the films made in Niles -- the Hollywood of 1915 https://nilesfilmmuseum.org/. Feels like two separate detached homes each with a 2-car garage increasing the income potential! Private yard with big master bedrooms and closets! One home could work as a 4 bedroom or 3 bedroom with a den. Front home has a relaxing koi pond Back home has a balcony with beautiful Mission Peak views.

394 L St, Fremont

Listed by Bill Can!trell, (510) 468-7376 from RealQuest Properties
(If provided) CoList: Krystina Cantrell from

Sold listing courtesy of Lannie Mok from

37947 Essanay Pl, Fremont
$1,116,000
3 Beds ⋅ 3 Baths ⋅ BE41055321 MLS
Step into this delightful, two-story single-family duet-style abode nestled in the picturesque Niles area. Tucked away on a tranquil cul-de-sac, this home has a prime location with no through traffic. Inside, discover a stunning open floor plan with soaring ceilings, a chef's dream kitchen featuring Quartz countertops, modernized cabinets, and sleek stainless-steel appliances. Entertain with ease as the dining area seamlessly transitions into a bright sunroom, ideal for entertaining. Throughout the home, recessed lighting illuminates every corner, complemented by smart switches in the living room and master bedroom. The downstairs powder room boasts a new vanity and mirror. Retreat to the spacious master suite, offering breathtaking views of the scenic Mission Hills. Enjoy the low-maintenance yard complete with a deck, perfect for summer barbecues. The attached two-car garage features a recently replaced LiftMaster door. Conveniently located just minutes away from Fremont Bart, Fremont Hub, and major freeways.Take a leisurely stroll to the Historic Niles area, where great restaurants, a vibrant farmers market, and entertainment await. Additional upgrades HVAC system, dual-pane window. NO HOA!! Don't miss the OH on April 13th and 14th!

37947 Essanay Pl, Fremont

Listed by Moni Shah, (510) 364-9446 from Real Estate Center
(If provided) CoList: from

Sold listing courtesy of Roby Thomas from SGGL01

38128 Canyon Oaks Ct, Fremont
$2,120,000
5 Beds ⋅ 3 Baths ⋅ BE41054110 MLS
Positively Marvelous! Nestled perfectly in the sought-after Fremont Niles neighborhood, this beautiful residence boasts bright and flowing floor plan and inviting layout with excellent location and convenient commuting to Silicon Valley major tech companies. Built in 1991, this incredible home has approx. 2,763 Sq. Ft. of living space and approx. 5,610 Sq. Ft. of premium lot ~ Offers 5 bedrooms, 3 bathrooms and attached 2 car garage ~ Stunning living room and fantastic family room showcase vaulted ceiling, hardwood floors, plantation shutters, large windows with abundant natural light excellent for any occasion ~ Numerous good features including convenient downstairs bedroom suite, lavish master bedroom suite, gourmet chef's kitchen, vaulted ceiling in all bedrooms, large loft, double pane windows and hardwood flooring throughout and low-maintenance & delightful backyard perfect for entertaining and relaxing ~ Meticulous and move-in ready condition ~ Don't wait! This wonderful home could be yours today!

38128 Canyon Oaks Ct, Fremont

Listed by Linda Young, (510) 673-8811 from Top Mission Realty & Invest
(If provided) CoList: from

Sold listing courtesy of Satheesh Allam from CALH

37900 2nd Street, Fremont
$1,358,000
3 Beds ⋅ 2 Baths ⋅ BE41051930 MLS
Charming smart home awaits you on the cutest street in desirable Niles! This fully updated, low maintenance, move-in ready home awaits you and yours! Laminate floors, chic molding, and recessed lighting throughout the open floorplan transitions into the gourmet kitchen featuring quartz counters, central island gas cooking, and stainless-steel appliances. Owned Tesla solar (NEM 2.0) with Tesla Power Wall will save you hundreds per month in energy costs! Spend little effort and money maintaining a landscape ideal for play and entertaining. Walk to the block's end to access miles of hiking trails along Alameda Creek or walk the other direction to enjoy all the restaurants, shopping, and entertainment that historic Niles has to offer! This easy living home will raise your quality of life!

37900 2nd Street, Fremont

Listed by Timothy Fletcher, (253) 370-5748 from KW Advisors
(If provided) CoList: from

Sold listing courtesy of Kashmir Shahi from SKSS01

35181 Mount Whitney Terrace, Fremont
$2,300,000
4 Beds ⋅ 3 Baths ⋅ BE41051798 MLS
An absolute stunner in the highly sought after Niles Station Community! The moment you walk into this Northeast facing home you'll be met with high ceilings and an abundance of natural light. The home features owned solar, a bedroom and a full bathroom downstairs, an updated gourmet kitchen, a custom oversized island, wine fridge, stainless steel appliances, a built-in desk and ceiling speakers. The spacious kitchen flows right into the manicured backyard featuring a fire pit, an avocado tree and plenty of space to garden. Sit back, relax and enjoy sunsets next to the fire pit, or host your summer barbecues and festivities! Upstairs you'll find three more bedrooms, with an updated guest bathroom. The master bedroom suite boasts a walk-in closet, a modern bathroom with a custom rain shower with tile from floor to ceiling. New paint, door hardware and recessed lighting throughout the home. The home is conveniently located near the desirable Niles Elementary, BART, Downtown Niles, Quarry Lakes, Shopping Plazas, Restaurants and is a short distance from the 84/680/880 freeways. Don't miss your opportunity to own this gorgeous home!

35181 Mount Whitney Terrace, Fremont

Listed by Francis Ricafort, (510) 593-7111 from Legacy Real Estate & Assoc.
(If provided) CoList: Willa Ricafort from Legacy Real Estate & Assoc.

Sold listing courtesy of Suman Mirchandani from

311 Sandstone Dr, Fremont
$1,550,000
4 Beds ⋅ 3 Baths ⋅ BE41045046 MLS
Beautiful upgraded home in the highly desirable Niles area. 4 bedrooms, 2 ½ bathrooms, 1789 sq ft of living space, spacious bright open floor plan, hardwood floors throughout downstairs. High ceilings, recessed lights, double-paned windows, ceiling fans. Owned solar panels plus a backup battery as a bonus. Separate living room and family rooms, formal dining room and eat-in kitchen, upgraded bathrooms. The master bedroom has a walk-in closet. 4-year-old roof and two-sided fireplace. Low maintenance large front and backyards, with lots of fruit trees, ideal for family friend get-togethers. No HOA. This home is in a great location with a neighborhood park down the street. It's close to BART and has easy access to freeways 680, 880, and Dumbarton Bridge and is in the award-winning Niles Elementary area. This is a must-see.

311 Sandstone Dr, Fremont

Listed by Kurshed Deen, (510) 468-6658 from Legacy Real Estate & Assoc.
(If provided) CoList: from

Sold listing courtesy of Kurshed Deen from SMMX01

37510 3Rd St, Fremont
$1,275,875
4 Beds ⋅ 2 Baths ⋅ BE41043702 MLS
PLEASE DO NOT DISTURB TENANTS OF 37510 3RD ST! ONLY THE HOUSE ON 260 G ST CAN BE SHOWN AT THIS TIME. Rare opportunity to own two single family homes on a prime corner lot of 8,100 sq ft in the highly desired downtown Historic Niles District. The first home located at 37510 3rd St is a charming 2 bedroom 1 bathroom home full of character, offering approx. 642 sq ft plus a large basement. The second home located at 260 G St is a nicely maintained 2 bedrooms and 1 bathroom home of approx. 729 sq ft with a custom remodeled kitchen, updated flooring, recessed lighting, updated windows and an updated bathroom. This is not a 4 bedroom 2 bathroom home, but 2 separate homes of 2 bed 1 bath each situated on the same lot. The lot is a street-to-street lot. The house on G St is newer and has a one car garage. The house on 3rd St is older and doesn't have a garage. Both homes have nicely landscaped yards. This property is just blocks to Niles downtown with restaurants, quaint shops, the Silent Film Museum, a local supermarket, a weekly farmers market, and Town Plaza. The proximity of BART station and highways 84/Dumbarton Bridge and 880 (through Niles Canyon) makes the commute to either San Francisco or Silicon Valley, Facebook and Google Headquarters very convenient.

37510 3Rd St, Fremont

Listed by Joe Schembri, (510) 608-7667 from Coldwell Banker Realty
(If provided) CoList: from

Sold listing courtesy of Louis Heystek from SHGM06

35241 Black Mesa Ter, Fremont
$1,898,000
5 Beds ⋅ 3 Baths ⋅ BE41039204 MLS
Spacious and stunning 5 bed/3 baths 2400 sq ft. featuring high ceilings with natural lights that welcomes you into a formal living room next to it is a Big family room with eat in kitchen. an upgraded chef kitchen with gorgeous countertops and tile backsplash, and stainless appliances, with a farm sink, with a beautiful island. Luxury vinyl planks throughout the house. Upgraded master bathroom with new cabinets. shower stall and a tub, dual sink vanities and a walk in closet. Upgraded Hall bathroom with beautiful tiles with tub and double vanities Recessed lights throughout, copper plumping. Full bedroom with upgraded bathroom with Shower Stall downstairs, a bonus room upstairs. Nearby Bart station, HWY 84,880 and 680

35241 Black Mesa Ter, Fremont

Listed by Saba Nazar, (510) 938-1925 from Compass
(If provided) CoList: from

Sold listing courtesy of Nusrat Khan from CCNUTKHN

37348 Niles, Fremont
$1,700,000
BE41018526 MLS
Rare one of a kind Niles commercial property with 2 stores a single family home and beautiful Spanish style villa. Lots of options for this Iconic Niles property. A large courtyard area can be used for many things during all of Niles special events or this could be a very nice patio for your Spanish style home or business, many people say they would like to see a restaurant here. Two other former studio apartments are currently being used as storage but could be rehabbed and livable in a short time. Lots of options for income with some updating, main buildings could be divided in 2 or sub leased for antiques sales or even a work and live type of set up. Options are only limited to your creativity. Sellers are in process of clearing everything out.

37348 Niles, Fremont

Listed by Antone Koep, (510) 384-1883 from I.R.E.B., UGB Properties
(If provided) CoList: from

Sold listing courtesy of Simone Mccarthy from NAWAR

board logoThe data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than Real Estate Company are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents.
Based on information from MLSListings MLS as of . All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.


Copyright 2026 MLSListings Inc. All rights reserved