meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215752' 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
(
)
)
ffd_listing_title, 95 Red Rock 4F West Way #309M, San Francisco, CA, 94131
ffd_mls_id, 508843
ffd_salesforce_id, a0E1I00000TTRPIUA5
num_of_fireplaces__c, 0
num_of_rooms__c, 2
of_units__c, 396
address2__c, 95 Red Rock 4F West Way #309M, San Francisco, CA, 94131
pba__address_pb__c, 95 Red Rock 4F West Way #309M, San Francisco, CA, 94131
agent_only_remarks__c, Escrow opened with Fidelity, Sylvia Wong, 415-3592118, [email protected]
appliances__c, Electric Range;Freestanding Range;Hood Over Range
architectural_style__c, Rustic
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1972
building_name__c, Diamond Heights Village HOA
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-02-04
ffd_createddate, 2020-10-25T20:45:28.000+0000
days_on_market__c, 997
dom__c, 141
ffd_description_pb, Diamond Heights Village HOA. Studio condo. Private indoor garage with security gate. Washer & Dry in the complex. Garage with security gate, view of private garden & expansive view from the 3rd floor. HOA includes garbage, building maintenance, building insurance including Quake. Please send signed CAR Coronavirus Property Entry Advisory and Declaration (PEAD) prior to visiting and to schedule appointment call 415-515-7972. HOA covers: Common area, pool, jacuzzi, work out gym, water features, pathways, garbage, parking garage, bike storage, water, garbage, basic cable. HOA requires rugs to dampen any noise to the unit below.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 3
external_listing__c, 1
pba__floor__c, 3
pba__floortype_pb__c, Carpet;Linoleum
hoa_dues__c, 489
hoa_fee_includes__c, Management,Earthquake Insurance,Trash,Maintenance Grounds,Homeowners Insurance,Security
pba__hoafees__c, 489
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric;Wall Furnace
ffd_lastmodifieddate, 2022-01-25T15:38:42.000+0000
pba__latitude_pb__c, 37.746321
pba__latitude_property__c, 37.746321
laundry_appliances__c, In Laundry Room
laundry_features__c, Inside Room
listed_date__c, 2020-10-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robert
pba__listing_agent_lastname__c, Barcewski
listing_agent_mls_id__c, 804183
ffd_listingagentname, Robert E Barcewski
listing_agent_number__c, 166013660
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SANF
listing_office_name__c, Engel & Voelkers San Francisco
listing_office_number__c, 25914
pba__listingprice_pb__c, 450000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.44152
pba__lotsize_pb__c, 0
mls_id__c, 508843
main_level__c, Kitchen
master_property__c, a0O1I00000BBKIeUAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-10-25
original_price__c, 475000
overall_days_on_market__c, 182
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-03-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 949.37
pba__propertytype__c, Condominium
id, a0E1I00000TTRPIUA5
roof__c, Composition
sale_date__c, 2021-03-15
sale_price__c, 450000
selling_agent_mls_id__c, 809007
selling_agent_number__c, 1039665
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Kinoko
pba__status__c, Closed
pba__totalarea_pb__c, 474
size__c, 474
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 4F West Way #309M, San Francisco, CA, 94131
transportation__c, 2 Blocks
unit_number__c, 309M
view__c, Panoramic;Garden/Greenbelt;Hills;Ridge
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/372829-1.jpg
ListingId, a0E1I00000TTRPIUA5