NOT LISTED FOR SALE

Estimated Value: $1,236,000 - $2,314,218

6 Beds
6.5 Baths
10,354 Sq Ft
$165/Sq Ft Est. Value

Last Sold February 21, 2020

Last sale price $838,000 $81 Per Sq Ft

Est. 104% increase in value since last sale

Current estimated payment $10,458/month

124 Days on Market

Highlights

  • 4.91 Acre Lot
  • Traditional Architecture
  • Cul-De-Sac
  • Creekside Middle School Rated A+
  • 4 Fireplaces
  • 4 Car Attached Garage

About This Home

As of February 2020

Very RARE opportunity in the exclusive Carmel subdivision of Queens Manor. This nearly 11,000 sqft, all brick, home sits on almost 5 acres and is nestled off the street for privacy and serenity. This home is ready for you to put your finishing touches on and make this the show stopper that it's meant to be. This executive style home boasts 6 bedrooms, 6.5 bathrooms, a full finished basement, and 4 car garage. Large kitchen, living room & sun/breakfast room is made to entertain friends and enjoy family gatherings. There are 4 fireplaces to make those winter nights warm & cozy - and over 70 windows throughout to bring in plenty of natural light. Priced well below market value, this home is ready for the right buyer to create a masterpiece!

Last Agent to Sell the Property

Randy Placencia

Red Bridge Real Estate License #RB14045562 Listed on: 08/17/2019

Last Buyer's Agent

Amber Hatton

Offerpad Brokerage, LLC

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1985

Lot Details

  • 4.91 Acre Lot
  • Cul-De-Sac

Parking

  • 4 Car Attached Garage

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • 4 Fireplaces
  • Finished Basement

Bedrooms and Bathrooms

  • 6 Bedrooms

Outdoor Features

  • Screened Patio

Utilities

  • Central Air
  • Well
  • Septic Tank

Community Details

  • Association fees include entrance common maintenance snow removal
  • Queens Manor Subdivision
  • Property managed by Queens Manor HOA

Listing and Financial Details

  • Assessor Parcel Number 291303003015000018

Home Details

Home Type

Single Family

Year Built

Built in 1985

Lot Details

0

Parking

4

Listing Details

  • Property Sub Type: Single Family Residence
  • Architectural Style: TraditonalAmerican
  • Property Type: Residential
  • New Construction: No
  • Tax Year: 2018
  • Year Built: 1985
  • Garage Y N: Yes
  • Lot Size Acres: 4.91
  • Subdivision Name: QUEENS MANOR
  • Inspection Warranties: General,SeeRemarks
  • Property Description: Very RARE opportunity in the exclusive Carmel subdivision of Queens Manor. This nearly 11,000 sqft, all brick, home sits on almost 5 acres and is nestled off the street for privacy and serenity. This home is ready for you to put your finishing touches on and make this the show stopper that it's meant to be. This executive style home boasts 6 bedrooms, 6.5 bathrooms, a full finished basement, and 4 car garage. Large kitchen, living room & sun/breakfast room is made to entertain friends and enjoy family gatherings. There are 4 fireplaces to make those winter nights warm & cozy - and over 70 windows throughout to bring in plenty of natural light. Priced well below market value, this home is ready for the right buyer to create a masterpiece!
  • Transaction Type: Sale
  • Special Features: None

Interior Features

  • Basement: Yes
  • Basement Type: Finished
  • Appliances: Electric Cooktop,Dishwasher,Down Draft,Disposal,Microwave,Oven,Double Oven,Refrigerator
  • Levels: Two
  • Full Bathrooms: 6
  • Half Bathrooms: 1
  • Total Bathrooms: 7
  • Total Bedrooms: 6
  • Fireplace Features: Family Room,Great Room,Living Room,Recreation Room
  • Fireplaces: 4
  • Interior Amenities: Attic Pull Down Stairs,Built In Book Shelves,Ceiling Raised,Ceiling Tray,Walk-in Closet(s),Hardwood Floors
  • Living Area: 10354
  • Other Equipment: Central Vacuum,Intercom,Smoke Detector,Sump Pump,Sump Pump
  • Room Count: 14
  • Areas Interior: Bath Sinks Double Main,Bedroom Other on Main,Foyer - 2 Story,Living Room Formal,Laundry Room Main Level
  • Eating Area: Breakfast Room,Formal Dining Room
  • Basement Full Bathrooms: 1
  • Main Level Full Bathrooms: 1
  • Sq Ft Main Upper: 7112
  • Main Level Sq Ft: 4205
  • Basement Half Bathrooms: 0
  • Main Half Bathrooms: 1
  • Master Bedroom Description: Closet Walk in,Sinks Double,Tub Full with Separate Shower,Tub Garden
  • Total Sq Ft: 10354
  • Kitchen Features: Breakfast Bar,Center Island,Pantry WalkIn
  • Below Grade Sq Ft: 3242
  • Upper Level Sq Ft: 2907
  • Pct Optional Level Finished: 75+%

Exterior Features

  • Construction Materials: Brick
  • Disclosures: Not Applicable
  • Exterior Features: Driveway Exposed Aggregate
  • Foundation Details: Concrete Perimeter
  • List Price: 838000
  • Association Maintained Building Exterior: 0
  • Porch: Screened in Patio

Garage/Parking

  • Garage Spaces: 4
  • Fuel: Electric
  • Garage Parking Description: Attached
  • Garage Parking Other: Rear Load Garage
  • Garage Sq Ft: 1275

Utilities

  • Sewer: Septic Tank
  • Cooling: Central Air
  • Heating: Electronic Air Filter,Dual,Heat Pump
  • Water Source: Well
  • Solid Waste: 0
  • Utility Options: Cable Available,High Speed Internet Avail
  • Water Heater: Electric

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Management Company Name: Queens Manor HOA

Fee Information

  • Association Fee Includes: Entrance Common,Maintenance,Snow Removal
  • Mandatory Fee: 500

Lot Info

  • Property Attached Yn: No
  • Parcel Number: 291303003015000018
  • Acres: 3-5 Acres
  • Lot Information: Cul-De-Sac
  • Lot Number: 11
  • Lot Size: 213,880

Green Features

  • Green Certification Y N: 0

Tax Info

  • Tax Annual Amount: 24342
  • Semi Annual Property Tax Amt: 12171
  • Tax Exemption: None

MLS Schools

  • School District: Carmel Clay Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 17, 2019
Closed on
Feb 21, 2020
Sold by
Simple Quarters Llc
Bought by
Wilson Carlos
Seller's Agent
Randy Placencia
Red Bridge Real Estate
Buyer's Agent
Amber Hatton
Offerpad Brokerage, LLC
List Price
$838,000
Sold Price
$838,000
Current Estimated Value
$1,713,055

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$875,055
Avg. Annual Appreciation
14.12%
Original Mortgage
$510,400
Interest Rate
3.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 14, 2019
Sold by
Lehr Eric C and Lehr Maurine L
Bought by
Simple Quarters Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$600,000
Interest Rate
3.7%
Mortgage Type
Commercial

Purchase Details

Closed on
Jul 14, 2006
Sold by
Goodloe Samuel L and Goodloe Tonja W
Bought by
Lehr Eric C and Lehr Maurine L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$130,000
Interest Rate
6.73%
Mortgage Type
Credit Line Revolving
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
Wilson Carlos -- Chicago Title Company Llc
Simple Quarters Llc -- None Available
Lehr Eric C -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Wilson Carlos $500,000
Closed Wilson Carlos $510,400
Closed Wilson Carlos $242,962
Previous Owner Simple Quarters Llc $600,000
Previous Owner Simple Quarters Llc $100,000
Previous Owner Lehr Eric C $250,000
Previous Owner Lehr Eric C $130,000
Previous Owner Lehr Eric C $650,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/21/2020 02/21/20 Sold $838,000 0.0% $81 / Sq Ft
12/19/2019 12/19/19 Pending -- -- --
11/26/2019 11/26/19 For Sale $838,000 0.0% $81 / Sq Ft
11/25/2019 11/25/19 Off Market $838,000 -- --
10/14/2019 10/14/19 Price Changed $838,000 -4.2% $81 / Sq Ft
09/19/2019 09/19/19 Price Changed $875,000 -2.8% $85 / Sq Ft
08/16/2019 08/16/19 For Sale $899,900 -- $87 / 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 $13,491 $1,078,000 $347,900 $730,100
2023 $13,556 $1,078,000 $347,900 $730,100
2022 $12,786 $990,900 $370,400 $620,500
2021 $12,144 $935,900 $370,400 $565,500
2020 $12,322 $951,100 $370,400 $580,700
2019 $19,648 $953,000 $406,400 $546,600
2018 $12,171 $953,000 $406,400 $546,600
2017 $11,630 $906,500 $406,400 $500,100
2016 $12,754 $1,016,700 $406,400 $610,300
2014 $13,112 $1,067,700 $406,400 $661,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MIBOR Broker Listing Cooperative®

MLS Number: MBR21662588

MIBOR Broker Listing Cooperative®

APN: 29-13-03-003-015.000-018