#869217, Listing office: Exit Realty First Choice
Property details
About 197-29 Hiawatha Ave
Introducing this pristine 3-family, 100% brick Colonial home, built in 2005, offering a perfect combination of modern comfort and convenience. Featuring balconies on every floor and a private driveway with a garage, this home is designed for easy living. 1st Floor: Includes a generous 1-bedroom with a full bath, living room, formal dining room, and access to the garage. 2nd Floor: Boasts 3 bedrooms, 1.5 baths, a spacious living room, formal dining room, and a private balcony. 3rd Floor: Features 3 bedrooms, 1.5 baths, living room, formal dining room, and another balcony. This home is ideally located just minutes from transportation, shopping, LIRR, schools, and places of worship, offering a blend of style, comfort, and convenience. Perfect for buyers seeking a spacious, modern home in a highly desirable location. Don't wait - this one won't last long!, Additional information: Interior Features:Lr/Dr
Highlights
Home typeTriplex
HeatingNatural Gas, Baseboard, Hot Water
StatusActive
Year built2003
ParkingPrivate, Attached, Driveway
MLS #L3591475
Summary
- Partial Bathrooms: 2
- Full Bathrooms: 3
- Interior: First Floor Bedroom
- Total Bedroom Count: 8
- Private Pool: No
- Parking: Private, Attached, Driveway
- Architectural Style: Colonial
- Heating: Natural Gas, Baseboard, Hot Water
- Cooling: None
- List Price: $1,449,000
- Directions: Cross Streets: Carpenter Avenue and Hiawatha Avenue.
- Year Built: 2003
- MLS Number: L3591475
- MLS Name: ONEKEY2
- Office Name: BERKSHIRE HATHAWAY
- Office Phone: (516) 741-3070
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.
DMCA Notice
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: 7/24/2025, 2:41:29 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
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
5
P.S. 35 Nathaniel Woodhull School
Public District KG-5
0.3 mi
•19102 90th Ave
3
P.S. 134 Hollis School
Public District PK-5
0.5 mi
•203-02 109th Ave
5
P.S. 118 Lorraine Hansberry School
Public District PK-5
0.6 mi
•190-20 109th Rd
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 $75,379. The majority of Hollis, NY residents have income between $35k-100k annually. The majority of families are single, no kids. The majority of residents in this area have high school diploma education.
How much money do the neighbors make?
29%
<35k
42%
35k-100k
29%
100k-200k
0%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
45%
Single, No Kids
20%
Single, with Kids
16%
Married, No Kids
19%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
13%
<11 yrs old
6%
12-17 yrs old
23%
18-34 yrs old
41%
35-64 yrs old
17%
65+ yrs old
What do the neighbors do for fun?
Pro Boxing
Major League Soccer (MLS)
Mexican League Soccer
Where do the neighbors shop?
H&M
Burlington
Foot Locker
Where do the neighbors go to eat?
Boston Market
Popeyes
White Castle
What do the neighbors drive?
Honda
Nissan
Kia
What do the neighbors listen to?
Rhythmic Contemporary Hits
Urban Adult Contemporary
News
All data provided by Home Junction and Claritas
Similar homes for sale
#843928, Listing office: Keystone Realty USA Corp
#885973, Listing office: Keystone Realty USA Corp
Frequently asked questions
About 197-29 Hiawatha Ave
The listing price of 197-29 Hiawatha Ave property is $1,449,000.
The property 197-29 Hiawatha Ave is a multi located in Hollis, New York, 11423.
Active Listing: 197-29 Hiawatha Ave is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 197-29 Hiawatha Ave are: P.S. 35 Nathaniel Woodhull School (GreatSchools Rating 5/10), P.S. 134 Hollis School (GreatSchools Rating 3/10), P.S. 118 Lorraine Hansberry School (GreatSchools Rating 5/10), I.S. 192 The Linden School (GreatSchools Rating 4/10), I.S. 238 Susan B. Anthony Academy (GreatSchools Rating 4/10), Jean Nuzzi Intermediate School (GreatSchools Rating 5/10), Cambria Heights Academy (GreatSchools Rating 4/10), Pathways College Preparatory School: A College Board School (GreatSchools Rating 6/10), Institute for Health Professions at Cambria Heights (GreatSchools Rating 3/10).
The year of construction for 197-29 Hiawatha Ave is 2003.
This home is located at 197-29 Hiawatha Ave in Hollis, NY and zip code 11423 in the Southeastern Queens neighborhood. Features: 8 bedrooms, 5 bathrooms. It has been listed on Rocket Homes since November 15, 2024 and is currently priced at $1,449,000.
Over 232 listings were sold over their listed price in June 2025 in Hollis, NY. In the same period over 715 listings were sold below the listed price and 1007 listings were sold for the listed price. The number of listings in Hollis, NY decreased by 4.3% between May and June 2025. The median list price of listings available in June 2025 was $881,252, while the average time on the real estate market was 99 days.
From Rocket Homes Real Estate and based on county public records data.