23459 St Andrews Drive
Columbia Station, OH 44028
- 3 beds
- 3 baths
- 2,747 sqft
- $218 per sqft
- 2023 build
- – on site
Welcome to this stunning Mystique model home in the desirable Emerald Woods community of Columbia Station! Offering over 2,700 sq ft of meticulously designed living space, this move-in-ready home is better than new, with every available upgrade and option selected—perfect for buyers who want luxury without the wait of building. From the fully landscaped front entrance, step into a welcoming mudroom/laundry area with a custom built-in bench. Just off the entry is a spacious bedroom and a full bath featuring upgraded flooring, a fully tiled shower, and a recessed shelf for convenience. Down the hall, a private home office with French doors and custom paneling awaits. The heart of the home features a wide-open layout with a gourmet kitchen, granite countertops, soft-close cabinets, and stainless steel appliances, flowing into the expansive family room and bump-out dining area centered around a gorgeous stone fireplace. The first-floor owner’s suite is a serene escape, complete with crown molding, a spa-like en suite with a rainfall shower, recessed shelf, dual vanities, and a large walk-in closet. Upstairs offers a spacious bonus living area, an additional bedroom, and another full bath—ideal for guests, a teen suite, or media room. Step outside to the extended L-shaped stamped concrete patio retreat with ceiling fans and enjoy your private backyard oasis Car enthusiasts will love the heated, extended garage with epoxy floors, hot and cold water, and plenty of space for storage or a workshop. Additional highlights: upgraded crown molding throughout, luxury flooring, plush upgraded carpet, premium lighting and ceiling fans, dimmer switches, and a built-in sound system throughout the entire home, backyard, and second floor. Turnkey and landscaped—save big over new! Furniture and sound system optional.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated May 4, 2025
•
MLS# 5118997 —
The Building
-
Year Built:2023
-
Year Built Source:PublicRecords
-
Construction Materials:Brick,VinylSiding
-
Architectural Style:Colonial
-
Direction Faces:North
-
Window Features:Blinds,DoublePaneWindows,WindowTreatments
-
Patio And Porch Features:Covered,FrontPorch,SeeRemarks
-
Levels:Two
-
Stories:2
-
Roof:Asphalt,Fiberglass
-
Basement:None
-
Basement:false
-
Foundation:Slab
-
Green Energy Efficient:Hvac,Lighting,Thermostat,Windows
-
Stories Total:21
-
Above Grade Finished Area:2747.0
-
Above Grade Finished Area Source:PublicRecords
Interior
-
Rooms Total:9
-
Interior Features:CeilingFans,CrownMolding,EntranceFoyer,EatInKitchen,GraniteCounters,HighCeilings,PrimaryDownstairs,OpenFloorplan,Pantry,SoundSystem,SeeRemarks,WalkInClosets,WiredForSound
-
Fireplace:true
-
Fireplaces Total:1
-
Fireplace Features:GlassDoors,GasLog,GreatRoom,Gas
Room Dimensions
-
Living Area:2747.0
-
Living Area Units:SquareFeet
Location
-
Directions:Rt. 82 to Boone, Right on Heatherstone and another right on St. Andrews.
-
Latitude:41.324477
-
Longitude:-81.888462
The Property
-
Parcel Number:12-00-017-000-135
-
Property Type:Residential
-
Property Subtype:SingleFamilyResidence
-
Property Subtype Additional:SingleFamilyResidence
-
Lot Features:BackYard,Landscaped,Private
-
Lot Size Acres:0.1763
-
Lot Size Area:0.1763
-
Lot Size Units:Acres
-
Lot Size Source:PublicRecords
-
View:true
-
View:Other
-
Property Attached:true
-
Fencing:None
-
Waterfront:false
-
Land Lease:false
Listing Agent
- Contact info:
- Agent phone:
- (440) 864-9792
- Office phone:
- (440) 327-6511
Taxes
-
Tax Year:2024
-
Tax Legal Description:EMERALD WOODS SUB NO 3 55.18 X 143.66
-
Tax Annual Amount:$6,988
Beds
-
Bedrooms Total:3
-
Main Level Bedrooms:2
Baths
-
Total Baths:3
-
Full Baths:3
-
Main Level Baths:2
The Listing
-
Listing Terms:Cash,Conventional,FHA,VaLoan
-
Home Warranty:false
-
Virtual Tour URL Unbranded 3:https://www.propertypanorama.com/23459-St-Andrews-Drive-Columbia-Station-OH-44028/unbranded
Heating & Cooling
-
Heating:ForcedAir,Fireplaces,Gas
-
Heating:true
-
Cooling:CentralAir,CeilingFans
-
Cooling:true
Utilities
-
Sewer:PublicSewer
-
Water Source:Public
Appliances
-
Appliances:BuiltInOven,Dishwasher,Disposal,Microwave,Range,Refrigerator
-
Laundry Features:WasherHookup,ElectricDryerHookup
Schools
-
Elementary School District:Columbia LSD - 4705
-
Middle School District:Columbia LSD - 4705
-
High School District:Columbia LSD - 4705
The Community
-
Subdivision Name:Emerald Woods Sub 3
-
Pool Private:false
-
Pool Features:None
-
Pets Allowed:Yes
-
Association:true
-
Association Fee:$400
-
Association Name:Emerald HOA
-
Association Fee Includes:AssociationManagement,Insurance,MaintenanceGrounds,Other,ReserveFund,SnowRemoval
-
Association Fee Frequency:Annually
-
Association Fee 2 Frequency:Monthly
Parking
-
Garage:true
-
Attached Garage:true
-
Garage Spaces:3.0
-
Carport:false
-
Parking Features:Attached,Driveway,Electricity,GarageFacesFront,Garage,GarageDoorOpener,HeatedGarage,Oversized,WaterAvailable
Monthly cost estimate
Asking price
$600,000
| Expense | Monthly cost |
|---|---|
|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$3,212
|
| Taxes | $582 |
| Insurance | $165 |
| HOA fees | $33 |
| Utilities | $150 See report |
| Total | $4,142/mo.* |
| *This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Max Internet Speed
Provided by BroadbandNow®
This is the maximum advertised internet speed available for this home. Under 10 Mbps is in the slower range, and anything above 30 Mbps is considered fast. For heavier internet users, some plans allow for more than 100 Mbps.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
5/1/25
May 1, 2025
|
Listed / Active | MLS_NOW | $600,000 |
