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

26599 Mariner Lane
Helendale, CA 92342

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $420,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1696
Agency: Professional Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8,184 sqft
Property Type: Residential
Year Built: 1986
Notes: BACK ON MARKET, NO FAULT OF SELLER. OPEN WATER VIEWS FROM YOUR PATIO! Fish right from your dock! This lovely home on the South Lake in Silver Lakes has been well maintained and loved! 3 bedrooms and 2 bathrooms, with several upgrades in recent years. Lovely open water views from the patio and even inside the home. A remodeled kitchen with upgraded appliances, flooring, new sink with motion sensor faucet, upgraded luxury electric cooktop, and granite counters. Seller replaced carpet in 2022, as well as tile flooring. They also installed gates and additional fencing with powder coat finish. In addition to that, they installed cameras, a ring doorbell and a security alarm, new toilets, had the ceilings in all rooms scraped, textured and painted. Very low maintenance yard with pretty landscaping. A private dock and launch area are yours to enjoy! Garage is lined with built in storage cabinets. Located on a quiet street with beautiful views, it is on the shady side of the street! Silver Lakes is a private community between Victorville and Barstow. Low monthly HOA dues include use of all of the amenities including a 27 hole championship Ted Robinson design golf course, Tennis courts, Bocce ball courts, Pickle Ball courts, gorgeous clubhouse, library, Olympic sized swimming pool, Kiddie pool, Gym, RV Park and storage, Equestrian facilities so you can stable your horses, Beach and boat launch, two beautiful lakes for fishing boating, kayaking, paddle boarding, and even windsurfing!
MlsNumber: HD24080785


Listing Provided By: Professional Realty, original listing
Name: Professional Realty
Phone: (760) 952-1077
Office Name: Coldwell Banker Home Source
Office Phone: (760) 952-3415
Agent Name: Team Roper Hernandez Real
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