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;

1050 Vistanna
Marquette, MI 49855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,690,000
Beds: 4
Baths: 4
Status: Active
SqFt: 5789
Agency: Coldwell Banker Schmidt Family Of Companies

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: This executive home features 6750 sq. ft. Conveniently located in the exclusive Orianna Hills neighborhood on Vistanna Drive and adjoining the 15th green of Marquette Golf Club. 4- Large bedrooms as well as 4- Bathrooms. An expansive kitchen lined with high end cherry cabinetry, includes a walk in pantry, and 4- seat dining at the island. Ultra high end Thermador appliances throughout. Seating for 10 in the bright and spacious formal Dining room. 24' ceilings in the Great Room showcase an equally impressive 20' domed front window. This immense window nurtures a spectacular interior rock garden with live trees. A formal Sitting Room allows you to entertain guests while awaiting dinners completion. A gas fireplace for ambience. You'll find imported Teak woodwork and white marble floors throughout this home. Your feet will remain toasty with its in-floor heat. Primary Suite consists of 3 separate rooms. A large bedroom area, executive office space and a spacious private bathroom. The bathroom features a large walk-in shower and boasts multiple shower heads plus steam for relaxing on the built-in bench. There is also a high end 2 person jetted spa tub for a good long soak after a hard day. There are 2 additional large bedrooms on main floor that share a common bathroom. A Laundry room and Meditation room round out the main floor. The basement floor consists of the 4th bedroom with full bathroom, a huge Living room area, an expansive Gym room and your very own Home Theater! Theater was professionally designed and is acoustically correct for 7.1 surround sound. Tiered leather seating for 5. Mechanical room and loads of additional storage space round out the basement 1100 sq. ft. garage space for your convenience. Conveniently located for easy access to downtown Marquette, the hospital and college, adjoining the golf course and within 1/2 mile of the Noquemenon Trail Network. Add Lake Superior and high speed internet; what more could you ask for!!!
MlsNumber: 50105038


Listing Provided By: Coldwell Banker Schmidt Family Of Companies, original listing
Name: Coldwell Banker Schmidt Family Of Companies
Office Name: Schmidt Realtors
Office Phone: (906) 225-5992
Agent Name: Daniel Menard
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt 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