The Retreat at Emerald Woods offers a unique opportunity to own a new construction ranch home in Columbia Station. Set among woodlands with 140+ acres of reserved common areas, you'll love the combination of convenience and innovative new home designs. Our ranch homes include first-floor owner's suites, lawn care, snow removal, optional second-floor living, and more.
Sold for $507,000
Street View
$507,000
23498 Saint Andrews Dr, Columbia Station, OH 44028
3beds
2,784sqft
SingleFamily
Built in 2023
7,840 Square Feet Lot
$538,600 Zestimate®
$182/sqft
$3,238 Estimated rent
Home value
$538,600
$512,000 - $566,000
$3,238/mo
Zestimate® history
Owner options
List your home for rent
$3,238/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,238/mo
Rent Zestimate®
Refinance and save
$3,292/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,292/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
Center islandVersatile floor planOpen kitchen
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Heating
- Other
Cooling
- Central
Features
- Has fireplace: No
Interior area
- Total interior livable area: 2,784 sqft
Property
Parking
- Parking features: Garage - Attached
Features
- Exterior features: Other
Lot
- Size: 7,840 Square Feet
Details
- Parcel number: 1200017000154
Construction
Type & style
- Home type: SingleFamily
Materials
- Frame
- Foundation: Slab
Condition
- Year built: 2023
Community & HOA
Location
- Region: Columbia Station
Financial & listing details
- Price per square foot: $182/sqft
- Tax assessed value: $458,390
- Annual tax amount: $6,904
Price history
| Date | Event | Price |
|---|---|---|
| 11/2/2023 | Sold | $507,000+42.8%$182/sqft |
Source: Public Record Report a problem | ||
| 5/30/2023 | Listing removed | -- |
Source: | ||
| 5/24/2023 | Price change | $354,990-2.5%$128/sqft |
Source: | ||
| 4/25/2023 | Price change | $363,990+6.7%$131/sqft |
Source: | ||
| 2/28/2023 | Price change | $340,990-4.7%$122/sqft |
Source: | ||
| 2/23/2023 | Listed for sale | $357,990$129/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $6,904 +475.6% | $160,440 +574.1% |
| 2023 | $1,200 | $23,800 |
| 2022 | -- | $23,800 |
Find assessor info on the county website
Neighborhood: 44028
Nearby homes
- $542,7003 bd3 ba2.7k sqft23514 Saint Andrews Dr, Columbia Station, OH 44028Off Market

- $490,6003 bd3 ba3k sqft23492 Saint Andrews Dr, Columbia Station, OH 44028Off Market
- $484,1003 bd2 ba2.2k sqft23526 Saint Andrews Dr, Columbia Station, OH 44028Off Market
- $537,1003 bd3 ba2.8k sqft23486 Saint Andrews Dr, Columbia Station, OH 44028Off Market
- $489,4003 bd2 ba2.7k sqft23544 Saint Andrews Dr, Columbia Station, OH 44028Off Market
- $551,8003 bd3 ba2.7k sqft23478 Saint Andrews Dr, Columbia Station, OH 44028Off Market
- $494,9002 bd2 ba2k sqft23499 Saint Andrews Dr, Columbia Station, OH 44028Off Market
- $479,7003 bd2 ba1.9k sqft23513 Saint Andrews Dr, Columbia Station, OH 44028Off Market
Nearby schools
GreatSchools rating
- 8/10Columbia Middle SchoolGrades: 5-8Distance: 2 mi
- 8/10Columbia High SchoolGrades: 9-12Distance: 2 mi
- 6/10Copopa Elementary SchoolGrades: PK-4Distance: 2.1 mi
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
$538,600
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
$538,600
- Ohio
- Lorain County
- Columbia Station
- 44028
- 23498 Saint Andrews Dr
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