{"data":[{"id":"b6cd0161-cd03-46d9-95a0-128f5ff9865b","snapshot":{"id":"761fa914-7bd6-4b2c-9548-e4b2c4a08fa3","zip":"32901","city":"Melbourne","notes":"DEMO ONLY - approved golden-story estimate.","pitch":"6/12","state":"FL","layers":1,"status":"approved","squares":24.2,"tax_pct":7,"subtotal":9150.7,"dump_fees":605,"roof_type":"Architectural Shingles","contact_id":"03f3c255-cd5b-470e-81ab-27ad7195074a","created_at":"2026-08-11T23:14:14.731873+00:00","line_items":[{"unit":"SQ","total":3146,"quantity":24.2,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":1089,"quantity":24.2,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":340,"quantity":4,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice and water shield"},{"unit":"SQ","total":193.6,"quantity":24.2,"item_code":"NAILS","unit_price":8,"description":"Roofing fasteners"},{"unit":"SQ","total":1815,"quantity":24.2,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":1210,"quantity":24.2,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":605,"quantity":24.2,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"margin_pct":20,"total_sqft":null,"updated_at":"2026-08-31T23:14:14.731873+00:00","approved_at":"2026-08-13T23:14:14.731873+00:00","approved_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","facet_count":1,"other_costs":0,"pitch_ratio":null,"overhead_pct":0,"permits_fees":350,"polygon_data":null,"pricing_mode":"retail","waste_factor":10,"facet_details":[],"pitch_degrees":null,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","total_squares":22,"commission_pct":0,"flat_area_sqft":0,"report_pdf_url":null,"approval_status":"approved","report_pdf_path":"generated://redfish/demo/golden-estimate-v1","total_job_price":12239.06,"aerial_image_url":null,"labor_cost_total":3025,"property_address":"100 Redfish Demo Way","rejection_reason":null,"pitched_area_sqft":null,"predominant_pitch":null,"created_by_user_id":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","linear_measurements":{},"material_cost_total":5170.7,"calculation_metadata":{"demo":true,"demo_key":"redfish-golden-estimate","pricing_source":"redfish_price_book"}},"changed_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"761fa914-7bd6-4b2c-9548-e4b2c4a08fa3","change_summary":"DEMO golden estimate approved snapshot","version_number":1},{"id":"97f64852-a777-4768-8737-f7f05c9804e4","snapshot":{"id":"34a5f107-b5b1-4d4c-8e24-9e983517a5de","zip":"32909","city":"Palm Bay","notes":"Baseline pricing populated from the Redfish price book. Review before sending.","pitch":"6/12","state":"FL","layers":1,"status":"draft","squares":44.9,"tax_pct":7,"subtotal":15896.7,"dump_fees":1122.5,"roof_type":"Architectural Shingles","contact_id":"35df1c23-8be8-4de7-a9e4-34f2f5c9df3f","created_at":"2026-04-03T18:27:37.960161+00:00","line_items":[{"unit":"SQ","total":5837,"source":"redfish_price_book","category":"material","quantity":44.9,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":2020.5,"source":"redfish_price_book","category":"material","quantity":44.9,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":595,"source":"redfish_price_book","category":"material","quantity":7,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice and water shield"},{"unit":"SQ","total":359.2,"source":"redfish_price_book","category":"material","quantity":44.9,"item_code":"NAILS","unit_price":8,"description":"Roofing fasteners"},{"unit":"SQ","total":3367.5,"source":"redfish_price_book","category":"labor","quantity":44.9,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":2245,"source":"redfish_price_book","category":"labor","quantity":44.9,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":1122.5,"source":"redfish_price_book","category":"disposal","quantity":44.9,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"source":"redfish_price_book","category":"permit","quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"margin_pct":20,"total_sqft":4079.9999999999995,"updated_at":"2026-08-31T23:14:14.731873+00:00","approved_at":null,"approved_by":null,"facet_count":1,"other_costs":0,"pitch_ratio":"6/12","overhead_pct":10,"permits_fees":350,"polygon_data":null,"pricing_mode":"retail","waste_factor":10,"facet_details":[],"pitch_degrees":26.57,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","total_squares":40.8,"commission_pct":0,"flat_area_sqft":0,"report_pdf_url":null,"approval_status":"draft","report_pdf_path":null,"total_job_price":21261.84,"aerial_image_url":null,"labor_cost_total":5612.5,"property_address":"3241 Wideman Avenue","rejection_reason":null,"pitched_area_sqft":null,"predominant_pitch":"6/12","created_by_user_id":"08e005af-33c6-40b0-afc2-8452ddd21e4f","linear_measurements":{"hips":60,"eaves":80,"rakes":145,"ridges":25,"valleys":30,"dripEdge":0,"parapetWall":0,"transitions":0,"stepFlashing":0,"wallFlashing":0},"material_cost_total":8811.7,"calculation_metadata":{"pricing_source":"redfish_baseline_price_book","review_required":true}},"changed_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"34a5f107-b5b1-4d4c-8e24-9e983517a5de","change_summary":"Redfish baseline price-book snapshot","version_number":1},{"id":"49210322-e9b8-4879-913a-961c6ddcb8df","snapshot":{"id":"d2d9a504-8312-4a37-a643-e7a1a5d2c311","zip":"32905","city":"Palm Bay","notes":null,"pitch":"6/12","state":"FL","layers":1,"status":"draft","squares":22,"tax_pct":7,"subtotal":7165,"dump_fees":837.5,"roof_type":"Architectural Shingles","contact_id":"39eaedb8-319f-4e3c-978b-0ec7ce503905","created_at":"2026-04-03T15:16:21.871768+00:00","line_items":[{"id":"li_1775238426854_3","unit":"SQ","total":2535,"source":"auto","category":"material","quantity":19.5,"is_custom":false,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural Shingles","is_override":false},{"id":"li_1775238426854_4","unit":"SQ","total":877.5,"source":"auto","category":"material","quantity":19.5,"is_custom":false,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic Underlayment","is_override":false},{"id":"li_1775238426854_5","unit":"SQ","total":246.5,"source":"auto","category":"material","quantity":2.9,"is_custom":false,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice & Water Shield","is_override":false},{"id":"li_1775238426854_6","unit":"SQ","total":156,"source":"auto","category":"material","quantity":19.5,"is_custom":false,"item_code":"NAILS","unit_price":8,"description":"Roofing Nails","is_override":false},{"id":"li_1775238426854_7","unit":"EA","total":75,"source":"auto","category":"material","quantity":3,"is_custom":false,"item_code":"PIPE_BOOT","unit_price":25,"description":"Pipe Boot/Jack","is_override":false},{"id":"li_1775238426854_8","unit":"SQ","total":1462.5,"source":"auto","category":"labor","quantity":19.5,"is_custom":false,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle Installation Labor","is_override":false},{"id":"li_1775238426854_9","unit":"SQ","total":975,"source":"auto","category":"labor","quantity":19.5,"is_custom":false,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Tear-Off Labor (1 layer)","is_override":false},{"id":"li_1775238426854_10","unit":"SQ","total":487.5,"source":"auto","category":"disposal","quantity":19.5,"is_custom":false,"item_code":"DUMP_FEE","unit_price":25,"description":"Dumpster / Dump Fees","is_override":false},{"id":"li_1775238426854_11","unit":"EA","total":350,"source":"auto","category":"disposal","quantity":1,"is_custom":false,"item_code":"PERMIT","unit_price":350,"description":"Building Permit","is_override":false}],"margin_pct":20,"total_sqft":2000,"updated_at":"2026-04-03T15:16:21.871768+00:00","approved_at":null,"approved_by":null,"facet_count":1,"other_costs":0,"pitch_ratio":"6/12","overhead_pct":8,"permits_fees":0,"polygon_data":null,"pricing_mode":"retail","waste_factor":10,"facet_details":[],"pitch_degrees":26.57,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","total_squares":20,"commission_pct":0,"flat_area_sqft":0,"report_pdf_url":null,"approval_status":"draft","report_pdf_path":null,"total_job_price":9935.848800000002,"aerial_image_url":null,"labor_cost_total":2437.5,"property_address":"2171 Pelham St NE","rejection_reason":null,"pitched_area_sqft":null,"predominant_pitch":"6/12","created_by_user_id":"4910c3f0-ba7c-4182-8e18-21bd84b85d04","linear_measurements":{"hips":100,"eaves":145,"rakes":0,"ridges":15,"valleys":0,"dripEdge":0,"parapetWall":0,"transitions":0,"stepFlashing":0,"wallFlashing":0},"material_cost_total":3890,"calculation_metadata":{}},"changed_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"d2d9a504-8312-4a37-a643-e7a1a5d2c311","change_summary":"Redfish baseline price-book snapshot","version_number":1},{"id":"25421e07-a6c3-4364-b2e9-5811e6c40135","snapshot":{"id":"0f277991-f7ee-4e1d-a00a-8968095a48fb","zip":"32922","city":"Cocoa","notes":"DEMO ONLY - estimate awaiting homeowner decision.","pitch":"5/12","state":"FL","layers":1,"status":"sent","squares":26.4,"tax_pct":7,"subtotal":9915.2,"dump_fees":660,"roof_type":"Architectural Shingles","contact_id":"8ae58970-8eb9-4a18-82c3-cce9e263001d","created_at":"2026-08-30T23:14:14.731873+00:00","line_items":[{"unit":"SQ","total":3432,"quantity":26.4,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":1188,"quantity":26.4,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":1980,"quantity":26.4,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":1320,"quantity":26.4,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":660,"quantity":26.4,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"margin_pct":20,"total_sqft":null,"updated_at":"2026-08-31T23:14:14.731873+00:00","approved_at":null,"approved_by":null,"facet_count":1,"other_costs":0,"pitch_ratio":null,"overhead_pct":0,"permits_fees":350,"polygon_data":null,"pricing_mode":"retail","waste_factor":10,"facet_details":[],"pitch_degrees":null,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","total_squares":24,"commission_pct":0,"flat_area_sqft":0,"report_pdf_url":null,"approval_status":"pending","report_pdf_path":null,"total_job_price":13260.33,"aerial_image_url":null,"labor_cost_total":3300,"property_address":"130 Redfish Demo Way","rejection_reason":null,"pitched_area_sqft":null,"predominant_pitch":null,"created_by_user_id":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","linear_measurements":{},"material_cost_total":5605.2,"calculation_metadata":{"demo":true,"demo_key":"redfish-estimate-awaiting-decision"}},"changed_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"0f277991-f7ee-4e1d-a00a-8968095a48fb","change_summary":"Redfish baseline price-book snapshot","version_number":1},{"id":"04ff158a-a232-4ec1-9bc0-370237f9f5c7","snapshot":{"id":"8e14c17a-ae80-4ccd-968d-86aab57f736e","zip":"32909","city":"Palm Bay","notes":"Baseline pricing populated from the Redfish price book. Review before sending.","pitch":"6/12","state":"FL","layers":1,"status":"draft","squares":35.5,"tax_pct":7,"subtotal":12681.5,"dump_fees":887.5,"roof_type":"Architectural Shingles","contact_id":"95fc090e-5761-4d32-b387-0308d074e524","created_at":"2026-04-14T15:29:57.217265+00:00","line_items":[{"unit":"SQ","total":4615,"source":"redfish_price_book","category":"material","quantity":35.5,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":1597.5,"source":"redfish_price_book","category":"material","quantity":35.5,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":510,"source":"redfish_price_book","category":"material","quantity":6,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice and water shield"},{"unit":"SQ","total":284,"source":"redfish_price_book","category":"material","quantity":35.5,"item_code":"NAILS","unit_price":8,"description":"Roofing fasteners"},{"unit":"SQ","total":2662.5,"source":"redfish_price_book","category":"labor","quantity":35.5,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":1775,"source":"redfish_price_book","category":"labor","quantity":35.5,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":887.5,"source":"redfish_price_book","category":"disposal","quantity":35.5,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"source":"redfish_price_book","category":"permit","quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"margin_pct":20,"total_sqft":3229.9999999999995,"updated_at":"2026-08-31T23:14:14.731873+00:00","approved_at":null,"approved_by":null,"facet_count":1,"other_costs":0,"pitch_ratio":"6/12","overhead_pct":10,"permits_fees":350,"polygon_data":null,"pricing_mode":"retail","waste_factor":10,"facet_details":[],"pitch_degrees":26.57,"tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","total_squares":32.3,"commission_pct":0,"flat_area_sqft":0,"report_pdf_url":null,"approval_status":"draft","report_pdf_path":null,"total_job_price":16961.51,"aerial_image_url":null,"labor_cost_total":4437.5,"property_address":"334 San Filippo Drive Southeast","rejection_reason":null,"pitched_area_sqft":null,"predominant_pitch":"6/12","created_by_user_id":"4910c3f0-ba7c-4182-8e18-21bd84b85d04","linear_measurements":{"hips":110,"eaves":165,"rakes":0,"ridges":45,"valleys":25,"dripEdge":0,"parapetWall":0,"transitions":0,"stepFlashing":0,"wallFlashing":0},"material_cost_total":7006.5,"calculation_metadata":{"pricing_source":"redfish_baseline_price_book","review_required":true}},"changed_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"8e14c17a-ae80-4ccd-968d-86aab57f736e","change_summary":"Redfish baseline price-book snapshot","version_number":1}],"rows":5,"limit":200,"table":"roof_estimate_versions","format":"knocklaunch-table-chunk-v1","offset":0,"schema":"public"}