meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221828' 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, 977 Duncan Street, San Francisco, CA, 94131
ffd_mls_id, 421607737
ffd_salesforce_id, a0E8W00000V1TlIUAV
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 2
address2__c, 977 Duncan Street, San Francisco, CA, 94131
pba__address_pb__c, 977 Duncan Street, San Francisco, CA, 94131
agent_only_remarks__c, OFFERS: TUE 11/9 @ 10:00am. Please see DP cover sheet for offer instructions. This is a 2-unit building that just completed the final stages of condo conversion and will close as condos. Must close concurrently with 979 Duncan. Newly forming HOA - new buyers must secure a new master insurance policy for the building. APPOINTMENTS: https://calendly.com/ceily/977-979-duncan DISCLOSURES: https://app.disclosures.io/link/977-Duncan-Street-3x92oiyy
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over;Window;Closet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1963
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Ceily S Landman
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-10-28T17:48:09.000+0000
days_on_market__c, 629
dom__c, 13
ffd_description_pb, A stunning hexagonal living room with a soaring cathedral ceiling and walk-out deck. Expansive views across the canyon. Serene peaceful environment in the middle of the city. These are just some of the things that make 977 Duncan so special. At the front of this top-floor condo, an open floor plan greets you with a spacious living room, dining room, and tastefully updated kitchen that is both beautiful and supremely practical. 4 beds & 2 full baths (incl. one primary suite) are nicely separated from the social rooms. Additional features include Brazilian cherry hardwood floors, solar tubes & transom windows to welcome abundant natural light, recessed lighting, generous closet space, in-unit laundry, tankless water heater, Nest thermostat, and a built-in speaker system. In addition to two private decks, this home enjoys access to the tranquil shared courtyard. 1- car garage parking & additional storage complete this unit. The lower unit in this boutique 2-unit building is also for sale.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard;Entry Gate
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 977-979 Duncan Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Cathedral Ceiling
ffd_lastmodifieddate, 2022-01-25T16:05:23.000+0000
pba__latitude_pb__c, 37.744865
pba__latitude_property__c, 37.744865
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-08-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sherri
pba__listing_agent_lastname__c, Howe
listing_agent_mls_id__c, 806718
ffd_listingagentname, Sherri Howe
listing_agent_number__c, 166017501
listing_co_agent_mls_id__c, 813032
listing_co_agent_number__c, 1059036
listing_co_office_mls_id__c, BRAVA
listing_co_office_name__c, Brava Real Estate
listing_co_office_number__c, 28638
listing_office_mls_id__c, BRAVA
listing_office_name__c, Brava Real Estate
listing_office_number__c, 28638
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.diamondheightscondos.com/
pba__longitude_pb__c, -122.442334
mls_id__c, 421607737
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Closet;Window
master_property__c, a0O1I000004VX4HUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-10-28
original_price__c, 1495000
overall_days_on_market__c, 102
parking_access__c, Independent
parking_features__c, Garage Facing Front,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-11-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 937.14
pba__propertytype__c, Condominium
id, a0E8W00000V1TlIUAV
sale_date__c, 2021-12-09
sale_price__c, 1625000
security_features__c, Security Gate
selling_agent_mls_id__c, 810310
selling_agent_number__c, 1045605
selling_co_agent_mls_id__c, 812201
selling_co_agent_number__c, 1055483
selling_co_office_mls_id__c, CBLUXURY
selling_co_office_name__c, Coldwell Banker Realty
selling_co_office_number__c, 2128
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1734
size__c, 1734
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Duncan
subdist__c, Diamond Heights
ffd_name, 977 Duncan Street, San Francisco, CA, 94131
view__c, Panoramic;Canyon;Forest
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1963
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530349383-1.jpg
ListingId, a0E8W00000V1TlIUAV