404 E Front St
Syracuse, MO 65354
4 Beds
2 Baths
1,404 sqft (on 3 acres)
4 Beds
2 Baths
1,404 sqft
(on 3 acres)
Homes for sale near 404 E Front St
FORECLOSURE102 ACRESCONNER REALTY LLC- 0.25 ACRES
- 0.39 ACRES
- AUCTION0.27 ACRES
See more homes for sale inSyracuse
Apartments for Rent
- Results are loading
Local Information
© Google
-- mins to
Description
Orchard homestead. 3-Acre mostly fenced-in backyard. Backyard includes a tire swing, zip line and a huge oak tree perfect for a treehouse.
Young orchard includes:
*20 apple trees
*6 cherry trees (2 sour & 4 sweet)
*4 peach trees
*4 plum trees
*4 apricot trees
*1 red nectarine tree
*4 pear trees
Also includes:
*Large strawberry patch
*10 grape vines
*20 blueberry bushes
*50 native blackberry plants
*5 mulberry trees
*several black walnut trees
*Recently-planted edible Nanking cherry privacy hedge
Beautiful red bud and magnolia trees near house.
Ready-to-use chicken coop and run, 4,000sqft garden area, and a large supply of firewood. Perfectly positioned for advertising a home business along Highway 50. Wonderful school district, great neighbors, low taxes, close to Mennonite surplus stores, 20 minutes to Sedalia (ALDI, Walmart, awesome Rec Center, etc.).
Recently remodeled (built in 1950). Two separate entrances with separate bathroom - side area used to be a salon. Perfect for home office, or for hosting company.
Energy-efficient elastomeric white cooling painted roof. City water/sewage. Central AC/heat. Carport. Shed. Close to city park.
Perfect for hosting parties, camping under the stars, or working from home.
Young orchard includes:
*20 apple trees
*6 cherry trees (2 sour & 4 sweet)
*4 peach trees
*4 plum trees
*4 apricot trees
*1 red nectarine tree
*4 pear trees
Also includes:
*Large strawberry patch
*10 grape vines
*20 blueberry bushes
*50 native blackberry plants
*5 mulberry trees
*several black walnut trees
*Recently-planted edible Nanking cherry privacy hedge
Beautiful red bud and magnolia trees near house.
Ready-to-use chicken coop and run, 4,000sqft garden area, and a large supply of firewood. Perfectly positioned for advertising a home business along Highway 50. Wonderful school district, great neighbors, low taxes, close to Mennonite surplus stores, 20 minutes to Sedalia (ALDI, Walmart, awesome Rec Center, etc.).
Recently remodeled (built in 1950). Two separate entrances with separate bathroom - side area used to be a salon. Perfect for home office, or for hosting company.
Energy-efficient elastomeric white cooling painted roof. City water/sewage. Central AC/heat. Carport. Shed. Close to city park.
Perfect for hosting parties, camping under the stars, or working from home.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources.
Home Highlights
Parking
No Info
Outdoor
Patio
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
No Info
Home Details for 404 E Front St
|
|---|
Heating & Cooling Heating: Forced Air, Propane ButaneAir ConditioningCooling System: CentralHeating Fuel: Forced Air |
Levels, Entrance, & Accessibility Stories: 1Floors: Carpet, Linoleum Vinyl |
Interior Details Additional StorageStorageCeiling Fan |
Appliances & Utilities DishwasherDryerRefrigeratorWasher |
|
|---|
Exterior Home Features Roof: AsphaltExterior: VinylGardenLawnPatio |
Parking & Garage Parking Spaces: 7Parking: Carport |
|
|---|
Year Built Year Built: 1950Year Updated: 2020 |
Property Type / Style Property Type: Single Family HomeArchitecture: Ranch / Rambler |
|
|---|
Lot Area: 3.00 acres |
|
|---|
RV Parking Rv Parking |
Price History for 404 E Front St
| Date | Price | Event | Source |
|---|---|---|---|
| 10/02/2023 | ListingRemoved | N/A | |
| 09/03/2023 | $237,000 | PriceChange | N/A |
| 08/27/2023 | $221,000 | PriceChange | N/A |
| 08/08/2023 | $187,000 | PriceChange | N/A |
| 07/18/2023 | $237,000 | Listed For Sale | N/A |
- Results are loading
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | |
| Assessment | $16,700 |
Home facts updated by county records
Comparable Sales for 404 E Front St
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
4.09 | Single-Family Home | - | 02/09/26 | 3 | 2 | 3,000 | |
4.69 | Single-Family Home | - | 09/12/25 | 4 | 2.5 | 2,138 | |
5.11 | Single-Family Home | - | 07/01/25 | 3 | 2 | 2,098 | |
4.63 | Single-Family Home | - | 10/20/25 | 3 | 2.5 | 2,442 | |
4.90 | Single-Family Home | - | 10/02/25 | 3 | 2 | 1,458 | |
4.99 | Single-Family Home | - | 02/23/26 | 4 | 2 | 1,600 | |
4.68 | Single-Family Home | - | 02/27/26 | 3 | 2.5 | 2,386 | |
5.01 | Single-Family Home | - | 03/04/26 | 2 | 2 | 1,250 | |
5.16 | Single-Family Home | - | 05/28/25 | 3 | 2 | 1,070 | |
5.15 | Single-Family Home | - | 10/06/25 | 2 | 2 | 1,288 |
Assigned Schools
These are the assigned schools for 404 E Front St.
- Tipton High School
- 9-12
- Public
- 206 Students
8/10GreatSchools RatingParent Rating AverageSmall Community really supports this school. Great teachers and administration. School board members attended this school and their children do now. Kids participate in multiple activities.Other Review9y ago - Tipton Elementary School
- PK-5
- Public
- 258 Students
4/10GreatSchools RatingParent Rating AverageN/AOther Review18y ago - TIPTON MIDDLE SCHOOL
- 6-8
- Public
- 138 Students
2/10GreatSchools RatingParent Rating Average
No reviews available for this school. 
Check out schools near 404 E Front St.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Homes for rent near 404 E Front St
- Results are loading
Off Market Homes Near 404 E Front St
- Results are loading
404 E Front St, Syracuse, MO 65354 is a 4 bedroom, 3 bathroom, 1,404 sqft single-family home built in 1950. This property is not currently available for sale. The current Trulia Estimate for 404 E Front St is $198,600.