NOT LISTED FOR SALE

3781 Shellmarr Ln Bloomfield Hills, MI 48302

Estimated Value: $959,625 - $1,053,000

5 Beds
5 Baths
4,042 Sq Ft
$245/Sq Ft Est. Value

Last Sold July 05, 2023

Last sale price $920,000 $228 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $6,243/month

31 Days on Market

Highlights

  • Built-In Refrigerator
  • Colonial Architecture
  • Double Oven
  • South Hills Middle School Rated A
  • No HOA
  • Enclosed patio or porch

About This Home

As of July 2023

Welcome to this stunning colonial home, where timeless elegance meets modern luxury. As you step through the front door, you'll be greeted by the warmth of the hardwood floors, ceramic and slate that flow throughout the main floor, creating a beautiful transition from room to room. The updated kitchen is a chef's dream, featuring top-of-the-line appliances, granite countertops, and ample storage space. The adjacent living room, dining room, and family room provide plenty of space for entertaining guests or relaxing with family. Fully renovated main floor laundry room with tons of storage. Two half bathrooms on the main floor.
One of the highlights of this home is the three-season room, where you can enjoy the beauty of the surrounding landscape without the intrusion of bugs or inclement weather. Speaking of the landscaping, it's simply stunning, with lush greenery, colorful flowers, and well-manicured lawns. Upstairs, the primary suite is a luxurious retreat, complete with walk-in closets, a limestone primary bath, shower and tub, and double sinks. Upstairs, there are four more bedrooms, each with its own unique charm. One is a suite complete with full bathroom and walk-in closet. The fifth bathroom has laundry hookup to convert to a second floor laundry room if desired. The finished basement offers additional living space and can be used for a variety of purposes, from a home theater to a home gym. With so much space and luxury, this colonial home is the perfect place to create lasting memories with your loved ones.

Last Listed By

Renee Orlewicz

Cedarwood Realty LLC, a Michigan LLC License #6501400167 Listed on: 05/05/2023

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1964

Lot Details

  • 0.61 Acre Lot
  • Lot Dimensions are 114x215x207x169
  • Sprinkler System

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Asphalt Roof
  • Stone Siding

Interior Spaces

  • 4,042 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Finished Basement
  • Sump Pump

Kitchen

  • Double Oven
  • Built-In Gas Oven
  • Electric Cooktop
  • Range Hood
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Additional Features

  • Enclosed patio or porch
  • Ground Level

Community Details

  • No Home Owners Association
  • Peabody Orchards No 1 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1928226003

Home Details

Home Type

Single Family

Est. Annual Taxes

$13,910

Year Built

Built in 1964

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Year Built: 1964
  • State Equalized Value: 432300.0000
  • Foundation Features: Sump Pump
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Fireplace: Yes
  • Fireplace Locations: Family Room, Living Room
  • Room Count: 17
  • Total Bedrooms: 5
  • Total Bathrooms: 3.20
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Built-In Gas Oven, Built-In Refrigerator, Dishwasher, Disposal, Double Oven, Dryer, Electric Cooktop, Microwave, Range Hood, Washer
  • Sq Ft Combined: 4874
  • Sq Ft Lower Floor: 832
  • Total Sq Ft: 4042
  • Sq Ft Total Bsmt: 1276

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick, Stone
  • Construction Features: Platted Sub.
  • Foundation Materials: Block
  • Frontage Feet: 114
  • Porch Type: Porch - Enclosed, Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 3 Car
  • Garage Features: Electricity, Door Opener, Side Entrance, Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Bloomfield Hills

Lot Info

  • Homestead: Yes
  • Lot Features: Sprinkler(s)
  • Lot Size Area: 0.61
  • Lot Dimensions: 114x215x207x169
  • Parcel Number: 1928226003

Tax Info

  • Tax Amount Summer: 7115.0000
  • Tax Amount Winter: 6795.0000
  • Total Tax: 13910.0000
  • Taxable Value: 372720.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 5, 2023
Closed on
Jul 6, 2023
Sold by
Silver Scott and Silver Alyssa
Bought by
Schafer Marc B and Schafer Elizabeth A
Seller's Agent
Renee Orlewicz
Cedarwood Realty LLC, a Michigan LLC
Buyer's Agent
Grant Berakovich
Max Broock, REALTORS®-Birmingham
List Price
$989,000
Sold Price
$920,000
Premium/Discount to List
-$69,000
-6.98%
Total Days on Market
31
Views
102
Current Estimated Value
$989,656

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$69,656
Avg. Annual Appreciation
4.33%

Purchase Details

Listed on
Jul 12, 2018
Closed on
Sep 21, 2018
Sold by
Forbes Timothy G and Forbes Suzy G
Bought by
Silver Scott and Silver Alyssa
Seller's Agent
Meredith Colburn
The Agency Hall & Hunter
Buyer's Agent
Michael Solan
Max Broock, REALTORS®-Bloomfield Hills
List Price
$725,000
Sold Price
$685,000
Premium/Discount to List
-$40,000
-5.52%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.35%
Original Mortgage
$516,000
Interest Rate
4.5%
Mortgage Type
New Conventional

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Schafer Marc B $920,000 None Listed On Document
Silver Scott $685,000 Equity Title Agency Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Silver Scott $489,000
Previous Owner Silver Scott $516,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/05/2023 07/05/23 Sold $920,000 -5.1% $228 / Sq Ft
06/06/2023 06/06/23 Pending -- -- --
05/28/2023 05/28/23 Price Changed $969,000 -2.0% $240 / Sq Ft
05/05/2023 05/05/23 For Sale $989,000 +44.4% $245 / Sq Ft
09/21/2018 09/21/18 Sold $685,000 -5.5% $168 / Sq Ft
07/30/2018 07/30/18 Pending -- -- --
07/12/2018 07/12/18 For Sale $725,000 -- $177 / Sq Ft
Source: Realcomp

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $8,762 $470,730 $0 $0
2023 $7,402 $451,030 $0 $0
2022 $13,910 $432,300 $0 $0
2021 $13,811 $386,410 $0 $0
2020 $6,770 $363,380 $0 $0
2019 $12,994 $349,210 $0 $0
2018 $10,268 $316,700 $0 $0
2017 $10,196 $311,410 $0 $0
2016 $10,213 $310,340 $0 $0
2015 -- $306,500 $0 $0
2014 -- $284,580 $0 $0
2011 -- $239,190 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in the area

  • 4747 Keithdale Ln, Bloomfield Hills, MI 48302

    $898,500

    • 4 Beds
    • 4.5 Baths
    • 3,932 Sq Ft
    • 4747 Keithdale Ln
    • Bloomfield Hills, MI

    Prime Bloomfield Twp location with Bloomfield Hills Schools! Nestled in a stunning park-like setting, this exceptional quad-level home welcomes you with a circular drive. Inside, the spacious living room features a cozy fireplace, hardwood floors, and abundant natural light, while the elegant dining room boasts marble floors and a built-in lighted display case. The large kitchen is a chef’s

    Alyse Robertelli Max Broock, REALTORS®-Bloomfield Hills

    Section Image
  • 2725 Endsleigh Dr, Bloomfield Hills, MI 48301

    $1,195,000

    • 5 Beds
    • 6 Baths
    • 3,497 Sq Ft
    • 2725 Endsleigh Dr
    • Bloomfield Hills, MI

    This magnificent five bedroom, three full and three half bath brick colonial is located in the well coveted Bloomfield Village subdivision. This fabulous home features 3500 square feet of above ground living, including an updated kitchen with large center island, quartz counters and high-end appliances, hardwood floors, large family room with built-ins and a brick fireplace, 2nd floor laundry,

    John Apap @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 2725 Endsleigh Dr, Bloomfield Hills, MI 48301

    $1,095,000

    • 5 Beds
    • 6 Baths
    • 3,497 Sq Ft
    • 2725 Endsleigh Dr
    • Bloomfield Hills, MI

    This magnificent five bedroom, three full and three half bath brick colonial is located in the well coveted Bloomfield Village subdivision. This fabulous home features 3500 square feet of above ground living, including an updated kitchen with large center island, quartz counters and high-end appliances, hardwood floors, large family room with built-ins and a brick fireplace, 2nd floor laundry,

    John Apap @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 4678 Brightmore Rd, Bloomfield Hills, MI 48302

    $880,000

    • 5 Beds
    • 4 Baths
    • 3,151 Sq Ft
    • 4678 Brightmore Rd
    • Bloomfield Hills, MI

    This stunning 5-bedroom, 4-bathroom home offers over 3,100 square feet of living space, plus an additional 860 square feet in the beautifully finished basement. Nestled on a desirable corner lot, the property boasts lush landscaping and exceptional curb appeal. With four levels of spacious living, this home features multiple gathering areas, including a family room with a gas fireplace, wet bar,

    Kathy Coon BHHS Michigan RE Great Lakes RH

    Section Image
  • 4170 Echo Rd, Bloomfield Hills, MI 48302

    $799,000

    • 4 Beds
    • 5 Baths
    • 5,166 Sq Ft
    • 4170 Echo Rd
    • Bloomfield Hills, MI

    CONTEMPORARY HOME WITH 300 FEET OF SECLUDED ECHO ROAD FRONTAGE, BROUGHT BACK TO LIFE. READY FOR A NEW OWNER TO LIVE UNDER THE 7 LARGE SKYLIGHTS PROVIDING A MOST NATURAL LIVING ENVIRONMENT. THE MOVING SUN WARMS THE TRAVERTINE STONE FLOORING IN AN OPEN FLOOR PLAN. FOUR SPACIOUS BEDROOMS WITH THE MASTER BEDROOM SUITE ALONG WITH A SEPARATE BEDROOM SUITE BOTH NEWLY CARPETED ON THE ENTRY LEVEL. THE

    Tom Meyer MTV Realty LLC

    Section Image
  • 4511 Lakeview Ct, Bloomfield Hills, MI 48301

    $775,000

    • 5 Beds
    • 4 Baths
    • 2,618 Sq Ft
    • 4511 Lakeview Ct
    • Bloomfield Hills, MI

    #WelcomeHOM to 4511 Lakeview! Bring your vision to this 5-bed, 4-bath colonial situated amongst multi-million dollar homes on a beautiful, private cul-de-sac. Set on a level .78 acre lot, with Wing Lake privileges and Bloomfield Hills schools. The home has tasteful upgrades throughout such as a bricked patio, two gas fireplaces and a master suite & bath with spa tub and heated flooring. Below,

    Dade DiMaggio House Of May

    Section Image
  • 630 Willow Glen Ct, Bloomfield Hills, MI 48304

    $960,000

    • 4 Beds
    • 4 Baths
    • 3,716 Sq Ft
    • 630 Willow Glen Ct
    • Bloomfield Hills, MI

    Wow, wow, wow. Welcome to this Bloomfield Hills 3700 square-foot brick walkout colonial sitting on a 1.7-acre wooded lot. This home is something special. Extremely well-maintained with minimal traffic on a cul-de-sac, shared by two other homes. The property offers an amazing layout with a large kitchen, a two-story great room, a living room, dining room and office all on one floor. Home has

    Mike Sher Max Broock, REALTORS®-Bloomfield Hills

    Section Image
  • 1535 W Long Lake Rd, Bloomfield Hills, MI 48302

    $875,000

    • 4 Beds
    • 5 Baths
    • 5,556 Sq Ft
    • 1535 W Long Lake Rd
    • Bloomfield Hills, MI

    BREATHTAKING SOFT CUSTOM CONTREMPORARY HOME WITH LONG CIRCULAR DRIVEWAY, 4 CAR GARAGE & PRIME LOCATION IN BLOOMFIELD HILLS SCHOOL DISTRICT ON 1.21 ACRE HUGE LOT. ELEGANTLY DESIGNED CUSTOM BUILT 5,556 SQ. FT WITH ROUNDED MARBLE FOYER CUSTOM 1ST FLOOR MASTER STE W/ JACUZZI & SAUNA & GRANITE MASTER BATH. 2ND FLOOR CURVED SHAPE LIBRARY W/ 11 WINDOWS. INCREDIBLE KITCHEN WITH GRANITE COUNTERTOPS &

    Jonathan Minerick HomeCoin.com

    Section Image
  • 1769 S Golf Ridge Dr, Bloomfield Township, MI 48302

    $1,199,000

    • 4 Beds
    • 5 Baths
    • 3,668 Sq Ft
    • 1769 S Golf Ridge Dr
    • Bloomfield Township, MI

    This stunning, like-new colonial is an absolute must-see! Featuring four spacious bedrooms and five beautifully appointed bathrooms (3 full and 2 half), this home is a true masterpiece. The custom kitchen boasts exquisite cabinetry, granite countertops, and top-of-the-line Thermador stainless steel appliances, all complemented by recessed and under-cabinet lighting. Gleaming hardwood floors flow

    Syeda Fatmi Berkshire Hathaway HomeServices Kee Realty Bham

    Section Image

Source: Realcomp

MLS Number: 20230026761

Realcomp

APN: 19-28-226-003