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

39346 Prospect Drive
Forest Falls, CA 92339

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $875,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3841
Agency: Gillmore Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14,020 sqft
Property Type: Residential
Year Built: 1957
Notes: Escape to the Mountains! This Dream Home is Hidden in the Forest. Fantastic family home boasts 4 huge bedrooms, 4.5 baths, family room, giant recreation room and oversized 2 car garage on 2 lots with paved drive, fire resistant construction (stucco exterior/eaves and concrete tile roof), energy efficient windows and heat/air systems. Enter into spacious living room with large native stone fireplace and huge picture window opening to forest/trees view essentially blocking out any neighbors. 2 large bedrooms and full bath with separate tub and shower make up the east wing. Centrally placed full featured kitchen has had recent remodel and affords granite counters, induction cooktop, microwave, oven, dishwasher and stainless fridge. Opened beamed family room is complete with large air-tight fireplace, beamed and peaked ceilings and access onto large balcony to bring the forest in. Complete the main level with inviting guest bath, large laundry/sewing room and master suite with full bath, walk closet and level access to nice rear yard with towering specimen trees and direct access to a great walking/hiking trail. Lower level provides access from main or direct access from outside and hosts another large bedroom, exercise/laundry room and custom full bath with large sauna and steam shower. Don't forget the 600 square foot recreation room with huge closet and full bath plus direct access into oversize 2 car garage with two walls of incredible storage. At 5000' of elevation the weather is often considered the banana belt of Forest Falls with tempered summers and generally mild winters.
MlsNumber: EV23213324


Listing Provided By: Gillmore Real Estate, original listing
Name: Gillmore Real Estate
Phone: (909) 794-2518
Office Name: GILLMORE REAL ESTATE
Office Phone: (909) 794-2518
Agent Name: THOMAS MCINTOSH
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