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!
Sold for $647,287 on 09/29/25
$647,287
1074 Greenhouse Trl, Columbia Station, OH 44028
2beds
1,841sqft
Single Family Residence
Built in 2025
8,276.4 Square Feet Lot
$647,900 Zestimate®
$352/sqft
$-- Estimated rent
Owner options
What's special
Zillow last checked: 7 hours ago
Listing updated: September 30, 2025 at 06:01am
Listing Provided 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

Facts & 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 sqft
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 & neighborhood
Security
- Security features: Carbon Monoxide Detector(s), Smoke Detector(s)
Community
- Community features: Common Grounds/Area, Clubhouse, Curbs, Fitness Center, Fitness, Other, Pool, Street Lights, Sidewalks
Senior living
- Senior community: Yes
Location
- Region: Columbia Station
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $350 monthly
- Services included: Association Management, Common Area Maintenance, Insurance, Maintenance Grounds, Pool(s), Recreation Facilities, Reserve Fund, Snow Removal
- Association name: Hickory Greens Hoa
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan
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
$647,900