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

25364 Sutton Court
Novi, MI 48374
Craig Killgrove with Real Estate One-Plymouth, original listing - (734) 455-7000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $739,900
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2350 Square Feet
Agency: Real Estate One-Plymouth
Agency Phone: (734) 455-7000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Condominium
Year Built: 2011
Notes: Kirkway Place of Novi Welcomes you to this Beautiful and Rare Detached Condo Ranch Home. As you Step in through the Front Door the Front Foyer with Hardwood Flooring and High Ceilings welcomes you. The Chefs Kitchen features Granite Countertops, Ceramic Tile Backsplash, Built-in Gas Cook-Top, Double Oven, Walk-in Pantry and an expanded Breakfast Bar. Dining area is very Bright with Natural light that is enhanced from the Large Windows and Glass Door-wall. The Great Room features a Gas Fireplace, Cathedral Ceiling featuring Crown Molding that continues throughout the Home. Massive Master Suite with a Spa-like Bathroom featuring a Large Walk-in Shower w/Sitting Bench and Very large Walk-In Closet. Beautiful Study features Custom Draperies a Sitting Window adding an Abundance of Natural Light along with the Immaculate Hardwood Floors that flow throughout the home. You will have many years of entertaining Family or Guest on the maintenance free Large Trex Deck. The Daylight Basement is already Plumbed for a Bathroom, just waiting to be finished per your ideas. Kirkway Place has Water Fountains, Walkways and Gazebo for you to enjoy along with the Worry-Free Living of Lawn Service, Snow Removal and outdoor maintenance is included!
MlsNumber: --
ListingId: 20250011282


Listing Provided By: Real Estate One-Plymouth, original listing
Phone: (734) 740-8323
Office Phone: (734) 455-7000
Agent Name: Craig Killgrove
Disclaimer: Copyright © 2025 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