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

50158 Ehrenberg Rd
Ehrenberg, AZ 85334

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $214,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1440
Agency: eXp Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1977
Notes: ***LEASED LAND***Do not miss this great opportunity on one of the largest lots in The Palms at River Edge. This double wide features a large side deck and carport maximizing the interior living space. Enjoy 1440 square feet of interior living area. Fully renovated down to the studs with a complete re-ducting of the central HVAC system including kick plate vents to eliminate the unsightly vents on the floors in most manufactured homes. The 2 Bdrms have been redesigned to offer the maximum living space. The master bdrm has been tastefully furnished with window coverings, nightstands, dresser and a wall mounted TV. The Cal King bed and bunkbed allows for a comfortable sleep for a minimum of 4 people. The master bath is configured with a dual sink and 30'' x 60'' walk in shower. <br /> The 2nd bdrm features one full size bed and two twin extra large beds. With an attached bathroom, it is almost like having two master bdrms. The bathroom contains a single sink vanity and another 30'' x 60'' walk in shower. With so many beds the whole home can sleep more than 12 comfortably.<br /> As you enter the massive living room area it is complimented by a very large sectional and wall mounted tv. 86" LCD TV. Enjoy movies with the backlit LED lights behind the TV for an immersing theatre experience. <br /> The large kitchen boasts dark stainless steel appliances including dishwasher. Your kitchen prepping is made simple with the huge butcher block center island. The fully remodeled kitchen cabinets are complete with hardware and quiet closing cabinets and drawers. The dining area that sits adjacent to the kitchen seats 10 comfortably for a great family style dinner. Also included in the appliances is a new washer and dryer as well as a 452 pound ice maker. <br /> You will not find a home more meticulously set up with not one option <br /> The remodel was complete and taken down to studs and subfloor, just completed in the summer of 2023. Fully drywalled with high end hand texture. Wood plank laminate flooring throughout entire house. Ceiling fans throughout the whole home. Looks like new a construction home.<br /> All new electrical, all new plumbing, brand new 5 ton HVAC packaged unit with heat pump, brand new dual element electric water heater, brand new 3 stage salt free water filtration softener system, never needs to be serviced <br /> Full Smart Home System so you can control all lights, ceiling fans, HVAC thermostat, and 9 ring cameras, with a phone tablet. Total of 33 dimmable recessed led lights throughout the house.<br /> Brand new 8'X10' tuff shed with 8' high sidewalls and double oversized front doors stores a brand new 4 Burner Outdoor BBQ.<br /> This home is TURNKEY, fully furnished, fully stocked, and completely move in ready for its new owner. Monthly Space Rent $660.
MlsNumber: 1028003


Listing Provided By: eXp Realty, original listing
Name: eXp Realty
Phone: (928) 706-4200
Office Name: eXp Realty
Office Phone: (928) 706-4200
Agent Name: Team RDP
Disclaimer: Copyright © 2024 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