1787 Gloucester Dr, Hamilton, OH 45014
Property image
Property image
SOLD
DEC 22, 2025

$442,000

Last sold price
  • 4 Beds
  • 3.5 Baths
  • 2,991 sqft (on 0.37 acres)

1787 Gloucester Dr, Hamilton, OH 45014

Est. Refi. Payment $2,763/mo*
Refinance Your Home
Currently Off Market - Sold Dec 22, 2025 for $442,000 (4% above list price)

Home Value

Learn more about this home's value by checking out the value of nearby homes and how much similar homes have sold for.

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
1856 Resor Rd, Fairfield, OH
0.11
Single-Family Home
$350,000
07/01/26
4
3
1,811
5803 Windermere Ln, Fairfield, OH
0.18
Single-Family Home
$387,000
06/29/26
3
2.5
2,584
5572 Kingsbury Rd, Fairfield, OH
0.42
Single-Family Home
$410,000
04/30/26
4
3.5
1,920
1770 Calumet Way, Fairfield, OH
0.24
Single-Family Home
$369,000
01/05/26
3
2
1,796
5736 Windermere Ln, Fairfield, OH
0.19
Single-Family Home
$369,300
05/13/26
3
2
1,886
1549 Christine Dr, Fairfield, OH
0.40
Single-Family Home
$339,000
02/24/26
4
2.5
2,000
5743 Jeffrey Pl, Fairfield, OH
0.49
Single-Family Home
$314,516
09/12/25
4
2.5
2,223

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
1856 Resor Rd, Fairfield, OH 45014
0.11
$350,000
4
3
1,811
Recently Sold
1803 Resor Rd, Fairfield, OH 45014
0.14
-
5
2
2,160
Off Market
1741 Resor Rd, Fairfield, OH 45014
0.10
$174,800
-
-
-
Off Market
1769 Resor Rd, Fairfield, OH 45014
0.13
$390,000
3
3
1,728
Recently Sold
5803 Windermere Ln, Fairfield, OH 45014
0.18
$387,000
3
2.5
2,584
Recently Sold
1914 Resor Rd, Fairfield, OH 45014
0.19
-
3
2.5
1,688
Off Market
5802 Windermere Ln, Fairfield, OH 45014
0.19
$418,900
3
3
2,720
Off Market
5699 Genevieve Pl, Fairfield, OH 45014
0.16
$386,900
4
2.5
2,502
Off Market
5784 Leslie Dr, Fairfield, OH 45014
0.22
$327,100
3
1.5
1,671
Off Market
5736 Windermere Ln, Fairfield, OH 45014
0.19
$369,300
3
2
1,886
Recently Sold
1903 Harrowgate Hill Ln, Fairfield, OH 45014
0.17
-
4
3.5
2,874
Off Market

Local Information

  • Map ViewExplore the area around 1787 Gloucester Dr.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Single-Family Home
Year Built
1980
Lot Size
0.37 acres
Living Area
2,991 sqft
Price/Sqft
$148/sqft
Parking
2 Car Garage
HOA
None

About this House

Welcome to 1787 Gloucester Drive. This contemporary home features four bedrooms, three full bathrooms, and one half bath. Enjoy an open-concept first floor with a wood-burning fireplace and a sun-lit kitchen that opens directly to the back deck. The first-floor primary suite offers a spacious en suite bathroom. You'll also find a first-floor laundry/mudroom, complete with storage. Upstairs, you'll find three additional spacious bedrooms and a full bath. The finished lower level provides entertaining space, including a full wet bar with abundant counter space and cabinetry, plus an additional full bathroom. Step outside to a beautiful backyard with a large deck and wooded views. Just minutes from the Village and surrounded by local parks. Recent improvements include: new roof, skylights, and windows; a new radon mitigation system; and new appliances including a washer and dryer.
1787 Gloucester Dr, Hamilton, OH 45014 is a 4 bedroom, 4 bathroom, 2,991 sqft single-family home built in 1980. It last sold for $442,000 on Dec 22, 2025 (4% above the $425,000 asking price). This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate rent is $3,607/month.
Contact this Building
Property Website
Last check for updates: about 8 hours ago
Listed by Marybeth Hoover, (513) 288-8960
Coldwell Banker Realty, (513) 321-9944
Megan S Stacey, (513) 702-8886
Coldwell Banker Realty, (513) 321-9944
Bought with: David Hirschman, (513) 888-4666, Comey & Shepherd, (513) 231-2800
Originating MLS: Cincinnati Area Multiple Listing Service
Source: Cincy MLS, MLS#1862483
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Zillow, Inc. are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Zillow, Inc. does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved

Home Details for 1787 Gloucester Dr

Interior Features

Interior Details
Basement: Full,Finished,Walk-Out AccessNumber of Rooms: 12Types of Rooms: Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Master Bathroom, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Dining Room, Family Room, Kitchen, Living Room, Office
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 3Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 2991 Square Feet
Appliances & Utilities
Appliances: Dishwasher, Double Oven, Dryer, Electric Cooktop, Disposal, Microwave, Refrigerator, Washer, Electric Water HeaterDishwasherDisposalDryerMicrowaveRefrigeratorWasher
Heating & Cooling
Heating: Electric,Heat PumpHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Electric
Fireplace & Spa
Fireplace: Living Room
Gas & Electric
Gas: None
Windows, Doors, Floors & Walls
Window: Double Hung, Insulated Windows
Levels, Entrance, & Accessibility
Stories: 2Levels: Two
View
No View

Exterior Features

Exterior Home Features
Roof: ShinglePatio / Porch: DeckFoundation: Concrete PerimeterNo Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageHas Open ParkingParking Spaces: 2Parking: Driveway
Water & Sewer
Sewer: Public Sewer

Property Information

Year Built
Year Built: 1980
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Contemporary/Modern
Building
Construction Materials: Wood SidingNot a New Construction
Property Information
Parcel Number: A0700092000044

Price & Status

Price
List Price: $425,000Price Per Sqft: $148/sqftPrice Range: $0 - $425,000
Status Change & Dates
Possession Timing: Negotiable

Active Status

MLS Status: Sold

Location

Direction & Address
City: Fairfield
School Information
High School District: Fairfield City SD

Building

Building Area
Building Area: 2991 Square Feet

HOA

Association for this Listing: Cincinnati Area Multiple Listing ServiceNo HOA

Lot Information

Lot Area: 0.37 acres

Documents

Disclaimer: Information has not been verified, is not guaranteed and subject to change.<BR>Copyright</A> &copy;2026 <A name="trans">MLS of Greater Cincinnati, Inc. All rights reserved.</A><BR>

Offer

Listing Terms: No Special Financing, Conventional

Miscellaneous

BasementMls Number: 1862483Listing Url

Price and Tax history

DateEventPrice
Dec 22, 2025
Source: Cincy MLS #1862483
Sold
$442,000
Nov 22, 2025
Source: Cincy MLS #1862483
Pending
$425,000
Nov 20, 2025
Source: Cincy MLS #1862483
Listed For Sale
$425,000
Oct 21, 2019
Source: Cincy MLS #1627857
Sold
$290,000
Sep 11, 2019
Source: Agent Provided
Pending
$319,900

Market trends in Fairfield

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$252K
$7.5KMoM
Sale-to-List Price
99.8%
0.5%MoM
Price per sq ft
$156
$1MoM
Available listings
97
9MoM

Around this home

What Locals Say about Fairfield

At least 351 Trulia users voted on each feature.

  • 87 % Say it's dog friendly

  • 84 % Say car is needed

  • 80 % Say parking is easy

  • 76 % Say there are sidewalks

  • 72 % Say yards are well-kept

  • 71 % Say there's holiday spirit

  • 68 % Say kids play outside

  • 67 % Say people would walk alone at night

  • 66 % Say it's quiet

  • 60 % Say streets are well-lit

  • 55 % Say there's wildlife

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

  • 51 % Say neighbors are friendly

  • 46 % Say it's walkable to restaurants

  • 43 % Say it's walkable to grocery stores

  • 28 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Psflight87
    "There’s space as well as sidewalks. I believe there’s a park where you can walk your dog also……….. "
    0
    Flag
  • Psflight87
    "Fairfield is a pretty safe place to live. Especially for the kids. It’s quiet and not too much happens "
    0
    Flag
  • Greg Williams
    "They need to research the area before making a decision to move out here. Traffic is extremely bad in the mornings and afternoons "
    0
    Flag
  • Barb Niehaus
    "There’s sidewalks and a nice dog park close by, and a lot of my neighbors are always out walking their dogs. The only bad thing is is that the dog park gets pretty crowded on the weekends so you do have to watch what time you go to the dog park "
    0
    Flag
  • Barb Niehaus
    "Minutes away from any store, there’s gas stations close by and a few grocery stores are a reasonable distance "
    0
    Flag
  • Trulia User
    "Great places like parks for dogs. Easy sidewalk access. Friendly neighbors and plenty of other dogs to play with in the area. "
    0
    Flag
  • Stephen Opoku
    "Great schools in the city. Shopping centers in and around. Parks and play grounds for families. Peaceful overlooking all."
    0
    Flag
  • Shea Wissmann
    "Neighbors look out for each other. Very convenient location but does have above average commuter traffic to get to the highways. Apartment complexes complex nearby creates this traffic."
    0
    Flag
  • Frankiesmommy789
    "Schools are multicultural and the area has tons of sports and other activities that children of all ages can get involved in! "
    5
    Flag
  • Robert D.
    "Great parks it's safe neighborhood is clean walking distance to restaurants the library in different little shops"
    0
    Flag
  • Kelena12.com
    "At the library sometimes there is a movie they’d play for all of Fairfield to come to. Then sometimes there is a church party "
    1
    Flag
  • Lehangcarr
    "Good place to live ! People friendly have a lot of activity to do ! Dog park ! Has a best market jungle Jim’s internationals market "
    0
    Flag
  • Timothy E.
    "People walk around the neighborhood a lot. Whether it’s a couple of friend power walking or a family walking their dog, it’s a very walk friendly neighborhood."
    0
    Flag
  • Govikings1222
    "I have great access to the highway and gasoline on the way. There are plenty of stores and restaurants also on my way to and from work. Location puts me within 30 minutes drive to everything. "
    1
    Flag
  • Connorbwh
    "Fairfield High School Sucks because it’s riddled with drugs and kids who constantly fight. If a good public school isn’t in your interest then I’d like to point out the serious lack of public transportation. The only thing good I can say about Fairfield is that it has a very diverse community."
    3
    Flag
  • Amanda S.
    "It’s a great neighborhood and safe place to live for me and my kids. I live close to everything food and gas."
    0
    Flag
  • Mike S.
    "my in-laws live here and they love it... neighborhood is nice and everyone has been so nice. since we have been here. "
    0
    Flag
  • Britney
    "I've lived in this neighborhood on and off for 15 years and it's always been great! quiet, friendly and clean. good school district and overall nice neighborhood to live in. "
    0
    Flag
  • Matt W.
    "Faiffield hosts summer concerts. Catholic parish hosts a large summer fair. Lot's of restaurants, golfing, parks, library, grocery & retail outlets."
    0
    Flag
  • Karen F.
    "The fireworks and the parade the they help the community and we are very friendly here . I like that it had a Kroger and the school are great. "
    0
    Flag
  • Karenforester78
    "it is a very nice place to live. And I would life here for even. And the store are not far and the restaurant are nice."
    0
    Flag
  • Taylor R.
    "July 3rd Red white and kaboom, in the summer every thursday night there is concerts, there is a car show in september, in the summer they have farmers market, there is a homecoming parade."
    0
    Flag
  • Joshua H.
    "It’s a great place to live and I would recommend people to this area very safe friendly and welcoming place "
    0
    Flag
  • Msmibrich@gmail.com
    "We need better access to public transportation, my commute to downtown is about 25min considering traffic. "
    0
    Flag
  • Malika R.
    "It looks nice and friendly. I love the accessibility to all necessary things (shops, restaurants, physicians, etc.) "
    0
    Flag
  • Melody S.
    "I love dogs! I clean up after my dogs! I think the dogs make our world better! I love my neighbor hood!"
    0
    Flag
  • Pete A. K. J.
    "Everyone controls their dogs, you always see neighbors walking their dogs and most dogs seem very socialized..."
    0
    Flag
  • Trish Y
    "I am not currently needing to commute in any capacity. Driving seems clear cut and well marked. Great gas prices "
    2
    Flag
  • Diane W.
    "We love the going to the weekly farmers market on Wednesday , concerts on Thursday and Friday night movies on the Village Green! "
    2
    Flag
  • Vina j
    "I've lived in the area for almost 18 years, great schools. Safe and quiet neighborhood. Close to hospitals, resteraunts and interstate."
    0
    Flag
  • Andrew C.
    "most areas are all dog/pet-friendly now. common areas are equipped with pet waste bags and garbage cans to throw them away in. dog parks seem to be popping up everywhere, with dog-friendly restaurants following suit. "
    0
    Flag
  • Amanda J.
    "I have lived in this neighborhood for almost 3 years and it’s always nice to see a friendly face. Having a feeling of security where we live isn’t something you find everyday."
    3
    Flag
  • Nichol G.
    "there are s lot of community garage sales. there are also a lot of car shows there isn't much else that goes on"
    1
    Flag
  • Adam b.
    "Very friendly area thats close to everything. No kids in school but i here they’re good too. Parks are abundant and close as well."
    0
    Flag

LGBTQ Local Legal Protections

Frequently asked questions about 1787 Gloucester Dr

  • What is the price history for 1787 Gloucester Dr?
    1787 Gloucester Dr in Hamilton, OH last sold for $442,000 in December 2025.
  • Is Hamilton a buyer's or seller's market?
    Hamilton is currently a buyer's market, based on recent for-sale activity.
  • What's the median sale price in Hamilton?
    The median sale price in Hamilton is $252K. That is down $7.5K from the prior month.
  • What do residents say about Hamilton?
    Residents describe Hamilton, OH as dog-friendly, easy to park in, and pedestrian-friendly. See recently sold homes in Hamilton, OH.
  • Does 1787 Gloucester Dr have air conditioning?
    Yes, 1787 Gloucester Dr in Hamilton, OH has air conditioning.
  • Does 1787 Gloucester Dr have laundry facilities?
    Yes, 1787 Gloucester Dr in Hamilton, OH has in-unit laundry.

Explore by feature - Pet Friendly

67 pet-friendly rentals in Hamilton, OH

Explore by feature - Garage

31 rentals with a garage in Hamilton, OH

Explore by feature - Air Conditioning

81 rentals with air conditioning in Hamilton, OH

Explore by feature - Pool

23 rentals with a pool in Hamilton, OH

Explore by feature - Washer/dryer

66 rentals with a washer/dryer in Hamilton, OH

Explore by feature - Outdoor Space

12 rentals with an outdoor space in Hamilton, OH

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 1787 Gloucester Dr

Skip to last item
Skip to first item

Homes for sale near 1787 Gloucester Dr

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item