He was absolutely the best! He was a steady presence in every part of selling my parents house. I completely put my trust in him and he made it a smooth process. I appreciate his guidance and all his time and effort he put in to ensure everything got done in a timely matter. I never had to worry once. Thank you John J. Rivard. I'm very thankful to you. Marie Ann Parker
5.0
John was a great guy as well as an awesome Realtor! He helped us from day 1. Always there for any questions we had and anytime. Very professional and helpful. I will recommend him to anyone I know looking for a house. Truly John was a godsend to us and made everything very easy. Also John went above and beyond negotiating us to stay here and rent our house back! He's an amazing guy and Realtor! Matt Rickert
5.0
He did a fantastic job! Julie
5.0
Julie
Featured Listings
72177
A: SELECT * FROM `lpdotcom`.`props-main` WHERE (`props-main`.`City` LIKE '%Atwater%' OR `props-main`.`City` LIKE '%Merced%') AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-21' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
449
$5,053,000
1.04
402 Mercy Ave
Merced, CA 95340
$509,990
5
4
2,554
0.15
39 Blueberry Ln #03 ST
Merced, CA 95341
$85,000
2
2
1,600
2499 E Gerard Ave #50
Merced, CA 95341
$85,000
2
2
1,600
2499 E Gerard Ave #50
Merced, CA 95341
General Inquiries
Please provide the following information and John J. Rivard will assist you.
* indicates required fields.
Loading...
Saving...
Deleting...
Searching...
19133
SELECT * FROM `lpdotcom`.`users` WHERE `id` = '19133'
SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '19133'