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 = 3127 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 = 3127 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 = 3127 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;

12205 Dos Rios Avenue
Grand Terrace, CA 92313

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $729,900
Beds: 5
Baths: 3
Status: Active
SqFt: 2142
Agency: eXp Realty of California, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12,375 sqft
Property Type: Residential
Year Built: 1962
Notes: WELCOME TO 12205 DOS RIOS AVE! THIS CHARMING 2-STORY, 2,142 SQFT HOME OFFERS THE PERFECT BLEND OF COMFORT AND CONVENIENCE, NESTLED IN THE WELCOMING COMMUNITY OF GRAND TERRACE. BOASTING 5 BEDROOMS AND 3 FULL BATHROOMS, THIS RESIDENCE IS THOUGHTFULLY DESIGNED TO ACCOMMODATE YOUR LIFESTYLE NEEDS. UPON ENTERING, YOU'LL BE GREETED BY A SPACIOUS INTERIOR FLOODED WITH NATURAL LIGHT, CREATING A WARM AND INVITING ATMOSPHERE THROUGHOUT. THE MAIN FLOOR FEATURES A CONVENIENT BEDROOM AND FULL BATHROOM, IDEAL FOR ACCOMMODATING GUESTS OR IN-LAWS WITH EASE. THE HEART OF THE HOME LIES IN THE EXPANSIVE KITCHEN, COMPLETE WITH AMPLE CABINET AND COUNTER SPACE, PERFECT FOR PREPARING DELICIOUS MEALS AND GATHERING WITH LOVED ONES. ADJACENT TO THE KITCHEN, THE COZY BREAKFAST AREA PROVIDES THE PERFECT SPOT TO START YOUR DAY WITH A CUP OF COFFEE AND A TRANQUIL VIEW OF THE BACKYARD. UNWIND IN THE SPACIOUS LIVING ROOM, WHERE A CHARMING FIREPLACE SETS THE STAGE FOR COZY EVENINGS SPENT CURLED UP WITH A GOOD BOOK OR ENJOYING QUALITY TIME WITH FAMILY. THE ADJOINING DINING AREA OFFERS AMPLE SPACE FOR HOSTING FAMILY DINNERS AND HOLIDAY GATHERINGS, CREATING CHERISHED MEMORIES FOR YEARS TO COME. VENTURE UPSTAIRS TO DISCOVER THE REMAINING FOUR BEDROOMS, INCLUDING THE LUXURIOUS PRIMARY SUITE. RETREAT TO YOUR PRIVATE OASIS, FEATURING A FULL BATH AND A GENEROUSLY SIZED WALK-IN CLOSET, PROVIDING THE ULTIMATE IN COMFORT AND CONVENIENCE. STEP OUTSIDE TO YOUR OWN BACKYARD PARADISE, COMPLETE WITH A SPARKLING POOL AND SPA, PERFECT FOR ENTERTAINING GUESTS OR SIMPLY RELAXING IN THE CALIFORNIA SUNSHINE. WITH ITS TRANQUIL AMBIANCE AND LUSH LANDSCAPING, THIS OUTDOOR SPACE IS SURE TO BECOME YOUR FAVORITE RETREAT. CONVENIENTLY LOCATED NEAR SHOPS, RESTAURANTS, PARKS, AND THE 215 FREEWAY, THIS HOME OFFERS EASY ACCESS TO EVERYTHING GRAND TERRACE HAS TO OFFER. DON'T MISS YOUR OPPORTUNITY TO MAKE THIS YOUR FOREVER HOME—SCHEDULE YOUR PRIVATE TOUR TODAY AND EXPERIENCE THE EPITOME OF SOUTHERN CALIFORNIA LIVING! CONTACT LISTING AGENT ALAN FORNISS AT 562-916-5483 FOR ADDITONAL INFORMATION OR PRIVATE SHOWINGS
MlsNumber: NP24084056


Listing Provided By: eXp Realty of California, Inc., original listing
Name: eXp Realty of California, Inc.
Phone: (888) 584-9427
Office Name: eXp Realty of California
Office Phone: (888) 584-9427
Agent Name: Alan Forniss
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 = 3127 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;
Real Estate Expert Photo for Joanna Heard
Joanna Heard
ASCIIRE/MAX Advantage
Call Today!: (909) 633-0220

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App