Title Page Background
HFQUERY 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 = 3369 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3369 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3369 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

5011 Juneau Court
Rancho Cucamonga, CA 91739

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 2865
Agency: Realty Masters & Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16,708 sqft
Property Type: Residential
Year Built: 2007
Notes: Located in the prestigious gated Rancho Etiwanda Estates, this home represents the epitome of serenity & tranquility with PARK-LIKE BACKYARD featuring INCREDIBLE ROCK WATERFALL, abundant with rich greenery, assortment of fruit trees & a CALIFORNIA ROOM with cozy fireplace & TV for entertaining all year long! This pristine CUL-DE-SAC home is turnkey featuring wonderful pops of color, w/ porcelain tile, hardwood flooring, plush neutral carpeting & shutters throughout. Upon entry, experience the height of the second floor w/bursts of light coming through the stairway windows giving off a warm & inviting feeling into the formal living & diningroom - a large seating area to gather & converse as well as enjoy family dinners. Continue the tour passing the powder room & into another great hosting space, the Great Room. Familyroom has a traditional look w/raised hearth fireplace & built-in lighted entertainment center & plenty of seating space. Well-appointed kitchen is roomy & functional featuring a center island with storage all the way around, spacious countertops in toffee granite, stainless steel appliances & a garden window. Ascend the stairs to find 3 bedrooms w/picturesque mountain views & hallway bathroom w/double sinks & separate shower convenient to have w/busy families on busy mornings. Through the double door entry is a sizable primary suite offering a retreat space of gentle blue walls & dark hardwood floors & what makes it so suite is the en-suite bathroom boasting of centralized soaking tub w/surround to lay out all your favorite candles, dual sinks, walk-in shower & a large organized closet. Let’s go out back & enjoy all the outdoors has to offer in this one of a kind backyard! Look at what is surrounding you- a feast for your eyes & ears! Birds chirping, hummingbirds & the sound of running water from an incredible rock waterfall that starts near the top of the slope & trickles down, so relaxing to hear; or step up to the top of the waterfall to enjoy twinkling city lights views. Glorious backyard lush w/mature growth of florals, fruit trees, river rock, even a raised garden bed to farm your own veggies. Hang out in the California Room - a covered shaded area w/TV & fireplace, recessed lights & ceiling fans perfect for dining all year long extending the feeling of indoors while you’re outdoors. Show off your BBQ skills w/stainless steel Twin Eagles BBQ also featuring island in beauitful granite, storage, sink & utensil drawer. Come & fall in love!
MlsNumber: CV24096654


Listing Provided By: Realty Masters & Associates, original listing
Name: Realty Masters & Associates
Phone: (714) 368-1300
Office Name: REALTY MASTERS & ASSOCIATES
Office Phone: (909) 303-4500
Agent Name: Kevin Shin
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.


Local Real Estate Expert

HFQUERY 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 = 3369 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Anthony Piscitello
ASCIIPiscitello Realty
Call Today!: (951) 638-4513

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App