Cheyenne Celestine
BEDS8
BATHS5 full
SQUARE FEET3,411
MLS#ML82047849
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLOther
Listing Courtesy of:
All Star Homes
Agency Phone: 650-231-8888
Associate Name: Jessica Shum
Listing Shown by:
Farrell Smyth, Inc.
Associate Name: Cheyenne Celestine
Property Description
Incredible Downtown Hayward location! Built in 2020, this spacious 3,411 sq ft property offers flexible living with separate upper and lower levels and two separate addresses. Featuring 8 bedrooms and 5 bathrooms on an approximately 7,700 sq ft lot, this property is ideal for multi-generational living or investment opportunities. Upper level offers approximately 1,648 sq ft and lower level offers approximately 1,763 sq ft. Both units are tenant occupied, generating $8,070/month in rental income ($4,070 upper level / $4,000 lower level). Interior features include laminate hardwood flooring, quartz countertops, stainless steel appliances, modern finishes, spacious family room with wet bar, and large deck above garage. Property also includes a Tesla solar system for added energy efficiency. Private backyard with mature landscaping and separate outdoor areas. Convenient location near Downtown Hayward, shopping, restaurants, schools, and easy access to Hwy 92, 580, and 238. Don't miss this opportunity!!
Property Features
Property Type: Residential - Single Family
Cooling: Central Air
Garage: 2 car attached
Home Style: Custom
Lot Size: 0.18 Acres
Roof Type: Composition
Stories: 2.0
Year Built: 2020
Feature Descriptions
Appliances: Dishwasher, Disposal
Days on Site: 4
Exterior: Stucco
Fencing: Wood
Flooring: Laminate
Parcel#: 4270061057
Parking: Gated
Parking Notes: Gated
Sewer: Public Sewer
Water: Public
Local Schools
School District: Other
Listed By / Shown By
Listed By
Agency Name: All Star Homes
Agent Name: Jessica Shum
Agency Phone: 650-231-8888
Shown By
Agent Name: Cheyenne Celestine
Agent Phone: (805) 543-2636 ext. 16
Agency Title: Farrell Smyth, Inc.
Estimate Your Payment
Estimated Payment
$ 3,977.23 per month $3,516.40 Principal & Interest $0.00 Property Tax (data not provided by mls) $460.83 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 --
1624 D Street | MLS# ML82047849
This single family home located at 1624 D Street, Hayward, CA 94541 is currently listed for sale with an asking price of $1,580,000. This property was built in 2020 and has 8 bedrooms and 5 full baths with 3411 sq. ft. D Street is located within the Other school district. Search Hayward real estate on ccelestine.farrellsmyth.com today.