Sidarealty.com Search Results

Spacious full-brick 3-family property in the heart of Flushing, offering three separate apartments across three above-grade levels plus a basement. Situated on an approximately 2,832 SF lot with a building size of approximately 25' x 48', this property features a total of 8 bedrooms, 5 full bathrooms, and an additional half bathroom, parking for approximately four vehicles plus a garage, and a highly convenient location near Queens College, Main Street Flushing, shopping, dining, parks, public transportation, and everyday conveniences. The property also offers convenient access to Flushing–Main Street LIRR station and major transit options. Gut renovated in 2015 and offered in move-in-ready condition, the property will be delivered vacant, providing flexibility for end-users and investors alike. Additional improvements include updated electrical and plumbing systems, gutter and drainage improvements, balcony decking renovations, and a hot water heater replacement completed in 2019. The first floor features a 2-bedroom, 1-bath apartment with a full-size kitchen and direct access to the backyard. The second floor offers a 3-bedroom, 2-bath apartment with one ensuite bedroom, an additional full bathroom, a full-size kitchen, and balcony access. The third floor features a similar 3-bedroom, 2-bath apartment with one ensuite bedroom, an additional full bathroom, a full-size kitchen, and balcony access. The finished basement offers walk-out access, an additional half bathroom, and washer/dryer access, providing extra usable space and convenience. Each unit offers a spacious layout, full-size kitchen, open living and dining areas, and split-system air conditioning. Skylights above the staircase and in the third-floor bathroom provide additional natural light throughout the upper level. Additional features include a sprinkler system, backyard access, and ample parking accommodations.

8 Beds ⋅ 6 Baths ⋅ 1010785 MLS

Spacious full-brick 3-family property in the heart of Flushing, offering three separate apartments across three above-grade levels plus a basement. Situated on an approximately 2,832 SF lot with a building size of approximately 25' x 48', this property features a total of 8 bedrooms, 5 full bathrooms, and an additional half bathroom, parking for approximately four vehicles plus a garage, and a highly convenient location near Queens College, Main Street Flushing, shopping, dining, parks, public transportation, and everyday conveniences. The property also offers convenient access to Flushing–Main Street LIRR station and major transit options. Gut renovated in 2015 and offered in move-in-ready condition, the property will be delivered vacant, providing flexibility for end-users and investors alike. Additional improvements include updated electrical and plumbing systems, gutter and drainage improvements, balcony decking renovations, and a hot water heater replacement completed in 2019. The first floor features a 2-bedroom, 1-bath apartment with a full-size kitchen and direct access to the backyard. The second floor offers a 3-bedroom, 2-bath apartment with one ensuite bedroom, an additional full bathroom, a full-size kitchen, and balcony access. The third floor features a similar 3-bedroom, 2-bath apartment with one ensuite bedroom, an additional full bathroom, a full-size kitchen, and balcony access. The finished basement offers walk-out access, an additional half bathroom, and washer/dryer access, providing extra usable space and convenience. Each unit offers a spacious layout, full-size kitchen, open living and dining areas, and split-system air conditioning. Skylights above the staircase and in the third-floor bathroom provide additional natural light throughout the upper level. Additional features include a sprinkler system, backyard access, and ample parking accommodations.

59-17 Kissena Boulevard, Flushing

Welcome to the Bayside Gables, one of the most sought-after communities in Northeast Queens, where your search for the perfect home ends. This charming 4-bedroom, 4-bath split-level residence enjoys a southern exposure, filling the home with abundant natural light and warmth throughout the day. Upon entering the foyer, you are welcomed into a spacious sunken living room featuring a wood-burning fireplace, which flows seamlessly into the adjacent dining area and leads to a custom kitchen. The kitchen showcases solid oak cabinetry, granite countertops, a Sub-Zero refrigerator, stainless steel appliances, exquisite tile flooring throughout, and additional high-end finishes perfect for both everyday living and entertaining. The bedrooms are generously sized and feature pristine hardwood flooring, well-appointed bathrooms, and ample closet space. The fully finished basement provides additional living space, ideal for entertaining, recreation, or relaxation. A rare highlight includes a two-car garage, additional storage, and a four-car driveway, offering exceptional convenience. Situated on approximately 0.3 acres, the property provides unmatched privacy and generous outdoor space, ideal for an in-ground pool addition or custom landscaping, and the home has been recently upgraded with a brand-new roof. Centrally located near schools, transportation, shopping, houses of worship, parks, and just steps from Little Neck Bay and the Bayside Marina, this home offers the perfect balance of tranquility and accessibility. A true hallmark of elegance, and a must-see opportunity in an exceptional neighborhood.

4 Beds ⋅ 4 Baths ⋅ 952670 MLS

Welcome to the Bayside Gables, one of the most sought-after communities in Northeast Queens, where your search for the perfect home ends. This charming 4-bedroom, 4-bath split-level residence enjoys a southern exposure, filling the home with abundant natural light and warmth throughout the day. Upon entering the foyer, you are welcomed into a spacious sunken living room featuring a wood-burning fireplace, which flows seamlessly into the adjacent dining area and leads to a custom kitchen. The kitchen showcases solid oak cabinetry, granite countertops, a Sub-Zero refrigerator, stainless steel appliances, exquisite tile flooring throughout, and additional high-end finishes perfect for both everyday living and entertaining. The bedrooms are generously sized and feature pristine hardwood flooring, well-appointed bathrooms, and ample closet space. The fully finished basement provides additional living space, ideal for entertaining, recreation, or relaxation. A rare highlight includes a two-car garage, additional storage, and a four-car driveway, offering exceptional convenience. Situated on approximately 0.3 acres, the property provides unmatched privacy and generous outdoor space, ideal for an in-ground pool addition or custom landscaping, and the home has been recently upgraded with a brand-new roof. Centrally located near schools, transportation, shopping, houses of worship, parks, and just steps from Little Neck Bay and the Bayside Marina, this home offers the perfect balance of tranquility and accessibility. A true hallmark of elegance, and a must-see opportunity in an exceptional neighborhood.

216-29 28th Avenue, Bayside

Welcome to this exceptional and spacious single-family home located in the heart of Douglaston, Queens, offering rare country-style living on a quiet, tree-lined private road. Beautifully maintained and set on an large 126 x 95 landscaped lot with a serene waterfall, this unique corner property overlooks the protected Alley Pond, ensuring permanent privacy and unobstructed views. Fence all around. The open-concept first floor features a generous living room with a fireplace, a large kitchen with granite countertop and stainless steel appliances. Kitchen has a skylight and breakfast area, a formal dining room ideal for entertaining, a family room with cathedral ceilings, a full bathroom, and a bedroom, along with a legal sun-filled four-season Florida room. Upstairs boasts an oversized primary bedroom, two additional bedrooms, walk-in closet and a full bathroom. The full basement includes a laundry room, boiler room, storage, and a partially finished area. An additional legal brick outbuilding offers versatile use as a shed, workshop, summer kitchen, or BBQ area. It has 2 car garage with grage opening and additional 5 cars parking. Conveniently located near public transportation including local and express buses and the LIRR (just 20 minutes to Manhattan). You are also just minutes from major highways (LIE and Cross Island Pkway) and it's making this location ideal for those on the go. It is close to schools, parks, shopping, and houses of worship—this rare gem truly must be seen to be appreciated.

4 Beds ⋅ 2 Baths ⋅ 920355 MLS

Welcome to this exceptional and spacious single-family home located in the heart of Douglaston, Queens, offering rare country-style living on a quiet, tree-lined private road. Beautifully maintained and set on an large 126 x 95 landscaped lot with a serene waterfall, this unique corner property overlooks the protected Alley Pond, ensuring permanent privacy and unobstructed views. Fence all around. The open-concept first floor features a generous living room with a fireplace, a large kitchen with granite countertop and stainless steel appliances. Kitchen has a skylight and breakfast area, a formal dining room ideal for entertaining, a family room with cathedral ceilings, a full bathroom, and a bedroom, along with a legal sun-filled four-season Florida room. Upstairs boasts an oversized primary bedroom, two additional bedrooms, walk-in closet and a full bathroom. The full basement includes a laundry room, boiler room, storage, and a partially finished area. An additional legal brick outbuilding offers versatile use as a shed, workshop, summer kitchen, or BBQ area. It has 2 car garage with grage opening and additional 5 cars parking. Conveniently located near public transportation including local and express buses and the LIRR (just 20 minutes to Manhattan). You are also just minutes from major highways (LIE and Cross Island Pkway) and it's making this location ideal for those on the go. It is close to schools, parks, shopping, and houses of worship—this rare gem truly must be seen to be appreciated.

53-21 240th Street, Douglaston

Currently used by steel fabrication business. Business owner willing to sell business and equipment included with building sale.

906747 MLS

Currently used by steel fabrication business. Business owner willing to sell business and equipment included with building sale.

15050 11th Avenue, Whitestone

Prime Forest Hills Location, One Dwelling Fully Detached House. Lot Size 65 X 100, Building Size 27 X 44, Large Backyard, Private Driveway, 5 Bedrooms, 3 Bathrooms, 1 Half-Bath, Finished Basement With A Back Door Entrance. Located In A Convenient Area With Easy Access To Amenities, Public Transport, And PS.196.

5 Beds ⋅ 4 Baths ⋅ 857842 MLS

Prime Forest Hills Location, One Dwelling Fully Detached House. Lot Size 65 X 100, Building Size 27 X 44, Large Backyard, Private Driveway, 5 Bedrooms, 3 Bathrooms, 1 Half-Bath, Finished Basement With A Back Door Entrance. Located In A Convenient Area With Easy Access To Amenities, Public Transport, And PS.196.

112-30 68 Avenue, Forest Hills

warehouse building for sale, and if wanted Long running established autobody shop including inventory. Spray booth,mixing bank, paint room, 2-compressors, 2-storage containers,inspection machine., Additional information: Business Located At:131-09 14th Avenue

834384 MLS

warehouse building for sale, and if wanted Long running established autobody shop including inventory. Spray booth,mixing bank, paint room, 2-compressors, 2-storage containers,inspection machine., Additional information: Business Located At:131-09 14th Avenue

131-09 14th Avenue, College Point

Incredibly unique 1988 young, 3-Family home in Fresh Meadows offering spacious living and exceptional investment potential. This enormous property has an impressive building size of 28 x 58! The ground-level duplex features 3 bedrooms, 2 baths, and backyard access. The second and third-floor apartments each boast 3 bedrooms, 2 baths, and a balcony. All apartments offer oversized living spaces with abundant natural light, king-sized bedrooms, and ample closet space. Additional features include common area laundry, two driveways, a large foyer, and hardwood floors throughout. Tenants are responsible for their own cooking gas and electricity, while the owner covers the cost of heat. Conveniently located near transportation (LIE, Q17 & Q88 buses), Fresh Meadows Shopping Center, an array of dining options, Kissena Park, and more! A must-see property!

9 Beds ⋅ 7 Baths ⋅ 833161 MLS

Incredibly unique 1988 young, 3-Family home in Fresh Meadows offering spacious living and exceptional investment potential. This enormous property has an impressive building size of 28 x 58! The ground-level duplex features 3 bedrooms, 2 baths, and backyard access. The second and third-floor apartments each boast 3 bedrooms, 2 baths, and a balcony. All apartments offer oversized living spaces with abundant natural light, king-sized bedrooms, and ample closet space. Additional features include common area laundry, two driveways, a large foyer, and hardwood floors throughout. Tenants are responsible for their own cooking gas and electricity, while the owner covers the cost of heat. Conveniently located near transportation (LIE, Q17 & Q88 buses), Fresh Meadows Shopping Center, an array of dining options, Kissena Park, and more! A must-see property!

61-21 169th Street, Fresh Meadows

Prime Mixed-Use Property in the Heart of Douglaston, Queens! Seize this rare investment opportunity in one of Queens' most sought-after neighborhoods! This mixed-use gem offers two spacious residential units on the second floor: a bright and airy two-bedroom apartment, ideal for families or roommates, and a charming one-bedroom unit, perfect for singles or couples. Both units promise consistent rental income and are always in demand due to the property's prime location. The ground floor is home to a well-established, thriving pizzeria that has been a loyal commercial tenant for years, providing a stable and reliable income stream. With its unbeatable location in a vibrant, desirable neighborhood, this property offers significant potential for both immediate cash flow and long-term appreciation. Don't miss your chance to invest in this exceptional property!

L3580838 MLS

Prime Mixed-Use Property in the Heart of Douglaston, Queens! Seize this rare investment opportunity in one of Queens' most sought-after neighborhoods! This mixed-use gem offers two spacious residential units on the second floor: a bright and airy two-bedroom apartment, ideal for families or roommates, and a charming one-bedroom unit, perfect for singles or couples. Both units promise consistent rental income and are always in demand due to the property's prime location. The ground floor is home to a well-established, thriving pizzeria that has been a loyal commercial tenant for years, providing a stable and reliable income stream. With its unbeatable location in a vibrant, desirable neighborhood, this property offers significant potential for both immediate cash flow and long-term appreciation. Don't miss your chance to invest in this exceptional property!

44-17 Douglaston Parkway, Douglaston

$1,999,999

BEACH BLOCK BEAUTY with a Backyard Built for Entertaining Stunning! Immaculate! Dynamite! This beach block gem is everything you’ve been waiting for and then some. Just steps from the sand, this bright and breezy home blends charm with luxury, all centered around the most desirable backyard oasis in all of Rockaway. Inside, you'll find three spacious bedrooms, three and a half bathrooms, a sun-drenched living room with a cozy fireplace, a formal dining room perfect for gatherings, family room and laundry room. Sliding doors open to your private outdoor paradise—ideal for entertaining all year long. The showstopper? A heated in-ground saltwater pool (3 years young), surrounded by a gorgeous patio, plush landscaping, complete with a cabana, outdoor shower and bath, and plenty of space to relax, dine, and host in style. Additional highlights include central air, two driveways, audio surround sound and a fully equipped lower-level apartment—perfect as a Mother/Daughter set up, guests or extended family members. Whether you're hosting a summer soirée or enjoying peaceful beachside mornings, this home delivers comfort, style, and that unbeatable Rockaway lifestyle.

4 Beds ⋅ 4 Baths ⋅ 874386 MLS

BEACH BLOCK BEAUTY with a Backyard Built for Entertaining Stunning! Immaculate! Dynamite! This beach block gem is everything you’ve been waiting for and then some. Just steps from the sand, this bright and breezy home blends charm with luxury, all centered around the most desirable backyard oasis in all of Rockaway. Inside, you'll find three spacious bedrooms, three and a half bathrooms, a sun-drenched living room with a cozy fireplace, a formal dining room perfect for gatherings, family room and laundry room. Sliding doors open to your private outdoor paradise—ideal for entertaining all year long. The showstopper? A heated in-ground saltwater pool (3 years young), surrounded by a gorgeous patio, plush landscaping, complete with a cabana, outdoor shower and bath, and plenty of space to relax, dine, and host in style. Additional highlights include central air, two driveways, audio surround sound and a fully equipped lower-level apartment—perfect as a Mother/Daughter set up, guests or extended family members. Whether you're hosting a summer soirée or enjoying peaceful beachside mornings, this home delivers comfort, style, and that unbeatable Rockaway lifestyle.

156 Beach 135th Street, Belle Harbor

$1,999,000

TBA

5 Beds ⋅ 4 Baths ⋅ 868097 MLS

TBA

8033 169 Street, Jamaica

$1,999,000

I'm So excited to Offer This Legacy Property for Sale in The Royal Neighborhood of Rego Park. Very Rarely does a Huge End Property (see the description)become available For Sale in this desired location. Solid built Property with many Modern Designs. Enough parking space for 3-4 cars and Living space to move about. Too Much to mention in this writing. Come See and Have some Tea!!!, Additional information: Appearance:Excellent,Interior Features:Lr/Dr,Separate Hotwater Heater:Y

8 Beds ⋅ 6 Baths ⋅ L3544894 MLS

I'm So excited to Offer This Legacy Property for Sale in The Royal Neighborhood of Rego Park. Very Rarely does a Huge End Property (see the description)become available For Sale in this desired location. Solid built Property with many Modern Designs. Enough parking space for 3-4 cars and Living space to move about. Too Much to mention in this writing. Come See and Have some Tea!!!, Additional information: Appearance:Excellent,Interior Features:Lr/Dr,Separate Hotwater Heater:Y

99-32 63rd Avenue, Rego Park

$1,997,500

Step inside this custom-built contemporary masterpiece, crafted in 2017 for those with truly discerning taste. From the moment you enter, the home radiates warmth and sophistication—red oak floors, walls of Marvin windows, soaring ceilings, and thoughtful architectural details create an atmosphere that is both inviting and effortlessly refined. Designed for comfortable everyday living yet exceptional for entertaining, this residence is the perfect blend of elegance and livability. The grand foyer sets the tone, showcasing 21-foot ceilings, a sweeping staircase, and a showstopping chandelier that instantly captivates. Just off the entrance is a private family room with its own full bath—ideal as a guest suite, media room, or home office. Continue through the main level to discover an expansive open-concept living room, dining area, and chef’s kitchen that seamlessly flow together beneath magnificent 11-foot ceilings. The kitchen is equipped with Sub-Zero refrigeration, Wolf cooking appliances, quartz countertops, and beautifully crafted custom cabinetry. A convenient half bath and access to the covered patio and generous backyard complete this exceptional floor. The second level offers three spacious bedrooms, including a serene primary suite designed to feel like a personal retreat. The main hall bath is ADA-accessible for added convenience. The oversized primary bedroom is complemented by an extraordinary walk-in closet—large enough to function as a dressing room or private office—and a spa-inspired ensuite featuring radiant heated floors, a double-wide vanity, a luxurious whirlpool tub, and rainfall shower. This level continues the home’s airy elegance with 10-foot ceilings throughout. The fully finished lower level extends the home’s versatility, offering 8-foot ceilings, a den with wet bar, a bonus room perfect for overnight guests, a full bath, and a dedicated laundry area. Whether used for recreation, relaxation, or hosting, this floor adds tremendous value and comfort. Modern conveniences elevate the entire home: central AC, a hybrid heating system with VLF electric and gas, state-of-the-art Toto self-cleaning toilets, and an elevator providing effortless access to all three levels. Completing the property is a private garage and thoughtfully designed outdoor spaces. This is more than a home—it’s a statement. A rare combination of high-end craftsmanship, innovative features, and timeless style. Come experience it in person and feel the difference the moment you walk through the door.

3 Beds ⋅ 4 Baths ⋅ 936046 MLS

Step inside this custom-built contemporary masterpiece, crafted in 2017 for those with truly discerning taste. From the moment you enter, the home radiates warmth and sophistication—red oak floors, walls of Marvin windows, soaring ceilings, and thoughtful architectural details create an atmosphere that is both inviting and effortlessly refined. Designed for comfortable everyday living yet exceptional for entertaining, this residence is the perfect blend of elegance and livability. The grand foyer sets the tone, showcasing 21-foot ceilings, a sweeping staircase, and a showstopping chandelier that instantly captivates. Just off the entrance is a private family room with its own full bath—ideal as a guest suite, media room, or home office. Continue through the main level to discover an expansive open-concept living room, dining area, and chef’s kitchen that seamlessly flow together beneath magnificent 11-foot ceilings. The kitchen is equipped with Sub-Zero refrigeration, Wolf cooking appliances, quartz countertops, and beautifully crafted custom cabinetry. A convenient half bath and access to the covered patio and generous backyard complete this exceptional floor. The second level offers three spacious bedrooms, including a serene primary suite designed to feel like a personal retreat. The main hall bath is ADA-accessible for added convenience. The oversized primary bedroom is complemented by an extraordinary walk-in closet—large enough to function as a dressing room or private office—and a spa-inspired ensuite featuring radiant heated floors, a double-wide vanity, a luxurious whirlpool tub, and rainfall shower. This level continues the home’s airy elegance with 10-foot ceilings throughout. The fully finished lower level extends the home’s versatility, offering 8-foot ceilings, a den with wet bar, a bonus room perfect for overnight guests, a full bath, and a dedicated laundry area. Whether used for recreation, relaxation, or hosting, this floor adds tremendous value and comfort. Modern conveniences elevate the entire home: central AC, a hybrid heating system with VLF electric and gas, state-of-the-art Toto self-cleaning toilets, and an elevator providing effortless access to all three levels. Completing the property is a private garage and thoughtfully designed outdoor spaces. This is more than a home—it’s a statement. A rare combination of high-end craftsmanship, innovative features, and timeless style. Come experience it in person and feel the difference the moment you walk through the door.

209-25 28th Avenue, Bayside

This Gorgeous brand-new brick home faces east, welcoming abundant morning sunlight. Located in the heart of Buyside top-rated School District 26, it sits on a prime section steps from Bell Blvd’s shops and restaurants, and just minutes to the LIRR station, with express service to Flushing and Manhattan. Property Highlights: East-facing orientation with bright, natural light throughout, All-brick construction with elegant architectural design Each floor features a 3-bedroom, 2-bathroom layout with open interiors Fully finished 9-ft high basement with separate entrance Outstanding Designed showcasing luxury and prestige Floor-to-ceiling windows for exceptional brightness Detached garage and wide private driveway Built with premium materials and modern finishes, offering both comfort and style Ideal for both self-use and investment!

6 Beds ⋅ 5 Baths ⋅ 978988 MLS

This Gorgeous brand-new brick home faces east, welcoming abundant morning sunlight. Located in the heart of Buyside top-rated School District 26, it sits on a prime section steps from Bell Blvd’s shops and restaurants, and just minutes to the LIRR station, with express service to Flushing and Manhattan. Property Highlights: East-facing orientation with bright, natural light throughout, All-brick construction with elegant architectural design Each floor features a 3-bedroom, 2-bathroom layout with open interiors Fully finished 9-ft high basement with separate entrance Outstanding Designed showcasing luxury and prestige Floor-to-ceiling windows for exceptional brightness Detached garage and wide private driveway Built with premium materials and modern finishes, offering both comfort and style Ideal for both self-use and investment!

3828 215th Street, Bayside

Welcome to this beautiful south-facing two-dwelling detached home in Whitestone. The front unit features a high-ceiling design, fully automated window shades, a primary bedroom with custom-built closets, and both front and rear balconies. The second unit offers 2 bedrooms and 2 bathrooms. The property includes a fully finished basement with 9-foot ceilings and a separate entrance. There is also a private garage and driveway that can accommodate multiple vehicles. The spacious backyard provides an ideal setting for outdoor activities. Conveniently located near supermarkets, restaurants, parks, schools, and public transportation.

6 Beds ⋅ 6 Baths ⋅ 975797 MLS

Welcome to this beautiful south-facing two-dwelling detached home in Whitestone. The front unit features a high-ceiling design, fully automated window shades, a primary bedroom with custom-built closets, and both front and rear balconies. The second unit offers 2 bedrooms and 2 bathrooms. The property includes a fully finished basement with 9-foot ceilings and a separate entrance. There is also a private garage and driveway that can accommodate multiple vehicles. The spacious backyard provides an ideal setting for outdoor activities. Conveniently located near supermarkets, restaurants, parks, schools, and public transportation.

147-25 18th Avenue, Whitestone

Heart of Buyside! top-rated School District 26, Brand New Luxury Brick Two Family sits on a prime section, steps from Bell Blvd’s shops and restaurants, and just minutes to the LIRR station, with express service to Main Street of Flushing & Midtown Manhattan. All-brick construction with elegant architectural design, Each floor features a 3-bedroom, 2-bathroom layout with open interiors. Fully finished 9-ft high basement with separate entrance Outstanding Designed showcasing luxury and prestige, Hardwood Floors through-out, Floor-to-ceiling windows for exceptional brightness, Private Backyard with beautiful landscaping. Detached garage and wide private driveway. Built with premium materials and modern finishes, offering both comfort and style!

6 Beds ⋅ 5 Baths ⋅ 962971 MLS

Heart of Buyside! top-rated School District 26, Brand New Luxury Brick Two Family sits on a prime section, steps from Bell Blvd’s shops and restaurants, and just minutes to the LIRR station, with express service to Main Street of Flushing & Midtown Manhattan. All-brick construction with elegant architectural design, Each floor features a 3-bedroom, 2-bathroom layout with open interiors. Fully finished 9-ft high basement with separate entrance Outstanding Designed showcasing luxury and prestige, Hardwood Floors through-out, Floor-to-ceiling windows for exceptional brightness, Private Backyard with beautiful landscaping. Detached garage and wide private driveway. Built with premium materials and modern finishes, offering both comfort and style!

38-36 215th Street, Bayside

This newly constructed two family home located at one of best areas in bayside , one block from bayside golf clubs and walking distance to little bay park, great air quality and great schools district, this very spacious home has 2000 SFT on the 1st floor and 2000 SFT basement and near 1900 SFT 2nd floor, 1st floor has 10 foot ceiling and a Double high contemporary design Living room Ceiling and can walk directly to the back yard which is great for any family events , open kitchen with European design cabinet, granite countertops and granite countertop island can serve up to 6-8 people, expensive tiles and hardwood floors finished , 3 huge master bedrooms with big closet and a half bath for the guests, 2nd floor 4 larger bedrooms and 3 full bath with open dine in kitchen, front and back balcony, laundry room, full basement with 2000 SFT of recreation and storage space beautiful tile floor and a full bathroom. Wash and dryer, high ceilings with lots windows, side and rear entrance, architectural design bricks exterior with stone blocks surrounding windows, full house spray foam insulations , clays roof design, expensive windows, steel doors, 2x6 frames structure. Detached garage and 10 foot driveway.

7 Beds ⋅ 7 Baths ⋅ 929611 MLS

This newly constructed two family home located at one of best areas in bayside , one block from bayside golf clubs and walking distance to little bay park, great air quality and great schools district, this very spacious home has 2000 SFT on the 1st floor and 2000 SFT basement and near 1900 SFT 2nd floor, 1st floor has 10 foot ceiling and a Double high contemporary design Living room Ceiling and can walk directly to the back yard which is great for any family events , open kitchen with European design cabinet, granite countertops and granite countertop island can serve up to 6-8 people, expensive tiles and hardwood floors finished , 3 huge master bedrooms with big closet and a half bath for the guests, 2nd floor 4 larger bedrooms and 3 full bath with open dine in kitchen, front and back balcony, laundry room, full basement with 2000 SFT of recreation and storage space beautiful tile floor and a full bathroom. Wash and dryer, high ceilings with lots windows, side and rear entrance, architectural design bricks exterior with stone blocks surrounding windows, full house spray foam insulations , clays roof design, expensive windows, steel doors, 2x6 frames structure. Detached garage and 10 foot driveway.

17-11 201 Street, Bayside

Heart of Buyside! top-rated School District 26, Brand New Luxury Brick Two Family sits on a prime section, steps from Bell Blvd’s shops and restaurants, and just minutes to the LIRR station, with express service to Main Street of Flushing & Midtown Manhattan. All-brick construction with elegant architectural design, Each floor features a 3-bedroom, 2-bathroom layout with open interiors. Fully finished 9-ft high basement with separate entrance Outstanding Designed showcasing luxury and prestige, Hardwood Floors through-out, Floor-to-ceiling windows for exceptional brightness, Private Backyard with beautiful landscaping. Detached garage and wide private driveway. Built with premium materials and modern finishes, offering both comfort and style!

6 Beds ⋅ 5 Baths ⋅ 923518 MLS

Heart of Buyside! top-rated School District 26, Brand New Luxury Brick Two Family sits on a prime section, steps from Bell Blvd’s shops and restaurants, and just minutes to the LIRR station, with express service to Main Street of Flushing & Midtown Manhattan. All-brick construction with elegant architectural design, Each floor features a 3-bedroom, 2-bathroom layout with open interiors. Fully finished 9-ft high basement with separate entrance Outstanding Designed showcasing luxury and prestige, Hardwood Floors through-out, Floor-to-ceiling windows for exceptional brightness, Private Backyard with beautiful landscaping. Detached garage and wide private driveway. Built with premium materials and modern finishes, offering both comfort and style!

3832 215th Street, Bayside

Welcome to this Brand New Built Luxury Two family located in Bayside School District 26. Features 7 bedrooms, 5 bathrooms, 2 half bath. Lot size 50*90 , Building size size 34.4*42.3. High Ceiling ,large open kitchen, marble radiant heated floor. Private driveway and full finished basement with separate entrance. Close to schools, Hmart, restaurants, buses and highways.

7 Beds ⋅ 7 Baths ⋅ 885782 MLS

Welcome to this Brand New Built Luxury Two family located in Bayside School District 26. Features 7 bedrooms, 5 bathrooms, 2 half bath. Lot size 50*90 , Building size size 34.4*42.3. High Ceiling ,large open kitchen, marble radiant heated floor. Private driveway and full finished basement with separate entrance. Close to schools, Hmart, restaurants, buses and highways.

20222 45th Drive, Bayside

$1,988,000

The Epitome of Modern Luxury Living in Beechhurst! Welcome to this beautifully landscaped, exquisite single-family residence offering over 2,000 square feet of interior living space plus a full finished basement. Fully updated and meticulously maintained, this home blends sophisticated design, high-end finishes, and thoughtful functionality at every turn. Step inside to a dramatic double-entry foyer with cathedral ceilings, leading to an open-concept layout. The inviting living area with a wood-burning fireplace creates the perfect ambiance for relaxing or entertaining, flowing seamlessly into an elegant dining area and a custom chef’s kitchen featuring quartz countertops and Viking appliances. Upstairs, the primary suite is a true retreat with a spa-inspired marble bathroom, while three additional bedrooms share another full marble bath, each with Toto Neorest toilets and luxurious finishes. The fully finished basement offers a versatile living space—ideal for a home office, gym, or media room. Step outside to a private backyard oasis, perfect for gatherings or quiet evenings under the stars, complete with an outdoor TV. Additional features include central heating and cooling, radiant heated floors throughout, and Control4 smart home technology that seamlessly manages indoor and outdoor multi-zone speakers, sprinklers, and Nest security cameras and thermostats. The home is further enhanced by Andersen windows, Juliet balconies, a one-car garage with private driveway, and a DaVinci slate roof that blends durability with timeless elegance. This Beechhurst residence truly represents the epitome of luxury living—a rare find offering comfort, technology, and style in perfect harmony.

4 Beds ⋅ 4 Baths ⋅ 932306 MLS

The Epitome of Modern Luxury Living in Beechhurst! Welcome to this beautifully landscaped, exquisite single-family residence offering over 2,000 square feet of interior living space plus a full finished basement. Fully updated and meticulously maintained, this home blends sophisticated design, high-end finishes, and thoughtful functionality at every turn. Step inside to a dramatic double-entry foyer with cathedral ceilings, leading to an open-concept layout. The inviting living area with a wood-burning fireplace creates the perfect ambiance for relaxing or entertaining, flowing seamlessly into an elegant dining area and a custom chef’s kitchen featuring quartz countertops and Viking appliances. Upstairs, the primary suite is a true retreat with a spa-inspired marble bathroom, while three additional bedrooms share another full marble bath, each with Toto Neorest toilets and luxurious finishes. The fully finished basement offers a versatile living space—ideal for a home office, gym, or media room. Step outside to a private backyard oasis, perfect for gatherings or quiet evenings under the stars, complete with an outdoor TV. Additional features include central heating and cooling, radiant heated floors throughout, and Control4 smart home technology that seamlessly manages indoor and outdoor multi-zone speakers, sprinklers, and Nest security cameras and thermostats. The home is further enhanced by Andersen windows, Juliet balconies, a one-car garage with private driveway, and a DaVinci slate roof that blends durability with timeless elegance. This Beechhurst residence truly represents the epitome of luxury living—a rare find offering comfort, technology, and style in perfect harmony.

1463 Burton Street, Whitestone

$1,980,000

Location Location Location! This Magnificent 5-bedroom, 3-bathroom Contemporary house is a homeowners dream. Quietly tucked away in a private cul-de-sac in the Weeks Woodland Section of Bayside this spacious property features PRIVACY and LUXURY at its best. Includes 2 working fire-places, a living room, family room, a large bedroom with full ensuite, separate dining areas, and an entertaining kitchen all on the first floor! Walk in through the beautiful double doors to a grand entrance. This 3 level home is welcoming and inviting. With a private living room featuring a wood-burning fireplace, to the right, a formal dining room to the left a custom-built gourmet kitchen featuring solid wood cabinetry, granite countertops, premium appliances, and refined finishes. Adjacent to the kitchen is a large Family Room featuring a gas burning fireplace. The home offers oversized rooms and expansive Floor to Ceiling Anderson windows which offer plenty of natural light, enhancing the home's inviting ambiance. 4 well appointed Bedrooms with custom built closets and 2 Full Baths are on the second level. Every detail in this home is thoughtfully designed and meticulously crafted. The home includes a fully finished basement with ceramic flooring and its own separate entrance. Step outside to a beautifully landscaped backyard, complete with a built-in outdoor kitchen, a wood-burning pizza oven, perfect for large parties and entertaining. This home offers: Private security system, Underground sprinkler system, a Water filtration-system, Jacuzzi tub and Sky-lights. Set in a very secluded area of Weeks Woodland, this is the perfect place to call home. A true hallmark of elegance with a touch of European flair—this home is a must-see!

5 Beds ⋅ 3 Baths ⋅ 987472 MLS

Location Location Location! This Magnificent 5-bedroom, 3-bathroom Contemporary house is a homeowners dream. Quietly tucked away in a private cul-de-sac in the Weeks Woodland Section of Bayside this spacious property features PRIVACY and LUXURY at its best. Includes 2 working fire-places, a living room, family room, a large bedroom with full ensuite, separate dining areas, and an entertaining kitchen all on the first floor! Walk in through the beautiful double doors to a grand entrance. This 3 level home is welcoming and inviting. With a private living room featuring a wood-burning fireplace, to the right, a formal dining room to the left a custom-built gourmet kitchen featuring solid wood cabinetry, granite countertops, premium appliances, and refined finishes. Adjacent to the kitchen is a large Family Room featuring a gas burning fireplace. The home offers oversized rooms and expansive Floor to Ceiling Anderson windows which offer plenty of natural light, enhancing the home's inviting ambiance. 4 well appointed Bedrooms with custom built closets and 2 Full Baths are on the second level. Every detail in this home is thoughtfully designed and meticulously crafted. The home includes a fully finished basement with ceramic flooring and its own separate entrance. Step outside to a beautifully landscaped backyard, complete with a built-in outdoor kitchen, a wood-burning pizza oven, perfect for large parties and entertaining. This home offers: Private security system, Underground sprinkler system, a Water filtration-system, Jacuzzi tub and Sky-lights. Set in a very secluded area of Weeks Woodland, this is the perfect place to call home. A true hallmark of elegance with a touch of European flair—this home is a must-see!

2957 214th Place, Bayside

Impeccably Maintained 2019 New Construction In The Heart Of Whitestone Featuring Water Views, High Ceilings, Oversized Windows, Rich Hardwood and Tile Floors, Central Vacuum And Exceptional Natural Light Throughout. Approximately 3,000 Total Square Feet of Beautifully Designed Living Space. Elegant Open Layout Includes Designer Eat-In Kitchen, Spacious Living And Dining Areas, Generously Sized Bedrooms, And Luxurious Primary Suite. Fully Finished Walkout Basement Offers Exceptional Additional Living Space. Beautifully Landscaped Property With Private Backyard And Expansive Patio. Conveniently Located Near Shopping, Dining, Schools, And Transportation. A Rare Turnkey Opportunity.

4 Beds ⋅ 4 Baths ⋅ 995865 MLS

Impeccably Maintained 2019 New Construction In The Heart Of Whitestone Featuring Water Views, High Ceilings, Oversized Windows, Rich Hardwood and Tile Floors, Central Vacuum And Exceptional Natural Light Throughout. Approximately 3,000 Total Square Feet of Beautifully Designed Living Space. Elegant Open Layout Includes Designer Eat-In Kitchen, Spacious Living And Dining Areas, Generously Sized Bedrooms, And Luxurious Primary Suite. Fully Finished Walkout Basement Offers Exceptional Additional Living Space. Beautifully Landscaped Property With Private Backyard And Expansive Patio. Conveniently Located Near Shopping, Dining, Schools, And Transportation. A Rare Turnkey Opportunity.

339 150th Street, Whitestone

This newly renovated, Extra Large, multi-family brick home has 3 stories plus a basement with a separate outdoor entrance and high ceilings; 1 Car Garage and Private Driveway. The first floor studio office space features an open layout with kitchen, and living room, and a separate room which can easily be converted to a 1 bedroom living space. While the 2nd & 3rd floors each have 3 bedrooms and 1.5 baths. You will enjoy this beautifully renovated space with top grade appliances, multiple ductless Mitsubishi Heat/AC units and beautiful floors, and the 2nd floor has a Terrace. This property is conveniently located in close proximity to the #7 Line & LIRR which affords you a 15 min. commute to NYC. This house is conveniently located close to a variety of Shopping and Dining and is in close proximity to Schools, Park, Queens Blvd & LIE. This property is suitable for Owner occupation with a large family, or as a rental property with exceptional Rental potential, or a combination of both. Comes with intercom and entrance buzzer. Appearance is Outstanding! This is a gem, because it needs no work at all, so it's in move in ready condition.

6 Beds ⋅ 5 Baths ⋅ 879494 MLS

This newly renovated, Extra Large, multi-family brick home has 3 stories plus a basement with a separate outdoor entrance and high ceilings; 1 Car Garage and Private Driveway. The first floor studio office space features an open layout with kitchen, and living room, and a separate room which can easily be converted to a 1 bedroom living space. While the 2nd & 3rd floors each have 3 bedrooms and 1.5 baths. You will enjoy this beautifully renovated space with top grade appliances, multiple ductless Mitsubishi Heat/AC units and beautiful floors, and the 2nd floor has a Terrace. This property is conveniently located in close proximity to the #7 Line & LIRR which affords you a 15 min. commute to NYC. This house is conveniently located close to a variety of Shopping and Dining and is in close proximity to Schools, Park, Queens Blvd & LIE. This property is suitable for Owner occupation with a large family, or as a rental property with exceptional Rental potential, or a combination of both. Comes with intercom and entrance buzzer. Appearance is Outstanding! This is a gem, because it needs no work at all, so it's in move in ready condition.

69-28 43rd Avenue, Woodside

Rare find mix use building in Prime location of Roosevelt ave, Jackson Heights. This building consist of one retail space (basement newly renovated) + 2 residential units. Retail Vacant, residential units has no lease left.. Prime location! 1 block away from 7 train Junction Blvd-subway station, close to major highways, shops, and restaurants, convenient to all. Great for 1031 exchange property or end user! SUPER LOW TAXES!

L3413708 MLS

Rare find mix use building in Prime location of Roosevelt ave, Jackson Heights. This building consist of one retail space (basement newly renovated) + 2 residential units. Retail Vacant, residential units has no lease left.. Prime location! 1 block away from 7 train Junction Blvd-subway station, close to major highways, shops, and restaurants, convenient to all. Great for 1031 exchange property or end user! SUPER LOW TAXES!

95-07 Roosevelt Avenue, Jackson Heights