meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237729' 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-11-18 23:07:35
[post_modified_gmt] => 2024-11-19 07:07:35
[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
(
)
)
ffd_listing_title, 225 Sadowa Street, San Francisco, CA, 94112
ffd_mls_id, 422665481
ffd_salesforce_id, a0E8W00000WkUjkUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 225 Sadowa Street, San Francisco, CA, 94112
pba__address_pb__c, 225 Sadowa Street, San Francisco, CA, 94112
agent_only_remarks__c, Lower level is unwarranted. For more information and showing requests, please contact Mark Brown, [email protected] or 415-359-5576.
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1906
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark Brown
pba__contingentdate__c, 2022-07-31
ffd_createddate, 2022-06-02T20:48:52.000+0000
days_on_market__c, 943
dom__c, 69
ffd_description_pb, 225 Sadowa Street is a 5 bed, 4 bath single-family home in the delightful Oceanview neighborhood. This expansive three-level home is situated on an oversized lot with mature garden and fruit trees. Enjoy the idyllic views of the Southern hills from the rear deck. Filled with character, this property is dream home ready. The 6,246 sq ft double lot is extra deep at 125' and offers 50' of frontage. Expansion and development potential abound. A generous floor-to-area ratio of 1.8 to 1 may support a much larger home or possible ADU. New SB9 legislation may provide an opportunity for a lot split and up to four units. Buyer to explore! Great value with easy freeway access!
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-07-13T17:11:54.000+0000
pba__latitude_pb__c, 37.7121157
pba__latitude_property__c, 37.7121157
listed_date__c, 2022-06-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Brown
listing_agent_mls_id__c, 197834
ffd_listingagentname, Tim A Brown
listing_agent_number__c, 197834
listing_co_agent_mls_id__c, 807124
listing_co_agent_number__c, 166018264
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 1499000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.brownsf.com/listings/listing/422645873
pba__longitude_pb__c, -122.460021
mls_id__c, 422665481
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-06-02
original_price__c, 1749000
overall_days_on_market__c, -81236
parking_access__c, Tandem
parking_features__c, Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-08-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 360.23
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000WkUjkUAF
sale_date__c, 2022-08-26
sale_price__c, 1460000
selling_agent_mls_id__c, 810526
selling_agent_number__c, 1046686
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, CENTURY 21 Real Estate Alliance
pba__status__c, Closed
pba__totalarea_pb__c, 4053
size__c, 4053
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Sadowa
subdist__c, Oceanview
ffd_name, 225 Sadowa Street, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530470307_5b2a7724-fbd0-41f7-905f-088aef714103.jpg
_yoast_indexnow_last_ping, 1735677756
