Southeast FL · Active District
IL Listings
9,103
active nationwide
Enriched
1,300
contact + description pulled
Geocoded
438
rooftop address confirmed
HS Synced
482
5 fields live in CRM
SE FL Deals
127
Palm Beach · Broward · Dade
Outreach Ready
36
SE FL CHs · messages drafted
🏪
Stage 1 — InvestorLift Marketplace Pull
Fetch all active national listings into Supabase
⏰ Mac Cron · 7:00 AM PT daily
Why Mac, not VPS
VPS IP is CloudFront-blocked by InvestorLift's WAF — returns 403 on all API calls. The Mac (AWS EC2 arm64 at 100.123.248.46) has a clean residential IP + valid session cookies stored at /Users/ec2-user/openclaw/workspace/data/investorlift-cookies-raw.txt. All IL API calls SSH through the Mac.
Fields pulled from IL marketplace API
raw_id city state zip beds baths sqft ask_price arv meta.lat meta.lng meta.title meta.expiresAt meta.views meta.condition meta.occupancy picture_link property_type year_built meta.offersCount
Example record (scraped status — not yet enriched)
Deal record at Stage 1
raw_id"314069"
city"Hollywood"
state"FL"
ask_price335000
arv465000
meta.lat26.0112
meta.lng-80.1459
enrichment_status"scraped"
What's missing (needs enrichment)
contact_namenull
contact_phonenull
account_companynull
listing_descriptionnull
occupancy_statusnull
access_infonull
address_from_descnull
9,103 active national listings 34 states · upserted daily expired deals auto-removed
Mac SSH · per-deal IL detail API call for every "scraped" deal
🔍
Stage 2 — Detail Enrichment
Per-deal IL API call — pulls contact, description, financials, access
🍎 Mac · no rate cap · all unprocessed deals
What gets extracted from the detail API
contact_name contact_phone contact_email contact_firstname contact_lastname account_company listing_description occupancy_status access_info condition emd_amount repair_estimate meta.hasOpenHouse meta.docsCount address_from_desc contact_match
■ derived = regex-extracted from listing_description text (e.g. street address embedded in the description body)
Example — what a real description gives us
Record after enrichment
contact_name"Mickael OMD"
contact_phone"3053992749"
account_company"Off Market Deals LLC"
occupancy_status"Vacant"
condition"Full Rehab"
address_from_desc"6571 Park St Hollywood FL"
enrichment_status"enriched"
Signals extracted from description text
access"sight unseen priority"
motivation"as-is assignment"
multifamilyno (SFR)
hoa_flagnone
closing_deadlinenot specified
roof_yearnot specified
photo_link"photos.app.goo.gl/..."
1,300 enriched total 77% have phone number 21% have email FL: 506 enriched · complete
VPS · Nominatim + Google Maps Geocoding API · lat/lng → rooftop address
📍
Stage 3 — Geocoding + District Tagging
Convert lat/lng → verified street address · assign FL district by county
🖥️ VPS · Google Maps + OSM · $0.005/call
What geocoding gives us (per deal)
address_from_google address_from_osm neighborhood meta.geocodePlaceId meta.geocodeLocationType county meta.fl_district
Location type hierarchy (Google)
ROOFTOP
Exact match · pinned to structure
RANGE_INTERPOLATED
Estimated from street range
GEOMETRIC_CENTER
Center of area · less precise
FL district mapping — county → district
Southeast
Palm Beach · Broward · Miami-Dade · Monroe
127 deals
Central West
Hillsborough · Pinellas · Pasco · Manatee · Sarasota
540 deals
Central East
Orange · Osceola · Seminole · Brevard · Polk
384 deals
Northeast
Duval · Clay · St Johns · Flagler · Nassau
267 deals
Southwest
Lee · Collier · Charlotte · Glades
262 deals
Northwest
Escambia · Santa Rosa · Okaloosa · Leon
97 deals
438 geocoded total FL 100% complete — 386 deals 2,106 FL deals district-tagged TX · OH · GA · NC pending
VPS → HubSpot API · PATCH deal by hubspot_deal_id · 5 field writes per deal
🏢
Stage 4 — HubSpot Sync
Push geocoded address + district into the deal record in CRM
🖥️ VPS · sync-geocode-to-hubspot.js · per state
Fields written to HubSpot deal properties
property_address property_full_address property_neighborhood property_county property_district
■ pushed = written to HubSpot via PATCH /crm/v3/objects/deals/{id} · matched by hubspot_deal_id stored in Supabase
What a synced deal looks like in HubSpot
HubSpot deal properties (after sync)
property_address"6571 Park St"
property_full_address"6571 Park St Hollywood FL 33024"
property_neighborhood"West Hollywood"
property_county"Broward County"
property_district"Southeast"
Supabase tracking fields updated
hubspot_syncedtrue
geocode_hs_synced_at"2026-04-30T18:21Z"
hubspot_sync_status"synced"
hubspot_deal_id"57835869200"
482 FL deals fully synced 5 properties written per deal 863 non-FL deals pending geocode
Manual authorization → unified-outreach-engine.js → Quo API → SMS to CH phone
📱
Stage 5 — Quo Outreach
Deal-specific SMS to contract holders via Quo — grounded voice, one question
🔐 Manual Auth Required · OUTREACH_ENABLED gate
Outbound phone lines — Quo
(407) 974-6227
Southeast FL
Shared — David · Angel · H3
Additional lines to be assigned per district as outreach expands to other FL districts and states.
How the message is built — from DB fields
DB fields read
contact_firstname contact_phone address_from_desc city · state · zip occupancy_status access_info listing_description meta.hasOpenHouse
Context signals extracted from description
📋Access method — appointment only, sight unseen priority, lockbox
⚠️HOA red flags — mandatory club membership, approval required
⏱️Closing deadline — hard dates from listing text
🏠Occupancy details — vacant / owner in it / tenant · multifamily unit count + lease terms
🔍Unusual situations — sell-and-stay, HVAC unknown, old roof, garage conversion, foreclosure
Message format — multi-deal CH example (Mickael OMD · 11 deals)
hey Mickael saw a few of your deals on investorlift 6571 Park St Hollywood FL 33024 - sight unseen offers get priority — are you accepting those now? 1001 S 62nd Ave Hollywood FL 33023 - currently vacant — is there a lockbox or who coordinates access? i see you have a lot more on there too — happy to work through them all which of these is most active for you right now?
✓ first name only ✓ no credentials ✓ 2 deals shown · volume acknowledged ✓ one question only ✓ no specs / no price
Follow-up cadence — mentor voice by touch
T1 · Cold
Mike Ferry
Direct, one question, no fluff
T3 · Response
Manjit Damji
Relational, build rapport
T7 · Stalled
Tom Norton
Certainty framing
T14 · Urgency
Grant Cardone
Scarcity, buyer pool
T21+ · Object.
Todd Terry
Counter, pivot to next deal
Tracking fields written back to Supabase after send
initial_sms_sent initial_sms_sent_at sms_template_used conversation_id touch_count last_outreach_action acquisition_stage
36 SE FL messages drafted and ready FROM: (407) 974-6227 OUTREACH_ENABLED=false · awaiting authorization