Welcome to this extraordinary estate where timeless luxury meets everyday comfort nestled on a private court in the prestigious Rosewood Estates community on 2.6 park-like acres. A gated circular drive leads you to an awe-inspiring entry setting the tone for the timeless elegance that follows. This custom-designed home boasts 6 spacious bedrooms and 7 bathrooms, each crafted for privacy and relaxation. The main living area is nothing short of breathtaking, with soaring vaulted ceilings, rich Restoration Hardware light fixtures, and the first of two stunning fireplaces that create a warm, welcoming ambiance. The show-stopping dining room flows effortlessly through a butler pantry into the chef's kitchen, with an enormous center island, custom cabinetry, quartzite counters, walk-in pantry, while the wide-plank hickory wood flooring commands attention, the breakfast room allows access to the balcony or deck with built in Wolf grill. The massive main level laundry room includes one of the 3 washers and 3 dryers. The main level primary suite is a serene retreat with his and her closets including the 2nd washer and dryer along with a luxury bath, and its own sitting room offering peaceful views of the grounds with balcony access perfect for morning coffee or quiet moments. Upstairs, a 2nd primary suite, 3 enormous bedrooms and a massive bonus room providing flexible space for a home office, playroom, studio, or guest suite. The finished walkout basement is an entertainer's dream, featuring a full wet bar, with a gorgeous backlit gathering island, dishwasher, beverage refrigerators, billiards room, workout room with 3rd laundry facility, a light filled office & even a 3rd primary suite. Step outside to enjoy a tranquil in-ground pool, pool house, sand volleyball court overlooking the 11 acre community preserve. Parking is a breeze in the spectacular heated 5.5 car garage. Top-rated schools, shopping, dining, & minutes from the Illinois border allowing an easy commute.
Active
$3,295,000
12305 Alvina Rose Ct, Saint John, IN 46373
6beds
10,930sqft
Est.:
Single Family Residence
Built in 2005
2.59 Acres Lot
$3,053,000 Zestimate®
$301/sqft
$63/mo HOA
What's special
Tranquil in-ground poolGated circular driveFinished walkout basementFull wet barMassive bonus roomPrimary suiteEnormous bedrooms
- 26 days
- on Zillow |
- 2,959 |
- 153 |
Zillow last checked: 7 hours ago
Listing updated: August 01, 2025 at 01:39pm
Listed by:
Gina Guarino,
McColly Real Estate 219-322-5508,
Dominic Guarino,
McColly Real Estate
Source: NIRA,MLS#: 824391

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 7
- Full bathrooms: 3
- 3/4 bathrooms: 2
- 1/2 bathrooms: 2
Rooms
- Room types: Bedroom 2, Living Room, Primary Bedroom, Other Room, Office, Laundry, Kitchen, Game Room, Family Room, Exercise Room, Dining Room, Bonus Room, Bedroom 6, Bedroom 5, Bedroom 4, Bedroom 3
Primary bedroom
- Description: Sitting room, Balcony Access, Dual Closets
- Area: 521.9
- Dimensions: 30.7 x 17.0
Bedroom 2
- Description: 2nd Primary Bed, Bath, Changing Area, Walk-in-Closet
- Area: 351.56
- Dimensions: 18.7 x 18.8
Bedroom 3
- Description: Walk-in Closet, Jack and Jill Bath, Bonus Rm Access
- Area: 479.22
- Dimensions: 29.4 x 16.3
Bedroom 4
- Description: Walk-in Closet
- Area: 244.8
- Dimensions: 17.0 x 14.4
Bedroom 5
- Description: Walk-in Closet Jack and Jill Bath
- Area: 279
- Dimensions: 18.0 x 15.5
Bedroom 6
- Description: Walk-in Closet, Sitting Area, Huge En-suite Bath
- Area: 450
- Dimensions: 30.0 x 15.0
Bonus room
- Description: Bedroom 7 with Walk-In Closet
- Area: 377
- Dimensions: 26.0 x 14.5
Breakfast room
- Description: Restoration Hdwr Chandelier
- Area: 154
- Dimensions: 14.0 x 11.0
Dining room
- Area: 258.4
- Dimensions: 19.0 x 13.6
Exercise room
- Description: 3rd Laundry Closet
- Area: 374
- Dimensions: 34.0 x 11.0
Family room
- Description: Wetbar, refrigerator, 2nd Dishwasher, Pool Access
- Area: 725
- Dimensions: 29.0 x 25.0
Foyer
- Description: Main Level - Walk-in Coat Closet
- Area: 136.78
- Dimensions: 14.0 x 9.77
Game room
- Description: Billiard Room
- Area: 345.6
- Dimensions: 24.0 x 14.4
Kitchen
- Description: Huge quartzite island
- Area: 495
- Dimensions: 30.0 x 16.5
Laundry
- Description: Plenty of storage
- Area: 114.4
- Dimensions: 14.3 x 8.0
Living room
- Description: Cathedral Ceiling, Attached Entertainment
- Area: 529.2
- Dimensions: 27.0 x 19.6
Office
- Description: Overlooking Pool with door access
- Area: 140
- Dimensions: 14.0 x 10.0
Other
- Description: Bar Area
- Area: 120
- Dimensions: 16.0 x 7.5
Other
- Description: Butler Pantry
- Area: 57.75
- Dimensions: 10.5 x 5.5
Heating
- Forced Air, Natural Gas
Appliances
- Included: Dishwasher, Refrigerator, Water Softener Owned, Washer, Stainless Steel Appliance(s), Range Hood, Microwave, Gas Water Heater, Freezer, Electric Cooktop, Dryer, Disposal
- Laundry: Gas Dryer Hookup, Washer Hookup, Sink, Main Level, Lower Level, Laundry Room
Features
- Cathedral Ceiling(s), Tray Ceiling(s), Wet Bar, Walk-In Closet(s), Vaulted Ceiling(s), Recessed Lighting, Pantry, Granite Counters, Kitchen Island, His and Hers Closets, High Ceilings, Double Vanity, Entrance Foyer, Eat-in Kitchen, Ceiling Fan(s)
- Windows: Blinds
- Basement: Finished,Storage Space,Walk-Out Access,Interior Entry,Full
- Number of fireplaces: 2
- Fireplace features: Basement, Wood Burning, Gas, Living Room, Gas Log
Interior area
- Total structure area: 10,930
- Total interior livable area: 10,930 sqft
- Finished area above ground: 7,912
Property
Parking
- Total spaces: 5
- Parking features: Attached, Driveway, Oversized, Kitchen Level, Heated Garage, Garage Faces Side, Garage Door Opener
- Attached garage spaces: 5
- Has uncovered spaces: Yes
Features
- Levels: Two
- Patio & porch: Deck, Rear Porch, Patio
- Exterior features: Private Yard, Storage, Rain Gutters, Lighting
- Pool features: Heated, In Ground
- Has spa: Yes
- Spa features: Bath
- Has view: Yes
- View description: Meadow, Trees/Woods, Neighborhood
Lot
- Size: 2.59 Acres
- Features: Back Yard, Wooded, Sprinklers In Front, Paved, Private, Landscaped, Front Yard, Cul-De-Sac
Details
- Has additional parcels: Yes
- Parcel number: 451132326002000035
- Zoning description: residential
- Special conditions: Agent Owned
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Condition
- New construction: No
- Year built: 2005
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected, Natural Gas Connected, Water Connected, Sewer Connected, Electricity Connected
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Security Lights, Smoke Detector(s), Security System, Fire Alarm
- Subdivision: Rosewood Estates
HOA
- Has HOA: Yes
- Amenities included: Maintenance Grounds
- Services included: Maintenance Grounds, Maintenance Structure
- HOA fee: $750 annually
- HOA name: Rosewood Estates POA
- HOA phone: 708-214-6887
Location
- Region: Saint John
Financial & listing details
- Price per square foot: $301/sqft
- Tax assessed value: $1,364,300
- Annual tax amount: $17,923
- Date on market: 7/17/2025
- Listing agreement: Exclusive Agency
- Listing terms: Assumable,Cash,Conventional
- Loading
- Loading