174 Mills Pond Rd, Unit 2D

600 Sq. Ft.
$44 / Sq. Ft.
600
Sq. Ft.
$44
per Sq. Ft.

Description

Updated and spacious two bedroom apartment with occupancy available immediately! Located with close proximity to Stony Brook University with all utilities included besides cable and Wi-Fi.Updated and spacious two bedroom apartment with occupancy available immediately! Located with close proximity to Stony Brook University with all utilities included besides cable and Wi-Fi.
  1. Listed by Eric Gordon Ramsay IV • Eric G Ramsay Jr Assoc LLC
    P: (631)-665-1500 C: (631)-336-9563 ericiv@ericramsay.com

Property Details for 174 Mills Pond Road, Unit 2D

City/Township
Smithtown
Architectural Style
Traditional
Waterfront
No
Pets Allowed
No
LISTING UPDATED: 02/03/2026 02:04 AM

Property Details for 174 Mills Pond Road, Unit 2D

StatusClosed
MLS #938133
Days on Market73
Rental Incentives-
Costs & Fees-
Available Date11/21/2025
Lease TermLease Length: 12 Months
Furnished-
Compass TypeApartment
MLS TypeApartment
Year Built1947
Lot Size1.35 AC / 58,806 SF
CountySuffolk County

Location

Listing Courtesy of Eric G Ramsay Jr Assoc LLC, Eric Gordon Ramsay IV
Add your commute

Building Information for 174 Mills Pond Road, Unit 2D

Stories-Residences-Year Built1947Lot Size1.35 AC / 58,806 SF

Property Information for 174 Mills Pond Road, Unit 2D

Summary
Location and General Information
  • Senior Community YN: No
  • Property Attached: No
  • Structure Type: false
  • State Or Province: NY
School Information
  • School District: Smithtown
  • Elementary School District: Smithtown
  • Elementary School: St James Elementary School
  • Middle Or Junior School District: Smithtown
  • Middle Or Junior School: Nesaquake Middle School
  • High School District: Smithtown
  • High School: Smithtown High School-East
Rental
Rental
  • Lease Term: 12 Months
  • RentSpree Y/N: false
Taxes and HOA Information
Taxes and HOA Information
  • Parcel Number: 0800-039-00-02-00-006-000
  • Association: No
Interior and Exterior Features
Interior Features
  • Amenities: Galley Type Kitchen, Public, Traditional
  • Interior Features: Galley Type Kitchen
  • Appliances: Cooktop, Refrigerator
  • Total Rooms: 4
  • Attic Description: None
  • Location Amenities: Galley Kitchen
  • Living Area: 600.00
  • Basement: No
Exterior Features
  • Exterior Property Features: Common
  • Elevation Certificate: No
  • Construction Materials: Frame
Lot Information
  • Building Area Units: Square Feet
Parking
  • Parking Features: Common
  • Garage: No
  • Carport: No
Utilities
  • Cooling: None
  • Heating: Electric
  • Heat Fuel Type: Electric
  • Sewer: Cesspool
  • Water Source: Public
  • Utilities: Electricity Connected, Water Connected
Green Features
  • Green Features: Cooktop, Refrigerator, Electric

Property History for 174 Mills Pond Road, Unit 2D

DateEvent & SourcePriceAppreciation
Feb 2, 2026

Rented

ONEKEY #938133

$2,200
Nov 21, 2025

Listed (Active)

ONEKEY #938133

$2,400
Nov 16, 2025

Expired

ONEKEY #902658

$2,400
Oct 16, 2025

Temporarily Off Market

ONEKEY #902658

$2,400
Aug 22, 2025

Listed (Active)

ONEKEY #902658

$2,700
Jun 1, 2020

Rented

ONEKEY #3213814

Jun 1, 2020

Temporarily Off Market

ONEKEY #3213814

Jun 1, 2020

Contract

ONEKEY #3213814

Jun 1, 2020

Rented

ONEKEY #3213814

$1,025
Jun 1, 2020

Pending

ONEKEY #L3213814

Jun 1, 2020

Contract

ONEKEY #3213814

Jun 1, 2020

Rented

ONEKEY #3213814

$1,025
May 4, 2020

Listed (Active)

ONEKEY #3213814

$1,025
May 4, 2020

Listed (Active)

ONEKEY #3213814

$1,025
DateEvent & SourcePrice
02/02/2026

Rented

ONEKEY #938133

$2,200
11/21/2025

Listed (Active)

ONEKEY #938133

$2,400
11/16/2025

Expired

ONEKEY #902658

$2,400
10/16/2025

Temporarily Off Market

ONEKEY #902658

$2,400
08/22/2025

Listed (Active)

ONEKEY #902658

$2,700
06/01/2020

Rented

ONEKEY #3213814

06/01/2020

Temporarily Off Market

ONEKEY #3213814

06/01/2020

Contract

ONEKEY #3213814

06/01/2020

Rented

ONEKEY #3213814

$1,025
06/01/2020

Pending

ONEKEY #L3213814

06/01/2020

Contract

ONEKEY #3213814

06/01/2020

Rented

ONEKEY #3213814

$1,025
05/04/2020

Listed (Active)

ONEKEY #3213814

$1,025
05/04/2020

Listed (Active)

ONEKEY #3213814

$1,025

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Schools near 174 Mills Pond Road, Unit 2D

This home is within Smithtown Central School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Public - 6 to 8
Rating
School
Distance
Saint James Elementary School
PublicK to 5

Nesaquake Middle School
Public6 to 8

Smithtown High School East
Public9 to 12

Great Hollow Middle School
Public6 to 8

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the owner. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Eric G Ramsay Jr Assoc LLC, Eric Gordon Ramsay IV

Based on information submitted to the MLS GRID as of 02/03/2026 02:04 AM. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively 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. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.