Welcome to Seldom Rest Christmas Tree Farm. A life, and property like no other. One of Lapeer County's anchor tree farms, a best kept secret...and for some -- a yearly tradition. A lifetime of memories have been planted here, now it's time to find the new caretakers of this majestic ranch. Thousands of trees ready for this year's harvest and thousands more in the various growth stages -- a true turn-key investment for a savvy buyer. This property offers a rare business opportunity where the land itself can help to cover mortgage, tax and insurance costs. With 80 acres this homestead could serve as a multiuse Ag setup -- barn has room for stalls and already has frost free water and electric with ample hay storage. A large pond, stream and manicured trails wind through the trees. Prime hunting land with many large deer harvested yearly. Perfectly maintained open-concept home awaits your personal touches and updates offering a fully finished walk-out lower level, wood flooring, new (2024) roof and newer (2020) furnace. Owner is willing to discuss, in person, the business model and we are happy to offer tours on the farm UTV. Showings will be approved and booked with proof of funds or a preapproval letter from a credited lender.
For sale
$1,500,000
4700 Stanley Rd, Columbiaville, MI 48421
3beds
2,988sqft
Est.:
Single Family Residence
Built in 1990
80 Acres Lot
$1,449,500 Zestimate®
$502/sqft
$-- HOA
What's special
Large pondPrime hunting landManicured trailsWood flooringOpen-concept home
- 114 days |
- 597 |
- 22 |
Zillow last checked: 8 hours ago
Listing updated: October 26, 2025 at 04:01am
Listed by:
Traci Nelson Martin 248-703-0035,
Max Broock, REALTORS®-Bloomfield Hills 248-644-4700
Source: Realcomp II,MLS#: 20251034113
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Heating
- Forced Air, Propane
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Built In Gas Range, Built In Refrigerator, Dishwasher, Disposal, Dryer, Exhaust Fan, Microwave, Vented Exhaust Fan, Washer, Water Softener Rented
- Laundry: Laundry Room, Washer Hookup
Features
- Programmable Thermostat, Spa Hottub
- Basement: Bath Stubbed,Daylight,Finished,Full,Walk Out Access
- Has fireplace: Yes
- Fireplace features: Gas, 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, Circular Driveway, Direct Access, Electricityin Garage, Garage Faces Front, Garage Door Opener
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevelwSteps
- Patio & porch: Deck, Patio, Porch, Terrace
- Exterior features: Gutter Guard System, Lighting
- Pool features: None
- Fencing: Fencing Allowed
- Waterfront features: Pond
- Body of water: private pond
Lot
- Size: 80 Acres
- Features: Farm, Irregular Lot, Wooded
Details
- Additional structures: Barns, Hay Barn, Outbuildings Allowed, Sheds, Sheds Allowed, Stables
- Parcel number: 01700904400
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Basement, Wood
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1990
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Cable Available
Community & HOA
Community
- Security: Security System Leased
- Subdivision: MILES SUB
HOA
- Has HOA: No
Location
- Region: Columbiaville
Financial & listing details
- Price per square foot: $502/sqft
- Tax assessed value: $382,000
- Annual tax amount: $3,844
- Date on market: 9/6/2025
- Cumulative days on market: 114 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Estimated market value
$1,449,500
$1.38M - $1.52M
$2,938/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 9/6/2025 | Listed for sale | $1,500,000$502/sqft |
Source:  Realcomp II #20251034113 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $196 +38.3% | $9,600 +1.1% |
| 2024 | $142 +5.4% | $9,500 +5.6% |
| 2023 | $135 +6.7% | $9,000 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$9,051/mo
Principal & interest
$7413
Property taxes
$1113
Home insurance
$525
Climate risks
Neighborhood: 48421
Nearby schools
GreatSchools rating
- 8/10C.K. Schickler Elementary SchoolGrades: PK-5Distance: 5.6 mi
- 2/10Zemmer Middle SchoolGrades: 8-9Distance: 5.6 mi
- 7/10Lapeer East Senior High SchoolGrades: 10-12Distance: 8 mi
- Loading
- Loading
