Cheyenne Celestine
BEDS3
BATHS1 full
SQUARE FEET951
MLS#41136799
STATUSActive
PROPERTY TYPEResidential - Single Family
SUBDIVISIONMISSION
SCHOOLFremont Unified
Listing Courtesy of:
Coldwell Banker Realty
Agency Phone: 510-608-7600
Associate Name: Joe Schembri
Listing Shown by:
Farrell Smyth, Inc.
Associate Name: Cheyenne Celestine
Property Description
Permitted patio/sunroom of approx. 250 sq ft is not included in the total square footage. Charming ranch-style home in the heart of the coveted Mission San Jose district just a few blocks to awarded schools Mission San Jose Elementary, Hopkins Jr High, Mission San Jose High & Ohlone College. Situated on a tranquil, tree-lined street within walking distance to downtown Mission San Jose, restaurants, and parks, this North-facing 3-bedroom home offers a welcoming front living room filled with natural light from large windows. The bathroom boasts approx. $60K in remodeling. Conveniently located near Highways 680 and 880, this home offers easy access to Silicon Valley, Facebook, Google, and Apple.
Property Features
Property Type: Residential - Single Family
Cooling: None
Garage: 1 car attached
Heating: WallFurnace
Home Style: Ranch
Lot Size: 0.12 Acres
Roof Type: Shingle
Stories: 1.0
Year Built: 1953
Feature Descriptions
Appliances: GasWaterHeater
Exterior: Stucco
Fireplace: LivingRoom
Flooring: Tile, Wood
Lot: BackYard, FrontYard, Garden, StreetLevel
Parcel#: 513608119
Parking: Garage, GarageDoorOpener
Parking Notes: Garage, GarageDoorOpener
Local Schools
School District: Fremont Unified
Listed By / Shown By
Listed By
Agency Name: Coldwell Banker Realty
Agent Name: Joe Schembri
Agency Phone: 510-608-7600
Shown By
Agent Name: Cheyenne Celestine
Agent Phone: (805) 543-2636 ext. 16
Agency Title: Farrell Smyth, Inc.
Estimate Your Payment
Estimated Payment
$ 3,896.68 per month $3,445.18 Principal & Interest $0.00 Property Tax (data not provided by mls) $451.50 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
338 Lemarc St | MLS# 41136799
This single family home located at 338 Lemarc St, Fremont, CA 94539 is currently listed for sale with an asking price of $1,548,000. This property was built in 1953 and has 3 bedrooms and 1 full baths with 951 sq. ft. Lemarc St is located in the MISSION subdivision within the Fremont Unified school district. Search MISSION real estate on ccelestine.farrellsmyth.com today.