meta_query='key:subdist__c;value:Inner Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374786' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12159
[post_author] => 4
[post_date] => 2018-10-30 00:24:04
[post_date_gmt] => 2018-10-30 00:24:04
[post_content] => On the foggy side but not too far. With tongue in cheek, call it Outer Cole Valley if you really can’t stomach life west of Arguello. Classic Edwardians, modern transit, Golden Gate Park adjacent.
[post_title] => Inner Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:19:54
[post_modified_gmt] => 2024-03-19 19:19:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12159
[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, 1711500930
ffd_listing_title, 1247 6th 1249 Avenue, San Francisco, CA, 94122
ffd_mls_id, 424005445
ffd_salesforce_id, a0EUd00000101wPMAQ
num_of_rooms__c, 14
of_units__c, 2
address2__c, 1247 6th 1249 Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1247 6th 1249 Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Seller financing is available! Please call Erno to view: 650.533.4923. Escrow opened with David Banker, Old Republic, [email protected]. As a courtesy to the Tenants, need 48 hours notice to show upper unit. Floor plans, video and more at www.6thandhugo.com
appliances__c, Dishwasher;Gas Water Heater;Built-In Refrigerator
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Erno A Veresh
pba__contingentdate__c, 2024-02-26
ffd_createddate, 2024-02-01T11:51:20.000+0000
days_on_market__c, 54
dom__c, 50
ffd_description_pb, Rarely available, 2-unit building steps to Golden Gate Park & amenities found on Irving St in the thriving Inner Sunset. Located in the best part of the Inner Sunset, this building was extensively renovated & expanded. Unit 1247 (TOP floor) offers nearly 2,000 sqft, 4Br/1.5Ba, in-unit laundry, 1-car parking & brilliant floor plan. Fully detached, the unit is flooded with natural light. The charm of the Edwardian era building is still present with refinished oak hardwood floors, decorative skylight & trim details. Modern conveniences elevate the unit with speakers throughout, gorgeous baths, towel warmer, door intercom & radiant heating system with multiple thermostats. Unit 1249 lives on 2 levels & offers over 2,400 sqft, per Condo Map, with 5Br + dedicated office & 2.5 baths + 1-car parking. Immense flexibility in space is present given the first level great room, oversized wet bar counter space & 3Br/1Ba found here. Both units offer direct access to the rear yard. High intrinsic value present via City's Condo conversion expedited program for 2-unit buildings. Enjoy vibrant GG Park, plethora of shops & dining & bustling UCSF medical campus. Steps to bus lines #7, 28, 66, N-Judah, and tech shuttles.
district__c, SF District 2
external_listing__c, 1
pba__floortype_pb__c, Wood;Varies by Unit
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant;Gas
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2024-03-27T00:48:22.000+0000
pba__latitude_pb__c, 37.765257
pba__latitude_property__c, 37.765257
laundry_features__c, In Each Unit
listed_date__c, 2024-01-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dino
pba__listing_agent_lastname__c, Zuzic
listing_agent_mls_id__c, 807300
ffd_listingagentname, Dino Zuzic
listing_agent_number__c, 1014561
listing_co_agent_mls_id__c, 800445
listing_co_agent_number__c, 800445
listing_co_office_mls_id__c, VERE
listing_co_office_name__c, Veresh, Erno A.
listing_co_office_number__c, 2183
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3244000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.youtube.com/watch?v=eq-k0GKhrpw
pba__longitude_pb__c, -122.463381
mls_id__c, 424005445
parkingspaces__c, 2
on_market_date__c, 2024-02-01
original_price__c, 3244000
overall_days_on_market__c, -81845
parking_features__c, Attached,Interior Access
pba__pendingdate__c, 2024-03-22
price_per_square_foot__c, 721.34
pba__propertytype__c, Duplex
ListingId, a0EUd00000101wPMAQ
sale_date__c, 2024-03-25
sale_price__c, 3140000
selling_agent_mls_id__c, A318637
selling_agent_number__c, 981091427
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 4353
size__c, 4353
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 6th
subdist__c, Inner Sunset
ffd_name, 1247 6th 1249 Avenue, San Francisco, CA, 94122
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530725275-1.jpg