$279,900

Estimated payment $1,682/month

3 Beds
3 Baths
1,300 Sq Ft
$215 Price per Sq Ft

About This Home

Welcome to 14840 Artesian, a stunning colonial located in the beautiful, well-maintained Rosedale Park neighborhood! This charming home combines classic charm with modern amenities.The kitchen has been completely remodeled making it an open-concept, including new cabinets, Quartz countertops, new backsplash, and new stainless steel appliances (2026). Gleaming new vinyl plank flooring run along the entire home, adding warmth and character (2026). The bathrooms have been remodeled with new tile surround, new ceramic tile floor, new vanity, and new toilet (2026). Enjoy the  newly added bathroom in the primary bedroom (2026). The look of these three full bathrooms defines true Luxury living. Other updates include new garage door (2026), new roof on home (2026), new windows (2026), fresh paint (2026), new LED lighting throughout the house (2026), new chandelier (2026), and so much more! Schedule your showing today! This one might not last very long!!

Listing Agent

Charles Tamou

Top Agent Realty License #6502431245 Listed on: 04/21/2026

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,381

Year Built

  • Built in 1972 | Remodeled in 2026

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete

Additional Features

  • Lot Dimensions are 50x119
  • Ground Level
  • Basement

Community Details

  • Rosedale Park Subdivision

Listing and Financial Details

  • Assessor Parcel Number W22I084628S

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,381

Year Built

Built in 1972 | Remodeled in 2026

Lot Details

6,098 Sq Ft Lot

Parking

2

Listing Details

  • Property Type: Residential
  • Year Built: 1972
  • State Equalized Value: 87700.00
  • Year Renovated: 2026
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Fireplace: No
  • Basement: Yes

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured
  • Construction Materials: AluminumSiding, Brick
  • Road Frontage Type: Paved
  • Fencing: BackYard

Garage/Parking

  • Garage: Yes

Utilities

  • Heating: ForcedAir, NaturalGas
  • Sewer: PublicSewer
  • Water Heater Fuel: NaturalGas
  • Water Source: Public

Lot Info

  • Lot Dimensions: 50X119
  • Parcel Number: W22I084628S

Tax Info

  • Tax Amount Summer: 2128.00
  • Tax Amount Winter: 253.00

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

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 $2,428 $87,700 $0 $0
2024 $2,400 $78,200 $0 $0
2023 $2,333 $63,900 $0 $0
2022 $2,503 $65,000 $0 $0
2021 $2,428 $46,900 $0 $0
2020 $2,427 $37,600 $0 $0
2019 $2,386 $29,500 $0 $0
2018 $2,064 $26,300 $0 $0
2017 $440 $23,200 $0 $0
2016 $2,651 $30,100 $0 $0
2015 $3,010 $30,100 $0 $0
2013 $3,757 $37,569 $0 $0
2010 -- $52,145 $1,904 $50,241
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/21/2026 04/21/26 For Sale $279,900 -- $215 / Sq Ft
Source: Realcomp

Purchase History

Date Type Sale Price Title Company
Warranty Deed $83,800 Speedy Title & Escrow Services
Interfamily Deed Transfer -- None Available
Source: Public Records

About the Listing Agent

Charles' Other Listings

  • 15093 Stahelin Ave, Detroit, MI 48223

    $319,900

    • 3 Beds
    • 3 Baths
    • 1,900 Sq Ft
    • 15093 Stahelin Ave
    • Detroit, MI

    LOCATION, LOCATION, LOCATION!! Welcome to Rosedale Park, one of Detroit’s finest and well-maintained neighborhoods! This stunning colonial has been completely remodeled, combining its classic charm with new, modern amenities. The kitchen has been completely remodeled with a new kitchen cabinets, quartz countertops, subway tile backsplash, a new chandeliers, and stainless steel appliances (2026).

    Charles Tamou Top Agent Realty

    Section Image
  • 14550 Penrod St, Detroit, MI 48223

    $319,900

    • 3 Beds
    • 2 Baths
    • 2,100 Sq Ft
    • 14550 Penrod St
    • Detroit, MI

    LOCATION, LOCATION, LOCATION!! Welcome to Rosedale Park, one of Detroit’s finest and well-maintained neighborhoods! This stunning colonial has been completely remodeled, combining its classic charm with new, modern amenities. The kitchen has been completely remodeled with a new gorgeous kitchen cabinets, quartz countertops, subway tile backsplash, a new chandeliers, and stainless steel appliances

    Charles Tamou Top Agent Realty

    Section Image
  • 16204 Wisconsin St, Detroit, MI 48221

    $165,000

    • 3 Beds
    • 1.5 Baths
    • 1,536 Sq Ft
    • 16204 Wisconsin St
    • Detroit, MI

    This Beautifully maintained 3-bedroom and 1-half bath home offering comfort, character, and functionality throughout! This inviting property features a spacious living room highlighted by a cozy fireplace, perfect for relaxing or entertaining. The formal dining room provides an ideal setting for gatherings, while the charming breakfast nook offers a bright and casual space to enjoy your morning

    Charles Tamou Top Agent Realty

    Section Image
  • 16204 Roselawn St, Detroit, MI 48221

    $249,900

    • 3 Beds
    • 2 Baths
    • 1,500 Sq Ft
    • 16204 Roselawn St
    • Detroit, MI

    Welcome to 16204 Roselawn, a stunning Tudor-style colonial in Detroit's Fitzgerald/Marygrove neighborhood featuring timeless character, spacious living areas, and a beautifully detailed brick exterior. This charming home combines classic charm with modern amenities.The kitchen has been completely remodeled making it an open-concept, including new cabinets, a gorgeous light brown island in the

    Charles Tamou Top Agent Realty

    Section Image
  • 23701 Marlow St, Oak Park, MI 48237

    $419,900

    • 4 Beds
    • 4 Baths
    • 2,518 Sq Ft
    • 23701 Marlow St
    • Oak Park, MI

    Welcome to this completely remodeled 4-bedroom, 3.5 bathroom home featuring a basement. Nested in a prime Oak Park neighborhood, the 2,500+ sqft home not only offers plenty living space, but offers a perfect blend of modern luxury and two Primary suites! The kitchen, which is an open concept to the living room, has been remodeled with white shaker cabinets, a black island, quartz countertops,

    Charles Tamou Top Agent Realty

    Section Image
  • 1724 Graefield Rd, Birmingham, MI 48009

    $275,000

    • 2 Beds
    • 1 Bath
    • 906 Sq Ft
    • 1724 Graefield Rd
    • Birmingham, MI

    In the heart of Birmingham located near cafes and great restaurants and shopping centers.This beautifully remodeled condo showcases a comprehensive array of high-quality upgrades, including an upgraded kitchen, newly renovated bathrooms(2025), updated flooring(2025), and professionally sanded and stained countertops(2025). The residence further features new lighting fixtures throughout(2025),

    Charles Tamou Top Agent Realty

    Section Image
  • 1066 Lorenzo Ct Unit 5, Troy, MI 48085

    $565,000

    • 3 Beds
    • 3.5 Baths
    • 2,438 Sq Ft
    • 1066 Lorenzo Ct
    • Unit 5
    • Troy, MI

    Discover this beautifully designed 3-bedroom, 3-bath home, where warmth meets functionality and style. Step into the open sitting area, complete with a cozy fireplace that sets the perfect tone for relaxing nights or entertaining guests. Three spacious walk-in closets provide ample storage and convenience.The home also features a spacious basement with endless possibilities—whether you

    Charles Tamou Top Agent Realty

    Section Image
  • 784 Barrington Rd, Grosse Pointe Park, MI 48230

    $699,900

    • 4 Beds
    • 5 Baths
    • 3,802 Sq Ft
    • 784 Barrington Rd
    • Grosse Pointe Park, MI

    Welcome to 784 Barrington, the most stunning, the most unique, and the most modern home in the neighborhood! This 4 bedroom, 4.5 bathroom Gem combines classic charm with modern luxury. The kitchen, which is an open concept to the living room, has been remodeled with white shaker cabinets, a forest green island, quartz countertops, new ceramic tile backsplash, and all-new stainless steel

    Charles Tamou Top Agent Realty

    Section Image
  • 18027 Curtain Ave, Eastpointe, MI 48021

    $219,900

    • 3 Beds
    • 1 Bath
    • 1,100 Sq Ft
    • 18027 Curtain Ave
    • Eastpointe, MI

    Welcome to this fanciest, most beautiful brick ranch in Eastpointe! The charming home has all of the amenities and updates you’ve been looking for! The kitchen has nice maple cabinets, granite countertops, and marble floors. The bathroom has black ceramic tile, a modern vanity, and a gorgeous custom marble floor. Other updates include fresh paint (2026), new carpeting (2026), new garage door

    Charles Tamou Top Agent Realty

    Section Image

Source: Realcomp

MLS Number: 20261024851

Realcomp

APN: 22-084628

Your Personal Tour Guide

Ask me questions while you tour the home.