Skip main navigation
Sold for $479,823
  • $479,823

    542 Holland Dr, Trenton, OH 45067

    3beds
    --sqft
    Single Family Residence
    Built in 2024
    0.31 Acres Lot
    $475,400 Zestimate®
    $--/sqft
    $2,497 Estimated rent

    Home value

    $475,400

    $452,000 - $499,000

    $2,497/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,497/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,497/mo

    Rent Zestimate®

    Refinance and save

    $3,110/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,110/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Open Concept, Custom 1805sf Ranch with Split Floor Plan in Desirable Maple View Elk Creek. This Charleston II by Todd Homes Offers Upgrades-9ft Ceilings, Recessed Lighting & Beautiful LVT Flooring & Much More. Great Room Flows into the Upscale Kitchen & Light Filled Sunroom. 22' x 10' Covered Porch for Outdoor Enjoyment. Kitchen Features a Dining Island, Granite Countertops, Stainless Steel Appliances, Shaker Soft Close Cabinetry & an Extra-Large Pantry. The Private Primary Suite is an Impressive 17' x 13' & Consists of a Massive Walk-In Closet & a Breathtaking Deluxe Spa Bath with a 6' x 4' Walk-In Shower with Floor to Ceiling Tile, Frameless Glass, Bathing Bench, & a Quartz Topped Double Vanity. Two Additional Bedrooms Are Nice Sized & Have Large Closets. Lower Level with Egress & Full Bath Rough-In for Future Living Spaces. This Home Has a 3 Car Garage for All Your Toys! The Brick & Stone Exterior Provides Maximum Curb Appeal. Maple View Elk Creek is a Private Cul-De-Sac-NO HOA!

    Zillow last checked:

    Listing updated:

    Listed by:

    Darlene V. Todd 513-236-0777,

    Comey & Shepherd 513-489-2100

    Bought with:

    Not Member

    NonMember Firm (NONMEM)

    Source: Cincy MLS,MLS#: 1801462MLS LogoOriginating MLS: Cincinnati Area Multiple Listing Service

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 2
    Rooms
    • Room types: Formal Dining Room
    Primary bedroom
    • Features: Bath Adjoins, Walk-In Closet(s), Wall-to-Wall Carpet
    • Level: First
    • Area: 255
    • Dimensions: 17 x 15
    Bedroom 2
    • Level: First
    • Area: 143
    • Dimensions: 13 x 11
    Bedroom 3
    • Level: First
    • Area: 144
    • Dimensions: 12 x 12
    Bedroom 4
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 5
    • Area: 0
    • Dimensions: 0 x 0
    Primary bathroom
    • Features: Built-In Shower Seat, Double Vanity, Marb/Gran/Slate, Shower
    Bathroom
    • Features: Builtin Shower Seat
    Bathroom 1
    • Features: Full
    • Level: First
    Bathroom 2
    • Features: Full
    • Level: First
    Dining room
    • Features: Walkout, Other
    • Level: First
    • Area: 150
    • Dimensions: 15 x 10
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Great room
    • Features: Other
    • Level: First
    • Area: 247
    • Dimensions: 19 x 13
    Kitchen
    • Features: Eat-in Kitchen, Gourmet, Kitchen Island, Marble/Granite/Slate, Pantry, Walkout, Wood Cabinets, Other
    • Area: 266
    • Dimensions: 19 x 14
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Office
    • Area: 0
    • Dimensions: 0 x 0
    Heating
    • Forced Air, Gas
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Disposal, Microwave, Oven/Range, Electric Water Heater
    Features
    • High Ceilings, Ceiling Fan(s), Recessed Lighting
    • Windows: Insulated Windows, Vinyl
    • Basement: Full,Bath/Stubbed,Concrete,Unfinished
    Interior area
    • Total structure area: 0

    Property

    Parking
    • Total spaces: 3
    • Parking features: Driveway
    • Attached garage spaces: 3
    • Has uncovered spaces: Yes
    Features
    • Levels: One
    • Stories: 1
    Lot
    • Size: 0.31 Acres
    • Features: Less than .5 Acre
    • Topography: Stream/Creek
    • Residential vegetation: Partially Wooded
    Details
    • Parcel number: NEW/UNDER CONST/TO BE BUILT
    • Zoning description: Residential
    • Other equipment: Sump Pump

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Transitional
    • Property subtype: Single Family Residence
    Materials
    • Brick, Stone, Vinyl Siding
    • Foundation: Concrete Perimeter
    • Roof: Shingle
    Condition
    • New construction: Yes
    • Year built: 2024
    Details
    • Builder name: Todd Homes

    Utilities & green energy

    • Electric: 220 Volts
    • Gas: Natural
    • Sewer: Public Sewer
    • Water: Public

    Community & HOA

    Community
    • Security: Smoke Alarm
    • Subdivision: Maple View Elk Creek
    HOA
    • Has HOA: No
    Location
    • Region: Trenton

    Financial & listing details

    • Tax assessed value: $4,550
    • Annual tax amount: $4,570
    • Date on market: 4/10/2024
    • Listing terms: No Special Financing,Cash

    Price history

    DateEventPrice
    4/29/2024Sold$479,823
    Source: Cincy MLS #1801462 Report a problem
    4/9/2024Pending sale$479,823+859.6%
    Source: Todd Homes Report a problem
    10/10/2023Sold$50,000
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$4,570 +7642.7%$1,590 +16.9%
    2024$59 $1,360
    Find assessor info on the county website

    Neighborhood: 45067

    Nearby schools

    GreatSchools rating
    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
    $475,400
    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
    $475,400