NOT LISTED FOR SALE

Estimated Value: $677,000 - $826,000

5 Beds
4 Baths
3,471 Sq Ft
$211/Sq Ft Est. Value

Last Sold June 12, 2014

Last sale price $525,000 $151 Per Sq Ft

Est. 38% increase in value since last sale

Current estimated payment $4,840/month

106 Days on Market

Highlights

  • Deck
  • Whirlpool Bathtub
  • Double Oven
  • Kolling Elementary School Rated A
  • Covered patio or porch
  • 3.5 Car Attached Garage

About This Home

As of June 2014

WARM..COMFORTABLE..BEAUTIFUL..DESCRIBE THIS NEWER TWO STORY HOME SITUATED WITHIN THE EXCLUSIVE LAKE HILLS SUBDIVISION! The first impression of this luxurious home comes from the beautiful angled roof lines and covered stone front porch leading into the grand foyer displaying the hardwood flooring.The combined Great Room and Kitchen dining create a large gathering area that enjoys a cozy fireplace,light filled windows,access to the rear deck/patio with a great view of the perfect back yard.To add to the beauty and comfort of this home,the well designed large kitchen boasts granite counter tops, stainless steel appliances(included), an abundance of custom cabinetry,center island, large dry bar near the separate formal dining room and more!UNBELIEVABLE MASTER SUITE RETREAT provides a private glamour bath,steam shower,private sitting/workout room & walk-in closet.Rooms for the entire family with four additional bedrooms,formal livroom,daylight basement w/x-high ceiling,3 car garage! WOW!

Last Agent to Sell the Property

Gina Guarino

McColly Real Estate License #RB14043690 Listed on: 01/12/2014

McColly Real Estate

Last Buyer's Agent

Scott Spevacek

Century 21 Circle License #RB14024642

Century 21 Circle

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,679

Year Built

  • Built in 2005

Lot Details

  • 0.3 Acre Lot
  • Lot Dimensions are 80x165

Parking

  • 3.5 Car Attached Garage

Home Design

  • Brick Foundation

Interior Spaces

  • 3,471 Sq Ft Home
  • 2-Story Property
  • Dry Bar
  • Recreation Room with Fireplace
  • Natural lighting in basement

Kitchen

  • Double Oven
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Whirlpool Bathtub

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Covered patio or porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Water Softener is Owned

Community Details

  • Property has a Home Owners Association
  • Vanguard Community Management Association, Phone Number (847) 490-3833
  • Lake Hills Subdivision

Listing and Financial Details

  • Assessor Parcel Number 451128427010000035

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,679

Year Built

Built in 2005

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Year Built: 2005
  • Co List Office Mls Id: NRA254
  • Subdivision Name: Lake Hills
  • Above Grade Finished Sq Ft: 3471
  • Garage Yn: Yes
  • Unit Levels: Two
  • Property Attached Yn: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Gas Range, Dishwasher, Disposal, Double Oven, Dryer, Exhaust Fan, Microwave, Refrigerator, Washer, Water Softener Owned
  • Interior Amenities: Cathedral Ceiling(s), Dry Bar, Sauna, Vaulted Ceiling(s), Whirlpool Tub
  • Basement: Daylight, Sump Pump
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Recreation Room
  • Fireplaces: 1
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Exterior Features: Lighting
  • Acres: 0.303
  • Construction Type: Brick, Cement Siding
  • Patio And Porch Features: Covered, Deck, Patio, Porch

Garage/Parking

  • Garage Spaces: 3.5
  • Parking Features: Attached

Utilities

  • Cooling: Central Air, Whole House Fan
  • Heating: Forced Air, Humidity Control, Natural Gas
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Sidewalks
  • Association Fee: 352.8
  • Association Name: Vanguard Community Management
  • Phone: 847-490-3833
  • Association: Yes

Schools

  • Junior High Dist: Lake Central

Lot Info

  • Lot Dimensions: 80x165
  • Lot Size Sq Ft: 13198
  • Parcel #: 451128427010000035

Tax Info

  • Year: 2013
  • Tax Annual Amount: 5679

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 12, 2014
Closed on
Jun 10, 2014
Sold by
Allegretti James and Allegretti Carolyn
Bought by
The M & M Family Trust
Seller's Agent
Gina Guarino
McColly Real Estate
Buyer's Agent
Scott Spevacek
Century 21 Circle
List Price
$525,000
Sold Price
$525,000
Total Days on Market
106
Current Estimated Value
$726,371

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$201,371
Avg. Annual Appreciation
3.07%
Original Mortgage
$417,000
Interest Rate
4.2%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 30, 2005
Sold by
Newcastle Homes Llc
Bought by
Allegretti James and Allegretti Carolyn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$359,650
Interest Rate
5.88%
Mortgage Type
Fannie Mae Freddie Mac
Source: Public Records

Similar Homes in Saint John, IN

  • 9446 Villagio Way, Saint John, IN 46373

    $650,000

    • 5 Beds
    • 3 Baths
    • 4,687 Sq Ft
    • 9446 Villagio Way
    • Saint John, IN

    Welcome to this stunning and thoughtfully designed home that combines elegance and functionality. The heart of the home features a beautiful open-concept kitchen, complete with new, gleaming stainless steel appliances, sleek countertops, and ample cabinetry. Perfect for both everyday living and entertaining. The master bedroom is located on the main floor, offering a private retreat with tray

    Tom Cummings Keller Williams Preferred Real

    Section Image
  • 8312 Emerson Dr, Saint John, IN 46373

    $599,900

    • 6 Beds
    • 3.5 Baths
    • 3,547 Sq Ft
    • 8312 Emerson Dr
    • Saint John, IN

    Welcome to this sophisticated, move-in ready two-story showstopper!Only four years young, this home feels like brand-new construction customized to your taste. With 5 bedrooms with possible 6th and four bathrooms, every inch of this home has been thoughtfully designed with functionality and modernized touches!From the cathedral ceilings stylish finishes, this property delivers luxury at every

    Lisa Reyes McColly Real Estate

    Section Image
  • 9793 Aster Cove, Saint John, IN 46373

    $699,999

    • 6 Beds
    • 3 Baths
    • 2,956 Sq Ft
    • 9793 Aster Cove
    • Saint John, IN

    Welcome to 9397 Aster Cove, St. John - A Stunning 6-Bedroom, 3-Bathroom Dream Home! Step into elegance with this beautifully maintained residence, offering space, style, and functionality in one of St. John's most desirable neighborhoods. From the moment you enter the impressive two-story foyer, you'll be captivated by the rich hand-scraped oak floors that span the main level. Just off the foyer,

    Caleb Lyzenga eXp Realty, LLC

    Section Image
  • 9164 Sherwood Ct, Saint John, IN 46373

    $560,000

    • 4 Beds
    • 3.5 Baths
    • 3,288 Sq Ft
    • 9164 Sherwood Ct
    • Saint John, IN

    Impeccable 4-Bedroom Home in Walden ClearingWelcome to 9164 Sherwood Ct., located in the highly sought-after Walden Clearing neighborhood of St. John! Built in 2021 and better than new, this stunning 4-bedroom, 3.5-bath home offers nearly 3,300 sq ft of beautifully finished living space on a premium landscaped lot with in ground sprinklers system that is located on a cul de sac. The neighborhood

    Krystle Rogers Signature Realty Group

    Section Image
  • 8592 Ventura Trails Dr, Saint John, IN 46373

    $635,000

    • 4 Beds
    • 4 Baths
    • 4,782 Sq Ft
    • 8592 Ventura Trails Dr
    • Saint John, IN

    Welcome to this beautifully updated two-story home in the highly desirable Ventura Estates of St. John-a perfect blend of space, style, and comfort. Inside, you'll find an open-concept eat-in kitchen featuring tall cabinetry, abundant storage, and newer appliances, seamlessly flowing into the bright and spacious family room--ideal for entertaining or everyday living.Natural light pours in through

    Fatimah Amara Keller Williams Realty Group

    Section Image
  • 9511 W 100th Ave, Saint John, IN 46373

    $849,900

    • 5 Beds
    • 3.5 Baths
    • 3,293 Sq Ft
    • 9511 W 100th Ave
    • Saint John, IN

    Stunning new construction home blending luxurious design with exceptional functionality--ready for immediate occupancy! Situated on a corner lot in the highly sought-after North Gate subdivision of St. John, this 5-bedroom, 4-bathroom Craftsman-style residence offers refined living across two expansive stories. At the heart of the home is a dramatic two-story Great Room, filled with natural light

    Jana Caudill eXp Realty, LLC

    Section Image
  • 10000 White Jasmine Dr, Saint John, IN 46373

    $777,000

    • 5 Beds
    • 3 Baths
    • 3,111 Sq Ft
    • 10000 White Jasmine Dr
    • Saint John, IN

    Welcome to your dream home! This stunning 5-bedroom, 3-bath residence offers exquisite design and modern amenities, perfect for comfortable living and entertaining. As you enter, you're greeted by elegant hardwood floors that flow throughout the main level, enhancing the warmth and sophistication of the space. The main level features a spacious bedroom with a convenient 3/4 bath, ideal for guests

    Lisa Grady McColly Real Estate

    Section Image
  • 9238 Olcott Ave, Saint John, IN 46373

    $549,900

    • 4 Beds
    • 4 Baths
    • 2,968 Sq Ft
    • 9238 Olcott Ave
    • Saint John, IN

    Welcome to this stunning St. John ranch that truly has it all! Sitting on a lush 1/2 acre lot, this 4 bdrm, 4 bathroom showstopper features nearly 3,000 sq ft of beautifully finished space - perfect for relaxing, entertaining and everything in between. Main level highlights include: Spacious kitchen w/cherry cabinets, granite counters, SS appliances, island, under cabinet lighting, and a huge

    Karen Simnick Century 21 Circle

    Section Image
  • 8417 Willow Haven Dr, Saint John, IN 46373

    $739,900

    • 5 Beds
    • 4 Baths
    • 2,861 Sq Ft
    • 8417 Willow Haven Dr
    • Saint John, IN

    UNDER CONSTRUCTION! Don't miss this adorable modern farmhouse with all the spaces you'll love and a price you'll love too! 5 bedrooms, 4 baths include a main level guest suite, jack and jill bathroom for bedrooms 2 & 3 and bedroom 4 ensuite. Primary bedroom has it's own spa bath w/ glass enclosed tile shower & freestanding tub. The 2 story foyer is accented by an open staircase leading to the

    Dawn Veness McColly Real Estate

    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
The M & M Family Trust -- Chicago Title Insurance Co
Allegretti James -- Ticor Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open The M & M Family Trust $442,000
Closed M & M Family Trust $417,000
Closed The M & M Family Trust $417,000
Previous Owner Allegretti James $315,000
Previous Owner Allegretti James $100,000
Previous Owner Allegretti James $183,000
Previous Owner Allegretti James $359,650
Previous Owner Allegretti James M $119,350
Previous Owner Newcastle Homes Llc $315,563
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/12/2014 06/12/14 Sold $525,000 0.0% $151 / Sq Ft
04/28/2014 04/28/14 Pending -- -- --
01/12/2014 01/12/14 For Sale $525,000 -- $151 / Sq Ft
Source: Northwest Indiana Association of REALTORS®

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 $11,821 $600,200 $124,800 $475,400
2023 $6,185 $584,600 $124,800 $459,800
2022 $6,185 $568,700 $124,800 $443,900
2021 $5,994 $562,000 $124,800 $437,200
2020 $5,595 $516,300 $94,900 $421,400
2019 $6,153 $524,600 $94,900 $429,700
2018 $6,068 $502,700 $94,900 $407,800
2017 $5,900 $506,000 $88,100 $417,900
2016 $5,652 $490,700 $88,100 $402,600
2014 $5,582 $502,600 $88,000 $414,600
2013 $5,680 $502,100 $88,100 $414,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northwest Indiana Association of REALTORS®

MLS Number: 342409

Northwest Indiana Association of REALTORS®

APN: 45-11-28-427-010.000-035