Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the gd-system-plugin domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the dsidxpress domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the simple-responsive-slider domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/wp-includes/functions.php on line 6114

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '7041' AND `object_type` = 'post' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '7041' AND `object_type` = 'post' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
INSERT INTO `wp_s5gkyt32hd_yoast_indexable` (`object_type`, `object_id`, `object_sub_type`, `permalink`, `primary_focus_keyword_score`, `readability_score`, `inclusive_language_score`, `is_cornerstone`, `is_robots_noindex`, `is_robots_nofollow`, `is_robots_noimageindex`, `is_robots_noarchive`, `is_robots_nosnippet`, `open_graph_image`, `open_graph_image_id`, `open_graph_image_source`, `open_graph_image_meta`, `twitter_image`, `twitter_image_id`, `twitter_image_source`, `primary_focus_keyword`, `canonical`, `title`, `description`, `breadcrumb_title`, `open_graph_title`, `open_graph_description`, `twitter_title`, `twitter_description`, `estimated_reading_time_minutes`, `author_id`, `post_parent`, `number_of_pages`, `post_status`, `is_protected`, `is_public`, `has_public_posts`, `blog_id`, `schema_page_type`, `schema_article_type`, `object_last_modified`, `object_published_at`, `version`, `permalink_hash`, `created_at`, `updated_at`) VALUES ('post', '7041', 'post', 'https://ostermanrealestate.com/property-21/', NULL, '30', '0', '0', NULL, '0', NULL, NULL, NULL, 'https://ostermanrealestate.com/wp-content/uploads/2020/02/5302-N-42nd-Pl-Phoenix-AZ-85018-property-21.jpg', '7119', 'featured-image', '{\"width\":1080,\"height\":721,\"url\":\"https://ostermanrealestate.com/wp-content/uploads/2020/02/5302-N-42nd-Pl-Phoenix-AZ-85018-property-21.jpg\",\"path\":\"/var/www/wp-content/uploads/2020/02/5302-N-42nd-Pl-Phoenix-AZ-85018-property-21.jpg\",\"size\":\"full\",\"id\":7119,\"alt\":\"5302-N-42nd-Pl-Phoenix-AZ-85018-property-21\",\"pixels\":778680,\"type\":\"image/jpeg\"}', 'https://ostermanrealestate.com/wp-content/uploads/2020/02/5302-N-42nd-Pl-Phoenix-AZ-85018-property-21.jpg', '7119', 'featured-image', NULL, 'https://ostermanrealestate.com/property-21/', NULL, NULL, '5302 N 42nd Pl Phoenix, AZ 85018', NULL, NULL, NULL, NULL, '2', '9', '0', NULL, 'publish', '0', NULL, NULL, '1', NULL, NULL, '2022-08-12 20:51:02', '2020-02-25 10:55:40', '2', '43:f70a9cf244f31d9e505cb59bb3a67c05', '2024-12-23 02:12:21', '2024-12-23 02:12:21')

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_primary_term' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_primary_term` WHERE `post_id` = '7041' AND `taxonomy` = 'category' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_primary_term' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_primary_term` WHERE `post_id` = '7041' AND `taxonomy` = 'category' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_primary_term' doesn't exist]
INSERT INTO `wp_s5gkyt32hd_yoast_primary_term` (`term_id`, `post_id`, `taxonomy`, `blog_id`, `created_at`, `updated_at`) VALUES ('6', '7041', 'category', '1', '2024-12-23 02:12:21', '2024-12-23 02:12:21')

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable_hierarchy' doesn't exist]
DELETE FROM `wp_s5gkyt32hd_yoast_indexable_hierarchy` WHERE `indexable_id` = '0'

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '9' AND `object_type` = 'user' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '9' AND `object_type` = 'user' LIMIT 1

5302 N 42nd Pl Phoenix, AZ 85018 - Thomas Osterman - Realtor

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_type` = 'home-page' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_type` = 'home-page' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
INSERT INTO `wp_s5gkyt32hd_yoast_indexable` (`object_type`, `title`, `breadcrumb_title`, `permalink`, `blog_id`, `description`, `is_robots_noindex`, `open_graph_title`, `open_graph_image`, `open_graph_image_id`, `open_graph_description`, `open_graph_image_source`, `open_graph_image_meta`, `object_published_at`, `object_last_modified`, `version`, `permalink_hash`, `created_at`, `updated_at`) VALUES ('home-page', '%%sitename%% %%page%% %%sep%% %%sitedesc%%', 'Home', 'https://ostermanrealestate.com/', '1', 'Scottsdale and Paradise Valley Real Estate Agent', '0', '%%sitename%%', '', '0', '', NULL, NULL, '2013-12-16 15:06:17', '2024-11-13 23:10:02', '2', '31:d0656dafba030bdc157ccf34055e49bd', '2024-12-23 02:12:21', '2024-12-23 02:12:21')

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '13669' AND `object_type` = 'post' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '13669' AND `object_type` = 'post' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SHOW FULL COLUMNS FROM `wp_s5gkyt32hd_yoast_indexable`

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '15' AND `object_type` = 'user' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_indexable` WHERE `object_id` = '15' AND `object_type` = 'user' LIMIT 1

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable_hierarchy' doesn't exist]
SELECT `ancestor_id` FROM `wp_s5gkyt32hd_yoast_indexable_hierarchy` WHERE `indexable_id` = '0' ORDER BY `depth` DESC

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_indexable_hierarchy' doesn't exist]
SELECT `ancestor_id` FROM `wp_s5gkyt32hd_yoast_indexable_hierarchy` WHERE `indexable_id` = '0' ORDER BY `depth` DESC

5302 N 42nd Pl Phoenix, AZ 85018

$2,180,000 • 4,572 SF • 5 Beds • 5.5 Baths • MLS#: 6130286

This exquisitely designed, uniquely modern entertainer’s home offers breathtaking, unobstructed views of Camelback Mountain from virtually every room. Enjoy picturesque sunsets poolside, from the 2nd floor balcony, or right from the comfort of the expansive master suite with its own private terrace where you’ll also sneak in Piestewa views! This artfully inspired residence, sitting on over one-half acre, was reconstructed in 2019 to include a 3,929 main house with 2 magnificent master suites (one on each floor) and 2 additional bedrooms with en-suite baths, walk-in closets, and access to outdoor living spaces.

Designed for open-concept living, you’re invited into the heart of the home, featuring a true chef’s kitchen with a Thermador Suite, including a 6-burner gas cook-top, double wall ovens, custom column refrigerator/freezer, an expansive center island with breakfast bar draped in white quartz. Tucked just behind the main kitchen is an amazingly apportioned butler’s pantry with its own sink, prep counters, dishwasher and a temperature controlled 360-bottle wine room. Encased by windows, the great room, with gas fireplace, has a retractable glass wall that invites you to the artfully manicured, resort-style backyard with a new pool, four-hole putting green, fire-pit, outdoor kitchen with gas BBQ and granite topped pool bar, citrus trees and an herb/vegetable garden. You’ll also find your way to the newly constructed 643 sf guest house with full kitchen featuring KitchenAid appliances, bathroom and a full-size washer/dryer, all reflecting the same quality finishes found in the main residence.

The home is also pre-wired for solar panels and features Control4 SmartHome Technology allowing remote access for all electronic, acoustic, temp control, security and surveillance systems, making it a simple touch to bring the home to life for every type of gathering. Nestled in a quiet, prestigious community in the Camelback Corridor between Arcadia and Paradise Valley, you can walk/bike to neighborhood hot spots like Steak 44, The Village, AJ’s Fine Foods, Echo Canyon hiking and the new Sun’s training center among other high-end shopping, fine dining and entertainment options. Right in the middle of it all, you’re a 10-minute drive to Downtown Phoenix, Scottsdale and Sky Harbor.

This home is truly a unique piece of art with finishes that have been well thought out and carefully orchestrated for the most discriminate entertainer.

 

Walk Thru Tour

 

Floor Plan

Floor Plan

 
 

Share

Facebook
Twitter
WhatsApp
Pinterest
LinkedIn

Thomas Osterman

Thomas Osterman, a leader within the Phoenix area real estate community since 1984, has been assisting clients with their home purchasing and selling needs. To date, he has closed over $128 million in sales, was among the top 3% of Maricopa County Realtors in 2012 for gross-dollar sales volume, was named a Top Producer by Phoenix Magazine for 2021, was in the top. 1% of gross-dollar sales volume in Arizona for Q1 2022 and the top 2% for Q2 2022.Thomas has used his intimate knowledge of Paradise Valley, North Scottsdale, Central Scottsdale, North Phoenix, North Central Phoenix, Arcadia and the Biltmore neighborhoods to offer an exceptional level of personal service. Due to his master negotiation skills, Thomas will ensure that you receive the outcome you desire and the home you deserve. If you are looking for an experienced, professional and genuine real estate agent to get the job done, contact Thomas today at (602) 405-4052.

Contact Thomas

Address: 645 E Missouri Ave Ste 270 Phoenix, AZ 85012

Message Me Here To See This Home

Client Testimonial

Dino C.

“Although I’m no stranger to buying and selling luxury homes, I was pleasantly surprised by Thomas’ knowledge and attention to details. He took the time to become familiar with my needs and to research the market to find just the right options. In addition, Thomas was available for any questions I had about the communities and what I could expect. He also helped tremendously to coordinate the escrow process when I found a home I wanted. I am happy to know that I can rely on Thomas for all of my future real estate needs.”

Message Me Here To See This Home

“Although I’m no stranger to buying and selling luxury homes, I was pleasantly surprised by Thomas’ knowledge and attention to details. He took the time to become familiar with my needs and to research the market to find just the right options. In addition, Thomas was available for any questions I had about the communities and what I could expect. He also helped tremendously to coordinate the escrow process when I found a home I wanted. I am happy to know that I can rely on Thomas for all of my future real estate needs.”
Dino C.

Search These Luxury Phoenix Area Communities For Your Next Home