**Only Real Estate being sold, business not included**Turn key business opportunity in Ida Township! Spanning 5,200 sq ft and situated on over an acre, this completely renovated commercial property blends modern updates with versatile space. The front of the building features a dedicated showroom to welcome customers, while the finished office area includes a kitchen and bathroom for day-to-day convenience. Above the warehouse you’ll find loft storage, ideal for keeping operations organized. The heart of the property is the expansive warehouse, offering high ceilings, open floor space, and flexible use for storage, equipment, or light industrial needs. With a brand new roof and recent renovations throughout, this property is move-in ready, providing endless opportunities for retail, service, or industrial businesses to thrive.
Sold for $500,000 on 12/11/25
$500,000
5770 Lewis Ave, Ida, MI 48140
1beds
5,200sqft
Single Family Residence
Built in 1979
1.01 Acres Lot
$500,200 Zestimate®
$96/sqft
$-- Estimated rent
Home value
$500,200
$475,000 - $525,000
Not available
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: December 11, 2025 at 01:23pm
Listed by:
Jacob Levicki 734-347-5295,
eXp Realty LLC in Monroe
Bought with:
Ashley Begeman, 6501371861
Key Realty One LLC - Ida
Source: MiRealSource,MLS#: 50190147
Originating MLS: Southeastern Border Association of REALTORS
Originating MLS: Southeastern Border Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 1
- Bathrooms: 1
- Full bathrooms: 1
- Main level bathrooms: 1
- Main level bedrooms: 1
Bedroom 1
- Level: Main
- Area: 800
- Dimensions: 40 x 20
Bathroom 1
- Level: Main
Dining room
- Level: Main
- Area: 264
- Dimensions: 11 x 24
Kitchen
- Level: Main
- Area: 216
- Dimensions: 9 x 24
Living room
- Level: Main
- Area: 480
- Dimensions: 20 x 24
Heating
- Forced Air, Natural Gas
Features
- Has basement: No
- Has fireplace: No
Interior area
- Total structure area: 5,200
- Total interior livable area: 5,200 sqft
- Finished area above ground: 5,200
- Finished area below ground: 0
Property
Parking
- Total spaces: 15
- Parking features: Attached
- Attached garage spaces: 15
Features
- Levels: One
- Stories: 1
- Frontage type: Road
- Frontage length: 101
Lot
- Size: 1.01 Acres
- Dimensions: 101 x 282 x irregular
Details
- Parcel number: 0801501920
- Special conditions: Private
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence
Materials
- Steel
- Foundation: Slab
Condition
- Year built: 1979
Utilities & green energy
- Sewer: Septic Tank
- Water: Private Well
Community & neighborhood
Location
- Region: Ida
- Subdivision: None
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 12/11/2025 | Sold | $500,000-9.1%$96/sqft |
Source:  MiRealSource #50190147 | ||
| 10/22/2025 | Pending sale | $550,000$106/sqft |
Source: MiRealSource #50190147 | ||
| 10/1/2025 | Listed for sale | $550,000$106/sqft |
Source: MiRealSource #50190147 | ||
Public tax history
Tax history is unavailable.
Neighborhood: 48140
Nearby schools
GreatSchools rating
- 7/10Ida Middle SchoolGrades: 5-8Distance: 2.7 mi
- 8/10Ida High SchoolGrades: 9-12Distance: 2.7 mi
- 5/10Ida Elementary SchoolGrades: PK-4Distance: 2.8 mi
Schools provided by the listing agent
- District: Ida Public School District
Source: MiRealSource. 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.