Traditional

337 I St

Fremont , CA 94536

MLS#: 41109682

$2,800,000

Status: Active
Listing number: 41109682
Listing provided by: Coldwell Banker Realty
Listing agent phone: None
Last update: 2 days ago
On site: 6 days ago
Browse Properties
NILES - Residential

Property

Beds

4

Full Baths

2

1/2 Baths

None

Year Built

1919

Sq.Footage

3,590

Rare opportunity to own a live & work property. 3 detached rental units on one prime corner lot of 10,780sq ft in the highly desired downtown Historic Niles District. Perfectly situated at the end of a quiet street w/ no rear neighbors & backing up to Niles Community Park, this property offers privacy, charm, & versatility. The main unit (337 I St) tucked away in the back is approx.1,850sqft & offers 3 bedrooms & 1 full bathroom. It boasts a large great room living room w/ custom doors leading out to the back patio; custom commercial kitchen w/ oversized island, professional-grade stainless steel appliances, stainless steel sink & large walk-in pantry; separate dining room w/ plantation shutters. Other highlights: upgraded dual paned windows throughout, updated luxury laminate flooring, central AC & heating, updated bathroom, oversized 2car garage, beautiful long cement aggregate driveway, large rear patio. The 2nd unit (339 I St) offers 1,060sqft, 2 bedrooms 1 bathroom, w/ family room & living room. The 3rd unit (337 I St) offers 680sqft, 1 bedroom, 1 bathroom w/ living room. Beautiful curb appeal w/ white picket fence. This property is just blocks to Niles downtown w/ restaurants, quaint shops, the Silent Film Museum, a local supermarket, a weekly farmers market, & Town Plaza.

Features & Amenities

Interior

  • Total Bedrooms

    4

  • Bathrooms

    2

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Fireplace YN

    NO

  • Heating YN

    YES

  • Heating

    Forced Air

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Wood Siding

  • Parking

    Attached, Garage, Garage Door Opener

  • Patio and Porch Features

    Patio

  • Pool

    Yes

  • Pool Features

    None

Area & Lot

  • Lot Features

    Back Yard, Front Yard

  • Lot Size(acres)

    0.2475

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Traditional

Price

  • Sales Price

    $2,800,000

  • Sq. Footage

    3, 590

  • Price/SqFt

    $779

HOA

  • Association

    NO

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • Stories

    1

  • 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 Joe Schembri , 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.

(818) 321-0175

Lina@theosrealty.com


* 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.
Rare opportunity to own a live & work property. 3 detached rental units on one prime corner lot of 10,780sq ft in the highly desired downtown Historic Niles District. Perfectly situated at the end of a quiet street w/ no rear neighbors & backing up to Niles Community Park, this property offers privacy, charm, & versatility. The main unit (337 I St) tucked away in the back is approx.1,850sqft & offers 3 bedrooms & 1 full bathroom. It boasts a large great room living room w/ custom doors leading out to the back patio; custom commercial kitchen w/ oversized island, professional-grade stainless steel appliances, stainless steel sink & large walk-in pantry; separate dining room w/ plantation shutters. Other highlights: upgraded dual paned windows throughout, updated luxury laminate flooring, central AC & heating, updated bathroom, oversized 2car garage, beautiful long cement aggregate driveway, large rear patio. The 2nd unit (339 I St) offers 1,060sqft, 2 bedrooms 1 bathroom, w/ family room & living room. The 3rd unit (337 I St) offers 680sqft, 1 bedroom, 1 bathroom w/ living room. Beautiful curb appeal w/ white picket fence. This property is just blocks to Niles downtown w/ restaurants, quaint shops, the Silent Film Museum, a local supermarket, a weekly farmers market, & Town Plaza.

337 I St

Message successfully sent.

What would you like to know?

Related Properties

New on site 1 day ago
Welcome to this beautifully upgraded custom home in the prestigious Heritage Heights of Mission San Jose. Featuring one of the largest floor plan in the neighborhood, this spacious 4-bedroom plus large bonus room home blends elegant design with modern comfort. One bedroom and one full bathroom are downstairs. Double doors lead you into a grand foyer with custom entry flooring, a spiral staircase and vaulted ceilings. The open layout includes a formal living room, dining room, custom kitchen, and a large family room with a fireplace. Highlights include custom flooring throughout, new LED recessed lighting, European-style bathrooms, dual-pane windows, plantation shutters, newly painted interior and exterior, a Tesla charger, and custom garage cabinetry. The front yard boasts a cement aggregate walkway with brick accents and custom cement areas. The landscaped backyard features a granite patio, built-in BBQ, custom gazebo, fountain with waterfall, custom retaining walls, and mature trees. Close to shops, local eateries, and outdoor attractions miles of hiking trails and gorgeous Bay views. Easy commute access to 680, 880, 84/Dumbarton Bridge, BART station, San Francisco, Peninsula, Silicon Valley, Facebook, Google/YouTube, Apple.
#41108020

Fremont

43578 Greenhills Way

4 Beds

3 Baths

3,112 Sq.Ft.

$3,288,000

MLS#: 41108020

New on site 1 day ago
Welcome to this grand Warm Springs estate in Fremont, offering 5 spacious bedrooms, 3 bathrooms, and an oversized activity room across 3,196 sq. ft. of living space on an 8,860 sq. ft. lot. Designed with both comfort and versatility in mind, this home is ideal for large or multi-generational families seeking space and convenience in a highly desirable neighborhood. Nestled on a quiet cul-de-sac, the property provides privacy while being just minutes from excellent schools, scenic parks, the BART station, and major freeways - perfect for commuters and families alike. Inside, soaring ceilings flood the living room with natural light, creating a bright and welcoming atmosphere.Fresh interior paint and brand-new carpet add a move-in-ready touch throughout. The thoughtfully designed floor plan includes a main-level bedroom and full bath, and separate living and family room. Upstairs, the oversized activity room offers endless possibilities, whether as a playroom, home office, or media lounge. Outside, the expansive backyard is ready for gatherings, gardening, or simply enjoying the outdoors, with plenty of room for relaxation and play. Don't miss this wonderful home that combines function, comfort, space, and location! Welcome home!
#ML82022160

Fremont

44520 Mesquite Court

5 Beds

3 Baths

3,198 Sq.Ft.

$2,749,000

MLS#: ML82022160

New on site 2 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.
#41111867

Fremont

41519 Apricot Ln

3 Beds

2 Baths

2,018 Sq.Ft.

$2,388,000

MLS#: 41111867

Nestled in the heart of Fremont’s historical Niles District where the golden era of silent films began! Don't miss your opportunity to own a one-of-a-kind triplex property! THREE HOMES on one lot. Each home has its own address, PG&E meter, garage & laundry. Whether you're looking for investment, multi-generational living, or rental income to offset your mortgage, this property offers flexibility, location & historical charm in equal measure! Each home has been beautifully renovated with the main home gorgeously showcasing Niles antique design! YOU MUST SEE to appreciate: photos do not capture the quality craftsmanship and stunning design! Located just steps away from Niles Elementary School and the bustling "Main Street" with weekly Farmer's Market, restaurants, antique shops & ongoing festivities. Enjoy breathtaking views as you stroll the Niles Community Park with tennis courts, playground, paved pathways, and breathtaking Fall colors - just a few minutes walk away! Act fast! THREE stunning homes priced for the cost of two with perfect location in downtown Niles District. Bring your extended family! This won’t last!
#41111513

Fremont

37230 2nd St

6 Beds

3 Baths

2,440 Sq.Ft.

$2,299,888

MLS#: 41111513

Welcome to 230 D Street, Fremont, located in the heart of historic Niles District, a neighborhood celebrated for its small-town charm and rich cinematic history. This stunning property offers a fully remodeled main residence with permits, paired with a newly built ADU both thoughtfully designed with modern finishes and complete privacy. The main home features 1460 sq. ft . with 3 bedrooms and 2.5 bathrooms, showcasing a brand-new kitchen with stainless steel appliances, stylish bathrooms, new flooring, windows and energy-efficient heat pump systems for heating and cooling. Entertaining with its own huge backyard. The new built ADU includes 774 sq. ft. with 2 bedrooms and 2 bathrooms, with spacious yard , its own separate driveway and entrance, making it ideal for extended family, guests, or rental income. Set on an expansive 11,760 sq. ft. lot, the layout ensures each home enjoys privacy while sharing a peaceful setting on a quiet street. The property is also in a prime location walking distance to Niles Elementary School and Niles Community Park perfect for families and nature lovers alike. With its blend of modern upgrades, functional living, and the charm of Niles, this property is truly one of the best homes in the neighborhood.
#ML82018390

Fremont

230 D Street

5 Beds

4 Baths

2,234 Sq.Ft.

$2,390,000

MLS#: ML82018390

NEW PRICE! In the Quail Run Community! This 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,650,000

MLS#: 41106496

Mission San Jose Masterpiece: Unbeatable Location Within o.8-Mile Radius of Top MSJ Schools, Excellent Property Appreciation, and Easy Access to Silicon Valley Commute Routes and BART. Indulge in a lifestyle where elegance meets practicality, and invest in a community known for its excellent appreciation rates and strong resale values. This stunning luxury property was rebuilt in 2000 with most of its components under 25 years old. It offers exquisite architectural design and amenities. The meticulously maintained front yard and elegant double-door entry create an excellent curb appeal. Step inside to an open-concept layout that bathes every room in natural light. Enjoy the warmth of rich hardwood floors that flow throughout the main living areas, creating an inviting ambiance perfect for gatherings. The gourmet kitchen features top-of-the-line appliances, wet bar, walk-in pantry, custom cabinetry, and an island with breakfast bar and food prep area. Retreat to the expansive primary suite, complete with a spa-like bathroom and tranquil balcony for morning coffee and evening sunset. Take the 3-D tour to experience the well-designed floor plan and see it in person during the Open House this weekend!
#41106060

Fremont

42001 Via San Gabriel

5 Beds

3 Baths

2,574 Sq.Ft.

$3,288,888

MLS#: 41106060

This stunning, extensively renovated 4-bed, 2.5-bath, north-east facing home has access to top-rated Weibel and Irvington schools. Upon entry, you’ll be captivated by soaring cathedral ceilings & abundant natural light. The open-concept living and dining areas flow seamlessly to the kitchen with sleek cabinetry, quartz waterfall countertops, breakfast bar, and stainless-steel appliances, incl. a smart Café induction range. A connected family room boasts an elegant fireplace, half-bath, and sliding doors for easy access to outdoor entertaining. Upstairs are three bedrooms, a full bath, plus a spacious primary suite with vaulted ceilings, ample closet space & a luxe double-sink bathroom. The 7,800+ SF lot is your vision in the making: a play structure, garden, croquet area, or an ADU—it’s all possible. Additional convenience & comfort: attached two-car garage, laundry room, coat closet & under-stair storage. Builder provides a 1-year warranty. Upgrades include flooring, doors, lighting, double-pane windows, new furnace/AC and water heater, updated electrical & plumbing, and more. No HOA. This coveted location is close to BART, 99 Ranch, multiple parks, and easy freeway access. A GROUND-FLOOR BEDROOM AND FULL BATH CONVERSION IS NOW AVAILABLE AT THIS IMPROVED LIST PRICE!
#41105782

Fremont

1485 Deschutes Pl

4 Beds

2 Baths

2,163 Sq.Ft.

$2,248,000

MLS#: 41105782

Beautifully upgraded east facing home in the highly sought-after Mission San Jose district with top-rated schools: Mission Valley Elem, Hopkins Jr. High & Mission San Jose High! This spacious 2,665 sq ft home on a 6,300 sq ft lot offers 5BR/3BA plus a large bonus room upstairs, perfect for a 6th bedroom, office, or den. A private upstairs in-law unit with separate entrance, 2BR/1BA offers incredible flexibility for extended family, rental income, or ADU use. The bright, open layout includes a living room with bay windows, cozy fireplace, and dining area with skylight. The remodeled kitchen features new quartz countertops, backsplash, stainless steel appliances, and freshly painted cabinets. Downstairs includes a spacious primary suite with two closets, new walk-in shower, double vanity, porcelain tile flooring, plus 3 more bedrooms and a fully renovated bath. Other upgrades include new luxury vinyl plank flooring (downstairs), recessed lighting, dual-pane windows, new interior/exterior paint, central heating, and brand-new A/C (downstairs). Fresh landscaping with new lawn. Close to Lake Elizabeth, shops, restaurants, Fremont Library, BART & easy access to I-680/I-880. Don’t miss this rare opportunity! Welcome Home!
#41104432

Fremont

42077 Miranda St

5 Beds

3 Baths

2,665 Sq.Ft.

$3,099,000

MLS#: 41104432

- 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