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

15135 Orchard Springs Road
Grass Valley, CA 95945
Keven Geaney with Melson Realty, Inc., original listing - (559) 697-0002

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,900
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3600 Square Feet
Agency: Melson Realty, Inc.
Agency Phone: (559) 697-0002

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1977
Notes: Imagine living in nature, but at the same time being close to shops and restaurants, and having the modern comforts. Your imagination has come true in this 4/5 (two master suites), 3,600 square foot majestic family retreat on 2.26 acres, including your very own .5 acre pond. <br /> On the lower level, of this two-level retreat, is a large living space with 9-foot high ceiling, wood-burning fireplace, a multi-use room, a guest bathroom and a master suite. A bar area, which could be converted to a kitchenette, is ready to entertain guests. The main level has vaulted wood ceilings. The living room has an antique looking gas fireplace. The dining room and kitchen are also in view in this open floor plan. From the dining room windows a breathtaking view of your own private wilderness and pond can be seen, with geese swimming and deer roaming. Your eyes are then drawn to a chef's kitchen, which was designed with functionality and practicality in mind. Most of the soft-close drawers are pull-outs, including a spice rack. Every space in this dream kitchen has been planned out to make life easier for numerous chefs in the kitchen. It has two peninsulas, one with seating for three, and another with a sideways sink so two chefs can use it on both sides of the island. The faucet swivels and turns on by touch. Another faucet automatically emits hot water. A Bosch dishwasher and trash compactor are also attached to this peninsula. The centerpiece of this chef's kitchen is a Decor double-oven with 6-burner range. A door leads out to a sun room and patio. The lower level also has a patio, along with a gas barbecue and fire-pit. The main master suite is next, with a vaulted wood ceiling. The master bath has spa-like comforts with a jetted tub and massaging shower with 6-body jets, a waterfall, and handheld sprayer. Also two more bedrooms and a jack-and-jill bathroom. This paradise is near Sacramento, Lake Tahoe and Reno. Front 1.67 acre property is also for sale, house & 2,000 SF shop.
MlsNumber: --
ListingId: 233197


Listing Provided By: Melson Realty, Inc., original listing
Phone: (559) 799-8785
Office Phone: (559) 697-0002
Agent Name: Keven Geaney
Disclaimer: Copyright © 2025 Tulare County MLS. 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 = 216 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 Two Birds Homes with Moriah & Kelly
Two Birds Homes with Moriah & Kelly
Call Today!: (530) 648-0750

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App