One level living in Hunters Crossing with a pool! Move in ready and updated: 2 bedrooms 2 baths with a bonus office and an in ground fiberglass pool just in time to cool off during the hot summer days! The home and pool sits on 2 lots and has a bonus extra full lot to the west giving you options to expand. All one level home with new neutral colored LVP flooring throughout the home. All heat/cooling vents have been professionally cleaned and furnace filter changed. Enclosed porch overlooks the new deck. Lots of closets and a main floor laundry includes washer/dryer. Great room has vaulted ceilings and LVP flooring. Kitchen has oak cabinetry, island with sink, roll out cabinetry shelves, walk in pantry, and includes refrigerator and newer gas range. Primary bedroom has tray ceiling, walk in closet, tiled floor and tiled tub/shower. Attic over garage houses furnace and gas water heater, and lots of storage space. Also has a storm closet in garage. All pool pumps, equipment and solar and winter cover included. City water and sewer but not in city limits. Great location close to schools, shopping and US 31.
Closed
Zestimate®
$295,000
823 Frontier Dr, Rochester, IN 46975
2beds
1,561sqft
Single Family Residence
Built in 2005
0.51 Acres Lot
$295,000 Zestimate®
$--/sqft
$1,445 Estimated rent
Home value
$295,000
$280,000 - $310,000
$1,445/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: January 27, 2026 at 07:13am
Listed by:
Lisa Goodman 574-835-0986,
LAKESHORE RLTRS, INCR
Bought with:
Abigail Renie
LAKESHORE RLTRS, INCR
Source: IRMLS,MLS#: 202525332
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
- Main level bedrooms: 2
Bedroom 1
- Level: Main
Bedroom 2
- Level: Main
Dining room
- Level: Main
- Area: 88
- Dimensions: 11 x 8
Kitchen
- Level: Main
- Area: 171
- Dimensions: 19 x 9
Living room
- Level: Main
- Area: 324
- Dimensions: 18 x 18
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Refrigerator, Washer, Dryer-Gas, Exhaust Fan, Gas Range, Gas Water Heater
- Laundry: Main Level
Features
- Built-in Desk, Walk-In Closet(s), Kitchen Island, Pantry, Main Level Bedroom Suite
- Flooring: Vinyl
- Has basement: No
- Attic: Pull Down Stairs
- Has fireplace: No
- Fireplace features: None
Interior area
- Total structure area: 1,561
- Total interior livable area: 1,561 sqft
- Finished area above ground: 1,561
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage Door Opener, Concrete
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck, Enclosed
- Pool features: In Ground
Lot
- Size: 0.51 Acres
- Dimensions: 68x106 71x106, 68x106
- Features: Level, City/Town/Suburb
Details
- Additional parcels included: 2507-07-500-013.000-008
- Parcel number: 250707500014.000008
- Other equipment: Pool Equipment
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Slab
- Roof: Asphalt,Shingle
Condition
- New construction: No
- Year built: 2005
Utilities & green energy
- Electric: Duke Energy Indiana
- Gas: NIPSCO
- Sewer: City
- Water: City
Community & neighborhood
Location
- Region: Rochester
- Subdivision: Hunters Crossing
Other
Other facts
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 1/27/2026 | Sold | $295,000-4.8% |
Source:  IRMLS #202525332 Report a problem | ||
| 12/31/2025 | Pending sale | $309,999 |
Source: IRMLS #202525332 Report a problem | ||
| 8/14/2025 | Price change | $309,999-3.1% |
Source: IRMLS #202525332 Report a problem | ||
| 7/1/2025 | Listed for sale | $320,000 |
Source: IRMLS #202525332 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $905 | $171,500 -2.1% |
| 2023 | -- | $175,200 +7.4% |
| 2022 | -- | $163,100 +16.3% |
Find assessor info on the county website
Neighborhood: 46975
Nearby schools
GreatSchools rating
- 6/10Rochester Community Md SchoolGrades: 5-7Distance: 0.2 mi
- 4/10Rochester Community High SchoolGrades: 8-12Distance: 0.2 mi
- NAColumbia Elementary SchoolGrades: PK-1Distance: 0.8 mi
Schools provided by the listing agent
- Elementary: Columbia / Riddle
- Middle: Rochester Community
- High: Rochester Community
- District: Rochester Community School Corp.
Source: IRMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.