512 WATER STREET, #512
Celebration, FL 34747
$375,000
Perfectly positioned in the heart of Celebration’s Main Village, this beautifully updated 2-bedroom, 2-bath second-floor end-unit condo offers the ideal blend of style, comfort, and convenience. Renovated in 2022 with over $65,000 in thoughtful improvements, this penthouse-style residence lives large thanks to soaring vaulted ceilings, an airy open-concept living and dining space, and abundant natural light streaming through double-pane windows. The stunning kitchen is open to the main living area and features stainless steel appliances, a smooth-top range, stone backsplash, upgraded cabinetry, and modern finishes that make everyday living and entertaining effortless.
Enjoy your morning coffee or evening glass of wine from the private balcony overlooking Mulberry Avenue, with lovely views of picturesque Savannah Square and the scenic canal along Celebration’s Esplanade—leading you directly to Downtown Celebration just one block away. Both bathrooms were fully renovated with comfort-height vanities and toilets, with a tub/shower combination in the guest bath and a spacious walk-in shower in the primary suite. Additional highlights include crown molding, LED lighting throughout, blinds on every window with automatic upper blinds, newer LG washer and dryer, a convenient storage closet adjacent to the front door, concierge trash service, and two parking decals for easy resident parking.
This meticulously maintained building also received a fresh exterior paint update and new roof in 2025, adding long-term value and peace of mind. Residents of Celebration enjoy a one-of-a-kind small-town atmosphere with lakeside dining, boutiques, coffee shops, community events, a Sunday farmers market, ...
+ Read More
Listing Courtesy of: IMAGINATION REALTY, INC
321-939-1300
Buyer Represented by: IMAGINATION REALTY, INC
| Listing Id: | S5148526 |
|---|---|
| List Price: | $385,000 |
| Close Price: | $375,000 |
| Close Date: | 2026-06-02 |
| Property Type: | Residential |
| Property Sub Type: | Condominium |
| Status: | Closed |
| Bedrooms Total: | 2 |
| Bathrooms Full: | 2 |
| Living Area: | 1,214 |
| Condo Fees: | 565.0 |
| Tax Annual Amount: | $4,877 |
| Lot Size Square Feet: | 435 |
| Lot Size Acres: | 0.01 |
| Architectural Style: | Historic, Traditional |
| Waterfront?: | No |
| City: | Celebration |
| County Or Parish: | Osceola |
| Subdivision Name: | Water Street Condo Ph 04 |
| Postal Code: | 34747 |
| Year Built: | 1998 |
| Appliances: | Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer |
| Association Amenities: | Fitness Center, Vehicle Restrictions |
| Association Fee: | $357 |
| Association Fee Frequency: | Quarterly |
| Association Fee Includes: | Escrow Reserves Fund, Insurance, Maintenance Structure, Maintenance Grounds, Pest Control, Trash |
| Bathrooms Total Integer: | 2 |
| Building Area Source: | Public Records |
| Building Area Total: | 1232 |
| Building Area Units: | Square Feet |
| Direction Faces: | Southeast |
| Foundation Details: | Slab |
| Construction Materials: | Stucco, Frame |
| Cooling: | Central Air |
| Directions: | I-4 to US 192 (Exit 64 toward Kissimmee), Right onto Celebration Ave. turn Right on Waterstreet, take next Left over the bridge on Mulberry, Unit is on the Left (second floor). |
| Elementary School: | Celebration K-8 |
| Exterior Features: | Balcony, Rain Gutters, Storage |
| Flooring: | Carpet, Ceramic Tile |
| Furnished: | Unfurnished |
| Community Features: | Association Recreation - Owned, Deed Restrictions, Dog Park, Fitness Center, Irrigation-Reclaimed Water, Park, Playground, Pool, Special Community Restrictions, Tennis Court(s), Street Lights |
| Heating: | Central, Electric, Heat Pump |
| High School: | Celebration High |
| Interior Features: | Cathedral Ceiling(s), Ceiling Fans(s), Crown Molding, High Ceilings, Open Floorplan, Walk-In Closet(s), Window Treatments |
| Laundry Features: | Inside, Laundry Closet |
| Levels: | One |
| Ownership: | Fee Simple |
| Living Area Source: | Public Records |
| Living Area Units: | Square Feet |
| Lot Features: | Corner Lot, Level, Sidewalk, Paved, Unincorporated |
| Lot Size Acres: | 0.01 |
| Middle Or Junior School: | Celebration K-8 |
| MLS Area Major: | 34747 - Kissimmee/Celebration |
| MLS Area Major: | 34747 - Kissimmee/Celebration |
| Other Structures: | Storage |
| Original List Price: | $385,000 |
| Other Equipment: | Irrigation Equipment |
| Parcel Number: | 07-25-28-5423-0001-5120 |
| Parking Features: | None, On Street, Open |
| Pets Allowed: | Yes |
| Stories Total: | 1 |
| Township: | 25 |
| Road Surface Type: | Asphalt, Paved |
| Roof: | Built-Up |
| Listing Terms: | Cash, Conventional |
| Tax Year: | 2025 |
| Security Features: | Fire Sprinkler System, Security System Owned, Smoke Detector(s) |
| Sewer: | Public Sewer |
| Special Listing Conditions: | None |
| Water Body Name: | WATER STREET CANAL |
| State Or Province: | FL |
| Association?: | Yes |
| Builder Model: | B-3 |
| Utilities: | BB/HS Internet Available, Cable Available, Electricity Connected, Fiber Optics, Sewer Connected, Underground Utilities, Water Connected |
| Green Water Conservation: | Irrigation-Reclaimed Water |
| Water Source: | Public |
| Property Condition: | Completed |
| Public Survey Range: | 28 |
| Public Survey Section: | 7 |
| Zoning: | OPUD |
| Possession: | Close Of Escrow |
| Tax Other Annual Assessment Amount: | 440 |
| Vegetation: | Mature Landscaping, Trees/Landscaped |
| Window Features: | Blinds, Thermal Windows, Window Treatments |
| Additional Lease Restrictions: | NO SHORT TERM RENTALS. Buyer to verify condominium restrictions. |
| Additional Rooms: | Inside Utility |
| Approval Process: | N/A |
| Association Approval Required Yn: | No |
| Association Email: | dmedina@LelandManagement.com |
| Association Fee Requirement: | Required |
| Available For Lease Yn: | Yes |
| Backups Requested Yn: | No |
| Building Area Total Srch Sq M: | 114.46 |
| Building Elevator Yn: | No |
| Building Name Number: | FARMINGTON / 6 |
| Calculated List Price By Calcula: | 317.13 |
| Cddyn: | Yes |
| Condo Fees Term: | Monthly |
| Condo Land Included Yn: | No |
| Dprurl: | https://www.workforce-resource.com/dpr/listing/MFRMLS/S5148526?w=Agent&skip_sso=true |
| Dprurl 2: | https://www.workforce-resource.com/dpr/listing/MFRMLS/S5148526?w=Customer |
| Dpryn: | Yes |
| Exist Lse Tenant Yn: | No |
| Flood Zone Code: | X |
| Flood Zone Date: | 2013-06-18 |
| Flood Zone Panel: | 12097C0035G |
| Floor Number: | 2 |
| Green Verification Count: | 0 |
| Homestead Yn: | No |
| Lease Restrictions Yn: | Yes |
| Listing Exclusion Yn: | No |
| Living Area Meters: | 112.78 |
| Lot Size Square Meters: | 40 |
| Max Pet Weight: | 999 |
| Minimum Lease: | 1-2 Years |
| Monthly Condo Fee Amount: | $565 |
| Monthly Hoa Amount: | $119 |
| Number Of Pets: | 2 |
| Num Of Own Years Prior To Lse: | 0 |
| Num Times per Year: | 1 |
| Pet Restrictions: | Buyers to verify with condo rules and regulations. |
| Pet Size: | Extra Large (101+ Lbs.) |
| Planned Unit Development Yn: | Yes |
| Property Description: | End Unit, Penthouse |
| Realtor Info: | Floor Plan Available, No Sign |
| Room Count: | 4 |
| Sdeo yn: | No |
| Total Acreage: | 0 to less than 1/4 |
| Total Annual Fees: | $8,209 |
| Total Monthly Fees: | $684 |
| Unit Number Yn: | No |
| Water Access Yn: | No |
| Water Extras Yn: | No |
| Water View: | No |
| Yrs Of Owner Prior To Leasing Re: | 0 |
| Zoning Compatible Yn: | Yes |
| Road Responsibility: | Public Maintained Road |
| Association Name: | CROA /Daniel Medina |
| Association Phone: | 321-939-2021 |
| Association 2 Yn: | 0 |
| Attribution Contact: | 321-939-1300 |
| Originating System Name : | Stellar MLS |
| Community Association Water Features: | Lake |
| In Law Suite Yn: | No |
| Green Energy Generation Yn: | No |
| Listing Contract Date: | 2026-04-27 |
Mortgage Calculator
Listing Agent
Copyright 2026 My Florida Regional MLS DBA Stellar MLS. All rights reserved. Information deemed reliable but is not guaranteed. The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of My Florida Regional MLS DBA Stellar MLS. Real estate listings held by brokerage firms other than the owner of this page include the name of the listing broker. Information provided is for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This site will be monitored for 'scraping' and any use of search facilities of data on the site other than by a consumer looking to purchase real estate is prohibited. Listing broker has attempted to offer accurate data, but buyers are advised to confirm all items. Information last updated on October 21, 2026 12:22 AM - ET
Based on information submitted to the MLS GRID as of October 21, 2026 12:22 AM - ET. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. Some listings have been excluded from this website.
IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time.
Property Last Updated: October 21, 2026 12:22 AM - ET
