Scottsdale, AZ 85251

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` = '5986' 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', '5986', 'post', 'https://ostermanrealestate.com/property-17/', NULL, '90', '0', '0', NULL, '0', NULL, NULL, NULL, 'https://ostermanrealestate.com/wp-content/uploads/2018/09/Great-Room-Kitchen-Dining-Nook.jpg', '5989', 'featured-image', '{\"width\":4243,\"height\":2818,\"url\":\"https://ostermanrealestate.com/wp-content/uploads/2018/09/Great-Room-Kitchen-Dining-Nook.jpg\",\"path\":\"/var/www/wp-content/uploads/2018/09/Great-Room-Kitchen-Dining-Nook.jpg\",\"size\":\"full\",\"id\":5989,\"alt\":\"Great Room Kitchen Dining Nook\",\"pixels\":11956774,\"type\":\"image/jpeg\"}', 'https://ostermanrealestate.com/wp-content/uploads/2018/09/Great-Room-Kitchen-Dining-Nook.jpg', '5989', 'featured-image', NULL, 'https://ostermanrealestate.com/property-17/', NULL, NULL, 'Scottsdale, AZ 85251', NULL, NULL, NULL, NULL, '1', '3', '0', NULL, 'publish', '0', NULL, NULL, '1', NULL, NULL, '2022-08-12 19:17:51', '2016-01-09 13:29:11', '2', '43:0c847975719eeddacf9510669d920b4b', '2024-12-22 07:28:53', '2024-12-22 07:28:53')

WordPress database error: [Table 'c6z445290005483.wp_s5gkyt32hd_yoast_primary_term' doesn't exist]
SELECT * FROM `wp_s5gkyt32hd_yoast_primary_term` WHERE `post_id` = '5986' 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', '5986', 'category', '1', '2024-12-22 07:28:53', '2024-12-22 07:28:53')

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

Scottsdale, AZ 85251 - 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]
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-22 07:28:53', '2024-12-22 07:28:53')

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_hierarchy' doesn't exist]
SELECT `ancestor_id` FROM `wp_s5gkyt32hd_yoast_indexable_hierarchy` WHERE `indexable_id` = '0' ORDER BY `depth` DESC

January 9, 2016
Blog

Beds: 2, Baths: 2, Sqft: 1,447
Scottsdale, AZ 85251

$475,000 • 1,447 SF • 1 beds • 1.75 baths • MLS#: 5823469
Awesome contemporary 2-story condo in gated community, featuring 1,447 SF, 1 master bedroom, 1.75 baths, office, fabulous kitchen, dinning and great room combination, very light and bright, concrete and wood flooring. Kitchen includes Silestone quartz countertops, Bosch oven and gas range, Sub-Zero fridge/freezer, tons of cabinets, storage & pantry. Master retreat upstairs includes hardwood floors, walk-in closet, full size washer/dryer, master bath with additional closets, double sinks & private toilet room. This condo has a wired network, is wired for wall speakers and sale includes 2 flat screen Samsung TV’s. In addition, this community is adjacent to the Canal with wide paved paths for biking & walking & is surrounded by fantastic shopping, restaurants & entertainment choices.

Gallery

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.

Download your free luxury real estate guide

Real Estate Search

Property Type

City

Price From

Beds

Baths

Min Sqft

try our

Advanced Search

Contact Thomas Osterman