Title Page Background
DEBUG FN args: Array ( [0] => 1794 [1] => [2] => [3] => agent ) BEFORE: Site: 1794 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1794 Igate: njhud LocID: 1794 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1794 AND i.igate IN ('nmhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1794 [1] => [2] => [3] => lender ) BEFORE: Site: 1794 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1794 Igate: njhud LocID: 1794 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1794 AND i.igate IN ('nmhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1794 [1] => [2] => [3] => other ) BEFORE: Site: 1794 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1794 Igate: njhud LocID: 1794 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1794 AND i.igate IN ('nmhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

15 York Drive
Edison, NJ 08817

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $115,000
Beds: 1
Baths: Full: 1
Status: Active Under Contract
SqFt: --
Agency: BHHS Fox & Roach Princeton Junction
Agency Phone:

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Oven - Gas, Range - Gas
Architectural Style: Other
Cooling: Wall Unit(s) A/C
Flooring: Tile, Laminate, Tile - Ceramic
Heating: Baseboard
Interior Features: KITCHEN, DEN/STUDY, LIVING ROOM, DEN, 1 Bedroom, Bath Full
Rooms: Bathroom 1, Bedroom 1

Window Features

Exterior Features: Curbs, Sidewalk, Screen/Storm Window, Insulated Pane Windows
Roof: Asphalt

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Riverview

Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Stock Cooperative
Year Built: --
Notes: Tastefully upgraded second floor unit on a unique short courtyard in conveniently located Riverview Estates. Enjoy this comfortable one bed room co-op with a den, which can be and is set up as a second bedroom. A beautiful inground outdoor pool and very clean laundry facility are among other benefits of living in Riverview such as close to major highways, public transportation to NYC, shopping, restaurants, Rutgers Unv., Middlesex College and so much more. Why continue to rent when you can own for the same budgeted money. NO INVESTORS: ALL PURCHASED ARE SUBJECT TO BOARD APPROVAL; MINIMUM CREDIT SCORE AND INCOME TO DEBT RATIOS REQUIREMEMTS MUST BE MET.
MlsNumber: --
ListingId: 2307209R


Listing Provided By: BHHS Fox & Roach Princeton Junction, original listing
Phone: (732) 809-0999
Agent Name: James Sturgis
Disclaimer: Copyright © 2024 Berkshire Hathaway HomeServices Fox & Roach, Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App