Welcome to this well-maintained, custom-built home in Howland with a brick front and custom windows. This home offers 3 large bedrooms and 2.5 bathrooms with plenty of living space.
Enter through the foyer featuring an open staircase with a wrought iron railing. The formal great room includes a gas fireplace and provides a comfortable space for relaxing or gathering. The formal dining room features crown molding, a tray ceiling, and a crystal chandelier.
The eat-in kitchen offers an island and two pantries for extra storage. A sliding glass door opens to the patio and landscaped yard, making it a great space for outdoor gatherings. Just off the kitchen, a half bath and laundry room are conveniently located.
Upstairs, the large primary bedroom includes a private full bathroom. Two additional bedrooms and another full bathroom provide space for family or guests. All bedrooms include ceiling fans and large closets.
The basement is dry, plumbed, and ready to be finished for additional living space if desired.
Updates include a brand new roof installed at the end of 2025, a security system and smart garage door technology, whole-house laminate flooring, kitchen disposal, light fixtures and fans (except in the dining room and foyer), and a furnace (comes with 12 yrs warranty on parts and labor), all completed in 2024. The 50-gallon hot water tank and microwave were replaced in 2023. The washer and dryer were new in 2020. The stove, refrigerator, dishwasher, and air conditioner were installed in 2015.
Schedule your showing today to see all this home has to offer.
Closed
$392,000
2031 Celestial Dr NE, Warren, OH 44484
3beds
2,098sqft
Single Family Residence
Built in 2003
0.39 Acres Lot
$395,400 Zestimate®
$187/sqft
$2,441 Estimated rent
Home value
$395,400
$297,000 - $530,000
$2,441/mo
Zestimate® history
Owner options
List your home for rent
$2,441/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,441/mo
Rent Zestimate®
Refinance and save
$2,550/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$2,550/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
Brick frontCustom windowsWasher and dryerCrystal chandelierLight fixtures and fansWhole-house laminate flooringTray ceiling
Zillow last checked:
Listing updated:
Listed by:
Rochelle Arriola 330-518-6221 RochelleA@StoufferRealty.com,
Berkshire Hathaway HomeServices Stouffer Realty,
Jeremy D Hernan 330-519-9818,
Berkshire Hathaway HomeServices Stouffer Realty
Bought with:
Michael Papalios, 2022000832
Brokers Realty Group
Source: MLS Now,MLS#: 5191469
Originating MLS: Youngstown Columbiana Association of REALTORS
Originating MLS: Youngstown Columbiana Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Primary bedroom
- Features: Window Treatments
- Level: Second
- Dimensions: 14.00 x 18.00
Bedroom
- Features: Window Treatments
- Level: Second
- Dimensions: 14.00 x 11.00
Bedroom
- Features: Window Treatments
- Level: Second
- Dimensions: 13.00 x 11.00
Primary bathroom
- Description: Flooring: Ceramic Tile
- Level: Second
Bathroom
- Description: Flooring: Ceramic Tile
- Level: Second
Dining room
- Description: Flooring: Ceramic Tile
- Features: Window Treatments
- Level: First
- Dimensions: 13.00 x 11.00
Eat in kitchen
- Description: Flooring: Ceramic Tile
- Level: First
- Dimensions: 21.00 x 11.00
Great room
- Features: Fireplace, Window Treatments
- Level: First
- Dimensions: 27.00 x 14.00
Laundry
- Description: Flooring: Ceramic Tile
- Level: First
Heating
- Forced Air, Fireplace(s), Gas
Cooling
- Central Air, Ceiling Fan(s)
Features
- Basement: Full,Unfinished
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 2,098
- Total interior livable area: 2,098 sqft
- Finished area above ground: 2,098
Property
Parking
- Total spaces: 2
- Parking features: Attached, Drain, Direct Access, Electricity, Garage, Garage Door Opener, Paved
- Attached garage spaces: 2
Accessibility
- Accessibility features: None
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Porch
- Exterior features: Fire Pit
Lot
- Size: 0.39 Acres
- Dimensions: 200 x 85
- Features: Irregular Lot
Details
- Parcel number: 28902164
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Conventional
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Roof: Asphalt,Fiberglass
Condition
- Year built: 2003
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: Hampton Run 03 Sec 06
HOA
- Has HOA: No
Location
- Region: Warren
Financial & listing details
- Price per square foot: $187/sqft
- Tax assessed value: $295,500
- Annual tax amount: $5,638
- Date on market: 3/6/2026
- Cumulative days on market: 45 days
Price history
| Date | Event | Price |
|---|---|---|
| 5/18/2026 | Sold | $392,000-4.4%$187/sqft |
Source:  MLS Now #5191469 Report a problem | ||
| 4/20/2026 | Pending sale | $410,000$195/sqft |
Source: MLS Now #5191469 Report a problem | ||
| 3/23/2026 | Listed for sale | $410,000$195/sqft |
Source: MLS Now #5191469 Report a problem | ||
| 3/9/2026 | Contingent | $410,000$195/sqft |
Source: MLS Now #5191469 Report a problem | ||
| 3/6/2026 | Listed for sale | $410,000+13.9%$195/sqft |
Source: MLS Now #5191469 Report a problem | ||
| 3/8/2024 | Sold | $360,000-1.4%$172/sqft |
Source: MLS Now #4498136 Report a problem | ||
| 1/23/2024 | Pending sale | $365,000$174/sqft |
Source: MLS Now #4498136 Report a problem | ||
| 10/18/2023 | Listed for sale | $365,000$174/sqft |
Source: MLS Now #4498136 Report a problem | ||
| 10/11/2023 | Listing removed | -- |
Source: MLS Now #4448620 Report a problem | ||
| 9/6/2023 | Listed for sale | $365,000$174/sqft |
Source: MLS Now #4448620 Report a problem | ||
| 8/26/2023 | Listing removed | -- |
Source: MLS Now #4448620 Report a problem | ||
| 8/11/2023 | Price change | $365,000-5.2%$174/sqft |
Source: MLS Now #4448620 Report a problem | ||
| 5/22/2023 | Price change | $385,000-1.3%$184/sqft |
Source: MLS Now #4448620 Report a problem | ||
| 5/13/2023 | Listed for sale | $390,000$186/sqft |
Source: MLS Now #4448620 Report a problem | ||
| 4/13/2023 | Pending sale | $390,000$186/sqft |
Source: MLS Now #4448620 Report a problem | ||
| 4/10/2023 | Listed for sale | $390,000+24275%$186/sqft |
Source: MLS Now #4448620 Report a problem | ||
| 3/31/2019 | Sold | $1,600-95.5%$1/sqft |
Source: Agent Provided Report a problem | ||
| 2/23/2019 | Listing removed | $1,600$1/sqft |
Source: Keller Williams Chervenic Realty #4067160 Report a problem | ||
| 2/19/2019 | Price change | $1,600-11.1%$1/sqft |
Source: Keller Williams Chervenic Realty #4067160 Report a problem | ||
| 2/1/2019 | Listed for rent | $1,800$1/sqft |
Source: Keller Williams Chervenic Rlty #4067160 Report a problem | ||
| 6/30/2003 | Sold | $35,900$17/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,638 +3.1% | $103,430 |
| 2024 | $5,470 -0.4% | $103,430 |
| 2023 | $5,494 +18.9% | $103,430 +40.7% |
| 2022 | $4,619 +2.4% | $73,500 |
| 2021 | $4,513 -7.5% | $73,500 |
| 2020 | $4,877 +6.7% | $73,500 +4.7% |
| 2019 | $4,569 +4.5% | $70,210 |
| 2018 | $4,372 +11.2% | $70,210 |
| 2017 | $3,930 +1.1% | $70,210 +4% |
| 2016 | $3,889 +2.6% | $67,520 |
| 2015 | $3,792 +3.6% | $67,520 |
| 2014 | $3,660 +0.6% | $67,520 |
| 2013 | $3,638 +0.2% | $67,520 |
| 2012 | $3,631 +4.2% | $67,520 +0% |
| 2011 | $3,486 -0.4% | $67,515 -6.5% |
| 2010 | $3,499 +0.2% | $72,240 |
| 2009 | $3,491 +0.2% | $72,240 |
| 2008 | $3,482 +0.5% | -- |
| 2007 | $3,465 -0.3% | -- |
| 2006 | $3,477 +2% | -- |
| 2005 | $3,407 +19.7% | $72,240 |
| 2004 | $2,848 | -- |
Find assessor info on the county website
Neighborhood: 44484
Nearby homes
- $388,9004 bd4 ba2.3k sqft2027 Celestial Dr NE, Warren, OH 44484Off Market
- $382,1004 bd2 ba2.2k sqft2035 Celestial Dr NE, Warren, OH 44484Off Market
- $389,1004 bd3 ba2.1k sqft2023 Celestial Dr NE, Warren, OH 44484Off Market
- $368,0004 bd2 ba2.1k sqft2039 Celestial Dr NE, Warren, OH 44484Off Market
- $357,0003 bd3 ba2.3k sqft2028 Celestial Dr NE, Warren, OH 44484Sold
- $345,4003 bd2 ba2k sqft2032 Celestial Dr NE, Warren, OH 44484Off Market
- $340,0004 bd3 ba2.2k sqft2043 Celestial Dr NE, Warren, OH 44484Sold
- $392,4003 bd3 ba2.4k sqft2036 Celestial Dr NE, Warren, OH 44484Off Market
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.3 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
$395,400
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
$395,400
- Ohio
- Trumbull County
- Warren
- 44484
- 2031 Celestial Dr NE
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Warren Topics
