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

57439 Meadowridge Drive
Washington, MI 48094

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $958,800
Beds: 4
Baths: 4
Status: Active
SqFt: 4361
Agency: Arterra Realty Michigan LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: QUICK OCCUPANCY: AUGUST 2024! Under construction. This ''Kirkwood'' 3 bed and 3.5 bath Ranch, showcases 4,400+ square feet of finished living space, including a finished lower-level. Home is adorned with top-tier finishes, Wood Flooring and Quartz CT throughout the entirety of the house. Gourmet-style kitchen with premium cabinets,SS appliances, a custom wood hood, and a bev center. With 10' ceilings and 8' doors interiors. Premium vanities, large shower and Freestanding tub in the Owner's Bath. Premium lighting and plumbing fixtures. Oversized 2-car garage with storage. Please note that the photos shown are of previously completed home. Price includes SS appliances, Sod and sprinklers and front landscaping. Builder is offer 2% Seller Credit on the base price if you use Lock Lending. QUICK OCCUPANCY: AUGUST 2024! Currently under construction... This exquisite "Kirkwood" Ranch, boasting 3 bedrooms and 3.5 baths, showcases an expansive 4,400+ square feet of finished living space, including a fully finished lower-level. The residence is adorned with top-tier finishes, continuous Wood Flooring and Quartz counter-tops throughout the entirety of the house. Gourmet-style kitchen with premium cabinets,SS appliances, a custom wood hood, and a beverage center. With 10-foot ceilings and 8-foot doors gracing the interiors. Owner's Suite is finished with stepped ceiling with beams and 2 WIC finished with custom shelvings. Premium vanities, large shower and Freestanding tub in the Owner's Bath. Premium lighting and plumbing fixtures throughout. Oversized 2-car garage with storage. Please note that the photos shown are of previously completed home. This SPEC home will be the same floor plan, similar front elevation and finished basement. Price includes stainless steel appliances, Sod and sprinklers and front landscaping! Arteva Lassale is offer a 2% Seller Credit on the base price if you use Lock Lending for financing!
MlsNumber: 24004066


Listing Provided By: Arterra Realty Michigan LLC, original listing
Name: Arterra Realty Michigan LLC
Phone: (248) 731-0048
Office Name: Arterra Realty Michigan LLC
Office Phone: (248) 731-0048
Agent Name: Kenny Lanzar
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3329 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Carmita Ballard
ASCIIeXp Realty
Call Today!: (248) 910-1379

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App