***Live like every day's a vacation in this 5,000+ sq ft Renaissance poolside paradise.*** In St. John's prestigious Renaissance subdivision, this 5-bedroom, 3-bath stunner delivers the perfect mix of luxury, space, and location. A main-level guest suite, soaring two-story great room drenched in natural light, and a gourmet kitchen with premium finishes set the stage for unforgettable living. Upstairs, the primary suite is a true retreat with a spa-style bath and generous walk-in closet. The finished basement adds over 1,500 sq ft of all-seasons living-full second kitchen, massive rec room, private guest quarters, and dedicated gym. Outside, the backyard becomes your private resort with a sparkling in-ground pool, expansive patio, and lush green lawn on a corner lot. Add a 3-car garage, top-rated Lake Central schools, and quick access to parks, trails, dining, shopping, and Chicago, and you have a home that's as rare as it is ready.
Active
$899,999
9875 Aster Cove St, John, IN 46373
6beds
5,071sqft
Est.:
Single Family Residence
Built in 2013
0.29 Acres Lot
$-- Zestimate®
$177/sqft
$42/mo HOA
What's special
Poolside paradiseFinished basementMain-level guest suiteSparkling in-ground poolExpansive patioPrivate guest quartersDedicated gym
- 16 days
- on Zillow |
- 823 |
- 47 |
Zillow last checked: 7 hours ago
Listing updated: August 18, 2025 at 10:07pm
Listing courtesy of:
Jorge Vega 312-444-0981,
New Avenue Realty LLC
Source: MRED as distributed by MLS GRID,MLS#: 12444558

Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Rooms
- Room types: Bedroom 5, Mud Room, Sitting Room, Breakfast Room, Foyer, Walk In Closet, Bedroom 6, Exercise Room, Kitchen
Primary bedroom
- Features: Flooring (Carpet), Window Treatments (Blinds), Bathroom (Full, Double Sink, Tub & Separate Shwr)
- Level: Second
- Area: 300 Square Feet
- Dimensions: 15X20
Bedroom 2
- Features: Flooring (Carpet), Window Treatments (Blinds)
- Level: Second
- Area: 228 Square Feet
- Dimensions: 12X19
Bedroom 3
- Features: Flooring (Carpet)
- Level: Second
- Area: 196 Square Feet
- Dimensions: 14X14
Bedroom 4
- Features: Flooring (Carpet)
- Level: Main
- Area: 156 Square Feet
- Dimensions: 13X12
Bedroom 5
- Features: Flooring (Hardwood)
- Level: Main
- Area: 182 Square Feet
- Dimensions: 14X13
Bedroom 6
- Features: Flooring (Other)
- Level: Basement
- Area: 180 Square Feet
- Dimensions: 15X12
Breakfast room
- Features: Flooring (Hardwood)
- Level: Main
- Area: 117 Square Feet
- Dimensions: 13X9
Dining room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 192 Square Feet
- Dimensions: 12X16
Exercise room
- Features: Flooring (Other)
- Level: Basement
- Area: 187 Square Feet
- Dimensions: 17X11
Family room
- Features: Flooring (Other)
- Level: Basement
- Area: 1053 Square Feet
- Dimensions: 39X27
Foyer
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 64 Square Feet
- Dimensions: 8X8
Kitchen
- Features: Kitchen (Eating Area-Breakfast Bar), Flooring (Hardwood)
- Level: Main
- Area: 169 Square Feet
- Dimensions: 13X13
Kitchen 2nd
- Features: Flooring (Other)
- Level: Basement
- Area: 195 Square Feet
- Dimensions: 15X13
Laundry
- Features: Flooring (Other)
- Level: Second
- Area: 54 Square Feet
- Dimensions: 6X9
Living room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 832 Square Feet
- Dimensions: 26X32
Mud room
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 63 Square Feet
- Dimensions: 9X7
Sitting room
- Features: Flooring (Hardwood)
- Level: Main
- Area: 156 Square Feet
- Dimensions: 13X12
Walk in closet
- Features: Flooring (Carpet)
- Level: Second
- Area: 72 Square Feet
- Dimensions: 8X9
Walk in closet
- Features: Flooring (Carpet)
- Level: Second
- Area: 72 Square Feet
- Dimensions: 12X6
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Range, Microwave, Dishwasher, Refrigerator, Water Purifier Owned, Water Softener Owned
- Laundry: Upper Level, Gas Dryer Hookup, In Unit, Sink
Features
- Vaulted Ceiling(s), Cathedral Ceiling(s), 1st Floor Bedroom, In-Law Floorplan, 1st Floor Full Bath, Walk-In Closet(s), High Ceilings, Coffered Ceiling(s), Open Floorplan, Separate Dining Room
- Flooring: Hardwood
- Windows: Screens
- Basement: Finished,Full
- Number of fireplaces: 1
- Fireplace features: Wood Burning, Gas Starter, Living Room
Interior area
- Total structure area: 5,071
- Total interior livable area: 5,071 sqft
Property
Parking
- Total spaces: 3
- Parking features: Concrete, Garage Door Opener, On Site, Garage Owned, Attached, Garage
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: No Disability Access
Features
- Stories: 2
- Patio & porch: Patio
- Pool features: In Ground
- Fencing: Fenced
Lot
- Size: 0.29 Acres
- Features: Corner Lot
Details
- Additional structures: Gazebo
- Parcel number: 451134326022000035
- Special conditions: List Broker Must Accompany
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Vinyl Siding, Brick
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2013
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Features: Pool
HOA
- Has HOA: Yes
- Services included: Other
- HOA fee: $508 annually
Location
- Region: John
Financial & listing details
- Price per square foot: $177/sqft
- Annual tax amount: $5,718
- Date on market: 8/13/2025
- Ownership: Fee Simple
- Loading
- Loading