Title Page Background
DEBUG FN args: Array ( [0] => 3473 [1] => [2] => [3] => agent ) BEFORE: Site: 3473 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3473 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3473 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3473 [1] => [2] => [3] => lender ) BEFORE: Site: 3473 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3473 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3473 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3473 [1] => [2] => [3] => other ) BEFORE: Site: 3473 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3473 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3473 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;

6169 Lapis Way
Riverside, CA 92503

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $570,000
Beds: 3
Baths:
Status: Active
SqFt: 1700 Square Feet
Agency: BERKSHIRE HATH HM SVCS CA PROP

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer, Oven - Gas
Architectural Style: Other
Heating: Central Furnace, Fireplace
Interior Features: High Ceilings, Crown Molding, Granite Counters
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Loft

Window Features

Exterior Features: Sprinkler System, Street Lights, Back Yard, Community Features Included: Sidewalks

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Welcome to this delightful 3-bedroom, 2.5-bathroom home nestled within a gated community in Riverside. As you approach the front door, the newly tiled entryway invites you inside. Step through, and you’ll discover a warm and inviting interior with thoughtful design details.<br /> The cherry-colored laminate wood flooring creates a seamless flow throughout the main living areas. Multiple windows flood the space with abundant natural light, making it feel airy and welcoming. The family room boasts a cozy fireplace with a white tile hearth, perfect for chilly evenings. Imagine gathering around the mantle, creating cherished memories with loved ones. The kitchen features granite countertops and elegant cherry-colored cabinets and stainless steel appliances. The island serves as both a practical workspace and an additional eating area, complete with convenient under-storage. Adjacent to the patio door, the dining area awaits your table. Enjoy meals bathed in sunlight and easy access to the backyard—a seamless blend of indoor and outdoor living. You’ll find a half bathroom and a laundry room conveniently located near the garage entrance.<br /> Ascend the stairs to discover a high-ceilinged loft—a versatile space that can serve as an office, cozy movie nook, or even be converted into a fourth bedroom. Double doors lead to a spacious master suite with a walk-in closet and built-in storage shelves. The master bathroom offers a walk-in shower, separate bathtub, double sinks, and an additional bonus walk-in closet. The upstairs hallway leads to a nicely sized bathroom with a shower/tub combo, serving two additional bedrooms. Both bedrooms are nicely sized and feature mirrored closed doors.<br /> A two-car garage provides direct access to the home, and a side yard door adds convenience. The backyard awaits your personal touch—imagine creating your own outdoor sanctuary.<br /> The gated community offers a refreshing pool, picnic area, and BBQ space for residents to enjoy.<br /> This well-maintained home is move-in ready, waiting for you to make it your own!<br /> <br /> OPEN HOUSE: SAT APRIL 4th & SUN APRIL 5th
MlsNumber: --


Listing Provided By: BERKSHIRE HATH HM SVCS CA PROP, original listing
Phone: (714) 998-8810
Office Phone: (909) 980-3100
Agent Name: Patricia Neder Eckman
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App