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

4125 Harbour Cove
Lansing, MI 48911

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $865,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4372 Square Feet
Agency: Berkshire Hathaway HomeServices Tomie Raines
Agency Phone: (517) 351-3617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Along the scenic banks of the Grand River, this stunning all-brick home in Grand Manor Cove, a gated community, offers breathtaking water views through its expansive glass design. Built in 2022, this 5-bedroom, 4.5-bath home spans nearly 4,400 square feet of thoughtfully designed living space, featuring exquisite finishes, bright open areas, and exceptional spaces for both relaxation and entertainment.<br /> <br /> Perfect for multi-generational living, the main floor boasts two bedrooms with a private ensuite bath. Upstairs, two additional bedrooms share a stylishly adjoined bath, complemented by two work or study-at-home stations. The lower level is an entertainer's dream, offering a spacious recreational area ideal for movie nights, game days, or hosting gatherings. Step outside onto the brand-new, full-width patio, and picture yourself sitting out by the water's edge by the firepit, under soft ambient lights, as the moon's glow reflects off the river. What an experience like no other.<br /> <br /> At the heart of the home, a magnificent chef's kitchen showcases an abundance of quartz countertops, stainless steel appliances, and a spacious working island with seatingdesigned to bring everyone together while enjoying the river views. This open, voluminous area connects casual and formal dining, and a welcoming, cozy conversation and lounge space with remote control blinds create a warm and inviting atmosphere.<br /> <br /> The pantry is a room in itselfan absolute dream for anyone who craves additional kitchen prep and storage space. Thoughtfully designed as a secondary kitchen area, this expansive 13.6 x 8.6 room ensures you'll never run out of space for ingredients, small appliances, and entertaining essentials.<br /> <br /> The luxurious primary suite offers stunning river views, a spa-like ensuite bath, and a dream-worthy walk-in closet. A secondary suite on this level also features its own private bath. Custom storage solutions by Closets By Design maximize every inch of space, including a hallway storage area equipped for all your gear, luggage, and seasonal wear. The custom shoe closet is a must-see for sneakerheads and fashion lovers alike!<br /> <br /> The oversized laundry room is both stylish and functional, complete with a washer, dryer, utility sink, shelving, and extensive counter space for folding and organizing. Step into the three-car garage, featuring an epoxy-coated floor, built-in storage racks, and cabinets for ultimate organization.<br /> <br /> Downstairs, the fifth bedroom and fourth full bath provide a private retreat with stunning water views and direct access to the patio through sliding doors. Whether you're looking for a quiet escape by the river or a great place to entertain, this home has it all.
MlsNumber: --
ListingId: 286411


Listing Provided By: Berkshire Hathaway HomeServices Tomie Raines, original listing
Phone: (517) 449-6100
Office Phone: (517) 351-3617
Agent Name: Lisa Fletcher
Disclaimer: Copyright © 2025 Greater Lansing 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.


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 = 3328 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;
Real Estate Expert Photo for BRIAN SUTTON
BRIAN SUTTON
ASCIIEXIT Realty Home Partners
Call Today!: (904) 476-6756

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App