meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222557' 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, 990 Duncan Street #304G, San Francisco, CA, 94131
ffd_mls_id, 422624427
ffd_salesforce_id, a0E8W00000V3RAEUA3
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 396
address2__c, 990 Duncan Street #304G, San Francisco, CA, 94131
pba__address_pb__c, 990 Duncan Street #304G, San Francisco, CA, 94131
agent_only_remarks__c, Hi Agents -- laundry room is in the building, no in unit sets allowed. Escrow opened with Nate Scharton at Old Republic. Please EMAIL both [email protected] and [email protected] for Q's and private showings. Offers if any, Thurs 2/3 by 3pm.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Range
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1972
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Gary J Snow
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-01-28T01:47:49.000+0000
days_on_market__c, 538
dom__c, 8
ffd_description_pb, Impressive south facing views greet you as you enter this top floor condo. Exposed wood ceilings in a generous living room and a central gas fireplace bring warmth while bedrooms and bathrooms on opposite ends provide maximum privacy. Unit 304G boasts high ceilings, newly refinished engineered hardwood flooring, custom lighting, kitchen with updated stainless appliances, and incredible natural light throughout the space. Diamond Heights Village recently remodeled their clubhouse, has a gym, heated pool, hot tub, sauna and a laundry room. One car secure parking is deeded to unit 304G and ample street parking is available in the neighborhood. Close to Diamond Heights Shopping Center, Glen Canyon Park and just minutes to Noe Valley, Glen Park, Castro & West Portal.
district__c, SF District 4
driveway_sidewalks__c, Shared Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Simulated Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Roof,Sewer,Trash,Elevator
pba__hoafees__c, 753
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village Assn
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric;Wall Furnace
interior_features__c, Wet Bar;Open Beam Ceiling
ffd_lastmodifieddate, 2022-03-01T12:46:28.000+0000
pba__latitude_pb__c, 37.7453263
pba__latitude_property__c, 37.7453263
laundry_features__c, Inside Area
listed_date__c, 2021-09-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Par
pba__listing_agent_lastname__c, Hanji
listing_agent_mls_id__c, 804371
ffd_listingagentname, Par Hanji
listing_agent_number__c, 166013908
listing_co_agent_mls_id__c, 804956
listing_co_agent_number__c, 166014699
listing_co_office_mls_id__c, COMP7
listing_co_office_name__c, Compass
listing_co_office_number__c, 28751
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4426443
mls_id__c, 422624427
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I000001Vi9QUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-01-27
original_price__c, 995000
overall_days_on_market__c, 32
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-02-04
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-02-28T21:34:52.000+0000
price_per_square_foot__c, 1055.32
pba__propertytype__c, Condominium
id, a0E8W00000V3RAEUA3
sale_date__c, 2022-02-28
sale_price__c, 1240000
security_features__c, Secured Access
selling_agent_mls_id__c, 811101
selling_agent_number__c, 1049821
selling_co_agent_mls_id__c, 808971
selling_co_agent_number__c, 1038794
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1175
size__c, 1175
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Duncan
subdist__c, Diamond Heights
ffd_name, 990 Duncan Street #304G, San Francisco, CA, 94131
view__c, City Lights;Canyon
website_property_type__c, Condominium
window_features__c, Dual Pane Full
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/530392560-1.jpg
ListingId, a0E8W00000V3RAEUA3