Refine Search
Sort by
42-29 217th Street, Bayside
$1,900,000
7 Beds ⋅ 5 Baths ⋅ 973542 MLS
Bayside North – First Time On The Market! Rare Detached Legal 3 Family Opportunity! "Built To Last" by an old world craftsman! This custom-built Solid Brick & Block residence on a 50X100 lot has only had one owner. Built in 1969 as a 2 family it was legally converted to a 3 family in 2000. This residence features two 3 bedroom/2 bath units and a one 1 bedroom/1 bath unit, each with a private entrance. Long driveway, huge rear yard, built in one car-garage, and additional parking. Being delivered fully vacant with no existing leases, this is a great opportunity to collect current fair market rents either by owner occupants looking for an income, or investors. This home was originally designed and built for multi-generational living under one roof offering plenty of privacy. Prime Queens County location Near All NYC Conveniences and amenities. Top-Rated District #26 Public Schools, Public Transportation, L.I.R.R, Houses Of Worship, Public Parks, Great Shopping, A Plethora Of Nearby Options For Fine And Casual Dining of International Cuisines, Pubs and Cafes. Short Distance To The Bay Terrace Shopping Center, Oakland Lake, The Wide-open Greenspaces Of John Golden & Crocheron Parks. Pride Of Ownership Reflects Throughout This Community Of Well-Maintained Homes. This property is being sold As Is. All information comes from sources believed to be reliable but not guaranteed and should be INDEPENDENTLY verified by purchaser(s). This includes, but is not limited to the verification of the year built, legal use and occupancy, real estate taxes, neighborhood school information and current zoning. All measurements are approximate and are provided for general informational purposes only and may be subject to errors. All offers subject to financing must be accompanied by a current and legible preapproval letter together with proof of funds. All offers represented as no mortgage contingency or ALL CASH will also be required to provide proof of funds.

42-29 217th Street, Bayside

169-14 45th Avenue, Flushing
$1,900,000
3 Beds ⋅ 4 Baths ⋅ 978064 MLS
Welcome to this exquisite Spanish-style villa set on a 5,000 sq ft lot, offering 3 bedrooms and 4 bathrooms, complete with an attached garage and private driveway. A grand foyer welcomes you into sun-drenched interiors, where the open-concept living room seamlessly flows into an elegant formal dining area, centered around a sophisticated gas fireplace—perfect for refined entertaining. Crafted with exceptional attention to detail, this home features soundproof windows, insulated walls, radiant heated flooring, central AC/heating, and additional split systems for year-round comfort. The exterior showcases timeless terracotta roof tiles and beautifully landscaped grounds, creating striking curb appeal. The custom chef’s kitchen is a true showpiece, outfitted with top-of-the-line appliances, a stunning marble center island, and a distinctive copper sink. French doors open to a private backyard oasis featuring elegant pavers, lush greenery, a fully equipped summer kitchen, a charming pergola with ambient string lighting, and a custom-built fire pit—perfect for elevated outdoor living. The property is fully fenced, offering enhanced privacy. Upstairs, the luxurious primary suite features custom his-and-hers California walk-in closets and a spa-inspired bathroom with a double vanity. Two additional spacious bedrooms and a beautifully designed bathroom with a jacuzzi tub complete the level. Ideally located just one block from Northern Blvd for effortless commuting. See it to believe it—a rare opportunity to own.

169-14 45th Avenue, Flushing

43-24 Morgan Street, Little Neck
$1,900,000
4 Beds ⋅ 4 Baths ⋅ 973700 MLS
Rare opportunity to own a fully detached colonial with a legal doctor’s office on an oversized 108 x 100 lot (R2A zoning) in prime Little Neck, just off Northern Boulevard. The main residence features a gracious living room with fireplace, formal dining room, eat-in kitchen with breakfast nook, family room, three bedrooms plus an additional flex room, a finished walk-up attic with half bath, and a full finished basement—ideal for a home office, playrooms, guest quarters, a reading room and more. The professional office offers a separate entrance, reception, multiple exam rooms, break room, half bath and a finished lower level with additional exam, records or storage rooms. Enjoy a private, landscaped, fenced yard, patio, and a 2-car garage with attached covered access to the main residence. Exceptional, easily accessible location that delivers the perfect blend of residential privacy and professional convenience.

43-24 Morgan Street, Little Neck

2120 22nd Road, Astoria
$1,900,000
7 Beds ⋅ 4 Baths ⋅ 958649 MLS
Semi-detached brick four family building situated on a quiet residential block in Astoria. The property is comprised of three well proportioned two bedroom apartments and one one bedroom apartment, each with a functional layout and good natural light throughout. The building features a full basement, ideal for storage and mechanicals, along with a rare three car garage located at the rear of the property, offering added convenience and potential additional income. Conveniently located near Ditmars Boulevard, with easy access to neighborhood shops, dining, public transportation, and Astoria Park, this property offers a strong combination of location, unit mix, and amenities. A solid opportunity for investors or owner-users seeking a multifamily asset in one of Astoria’s most established residential areas.

2120 22nd Road, Astoria

24-56 Little Neck Boulevard, Bayside
$1,900,000
4 Beds ⋅ 3 Baths ⋅ 938928 MLS
Custom Designed Mediterranean Inspired Colonial Located In The Bayside Gables On An Oversized 80 X 103 Lot Featuring Five Levels Of Living Space. Main Level: A Grand Entryway With Granite Flooring, Double Hall Closet & Marble Powder Room, Formal Dining Room, Eat In Kitchen, Laundry Room, Den With Fireplace & Sliding Glass Doors Leading Out Onto A Brick Patio Ideal For Outdoor Dining & Entertaining. Circular Staircase Leading Up To Your Second Level Which Features A Living/Media Room With Vaulted Ceiling & Skylights Overlooking The Lush Gardens. One Flight Up To Your Third Level Boasting An Oversized Primary Bedroom Ensuite With Full Bath, Two Walk In Closets, Three Additional Bedrooms With Water Views & Balconies Overlooking Little Neck Bay. Fourth (Lower) Level Is Ideal For A Home Office, Gaming Room Or Yoga Studio. Fifth (Basement) Level Potential For A Customizable Gym/Recreation Space Including Storage Rooms. Conveniently Located Near All, Transportation To NYC & LI Via LIRR, Express Buses To Manhattan & Local Buses To Main Street, The Bay Terrace Shopping Center, Schools, Library, Movie Theater, Restaurants & Cafes Along Bell Boulevard... The Next Move Is Yours...

24-56 Little Neck Boulevard, Bayside

24563 61st Avenue, Little Neck
$1,900,000
6 Beds ⋅ 4 Baths ⋅ 936557 MLS
Discover a rare opportunity in the highly desirable Little Neck neighborhood! This oversized, all-brick two-family home sits on an approx. 4,800 sq ft lot with 2,757 sq ft of living space, zoned R3X ideal for end-users and investors alike. Layout: 1st Floor: 3 Bedrooms, 2 Full Baths. 2nd Floor: 3 Bedrooms, 1 Full Bath. Attic: High ceiling, open space, can be study room or play room, 1 Full Bath, Large Private Terrace. Basement: Fully Finished, Separate Entrance, big space, 1 Full Bath, Laundry Room. Extra-wide driveway + spacious backyard. Bright interiors with excellent layout and functionality. Quiet, well-maintained residential block. Located in Top-Rated District 26 PS221 & MS67 (both Blue Ribbon schools!). Close to Douglaston Golf Course, supermarkets, major highways, and public transportation. Perfect for multi-generational living or high-income rental potential.

24563 61st Avenue, Little Neck

3280 38th Street, Astoria
$1,900,000
8 Beds ⋅ 3 Baths ⋅ 845583 MLS
Welcome to this beautifully maintained 3-family Townhome in the heart of vibrant Astoria. Spanning 3,192 sq ft over three levels, this property offers spacious layouts, high ceilings, and sunlit interiors, blending modern comfort with timeless charm. Each of the three apartments features generous room counts, two of the units have updated kitchens and baths, and unique design touches perfect for both investors and end-users. The home includes a full basement with storage, washer/dryer, and access to a private backyard oasis ideal for relaxing or entertaining. Located on a tree-lined street near Kaufman Studios and the upcoming $2B Innovation Queens Development, you're steps from the R/M train (1 block), N/W train (6 blocks), and the shops, restaurants, cafes and nearby parks along Broadway. Don't miss this rare opportunity, schedule your private tour today!

3280 38th Street, Astoria

86-27 57th Avenue, Elmhurst
$1,880,000
7 Beds ⋅ 5 Baths ⋅ 943955 MLS
Welcome to this 3 family fully-detached all-brick home located in the heart of Elmhurst. This well-maintained family occupied property offers 7 bedrooms and 5 full bathrooms and was fully renovated 7 years ago. Featuring spacious open-layout floor plans, the home sits on a 25 x 100 lot with a 23 x 53 building size. The property includes a 1-car garage and private driveway. The 1st floor features: a living room, dining room, kitchen, 2 bedrooms, and a full bathroom. The 2nd floor features: a living room, dining room, kitchen, 3 bedrooms, 2 full bathrooms, and a balcony. The 3rd floor features: a living room, dining room, kitchen, 2 bedrooms, an additional open room (previously used as a third bedroom), 2 full bathrooms, a laundry room, and a balcony. The finished basement has a separate entrance with access to the backyard. Conveniently located near the M & R subway lines, buses, Queens Center Mall, parks, supermarkets, and local shops. Don’t miss this opportunity to own a home with strong income potential in a prime location. The house will be delivered vacant.

86-27 57th Avenue, Elmhurst

144-91 37th Avenue Avenue, Flushing
$1,880,000
7 Beds ⋅ 5 Baths ⋅ 923949 MLS
Welcome to 144-91 37th Avenue, Flushing – a well-maintained brick Two-family home in the heart of Downtown Flushing! This 3-story property features a first-floor and a second-floor 4-bedroom, 2.5-bath unit, and a third-floor 3-bedroom, 1.5-bath unit, offering excellent flexibility for investment or multi-generational living, plus with R6 zoning, you can make extra investment. The home includes a full basement for extra storage and a private built-in garage for added convenience. Ideally located just moments from shops, restaurants, supermarkets, schools, and medical facilities, this property also provides unbeatable access to transportation, including the Main St 7 Train, LIRR Murray Hill Station, and bus lines (Q12, Q13), making commuting throughout Queens and Manhattan effortless.

144-91 37th Avenue Avenue, Flushing

3970 45th Street, Sunnyside
$1,880,000
5 Beds ⋅ 3 Baths ⋅ 917019 MLS
Discover Serenity at a Sunnyside Gardens Sanctuary Welcome to a magnificent escape: a three-level, five-bedroom, three-bathroom townhouse perfectly situated in the historic Sunnyside Gardens landmark district. Set on a generous 25' x 100' lot, this home isn't just a residence; it's a tranquil, green sanctuary, offering a peaceful refuge from the city's intensity. Versatile Living and Private Retreats This exceptionally spacious home is configured for maximum flexibility across its distinct levels: First Floor: Features a welcoming foyer, a formal living room and dining room, a kitchen, and two full bedrooms. The Master Bedroom provides a lovely direct flow to a private patio to enjoy the courtyard, an ideal spot for outdoor entertaining and quiet relaxation. Second Floor: Accessible via a vestibule, this level includes a second formal living room, an eat-in kitchen, a full bathroom, and two more bedrooms. Third Level Potential: The second floor offers access to a high-ceiling attic—a space ripe with potential for development into a luxurious master bedroom suite. Walk-in Basement: This fully usable, high-ceiling level is currently configured with a recreation room, a bathroom, bedroom facilities, a separate laundry area, storage, and a utility room. It includes a convenient private rear exit connecting directly to the main courtyard. The home features a gas heating system with two boilers and two hot water heaters. Each floor has its own thermostat , giving the occupiers full control over the temperature on every level. Unbeatable Location and Exclusive Amenities This property effortlessly combines quiet living with ultimate city convenience: Exceptional Tranquility: Enjoy an astonishing level of peace on 45th Street (between 39th and 43rd Avenues). This block is specifically designed with little to no through traffic, ensuring the home remains extremely quiet and silent inside, creating a truly serene, suburban-like living experience. Effortless Commute: Despite the quiet setting, the city is within easy reach. You're just a short 15-minute ride to Midtown Manhattan and the United Nations via the #7 train. Excellent connectivity is further provided by the Q-32 & Q-60 bus lines on Queens Boulevard, offering simple access to Brooklyn and other boroughs. Vibrant Community: The surrounding area boasts a lively neighborhood vibe, with international restaurants, charming pubs, cafes, 24-hour supermarkets, and houses of worship all nearby. Exclusive Park Access: As a future owner, you gain membership to the private Sunnyside Gardens Park, granting access to unique amenities like bicycle tracks, skate ramps, tennis courts, and picnic areas. Don't let this unique opportunity pass you by! Embrace the joy of living in a historically rich, convenient, and wonderfully tranquil home. This isn't just a house; it's your escape.

3970 45th Street, Sunnyside

88-34 184 Street, Hollis
$1,880,000
9 Beds ⋅ 5 Baths ⋅ 885973 MLS
Opportunity Knocks! 88-29 184th Street is a BRAND NEW CONSTRUCTION, CUSTOM BUILT TWO FAMILY home that will captivate you from the moment you arrive with its warm & welcoming energy. Sitting on a beautiful tree lined street of the Hollis/ Jamaica Estates border. Sitting on a 40x100 lot, and spans over 4,400 sq/ft of living space! Perfect opportunity for buyers looking for Space and income producing rental income to assist with mortgage payments. Configured as a 5 bedroom 3 bath DUPLEX over a 4 bedroom 2 bath rental unit plus a high ceiling full finished basement with both interior & exterior access. Both units enjoy expansive sun drenched, modern open concept living/dining areas which provide great space for entertaining. Stunning chefs granite kitchens equipped with floor to ceiling custom cabinetry, adorned with a full fleet of stainless steel appliances & equipped with island for bar stool seating. Spacious bedrooms with ample closet space. The elegant primary suite is equipped with a private en suite with spa like finishes. Down the hall a fully tiled bathroom is shared between the additional bedrooms and equipped with state of the art wall & floor tiles. Construction includes brand new select wide oak wood flooring, recessed lighting, central HVAC systems throughout. 88-29 184th Street is conveniently located with close proximity to major transportation which makes commuting a breeze. Stones throw to F train subway line at 179 street station. Short blocks to Midland Parkway, 188 Street, Grand Central Parkway. Wide array of shopping centers, restaurants, cafes, parks and many other vibrant neighborhood amenities.

88-34 184 Street, Hollis

100-33 Metropolitan Avenue, Forest Hills
$1,880,000
8 Beds ⋅ 6 Baths ⋅ 873142 MLS
Welcome to Forest Hills! Brick Mixed-use building on Metropolitan Ave. consists of a Storefront/Office, 4 Apartments, a Full Basement, Backyard and 2 Detached garages accessible on Olcott Street. The Building offers a total building size of approx. 3,600 square feet and a lot area of 2,519 square feet. It features 1,200 square feet on both the lower and first floors, along with additional 2,400 square feet on the second and third floors. The lower level space in the basement is used by the first floor tenant. Located in highly desirable location in Forest Hills with heavy vehicular traffic, the property enjoys high visibility and accessibility. It is perfectly positioned with sunny Southern exposures. Tenants pay all the utilities, except water and sewer. Each unit has own individual boiler and hot water heater. Hardwood floors throughout. Storefront has two bathrooms. Shown by appointment. Call today! Building size 20 x 60 Lot size 20 x 123.51 IRR Zoning: R3-2, R3A, Overlay C1-3 Built in 1930 Call for more information.

100-33 Metropolitan Avenue, Forest Hills

151-65 26 Avenue, Flushing
$1,875,000
4 Beds ⋅ 3 Baths ⋅ 926693 MLS
Welcome to this one-of-a-kind, custom built, fully renovated home in the highly desirable area of Flushing North! Here you will find an exclusive, SOUTH-FACING BRICK contemporary home, set on a 60'X95' lot. Property highlights include: •high efficiency RADIANT FLOOR HEATING through-out •3 zone RHEAM CENTRAL AIR •GOURMET CHEF'S KITCHEN •48” WOLF gas range •3 WOLF ovens (1 built-in) •SUB-ZERO refrigerator •SUB-ZERO 81-bottle 2 zone wine cooler •BOSH dishwasher •DACOR warming drawer •BROAN 1500 CFM range hood •Filtered water pot filler •Filtered water ice maker •Filtered water tap with INSTAHOT •impressive 5'x8' GRANITE ISLAND (seats 6) •TRAVERTINE/MARBLE flooring •dual PELLA sliding glass doors with integrated blinds providing access to the EXPANSIVE GRANITE DECK •Private PRIMARY BEDROOM SUITE •SPA-STYLE MARBLE PRIMARY BATH •oversized AIR TUB with mood lighting •DOUBLE VANITIES •WALK-IN SHOWER •private MARBLE WATER CLOSET •oversized WALK-IN CLOSET •additional 2ND FLOOR LAUNDRY hook-ups. Three very SPACIOUS ADDITIONAL BEDROOMS with MIRRORED DOUBLE CLOSET DOORS and an ADDITIONAL SPA BATHROOM round out the upstairs living quarters. Other property highlights include: •45 foot GRANITE DECK •main floor BONUS OFFICE •partially FINISHED BASEMENT •BONUS BASEMENT (unfinished) with 2 OUTSIDE ENTRANCES (approximately 40'X15') •ANDERSON windows •custom Honduran MAHOGONY doors through-out •intricate IRONWORK RAILINGS •CATHEDRAL ENTRY foyer •up to 10 FOOT CEILINGS •GAS FIREPLACE with remote control •CRYSTAL chandelier •VIDEO surveillance and ALARM systems •commercial FIRE ALARM system •video INTERCOM •CENTRAL VACCUM •HARDWIRED HIGH-SPEED INTERNET/TV/PHONE cables throughout •pre-wired 7.2 SURROUND SOUND in several rooms •pre-wired WHOLE HOUSE SOUND •FIOS and SPECTRUM wired •full sun 35' VEGETABLE GARDEN with compost •up to 6 CAR PARKING on premises •deep GARAGE. This exquisite owner designed residence truly checks every box — with premium appliances, contemporary technology, architectural details and ample space to entertain. Whether you're hosting 18 in the opulent 16' dining room, relaxing on the sun-drenched 40'x15' granite deck, or enjoying music in every room, this home offers luxury and lifestyle without compromise! Enjoy beautiful BOWNE Park and MEMORIAL FIELD just two minutes away! Commuting is a breeze with the QM-2 NYC Express Bus and Q-15 bus to Main Street, under ten minutes to the LIRR station for travel into Manhattan or Long Island! Shops, cafes, restaurants, schools, houses of worship, all within easy reach. Schedule your private tour today!

151-65 26 Avenue, Flushing

23-25 28 Street, Astoria
$1,875,000
7 Beds ⋅ 4 Baths ⋅ 857143 MLS
Welcome to 23-25 28th Street – A Rare Four-Family Gem in the Heart of Astoria’s Coveted Ditmars Area! Don’t miss this exceptional opportunity to own a legal four-family home in one of Queens’ most desirable and vibrant neighborhoods. Perfectly situated in the heart of Astoria, this property offers unparalleled access to everything Ditmars Boulevard has to offer — from world-class dining, cozy cafes, and boutique shopping to top-rated schools and effortless access to public transportation (just minutes to the N/W trains). This well-maintained property features three spacious two-bedroom apartments and one charming one-bedroom unit, making it a perfect investment for those seeking strong rental income in a high-demand area. In addition, you’ll find a full basement, a private one-car garage, and a side yard, offering ample storage, parking, and outdoor space. Highlights Include: Prime Astoria location near Ditmars Blvd Legal four-family residence Three 2-bedroom apartments + One 1-bedroom apartment Full basement with great potential One-car garage + side yard Ideal for investors or end-users seeking rental income Astoria is known for its rich cultural heritage, energetic atmosphere, and unbeatable convenience. Ditmars Boulevard is especially treasured by locals for its vibrant food scene, tree-lined blocks, and strong community feel, making it one of the most sought-after enclaves in Queens. Apt #1R(2 Bedroom) $2600 rent 2 bed Lease expires Oct 15 #2F(2 bedroom) $2200 no lease Apt #1F (1Bedroom) $2200 lease expires May 30th Moving out will be vacant on June 30th Apt #2R (2Bedroom) $2100, (will be vacant) No lease month-to-month One-car Garage Monthly Rent: $275 Whether you’re looking to expand your investment portfolio or establish roots in a thriving neighborhood, 23-25 28th Street is a rare find you won’t want to miss!

23-25 28 Street, Astoria

2826 215th Street, Bayside
$1,870,000
4 Beds ⋅ 3 Baths ⋅ 982225 MLS
Stunning contemporary single-family home located in the highly desirable Bayside (Bay Terrace area). Situated on a 52'x119' lot (approx. 6,188 SF) with approximately 3,528 SF of interior living space, this beautifully renovated residence offers luxury, space, and convenience. The home features 4 bedrooms and 3 full bathrooms, highlighted by an open-concept layout with a spacious dining area and a designer island kitchen equipped with high-end materials and appliances. The kitchen and entertainment area include a custom wet bar, wine cooler, dishwasher, and refrigerator, and open to a covered brick patio—perfect for indoor-outdoor living. The second-floor primary suite offers skylights, ample closet space, and a spa-quality bathroom, with access to a private tiled balcony. Additional highlights include three generously sized bedrooms, a comfortable sitting area with fireplace, laundry area, and a kitchenette for added convenience. Conveniently located near Bay Terrace Shopping Center, with easy access to supermarkets, restaurants, and daily amenities. Close to QM2 Bus, QM20 Bus, Q13 Bus, Q28 Bus, and Q16 Bus, as well as the LIRR for a convenient commute to Manhattan and Flushing. Enjoy proximity to Fort Totten Park and Bayside Marina, offering waterfront views, outdoor recreation, and a relaxed lifestyle. A rare opportunity to own a move-in ready luxury home in one of Bayside’s most sought-after locations.

2826 215th Street, Bayside

28-24 214th Street, Bayside
$1,865,000
3 Beds ⋅ 3 Baths ⋅ 988394 MLS
Rebuilt in 2004, this stunning residence sits on an oversized 7,700+ sqft lot on the desirable Weeks Woodland / Bayside Gables border. Beautiful spring trees and lush landscaping create exceptional curb appeal, complemented by premium Pella windows and doors and elegant copper gutters. Inside, a grand foyer leads to a formal living room with access to a sunlit enclosed porch, while a gallery hallway opens to a formal dining room with French doors to the same garden-view porch. The main level also features custom shelving, a powder room, home office, and a spacious eat-in chef’s kitchen with stone countertops, stainless steel appliances, and ample cabinetry, flowing into a bright family room with direct backyard access. Upstairs offers three spacious bedrooms, including one with a private balcony, plus a luxurious primary suite with a walk-in closet and spa-like bath. The finished basement provides flexible space for a gym or additional living area, along with laundry and storage. Additional highlights include central air, built-in speakers, and updated finishes throughout. The beautifully landscaped yard features lush grass, vibrant gardens, and a large patio, plus a long private driveway and two-car garage. This exceptional home seamlessly combines elegance, comfort, and high-quality craftsmanship.

28-24 214th Street, Bayside

14209 45th Ave, Flushing
$1,860,000
6 Beds ⋅ 5 Baths ⋅ 914383 MLS
Welcome to 14209 45th Avenue Flushing, a fully renovated brick two-family Detached home on a spacious 3,000 sq. ft. lot, just a short 10-minute walk to the lively Main Street, Flushing. Thoughtfully updated from top to bottom, this home seamlessly blends modern luxury with practical functionality, making it ideal for multigenerational living or as a smart investment opportunity. Every detail has been thoughtfully updated, including a brand-new roof, gutters, windows, electrical system, plumbing, boiler, and water heater. The first and second floors feature completely redone framing, walls, ceilings, and stunning new hardwood floors throughout. First Floor: Spacious living areas with an open, airy layout Beautifully designed brand-new kitchen Two full bathrooms, including one of the largest bathrooms per floor Second Floor: Large living room and three bedrooms Extra-large bathroom plus a second full bathroom Modern kitchen with ample space and style Basement: Fully finished with a bathroom and washer/dryer room Brand-new boiler for efficient heating Step outside to a private yard, perfect for entertaining friends and family, and enjoy the convenience of a one-car carport—an invaluable feature in such a bustling area where parking is always a challenge. This exceptional home offers move-in-ready comfort, modern upgrades, and a prime location in Flushing—truly a rare opportunity!

14209 45th Ave, Flushing

7442 43rd Avenue, Elmhurst
$1,850,000
7 Beds ⋅ 5 Baths ⋅ 1008864 MLS
Presenting a solid brick two-family home nestled in the heart of Elmhurst, offering an exceptional value-add opportunity with tremendous income potential. Spanning a total of 3,300 square feet, this property is perfectly configured for an investor or an owner-occupant looking to offset their mortgage. The top two floors each feature a spacious 3-bedroom, 1.5-bathroom layouts, with both units boasting a large balcony—ideal for outdoor space. The first floor has a spacious 1 bedroom and a full bathroom with access to the backyard. Additional value lies in the finished basement, ready for customization or extra storage. With a one-car garage and private driveway, this home checks every box for convenience. Located close to the E, F, M, R, and 7 trains, this is exactly the kind of solid, income-producing asset that rarely stays on the market long. Bring your vision and unlock its full potential.

7442 43rd Avenue, Elmhurst

246-12 Cambria Avenue, Little Neck
$1,850,000
4 Beds ⋅ 4 Baths ⋅ 1005941 MLS
Rare custom-built brick Colonial in a prime Queens location. Built in 2015, this well-maintained home offers approximately 2,800 SF of living space on a 5,200 SF lot, featuring central A/C, high ceilings, hardwood floors, radiant heated floors, and bright north-south exposure. The first floor includes a living room, dining area, family room, gourmet kitchen with cherry cabinetry, and 1 full bath. The second floor offers 3 bedrooms and 2 full baths, including a primary suite with Jacuzzi tub and separate shower. The walk-in finished basement has a separate entrance, 2 rooms, and 1 full bath. Additional highlights include a new boiler system, 2-car garage, landscaped garden, and approved property tax reduction, with 2027 taxes expected around $13,000. Conveniently located near District 26 schools, shops, New World Supermarket, restaurants, LIRR, and Q12/N20G buses to Flushing. Approx. 25 minutes to Manhattan by train. A rare opportunity offering custom quality, flexible use, rental potential, and excellent transportation convenience.

246-12 Cambria Avenue, Little Neck

2123 Amory Court, Ridgewood
$1,850,000
6 Beds ⋅ 2 Baths ⋅ 980239 MLS
Stunning Renovated Two-Family Home with Manhattan Views | Ridgewood–Bushwick Border Welcome to Unique 21-23 Amory Ct ,Ridgewood ,NY 11385 This exceptional, fully renovated luxury two-family residence is ideally situated in prime Ridgewood, right on the border of vibrant Bushwick. Offering breathtaking Manhattan skyline views and delivered vacant at closing, this rare opportunity is perfect for both end-users and savvy investors. Spanning approximately 3,300 square feet of thoughtfully designed living space on a 2,991 sq. ft. lot, this expansive home features 6 generously sized bedrooms and 2 full bathrooms, all within flexible R5B zoning. The first and second floors showcase a seamless open-concept layout, effortlessly connecting the eat-in kitchen, dining area, and living room—ideal for both everyday living and entertaining. Enjoy hardwood floors throughout, updated windows, and a beautifully appointed granite kitchen complete with an oversized island. Each level includes three spacious bedrooms and a full bathroom. The fully finished, ground-level basement offers a separate entrance and exceptional versatility—perfect for a recreation room, home office, gym, media lounge, or extended living space, with abundant storage throughout. Step outside to a large private backyard, ideal for entertaining or relaxing, along with the added convenience of a private long driveway and front-facing garage. Located near Bushwick and Williamsburg, you’ll enjoy immediate access to some of Brooklyn’s best dining, shopping, and nightlife. Commuting is effortless with nearby L and M subway lines, multiple bus routes, and easy access to major highways including the LIE and BQE, as well as LaGuardia and JFK Airports. Surrounded by parks, schools, fitness centers, and everyday conveniences, this property offers the perfect blend of comfort, connectivity, and vibrant city living. Move-in ready and impeccably maintained, this home is a rare find—offering both luxury and lifestyle in one exceptional package.

2123 Amory Court, Ridgewood

10876 38th Avenue, Corona
$1,850,000
9 Beds ⋅ 4 Baths ⋅ 961057 MLS
Prime income-producing asset in the heart of Corona! This legal 4-family sits in one of Queens’ strongest rental corridors, driven by transit access, commuter convenience, and proximity to major landmarks. This detached, brick quadruplex offers 4000 square feet plus a full basement with two outside entrances. With three 2 bedroom units with living room, dining area, EIK and full bath, and a 3 bedroom unit featuring a living room, dining room, full bath, and EIK, this property is the perfect investment to add to your portfolio. Positioned just minutes from Mets–Willets Point LIRR Station (~1 mile), 7 Train at 103 St–Corona Plaza, Bus routes Q23, Q58, and Q14 within close proximity, Citi Field & Flushing Meadows–Corona Park, Major highways including Grand Central Parkway & Van Wyck, LaGuardia Airport (~10 minutes), JFK Airport (~20–25 minutes). Unmatched connectivity to Manhattan, Nassau County, and surrounding boroughs keeps tenant demand high year-round! Whether you’re looking to secure stable cash flow or add a Queens multi-family to your portfolio, this is the type of asset that builds long-term wealth!

10876 38th Avenue, Corona

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of . 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.