Sibel Huryilmaz
Douglas Elliman Real Estate
(516) 613-5137
15 Total Sales
1 in Whitestone
$2,015,000 Price
618 151st St Whitestone, NY 11357
Whitestone NeighborhoodEstimated Value: $1,437,000 - $2,142,000
4
Beds
3
Baths
3,061
Sq Ft
$599/Sq Ft
Est. Value
Highlights
- Colonial Architecture
- Property is near public transit
- Den
- P.S. 193 - Alfred J. Kennedy Rated A
- 1 Fireplace
- 2 Car Detached Garage
About This Home
As of December 2023Wow! Wow! Wow! This young custom brick 4-bedroom, 3-full bath home is truly impressive with its numerous upgrades and attractive features. New kitchen & bathrooms with high end appliances and features will not disappoint. The saltwater pool with an outdoor kitchen is a fantastic addition, offering a great space for summer enjoyment and entertaining. The crown moldings and imported travertine tiles add elegance and style to this home. The presence of a sprinkler system helps maintain the professionally landscaped yard, ensuring its beauty and health. The inclusion of speakers throughout the home suggests a well-integrated sound system that can enhance the overall ambiance. These upgrades plus many more are going to appeal to buyers who value quality craftsmanship and attention to detail. Must see to truly appreciate.
Last Agent to Sell the Property
Maureen Folan R E Group LLC Brokerage Phone: 718-767-8200 License #10491206775 Listed on: 07/20/2023
Last Buyer's Agent
Non Member
NonMember
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $14,204
Year Built
- Built in 2008
Lot Details
- 6,416 Sq Ft Lot
- Lot Dimensions are 47.86x134.05
Parking
- 2 Car Detached Garage
Home Design
- Colonial Architecture
- Brick Exterior Construction
Interior Spaces
- 2-Story Property
- 1 Fireplace
- Den
- Eat-In Kitchen
Bedrooms and Bathrooms
- 4 Bedrooms
- 3 Full Bathrooms
Location
- Property is near public transit
Schools
- Ps 193 Alfred J Kennedy Elementary School
- JHS 194 William Carr Middle School
- Bayside High School
Utilities
- Central Air
- Heating System Uses Natural Gas
Listing and Financial Details
- Legal Lot and Block 41 / 4519
- Assessor Parcel Number 04519-0041
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 20, 2023
Closed on
Dec 22, 2023
Sold by
Pescatore Jessica and Zapata-Sanchez Johnny A
Bought by
Seller's Agent
Maureen Ramsbottom
Maureen Folan R E Group LLC
Buyer's Agent
Non Member
NonMember
List Price
$1,830,000
Sold Price
$1,450,000
Premium/Discount to List
-$380,000
-20.77%
Views
201
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$382,091
Avg. Annual Appreciation
8.98%
Original Mortgage
$990,000
Interest Rate
7.29%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Dec 1, 2009
Sold by
Cresthaven Associates Llc and C
Bought by
Giannopoulos Nadia and Giannopoulos Peter
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$653,000
Interest Rate
5.05%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Oct 21, 2009
Sold by
Cresthaven Associates Llc and Mattone % M
Bought by
Cresthaven Associates Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$653,000
Interest Rate
5.05%
Mortgage Type
Purchase Money Mortgage
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Whitestone, NY
-
Sibel Huryilmaz
-
Khalidah Arifee
Khalidah Arifee
Property Professionals Realty
(347) 801-2761
135 Total Sales
1 in Whitestone
$1,351,000 Price
-
Priscilla Chan-ho
Priscilla Chan-ho
Royalux Realty LLC
(833) 785-9727
77 Total Sales
1 in Whitestone
$1,500,000 Price
-
Mary Theresa Marolda
Mary Theresa Marolda
Douglas Elliman Real Estate
(516) 699-1644
50 Total Sales
1 in Whitestone
$1,670,000 Price
-
Kamruz Baccu
Kamruz Baccu
Island Advantage Realty LLC
(833) 324-3977
15 Total Sales
1 in Whitestone
$850,000 Price
-
Michelle Zhao
Michelle Zhao
Responds QuicklyZI Realty LLC
(934) 200-5622
132 Total Sales
1 in Whitestone
$1,650,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $1,450,000 | -- | ||
| Giannopoulos Nadia | $875,000 | -- | |
| Cresthaven Associates Llc | -- | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $6,473 | ||
| Open | Lora Manuel | $990,000 | |
| Closed | Lora Manuel | $990,000 | |
| Previous Owner | -- | $653,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 12/22/2023 12/22/23 | Sold | $1,450,000 | -18.0% | $474 / Sq Ft |
| 10/17/2023 10/17/23 | Pending | -- | -- | -- |
| 07/25/2023 07/25/23 | Price Changed | $1,768,000 | -3.4% | $578 / Sq Ft |
| 07/20/2023 07/20/23 | For Sale | $1,830,000 | -- | $598 / Sq Ft |
Source: OneKey® MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 |
|---|---|---|---|---|
| 2026 | $15,263 | $80,552 | $10,826 | $69,726 |
| 2025 | $14,399 | $75,994 | $10,610 | $65,384 |
| 2024 | $14,399 | $71,692 | $9,403 | $62,289 |
| 2023 | $14,399 | $71,692 | $10,419 | $61,273 |
| 2022 | $14,204 | $111,240 | $16,620 | $94,620 |
| 2021 | $14,127 | $92,220 | $16,620 | $75,600 |
| 2020 | $13,405 | $79,320 | $16,620 | $62,700 |
| 2019 | $12,498 | $85,500 | $16,620 | $68,880 |
| 2018 | $12,179 | $59,743 | $11,745 | $47,998 |
| 2017 | $12,087 | $59,294 | $14,014 | $45,280 |
| 2016 | $10,873 | $59,294 | $14,014 | $45,280 |
| 2015 | $6,747 | $52,773 | $17,648 | $35,125 |
| 2014 | $6,747 | $49,786 | $16,649 | $33,137 |
Source: Public Records
Agents Affiliated with this Home
-
Maureen Ramsbottom
Seller's Agent in 2023
Maureen Ramsbottom
Maureen Folan R E Group LLC
(718) 767-8200
54 in this area
576 Total Sales
-
NM
Buyer's Agent in 2023
Non Member
NonMember
Map
Source: OneKey® MLS
MLS Number: KEY3492352
APN: 04519-0041
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Ten-X are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Copyright 2026 OneKey® MLS. All rights reserved.
Based on information submitted to the MLS GRID
Listings courtesy of OneKey® MLS as distributed by MLS GRID
Nearby Homes
- 646 Clintonville St
- 150-50 6th Ave
- 150-129 Powells Cove Blvd
- 15043 8th Ave
- 150123 Powells Cove Blvd Unit 150-12
- 15003 7th Ave
- 150-26 Sullivan Dr
- 151-28 9th Ave
- 15018 8th Ave
- 335 Cresthaven Ln
- 151-46 10th Ave
- 3-24 150th St
- 14910 7th Ave
- 151-27 11th Ave
- 310 150th St
- 150-35 11th Ave
- 328 149th Place
- 15150 11th Ave
- 152-15 11th Ave
- 151-23 12th Ave
- 632 151st St
- 612 151st St
- 638 151st St
- 6-12 151st St
- 635 Clintonville St
- 641 Clintonville St
- 631 Clintonville St
- 645 Clintonville St
- 6-6 151st St
- 623 Clintonville St
- 649 Clintonville St
- 6-49 Clintonville St Unit 1st Fl
- 150168 Powells Cove Blvd Unit 150-16
- 606 151st St
- 151-02 6th Rd
- 15102 6th Rd
- 619 Clintonville St
- 6-53 Clintonville St
- 653 Clintonville St
- 15111 7th Ave
Your Personal Tour Guide
Ask me questions while you tour the home.