Title Page Background
HFQUERY 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 = 1776 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1776 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1776 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

207 2nd St
Hoboken, NJ 07030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,290,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1291
Agency: Keller Williams City Life JC Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: 207 2nd Street is an intimate 8-unit building, offering a serene escape and privacy with only two homes per floor. Built in 2009, an elevator building in downtown Hoboken, this 3-bedroom, 2-bathroom condominium offers a lifestyle of unparalleled convenience. This condo boasts an inviting layout flooded with natural light, with expansive bay windows in the living area and primary bedroom. Entertain in style with a seamless open floor plan, delineating distinct living and dining spaces. Three generously sized bedrooms are perfect for guests or a growing family. The exquisitely designed kitchen, adorned with sleek white maple cabinetry, luxurious granite countertops, and a stunning limestone backsplash. A spacious breakfast bar, under-cabinet lighting, and GE Profile Series stainless steel appliances round out the design. The primary bedroom is a sanctuary, ample space for a king-sized bed, an en-suite bathroom with a granite countertop vanity and contemporary tile design. Organization is effortless with custom closets throughout, while recessed lights add a touch of modern elegance. Enjoy the convenience of in-unit washer/dryer and a separate needed storage space. Additional highlights include central heat/AC, an on-demand tankless hot water heater, three ceiling fans, and oak hardwood floors with a charming mahogany inlay border. Take advantage of the building's elevator and common outdoor space, perfect for enjoying fresh air and mingling with neighbors. With multiple parking garages within walking distance, bustling Washington Street, and the Hoboken Path, urban convenience right at your door.
MlsNumber: 240007261


Listing Provided By: Keller Williams City Life JC Realty, original listing
Name: Keller Williams City Life JC Realty
Phone: (201) 433-1111
Office Name: KELLER WILLIAMS CITY LIFE JC REALTY
Office Phone: (201) 433-1111
Agent Name: JAMES CAHILL
Disclaimer: Copyright © 2024 Hudson County Multiple Listing Service. 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