Showcasehomegroup.com Search Results

5 listings

Refine Search

Sort by

369 test ri2, Columbia

5 Beds ⋅ 3 Baths ⋅ 5253242 MLS

369 test ri2, Columbia

9278 Leavitt Road, Elyria

72.18 acres commercial property located in a rapidly growing commercial and residential area, this expansive property offers exceptional potential for development, all utilities are available, making this an ideal opportunity for investors, developers and businesses looking to establish a presence in a thriving area. Buyer is advised to do all necessary due diligence to confirm and satisfy their particular use. There is a gas well and a water well as well as public service available. The house and barn will not be sold separately.

72.18 acres commercial property located in a rapidly growing commercial and residential area, this expansive property offers exceptional potential for development, all utilities are available, making this an ideal opportunity for investors, developers and businesses looking to establish a presence in a thriving area. Buyer is advised to do all necessary due diligence to confirm and satisfy their particular use. There is a gas well and a water well as well as public service available. The house and barn will not be sold separately.

9278 Leavitt Road, Elyria

1117 Abbe Road, Sheffield Village

Prime Development Opportunity in Sheffield Village, 38 acres of Commercial / Industrial land for development with 748 ft of frontage on Abbe Road located just south of the Ford Ohio Assembly Plant. Excellent access to the I-90 Interstate Highway system and possible access to rail service. Close proximity to Lake Erie ports and to many major manufacturing facilities. 35 minutes from downtown Cleveland and Hopkins airport. Public Water and electrical service on site. Boundary Lines in photos are estimated and may not be accurate

Prime Development Opportunity in Sheffield Village, 38 acres of Commercial / Industrial land for development with 748 ft of frontage on Abbe Road located just south of the Ford Ohio Assembly Plant. Excellent access to the I-90 Interstate Highway system and possible access to rail service. Close proximity to Lake Erie ports and to many major manufacturing facilities. 35 minutes from downtown Cleveland and Hopkins airport. Public Water and electrical service on site. Boundary Lines in photos are estimated and may not be accurate

1117 Abbe Road, Sheffield Village

32894 Lake Road, Avon Lake

This Lake Erie waterfront residence offers the kind of lifestyle most only imagine. Thoughtfully designed with remarkable attention to detail, the home features custom finishes throughout, including Italian marble accents and a striking ostrich leather wrapped bar. The interiors, designed by acclaimed Miami designer Jorge Castillo, balance refined style with everyday comfort, creating spaces that feel both elevated and welcoming. Outdoors, the property shines with an inground pool, hot tub, multiple seating areas, and a pool house complete with a kitchen and bar, ideal for entertaining or unwinding by the water. Expansive windows frame uninterrupted lake views, making the shoreline a constant presence throughout the home. This is more than a place to live. It is the lakefront lifestyle you have been waiting for.

6 Beds ⋅ 7 Baths ⋅ 5183096 MLS

This Lake Erie waterfront residence offers the kind of lifestyle most only imagine. Thoughtfully designed with remarkable attention to detail, the home features custom finishes throughout, including Italian marble accents and a striking ostrich leather wrapped bar. The interiors, designed by acclaimed Miami designer Jorge Castillo, balance refined style with everyday comfort, creating spaces that feel both elevated and welcoming. Outdoors, the property shines with an inground pool, hot tub, multiple seating areas, and a pool house complete with a kitchen and bar, ideal for entertaining or unwinding by the water. Expansive windows frame uninterrupted lake views, making the shoreline a constant presence throughout the home. This is more than a place to live. It is the lakefront lifestyle you have been waiting for.

32894 Lake Road, Avon Lake

14647 State Route 511, Camden

Kipton Quarry offers a rare opportunity to acquire a large-scale, reserve-backed quarry within the highly sought-after Berea Sandstone Formation, globally recognized as the industry standard for material consistency and geological testing. This asset is well positioned for mining, infrastructure, and energy-sector operators. The property spans approximately 56 acres, with active extraction on roughly 10 acres, and is supported by an estimated 400 million tons of recoverable Berea sandstone, providing long-term production visibility. All mineral and water rights convey, allowing full control over current operations and future development. All permits are in place and posted in office. Improvements include three on-site buildings totaling approximately 10,000+ SF, supporting processing, storage, logistics, and administrative functions, with additional capacity for expansion or modernization. The quarry serves multiple end markets with a diversified product mix, including architectural and dimensional sandstone, large-format erosion control blocks, aggregate stone for construction, and petroleum-grade core samples supplied domestically and internationally. Berea sandstone is the global reference standard for oil and gas reservoir testing and permeability analysis. The property also includes a natural spring water resource, providing additional development optionality. With substantial reserves, conveyed mineral and water rights, established infrastructure, and multi-sector demand, Kipton Quarry represents a durable, income-capable industrial asset with significant long-term upside.

Kipton Quarry offers a rare opportunity to acquire a large-scale, reserve-backed quarry within the highly sought-after Berea Sandstone Formation, globally recognized as the industry standard for material consistency and geological testing. This asset is well positioned for mining, infrastructure, and energy-sector operators. The property spans approximately 56 acres, with active extraction on roughly 10 acres, and is supported by an estimated 400 million tons of recoverable Berea sandstone, providing long-term production visibility. All mineral and water rights convey, allowing full control over current operations and future development. All permits are in place and posted in office. Improvements include three on-site buildings totaling approximately 10,000+ SF, supporting processing, storage, logistics, and administrative functions, with additional capacity for expansion or modernization. The quarry serves multiple end markets with a diversified product mix, including architectural and dimensional sandstone, large-format erosion control blocks, aggregate stone for construction, and petroleum-grade core samples supplied domestically and internationally. Berea sandstone is the global reference standard for oil and gas reservoir testing and permeability analysis. The property also includes a natural spring water resource, providing additional development optionality. With substantial reserves, conveyed mineral and water rights, established infrastructure, and multi-sector demand, Kipton Quarry represents a durable, income-capable industrial asset with significant long-term upside.

14647 State Route 511, Camden

The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of MLS Now and updated as of . Real estate listings held by brokerage firms other than Real Estate Company are marked with the Internet Data Exchange logo and detailed information about them includes the name of the listing broker(s).
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 MLS Now. All Rights Reserved.

How much is your home worth?

Get instant property value now!