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;

1625 Willoughby Road
Mason, MI 48854
Lynne VanDeventer with Coldwell Banker Realty-Okemos, original listing - (517) 349-4406

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,899,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4264 Square Feet
Agency: Coldwell Banker Realty-Okemos
Agency Phone: (517) 349-4406

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: ''Las Seis Chicas'' Okemos - the rarest of offerings for this one-of-a-kind splitable listing (5 splits in all for a total of 47.05 acres). Journey down the winding quarter of a mile paved driveway past the grazing area for the horses, fenced orchard, thousands of one-hundred-foot-tall Oak, Maple, Cherry, and Hickory trees and arrive at the beautiful home at the center of ''Las Seis Chicas''! This custom built one owner home will not disappoint. From the 190 sq. foot screened-in porch, enhanced raised bed garden, freshwater fully stocked 8-12 ft. deep and swimmable trout pond, to the custom built 3 stall timber framed barn. You will be amazed that every detail has been considered. Beautiful flowers and a limestone sidewalk bring you past a <br /> gurgling water fountain to the solid wood and glass, wrought iron front door. The stunning 2 story great room with its soaring wood ceilings, solid oak hardwood flooring, floor to ceiling windows, wood burning stone fireplace, all open to the large brick walled and wood ceilinged screened-in porch with its panoramic views of the pond, horse corral, and woods. The eating area is amazing with a butler's pantry, a full-length floor to ceiling glass dish cabinet, and a large Stickley solid oak dining table that sits twelve. The kitchen is nestled in a bay window and includes Cambria quartz counter tops and stainless-steel appliances. Enjoy the amazing glass doored walk-in pantry, convenient drop zone, first floor laundry, and half bath. Access to the 650 sq. foot three-stall garage incorporating one of the most amazing, heated <br /> workshop/art studios with its own brick fireplace and wrap around windows overlooking the horse corral and trout pond. The main floor has a rustic reclaimed wood walled billiard room, and a 2,000-book wood ceiling library lit with a large cast iron turn-of-the century (1800's) chandelier. This library is a book lover's dream with high backed red leather chairs in front of a large stone <br /> fireplace and a floor to ceiling ladder system for easy retrieval of even the books at the top of the fourteen-foot-high shelves. The main floor primary suite is framed by large windows showcasing the pond and woods, with direct outside access to a sitting area for your morning coffee or evening tea. A large walk-in closet and private bath with a freestanding tub, heated black granite floors, special wood buffet, and a huge mirror accompany the tiled two-<br /> headed shower with a built-in steamer. The second-floor overlook is dramatic with its 3 additional bedrooms and 2 full baths. The ensuite is amazing with a balcony overlooking the horse corral, gas fireplace T.V room, separate office area, extra sleep room, quaint cubby area, its own bath, and dry bar, plus its own heating and air-conditioning system! The full basement with 9' ceilings is <br /> currently used as a game area and has a Bilco door giving it outside access. The custom-built timber framed drive through barn is a one of a kind with a staircase to the hayloft. Two horse stalls (could easily be 3-5 horse stalls), hot and cold water, cedar-shake roof, full Maple syrup operation, and separate timber-framed woodshed for housing tractors, mowers, and split firewood. "Las Seis Chicas" truly is a lifestyle. It involves cutting firewood for the wooden hot bucket, Maple Syrup Operation, outside fire pit, and two stone fireplaces. It includes long walks on over a mile of the many trails that cut through dense forest, wetlands, and open meadows. It includes catching rainbow trout in a beautiful deep pond just outside your back door. Whether <br /> riding horses year-round, harvesting trophy whitetail deer and wild turkeys in the fall, tapping Maple trees in the spring snow, picking fresh fruit or berries from the orchard, finding morels in the springtime or reading a good book in front of a roaring fire in the library, the "Las Seis Chicas" is the premium experience. In the Okemos school district, just minutes away from MSU, shopping and restaurants, "Las Seis Chicas" provides the owner with a lifestyle that is unmatched in Southern Michigan. Starlink Internet service. House, Barn, and Woodshed 14.34 acres. Eastwoods 10.1 acres. Vacant lot on Willoughby Rd. 2 acres. Meadows off of Willoughby Rd. 7 acres. Hay field and large pasture 13.61 acres. For a total of 47.05 acres. See listing agent for flexibility in different splits.
MlsNumber: --
ListingId: 282880


Listing Provided By: Coldwell Banker Realty-Okemos, original listing
Phone: (517) 492-3274
Office Phone: (517) 349-4406
Agent Name: Lynne VanDeventer
Disclaimer: Copyright © 2024 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;
Feldpausch Brewster Team
Call Today!: (517) 668-6705

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App