Sign In

Close

x
Showing 1 of 0
X
Save
174 Mills Pond Road unit: 2D 2D Saint James NY 11780US2 Bed, 1.00 Bath (1 Full Bath), 938133
174 Mills Pond Road unit: 2D 2DSaint JamesNY11780
2400.0000 1/1/1900 12:00:00 AM
Realty Executives Power House
244-06 Jericho TurnpikeFloral ParkNY11001
516-437-8080
1 /

Courtesy of: Eric Gordon Ramsay IV, Eric G Ramsay Jr Assoc LLC, ericiv@ericramsay.com

174 Mills Pond Road unit: 2D 2D
Saint James NY 11780 US

Save
1 /

Courtesy of: Eric Gordon Ramsay IV, Eric G Ramsay Jr Assoc LLC, ericiv@ericramsay.com

Realty Executives Power House
244-06 Jericho Turnpike
Floral Park, NY, US 11001
516-437-8080

Get more info about this property

174 Mills Pond Road unit: 2D 2D
Saint James NY 11780 US

$2,400

Active Listing ID 938133
bed icon
2 bed
bath icon
1.00 Bath (1 Full)
lot icon
Lot: 1.35 Acres
home icon
Apartment

$2,400

Active Listing ID 938133
Save
3d icon
Maps

174 Mills Pond Road unit: 2D 2D 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 1.35 Acres
  • Property Type: Residential
  • Property Sub-type: Apartment
  • Features
  • Full Bathrooms: 1
  • Heating Fuels: Electric (Heating)

School Information

  • School
  • St James Elementary School(Elementary)
  • Nesaquake Middle School(MiddleSchool)
  • Smithtown High School-East(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Apartment
  • listprice: 2400
  • unparsedaddress: 174 Mills Pond Road unit: 2D
  • unitnumber: 2D
  • postalcity: Saint James
  • stateorprovince: NY
  • country: US
  • postalcode: 11780
  • bathroomsfull: 1
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 1.35
  • lotsizeunits: Acres
  • lotsizearea: 1.35
  • livingarea: 600
  • livingareaunits: Square Feet
  • latitude: 40.896065
  • longitude: -73.147285
  • listagentfullname: Eric Gordon Ramsay IV
  • listagentemail: ericiv@ericramsay.com
  • listagentkey: 3yd-MLSLINY-185626
  • listagentmlsid: 185626
  • listagentpreferredphone: 6313369563
  • listagentofficephone: 6313369563
  • listofficekey: 3yd-MLSLINY-RAMS01
  • listofficemlsid: RAMS01
  • disclaimer: Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MLSLINY
  • yearbuilt: 1947
  • listingcontractdate: 2025-11-21
  • listagenturl: http://www.ramsayrealtors.com
  • countyorparish: Suffolk County
  • parcelnumber: 0800-039-00-02-00-006-000
  • elementaryschool: St James Elementary School
  • highschool: Smithtown High School-East
  • elementaryschooldistrict: Smithtown
  • middleorjuniorschooldistrict: Smithtown
  • highschooldistrict: Smithtown
  • appliances: Cooktop, Refrigerator
  • constructionmaterials: Frame
  • heating: Electric (Heating)
  • fireplaceyn: False
  • transactiontype: ForRent
  • storiestotal: 0
  • parkingtotal: 0
  • waterfrontyn: False
  • franchiseaffiliation: Independent
  • interiorfeatures: Galley Type Kitchen
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bedroom 2, Bedroom 1
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -73.147285, 40.896065
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Eric G. Ramsay Jr. Associate LLC", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"ericiv@ericramsay.com", "ListBrokerageCity":"Bay Shore", "ListBrokerageCountry":"US", "ListBrokerageEmail":"rick@ericramsay.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/7f388d21636a11dfb28100219b9aa4d8/20100519134017246.png", "ListBrokerageName":"Eric G. Ramsay Jr. Associate LLC", "ListBrokeragePhone":"(631) 665-1500", "ListBrokeragePostalCode":"11706", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"236 West Main St", "ListBrokerageWebsiteUrl":"http://www.ramsayrealtors.com", "ListOfficeAddress1":"236 W Main St ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"RAMS01", "ListOfficeCity":"Bay Shore", "ListOfficeCountry":"USA", "ListOfficeEmail":"rick@ericramsay.com", "ListOfficePostalCode":"11706", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"APARTMENT - Other - Saint James, NY", "ListingURL":null, "MLSModificationTimestamp":"2025-11-22 07:13:39", "Neighborhoods":[], "PostalCode":null, "RoomCount":4, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 1/8/2026 6:53:08 PM GMT
Source Updated Date: 1/15/2026 6:46:38 PM GMT

Courtesy of: Eric Gordon Ramsay IV, Eric G Ramsay Jr Assoc LLC, ericiv@ericramsay.com

Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact