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

7880 Vernier
Fair Haven, MI 48023-2441
Joe Militello with EXP Realty LLC, original listing - (269) 600-4397

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $430,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1426 Square Feet
Agency: EXP Realty LLC
Agency Phone: (269) 600-4397

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Welcome to 7880 Vernier Lane, Fairhaven, MI 48023 New Construction Waterfront Home – Your Dream Awaits! Completion in the next 30 - 45 days. Experience luxurious waterfront living in this brand-new construction home located on a serene canal in the heart of Fairhaven, Michigan. This stunning property offers direct access to the St. Clair River and Lake St. Clair, making it a perfect haven for boating, fishing, and enjoying the water. Designed with modern elegance and functionality in mind, this home features a spacious open-concept layout, ideal for both family living and entertaining. High-end finishes are showcased throughout, including brand new appliances, and stylish fixtures, all complemented by expansive windows that flood the home with natural light and offer breathtaking water views. The outdoor space is equally impressive, with a large deck, nice size yard, and a private covered boat slip, perfect for those who love spending time on the water. Energy-efficient construction and smart home features ensure modern comfort and convenience, while the spacious garage adds extra practicality with all the extras included. The garage is completely finished with insulation, drywall and insulated 8-foot-high garage doors, an option you never get with the traditional home. The bonuses are the extra garage door giving access to the yard, and the garage was also designed and fitted with a half bath (to be complete) and gas line that can be used for that summer cabana style living. This property was designed with the boater lifestyle in mind! Additional parking space on the side of garage for a vehicle, boat or trailer. This exceptional home offers the perfect combination of tranquil waterfront living and contemporary luxury. Built for 3 bedrooms but is currently set up as 2. Don’t miss your chance to own a brand-new home in the sought-after Fairhaven area.
MlsNumber: --
ListingId: 50164881


Listing Provided By: EXP Realty LLC, original listing
Phone: (586) 914-4001
Office Phone: (269) 600-4397
Agent Name: Joe Militello
Disclaimer: Copyright © 2025 Multiple Listing Service MiRealSource. 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