Price Reduced50
$189,900
3 bd · 1 ba · 1,302 sqft
2 Columbia Circle, German Flatts, NY
Brandon Mosher · River Hills Properties LLC Lf · on 3 MLSs
Est. $1,246/mo$171/sqft · 39 days on Realty
3
Beds
2
Baths
1,020
Sqft
1882
Built
Welcome to 29 Walnut St a charming 3-bedroom, 1.5-bath home offering over 1,000 square feet of comfortable living space located in the Central Valley School District. The first floor welcomes you with a charming enclosed front porch that leads into a cozy living room, formal dining room, and nicely sized eat-in kitchen featuring ample cabinet space and updated appliances. Convenient first-floor laundry adds to the home's functionality. Upstairs you'll find three generously sized bedrooms offering plenty of space for family, guests, or a home office. The attached one-car garage is a fantastic bonus, featuring a convenient half bath, access to the full basement for additional storage, and direct access to the rear deck & backyard. Step outside to enjoy the fully fenced backyard, complete with a rear deck that creates the perfect setting for entertaining, relaxing, or enjoying warm summer evenings. Lovingly maintained, this home features a recently serviced furnace and a roof that is approximately 10 years old, providing peace of mind for its next owner. Conveniently located just minutes from Route 5S, Weller Library Park and the many amenities of the Village of Mohawk. This home offers comfort, convenience and charm.
Listing agent
Louis DeMichele Jr.
Courtesy of eXp Realty
(315) 527-4923
NYSShare · Listing S1711949
Listing agent
Louis DeMichele Jr.
Courtesy of eXp Realty
(315) 527-4923
Central New York Information Services (CNYREIS) · Listing S1711949
Listing agent
Louis DeMichele Jr.
Courtesy of eXp Realty
(315) 527-4923
New York State Alliance · Listing S1711949
Choose a source to show its complete, unblended listing record.
Showing NYSShare
$34,980
Estimated monthly payment
$1,246/mo
Loan amount $139,920. Estimate only — your actual rate and payment depend on credit, location, and lender.
2025 roll
School ratings (A+ to F) from HJN community data.
Gregory B Jarvis Middle School
5-8 · Regular · Central Valley School District
618 students · 10.7:1 student–teacher
Harry M Fisher Elementary School
PK-1 · Regular · Central Valley School District
348 students · 11.3:1 student–teacher
Herkimer High School
6-12 · Regular · Herkimer Central School District
537 students · 11.1:1 student–teacher
St Francis de Sales Early Childhood Learning Center
PK-1 · Alternative/Other
23 students · 7.9:1 student–teacher
Central Valley Academy
9-12 · Regular · Central Valley School District
615 students · 12.7:1 student–teacher
Barringer Road Elementary School
2-4 · Regular · Central Valley School District
434 students · 10.8:1 student–teacher
Herkimer-Fulton-Hamilton-Otsego Boces
KG-12 · Special Education · HERKIMER-FULTON-HAMILTON-OTSEGO BOCES
284 students · 4.5:1 student–teacher
Herkimer Elementary School
PK-5 · Regular · Herkimer Central School District
533 students · 11.1:1 student–teacher
Rings at ½ mile and 1 mile. Basemap © OpenMapTiles © OpenStreetMap contributors.
3 devices mapped within 1 mile of this home: 2 license-plate readers and 1 CCTV camera; 2 of them identified as Flock Safety devices. None within ½ mile. Nearest: 0.9 mi northeast. Operator named in the data: New York State Thruway Authority.
| Device type | Within ½ mi | Within 1 mi |
|---|---|---|
| License-plate readers | 0 | 2 |
| of which Flock Safety | 0 | 2 |
| CCTV cameras | 0 | 1 |
Community-reported via OpenStreetMap; may be incomplete. Data as of . © OpenStreetMap contributors (ODbL)
License-plate readers (ALPR) are fixed cameras that photograph passing vehicles and read their plates. Records are typically shared with the agency or association that operates the camera.
Flock Safety is a company whose plate-reader cameras are used by police departments, cities, HOAs and businesses. Its devices are usually solar-powered and pole-mounted.
CCTV cameras are fixed video cameras that record a street, building or other area.
Within 2 miles of this home: 17 restaurants and cafés, 3 grocery stores, and 8 parks and green spaces.
Place data from OpenStreetMap.
Little Caesars
Denny's
American restaurant · Mohawk Street
Dunkin' Donuts
Tony's Pizza
Subway
Mohawk Street
Applebee's
American restaurant
KFC
South Caroline Street
Taco Bell
South Caroline Street
Walmart Supercenter
North Caroline Street
ALDI
Central Avenue
Hannaford
East Albany Street
Weller Park
Myers Park
Tony Bagetta Mini Park
Russell Park
Brookwood Park
Wehrum Stadium
Ilion Park
Ilion Reservoir Number Three
Central New York Information Services (CNYREIS)New York State AllianceThis content last refreshed on 2026-10-13 03:25:21 UTC. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Price Reduced50$189,900
3 bd · 1 ba · 1,302 sqft
2 Columbia Circle, German Flatts, NY
Brandon Mosher · River Hills Properties LLC Lf · on 3 MLSs
50$199,000
4 bd · 2 ba · 1,829 sqft
3501 State Route 168, German Flatts, NY
Michael Philip Steele · Diedrich Associates Valley Realty · on 3 MLSs
50$149,900
4 bd · 3 ba · 2,252 sqft
8 Bellinger Street, German Flatts, NY
Brandon Mosher · River Hills Properties LLC Lf · on 3 MLSs
Price Reduced21$225,000
3 bd · — ba · 1,801 sqft
31 Walnut St, Mohawk, NY