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 Ave V
Littlerock, CA 93543
Miriam Carter with Berkshire Hathaway HomeServices California Properties, original listing - (818) 993-8900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $744,800
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: WHAT A DEAL!!! Investment Opportunity - Homes on a Productive, Income-Generating Property! Investors, this is your chance to own a stunning property that blends lifestyle and investment potential! Imagine living amidst grapevines, peaches, jujubes, and pomegranates, where the land not only adds beauty to your home but also generates income to help pay your mortgage. Abundant Fruit Trees. Enjoy a productive landscape that offers both natural beauty and the potential for extra income. Main House: Cozy and Versatile2 Bedrooms (option to convert to 3)Spacious kitchen - perfect for entertaining and cooking adventures Family room with a cozy fireplace - ideal for relaxing and hosting gatherings A private yard with its entrance is a peaceful retreat!! Guest House: Private and Spacious,3 Bedrooms, 2 Bathrooms - bright and airy, designed for comfort and Separate entry and yard - offering privacy and independence for family or guests Bonus Bungalow. Complete with a bathroom, ideal for a guest suite or home office. Additional Features: Two storage sheds for all your gardening needs. Long driveway with plenty of parking for Boats, trucks, and more. Stunning mountain views - enjoy breathtaking sunrises and sunsets that enhance the tranquility of this rural setting, making it a serene escape from city life. This is a rare and exciting opportunity to own a productive property that promotes a sustainable lifestyle while serving as a solid investment for the future. Don't wait - contact us today to make this extraordinary property yours!
MlsNumber: --
ListingId: 25000789


Listing Provided By: Berkshire Hathaway HomeServices California Properties, original listing
Phone: (818) 993-8900
Office Phone: (818) 993-8900
Agent Name: Miriam Carter
Disclaimer: Copyright © 2025 Greater Antelope Valley 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