NOT LISTED FOR SALE

Estimated Value: $1,858,000 - $2,266,000

4 Beds
4 Baths
3,632 Sq Ft
$558/Sq Ft Est. Value

Last Sold April 20, 2021

Last sale price $1,550,000 $427 Per Sq Ft

Est. 31% increase in value since last sale

Current estimated payment $11,529/month

Highlights

  • Private Pool
  • Gated Community
  • Mountain View
  • Laguna Elementary School Rated A
  • Waterfront
  • Granite Countertops

About This Home

As of March 2024

Stunning Waterfront Luxury Estate in prestigious Scottsdale Ranch. If you are dreaming of living a resort style lifestyle on the water, this is the home and community for you! Perfectly situated on a 42 acre private lake with jetty and boat.

Gorgeous views of Serena lake, palm trees and the McDowell mountains from nearly every room is what makes this rare custom estate unique. The home has been remodeled from top to bottom and offers the finest of finishes throughout. 19-foot cathedral ceilings and all on 1 easy level! Situated on a corner lot, this property has 3 bedrooms plus an office and 4 baths., including a master bedroom w/ en-suite. Entertain your guests in the chefs kitchen with a wrap around island with SS appliances including a microwave

Last Agent to Rent the Property

Azroy Salim

AZ Brokerage Holdings, LLC License #SA517417000 Listed on: 11/21/2023

Last Renter's Agent

Laura Tyler

eXp Realty License #SA676612000

eXp Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,406

Year Built

  • Built in 1987

Lot Details

  • 0.28 Acre Lot
  • Waterfront
  • Wrought Iron Fence
  • Grass Covered Lot

Parking

  • 3 Car Garage

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,632 Sq Ft Home
  • 1-Story Property
  • Family Room with Fireplace
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Granite Countertops

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 4 Bathrooms
  • Double Vanity
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Washer Hookup

Pool

  • Private Pool
  • Spa

Schools

  • Laguna Elementary School
  • Mountainside Middle School
  • Desert Mountain High School

Utilities

  • Central Air
  • Heating Available

Listing and Financial Details

  • Property Available on 11/21/23
  • 12-Month Minimum Lease Term
  • Tax Lot 12
  • Assessor Parcel Number 217-46-904-C

Community Details

Overview

  • Property has a Home Owners Association
  • Bayview Estates Association
  • Bayview Estates Subdivision

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,406

Year Built

Built in 1987

Lot Details

0

Parking

3

Rental Info

  • HOA Paid By: Landlord
  • Available Date: 2023-11-21

Listing Details

  • Cross Street: Shea Blvd & 100th Street
  • Legal Info Range: 5E
  • Property Type: Residential Lease
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 3.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 1987
  • Rental Info H O A Name: Bayview Estates
  • Non Assistive Animals: Call
  • Rental Info Rental Tax Percent: 1.84
  • Lease Term Minimum Lease Term Months: 12
  • Directions: From Shea, go south on 100th St and turn left into Bayview estates, house is first one on your left. Do not park in left hand side of driveway as that is for neighbor behind.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.28
  • Subdivision Name: BAYVIEW Estates
  • Property Attached Yn: No
  • Laundry Features Washer Hookup: Yes
  • Laundry Features Inside: Yes
  • Construction:Wood Frame: Yes
  • Water Source City Water2: Yes
  • Fireplace Features Fireplace Family Rm2: Yes
  • Special Features: None

Interior Features

  • Basement YN: No
  • Furnished: Unfurnished
  • Spa Features: Private
  • Possible Bedrooms: 4
  • Total Bedrooms: 4
  • Fireplace Features: Fireplace Family Rm, 1 Fireplace
  • Fireplace: Yes
  • Interior Amenities: Granite Counters, Double Vanity, Eat-in Kitchen, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 3632.0
  • Stories: 1
  • Kitchen Features:Granite Countertops: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Community Features:Gated: Yes
  • Master Bathroom:Double Vanity: Yes

Exterior Features

  • Fencing: Wrought Iron
  • Lot Features: Gravel/Stone Front, Grass Back
  • Pool Private: Yes
  • View: Mountain(s)
  • Waterfront: Yes
  • Disclosures: Agency Discl Req
  • Construction Type: Stucco, Wood Frame, Painted
  • Roof: Tile

Garage/Parking

  • Total Covered Spaces: 3.0
  • Garage Spaces: 3.0
  • Open Parking Spaces: 3.0

Utilities

  • Cooling: Central Air
  • Heating: Electric
  • Laundry Features: Washer Hookup, Inside
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Gated
  • Association Name: Bayview Estates
  • Phone: x
  • Association: Yes
  • Pets Allowed: Call

Schools

  • Elementary School: Laguna Elementary School
  • High School: Desert Mountain High School
  • Junior High Dist: Scottsdale Unified District
  • Middle Or Junior School: Mountainside Middle School

Lot Info

  • Lot Size Sq Ft: 12200.0
  • Parcel #: 217-46-904-C

Building Info

  • Builder Name: x

Tax Info

  • Tax Book Number: 217.00
  • Tax Lot: 12
  • Tax Map Number: 46.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Nov 20, 2023
Sold by
Albrechtsen Sharmi
Bought by
Lowdermilk Sheela
Current Estimated Value
$2,026,794

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,331,250
Outstanding Balance
$1,307,982
Interest Rate
7.49%
Mortgage Type
New Conventional
Estimated Equity
$718,812

Purchase Details

Listed on
Feb 2, 2021
Closed on
Mar 15, 2021
Sold by
Sarandi Greg
Bought by
Nissen Jesper and Albrechtsen Sharmi
Seller's Agent
Azroy Salim
AZ Brokerage Holdings, LLC
Buyer's Agent
Jorge Munos
Realty Executives Arizona Territory
List Price
$1,650,000
Sold Price
$1,550,000
Premium/Discount to List
-$100,000
-6.06%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.20%
Original Mortgage
$1,394,000
Interest Rate
3.05%
Mortgage Type
New Conventional

Purchase Details

Listed on
Oct 2, 2020
Closed on
Oct 21, 2020
Sold by
Weldon Jillian Lee and The Bronstein Survivors Trust
Bought by
The Joint Chiropractic Pv Village Llc
Seller's Agent
Donald Aldrich Jr
Keller Williams Arizona Realty
Buyer's Agent
Non-MLS Agent
Non-MLS Office
List Price
$1,175,000
Sold Price
$1,150,000
Premium/Discount to List
-$25,000
-2.13%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
86.24%

Purchase Details

Closed on
Dec 29, 2014
Sold by
Bronstein Living Trust and Bronstein David G
Bought by
Bronstein Family Trust and Bronstein David G

Purchase Details

Closed on
Jun 9, 2005
Sold by
Bronstein David and Bronstein Elizabeth
Bought by
Bronstein David G and Bronstein Elizabeth

Purchase Details

Closed on
Jan 6, 2000
Sold by
Ramey Lynne
Bought by
Knowles Edward H and Ramey Marguerite Lynne

Purchase Details

Closed on
Jun 4, 1999
Sold by
Knowles Edward
Bought by
Ramey Lynne

Purchase Details

Closed on
Mar 2, 1998
Sold by
Chamberlain Mary Ann
Bought by
Bronstein David and Bronstein Elizabeth

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$616,000
Interest Rate
4.87%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 21, 1998
Sold by
Chamberlain Michael D and Chamberlain Mary Ann
Bought by
Chamberlain Mary Ann

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$616,000
Interest Rate
4.87%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 8, 1997
Sold by
Chamberlain Michael D and Chamberlain Mary Ann
Bought by
Chamberlain Michael D and Chamberlain Mary Ann

Purchase Details

Closed on
Aug 10, 1995
Sold by
Barnes Bruce E
Bought by
Chamberlain Michael D and Chamberlain Mary Ann

Purchase Details

Closed on
Sep 22, 1994
Sold by
Chamberlain Michael D and Chamberlain Mary Ann
Bought by
Chamberlain Michael D and Chamberlain Mary Ann

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$475,000
Interest Rate
8.61%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 21, 1994
Sold by
Ramey Lynne
Bought by
Chamberlain Michael D and Chamberlain Mary Ann

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$475,000
Interest Rate
8.61%
Mortgage Type
New Conventional
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Lowdermilk Sheela $1,775,000 First American Title Insurance
Nissen Jesper $1,550,000 First American Title Ins Co
The Joint Chiropractic Pv Village Llc $1,150,000 Great American Title Agency
Bronstein Family Trust -- None Available
Bronstein David G -- --
Knowles Edward H -- --
Ramey Lynne -- Century Title Agency
Bronstein David $770,000 Lawyers Title Of Arizona Inc
Chamberlain Mary Ann -- --
Chamberlain Michael D -- Grand Canyon Title Agency In
Chamberlain Michael D -- Grand Canyon Title Agency In
Chamberlain Michael D -- United Title
Chamberlain Michael D -- --
Chamberlain Michael D $620,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lowdermilk Sheela $1,331,250
Previous Owner Nissen Jesper $1,394,000
Previous Owner Bronstein David $616,000
Previous Owner Chamberlain Michael D $475,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/13/2024 03/13/24 Rented $9,500 0.0% --
02/20/2024 02/20/24 Price Changed $9,500 -3.1% $3 / Sq Ft
01/22/2024 01/22/24 Price Changed $9,800 -2.0% $3 / Sq Ft
12/29/2023 12/29/23 For Rent $10,000 0.0% --
12/25/2023 12/25/23 Off Market $10,000 -- --
11/21/2023 11/21/23 For Rent $10,000 +11.1% --
02/01/2023 02/01/23 Rented $9,000 -9.5% --
01/01/2023 01/01/23 Under Contract -- -- --
12/27/2022 12/27/22 For Rent $9,950 0.0% --
12/02/2022 12/02/22 Under Contract -- -- --
11/17/2022 11/17/22 Price Changed $9,950 -17.1% $3 / Sq Ft
10/13/2022 10/13/22 For Rent $12,000 0.0% --
04/20/2021 04/20/21 Sold $1,550,000 -6.1% $427 / Sq Ft
03/25/2021 03/25/21 Pending -- -- --
01/13/2021 01/13/21 For Sale $1,650,000 +43.5% $454 / Sq Ft
10/27/2020 10/27/20 Sold $1,150,000 -2.1% $317 / Sq Ft
10/02/2020 10/02/20 For Sale $1,175,000 -- $324 / Sq Ft
Source: Arizona Regional Multiple Listing Service (ARMLS)

Tax History Compared to Growth

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 $9,406 $139,017 -- --
2024 $8,697 $132,397 -- --
2023 $8,697 $157,200 $31,440 $125,760
2022 $8,221 $138,880 $27,770 $111,110
2021 $8,772 $132,920 $26,580 $106,340
2020 $8,690 $126,380 $25,270 $101,110
2019 $8,364 $116,520 $23,300 $93,220
2018 $8,080 $113,170 $22,630 $90,540
2017 $7,713 $109,650 $21,930 $87,720
2016 $7,552 $109,380 $21,870 $87,510
2015 $7,159 $89,400 $17,880 $71,520
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6633141

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-46-904C