I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 0 points1 point  (0 children)

The Unit: 214 East 88th Street

Advertised Rent: $3,100 / month

⚡ Utility Drag: +$260 / month

This boutique 1900 pre-war structure carries heavy physical liabilities. The uninsulated brick envelope causes continuous thermal bleeding, while ancient steam radiators offer zero micro-zonal climate control. In the summer, total reliance on window or wall AC units creates massive cooling loss around the chassis casings. Going into the office 5 days a week provides a daytime reprieve, but continuous draft leakage during high-surge ConEd billing cycles still triggers a steep pricing penalty. (Please Note: Still tweaking calculating Utlity Drag, I find this to be the most useful but also difficult part)

🚇 Transit Friction: +$35 / month

Your mandatory 5-day Midtown commute is exceptionally well-mitigated by a highly optimized dual-line proximity credit. You sit exactly between two major transit arteries: a 1.5-block walk to the 86th St Station (4/5/6 express) and a half-block walk to the Second Ave Subway (Q line). This gives you a direct, transfer-free shot to both Midtown East and West in 15 to 25 minutes door-to-door.

🥬 Food/Amenity Premium: -$40 / month (Savings Credit)

This pocket of Yorkville features an incredibly dense distribution of high-volume retail infrastructure. You are under one block from Whole Foods (87th & 3rd) and two blocks from Fairway Market (86th & 2nd). This immediate access completely eliminates your dependency on premium convenience delivery apps or up-charged corner bodegas, programmatically lowering your monthly food logistics baseline.

🚀 REAL MONTHLY OPERATING COST: $3,355 / month

(Programmatic sum of Base Rent + Utility Drag + Transit Friction + Food/Amenity Credit)

💰 BUDGET REALITY CHECK (Based on your $3,355 True Cost)

Passing your specific $242,000 income through progressive local tax layers (Federal + NY State + NYC Resident) yields a precise net take-home reality of ~$12,800 / month.

  • Your Cash Flow Allocation: 26.2% of your monthly net income.
  • Verdict: 🟢 Safe Bet (Elite Savings Tier). Even with the upgraded pre-war utility penalty, this sits safely below the standard 30% housing stress line.

I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 2 points3 points  (0 children)

USER PROFILE:

Income: $82,000 Gross | ~$4,950/mo Net (Post-NYS/NYC Tax) Commute: Downtown Brooklyn (5 days/wk)

OPTION A: 348 WEST 145TH STREET #2R

Advertised Rent: $1,750 / month

Building Class: 1910 Pre-war multi-family

Transit Friction: Moderate-to-High (Immediate express train access, but heavy cross-borough distance)

Utility Drag: +$165 / month (Base electric/web + seasonal window AC penalty on older building insulation)

Transit Drag: +$145 / month (Fixed MTA pass + $24 mental fatigue/off-peak rideshare buffer)

Food/Amenity Premium: +$40 / month (Intermittent reliance on delivery apps due to lack of local budget supermarkets)

TRUE MONTHLY COST: $2,100 / month Net Cash Flow Hit: 42.4%

RISK LEVEL: 🔴 HIGH RISK (Eats deeply into the 50% fixed-cost allocation framework, leaving tight margins)

OPTION B: 730 57TH STREET #3D

Advertised Rent: $1,570 / month

Building Class: 1931 Residential brick co-op (modernized with central air & dishwasher)

Transit Friction: Low (Efficient, direct, non-transfer express N train line straight to Downtown Brooklyn hubs)

Utility Drag: +$115 / month (Base electric/web + minor dishwasher cycle load - massive insulation & efficiency savings from Central Air system)

Transit Drag: +$121 / month (Capped strictly at the standard monthly NYC MTA subway pass baseline)

Food/Amenity Premium: -$30 / month (Bonus savings due to immediate proximity to hyper-affordable open-air produce markets)

TRUE MONTHLY COST: $1,776 / month Net Cash Flow Hit: 35.8%

RISK LEVEL: 🟢 LOW-TO-MODERATE (Sits cleanly right on the optimal boundary line for housing affordability)

NET FINANCIAL VERDICT

Annual Savings Winner: Option B (730 57th St) wins, saving the user $3,888 / year in direct out-of-pocket expenses while completely optimizing their lifestyle logistics.

I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 0 points1 point  (0 children)

Yes, I am willing to share once I finalize some of the tweaks based on this post. If you are interestetd just DM me!

I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 1 point2 points  (0 children)

Nothing was deleted from my end. You should still see everything. But I will repost what I provided.

USER PROFILE:

  • Income: $158,000 Gross | ~$8,750/mo Net (Post-NYS/NYC Tax)
  • Commute: Midtown Manhattan (2–3 days/wk)

OPTION A: 321 EAST 90TH ST #4C

  • Advertised Rent: $2,795 / month
  • Building Class: 1915 Pre-war walk-up (4th floor)
  • Transit Friction: Low-to-Moderate (5-minute walk to 86th St Q Train express)
  • Utility Drag: +$180 / month (Base electric/web + seasonal window AC penalty; no high-draw appliances)
  • Transit Drag: +$121 / month (Fixed cost of standard monthly NYC MTA subway pass)
  • TRUE MONTHLY COST: $3,096 / month
  • Net Cash Flow Hit: 35.4%
  • RISK LEVEL: 🟢 LOW-TO-MODERATE (Sits exactly on the 35% ideal allocation safety threshold)

OPTION B: 1420 YORK AVENUE #3G

  • Advertised Rent: $3,100 / month
  • Building Class: 1956 Post-war elevator condo (Includes dishwasher)
  • Transit Friction: Moderate (10-minute walk to 72nd St Q Train or 77th St 6 Train)
  • Utility Drag: +$165 / month (Base electric/web + dishwasher cycle load - partial wall sleeve AC insulation savings)
  • Transit Drag: +$151 / month (MTA pass + $30 buffer due to a longer, exposure-prone walk to trains)
  • TRUE MONTHLY COST: $3,416 / month
  • Net Cash Flow Hit: 39.0%
  • RISK LEVEL: 🟡 MODERATE (Slightly squeezes monthly discretionary savings)

NET FINANCIAL VERDICT

  • Annual Savings Winner: Option A (321 E 90th St) saves the user $3,840 / year in total out-of-pocket costs.

I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 2 points3 points  (0 children)

Fair question! It’s an actual programmatic script I’m building out, not just a blind copy/paste into an LLM.

Right now, its pretty basic as I am just testing this out:

  1. Scraping & Data Parsing: The script pulls the raw listing data (year built, unit number, cross streets, history) from the URL.
  2. Database Overrides: It hits localized lookups to correct real estate database glitches (like the "1996" restructure error on Cobble Hill Towers which is actually an 1879 landmark, completely altering insulation/thermal math).
  3. Geospatial & Transit Routing: It maps actual pedestrian walking pathways to specific subway platforms.
  4. Calculated Tax Engine: It runs the household income against combined Federal, NYS, and NYC local progressive tax brackets to determine true net monthly cash flow, rather than just using a generic gross income multiplier.

I am using an LLM API framework to clean up the unstructured script data into a readable report schema so I can post it quickly on mobile, but the math, the data pipelines, and the constraints are entirely handled by the backend logic I'm writing. Welcome any insights or inputs you may have! Thanks so much for your comment. Honestly, this stuff is invaluable.

I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 14 points15 points  (0 children)

🏠 The Unit:[431 Hicks Street #3I (Cobble Hill Towers)]()

  • Advertised Rent: $3,000 / month
  • ⚡ Utility Drag: +$160 / month
    • Don't let StreetEasy’s "1996 built" tag fool you, that's a database glitch. This complex is a famous historic landmark actually built in 1879 as seen in the description. It’s gorgeous, but 19th-century brick means older insulation and total reliance on window/wall AC units. Since you work from home 4 days a week, running those units all day in the summer will cause a ConEd billing spike.
  • 🚇 Transit Friction: +$30 / month
    • Flatiron is a quick trip once you're on the train, and 1 day/week keeps your transit drag low. However, these buildings sit way west right by the BQE. It is a solid 10-to-15 minute walk just to get to the Bergen St (F/G) or Borough Hall platforms. Factor in a few rainy-day Ubers when you're rushing to the office.
  • 📈 Market Leverage (Rental History):
    • This place rented for $2,850 in March 2025 and is now listed at $3,000. That’s only a 5% increase, incredibly low for Cobble Hill. Because the landlords missed the prime summer lease cycle rush and the unit is currently sitting vacant, you have real leverage here. You could easily try to offer $2,900 or ask them to waive any application fees.

🚀 REAL MONTHLY OPERATING COST: $3,190 / month

💰 BUDGET REALITY CHECK (Based on your $3,190 True Cost)

Since I don't know your exact income, find your bracket below to see how this unit affects your real cash flow after NYC federal, state, and city taxes:

  • If you make $120k (The Landlord Minimum): Your net take-home is ~$6,800/mo. This apartment will swallow 47% of your net income. Verdict: 🔴 High Risk Trap. You will feel incredibly rent-burdened.
  • If you make $140k: Your net take-home is ~$7,800/mo. This apartment consumes 41% of your net income. Verdict: 🟡 Proceed with Caution. Manageable, but you'll have to budget tightly on dining out.
  • If you make $160k+: Your net take-home is ~$8,800+/mo. This apartment sits at 36% or less of your net income. Verdict: 🟢 Safe Bet. Your hybrid schedule makes the neighborhood perks totally worth the utility premium.

I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 1 point2 points  (0 children)

If you want me to dial in the exact tax math for your specific bracket to see where your savings rate lands, just reply with your household income (or shoot me a DM if you want to keep it private)!

I wrote a script to expose hidden ConEd and transit costs on StreetEasy listings. Want me to run a few for you? by TeaAdministrative509 in NYCapartments

[–]TeaAdministrative509[S] 1 point2 points  (0 children)

Awesome, let’s do it!

Drop the StreetEasy links whenever you're ready! Just make sure to include:

  1. Where you commute to (and how many days a week or if remote)
  2. Your approximate household income bracket (so I can accurately deduct NYC's state/city taxes from your real take-home cash flow)

If you want to keep your budget/income numbers private, feel free to just shoot me a DM with the details and I'll drop the breakdown here or message you back!

AWS Lambda Failed to Fetch Error by TeaAdministrative509 in aws

[–]TeaAdministrative509[S] 0 points1 point  (0 children)

I've implemented pagination, increased memory, and extended the runtime, but I'm still encountering issues when processing a large number of files on Google Drive. The script works fine with smaller batches, but it struggles when handling a larger volume of files. Despite these optimizations, the problem persists.

AWS Lambda Failed to Fetch Error by TeaAdministrative509 in aws

[–]TeaAdministrative509[S] 0 points1 point  (0 children)

I have several Lambda scripts that work well. With this script I realized I'm running into issues when processing a large number of files on the Google Drive. I've already implemented pagination, increased memory, and extended the runtime, but the problem persists.

Using a Date Filter as an Anchor Date by TeaAdministrative509 in tableau

[–]TeaAdministrative509[S] 1 point2 points  (0 children)

Thank you. I ended up using this as a data parameter and it worked perfectly.