Skip main navigation
Off market
  • $672,800

    174 Longview Ave, Celebration, FL 34747

    4beds
    1,924sqft
    Single Family Residence
    Built in 1998
    3,571 Square Feet Lot
    $672,800 Zestimate®
    $350/sqft
    $3,396 Estimated rent

    Home value

    $672,800

    $639,000 - $713,000

    $3,396/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,396/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

    $3,396/mo

    Rent Zestimate®

    Refinance and save

    $4,492/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

    $4,492/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

    BACK ON THE MARKET, buyer's financing fell through. This completely renovated Celebrtion home is move-in ready! The ROOF and AC were replaced in 2015. The kitchen has been updated with unique GRANITE COUNTERTOPS, NEW CABINETS, NEW TILE BACKSPLASH, STAINLESS STEEL APPLIANCES, stylish PENDANT LIGHTING, and an island with space for seating. The home also features NEW SUPER-EFFICIENT foam INSULATION and a TANKLESS WATER HEATER. The first story flooring has been replaced with TRAVERTINE STONE FLOORS. Gorgeous, oversized windows in the living room offer a lovely view of the fenced backyard. The attached garage has it's own AC. Upstairs, the master bath has been updated with GRANITE COUNTERTOPS, a GLASS TILE ACCENT WALL, DUAL SINKS, NEW VANITY, newly updated/tiled shower, and a WALK IN closet. The second upstairs bath has also been upgraded with matching GRANITE and all new fixtures. The oversized, covered front porch is the perfect outdoor space in which to enjoy the beauty of Celebration. Parks, swimming pools, and nature trails, are located a short distance away, and this home is located just north of the popular town center with shopping, dining, hotels, and community events. Walt Disney World theme parks and resorts are a few minutes away. Tour this beautiful home today!

    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: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Other, Electric
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Garbage disposal, Microwave, Range / Oven, Washer
    Features
    • Ceiling Fans(s), Eating Space In Kitchen, High Ceiling(s), Kitchen/Family Room Combo, Built in Features
    • Flooring: Tile, Carpet
    Interior area
    • Structure area source: Public Records
    • Total interior livable area: 1,924 sqft

    Property

    Parking
    • Total spaces: 1
    • Parking features: Garage - Attached
    Features
    • Levels: Two
    • Patio & porch: Patio, Front Porch
    • Exterior features: Vinyl, Cement / Concrete
    • Fencing: Vinyl
    Lot
    • Size: 3,571 sqft
    • Dimensions: 48x75
    • Features: Level/Flat, Sidewalk, Street Paved
    • Residential vegetation: Mature Landscaping
    Details
    • Parcel number: 072528280700011110
    • Zoning: OPUD

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Footing
    • Roof: Asphalt
    Condition
    • Year built: 1998

    Utilities & green energy

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

    Community & neighborhood

    Location
    • Region: Celebration
    • Subdivision: CELEBRATION NORTH VILLAGE UNIT 05

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $79 monthly
    • Amenities included: Playground, Fitness Center, Park, Pool, Tennis Court(s), Recreation Facilities, Trails

    Other

    Other facts
    • Additional Parcels YN: 0
    • Appliances: Dishwasher, Disposal, Electric Water Heater, Range, Microwave, Washer, Dryer
    • Association Amenities: Playground, Fitness Center, Park, Pool, Tennis Court(s), Recreation Facilities, Trails
    • Association Approval Required YN: 0
    • Association Fee Requirement: Required
    • Attached Garage YN: 1
    • Additional Rooms: Family Room
    • Available For Lease YN: 1
    • Community Features: Deed Restrictions, Playground, Park, Sidewalk, Pool, Fitness, Tennis Courts, Irrigation-Reclaimed Water
    • Cooling: Central Air
    • Country: US
    • Building Area Source: Public Records
    • DPRYN: 1
    • Exist Lse Tenant YN: 0
    • Fireplace YN: 0
    • Flood Zone Code: X
    • Flooring: Carpet, Ceramic Tile, Travertine
    • Foundation Details: Slab
    • Garage YN: 1
    • Heating: Electric
    • Homestead YN: 1
    • Exterior Features: Sidewalk, Fenced, Sprinkler Metered
    • Interior Features: Ceiling Fans(s), Eating Space In Kitchen, High Ceiling(s), Kitchen/Family Room Combo, Built in Features
    • Levels: Two
    • Listing Service: Full Service
    • Listing Terms: Cash, Conventional
    • Lot Features: Level/Flat, Sidewalk, Street Paved
    • Major Change Type: Pending
    • Mls Status: Pending
    • New Construction YN: 0
    • Ownership: Fee Simple
    • Parking Features: Garage Door Opener, On Street, Driveway
    • Patio And Porch Features: Patio, Front Porch
    • Stories Total: 2
    • Pool Private YN: 0
    • Utilities: Electricity Connected, Phone Available, Sewer Connected, BB/HS Internet Available, Cable Available, Street Lights, Underground Utilities, Sprinkler Recycled, Sprinkler Meter, Water Connected
    • Previous Status: Active
    • Property Sub Type: Single Family Residence
    • Property Type: Residential
    • Vegetation: Mature Landscaping
    • Roof: Shingle
    • Sewer: Public Sewer
    • Syndicate To: Homes.com, HomeSnap, Realtor.com, Zillow/Trulia, International MLS
    • Water Access YN: 0
    • Water Extras YN: 0
    • Waterfront Feet Total: 0
    • Waterfront YN: 0
    • Water Source: Public
    • Water View YN: 0
    • Association Fee Frequency: Quarterly
    • Lease Restrictions YN: 1
    • Num Of Own Years Prior To Lse: 0
    • List Agent AOR: Orlando Regional
    • List AOR: Orlando Regional
    • Zoning Compatible YN: 1
    • Tax Year: 2019
    • County Or Parish: Osceola
    • Room Count: 7
    • Year Built: 1998
    • Minimum Lease: 1-2 Years
    • Pets Allowed: No
    • Public Survey Section: 7
    • Architectural Style: Colonial
    • Garage Dimensions: 10x20
    • Zoning: OPUD
    • Direction Faces: Northwest
    • MLS Area Major: 34747 - Kissimmee/Celebration
    • Construction Materials: Cement Siding
    • Association Fee: 239.00
    • Building Area Total: 2321.00
    • Living Area: 1924.00
    • Lot Size Dimensions: 48x75
    • Subdivision Name: CELEBRATION NORTH VILLAGE UNIT 05
    • Public Survey Range: 28E
    • Association Name: Celebration Town Hall
    • Fencing: Vinyl
    • Additional Lease Restrictions: see association for details and restrictions
    • Total Acreage: 0 to less than 1/4
    • Tax Annual Amount: 4137.43
    • Listing terms: Cash, Conventional
    • Ownership: Fee Simple

    Price history

    DateEventPrice
    2/19/2025Listing removed$735,000$382/sqft
    Source: Stellar MLS #O6241126 Report a problem
    10/4/2024Price change$735,000-0.7%$382/sqft
    Source: Stellar MLS #O6241126 Report a problem
    9/12/2024Listed for sale$739,900-0.7%$385/sqft
    Source: Stellar MLS #O6241126 Report a problem
    7/11/2024Listing removed$745,000$387/sqft
    Source: Stellar MLS #O6201110 Report a problem
    6/13/2024Pending sale$745,000$387/sqft
    Source: Stellar MLS #O6201110 Report a problem
    5/2/2024Listed for sale$745,000-2%$387/sqft
    Source: Stellar MLS #O6201110 Report a problem
    4/25/2024Listing removed--
    Source: Stellar MLS #O6174351 Report a problem
    2/29/2024Price change$759,900-1.9%$395/sqft
    Source: Stellar MLS #O6174351 Report a problem
    1/30/2024Listed for sale$775,000+11.1%$403/sqft
    Source: Stellar MLS #O6174351 Report a problem
    4/28/2023Sold$697,500-3.8%$363/sqft
    Source: Public Record Report a problem
    3/22/2023Pending sale$725,000$377/sqft
    Source: Stellar MLS #O6095540 Report a problem
    3/10/2023Listed for sale$725,000+54.6%$377/sqft
    Source: Stellar MLS #O6095540 Report a problem
    3/15/2021Sold$469,000$244/sqft
    Source: Public Record Report a problem
    2/2/2021Pending sale$469,000$244/sqft
    Source: Stellar MLS #O5893391 Report a problem
    1/11/2021Listed for sale$469,000$244/sqft
    Source: Stellar MLS #O5893391 Report a problem
    10/6/2020Pending sale$469,000$244/sqft
    Source: ZIRO REALTY #O5893391 Report a problem
    9/19/2020Listed for sale$469,000+9.1%$244/sqft
    Source: ZIRO REALTY #O5893391 Report a problem
    1/11/2017Listing removed$430,000$223/sqft
    Source: Keller Williams - Oviedo #O5467382 Report a problem
    9/30/2016Price change$430,000-2.3%$223/sqft
    Source: Keller Williams - Oviedo #O5467382 Report a problem
    9/23/2016Listed for sale$440,000+14.3%$229/sqft
    Source: KELLER WILLIAMS ADVANTAGE RLTY #O5467382 Report a problem
    9/3/2015Sold$385,000-1.3%$200/sqft
    Source: Stellar MLS #S4811357 Report a problem
    7/7/2015Price change$389,900-1.3%$203/sqft
    Source: Better Homes and Gardens Real Estate Fine Living #S4811357 Report a problem
    6/12/2015Price change$394,900-1%$205/sqft
    Source: Better Homes and Gardens Real Estate Fine Living #S4811357 Report a problem
    4/21/2015Listed for sale$399,000+36.2%$207/sqft
    Source: Better Homes and Gardens Real Estate Fine Living #S4811357 Report a problem
    6/11/2014Sold$293,000+48.1%$152/sqft
    Source: Public Record Report a problem
    2/25/1999Sold$197,900$103/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$7,339 +5.3%$512,500 +4.2%
    2024$6,973 +31.2%$492,000 +8.5%
    2023$5,315 +3%$453,400 +21%
    2022$5,160 +23%$374,800 +18.8%
    2021$4,196 +0.5%$315,400 +6.6%
    2020$4,175 +0.9%$295,900 +5%
    2019$4,137 $281,900 +1.9%
    2018$4,137 +1.1%$276,559 +2.1%
    2017$4,093 -2%$270,871 +2.1%
    2016$4,175 -6.7%$265,300 -3.1%
    2015$4,475 +16.1%$273,800 +23.5%
    2014$3,855 $221,681 +1.5%
    2013-- $218,405 +1.7%
    2012-- $214,755 +3%
    2011-- $208,500 -4.2%
    2010-- $217,700 -14.5%
    2009-- $254,700 -19.2%
    2008-- $315,200

    Find assessor info on the county website

    Neighborhood: North 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
    $672,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
    $672,800