174 Front St, Middletown, CT 06457
OFF MARKET

174 Front St
Middletown, CT 06457

  • 3 Beds
  • 2 Baths
  • 1,506 sqft

$362,400

Trulia Estimate
as of Jun 29, 2026
Est. Refi. Payment $2,451/mo*
Refinance Your Home

$362,400

Trulia Estimate
as of Jun 29, 2026
Est. Refi. Payment $2,451/mo*
Refinance Your Home
3 Beds
2 Baths
1,506 sqft

Local Information

  • Map ViewExplore the area around 174 Front St.
  • Schools1 Preschool School1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Description

South Farms location of Middletown, this 2 family provides a great opportunity for an owner occupied investment! Live in the first floor and collect rent from the tenant upstairs. Great condition with many improvements. New roof, New boiler & water storage tank (2013), windows (2008), updated electrical, and newer oil tank. The 1st floor unit offers 2 bedrooms, 1 bath, updated kitchen with SS appliances, newer carpets, hardwood floors and its own deck off the back. The 2nd floor unit has 1 bedroom, 1 bath, and has been updated. There is a wall A/C unit on the 2nd floor only. There is even a 2 car garage! Move right into this property and continue to collect the rent from 2nd floor tenant! Heat/Hot water are included in monthly rent. Seller is ready to sell!
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
Garage
Outdoor
Deck
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
Less than a day ago

Home Details for 174 Front St

Interior Features

Interior Details
BasementNumber of Rooms: 7
Heating & Cooling
Heating: Baseboard, OilAir ConditioningCooling System: WallHeating Fuel: Baseboard
Levels, Entrance, & Accessibility
Stories: 2
Appliances & Utilities
DryerRefrigerator

Exterior Features

Exterior Home Features
Roof: AsphaltDeckExterior: Other
Parking & Garage
GarageParking Spaces: 2Parking: Garage Detached, Off Street

Property Information

Year Built
Year Built: 1919Year Updated: 1991
Property Type / Style
Property Type: Multi Family

Community

Units in Building: 2

Lot Information

Lot Area: 6098 sqft

Price History for 174 Front St

DatePriceEventSource
05/14/2018$183,400Sold
Smart MLS #170053761
02/27/2018$190,000Listed For SaleAgent Provided
10/11/2017$164,900ListingRemovedAgent Provided
09/19/2017$164,900PriceChange
Agent Provided
09/05/2017$169,900PriceChange
Agent Provided
09/01/2017$179,900PriceChange
Agent Provided
08/06/2017$184,900PriceChange
Agent Provided
07/19/2017$189,900PriceChange
Agent Provided
05/10/2017$194,900PriceChange
Agent Provided
04/20/2017$199,900Listed For SaleAgent Provided
06/20/2016$199,900ListingRemovedAgent Provided
02/20/2016$199,900Listed For SaleAgent Provided
11/10/2015$1,300ListingRemovedAgent Provided
10/30/2015$1,300Listed For RentAgent Provided
09/29/2014$187,000ListingRemovedAgent Provided
05/21/2014$187,000Listed For SaleAgent Provided
01/09/1998$75,900Sold
N/A

Market trends in Middletown

Last updated May 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$282K
$833MoM
Sale-to-List Price
102.3%
1.5%MoM
Price per sq ft
$235
$19MoM
Available listings
84
19MoM
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$5,930
Assessment$160,220
Home facts updated by county records

Comparable Sales for 174 Front St

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
132 Front Street, Middletown, CT
0.08
Multi-Family Home
$310,000
07/22/25
4
2
2,016
2 Wall St, Middletown, CT
0.32
Multi-Family Home
$335,000
09/02/25
3
2
2,526
116 Front Street, Middletown, CT
0.11
Multi-Family Home
$395,000
07/21/25
6
2
2,579
73 Durant Street, Middletown, CT
0.42
Multi-Family Home
$366,500
12/29/25
6
2
2,417
102 Main St Extension, Middletown, CT
0.68
Multi-Family Home
$405,000
12/18/25
4
2
1,518
2 Millbrook Rd, Middletown, CT
0.45
Multi-Family Home
$360,000
07/01/25
4
2
1,872
37 Hotchkiss St, Middletown, CT
0.94
Multi-Family Home
$198,635
10/20/25
4
2
1,616
74 Mill Street, Middletown, CT
0.71
Multi-Family Home
$330,000
08/12/25
4
2
1,944
156 South Main Street, Middletown, CT
0.71
Multi-Family Home
$388,000
10/31/25
4
2
2,214
1 Jefferson Avenue, Middletown, CT
0.29
Multi-Family Home
$500,000
03/18/26
5
3
3,546

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 174 Front St.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Middletown

At least 386 Trulia users voted on each feature.

  • 84 % Say it's dog friendly

  • 82 % Say car is needed

  • 74 % Say parking is easy

  • 73 % Say there's holiday spirit

  • 71 % Say there are sidewalks

  • 62 % Say yards are well-kept

  • 62 % Say people would walk alone at night

  • 61 % Say streets are well-lit

  • 61 % Say kids play outside

  • 55 % Say it's quiet

  • 52 % Say it's walkable to restaurants

  • 49 % Say there's wildlife

  • 48 % Say neighbors are friendly

  • 42 % Say they plan to stay for at least 5 years

  • 38 % Say it's walkable to grocery stores

  • 23 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Travis Thomas
    "The people are very very nice. I am very comfortable here . Not afraid to leave the front door open or the slider to the deck"
    1
    Flag
  • James.sargeant30
    "My friend lives there she loves it very much good place to live with family everyone works and goes to school"
    0
    Flag
  • Julia Taylor
    "very easy to get to and from work when living in middletown! I work in Cheshire. Just hop onto 691 and in 15 min you’re there. "
    0
    Flag
  • Calm Teacher
    "Good schools for the most part and safe neighborhoods. Students don’t have to wear uniforms. The town has a lot of nice parks. "
    0
    Flag
  • Life Withsymph
    "You get to see the dogs being walked and you can pet them and talk to the owners build bonds , you will be able to see all different types of dogs and mixes "
    0
    Flag
  • Phyloren
    "Watch your children it is not safe. The schools have fights every day. The learning atmosphere is is awful. "
    0
    Flag
  • Kelly Capone
    "I haven’t lived here long and I’m not exactly sure what community events make my neighborhood special. "
    2
    Flag
  • Dlc.marie0816
    "I moved out here in June and I definitely love it.. feels like a nice place for my family, specially my kids"
    0
    Flag
  • Trulia User
    "There are dog parks everywhere, and plenty of places to walk uour dog. Even if you are in an apartment "
    3
    Flag
  • Michael W. W.
    "Wadsworth mansion has many trails. They have several public events in the summer time. There are two other state parks very close that are easily accessible by foot or car. Main Street has many restaurants that offer dine-in, carry out and delivery."
    12
    Flag
  • Joseph V.
    "Middletown is a town that has enjoyable events such as the weekly farmers market the the fall festival and during Christmas time they put up the huge Christmas trees "
    3
    Flag
  • Marquis W. G.
    "My neighborhood is surrounded by semi luxury condos and townhouses full of hard working families. Very family oriented and very peaceful. I love it here!"
    3
    Flag
  • Ishmaila L.
    "Dog owners will like the space made to them to run around and exercise. There are also doggy bags available to help pick up dog waste."
    2
    Flag
  • Marquis W. G.
    "I just moved here recently and I love the community and neighbors. The property is very clean and the neighborhood feels very family oriented "
    0
    Flag
  • Francheska M.
    "Neighbors are very friendly with a really good community sense. Conveniently close to stores and park. "
    0
    Flag
  • Shelby W.
    "The commute downtown on public transportation has changed and not as Easy. Driving downtown is 5-7 minutes. Walking is a half hour. "
    0
    Flag
  • ISA M.
    "School system is awesome in Middletown Ct. You can walk around at night time and still feel safe! I like it that much!"
    0
    Flag
  • Sekernan
    "I drive about 7 or 8 miles to work. Traffic depends on day and time of day. Never too bad. Takes 11-15 minutes to get there. I am able to walk to some stores and laundromats in the area, sidewalks make this safe"
    0
    Flag
  • Richard D.
    "The is a walking/biking trail and a dog park. Nice clean areas safe for walking and locations for waste disposal."
    0
    Flag
  • Christina Y.
    "The schools are awesome for elementary and high school and college.The food here in the restaurants are good too."
    2
    Flag
  • Chelsea C.
    "it’s good but I drive there’s never much traffic which is good and easy to get to work and drive kids to school"
    1
    Flag
  • Michelle E. B.
    "my neighborhood has access to transportation, stores, schools, hospital and is close to downtown. "
    1
    Flag
  • Marisa
    "commute is pretty good, surrounded by plenty of stores and easy access to many restaurants and everything one could need"
    0
    Flag
  • Trevor N.
    "We live near wadsworth mansion so they often have public concerts, vendors, ect. Snow school is right down the road as well. "
    1
    Flag
  • Marisa
    "i think it’s a great place to own a dog .. i have a chocolate lab myself and their are tons of sidewalks and a bike trail as well. everyone’s pretty friendly & clean up after their dogs as well"
    0
    Flag
  • Frankie T.
    "Lots of pups here in Middletown and even some dog-friendly restaurant patios! Our dog loves the walkable North End."
    1
    Flag
  • Molinaronijhana
    "We have bike shows, Christmas carriage rides and a huge tree for Christmas, trick or treating on main st and a wonderful YMCA "
    1
    Flag
  • Shellycato19
    "A lot of dogs living in the area. Not a lot of places to really run, but nice places to take a long and peaceful walk. Unfortunately a lot of owners don’t clean up after their dogs, but it’s starting g to get a little better. Overall a decent place to have pups. "
    1
    Flag
  • Shewarrens
    "It’s a beautiful place to live , It’s a very nice place to grow your kids there’s of restaurant and park and transportation if you don’t drive"
    2
    Flag
  • Asweetrdrm
    "It's a good place to live, low crime rate. Neighbors are friendly. Plenty of kids and close to schools"
    1
    Flag
  • Kurt.r.wentzell
    "There’s not a lot of traffic on my street. A lot of the neighbors have dogs and you always see people walking their dogs on leashes. There’s also a park just down the street."
    1
    Flag
  • Qcockrell
    "more activities for the kids to keep them busy and there need to be more job opportunities for the ones that are looking for a job"
    1
    Flag
  • Lisa C.
    "the neighborhood is a private road with only 1 way in/out. everyone knows everyone. no crime all neighbors have lived here since 1950s and passed houses down through generations. the elementary school is in walking distance safe neighborhood where children could play in the road and not have to worry about traffic"
    2
    Flag
  • Wolver1068.jb
    "We have a great town to raise children in and is rated one of top towns in the United States for raising children. Lots of his Tory in town and the surrounding areas. Great place to have a family vacation!"
    0
    Flag
  • Alnoor R.
    "Decent schools,safe, plenty of kid friendly space. Property taxes are high in CT. Job marked is tepid at best"
    0
    Flag
  • Jagalpure.prafull
    "Nice city and nebourhood. Good parks nearby. very well connected to major highways. Boston and New York are nearest best cities to explore. "
    0
    Flag
  • Brian
    "great central location in CT, close to downtown and highways. quiet neighborhood, but properties very close together"
    0
    Flag
  • Kathy
    "Best restaurant and nightlife scene in the area. outstanding, unique restaurants and small businesses. Plenty of daytime family events on Main street like car shows, bike shows, Christmas tree lighting. Vibrant, diverse community in a college town with a lot of great history that is still celebrated."
    0
    Flag
  • Mhasbro13
    "I’ve lived in this community for 4 years. I love the amenities offered to us. My neighbors are very friendly. Most everyone will say hello when they see you, even if they don’t know you. Great place to liven."
    0
    Flag
  • Leonardo V.
    "It is a very safe place to live..also shopping is close. The neighbors are friendly and very courteous.."
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

48 pet-friendly rentals in Middletown, CT

Explore by feature - Garage

7 rentals with a garage in Middletown, CT

Explore by feature - Air Conditioning

35 rentals with air conditioning in Middletown, CT

Explore by feature - Pool

13 rentals with a pool in Middletown, CT

Explore by feature - Washer/dryer

55 rentals with a washer/dryer in Middletown, CT

Homes for sale near 174 Front St

Skip to last item
Skip to first item

Off Market Homes Near 174 Front St

Skip to last item
Skip to first item
174 Front St, Middletown, CT 06457 is a 3 bedroom, 2 bathroom, 1,506 sqft multi-family built in 1919. This property is not currently available for sale. 174 Front St was last sold on May 14, 2018 for $183,400. The current Trulia Estimate for 174 Front St is $362,400.