Gorgeous new Brookstone plan by Schmidt Builders in the beautiful brand new community of Shetland Farms featuring a soaring 2 story foyer. Very open plan offers an island kitchen with stainless steel appliances, beautiful cabinetry with quartz counters, walk-out morning room and a formal dining room all with a view to the huge great room with gas fireplace with stone surround. A flex room and full bathroom round out the first floor. Upstairs homeowners retreat with an en suite that includes 2 separate vanities, large shower, water closet and large walk-in closet. Three additional bedrooms and a centrally located hall bathroom. Full basement with full bath rough-in. 3-bay garage.
Sold for $694,900 on 07/02/25
$694,900
5874 Shetland Ct, Hamilton, OH 45011
4beds
2,868sqft
Single Family Residence
Built in ----
0.5 Acres Lot
$695,900 Zestimate®
$242/sqft
$2,851 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: July 17, 2025 at 10:03am
Listed by:
Alexander A Hencheck Jr. 513-469-2424,
HMS Real Estate 513-469-2424
Bought with:
Linda W Kunkel, 2005008312
Coldwell Banker Realty
Source: Cincy MLS,MLS#: 1791651
Originating MLS: Cincinnati Area Multiple Listing Service

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Wall-to-Wall Carpet
- Level: Second
- Area: 270
- Dimensions: 18 x 15
Bedroom 2
- Level: Second
- Area: 182
- Dimensions: 13 x 14
Bedroom 3
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom 4
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Shower, Double Shower
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Partial
- Level: First
Dining room
- Features: Formal, WW Carpet
- Level: First
- Area: 144
- Dimensions: 12 x 12
Family room
- Area: 0
- Dimensions: 0 x 0
Great room
- Features: Fireplace, Other
- Level: First
- Area: 357
- Dimensions: 21 x 17
Kitchen
- Features: Pantry, Quartz Counters, Walkout, Gourmet, Kitchen Island, Wood Cabinets, Other
- Area: 168
- Dimensions: 14 x 12
Living room
- Area: 0
- Dimensions: 0 x 0
Office
- Features: Wall-to-Wall Carpet
- Level: First
- Area: 120
- Dimensions: 12 x 10
Heating
- Program Thermostat, Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Convection Oven, Dishwasher, Disposal, Microwave, Oven/Range, Gas Water Heater
Features
- High Ceilings, Crown Molding, Recessed Lighting
- Doors: Multi Panel Doors
- Windows: Vinyl, Insulated Windows
- Basement: Full,Bath/Stubbed,Concrete
- Number of fireplaces: 1
- Fireplace features: Stone, Gas, Great Room
Interior area
- Total structure area: 2,868
- Total interior livable area: 2,868 sqft
Property
Parking
- Total spaces: 3
- Parking features: Concrete, Garage Door Opener
- Attached garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Porch
Lot
- Size: 0.50 Acres
- Features: Less than .5 Acre
Details
- Parcel number: D2020341000002
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: Yes
Details
- Builder name: Schmidt Builders
- Warranty included: Yes
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Security
- Security features: Smoke Alarm
Location
- Region: Hamilton
- Subdivision: Shetland Farms
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $55 monthly
- Association name: TBD
Other
Other facts
- Listing terms: Special Financing,Conventional
Services availability
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$695,900
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$695,900