x
Showing 1 of 0
X
Save

498 Green Orchard
Riverside CA 92506 US

$1,799,999

Active Listing ID RS26080399
bed icon
5 bed
bath icon
5.00 Bath (4 Full , 1 Half)
lot icon
Lot: 31,799.00 Square Feet
home icon
Single Family Residence

$1,799,999

Active Listing ID RS26080399
Save

498 Green Orchard This home comes with a PRIVATE CASITA WITH FULL KITCHEN — YOUR OWN GUEST RETREAT ??? Step into luxury with this rare offering in the prestigious Stellan Ridge Community — featuring a detached, fully remodeled casita (~900 sqft) with 2 bedrooms, full bathroom, its own kitchen, and a private firepit. Perfect for multi-generational living, rental income, or elevated guest quarters. The main residence is just as impressive. Designed for effortless entertaining, the home welcomes you with a formal living and dining area, highlighted by custom lighting and oversized windows that frame the beautifully landscaped grounds. The fully remodeled chef’s kitchen showcases rich granite countertops and opens seamlessly to the family room, creating a warm and inviting space complete with a fireplace and scenic backyard views. On the main floor, the master’s suite offers a private retreat with custom finishes, a spacious layout, spa-style bath with separate tub and shower, and generous closet space. Upstairs, enjoy a large loft ideal for a media room, office, or additional lounge space, along with well-sized secondary bedrooms. Step outside to your personal resort: a heated saltwater spa pool (no chlorine) — fully fenced for privacy and safety — paired with a beautiful patio area featuring a firepit, perfect for day-to-night entertaining. This property features TWO firepits total — one by the main patio and one in the private casita — creating multiple luxury outdoor experiences. Take in the stunning panoramic views overlooking Mt. Baldy and Big Bear, giving you that elevated, resort-style living every single day. The home also includes owned solar for long-term efficiency and savings, while the private courtyard invites peaceful mornings or intimate gatherings. The front grounds are beautifully maintained by the HOA, enhancing the home’s pristine curb appeal. Luxury. Flexibility. Income Potential. This is more than a home — it’s a lifestyle opportunity designed to sell fast. side note: more photos to come.

Collapse all

Property Features

  • Facts
  • Lot Size: 31,799.00 Square Feet
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 4
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Exterior Finish: Fence, Pool, Community Features Included: Sidewalks, 0-1 Unit/Acre
  • Heating Fuels: Central
  • Additional Features
  • Pool

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1799999
  • unparsedaddress: 498 Green Orchard
  • postalcity: Riverside
  • stateorprovince: CA
  • country: US
  • postalcode: 92506
  • bathroomsfull: 4
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.730004591368228
  • lotsizeunits: Square Feet
  • lotsizearea: 31799
  • livingarea: 4586
  • livingareaunits: Square Feet
  • listagentfullname: Athelle Singson
  • listagentemail: diamondsingson@gmail.com
  • listagentkey: 3yd-MRMLSCA-RSSINGATH
  • listagentmlsid: RSSINGATH
  • listagentpreferredphone: 5622539927
  • listagentofficephone: 5626534406
  • listofficekey: 3yd-MRMLSCA-RSVM
  • listagentstatelicense: 02167812
  • listofficemlsid: RSVM
  • disclaimer: Copyright © 2026 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MRMLSCA
  • yearbuilt: 2007
  • listingcontractdate: 2026-04-15
  • listagenturl: http://www.marquirealty.com
  • countyorparish: Riverside
  • parcelnumber: 243200032
  • elementaryschooldistrict: Riverside Unified
  • middleorjuniorschooldistrict: Riverside Unified
  • highschooldistrict: Riverside Unified
  • cooling: Central Air
  • heating: Central
  • numberofunitstotal: 1
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 4
  • parkingfeatures: Garage
  • waterfrontyn: False
  • exteriorfeatures: Fence, Pool, Community Features Included: Sidewalks, 0-1 Unit/Acre
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5
  • dock: False
  • poolprivateyn: True
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-MRMLSCA-RS26080399", "OpenHouseEndTime": "2026-04-25T22:00:00+00:00", "OpenHouseId": "RS26080399", "OpenHouseRemarks": null, "OpenHouseStartTime": "2026-04-25T19:00:00+00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }, { "AppointmentRequiredYN": false, "ListingKey": "3yd-MRMLSCA-RS26080399", "OpenHouseEndTime": "2026-04-26T22:00:00+00:00", "OpenHouseId": "RS26080399", "OpenHouseRemarks": "", "OpenHouseStartTime": "2026-04-26T19:00:00+00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }, { "AppointmentRequiredYN": false, "ListingKey": "3yd-MRMLSCA-RS26080399", "OpenHouseEndTime": "2026-05-02T22:30:00+00:00", "OpenHouseId": "RS26080399", "OpenHouseRemarks": "", "OpenHouseStartTime": "2026-05-02T19:00:00+00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }, { "AppointmentRequiredYN": false, "ListingKey": "3yd-MRMLSCA-RS26080399", "OpenHouseEndTime": "2026-05-03T22:30:00+00:00", "OpenHouseId": "RS26080399", "OpenHouseRemarks": "", "OpenHouseStartTime": "2026-05-03T19:00:00+00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"MARQUI Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Monthly", "ExpenseValue":375}], "GeocodeOptions":null, "LeadRoutingEmail":"diamondsingson@gmail.com", "ListBrokerageCity":"Cerritos", "ListBrokerageCountry":"US", "ListBrokerageEmail":"vince@marquirealty.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/110/260441/20140319142921517.png", "ListBrokerageName":"MARQUI Realty", "ListBrokeragePhone":"(562) 253-9927", "ListBrokeragePostalCode":"90703", "ListBrokerageStateOrProvince":"CA", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"10900 E 183rd St, Suite 285", "ListBrokerageWebsiteUrl":"http://www.marquirealty.com", "ListOfficeAddress1":"1 Centerpointe Drive #410", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"RMARTVIN", "ListOfficeCity":"La Palma", "ListOfficeCountry":"US", "ListOfficeEmail":"vincentdmartinez@gmail.com", "ListOfficePostalCode":"90623", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family Residence - Riverside, CA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/498-Green-Orchard-Pl_Riverside_CA_92506_M13356-24053?f=listhub&s=MRMLSCA&m=RS26080399&c=rexren", "MLSModificationTimestamp":"2026-04-15T07:53:24Z", "Neighborhoods":[], "PostalCode":null, "RawPropertySubType":"Single Family Residence", "RawPropertyType":"Residential", "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 4/21/2026 11:09:28 PM GMT
Source Updated Date: 4/28/2026 6:48:32 AM GMT

Courtesy of: Athelle Singson, NTMR Holdings Inc., diamondsingson@gmail.com

Copyright © 2026 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.