NOT LISTED FOR SALE

6154 W Longview Dr Unit 44 East Lansing, MI 48823

Estimated Value: $524,431 - $591,000

4 Beds
3.5 Baths
3,633 Sq Ft
$156/Sq Ft Est. Value

Last Sold July 30, 2021

Last sale price $434,900 $120 Per Sq Ft

Est. 30% increase in value since last sale

Current estimated payment $3,388/month

3 Days on Market

Highlights

  • Deck
  • Cathedral Ceiling
  • Whirlpool Bathtub
  • MacDonald Middle School Rated A-
  • Main Floor Primary Bedroom
  • 2 Fireplaces

About This Home

As of July 2021

Fabulous stand-alone condo in mint condition! Unique condominium development with only $235.00 monthly association fee that included lawn care, mulching, trash pickup, and sprinkler maintenance. Gleaming hardwood floors! Spacious foyer entry. Library with a bay window and built-ins. Stunning great room offering soaring ceilings, a beautiful marble fireplace, plus floor to ceiling windows. Adjoining formal dining with a French slider to the huge maintenance free wrap around deck and private yard. The spacious kitchen offers granite counters, stainless steel appliances, an informal breakfast nook, and includes deck access! Lovely main floor primary suite offering a large private bath, glass shower, whirlpool tub, loads of closet space, and access to the four-season room with loads of Eastern & Southern sunlight. Two additional generous bedrooms upstairs off a winding staircase with walk-in closets and another full bath. Finished lower level featuring a second masonry fireplace with a gas log, built-in bookshelves, possible 4th bedroom, full bath, and loads of storage. Convenient 1st floor laundry. Built in storage and service door off the oversized 2-car garage. New furnace Nov. 2019. Custom epoxy coated garage floor. Great opportunity! See attached extra list. Close to Costco, MSU, eateries, and highway access.

Last Listed By

Lynne VanDeventer

Coldwell Banker Professionals -Okemos License #6501128440 Listed on: 06/16/2021

Coldwell Banker Professionals -Okemos

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1995

Lot Details

  • Property fronts a private road
  • Front Yard Sprinklers

HOA Fees

  • $235 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Front Facing Garage

Home Design

  • Brick Exterior Construction
  • Shingle Roof

Interior Spaces

  • 2-Story Property
  • Cathedral Ceiling
  • 2 Fireplaces
  • Gas Fireplace
  • Great Room
  • Family Room
  • Living Room
  • Formal Dining Room
  • Sun or Florida Room

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Whirlpool Bathtub

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Bedroom in Basement
  • Basement Window Egress

Outdoor Features

  • Deck

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Underground Utilities
  • Gas Water Heater
  • Cable TV Available

Community Details

Overview

  • The Greens At Walnut Hills Association
  • Greens At Walnut Hills Subdivision

Recreation

  • Snow Removal

Home Details

Home Type

Single Family

Year Built

Built in 1995

Lot Details

0

HOA Fees

$235 per month

Parking

2

Listing Details

  • Property Sub Type: Single Family Residence
  • Dining Room Level: First
  • Living Room Level: First
  • Tax Year: 2020
  • Levels: Two
  • Parking Features Garage Spaces: 2.0
  • Year Built: 1995
  • Lot Size: Irregular
  • Subdivision Name: Greens at Walnut Hills
  • Above Grade Finished Sq Ft: 2733.0
  • Architectural Style: Site Condo
  • Living Area: 3633.0
  • General Property Info:Lot Size Dimensions: Irregular
  • General Property Info:Above Grade Finished Area: 2733.0
  • General Property Info:Total Livable Area: 3633.0
  • Baths:_pound_Full Baths 2: 1
  • Baths:_pound_Full Baths 1: 1
  • Baths:_pound_Full Baths B: 1
  • Baths:_pound_Half Baths 1: 1
  • Rooms:Dining Room2: Yes
  • Rooms:Living Room2: Yes
  • Primary Bedroom Level: First
  • Laundry Features:Main Level: Yes
  • Levels:Two2: Yes
  • Appliances Dryer: Yes
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Rooms:Family Room2: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities:Water Connected: Yes
  • Roof:Shingle: Yes
  • Cooling:Central Air: Yes
  • Improvements:Formal Dining Room: Yes
  • Improvements:Great Room: Yes
  • Improvements:Whirlpool Bathtub: Yes
  • Exterior:Brick: Yes
  • Percent Basement Finished: Yes
  • Architectural Style:Site Condo: Yes
  • Utilities:Cable Connected: Yes
  • Road Frontage Type:Private Road: Yes
  • Improvements:_four_ Season Room: Yes
  • Utilities:Underground Utilities: Yes
  • General Property Info:Building Area Total SqFt: 4653.0
  • Special Features: None

Interior Features

  • Basement: Egress Windows, Finished, Full
  • Heating: Forced Air, Natural Gas
  • Interior Amenities: Cathedral Ceiling(s), Pantry, Whirlpool Bathtub
  • Total Bedrooms: 4
  • Room: 10
  • Property Type: Residential
  • Bedroom 3 Level: Second
  • Bedroom 4 Level: Basement
  • Family Room Level: Basement
  • Other Level: First
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Below Grade Sq Ft: 900.0
  • Fireplace Features: Gas
  • Fireplaces: 2
  • Fireplace: Yes
  • Appliances:Gas Water Heater: Yes
  • Full Basement: Yes
  • Community Features:Sidewalks: Yes
  • Appliances Range: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Pantry: Yes
  • Appliances:Humidifier: Yes
  • Fireplace Features:Gas3: Yes
  • Basement:Egress Windows: Yes
  • Community Features:Street Lights: Yes

Exterior Features

  • Roof: Shingle
  • Lot Features: Sprinklers In Front
  • RoadFrontageType: Private Road
  • RoadSurfaceType: Paved
  • Patio And Porch Features: Deck
  • Home Warranty: No
  • Construction Type: Brick, Rough Sawn
  • Patio Porch Features:Deck: Yes
  • Lot Features:Sprinklers In Front: Yes

Garage/Parking

  • Parking Features: Concrete Driveway, Finished, Garage Faces Front
  • Attached Garage: No
  • Garage Spaces: 2.0
  • Parking Features:Garage Faces Front: Yes
  • Parking Features:Finished2: Yes
  • Parking Features:Concrete Driveway: Yes

Utilities

  • Sewer: Public Sewer
  • Appliances: Disposal, Gas Water Heater, Microwave, Washer, Refrigerator, Range, Humidifier, Dryer, Dishwasher
  • Cooling: Central Air
  • LaundryFeatures: Main Level
  • Utilities: Water Connected, Underground Utilities, Natural Gas Available, Cable Connected
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association Fee: 235.0
  • Association Fee Frequency: Monthly
  • Association Name: The Greens at Walnut Hills
  • Community Features: Sidewalks, Street Lights
  • Association Amenities: Trash, Snow Removal, Insurance, Landscaping
  • Association: Yes

Association/Amenities

  • Location Legal Info:Association Fee: 235.0
  • Location Legal Info:Association Name: The Greens at Walnut Hills
  • Location Legal Info:Association Fee Frequency: Monthly
  • Association Amenities:Landscaping: Yes
  • Association Amenities:Snow Removal2: Yes
  • Association Amenities:Trash: Yes
  • Association Amenities:Insurance: Yes

Schools

  • Junior High Dist: East Lansing

Tax Info

  • Tax Carrier Route: 9739
  • Tax Annual Amount: 11353.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 16, 2021
Closed on
Jul 30, 2021
Sold by
Bartow James M and James M Bartow Trust
Bought by
Jin Qingxu
Seller's Agent
Lynne VanDeventer
Coldwell Banker Professionals -Okemos
Buyer's Agent
Missy Lord
RE/MAX Real Estate Professionals Dewitt
List Price
$434,900
Sold Price
$434,900
Total Days on Market
3
Current Estimated Value
$565,108

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$130,208
Avg. Annual Appreciation
7.12%
Original Mortgage
$173,960
Outstanding Balance
$136,576
Interest Rate
2.2%
Mortgage Type
New Conventional
Estimated Equity
$428,532

Purchase Details

Closed on
Jul 11, 2011
Sold by
Bartow James M
Bought by
Bartow James M

Purchase Details

Closed on
Mar 30, 2007
Sold by
Hodowaine Vera M
Bought by
Bartow James M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$316,000
Interest Rate
6.25%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 23, 1994
Bought by
Hodowaine Vera M

Purchase Details

Closed on
Dec 22, 1994
Sold by
Highlands At Walnut Hills
Bought by
Cawood Building Co

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

Similar Homes in East Lansing, MI

  • 8471 Clark Rd, East Lansing, MI 48823

    $550,000

    • 4 Beds
    • 4.5 Baths
    • 3,220 Sq Ft
    • 8471 Clark Rd
    • East Lansing, MI

    **HIGHEST AND BEST OFFERS ARE REQUESTED BY 5/1/202/ AT 11:59PM**Luxury meets country living at 8471 Clark Rd in East Lansing. This fully remodeled 4-bed, 4.5-bath home sits on 3.7 private acres just 200 ft from Rose Lake Wildlife Preserve. Enjoy a vaulted great room, chef's kitchen with stainless steel appliances, two primary suites, a walk-out basement, private office, and a new fruit orchard.

    Christopher Silker Keller Williams Realty Lansing

    Section Image
  • 6074 E Longview Dr Unit 79, East Lansing, MI 48823

    $659,000

    • 3 Beds
    • 3.5 Baths
    • 4,419 Sq Ft
    • 6074 E Longview Dr
    • Unit 79
    • East Lansing, MI

    Wow! Fully renovated 3 bed plus den, 3.5 bath ranch with 4600 finished square feet. Covered front porch with custom metal railing greets you. Once inside the space expands with volume ceilings, light mohawk carpeting, venetian blinds, fresh paint and all new fixtures. 2nd primary suite is to the left past foyer with walk in shower. Continue into foyer and 40 ft great room expands on the south

    Joseph Vitale Century 21 Affiliated

    Section Image
  • 6261 Windrush Ln, East Lansing, MI 48823

    $709,900

    • 5 Beds
    • 3.5 Baths
    • 3,769 Sq Ft
    • 6261 Windrush Ln
    • East Lansing, MI

    Exclusive executive five-bedroom, four-bathroom traditional home is located in the highly desirable White Hills Lakes neighborhood. The expansive front yard has been professionallylandscaped, offering exceptional curb appeal with low maintenance. As you cross the thresholdinto the light-filled entry, you will be wowed by the scope and functionality of this home'simpressive floor

    Heather Driscoll EXIT Great Lakes Realty

    Section Image
  • 5791 Westminster Way, East Lansing, MI 48823

    $469,600

    • 4 Beds
    • 3 Baths
    • 2,769 Sq Ft
    • 5791 Westminster Way
    • East Lansing, MI

    Haslett Schools, popular Everett Woods sub. Custom Giguere Builders home with almost 2800 above grade Sq Ft, large great room area with tile floors, brick faced wood burning fireplace, dining area with extra storage, kitchen with granite countertops, newer appliances, gas cooktop in center island with large pantry along with second closet. Family room area off of kitchen could be used for

    Terry Lasky Coldwell Banker Professionals -Okemos

    Section Image
  • 1740 Foxcroft Rd, East Lansing, MI 48823

    $474,900

    • 5 Beds
    • 3.5 Baths
    • 4,195 Sq Ft
    • 1740 Foxcroft Rd
    • East Lansing, MI

    Your search is over with this updated, classic ranch in Whitehills Estates! 1740 Foxcroft is the perfect mix of original charm with the modern amenities you deserve. You are greeted by a wide foyer that spills into the living room complete with hardwood floors and a giant picture window letting in a ton of natural light. The tastefully done kitchen with stainless steel appliances and granite

    Megan Doyle - Busque RE/MAX Real Estate Professionals

    Section Image
  • 6031 Marietta Way, East Lansing, MI 48823

    $650,000

    • 5 Beds
    • 4 Baths
    • 3,911 Sq Ft
    • 6031 Marietta Way
    • East Lansing, MI

    Stunningly Luxurious Home in the desirable Haslett School District! Welcome to 6031 Marietta Way, an exceptional residence nestled in one of the area's most sought-after neighborhoods. This meticulously maintained home offers elegance, space, and premium features throughout. Step inside to soaring ceilings, rich finishes, and a thoughtful layout designed for both comfort and style. The main floor

    Ben Magsig EXP Realty - Haslett

    Section Image
  • 2229 Cider Mill Dr Unit 124, East Lansing, MI 48823

    $619,900

    • 5 Beds
    • 3.5 Baths
    • 3,412 Sq Ft
    • 2229 Cider Mill Dr
    • Unit 124
    • East Lansing, MI

    Welcome to 2229 Cider Mill Drive, a nine-year old Eastbrooke home nestled in a cul de sac, surrounded by trees, and a natural area that connects to Brattin Woods Park. The main floor features a living room, formal dining room, luxurious kitchen, and a glass-surrounded Michigan room that puts you close to nature. The double-sided fireplace makes both living room and Michigan room cozy. Upstairs

    Kristy Seibold Real Estate One 1st

    Section Image
  • 16875 Black Walnut Ln, East Lansing, MI 48823

    $644,900

    • 5 Beds
    • 5.5 Baths
    • 4,334 Sq Ft
    • 16875 Black Walnut Ln
    • East Lansing, MI

    Spacious Family Retreat with Dream Kitchen & Private Yard Oasis in the Meadows...Welcome to this expansive and beautifully updated family home that blends everyday functionality with thoughtful luxury, and was appraised in November 2024 for $700,000. The stately double front door entry opens to a two story foyer and grand staircase. Off the foyer you will find two perfectly planned rooms for our

    Lisa Green- Ramont RE/MAX Real Estate Professionals

    Section Image
  • 525 Northlawn Ave, East Lansing, MI 48823

    $675,000

    • 4 Beds
    • 3.5 Baths
    • 3,692 Sq Ft
    • 525 Northlawn Ave
    • East Lansing, MI

    Welcome home to 525 Northlawn Avenue, East Lansing 48823. This is truly one of East Lansing's very special homes. It's rare to find a spacious all brick ranch floor plan, on an extra-large corner lot, in the Glencairn Neighborhood. The owners have loved and cared for this wonderful gem walking distance to Shaw Park, Glencairn Elementary School, as well as the Hannah Community Center, Library,

    Dave Ledebuhr Musselman Realty Company

    Section Image

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Jin Qingxu $434,900 Tri County Title Agency Llc
Bartow James M -- None Available
Bartow James M $395,000 Talon Group
Hodowaine Vera M $60,000 --
Cawood Building Co $42,400 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Jin Qingxu $173,960
Previous Owner Bartow James M $244,000
Previous Owner Bartow James M $316,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/30/2021 07/30/21 Sold $434,900 0.0% $120 / Sq Ft
06/16/2021 06/16/21 For Sale $434,900 -- $120 / Sq Ft
Source: Greater Lansing Association of Realtors®

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
2024 $63 $242,900 $0 $242,900
2023 $11,562 $228,500 $0 $228,500
2022 $11,312 $215,300 $0 $215,300
2021 $11,512 $205,300 $0 $205,300
2020 $11,353 $201,800 $0 $201,800
2019 $10,986 $193,200 $0 $193,200
2018 $7,821 $175,900 $0 $175,900
2017 $7,455 $167,600 $0 $167,600
2016 $4,118 $150,100 $0 $150,100
2015 $4,118 $152,400 $0 $0
2014 $4,118 $150,200 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Greater Lansing Association of Realtors®

MLS Number: 256555

Greater Lansing Association of Realtors®

APN: 02-02-05-402-044