Seller's Agent in 2026
Angelo Pusateri
Comey & Shepherd
(513) 544-5150
3 in this area
154 Total Sales
7404 Orchard St Cincinnati, OH 45227
3
Beds
4
Baths
--
Sq Ft
5,118
Sq Ft Lot
Highlights
- Media Room
- New Construction
- Marble Flooring
- Terrace Park Elementary School Rated A+
- Deck
- 4-minute walk to Muchmore Park
About This Home
As of January 2026Live Where Luxury Meets Lifestyle! The Reserves at Walton Creek offers exclusive homes in Columbia Twp within top-rated Mariemont City SD. Elegant curb appeal, chef's kitchen w/ Thermador appliances, spa-like primary suites & flexible spaces for real life. 10-Yr CRA Tax Abatement means more money for what matters. Open layout w/ home office option, finished lower level & inviting outdoor living. Minutes to downtown, dining/entertainment, parks & the bike trail. Only a few of these opportunities left! Don't miss your chance! Luxury, location + lifestyle together like never before!
Last Agent to Sell the Property
Comey & Shepherd License #2005012481 Listed on: 10/29/2025
Home Details
Home Type
- Single Family
Year Built
- Built in 2025 | New Construction
Lot Details
- 5,118 Sq Ft Lot
- Property is zoned Residential,Multi Family
Parking
- 2 Car Garage
- Front Facing Garage
- Driveway
Home Design
- Transitional Architecture
- Poured Concrete
- Shingle Roof
Interior Spaces
- 2-Story Property
- Crown Molding
- Ceiling height of 9 feet or more
- Gas Fireplace
- Vinyl Clad Windows
- Double Hung Windows
- Great Room with Fireplace
- Media Room
- Finished Basement
- Basement Fills Entire Space Under The House
Kitchen
- Eat-In Kitchen
- Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Quartz Countertops
- Solid Wood Cabinet
Flooring
- Wood
- Marble
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
Outdoor Features
- Deck
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Gas Water Heater
Community Details
- No Home Owners Association
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Mar 19, 2025
Sold by
Amp Inc
Bought by
Harbor Lookout Holdings Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$630,466
Outstanding Balance
$414,921
Interest Rate
6.89%
Mortgage Type
Construction
Estimated Equity
$65,713
Purchase Details
Closed on
Oct 11, 2024
Sold by
Wp Offsite Construction Llc
Bought by
A M P Inc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$560,950
Interest Rate
5.47%
Mortgage Type
Credit Line Revolving
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $50,000 | None Listed On Document | |
| Warranty Deed | $50,000 | None Listed On Document | |
| Special Warranty Deed | $250,000 | None Listed On Document |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $630,466 | Construction | |
| Closed | $630,466 | Construction | |
| Previous Owner | $560,950 | Credit Line Revolving |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 01/06/2026 01/06/26 | Sold | $994,900 | 0.0% | -- |
| 11/11/2025 11/11/25 | Pending | -- | -- | -- |
| 10/29/2025 10/29/25 | For Sale | $994,900 | -- | -- |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History Compared to Growth
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 | -- | -- | -- | -- |
Source: Public Records
Agents Affiliated with this Home
-
Angelo Pusateri
-
Suzette Waugh
S
Seller Co-Listing Agent in 2026
Suzette Waugh
Comey & Shepherd
(513) 477-7698
1 in this area
117 Total Sales
-
Avery Lindner
Buyer's Agent in 2026
Avery Lindner
Coldwell Banker Realty
(513) 405-8855
1 in this area
37 Total Sales
-
Shelley Miller Reed
Buyer Co-Listing Agent in 2026
Shelley Miller Reed
Coldwell Banker Realty
(513) 476-8266
12 in this area
260 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1860240
APN: 520-0111-0238
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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.
Ten-X 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 2025, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 7412 Orchard St
- 7410 Orchard St
- 7408 Orchard St
- 7406 Orchard St
- 7411 Elm St
- 4190 Beech St
- 3758 Miami Run
- 3766 Miami Run
- 3754 Miami Run
- 3762 Miami Run
- 3746 Miami Run
- 3763 Miami Run
- 3767 Miami Run
- 3750 Miami Run
- 3809 Petoskey Ave
- 3825 Petoskey Ave
- 7976 Ashley View Dr
- 7900 Annesdale Dr
- 6949 Cambridge Ave
- 7018 Bramble Ave