Claude AI Strategy That Gives Buyers The Upper Hand with Scott Selleck

In this instructional video, real‑estate veteran Scott Selleck demonstrates a step‑by‑step workflow that combines traditional MLS and public‑record data with Anthropic’s Claude Cowork/CoPilot to produce a highly detailed, data‑driven comparative market analysis (CMA) for a Fair Lawn, New Jersey, 4‑bedroom, 3‑bath colonial located in an AE flood zone. Scott first gathers grounded source documents – MLS listing, seller disclosure, flood maps, zoning information, floor plans, tax records, and historic sales comps – and organizes them in a dedicated folder. He then uploads these PDFs into Claude Cowork, provides the MLS link, and instructs the agentic AI to read, cross‑reference, and synthesize the information. Claude pulls supplemental data from Zillow, FEMA, RPR (Realtor Property Resources), Realist, and other public sources, calculates flood‑insurance costs, applies flood‑zone discount percentages (5‑10 % based on research), and produces adjusted value ranges. The AI iteratively refines the analysis as Scott adds more detailed agent‑generated reports, resulting in multiple versions of the CMA that incorporate absorption rates, days‑on‑market, sold‑to‑list ratios, and market‑trend metrics. Claude then generates concrete offer strategies – competitive, serious, and aggressive price bands with escalation clauses – and formats the findings into a polished 12‑page PDF and a 20‑slide Gamma presentation for the client. Throughout, Scott highlights the importance of grounding AI output in verified MLS data, discusses challenges accessing the MLS via the Claude Chrome extension, and underscores his 34‑year real‑estate experience and AI‑agent certifications that lend credibility to the workflow. The video serves as a practical guide for agents seeking to leverage AI as a research partner while maintaining data integrity and delivering superior buyer‑focused insights.
Chapters
Okay, so this room is going to be— this video is going to be covering using Claude Cowork and the different applications to do an analysis on a property for a client that is looking at Fairlawn. And I'm going to use the different tools that I use and set up with Cloyd Cowork to see if we can produce a very thorough report that really gives the client a clear picture that this property we're looking at is a good, a good investment. So I'm going to go into Cloyd Cowork first. Actually, before I go into Cloyd Cowork, I'm going to pull up the MLS information for the property and download it. So, let's see and take the MLS number from here. And paste it here. MLS. I have not asked Claude Coworker to take over my New Jersey MLS yet. Right now, I'm just doing homework on the property, gathering reports. So I can basically have them feed CLOiD co-work with the project, but I am gonna do a whole CMA, and then CLOiD is going to access my MLS data and help me to basically make the best overall evaluation. Okay. We're looking at 42-08, cost report. Right? So I'm gonna go down to a folder here. And I'm going to— I'm just gonna create a folder on my desktop so I can keep everything in one place for today. I'm gonna call it 4842-S08. Okay, that's the folder we're going to use. Shrink that down because we're going to need to get a couple of things here. One is we're going to go in and get the seller disclosure. Client's gonna want to review that. The first thing, there's also floor plans. Oh, it is gonna love this. 2208, Oscrow Court, Fair Lawn, floodplains. And we got that. We're gonna go to the real list report. Here's the flood determination. I'm gonna download this. Going right into— that's too easy. Let's go up here. There's a flood map, flood zone. There it goes. PDF. That's where I want to put it, right in here. Save. So I got a flood map. I got the seller disclosure. I got floor plans for this place already. I'm going to close this. Go back this way. Got this property report. Custom print. Custom printouts gives me more information about the property than the basic quick report. Now, the sales comps in a realist report are not really that great for value, but the neighborhood profile, the neighborhood, you know, the other details and the tax records, past sale information are good. You see what I'm doing? I'm building a story. 25 pages, 25-page story. Notice I'm not doing a search through ChatGPT or Claude or Perplexity yet. I'm doing what information is available to me in my resources as a realtor with the MLS and supporting services, because that's the grounded information. That's the most accurate information. I'm going to let Claude review everything and help shape, shape it. But basically, I'm making sure that this thing is not going to be hallucinating and they're working on real grounded information. All right, so we got, um, pretty good information. Now, what I'm curious about too is the zoning map, because this is a very large— it's kind of an unusual property on a cul-de-sac. I want to see the shape of the lot. So we have fire hazard and risk building permits. Something is opening right behind us. I don't think I need this. Okay, so I have some pretty— a pretty good starting place right now. Um, it's a New Jersey MLS open. I'm going to print out The agent full report. I mean, I'm going to save it as a PDF because this will give me additional information. So agent full report. It's just into parcel, archived history, any kind of history, tax, photos. That's basically adding on additional data. I guess it's not letting me do that. Okay. Saving it as a PDF. Put your stuff here. Airline. Go engines. MLS matrix. Okay. That's a pretty good start. So if we were to go back here, Go back to results. So we have a 4-bedroom, 3-bath, 3 full baths. Right. We have built in the 1970s. 1970s, essential air. You got a lot size 7,800. That's a pretty good-sized lot. And we're going to go with style colonial. All right, the reason why I'm taking— writing this information down Also in a flood zone. This is pretty relevant. In the cul-de-sac. The taxes are close to $20K. Okay. So what I'm going to do is I'm going to come in here and I'm going to do a search. I'm going to go Airline, active, under contract, sold, withdrawn in the last 80 days, expired, is there in 180 days. I'm going to go properties over $900,000. Let's call it $1.2 million. We know it's 4 bedrooms. We know it's a colonial, but let's keep that open. We know the age, 1970s. Okay. So let's— and we're going to go back with sales data. I'm just going to go back. I'm going to give access to 3, almost 3 years of data. It's 29 listings. Right? And I'm going to basically choose all. I'm going to do export. Export. Bass. Bass. Desktop. This is going to be Fair Lawn sales data for past 3 years. 4-bedroom, 3-bath single-family. Almost 900 to 1 main. I mean, alright. I'm also gonna leave this, this, The MO is open right now because I want Claude to be able to access it too and look through this data as well. So now I'm going into Claude, and basically I'm in cowork, and I want to, you know, I'm gonna tell it what I want to do. I want to evaluate— I want to do a market analysis deep dive into 42-08 West Grove Court, Fair Lawn, New Jersey. And buyers interested in purchasing this 4-bedroom, 3-full-bath colonial built in the 1970s. On a old, on a in a flood zone, well maintained, 7,800 square foot lot. Okay, access. Yeah, please review attached files. Oh, don't access. My New Jersey MLS link. I'm gonna go here to my New Jersey MLS link right at the top. I'm gonna go and deploy it for additional review. Of sales, those documents, sales information going back 3 years. You know, is this property overpriced? How does the flood Status affects the value of the property. Flood zone documents attached. How much is flood insurance for this property? Foundation fell on FEMA research. Connect through Claude from connection. We use web to supplement sales data attached to do full analysis and provide recommended offer. It's anticipated That there will be a bidding war on this property because it's in good condition. Upgraded large kitchen, huge rear deck, nice, nicely situated in the dead-end street with terrace. Start spelling the spring. Backyard woods and water stream. And I'm gonna go here and choose a different folder. I'm gonna choose a different folder. I'm actually gonna use the folder I created, include, to drop any information in. And now I'm gonna use the star. I'm gonna add information. And I'm just gonna update, upload all this information into Claude. Notice I'm leaving open the MLS. Alright. I'm also leaving open right now. Realist. I have open, uh, I do not have NPR here. Let's see. Well, I'm just— now the thing about Claude Cowork is I'm— if you notice, I left Claude Cowork to do other things because it's, it's an agentic agent. So it's basically researching the questions right, right now. And you see, the first thing it says, let me pull down all this data first, reading everything uploaded. The flood insurance and supplemental information is basically trying to figure out the background information first. Now it's going to grab Zillow data and flood insurance-specific information too. So it's, it's not only looking at my MLS data that I uploaded, it's going into looking at Zillow to cross-reference, and it's also looking at flood insurance information. So we can just let that work. Right now in the background. Right? Well, we go up here. NPR. That's what I opened before. I'm gonna close this here. I'm gonna sign in. I close this one. What I'm trying to do is just close a couple of things because we have video Loom, we got the MLS, we got the Realist open. Okay, here. Yeah, here is the NPR. Now we have the NPR here. So I'm going to go in here and I'm just going to go into the NPR is our, is our National Association of Realtors. Website. You can do research on property values. And I'm going to pull up a report and cross-reference the information. What I'm trying to do is look at the value from different sources, different angles. That's my goal, right? So right here, you see this here? Recommended about $1,097,000. Right now it's listed for $94,000. 4-bedroom, 3-bath. Here's our square feet. I didn't have that before. And then it gives, you know, our RVM confidence is if you, if you get close to 5 stars, telling you that it's got enough information to do a pretty good call on value. What are 5 stars? So it feels, uh, It feels strong. So right now it's kind of leaning towards this $1,000, basically $1,098, which makes sense to me, you know, for the value. I think they— I think from what's property, uh, they basically, um, put it at that price to create a bidding situation. Look at the, you know, the pictures here are just crazy. This place is so pretty. It's— and it sits on a canal. It's a description. So let's see what we can do with RPR here. It's given more information. Market trends, RIF on CMA neighborhood, more updates. So if I want to create a report, CMA template. What I'm doing is I'm basically using this template to create a report for me for RPR to create, in essence, another form of a CMA for the buyers. I'm basically Creating different market reports so the buyers would be able to cross-reference the information. I go back to Claude's. First, so Claude is basically reading through the skills. That I set up in Claude. So it's utilizing my background for 34 years, my ability, how I research sales comps. And now it's building a full analysis of a report. And now it's saying, let me build this comprehensive analysis document. So you can see on the side here, it's checking off the different things it's doing while it's doing it. So again, I don't have to want— I don't have to sit here. I'm letting it do the report, but what I want to do is get this report right here. So I'm just going to go back here and just do a report, make it easier. That's just creating— so RPR just creating a report. I didn't want to pull sales comps yet from the RPR because they usually, you know, it's, it's, it's not as efficient with the sales comps for that platform. But I wanted to have the information available that was straightforward. What What they can pull on the property report that they have, a 15-page report. Because what I want to do is add this report to the evaluation, and I'm also going to keep it open. Now, what's interesting here is I gave this— I gave Claude Cork already access to my MLS. And now it's come back and says, because I asked a question, hi, is this full analysis? Is this place overpriced? And it said, uh, at $494,000, it's priced right at the medium for 4-bedroom, 3-bath colonial. Most of these comps aren't in a flood zone. Flood adjustment fair value sits around $895,000 to $940,000. That said, it's not egregious. The seller has priced the property strength cul-de-sac. River setting, updated kitchen, 3 tiers of decking, mass walkout basement, and the, uh, letting the market decide what the flood zone is worth. That makes sense. The flood zone impact zone AE, AE 0 feet from the 100-year floodplain research consistently shows 5 to 10% value discount. So that's a good gauge, 5 to 10, um, for the AI— for AE properties. Though this is one, this one has positives. No flood claims. House sits above the river level. No water intrusion reported. Seller disclosure makes flood damage says none. So it's read the seller disclosure. This is important. Uh, Claude has read the seller disclosure to confirm that, that I attached. Blood insurance expected around $2,000, $3,500. NFIP risk rating is 20 with a premium increase up to 18% annual until the target rate reached. That's $167 to $292 a month added carrying cost. That's interesting. So it's, it's a, it's a, it's a scale. It's a Increasing scale and the cost for flood insurance starts low and raises up to the high point. No elevation certificate exists, though getting one could help reduce premiums. Offer strategy for bidding war. Competitive, recommended $949,965. Serious respect, uh, $949,000 to $965,000. Serious respects the market, doesn't overpay. Aggressive to win, $970,000 to $985,000 with escalation clause. Do not exceed $985,000. Beyond that, the numbers stop supporting the purchase price. Isn't that interesting? The full report with comps, tables, flood analysis, carrying cost breakdown, seller disclosure flags, and offer tactics here. View your buyer's market analysis. So it basically created the data I provided on the spreadsheets, has created a market analysis for the property. It's formatted this here into, you know, 12 pages. And then it, and it says here, um, the sources that it went to. So it went on the FEMA risk rating map, Stanford flood risk impact on home values, actually cross-referenced this information. Freddie Mac perception of flood risk, NJ climate change, Coldwell Banker flood zone. Buying a home in a flood zone, it, it, that's fascinating. I'm going to add in the, uh, the additional report. That's it. I'm gonna do something a little different. I'm gonna say, okay, to RPR. Okay. Open up the property again, the data. I'm gonna take the link. And I'm gonna go into Claude. Please take this information into consideration and connect. To our paper for additional analysis if needed. The additional report I added in, and it's modifying the presentation to the right. As it's reading and getting more information. This RPR data is a game changer for analysis. A few critical findings that shift the price. Now you see what I did? I'm giving it more reference information. I'm not letting it rely on Zillow. I'm not letting it rely on Redfin. It's relying on MLS information and National Association of Realtors information for equity. RPR. So, saying the RPR data introduces several key data points that need to be folded into the report. Most importantly, this evaluation model paid property at $1,097,000, which is the range, and, uh, $955,000 to $1,224,000 in Fair Lawn running at 102.1% sold to list ratio means a home selling above ask. Let's update the analysis. So basically, it was because the RVM, Realtor Valuation Model, had 4 out of 5 stars and put it at close to $1,097,000 to $1,098,000 with a range of $955,000 to $1,024,000. Claude is putting a high weight on that because it's a detailed analysis model algorithm. And it's adjusting. It's adjusting the pricing. I'm going to ask quick, have you connected to the NJMLS website with the Claude Chrome extension? I wanna know if this is, is it reading my files that I've uploaded, or is it also utilizing— I don't see it connecting to the other websites, which I would see up above on my, my menu when it does connect. to the other websites, it creates a group, and it's, it's a colorful link. It's kind of like showing you that Claude is merging kind of with the Chrome browser. Okay. Right now, it's actually what it's doing first before it's answering that question is it basically is, um, It's rewriting the market analysis based on the additional detailed information from the, the RPR report. You can see it to the right here. It's fascinating. It does. So you see the benefit of working with AI agents, certified agents. You know, I'm Basically doing high-level research with quality data, but I'm leveraging Claude Copilot as a thought partner research assistant to cross-reference information to get the best quality answer and to protect my client to highest level and give them the best advice on what offer to make in this competitive environment without With making sure that they don't overpay for something that doesn't make sense. That's my goal. Best quality advice, best strategy. Now, if you look up here to the top, you see what's in market analysis. This just lit up. That means that Claude right now is trying to access the MLS basically through— see right here, you hear Claude is going into the MLS right now and accessing my MLS. I'm going to shrink this and I'm going to open this here. So it says error address browser is attempting to use above. So Claude is trying to figure out how to get in it. I've given it a link. Um, so it's thinking. Basically, Claude is thinking right now. How do I leverage You know, this information. So it's also— it's connected. I hope that it won't. I'm gonna basically do a basic search that I did for my report. So, by doing this, I am hoping that we'll have an easier time. Yeah, I married the same search that I uploaded. Let's see if this kind of helps Claude be able to access it. Now I'm going to take this link again, and we're going to go into Claude. Down here, the page seems to have navigated. Let me reenter. And I'm just going to kind of spoon-feed it. Why I'm doing this is because Claude was making a decision, right, based on a report that I export. Um, from this search as a folder, but it's a lot different when Claude can actually go in and look at the full information of this entire— all these records. I'm talking about descriptions, past history, everything, not just a spreadsheet of certain fields picked out, um, minimal fields. And by looking at that, it can get the absorption rate. It can get, you know, which is basically, you know, for example, like what a, uh, the place, the final sale price versus the listing price, how much it sells over like an asking price. It can get the days on market. You know, it can get, um, the types, the types of the deals, how many cash deals are there, you know. So it's doing its homework right now. And so, so what I— when you work on something like this, um, you're always trying to give it the most quality information, you know, basically. So if you notice, I went in before and I gave it the end, the, uh, The NPR information. Now that raised the information up a level because it had, it had a good algorithm that really had a good sense of the value, which gave Claude more direction. If Claude doesn't have direction, it doesn't have grounded information from the MLS, it's, it's going to fall back on a generic Zillow or Redfin value. And that's dangerous because that's just aggregate data. You know, that's just the aggregate data is they're just looking at, you know, location, zip code, lot size, interior size, taxes. You know, so they're not, um, you know, they're, they're, um, they're not going to understand the full picture, the details that would be in the history of an MLS. And so, for some reason, it's not letting us access tonight. The MLS. You see here, it says— it's kind of interesting. It says, let me try navigating directly to update the URL you just shared. Now Matrix is searching the URL I just shared. Those links are specifically timed out. Let me use this feed bar search directly with the MLS instead. Now let me press enter to trigger the search. It's actually, if you look in the background, it's trying to do a search on this MLS. It's really interesting. This is the first time I've done this this way. So I'm just more curious of how far Claude can push the envelope with the MLS. I already gave it the data from that report, but I'd love to see it go in and, I mean, there's another way to do it. I don't want to change this because it's trying to mess with this. We'll give it a couple more minutes to see if Claude can figure out how to do this search. If it can't, maybe what I'll do is instead of, um, doing the export— so I said I'm hitting a wall with the Chrome extension. The extension is through cannot access Chrome extension URL. Here's what I suggest in your Chrome browser. Make sure the end is the NJMLS Matrix tab is active and not blocked by any extension popup. Okay. To see if there's any pop-up issue. What I'm gonna do, I'm gonna do it differently. I'm gonna hit this button. So you have this information here. Let's try it this way. I'm going to hit all, and I'm going to go to agent full report for each property, the full report. So basically, I'm going to get— I'm going to do a workaround. I don't know if it will work, but it'd be too much grumbling. Just getting rid of this. There it is. Okay, so it's letting me do the tax and the listing. Photos. Okay, so I'm going to print out the full report for each one, but all put together in one report on a PDF. I'm going to upload the PDF and see if that will help us. What I'm trying to do is get context. You know, the descriptions will help have a better read on the properties. All right. I'm just curious to say yes, I was able to do it last night to pull Evaluate information from the MLS. I'm not going to sit there and dwell on this much longer, but I was just more curious. So now what it's trying to do is trying to create a new tab so we can just Try to navigate the MLS. Keep in mind, I'm still working. I'm just letting it do its thing. That's the beauty of, of, of fluid color. Okay, so it said, good, we're on the residential search page. Let me make— take a screenshot to see the layout. It's actually figured out how to get onto the MLS. Now I can use the MLS Matrix search. Or I'm logged in, Scott, and I can see the full residential search. Let me set up the search criteria to full Fairlawn first to check it out. Sold status search field. Let, let me first search the specific listing by the MLS, then I'll do the broader comp search. Let's use the speed bar and pop search bar. It's actually figured out how to do it. So let's— I'm going to close this for a second. I'm just curious. Look at this. It's put the MLS number in by itself. It's basically teaching itself how to use the MLS right now. It's taking a long time. So let's just go here. I'm going to just— I'm going to just see what it does by putting the report in. Despair us here, you know, educating Claude on how to navigate the MLS. Not why I'm here for it, but I wanted to see how far I could push it. Now it's saying it keeps getting blocked. So now let's see if it's gonna— now it's gonna review this report. Scott just uploaded a report. That's much more efficient. Make sure your browser connection— let me read it. Let me read it now. Now it's going through this report, which is a full agent, uh, full agent report tax records for each of the comps I pulled over the last 2 years. So this way you can read all the descriptions, every, every detail about the places, not just that little spreadsheet. That I uploaded before. Because what I'm trying to do is have it look at, you know, the absorption rates and then, and the overall descriptions and the age of the place and the condition and the location, everything take more into, more into account. And then it backs into looking at the most consistent data, which houses are You know, close in proximity, close in age, condition. At 95%. As we're waiting for that, the buyer market analysis— this is what's been produced before it reviews this additional data. It's recommending a, a price range up to $985,000. Let's see how it affects the data once it's, it's going to Have more detailed specifics about all the properties. And look at the information I put together on this report. I mean, look how detailed it is. This is like night and day, you know, what a normal CMA looks like. Look at the— how it goes— the selling points of all the upgrades, the dead-end street, comparable market analysis. Now, would it look here? Now it's saying Scott just uploaded. Good. I have the full V2 structure now. Let's— let me build V3 with a version which is the actual CMA sold price incorporated. This change changes the analysis substantially. So let's see, because I gave it before the RPA RPR report, and now I've given it extensive detailed option details of Of all the closed data and active data for the past 2 years. It's going to update this report. Takeaways from comparables. If, you know, so we Key takeaways, Fairlawn market, 4-bedroom, 3-bath home, back to median days on market, 17.5 homes priced correctly, move in 17 days, $949,000 asking on 42, uh, Cosgrove Street, precisely with the median sales price. And 31 Albert Avenue is currently under contract at $1,150,000, sharing the Upper end of the market is also healthy. However, this vast majority of these comps are not in a flood zone. The distinction is critical. A Colonial 949 on a flood zone lot in Fairlawn represents a different risk profile than 949 on Saddle River Road floodplain. The comps suggest 949 is the right neighborhood for the property, but the flood zone should command a discount from that figure. And it's breaking down. Isn't this fascinating? It's broken down this flood information. High-risk 100-year flood distance to 0 feet because there's a canal right next to the house. Community park to Participation status are regular. Coastal barrier resource. Seller-owner since 2003. Flood insurance is currently in place. No flood insurance have been filed. No claims have been filed. No flood damage, no FEMA elevation certificate. Agent remarks, house has never flooded. Flood zone impact on property value. And then because it went on to those different websites to do research, it came up with this grid. National Bureau of Economic Research, 4 to 13% standard. SFHA designated specifically to negative 2, $10,500 per $500,000. That's interesting. So, if it's worth like a million, you're looking like a $20,000 discount. Freddie Mac, ours, 2.3% present baseline. North Carolina study flood, 6.6% average. Zone A, 9% to 18%, less than A or B. Australia comp, 10.8%. Really large range. For this property specifically, a conservative 5% to 8% discount. Okay. So basically, that's why at $949,000 to $975,000 medium comp value, Yielding adjusted fair market of $895,000 to $928,000. And while we're— I'm reading this, Claude is finishing up updating the report right here. Because it's a zero distance from the floodplain, and that's why it's really highlighting this because of the streams right in the back. Okay, now, Claude is saying here, basically version 3, actually sold price is seemingly drastically higher than the list price. Home list $949,000, selling for $1,130,000. So the absorption rate is much— the absorption rate, because it had more detailed information now. And it was able to look at the absorption rate of the list, final sale price, and list price. The average sold to list across 7 closest comps is 107.8. That's 7.8% over ask based on the list, you know, listings. So version 3, the final version here, the new recommendation, range $940,000 to $1 million. Upward revision driven by actual transactions, a recommended opening offer move for $975,000 to $1,010,000, and then the escalation move to $1,015,000 to $1,060,000. Look at the difference for quality information. The flood zone argument actually gets stronger. Every single comp in the CMA is in the non-flood zone, which means that the $1,100,000 median sold price represents a buyer paying without flood. The 5-point flood discount now applied to higher, more reliable base, the new version. And the analysis breaking down how each cell relates to the subject table exactly with the change. So this is the final analysis here. You provide me with a clean report, not referencing changes underneath. Or, uh, 3 versions, but final analysis. So it's going in now. What I'm trying to do is basically take out these areas about the critical version 2 and make it— Come up with a clean final report. Then I'm gonna finish it off by creating a website. I can't hear. I'm gonna create a website through. To gamma. And this is the way to use, you know, basically, um, The MLS data, the RPR data from the National Association of Realtors, the Realist data, the flood insurance data, sales history data going back 2 years, the absorption rate data. The reason why it's very, very important to understand the absorption rate is because of how quick and tight this market is. It's very difficult for buyers to engage in a property and make offers in this competitive market when a lot of these properties are going over. 15 to 40% over asking price sometimes, you know, sometimes 20, 30, 40% over asking price. And they said like, how can I get my hands around that? And the only way to get your hands around that is to understand what's transpired in the last 6 months, 9 months, or 12 months, to 2 years, or more importantly, the last 3 to 6 months of data. Because what What may look like just a couple of properties that, um, that sold over ask, when you look closer at it, there could be a clear trend. And if the— and if, if the seller looked at the same information, or the other buyers that are looking at that same information that are making offers, it's the one that's going to win it. And for the buyers, it's the one that has the clearest picture. of what's going on in the property and how, and how different things are impacted. And, and, and they could be comfortable to make that decision because it's not what the offer price is that's relevant. It's what the real value of the place is that's more relevant. And you can only find that out through looking at the historicals, the patterns, the trends. To understand, you know, what— and also the quickness of how something's— how quickly something's going off the market. You know, so something is— the typical, uh, well-positioned property is not going to be on the market more than 7, uh, 5 days to 7 days in this market if it's done properly. Uh, it's— and it comes out on a Tuesday, you know, it's— or Wednesday. It'll go through the open house on weekend, and the final investment will be done by Tuesday, the following Tuesday, a week. So you have a very small window to make a very important, well-informed decision. You know, and then, and then there's not a lot of realtors that even understand how to even use this, these kind of tools. And, um, and are willing to put the time in to protect, to protect you, your investment, your, you know, your, uh, your future. This is a large asset. There are a lot of great realtors that would, that are training on it right now, you know, but, you know, who you hire matters. You know, I've been in the business for 34 years, you know, and, and I've been studying And went through the Crème Institute of Technology Training to be certified as a buyer's— as a certified AI agent. I completed the boot camp for the AI Advantage last year for Tony Robbins and Dean Grazia. I'm part of the AI Marketing Academy with Jason Pantana. You know, I've I train on this 10 hours a week, 8 to 10 hours a week. Now we have the clean final version of the report. Let's see if it, if it produced what we're looking for. Okay, you're gonna— all the red lines are the references to the versions are done, are out. Interesting. So something happened here. It referenced the RPR report, and it noted that the RPR report, the value, doesn't reference the flood, the proper flood zone. So basically, it says minimal flood risk. Instead of AI, high risk. So it's basically saying that the RVM of the $1,097,000 likely overstates the value because it does not account for the AI designation, the AE designation. That said, the RVM aligns closely with the $1,001,000 median sold price. For non-flood comps. So what does that do for the value? Well, basically, let's see. So you got months of inventory under 1 month, and it created this grid underneath it. Okay. So it says up here, the RPR valuation and market condition. RVM estimated value, $1,097,000. RVM range low, $955,000. RVM range high, $1,250,000. RVM confidence, 3 out of 5 stars, that's moderate. Interesting. So that lowered that. RVM monthly change, $11,590. Yearly change. So basically, the RPR valuation market report shows appreciation in Fair Lawn. At 11%, 0.31, I guess, in the past year. And said price to estimate value, 86%, this well below our number. Price per square foot, $346. So we have market type, seller market, months of inventory. Under 1 month sold the list price, 102.1% home selling above ask, sold the list price, 4-bedroom, 3-bath, 108. So regular single families, the sold the list absorption rate is 102.1%. So it's basically selling 100— over 102% over ask. But if you go to 4 bedrooms and 3 baths, Because it's a larger home, it's close to 108% over ask price. Medium days on the market, 31. Medium sale price— medium sold price for the comps for the 4-bedroom, 3-bath is $1.1 million. This is one of the tightest selling markets in Bergen County and Fair Lawn right now. It's less than 1 month inventory, virtually no No supply. And you got basically the places selling over 102% to 108% over ask. That's a pretty tough environment for a buyer to be in. So the— for the buyer's $949,000 list price, deliberately low anchored based on what comparables homes are actually trading, expect the property to attract a $1 million to $1,050,000 The open house April 5th is designated to generate exactly that kind of competitive. Okay, so that, that's a clear picture. I got this crazy cat that is attacking my computer right now. Um, flood zone impact. Seller disclosure information. So I'm feeling pretty good about this report. I mean, I feel it's pretty accurate taken. I mean, it's fascinating how it caught the RPR, that it didn't highlight the flood designation. That's why the stars went down from 4 to 3. A few days before, when the original report came out, had a confidence level of 4 to 5 stars. But after Claude caught that it designated the— didn't designate the flood insurance, the flood risk correctly, it lowered the confidence level to 3 to 5. So what it's saying right here, at a $1,110,000 recommended offer price, a total monthly carrying cost Is around $72,000. Now, let's break it down to cost of the monthly cost and the flood insurance at $2,000 to $3,500. That's a competitive non-flood zone home would not carry. A comparable non-flood zone home would not carry over 10 years with escalating NFIP rates. The amount to $25,000 to $80,000 additional expense, a legitimate factor in a purchase price negotiation. So basically, over the next 10 years, it's saying that to be in that flood zone, the flood insurance is going to be increasing over the next 10 years, and it's going to cost the owner $25,000 to $80,000 in additional expense. Stellar disclosure flags, valuation triangular, recommended offer strategy, neighborhood snapshot RPR, appendix broader market data, and JM List 3-year window because I went out 3 years. Isn't that fascinating? Bottom line. Bottom line. Let's see. We're going to conclude this here. In the— in this property over— is this property overpriced? No, it's priced significantly below comparable homes that are actually trading. The median sold price, 4-bedroom, 3-bath home in Fairlawn, is $1.1 million. The average sold to list is 178%, 108%. At $949,000, the list agent is running a textbook attracting Pete's strategy, the data says it will work. Your buyers do have a legitimate negotiation advantage that other buyers may not fully appreciate. The zone, flood zone, every, every single comparable sale in CMA database is non-flood zone. The subject zone AE designates a real and ongoing cost that reduces the property's value relatively to comps. The flood zone translates to 2,000 to 3,500 years in mandatory flood insurance increase up to 18%, potential resale friction and elevation certificate from the seller over 10 years. A 10-year hold, the cumulative carry cost would be $25,000 to $80,000, plus buyers who don't account for this will overpay. Uh, a penalty of $25,000 to $50,000. $50,000 plus. Buyers who don't account for this will overpay. That said, the property delivers something generally rare: a private south-facing riverfront cul-de-sac with updated finishes, 3 tiers of decking, a massive finished basement, and direct access to Saddle River and county parkland. But buyers who value this— this is one of the few properties in Fairlawn that offers that. Recommended offer price: $1,010,000 with an escalation clause to $1,060,000. This positions the buyer as a serious contender at $108,000 sold at list market, which maintains a discipline of its own expense. That actually puts a disclaimer at the bottom here that, you know, this analysis is for information purposes and does not constitute an appraisal. All pricing insights and framing of market context, market positioning. Data sources is awesome. It lists the data sources here. Data sources: RPR, Realtor Property Resources, NJMLS, Full Agent CMA, FEMA, CoreLogic, public records, RPR, uh, computer-generated estimates, no appraisal flood insurance estimates based on available NFIP data and should Confirm with licensed agent prepared by Scott Selleck. That is amazing. So now I'm going to go do something really cool. I'm going to say here now, can you please create a Come on, you. I can't see you right here. Come on, get out of here. Can you please create a gamma app presentation from this report? For 20 slides. Now I'm asking Claude to take this report, right, and create a Gamma presentation, slide presentation. That's— I'm gonna have an active link. And I'm going to send my client. And this is like, you know, residential CMA on steroids. And this is the way for the future. You can do this with a little kitten and, and a commitment to excellence. I'm doing the presentation. I'm trying to open up this file. Because what? I've been at this for an hour and twenty minutes. Crazy. I actually stopped it. I stepped on my computer. No, no, that's okay. So I just downloaded— hopefully it didn't mess up my thing. The cat is attracted to the lights on the computer. Otherwise, my little cat mouse is watching the mouse go back and forth and is trying to attack my mouse. Okay, so let's, um, go here. I'm letting Claude— now I haven't even been looking, gone back to even see what a presentation is yet. Okay, so now Claude Your Gamma presentation is generating now 20 slides. It's using a marine theme. It should only take a couple more minutes. You're gonna love this. I'm just moving this over. Come on. Okay. What I'm trying to do is I'm gonna send my client the full report. That's the full report. I'm going up. Okay. So this is our final step. I created a Gamma presentation from the PDF report. Check this out. Oh, with this little critter sitting here. That's not easy. Jacking my whole thing here. Look at this. Look at this gorgeous report. Yeah, what's cool about gamma, right, is, um, I can— now I'm in gamma right now, my program. I can basically edit this picture. This picture is not airline and is not the water picture. If I just go— I'm going to go over the MLS. And, um,
More from Scott

Fort Lee, Cliffside Park & Edgewater Realtor | Scott Selleck, KW City Views Realty

Fort Lee, Cliffside Park & Edgewater Realtor | Scott Selleck, KW City Views Realty





