meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='427521' posts_per_page=4 post_type=property
bool(false)
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-11-14 12:28:52
[post_modified_gmt] => 2024-11-14 20:28:52
[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
(
)
)
_yoast_indexnow_last_ping, 1747272902
ffd_listing_title, 95 Red Rock Way #311M, San Francisco, CA, 94131
ffd_mls_id, 425031202
ffd_salesforce_id, a0EUd000004nkLzMAI
num_of_fireplaces__c, 1
num_of_rooms__c, 3
of_units__c, 396
pba__address_pb__c, 95 Red Rock Way #311M, San Francisco, CA, 94131
address2__c, 95 Red Rock Way #311M, San Francisco, CA, 94131
agent_only_remarks__c, Disclosure package available. Text/email Colby for showings and offer instructions-415-279-4556 or [email protected]. Listing agent is related to seller.
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Free Standing Electric Oven
bath_features__c, Marble
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1972
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2025-04-21T10:48:18.000+0000
days_on_market__c, 23
dom__c, 23
ffd_description_pb, Experience elevated living in this sleek, south-facing residence, thoughtfully redesigned with clean lines, high-end features, and an enviable location at the heart of the City. Enjoy an abundance of natural light and breathtaking, rare Bay-To-Ocean views, something truly unique in Diamond Heights Village. This top-floor corner residence has been thoughtfully upgraded, offering sophisticated finishes such as sleek marble countertops, durable bamboo flooring, and stainless steel appliances. With an open floor plan that seamlessly connects the living, dining, and kitchen areas, this condo is perfect for both everyday living and entertaining. The spacious bathroom has been stylishly updated with Waterworks tile and a spa-like rain shower. Plus, the convenient location places you just minutes from dining, shopping, and public transportation, providing the best of SF at your doorstep. Building amenities include gym, heated pool, spa/sauna, and garage parking. You don't want to miss this opportunity!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;See Remarks
pba__floortype_pb__c, Bamboo;Carpet;Tile
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Roof,Sewer,Trash,Water
pba__hoafees__c, 808
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Wall Furnace;Fireplace(s)
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2025-05-15T00:47:57.000+0000
pba__latitude_pb__c, 37.7463235
pba__latitude_property__c, 37.7463235
listed_date__c, 2025-01-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Colby
pba__listing_agent_lastname__c, Josey
listing_agent_mls_id__c, 815567
ffd_listingagentname, Colby Josey
listing_agent_number__c, 1073187
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 695000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=6bdCurfJ7m9&mls=1
pba__longitude_pb__c, -122.441517
mls_id__c, 425031202
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0O1I00000BBKIeUAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2025-04-21
open_house_end__c, 2025-05-17T15:00:00.000+0000
open_house_start__c, 2025-05-17T13:00:00.000+0000
original_price__c, 695000
overall_days_on_market__c, -82290
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 1800-01-01
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 837.35
pba__propertytype__c, Condominium
ListingId, a0EUd000004nkLzMAI
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 830
size__c, 830
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Red Rock
subdist__c, Diamond Heights
ffd_name, 95 Red Rock Way #311M, San Francisco, CA, 94131
view__c, Ocean;City;Bay;Water;Woods;Forest
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings;Bay Window(s);Window Screens;Solar Screens
pba__yearbuilt_pb__c, 1972
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530982769-1.jpg