Array
(
[ID] => 12155
[post_author] => 4
[post_date] => 2018-10-29 01:19:04
[post_date_gmt] => 2018-10-29 01:19:04
[post_content] => Above it all and sometimes in the fog, Diamond Heights has some great mid-century homes in the neighborhood overlooking Noe Valley. Diamond Heights Village dominates the neighborhood with nearly 400 condos, some of which have incredible downtown and Bay views. You'll need a car or quads of steel to get around in this 'hood.
[post_title] => Diamond Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => diamond-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:32:42
[post_modified_gmt] => 2024-04-11 15:32:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12155
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 15 Red Rock Way #308N, San Francisco, CA, 94131
ffd_mls_id, 421547471
ffd_salesforce_id, a0E1I00000UTwWqUAL
num_of_fireplaces__c, 1
num_of_rooms__c, 2
of_units__c, 396
address2__c, 15 Red Rock Way #308N, San Francisco, CA, 94131
pba__address_pb__c, 15 Red Rock Way #308N, San Francisco, CA, 94131
agent_only_remarks__c, No lockbox or sign on building. Easy to show. Contact David at 415 828-3615 or [email protected] to schedule (do not use Showingtime). Buyers and their agents to provide their own masks and follow COVID protocols. Disclosure Link: https://app.disclosures.io/link/15-Red-Rock-Way-308N-xbr1jee1 Please use North American Title, Katerina Rosignuolo.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Oven
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1972
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-06-07
ffd_createddate, 2021-06-04T17:47:55.000+0000
days_on_market__c, 775
dom__c, 21
ffd_description_pb, Imagine waking up to stunning views of downtown San Francisco and the Bay every morning! This top floor condo features exposed beam ceilings, gas fireplace, wood floors, and walk-in closet. Enjoy resort style living at Diamond Heights Village with attractive amenities including a heated pool, spa, dry sauna, clubroom with pool table, lounge, walking paths, and a large, recently renovated gym. This large studio with sleeping alcove comes with one deeded parking space in the secure garage. HOA dues include earthquake insurance. It's a 3 minute drive or 9 minute walk to Diamond Heights Shopping Center with a Safeway, Walgreens, cafes and other services. Welcome home to your million-dollar view!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Earthquake Insurance,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Sewer,Trash,Water,Other,See Remarks
15 Red Rock Way #308N, San Francisco, CA, 94131 - Property Description
Imagine waking up to stunning views of downtown San Francisco and the Bay every morning! This top floor condo features exposed beam ceilings, gas fireplace, wood floors, and walk-in closet. Enjoy resort style living at Diamond Heights Village with attractive amenities including a heated pool, spa, dry sauna, clubroom with pool table, lounge, walking paths, and a large, recently renovated gym. This large studio with sleeping alcove comes with one deeded parking space in the secure garage. HOA dues include earthquake insurance. It's a 3 minute drive or 9 minute walk to Diamond Heights Shopping Center with a Safeway, Walgreens, cafes and other services. Welcome home to your million-dollar view!
