$469,900
SOLD JUN 18, 2021
Last list price

818 N Fairoaks Ct Andover, KS 67002

5 Beds
3 Baths
3,646 Sq Ft
0.29 Acres

Recently Sold

$129 Per Sq Ft

1 Day on Market

Highlights

  • Spa
  • Waterfront
  • Clubhouse
  • Sunflower Elementary School Rated A-
  • Community Lake
  • Pond

About This Home

As of July 2025

Welcome to this beautiful lake lot home located on a Cul-de-Sac in Crescent Lakes! Step inside to the warm and inviting living room which features hardwood flooring, gas fireplace, built-ins, and tons of natural light. The kitchen offers a huge island, granite countertops, stainless steel appliances, walk-in pantry, and plenty of cabinet space. Dining nook is located right off the kitchen, perfect for entertaining family and friends. Spacious master bedroom features a lovely bay window and walk-in closets. The master bathroom has two sinks, soaker tub, and a separate walk-in shower. The main floor also offers an office (or bedroom) with French doors, an additional guest bedroom, and a full guest bathroom. Downstairs in the walk-out basement, the large family room features a gas fireplace, a wet bar, and view out windows. Two bedrooms, a bathroom, and a bonus room used as a gym completes the basement. Step outside on the covered deck or covered patio and be greeted by beautiful views of the neighborhood lake, right from your backyard! The Crescent Lakes neighborhood features two swimming pools, 5 fishing lakes, playground, clubhouse, and much more! Don't miss this opportunity to live in this highly desirable neighborhood in Andover - schedule your private showing today!

Last Agent to Sell the Property

Tyson Bean

Pinnacle Realty Group License #00228875 Listed on: 04/29/2021

Last Buyer's Agent

Nancy Shih

RE/MAX Associates License #00232508

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,173

Year Built

  • Built in 2010

Lot Details

  • 0.29 Acre Lot
  • Waterfront
  • Cul-De-Sac
  • Sprinkler System

HOA Fees

  • $31 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Frame Construction
  • Composition Roof

Interior Spaces

  • Wet Bar
  • Wired For Sound
  • Ceiling Fan
  • Multiple Fireplaces
  • Attached Fireplace Door
  • Electric Fireplace
  • Gas Fireplace
  • Window Treatments
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Formal Dining Room
  • Home Office
  • Bonus Room
  • Wood Flooring

Kitchen

  • Breakfast Bar
  • Oven or Range
  • Electric Cooktop
  • Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • 3 Full Bathrooms
  • Granite Bathroom Countertops
  • Dual Vanity Sinks in Primary Bathroom
  • Whirlpool Bathtub
  • Separate Shower in Primary Bathroom

Laundry

  • Laundry Room
  • Laundry on main level
  • 220 Volts In Laundry

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Bedroom in Basement
  • Finished Basement Bathroom
  • Basement Storage

Home Security

  • Home Security System
  • Storm Windows

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Spa
  • Pond
  • Covered Deck
  • Covered patio or porch
  • Rain Gutters

Schools

  • Sunflower Elementary School
  • Andover Central Middle School
  • Andover Central High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas

Listing and Financial Details

  • Assessor Parcel Number 20015-008-304-17-0-40-06-033.00-0

Community Details

Overview

  • Association fees include gen. upkeep for common ar
  • $200 HOA Transfer Fee
  • Crescent Lakes Subdivision
  • Community Lake
  • Greenbelt

Amenities

  • Clubhouse

Recreation

  • Community Playground
  • Community Pool
  • Jogging Path

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,173

Year Built

Built in 2010

Lot Details

0

HOA Fees

$31 per month

Listing Details

  • Class: Residential
  • Property Type: Single Family Onsite Blt
  • Architecture: Ranch
  • Property Condition Report: Yes
  • Estimated Age: 11 - 20 Years
  • Total Specials: 19072.98
  • Year Built: 2010
  • Annual Specials: 1836.74
  • Estimated AGLA: 1944
  • Estimated BFA: 1702
  • Estimated TFLA: 3646
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Range/Oven
  • Fireplace: Two, Living Room, Family Room, Gas, Electric
  • Interior Amenities: Ceiling Fan(s), Closet-Walk-In, Fireplace Doors/Screens, Hardwood Floors, Security System, Wet Bar, Whirlpool, Window Coverings-All, Wired For Surround Sound
  • Total Bedrooms: 5
  • Master Bedroom: Dimensions: 17x13.11, On Level: Main, Flooring: Carpet
  • Master Bedroom Features: Master Bdrm On Main Level, Master Bedroom Bath, Sep. Tub/Shower/Mstr Bdrm, Two Sinks, Granite Counters
  • AG Bedrooms: 3
  • Total Bathrooms: 3
  • AG Full Bathrooms: 2
  • Total Full Baths: 3
  • Basement: Yes - Finished
  • Basement Finished: 3 Bedroom, 1 Bath, Bsmt Rec/Family Room, Bsmt Office, Bsmt Wet Bar, Bsmt Storage, Bsmt Bonus Room
  • Basement Foundation: Full, Walk Out At Grade, View Out
  • Dining Area: Eating Bar, Eating Space In Kitchen, Formal, Kitchen/Dining Combo
  • Kitchen: Dimensions: 13.4x12.5, On Level: Main, Flooring: Wood
  • Kitchen Features: Eating Bar, Island, Pantry, Range Hood, Electric Hookup, Granite Counters
  • Living Room: Dimensions: 16.4x13.5, On Level: Main, Flooring: Wood
  • Room 4: Dining Room, Dimensions: 12.8x10.9, On Level: Main, Flooring: Wood
  • Room 5: Bedroom, Dimensions: 12.5x10.11, On Level: Main, Flooring: Carpet
  • Room 6: Bedroom, Dimensions: 13.2x11.2, On Level: Main, Flooring: Carpet
  • Room 7: Family Room, Dimensions: 36x19, On Level: Basement, Flooring: Carpet
  • Room 8: Bedroom, Dimensions: 13.4x12.5, On Level: Basement, Flooring: Carpet
  • Room 9: Bedroom, Dimensions: 14.7x13.1, On Level: Basement, Flooring: Carpet
  • Room 10: Bedroom, Dimensions: 14.8x12.9, On Level: Basement, Flooring: Carpet
  • Room 11: Storage, Dimensions: 13.3x10.3, On Level: Basement, Flooring: Carpet
  • Levels: One Story

Exterior Features

  • Construction: Frame W/Less Than 50% Mas
  • Exterior Amenities: Covered Patio, Covered Deck, Guttering, Irrigation Pump, Irrigation Well, Sprinkler System, Storm Windows/Ins Glass
  • Roof: Composition

Garage/Parking

  • Garage: Attached, Opener
  • Garage Size: 3

Utilities

  • Cooling: Central, Electric
  • Flood Insurance: Unknown
  • Heating: Forced Air, Gas
  • Laundry: Main Floor, Separate Room, 220-Electric
  • Utilities: Natural Gas, Public Water, Sewer

Condo/Co-op/Association

  • HOA Fees Include: Gen. Upkeep For Common Ar
  • HOA Initiation Fee: 200
  • HOA YN: Yes
  • Annual HOA Fees: 375

Association/Amenities

  • Neighborhood Amenities: Club House, Greenbelt, Jogging Path, Lake/Pond, Playground, Swimming Pool

Schools

  • School District: Andover School District (USD 385)
  • Elementary School: Sunflower
  • Middle School: Andover Central
  • High School: Andover Central
  • Elementary School: Sunflower
  • High School: Andover Central

Lot Info

  • Acreage: City Lot
  • Includes Lot Y/N: Yes
  • Lot Description: Cul-De-Sac, Pond/Lake, Standard, Waterfront W/Access
  • Lot Size Sq Ft: 12750
  • Number Of Acres: 0.29
  • Geo ADDRESS Line: 818 N Fairoaks Ct
  • Geo PRIMARY City: Andover
  • Geo Quality: 0.95
  • Geo Subdivision: KS
  • Geo Update: 04/30/2021
  • Geo Zoom Level: 16

Tax Info

  • General Property Taxes: 8172.78
  • Assessor Parcel Number: 20015-008-304-17-0-40-06-033.00-0
  • General Tax Year: 2020

MLS Schools

  • Middle School: Andover Central
  • School District: Andover School District (USD 385)

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 29, 2021
Closed on
Jun 14, 2021
Sold by
Yagnik Priyank J and Desai Pooja H
Bought by
Mi Danya
Seller's Agent
Tyson Bean
Pinnacle Realty Group
Buyer's Agent
Nancy Shih
RE/MAX Associates
List Price
$469,900

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.03%
Original Mortgage
$339,000
Outstanding Balance
$308,256
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$175,730

Purchase Details

Closed on
Dec 22, 2009
Sold by
Crescent Lake Developments
Bought by
Homebuilders Homebuilders and Homebuilders H
Source: Public Records

Similar Homes in the area

  • 826 N Speyside Cir, Andover, KS 67002

    $499,520

    • 3 Beds
    • 2.5 Baths
    • 2,029 Sq Ft
    • 826 N Speyside Cir
    • Andover, KS

    The Hogan is a contemporary and roomy 3-bedroom zero entry patio home. It features a spacious great room with large windows that offer ample natural light. The kitchen boasts a generous-sized island that can comfortably seat four adults. It offers a full-service kitchen amenities, allowing for convenient meal preparation and entertaining. One of the highlights of the Hogan is the zero-entry

    Denise Gray Berkshire Hathaway PenFed Realty

    Section Image
  • 201 S Bordeulac St, Wichita, KS 67230

    $359,000

    • 3 Beds
    • 3 Baths
    • 2,397 Sq Ft
    • 201 S Bordeulac St
    • Wichita, KS

    Don’t miss your chance to own this stunning custom home, ideally located in the highly desirable Andover area while benefiting from Sedgwick County taxes. From the moment you step inside, you’ll be welcomed by an elegant formal dining space complete with a built-in buffet—perfect for entertaining. The kitchen is a true showpiece, featuring custom cabinetry, granite countertops, a stylish tile

    Kirk Short Keller Williams Signature Partners, LLC

    Section Image
  • 704 W Cornerstone Ct, Andover, KS 67002

    $399,900

    • 3 Beds
    • 2 Baths
    • 1,808 Sq Ft
    • 704 W Cornerstone Ct
    • Andover, KS

    Tucked away on a quiet cul-de-sac in the Andover School District with no special taxes, this beautiful, light-filled home offers comfort, style, and room to grow. The main living area features high ceilings, a gas fireplace, and abundant natural light. A formal dining space complements the open layout and is perfect for entertaining. The kitchen is equipped with hardwood floors, granite

    HEATHER STEWART Coldwell Banker Plaza Real Estate

    Section Image
  • 2246 S Nicole Cir, Andover, KS 67002

    $499,000

    • 5 Beds
    • 3 Baths
    • 3,039 Sq Ft
    • 2246 S Nicole Cir
    • Andover, KS

    Stunning 5-Bedroom Home in Sought-After Tuscany – No HOA Fees! Welcome to this beautifully designed 5-bedroom, 3-bathroom home nestled in the desirable Tuscany Phase 3 neighborhood of Andover, KS. With no HOA fees and the peace of mind of neighborhood Covenants & Restrictions, this property offers the perfect balance of freedom and community standards. Situated on two spacious lots, this home

    Kirk Short Keller Williams Signature Partners, LLC

    Section Image
  • 821 N Woodstone Dr, Andover, KS 67002

    $525,000

    • 6 Beds
    • 3 Baths
    • 3,354 Sq Ft
    • 821 N Woodstone Dr
    • Andover, KS

    Welcome to this stunning former model, one-owner ranch-style home nestled on a serene waterfront lot in Crescent Lakes, and in the sought-after Andover School District. Boasting 5 spacious bedrooms plus a flexible 6th bedroom or home office or media room, this residence combines timeless European-inspired decor with modern comfort. Upgrades galore from plumbing to light fixtures, to unique and

    Kathy Rosell Reece Nichols South Central Kansas

    Section Image
  • 524 E Crescent Lakes Dr, Andover, KS 67002

    $459,900

    • 5 Beds
    • 3 Baths
    • 3,190 Sq Ft
    • 524 E Crescent Lakes Dr
    • Andover, KS

    Move right into one of the most unique homes in Crescent Lakes. This house was the original model home in Phase 4. LVP recently installed through out the whole living space upstairs & downstairs. New roof from 2021. This home is so pristine one could eat right off the floor. Backyard is huge & fully fenced. Too many great features to list. Come see for yourself.

    Erik Weiss Berkshire Hathaway PenFed Realty

    Section Image
  • 620 N Somerset Ct, Andover, KS 67002

    $400,000

    • 5 Beds
    • 3 Baths
    • 3,085 Sq Ft
    • 620 N Somerset Ct
    • Andover, KS

    Welcome home to 620 N. Somerset Ct. located in the sought after Crescent Lakes Welcome to 620 N. Somerset Ct., a beautifully maintained ranch nestled in the highly sought-after Crescent Lakes community—just a short walk to Andover Central schools! From the moment you step inside, you'll be welcomed by an inviting living room filled with natural light, complete with large windows, a ceiling fan, a

    Cindy Carnahan Reece Nichols South Central Kansas

    Section Image
  • 1013 E Rosemont Ct, Andover, KS 67002

    $499,000

    • 5 Beds
    • 3 Baths
    • 3,200 Sq Ft
    • 1013 E Rosemont Ct
    • Andover, KS

    Andover Central Schools are within walking distance in this freshly painted and move in ready 5 bedroom ranch style home in beautiful Estates at Crescent Lakes! Attention to detail is apparent throughout including granite countertops, gorgeous hardwood floors, stacked stone fireplace, instant hot water attached to the water heater, gas cooktop, irrigation well and more. The expansive open

    Kathy Rosell Reece Nichols South Central Kansas

    Section Image
  • 1009 E Rosemont Ct, Andover, KS 67002

    $499,000

    • 5 Beds
    • 3 Baths
    • 3,120 Sq Ft
    • 1009 E Rosemont Ct
    • Andover, KS

    SHE IS REFRESHING. SHE IS WELL CARED FOR. SHE IS OH, SO WELCOMING. MEET, “ROSE” - YOUR NEXT ADDRESS HERE ON ROSEMONT CT in CRESCENT LAKES! Arrive and you are welcomed by the lush lawn, perfectly placed landscaping and striking brick and stone facade giving you classic curb appeal. Whether retuning home or welcoming guests, you are greeted by a refined entryway and inviting floor plan. The living

    Keely Hillard Keller Williams Signature Partners, LLC

    Section Image

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- Security 1St Title Llc
Warranty Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $339,000 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/24/2025 07/24/25 Sold -- -- --
06/24/2025 06/24/25 Pending -- -- --
06/19/2025 06/19/25 For Sale $548,800 +16.8% $151 / Sq Ft
06/18/2021 06/18/21 Sold -- -- --
04/30/2021 04/30/21 Pending -- -- --
04/29/2021 04/29/21 For Sale $469,900 +4.4% $129 / Sq Ft
06/25/2015 06/25/15 Sold -- -- --
05/04/2015 05/04/15 Pending -- -- --
04/06/2015 04/06/15 For Sale $449,900 -- $132 / Sq Ft
Source: South Central Kansas MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $112 $62,744 $6,202 $56,542
2024 $112 $61,564 $6,202 $55,362
2023 $10,926 $59,771 $6,202 $53,569
2022 $10,871 $55,225 $6,202 $49,023
2021 $8,249 $51,658 $6,202 $45,456
2020 $10,010 $50,221 $6,202 $44,019
2019 $10,095 $50,221 $6,202 $44,019
2018 $9,807 $48,769 $6,202 $42,567
2017 $9,940 $49,537 $6,202 $43,335
2014 -- $396,300 $50,180 $346,120
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: South Central Kansas MLS

MLS Number: 595428

South Central Kansas MLS

APN: 304-17-0-40-06-033-00-0