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

206 W Crystal Ln
Quartzsite, AZ 85346
Armando Heredia with David Plunkett Realty - Quartzsite, original listing - (928) 927-5290

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $416,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1920 Square Feet
Agency: David Plunkett Realty - Quartzsite
Agency Phone: (928) 927-5290

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 2022
Notes: A fantastic piece of property is waiting for you. This 2022 Clayton manufactured home sets on a one-acre lot that is fully fenced in for privacy. A covered carport/patio is attached on the northside of the home while the southside is shaded by an awning the complete length of the home. The home sets high on a mound to protect from flooding. The interior of the house is spacious as it includes 3 bedrooms ,2 baths, a large living room, dining room, modern kitchen, utility room, and large pantry. All the bedrooms have walk-in closets and ceiling fans. The kitchen is equipped with a built-in microwave, electric oven/stove, breakfast bar with hard countertop, dishwasher, plenty wooden cabinets, hard counter tops, recessed ceiling lights, and double door stainless steel refrigerator. The one- acre parcel easily accommodates a 30'' x 12' wooden shed, two 10' X 12' sheds, a green house, and gardening area. The 30' X 15' shed is prepared as a work studio. It has a utility sink, full bath, and mini split. The yard has matured trees for shade and several new citrus trees. The yard is landscaped. Hedges surround the fenced perimeter. Watering the foliage is not a problem as the property has a well and is connected to city water. The well provides water to the irrigation system and the work studio, while the city water serves the home. The property is fully fenced and has automatic gates. Some of the furniture will be staying.
MlsNumber: --
ListingId: 1035620


Listing Provided By: David Plunkett Realty - Quartzsite, original listing
Phone: (928) 669-0712
Office Phone: (928) 927-5290
Agent Name: Armando Heredia
Disclaimer: Copyright © 2025 Lake Havasu 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