Property search · The Consumer Protection Brokerage
Every listing shows your estimated rebate.
The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.
3318 CelesteRiverside, CA 92507




Location, Location, Location! Rare opportunity to own a spacious 2,234 sq. ft. home in one of the most desirable neighborhoods adjacent to UC Riverside. Featuring 4 bedrooms and 4 bathrooms, this versatile property is ideal for owner-occupants, multi-generational living, student housing, or investors seeking strong rental potential in one of Riverside's most in-demand markets.The flexible floor plan includes two primary suites, one with its own private exterior entranceperfect for extended family, guests, a home office, or the opportunity to generate additional rental income. Recent UpgradesHouse repiped (2021)New HVAC/air conditioning system (2022)Sewer pipe relining (2025)New dishwasher (2025)Inside, you'll find a welcoming formal living room with a cozy fireplace, a separate family room, and a generously sized kitchen with abundant cabinetry and counter space that opens to the main living areasideal for both everyday living and entertaining. A dedicated indoor laundry room adds convenience and functionality.Situated on an expansive 10,454 sq. ft. lot, the backyard offers endless possibilities to create your dream outdoor retreat, whether you envision a garden, entertaining space, play area, or future enhancements.The location is truly exceptional. Just a short walk to UC Riverside, this home is an outstanding option for families, parents purchasing for a student, or investors looking to capitalize on consistent rental demand. Convenient access to Interstate 60 and State Route 91 makes commuting throughout the Inland Empire quick and easy.Outdoor recreation is just minutes away, with the popular Box Springs Mountain "C" Trail and the beautiful UC Riverside Botanic Gardens nearby. You'll also enjoy close proximity to shopping, dining, parks, and the vibrant arts, entertainment, and restaurant scene in Downtown Riverside.Families will appreciate access to highly regarded schools, including Riverside STEM Academy, Harada Elementary School, University Heights Middle School, and North High School.Whether you're searching for a spacious forever home, housing for a UCR student, or a high-performing investment property, this exceptional residence delivers the perfect combination of location, flexibility, comfort, and long-term value. Click on the 360 prompt, take a virtual tour !
| 2 weeks ago | Listing updated with changes from the MLS® | |
| 3 weeks ago | Status changed to Active | |
| a month ago | Listing first seen on site |
This information is deemed reliable but not guaranteed. You should rely on this information only to decide whether or not to further investigate a particular property. BEFORE MAKING ANY OTHER DECISION, YOU SHOULD PERSONALLY INVESTIGATE THE FACTS (e.g. square footage and lot size) with the assistance of an appropriate professional. You may use this information only to identify properties you may be interested in investigating further. All uses except for personal, non-commercial use in accordance with the foregoing purpose are prohibited. Redistribution or copying of this information, any photographs or video tours is strictly prohibited. This information is derived from the Internet Data Exchange (IDX) service provided by San Diego MLS®. Displayed property listings may be held by a brokerage firm other than the broker and/or agent responsible for this display. The information and any photographs and video tours and the compilation from which they are derived is protected by copyright. Copyright © 2026 San Diego MLS®.
Last checked 2026
*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.
Found a home you love?
Schedule a free consultation to lock in your rebate before you offer.
Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.