• Price: $1,549,000

  • 25700 Quail Hill Lane
    Caldwell, ID 83607

  • MLS #: 98932169

Property Details

***GENERATIONAL HOME*** One of a kind home has it all, MIL quarters or quest home. 1bed/1bath, kitchen, Living room, dining room, own laundry and entrance. Totally private, all under same roof, yet seperate. Have aging parents close by. Four bed/3.5bath in main living part of home. Kitchen looks to front of home with huge front porch. High ceilings with stone fireplace, ceiling fans in all bedrooms and beautiful lighting throughout. Appliances are high end with beautiful cabinets with maximun storage. Butler pantry has direct access from garage to unload, sink for prep and space for extra refrigerator. Master on one side of home with master bath having soaker tub, walk in shower with direct access to master closet and laundry, while all other bedrooms on opposite side. Second BR is optional office, 3rd & 4th BR are jack and jill. Oversized great room opens up with enormous sliding doors to canopy like extended patio for leisure. Upstairs bonus room offers plenty of space for activities with a full bath. Details »

5 Bedrooms

5 Bathrooms

4332 Square Feet

Becky O'Neal

Realtor Homes of Idaho Idaho
  • 148 N Yale Street
    Nampa, ID 83651
  • 208-863-8529

Biography

pemspan style="font-size: 14pt"Handing over the keys to your new home is the greatest job ever. The smiles on your faces says everything. The day you get to move in is the sweet reward. /span/em/ppemspan style="font-size: 14pt"That is my job. Yes there is a lot to do before and up until the move in day, but that's what I'm for. I take that on and work with a team of real estate professionals behind the scene to get you to the closing table. I work hard to keep you informed and in front of all the timely dates that real estate requires. I always vow to work hard with honesty and true integrity.  Trusting me with your home purchase and sell is an honor and I take it seriously./span/em/pbr /pspan style="font-size: 14pt"strongKindly,/strong/span/ppspan style="font-size: 14pt"strongBecky O'Neal/strong/span/p

Colby Lampman

Co-Listing Agent Homes of Idaho
  • 208-442-1530
  • 208-353-5523

Biography

SimpleXMLElement Object
(
    [0] => disclaimer
)
SimpleXMLElement Object
(
    [0] => contactDisclaimer
)
SimpleXMLElement Object
(
    [0] => Terms acceptance requirement notification
)
SimpleXMLElement Object
(
    [0] => canadaContactDisclaimerNotice
)
SimpleXMLElement Object
(
    [0] => Canadian disclaimer checkbox label
)
SimpleXMLElement Object
(
    [0] => canadaDisclaimerLabel
)
SimpleXMLElement Object
(
    [0] => Canadian disclaimer
)
SimpleXMLElement Object
(
    [0] => canadaContactDisclaimer
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => prevPage_previous
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => prevPage_page
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => nextPage_previous
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => nextPage_page
)
SimpleXMLElement Object
(
    [0] => The title for the agent listings page
)
SimpleXMLElement Object
(
    [0] => agentlistings_h1
)
SimpleXMLElement Object
(
    [0] => The main intro text for the agent listings page
)
SimpleXMLElement Object
(
    [0] => agentlistings_headerText
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_addressColumn
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_sizeColumn
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_priceColumn
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_photoColumn
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_addressLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_sizeLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_bedsLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_priceLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_openTourButton
)
SimpleXMLElement Object
(
    [0] => The title for the Property Details page
)
SimpleXMLElement Object
(
    [0] => propertydetails
)
SimpleXMLElement Object
(
    [0] => See More Listings button text
)
SimpleXMLElement Object
(
    [0] => seeMoreListings
)

Browse through the many properties that I am currently representing. Click the property to view the virtual tour of each listing.

Photo Address Size Price
5154 S Alston Pl Meridian, ID 83642 2,748 SqFt $899,900
7932 W Grubstake Drive Boise, ID 83709 1,185 SqFt $395,000
TBD Boydstun St McCall, ID 83638 0 SqFt $220,000
116 N Moffatt Ave Emmett, ID 83617 907 SqFt $269,000
16317 Red Oak Drive Nampa, ID 83687 1,344 SqFt $350,000
4173 W Thornapple Dr Meridian, ID 83646 2,750 SqFt $879,777
4461 E E Stone Falls Dr Nampa, ID 83686 2,131 SqFt $460,000
2092 N Sevenoaks Way Eagle, ID 83616 4,411 SqFt $1,450,000
820 Independence Ln Emmett, ID 83617 1,404 SqFt $334,999
106 Newsome St Harpster, ID 83552 2,700 SqFt $750,000
2578 N Iditarod Kuna, ID 83634 2,103 SqFt $515,000
9 Elderberry Circle Idaho City, ID 83631 2,296 SqFt $499,999
1461 W Lark Ct Nampa, ID 83651 1,250 SqFt $324,900
205 S Ripplerock Ln Star, ID 83669 2,056 SqFt $419,900
6953 W Ashland Dr Boise, ID 83709 1,134 SqFt $435,000
6701 Hammermill Boise, ID 83714 2,692 SqFt $799,999
16714 Suffolk Ave Caldwell, ID 83607 1,572 SqFt $425,000
323 Maverick Fruitland, ID 83619 1,859 SqFt $453,000
163 N Huntsman Ln Eagle, ID 83616 1,684 SqFt $624,800
2289 E Shalimar Dr Eagle, ID 83616 1,961 SqFt $600,000
1206 NW 20th Ct Fruitland, ID 83619 1,450 SqFt $398,000
See More Listings

Property Details

Address: 5154 S Alston Pl Meridian, ID 83642
Size: 2,748 SqFt
Bedrooms: 3
Asking Price: $899,900

View this listing

Find out your monthly payments for this listing

Mortgage Calculator

How Much Can I Borrow?

How Much Can I Afford?

To email this brochure, please fill out the appropriate fields below. When done, simply click the "SEND" button.

Email Brochure Form



By registering, you agree to our terms of use and that real estate professionals and lenders may call/text you about your inquiry, which may involve the use of automated means and prerecorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply.

Select a school from the list below to view its contact information and statistics.

Type of school

CENTRAL CANYON ELEMENTARY SCHOOL (Grades: PK - 5)
NOTUS ELEMENTARY SCHOOL (Grades: PK - 6)
PURPLE SAGE ELEMENTARY (Grades: PK - 5)
RIVERVUE MIDDLE SCHOOL (Grades: 6 - 8)
VALLIVUE ACADEMY (Grades: 9 - 12)
VALLIVUE HIGH SCHOOL (Grades: 9 - 12)
VALLIVUE MIDDLE SCHOOL (Grades: 6 - 8)
VALLIVUE VIRTUAL ACADEMY (Grades: PK - 12)
WEST CANYON ELEMENTARY SCHOOL (Grades: PK - 5)
CALDWELL SENIOR HIGH SCHOOL (Grades: 9 - 12)
CANYON SPRINGS HIGH SCHOOL (Grades: 6 - 12)
HERITAGE COMMUNITY CHARTER (Grades: KG - 8)
JEFFERSON MIDDLE SCHOOL (Grades: 6 - 8)
LEWIS AND CLARK ELEMENTARY (Grades: PK - 5)
LINCOLN ELEMENTARY SCHOOL (Grades: PK - 5)
SACAJAWEA ELEMENTARY SCHOOL (Grades: PK - 5)
SKYWAY ELEMENTARY (Grades: KG - 5)
SOUTHWEST IDAHO JUVENILE DETENTION (Grades: 1 - 12)
SYRINGA MIDDLE SCHOOL (Grades: 6 - 8)
THOMAS JEFFERSON CHARTER (Grades: KG - 12)
VAN BUREN ELEMENTARY SCHOOL (Grades: KG - 5)
VISION CHARTER SCHOOL (Grades: KG - 13)
WASHINGTON ELEMENTARY SCHOOL (Grades: PK - 5)
WILSON ELEMENTARY SCHOOL (Grades: PK - 5)
Information

Institution Name:
Central Canyon Elementary School

Phone: (208)459-3367
Type: Regular school
NCES District ID: 1600600

Mailing Address:
16437 Florida AvenueCaldwell, ID 83607

District: Vallivue School District
County:
NCES School ID: 160060000083

Student/Teacher Ratio
Characteristics
Locale : Suburban, Midsize (22)
Charter : no
Total Teachers (FTE) : 35.00
Total Students : 730
Student/Teacher Ratio : 20.9
Enrollment by Grade

Students: PK - 05

Grade Students
PK42
KG106
1st114
2nd102
3rd116
4th129
5th121

School Data Provided By NCES
This information is provided by a third party provider and may or may not reflect all schools in this area.

Want to visit this property? Use this information to plan your trip. Check out local weather data.

High

:

65°F

Low

:

31°F

Precipitation

:

0 mm

Humidity

:

89 %

Wind

:

6mph

Pressure

:

1021

37
° F
|
°C

Sunny

Caldwell, ID 83607

Mon

Tue

Wed

There are two ways to get directions to this property. You can print the directions from your computer or have the address texted to your phone which can then be opened in Google maps.

Please enter Cell Numbers with only 10 digits (ex. 5555555555)

By registering, you agree to our terms of use and that real estate professionals and lenders may call/text you about your inquiry, which may involve the use of automated means and prerecorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply.
25700 Quail Hill Lane Caldwell, ID 83607