Move-In Ready Mystique ranch home available NOW in Del Webb! Enjoy the resort-style amenities and low maintenance living while enjoying the innovative open floor plan of the popular Mystique. This home offers a 3-car garage AND 150 square feet of storage! Walk into this gorgeous home from the front porch where you can enjoy your morning coffee. The Mystique boasts a great deal of natural daylight with large windows. The kitchen has the WOW factor with beautiful quartz countertops and upgraded cabinets. Enjoy the stainless-steel built-in appliances while cooking your favorite meals. The owner’s suite bedroom is oversized and enjoy relaxing in the spa-like bathroom. The most wonderful feature of this home is it’s view of the plush trees while sitting out on the rear extended patio. Call now for a viewing!
Closed
$647,287
1074 Greenhouse Trl, Columbia Station, OH 44028
2beds
1,841sqft
Single Family Residence
Built in 2025
8,276 Square Feet Lot
$663,200 Zestimate®
$352/sqft
$2,686 Estimated rent
Home value
$663,200
$590,000 - $743,000
$2,686/mo
Zestimate® history
Owner options
List your home for rent
$2,686/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,686/mo
Rent Zestimate®
Refinance and save
$4,582/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,582/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Large windowsBeautiful quartz countertopsInnovative open floor planStainless-steel built-in appliancesFront porchRear extended patioSpa-like bathroom
Zillow last checked:
Listing updated:
Listed by:
Matthew Suttle 330-705-7536 matt.suttle@pulte.com,
Keller Williams Chervenic Rlty
Bought with:
William D Eddy, 2018002760
Russell Real Estate Services
Source: MLS Now,MLS#: 5136741
Originating MLS: Akron Cleveland Association of REALTORS
Originating MLS: Akron Cleveland Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 2
Primary bedroom
- Description: Flooring: Luxury Vinyl Tile
- Level: First
- Dimensions: 16 x 14
Bedroom
- Description: Flooring: Luxury Vinyl Tile
- Level: First
- Dimensions: 12 x 11
Primary bathroom
- Description: Flooring: Luxury Vinyl Tile
- Level: First
Bathroom
- Description: Flooring: Luxury Vinyl Tile
- Level: First
Eat in kitchen
- Description: Flooring: Luxury Vinyl Tile
- Level: First
- Dimensions: 11 x 10
Great room
- Description: Flooring: Luxury Vinyl Tile
- Level: First
- Dimensions: 19 x 13
Kitchen
- Description: Flooring: Luxury Vinyl Tile
- Level: First
Laundry
- Description: Flooring: Luxury Vinyl Tile
- Level: First
Library
- Description: Flooring: Luxury Vinyl Tile
- Level: First
- Dimensions: 12 x 10
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Built-In Oven, Cooktop, Dishwasher, Disposal, Microwave
- Laundry: Electric Dryer Hookup, Main Level, Laundry Room, Laundry Tub, Sink
Features
- Has basement: No
- Number of fireplaces: 1
Interior area
- Total structure area: 1,841
- Total interior livable area: 1,841 sqft
- Finished area above ground: 1,841
Property
Parking
- Total spaces: 3
- Parking features: Attached, Driveway, Garage Faces Front, Garage, Garage Door Opener, Oversized
- Attached garage spaces: 3
Features
- Levels: One
- Stories: 1
- Patio & porch: Rear Porch, Covered, Front Porch
- Pool features: Community
Lot
- Size: 8,276 Square Feet
Details
- Parcel number: 1200015000122
- Special conditions: Builder Owned
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Batts Insulation, Blown-In Insulation, Frame, Shake Siding, Stone Veneer, Vinyl Siding
- Foundation: Slab
- Roof: Asphalt
Condition
- New Construction
- New construction: Yes
- Year built: 2025
Details
- Builder name: Pulte Homes Of Ohio, Llc
- Warranty included: Yes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Features: Common Grounds/Area, Clubhouse, Curbs, Fitness Center, Fitness, Other, Pool, Street Lights, Sidewalks
- Security: Carbon Monoxide Detector(s), Smoke Detector(s)
- Senior community: Yes
HOA
- Has HOA: Yes
- Services included: Association Management, Common Area Maintenance, Insurance, Maintenance Grounds, Pool(s), Recreation Facilities, Reserve Fund, Snow Removal
- HOA fee: $350 monthly
- HOA name: Hickory Greens Hoa
Location
- Region: Columbia Station
Financial & listing details
- Price per square foot: $352/sqft
- Date on market: 7/2/2025
- Cumulative days on market: 37 days
- Listing terms: Cash,Conventional,FHA,VA Loan
Price history
| Date | Event | Price |
|---|---|---|
| 9/29/2025 | Sold | $647,287-1.8%$352/sqft |
Source:  MLS Now #5136741 Report a problem | ||
| 8/8/2025 | Pending sale | $659,212$358/sqft |
Source: MLS Now #5136741 Report a problem | ||
| 7/2/2025 | Price change | $659,212$358/sqft |
Source: MLS Now #5136741 Report a problem | ||
| 4/24/2025 | Listed for sale | -- |
Source:  Del Webb Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | -- |
Find assessor info on the county website
Neighborhood: 44028
Nearby homes
- $492,100-- bd-- ba-- sqft1054 Greenhouse Trl, Columbia Station, OH 44028Sold
- $653,3152 bd2 ba2.6k sqft1078 Greenhouse Trl, Columbia Station, OH 44028Sold
- $662,0003 bd3 ba2.7k sqft1082 Greenhouse Trl, Columbia Station, OH 44028Sold
- $622,800-- bd-- ba-- sqft1031 Greenhouse Trl, Columbia Station, OH 44028Sold
- $574,800-- bd-- ba-- sqft1030 Greenhouse Trl, Columbia Station, OH 44028Sold
- $302,0004 bd1 ba1.7k sqft23685 Royalton Rd, Columbia Station, OH 44028Sold
- $280,5003 bd1 ba1.5k sqft23661 Royalton Rd, Columbia Station, OH 44028Off Market
- $---- bd-- ba-- sqft2018 Blueberry Ct, Columbia Station, OH 44028Off Market
Nearby schools
GreatSchools rating
- 8/10Columbia Middle SchoolGrades: 5-8Distance: 2 mi
- 8/10Columbia High SchoolGrades: 9-12Distance: 1.7 mi
- 6/10Copopa Elementary SchoolGrades: PK-4Distance: 2 mi
Schools provided by the listing agent
- District: Columbia LSD - 4705
Source: MLS Now. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$663,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$663,200
- Ohio
- Lorain County
- Columbia Station
- 44028
- 1074 Greenhouse Trl
Nearby cities
Nearby zip codes
Other Columbia Station Topics
- Apartments for Rent in 44028
- Houses for Sale in 44028
- Houses for Rent in 44028
- 44028 Real Estate
- Columbia Station Condos
- Houses for Sale in Columbia Station
- Newest Listings in Columbia Station
- Columbia Station Home Values
- Columbia Station Real Estate Agents
- Columbia Station Refinance
- Columbia Station Mortgage Rates
