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

34031 Arrowhead Street
Westland, MI 48185

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $218,000
Beds: 3
Baths: 1
Status: Pending
SqFt: 1297
Agency: Remerica Integrity II Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1957
Notes: AGENTS READ THE AGENT ONLY REMARKS PRIOR TO SCHEDULING A SHOWING. This newly renovated 3-bedroom home in Westland boasts a range of modern features and improvements. The kitchen has been upgraded with brand new cabinets, granite countertops, a dishwasher, microwave, and disposal, providing a contemporary and functional space. The dining room seamlessly connects to a four-season room through a door wall, offering versatility for family activities or entertaining guests.<br /> The bathroom has undergone renovations, featuring a new ceramic tile surround shower, a countertop with a sink, and an exhaust fan for enhanced ventilation. Original wood floors in the living room, bedrooms, and hallway have been meticulously sanded and stained, preserving the property's charm. Additionally, new ceramic flooring has been installed in the bathroom, kitchen, and dining room.<br /> The four-season room stands out with its brand new vinyl plank flooring, upscale sliding windows, and a doorwall. This space opens up to a maintenance-free composite platform outdoors, extending the living and entertaining areas.<br /> The property includes a two-car detached garage with a dedicated workroom area. The garage is equipped with a door opener, and a new driveway enhances both functionality and curb appeal. The basement presents an opportunity for further customization, as it is ready to be finished, with plumbing already in place for an additional bathroom.<br /> In summary, this renovated home in Westland combines modern conveniences with thoughtful upgrades, providing a comfortable and aesthetically pleasing living space. The addition of skylights in the four-season room, bathroom and kitchen add lighting to these rooms. The attention to detail in preserving original features while incorporating contemporary elements contributes to the overall appeal of the property.
MlsNumber: 20240007113


Listing Provided By: Remerica Integrity II Realty, original listing
Name: Remerica Integrity II Realty
Phone: (248) 912-9990
Office Name: Remerica Hometown
Office Phone: (734) 459-6222
Agent Name: Lori Emma
Disclaimer: Copyright © 2024 Realcomp Limited II. 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