meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='377392' 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-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
(
)
)
_yoast_indexnow_last_ping, 1715302565
ffd_listing_title, 135 Red Rock Way #105L, San Francisco, CA, 94131
ffd_mls_id, 424017596
ffd_salesforce_id, a0EUd000001ZGZBMA4
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 396
address2__c, 135 Red Rock Way #105L, San Francisco, CA, 94131
pba__address_pb__c, 135 Red Rock Way #105L, San Francisco, CA, 94131
agent_only_remarks__c, Offers as they come. Unit needs just a little TLC. Kitchen and baths can be updated. Great light in unit and the patio space really adds to the unit.
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1972
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-04-10
ffd_createddate, 2024-03-26T21:47:31.000+0000
days_on_market__c, 44
dom__c, 35
ffd_description_pb, 135 Red Rock Way #105L is a modern, urban retreat in San Francisco. This spacious studio offers smart and efficient use of space including a sleeping alcove and defined dining and living room areas. There is 650 square feet of living space plus a private, large, south-facing patio, which not only enhances the interior living space, but also allows for abundant light. There are three good-sized closets and a gas fireplace. A kitchen, full bath with separate vanity area completes this space. One-car parking and laundry facilities are located within the building. The Association, Diamond Heights Village, offers a lush, landscaped common area, with exotic plantings, streams and bridges. There is a beautiful swimming pool, club house, and a well-equipped gym. Located in the Diamond Heights neighborhood, there is good access to public transportation, freeways, and shopping at the Diamond Heights Shopping Center. The Castro, Noe Valley, and Glen Park are just minutes away. This condominium has wonderful potential and can be the perfect starter home or pied a terre in the City.
district__c, SF District 4
driveway_sidewalks__c, Paved Sidewalk,Shared Driveway,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Carpet;Linoleum
hoa_fee_includes__c, Earthquake Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Recreation Facility,Trash,Water
pba__hoafees__c, 646
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2024-05-10T00:46:58.000+0000
pba__latitude_pb__c, 37.746139
pba__latitude_property__c, 37.746139
laundry_features__c, No Hookups
listed_date__c, 2024-02-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Kitchen
listing_agent_mls_id__c, 803707
ffd_listingagentname, William J Kitchen Jr.
listing_agent_number__c, 803707
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 499000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.442014
mls_id__c, 424017596
master_property__c, a0O1I000001ViQXUA0
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-26
original_price__c, 499000
overall_days_on_market__c, -81899
parking_access__c, Side by Side
parking_features__c, Enclosed
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2024-04-30
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-09T10:33:45.000+0000
price_per_square_foot__c, 692.31
pba__propertytype__c, Condominium
ListingId, a0EUd000001ZGZBMA4
road_surface_type__c, Paved
sale_date__c, 2024-05-09
sale_price__c, 450000
security_features__c, Secured Access
selling_agent_mls_id__c, 808652
selling_agent_number__c, 1037458
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 650
size__c, 650
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Red Rock
subdist__c, Diamond Heights
ffd_name, 135 Red Rock Way #105L, San Francisco, CA, 94131
website_property_type__c, Condominium
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/530750819-1.jpg