$549,900
$75K PRICE DROP

Estimated payment $3,223/month

Total Views 5,051
3 Beds
2 Baths
1,412 Sq Ft
$389 Price per Sq Ft

Highlights

  • Heated Pool
  • RV Gated
  • Covered patio or porch
  • Greenway High School Rated A-
  • No HOA
  • 4.5 Car Garage

About This Home

Step into a world of color, creativity, and comfort with this fully furnished, turnkey short-term rental that's already a hit on Airbnb! Designed for both relaxation and entertainment, this one-of-a-kind home features incredible hand-painted murals by a local artist, adding personality and charm to every space. Inside, you'll find pops of brilliant color throughout, a stylish coffee bar, and thoughtfully curated furnishings that make guests feel right at home. But the real magic happens outside—your backyard oasis is built for unforgettable memories, complete with a sparkling heated pool, putting green, outdoor games, hanging chairs, turf, and a grill for the ultimate gathering space. The fun doesn't stop there! A separate 2.5 car garage-turned-game-room is air conditioned and offers even more entertainment, featuring a poker table, pool table, shuffleboard, and a bar; an absolute guest favorite. Whether you're looking for a lucrative investment property or a personal retreat, this home is ready to go and packed with character. Don't miss your chance to own this highly rated, income-producing Airbnb!

Listing Agent

Michael Weinstein

West USA Realty License #SA538104000

West USA Realty

Co-Listing Agent

Ryan Gerdes

West USA Realty License #SA542372000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,851

Year Built

  • Built in 1979

Lot Details

  • 8,493 Sq Ft Lot
  • Desert faces the front and back of the property
  • Block Wall Fence

Parking

  • 4.5 Car Garage
  • 6 Open Parking Spaces
  • Garage Door Opener
  • RV Gated

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Siding
  • Stucco

Interior Spaces

  • 1,412 Sq Ft Home
  • 1-Story Property
  • Ceiling Fan
  • Double Pane Windows
  • Tinted Windows
  • Family Room with Fireplace
  • Tile Flooring
  • Built-In Microwave

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Bathrooms

Accessible Home Design

  • No Interior Steps

Outdoor Features

  • Heated Pool
  • Covered patio or porch

Schools

  • Sunburst Elementary School
  • Desert Foothills Middle School
  • Greenway High School

Utilities

  • Refrigerated Cooling System
  • Heating Available
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Parkview North Subdivision

Listing and Financial Details

  • Tax Lot 21
  • Assessor Parcel Number 207-27-167

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,851

Year Built

Built in 1979

Lot Details

0

Parking

4

Listing Details

  • Cross Street: 47th Avenue and Bell Road
  • Legal Info Range: 2E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 6.0
  • Parking Spaces Total Covered Spaces: 4.5
  • Separate Den Office Sep Den Office: N
  • Year Built: 1979
  • Tax Year: 2024
  • Property Sub Type: Single Family - Detached
  • Horses: No
  • Lot Size Acres: 0.2
  • Co List Office Mls Id: wusa94
  • Co List Office Phone: 602-942-4200
  • Subdivision Name: PARKVIEW NORTH
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Assessor
  • Special Features: None

Interior Features

  • Flooring: Tile
  • Basement YN: No
  • Spa Features: None
  • Possible Bedrooms: 3
  • Total Bedrooms: 3
  • Fireplace Features: 1 Fireplace, Family Room
  • Fireplace: Yes
  • Interior Amenities: No Interior Steps, 3/4 Bath Master Bdrm, High Speed Internet
  • Living Area: 1412.0
  • Stories: 1
  • Window Features: Dual Pane, Tinted Windows
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Fireplace:Fireplace Family Rm: Yes
  • Kitchen Features:Non-laminate Counter: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Covered Patio(s)
  • Lot Features: Desert Back, Desert Front
  • Pool Features: Heated, Private
  • Pool Private: Yes
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Siding, Frame - Wood
  • Roof: Composition
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes

Garage/Parking

  • Total Covered Spaces: 4.5
  • Parking Features: Dir Entry frm Garage, Electric Door Opener, Extnded Lngth Garage, RV Gate, Detached, RV Access/Parking
  • Attached Garage: No
  • Garage Spaces: 4.5
  • Open Parking Spaces: 6.0
  • Parking Features:Dir Entry frm Garage: Yes
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:RV Gate: Yes
  • Parking Features:Extnded Lngth Garage: Yes
  • Parking Features:RV Parking: Yes
  • Parking Features:Detached: Yes

Utilities

  • Cooling: Ceiling Fan(s), Refrigeration
  • Heating: Electric
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Amenities: None
  • Association: No

Association/Amenities

  • Association Fees:HOA YN2: N
  • Association Fees:PAD Fee YN2: N
  • Association Fee Incl:No Fees: Yes

Fee Information

  • Association Fee Includes: No Fees

Schools

  • Elementary School: Sunburst School
  • High School: Greenway High School
  • Junior High Dist: Glendale Union High School District
  • Middle Or Junior School: Desert Foothills Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 8493.0
  • Parcel #: 207-27-167
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Unknown

Tax Info

  • Tax Annual Amount: 1851.0
  • Tax Book Number: 207.00
  • Tax Lot: 21
  • Tax Map Number: 27.00

Map

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

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 $1,851 $15,137 -- --
2024 $1,818 $14,416 -- --
2023 $1,818 $29,620 $5,920 $23,700
2022 $1,534 $22,800 $4,560 $18,240
2021 $1,573 $20,900 $4,180 $16,720
2020 $1,531 $19,360 $3,870 $15,490
2019 $1,503 $18,210 $3,640 $14,570
2018 $1,461 $15,660 $3,130 $12,530
2017 $1,456 $13,630 $2,720 $10,910
2016 $1,622 $13,010 $2,600 $10,410
2015 $1,072 $11,570 $2,310 $9,260
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/03/2025 03/03/25 Price Changed $549,900 -12.0% $389 / Sq Ft
02/19/2025 02/19/25 For Sale $624,900 +23.7% $443 / Sq Ft
04/29/2022 04/29/22 Sold $505,000 +9.8% $358 / Sq Ft
04/07/2022 04/07/22 Pending -- -- --
04/04/2022 04/04/22 For Sale $460,000 +114.0% $326 / Sq Ft
05/16/2017 05/16/17 Sold $215,000 -6.1% $152 / Sq Ft
04/15/2017 04/15/17 Pending -- -- --
03/25/2017 03/25/17 For Sale $229,000 -- $162 / Sq Ft
Source: Arizona Regional Multiple Listing Service (ARMLS)

Deed History

Date Type Sale Price Title Company
Interfamily Deed Transfer -- Mortgage Connect Lp
Warranty Deed $215,000 Clear Title Agency Of Arizon
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Warranty Deed $211,000 Chicago Title Insurance Co
Warranty Deed $127,000 Capital Title Agency Inc
Cash Sale Deed $120,375 First American Title Ins Co
Interfamily Deed Transfer -- Fidelity National Title
Warranty Deed $70,000 Security Title Agency
Cash Sale Deed $80,000 United Title Agency
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $209,606 FHA
Closed $209,571 FHA
Closed $65,000 New Conventional
Closed $212,276 FHA
Closed $211,105 No Value Available
Previous Owner $153,491 New Conventional
Previous Owner $168,800 New Conventional
Previous Owner $125,037 FHA
Previous Owner $105,000 No Value Available
Previous Owner $67,900 New Conventional
Previous Owner $58,500 No Value Available
Closed $31,650 No Value Available
Source: Public Records

Similar Homes in Glendale, AZ

  • 4523 W Bluefield Ave, Glendale, AZ 85308

    $520,000

    • 4 Beds
    • 2.5 Baths
    • 2,620 Sq Ft
    • 4523 W Bluefield Ave
    • Glendale, AZ

    Nestled in the sought-after Bellair Golf Course community, this beautifully updated home offers modern upgrades and resort-style living. Enjoy stunning golf course views, a sleek kitchen with new appliances, and a cozy family room with a fireplace. The landscaped backyard is perfect for relaxing or entertaining. Bellair provides golf, pickleball, pools, walking paths, and RV storage for

    Keslie Halonen Keller Williams Realty Professional Partners

    Section Image
  • 3743 W Hartford Ave, Glendale, AZ 85308

    $449,000

    • 4 Beds
    • 2 Baths
    • 1,898 Sq Ft
    • 3743 W Hartford Ave
    • Glendale, AZ

    No HOA! Tons of parking! Welcome to this stunning single-level retreat, thoughtfully updated & move-in ready! Situated on a desirable north/south-facing lot, this property offers 2 driveways, 2 RV gates w/parking, & 2-car garage—perfect for extra space for vehicles, trailers, or an RV. Inside, you'll find a bright, open-concept living space w/new flooring, baseboards, & fresh interior paint t/o.

    Gerry Dombek CRS West USA Realty

    Section Image
  • 17463 N 66th Ave, Glendale, AZ 85308

    $563,980

    • 3 Beds
    • 2 Baths
    • 1,832 Sq Ft
    • 17463 N 66th Ave
    • Glendale, AZ

    Just completed! One of our last available homes in the community, nestled along the scenic Skunk Creek Trail near Arrowhead. Single-level 3-Bedroom, 2.5 baths, 1832sq ft with a bright, open Great Room and features a wall of sliding doors to the covered patio; Gourmet kitchen, oversized island, walk in pantry, 42'' upper cabinets; quartz counter tops in kitchen and baths; Owner's Super shower;

    Dean Selvey RE/MAX Excalibur

    Section Image
  • 17469 N 66th Ave, Glendale, AZ 85308

    $506,400

    • 3 Beds
    • 2 Baths
    • 1,832 Sq Ft
    • 17469 N 66th Ave
    • Glendale, AZ

    Only a few lots remain!! Discover the hidden enclave of new homes at Campana Trails. This collection of 21 single-family homes nestled along the scenic Skunk Creek Trail in Glendale offers a perfect blend of serenity and convenience. Priced affordably in the low $500s with below-market financing options! Still time to select all interior finishes, exterior elevation, and colors. 3-Bedrooms, 2.5

    Dean Selvey RE/MAX Excalibur

    Section Image
  • 20630 N 42nd Ave, Glendale, AZ 85308

    $559,500

    • 4 Beds
    • 2 Baths
    • 2,399 Sq Ft
    • 20630 N 42nd Ave
    • Glendale, AZ

    Privacy meets convenience. This beautiful single-story home backs up to an open landscape and privately owned preserve with beautiful mountain views, all from your own backyard. Imagine grilling out on the custom built in gas BBQ while taking in the views! The split floor plan provides a primary retreat with ensuite bath, and you'll find a huge 9x20 bonus room. Throughout this open floor plan

    Kim Panozzo HomeSmart

    Section Image
  • 5517 W Aster Dr, Glendale, AZ 85304

    $530,000

    • 4 Beds
    • 2 Baths
    • 2,145 Sq Ft
    • 5517 W Aster Dr
    • Glendale, AZ

    Welcome to a well-maintained home in the desirable Marshall Ranch community of Glendale. Located on a quiet street, this single-level property offers a comfortable layout. The primary suite offers plenty of space, complete with an en-suite bath and walk-in closet, while the additional bedrooms are ideal for guests, a home office, or hobbies. A light-filled living room that flows into the formal

    Otley Smith Citiea

    Section Image
  • 4053 W Quail Ave, Glendale, AZ 85308

    $459,000

    • 3 Beds
    • 2.5 Baths
    • 1,507 Sq Ft
    • 4053 W Quail Ave
    • Glendale, AZ

    Affordable and sustainable living in Goodyear! This Hello Green Home is offered with a green energy package that includes a MASSIVE SELLER-PAID INTEREST RATE BUY DOWN and pre-permitted solar + battery system to be owned by the buyer including potential eligibility for the federal tax credit (consult a tax professional). The home has been completely renovated with a gorgeous new kitchen

    James Samsing Econest, Inc.

    Section Image
  • 5951 W Irma Ln, Glendale, AZ 85308

    $675,000

    • 4 Beds
    • 3 Baths
    • 2,414 Sq Ft
    • 5951 W Irma Ln
    • Glendale, AZ

    Welcome to this fully updated 4-bedroom 3-bathroom home with a pool, golf course views & prime location! Freshly repainted from top to bottom, including all walls, ceilings, baseboards, kitchen, and bathroom cabinets, this home is truly move-in ready! On the main level, you will find a versatile bedroom with a walk-in closet, perfect for a guest, and a dedicated office. The updated kitchen

    Beth Rider Keller Williams Arizona Realty

    Section Image
  • 21209 N 40th Ave, Glendale, AZ 85308

    $479,980

    • 3 Beds
    • 2 Baths
    • 1,578 Sq Ft
    • 21209 N 40th Ave
    • Glendale, AZ

    Beautiful home in North Glendale within the quiet community of Sunset Trials! This single-level house has almost 1,600 square feet of living space which includes a large living room, three-bedrooms plus a den, two-bathrooms, and a spacious kitchen with nice oak cabinets, upgraded countertops, and new appliances. The house also sits on an oversize lot and features a big backyard with an extended

    Tony C. Doan West USA Realty

    Section Image

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6822881

Arizona Regional Multiple Listing Service (ARMLS)

APN: 207-27-167