$10,000 Closing Credit¹
#L3584843, Listing Office: P R O Links Realty Inc
$10,000
closing credit¹
243 150th St Whitestone, NY 11357
$1,880,000 List price
$10,000
Closing credit¹
4 beds
3 full, 1 partial
House
Property details
About 243 150th St
Welcome to this stunning, custom-built, two-story brick residence in the heart of Whitestone, meticulously renovated with top-tier imported finishes and premium appliances, including Miele, Bertazzoni, and Viking. The home radiates elegance and modern sophistication, starting with a grand foyer and custom walnut flooring that set a luxurious tone from the moment you enter. The upper level boasts four spacious bedrooms and two bathrooms, including a master suite complete with a walk-in closet. The expansive, high-ceilinged living room is both beautiful and functional, offering a welcoming and refined space for relaxation and gatherings. On the lower level, the open-concept kitchen combines elegance with functionality, featuring radiant heated floors, a large granite island, a premium appliance suite, and custom cabinetry. Adjacent to the kitchen, the cozy family room opens seamlessly to the tranquil patio and backyard through glass doors, perfect for effortless indoor-outdoor living. The spacious walk-out lower level offers abundant closet and storage space with additional access to the backyard. The versatile unfinished basement can be customized to suit the buyer's preferred use. Outdoor spaces are thoughtfully designed for entertaining, and the home includes central air and an attached two-car garage. Every detail has been thoughtfully crafted, with custom walnut flooring throughout and bathrooms enhanced by walnut cabinetry, adding a refined, cohesive aesthetic. A beautiful staircase with imported walnut steps leads to the upper level, where you'll find four spacious bedrooms and two bathrooms, including a luxurious master suite complete with a walk-in closet. The expansive, high-ceilinged living room is designed to offer both beauty and functionality, creating an inviting space for relaxation and gatherings. Conveniently located near Francis Lewis Park and just minutes from major highways and bridges, this exceptional home blends timeless elegance with modern convenience, creating an unparalleled living experience.
Highlights
Home typeSingle Family Residence
HeatingNatural Gas, Forced Air
StatusActive
CoolingCentral Air
Year built2003
ParkingPrivate, Attached
MLS #L3588776
Summary
- MLS Number: L3588776
- MLS Name: ONEKEY2
- Office Name: Tru International Realty Corp
- Office Phone: (929) 608-9600
Listings courtesy of OneKey MLS as distributed by 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. Properties displayed may be listed or sold by various participants in the MLS.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the OneKey™ MLS. Real Estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. This information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed.
Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 2/4/2025, 10:56:49 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$1,880,000
243 150th St
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
7
P.S. 193 Alfred J. Kennedy School
Public District PK-5
0.6 mi
•15220 11th Ave
9
P.S. 79 Francis Lewis School
Public District KG-6
0.8 mi
•14727 15th Dr
6
P.S. 129 Patricia Larkin School
Public District KG-5
1.3 mi
•12802 7th Ave
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $108,636. The majority of Whitestone, NY residents have income between $100k-200k annually. The majority of families are married, no kids. Most residents in this area have post secondary degree education.
How much money do the neighbors make?
19%
<35k
26%
35k-100k
40%
100k-200k
15%
200k+
What level of education do the neighbors have?
No High School
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
27%
Single, No Kids
4%
Single, with Kids
35%
Married, No Kids
34%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
15%
<11 yrs old
8%
12-17 yrs old
17%
18-34 yrs old
44%
35-64 yrs old
16%
65+ yrs old
What do the neighbors do for fun?
Live Theatre
Hiking/backpacking
Men's Tennis
Where do the neighbors shop?
Bloomingdales
Nordstrom Rack
Crate & Barrel
Where do the neighbors go to eat?
Boston Market
Starbucks
The Cheesecake Factory
What do the neighbors drive?
Mercedes
Audi
Volvo
What do the neighbors listen to?
News
Alternative
All data provided by Home Junction and Claritas
Similar homes for sale
$10,000 Closing Credit¹
#L3591712, Listing Office: Keller Williams Rlty Landmark
$10,000 Closing Credit¹
#L3571877, Listing Office: Real Broker NY LLC
$10,000 Closing Credit¹
#815857, Listing Office: Century Homes Realty Group LLC
$10,000 Closing Credit¹
#L3586470, Listing Office: Signature Spaces NYC Corp
$10,000 Closing Credit¹
#L3589193, Listing Office: Sany Realty Group LLC
$10,000 Closing Credit¹
#807892, Listing Office: LAFFEY REAL ESTATE
$10,000 Closing Credit¹
#L3572560, Listing Office: Prospes Real Estate Corp
$10,000 Closing Credit¹
#L3584175, Listing Office: E Realty International Corp
$10,000 Closing Credit¹
#816746, Listing Office: RE/MAX 1st Choice
Frequently asked questions
About 243 150th St
This home is located at 243 150th St in Whitestone, NY and zip code 11357 in the Beechhurst neighborhood. Features: 4 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since November 1, 2024 and is currently priced at $1,880,000.
Over 208 listings were sold over their listed price in January 2025 in Whitestone, NY. In the same period over 759 listings were sold below the listed price and 890 listings were sold for the listed price. The inventory of homes for sale in Whitestone, NY between December and January 2025 decreased by 3.4%. In January 2025, listings were on the market for 79 days. During the same period, the median list price in this real estate market was $862,270.
From Rocket Homes Real Estate and based on county public records data.