Amazing Investment Opportunity with Incredible Tenant Longevity! Welcome to this charming 4-unit multi-family property offering the perfect blend of small-town village vibes and unmatched convenience. Situated in a prime location with easy access off Route 5S and just minutes from the NYS Thruway.
The property features a massive stone/gravel driveway that can comfortably accommodate up to 12 vehicles, a small rear yard ideal for relaxing on a nice summer day, and a covered front porch to welcome you home. Step inside to find timeless hardwood floors, separate electric meters, municipal electric, and a solid, dry basement.
The building boasts fantastic, long-term tenants in three of the leased units, with occupancy ranging from 7 to an incredible 30 years—a true testament to the comfort of this home. The fourth unit will be delivered vacant at the end of June, offering the perfect opportunity for an owner-occupant or for a new tenant at current market rent.
Don't miss out on adding this stable, high-potential income producer to your portfolio!
Pending
$210,000
29 Columbia St, Mohawk, NY 13407
6beds
6,024sqft
Quadruplex, Multi Family
Built in 1930
-- sqft lot
$-- Zestimate®
$35/sqft
$-- HOA
What's special
Timeless hardwood floorsSolid dry basement
- 25 days |
- 288 |
- 13 |
Zillow last checked:
Listing updated:
Listed by:
eXp Realty 888-276-0630,
Vincent DeNova 888-276-0630,
Jeanette Denney 315-240-3814,
eXp Realty
Source: NYSAMLSs,MLS#: S1688406
Originating MLS: Syracuse
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 4
- Full bathrooms: 4
Heating
- Electric, Baseboard
Appliances
- Included: Electric Water Heater
Features
- Ceiling Fan(s), Natural Woodwork, Window Treatments
- Flooring: Carpet, Hardwood, Varies, Vinyl
- Windows: Drapes, Storm Window(s), Thermal Windows, Wood Frames
- Basement: Partial
- Has fireplace: No
Interior area
- Total structure area: 6,024
- Total interior livable area: 6,024 sqft
Video & virtual tour
Property
Parking
- Parking features: Gravel, Two or More Spaces
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Porch
- Exterior features: Enclosed Porch, Porch
Lot
- Size: 8,624 Square Feet
- Dimensions: 65 x 132
- Features: Rectangular, Rectangular Lot, Residential Lot
Details
- Parcel number: 21280312004700070130000000
- Special conditions: Standard
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Fourplex
- Property subtype: Quadruplex, Multi Family
Materials
- Wood Siding, Copper Plumbing
- Foundation: Stone
- Roof: Asphalt
Condition
- Resale
- Year built: 1930
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Cable Available, High Speed Internet Available, Sewer Connected, Water Connected
Green energy
- Energy efficient items: Appliances, Windows
Community & HOA
Location
- Region: Mohawk
Financial & listing details
- Price per square foot: $35/sqft
- Tax assessed value: $50,000
- Annual tax amount: $3,108
- Date on market: 6/6/2026
- Cumulative days on market: 24 days
- Listing terms: Cash,Conventional,FHA,VA Loan
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/25/2026 | Pending sale | $210,000$35/sqft |
Source: | ||
| 6/8/2026 | Listed for sale | $210,000$35/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 13407
Nearby schools
GreatSchools rating
- 6/10Gregory B Jarvis Junior/Senior High SchoolGrades: 5-8Distance: 0.1 mi
- 4/10Central Valley AcademyGrades: 9-12Distance: 1.7 mi
- NAHarry M Fisher Elementary SchoolGrades: PK-1Distance: 0.4 mi
Schools provided by the listing agent
- District: Central Valley
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Herkimer County
- Mohawk
- 13407
- 29 Columbia St





