Water Front Luxury Realty

Save
Ask
Tour
Hide
Share
$1,265,000
340 Days On Site

245-47 148th Drive
Rosedale, NY 11422

For Sale|Single Family Residence|Active
6
Beds
5
Total Baths
5
Full Baths
1965
Built
County:
Queens
Listing courtesy of Spirit One Realty Inc info@spiritonerealty.com

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

Call Now: 987-456-3210
Is this the listing for you? We can help make it yours.
987-456-3210
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$5,771
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

Welcome to this spacious and well-appointed two-story home, ideally situated in the desirable Queens 29 school district. With its convenient location, you'll find yourself close to top-rated schools including Pathway College Preparatory School, Collaborative Arts Middle School, and PS 195 William Haberle. Enjoy easy access to local buses, parks, shops, and public transportation. This inviting residence features 6 generous bedrooms and 4 bathrooms, including a luxurious master bath. The home boasts two well-equipped kitchens, perfect for preparing meals and entertaining. The first floor includes a bedroom for added flexibility. Interior highlights include beautiful hardwood floors and elegant granite countertops. The finished basement provides additional living space, while the attic offers pull-down stairs for extra storage. Built with a classic brick and frame construction, this home also includes a convenient driveway. Heating is provided by electric with oil fuel, and the sewer system is community-based. For your comfort, the home is equipped with AC wall units. Don't miss the opportunity to make this exceptional property your new home!, Additional information: Interior Features:Marble Bath

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,265,000
Days On Site 
340 Days
Bedrooms 
6
Inside Area (SqFt) 
N/A
Total Baths 
5
Full Baths 
5
Partial Baths 
N/A
Lot Size 
N/A
Year Built 
1965
MLS® Number 
L3578837
Status 
Active
Property Tax 
$7,941
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
11 months agoListing updated with changes from the MLS®
11 months agoListing first seen on site
General Features
Cross Street 
253 St. /Huxleys
Parking 
DrivewayGarage Door OpenerPrivate
Property Sub Type 
Single Family Residence
Security 
Security System
Sewer 
Public Sewer
Stories 
Two
Water Source 
Public
Interior Features
Appliances 
DishwasherGas Water Heater
Basement 
FinishedFull
Flooring 
Hardwood
Heating 
Natural GasBaseboard
Interior 
Granite Counters
Spa 
Yes
Bathroom 1 
Level - BasementDescription - Finish Basement
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
FrameBrickVinyl Siding
Fencing 
Fenced
Lot Features 
Near Public Transit
Patio And Porch 
Porch
Spa 
Yes
Community Features
Association Amenities 
Park
School District 
Queens 29
Schools
School District
Queens 29
Elementary School
Ps 195 William Haberle
Middle School
Collaborative Arts Middle School
High School
Pathways College Preparatory School
Listing courtesy of Spirit One Realty Inc info@spiritonerealty.com


Based on information submitted to the MLS GRID as of 2025-08-20 12:42 AM EDT. 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.

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

REACH MICHELLE MADTES!


    error: Content is protected !!