Luma Realty Search Results

257 listings

Refine Search

Sort by

Don't miss out on the LAST LOT IN PHASE 1! Introducing an exciting new home plan by WP Land at Foundry Park in Oakley the site of Homearama 2025. This home features a stunning 22' x 15' gourmet kitchen with a coffee bar, island, custom cabinetry, Thermador appliances, and quartz countertops. The great room boasts a gas fireplace with built-ins. Dining room includes a buffet for added convenience. The primary suite offers two walk-in closets, and the expansive rooftop deck over 1,000 sq. ft. of covered and uncovered space includes a built-in bar for exceptional outdoor entertaining. Lot 15.

2 Beds ⋅ 5 Baths ⋅ 1861755 MLS

Don't miss out on the LAST LOT IN PHASE 1! Introducing an exciting new home plan by WP Land at Foundry Park in Oakley the site of Homearama 2025. This home features a stunning 22' x 15' gourmet kitchen with a coffee bar, island, custom cabinetry, Thermador appliances, and quartz countertops. The great room boasts a gas fireplace with built-ins. Dining room includes a buffet for added convenience. The primary suite offers two walk-in closets, and the expansive rooftop deck over 1,000 sq. ft. of covered and uncovered space includes a built-in bar for exceptional outdoor entertaining. Lot 15.

2905 Three Oaks Lane, Cincinnati

Courtesy of Timothy Mahoney with Sibcy Cline, Inc.

Stunning Modern Retreat in Historic Mount Adams! Elevate your living at 1238 Elsinore Ave, Cincinnati, OH 45202. This 2008-built, 3BR/3.5BA gem offers 3,718 sq ft of luxury: hardwood floors, high ceilings, SS appliances, updated kitchen & baths, 3 fireplaces, elevator, walk-in closets, & in-unit laundry. Panoramic views from balconies & rooftop deck with attached oversized 2-car garage. Pet-friendly with a private city feel. Walk to vibrant dining, shops, Eden Park, & downtown; 1 min to highways. Your modern haven awaits!

3 Beds ⋅ 4 Baths ⋅ 1859608 MLS

Stunning Modern Retreat in Historic Mount Adams! Elevate your living at 1238 Elsinore Ave, Cincinnati, OH 45202. This 2008-built, 3BR/3.5BA gem offers 3,718 sq ft of luxury: hardwood floors, high ceilings, SS appliances, updated kitchen & baths, 3 fireplaces, elevator, walk-in closets, & in-unit laundry. Panoramic views from balconies & rooftop deck with attached oversized 2-car garage. Pet-friendly with a private city feel. Walk to vibrant dining, shops, Eden Park, & downtown; 1 min to highways. Your modern haven awaits!

1238 Elsinore Avenue, Cincinnati

Courtesy of Brian Brockman with Bang Realty, Inc.

Perfect small business/office locations for lease on high-vis corner of Airport/Wilmer - various options available ranging from 200SF small offices to 500SF suite. Maildrop, multiple bathrooms, ADA accessible, plentiful parking, utilities included. Flat, all-inclusive rates @ $17/SF and flexing to fit needs/terms.

Perfect small business/office locations for lease on high-vis corner of Airport/Wilmer - various options available ranging from 200SF small offices to 500SF suite. Maildrop, multiple bathrooms, ADA accessible, plentiful parking, utilities included. Flat, all-inclusive rates @ $17/SF and flexing to fit needs/terms.

4242 Airport Road, Cincinnati

Courtesy of Nicholas Motz with eXp Realty

Welcome to the heart of Cincinnati's Incline District and be part of this thriving historic community. This elegant 3-story, 2,070 SF home features 3 bedrooms, 3 full baths, and a 2-car garage. High-end finishes include beamed ceilings, wood floors, granite and marble surfaces, and an open-concept layout. The first floor offers a walkout to a patio and yard, while the second floor opens to a private deck from a fully equipped kitchen with granite counters, island, and stainless steel appliances. Located just 5 minutes from downtown Cincinnati and major highways, you'll enjoy walkable access to restaurants, entertainment, and parks. A tax abatement is in place through 2033, with current annual taxes at just $302.28. This home is available for traditional sale, seller financing, or a 3-year lease/purchase program. The lease/purchase option requires a non-refundable partial down payment and first month's rent prior to move-in, with the down payment applied toward the purchase price.

3 Beds ⋅ 3 Baths ⋅ 1857731 MLS

Welcome to the heart of Cincinnati's Incline District and be part of this thriving historic community. This elegant 3-story, 2,070 SF home features 3 bedrooms, 3 full baths, and a 2-car garage. High-end finishes include beamed ceilings, wood floors, granite and marble surfaces, and an open-concept layout. The first floor offers a walkout to a patio and yard, while the second floor opens to a private deck from a fully equipped kitchen with granite counters, island, and stainless steel appliances. Located just 5 minutes from downtown Cincinnati and major highways, you'll enjoy walkable access to restaurants, entertainment, and parks. A tax abatement is in place through 2033, with current annual taxes at just $302.28. This home is available for traditional sale, seller financing, or a 3-year lease/purchase program. The lease/purchase option requires a non-refundable partial down payment and first month's rent prior to move-in, with the down payment applied toward the purchase price.

658 Hawthorne Avenue, Cincinnati

Courtesy of Joan Elflein with Ohio Broker Direct

Beautiful Mt.Auburn duplex features 7 bedrooms/3 full baths and 3 Kitchens! Centrally located in Mt Auburn, convenient to UC or downtown. Newer roof & HVAC. LVP flooring throughout. Partially finished walkout out LL to the fenced yard. Great investment opportunity.

Beautiful Mt.Auburn duplex features 7 bedrooms/3 full baths and 3 Kitchens! Centrally located in Mt Auburn, convenient to UC or downtown. Newer roof & HVAC. LVP flooring throughout. Partially finished walkout out LL to the fenced yard. Great investment opportunity.

2320 Maplewood Avenue, Cincinnati

Courtesy of Lei Liu with OwnerLand Realty, Inc.

Open House Info - please stop at our sales center at 271 Strader behind Eli's Bar-b-cue. Final opportunity in this amazing location next to Saint Rose Church, offering extraordinary, unobstructed views of the river and city! Over 17 stunning custom homes have already been sold on this block. This lot presents a rare chance to custom design your tax-abated dream home in Eden. Quality craftsmanship by Inman Construction defines these beautifully built homes. Enjoy outstanding top-floor outdoor living overlooking the Ohio River and downtown skyline. Elevator included! Don't miss your chance to Live the Good Life!

4 Beds ⋅ 4 Baths ⋅ 1850775 MLS

Open House Info - please stop at our sales center at 271 Strader behind Eli's Bar-b-cue. Final opportunity in this amazing location next to Saint Rose Church, offering extraordinary, unobstructed views of the river and city! Over 17 stunning custom homes have already been sold on this block. This lot presents a rare chance to custom design your tax-abated dream home in Eden. Quality craftsmanship by Inman Construction defines these beautifully built homes. Enjoy outstanding top-floor outdoor living overlooking the Ohio River and downtown skyline. Elevator included! Don't miss your chance to Live the Good Life!

2485 Riverside Drive, Cincinnati

Courtesy of Deborah Martin with Keller Williams Advisors

Large and Well Appointed Retail or Office Space in Prime Location on Madison Rd. 2,700 sf on 3 floors plus a spacious Lower Level. HW Floors. 12 car Parking Lot. Sprinkler System. Lease the entire Property for $3,900 per month or the LL and 2 floors for $3,000 per mo., or LL and 1 floor (or 2 upper floors) for $2,500 per month.

Large and Well Appointed Retail or Office Space in Prime Location on Madison Rd. 2,700 sf on 3 floors plus a spacious Lower Level. HW Floors. 12 car Parking Lot. Sprinkler System. Lease the entire Property for $3,900 per month or the LL and 2 floors for $3,000 per mo., or LL and 1 floor (or 2 upper floors) for $2,500 per month.

2029 Madison Road, Cincinnati

Courtesy of Nat Comisar with Sibcy Cline, Inc.

Brand new rooftop plan! Be among the first to own the latest townhome plan by WP Land Company in Foundry Park at Three Oaks. This four-story, 3-bedroom residence offers over 2,400 square feet of well-designed living space, perfectly positioned between the vibrant Homearama® 2025 Row and the community's peaceful park. Enjoy a 4th-floor rooftop level, 2-car garage, site-finished hardwood floors, Thermador appliances, and all the custom-quality finishes that define a WP Land home. Construction has not yet begun, don't miss your opportunity to personalize selections and make it your own. Lot 83.

3 Beds ⋅ 4 Baths ⋅ 1844465 MLS

Brand new rooftop plan! Be among the first to own the latest townhome plan by WP Land Company in Foundry Park at Three Oaks. This four-story, 3-bedroom residence offers over 2,400 square feet of well-designed living space, perfectly positioned between the vibrant Homearama® 2025 Row and the community's peaceful park. Enjoy a 4th-floor rooftop level, 2-car garage, site-finished hardwood floors, Thermador appliances, and all the custom-quality finishes that define a WP Land home. Construction has not yet begun, don't miss your opportunity to personalize selections and make it your own. Lot 83.

4417 Pin Oak Circle, Cincinnati

Courtesy of Timothy Mahoney with Sibcy Cline, Inc.

Introducing WP Land Company's newest townhome design in Foundry Park at Three Oaks now featuring a 4th floor rooftop level for elevated living and entertaining. Perfectly positioned between the Homearama® 2025 Row and the community park, this four-story residence offers modern architecture, refined spaces, and abundant natural light. 2-car garage, site-finished hardwood floors, Thermador appliances, and all the custom-quality finishes WP Land is known for come standard. Elevator option provides added convenience and long-term accessibility. Construction has not yet begun secure your opportunity to make selections and tailor the home to your style. Lot 84

2 Beds ⋅ 4 Baths ⋅ 1844462 MLS

Introducing WP Land Company's newest townhome design in Foundry Park at Three Oaks now featuring a 4th floor rooftop level for elevated living and entertaining. Perfectly positioned between the Homearama® 2025 Row and the community park, this four-story residence offers modern architecture, refined spaces, and abundant natural light. 2-car garage, site-finished hardwood floors, Thermador appliances, and all the custom-quality finishes WP Land is known for come standard. Elevator option provides added convenience and long-term accessibility. Construction has not yet begun secure your opportunity to make selections and tailor the home to your style. Lot 84

4413 Pin Oak Circle, Cincinnati

Courtesy of Timothy Mahoney with Sibcy Cline, Inc.

The Anderson Design by Cristo Homes. Beautiful 2-bedroom, 3.5 bathroom townhome with finished lower level. Approx. 1,910 sq. ft. of living space! Open concept design with luxury finishes, incredible convenience to I-71, 10 minutes from downtown. Located across from Elements Eatery.

2 Beds ⋅ 4 Baths ⋅ 1841965 MLS

The Anderson Design by Cristo Homes. Beautiful 2-bedroom, 3.5 bathroom townhome with finished lower level. Approx. 1,910 sq. ft. of living space! Open concept design with luxury finishes, incredible convenience to I-71, 10 minutes from downtown. Located across from Elements Eatery.

5003 Anderson Place, Cincinnati

Courtesy of Adam Marit with Real Link

This well-maintained property consists of 13 units, featuring one, one-bedroom and twelve, two-bedroom units. Each tenant also has their own separate storage. The property is situated in the West Price Hill neighborhood of Cincinnati, a residential area known for its affordability, community feel, and proximity to downtown. Just four miles from the city center, the location offers convenient access to major roadways, public transportation, and everyday amenities. Residents benefit from nearby retail centers like Glenway Crossing, as well as outdoor recreation at Rapid Run Park and Mount Echo Park. The area has a strong rental base, with consistent demand for affordable and Section 8 housing. This neighborhood combines accessibility, stability, and growth potentialmaking it an ideal setting for long-term multifamily investment. 65% of rents guaranteed!

This well-maintained property consists of 13 units, featuring one, one-bedroom and twelve, two-bedroom units. Each tenant also has their own separate storage. The property is situated in the West Price Hill neighborhood of Cincinnati, a residential area known for its affordability, community feel, and proximity to downtown. Just four miles from the city center, the location offers convenient access to major roadways, public transportation, and everyday amenities. Residents benefit from nearby retail centers like Glenway Crossing, as well as outdoor recreation at Rapid Run Park and Mount Echo Park. The area has a strong rental base, with consistent demand for affordable and Section 8 housing. This neighborhood combines accessibility, stability, and growth potentialmaking it an ideal setting for long-term multifamily investment. 65% of rents guaranteed!

1226 Rutledge Avenue, Cincinnati

Courtesy of Tryfon Christoforou with 3CRE Residential Advisors, LLC

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Right #3

3 Beds ⋅ 4 Baths ⋅ 1723617 MLS

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Right #3

1944 Bigelow Street, Cincinnati

Courtesy of Julie Back with Sibcy Cline, Inc.

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Right #2

3 Beds ⋅ 4 Baths ⋅ 1723614 MLS

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Right #2

1938 Bigelow Street, Cincinnati

Courtesy of Julie Back with Sibcy Cline, Inc.

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Left #2

3 Beds ⋅ 4 Baths ⋅ 1723615 MLS

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Left #2

1942 Bigelow Street, Cincinnati

Courtesy of Julie Back with Sibcy Cline, Inc.

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Left #3

3 Beds ⋅ 4 Baths ⋅ 1723620 MLS

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Exterior Left #3

1948 Bigelow Street, Cincinnati

Courtesy of Julie Back with Sibcy Cline, Inc.

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Middle #2

3 Beds ⋅ 4 Baths ⋅ 1723616 MLS

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Middle #2

1940 Bigelow Street, Cincinnati

Courtesy of Julie Back with Sibcy Cline, Inc.

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Middle #3.

3 Beds ⋅ 4 Baths ⋅ 1723624 MLS

Builder willing to sell the six building lots for $495,000. The six lots are shovel ready. Phase 2 includes: sewer taps, water taps and utilities in place on site. Existing plans and engineering included in price. Urban Life Style Living you've been looking for! Gold leed tax abatement. Exceptional location. Short distance to OTR, Clifton, UC Campus, Parks, Rec Center & Christ Hospital. Abundance of exciting features: open floor plan, engineered hardwood, quartz counters, wood cabinets, 2 car garage & prof landscaping. Building is Middle #3.

1946 Bigelow Street, Cincinnati

Courtesy of Julie Back with Sibcy Cline, Inc.

Prev
1
...
7
8
9
of 9
Next

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than our company are marked with the Broker Reciprocity™ logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. This data is up-to-date as of . Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved. Information deemed reliable but not guaranteed.

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of the Dayton Area Board of Realtors® MLS IDX Database. Real estate listings from the Dayton Area Board of Realtors® MLS IDX Database held by brokerage firms other than Luma Realty are marked with the IDX logo and are provided by the Dayton Area Board of Realtors® MLS IDX Database. Information is provided 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. Copyright© 2026 Dayton Area Board of Realtors®