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

7502 E Avenue V
Littlerock, CA 93543

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,900
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 1186 Square Feet
Agency: Berkshire Hathaway HomeServices California Properties
Agency Phone: (818) 993-8900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: An Incredible Opportunity: Two Homes with Thriving Land! ??<br /> Discover the perfect blend of investment and lifestyle with this exceptional property featuring two homes nestled amidst flourishing grapevines, peaches, jujubes, and grenades. Cultivate the land and generate income to help pay your mortgage!<br /> Abundant Fruit Trees: Enjoy a productive landscape that enhances your home's beauty and offers the potential for additional income.<br /> ?? Main House:2 Bedrooms (with the option to convert into a third)Spacious kitchen ideal for entertaining and culinary adventures.Inviting family room with a cozy fireplace, perfect for relaxation and gatherings<br /> Private yard with its own entrance, creating a peaceful retreat<br /> ?? Guest House:3 Bedrooms and 2 Bathrooms offering ample space for family or guests.Bright, airy living areas designed for comfort and convenience<br /> Separate entry and yard, ensuring privacy and independence<br /> ?? Additional Amenities:<br /> The bungalow is equipped with a bathroom, which is ideal for guests or a home office.<br /> Two storage sheds to keep your gardening tools organized and accessible.<br /> Long driveway providing easy access and parking. Breathtaking mountain views enhance the tranquility of this beautiful setting.<br /> This is a rare opportunity to own two homes with productive land, allowing you to create a sustainable lifestyle while enjoying the beauty of nature. Don’t miss out on this fantastic chance to invest in your future!
MlsNumber: --
ListingId: SR24195759


Listing Provided By: Berkshire Hathaway HomeServices California Properties, original listing
Phone: (213) 393-9923
Office Phone: (818) 993-8900
Agent Name: Miriam Carter
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