The Pipework mission isn't available until you complete the Lab Fees one. When you finish that earlier mission, Brian calls you and asks you to fetch rent from a woman named Mandy. To begin, set Collect Mandy's Rent as your destination.
Credit: Rockstar Games/Rockstar North
Credit: Rockstar Games/Rockstar North
Credit: Rockstar Games/Rockstar NorthDrive to Mandy's house. As you pull up nearby, you'll find her in the midst of a confrontation with her neighbor. Based on the contents of their debate, it's easy to side with Mandy. Your sympathies may shift over the next few minutes, however.
When you're ready, approach Mandy where she waits by the fence. She invites you inside.
Credit: Rockstar Games/Rockstar North
Credit: Rockstar Games/Rockstar NorthFollow Mandy
As directed, follow Mandy up the steps and along her porch, then through the door and into her kitchen area. She walks past the island and down a hallway, talking as she does. Continue following her to reach her bedroom.
Once she arrives at her bedroom, she grabs her laptop and drops to her bed, where she lies while tending to a billing matter. Soon, a prompt will appear on-screen, allowing you to press L2 and interact with her as she rambles. If you want, you can interrupt her to ask where she keeps the plunger. Otherwise, let her keep talking and she will gently tease you at the end of her speech for entering her bedroom for no real reason.
Credit: Rockstar Games/Rockstar NorthPick up the plunger
Mandy finally reveals that the plunger is waiting just where you might expect: in the bathroom across the hallway from her bedroom.
Cross the hallway and grab the plunger by pressing the TRIANGLE button while standing within easy reach.
Credit: Rockstar Games/Rockstar North
Credit: Rockstar Games/Rockstar NorthFix the sink
Take the plunger into the kitchen you passed through a moment earlier.
When you get near the sink, you'll see another TRIANGLE prompt. Then you can start plunging. Pressing the R3 button replicates the approximate motion of a sink plunger. Do it right and you'll cause a fountain of brown sludge to erupt in the sink.
Next, you'll crawl under the sink for more repair work. At this point, you'll need to press the R2 button to twist the coupling, which should allow you to get at whatever might be blocking the sink. You'll need to continue using the wrench to undo the pipe.
Credit: Rockstar Games/Rockstar North
Credit: Rockstar Games/Rockstar NorthPartway through the process, Mandy arrives wearing only a string bikini and talks to you as you work. Then, you finally find whatever was causing the blockage. Mandy snatches it from your hand and retreats toward her bedroom.
She reconsiders and returns as you are still crawling out from under the sink. Then she offers you a box of cigars as compensation for your hard work fixing her pipe. But as you reach to take one, she slams the lid shut, revealing it was a trap.
Credit: Rockstar Games/Rockstar NorthMandy now talks rather a lot. You can either let her keep going, or target her and interrupt her by pressing the SQUARE button.
Once her speech ends, she storms out onto her porch. You can stay behind to investigate the house. There is a coffee maker on the counter, in case you'd like to pour coffee. You can also grab an apple from her fruit bowl.
Credit: Rockstar Games/Rockstar North
Credit: Rockstar Games/Rockstar NorthMore illuminatingly, you can make your way to the door at the end of the hallway, between Mandy's bedroom and her bathroom. If you enter that door, you'll enter her home office. Examine an object on her desk and you'll take a closer look. It reveals something you might not have expected.
Go out onto the porch to find Mandy staring into the darkness. After a brief exchange, she'll head back inside. If you're not done with her games, you can follow her into the living room. There, she sits on the edge of her couch and you can choose to defuse or provoke her.
Credit: Rockstar Games/Rockstar North
Credit: Rockstar Games/Rockstar NorthAssuming you choose to defuse the situation, as I did, Mandy soon flees to her bedroom once again. Shortly after that, Brian sends a text letting you know that Mandy's rent just came through. He's pleased, and you get to choose how to respond. The mission is concluded.
Head outside and check the street near the fence to find a Macizo Cigar, if you like. Otherwise, you're done here.

