$425,000

174 Celtic Wedding Dr Saint Johns, FL 32259

Estimated payment $2,771/month

Total Views 3,594
4 Beds
2 Baths
1,823 Sq Ft
$233 Price per Sq Ft

Highlights

  • Fitness Center
  • Home fronts a pond
  • Open Floorplan
  • Freedom Crossing Academy Rated A
  • Pond View
  • Clubhouse

About This Home

Exquisite Waterview Retreat in St. Johns, Florida! This stunning 4-bedroom, 2-bathroom home offers water views, an open-concept floor plan, and impeccable finishes for both relaxation and everyday comfort. Enjoy soaring ceilings, natural light, and designer touches throughout. The gourmet kitchen features quartz countertops, stainless steel appliances, and an oversized island—perfect for entertaining. The spacious living and dining areas open to the lanai, where you can enjoy breathtaking sunsets. The primary suite boasts a spa-like ensuite with dual vanities, a soaking tub, a walk-in shower, and a large closet. Three additional bedrooms provide ample space for family, guests, or a home office. Located in a top-rated school district, this community offers 2 pools, a fitness center, basketball courts, parks, and more! Enjoy nearby shopping, dining, golf, and Ponte Vedra Beach. Experience Florida living at its finest—schedule your private tour today! Recent updates include Bosch dishwasher less than 1 yr old, brand new interior/exterior paint, brand new carpets in bedrooms, and newly pressure washed. Water Heater ~ 2-3 yrs old, LVP flooring 2 years old, AC ~ 5 yrs old.

Listing Agent

MELANIE CROSS-HARTLEY

HERRON REAL ESTATE LLC License #3404565

HERRON REAL ESTATE LLC

Co-Listing Agent

Jason Hartley

HERRON REAL ESTATE LLC License #3292344

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,732

Year Built

  • Built in 2012

Lot Details

  • 7,405 Sq Ft Lot
  • Home fronts a pond
  • Wrought Iron Fence
  • Vinyl Fence
  • Back Yard Fenced

HOA Fees

  • $5 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Traditional Architecture
  • Shingle Roof
  • Siding
  • Stucco

Interior Spaces

  • 1,823 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Entrance Foyer
  • Pond Views

Kitchen

  • Electric Oven
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms
  • Bathtub and Shower Combination in Primary Bathroom

Laundry

  • Laundry in unit
  • Washer and Electric Dryer Hookup

Outdoor Features

  • Patio

Utilities

  • Central Heating and Cooling System
  • Electric Water Heater

Listing and Financial Details

  • Assessor Parcel Number 0097622470

Community Details

Overview

  • Aberdeen Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Basketball Court
  • Community Playground
  • Fitness Center
  • Park
  • Dog Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,732

Year Built

Built in 2012

Lot Details

0

HOA Fees

$5 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Attached Yn: No
  • New Construction: No
  • Stories: 1
  • Year Built: 2012
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.17
  • Road Surface Type: Asphalt
  • Subdivision Name: Aberdeen
  • Architectural Style: Traditional
  • Carport Y N: No
  • Garage Yn: Yes
  • Sewer:Public Sewer: Yes
  • Appliances Microwave: Yes
  • ViewPond: Yes
  • General Property Information:Pool Private YN: No
  • Special Features: None

Interior Features

  • Interior Amenities: Ceiling Fan(s), Entrance Foyer, Kitchen Island, Open Floorplan, Pantry, Primary Bathroom - Tub with Shower, Walk-In Closet(s)
  • Major Appliances: Dishwasher, Disposal, Electric Oven, Electric Range, Electric Water Heater, Microwave
  • Full Bathrooms: 2
  • Total Bedrooms: 4
  • Flooring: Carpet, Laminate, Tile
  • ResoLivingAreaSource: PublicRecords
  • Appliances:Electric Water Heater: Yes
  • Appliances Dishwasher: Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Kitchen Island: Yes
  • Interior Features:Pantry: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Interior Features:Entrance Foyer: Yes
  • Appliances:Electric Oven: Yes
  • Laundry Features:In Unit: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Open Floorplan: Yes

Exterior Features

  • Waterfront: Yes
  • Fencing: Back Yard, Vinyl, Wrought Iron
  • Roof: Shingle
  • View: Pond
  • Waterfront Features: Pond
  • Construction Type: Composition Siding, Stucco
  • Patio And Porch Features: Covered, Patio
  • Waterfront Features:Pond2: Yes
  • Patio And Porch Features:Covered2: Yes
  • Patio And Porch Features:Patio: Yes
  • Construction Materials:Stucco: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.0
  • Parking Features: Attached, Garage
  • General Property Information:Garage Spaces: 2.0
  • Parking Features:Attached: Yes
  • Parking Features:Garage: Yes
  • General Property Information:Garage YN: Yes

Utilities

  • Utilities: Cable Available, Electricity Connected, Sewer Connected, Water Connected
  • Laundry Features: Electric Dryer Hookup, In Unit, Washer Hookup
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Central
  • Heating Yn: Yes
  • Sewer: Public Sewer
  • Water Source: Public
  • Heating:Central: Yes

Condo/Co-op/Association

  • Association Fee: 60.0
  • Association Fee Frequency: Annually
  • Senior Community: No
  • Amenities: Basketball Court, Clubhouse, Dog Park, Fitness Center, Park, Playground
  • Association: Yes

Association/Amenities

  • General Property Information:Association YN: Yes
  • General Property Information:Association Fee: 60.0
  • General Property Information:Association Fee Frequency: Annually
  • Association Amenities:Clubhouse: Yes
  • Association Amenities:Basketball Court: Yes
  • Association Amenities:Fitness Center: Yes
  • Association Amenities:Playground: Yes
  • Association Amenities:Park: Yes
  • Association Amenities:Dog Park: Yes

Lot Info

  • Current Use: Residential
  • Lot Size Sq Ft: 7405.2
  • Parcel #: 0097622470
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 4732.18
  • Tax Year: 2024

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $4,814 $248,731 -- --
2023 $4,814 $252,564 $0 $0
2022 $3,591 $159,376 $0 $0
2021 $3,547 $154,734 $0 $0
2020 $3,505 $152,598 $0 $0
2019 $3,717 $149,167 $0 $0
2018 $3,563 $146,386 $0 $0
2017 $3,553 $143,375 $0 $0
2016 $3,549 $144,639 $0 $0
2015 $3,574 $143,634 $0 $0
2014 $3,578 $142,493 $0 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/07/2025 04/07/25 Price Changed $425,000 -2.3% $233 / Sq Ft
03/20/2025 03/20/25 For Sale $435,000 +146.7% $239 / Sq Ft
12/17/2023 12/17/23 Off Market $176,345 -- --
06/29/2012 06/29/12 Sold $176,345 -2.0% $98 / Sq Ft
04/16/2012 04/16/12 Pending -- -- --
02/14/2012 02/14/12 For Sale $180,010 -- $100 / Sq Ft
Source: realMLS (Northeast Florida Multiple Listing Service)

Deed History

Date Type Sale Price Title Company
Quit Claim Deed $100 None Listed On Document
Corporate Deed $176,345 Dhi Title Of Florida Inc
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $299,145 FHA
Previous Owner $45,000 Stand Alone Second
Previous Owner $179,943 New Conventional
Source: Public Records

Similar Homes in the area

  • 653 Box Branch Cir, Saint Johns, FL 32259

    $509,000

    • 3 Beds
    • 2 Baths
    • 1,852 Sq Ft
    • 653 Box Branch Cir
    • Saint Johns, FL

    Beautiful Fully renovated Home in the heart of Julington Creek Plantation! Open Floor Plan, New Kitchen Cabinets, Venato Quartz countertops, All Appliances incl., Custom Tile, New Luxury plank flooring, All New Bathrooms with Freestanding tub in the Primary, All New Designer Lighting, Two Car Garage, Screened Patio opens on to a Nature Preserve with Fenced Backyard and New pavers. Don't miss this

    RENDA HALL INI REALTY

    Section Image
  • 287 Shetland Dr, Saint Johns, FL 32259

    $450,000

    • 4 Beds
    • 2 Baths
    • 1,913 Sq Ft
    • 287 Shetland Dr
    • Saint Johns, FL

    Lovingly cared for and thoughtfully designed, this beautifully maintained home in St. Johns, FL offers comfort, space, and style in the heart of a vibrant, amenity-rich community. Step inside to discover an open-concept floorplan that seamlessly blends living, dining, and kitchen areas—perfect for entertaining or everyday living. The layout is smart and efficient, with no wasted space, making the

    Erica Jolles ROUND TABLE REALTY

    Section Image
  • 101 Lochnagar Mountain Dr, Saint Johns, FL 32259

    $394,000

    • 3 Beds
    • 2 Baths
    • 1,540 Sq Ft
    • 101 Lochnagar Mountain Dr
    • Saint Johns, FL

    Open House Wed April 23rd (12 to 3:00) Sutherland Forest neighborhood of Aberdeen! This impeccably maintained residence offers 3 spacious bedrooms, 2 pristine baths, and a versatile flex room—ideal as a home office, formal living or dining area, or even a relaxing retreat. With 1,540 square feet of thoughtfully designed living space, every detail has been curated for modern comfort and style.

    Aliea Veon BETROS REALTY INC

    Section Image
  • 546 S Aberdeenshire Dr, Saint Johns, FL 32259

    $364,500

    • 3 Beds
    • 2 Baths
    • 1,323 Sq Ft
    • 546 S Aberdeenshire Dr
    • Saint Johns, FL

    This exceptional three-bedroom, two-bathroom home features an open-concept design is situated in one of the finest communities in Northwest St. John's County, known as Aberdeen.The interior boasts a blend of tile, laminate, & carpeted flooring, enhancing its inviting atmosphere. The expansive kitchen showcases 42-inch wooden cabinetry, stainless steel appliances & a convenient breakfast bar,

    Sena Baker FIRST COAST REALTY OF JACKSONVILLE INC

    Section Image
  • 1556 Greenridge Cir W, Saint Johns, FL 32259

    $474,900

    • 3 Beds
    • 2 Baths
    • 1,947 Sq Ft
    • 1556 Greenridge Cir W
    • Saint Johns, FL

    MS CLEAN LIVES HERE! I challenge you to find a more immaculate home than this one...they are RARE! Lovely ALL BRICK home on almost half an acre with a pond view and PLENTY OF SPACE BETWEEN HOMES. NEW ROOF in 2025 with extended transferrable warranty (a $25,000 upgrade). This Custom built home is rock solid and NO CDD fees. Mature trees and landscaping really set this apart. Oversized side

    Dana Hancock RE/MAX SPECIALISTS

    Section Image
  • 1071 Orangewood Rd, Saint Johns, FL 32259

    $439,000

    • 3 Beds
    • 2.5 Baths
    • 2,326 Sq Ft
    • 1071 Orangewood Rd
    • Saint Johns, FL

    NO HOA or rules, NO COOKIE CUTTER HERE...this custom POOL home has ALL the character new homes lack! Full brick exterior, this adorable home is LOADED with features; especially when it comes to outdoor living!!! Situated on almost 1/2 acre the privacy it provides is hard to find. In the fully fenced backyard you'll find the shimmering inground Pool, a screened gazebo with TV & fan, a

    Dana Hancock RE/MAX SPECIALISTS

    Section Image
  • 217 Clover Ct, Saint Johns, FL 32259

    $424,999

    • 3 Beds
    • 2 Baths
    • 2,102 Sq Ft
    • 217 Clover Ct
    • Saint Johns, FL

    *MOTIVATED SELLER, offering $8,000 towards buyers closing costs and prepaids.**Discover this delightful 3-bedroom, 2-bathroom home in the highly desirable Julington Creek Plantation. Offering a perfect blend of comfort, style, and versatility, this home is ready to meet all your needs.This home features a bonus room/office with a vaulted ceiling, this versatile space can be used as a home

    DWIGHT SKYERS FLORIDA HOMES REALTY & MTG LLC

    Section Image
  • 496 Heron Landing Rd, Saint Johns, FL 32259

    $485,000

    • 3 Beds
    • 2.5 Baths
    • 1,900 Sq Ft
    • 496 Heron Landing Rd
    • Saint Johns, FL

    Better Than a Model Home! Stunning Durbin Crossing Gem - Huge Lot & Custom Features!Welcome to your new home that looks straight out of a design magazine! Located in the highly sought-after St. Johns County, this 3-bedroom, 2.5-bathroom home is a rare opportunity under $500K in a neighborhood where homes at this price point are hard to come by. This home sits on one of the largest lots in

    Erica Jolles ROUND TABLE REALTY

    Section Image
  • 61 Archwood Dr, St. Augustine, FL 32092

    $447,500

    • 3 Beds
    • 2 Baths
    • 1,850 Sq Ft
    • 61 Archwood Dr
    • St. Augustine, FL

    **OPEN HOUSE SAT the 19th 12:30-3:00** The Ultimate resort-style living in Shearwater AND it is located at the northern entrance near 210 and very close to the amenity center! This exceptional one-story residence features 3 beautifully appointed bedrooms, 2 luxurious baths, and a versatile office/flex space that adapts perfectly to your lifestyle—all set on a desirable corner lot with a

    Aliea Veon BETROS REALTY INC

    Section Image

Source: realMLS (Northeast Florida Multiple Listing Service)

MLS Number: 2076378

realMLS (Northeast Florida Multiple Listing Service)

APN: 009762-2470