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();
447
$2,250,000
9.00
71 Tyler Rd
Merced, CA 95341
$579,000
4
2
2,455
0.22
307 Noble Dr
Merced, CA 95348
$384,900
4
3
1,889
0.06
1482 Autry Way
Merced, CA 95348
$265,000
1.00
5771 N Siena Ave
Merced, CA 95340
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'