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 = 3329 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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 = 3329 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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 = 3329 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;

2 Juniper Lane
Portsmouth, NH 03801

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $679,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active Under Contract
SqFt: 1575 Square Feet
Agency: Green & Company
Agency Phone: (603) 964-7572

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Range - Gas
Architectural Style: Other
Cooling: Central A/C
Flooring: Carpet, Wood
Heating: Forced Air
Interior Features: Kitchen Island, Programmable Thermostat, Ceiling Fan, Sprinkler System, Walk-in Closet, Dining Area, Primary BR w/ BA, Natural Light, Laundry Hook-ups, Laundry - 2nd Floor, Storage - Indoor, Living/Dining, Light Fixtures -Enrgy Rtd, Air Conditioner, Smoke Detectr-hrdwrdw/Bat
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Kitchen, Bonus Room

Window Features

Exterior Features: Deck, Window Screens, Windows - Energy Star
Parking Features: Garage, Underground/Basement, Assigned, Paved or Surfaced
Patio and Porch Features: Deck
Property Condition: New Construction
Roof: Shingle, Asphalt

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Juniper Commons

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Condominium
Year Built: 2023
Notes: NEW CONSTRUCTION! Welcome to Juniper Commons, a new 50-unit townhome pocket community in a great Portsmouth location. Abutting vast wooded conservation land, this beautifully landscaped community will feature three bedroom, three bath townhomes. The two-car garage entry leads into a finished first floor space ideal for an office, or mud/storage area. Up the hardwood stairs the living level is an inviting open layout with high ceilings, hardwood flooring, and great natural lighting. The spacious living and dining area opens to beautifully finished kitchens including cabinetry to the ceiling, pantry storage, oversized island, stainless appliances, and high end stone countertops. Sliding glass doors off the kitchen leads to a private deck space. The third floor has three bedrooms and two baths, including a primary suite with walk-in closet, and bath with tile shower and glass enclosure. Hardwood flooring throughout all bedrooms and living areas. Central air. Professionally landscaped community with community park, sidewalks, and trail leading to the lush wooded open space behind the homes for all to enjoy!
MlsNumber: --
ListingId: 4982652


Listing Provided By: Green & Company, original listing
Phone: (603) 996-1396
Office Phone: (603) 964-7572
Agent Name: Susan Green
Disclaimer: Copyright © 2024 PrimeMLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3329 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Real Estate Expert Photo for Hoda Crutchfield
Hoda Crutchfield
ASCIIGlover Agency
Call Today!: (586) 484-3806

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App