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 = 239 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 239 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 239 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

21 Quail Hollow Way
Red Bluff, CA 96080

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2013
Agency: River City Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1993
Notes: This well maintained one owner home has so much to offer and is in immaculate condition. The beautifully landscaped yard welcomes you. As you enter the home you are greeted by lovely tile floors in perfect condition. The entire interior was recently painted with all new baseboards upstairs, new carpet on the stairs, redone pantry, and master closet. The living room is spacious and perfect for entertaining, the kitchen offers a large amount of storage with plenty of cabinet space and a large pantry. There is a lovely breakfast nook that is graced with natural light. As you arrive upstairs you will notice the inviting wood laminate floors and spacious bedrooms. The master bedroom is oversized with a walk in closet and great sized bathroom including a jetted tub. There is also a half bath downstairs perfect for guests when you are entertaining. The garage was also recently painted and is ready to go. There is a bonus room in the garage that would make a perfect gym, or home office. There is storage space above the bonus room perfect for all of your storage totes. The backyard is very spacious and loaded with beautiful raywood ash trees that shade nearly the entire backyard, it is such a peaceful and beautiful backyard. A newer deck is the perfect spot for morning coffee, or evening barbecues. The owned solar is a huge plus making your bill very minimal. Another plus for your energy costs is the whole house fan. There is also a generator that is connected to the home and will run the basics. Also, a shed for additional storage needs. This home has been well cared for many years by the original owners and you can feel the pride of ownership throughout. This is a fantastic street and you are surrounded by wonderful neighbors, nearly everyone on this street has lived here for many, many years. Reach out today with any questions you may have, or to schedule a showing. Rachael Kordzikowski, Lic. 02063790, River City Realty, 530.526.7394.
MlsNumber: 20240262


Listing Provided By: River City Realty, original listing
Name: River City Realty
Phone: (530) 200-2700
Office Name: River City Realty
Office Phone: (530) 200-2700
Agent Name: Rachael Kordzikowski
Disclaimer: Copyright © 2024 Tehama County Association Of Realtors. 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