Cancel

Open app

Search

Dream Fountain

4.5 (2 reviews)

Dream Fountain Photos

Recommended Reviews - Dream Fountain

Your trust is our priority, so businesses can't pay to alter or remove their reviews. Learn more about reviews.
Yelp app icon
Browse more easily on the app
Review Feed Illustration

5 years ago

Helpful 9
Thanks 0
Love this 8
Oh no 0
Photo of Ric C.
322
582
8162

9 years ago

Helpful 6
Thanks 0
Love this 7
Oh no 0

Verify this business for free

People searched for Local Flavor 1,033 times last month within 5 miles of this business.

Verify this business

The Flintstone House - Turtle rock

The Flintstone House

4.1(12 reviews)
6.9 mi

Neat local flavor to take a look out…read more It's actually someone's house that they live in, so make sure to be mindful and polite when visiting (because I can't imagine how annoyed the neighbors would be with randos going in and out as well as just thinking this place is an eyesore with how rich and pretentious the neighborhood already seems). There are statues of the saber tooth there and Fred, some dinos. Lots of purple and orange colors. It's not only just Flintstones theme as there are bunnies, aliens, Terracotta warriors and an eclectic mix of decor. Neat, fun and interesting stop if you're nearby and on the way somewhere else.

Flintstones House Hillsborough CA Wed 4/12/23 ©…read moreLet me start by saying, this quirky house is not a tourist destination! For decades, this prominent feature in Hillsborough hills just off the scenic route Hwy 280 brought happy feelings to passers by! Of course it's been a curiosity for decades in existence... but wait! All it is, a wonderful single family residence, with a twist in a story full of intrigue & litigation! And it has its own Wikipedia page! I've told myself, Grey, you live close by, you've got to write about the Flintstones House! It's a curiosity worth noted, yet a source of controversy to its neighbors! A colorful authentically looking residence in the affluent Hillsborough community uniquely affected the inner moods within the neighborhood, while much of the story remained hidden from public eye. The listing wasn't on the Yelp maps until recently, a yelper put it on during the pandemic, the house itself has been gracing the hill for decades in existence. The Flintstones house has been renovated & changed hands some years ago... I believe it used to sport an off white stucco, at some point it got repainted bright orange & purple... sold in 2017 & that's when complaints began. As the storytelling goes, the original Flintstones suburban sprawl developed in real life! Much controversy to it in the recent years due to the current owner coloring it even brighter burnt color resembling the cave & decorating the yard even more...beauty is in the eye of the beholder! Neighbors considered yard decorations an eye sore! So they brought forth the law suits. The installations of dinosaurs became a point of contention. Maybe historic inaccuracies were getting on their nerves? :-) After all, all we know is that Fred & Wilma enjoyed the company of their pet dinosaur Dino, but were there many others in the Stone Age? What about a Giraffe, a woolly mammoth, and a Fred Flintstone himself?! I understand neighbors didn't want any attention in the affluent town they reside in. Well, the owner won the law suit! She gets to keep her dinosaurs! Not only that, but also $125K from the city for originating the architectural review in the first place! And we the public got to enjoy this amazing architectural creation for years to come! *Well, he packed his guitar and his bar-room tan, Gotta get some miles behind him as fast as he can, Another destination, some place else to play. *But as the night approaches, a change is in the air His heart is pumping fast, he's got no cares The music befriends him, it can take him anywhere It's a honky-tonk engagement But there's no better place to play His mind feels like crazy pavement He's getting crazed out every day [ Review #766 w 2 pix on May 2, 2023 ] Flintstones House! Hillsborough CA Wed 4/12/23 Yabba Dabba Doo! @Flintstones House Hillsborough CA Wed 4/19/23

Photos
The Flintstone House - Alien on mailbox

Alien on mailbox

The Flintstone House - Sign

Sign

The Flintstone House

See all

Yelp Community Event: Orangetheory Fitness

Yelp Community Event: Orangetheory Fitness

5.0(10 reviews)
2.8 mi

My legs are currently dying as we speak... AHAHAHAHHAA…read more Had the opportunity to try out an orange theory class not knowing what to expect. It was not an easy class but our coach Krystina was fantastic. She held us all accountable and motivated throughout the hour class. We rotate between 3 different workouts with the water rowing machine being my favorite. The classroom was able to accommodate around 20+ ppl I want to say and it was enough room for all of us to move around. The machines and mats were clean and they provided sanitation wipes. Overall, such a great class and I would highly recommend to anyone looking to build a routine or just start off their fitness journey. Thank you Orange Fitness Team for this opportunity! And thank you Paolo for organizing this event and surprising us with a bunch of Yelp goodies and snacks! 10.27.2024 | Sunday @12pm

Big thanks to Paolo and Orange theory for this awesome Yelp event! And thank you Kristie L for…read moreinviting me to get my butt kicked by this high energy HIIT class We started off the session with signing up for a number rower or treadmill, which we would move clockwise to each correspondence number as the session progressed. Unfortunately there were not enough heart rate monitors for everyone in the class, i was hoping to get a more detailed look into Orangetheory's red orange zone and see how I did in the class There were three stations and our trainer guided us through each, helped motivate and push us to keep hitting our target. I enjoyed the music that was playing too. I liked that there was sanitizing wipes readily available for everyone to use after every round. After our class, Paolo had yummy treats and yelp swag for us!! Incredibly thankful.

Photos
Yelp Community Event: Orangetheory Fitness
Yelp Community Event: Orangetheory Fitness
Yelp Community Event: Orangetheory Fitness - Gym area

See all

Gym area

Arroyo Park

Arroyo Park

4.0(6 reviews)
6.3 mi

I've lived two streets away from this little creek and park for six years and never realized it,…read morebut this year during quarantine I noticed it on Maps and had to check it out. The first time I came here I was actually a little scared! It's a legit woodsy area right next to a neighborhood, with a small babbling (or maybe trickling) creek. The mallard ducks like to call this place their home, mostly visible in early morning or evening (you can sometimes catch them sleeping!). After you get used to the insular quietness of this park, you come to really appreciate it! It's a very short path (I think my Fitbit logs it as about 200-300 steps across), but it's very peaceful. You can listen to the birds chirp, the squirrels rush about, and the water and gentle rustling of leaves. I also found it funny to catch the squirrels yelling their heads off more than once. It's located between two streets, so you can clearly see houses on both sides, and it's pretty safe. I'd recommend taking a stroll! But not too many so I can keep the quietness to myself :)

Arroyo Park is probably one of the honey's favorite parks in the area due to the mallard ducko…read morefamily that is in residence in the stream. We originally thought it was just the drake and his two ladies, but it turns out there's at least two drakes and three hens, though we don't usually see them all together. The park is open during daylight hours and is usually pretty quiet, surprising for being not that far from the bustling El Camino street. You can hear the brook babbling and birds, and it's really quite a lovely stop.

Photos
Arroyo Park - Historical park sign

Historical park sign

Arroyo Park - Fun in cool water

Fun in cool water

Arroyo Park

See all

City of Colma

City of Colma

4.5(11 reviews)
4.3 mi

I find that this city is a little unusual, in that all of the cemetaries were moved here when the…read morepopulation of San Francisco was increasing (there is only one cemetary left in SF, it is for dogs or pets, I think that I read this in a guide book a long time ago). This city is the next one over from Daly City, but it is just before South San Francisco. True story: when we would cut class, often times, my friends and I would check out the graves at the nearby cemetaries, but first, we'd go to the local corner store and buy a snack or a drink. We'd read the stones and when we saw a young child or baby, we'd be sad. We weren't disrespectful. I think we were just killing time, until we could sneak into a friend's place nearby. My school was called Colma Middle School, but when the principal retired, it was renamed Thomas R. Pollicita Middle School. It was the closest middle school within the district from my home on Edgemar Street (off of Lowell). I'd take the Sam Trans bus there, but I'd catch it near Templeton. Sometimes, I'd get a ride home, I guess that depended on the schedule. I went there for three years.

For as long as I can remember, the City of Colma was only known as one thing.....the burial…read morelocation of my family members, grand parents, god parents, and close friends of the family. I work in the essential services, and I sometimes visit customers/ patients who live in or near Colma. When I get to their front door, I can see a cemetery nearby. It's hard to tell if I'm in Daly City, Colma, or South San Francisco. Rest in Peace, God Bless.....

Photos
City of Colma - Got this today  for  checking in the business.

Got this today for checking in the business.

City of Colma - Got this today for checking in.

Got this today for checking in.

City of Colma - Only in Colma! Where more reside underground (cemeteries) than above! It's actually vintage but no way I'm bringing it home lol

See all

Only in Colma! Where more reside underground (cemeteries) than above! It's actually vintage but no way I'm bringing it home lol

Dream Fountain - localflavor - Updated May 2026

Loading...
Loading...
Loading...