9875 Aster Cove, St. John, IN 46373

$859,000
Property Type: Residential Bedrooms: 5 Baths: 4 Square Footage: 6,670 Lot Size (sq. ft.): 12,635 Status: Active
Current Price: $859,000 List Date: 3/18/2026 Last Modified: 3/27/2026

Overview

Description

Move-in ready 5-bedroom home with a private in-ground pool, finished basement with second kitchen, and 3-car garage in St. John's sought-after Renaissance subdivision. Set on a corner lot in the highly sought-after Lake Central School District, this home offers the space, layout, and features today's buyers are actively looking for. The backyard is designed for both everyday living and entertaining, with a private in-ground pool, expansive patio, and a spacious yard. Inside, the two-story great room brings in natural light and connects to a well-appointed kitchen with ample space for gathering. A main-level guest bedroom and full bath provide flexibility for guests, related living, or a home office. The finished basement adds over 1,500 square feet of living space, complete with a full second kitchen, large rec room, private guest area, and dedicated gym-ideal for extended stays, entertaining, or multi-generational living. Upstairs, the primary suite offers a comfortable retreat with a ...

Listing Details MLS# 835607

General Property Information

New Construction YN
No
Bedrooms Total
5
Bathrooms Full
3
Bathrooms Half
Yes
Bathrooms Total
4
Rooms Total
20
Accessibility Features YN
No
Above Grade Finished Area
3472
Below Grade Finished Area
3198
Living Area
6670
Living Area Source
Estimated
Year Built
2013
Garage YN
Yes
Garage Spaces
3
Lot Size Acres
0.2901
Lot Size Square Feet
12635
Lot Size Source
Estimated
Association YN
Yes
Association Fee
508
Association Fee Frequency
Annually
Association Name
The Gates of St. John
Association Phone
219-464-3536
Waterfront YN
No
Basement YN
Yes
Fireplace YN
Yes
Bathrooms Three Quarter
0
Below Grade Unfinished Area
0

Property Features

Appliances: Dishwasher; Gas Range; Gas Water Heater; Microwave; Refrigerator; Stainless Steel Appliance(s); Water Softener Owned Association Amenities: None Association Fee Includes: Maintenance Structure Basement: Finished; Full; Interior Entry; Storage Space; Sump Pump Construction Materials: Brick; Vinyl Siding Cooling: Central Air Electric: 200+ Amp Service; Generator Exterior Features: Private Yard Fencing: Back Yard; Fenced Fireplace Features: Gas; Gas Log; Living Room Flooring: Carpet; Hardwood; Tile Heating: Central; Forced Air; Natural Gas Interior Features: Cathedral Ceiling(s); Ceiling Fan(s); Crown Molding; Double Vanity; Eat-in Kitchen; Entrance Foyer; Granite Counters; High Ceilings; In-Law Floorplan; Open Floorplan; Recessed Lighting; Soaking Tub; Tray Ceiling(s); Vaulted Ceiling(s); Walk-In Closet(s) Laundry Features: Gas Dryer Hookup; Laundry Room; Sink; Upper Level; Washer Hookup Levels: 2-Sty Listing Terms: Cash; Conventional; VA Loan Lot Features: Back Yard; Corner Lot; Landscaped; Private Parking Features: Additional Parking; Attached; Concrete; Driveway; Garage Door Opener; Garage Faces Side; Oversized Patio And Porch Features: Covered; Patio Pool Features: Heated; In Ground Possession: Close Of Escrow Roof: Shingle Security Features: Carbon Monoxide Detector(s); Smoke Detector(s) Sewer: Public Sewer Special Listing Conditions: None Utilities: Electricity Connected; Natural Gas Connected View: Neighborhood Water Source: Public; Well Window Features: Bay Window(s); Insulated Windows; Storm Window(s) Room Types: Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6; Dining Room; Exercise Room; Family Room; Kitchen; Laundry; Living Room; Other Room; Primary Bedroom; Utility Room

Contract Information

Original List Price
859000
Auction YN
No
Property Sub Type
Single Family Residence
Property Attached YN
No
Listing Agreement
Exclusive Right To Sell
Seller to consider offering concessions
No
Owner Name
Indiana Land Trust Company Tr
Occupant Type
Owner

Location Tax and Legal

Street Number
9875
Street Name
Aster
Street Suffix
Cove
County
Lake
State
IN
Postal Code
46373
Subdivision Name
Renaissance #4

Remarks and Miscellaneous

Public Remarks
Move-in ready 5-bedroom home with a private in-ground pool, finished basement with second kitchen, and 3-car garage in St. John's sought-after Renaissance subdivision. Set on a corner lot in the highly sought-after Lake Central School District, this home offers the space, layout, and features today's buyers are actively looking for. The backyard is designed for both everyday living and entertaining, with a private in-ground pool, expansive patio, and a spacious yard. Inside, the two-story great room brings in natural light and connects to a well-appointed kitchen with ample space for gathering. A main-level guest bedroom and full bath provide flexibility for guests, related living, or a home office. The finished basement adds over 1,500 square feet of living space, complete with a full second kitchen, large rec room, private guest area, and dedicated gym-ideal for extended stays, entertaining, or multi-generational living. Upstairs, the primary suite offers a comfortable retreat with a spa-style bath and walk-in closet, along with additional generously sized bedrooms. Additional highlights include a 3-car garage, well-maintained interior, and a layout that balances open-concept living with functional space. Conveniently located near parks, walking trails, shopping, dining, and with easy access to commuter routes into Chicago, this home offers a combination of location, space, and features that's hard to find in today's market.

Status Change Information

Major Change Timestamp
2026-03-18T00:02:44Z
Major Change Type
New Listing
Status Change Timestamp
2026-03-17

More Information

Bathroom Totals

Basement Full
Yes
Main 1/2
Yes
Main Full
Yes
Upper Full
2

Exemption Information

Exemption YN
No

Fireplace Features

Fireplaces Total
Yes
Gas
Yes
Gas Log
Yes
Living Room
Yes

Square Footage Information

Upper Level Finished SqFt
1695
Main Level Finished SqFt
1777
Lower Level Finished SqFt
1599
Basement Level Finished SqFt
1599

Showing Requirements

Showing Instructions
Email: admin@TheNewAvenue.com with loan pre-approval/proof of funds (seller's request), agent ID, Date, Time, and cell phone number. (**24hr Notice Required** Saturday & Sunday showings preferred by owner due to their schedule)

Room Types

Bedroom 2 Level
Upper
Bedroom 3 Level
Upper
Bedroom 4 Level
Upper
Bedroom 5 Level
Main
Bedroom 6 Level
Basement
Dining Room Level
Main
Exercise Room Level
Basement
Family Room Level
Basement
Kitchen Level
Basement
Laundry Level
Upper
Living Room Level
Main
Other Room Level
Upper
Primary Bedroom Level
Upper
Utility Room Level
Basement
Bedroom 2
Yes
Bedroom 3
Yes
Bedroom 4
Yes
Bedroom 5
Yes
Bedroom 6
Yes
Dining Room
Yes
Exercise Room
Yes
Family Room
Yes
Kitchen
Yes
Laundry
Yes
Living Room
Yes
Other Room
Yes
Primary Bedroom
Yes
Utility Room
Yes

Location, Tax, and Legal

School District
Lake Central
Elementary School
Kolling Elementary School
Middle Or Junior School
Clark Middle School
High School
Lake Central High School
Tax Annual Amount
5718
Tax Year
2024
Tax Assessed Value
595300
Tax Legal Description
RENAISSANCE UNIT 4 LOT 548
Parcel Number
451134326022000035
Additional Parcels YN
No
Zoning Description
Residential
Township
St. John
Directions
From U.S. 41, head east along 101st Avenue in St. John until you reach the entrance to the Renaissance subdivision. The property is located on a corner lot, roughly two miles east of U.S. 41, with the neighborhood situated on the left-hand side.
Census Tract
426.11

Appliances

Dishwasher
Yes
Gas Range
Yes
Gas Water Heater
Yes
Microwave
Yes
Refrigerator
Yes
Stainless Steel Appliance(s)
Yes
Water Softener Owned
Yes

Association Amenities

None
Yes

Association Fee Includes

Maintenance Structure
Yes

Basement

Finished
Yes
Full
Yes
Interior Entry
Yes
Storage Space
Yes
Sump Pump
Yes

Construction Materials

Brick
Yes
Vinyl Siding
Yes

Cooling

Central Air
Yes

Electric

200+ Amp Service
Yes
Generator
Yes

Exterior Features

Private Yard
Yes

Fencing

Back Yard
Yes
Fenced
Yes

Flooring

Carpet
Yes
Hardwood
Yes
Tile
Yes

Heating

Central
Yes
Forced Air
Yes
Natural Gas
Yes

Interior Features

Cathedral Ceiling(s)
Yes
Ceiling Fan(s)
Yes
Crown Molding
Yes
Double Vanity
Yes
Eat-in Kitchen
Yes
Entrance Foyer
Yes
Granite Counters
Yes
High Ceilings
Yes
In-Law Floorplan
Yes
Open Floorplan
Yes
Recessed Lighting
Yes
Soaking Tub
Yes
Tray Ceiling(s)
Yes
Vaulted Ceiling(s)
Yes
Walk-In Closet(s)
Yes

Laundry Features

Gas Dryer Hookup
Yes
Laundry Room
Yes
Sink
Yes
Upper Level
Yes
Washer Hookup
Yes

Levels

2-Sty
Yes

Listing Terms

Cash
Yes
Conventional
Yes
VA Loan
Yes

Lot Features

Back Yard
Yes
Corner Lot
Yes
Landscaped
Yes
Private
Yes

Parking Features

Additional Parking
Yes
Attached
Yes
Concrete
Yes
Driveway
Yes
Garage Door Opener
Yes
Garage Faces Side
Yes
Oversized
Yes

Patio And Porch Features

Covered
Yes
Patio
Yes

Pool Features

Heated
Yes
In Ground
Yes

Possession

Close Of Escrow
Yes

Roof

Shingle
Yes

Security Features

Carbon Monoxide Detector(s)
Yes
Smoke Detector(s)
Yes

Sewer

Public Sewer
Yes

Special Listing Conditions

None
Yes

Utilities

Electricity Connected
Yes
Natural Gas Connected
Yes

View

Neighborhood
Yes

Water Source

Public
Yes
Well
Yes

Window Features

Bay Window(s)
Yes
Insulated Windows
Yes
Storm Window(s)
Yes

Room Information

Room Name Level Length Width Remarks
Living Room Main 26.00 32.00
Dining Room Main 12.00 16.00
Kitchen Main 13.00 13.00
Family Room Basement 39.00 27.00
Laundry Upper 6.00 9.00
Primary Bedroom Upper 15.00 20.00
Bedroom 2 Upper 12.00 19.00
Bedroom 3 Upper 14.00 14.00
Bedroom 4 Upper 13.00 12.00
Bedroom 5 Main 14.00 13.00
Other Main 13.00 12.00 Sitting Room
Foyer Main 8.00 8.00
Other Main 12.00 6.00 Walk-in Closet
Exercise Room Basement 17.00 11.00 Glass doors
Mudroom Main 9.00 7.00
Breakfast Room Main 13.00 9.00
Other Upper 8.00 9.00 2nd bedroom Walk-in Closet
Bedroom 6 Basement 15.00 12.00
Kitchen Basement 15.00 13.00 In-law kitchen
Utility Room Basement 8.00 14.00 Mechanical room
Listing Office: New Avenue Realty,LLC
Last Updated: March - 27 - 2026
This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. Copyright 2024 Triangle MLS, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.