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 = 3393 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 = 3393 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 = 3393 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;

31a Grove St
Hicksville, NY 11801
Harminderjit Dhillon with HP REALTY ADVISORS INC, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,388,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: --
Agency: HP REALTY ADVISORS INC
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Welcome to your dream home! This beautifully designed new construction property offers modern living with exquisite finishes and an open floor plan. Key Features: 5 Large Bedrooms: The primary suite includes a walk-in closet and a spa-like ensuite bathroom with a soaking tub, and a separate shower. Additional bedrooms are generously sized with modern design touches. 5 Full Bathrooms: Each one has modern luxurious finishes featuring Japanese toilets, Bluetooth speakers, and rain/jet showers. Spacious Layout: Enjoy abundant natural light throughout the large living room, which flows seamlessly into the dining area and gourmet kitchen. Hardwood floors all throughout the home make a seamless design. Chef's Kitchen: Featuring stainless steel appliances, quartz countertops, a spacious island, and ample cabinet space-perfect for entertaining or everyday cooking. Finished Basement: The open layout basement is perfect for entertainment or office space, featuring tall 8 feet ceilings, a full bathroom, laundry, and outside entrance. 1 Car Garage: Featuring an epoxy finish, perfect to protect your car from the elements, or even create a home gym or workshop. Outdoor Oasis: Step outside to a beautifully landscaped backyard, ideal for relaxation or gatherings. The patio offers a perfect spot for outdoor dining or enjoying a morning coffee. Energy Efficiency: Built with energy-efficient materials and appliances, this home will help you save on utility costs while reducing your carbon footprint. The entire home is covered with spray foam insulation and high quality Pella windows. Also featured is 2 separate HVAC units for further efficiency. Prime Location: Situated in the vibrant community of Hicksville with easy access to transportation, schools, shopping, and dining. This new construction home combines style, comfort, and functionality, making it the perfect place for you to create lasting memories. Schedule a showing today and experience all it has to offer!
MlsNumber: --
ListingId: 11347208


Listing Provided By: HP REALTY ADVISORS INC, original listing
Phone: (516) 932-3400
Agent Name: Harminderjit Dhillon
Disclaimer: Copyright © 2024 My State MLS. 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