Seller's Agent in 2026
Angelo Pusateri
Comey & Shepherd
(513) 544-5150
3 in this area
144 Total Sales
7404 Orchard St Cincinnati, OH 45227
Estimated Value: $989,000 - $1,098,000
3
Beds
4
Baths
--
Sq Ft
5,118
Sq Ft Lot 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
Listed on
Oct 29, 2025
Closed on
Jan 6, 2026
Sold by
Lookout Holdings Llc
Bought by
Vanscoy Gregory
Seller's Agent
Angelo Pusateri
Comey & Shepherd
Buyer's Agent
Avery Lindner
Coldwell Banker Realty
List Price
$994,900
Sold Price
$994,900
Views
5
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$29,796
Avg. Annual Appreciation
9.07%
Purchase Details
Listed on
Oct 29, 2025
Closed on
Dec 23, 2025
Sold by
Harbor Lookout Holdings Llc
Bought by
Lookout Holdings Llc
Seller's Agent
Angelo Pusateri
Comey & Shepherd
Buyer's Agent
Avery Lindner
Coldwell Banker Realty
List Price
$994,900
Sold Price
$994,900
Views
5
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
Interest Rate
6.89%
Mortgage Type
Construction
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
Purchase Details
Closed on
Sep 23, 2024
Sold by
Wp Offsite Construction Llc
Bought by
Wp Offsite Construction Llc
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
Purchase Details
Closed on
Aug 26, 2024
Sold by
Remember Well Llc
Bought by
Wp Offsite Construction Llc
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
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 | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Vanscoy Gregory | $994,900 | None Listed On Document | |
| Lookout Holdings Llc | -- | None Listed On Document | |
| Harbor Lookout Holdings Llc | $50,000 | None Listed On Document | |
| Harbor Lookout Holdings Llc | $50,000 | None Listed On Document | |
| A M P Inc | $250,000 | None Listed On Document | |
| Wp Offsite Construction Llc | -- | None Listed On Document | |
| Wp Offsite Construction Llc | $41,800 | None Listed On Document |
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 | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Harbor Lookout Holdings Llc | $630,466 | |
| Previous Owner | A M P Inc | $560,950 |
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)
Agents Affiliated with this Home
-
Angelo Pusateri
-
Suzette Waugh
S
Seller Co-Listing Agent in 2026
Suzette Waugh
Comey & Shepherd
(513) 477-7698
2 in this area
114 Total Sales
-
Avery Lindner
Buyer's Agent in 2026
Avery Lindner
Coldwell Banker Realty
(513) 405-8855
1 in this area
50 Total Sales
-
Shelley Miller Reed
Buyer Co-Listing Agent in 2026
Shelley Miller Reed
Coldwell Banker Realty
(513) 476-8266
12 in this area
259 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 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 7406 Orchard St
- 7408 Orchard St
- 7412 Orchard St
- 7411 Elm St
- 7447 Muchmore Close
- 4261 Walton Creek Rd
- 3771 Miami Run
- 3746 Miami Run
- 3767 Miami Run
- 3750 Miami Run
- 3766 Miami Run Unit 13
- 3766 Miami Run
- 4108 Ashley Oaks Dr
- 3762 Miami Run
- 3762 Miami Run Unit 14
- 3758 Miami Run
- 3758 Miami Run Unit 15
- 7010 Wooster Pike
- 4555 Walton Creek Rd
- L Walton Creek Rd
- 4050 Spring St
- 7409 Elm St
- 7415 Elm St
- 7419 Elm St
- 4101 Beech St
- 4069 Walton Creek Rd
- 11 Spring Knoll Dr
- 7410 Elm St
- 9 Spring Knoll Dr
- 7 Spring Knoll Dr Unit 32
- 5 Spring Knoll Dr
- 4119 Beech St
- 18 Spring Knoll Dr
- 16 Spring Knoll Dr
- 5 Spring Hill Dr Unit 3
- 3 Spring Hill Dr Unit 2
- 7 Spring Hill Dr
- 9 Spring Hill Dr
- 3 Spring Knoll Dr
- 20 Spring Hill Dr
Your Personal Tour Guide
Ask me questions while you tour the home.