$405,000
SOLD JUN 6, 2025

174 Celtic Wedding Dr Saint Johns, FL 32259

4 Beds
2 Baths
1,823 Sq Ft
7,405 Sq Ft Lot

Recently Sold

$222 Per Sq Ft

7% Below List Price

47 Days on Market

Highlights

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

About This Home

As of June 2025

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.

Last Agent to Sell the Property

MELANIE CROSS-HARTLEY

HERRON REAL ESTATE LLC License #3404565 Listed on: 03/20/2025

HERRON REAL ESTATE LLC

Co-Listed By

Jason Hartley

HERRON REAL ESTATE LLC License #3292344

Last Buyer's Agent

DANNY TRAN

LATITUDE 30 REALTY LLC License #3500044

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
  • 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

  • Covered Patio or Porch

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
  • General Property Information Living Area2: 1823.0
  • General Property Information Waterfront YN: Yes
  • General Property Information New Construction YN: No
  • General Property Information List PriceSqFt2: 227.65
  • Cooling Central Air: Yes
  • Sewer:Public Sewer: Yes
  • Water Source Public: Yes
  • Architectural Style Traditional: Yes
  • General Property Information Accessibility Features YN2: No
  • Appliances Microwave: Yes
  • Flooring Tile: Yes
  • Laundry Features Electric Dryer Hookup: Yes
  • Laundry Features Washer Hookup: Yes
  • Interior Features Primary Bathroom - Tub with Shower: Yes
  • Fencing Back Yard: Yes
  • Flooring Laminate: Yes
  • General Property Information Senior Community YN: No
  • Construction Materials Composition Siding: Yes
  • General Property Information Lot Size Acres: 0.17
  • General Property Information Carport YN: No
  • Utilities Electricity Connected: 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
  • Living Area: 1823.0
  • 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

Tax Info

  • Tax Annual Amount: 4732.18
  • Tax Year: 2024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 20, 2025
Closed on
Jun 6, 2025
Sold by
Rodarte Sarah
Bought by
Nguyen Tuong Thien and Nguyen Tuong Vy
Seller's Agent
MELANIE CROSS-HARTLEY
HERRON REAL ESTATE LLC
Buyer's Agent
DANNY TRAN
LATITUDE 30 REALTY LLC
List Price
$435,000
Sold Price
$405,000
Premium/Discount to List
-$30,000
-6.9%
Views
108
Current Estimated Value
$405,670

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$670
Avg. Annual Appreciation
0.30%
Original Mortgage
$324,000
Outstanding Balance
$323,160
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
$82,510

Purchase Details

Closed on
Feb 2, 2024
Sold by
Rodarte David
Bought by
Rodarte Sarah

Purchase Details

Listed on
Feb 14, 2012
Closed on
Jun 26, 2012
Sold by
D R Horton Inc Jacksonville
Bought by
Rodarte Sarah Denise and Rodarte David
Seller's Agent
Charlie Rogers, Jr
D R HORTON REALTY INC
Buyer's Agent
Stella Alexander
ENGEL & VOLKERS FIRST COAST
List Price
$180,010
Sold Price
$176,345
Premium/Discount to List
-$3,665
-2.04%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.36%
Original Mortgage
$179,943
Interest Rate
3.83%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Purchase History

Date Type Sale Price Title Company
Warranty Deed $405,000 Landmark Title
Warranty Deed $405,000 Landmark Title
Quit Claim Deed $100 None Listed On Document
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 $324,000 New Conventional
Closed $324,000 New Conventional
Previous Owner $179,943 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/06/2025 06/06/25 Sold $405,000 -2.4% $222 / Sq Ft
05/06/2025 05/06/25 Pending -- -- --
05/01/2025 05/01/25 Price Changed $415,000 -2.4% $228 / Sq Ft
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 View Prior Sale
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)

Tax History Compared to Growth

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
2025 $4,814 $265,533 -- --
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

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: realMLS (Northeast Florida Multiple Listing Service)

MLS Number: 2076378

realMLS (Northeast Florida Multiple Listing Service)

APN: 009762-2470