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

12151 Fremont Street
Yucaipa, CA 92399

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $159,900
Beds: 2
Baths: 2
Status: Active
SqFt: 1344
Agency: Century 21 Lois Lauer Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2,000 sqft
Property Type: Residential
Year Built: 1971
Notes: Welcome to Space 76 at the prestigious Fremont Heights Mobile Home Estates at the base of the mountains in gorgeous upper Yucaipa!! This park is 55 and older giving you the privacy, quietness and security you require! This turnkey and completely furnished property! That is right, it will come completely furnished with reasonable accepted offer!! When you enter this home you will want to stay as we have stunning mountain, city and a peek of Santa Catalina Island on a clear day!! Home features a separate Living Room Room, Dining Room and Den. Kitchen is perfect with ample cabinet and countertop space and is open to the Den. Living Room features oversized windows giving you an a gorgeous view of the mountains and wildlife as this is one of the few units with no homes across the street. We have two separate bedroom including a Primary Bedroom with its own private Bathroom. Second Bathroom is located in the Hallway. Separate Laundry Room for added convenience. Central Air, Heat and Water Heater have been upgraded also the past two years at a cost of over $18k. Home also has a side covered porch that stretches the length of your home and has a spacious backyard with stunning mountain and valley views. Perfect for gardening, fur babies or to relax. Two Storage Sheds are included in this sale. Exterior Grounds are meticulously maintained and with this location you are able to interact with wildlife in this pristine setting. Views from this home are captivating and give you a sense of peace with all the beauty that surrounds this home. Pets are welcome but certain restrictions apply. You also have numerous amenities for this private community including but not limited to the pool, inside spa, banquet room, kitchen, billiard room and reading room. This park has low rent. Current owners base rent for this space is under $650.00. Buyer to verify if the amount will be slightly adjusted for new ownership. Park Approval is required. Utilities are not included in the base space rent but are billed through the monthly statement for convenience except electric. Just a few minutes drive to Historic Downtown Yucaipa and 10 minutes to Oak Glen! This scenic area of Yucaipa feels hidden and above the clouds but yet we have close proximity to shopping, transit, medical services, recreation, Yucaipa Regional Park, neighborhood parks and the freeway. Lets schedule and appointment to view this home and once you do, I will see you in Escrow!! : )
MlsNumber: IV24055221


Listing Provided By: Century 21 Lois Lauer Realty, original listing
Name: Century 21 Lois Lauer Realty
Phone: (909) 748-7000
Office Name: CENTURY 21 LOIS LAUER REALTY
Office Phone: (909) 748-7000
Agent Name: KENNETH ADKINS
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','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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