meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338435' 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] => 2023-06-23 11:53:47
[post_modified_gmt] => 2023-06-23 18:53:47
[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, 990 Duncan Street #307G, San Francisco, CA, 94131
ffd_mls_id, 423900428
ffd_salesforce_id, a0E8W00000dSTOeUAO
num_of_fireplaces__c, 1
num_of_rooms__c, 3
of_units__c, 396
address2__c, 990 Duncan Street #307G, San Francisco, CA, 94131
pba__address_pb__c, 990 Duncan Street #307G, San Francisco, CA, 94131
agent_only_remarks__c, Easy to show, please contact listing agent 415.871.4597 Carlos. Buyer to verify functionality of the gas fireplace. https://app.disclosures.io/link/990-Duncan-St-307G-xmkyck5n
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Refrigerator
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, 2023-09-14T10:47:08.000+0000
days_on_market__c, 8
dom__c, 8
ffd_description_pb, Welcome to a nestle 1BR 1BA condo located in the Diamond Heights Village. This home is perfectly located on the top floor, bright, and it's a corner unit! The kitchen features new stainless steel appliances, equipped with a refrigerator, gas range oven, dishwasher, a microwave, and lots of cabinet space. The dining area and living room receives a great amount of natural light through the large windows. The home was recently painted in the interior, along with new light and water fixtures were installed for the sale. It has 1 parking space assigned, in a secured gated garage. Notable amenities of the community include the landscaped garden, a clubhouse with a pool table, a gym with separate cardio and weight training areas, and an outdoor heated swimming pool. Close to your new home you will find great green spaces, Douglass Playground and Dogplay, Douglass Park Tennis Courts, amazing Glen Canyon Park Trails. Close and convenient shops include Safeway, and Walgreens. Take a look and be marbled by all the value this home offers.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Fireplace;Fire Pit
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Laminate
hoa_fee_includes__c, Common Areas,Elevator,Insurance on Structure,Maintenance Exterior,Management,Pool,Trash,Water
pba__hoafees__c, 688
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Wall Furnace
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2023-09-22T22:47:08.000+0000
pba__latitude_pb__c, 37.7453263
pba__latitude_property__c, 37.7453263
laundry_features__c, Ground Floor
listed_date__c, 2023-06-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Carlos
pba__listing_agent_lastname__c, Barrientos
listing_agent_mls_id__c, 809136
ffd_listingagentname, Carlos L Barrientos
listing_agent_number__c, 1040713
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REDF
listing_office_name__c, Redfin
listing_office_number__c, 64045
pba__listingprice_pb__c, 649000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=uWhH5SnqBaT&brand=0&mls=1&
pba__longitude_pb__c, -122.4426443
mls_id__c, 423900428
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Tile
master_property__c, a0O8W00000KTGPfUAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-09-14
open_house_end__c, 2023-09-23T16:00:00.000+0000
open_house_start__c, 2023-09-23T14:00:00.000+0000
original_price__c, 649000
overall_days_on_market__c, -81705
parking_access__c, Independent
parking_features__c, Garage Door Opener
parking_type__c, On Site - Assigned (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, 872.31
pba__propertytype__c, Condominium
ListingId, a0E8W00000dSTOeUAO
room_type__c, Kitchen;Living Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
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, 744
size__c, 744
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Duncan
subdist__c, Diamond Heights
ffd_name, 990 Duncan Street #307G, San Francisco, CA, 94131
view__c, Garden/Greenbelt
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/530676530-1.jpg