NOT LISTED FOR SALE

Estimated Value: $3,153,000 - $3,657,000

8 Beds
7.5 Baths
12,740 Sq Ft
$271/Sq Ft Est. Value

Last Sold May 21, 2024

Last sale price $3,600,000 $283 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $22,168/month

Highlights

  • Pool House
  • Sauna
  • Pond View
  • Smoky Row Elementary School Rated A+
  • Gated Community
  • 1.15 Acre Lot

About This Home

As of May 2024

Enter the realm of luxury and refinement at 13158 W Sherbern Drive, where the Grand Italianate Villa reigns supreme within the prestigious gated community of Estates of Clay West. With 8 bedrooms and 7.5 baths, this architectural marvel welcomes you with unparalleled grandeur and sophistication. Step inside to experience the seamless fusion of Old World Italian charm and modern opulence, evident in every detail from the sweeping foyer to the intimate terrace fireplace. Set gracefully on an acre of manicured grounds, the residence offers breathtaking water views, creating a serene and tranquil ambiance. Indulge in the finer things in life as you unwind in the soothing spa or enjoy a glass of fine wine by the terrace fireplace. The Pool House, complete with a kitchen bar and full bath, invites leisurely afternoons spent under the shade of the pergola with retractable awnings. With meticulous craftsmanship evident throughout, this grand Italianate Villa epitomizes timeless elegance, offering a lifestyle of unparalleled luxury in the heart of Carmel. Embrace the rare blend of sophistication and refinement, where every moment is a testament to the art of living well.

Last Agent to Sell the Property

Jennil Salazar

Compass Indiana, LLC Brokerage Email: Jennil.Salazar@Compass.com License #RB14044787 Listed on: 05/20/2024

Compass Indiana, LLC

Last Buyer's Agent

Shannon Gilbert

Highgarden Real Estate License #RB14037650

Highgarden Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $44,338

Year Built

  • Built in 2004

Lot Details

  • 1.15 Acre Lot
  • Sprinkler System
  • Mature Trees

HOA Fees

  • $333 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction
  • Concrete Perimeter Foundation
  • Stone

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Home Theater Equipment
  • Built-in Bookshelves
  • Tray Ceiling
  • Vaulted Ceiling
  • Family Room with Fireplace
  • 4 Fireplaces
  • Great Room with Fireplace
  • Den with Fireplace
  • Sauna
  • Wood Flooring
  • Pond Views

Kitchen

  • Double Oven
  • Gas Oven
  • Gas Cooktop
  • Range Hood
  • Warming Drawer
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 8 Bedrooms
  • Fireplace in Bedroom
  • Walk-In Closet

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Sump Pump with Backup
  • Fireplace in Basement

Home Security

  • Security System Owned
  • Fire and Smoke Detector

Pool

  • Pool House
  • Gunite Spa

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Outdoor Water Feature
  • Outdoor Fireplace
  • Fire Pit
  • Breezeway

Utilities

  • Forced Air Heating System
  • Heating System Uses Gas
  • Gas Water Heater

Listing and Financial Details

  • Tax Lot 11
  • Assessor Parcel Number 290928024011000018

Community Details

Overview

  • Association fees include insurance, maintenance, nature area, management, snow removal, trash
  • Estates Of Clay West Subdivision
  • Property managed by Armour Property Management
  • The community has rules related to covenants, conditions, and restrictions

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$44,338

Year Built

Built in 2004

Lot Details

0

HOA Fees

$333 per month

Parking

4

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: Italianate
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2023
  • Year Built: 2004
  • Building Area Total: 12740
  • Garage Y N: Yes
  • Lot Size Acres: 1.15
  • Subdivision Name: Estates Of Clay West
  • Transaction Type: Sale
  • Website: www.jennilsalazar.com
  • Accessibility Features YN: No
  • MBR_AttributionContact: Jennil.Salazar@Compass.com
  • Attribution Contact: Jennil.Salazar@Compass.com
  • Special Features: None

Interior Features

  • Basement: Yes
  • Basement Type: Finished
  • Appliances: Gas Cooktop, Dishwasher, Gas Water Heater, Microwave, Double Oven, Gas Oven, Range Hood, Refrigerator, Warming Drawer, Water Softener Owned
  • Levels: Two
  • Full Bathrooms: 7
  • Half Bathrooms: 1
  • Total Bathrooms: 8
  • Total Bedrooms: 8
  • Below Grade Sq Ft: 4090
  • Fireplace Features: Basement, Bedroom, Den/Library Fireplace, Family Room, Great Room, Outside
  • Fireplaces: 4
  • Interior Amenities: Built In Book Shelves, Raised Ceiling(s), Tray Ceiling(s), Vaulted Ceiling(s), Hardwood Floors, Network Ready, Sauna, Walk-in Closet(s), Wet Bar
  • Living Area: 12740
  • Main Level Bedrooms: 1
  • Other Equipment: Security Alarm Paid, Smoke Alarm, Sump Pump, Sump Pump w/Backup, Theater Equipment
  • Spa Features: Gunite
  • Spa Y N: Yes
  • Areas Interior: Great Room - 2 Story
  • Eating Area: Breakfast Room,Formal Dining Room
  • Basement Full Bathrooms: 1
  • Main Level Full Bathrooms: 2
  • Main Level Sq Ft: 4752
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 1
  • Upper Level Sq Ft: 3898
  • ResoLivingAreaSource: Assessor
  • Rooms Basement: 6

Exterior Features

  • Construction Materials: Brick, Stone
  • Exterior Features: Lighting, Outdoor Fire Pit, Pool House, Sprinkler System, Water Feature Fountain
  • Foundation Details: Concrete Perimeter
  • List Price: 3600000
  • Patio And Porch Features: Breeze Way, Covered Patio, Covered Porch, Deck UP
  • Pool Features: In Ground
  • Pool Private Y N: Yes
  • View: Pond, Water
  • View Y N: Yes
  • Waterfront: No

Garage/Parking

  • Garage Spaces: 4
  • Parking Features: Attached, Garage Door Opener
  • Garage Parking Other: Courtyard Load Garage,Garage Door Opener,Service Door
  • Garage Sq Ft: 2762

Utilities

  • Utilities: Cable Available, Gas Nearby
  • Cooling: Central Electric
  • Heating: Forced Air, Gas
  • Laundry Features: Laundry Room, Main Level, Upper Level
  • Water Source: Municipal/City
  • Solid Waste: No

Condo/Co-op/Association

  • Association Amenities: Gated
  • Association Fee: 4000
  • Association Fee Frequency: Annually
  • Association YN: Yes
  • Management Company Name: Armour Property Management
  • H O A Disclosures: Covenants & Restrictions

Fee Information

  • Association Fee Includes: Insurance, Maintenance, Nature Area, Management, Snow Removal, Trash

Lot Info

  • Lot Features: Gated Community, Street Lights, Mature Trees
  • Property Attached Yn: No
  • Additional Parcels: No
  • Horse Amenities: None
  • Lot Size Sq Ft: 50094
  • Parcel Number: 290928024011000018
  • Acres: 1-3 Acres
  • Price Acre: 3130435

Green Features

  • Green Certification Y N: No

Tax Info

  • Tax Annual Amount: 44338
  • Tax Lot: 11
  • Semi Annual Property Tax Amt: 22169
  • Tax Exemption: Homestead Tax Exemption

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 20, 2024
Closed on
May 23, 2024
Sold by
Bir Allan C and Bir Erin M
Bought by
Ffer Jeni and Singh Satinder
Seller's Agent
Jennil Salazar
Compass Indiana, LLC
Buyer's Agent
Shannon Gilbert
Highgarden Real Estate
List Price
$3,600,000
Sold Price
$3,600,000
Total Days on Market
0
Views
6
Current Estimated Value
$3,452,406

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$147,594
Avg. Annual Appreciation
-7.39%
Original Mortgage
$2,200,000
Outstanding Balance
$2,172,511
Interest Rate
7.13%
Mortgage Type
New Conventional
Estimated Equity
$1,072,996

Purchase Details

Listed on
Nov 12, 2018
Closed on
May 22, 2019
Sold by
Modany Kevin M and Modany Carrie A
Bought by
Bir Allan C and Bir Erin M
Seller's Agent
Sherry Drybrough
F.C. Tucker Company
Buyer's Agent
Jennil Salazar
Compass Indiana, LLC
List Price
$2,350,000
Sold Price
$2,025,000
Premium/Discount to List
-$325,000
-13.83%

Home Financials for this Owner

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

Purchase Details

Closed on
May 7, 2010
Sold by
Copeland Robert and Copeland Donna
Bought by
Modany Kevin M and Modany Carrie A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,200,000
Interest Rate
4.83%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jan 27, 2004
Sold by
The Estates Llc
Bought by
Copeland Robert and Copeland Donna
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
Ffer Jeni $3,600,000 First American Title
Bir Allan C -- None Available
Modany Kevin M -- None Available
Copeland Robert -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ffer Jeni $2,200,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/21/2024 05/21/24 Sold $3,600,000 0.0% $283 / Sq Ft
05/20/2024 05/20/24 Pending -- -- --
05/20/2024 05/20/24 For Sale $3,600,000 +77.8% $283 / Sq Ft
05/20/2019 05/20/19 Sold $2,025,000 -13.8% $234 / Sq Ft
11/12/2018 11/12/18 Pending -- -- --
11/12/2018 11/12/18 For Sale $2,350,000 -- $272 / Sq Ft
Source: MIBOR Broker Listing Cooperative®

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 $43,231 $2,125,500 $456,000 $1,669,500
2023 $43,296 $2,144,400 $456,000 $1,688,400
2022 $44,305 $2,148,000 $228,500 $1,919,500
2021 $39,857 $1,920,100 $228,500 $1,691,600
2020 $39,567 $1,905,800 $228,500 $1,677,300
2019 $24,025 $1,893,900 $228,700 $1,665,200
2018 $23,859 $1,915,100 $228,700 $1,686,400
2017 $23,159 $1,809,800 $228,700 $1,581,100
2016 $22,892 $1,863,200 $228,700 $1,634,500
2014 $22,574 $1,861,400 $228,700 $1,632,700
2013 $22,574 $1,826,200 $228,700 $1,597,500
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: 21967243

MIBOR Broker Listing Cooperative®

APN: 29-09-28-024-011.000-018