Welcome to your dream home in one of Howland's most desirable neighborhoods! This meticulously maintained, one-owner residence offers a perfect blend of comfort and style with 3 generous bedrooms, 2.5 bathrooms, and an oversized attached 2-car garage for additional storage. The inviting two-story foyer and open living areas make this home a must see! The kitchen features granite countertops, a modern backsplash, stainless steel appliances, a generous pantry, and vaulted ceiling. The great room, adjacent to the kitchen, has a gas fireplace and full wall of windows offering great natural lighting. The current den on the first floor could also serve as a formal dining room, if desired. Additionally, the first floor office has plumbing for a laundry room, if a first floor laundry is a must. There is also a conveniently located half bath on the first floor. Retreat to the upstairs where the primary bedroom boasts a spacious walk-in closet and a luxurious ensuite bathroom complete with a soaking tub and a separate shower. Two additional spacious bedrooms have great closet space and an additional full bath. The finished basement has a large great room and bar area as well. Step outside to your private backyard sanctuary, where you’ll find a beautifully landscaped yard featuring a large private patio, perfect for relaxing and enjoying the outdoors. Additional highlights include a new roof in 2023, new furnace in 2017, new washing machine in 2025, and stamped concrete patio in 2018. Don’t miss out—schedule your showing today and make this exceptional property yours! A one-year home warranty is included for added peace of mind.
Closed
$357,000
2028 Celestial Dr NE, Warren, OH 44484
3beds
2,393sqft
Single Family Residence
Built in 1997
0.41 Acres Lot
$369,700 Zestimate®
$149/sqft
$2,451 Estimated rent
Home value
$369,700
$292,000 - $466,000
$2,451/mo
Zestimate® history
Owner options
List your home for rent
$2,451/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,451/mo
Rent Zestimate®
Refinance and save
$2,322/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$2,322/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
Gas fireplaceVaulted ceilingModern backsplashLarge private patioTwo-story foyerFinished basementStainless steel appliances
Zillow last checked:
Listing updated:
Listed by:
Leslie A Cornicello 330-856-2299 wzr@williamzamarelli.com,
William Zamarelli, Inc.
Bought with:
Kim Dobson, 392409
Russell Real Estate Services
Source: MLS Now,MLS#: 5146463
Originating MLS: Stark Trumbull Area REALTORS
Originating MLS: Stark Trumbull Area REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Primary bedroom
- Description: Walk-in closet + 2nd closet,Flooring: Carpet
- Level: Second
- Dimensions: 13 x 15
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 12 x 12
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 12 x 13
Dining room
- Description: Currently used as den
- Level: First
- Dimensions: 11 x 11
Family room
- Description: Beautifully finished w/bar area,Flooring: Carpet
- Features: Bar
- Level: Basement
- Dimensions: 21 x 24
Great room
- Description: Gas fireplace,Flooring: Carpet
- Features: Fireplace
- Level: First
- Dimensions: 15 x 17
Laundry
- Description: Plumbing in wall of office for 1st floor laundry
- Level: Basement
- Dimensions: 10 x 12
Office
- Description: Plumbing in wall for 1st floor laundry,Flooring: Carpet
- Level: First
- Dimensions: 6 x 7
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Dryer, Dishwasher, Disposal, Microwave, Range, Refrigerator, Washer
- Laundry: In Basement, Main Level
Features
- Ceiling Fan(s), Cathedral Ceiling(s), Entrance Foyer, Granite Counters, His and Hers Closets, Kitchen Island, Multiple Closets, Pantry, Vaulted Ceiling(s), Bar
- Basement: Full,Finished,Sump Pump
- Number of fireplaces: 1
- Fireplace features: Great Room
Interior area
- Total structure area: 2,393
- Total interior livable area: 2,393 sqft
- Finished area above ground: 1,889
- Finished area below ground: 504
Property
Parking
- Total spaces: 2
- Parking features: Attached, Driveway, Garage Faces Front, Garage, Garage Door Opener
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Front Porch, Patio
- Fencing: Partial,Wood
Lot
- Size: 0.41 Acres
- Features: Back Yard, Dead End, Front Yard, Landscaped, Few Trees
Details
- Parcel number: 28902165
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Colonial
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Roof: Asphalt,Fiberglass
Condition
- Year built: 1997
Details
- Warranty included: Yes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Smoke Detector(s)
HOA
- Has HOA: No
Location
- Region: Warren
Financial & listing details
- Price per square foot: $149/sqft
- Tax assessed value: $262,900
- Annual tax amount: $4,867
- Date on market: 8/7/2025
- Cumulative days on market: 5 days
Price history
| Date | Event | Price |
|---|---|---|
| 9/17/2025 | Sold | $357,000+2%$149/sqft |
Source:  MLS Now #5146463 Report a problem | ||
| 8/11/2025 | Pending sale | $349,900$146/sqft |
Source: MLS Now #5146463 Report a problem | ||
| 8/7/2025 | Listed for sale | $349,900+1127.7%$146/sqft |
Source: MLS Now #5146463 Report a problem | ||
| 9/3/1997 | Sold | $28,500$12/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,899 +0.7% | $92,020 |
| 2024 | $4,867 -0.4% | $92,020 |
| 2023 | $4,888 +18.2% | $92,020 +39.9% |
| 2022 | $4,134 +2.4% | $65,770 |
| 2021 | $4,038 -0.4% | $65,770 |
| 2020 | $4,054 -1% | $65,770 +4.5% |
| 2019 | $4,096 +4.5% | $62,930 |
| 2018 | $3,919 +11.2% | $62,930 |
| 2017 | $3,523 +2.6% | $62,930 +5.6% |
| 2016 | $3,433 +2.6% | $59,610 |
| 2015 | $3,348 +3.6% | $59,610 |
| 2014 | $3,231 +0.6% | $59,610 |
| 2013 | $3,212 +0.2% | $59,610 |
| 2012 | $3,206 +4.2% | $59,610 +0% |
| 2011 | $3,078 -0.3% | $59,605 -6.5% |
| 2010 | $3,087 -2.6% | $63,735 |
| 2009 | $3,168 +0.2% | $63,735 |
| 2008 | $3,160 +3.4% | -- |
| 2007 | $3,057 -0.3% | -- |
| 2006 | $3,068 +2% | -- |
| 2005 | $3,006 +14.8% | $63,735 |
| 2004 | $2,618 -0.6% | -- |
| 2003 | $2,635 +13% | -- |
| 2002 | $2,331 +2.9% | -- |
| 2001 | $2,266 +2.2% | -- |
| 2000 | $2,218 | -- |
Find assessor info on the county website
Neighborhood: 44484
Nearby homes
- $345,4003 bd2 ba2k sqft2032 Celestial Dr NE, Warren, OH 44484Off Market
- $368,5004 bd2 ba2.3k sqft2024 Celestial Dr NE, Warren, OH 44484Off Market
- $392,4003 bd3 ba2.4k sqft2036 Celestial Dr NE, Warren, OH 44484Off Market
- $435,0003 bd3 ba3.8k sqft2020 Celestial Dr NE, Warren, OH 44484Sold
- $317,6003 bd2 ba1.7k sqft2170 Celestial Dr NE, Warren, OH 44484Off Market
- $329,3003 bd2 ba1.6k sqft2164 Celestial Dr NE, Warren, OH 44484Off Market
- $388,9004 bd4 ba2.3k sqft2027 Celestial Dr NE, Warren, OH 44484Off Market
- $392,0003 bd3 ba2k sqft2031 Celestial Dr NE, Warren, OH 44484Sold
Nearby schools
GreatSchools rating
- 6/10Mines Elementary SchoolGrades: 3-5Distance: 1.2 mi
- 7/10Howland Middle SchoolGrades: 5-8Distance: 2.5 mi
- 7/10Howland High SchoolGrades: 9-12Distance: 2.2 mi
Schools provided by the listing agent
- District: Howland LSD - 7808
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
$369,700
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
$369,700
- Ohio
- Trumbull County
- Warren
- 44484
- 2028 Celestial Dr NE
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Warren Topics
