NOT LISTED FOR SALE

510 Mossy Creek Ct Alpharetta, GA 30004

Estimated Value: $865,000 - $1,072,939

4 Beds
4.5 Baths
5,503 Sq Ft
$175/Sq Ft Est. Value

Last Sold October 03, 2023

Last sale price $875,000 $159 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $5,859/month

50 Days on Market

Highlights

  • View of Trees or Woods
  • Craftsman Architecture
  • Deck
  • Midway Elementary School Rated A
  • Dining Room Seats More Than Twelve
  • Wooded Lot

About This Home

As of October 2023

Beautiful Hedgewood built home in sought after Longwood subdivision. Only 58 homes in this charming community and best kept secret in Forsyth County! Three story home on full finished basement. Brand new carpet and interior paint. Huge detached 3 car garage with massive storage space in the attic (entire area covered with plywood), and a freight lift for getting heavy or large items into the attic. Largest floorplan in the neighborhood. Main level features an office/study with built ins, huge dining room that can fit an oversized table, updated kitchen with granite counters, island and separate eating area. Kitchen opens to spacious family room with stone fireplace. Hardwood floors on entire main level. Oversized master suite and updated bathroom upstairs plus 2 additional bedrooms with Jack and Jill bath. Third story has a 4th bedroom and full bath plus a large walk-in closet. Perfect space for a teen or guest. Basement is finished and features a full bathroom, large living room, workout room and a room set up as a bedroom. There is some unfinished space in the basement that can be used as a workshop, for storage, or can be finished if desired. You will love the rocking chair double decker porches off the side of the home overlooking the beautiful courtyard area. This home is in an unbelievable location and in a desirable community with lots of trees and large size lots. Denmark High School and the brand new Midway Elementary school opening in 2024 are within walking distance from the neighborhood. Close to Fowler Park, the Big Creek Greenway and shopping and dining at the Halcyon development and the Collection at Forsyth. Welcome home!

Last Agent to Sell the Property

Amy Mcdaniel

Drake Realty of GA, Inc. License #229338 Listed on: 07/12/2023

Drake Realty of GA, Inc.

Last Buyer's Agent

Ashley Goodrich

Keller Williams Rlty Consultants License #343389

Keller Williams Rlty Consultants

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,253

Year Built

  • Built in 2001

Lot Details

  • 0.59 Acre Lot
  • Cul-De-Sac
  • Landscaped
  • Corner Lot
  • Level Lot
  • Irrigation Equipment
  • Wooded Lot
  • Back Yard

HOA Fees

  • $92 Monthly HOA Fees

Parking

  • 3 Car Detached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway Level

Home Design

  • Craftsman Architecture
  • Traditional Architecture
  • Shingle Roof
  • Composition Roof
  • Cement Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 3-Story Property
  • Bookcases
  • Crown Molding
  • Ceiling height of 10 feet on the main level
  • Ceiling Fan
  • Entrance Foyer
  • Family Room with Fireplace
  • Dining Room Seats More Than Twelve
  • Breakfast Room
  • Formal Dining Room
  • Workshop
  • Home Gym
  • Views of Woods
  • Fire and Smoke Detector
  • Laundry Room

Kitchen

  • Open to Family Room
  • Breakfast Bar
  • Walk-In Pantry
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Stone Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Oversized primary bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Separate Shower in Primary Bathroom

Finished Basement

  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry
  • Finished Basement Bathroom
  • Stubbed For A Bathroom

Outdoor Features

  • Courtyard
  • Deck
  • Covered Patio or Porch

Location

  • Property is near schools
  • Property is near shops

Schools

  • Midway - Forsyth Elementary School
  • Desana Middle School
  • Denmark High School

Utilities

  • Central Heating and Cooling System
  • Heating System Uses Natural Gas
  • Underground Utilities
  • Gas Water Heater
  • Septic Tank
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 45
  • Assessor Parcel Number 062   162

Community Details

Overview

  • Longwood HOA, Phone Number (678) 429-9996
  • Longwood Subdivision

Recreation

  • Community Playground
  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,253

Year Built

Built in 2001

Lot Details

0

HOA Fees

$92 per month

Parking

3

Listing Details

  • Standard Status: Closed
  • Legal Description: 2-1 549 LOT45 LONGWOOD
  • Property Type: Residential
  • MLS Status: Closed
  • Property Sub Type: Single Family Residence
  • Architectural Style: Craftsman, Traditional
  • Property Condition: Resale
  • Year Built: 2001
  • Levels Stories: Three Or More
  • Cert Prof Home Bldrs Legacy: Hedgewood
  • Above Grade Finished Sq Ft: 3854.00
  • Below Grade Sq Ft: 408.00
  • Special Features: None

Property Details

  • Property: Residential Detached

Interior Features

  • Flooring: Carpet, Ceramic Tile, Hardwood
  • Fireplace Features: Family Room
  • Number Of Fireplaces: 1
  • Other Equipment: Irrigation Equipment
  • Appliances: Dishwasher, Disposal, Gas Range, Gas Water Heater, Microwave
  • Interior Amenities: Bookcases, Crown Molding, Double Vanity, Entrance Foyer, High Ceilings 9 ft Upper, High Ceilings 10 ft Main, High Speed Internet, Walk-In Closet(s)
  • Basement: Bath/Stubbed, Exterior Entry, Finished, Finished Bath, Full, Interior Entry
  • Kitchen Features: Breakfast Bar, Breakfast Room, Cabinets Other, Kitchen Island, Pantry Walk-In, Stone Counters, View to Family Room
  • Common Walls: No Common Walls
  • Additional Rooms: Basement, Exercise Room, Workshop
  • Dining Room Features: Seats 12+, Separate Dining Room
  • Square Footage: 5503.00
  • Spa Features: None
  • Window Features: None
  • Below Grade Finished Sq Ft: 1241.00

Beds/Baths

  • Total Bedrooms: 4
  • Bedroom Features: Oversized Master
  • Total Bathrooms: 5
  • Total Full Baths: 4
  • Total Half Baths: 1
  • Lower Full Bathrooms: 1
  • Main Half Bathrooms: 1
  • Master Bathroom Features: Double Vanity, Separate Tub/Shower

Exterior Features

  • Other Structures: Garage(s)
  • Construction Materials: Cement Siding
  • Roof Type: Composition, Shingle
  • Patio And Porch Features: Covered, Deck, Front Porch, Rear Porch, Side Porch
  • Exterior Features: Courtyard
  • View: Trees/Woods
  • Foundation: Concrete Perimeter

Garage/Parking

  • Carport or Garage: 3
  • Number of Garage Spaces: 3
  • Number Of Parking Spaces: 3
  • Parking Features: Detached, Driveway, Garage, Garage Door Opener, Garage Faces Side, Level Driveway

Utilities

  • Sewer: Septic Tank
  • Water Source: Public
  • Security: Smoke Detector(s)
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Central, Natural Gas
  • Laundry Features: Laundry Room
  • Utilities: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Underground Utilities, Water Available
  • Electric: Other

Condo/Co-op/Association

  • HOA Fee Includes: Reserve Fund, Swim/Tennis, Trash
  • Community Features: Homeowners Assoc, Near Schools, Near Shopping, Near Trails/Greenway, Playground, Pool, Sidewalks, Street Lights
  • Association Fee: 1100
  • Association Fee Frequency: Annually
  • Association: Yes
  • Hoa Contact Phone: 678-429-9996
  • Management Company Email: hoa.longwood@gmail.com
  • Subdivision Complex: Longwood

Association/Amenities

  • Management Company: Longwood HOA

Schools

  • Elementary School: Midway - Forsyth
  • Middle School: DeSana
  • High School: Denmark High School

Lot Info

  • Acres: 0.5900
  • Lot: 45
  • Deed Book: 10779
  • Deed Page: 251
  • Lot Features: Back Yard, Corner Lot, Cul-De-Sac, Landscaped, Level, Wooded
  • Lot Dimensions: x
  • Parcel Number: 062   162
  • Horse Amenities: None
  • Land Lease: No
  • Property Attached Yn: No

Green Features

  • Green Energy Generation: None

Tax Info

  • Taxes: 5253.00
  • Assessor Parcel Number: 062-000-162
  • Close Date: 2023-10-03
  • Tax Year: 2022

MLS Schools

  • Elementary School: Midway - Forsyth
  • High School: Denmark High School
  • Middle School: DeSana

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 12, 2023
Closed on
Oct 3, 2023
Sold by
Yearwood Brian L and Yearwood Perri A
Bought by
Mahan Kenneth Scott and Mahan Carolan Elizabeth
Seller's Agent
Amy Mcdaniel
Drake Realty of GA, Inc.
Buyer's Agent
Ashley Goodrich
Keller Williams Rlty Consultants
List Price
$875,000
Sold Price
$875,000
Views
83
Current Estimated Value
$964,485

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$89,485
Avg. Annual Appreciation
4.99%
Original Mortgage
$700,000
Outstanding Balance
$686,518
Interest Rate
7.23%
Mortgage Type
New Conventional
Estimated Equity
$277,967

Purchase Details

Closed on
Sep 21, 2021
Sold by
Yearwood Brian L
Bought by
Yearwood Brian L and Yearwood Perri A

Purchase Details

Closed on
Nov 5, 2009
Sold by
Yearwood Perri A
Bought by
Yearwood Brian L

Purchase Details

Closed on
Oct 25, 2002
Sold by
Yearwood Brian L
Bought by
Yearwood Brian L and Yearwood Terri Ann

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$300,000
Interest Rate
5.93%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 17, 2001
Sold by
Hedgewood Properties Inc +
Bought by
Yearwood Brian L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$300,700
Interest Rate
6.49%
Mortgage Type
New Conventional
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Mahan Kenneth Scott $875,000 None Listed On Document
Yearwood Brian L -- --
Yearwood Brian L -- --
Yearwood Brian L -- --
Yearwood Brian L $435,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mahan Kenneth Scott $700,000
Previous Owner Yearwood Brian L $300,000
Previous Owner Yearwood Brian L $300,700
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/03/2023 10/03/23 Sold $875,000 0.0% $159 / Sq Ft
09/01/2023 09/01/23 Pending -- -- --
08/29/2023 08/29/23 For Sale $875,000 0.0% $159 / Sq Ft
07/22/2023 07/22/23 Pending -- -- --
07/12/2023 07/12/23 For Sale $875,000 -- $159 / Sq Ft
Source: First Multiple Listing Service (FMLS)

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 $7,833 $352,408 $68,000 $284,408
2024 $7,833 $341,964 $68,000 $273,964
2023 $5,380 $278,456 $60,000 $218,456
2022 $5,253 $180,844 $40,000 $140,844
2021 $4,597 $180,844 $40,000 $140,844
2020 $4,555 $178,812 $30,000 $148,812
2019 $4,512 $176,372 $30,000 $146,372
2018 $4,537 $176,772 $30,000 $146,772
2017 $4,250 $162,396 $30,000 $132,396
2016 $3,984 $149,796 $24,000 $125,796
2015 $3,949 $147,796 $22,000 $125,796
2014 $3,545 $137,340 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: First Multiple Listing Service (FMLS)

MLS Number: 7243885

First Multiple Listing Service (FMLS)

APN: 062-162