meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='418580' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70661
[post_author] => 4
[post_date] => 2018-11-30 20:30:35
[post_date_gmt] => 2018-11-30 20:30:35
[post_content] => East of Orizaba, but northwest of I-280 and south of Lakeside, the Oceanview slopes gently down to the Outer Mission where I-280 snakes along the neighborhood border to Daly City and points south. There's good access to I-280 from the entire neighborhood, and Balboa Park BART is just a few blocks from the northeast side of the neighborhood.
[post_title] => Oceanview
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => oceanview
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:20:55
[post_modified_gmt] => 2024-04-12 19:20:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70661
[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, 1728755731
ffd_listing_title, 150 Josiah Avenue, San Francisco, CA, 94112
ffd_mls_id, 424070067
ffd_salesforce_id, a0EUd000003Fv4HMAS
num_of_rooms__c, 12
of_units__c, 3
address2__c, 150 Josiah Avenue, San Francisco, CA, 94112
pba__address_pb__c, 150 Josiah Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Call for appt - Top floor 3/2 to be delivered vacant at COE. Both Studio and One-bedroom are leased at market rates. No expense spared in this transition from SFR to 3 Unit. Disclosures: https://app.disclosures.io/app/users/88ae0ff0-73ec-4f7a-a7f4-d2bedb923eb1/packages/e81af384-e1f5-44b7-b7bf-bf9fc8b8cadd/documents
appliances__c, Dishwasher;Tankless Water Heater;Free Standing Refrigerator;Ice Maker;See Remarks;Varies By Unit
architectural_style__c, Traditional
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, Zach DeRossette
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-10-02T10:50:01.000+0000
days_on_market__c, 10
dom__c, 10
ffd_description_pb, Stunning, Completely Renovated Three-Unit Masterpiece! Originally purchased as a single-family home, this exceptional property has undergone a meticulous transformation into a spectacular three-unit multifamily residence, where modern luxury and intelligent design come together seamlessly. Every detail of the renovation has been carefully crafted, creating a space that is both elegant and highly functional perfect for contemporary living in the city. The two-level backyard oasis invites you to host lively gatherings or enjoy relaxed grilling sessions. Expansive entertainment and dining areas provide an ideal setting for memorable outdoor meals and social occasions. Fitness enthusiasts will appreciate the convenience and privacy of the on-site private gym, while separate storage units provide ample room for all your belongings. The top floor features a stunning three-bedroom, two-bath residence with breathtaking views of the Bay. On the lower level, a one-bedroom residence and a studio apartment provide comfortable living spaces, perfect for generating additional rental income. This property is packed with cutting-edge features that provide both convenience and sustainability. Enjoy biometric keyless entry for enhanced security.
district__c, SF District 3
exterior_features__c, Fenced Yard;Yard Space
external_listing__c, 1
pba__floortype_pb__c, Laminate
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2024-10-12T17:47:23.000+0000
pba__latitude_pb__c, 37.7172855
pba__latitude_property__c, 37.7172855
laundry_features__c, In Each Unit
listed_date__c, 2024-10-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, Chow
listing_agent_mls_id__c, 400368
ffd_listingagentname, Mark R Chow
listing_agent_number__c, 400368
listing_co_agent_mls_id__c, EB909285
listing_co_agent_number__c, 981375263
listing_co_office_mls_id__c, 10196
listing_co_office_name__c, Compass
listing_co_office_number__c, 981036985
listing_office_mls_id__c, COMP96
listing_office_name__c, Compass
listing_office_number__c, 29143
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, https://150Josiah.com
pba__longitude_pb__c, -122.4540978
mls_id__c, 424070067
parkingspaces__c, 3
on_market_date__c, 2024-10-02
open_house_end__c, 2024-10-12T16:00:00.000+0000
open_house_start__c, 2024-10-12T14:00:00.000+0000
original_price__c, 1995000
overall_days_on_market__c, -82089
parking_features__c, Attached,Garage
patio_and_porch_features__c, Uncovered Patio;Balcony/Deck;Varies by Unit
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 0
pba__propertytype__c, Triplex
ListingId, a0EUd000003Fv4HMAS
roof__c, Composition
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Fire Alarm;Video System
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Josiah
subdist__c, Oceanview
ffd_name, 150 Josiah Avenue, San Francisco, CA, 94112
view__c, City;Bay
website_property_type__c, Triplex
window_features__c, Dual Pane Full;Bay Window(s);Varies by Unit
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530854251-1.jpg