meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='372982' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15735
[post_author] => 4
[post_date] => 2018-11-02 20:00:49
[post_date_gmt] => 2018-11-02 20:00:49
[post_content] => Balboa Park BART. Single-family homeowners shuttling south to Silicon Valley or BARTing to downtown and points east. Balboa Park. An urban delight with an indoor swimming pool, outdoor ball fields, and a great playground. Ocean Avenue boutiques, grocery stores, restaurants, and more are a quick meander away.
[post_title] => Mission Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:23:14
[post_modified_gmt] => 2024-04-12 19:23:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15735
[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, 1708775724
ffd_listing_title, 4192 Mission 4194 Street, San Francisco, CA, 94112
ffd_mls_id, 423920366
ffd_salesforce_id, a0EUd000000j3o9MAA
num_of_rooms__c, 12
of_units__c, 5
address2__c, 4192 Mission 4194 Street, San Francisco, CA, 94112
pba__address_pb__c, 4192 Mission 4194 Street, San Francisco, CA, 94112
agent_only_remarks__c, Offers requested Weds 24-Jan, 10a please. Please allow 48 hours for a response. Sellers may consider seller financing. Easy to show by appt - contact Michael at 415.606.2625. Escrow opened with Amy Edberg, First America. Commercial loan likely required. Disclosures here: https://app.disclosures.io/link/41924194-Mission-St-znv8hdqv. Zoning is NCD Excelsior Outer Mission (link to details https://bit.ly/3Q2EtXy).
appliances__c, Insulated Water Heater;Gas Water Heater;Free Standing Refrigerator;Free Standing Electric Range
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 3
year_build_text__c, 1956
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Tracy Hsieh
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-01-05T17:47:10.000+0000
days_on_market__c, 50
dom__c, 24
ffd_description_pb, Incredible mixed use building on high traffic Mission St with two side-by-side commercial spaces and 3 residential units. Huge 6 car-parking/warehouse space on lower level with alley access. Commercial space(s) will deliver vacant and include a kitchenette, 4 large offices, conference room, reception area, bathrooms, storage, vault. 3 bright and airy 1BD/1BA apartments on top floor: 2 rented with long-term stable tenants. 1 unit vacant and remodeled for owner's use or maximum rents. Located on the vibrant North End of Mission Terrace just blocks to Bernal Heights and Glen Park. Zoned NCD which includes retail, offices and restaurants, among others (see planning code for complete list).
district__c, SF District 10
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2024-02-24T11:48:47.000+0000
pba__latitude_pb__c, 37.73013
pba__latitude_property__c, 37.73013
listed_date__c, 2023-11-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Minson
listing_agent_mls_id__c, 808482
ffd_listingagentname, Michael Minson
listing_agent_number__c, 1035858
listing_co_agent_mls_id__c, 813002
listing_co_agent_number__c, 1058962
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 1298000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.levelupgroup.com/featured/CA/San%20Francisco/94112/4192-4194-Mission-St/37027
pba__longitude_pb__c, -122.430292
mls_id__c, 423920366
parkingspaces__c, 6
on_market_date__c, 2024-01-05
original_price__c, 1298000
overall_days_on_market__c, -81818
parking_features__c, Garage,Interior Access,Side-by-Side,Tandem Garage
pba__pendingdate__c, 2024-01-29
price_per_square_foot__c, 386.01
pba__propertytype__c, 5 or More Unit
ListingId, a0EUd000000j3o9MAA
roof__c, Composition
sale_date__c, 2024-02-22
sale_price__c, 1380000
security_features__c, Security Gate
selling_agent_mls_id__c, 817454
selling_agent_number__c, 1076322
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 3575
size__c, 3575
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Mission
subdist__c, Mission Terrace
ffd_name, 4192 Mission 4194 Street, San Francisco, CA, 94112
view__c, San Francisco
website_property_type__c, 5 or More Unit
pba__yearbuilt_pb__c, 1956
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530706255-1.jpg