Brian Young PLLC
DPR Realty LLC
Phone: 602-405-3949 Direct
Phone: 480-990-SOLD (7653)
8341 E Gelding Drive, Scottsdale, AZ 85260
Fax:

MLS# 6705625 – 4002 N 54th Place, Phoenix, AZ 85018

$14,995 - 4Br/4Ba - for Sale in Mary Manor, Phoenix
Price: $14,995
Beds: 4
Baths: 3 full, 1 half
Living Area SqFt: 4,672
Status: Active
Property Type: Single Family Residence
Year Built: 2017
Neighborhood: Mary Manor
Days on Website: 334

Courtesy of MMRE Advisors pm@mmreadvisors.com

Property Description

THIS IS A FURNISHED RENTAL THAT IS AVAILABLE SEASONALLY, LONG TERM PRICING, PLEASE CALL FOR BLENDED RATE!! (Jan – Mar $29,995) (Apr, Oct – Dec $17,495) (May – Sept $14,995)!!! Seize the rare opportunity to call this exceptional furnished rental home! Nestled in the heart of Arcadia Proper, this spectacular residence stands above the rest, blending unmatched quality and character in a way few homes can. Crafted as a developer’s personal masterpiece, this 4-bedroom, 3.5-bath retreat is brimming with luxurious touches. Set along a charming, winding street, it boasts a true chef’s kitchen featuring a U-shaped island with ample seating—perfect for entertaining—crowned with pristine white marble. Top-tier Thermador appliances, a coffee and wine station… and seamless flow into an open great room with cascading steel doors to the backyard elevate the experience. The master suite is a dream, offering a spacious soaker tub, an expansive walk-in shower, and custom marble and honed granite finishes. Beyond its stunning interior, this showpiece shines outside with a pickleball/sport court and impeccable surroundings. Behind the scenes, every detail is as impressive as the facade. This is a must-see gem that belongs at the top of your list!

Open House

 
TUE 15 Apr
Schedule Tour
 
WED 16 Apr
Schedule Tour
 
THU 17 Apr
Schedule Tour
 

Property Details and Features

  • Appliances & Equipment
  • “Water Purifier”
  • Bathrooms
  • 3 total decimal bathrooms
  • 4 total bathrooms
  • Bedrooms
  • 4 total bedrooms
  • Building
  • Built in 2017
  • Architectural style: “Other”
  • Living area: 4672
  • Construction materials: “Synthetic Stucco”, “Stucco”, “Wood Frame”, “Low VOC Paint”, “Brick Veneer”, “Brick”, “Spray Foam Insulation”
  • Cooling
  • “Central Air”
  • “Programmable Thmstat”
  • “See Remarks”
  • Accessibility Features
  • Accessibility features: “Accessible Door 32in+ Wide”, “Zero-Grade Entry”, “Mltpl Entries/Exits”, “Ktch Insulated Pipes”, “Accessible Hallway(s)”
  • Exterior Features
  • “Playground”
  • “Private Yard”
  • “Built-in Barbecue”
  • Fence
  • “Block”
  • Fireplaces
  • “Firepit”
  • “Exterior Fireplace”
  • “Gas Fireplace”
  • “Fireplace Living Rm”
  • “2 Fireplaces”
  • Floors
  • “Stone”
  • “Wood”
  • Garage
  • 2 spaces
  • Heating
  • “Electric”
  • Interior Features
  • “See Remarks”
  • “Eat-in Kitchen”
  • “Breakfast Bar”
  • “9+ Flat Ceilings”
  • “No Interior Steps”
  • “Vaulted Ceiling(s)”
  • “Kitchen Island”
  • “Double Vanity”
  • “Full Bth Master Bdrm”
  • “Separate Shwr & Tub”
  • “High Speed Internet”
  • “Smart Home”
  • Laundry
  • “Dryer Included”
  • “Inside”
  • “Washer Included”
  • Listing
  • Listing ID: 6705625
  • Standard status: Active
  • 334 days on market
  • Rent includes: “Internet”, “Electricity”, “Gas”, “Water”, “Utility Caps Apply”, “Sewer”, “Pool Service – Full”, “Pest Control Svc”, “Linen”, “Gardening Service”, “Garbage Collection”, “Dishes”, “Cable TV”
  • Location
  • Subdivision name: MARY MANOR
  • Lot
  • 0.41 acres
  • 17,929 sqft
  • “Sprinklers In Rear”
  • “Sprinklers In Front”
  • “Grass Front”
  • “Grass Back”
  • “Synthetic Grass Back”
  • “Auto Timer H2O Front”
  • “Auto Timer H2O Back”
  • Energy Saving
  • Green energy efficient: “Fresh Air Mechanical”, “Multi-Zones”
  • Green water conservation: “Tankless Ht Wtr Heat”, “Recirculation Pump”
  • Parking
  • “Direct Access”
  • “Garage Door Opener”
  • “Extended Length Garage”
  • “Side Vehicle Entry”
  • “Gated”
  • Pool
  • “Private”
  • Possession
  • “Refer to Date Availb”
  • Property
  • View: “Mountain(s)”
  • Roof
  • “Composition”
  • “Metal”
  • Schools
  • Elementary school: Hopi Elementary School
  • High school: Arcadia High School
  • High school district: Scottsdale Unified District
  • Security Features
  • “Fire Sprinkler System”
  • Sewer
  • “Public Sewer”
  • Taxes
  • Lot: 4
  • Windows
  • “Low-Emissivity Windows”
  • “Dual Pane”
  • “Wood Frames”

Property Map

Nearby Schools

This content last updated on April 14, 2025 4:05AM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.

Print Options

Select the items on the page that you would like to print. This "Print Options" block will not be printed.

Main Photo Main Details Property Description Property Features
Additional Photos Addtl Photos Size Location Map Schools