OPEN 11/01-- 12 noon-3 pm <<<OUTSTANDING CUSTOM SMITH-BUILT COLONIAL – A TRUE SHOWSTOPPER! Welcome to this one-of-a-kind masterpiece that radiates quality, craftsmanship, and charm! Featuring a massive primary suite with dual walk-in closets and a luxurious en-suite bath, this home was built to impress. The custom gourmet chef’s kitchen, remodeled in 2022, is loaded with cabinetry, high-end appliances, and stunning Detroit Pewabic tile accents—also showcased on the fireplace in the spacious great room. Entertain in style with a formal dining room and a main-floor den that easily converts to a 5th bedroom or private home office. The fully finished walk-out basement includes a full bath and a door wall leading to a sprawling patio with a hot tub. At the same time, the elevated custom deck off the main floor offers serene views of a park-like backyard—perfect for entertaining or quiet evenings at home. Recent updates include: New roof (2022), Rear deck (2021), New carpet (2025). This home is truly custom throughout and an absolute pleasure to tour. Don’t miss your chance to own this showstopper—schedule your private showing today!
For sale
Price cut: $25K (10/30)
$774,102
339 N Alice Ave, Rochester, MI 48307
4beds
3,782sqft
Est.:
Single Family Residence
Built in 2000
6,534 Square Feet Lot
$-- Zestimate®
$205/sqft
$-- HOA
What's special
- 114 days |
- 1,336 |
- 41 |
Likely to sell faster than
Zillow last checked: 8 hours ago
Listing updated: October 30, 2025 at 12:02pm
Listed by:
Hank Mendez 586-405-3333,
Real Estate One Inc-Shelby 586-532-5500,
Haralambous Kourlos,
Real Estate One Inc-Shelby
Source: MiRealSource,MLS#: 50187381
Originating MLS: MiRealSource
Originating MLS: MiRealSourceTour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Rooms
- Room types: Den/Study/Lib, Family Room, Bedroom, Great Room, Living Room, Master Bedroom, Master Bathroom, Office, Bonus Room, Basement Lavatory, Second Flr Full Bathroom, Breakfast Nook/Room, Dining Room
Bedroom 1
- Level: Upper
- Area: 324
- Dimensions: 18 x 18
Bedroom 2
- Level: Upper
- Area: 156
- Dimensions: 13 x 12
Bedroom 3
- Level: Upper
- Area: 143
- Dimensions: 13 x 11
Bedroom 4
- Level: Upper
- Area: 110
- Dimensions: 11 x 10
Bathroom 1
- Level: Second
- Area: 120
- Dimensions: 10 x 12
Bathroom 2
- Level: Second
- Area: 100
- Dimensions: 10 x 10
Bathroom 3
- Level: Lower
- Area: 64
- Dimensions: 8 x 8
Dining room
- Level: Main
- Area: 180
- Dimensions: 15 x 12
Family room
- Level: Lower
- Area: 667
- Dimensions: 29 x 23
Great room
- Level: Main
- Area: 255
- Dimensions: 17 x 15
Kitchen
- Level: Main
- Area: 168
- Dimensions: 14 x 12
Heating
- Forced Air, Air Cleaner, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Dryer, Humidifier, Microwave, Range/Oven, Refrigerator, Washer, Gas Water Heater
- Laundry: Main Level
Features
- Sump Pump, Walk-In Closet(s), Pantry, Eat-in Kitchen
- Flooring: Ceramic Tile, Hardwood
- Basement: Finished,Walk-Out Access,Concrete
- Number of fireplaces: 1
- Fireplace features: Gas, Great Room
Interior area
- Total structure area: 3,877
- Total interior livable area: 3,782 sqft
- Finished area above ground: 2,682
- Finished area below ground: 1,100
Property
Parking
- Total spaces: 2
- Parking features: Garage, Attached, Garage Door Opener
- Attached garage spaces: 2
Features
- Levels: Multi/Split,Two
- Stories: 2
- Patio & porch: Deck, Patio, Porch
- Exterior features: Lawn Sprinkler
- Has spa: Yes
- Spa features: Bath
- Frontage type: Road
- Frontage length: 54
Lot
- Size: 6,534 Square Feet
- Dimensions: 54 x 124
- Features: Dead End, Subdivision
Details
- Parcel number: 1515126013
- Special conditions: Private
- Other equipment: Air Cleaner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Basement, Concrete Perimeter
Condition
- New construction: No
- Year built: 2000
Utilities & green energy
- Sewer: Public Sanitary
- Water: Public
- Utilities for property: Cable/Internet Avail.
Community & HOA
Community
- Subdivision: Fairview
HOA
- Has HOA: No
- Deposit fee: $0
- Application fee: $0
Location
- Region: Rochester
Financial & listing details
- Price per square foot: $205/sqft
- Tax assessed value: $721,140
- Annual tax amount: $11,138
- Date on market: 9/4/2025
- Cumulative days on market: 132 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,VA Loan
- Road surface type: Paved
Estimated market value
Not available
Estimated sales range
Not available
$4,041/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/30/2025 | Price change | $774,102-3.1%$205/sqft |
Source:  MiRealSource #50187381 Report a problem | ||
| 9/29/2025 | Price change | $799,102-4.8%$211/sqft |
Source: MiRealSource #50187381 Report a problem | ||
| 9/10/2025 | Listed for sale | $839,102-1.3%$222/sqft |
Source: MiRealSource #50187381 Report a problem | ||
| 8/27/2025 | Listing removed | $849,900$225/sqft |
Source:  Realcomp II #20251025786 Report a problem | ||
| 8/14/2025 | Listed for sale | $849,900+98.1%$225/sqft |
Source: Realcomp II #20251025786 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $10,336 +5% | $360,570 +10.8% |
| 2023 | $9,844 +6.4% | $325,330 +6.8% |
| 2022 | $9,248 -4.1% | $304,500 +0.7% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$4,732/mo
Principal & interest
$3668
Property taxes
$793
Home insurance
$271
Climate risks
Neighborhood: 48307
Nearby schools
GreatSchools rating
- 6/10McGregor Elementary SchoolGrades: PK-5Distance: 0.3 mi
- 10/10Rochester High SchoolGrades: 7-12Distance: 0.5 mi
- 8/10West Middle SchoolGrades: 6-12Distance: 1.4 mi
Schools provided by the listing agent
- District: Rochester Community School District
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading
