$740,000
PENDING

Estimated payment $4,889/month

Total Views 1,922
5 Beds
3.5 Baths
4,481 Sq Ft
$165 Price per Sq Ft

Highlights

  • Hot Property
  • Eat-In Gourmet Kitchen
  • Living Room with Fireplace
  • Pool House
  • Covered Deck
  • Traditional Architecture

About This Home

A private backyard oasis sets this custom 5 bed 3.5 bath residence with over 4,400 sqft of finished living space apart. Designed for effortless entertaining, the outdoor retreat features a 40x24 inground pool, pool house with bar seating and speakers, multiple gathering areas, elegant water features, a built-in grill and outdoor fireplace. A 32x12 covered patio and spacious three-season room provide even more room to relax while overlooking the pool and professionally landscaped grounds. Inside, rich hardwood floors, a soaring two-story Great Room, wood-burning fireplace and gourmet kitchen with granite, stainless appliances and a large island create a refined custom feel. Additional highlights include a first-floor office, 9' ceilings, three-car garage and a finished walkout lower level with wet bar, fireplace, built-ins and a private fifth-bedroom suite. Truly a masterpiece of a home to call your own!

Listing Agent

Edward Lindenschmidt

Keller Williams Advisors License #2017002296 Listed on: 07/22/2026

Keller Williams Advisors

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,920

Year Built

  • Built in 2000

Lot Details

  • 19,994 Sq Ft Lot
  • Lot Dimensions are 100 x 200
  • Aluminum or Metal Fence
  • Sprinkler System

HOA Fees

  • $30 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 4,481 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Chair Railings
  • Crown Molding
  • Cathedral Ceiling
  • Chandelier
  • Wood Burning Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Wood Frame Window
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Living Room with Fireplace
  • 2 Fireplaces
  • Laundry Chute

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Double Oven
  • Electric Cooktop
  • Microwave
  • Kitchen Island

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Built-In Shower Bench

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Pool

  • Pool House
  • In Ground Pool

Outdoor Features

  • Covered Deck
  • Patio
  • Outdoor Fireplace
  • Outdoor Grill

Utilities

  • Forced Air Heating and Cooling System
  • Mini Split Air Conditioners
  • Mini Split Heat Pump
  • Heating System Uses Gas
  • 220 Volts
  • Tankless Water Heater
  • Gas Water Heater
  • Cable TV Available

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,920

Year Built

Built in 2000

Lot Details

0.46 Acres

HOA Fees

$30 per month

Parking

3

Listing Details

  • Suburb: Green Twp.
  • Cross Street: Castlebridge
  • Buildings: Pool House
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt, Cable, Laundry Chute
  • Census Tract Realist: 211.02
  • Cooling: Central Air, Mini-Split
  • Heating: Mini-Split, Forced Air, Gas
  • Lot Area Realist: 19994.00
  • Suburb S I C: Green Twp.
  • Basement Features: Finished, Walkout, WW Carpet
  • Bathroom 4: Full
  • Bathroom 4 Level: Lower
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Chair Rail, Chandelier
  • Entry Foyer: Closet, Open Foyer, Wood Floor
  • Family Room Feat: Bookcases
  • Living Great Rm Dim: 23 x 20
  • Living Room Feat: Fireplace, Wood Floor
  • Single Family Desc: Single Family
  • Study Lib Den: 10x10 Level: 1
  • Study Lib Den Dim: 10 x 10
  • Water Heating: Gas, Tankless
  • Year Built: 2000
  • Architecture: Traditional
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 5
  • Directions: Ebenezer to west on Cleves Warsaw, Right Wexford Ln.
  • Lot Measurement: Acres
  • Status: Pending
  • On Market Date: 2026-07-22
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • Second Floor Area: 1273
  • ADU Y/N: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Cathedral Ceiling, Crown Molding, French Doors, Multi Panel Doors
  • Bedroom 2: 12x14 Level: 2
  • Bedroom 3: 10x11 Level: 2
  • Bedroom 4: 10x15 Level: 2
  • Bedroom 5: 12x13 Level: Lower
  • Breakfast Room: 21x12 Level: 1
  • Dining Room: 12x16 Level: 1
  • Family Room: 20x19 Level: Lower
  • Living Room: 23x20 Level: 1
  • Recreation Room: 15x18 Level: Lower
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $4960
  • Appliances: Double Oven, Electric Cooktop, Microwave
  • Kitchen Features: Pantry, Counter Bar, Eat-In, Tile Floor, Walkout, Gourmet, Island, Marble/Granite/Slate
  • Basement: Full
  • Study Features: Wood Floor
  • Entry: 12x19 Level: 1
  • Bathrooms: 4.00
  • Kitchen Dim: 17 x 15
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Laundry Room: 10x7 Level: 1
  • Laundryroom Dim: 10 x 7
  • Recreation Room Dim: 15 x 18
  • Fireplace: Gas, Wood
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 4481.00
  • Windows: Double Pane, Wood
  • PrimaryBedroomDim: 20 x 12
  • Primary Bathrooms: Built-In Shower Seat, Shower, Tile Floor
  • PrimaryBedFeat: Bath Adjoins
  • P R I M A R Y B E D R O O M: 20x12 Level: 2

Exterior Features

  • Fencing: Metal
  • Roof: Shingle
  • Pool: In-Ground
  • Construction: Brick
  • Outside Features: BBQ Grill, Covered Deck/Patio, Deck, Fireplace, Patio, Sprinklers
  • Foundation: Poured
  • Listing Price: 740000.00
  • Acres: 0.4590
  • New Construction: No

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Side, Garage Attached
  • Parking: Driveway

Utilities

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

Condo/Co-op/Association

  • HOA Fees: 360.00
  • Fee Frequency: Annually
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: Oak Hills Local SD

Lot Info

  • Lot Dimensions: 100 x 200
  • Lot Size Sq Ft: 19994.00
  • Total Assessed Value: Of Record

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $9,920 $190,586 $23,030 $167,556
2024 $9,686 $190,586 $23,030 $167,556
2023 $9,687 $190,586 $23,030 $167,556
2022 $9,212 $153,668 $27,440 $126,228
2021 $8,281 $153,668 $27,440 $126,228
2020 $8,376 $153,668 $27,440 $126,228
2019 $8,201 $137,204 $24,500 $112,704
2018 $8,212 $137,204 $24,500 $112,704
2017 $7,745 $137,204 $24,500 $112,704
2016 $8,087 $143,042 $24,255 $118,787
2015 $8,151 $143,042 $24,255 $118,787
2014 $8,162 $143,042 $24,255 $118,787
2013 $7,702 $144,487 $24,500 $119,987
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/28/2026 07/28/26 Pending -- -- --
07/22/2026 07/22/26 For Sale $740,000 +5.7% $165 / Sq Ft
05/30/2025 05/30/25 Sold $699,900 0.0% $202 / Sq Ft View Prior Sale
04/19/2025 04/19/25 Off Market $699,900 -- --
04/18/2025 04/18/25 Pending -- -- --
04/15/2025 04/15/25 Off Market $699,900 -- --
04/14/2025 04/14/25 For Sale $699,900 0.0% $202 / Sq Ft
04/11/2025 04/11/25 Off Market $699,900 -- --
04/09/2025 04/09/25 For Sale $699,900 -- $202 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Quit Claim Deed -- Fidelity National Title
Warranty Deed $699,900 None Listed On Document
Interfamily Deed Transfer -- Attorney
Warranty Deed $442,900 --
Warranty Deed $65,000 Tri-Star Title Agency Inc
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $536,563 FHA
Previous Owner $533,398 FHA
Previous Owner $520,000 Credit Line Revolving
Previous Owner $45,000 Credit Line Revolving
Previous Owner $190,000 New Conventional
Previous Owner $278,000 Stand Alone Refi Refinance Of Original Loan
Previous Owner $71,400 Unknown
Previous Owner $250,000 Credit Line Revolving
Previous Owner $130,000 Unknown
Previous Owner $139,000 New Conventional
Previous Owner $140,000 Unknown
Previous Owner $75,000 Credit Line Revolving
Previous Owner $157,500 Unknown
Previous Owner $109,000 Credit Line Revolving
Previous Owner $285,000 Unknown
Previous Owner $285,000 Unknown
Previous Owner $310,000 Unknown
Previous Owner $270,000 No Value Available
Previous Owner $351,500 No Value Available
Source: Public Records

About the Listing Agent

Edward Lindenschmidt

Keller Williams Advisors

(513) 547-6165

Section Image

Edward Lindenschmidt | Cincinnati & Northern Kentucky Real Estate Expert

Cincinnati native and longtime Westside resident, Edward Lindenschmidt is a top-performing real estate agent helping buyers and sellers navigate the Cincinnati and Northern Kentucky markets with confidence.

Since 2017, Edward has built a reputation for delivering results, closing over 300 transactions and consistently ranking in the top 4% of Cincinnati-area Realtors. He has also been recognized with Cincy

Edward's Other Listings

  • 3229 Brunsman Way, North Bend, OH 45052

    $499,900 New Construction

    • 4 Beds
    • 2.5 Baths
    • 2,479 Sq Ft
    • 3229 Brunsman Way
    • North Bend, OH

    Move right into this stunning NEW CONSTRUCTION home offering over 2,400 sq ft of finished living space and luxury finishes throughout. The open floor plan features a dramatic 2-story great room filled with natural light, a private home office, mudroom, and chef-inspired kitchen with gas range and butler's pantry. The first-floor primary suite includes a soaking tub, separate shower, and walk-in

    Edward Lindenschmidt Keller Williams Advisors

    Section Image
  • 139 Winkler St, Cincinnati, OH 45219

    $340,000 Open Sun 12PM - 2PM

    • 3 Beds
    • 2.5 Baths
    • 1,760 Sq Ft
    • 139 Winkler St
    • Cincinnati, OH

    OPEN HOUSE Sunday 8/2 from 12-2! Live close to it all in this beautifully renovated home near Downtown Cincinnati, UC, major hospitals, and OTR. Tucked away on a quiet, secluded street, this home offers a peaceful retreat while keeping popular dining, shopping, entertainment, and nightlife just a walk or quick rideshare away. Inside, the bright, open layout delivers serious style with soaring

    Edward Lindenschmidt Keller Williams Advisors

    Section Image
  • 24 Burk Ave, Florence, KY 41042

    $267,000 Pending

    • 4 Beds
    • 2 Baths
    • 1,248 Sq Ft
    • 24 Burk Ave
    • Florence, KY

    OPEN HOUSE CANCELED - Retro Mid-Century modern vibes meet everyday comfort in this spacious 4-bedroom, 2-bath ranch situated on a double lot. Pristine hardwood floors, mature trees, and beautifully landscaped grounds create a warm and inviting setting. The large open kitchen offers plenty of space for cooking and gathering, while the finished lower level features a huge family room with walkout

    Edward Lindenschmidt Keller Williams Advisors

    Section Image
  • 2716 Minot Ave, Cincinnati, OH 45209

    $475,000

    • 5 Beds
    • 2.5 Baths
    • 2,002 Sq Ft
    • 2716 Minot Ave
    • Cincinnati, OH

    Historic character meets move-in-ready comfort in this spacious Oakley home. Offering five bedrooms plus a flexible first-floor office that has previously served as a bedroom, the versatile layout provides abundant space for working from home, hosting guests, or creating rooms tailored to your lifestyle. Nine-foot ceilings enhance the bright, open feel, while the updated kitchen and bathrooms

    Edward Lindenschmidt Keller Williams Advisors

    Section Image
  • 5237 Leona Dr, Cincinnati, OH 45238

    $204,000 Sold Aug 12, 2025

    • 3 Beds
    • 2 Baths
    • 2,108 Sq Ft
    • 5237 Leona Dr
    • Cincinnati, OH

    OPEN HOUSE - Friday 7/10 from 6-7:30! Welcome home to this charming 3-bedroom, 2-bath Cape Cod in the heart of Green Township! Just a short stroll to Bosken Park, local dining, and the busline, this well-maintained gem offers comfort and convenience. Enjoy summer evenings in the spacious, privacy fenced backyard complete with mature trees, a deck, and a cozy seating area perfect for relaxing or

    Edward Lindenschmidt Keller Williams Advisors

  • 5630 Karen Ave, Cincinnati, OH 45248

    $190,000 Sold Jul 31, 2025

    • 2 Beds
    • 2 Baths
    • 820 Sq Ft
    • 5630 Karen Ave
    • Cincinnati, OH

    Welcome to this charming 2 bed, 2 bath ranch home in the award-winning Oak Hills School District! This beautiful cozy home offers comfort, style, and convenience all in one. Step inside to find fresh paint and an updated main bathroom, adding a modern touch to the inviting interior. The spacious, fenced-in backyard features a newly stained rear deck perfect for gatherings, grilling, or relaxing

    Edward Lindenschmidt Keller Williams Advisors

  • 3007 Ideal Terrace, Cincinnati, OH 45238

    $190,000 Sold Oct 16, 2025

    • 2 Beds
    • 2 Baths
    • 990 Sq Ft
    • 3007 Ideal Terrace
    • Cincinnati, OH

    Immaculate 2-bedroom, 2 full bath ranch in Westwood, beautifully remodeled and FHA ready! Nestled on a quiet cul-de-sac street, this move-in ready home features gleaming hardwood floors throughout, a spacious living room, formal dining room, and updated kitchen and bath. Enjoy a large front porch perfect for relaxing, plus a private oversized backyard ideal for entertaining. The full unfinished

    Edward Lindenschmidt Keller Williams Advisors

  • 6880 Rackview Rd, Cincinnati, OH 45248

    $475,000 Sold Apr 15, 2026

    • 5 Beds
    • 4 Baths
    • 4,457 Sq Ft
    • 6880 Rackview Rd
    • Cincinnati, OH

    Welcome to a home designed to evolve with you! This expansive Green Township residence offers over 4,400 sq ft of finished living space, including a rare attached in-law suite/apartment ideal for multigenerational living, work-from-home flexibility, or income potential located in the award winning Oak Hills School District. The main home features 4 bedrooms, 3 full baths, hardwood floors,

    Edward Lindenschmidt Keller Williams Advisors

  • 4961 Troubador Ct, Cincinnati, OH 45238

    $300,000 Sold Aug 29, 2025

    • 4 Beds
    • 2.5 Baths
    • 3,414 Sq Ft
    • 4961 Troubador Ct
    • Cincinnati, OH

    OPEN HOUSE Sunday 7/27 from Noon-2pm. Tucked away at the end of a peaceful cul-de-sac in the award-winning Oak Hills School District, this spacious 4-bedroom, 2.5-bath home offers the perfect blend of comfort, convenience, and outdoor living. Step inside to find a welcoming layout with a formal dining room, open concept kitchen, breakfast room, a large primary suite and plenty of room for

    Edward Lindenschmidt Keller Williams Advisors

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1887865

MLS of Greater Cincinnati (CincyMLS)

APN: 550-0260-0445

Your Personal Tour Guide

Ask me questions while you tour the home.