ML# :932932   Space, style and modern luxury come together at 196 Shepherd Avenue! A meticulously renovated fully detached two family nestled on a beautiful tree lined street of Cypress Hills. This turn key property is the perfect opportunity for buyers looking for space, plus income generating rental property to assist with mortgage payments. Configured as 3 bedroom 1 bath rental unit which has the ability to generate $3, 800/month over a 3 bedroom 1 bath garden unit, which can easily be used as a garden-basement duplex to create additional space. Both units enjoy expansive sunny & bright living/dining areas which provide great space for entertaining. Beautiful chefs granite kitchens equipped with floor to ceiling custom cabinetry and adorned with a full fleet of stainless steel appliances. Spacious bedrooms equipped with ample closet space, fully tiled bathrooms adorned with state of the art wall & floor tiles and much more! Must see to appreciate. Renovations include brand new flooring, recessed lighting, updated electrical, heating, and plumbing systems throughout. This masterfully re-imagined 2 family is conveniently located with close proximity to major transportation which makes commuting a breeze. Just off Fulton Street, Atlantic Avenue, Arlington Avenue. Short blocks to schools, shopping centers, restaurants, cafes, parks and many other vibrant neighborhood amenities.

ML# :931111   Brick Semi-Attached Two Family House in College Point. This well-maintained property offers both comfort and investment potential. The first floor features 3 bedrooms, 2 full bathrooms, along with a living room, dining area and kitchen. The second floor offers 4 bedrooms, 2 full bathrooms, a living room, dining area and kitchen. Enjoy outdoor living in the private backyard. Conveniently located near bus stop, supermarkets and shopping centers, this home provides comfort, versatility, and long-term value. Ideal for investors or owner-occupants seeking additional income.

ML# :930653   172-11 Horace Harding Expressway is a turn key, move in ready newly renovated brick single family. Situated on the border of Fresh Meadows & East Flushing!Wide Private driveway, & indoor garage. Perfect opportunity for buyers looking for space. 1st Floor - Expansive sun drenched formal living area provides great space for entertaining. The formal dining area is over looked by the beautiful granite kitchen any chef will love. Kitchen features floor to ceiling custom cabinetry and adorned with a full fleet of stainless steel appliances. Powder room on 1st floor for your guest. Up a flight of stairs onto the second floor 3 spacious bedrooms awaits you, each equipped with ample closet space. Down the hall a spacious fully tiled bathroom is adorned with state of the art wall & floor tiles.Renovations include brand new select wide oak wood flooring, updated electrical, heating & plumbing systems throughout.The high ceiling finished basement is setup to be used as storage space, home office, additional recreational space and leads into the indoor garage. 172-11 Horace Harding Expressway is conveniently located with close proximity to major transportation which makes commuting a breeze. Just off Utopia Parkway, Booth Memorial Avenue, 164 Street. Short blocks to schools, shopping centers, restaurants, cafes, parks and many other vibrant neighborhood amenities.

ML# :920900   Welcome to Your New Home at Grand 3 at Sky View Parc!This stunning resale condo offers an unparalleled living experience with breathtaking partial garden views from your private balcony.Featuring the most desirable split-bedroom layout, this home is designed for both comfort and privacy. The spacious master suite includes a walk-through closet and a luxurious en-suite bathroom.The open-concept, vented chef’s kitchen is equipped with Bosch stainless steel appliances, granite countertops, an in-sink macerator, a Latch smart lock, and a range hood vented to the outside—ideal for gourmet cooking. With 9-foot ceilings and hardwood floors throughout, every corner of this home exudes elegance and warmth.Entertain guests effortlessly in the expansive living and dining area, complete with a convenient in-unit washer and dryer. The second bedroom offers a generous closet and bright natural light, while an additional living room closet ensures easy organization.Building AmenitiesResidents of this full-service condominium enjoy resort-style amenities, including:• Landscaped terraces & BBQ grills• Tennis & basketball courts• Children’s playground & indoor playroom• Jacuzzi, steam room & sauna• 24/7 fitness center & running track• Seasonal outdoor swimming pool• 4-acre planted roof parkSecurity & LocationEnjoy peace of mind with 24-hour doorman service, on-site security, and surveillance cameras throughout the property. Conveniently located just two blocks from the #7 Train and LIRR, Sky View Parc offers effortless access to all of New York City’s major destinations.

ML# :913481   Turnkey 4-Bedroom Gem in Prime Upper Glendale!Welcome to this beautifully renovated and meticulously maintained legal 2-family home (used as 1) in one of Glendale’s most sought-after neighborhoods!Featuring:Modern kitchen with granite counters, stainless steel appliances & 6-burner gas stove.Spacious living room with gas fireplace & oversized bay window.Hardwood floors & recessed lighting throughout.Full basement with epoxy floors, new washer/dryer & updated boiler.Meticulous backyard with pavers & new 1.5-car garage.Driveway fits 5 cars!Major upgrades: new roof, windows, siding, stoops, hot water heater, patio, and more – even an ADT security system!This home offers space, style, and flexibility with endless possibilities. Just move in and start making memories.

ML# :904136   The Farrington, experience elevated living at one of the last remaining condominiums in Flushing offering property tax abatement. Enjoy exceptional value with property taxes as low as $30 per month during the abatement period, an ideal choice for both end-users and investors. This freehold property combines comprehensive amenities, thoughtful functionality and refined comfort. Features a 24-hour attended lobby with concierge, doorman service and video intercom for added convenience/security. Building is quipped with a state-of-the-art fitness center and an indoor swimming pool. There’s also a recreation room/media lounge and meeting/community rooms. Residents enjoy a landscaped rooftop terrace with panoramic views of Manhattan and Queens, complete with seating, grilling stations and lounge space. Many units also have their own private balcony. Available on-site garage parking and valet service. Notably, there are 15 electric vehicle supercharger stations. A dedicated bike room and package room. The base levels house retail and dining thanks to its integration with the attached hotel and mall, offering seamless urban convenience with access to premier dining and lifestyle options, including 3366doc Seafood Restaurant, Kaizen Japanese Restaurant, and an on-site winery. Don’t miss this rare opportunity to own a luxury residence in a high-demand location with substantial long-term benefits.

ML# :897624   This beautifully updated home in Plainview, set within the desirable Bethpage School District, truly has it all. From the moment you step inside, you’ll notice the attention to detail and tasteful updates throughout. This isn’t just a home...it’s a lifestyle!The kitchen is a standout—fully renovated with stainless steel appliances, granite countertops, all gas cooking, and an open layout that flows right into the living and dining spaces. It’s perfect for everyday living and effortless entertaining. Gorgeous hardwood floors have been redone throughout, giving the home a warm, polished feel.All of the bathrooms have been stylishly updated, and the windows are Andersens—bringing in great natural light while adding to the home’s energy efficiency. The exterior has also been refreshed & updated, offering great curb appeal.Out back, you’ll find a private oasis with a stunning inground saltwater pool and a spacious patio—ideal for relaxing or hosting, no matter the season.It’s a home that feels luxurious without trying too hard—updated, move-in ready, and made for easy living.

ML# :893858   Welcome to this meticulously maintained brick attached rowhouse, single family residence nestled in the vibrant heart of Woodside, Queens. This inviting home features covered porches in both the front and rear. It is thoughtfully upgraded and move-in ready. You’ll appreciate the spacious, light-filled interiors featuring hardwood floors, updated baths, a modern kitchen with stainless-steel appliances, and ample closet space. The main floor offers a spacious living room, formal dining room, a bright kitchen, and a convenient half bathroom. Upstairs, you’ll find three comfortable bedrooms and a full bathroom. A fully finished basement adds extra space, ideal for a home office or recreation area. Ideally situated near multiple transit options, including the 7, E, M, and R subway lines, Q18 and Q47 bus routes, and the LIRR Woodside Station, with quick access to BQE, LIE, and Queens Blvd. Enjoy proximity to shopping centers, public schools, Elmhurst Park, and other neighborhood amenities. This home delivers the perfect blend of comfort, convenience, and location.

ML# :899976   An open floor plan, set back on a hill, with a full finished basement with a bath and laundry room, oak floors under the carpet, quiet deck off the family room has great potential! Minutes to the LIRR, public transportation, shopping, great school district #26, The property is 67’ feet wide along little neck parkway and 150’ deep with a poured concrete foundation allows you the option to remodel, making a third bedroom, or building & extending the home......

ML# :895037   Prime College Point Two-Family Income-Producing Property — It features a 3-bedroom, 1-bath unit on the first floor, a 2-bedroom, 1-bath unit on the second floor, plus a walk-up attic with 2 bedrooms , complete with its own private entrance. The basement offers a half bath and walkout access to the backyard. Building size is 20x45, providing a total of 2, 600 sq ft of interior space. Low annual taxes of just $7, 262. Ideally located near Target, BJ’s, shopping, dining, and all neighborhood conveniences. College Point is one of NYC’s fastest-rising markets, brimming with potential. Only 12 minutes drive to downtown Flushing, with Q20/Q26/Q25 buses offering direct access to Main Street and the 7 train.