Luma Realty Search Results

Beautiful 110 acres located on a quiet country rd across the road from Ceasar Creek State Park. Property offers many possibilities including keeping it as its current farming use or developed into a multi-family or large single-family lot or break off into several building lots. Clinton Massie school district.

1896126 MLS

Beautiful 110 acres located on a quiet country rd across the road from Ceasar Creek State Park. Property offers many possibilities including keeping it as its current farming use or developed into a multi-family or large single-family lot or break off into several building lots. Clinton Massie school district.

Oregonia Road, Massie Twp

Courtesy of Sue Walker with Honnerlaw Real Estate Services

$2,999,000

A one-of-a-kind modern retreat positioned above the Ohio River Valley, combining dramatic architecture, panoramic sunset views and remarkable privacy all within a peaceful 30-mile drive from Cincinnati. Designed by renowned architect Jose Garcia, this extraordinary 4-bedroom, 3.5-bath residence is privately situated on 32 stunning acres behind a gated drive. Floor-to-ceiling windows showcase sweeping views and natural light, while custom wood flooring adds warmth throughout. The chef's kitchen features premium Thermador appliances and leathered granite countertops. An elevator provides access to all three levels. The primary bath offers a soaking tub and radiant heated floors, while two wood-burning stoves add warmth and ambiance. Hiking trails and garden areas wind throughout the acreage. Secluded from sight, this exceptional estate brings architecture, land, and nature together beautifully. See the feature sheet for the extensive list of exceptional features.

4 Beds ⋅ 4 Baths ⋅ 1894495 MLS

A one-of-a-kind modern retreat positioned above the Ohio River Valley, combining dramatic architecture, panoramic sunset views and remarkable privacy all within a peaceful 30-mile drive from Cincinnati. Designed by renowned architect Jose Garcia, this extraordinary 4-bedroom, 3.5-bath residence is privately situated on 32 stunning acres behind a gated drive. Floor-to-ceiling windows showcase sweeping views and natural light, while custom wood flooring adds warmth throughout. The chef's kitchen features premium Thermador appliances and leathered granite countertops. An elevator provides access to all three levels. The primary bath offers a soaking tub and radiant heated floors, while two wood-burning stoves add warmth and ambiance. Hiking trails and garden areas wind throughout the acreage. Secluded from sight, this exceptional estate brings architecture, land, and nature together beautifully. See the feature sheet for the extensive list of exceptional features.

1908 Us Rt 52, Washington Twp

Courtesy of Christopher Shepherd with Plum Tree Realty

$2,995,000

The epitome of Central Village living in the heart of Clippinger Woods, 8100 Chinquapin Lane offers well over 5700 of finished square footage with custom finishes throughout. From the time you enter this home, there is a sense of quality and design from Engler Builders in 2007. The open custom kitchen has a separate bar area, butler pantry and loads of storage and counter space. The first floor primary offers 2 separate primary baths with a connecting shower and walk-in closets. A formal 1st floor study has handmade bookcases, hardwood flooring and French doors. The lower level has over 1800 square feet of finished space with a great room and an additional recreation room, complete with a mini-kitchen and fireplace. With a full bath in the lower level, there is potential for multi-generational living space. Location, location, location. Walk to the schools, parks, stroll down the street and so close to downtown Madeira and Mariemont.

4 Beds ⋅ 6 Baths ⋅ 1887875 MLS

The epitome of Central Village living in the heart of Clippinger Woods, 8100 Chinquapin Lane offers well over 5700 of finished square footage with custom finishes throughout. From the time you enter this home, there is a sense of quality and design from Engler Builders in 2007. The open custom kitchen has a separate bar area, butler pantry and loads of storage and counter space. The first floor primary offers 2 separate primary baths with a connecting shower and walk-in closets. A formal 1st floor study has handmade bookcases, hardwood flooring and French doors. The lower level has over 1800 square feet of finished space with a great room and an additional recreation room, complete with a mini-kitchen and fireplace. With a full bath in the lower level, there is potential for multi-generational living space. Location, location, location. Walk to the schools, parks, stroll down the street and so close to downtown Madeira and Mariemont.

8100 Chinquapin Lane, Indian Hill

Courtesy of Robert Stephens with Comey & Shepherd

7886 Locust Grove Court, Clearcreek Twp.

$2,900,000

When architecture meets artistry, something extraordinary happens. Custom-built by Sims, this contemporary Country Brook estate sits on nearly 2 wooded acres, blending dramatic design with natural beauty. A grand foyer and floating staircase lead to an open floor plan with soaring ceilings, expansive windows, wooded views, rich hardwood and tile floors, and a striking two-story dining area. The kitchen flows into light-filled living spaces and outdoor entertaining areas. The primary suite features a spa-inspired bath with walk-through shower, waterfall soaking tub, and two oversized walk-in closets, including one with an island. Downstairs, the finished walkout level is made for entertaining, with a media room, full bar, wine room and exercise room. Open the doors to extend gatherings outdoors, where multiple decks, a hot tub and sauna await. Exceptional architecture, beautiful surroundings and room to entertain - this home has it all.

5 Beds ⋅ 6 Baths ⋅ 1896898 MLS

When architecture meets artistry, something extraordinary happens. Custom-built by Sims, this contemporary Country Brook estate sits on nearly 2 wooded acres, blending dramatic design with natural beauty. A grand foyer and floating staircase lead to an open floor plan with soaring ceilings, expansive windows, wooded views, rich hardwood and tile floors, and a striking two-story dining area. The kitchen flows into light-filled living spaces and outdoor entertaining areas. The primary suite features a spa-inspired bath with walk-through shower, waterfall soaking tub, and two oversized walk-in closets, including one with an island. Downstairs, the finished walkout level is made for entertaining, with a media room, full bar, wine room and exercise room. Open the doors to extend gatherings outdoors, where multiple decks, a hot tub and sauna await. Exceptional architecture, beautiful surroundings and room to entertain - this home has it all.

7886 Locust Grove Court, Clearcreek Twp.

Courtesy of Denise Gifford with Keller Williams Advisors

$2,900,000

When architecture meets artistry, something extraordinary happens. Custom-built by Sims, this contemporary Country Brook estate sits on nearly 2 wooded acres, blending dramatic design with natural beauty. A grand foyer and floating staircase lead to an open floor plan with soaring ceilings, expansive windows, wooded views, rich hardwood and tile floors, and a striking two-story dining area. The kitchen flows into light-filled living spaces and outdoor entertaining areas. The primary suite features a spa-inspired bath with walk-through shower, waterfall soaking tub, and two oversized walk-in closets, including one with an island. Downstairs, the finished walkout level is made for entertaining, with a media room, full bar, wine room and exercise room. Open the doors to extend gatherings outdoors, where multiple decks, a hot tub and sauna await. Exceptional architecture, beautiful surroundings and room to entertain - this home has it all.

5 Beds ⋅ 6 Baths ⋅ 971651 MLS

When architecture meets artistry, something extraordinary happens. Custom-built by Sims, this contemporary Country Brook estate sits on nearly 2 wooded acres, blending dramatic design with natural beauty. A grand foyer and floating staircase lead to an open floor plan with soaring ceilings, expansive windows, wooded views, rich hardwood and tile floors, and a striking two-story dining area. The kitchen flows into light-filled living spaces and outdoor entertaining areas. The primary suite features a spa-inspired bath with walk-through shower, waterfall soaking tub, and two oversized walk-in closets, including one with an island. Downstairs, the finished walkout level is made for entertaining, with a media room, full bar, wine room and exercise room. Open the doors to extend gatherings outdoors, where multiple decks, a hot tub and sauna await. Exceptional architecture, beautiful surroundings and room to entertain - this home has it all.

7886 Locust Grove Court, Springboro

Courtesy of Denise Gifford and Keller Williams Advisors Rlty

$2,900,000

Blue Heron Homestead offers 58 acres of rolling hills in southeast Champaign County, anchored by an 11-acre lake and a 5,661 sq ft home built in 2005, with a new roof and Hardie board siding completed in 2026. The residence features 4 bedrooms, 3 full baths, and 2 half baths, with an open-concept layout designed for comfortable living and entertaining. The wraparound deck along the front of the home offers scenic views from multiple vantage points, while the finished walkout basement is built for entertaining with a bar, hot tub, and movie theater. A 3-car attached garage adds convenience, and a newer outbuilding with water and electricity provides ample space for equipment, vehicles, a shop, or storage. The property also includes an additional parcel, Parcel ID J35-10-00-41-00-062-00, adding to the overall real estate offering. The land is just as impressive as the home. Mature hardwoods cover the rolling terrain, and a trail system runs throughout, providing access to every corner of the property for hiking, riding, and recreation. The 11-acre lake is the centerpiece, well stocked with fish and offering scenic views throughout the property. Wildlife is abundant across the timber, water, and field edges, with waterfowl frequenting the lake and eagles often spotted overhead. This is a true recreational property that offers an exceptional combination of natural beauty, outdoor enjoyment, and comfortable living. Properties combining this much water, mature timber, acreage, and a home of this size are rarely available in west central Ohio. Whether you are looking for a private residence, a hunting and recreational retreat, or a combination of both, Blue Heron Homestead delivers a unique opportunity. Showings are available to qualified buyers only. Proof of funds or a lender pre-approval letter is required prior to scheduling.

4 Beds ⋅ 5 Baths ⋅ 970253 MLS

Blue Heron Homestead offers 58 acres of rolling hills in southeast Champaign County, anchored by an 11-acre lake and a 5,661 sq ft home built in 2005, with a new roof and Hardie board siding completed in 2026. The residence features 4 bedrooms, 3 full baths, and 2 half baths, with an open-concept layout designed for comfortable living and entertaining. The wraparound deck along the front of the home offers scenic views from multiple vantage points, while the finished walkout basement is built for entertaining with a bar, hot tub, and movie theater. A 3-car attached garage adds convenience, and a newer outbuilding with water and electricity provides ample space for equipment, vehicles, a shop, or storage. The property also includes an additional parcel, Parcel ID J35-10-00-41-00-062-00, adding to the overall real estate offering. The land is just as impressive as the home. Mature hardwoods cover the rolling terrain, and a trail system runs throughout, providing access to every corner of the property for hiking, riding, and recreation. The 11-acre lake is the centerpiece, well stocked with fish and offering scenic views throughout the property. Wildlife is abundant across the timber, water, and field edges, with waterfowl frequenting the lake and eagles often spotted overhead. This is a true recreational property that offers an exceptional combination of natural beauty, outdoor enjoyment, and comfortable living. Properties combining this much water, mature timber, acreage, and a home of this size are rarely available in west central Ohio. Whether you are looking for a private residence, a hunting and recreational retreat, or a combination of both, Blue Heron Homestead delivers a unique opportunity. Showings are available to qualified buyers only. Proof of funds or a lender pre-approval letter is required prior to scheduling.

7701 Long Pond Road, Mechanicsburg

Courtesy of Travis Kenton and Whitetail Properties Real Est

$2,900,000

Introducing an impressive 25,000 square foot industrial commercial warehouse, the ultimate solution for all your storage and logistical needs. This state-of-the-art facility boasts a versatile layout, designed to accommodate a wide range of industries and operations. With ample space for storing inventory, equipment, and machinery, this warehouse provides the perfect platform for your business to grow and thrive. Featuring high ceilings, large entryway, easy access loading docks.

1872095 MLS

Introducing an impressive 25,000 square foot industrial commercial warehouse, the ultimate solution for all your storage and logistical needs. This state-of-the-art facility boasts a versatile layout, designed to accommodate a wide range of industries and operations. With ample space for storing inventory, equipment, and machinery, this warehouse provides the perfect platform for your business to grow and thrive. Featuring high ceilings, large entryway, easy access loading docks.

201 American Way, Monroe

Courtesy of Monika Deroussel with eXp Realty

$2,875,000

Build the home of your dreams on this exclusive, wooded lot with Daley Design + Build. In the western quiet part of Madeira with Quick access to Kenwood and many shops and restaurants. This awesome 4,592sf home is perfect for entertaining with its spacious kitchen, open Great room and walk-out onto back patio. 1st floor Primary bdrm features a private office, large walk in closet & primary bath. LL features a family room, 1 bdrm and rec room. Or design your own home from scratch!

1895592 MLS

Build the home of your dreams on this exclusive, wooded lot with Daley Design + Build. In the western quiet part of Madeira with Quick access to Kenwood and many shops and restaurants. This awesome 4,592sf home is perfect for entertaining with its spacious kitchen, open Great room and walk-out onto back patio. 1st floor Primary bdrm features a private office, large walk in closet & primary bath. LL features a family room, 1 bdrm and rec room. Or design your own home from scratch!

6764 Ken Arbre Drive, Madeira

Courtesy of Peter Craft with Lou Park Realty

$2,835,000

Location, Location, Location! Attention Investors and Developers...Excellent parcel for Commercial Development. Frontage on Three Roads. Visible from SR 32. Corner Lot. Close to Southern State College, Hospital, Schools, Dining & Shopping. Utilities Available.

1776618 MLS

Location, Location, Location! Attention Investors and Developers...Excellent parcel for Commercial Development. Frontage on Three Roads. Visible from SR 32. Corner Lot. Close to Southern State College, Hospital, Schools, Dining & Shopping. Utilities Available.

3517 Bardwell West Road, Green Twp

Courtesy of Sarah Leever with Howard Hanna Real Estate Servi

$2,799,000

Sterling Homes introduces The Albert for HOMEARAMA® 2026. Save hundreds of thousands of dollars in Homearama discounts and call this home by the end of September. What more could you ask for? Maybe FULLY FURNISHED, golf simulator, theater room w/ surround sound by Hanson A.V., selections by Bishop Design, and a wellness room! Set on over two private acres in The Estates at Bothe Farms, Sterling Homes presents a timeless European design that's sophisticated, welcoming, and effortlessly livable. From soaring vaulted ceilings and rich architectural details to custom millwork and warm natural finishes, this home is designed to leave a lasting impression. Key features include four bedrooms, a first-floor primary suite, a vaulted great room, a golf simulator, a fitness room with a dry sauna, three fireplaces, multiple dry bars, a butler's pantry w/ second fridge & sink, a private office, a welcoming front coffee porch, and 6,096 sqft designed for exceptional everyday living and entertaining.

4 Beds ⋅ 5 Baths ⋅ 1892301 MLS

Sterling Homes introduces The Albert for HOMEARAMA® 2026. Save hundreds of thousands of dollars in Homearama discounts and call this home by the end of September. What more could you ask for? Maybe FULLY FURNISHED, golf simulator, theater room w/ surround sound by Hanson A.V., selections by Bishop Design, and a wellness room! Set on over two private acres in The Estates at Bothe Farms, Sterling Homes presents a timeless European design that's sophisticated, welcoming, and effortlessly livable. From soaring vaulted ceilings and rich architectural details to custom millwork and warm natural finishes, this home is designed to leave a lasting impression. Key features include four bedrooms, a first-floor primary suite, a vaulted great room, a golf simulator, a fitness room with a dry sauna, three fireplaces, multiple dry bars, a butler's pantry w/ second fridge & sink, a private office, a welcoming front coffee porch, and 6,096 sqft designed for exceptional everyday living and entertaining.

9702 Christian Court, Hamilton Twp

Courtesy of Michael Hines with Coldwell Banker Realty

$2,750,000

Rare investment opportunity just one block from Uptown Oxford and close to Miami University! This income-producing property features a student rental house plus eight 2-bedroom apartments, all recently updated, including the roof and exterior paint. Fully leased for the current school year at $227,000, with projected gross income of $230,800 for next school year. The house and several units are already leased for next year, giving you a strong head start. Plenty of off-street parking, a major advantage in this high-demand area. The parking lot has been recently paved and numbered. Properties like this rarely come to market. Don't miss your chance to own a premier rental portfolio in an unbeatable location!

1897911 MLS

Rare investment opportunity just one block from Uptown Oxford and close to Miami University! This income-producing property features a student rental house plus eight 2-bedroom apartments, all recently updated, including the roof and exterior paint. Fully leased for the current school year at $227,000, with projected gross income of $230,800 for next school year. The house and several units are already leased for next year, giving you a strong head start. Plenty of off-street parking, a major advantage in this high-demand area. The parking lot has been recently paved and numbered. Properties like this rarely come to market. Don't miss your chance to own a premier rental portfolio in an unbeatable location!

108 S Main Street, Oxford

Courtesy of Kenneth Thacker with Century 21 Thacker & Assoc.

$2,750,000

Unparalleled luxury and craftsmanship! John Hill Construction presents its 2026 Homearama entry, The Legacy. This show-stopping custom new build boasts over 7000 sqft of living space and offers a thoughtfully-planned layout complete w/1st flr study, great rm w/dramatic stone FP, gourmet eat-in kitchen w/oversized quartz island + butlers pantry, 1st flr primary suite w/walk-in closet + spa-like bath, gorgeous 1st flr guest suite, two 2nd flr bdrm suites, pocket ofc, lg laundry rm (w/dog shower!), and finished LL incl wet bar/home gym/addt'l egress bdrm/full bath. Truly stunning architectural features + upscale designer finishes at every turn. The luxe experience continues outdoors, featuring an inviting front porch, expansive rear patio, and incredible covered space w/FP + outdoor kitchen. Plus a 3-car garage w/zero-step entry. All situated on a prime 2+ acre lot in the new Estates at Bothe Farms community, conveniently located just 3 miles from all that downtown Loveland has to offer!

5 Beds ⋅ 6 Baths ⋅ 1894385 MLS

Unparalleled luxury and craftsmanship! John Hill Construction presents its 2026 Homearama entry, The Legacy. This show-stopping custom new build boasts over 7000 sqft of living space and offers a thoughtfully-planned layout complete w/1st flr study, great rm w/dramatic stone FP, gourmet eat-in kitchen w/oversized quartz island + butlers pantry, 1st flr primary suite w/walk-in closet + spa-like bath, gorgeous 1st flr guest suite, two 2nd flr bdrm suites, pocket ofc, lg laundry rm (w/dog shower!), and finished LL incl wet bar/home gym/addt'l egress bdrm/full bath. Truly stunning architectural features + upscale designer finishes at every turn. The luxe experience continues outdoors, featuring an inviting front porch, expansive rear patio, and incredible covered space w/FP + outdoor kitchen. Plus a 3-car garage w/zero-step entry. All situated on a prime 2+ acre lot in the new Estates at Bothe Farms community, conveniently located just 3 miles from all that downtown Loveland has to offer!

9798 Christian Court, Hamilton Twp

Courtesy of Eleanor Kowalchik with Keller Williams Pinnacle Group

$2,750,000

Pics coming soon. Set amid 42 acres of pristine grounds, this distinguished Tudor estate embodies timeless architecture, gracious proportions and enduring elegance, with select views toward the river. Offering over 7,000 sq. ft., the residence is defined by grand, oversized rooms, exquisite hardwood floors and exceptional craftsmanship. The impressive chef's kitchen is designed for both everyday living and elegant entertaining, while the luxurious primary suite features a beautifully appointed bath and remarkable dressing closet. A game room provides additional space to gather and entertain. Immerse yourself in the saltwater pool and enjoy your own tennis/pickleball courts. The stately carriage house offers a private apartment and substantial garage space, it also offers exceptional versatility for guests, a collector's garage or additional pursuits. Thoughtful improvements complement the character of this exceptional country estate. Proof of funds or preapproval required for showing

5 Beds ⋅ 6 Baths ⋅ 1892245 MLS

Pics coming soon. Set amid 42 acres of pristine grounds, this distinguished Tudor estate embodies timeless architecture, gracious proportions and enduring elegance, with select views toward the river. Offering over 7,000 sq. ft., the residence is defined by grand, oversized rooms, exquisite hardwood floors and exceptional craftsmanship. The impressive chef's kitchen is designed for both everyday living and elegant entertaining, while the luxurious primary suite features a beautifully appointed bath and remarkable dressing closet. A game room provides additional space to gather and entertain. Immerse yourself in the saltwater pool and enjoy your own tennis/pickleball courts. The stately carriage house offers a private apartment and substantial garage space, it also offers exceptional versatility for guests, a collector's garage or additional pursuits. Thoughtful improvements complement the character of this exceptional country estate. Proof of funds or preapproval required for showing

1104 Us Rt 52, Ohio Twp

Courtesy of Deborah Long with Keller Williams Advisors

$2,700,000

Additional 50 acres now available! Discover an unparalleled investment opportunity with this prime parcel of land located at the bustling intersection of I-70 and State Route 54. Spanning approximately 27 acres of flat, fertile terrain, this property is currently zoned A-1: Agricultural District, making it perfect for continued agricultural use or for future development. For many years, this land has been dedicated to producing high-yield corn and soybean crops, benefiting from its nutrient-rich soil and optimal farming conditions. The exceptional visibility and accessibility of this property cannot be overstated, with over 2,800 vehicles passing by daily, offering tremendous potential for various uses. This land offers easy access to several major locations, making it an attractive option for potential buyers looking to invest in a property with great connectivity and future development possibilities. Whether you envision continuing its agricultural legacy or transforming it into a new venture, this land holds immense promise. Don't miss out on this exceptional opportunity to own a prime piece of real estate in a highly sought-after location. Contact us today for more information and to schedule a viewing.

924805 MLS

Additional 50 acres now available! Discover an unparalleled investment opportunity with this prime parcel of land located at the bustling intersection of I-70 and State Route 54. Spanning approximately 27 acres of flat, fertile terrain, this property is currently zoned A-1: Agricultural District, making it perfect for continued agricultural use or for future development. For many years, this land has been dedicated to producing high-yield corn and soybean crops, benefiting from its nutrient-rich soil and optimal farming conditions. The exceptional visibility and accessibility of this property cannot be overstated, with over 2,800 vehicles passing by daily, offering tremendous potential for various uses. This land offers easy access to several major locations, making it an attractive option for potential buyers looking to invest in a property with great connectivity and future development possibilities. Whether you envision continuing its agricultural legacy or transforming it into a new venture, this land holds immense promise. Don't miss out on this exceptional opportunity to own a prime piece of real estate in a highly sought-after location. Contact us today for more information and to schedule a viewing.

N Urbana Lisbon Road, South Vienna

Courtesy of Jane Miller and Lagonda Creek Real Estate LLC

$2,699,000

Beautiful estate home on 5.014 private acres! Features include a 4-stall barn and heated swimming pool with a retractable cover. Architectural details throughout with beamed ceilings, fireplaces, custom built-ins, hardwood floors and light-filled rooms. Stylish kitchen with top-line appliances and abundant cabinetry. Three spacious gathering rooms. Luxurious primary suite with private bath and sitting room (dressing area). Geothermal heating and cooling, whole-house water softening system and generator. Expansive rear patio with covered entertaining area. Barn offers running water, electric tack room, threshing floor and storage hayloft. A rare opportunity to enjoy exceptional privacy and amenities! Prequalification letter required for appointment. No escalation clauses. Offers must remain open for 48 hours.

5 Beds ⋅ 6 Baths ⋅ 1898618 MLS

Beautiful estate home on 5.014 private acres! Features include a 4-stall barn and heated swimming pool with a retractable cover. Architectural details throughout with beamed ceilings, fireplaces, custom built-ins, hardwood floors and light-filled rooms. Stylish kitchen with top-line appliances and abundant cabinetry. Three spacious gathering rooms. Luxurious primary suite with private bath and sitting room (dressing area). Geothermal heating and cooling, whole-house water softening system and generator. Expansive rear patio with covered entertaining area. Barn offers running water, electric tack room, threshing floor and storage hayloft. A rare opportunity to enjoy exceptional privacy and amenities! Prequalification letter required for appointment. No escalation clauses. Offers must remain open for 48 hours.

9350 Whitegate Lane, Indian Hill

Courtesy of Julie Back with Sibcy Cline, Inc.

$2,675,000

Attention investors! This tax-saving portfolio is an LLC containing 12 spectacular single-family homes and is now available! Buy the LLC and pay less fees! Each home has been meticulously well maintained, updated, leased, and presents a highly profitable, long-term, low-risk asset for your portfolio, collectively priced well below their market value-instant income, instant equity! Most homes are centrally located within a few minutes of each other for added convenience. Opportunity Proposal, additional information for each property, and financial information available upon request. Addresses included: 2638 Allaire Ave, 3401 Blue Rock Rd, 9149 Depalma Dr, 3315 Lapland Dr, 3257 Lapland Dr, 5281 Orchardridge Ct, 3154 Rockacres Dr, 9031 Round Top Rd, 1149 Jennie Lane, 5470 Vogel Rd, 5941 Willow Oak, and 3442 Jessup Rd.

1889362 MLS

Attention investors! This tax-saving portfolio is an LLC containing 12 spectacular single-family homes and is now available! Buy the LLC and pay less fees! Each home has been meticulously well maintained, updated, leased, and presents a highly profitable, long-term, low-risk asset for your portfolio, collectively priced well below their market value-instant income, instant equity! Most homes are centrally located within a few minutes of each other for added convenience. Opportunity Proposal, additional information for each property, and financial information available upon request. Addresses included: 2638 Allaire Ave, 3401 Blue Rock Rd, 9149 Depalma Dr, 3315 Lapland Dr, 3257 Lapland Dr, 5281 Orchardridge Ct, 3154 Rockacres Dr, 9031 Round Top Rd, 1149 Jennie Lane, 5470 Vogel Rd, 5941 Willow Oak, and 3442 Jessup Rd.

5281 Orchardridge Court, Green Twp

Courtesy of Dustin Hensley with Keller Williams Pinnacle Group

$2,649,900

Rare opportunity to own this asset in the heart of Walnut Hills shopping district! 13,000sqft office available for lease. 7,500sqft is occupied by City Limits Laundromat on a fresh five year triple net lease at $4,002 per month. 6,000sqft warehouse space is occupied by University Mattress at $2,500 a month.

1889986 MLS

Rare opportunity to own this asset in the heart of Walnut Hills shopping district! 13,000sqft office available for lease. 7,500sqft is occupied by City Limits Laundromat on a fresh five year triple net lease at $4,002 per month. 6,000sqft warehouse space is occupied by University Mattress at $2,500 a month.

2612 Gilbert Avenue, Cincinnati

Courtesy of Ali Abdur-Rahman with Plum Tree Realty

$2,648,400

Don’t miss this exceptional opportunity to own 44.138 acres of prime development farmland located on the south side of Piqua in Miami County. This property offers, significant road frontage, and set on the edge of Piqua city limits.

949525 MLS

Don’t miss this exceptional opportunity to own 44.138 acres of prime development farmland located on the south side of Piqua in Miami County. This property offers, significant road frontage, and set on the edge of Piqua city limits.

6230 Drake Road, Piqua

Courtesy of Ryan Havenar and Bruns Realty Group, LLC

$2,622,000

Welcome to Sandymar Drive, one of Sycamore Township and Indian Hill schools' premier streets. This homesite is the exceptional opportunity you've been waiting for to design a new luxury home with J&K Custom Homes on a rare wide, estate-like lot, seconds from Montgomery, Kenwood Town Center and the Village of Indian Hill. This unique loop neighborhood-style street feels private yet inviting. The lot offers a secluded, wooded backdrop with a creek winding along the rear. The thoughtful design pairs timeless architecture with modern living, featuring a 1st flr primary suite, expansive kitchen and great room, scullery, private study, screened deck with fireplace and an amazing view of the woods, mudroom and separate 2 and 1-car garages. Upstairs are two generous bedroom suites. The lot was recently cleared. Construction to begin fall 2026. There is still time to personalize the plan. Curious what the finished interiors could look like? Ask for details on other recently completed J&K Homes!

3 Beds ⋅ 5 Baths ⋅ 1890576 MLS

Welcome to Sandymar Drive, one of Sycamore Township and Indian Hill schools' premier streets. This homesite is the exceptional opportunity you've been waiting for to design a new luxury home with J&K Custom Homes on a rare wide, estate-like lot, seconds from Montgomery, Kenwood Town Center and the Village of Indian Hill. This unique loop neighborhood-style street feels private yet inviting. The lot offers a secluded, wooded backdrop with a creek winding along the rear. The thoughtful design pairs timeless architecture with modern living, featuring a 1st flr primary suite, expansive kitchen and great room, scullery, private study, screened deck with fireplace and an amazing view of the woods, mudroom and separate 2 and 1-car garages. Upstairs are two generous bedroom suites. The lot was recently cleared. Construction to begin fall 2026. There is still time to personalize the plan. Curious what the finished interiors could look like? Ask for details on other recently completed J&K Homes!

8800 Sandymar Drive, Sycamore Twp

Courtesy of Michael Hines with Coldwell Banker Realty

$2,613,100

Beautiful 88+ acres located just outside of Wilmington and near the I-71 exit. Large pond has been added to provide drainage for the piece. Perfect place for development of multi housing.

1891501 MLS

Beautiful 88+ acres located just outside of Wilmington and near the I-71 exit. Large pond has been added to provide drainage for the piece. Perfect place for development of multi housing.

Mt Pleasant Rd, Liberty Twp

Courtesy of Sue Walker with Honnerlaw Real Estate Services

$2,600,000

Set on 4 private acres just minutes from downtown Loveland, this exceptional Stonehaven Modern Manor by Old World Custom Homes presents a rare opportunity to own a completed, move in ready custom home with immediate availability. Blending timeless architecture with luxury craftsmanship, the home offers over 5,000 finished square feet highlighted by a breathtaking vaulted kitchen featuring exposed timber trusses, custom Amish built cabinetry, oversized quartzite islands, adjoining scullery, and dramatic arched stone window wall. The open design flows seamlessly into the Great Room and covered outdoor living area with a see through fireplace. Additional highlights include a luxurious First floor Primary Suite, Private Study, dedicated lounge, finished lower level with bar and fitness space, and a 4 car garage. A truly rare opportunity to enjoy the craftsmanship of Old World Custom Homes on a scale and setting seldom available.

4 Beds ⋅ 5 Baths ⋅ 1894058 MLS

Set on 4 private acres just minutes from downtown Loveland, this exceptional Stonehaven Modern Manor by Old World Custom Homes presents a rare opportunity to own a completed, move in ready custom home with immediate availability. Blending timeless architecture with luxury craftsmanship, the home offers over 5,000 finished square feet highlighted by a breathtaking vaulted kitchen featuring exposed timber trusses, custom Amish built cabinetry, oversized quartzite islands, adjoining scullery, and dramatic arched stone window wall. The open design flows seamlessly into the Great Room and covered outdoor living area with a see through fireplace. Additional highlights include a luxurious First floor Primary Suite, Private Study, dedicated lounge, finished lower level with bar and fitness space, and a 4 car garage. A truly rare opportunity to enjoy the craftsmanship of Old World Custom Homes on a scale and setting seldom available.

10475 Harrison Road, Hamilton Twp

Courtesy of Adam Schupp with Sibcy Cline, Inc.

$2,500,000

Exceptional opportunity to own approximately 166 acres of farmland conveniently located between Wilmington and Hillsboro, Ohio! This property consists of three parcels, offering over 162 tillable acres ideal for agricultural use or investment. A single-family home with an attached two-car garage is situated on one of the parcels. The property benefits from CAUV tax valuation, providing potential property tax savings. With extensive tillable acreage, multiple parcels, and a residential dwelling, this property offers a rare opportunity for farmers, investors, or those seeking a large agricultural estate.

2 Beds ⋅ 1 Baths ⋅ 971722 MLS

Exceptional opportunity to own approximately 166 acres of farmland conveniently located between Wilmington and Hillsboro, Ohio! This property consists of three parcels, offering over 162 tillable acres ideal for agricultural use or investment. A single-family home with an attached two-car garage is situated on one of the parcels. The property benefits from CAUV tax valuation, providing potential property tax savings. With extensive tillable acreage, multiple parcels, and a residential dwelling, this property offers a rare opportunity for farmers, investors, or those seeking a large agricultural estate.

549 Hildebrant Road, New Vienna

Courtesy of Tyler Everidge and eXp Realty

$2,500,000

Excellent opportunity to purchase 103± acres located along US Rte 22 in Richland Township, Clinton County, just west of Reesville. This property features approximately 78 acres of tillable farmland, additional wooded acreage, and 1,580± feet of road frontage. The tillable ground consists of a mixture of Miamian, Crosby-Celina, Kokomo, and Celina-Losantville soils with an overall NCCPI rating of 61.1. Currently enrolled in CAUV, the property offers an opportunity for farmers looking to expand their operations or investors seeking additional agricultural acreage. The property is also zoned I-1 Industrial, offering potential for other permitted uses subject to applicable approvals. Conveniently located near SR 72, US 22, and I-71. Offered as one tract via Sealed Bid Auction, with initial bids due Wednesday, December 9, 2026, at 3:00 PM. Search {Property Address} +"Auction" to visit the full listing online and to download the bidder packet. Local MLS rules require us to input a list price. List price is a suggested starting bid and does not necessarily indicate fair market value or a reserve value. Property sells subject to seller confirmation.

971264 MLS

Excellent opportunity to purchase 103± acres located along US Rte 22 in Richland Township, Clinton County, just west of Reesville. This property features approximately 78 acres of tillable farmland, additional wooded acreage, and 1,580± feet of road frontage. The tillable ground consists of a mixture of Miamian, Crosby-Celina, Kokomo, and Celina-Losantville soils with an overall NCCPI rating of 61.1. Currently enrolled in CAUV, the property offers an opportunity for farmers looking to expand their operations or investors seeking additional agricultural acreage. The property is also zoned I-1 Industrial, offering potential for other permitted uses subject to applicable approvals. Conveniently located near SR 72, US 22, and I-71. Offered as one tract via Sealed Bid Auction, with initial bids due Wednesday, December 9, 2026, at 3:00 PM. Search {Property Address} +"Auction" to visit the full listing online and to download the bidder packet. Local MLS rules require us to input a list price. List price is a suggested starting bid and does not necessarily indicate fair market value or a reserve value. Property sells subject to seller confirmation.

US Rte 22, Sabina

Courtesy of Nathan Sheridan and Sheridans LLC

$2,500,000

Step back in time to this Kettering treasure; the Cox Mansion, also know as Trails End. Built in 1916 by Ohio Governor, James Cox, this beautiful and historic French Renaissance estate is situated on over 5 acres and was designed by Oswald Hering of New York, featuring over 15,000 sq ft. of finished living area. A grand entrance welcomes visitors with a spiral staircase, tiled floors, and fireplace with custom mantle. A warm and inviting paneled library with custom book shelves has new custom flooring with fireplace. A massive living room with paneled walls and fireplace also has new custom hardwood flooring in keeping with the history of the mansion. A gorgeous new kitchen features custom cabinetry, quartz counters, all stainless steel appliances including a wine refrigerator. Current owners have also completed a custom wet bar with rich stained cabinetry with granite counters including a wine refrigerator and icemaker. The banquet sized reception room offers a full wall of windows and seating for very large groups. The convenient first floor laundry has double washers and dryers. Upstairs, find refinished hardwood flooring along with 5 bedrooms; each with a full bathroom. Lower level walkout basement has four additional bedrooms and 3 full bath with 2 half baths Outside, find a newly built inground swimming pool with slide, attractive fence, large patio area surrounding the pool, and tennis courts plus paver patio area. This residence has been used as an AirBnB and in yesteryear, it has hosted dignitaries including President Theodore Roosevelt, Woodrow Wilson, Franklin D Roosevelt, and Harry Truman. Please note that all furnishings convey with the property. Current owners have installed a new kitchen, bar, swimming pool, replaced roof top HVAC units, completed a comprehensive electrical upgrade, refinished architectural trim and more! This estate is an historical masterpiece!

9 Beds ⋅ 11 Baths ⋅ 969611 MLS

Step back in time to this Kettering treasure; the Cox Mansion, also know as Trails End. Built in 1916 by Ohio Governor, James Cox, this beautiful and historic French Renaissance estate is situated on over 5 acres and was designed by Oswald Hering of New York, featuring over 15,000 sq ft. of finished living area. A grand entrance welcomes visitors with a spiral staircase, tiled floors, and fireplace with custom mantle. A warm and inviting paneled library with custom book shelves has new custom flooring with fireplace. A massive living room with paneled walls and fireplace also has new custom hardwood flooring in keeping with the history of the mansion. A gorgeous new kitchen features custom cabinetry, quartz counters, all stainless steel appliances including a wine refrigerator. Current owners have also completed a custom wet bar with rich stained cabinetry with granite counters including a wine refrigerator and icemaker. The banquet sized reception room offers a full wall of windows and seating for very large groups. The convenient first floor laundry has double washers and dryers. Upstairs, find refinished hardwood flooring along with 5 bedrooms; each with a full bathroom. Lower level walkout basement has four additional bedrooms and 3 full bath with 2 half baths Outside, find a newly built inground swimming pool with slide, attractive fence, large patio area surrounding the pool, and tennis courts plus paver patio area. This residence has been used as an AirBnB and in yesteryear, it has hosted dignitaries including President Theodore Roosevelt, Woodrow Wilson, Franklin D Roosevelt, and Harry Truman. Please note that all furnishings convey with the property. Current owners have installed a new kitchen, bar, swimming pool, replaced roof top HVAC units, completed a comprehensive electrical upgrade, refinished architectural trim and more! This estate is an historical masterpiece!

3500 Governors Trail, Kettering

Courtesy of Nancy L Webb and BHHS Professional Realty

$2,500,000

Rare opportunity to own approximately 605 acres of scenic conservation land at 289 State Route 133, Felicity, Ohio. The property includes a bi-level home in need of renovation or possible tear down and a large horse barn. Ideal for recreational use, hunting, ATV riding, horseback riding, with potential for a horse farm or rustic wedding place with the right vision. A conservation easement covers all but approximately 20 acres, which includes the house and barn area extending to the cell tower. Easement details are available through the county recorder's office. A truly unique opportunity to own a large, private tract of land.

1890063 MLS

Rare opportunity to own approximately 605 acres of scenic conservation land at 289 State Route 133, Felicity, Ohio. The property includes a bi-level home in need of renovation or possible tear down and a large horse barn. Ideal for recreational use, hunting, ATV riding, horseback riding, with potential for a horse farm or rustic wedding place with the right vision. A conservation easement covers all but approximately 20 acres, which includes the house and barn area extending to the cell tower. Easement details are available through the county recorder's office. A truly unique opportunity to own a large, private tract of land.

289 St Rt 133, Franklin Twp

Courtesy of Tracy Sunderhaus with Hand In Hand Realty, LLC

$2,500,000

One of a kind 40 acre private estate in the Appalachian foothills overlooking Brush Creek Valley. This 7,000+ SF contemporary home offers 5 bedrooms, 6 baths, ensuite bedrooms, soaring ceilings and walls of windows overlooking a private 3-acre stocked lake. First floor primary suite features a fireplace, lake views and private deck. Expansive kitchen plus catering/prep kitchen. Waterfront patio, outdoor kitchen, pavilion, dock and beach. Approx. 2,000' of deep water river frontage, separate 2 bedroom creekside short term rental and 30x80 glass closed conservatory pavilion with restroom and lakeside setting for gatherings. Hunting, fishing and shooting range/house. Features include loft style guest accommodations, sporting/storage space, 1st-floor laundry, gas & wood-burning fireplaces and 2 geothermal systems. Surrounded by protected conservancy land for exceptional privacy. Ideal private estate, retreat, or recreational property.

5 Beds ⋅ 6 Baths ⋅ 1893939 MLS

One of a kind 40 acre private estate in the Appalachian foothills overlooking Brush Creek Valley. This 7,000+ SF contemporary home offers 5 bedrooms, 6 baths, ensuite bedrooms, soaring ceilings and walls of windows overlooking a private 3-acre stocked lake. First floor primary suite features a fireplace, lake views and private deck. Expansive kitchen plus catering/prep kitchen. Waterfront patio, outdoor kitchen, pavilion, dock and beach. Approx. 2,000' of deep water river frontage, separate 2 bedroom creekside short term rental and 30x80 glass closed conservatory pavilion with restroom and lakeside setting for gatherings. Hunting, fishing and shooting range/house. Features include loft style guest accommodations, sporting/storage space, 1st-floor laundry, gas & wood-burning fireplaces and 2 geothermal systems. Surrounded by protected conservancy land for exceptional privacy. Ideal private estate, retreat, or recreational property.

1805 Waggoner Riffle Road, West Union

Courtesy of Heather Herr with Private Real Estate Collection

$2,500,000

Opportunities like this only come once in a lifetime. One Listing, BUT SO MUCH ELSE! Two Homes, Two Ponds, and 23 acres of rolling meadows and woods. Home #1 is 4 bedrooms, 3.5 bathrooms, 2 car garage with an indoor pool. Home #2 is a 3 bedroom, 1 full bath, 1 car garage, Bonus, you get a 30 x 50 4 stall horse/animal barn, 6000+ sq ft office/shop combo with 3 phase electric, large dock roll-up doors, over-head cranes, meeting rooms, etc.

4 Beds ⋅ 3 Baths ⋅ 963496 MLS

Opportunities like this only come once in a lifetime. One Listing, BUT SO MUCH ELSE! Two Homes, Two Ponds, and 23 acres of rolling meadows and woods. Home #1 is 4 bedrooms, 3.5 bathrooms, 2 car garage with an indoor pool. Home #2 is a 3 bedroom, 1 full bath, 1 car garage, Bonus, you get a 30 x 50 4 stall horse/animal barn, 6000+ sq ft office/shop combo with 3 phase electric, large dock roll-up doors, over-head cranes, meeting rooms, etc.

6788 E US RT 22 & 3, Morrow

Courtesy of Janelle Sprandel and Comey & Shepherd REALTORS

$2,500,000

$100,000 reduction! Opportunities like this only come once in a lifetime. TWO Homes, One 6000 Sq ft Business/Office Space, Two Ponds, and 23 acres of rolling meadows and woods. Home #1 is 4 bedrooms, 3.5 bathrooms, 2 car garage with an indoor pool. Home #2 is a 3 bedroom, 1 full bath, 1 car garage, Bonus, you get a 30 x 50 4 stall horse/animal barn, 6000+ sq ft office/shop combo with 3 phase electric, large dock roll-up doors, over-head cranes, meeting rooms, etc.

4 Beds ⋅ 4 Baths ⋅ 1885279 MLS

$100,000 reduction! Opportunities like this only come once in a lifetime. TWO Homes, One 6000 Sq ft Business/Office Space, Two Ponds, and 23 acres of rolling meadows and woods. Home #1 is 4 bedrooms, 3.5 bathrooms, 2 car garage with an indoor pool. Home #2 is a 3 bedroom, 1 full bath, 1 car garage, Bonus, you get a 30 x 50 4 stall horse/animal barn, 6000+ sq ft office/shop combo with 3 phase electric, large dock roll-up doors, over-head cranes, meeting rooms, etc.

6788 E Us Rt 22 & 3, Salem Twp

Courtesy of Janelle Sprandel with Comey & Shepherd

$2,499,000

Stunning open transition! Staycation resort living! Approx 8991 Sq Ft of pure Luxury! Soaring ceilings,3 gas fireplaces,2 story windows W/magnificent views,a Gourmet Chef's kitchen,2 family rms, billiard Rm, exercise rm, heated gunite pool w/hot tub,swim up bar,gazebo w/outdoor kitchen,built-in grill,& speakers!Circular driveway w/water feature.Sought after Taft Place!Bright & airy!Spacious eat-in kitchen open to family room & decking overlooking the pool & gorgeous grounds!Primary suite w/FP,private deck,large walk-in closet w/organizers,remodeled & spacious glamour bath w/walk in shower.Walkout lower lev w/bar-kitchenette,a generous media/entertainment area,flex spaces,2 full baths,a playroom,2 projectors,& guest room! Abundant storage.A gem-ready to go!Immaculate. Paint-Int & Ext/landscape/carpet on 1st floor/hardwood redone/driveway refresh/kitchen updates/1 AC unit-2026!Low Lev & primary bath full remodels by current owners.

4 Beds ⋅ 6 Baths ⋅ 1883576 MLS

Stunning open transition! Staycation resort living! Approx 8991 Sq Ft of pure Luxury! Soaring ceilings,3 gas fireplaces,2 story windows W/magnificent views,a Gourmet Chef's kitchen,2 family rms, billiard Rm, exercise rm, heated gunite pool w/hot tub,swim up bar,gazebo w/outdoor kitchen,built-in grill,& speakers!Circular driveway w/water feature.Sought after Taft Place!Bright & airy!Spacious eat-in kitchen open to family room & decking overlooking the pool & gorgeous grounds!Primary suite w/FP,private deck,large walk-in closet w/organizers,remodeled & spacious glamour bath w/walk in shower.Walkout lower lev w/bar-kitchenette,a generous media/entertainment area,flex spaces,2 full baths,a playroom,2 projectors,& guest room! Abundant storage.A gem-ready to go!Immaculate. Paint-Int & Ext/landscape/carpet on 1st floor/hardwood redone/driveway refresh/kitchen updates/1 AC unit-2026!Low Lev & primary bath full remodels by current owners.

5035 Taft Place, Indian Hill

Courtesy of Julia Packer Wesselkamper with Coldwell Banker Realty

$2,490,000

Stunning Property for Sale. Over 9,500 Square foot Home on 15 acres with an indoor pool, elevator, newly painted throughout, newer roof, vaulted ceilings, hardwood flooring, Updated Kitchen. Finished 2,000 square foot Barn with Gym and Indoor FullCourt Basketball, Stocked Acre Lake, 6 Bedrooms, 4.5 baths, finished walkout basement with 2nd kitchen New updates throughout. More options than can list, come see your new Dream Home today! Opportunity for substantial tax abatement through Farm classification. Agent is Related to Seller.

6 Beds ⋅ 6 Baths ⋅ 1892017 MLS

Stunning Property for Sale. Over 9,500 Square foot Home on 15 acres with an indoor pool, elevator, newly painted throughout, newer roof, vaulted ceilings, hardwood flooring, Updated Kitchen. Finished 2,000 square foot Barn with Gym and Indoor FullCourt Basketball, Stocked Acre Lake, 6 Bedrooms, 4.5 baths, finished walkout basement with 2nd kitchen New updates throughout. More options than can list, come see your new Dream Home today! Opportunity for substantial tax abatement through Farm classification. Agent is Related to Seller.

9500 Zoar Road, Hamilton Twp

Courtesy of Kristen Heap with Plum Tree Realty

How much is your home worth?

How much is your home worth?