$674,900
PENDING NEW CONSTRUCTION $15K PRICE DROP

5874 Shetland Ct Liberty Twp., OH 45011

Estimated payment $4,311/month

Total Views 7,982
4 Beds
2.5 Baths
2,868 Sq Ft
$235 Price per Sq Ft

Highlights

  • New Construction
  • Gourmet Kitchen
  • Quartz Countertops
  • Cherokee Elementary School Rated A-
  • Traditional Architecture
  • Porch

About This Home

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.

Last Listed By

Alexander Hencheck

HMS Real Estate License #0000198425 Listed on: 12/08/2023

Home Details

Home Type

  • Single Family

Lot Details

  • 0.5 Acre Lot

HOA Fees

  • $55 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Garage Door Opener

Home Design

  • New Construction
  • Traditional Architecture
  • Brick Exterior Construction
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2,868 Sq Ft Home
  • 2-Story Property
  • Crown Molding
  • Ceiling height of 9 feet or more
  • Stone Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Panel Doors
  • Great Room with Fireplace
  • Concrete Flooring
  • Basement Fills Entire Space Under The House

Kitchen

  • Gourmet Kitchen
  • Convection Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Outdoor Features

  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Programmable Thermostat
  • Gas Water Heater

Community Details

  • Association fees include professionalmgt
  • Built by Schmidt Builders
  • Shetland Farms Subdivision

Home Details

Home Type

Single Family

Lot Details

0

HOA Fees

$55 per month

Parking

3

Listing Details

  • Suburb: Liberty Twp.
  • Degree Complete: Completed
  • Land Description: Less than .5 Acre
  • Broker Approved: Yes
  • Miscellaneous: Home Warranty,Recessed Lights,Smoke Alarm
  • Basement Sq Ft: 1420
  • Cooling: Central Air
  • Heating: Program Thermostat, Forced Air, Gas
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Liberty Twp.
  • Taxes Annual: 0
  • Price Per Acre: 1346568.24
  • Zoning: Residential
  • Basement Features: Bath Rough-In,Concrete Floor
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Breakfast Room Area: 132
  • Homebuilder: Schmidt Builders
  • Dining Room Feat: Formal,WW Carpet
  • Entry Area: 72
  • Entry Foyer: Closet,Other
  • Great Room Feat: Fireplace,Other
  • Living Great Rm Dim: 0 x 0
  • Mechanical Systems: Garage Door Opener
  • Single Family Desc: Single Family
  • Study Lib Den: 12x10 Level: 1
  • Study Lib Den Area: 120
  • Study Lib Den Dim: 12 x 10
  • Study Lib Den Len: 12
  • Water Heating: Gas
  • Architecture: Traditional
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 4
  • Directions: I-75 to West Route 129, Right Princeton Glendale Rd, Left Millikin Rd, Right Liberty Fairfield, Right Carthel Dr, Right Myra Lane, Right Shetland Ct.
  • Lot Measurement: Acres
  • Status: Pending
  • Property Subtype 1: Single Family Residence
  • Suburb (SIC): Shetland Farms
  • Occupancy: At Closing
  • ResoPropertyType: Residential
  • Special Features: 4098
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, Multi Panel Doors
  • Bedroom 2: 14x13 Level: 2
  • Bedroom 3: 12x15 Level: 2
  • Bedroom 4: 12x13 Level: 2
  • Breakfast Room: 12x11 Level: 1
  • Dining Room: 12x12 Level: 1
  • Property Type: Residential
  • Year Built Exception: New
  • Reciprocal Listing: No
  • Semi Annual Taxes: $0
  • Appliances: Convection Oven, Dishwasher, Garbage Disposal, Microwave, Oven/Range
  • Kitchen Features: Pantry,Quartz Counters,Walkout,Gourmet,Island,Wood Cabinets,Other
  • Bedroom 2 Area: 182
  • Basement: Full
  • Bedroom 3 Area: 180
  • Study Features: Wall-to-Wall Carpet
  • Bedroom 4 Area: 156
  • Entry: 9x8 Level: 1
  • Bathrooms: 3.00
  • Great Room: 21x17 Level: 1
  • Kitchen Area: 168
  • Kitchen Dim: 14 x 12
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 2
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Diningroom Area: 144
  • Laundry Room: 7x6 Level: 1
  • Laundry Room Area: 42
  • Laundryroom Dim: 7 x 6
  • Recreation Room Dim: 0 x 0
  • Fireplace: Stone, Gas
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2868.00
  • Total Rooms: 9
  • Windows: Vinyl, Insulated
  • PrimaryBedroomArea: 270
  • PrimaryBedroomDim: 18 x 15
  • PrimaryBedroomLen: 18
  • Primary Bathrooms: Shower,Double Shower
  • PrimaryBedFeat: Bath Adjoins,Walk-in Closet,Wall-to-Wall Carpet
  • P R I M A R Y B E D R O O M: 18x15 Level: 2

Exterior Features

  • Roof: Shingle
  • Construction: Brick, Vinyl Siding
  • Outside Features: Patio, Porch
  • Foundation: Poured
  • Listing Price: 674900.00
  • Acres: 0.5012
  • New Construction: Yes

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Front,Garage Attached
  • Parking: Concrete

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 55.00
  • Fee Frequency: Monthly
  • HOA Management Co: TBD
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Inc.In HOA/Condo Fee: ProfessionalMgt

Schools

  • District: Lakota Local SD

Lot Info

  • Lot Dimensions: Irregular
  • Lot Size Sq Ft: 21832.00
  • Total Assessed Value: Of Record
  • ResoLotSizeUnits: Acres

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 -- $8,830 $8,830 --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/21/2025 04/21/25 Pending -- -- --
04/15/2025 04/15/25 Off Market $674,900 -- --
04/14/2025 04/14/25 For Sale $674,900 0.0% $235 / Sq Ft
03/10/2025 03/10/25 Off Market $674,900 -- --
03/06/2025 03/06/25 Price Changed $674,900 -2.2% $235 / Sq Ft
12/09/2023 12/09/23 For Sale $689,900 -- $241 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1791651

MLS of Greater Cincinnati (CincyMLS)

APN: D2020-341-000-002