$2,200,000
$300K PRICE DROP

Estimated payment $13,612/month

Total Views 6,692
12 Beds
9.5 Baths
5,950 Sq Ft
$370 Price per Sq Ft

Highlights

  • 0.25 Acre Lot
  • Main Floor Bedroom
  • High Ceiling
  • Wood Flooring
  • 4 Fireplaces
  • 3-minute walk to Bayswater Park

About This Home

Welcome to your dream estate in the prestigious Bayswater Park community—an extraordinary opportunity to own a truly expansive and impeccably maintained residence. This beautifully updated home boasts a stunning 12 bedrooms and 9 luxurious bathrooms, offering ample space for large families, multi-generational living, or anyone who enjoys entertaining on a grand scale. From the moment you arrive, the curb appeal is undeniable, with manicured landscaping and a stately presence that sets the tone for what lies within.

Step inside and experience the care and craftsmanship that define this remarkable home. Every inch has been thoughtfully updated by the dedicated owner, combining modern elegance with timeless charm. The home features spacious living areas, an abundance of natural light, and high-end finishes throughout. With a 4-car garage providing both convenience and storage, this home is as practical as it is beautiful. Whether you're hosting gatherings or seeking your own private sanctuary, this Bayswater Park gem is a rare find that blends luxury, comfort, and functionality.

Listing Agent

Glen Reshiram

Park Assets Real Estate Corp Brokerage Phone: 718-684-8000 License #10401345003 Listed on: 04/26/2025

Property Details

Home Type

  • Manufactured Home

Est. Annual Taxes

  • $22,686

Year Built

  • Built in 1931

Lot Details

  • 0.25 Acre Lot

Parking

  • 4 Car Garage

Interior Spaces

  • 5,950 Sq Ft Home
  • 3-Story Property
  • Built-In Features
  • Crown Molding
  • Beamed Ceilings
  • High Ceiling
  • Recessed Lighting
  • 4 Fireplaces
  • ENERGY STAR Qualified Windows
  • Formal Dining Room
  • Storage
  • Dryer
  • Wood Flooring
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Gas Oven
  • Microwave
  • Freezer
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops

Bedrooms and Bathrooms

  • 12 Bedrooms
  • Main Floor Bedroom
  • En-Suite Primary Bedroom

Schools

  • Ps 104 Bays Water Elementary School
  • Village Academy Middle School
  • Rockaway Collegiate High School

Utilities

  • ENERGY STAR Qualified Air Conditioning
  • Baseboard Heating
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 15726-0001

Property Details

Home Type

Manufactured Home

Est. Annual Taxes

$22,686

Year Built

Built in 1931

Lot Details

0

Parking

4

Listing Details

  • Property Type: Residential
  • Architectural Style: Mini Estate
  • Property SubType: Manufactured Home
  • Property Condition: Updated/Remodeled
  • Levels: Three Or More
  • Year Built: 1931
  • Attribution Contact: 718-684-8000
  • Body Type: Double Wide
  • Carport Y N: No
  • Special Features: None
  • Property Sub Type: MobileManufactured

Interior Features

  • Appliances: Dishwasher, Dryer, Freezer, Gas Oven, Gas Range, Microwave, Stainless Steel Appliance(s), Gas Water Heater
  • Interior Amenities: First Floor Bedroom, First Floor Full Bath, Beamed Ceilings, Built-in Features, Crown Molding, Eat-in Kitchen, Formal Dining, Granite Counters, High Ceilings, Kitchen Island, Primary Bathroom, Open Kitchen, Pantry, Recessed Lighting, Storage, Washer/Dryer Hookup
  • Fireplaces: 4
  • Flooring: Hardwood
  • Fireplace Features: Family Room
  • Full Bathrooms: 9
  • Half Bathrooms: 1
  • Basement: Full
  • Total Bedrooms: 12
  • Fireplace: Yes
  • Living Area: 5950
  • Window Features: ENERGY STAR Qualified Windows
  • Basement YN: Yes

Exterior Features

  • Construction Materials: Fiberglass Siding
  • Pool Private: No
  • Spa: No
  • Waterfront: No

Garage/Parking

  • Total Parking Spaces: 10
  • Garage Spaces: 4
  • Garage: Yes

Utilities

  • Cooling: ENERGY STAR Qualified Equipment
  • Heating: Baseboard
  • Laundry Features: Multiple Locations
  • Sewer: Public Sewer
  • Utilities: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Trash Collection Public, Water Available
  • Water Source: Public

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Middle School: Village Academy

Lot Info

  • Lot Size Acres: 0.2525
  • Lot Size Sq Ft: 11000
  • Building Area Total: 5950
  • Parcel Number: 15726-0001
  • Property Attached: No
  • Additional Parcels: No

Rental Info

  • Lease Considered: No

Tax Info

  • Tax Annual Amount: 22686.4
  • Tax Year: 2024

MLS Schools

  • Elementary School: Ps 104 Bays Water
  • High School: Rockaway Collegiate High School
  • Middle School District: Queens 27

Map

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

Property History

Date Event Price Change Sq Ft Price
09/09/2025 09/09/25 Price Changed $2,200,000 -4.3% $370 / Sq Ft
07/20/2025 07/20/25 Price Changed $2,300,000 -4.2% $387 / Sq Ft
06/30/2025 06/30/25 Price Changed $2,400,000 -2.0% $403 / Sq Ft
06/03/2025 06/03/25 Price Changed $2,450,000 -2.0% $412 / Sq Ft
04/26/2025 04/26/25 For Sale $2,500,000 -- $420 / Sq Ft
Source: OneKey® MLS

Source: OneKey® MLS

MLS Number: 853842

OneKey® MLS

APN: 15726-0001