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

714 Horizons
Marquette, MI 49855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $719,900
Beds: 5
Baths: 4
Status: Active
SqFt: 2079
Agency: COLDWELL BANKER SCHMIDT REALTORS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2017
Notes: Welcome to your Harlow Farms "Dream Home". This custom built 5- bedroom, 3.5- bath home nestled in amongst the Horizons Premier Single Family Homesites is exactly what you have been searching for. Built in 2017 by Sunrise Builders, this home is sure to check all the boxes. The main floor consists of a large open concept area which encompasses the kitchen (with eat-at island and walk in pantry), dining and living rooms. Main floor laundry facilities and mud room, 1/2 bath and the first bedroom. This floor also offers stunning views from the elevated, enclosed custom sun porch overlooking the beautifully wooded ravine. Sit and sip your morning coffee or relax and unwind with an evening beverage as you watch the local deer meander through. The upstairs floor offers 3- large bedrooms and 2- full bathrooms. The Primary Suite consists of an expansive bedroom, large walk-in closet, and a beautifully designed tile and glass master bathroom with oversized walk-in shower. A balcony view overlooks the front entrance atrium area. The basement space offers a large Recreation Room with walk-out access to the back yard. There is also a 5th bedroom and the 3rd full bathroom. The basement space is rounded out by the mechanical/storage room as well as an additional overflow storage room. This home is beautifully designed and professionally landscaped to seamlessly blend with the natural backyard ravine landscape. A multi zoned sprinkler system encompasses the entire lot for added convenience. Harlow Farms is truly Marquette's crown jewel community development. It offers Premier Homesites, Condominiums, Townhomes, Assisted Living, Memory Care and Senior Independent Living. There are over 25 acres of conservation areas which encompass protected ponds and creeks. Community areas include a 2,200 square foot Neighborhood Center, and a children's playground. Harlow Farms boasts its own internal trail system and offers easy access to the Iron Ore Heritage Trail as well as a trail connection to the Noquemanon South Trail Network. Conveniently located for a minimal commute to all things Marquette. Easy access to the Hospital, College, Shopping, Downtown night life and let us not forget our majestic Lake Superior. This magnificent home within the Harlow Farms Conservation Community is everything you have been searching for and more!!! Schedule your own personal visit today. Owner requires occupancy through 6/15/24. Open House scheduled to occur on Saturday 4/27 from 1-4pm. All offers due by Saturday 4/27 at 6pm with an response by 12 noon 4/28.
MlsNumber: 50139412


Listing Provided By: COLDWELL BANKER SCHMIDT REALTORS, original listing
Name: COLDWELL BANKER SCHMIDT REALTORS
Phone: (906) 225-5992
Office Name: COLDWELL BANKER SCHMIDT REALTORS
Office Phone: (906) 225-5992
Agent Name: DANIEL MENARD
Disclaimer: Copyright © 2024 Upper Peninsula 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App