Skip main navigation
Off market
Street View
  • $959,700

    400 County Road 480, Marquette, MI 49855

    7beds
    5,485sqft
    SingleFamily
    Built in 1975
    17.59 Acres Lot
    $959,700 Zestimate®
    $175/sqft
    $4,648 Estimated rent

    Home value

    $959,700

    $854,000 - $1.08M

    $4,648/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,648/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,648/mo

    Rent Zestimate®

    Refinance and save

    $5,955/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $5,955/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    One of kind property offering a true Northwoods lifestyle. This custom built home is situated on over 17 acres of wooded privacy offering a huge fully fenced, park like yard with old growth red and white pines, a basketball court (half-court) and many maintained trails which connect to local snowmobile, ATV, horseback riding and biking trails. Kids will love the 12x15 playhouse and the little "fishing" dock at the creek! With over five thousand feet of living space this is a home you and your family can grow into, creating many happy and fond memories this unique property makes possible. Inside you will find a new Schwalbach kitchen with a massive granite island, all new GE appliances, under counter lighting, recessed lighting and accent lighting. Beautiful solid hickory wood flooring has recently been installed throughout the kitchen, dining room, entry and living room. The 30x17 great room offers a massive Lake Superior stone fireplace, built in bookcases and entertainment area and a huge bay window with seating that overlooks the crystal clear waters of Cedar Creek. Off the great room is a 15x13 three season room with direct access to the 1,700 sq. ft deck with built in seating, raised flower beds, and a firepit. The main floor of this home offers a guest suite complete with a full bath, walk-in closet and office area, a large laundry room with newer flooring and tub, a formal living room with gas fireplace, formal dining area, two mudrooms and a newly remodeled half bath. Upstairs you will find a huge master bedroom with large windows overlooking the water, his and her walk-in closets and large master bath with spa tub and tiled walk in shower. There's plenty of room for company as there are an additional five bedrooms several of which are quite spacious and offer built in beds, desk areas and plenty of storage. The lower level of this home has an exercise area, sauna, tub and cedar shower. Your family will love the 30x17 theater room complete with theater style seating and Devon surround sound! In addition you'll find a 37x12 shop area with staircase to the garage, a wood boiler which is connected to the natural gas boiler for auxiliary heating. For indoor fun you can hone your shooting skills in the interior shooting gallery perfect for small caliber shooting practice! You will have plenty of room for all your trucks, autos, snowmobiles and all other outdoor toys and equipment in the separate six car garage (with electricity), pole building and barn. There are two wells with one being a short distance back on the property where there is a private parking area for a recreational vehicle with a separate underground electric service to hook up to. The attached 50x30 garage offers built-in work benches, plenty of shelving, 20x6 covered woodshed, 19x13 utility/gardening shed, chimney for wood stove and a built-in dog house! All this located within minutes of Marquette, 15 minutes to Sawyer International Airport or Marquette.

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 7
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Other, Electric, Gas
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Range / Oven, Refrigerator, Washer
    Features
    • Basement: Partially finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 5,485 sqft

    Property

    Parking
    • Parking features: Garage - Attached, Garage - Detached
    Features
    • Exterior features: Wood
    Lot
    • Size: 17.59 Acres
    Details
    • Parcel number: 520211900210

    Construction

    Type & style
    • Home type: SingleFamily
    Condition
    • Year built: 1975

    Community & HOA

    Location
    • Region: Marquette

    Financial & listing details

    • Price per square foot: $175/sqft
    • Tax assessed value: $859,800
    • Annual tax amount: $7,327

    Price history

    DateEventPrice
    1/15/2016Sold$490,000-12.3%$89/sqft
    Source: Agent Provided Report a problem
    11/18/2015Price change$559,000-5.1%$102/sqft
    Source: Coldwell Banker Schmidt, Realtors #1090059 Report a problem
    9/5/2015Listed for sale$589,000+156.1%$107/sqft
    Source: Coldwell Banker Schmidt, Realtors #1090059 Report a problem
    6/11/1998Sold$230,000$42/sqft
    Source: Agent Provided Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$7,327 +4.6%$429,900 +7.2%
    2024$7,006 $401,200 +16.5%
    2023-- $344,500 +23.7%
    2022-- $278,500 +5.2%
    2021-- $264,700 +2.5%
    2019-- $258,300 +6.3%
    2018-- $243,000 +2.5%
    2017-- $237,000 +13.3%
    2016-- $209,200
    2015-- $209,200 -6%
    2014-- $222,500 +11.1%
    2012-- $200,300 -5.2%
    2011-- $211,300
    2010-- $211,300
    Find assessor info on the county website

    Neighborhood: 49855

    Nearby schools

    GreatSchools rating
    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.