meta_query='key:subdist__c;value:Inner Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='339345' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12162
[post_author] => 4
[post_date] => 2018-10-29 01:21:18
[post_date_gmt] => 2018-10-29 01:21:18
[post_content] => Barely west of Laurel Village and Jordan Park. Very east of Ocean Beach. It's not a transitional neighborhood, it's the Inner Richmond. Delightful shops on Clement Street and a surprisingly central location. But no Muni light rail.
[post_title] => Inner Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 11:04:56
[post_modified_gmt] => 2024-03-19 18:04:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12162
[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, 555 2nd Avenue, San Francisco, CA, 94118
ffd_mls_id, 423728453
ffd_salesforce_id, a0E8W00000cper9UAA
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 555 2nd Avenue, San Francisco, CA, 94118
pba__address_pb__c, 555 2nd Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Two-unit property per city records. Pre-escrow opened with Michelle Pineda of Old Republic Title Co. Email: [email protected]. Disclosures: https://app.disclosures.io/link/555-2nd-Avenue-ppwn104c
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1903
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Marie T Carr
pba__contingentdate__c, 2023-09-01
cooling__c, None
ffd_createddate, 2023-08-26T02:48:56.000+0000
days_on_market__c, 36
dom__c, 23
ffd_description_pb, Fantastic Inner Richmond location for this Edwardian style 2-unit flexible use property. The two-story upper unit offers wonderful house-like features including high ceilings and abundant natural light throughout, a spacious bright living room with fireplace, sizeable dining room with period details, updated eat-in kitchen with stainless steel appliances, laundry closet, a bright bonus room/office off the kitchen overlooks the backyard, upstairs features two spacious bedrooms with ample closet space and one bathroom. The bottom, lower unit comprises of one bedroom, one bathroom, kitchen, living/dining room combo and bright office/bonus room with direct access to the backyard. The property includes a one car garage plus driveway parking and large sunny fenced in backyard. Ideally located close to Golden Gate Park, Clement and Geary Street restaurants and more.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Tile;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2023-09-29T01:49:01.000+0000
pba__latitude_pb__c, 37.77824
pba__latitude_property__c, 37.77824
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-03-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Harrington
listing_agent_mls_id__c, 803214
ffd_listingagentname, Michael B Harrington
listing_agent_number__c, 803214
listing_co_agent_mls_id__c, 805801
listing_co_agent_number__c, 166015854
listing_co_office_mls_id__c, STHB
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 2050
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.46011
lower_level__c, Bedroom(s),Full Bath(s),Garage,Kitchen,Living Room
mls_id__c, 423728453
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-08-23
original_price__c, 1795000
overall_days_on_market__c, -81683
parking_access__c, Independent
parking_features__c, Detached,Size Limited
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-09-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-28T11:52:19.000+0000
price_per_square_foot__c, 638.89
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cper9UAA
road_surface_type__c, Paved
roof__c, Composition;Elastomeric
room_type__c, Office;Kitchen;Living Room;Baths Other;Dining Room
sale_date__c, 2023-09-28
sale_price__c, 1725000
selling_agent_mls_id__c, 817963
selling_agent_number__c, 1076775
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 2700
size__c, 2700
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 2nd
subdist__c, Inner Richmond
ffd_name, 555 2nd Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1903
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530650950-1.jpg