Skip main navigation
Sold for $918,000
  • $918,000

    404 Sycamore St, Celebration, FL 34747

    5beds
    4,150sqft
    Single Family Residence
    Built in 1996
    9,321 Square Feet Lot
    $1,471,800 Zestimate®
    $221/sqft
    $7,375 Estimated rent

    Home value

    $1,471,800

    $1.31M - $1.68M

    $7,375/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $7,375/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,375/mo

    Rent Zestimate®

    Refinance and save

    $6,334/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,334/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 started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Seller says Sell! Big Price Drop! Special Fall Is In The Air Promotion for a fabulous home located in the main village of the town that Disney built - Seller will pay one year of HOA at closing for buyer if accepted contract is received by 10/31/2019 that goes to close. Super Rare Main Village Property up for sale for the first time! This Wonderful Single Family Home provides marvelous Options as it is the largest (sq ft under air) property on Celebration's Favored Sycamore Street - Many people will love THIS Newport Coastal Model as you will receive a Double Porch, First Floor Master, Corner Lot, recent new roof, double pane windows, remodeled Kitchen, first floor office and three additional bedrooms upstairs - four full baths in the main house Plus a 3 Car garage apt - So 5 total bedrooms, 5 total bathrooms And an office ! It's almost impossible to find this Winning combination in Celebration's Main Village. You can easily rent the garage apt for approximately $1,200 a month as most tenants want to be able to walk to downtown Celebration which is chock full of great restaurants, close to K- 8 school, retail stores, Starbucks, Post Office, Celebration Golf Course and much more. Measurements, fees & what is included should be independently verified by buyer or buyers agent. Then it is all about Location, Location, Location!
    Originating MLS: Orlando Regional

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 5
    Heating
    • Other
    Cooling
    • Other
    Appliances
    • Laundry: Inside
    Features
    • Ceiling Fans(s), Eating Space In Kitchen, High Ceiling(s), Master Bedroom Downstairs, Open Floorplan, Split Bedroom, Walk-In Closet(s), Crown Molding, Solid Wood Cabinets, Thermostat, Kitchen/Family Room Combo, Solid Surface Counters, Cathedral Ceiling(s), Vaulted Ceiling(s), Tray Ceiling(s)
    • Flooring: Tile, Carpet
    • Windows: Blinds, Window Treatments
    • Fireplace features: Wood Burning
    Interior area
    • Total interior livable area: 4,150 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage
    Features
    • Levels: Two
    • Patio & porch: Front Porch, Rear Porch
    • Exterior features: Other
    Lot
    • Size: 9,321 Square Feet
    • Features: Sidewalk, Street Paved, Corner Lot, Near Golf Course
    • Residential vegetation: Trees/Landscaped
    Details
    • Parcel number: 072528278300012430
    • Zoning: OPUD

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Footing
    • Roof: Composition
    Condition
    • Completed
    • Year built: 1996
    Details
    • Builder model: The Newport
    • Builder name: David Weekley

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Electricity Connected, Sewer Connected, Cable Available, Public, Street Lights, Underground Utilities, Sprinkler Recycled

    Community & HOA

    Community
    • Security: Smoke Detector(s)
    • Subdivision: CELEBRATION VILLAGE UNIT 02
    HOA
    • Has HOA: Yes
    • Amenities included: Playground, Fitness Center, Park, Pool, Tennis Court(s), Basketball Court
    • HOA fee: $79 monthly
    Location
    • Region: Celebration

    Financial & listing details

    • Price per square foot: $221/sqft
    • Tax assessed value: $1,256,300
    • Annual tax amount: $18,368
    • Listing terms: Cash, Conventional
    • Ownership: Fee Simple

    Price history

    DateEventPrice
    11/13/2023Sold$918,000-45.3%$221/sqft
    Source: Public Record Report a problem
    10/18/2023Pending sale$1,677,500$404/sqft
    Source: Stellar MLS #O6142794 Report a problem
    9/28/2023Price change$1,677,500-4.1%$404/sqft
    Source: Stellar MLS #O6142794 Report a problem
    9/18/2023Listed for sale$1,749,000+90.2%$421/sqft
    Source: Stellar MLS #O6142794 Report a problem
    1/7/2021Listing removed--
    Source: Stellar MLS Report a problem
    1/6/2021Sold$919,800-1%$222/sqft
    Source: Stellar MLS #O5749223 Report a problem
    10/3/2019Pending sale$928,900$224/sqft
    Source: FLORIDA IN MOTION REALTY INC #O5749223 Report a problem
    8/27/2019Price change$928,900-1.1%$224/sqft
    Source: FLORIDA IN MOTION REALTY INC #O5749223 Report a problem
    5/1/2019Price change$938,900-3.8%$226/sqft
    Source: FLORIDA IN MOTION REALTY INC #O5749223 Report a problem
    3/5/2019Price change$975,7490%$235/sqft
    Source: FLORIDA IN MOTION REALTY INC #O5749223 Report a problem
    12/5/2018Listed for sale$975,750+169.8%$235/sqft
    Source: FLORIDA IN MOTION REALTY INC #O5749223 Report a problem
    1/9/1997Sold$361,600$87/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$18,368 +4%$1,256,300 +5.9%
    2024$17,656 +12.4%$1,186,400 -0.1%
    2023$15,701 +11.8%$1,188,100 +14.4%
    2022$14,042 +17.4%$1,038,100 +35.3%
    2021$11,957 +60%$767,000 +4.8%
    2020$7,475 +0.7%$731,800 +1.7%
    2019$7,421 $719,700 +52.9%
    2018$7,421 +0.9%$470,690 +2.1%
    2017$7,358 -0.2%$461,009 +2.1%
    2016$7,371 +1%$451,527 +0.7%
    2015$7,298 -11.9%$448,389 +0.8%
    2014$8,281 $444,831 +1.5%
    2013-- $438,258 +1.7%
    2012-- $430,933 -42.8%
    2007-- $753,400 +10.4%
    2006-- $682,200 +31.2%
    2005-- $520,000 +22.9%
    2004-- $423,200
    2003-- $423,200 +23.4%
    2002$5,191 +1.8%$343,077 +1.6%
    2001$5,101 +1%$337,674 +3%
    2000$5,049 $327,839
    Find assessor info on the county website

    Neighborhood: Celebration Village

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Celebration (K12)
    • Middle: Celebration (K12)
    • High: Celebration High

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    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

    $1,471,800

    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

    $1,471,800