Skip main navigation
Off market
Street View
  • $2,606,800

    400 Water St, Celebration, FL 34747

    5beds
    5,124sqft
    Single Family Residence
    Built in 1997
    0.41 Acres Lot
    $2,606,800 Zestimate®
    $509/sqft
    $5,816 Estimated rent

    Home value

    $2,606,800

    $2.32M - $2.95M

    $5,816/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $5,816/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

    $5,816/mo

    Rent Zestimate®

    Refinance and save

    $17,215/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,215/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 off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available 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 & neighborhood

    Security
    • Security features: Security System Owned
    Location
    • Region: Celebration
    • Subdivision: CELEBRATION

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $162 monthly
    • Amenities included: Playground, Park, Pool, Security, Tennis Court(s), Recreation Facilities, Basketball Court, Golf Course, Trails
    • Services included: Recreational Facilities

    Other

    Other facts
    • Additional Parcels YN: 0
    • Additional Rooms: Attic, Inside Utility, Den/Library/Office, Formal Dining Room Separate, Breakfast Room Separate, Interior In-Law Suite
    • Appliances: Dishwasher, Disposal, Electric Water Heater, Range, Refrigerator, Microwave, Washer, Dryer
    • Association Amenities: Playground, Park, Pool, Security, Tennis Court(s), Recreation Facilities, Basketball Court, Golf Course, Trails
    • Association Approval Required YN: 0
    • Association Fee Requirement: Required
    • Attached Garage YN: 1
    • Available For Lease YN: 1
    • Community Features: Deed Restrictions, Playground, Park, Sidewalk, Pool, Fitness, Tennis Courts, Golf, Association Recreation - Owned
    • Country: US
    • Building Area Source: Public Records
    • Disclosures: Seller Property Disclosure, HOA/PUD/Condo Disclosure
    • DPRYN: 1
    • Exist Lse Tenant YN: 0
    • Flood Zone Code: X
    • Flooring: Carpet, Ceramic Tile, Wood
    • Cooling: Zoned
    • Foundation Details: Slab
    • Garage YN: 1
    • Heating: Central, Electric, Zoned
    • Exterior Features: French Doors, Irrigation System, Sidewalk, Fenced, Sliding Doors, Balcony, Sprinkler Metered
    • Fireplace Features: Living Room, Other Room
    • Interior 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
    • Fireplace YN: 1
    • Levels: Two
    • Homestead YN: 0
    • Listing Service: Full Service
    • Listing Terms: Cash, Conventional
    • Lot Features: Sidewalk, Street Paved, Corner Lot, Street One Way
    • Major Change Type: Pending
    • Mls Status: Pending
    • New Construction YN: 0
    • Ownership: Fee Simple
    • Parking Features: Garage Door Opener, Parking Pad, Alley Access
    • Patio And Porch Features: Deck, Patio, Porch, Covered, Front Porch
    • Pets Allowed: Yes
    • Planned Unit Development YN: 1
    • Utilities: Electricity Connected, BB/HS Internet Available, Public, Street Lights, Underground Utilities, Cable Connected, Sprinkler Recycled, Sprinkler Meter
    • Previous Status: Active
    • Property Sub Type: Single Family Residence
    • Property Type: Residential
    • Vegetation: Mature Landscaping, Trees/Landscaped
    • Roof: Shingle
    • Sewer: Public Sewer
    • Syndicate To: Homes.com, HomeSnap, Realtor.com, Zillow/Trulia, International MLS
    • Water Access YN: 0
    • Water Extras YN: 0
    • Water Source: Public
    • Association Fee Frequency: Quarterly
    • Window Features: Blinds, Window Treatments
    • Direction Faces: East
    • Laundry Features: Inside
    • Lease Restrictions YN: 1
    • Num Of Own Years Prior To Lse: 0
    • Association Fee Includes: Recreational Facilities
    • Pool Features: Gunite, In Ground
    • Pool Private YN: 1
    • List Agent AOR: Orlando Regional
    • List AOR: Orlando Regional
    • Security Features: Security System Owned
    • View: Garden, Water, Golf Course
    • Property Condition: Completed
    • Public Survey Range: 28
    • Room Count: 8
    • Water View YN: 1
    • Representation: Seller Represented
    • Spa Features: In Ground
    • Waterfront YN: 1
    • Tax Year: 2019
    • County Or Parish: Osceola
    • Minimum Lease: 1-2 Years
    • Public Survey Section: 07
    • Water View: Canal
    • Zoning: OPUD
    • Year Built: 1997
    • Waterfront Features: Canal - Freshwater
    • MLS Area Major: 34747 - Kissimmee/Celebration
    • Lot Size Dimensions: x
    • Construction Materials: Cement Siding
    • Architectural Style: Historical
    • Complex Community Name NCCB: CELEBRATION
    • Waterfront Feet Total: 12
    • Subdivision Name: CELEBRATION
    • Living Area: 5124.00
    • Building Area Total: 6726.00
    • Model: ROSEMOUNT CUSTOM HOME
    • Water Frontage Feet Canal Fresh: 12
    • Additional Water Information: ''), javascript:__doPostBack('m_rpPageList$ctl14$lbPageLink'
    • Builder Name: Akers Custom Homes
    • Association Name: Celebration Residential Owners Association
    • Fencing: Other, Masonry
    • Total Acreage: 1/2 to less than 1
    • Additional Lease Restrictions: Celebration Town Hall has info at 407-566-1200
    • Association Fee: 487.90
    • Builder Model: ROSEMOUNT CUSTOM HOME
    • Tax Annual Amount: 19752.28
    • Water Body Name: CELEBRATION MAIN VILLAGE CANAL
    • 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

    Public tax history

    YearProperty taxesTax assessment
    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%

    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,606,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
    $2,606,800