$890,000
SOLD DEC 5, 2025
5 Beds
3 Baths
1,500 Sq Ft
3,000 Sq Ft Lot

Recently Sold

$593 Per Sq Ft

1% Below List Price

122 Days on Market

Highlights

  • Colonial Architecture
  • Stainless Steel Appliances
  • Bathroom on Main Level
  • Main Floor Bedroom
  • Recessed Lighting
  • 2-minute walk to Brookville Park

About This Home

As of December 2025

Nestled on a beautiful tree lined street of Rosedale, 240-05 Weller avenue is a turn key, move in ready single family home that will captivate you from the moment you arrive with its warm & welcoming energy. Sitting on a 30x100 lot featuring a wide private driveway, and tons of yard space to enjoy outdoor gatherings. This move in ready single family is the perfect opportunity for buyers looking for space. Open the door and enter an expansive sun drenched, modern open concept living/dining area which provides great space for entertaining. The elegant chefs granite kitchen is equipped with floor to ceiling custom cabinetry, adorned with a full fleet of stainless steel appliances & equipped with island for bar stool seating. A rare to find amenity that this house offers is a spacious bedroom & full bath on the first floor. On the second floor 3 additional spacious bedrooms awaits you, each equipped with ample closet space. Down the hall a fully tiled bathroom is adorned with state of the art wall & floor tiles. The high ceiling attic serves as an additional bedroom. The high ceiling full finished basement is fully finished and has both interior and exterior access and can easily be used as the perfect in-law suite. 240-05 Weller Avenue has been fully gutted and remodeled by an expert team of contractors and designers featuring select wide oak wood flooring, recessed lighting, brand new electrical, heating, plumbing and energy efficient split unit A/C systems throughout. 240-05 Weller Avenue is located in the heart of Rosedale! Just stones throw to the Rosedale LIRR station, which makes commuting a breeze. Just off Brookville Blvd, Francis Lewis Blvd, Mayda Road, Huxley Street. Belt Parkway, Cross island Parkway, Southern State Parkway. Short blocks to JFK Airport, Airport hotels, schools, shopping centers, restaurants, cafes, parks and many other vibrant neighborhood amenities.

Last Agent to Sell the Property

Gabriel Kashi

Keystone Realty USA Corp Brokerage Phone: 631-261-2800 License #10401217533 Listed on: 07/07/2025

Co-Listed By

Joshua Haiimpour

Keystone Realty USA Corp Brokerage Phone: 631-261-2800 License #10401324030

Last Buyer's Agent

Gayon Facey

Xquizit Realty Inc License #10311209137

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,513

Year Built

  • Built in 1930

Home Design

  • Colonial Architecture
  • Frame Construction

Interior Spaces

  • 1,500 Sq Ft Home
  • Recessed Lighting
  • Finished Basement
  • Basement Fills Entire Space Under The House
  • Stainless Steel Appliances

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Bathroom on Main Level
  • 3 Full Bathrooms

Parking

  • 4 Carport Spaces
  • Driveway

Schools

  • Ps 38 Rosedale Elementary School
  • Cambria Heights Academy High School

Utilities

  • ENERGY STAR Qualified Air Conditioning
  • Natural Gas Connected

Additional Features

  • ENERGY STAR Qualified Equipment for Heating
  • 3,000 Sq Ft Lot

Listing and Financial Details

  • Assessor Parcel Number 13554-0060

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,513

Year Built

Built in 1930

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architectural Style: Colonial
  • Property SubType: Single Family Residence
  • Year Built: 1930
  • Attribution Contact: 631-261-2800
  • Co List Office Mls Id: KEYKEEG02
  • Co List Office Phone: 631-261-2800
  • Carport Y N: Yes
  • CurrentPrice: 890000.00
  • MlsMajorChangeType: Sold
  • CurrentPrice_By_LivingArea: 593.33333
  • ListPrice_By_LivingArea: 599.33333
  • ListPrice_By_OriginalListPrice: 0.94731
  • ListPrice_By_LotSizeAcres: 13047895.5007
  • LivingAreaSearchSqFt: 1500.00
  • CurrentPrice_By_BuildingAreaTotal: 593.33333
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Stainless Steel Appliance(s)
  • Interior Amenities: First Floor Bedroom, First Floor Full Bath
  • Full Bathrooms: 3
  • Basement: Finished, Full
  • Total Bedrooms: 5
  • Living Area: 1500
  • Basement YN: Yes

Exterior Features

  • Construction Materials: Frame
  • Pool Private: No
  • Waterfront: No

Garage/Parking

  • Garage: No
  • Parking Description: Driveway, Private
  • Carport Spaces: 4

Utilities

  • Cooling: ENERGY STAR Qualified Equipment
  • Heating: ENERGY STAR Qualified Equipment
  • Sewer: Public Sewer
  • Utilities: Natural Gas Connected
  • Water Source: Public

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Middle School: Call Listing Agent

Lot Info

  • Lot Size Acres: 0.0689
  • Lot Size Sq Ft: 3000
  • Parcel Number: 13554-0060
  • Property Attached: No

Rental Info

  • Lease Considered: No

Tax Info

  • Tax Annual Amount: 4513.48
  • Tax Year: 2024

MLS Schools

  • Elementary School: Ps 38 Rosedale
  • High School: Cambria Heights Academy
  • Middle School District: Contact Agent

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 7, 2025
Closed on
Dec 4, 2025
Sold by
Mahe Group Llc
Bought by
Spence Carey A and Spence Violet A
Seller's Agent
Gabriel Kashi
Keystone Realty USA Corp
Buyer's Agent
Gayon Facey
Xquizit Realty Inc
List Price
$899,000
Sold Price
$890,000
Premium/Discount to List
-$9,000
-1%
Views
111

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-47.10%
Original Mortgage
$873,879
Outstanding Balance
$873,879
Interest Rate
6.22%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
-$22,676

Purchase Details

Closed on
Apr 3, 2025
Sold by
Estate Of Miriam A Tannenbaum and Tannenbaum Administrator Richard J
Bought by
Mahe Group Llc
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Type Sale Price Title Company
Deed $890,000 --
Deed $560,000 --
Deed $560,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $873,879 Purchase Money Mortgage
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/05/2025 12/05/25 Sold $890,000 -1.0% $593 / Sq Ft
11/06/2025 11/06/25 Pending -- -- --
10/21/2025 10/21/25 Price Changed $899,000 0.0% $599 / Sq Ft
10/21/2025 10/21/25 For Sale $899,000 -2.2% $599 / Sq Ft
09/09/2025 09/09/25 Pending -- -- --
08/07/2025 08/07/25 Price Changed $919,000 -3.2% $613 / Sq Ft
07/07/2025 07/07/25 For Sale $949,000 -- $633 / Sq Ft
Source: OneKey® MLS

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 $4,501 $25,241 $5,040 $20,201
2024 $4,513 $23,812 $5,117 $18,695
2023 $4,278 $22,464 $4,682 $17,782
2022 $4,198 $32,880 $7,440 $25,440
2021 $4,396 $29,820 $7,440 $22,380
2020 $4,156 $25,620 $7,440 $18,180
2019 $3,858 $26,700 $7,440 $19,260
2018 $3,518 $18,720 $4,992 $13,728
2017 $3,516 $18,720 $5,113 $13,607
2016 $3,404 $18,720 $5,113 $13,607
2015 $2,099 $17,528 $5,390 $12,138
2014 $2,099 $16,536 $6,095 $10,441
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: OneKey® MLS

MLS Number: 886286

OneKey® MLS

APN: 13554-0060