6518 W LOUISE Drive, Glendale, AZ 85310

$895,000
Property Type: Residential Bedrooms: 4 Baths: 3 Square Footage: 3,134 Lot Size (sq. ft.): 9,900 Status: Closed
Current Price: $895,000 List Date: 6/19/2025 Last Modified: 4/06/2026

Overview

Description

When a husband dreamed of the ultimate entertaining space and his wife envisioned clean, modern design, the result was The Entertainer. Interior features include a wood-burning fireplace, custom bar, massive island, bold finishes, smooth texture walls, LED lighting, and a spa-style primary suite with a fully built-out closet. The open, split layout balances flow with function. Outdoors, enjoy a gas-heated pool and spa, wood-burning fire pit, synthetic turf, and paver-accented patios ideal for gatherings. A new concrete tile roof and completely finished landscape add lasting value and curb appeal. Every space blends comfort, personality, and purpose in a home built to impress.

Supplements: Welcome to The Entertainera home thoughtfully designed by its owners to combine bold, social spaces with calm, modern elegance. Located in a well-established Arrowhead community, this completely reimagined home blends warmth, clean design, and premium upgrades both inside and out. Every detail, from the flow of the floor plan to the finishes selec ...

Listing Details MLS# 6875052

Location, Tax & Legal

House Number
6518
Compass
W
Street Name
LOUISE
St Suffix
Drive
City/Town Code
Glendale
State/Province
AZ
Zip Code
85310
Zip4
5701
Country
US
County Code
Maricopa
Assessor Number
200-05-356
Subdivision
TOP OF THE RANCH 3
Tax Year
2024
Assessor's Map #
5
Legal Description (Abbrev)
LOT 248 TOP OF THE RANCH 3 MCR 037010
Assessor's Parcel #
356
Tax Municipality
Glendale
Taxes
3408

Contract Information

Type
Exclusive Right To Sell
Ownership
Fee Simple
Co-Ownership (Fractional) Agreement YN
No

General Property Description

Dwelling Type
Single Family Residence
Dwelling Styles
Detached
Exterior Stories
Yes
# of Interior Levels
Yes
# Bedrooms
4
Total Bathrooms
3
Approx SQFT
3134
Price/SqFt
285.57
Horses
N
Model
SHASTA
Builder Name
CENTEX HOMES
Year Built
1994
Approx Lot SqFt
9900
Approx Lot Acres
0.227
Flood Zone
No
Community Pool Y/N
No
Private Pool Y/N
Yes
Fireplace YN
Yes
Fireplaces Total
Yes
Planned Comm Name
Arrowhead Ranch
Marketing Name
The Entertainer
Elementary School District
Deer Valley Unified District
High School District
Deer Valley Unified District
Elementary School
Legend Springs Elementary
Jr. High School
Hillcrest Middle School
High School
Mountain Ridge High School

Remarks Misc

Cross Street
N 67th Ave & W Deer Valley Rd
Directions
From AZ-101 Loop W take exit 18 toward 67th Ave, Merge onto W Beardsley Rd, Head North onto N 67th Ave, Turn right onto W Deer Valley Rd, Turn left onto N 66th Ave, Turn right onto W Louise Dr.

Status Change Info

Off Market Date
2025-08-01
Under Contract Date
2025-07-30
Close of Escrow Date
2025-08-29

Legal Info

Township
4N
Range
2E
Section
19
Lot Number
248

More Information

Basement

Basement Y/N
N

Items Updated

Floor Yr Updated
2021
Floor Partial/Full
Full
Wiring Yr Updated
2021
Wiring Partial/Full
Partial
Plmbg Yr Updated
2021
Plmbg Partial/Full
Partial
Ht/Cool Yr Updated
2021
Ht/Cool Partial/Full
Partial
Roof Yr Updated
2021
Roof Partial/Full
Full
Kitchen Yr Updated
2021
Kitchen Partial/Full
Full
Bath(s) Yr Updated
2021
Bath(s) Partial/Full
Full
Rm Adtn Yr Updated
2021
Rm Adtn Partial/Full
Full
Pool Yr Updated
2021
Pool Partial/Full
Partial

Parking Spaces

Garage Spaces
3
Slab Parking Spaces
4
Total Covered Spaces
3

Solar Panels

Ownership
Monthly Lease Assumption

Showing Notification Methods

Showing Service
Aligned Showings
Text
Yes
Email
Yes
Phone Call
Yes

Sold Info

Loan Type
Cash
Closing Cost Split
Buyer - B
Buyer Concession $/%
%
Seller Concession $/%
%
Buyer Concession to Seller
0
Seller Concession to Buyer
0

Special Listing Cond

N/A
Yes

Construction

Block
Yes

Const - Finish

Painted
Yes
Stucco
Yes

Roofing

Tile
Yes
Concrete
Yes

Association & Fees

HOA Y/N
Y
HOA Disclosure/Addendum Affirmation
Yes
HOA Transfer Fee
0
HOA Fee
0
HOA Paid Frequency
Quarterly
HOA Name
AAM
HOA Telephone
602-906-4940
Special Assessment HOA
No
HOA 2 Y/N
N
PAD Fee Y/N
N
Cap Improvement/Impact Fee
0
Cap Improvement/Impact Fee $/%
%
Cap Improvement/Impact Fee 2
0
Cap Improvement/Impact Fee 2 $/%
%
Prepaid Association Fees HOA
0
Disclosure Fees HOA
0
Other Fees HOA
0
Land Lease Fee Y/N
N
Rec Center Fee Y/N
N
Ttl Mthly Fee Equiv
0

Lockbox Type

Supra
Yes

Architecture

Contemporary
Yes

Master Bathroom

Full Bth Master Bdrm
Yes
Separate Shwr & Tub
Yes
Double Vanity
Yes
Private Toilet Room
Yes

Master Bedroom

Split
Yes

Additional Bedroom

Other Bedroom Split
Yes
Master Bedroom Walk-in Closet
Yes

Add'l Property Use

None
Yes

Fireplace Features

Fireplace Living Rm
Yes
Fire Pit
Yes

Flooring

Vinyl
Yes

Window Features

Solar Screens
Yes
Dual Pane
Yes

Private Pool Features

Heated
Yes
Play Pool
Yes

Community Features

Children's Playgrnd
Yes
Golf
Yes

Dining Area

Formal
Yes
Eat-in Kitchen
Yes
Breakfast Bar
Yes

Heating

Natural Gas
Yes

View

Mountain(s)
Yes

Kitchen Features

Dishwasher
Yes
Disposal
Yes
Gas Oven
Yes
Gas Range
Yes
Kitchen Island
Yes
Built-in Microwave
Yes
Multiple Ovens
Yes
Non-laminate Counter
Yes
Pantry
Yes
Refrigerator
Yes
Walk-in Pantry
Yes

Cooling

Ceiling Fan(s)
Yes
Central Air
Yes

Interior Features

9+ Flat Ceilings
Yes
Wet Bar
Yes
No Interior Steps
Yes

Laundry

Washer Included
Yes
Dryer Included
Yes
Washer Hookup
Yes
Inside
Yes

Other Rooms

Great Room
Yes

Separate Den/Office

Sep Den/Office Y/N
N

Technology

Sat Dish TV Lsd
Yes
Cable TV Avail
Yes
High Speed Internet
Yes

Fencing

Block
Yes

Water Source

City Water
Yes

Exterior Features

Covered Patio(s)
Yes
Patio
Yes

Spa

Private
Yes
Heated
Yes

Sewer

Sewer - Public
Yes

Parking Features

Attch'd Gar Cabinets
Yes
Direct Access
Yes
Garage Door Opener
Yes

New Financing

Cash
Yes
VA
Yes
Conventional
Yes
FHA
Yes

Energy/Green Feature

Solar Panels
Yes

Plumbing

Gas Hot Water Heater
Yes
Gas Hot Wtr – Tnklss
Yes

Utilities

APS
Yes
SW Gas
Yes

Existing 1st Loan

Treat as Free&Clear
Yes

Property Description

Corner Lot
Yes
North/South Exposure
Yes

Landscaping

Synthetic Grass Frnt
Yes
Synthetic Grass Back
Yes
Yrd Wtring Sys Front
Yes
Yrd Wtring Sys Back
Yes
Auto Timer H2O Front
Yes
Auto Timer H2O Back
Yes

Services

City Services
Yes

Disclosures

Seller Discl Avail
Yes
Agency Discl Req
Yes

Possession

Close of Escrow
Yes

Association Fee Incl

Common Area Maint
Yes

Assoc Rules/Info

Pets OK (See Rmrks)
Yes
Rental OK (See Rmks)
Yes

Property Features

Special Listing Cond: N/A Add'l Property Use: None Architecture: Contemporary View: Mountain(s) Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room Master Bedroom: Split Additional Bedroom: Other Bedroom Split; Master Bedroom Walk-in Closet Fireplace Features: Fireplace Living Rm; Fire Pit Flooring: Vinyl Window Features: Solar Screens; Dual Pane Private Pool Features: Heated; Play Pool Spa: Private; Heated Community Features: Children's Playgrnd; Golf Dining Area: Formal; Eat-in Kitchen; Breakfast Bar Kitchen Features: Gas Oven; Gas Range; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Multiple Ovens; Pantry; Walk-in Pantry; Non-laminate Counter; Kitchen Island Laundry: Washer Included; Dryer Included; Washer Hookup; Inside Other Rooms: Great Room Interior Features: 9+ Flat Ceilings; Wet Bar; No Interior Steps Technology: Sat Dish TV Lsd; Cable TV Avail; High Speed Internet Exterior Features: Covered Patio(s); Patio Parking Features: Attch'd Gar Cabinets; Direct Access; Garage Door Opener Construction: Block Const - Finish: Painted; Stucco Roofing: Tile; Concrete Cooling: Central Air; Ceiling Fan(s) Heating: Natural Gas Plumbing: Gas Hot Water Heater; Gas Hot Wtr – Tnklss Utilities: APS; SW Gas Water Source: City Water Sewer: Sewer - Public Services: City Services Fencing: Block Property Description: Corner Lot; North/South Exposure Landscaping: Synthetic Grass Frnt; Synthetic Grass Back; Yrd Wtring Sys Front; Yrd Wtring Sys Back; Auto Timer H2O Front; Auto Timer H2O Back Showing Notification Methods: Text; Email; Phone Call Lockbox Type: Supra Possession: Close of Escrow Association Fee Incl: Common Area Maint Existing 1st Loan: Treat as Free&Clear New Financing: Cash; VA; FHA; Conventional Disclosures: Seller Discl Avail; Agency Discl Req
IDX
Listing Office: HomeSmart
Last Updated: April - 06 - 2026
Copyright 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.