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 #204N, San Francisco, CA, 94131
ffd_mls_id, 422692631
ffd_salesforce_id, a0E8W00000YZHtJUAX
num_of_fireplaces__c, 1
num_of_rooms__c, 2
of_units__c, 396
address2__c, 15 Red Rock Way #204N, San Francisco, CA, 94131
pba__address_pb__c, 15 Red Rock Way #204N, San Francisco, CA, 94131
agent_only_remarks__c, Calling/texting Listing agent Jay Zhu 415-730-1822 for private showing appointment, Escrow is opened with Gerrie at Chicago Title (1929 Market St), prefer to use them. Seller is increasing buyer's broker commission up to 3% of purchase price, please send your buyers and let us to sell this stunning view unit.
appliances__c, Dishwasher;Disposal;Electric Cook Top
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1972
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-10-18
ffd_createddate, 2022-09-08T20:48:57.000+0000
days_on_market__c, 314
dom__c, 65
ffd_description_pb, This brand new remodeled 2-room studio is perched on top of Diamond Heights with stunning 180-degree view of San Francisco Skyline and beyond. The unit offers new waterproof vinyl floor throughout, new lightings, new cabinets, marble countertop and appliances. One-car deeded parking, bright open floor plan, fireplace, and nice size walk-in closet. The building has an elevator & laundry. Amenities include community clubhouse, fitness center, heated pool, hot tub, sauna, and EV charging stations. Shopping and dining are just two-minute drive to the nearby Noe Valley district.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Other
pba__floortype_pb__c, Vinyl
hoa_fee_includes__c, Common Areas,Elevator,Maintenance Exterior,Management,Pool,Trash,Water,See Remarks
15 Red Rock Way #204N, San Francisco, CA, 94131 - Property Description
This brand new remodeled 2-room studio is perched on top of Diamond Heights with stunning 180-degree view of San Francisco Skyline and beyond. The unit offers new waterproof vinyl floor throughout, new lightings, new cabinets, marble countertop and appliances. One-car deeded parking, bright open floor plan, fireplace, and nice size walk-in closet. The building has an elevator & laundry. Amenities include community clubhouse, fitness center, heated pool, hot tub, sauna, and EV charging stations. Shopping and dining are just two-minute drive to the nearby Noe Valley district.
