meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237602' 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-04-09 08:50:23
[post_modified_gmt] => 2024-04-09 15:50:23
[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
(
)
)
ffd_listing_title, 624 Fillmore Street #3, San Francisco, CA, 94117
ffd_mls_id, 422678467
ffd_salesforce_id, a0E8W00000XkxKjUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 3
address2__c, 624 Fillmore Street #3, San Francisco, CA, 94117
pba__address_pb__c, 624 Fillmore Street #3, San Francisco, CA, 94117
agent_only_remarks__c, The disclosure packet is available on homelight/IO and here is the link: https://app.disclosures.io/link/624-Fillmore-Street-3-dxtfkrxr Please email the listing agent to schedule appointments and follow advised health safety protocols.---OFFER DATE TUESDAY 7/26/22 BY 4:00PM---
appliances__c, Dishwasher;Gas Water Heater;Electric Cook Top;Built-In Refrigerator
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1980
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-07-15T15:47:51.000+0000
days_on_market__c, 369
dom__c, 11
ffd_description_pb, Fabulous investment opportunity to own a three-bedroom, two-bath, top floor flat with phenomenal views on Fillmore Street in the iconic Alamo Square district of San Francisco! The flat opens to a large living area with fireplace, an open kitchen/dining area and deck/patio with breath-taking views of downtown San Francisco and beyond. There is a separate laundry room, a bathroom, three spacious bedrooms, one with en-suite bath, that are all on one level. The flat is move-in ready, or the perfect open slate for the buyer who wants to add the finishing touches to make this their own special refuge inspired by their individual creativity and taste. There is deeded parking, deeded storage, and a common backyard/outdoor space that complete this special flat that is close to everything!
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Other;Tile
hoa_fee_includes__c, Common Areas,Homeowners Insurance,Trash
pba__hoafees__c, 225
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 624 Fillmore Street Condominium Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T17:22:04.000+0000
pba__latitude_pb__c, 37.7753273
pba__latitude_property__c, 37.7753273
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2022-07-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeffrey
pba__listing_agent_lastname__c, Salgado
listing_agent_mls_id__c, 805001
ffd_listingagentname, Jeffrey A Salgado
listing_agent_number__c, 166014760
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 959000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4308441
mls_id__c, 422678467
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Shower Stall(s)
master_property__c, a0O8W00000FprTsUAJ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-07-15
original_price__c, 959000
overall_days_on_market__c, -81279
parking_access__c, Independent
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 2022-07-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 950
pba__propertytype__c, Condominium
ListingId, a0E8W00000XkxKjUAJ
room_type__c, Laundry;Kitchen;Living Room;Dining Room;Great Room
sale_date__c, 2022-08-19
sale_price__c, 1425000
security_features__c, Security Gate
selling_agent_mls_id__c, 807674
selling_agent_number__c, 1023667
selling_co_agent_mls_id__c, 812378
selling_co_agent_number__c, 1056316
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1500
size__c, 1500
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fillmore
subdist__c, Alamo Square
ffd_name, 624 Fillmore Street #3, San Francisco, CA, 94117
view__c, City;Panoramic;City Lights;Downtown;San Francisco;Mountains
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1980
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530496828-1.jpg