Skip main navigation
Off market
Street View
  • $2,623,400

    400 Water St, Celebration, FL 34747

    5beds
    5,124sqft
    Single Family Residence
    Built in 1997
    0.41 Acres Lot
    $2,623,400 Zestimate®
    $512/sqft
    $6,181 Estimated rent

    Home value

    $2,623,400

    $2.33M - $2.96M

    $6,181/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

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

    $6,181/mo

    Rent Zestimate®

    Refinance and save

    $17,581/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

    $17,581/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

    Rare Iconic Main Village Mansion up for sale. The "Rosemount" is in a caliber all to its own, this Main Village Mansion designed after the Rosemount Mansion in Alabama ( which is on the Historic Preservation site) . This two lot estate has stopped many in its tracks as it is divine in every aspect situated with beautiful views of Picturesque Canal & Celebration Golf Club. Super Rare Opportunity to own two Estate Lots in the Main Village of Celebration (LOTS 103 & 104) The Elegant first floor master bedroom has a walk-in closet and en-suite Master Bath located off of private garden. The architecture details include exquisite Crown Moldings, Grand Staircase and Multiple Fireplaces. This One-of-a-kind home offers a Music Room, Library and Family Room with French doors leading to the massive covered Wrap Porch and Fountain Pool. The Guest Quarters have a Bedroom, Bath and Media/Game Room. Both the Dining Room and Living Room have Fireplaces! Multiple doors lead to an expansive Lawn ( lot size closer to 1/2 acre which is impossible to find in this Disney town) , Giant Shade Trees & perfect seating areas to extend your entertainment area. Spectacular 360 degree views of Celebration, EPCOT Spaceship Earth and the Disney Fireworks from the "crow's nest" Cupola. All bedrooms are massive in size and many offer gardens or balconies off of them ( 5 bedroom, 5 full bath and 1/2 bath). Greek Revival with columns that are to die for - stroll to downtown Celebration's specialty stores, fabulous restaurants, Starbucks, Ice cream Parlor and Michael Graves designed Post Office. This corner lot mansion is across the street from the Robert Trent Jones Sr and Jr golf course. Oversized 3 car garage and extra parking pad. This home is for the person looking for the best home, on the best lot and the best location. Gourmet kitchen and brick walled pool area with lush gardens.

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Originating MLS: Orlando Regional

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 2
    • Full bathrooms: 5
    • 1/2 bathrooms: 2
    Heating
    • Forced air, Electric
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
    • Laundry: Inside
    Features
    • Ceiling Fans(s), High Ceiling(s), Master Bedroom Downstairs, Stone Counters, Walk-In Closet(s), Crown Molding, Solid Wood Cabinets, Thermostat, Kitchen/Family Room Combo, Window Treatments
    • Flooring: Softwood, Tile, Carpet, Hardwood
    • Windows: Blinds, Window Treatments
    • Basement: None
    • Has fireplace: Yes
    • Fireplace features: Living Room, Other Room
    Interior area
    • Structure area source: Public Records
    • Total interior livable area: 5,124 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Garage - Attached
    Features
    • Levels: Two
    • Patio & porch: Deck, Patio, Porch, Covered, Front Porch
    • Exterior features: Other, Shingle, Stone, Stucco, Wood, Brick
    • Pool features: Gunite, In Ground
    • Has spa: Yes
    • Spa features: In Ground
    • Fencing: Other, Masonry
    • Has view: Yes
    • View description: Park, Water
    • Has water view: Yes
    • Water view: Water
    • Waterfront features: Canal - Freshwater
    • Body of water: CELEBRATION MAIN VILLAGE CANAL
    Lot
    • Size: 0.41 Acres
    • Features: Sidewalk, Street Paved, Corner Lot, Street One Way
    • Residential vegetation: Mature Landscaping, Trees/Landscaped
    Details
    • Parcel number: 072528278300011040
    • Zoning: OPUD

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Historical
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Footing
    • Roof: Shake / Shingle
    Condition
    • Completed
    • Year built: 1997
    Details
    • Builder model: ROSEMOUNT CUSTOM HOME
    • Builder name: Akers Custom Homes

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Electricity Connected, BB/HS Internet Available, Public, Street Lights, Underground Utilities, Cable Connected, Sprinkler Recycled, Sprinkler Meter

    Community & HOA

    Community
    • Security: Security System Owned
    • Subdivision: CELEBRATION
    HOA
    • Has HOA: Yes
    • Amenities included: Playground, Park, Pool, Security, Tennis Court(s), Recreation Facilities, Basketball Court, Golf Course, Trails
    • Services included: Recreational Facilities
    • HOA fee: $162 monthly
    Location
    • Region: Celebration

    Financial & listing details

    • Price per square foot: $512/sqft
    • Tax assessed value: $1,837,900
    • Annual tax amount: $29,042
    • Listing terms: Cash, Conventional
    • Ownership: Fee Simple

    Price history

    DateEventPrice
    12/23/2020Sold$1,950,000-18.4%$381/sqft
    Source: Stellar MLS #O5892684 Report a problem
    11/11/2020Pending sale$2,390,000$466/sqft
    Source: FLORIDA IN MOTION REALTY INC #O5892684 Report a problem
    9/22/2020Listed for sale$2,390,000+31.7%$466/sqft
    Source: FLORIDA IN MOTION REALTY INC #O5892684 Report a problem
    9/24/2008Sold$1,815,000-22.8%$354/sqft
    Source: Public Record Report a problem
    5/18/2006Sold$2,350,000+147.6%$459/sqft
    Source: Public Record Report a problem
    6/24/1997Sold$949,000$185/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$29,042 +6.8%$1,837,900 +2.4%
    2024$27,189 +7.6%$1,794,900 +5.7%
    2023$25,259 +9%$1,698,000 +7.2%
    2022$23,164 +11.8%$1,583,700 +22.3%
    2021$20,710 +3.9%$1,294,800 +5.4%
    2020$19,935 +0.9%$1,228,900 +2.7%
    2019$19,752 $1,196,300 +4%
    2018$19,752 +2.5%$1,150,500 +0.3%
    2017$19,276 -1.9%$1,147,300 -4.2%
    2016$19,649 -4.8%$1,198,100 +5.5%
    2015$20,631 -4.8%$1,135,400 +3.3%
    2014$21,679 $1,098,900 +13.5%
    2013-- $967,900 +3.1%
    2012-- $938,700 +2.5%
    2011-- $915,700 -7.9%
    2010-- $994,700 -21.9%
    2009-- $1,274,000 -31%
    2008-- $1,846,700
    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 (K12)

    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
    $2,623,400
    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
    $2,623,400