Seldom Rest Christmas Tree Farm. An 80-acre estate in Oregon Township with a 1990 open-concept two-story home, a barn, a pond, a stream, trails and an established wholesale and choose-and-cut Christmas tree business that has operated from this address since 1999. Turn-key: approximately 20,000 Christmas trees stand in the ground in multiple planting blocks, including Fraser fir, concolor fir, blue spruce, white spruce and other popular varieties. The standing trees are included, and the business, farm name, tractors, backhoe, spray equipment and the rest of the farm equipment are available to convey to the new owner. A forester's inventory report by species and age is available to qualified buyers. The home has 1,988 square feet above grade plus a finished walkout lower level, 3 bedrooms, 2 full and 1 half baths, an attached two-car garage, a furnace from 2020 and central air. New roofs in 2024 on the house, the barn and the shed. The barn was built as a horse barn and has water, electric and hay storage. Deer hunting with seven blinds, three enclosed. 600 feet of paved road frontage, zoned agricultural, Lapeer schools. Proof of funds or a pre-approval is required before a showing. Seller will not split the parcel.
Coming soon 11/03
$999,000
4700 Stanley Rd, Columbiaville, MI 48421
3beds
2,988sqft
Single Family Residence
Built in 1990
80 Acres Lot
$689,900 Zestimate®
$334/sqft
$-- HOA
What's special
- 3 days
- 337
- 27
Zillow last checked:
Listing updated:
Listed by:
Nicholas Asplund 810-222-9019,
@properties Christie's Int'l RE Grosse Pointe 313-228-2221
Source: Realcomp II,MLS#: 20261086948
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Entry
- Area: 224
- Dimensions: 14 X 16
Bedroom
- Level: Second
- Area: 144
- Dimensions: 12 X 12
Bedroom
- Level: Second
- Area: 132
- Dimensions: 11 X 12
Primary bathroom
- Level: Entry
- Area: 80
- Dimensions: 8 X 10
Other
- Level: Second
- Area: 54
- Dimensions: 6 X 9
Other
- Level: Entry
- Area: 25
- Dimensions: 5 X 5
Heating
- Forced Air, Propane
Cooling
- Central Air
Features
- Basement: Finished,Walk Out Access
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total interior livable area: 2,988 sqft
- Finished area above ground: 1,988
- Finished area below ground: 1,000
Property
Parking
- Total spaces: 2
- Parking features: Two Car Garage, Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevel
- Patio & porch: Deck, Porch
- Pool features: None
- Waterfront features: Pond, Stream
Lot
- Size: 80 Acres
- Features: Farm, Wooded
Details
- Additional structures: Barns, Sheds
- Parcel number: 01700904400
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Basement, Wood
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1990
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
HOA
- Has HOA: No
Location
- Region: Columbiaville
Financial & listing details
- Price per square foot: $334/sqft
- Tax assessed value: $171,402
- Annual tax amount: $3,844
- Date on market: 11/3/2026
- Cumulative days on market: 3 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Estimated market value
$689,900
$566,000 - $821,000
$2,745/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/7/2026 | Listing removed | $1,199,999$402/sqft |
Source: | ||
| 7/10/2026 | Price change | $1,199,999-20%$402/sqft |
Source: | ||
| 4/3/2026 | Listed for sale | $1,499,9990%$502/sqft |
Source: | ||
| 9/6/2025 | Listed for sale | $1,500,000$502/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $3,493 +0.6% | $370,500 -3% |
| 2025 | $3,474 +8.4% | $382,000 +0.1% |
| 2024 | $3,205 +5.8% | $381,500 +15.3% |
| 2023 | $3,031 +9.9% | $330,800 +19.5% |
| 2022 | $2,759 +0.9% | $276,900 +16.8% |
| 2021 | $2,735 | $237,000 +3% |
| 2020 | -- | $230,000 -6.8% |
| 2018 | $2,680 +0.5% | $246,700 +3% |
| 2017 | $2,667 | $239,400 +8.9% |
| 2016 | -- | $219,800 |
| 2015 | -- | -- |
| 2014 | -- | $200,000 |
Find assessor info on the county website
Monthly payment
Est. payment







