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

60 Kunigunda Place
Islip Terrace, NY 11752

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 5
Baths: 3
Status: Pending
SqFt: 2054
Agency: HomeSmart Premier Living Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1987
Notes: **LOCATION LOCATION**NEW LISTING HIGH RANCH STYLE HOME, SITS ON 60 KUNIGUNDA PL, ISLIP TERRACE WITH EAST ISLIP DISTRICT SCHOOL!! THIS HUGE HOUSE OFFERS ON THE MAIN FLOOR A SUNDRENCHED MODERN KITCHEN THAT FEATURES WALLS/BASE SOLID WHITE CABINETS, CARRARA WHITE QUARTZ COUNTER TOPS, SS APPLIANCES INCLUDED REFRIGERATOR, STOVE, DISHWASHER AND MICROWAVE, GOLD GLASS BACKSPLASH, CONFY LARGE LIVING ROOM, YOU WON'T FEEL CROWDED IN THE LARGE OPEN LAYOUT CONCEPT AND SPACIOUS DINING AREA WITH OVERSIZED WINDOW TO THE BACKYARD, AMAZING SOCIAL AREA WHEN HAVING FAMILY OVER THE HOLIDAYS!! A MASTER BEDROOM SUITABLE FOR A KING-SIZE BED, EN-SUITE FULL TUB BATHROOM WITH TILE AROUND THE SHOWER. THE SECONDARY BEDROOM IS A KING/QUEEN-SIZED BED, THE THIRD BEDROOM IS A FULL/TWIN XL BED SIZE. KIDS FULL TUB BATHROOM WITH TILE AROUND THE SHOWER. THE FIRST LEVEL FEATURES A MOTHER/DAUGHTER APARTMENT WITH PROPER PERMITS WITH A PRIVATE ENTRANCE, A LARGE KICHENETTE WITH BASE/WALL CABINETS. THE MASTER BEDROOM IS SUITABLE FOR A KING-SIZE BED WITH A LARGE CLOSET AND MIRROR DOOR, THE SECONDARY BEDROOM IS SUITABLE FOR A KING/QUEEN-SIZED BED, FULL TUB BATHROOM THE ENTIRE FLOOR AREA IS COVERED WITH WATER-PROOF VINYL, AND LAUNDRY IN THE GARAGE, CAC, CONCRETE COVERED PATIO, PVC FENCE AROUND THE PROPERTY. THIS HOME BOATS A PRIME LOCATION THAT PROVIDES EASY ACCESS TO SCHOOLS, PARKS, AND SHOPPING CENTERS, 15 MINUTES FROM TANGLER OUTLETS IN DEER PARK AND 15 MINUTES FROM THE BEACHES, AND MAJOR TRANSPORTATION ROUTES. * LOW TAXES AFTER STAR 10,485 FOR EAST ISLIP DISTRICT SCHOOL!!. THIS LOVELY HOME IS GOING QUICKLY, WE LOOK FORWARD TO YOUR VISIT. DON'T MISS OUT ON THE OPPORTUNITY TO MAKE THIS RENOVATED HOME YOUR OWN 5 BEDS, 3 FULL TUB BATHS, LIVING R, DINING R, DEN/OFFICE MOTHER AND DAUGHTER APARTMENT WITH PROPER PERMITS. HOUSE IS GAS, YES GAS!! LAUNDRY WITH WASHER AND DRYER, CAC, 1 CAR ATTACHED GARAGE, CONCRETE COVERED PATIO FOR YOUR ENTERTAINMENT ALL SEASONS AROUND THE YEAR, THE HUGE BACKYARD IS COMPLETELY ENCLOSED WITH A LARGE PVC FENCE, ENOUGH SPACE FOR A POOL!! POTENTIAL HOME, TO MUCH TO LIST!!
MlsNumber: 3536418


Listing Provided By: HomeSmart Premier Living Realty, original listing
Name: HomeSmart Premier Living Realty
Phone: (516) 535-9692
Office Name: HomeSmart Premier Living Rlty
Office Phone: (631) 629-3630
Agent Name: Yolanda Castillo
Disclaimer: Copyright © 2024 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.


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 = 1874 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 Suzanne Rivera
Suzanne Rivera
ASCIIRE/MAX Superior
Call Today!: (631) 300-0947

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App