NOT LISTED FOR SALE

477 Shelbourne Rd Grosse Pointe Farms, MI 48236

Estimated Value: $450,250 - $784,000

3 Beds
2 Baths
2,626 Sq Ft
$210/Sq Ft Est. Value

Last Sold July 31, 2017

Last sale price $350,100 $133 Per Sq Ft

Est. 58% increase in value since last sale

Current estimated payment $3,314/month

8 Days on Market

Highlights

  • Ranch Style House
  • Cathedral Ceiling
  • 2 Car Attached Garage
  • John Monteith Elementary School Rated A-
  • Wood Flooring
  • Walk-In Closet

About This Home

As of July 2017

Well-maintained Cox & Baker Brick Ranch; Beautiful Windows throughout; Hardwood Floors; Updated Kitchen and Baths; Dimensional-Shingle Roof; Master Suite w Bedroom, Shower-Bath & Walk-in closet; Living Room and Family Room with Gas Fireplace. Basement with Glass Block Windows, Recreation Room, Kitchen, and Half-bath, Furnace Room, Laundry Room and Storage Rooms. Includes All Appliances. Easy-maintenance lush green landscaping. Move-in Ready!

Last Listed By

Ruth Ellen Mayhall

Adlhoch & Associates, REALTORS License #MISPE-6501263264 Listed on: 06/21/2017

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,727

Year Built

  • Built in 1951

Lot Details

  • 0.27

Parking

  • 2 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction

Interior Spaces

  • Cathedral Ceiling
  • Gas Fireplace
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Partially Finished Basement
  • Block Basement Construction

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Utilities

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

Additional Features

  • Patio
  • Lot Dimensions are 98 x 120

Listing and Financial Details

  • Assessor Parcel Number 38-001-09-0148-000

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,727

Year Built

Built in 1951

Lot Details

0

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • Year Built: 1951
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Cathedral/Vaulted Ceiling, Ceramic Floors, Hardwood Floors, Walk-In Closet
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: FamRoom Fireplace, Gas Fireplace, LivRoom Fireplace
  • Basement: Yes
  • Basement: Block, Partially Finished
  • Bedrooms: 3
  • Bedroom 1: On Entry Level, Dimensions: 16 x 12
  • Bedroom 1 Floor Covering: Wood
  • Bedroom 2: On Entry Level, Dimensions: 12 x 10
  • Bedroom 2 Floor Covering: Wood
  • Bedroom 3: On Entry Level, Dimensions: 12 x 10
  • Bedroom 3 Floor Covering: Wood
  • Bathrooms Description: Basement Lavatory, First Flr Full Bathroom
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Below Grade Bedrooms: 1
  • Bathroom 1: Dimensions: 8 x 7, On Level: Entry, Flooring: Marble
  • Bathroom 2: Dimensions: 7 x 6, On Level: Entry, Flooring: Ceramic
  • Room Types: Family Room, First Floor Bedroom, First Floor Mstr Bedroom, Living Room
  • Dining Room: On Entry Level, Dimensions: 15 x 12
  • Dining Room Floor Covering: Wood
  • Family Room: On Entry Level, Dimensions: 14 x 12
  • Kitchen: On Entry Level, Dimensions: 19 x 9
  • Kitchen Features: Eat-In Kitchen, Formal Dining Room
  • Kitchen Floor Covering: Ceramic
  • Living Room: On Entry Level, Dimensions: 19 x 15
  • Living Room Floor Covering: Wood
  • Below Grade Sq Ft: 1630
  • Finished Below Grade Sq Ft: 800
  • Above Grade Finished Sq Ft: 1826
  • Total Finished Sq Ft: 2626

Exterior Features

  • Exterior: Brick
  • Exterior Features: Patio, Sidewalks, Storms/Screens, Street Lights
  • Foundation: Basement
  • Frontage: 98
  • Road: Paved Street

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 2
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public At Street
  • Water: Public Water at Street
  • Water Heater: Gas
  • Cooling: Central A/C

Lot Info

  • Assessor Parcel Number: 38-001-09-0148-000
  • Zoning: Residential
  • Lot Dimensions: 98 x 120
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2016, Amount: $2,999.23
  • Winter Tax: Year: 2016, Amount: $2,728.14

MLS Schools

  • School District: Grosse Pointe Public Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 14, 2020
Sold by
Brennan James P and Brennan Cheryl
Bought by
Brennan Emily C and Brennan James P
Total Days on Market
8
Current Estimated Value
$552,063

Purchase Details

Listed on
Jun 21, 2017
Closed on
Jul 31, 2017
Sold by
Weiss Charles P and Weiss James R
Bought by
Brennan James P
Seller's Agent
Ruth Ellen Mayhall
Adlhoch & Associates, REALTORS
List Price
$350,000
Sold Price
$350,100
Premium/Discount to List
$100
0.03%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.39%

Purchase Details

Listed on
Jun 21, 2017
Closed on
Jun 1, 2017
Sold by
Mayhall Ruth Ellen
Bought by
Weiss Charles P
Seller's Agent
Ruth Ellen Mayhall
Adlhoch & Associates, REALTORS
List Price
$350,000
Sold Price
$350,100
Premium/Discount to List
$100
0.03%

Purchase Details

Closed on
Jan 25, 2001
Sold by
Weiss James R
Bought by
Weiss James R

Purchase Details

Closed on
Mar 27, 2000
Sold by
Weiss Anne M
Bought by
Weiss James R
Source: Public Records

Similar Homes in Grosse Pointe Farms, MI

  • 484 Bournemouth Cir, Grosse Pointe Farms, MI 48236

    $425,000

    • 3 Beds
    • 2.5 Baths
    • 2,746 Sq Ft
    • 484 Bournemouth Cir
    • Grosse Pointe Farms, MI

    Owner stated this IS the easiest home to maintain & run of all the homes that she has ever owned--and it will be sorely missed! Convenient, 1 floor living in this well updated ranch style home. Located, on a winding street that offers tranquility in Grosse Pointe Farms. Checkout the great kitchen & lovely living room with a fireplace. Newer: roof, furnace-a/c, and the hardwood floors were

    Dino Ricci Sine & Monaghan LLC

    Section Image
  • 441 Roland Rd, Grosse Pointe Farms, MI 48236

    $440,000

    • 3 Beds
    • 2.5 Baths
    • 1,524 Sq Ft
    • 441 Roland Rd
    • Grosse Pointe Farms, MI

    This beautifully updated home offers the perfect balance of classic style and modern convenience. Bathed in natural light and full of charm, it features eye-catching curb appeal, a well-designed layout, gleaming hardwood floors, and a lush, private backyard surrounded by a fence and gated entry. Upon entering, you're welcomed by a refined foyer that opens to both the formal dining and living

    Future Davis EXP Realty Main

    Section Image
  • 292 Chalfonte Ave, Grosse Pointe Farms, MI 48236

    $444,900

    • 4 Beds
    • 2 Baths
    • 2,713 Sq Ft
    • 292 Chalfonte Ave
    • Grosse Pointe Farms, MI

    ***FINAL & BEST OFFERS DUE TUESDAY MAY 20 @ 10AM*** Spacious and charming, this Tudor-style cottage welcomes you with distinctive brickwork, fresh landscaping, and solid wood front door, with its leaded glass detail. Step through the vestibule into a foyer that opens up to light-filled living and dining rooms surrounded by graceful archways, layered plaster crown moldings, ceiling rosettes,

    Charles Krasner Sine & Monaghan LLC

    Section Image
  • 366 Belanger Ave, Grosse Pointe Farms, MI 48236

    $599,000

    • 3 Beds
    • 3 Baths
    • 3,354 Sq Ft
    • 366 Belanger Ave
    • Grosse Pointe Farms, MI

    Welcome to this cozy 3-bedroom bungalow, featuring a warm living room with a fireplace and custom built-in bookshelves. Enjoy entertaining in the formal dining room and cooking in the gorgeous kitchen, complete with granite countertops, custom cabinetry, and beautiful hardwood floors throughout. The main level offers two spacious bedrooms, while the upstairs boasts a huge primary suite with two

    Mary Aubrey-Rogers Sine & Monaghan LLC

    Section Image
  • 480 Fisher Rd, Grosse Pointe Farms, MI 48230

    $429,000

    • 3 Beds
    • 1.5 Baths
    • 1,850 Sq Ft
    • 480 Fisher Rd
    • Grosse Pointe Farms, MI

    Spacious and exceptionally well-maintained Brick Colonial in a prime Grosse Pointe Farms location, offering excellent walkability to top-rated schools. This 3-bedroom, 1.5-bath home sits on a beautifully landscaped lot within the highly desirable Grosse Pointe School District. With a great layout, curb appeal and move-in ready condition, it's just minutes from schools, grocery stores, dining,

    Brad Morgan Jim Saros Real Estate Services

    Section Image
  • 81 Moross Rd, Grosse Pointe Farms, MI 48236

    $575,500

    • 3 Beds
    • 2.5 Baths
    • 1,894 Sq Ft
    • 81 Moross Rd
    • Grosse Pointe Farms, MI

    Handsome Grosse Pointe Farms Colonial located only a 5 minute walk to the Grosse Pointe Farms pier, park and marina. Three bed room, 2.5 baths. Living room features hardwood floors, fireplace and a three season room off living room. Formal dining room. Updated kitchen with maple cabinets, granite countertops and Island overlooking backyard. First floor bathroom with shower. Second floor features

    William Skitch Sine & Monaghan LLC

    Section Image
  • 309 Merriweather Rd, Grosse Pointe Farms, MI 48236

    $550,000

    • 3 Beds
    • 2.5 Baths
    • 2,116 Sq Ft
    • 309 Merriweather Rd
    • Grosse Pointe Farms, MI

    Live on one of the popular "M Streets" in this colonial-style home. It has three bedrooms, two and ahalf bathrooms, and a practical floor plan. The kitchen offers plenty of counter space. Enjoy a largeliving room, dining room, and a family room perfect for cozy nights or entertaining. Features hardwood floors, sizable bedrooms, and a finished basement. Newer furnace, air condoning and hot water

    Jennifer Filipiak Coldwell Banker Professionals-GPF

    Section Image
  • 251 Merriweather Rd, Grosse Pointe Farms, MI 48236

    $525,000

    • 4 Beds
    • 2.5 Baths
    • 3,215 Sq Ft
    • 251 Merriweather Rd
    • Grosse Pointe Farms, MI

    Lovingly maintained by the same family for over 55 years, this traditional center-entry Colonial offers character, craftsmanship, and mechanical peace of mind in a highly desirable neighborhood. Classic architectural details abound, including two striking floor-to-ceiling bay windows—one in the living room with gas fireplace, the other in the formal dining room—along with elegant wainscoting,

    Charles Krasner Sine & Monaghan LLC

    Section Image
  • 324 Mcmillan Rd, Grosse Pointe Farms, MI 48236

    $625,000

    • 3 Beds
    • 2.5 Baths
    • 2,455 Sq Ft
    • 324 Mcmillan Rd
    • Grosse Pointe Farms, MI

    Timeless Colonial in the Heart of Grosse Pointe Farms.Step into classic elegance with this beautifully maintained colonial, ideally located just a short walk from top-rated schools. The sun-drenched living room showcases rich random-pegged hardwood floors, custom window treatments, and a charming natural fireplace — a perfect blend of character and comfort. The updated kitchen is both stylish and

    David Fekin Jim Saros Real Estate Services

    Section Image

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
Brennan Emily C -- None Available
Brennan James P $350,100 Ata National Title Group
Weiss Charles P -- None Available
Weiss James R -- None Available
Weiss James R $42,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Brennan James P $160,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/31/2017 07/31/17 Sold $350,100 0.0% $133 / Sq Ft
06/29/2017 06/29/17 Pending -- -- --
06/21/2017 06/21/17 For Sale $350,000 -- $133 / Sq Ft
Source: Michigan Multiple Listing Service

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 $4,605 $213,500 $0 $0
2023 $7,741 $200,100 $0 $0
2022 $7,741 $183,900 $0 $0
2021 $7,741 $170,700 $0 $0
2019 $7,612 $150,700 $0 $0
2018 $3,895 $145,000 $0 $0
2017 $5,464 $141,500 $0 $0
2016 $5,727 $139,200 $0 $0
2015 $11,344 $125,200 $0 $0
2013 $10,990 $109,900 $0 $0
2012 $2,922 $109,900 $43,500 $66,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31323214

Michigan Multiple Listing Service

APN: 38-001-09-0148-000