• Sign Up
  • Log In
Susan Camus | Imagine Properties
  • HOME
  • ABOUT
    • Learn More
    • Meet the Team
    • Reviews
  • LIST OF SERVICES
    • Union News
    • Services
  • MORTGAGE
    • Mortgage Calculator
  • COMMUNITIES
    • Areas
    • Community News
    • All Listings
    • Palm Beach County
    • New Jersey
  • IMAGINE HELP
  • BUYERS
    • Buying Tips
    • Featured Listings
    • Search New York Homes
    • Search New Jersey Homes
  • SELLERS
    • Home Valuation
  • INVESTORS
  • RESOURCES
    • Slattery Moving & Storage
    • Short Sale
    • Senior Real Estate
    • Probate
    • Articles
  • MORE
    • Florida
    • School Report
    • Real Estate Tips
    • Sold Properties
  • RITZ-CARLTON RESIDENCES
  • CONTACT

Susan Camus

(845) 398-1717
susan@ImagineProperties1.com
  • Susan Camus(845) 398-1717
    susan@ImagineProperties1.com
    Copy Email
  • 100 Dutch Hill Rd Suite 260
    Orangeburg , NY 10962

Home

  • HOME
  • ABOUT
  • LIST OF SERVICES
  • MORTGAGE
  • COMMUNITIES
  • IMAGINE HELP
  • BUYERS
  • SELLERS
  • INVESTORS
  • RESOURCES
  • MORE
  • RITZ-CARLTON RESIDENCES
  • CONTACT
Susan Camus | Imagine Properties - Footer Logo
  • Notice of Exclusive Property Listing
  • Notice of Exclusive Property Listing
  • Privacy
  • Terms
  • DMCA
  • Accessibility
  • Fair Housing
© 2026 Imagine Properties. All rights reserved.
Website built by CloseHack.
Northwest Multiple Listing Service

The information contained in this listing has not been verified by Northwest Multiple Listing Service (NWMLS) - WA and should be verified by the buyer.

Based on information submitted to the MLS GRID as of 2026-01-02 15:48:31. 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.

The database information herein is provided from and copyrighted by the Northwest Multiple Listing Service (NWMLS). NWMLS data may not be reproduced or redistributed and is only for people viewing this site. Listings that feature the "three tree" icon are provided courtesy of NWMLS. All information provided is deemed reliable but is not guaranteed and should be independently verified. All properties are subject to prior sale or withdrawal. All rights are reserved by copyright.

Copyright 2024 Northwest Multiple Listing Service. All rights reserved.

New Jersey Multiple Listing Service, Inc.

The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Susan Camus | Imagine Properties are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website. 

All information deemed reliable but not guaranteed. Last date updated: 01/09/2023

2023 New Jersey Multiple Listing Service, Inc. All rights reserved.  

Beaches MLS

© BEACHES MLS. All rights reserved. Information Deemed Reliable, but Not Guaranteed. Listing information is from various brokers who participate in IDX and not all listings may be visible on the site. The property information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

My Florida Regional MLS DBA Stellar MLS

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Some IDX listings have been excluded from this website. Listing Information presented by local MLS brokerage: Susan Camus | Imagine Properties

OneKey MLS

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

$588,000
For Sale

15038 Union Turnpike #3A

New York, NY 11367
2 beds | 1 bath | 0.88 acres | #946415
  • Save
  • Contact
  • Share
  • Price Change Alerts
20 photos
Type:Purchase
Structure:Condo
Zone:Residential

Description

Welcome to this newly renovated 2-bedroom condo offering comfort, style, and convenience. The home features a modern kitchen with stainless steel appliances, a bright and airy living room with a hardwood floor, and access to a large private balcony—perfect for everyday enjoyment. Both bedrooms are generously sized with ample closet space. The full-service condominium offers a 24-hour doorman, large outdoor pool, gym, laundry, clubroom, playground, BBQ area, and assigned indoor parking. Conveniently located near major highways, with an express bus to Manhattan just across the street and approximately 10 minutes by bus to the E/F subway lines. Close to St. John’s University, shopping, and parks. a Must See!

  • Interior Details
      • InteriorElevator, Entrance Foyer, Quartz/Quartzite Counters
    • Heating & Cooling
      • CoolingWall/Window Unit(s)
      • HeatingElectric
    • Beds & Baths
      • Bathrooms1.0
      • Bedrooms2
      • Full Baths1
  • Property Details
      • Stories12
    • Measurements
      • Acres0.8825
    • Parking
      • Parking FeaturesCommon
      • Parking TypeGarage
      • Parking Spaces1.0
      • Parking Garage1
  • Construction Details
      • Property TypePurchase
    • Condition
      • Year Built1973
  • Utilities / Energy Details
      • Utility FeaturesCable Connected, Electricity Connected, Natural Gas Connected, Phone Available, Sewer Connected, Trash Collection Private, Water
      • AppliancesExhaust Fan, Gas Oven, Gas Range, Microwave, Range, Refrigerator, Stainless Steel Appliance(s)
      • Sewer InformationPublic Sewer
      • Utility SourcePublic
  • Community and Neighborhood Details
      • Elementary SchoolPs 117 J Keld/Briarwood School
      • Middle SchoolJhs 217 Robert A Van Wyck
      • High SchoolHillcrest High School
      • School DistrictQueens 28
      • CountyQueens
  • Financial Details
      • Original List Price$588,000
      • Taxes Annual$3,214
      • Days on Market (Cumulative)7
    • HOA
      • Hoa719.63
      • Hoa Fees719.63
  • Restrictions
      • Pets AllowedNo Restrictions
  • Other
      • MLS #946415

Location

Legal

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Last Updated: Yesterday at 10:51 AM. Source: ONEKEY

Provided By
Listing Agent: Leonard Zheng SFR (#KEY188101)
Listing Office: Voro LLC (#KEYVORO01)

Susan Camus | Imagine PropertiesReal Estate Group
Facebook
Google
OR

Interested in Purchasing 15038 Union Turnpike #3A?

Get an estimate on monthly payments on this property.

Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

Estimated Monthly Payment
$0.00
Loan Amount
$0.00
$
years

Down Payment

$
%
10.0%

Interest Rate

%
6.0%

Tax Rate

%
2.6%
$
$
annually
$
monthly