meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331919' 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
(
)
)
ffd_listing_title, 125 Majestic Avenue, San Francisco, CA, 94112
ffd_mls_id, 423722744
ffd_salesforce_id, a0E8W00000bEVaAUAW
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 125 Majestic Avenue, San Francisco, CA, 94112
pba__address_pb__c, 125 Majestic Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Property subject to court confirmation and overbid. Minimum overbid amount has been set to $743,900. Court/Overbid Date scheduled for Wednesday, 4/19/2023 at 9:00 AM. Offers shall be non-contingent and include a 10% deposit payable by check to Chicago Title Company. Appearance or Public Access by Video and/or Audio via Zoom: Parties, counsel and witnesses may appear by video or audio-only telephone through Zoom. For a video appearance, go to zoom.us, click "join a meeting" and input meeting ID 160 225 4765 and password 514879. For an audio-only telephone appearance through Zoom, call 1-669-254-5252 and key in meeting ID "160 225 4765#, then participant ID "0#", then password *514879#". (Toll rates may apply.) Counsel, parties and witnesses appearing by video must input their first and last name into the "Your Name" dialogue box. Prospective bidders should refer to Sections 701.510 to 701.680, inclusive, of the Code of Civil Procedure for provisions governing the terms, conditions, and effect of the sale and the liability of defaulting bidders. Buyer(s) shall be responsible for energy and water costs and buyer shall pay transfer tax. Please contact Rebecca Stack for a showing. [email protected] Disclosures - https://app.disclosures.io/link/125-Majestic-Avenue-96m08405
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1926
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-22T18:48:34.000+0000
days_on_market__c, 294
dom__c, 56
ffd_description_pb, 125 Majestic Avenue is an exceptional opportunity to develop a single-family home in the desirable Oceanview neighborhood. The property currently lives as a Two-Bedroom and One-Bathroom Single Family Residence with a large undeveloped basement, generous yard, and fantastic views. Nestled on a tree-lined street, the residence is located within a short distance to Muni, Bart, Whole Foods, and all the fantastic shopping and restaurants Ocean Avenue offers. The property is also within easy access to the 280 making this location a commuter's dream.
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-12-14T03:46:25.000+0000
pba__latitude_pb__c, 37.7163797
pba__latitude_property__c, 37.7163797
listed_date__c, 2023-02-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Allison
pba__listing_agent_lastname__c, Chapleau
listing_agent_mls_id__c, 981036
ffd_listingagentname, Allison Chapleau
listing_agent_number__c, 981036
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 743900
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4521635
mls_id__c, 423722744
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-02-22
original_price__c, 700000
overall_days_on_market__c, -81501
parking_access__c, Tandem
parking_features__c, Attached,Covered
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-04-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 850
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bEVaAUAW
sale_date__c, 2023-05-18
sale_price__c, 850000
selling_agent_mls_id__c, 809630
selling_agent_number__c, 1042187
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1000
size__c, 1000
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Majestic
subdist__c, Oceanview
ffd_name, 125 Majestic Avenue, San Francisco, CA, 94112
view__c, San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530582747-1.jpg
_yoast_indexnow_last_ping, 1702527296
