meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='373315' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15731
[post_author] => 4
[post_date] => 2018-11-02 19:54:56
[post_date_gmt] => 2018-11-02 19:54:56
[post_content] => The site of perhaps the most photographed vista in San Francisco, Alamo Square is home to the world-famous Painted Ladies. The row of iconic Victorian homes, with the city skyline as the backdrop, provides a picture-perfect postcard view of San Francisco.
Equally famous in movies is Alamo Square Park; on a hilltop overlooking the Painted Ladies, locals and tourists frequent the green space, playgrounds, walking trails, dog park, and tennis courts.
Architecture in Alamo Square is predominately Victorian and has the distinct honor of being the location of numerous homes exceeding 10,000 square feet of living space.
[post_title] => Alamo Square
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => alamo-square
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-07 09:28:38
[post_modified_gmt] => 2024-11-07 17:28:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15731
[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, 1735680594
ffd_listing_title, 714 Fillmore Street, San Francisco, CA, 94117
ffd_mls_id, 423924802
ffd_salesforce_id, a0EUd000000JsUcMAK
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 714 Fillmore Street, San Francisco, CA, 94117
pba__address_pb__c, 714 Fillmore Street, San Francisco, CA, 94117
agent_only_remarks__c, Court confirmation/overbid date has been set for February 2 at 10:15am at 2120 Martin Luther King Jr. Way, Berkeley, Dept 201. Minimum overbid is $971,750. Offer must be all cash and include a cashier's check for 10% of the bid amount. Zoom link: https://zoomgov.com/j/16092115313 This is for the sale of a 28.8% share in 710-714 Fillmore St. This property is an as-is probate sale, court confirmation required. Subject to court overbids. Commission shall only be paid to broker whose client is successful in court. Buyer shall pay transfer tax, all costs for water & energy certifications, smoke/CO detector installation and HOA transfer fees, if any. Please use the SFAR purchase agreement with the probate addendum. Buyers should verify square foot measurement, disclosures, and permit history and bed and bath count and legality for themselves. May require cash buyer--please provide proof of funds. Yard exclusive use of other owners. Basement storage. Co-owners of TIC were offered right of first refusal, which expired. Please call or text Eve Fisher at 415-535-0019 for viewings. Escrow is open with Mia McDowell at ORTC. Disclosures available at https://app.disclosures.io/link/714-Fillmore-Street-bymwians
appliances__c, Gas Plumbed
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-11-30T19:47:16.000+0000
days_on_market__c, 397
dom__c, 64
ffd_description_pb, Just steps away from the Painted Ladies and beautiful Alamo Square, possibilities abound in this 1600-square foot TIC unit. This quintessential Edwardian has 3 spacious bedrooms, an eat-in kitchen, a large formal dining room, sizeable living room, and an enclosed deck. Like many homes of its age, the home is characterized by tall ceilings, beautiful woodwork, and solid wood doors. The lower flat of a 3 unit TIC building, this home has the potential to be a stunning mix of old and new. Basement storage included. In close proximity to cultural hotspots Hayes Valley, the Fillmore, and the Lower Haight. Though the home needs work, you can't beat the location. This is a fixer property and no parking is included. This is a probate sale with court confirmation required.
district__c, SF District 6
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-03-01T11:47:14.000+0000
pba__latitude_pb__c, 37.776382
pba__latitude_property__c, 37.776382
laundry_features__c, None
listed_date__c, 2023-11-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eve
pba__listing_agent_lastname__c, Fisher
listing_agent_mls_id__c, 813240
ffd_listingagentname, Eve O Fisher
listing_agent_number__c, 1060390
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 971750
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.430947
mls_id__c, 423924802
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-11-30
original_price__c, 971750
overall_days_on_market__c, -81782
pba__pendingdate__c, 2024-02-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-02-29T16:32:43.000+0000
price_per_square_foot__c, 575.25
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000000JsUcMAK
room_type__c, Storage;Living Room;Family Room;Possible Guest;Primary Bedroom
sale_date__c, 2024-02-29
sale_price__c, 925000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, buyer self represented
pba__status__c, Closed
pba__totalarea_pb__c, 1608
size__c, 1608
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fillmore
subdist__c, Alamo Square
ffd_name, 714 Fillmore Street, San Francisco, CA, 94117
website_property_type__c, Tenancy In Common
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530708398-1.jpg