Propelligence

Cedar Chain Lakes
4 properties · 1 brief · rubric 1.0

Portfolio
Value scorecardCompare all 4, re-weight live
Properties · by score
7.714 Harrow Point RdCEDAR LAKE · Marlow · $985K
7.3822 Quarry BendCEDAR LAKE · Marlow · $1.24M · screened only
5.65 Tannery FlatsMILL POND · Ashgrove · $640K · screened only
5.53 Old Ferry LandingCEDAR LAKE · Marlow · $1.49M · screened only
About

Planning research only — not an appraisal, inspection, or legal/financial advice. Every figure marked “confirm” needs verifying before you rely on it.

Cedar Chain Lakes — sample scorecard

Fictional properties. Every address, price and finding here is invented to demonstrate the model.

Exports at the weighting currently set below.
Add a property Not configured in this build.
What this does, and how to switch it on

Paste a listing URL and it is written to a shared queue document; a scheduled task picks it up on its next run, produces a full due-diligence brief, and folds the property into this app. Nothing runs in the browser — this writes a request, and the task does the work.

Set queueUrl in your scorecard data to the document you want requests written to. The bar then activates and generates a bookmarklet that captures listings in one click, and the same document accepts a URL shared from a phone.

This demo has no queue configured, so the controls above are inert.

Inputs

runtime only · never stored

Set this first — it is an input, never stored in the file. Budget fit is DERIVED from it, so the ceiling moves the ranking just as the weights below do. It travels in a share link so whoever you send this to sees the same model.

$
$

Weights

fixed pool

Every score, rank and colour below recalculates as you move these. These are a fixed pool: raising one weight lowers the others, so the total is always 100% and every trade-off is visible. Lock a dimension with its lock control to hold it while you adjust the rest.

Start from scratch — sort the ten by how much they matter

Setting ten numbers is hard; sorting ten things is easy. Put each dimension in a bucket and the weights are derived from that — then fine-tune with the sliders.

Anything in Don’t care goes to 0%.
the rest
Weights always total 100% — raising one lowers the rest. Lock a dimension to protect it. Only one dimension is unlocked, so nothing can move.

Ranking

at current weighting

Ranked best to worst. Hover any bar for the headline read. A ▲/▼ chip means your weighting moved that property up or down versus the analyst's default. Rule a property out from the ⋯ menu on its row — it drops to the bottom, stops competing in the ranking and the sensitivity read, and keeps every word of its analysis.

the read on each
the full numeric table accessible view

Where they are

4 plotted

4 of 4 properties have coordinates. Markers carry the live score and open the brief. The map loads from the internet — the rest of this page does not, so nothing is fetched until you open it.

How solid is this ranking?

sensitivity

Stated weights are guesses, so the more useful question is not what are my weights but what would have to be true for the answer to change. For each property below: the smallest single change to one weight that would put it in first place. A property that flips on a two-point move is not really behind; one that cannot be moved at all is genuinely out.

Where the leader wins and loses

Two readings answer most of the question. The full grid is one click away when you want to argue with it.

all eleven dimensions
Weaker Stronger Every cell is labelled with its score, so colour is never the only channel.

Cost to reach the program

ceiling unset

Scored against the all-in ceiling set at the top of this page. All-in = a realistic negotiated purchase + renovation + any addition/ADU + closing, against your ceiling. Addition costs use 2026 ranges: ground-level bump-out $80–200/sq ft, second storey $300–500/sq ft, detached ADU $150–250/sq ft — pushed toward the upper end here for lakefront sites, slope and septic.

How to read this. The score compresses the judgement in each due-diligence brief into one comparable number; every sub-score is defensible from the research in that brief. Price vs. market asks whether the ask is supportable against comps — not whether the property is cheap. Risk is scored so higher = safer. Scores move as facts land, so a rebuilt brief updates its row here. Planning research only — not an appraisal or investment advice.

Search

mls SAMPLE-001 · pulled 16 Aug 2026 · rubric 1.0

14 Harrow Point Rd

CEDAR LAKE · Marlow · $985K
Value score7.7/ 10 see how it was scored
Opens in Word, Pages or Google Docs — tables and links intact.

The benchmark in this sample set: target lake, the right road, clean water, and a legal path to the fourth bedroom.

Sample brief. Every address, figure and finding below is invented. It exists to show the shape of a real brief and the moves the method makes — not to describe any actual property.

14 Harrow Point Rd, Marlow · MLS SAMPLE-001 · listing (fictional)

Listing photo · as of 16 Aug 2026
How it scored
Strongest
9.0
Location match
Weakest
6.0
Risk & unknowns

In this brief

  1. 01Executive summary
  2. 02Snapshot
  3. 03Title, boundaries & access
  4. 04Condition & disclosure
  5. 05Zoning & use
  6. 06Renovation & cost to reach the program
  7. 07Comparable sales
  8. 08Lake water quality
  9. 09Location & lifestyle
  10. 10Offer analysis
  11. 11Pre-offer checklist
01

Executive summary

Three findings move the decision more than anything in the listing copy.

  • The dock is grandfathered, not permitted. The current structure predates the 2011 shoreline ordinance and is legal only while it stands. Rebuild it — or let storm damage take it — and the replacement falls under the current 60 ft projection limit, which would cost roughly 14 ft of the existing reach. Confirm with the town before assuming the dock you see is the dock you keep.
  • The fourth bedroom the listing implies may not be buildable at all. The walkout has the volume and the egress window, but the septic is rated for three bedrooms — and on a waterfront lot, enlarging the leach field to carry a fourth is a siting question, not a cheque you can write. Treat it as the gate: an expansion runs $18–34K if a conforming field can be sited, and the honest answer might be that it cannot.
  • It is priced at the top of its own comp bucket. $985K against four true-lakefront sales on this shore between $402 and $478 per sq ft. At 2,180 sq ft the ask is $452 — defensible, not cheap, and there is no distress here to trade on: 59 days on market, no cut, one owner since 2009.

The headline read: this is the benchmark property in the sample set and the model puts it first. Target lake, the road archetype the profile describes, clean water, and a legal path to the program. What you are paying for is the absence of problems rather than any single spectacular feature, which is a defensible thing to buy and a hard thing to negotiate against. As-is $940K–$1.01M. An opening at $935K is arguable; below $900K is not.

02

Snapshot

Item

Detail

Ask

$985,000 ($452/sq ft)

Beds / baths / size

3 / 2.5 / 2,180 sq ft

Lot

1.0 acre, wooded, gentle grade to the water

Built

1978, substantially renovated 2019

Frontage

112 ft, owned to the waterline — no crossing

Water / sewer

Drilled well; private septic, 3-bedroom

Taxes

$9,240

Listed

18 June 2026, MLS SAMPLE-001 — 59 days, no price change

Value score

7.45 / 10 at the default weighting

The $9,240 tax line is the seller’s, not yours. It sits on an assessment near $520K — well under today’s value — and the town reassesses on sale. At a negotiated $950K the assessment resets toward market, and at the current rate near $17.8 per $1,000 the bill lands around $16,500: about $7,200 a year more than the listing shows, roughly $600 a month. Budget the reassessed number, because it is the one you pay from year one. Confirm the town’s reassessment trigger and its equalization rate before you rely on the figure — the mechanism varies, the direction does not.

03

Title, boundaries & access

Frontage conveys in fee to the waterline — the parcel encompasses the mean high water mark, so dock and mooring rights sit with the owner rather than with an association. This is the benchmark case and it is worth stating plainly, because the two comps that look cheaper on paper do not have it.

No road crossing. The lawn runs from the house to the water. Harrow Point Road ends at the property; there is no through traffic and no crossing to reach the shore — the configuration the profile asks for and the one the model scores highest.

  • Confirm: a utility easement along the north boundary appears on the tax map but not in the listing. Get the survey and establish its width and whether it is exercisable.
  • Confirm: the shared driveway serving the two uphill lots. Maintenance appears informal; ask for the recorded agreement, or establish that there is not one.
04

Condition & disclosure

The 2019 renovation covered kitchen, baths, windows and mechanicals. What it did not cover is the envelope: roof is original 1978 architectural shingle at the end of its service life, and the crawlspace has no vapour barrier.

Three disclosure items are marked Unknown — always the most informative part of a disclosure, because they are what the seller declines to warrant:

  • Prior water intrusion in the lower level — Unknown. With a lakeside crawlspace and no vapour barrier, treat this as a yes until an inspection says otherwise.
  • Age and capacity of the septic leach field — Unknown, and the most material blank on the form. A lakeside field carries two questions money does not always answer: whether the existing three-bedroom system still meets its rated capacity, and whether a larger one could be sited if you needed it — see §3.
  • Underground fuel storage — Unknown. A 1978 lake house may well have a buried oil tank. Line up a tank sweep; abandonment costs $2–4K, remediation vastly more.
05

Zoning & use

Lakeshore Residential. One single-family dwelling plus one accessory dwelling unit is permitted, and the acre is comfortably over the minimum. Short-term rental requires an annual permit, issued administratively below 12 occupants.

The binding constraint is not zoning — it is the septic, and it may be a harder one than the listing lets on. Occupancy and bedroom count are sized by the system, so the fourth bedroom and any STR occupancy above six people depend on the same field. Price them as one decision — and establish, before you offer, whether that decision is even available.

The terrain is the reason to doubt it. A conforming absorption field needs a fixed setback from the lake, clearance from the well and the property lines, and enough unsaturated soil above the seasonal high water table — and on a modest waterfront lot those can overlap until no compliant location is left, gentle grade or not. The counter-evidence is honest: the direct neighbour at 9 Harrow Point sold as a 4/3, so a four-bedroom field exists on this street. But that is that lot; siting is parcel-specific, and this one gives up area to a well and 112 ft of shoreline. Make it a contingency satisfied by a licensed designer’s written opinion that a conforming four-bedroom field is sitable — not by an inspection of the tank that is already there. If the answer is no, the fourth bedroom is off the table and this is a three-bedroom at $985K.

06

Renovation & cost to reach the program

Item

Range

Note

Roof replacement

$21,000 – $28,000

End of service life; not optional

Crawlspace encapsulation

$6,000 – $11,000

Ties to the water-intrusion Unknown

Septic expansion to 4 bedrooms

$18,000 – $34,000

Only if a conforming field is sitable (§3)

Walkout bedroom fit-out

$12,000 – $19,000

Egress already exists

Dock reserve

$0 – $40,000

Zero if grandfathered status holds; a rebuild resets to current limits

All-in at a negotiated $950K

$1.01M – $1.08M

Plus ~2.5% closing

The dock line is a range that starts at zero and that is the honest way to carry it — it is a coin-flip on a fact you can establish before closing, not a cost you can average.

07

Comparable sales

The dominant driver on this lake is owned frontage versus deeded or across-road access. The buckets are kept apart because mixing them makes the $/sq ft meaningless.

the comparable sales · 5

Address

Sold

Date

Bd/Ba

Sq ft

$/sq ft

Bucket

9 Harrow Point Rd

$1,040,000

May '26

4/3

2,180

$477

Owned frontage

41 Cedar Reach

$918,000

Mar '26

3/2

2,285

$402

Owned frontage

7 Quarry Bend

$742,000

Nov '25

4/3

2,640

$281

Deeded access, across road

22 Mill Pond Rd

$610,000

Sep '25

3/2

2,100

$290

Shared access

14 Harrow Point Rd — SUBJECT

$985,000 ask

—

3/2.5

2,180

$452

Owned frontage

The spread is the finding: owned frontage clears $402–$477 per sq ft here; access-only clears $281–$290. That is roughly a 35% discount for not owning the waterline, and it is why the frontage question is asked before the house is even looked at.

As-is value: $940,000 – $1,010,000. The direct neighbour at $477 sets the ceiling and is a newer four-bedroom; the subject should not exceed it.

08

Lake water quality

This is the lake’s water — what you swim in and look at, not the tap; drinking water here is the drilled well, tested separately (see the checklist). It is scored apart from access because the two are independent: a clean lake you cannot reach and a reachable lake that is fouling are different problems. Summer clarity has run 6.2–6.8 m over the last five seasons, phosphorus is low, and there is no bloom advisory on record for this basin. Near-shore weed is light and the lake association funds a harvesting programme.

Direction of travel matters as much as the level. Clarity has been stable, not declining — which is a different fifteen-year proposition from a lake that reads well today and is trending the wrong way.

09

Location & lifestyle

Destination

Distance

Typical drive

Groceries, pharmacy

6 mi

11 min

Hospital / ER

14 mi

22 min

Nearest international airport

58 mi

1 hr 5 min

Anchor city (family)

41 mi

52 min

Ski hill

33 mi

40 min

Winter access confirmed — Harrow Point Road is town-maintained and plowed to the end, which the two uphill comps cannot claim. Verified with the highway superintendent; the shared driveway beyond is the owners' responsibility.

10

Offer analysis

What pushes down: the roof is due, the crawlspace is unfinished, three disclosure Unknowns sit on the same lower level, and the fourth bedroom the listing implies may not be sitable at all.

What supports the price: owned frontage with no crossing, a stable clear lake, a town-plowed road, and a 2019 renovation that already spent the money on the expensive interior systems.

What you do not have: leverage. 59 days is unremarkable here, there has been no cut, and one owner since 2009 means no distress and no reset counter to point at. This is a property to buy well rather than to buy cheaply — and saying so is more useful than manufacturing an argument the seller will not recognise.

Suggested position: open $935,000, justified on the roof, the crawlspace and the septic capacity — three quotable items, not an opinion about value. Tie the final number to the inspection so each becomes a credit. Contingencies: survey and the north easement, a licensed designer’s written opinion that a conforming four-bedroom field is sitable, a written determination on the dock’s grandfathered status, a tank sweep, and a bindable insurance quote.

11

Pre-offer checklist

  • Survey — the north utility easement, its width and whether it is exercisable
  • Recorded maintenance agreement for the shared driveway, or confirmation there is none
  • Written determination on the dock's grandfathered status and what a rebuild would be limited to
  • Septic — a licensed designer’s written opinion that a conforming four-bedroom field is sitable within the lake setback, not just an inspection of the existing tank
  • Underground tank sweep
  • Well water test — bacteria, nitrates and hardness on the drilled well; this is your drinking water, and it is separate from the lake
  • Roof age and any remaining transferable warranty
  • Bindable homeowner's insurance quote before removing contingencies
  • Agent CMA with the MLS waterfront and frontage-feet fields — it supersedes the comp table above

Planning research only — not an appraisal, a title opinion, or legal or financial advice. Every item marked confirm needs verifying before you rely on it.

rubric 1.0

822 Quarry Bend

CEDAR LAKE · Marlow · $1.24M
Value score7.3/ 10 see how it was scored

Everything the brief asks for except the setting — and the setting is the half that cannot be renovated.

Screened, not fully briefed. This property was scored from a screening pass rather than a full due-diligence brief — so there is no chapter-by-chapter research here. Everything below is the reasoning behind each score, with its sources.
How it scored
Strongest
9.0
Location match
Weakest
4.5
Price vs. market
why it scored the way it did · 11
DimensionScoreReasoning
Location match 9.0 Same target lake, southern end.
Setting (private + sociable) 5.5 Amenity community — pool, tennis, houses close together. Reads well in the listing copy and scores LOWER here.
Waterfront use (access) 8.0 Level walk-in entry, deep-water dock.
Water quality (clarity · weeds · algae) 8.5 Same lake as Harrow Point; clarity comparable.
Interior character 8.5 Recently renovated, open plan, generous light.
Program fit 8.5 4 bed / 3 bath at 2,600 sq ft as built.
Price vs. market 4.5 Ask sits above every comp in the association.
ADU & guest space 7.0 Finished lower level with a separate entrance; short-term rental barred by covenant.
Budget fit 5.0 Tight once the assessment history is priced in.
Everyday access 7.5 Best everyday access in the set.
Risk & unknowns 5.0 Association reserve study is three years overdue.

rubric 1.0

5 Tannery Flats

MILL POND · Ashgrove · $640K
Value score5.6/ 10 see how it was scored

The clearest illustration of why access and water quality are scored apart: perfect entry into the worst water in the set.

Screened, not fully briefed. This property was scored from a screening pass rather than a full due-diligence brief — so there is no chapter-by-chapter research here. Everything below is the reasoning behind each score, with its sources.
How it scored
Strongest
9.5
Budget fit
Weakest
2.5
Water quality (clarity · weeds · algae)
why it scored the way it did · 11
DimensionScoreReasoning
Location match 3.0 Wrong lake, thirty-five minutes from the target area.
Setting (private + sociable) 6.0 Quiet, wooded, but nobody around to meet.
Waterfront use (access) 8.5 The easiest entry in the set — a level lawn straight into the water.
Water quality (clarity · weeds · algae) 2.5 Eutrophic. Summer Secchi ~1.9 m, dense milfoil on the shelf, blooms most Augusts with no harvesting programme.
Interior character 5.0 Serviceable, dated, low ceilings throughout.
Program fit 6.5 3 bed / 2 bath at 1,900 sq ft, with room to add.
Price vs. market 7.0 Priced sensibly against its own shore.
ADU & guest space 7.5 Two-family permitted by right; municipal sewer removes the septic obstacle.
Budget fit 9.5 By far the most headroom of anything here.
Everyday access 4.5 Thin on services; twenty-five minutes to a supermarket.
Risk & unknowns 4.5 Shoreline erosion noted in the 2023 disclosure.

rubric 1.0

3 Old Ferry Landing

CEDAR LAKE · Marlow · $1.49M
Value score5.5/ 10 see how it was scored

Ruled out by law rather than by money — the one failure mode a bigger cheque cannot fix.

Screened, not fully briefed. This property was scored from a screening pass rather than a full due-diligence brief — so there is no chapter-by-chapter research here. Everything below is the reasoning behind each score, with its sources.
How it scored
Strongest
9.0
Location match
Weakest
1.0
ADU & guest space
why it scored the way it did · 11
DimensionScoreReasoning
Location match 9.0 Prime frontage on the target lake.
Setting (private + sociable) 7.0 Good road, mature trees, generous lot.
Waterfront use (access) 8.0 Level beach entry with a new dock.
Water quality (clarity · weeds · algae) 8.5 Best water in the sample set.
Interior character 4.0 Uninsulated seasonal camp; dark, compartmentalised, no central heat.
Program fit 2.0 2 bed / 1 bath at 1,150 sq ft, and it cannot legally grow.
Price vs. market 3.0 The ask alone is {{pctOfCeiling:1490000}} of {{ceiling}}.
ADU & guest space 1.0 Prohibited outright by the sample zoning code.
Budget fit 1.5 Breaks the ceiling before any work.
Everyday access 5.5 Seasonal road; winter access unresolved.
Risk & unknowns 2.5 Nonconforming structure, septic within the setback, no permit history.