NOT LISTED FOR SALE

Estimated Value: $4,132,000 - $4,778,000

6 Beds
6.5 Baths
7,780 Sq Ft
$576/Sq Ft Est. Value

Last Sold June 21, 2024

Last sale price $4,200,000 $540 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $26,856/month

18 Days on Market

Highlights

  • Sauna
  • City View
  • Open Floorplan
  • Underwood Elementary School Rated A
  • 0.71 Acre Lot
  • Custom Closet System

About This Home

As of June 2024

Breathtaking city views are at every level of this immaculate home. This property, renovated to the studs in 2014, is an architectural delight. From the foyer's soaring ceiling to the gourmet kitchen, complete with an oversized island & eating area. The dining room draws you in w/coffered ceilings & wainscoting, as does the living room, complete with a picture window & original fireplace. Not to be outdone is the family room accented by custom built-ins & opens into the kitchen. The 2nd floor offers 4 bedrooms each with en suite bath & a study. Enter the master suite, and you'll be greeted by finishes second only to some of the world's most elite resorts: from the fireplace to the private deck to the massive master bath w/radiant heated floors, a huge shower, & and a soaking tub. The 3rd floor offers a home office, in-law suite, dance studio, recreation room & full bathroom. There is an elevator to all levels of this home. It is situated on a 2/3 acre lot in a prime commuter location.

Last Agent to Sell the Property

Kennedy Lynch Gold Team

Hammond Residential Real Estate Listed on: 02/08/2024

Hammond Residential Real Estate

Last Buyer's Agent

Kennedy Lynch Gold Team

Hammond Residential Real Estate Listed on: 02/08/2024

Hammond Residential Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $34,819

Year Built

  • Built in 1976

Lot Details

  • 0.71 Acre Lot
  • Fenced Yard
  • Landscaped Professionally
  • Level Lot
  • Sprinkler System
  • Property is zoned SR2

Parking

  • 2 Car Attached Garage
  • Parking Storage or Cabinetry
  • Garage Door Opener
  • Off-Street Parking

Property Views

  • City
  • Scenic Vista

Home Design

  • Colonial Architecture
  • Frame Construction
  • Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 7,780 Sq Ft Home
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Wainscoting
  • Coffered Ceiling
  • Recessed Lighting
  • 2 Fireplaces
  • Picture Window
  • Insulated Doors
  • Dining Area
  • Home Office
  • Play Room
  • Sauna
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Oven
  • Range
  • Microwave
  • Second Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Solid Surface Countertops
  • Disposal
  • Pot Filler

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary bedroom located on second floor
  • Custom Closet System
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Soaking Tub
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Home Security

  • Home Security System
  • Intercom

Outdoor Features

  • Balcony
  • Deck
  • Rain Gutters

Location

  • Property is near public transit
  • Property is near schools

Schools

  • Underwood Elementary School
  • Bigelow Middle School
  • Newton North High School

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number S:12 B:021 L:0033,682855

Community Details

Recreation

  • Park

Additional Features

  • No Home Owners Association
  • Shops

Home Details

Home Type

Single Family

Est. Annual Taxes

$34,819

Year Built

Built in 1976

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Colonial
  • Year Built: 1976
  • Buyer Agency: 2.5
  • Transaction Broker: 1
  • Year Built Details: Actual
  • SUB AGENCY OFFERED: No
  • Year Round: Yes
  • Compensation Based On: Net Sale Price
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Wood, Tile, Flooring - Hardwood
  • Interior Amenities: Bathroom - Full, Open Floorplan, Recessed Lighting, Closet/Cabinets - Custom Built, Bedroom, Play Room, Bathroom, Home Office, Central Vacuum, Wet Bar
  • Fireplace Features: Master Bedroom
  • Fireplace YN: Yes
  • Fireplaces: 2
  • Appliances: Range, Oven, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer
  • Total Bedrooms: 6
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Bathroom - Full, Walk-In Closet(s), Flooring - Hardwood
  • Room Bedroom3 Features: Bathroom - Full, Flooring - Hardwood
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Level: Second
  • Room Bedroom4 Features: Bathroom - Full, Walk-In Closet(s), Flooring - Hardwood
  • Room Bedroom5 Level: Third
  • Room Bedroom5 Features: Bathroom - Full
  • Full Bathrooms: 6
  • Half Bathrooms: 1
  • Total Bathrooms: 7
  • Total Bathrooms: 6.5
  • Room Master Bedroom Features: Bathroom - Full, Bathroom - Double Vanity/Sink, Walk-In Closet(s), Closet/Cabinets - Custom Built, Flooring - Hardwood, Balcony / Deck
  • Room Master Bedroom Level: Second
  • Master Bathroom Features: Yes
  • Bathroom 1 Features: Bathroom - Full
  • Bathroom 1 Level: First
  • Bathroom 2 Level: Second
  • Bathroom 2 Features: Bathroom - Full, Bathroom - Double Vanity/Sink, Bathroom - Tiled With Shower Stall, Bathroom - With Tub, Flooring - Stone/Ceramic Tile, Jacuzzi / Whirlpool Soaking Tub, Double Vanity, Recessed Lighting, Steam / Sauna
  • Bathroom 3 Features: Bathroom - Full, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile
  • Bathroom 3 Level: Second
  • Room Dining Room Features: Coffered Ceiling(s), Flooring - Hardwood, Window(s) - Picture, Open Floorplan, Recessed Lighting, Wainscoting
  • Room Dining Room Level: First
  • Room Family Room Level: First
  • Room Family Room Features: Closet/Cabinets - Custom Built, Flooring - Hardwood, Open Floorplan, Recessed Lighting
  • Room Kitchen Level: First
  • Room Kitchen Features: Flooring - Hardwood, Dining Area, Countertops - Stone/Granite/Solid, Kitchen Island, Wet Bar, Open Floorplan, Recessed Lighting, Second Dishwasher, Stainless Steel Appliances, Pot Filler Faucet, Wine Chiller
  • Laundry Features: Closet/Cabinets - Custom Built, Second Floor, Washer Hookup
  • Room Living Room Level: First
  • Room Living Room Features: Flooring - Hardwood, Window(s) - Picture, Open Floorplan, Recessed Lighting
  • Room Office Level: Third
  • Room Office Features: Closet/Cabinets - Custom Built
  • Basement: Full, Partially Finished
  • Living Area: 7780
  • Other Equipment: Intercom
  • Spa YN: No
  • MAIN LO: AN6181
  • LIST PRICE PER Sq Ft: 539.85
  • PRICE PER Sq Ft: 539.85
  • MAIN SO: AN6181

Exterior Features

  • Exterior Features: Deck, Rain Gutters, Professional Landscaping, Sprinkler System, Fenced Yard, City View(s)
  • Construction Materials: Frame
  • Fencing: Fenced
  • Foundation Details: Concrete Perimeter
  • Home Warranty YN: No
  • Patio And Porch Features: Deck
  • Roof: Shingle
  • View: Scenic View(s), City
  • View YN: Yes
  • Waterfront YN: No
  • Waterview Flag: No

Garage/Parking

  • Garage Spaces: 2
  • Attached Garage YN: Yes
  • Carport Y N: No
  • Covered Parking Spaces: 2
  • Garage YN: Yes
  • Parking Features: Attached, Garage Door Opener, Storage, Insulated, Off Street
  • Total Parking Spaces: 5

Utilities

  • Sewer: Public Sewer
  • Utilities: for Gas Range, Washer Hookup
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Cooling Y N: Yes
  • Heating YN: Yes
  • Security Features: Security System
  • Water Source: Public

Condo/Co-op/Association

  • Association YN: No
  • Community Features: Public Transportation, Shopping, Park, Highway Access, House of Worship, Public School, University
  • Senior Community YN: No

Lot Info

  • Parcel Number: S:12 B:021 L:0033,682855
  • Zoning: SR2
  • Farm Land Area Units: Square Feet
  • Lot Features: Level
  • Lot Size Acres: 0.71
  • Lot Size Area: 0.71
  • Lot Size Sq Ft: 31069
  • Lot Size Units: Acres
  • Property Attached YN: No
  • PAGE: 568
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 34819
  • Tax Book Number: 70456

Multi Family

  • Basement Included Sq Ft: No

MLS Schools

  • High School: Newton North
  • Elementary School: Underwood
  • Middle Or Junior School: Bigelow

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 1, 2022
Sold by
Mahendra Rajah Ft and Mahendra-Rajah
Bought by
Mahendra-Rajah Prashanth and Rajah
Current Estimated Value
$4,483,926

Purchase Details

Listed on
Jul 5, 2017
Closed on
Jan 17, 2018
Sold by
Mahendra-Rajah P J
Bought by
Mahendra-Rajah Ft
Seller's Agent
Erica Lockberg
Berkshire Hathaway HomeServices Town and Country Real Estate
Buyer's Agent
Montgomery Carroll Group
Compass
List Price
$3,650,000
Sold Price
$3,188,000
Premium/Discount to List
-$462,000
-12.66%

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.50%
Original Mortgage
$1,912,800
Interest Rate
2.75%
Mortgage Type
Unknown

Purchase Details

Listed on
Jul 5, 2017
Closed on
Dec 29, 2017
Sold by
Garraway Levi A and Garraway Gisele J
Bought by
Mahendra-Rajah Prashanth
Seller's Agent
Erica Lockberg
Berkshire Hathaway HomeServices Town and Country Real Estate
Buyer's Agent
Montgomery Carroll Group
Compass
List Price
$3,650,000
Sold Price
$3,188,000
Premium/Discount to List
-$462,000
-12.66%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,912,800
Interest Rate
2.75%
Mortgage Type
Unknown

Purchase Details

Listed on
Nov 4, 2014
Closed on
Feb 24, 2015
Sold by
Nof Maxim Llc
Bought by
Garraway Gisele J and Garraway Levi A
Seller's Agent
Sigal Fishman
Sigal Realty
Buyer's Agent
Jared Wilk
Compass
List Price
$3,795,000
Sold Price
$3,650,000
Premium/Discount to List
-$145,000
-3.82%

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.64%

Purchase Details

Listed on
Jun 19, 2013
Closed on
Dec 18, 2013
Sold by
Tishler Gerald P and Tishler Elizabeth S
Bought by
Nof Maxim Llc
Seller's Agent
Buzz Birnbaum
Hammond Residential Real Estate
Buyer's Agent
Sigal Fishman
Sigal Realty
List Price
$2,195,000
Sold Price
$1,825,000
Premium/Discount to List
-$370,000
-16.86%

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 11, 2006
Sold by
Tishler Elizabeth S and Tishler Gerald P
Bought by
Tishler Elizabeth S and Tishler Gerald P

Purchase Details

Closed on
Mar 9, 2004
Sold by
Haas Robert A
Bought by
Tishler Elizabeth S and Tishler Gerald P

Purchase Details

Closed on
Oct 1, 2003
Sold by
Troy Lane Rt
Bought by
Haas Robert A

Purchase Details

Closed on
May 5, 1998
Sold by
Haas Robert A and Haas Jane G
Bought by
Haas Robert A
Source: Public Records

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
Mahendra-Rajah Prashanth -- None Available
P Mahendra Rajah Ft -- None Available
Mahendra-Rajah Prashanth -- None Available
Mahendra-Rajah Ft -- --
Mahendra-Rajah Prashanth $3,188,000 --
Garraway Gisele J $3,650,000 --
Nof Maxim Llc $1,825,000 --
Tishler Elizabeth S -- --
Tishler Elizabeth S $1,537,500 --
Haas Robert A -- --
Haas Robert A $361,940 --
Mahendra-Rajah Ft -- --
Tishler Elizabeth S -- --
Tishler Elizabeth S $1,537,500 --
Haas Robert A -- --
Haas Robert A $361,940 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Mahendra-Rajah Prashanth $1,912,800
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/21/2024 06/21/24 Sold $4,200,000 0.0% $540 / Sq Ft
02/27/2024 02/27/24 Pending -- -- --
02/08/2024 02/08/24 For Sale $4,200,000 +31.7% $540 / Sq Ft
12/29/2017 12/29/17 Sold $3,188,000 -11.4% $410 / Sq Ft
10/27/2017 10/27/17 Pending -- -- --
10/02/2017 10/02/17 Price Changed $3,599,000 -0.7% $463 / Sq Ft
08/03/2017 08/03/17 Price Changed $3,625,000 -0.7% $466 / Sq Ft
07/05/2017 07/05/17 For Sale $3,650,000 0.0% $469 / Sq Ft
02/23/2015 02/23/15 Sold $3,650,000 0.0% $469 / Sq Ft
02/12/2015 02/12/15 Pending -- -- --
01/27/2015 01/27/15 Off Market $3,650,000 -- --
11/04/2014 11/04/14 For Sale $3,795,000 +107.9% $488 / Sq Ft
12/18/2013 12/18/13 Sold $1,825,000 0.0% $377 / Sq Ft
11/19/2013 11/19/13 Pending -- -- --
11/05/2013 11/05/13 Off Market $1,825,000 -- --
09/26/2013 09/26/13 Price Changed $1,995,000 -9.1% $412 / Sq Ft
06/19/2013 06/19/13 For Sale $2,195,000 -- $453 / Sq Ft
Source: MLS Property Information Network (MLS PIN)

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
2025 $37,008 $3,776,300 $1,397,900 $2,378,400
2024 $35,783 $3,666,300 $1,357,200 $2,309,100
2023 $34,819 $3,420,300 $1,084,800 $2,335,500
2022 $33,316 $3,166,900 $1,004,400 $2,162,500
2021 $32,147 $2,987,600 $947,500 $2,040,100
2020 $31,191 $2,987,600 $947,500 $2,040,100
2019 $30,311 $2,900,600 $919,900 $1,980,700
2018 $42,669 $3,943,500 $971,000 $2,972,500
2017 $41,370 $3,720,300 $916,000 $2,804,300
2016 $31,972 $2,809,500 $713,500 $2,096,000
2015 $20,148 $1,735,400 $666,800 $1,068,600
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 73200757

MLS Property Information Network (MLS PIN)

APN: NEWT-000012-000021-000033