meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329625' 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, 644 Fillmore Street, San Francisco, CA, 94117
ffd_mls_id, 423721177
ffd_salesforce_id, a0E8W00000bErI3UAK
num_of_fireplaces__c, 2
num_of_rooms__c, 7
of_units__c, 3
address2__c, 644 Fillmore Street, San Francisco, CA, 94117
pba__address_pb__c, 644 Fillmore Street, San Francisco, CA, 94117
agent_only_remarks__c, Note: Leased pkg pre-paid through Aug '23 plus ample street pkg. Escrow opened with Michelle Patterson at DOMA. Please email [email protected] to schedule a showing and/or to request disclosures. Please DO NOT text agents. Call Alla at 415.748.2550 for more information.
bath_features__c, Shower Stall(s);Jetted Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Alla Gershberg
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-01T18:48:02.000+0000
days_on_market__c, 140
dom__c, 9
ffd_description_pb, Incredible historical charm & modern updates coalesce in this enormous, beautifully restored and house-like 4bd/2ba full floor Edwardian condo. Originally designed by the renowned architect James Francis Dunn, the home welcomes you through its formal entry, where classic architectural details greet you - from intricate moldings, high ceilings, detailed wainscoting & wood paneling to the gleaming hardwood floors, refurbished to their original luster. Spacious FLR & roomy parlor open to adjacent FDR w/ez access to kitchen, ideal flow for entertaining. Decorative fireplaces accent both the dining & living rooms, highlighted by ornate baroque fireplace & bay windows. The updated chef's kitchen features new cabinetry, dramatic quartz countertops, SS appliances & gold hardware accents. Escape to the generous, primary suite located at the back of the home featuring ample closet space & en-suite bath. The home is made complete by 3 add'l beds, remodeled bath, in-unit w/d, ample closet space, shared yard/common area, leased pkg pre-paid through Aug 23, ample street pkg & massive deeded storage. Enjoy the convenience of city living w/ez access to shops & transport & just a short walk to Alamo Square Park. Don't miss this rare opportunity to own a piece of San Francisco's rich history!
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Wood
pba__hoafees__c, 301
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
ffd_lastmodifieddate, 2023-07-13T18:28:55.000+0000
pba__latitude_pb__c, 37.775523
pba__latitude_property__c, 37.775523
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-03-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dale
pba__listing_agent_lastname__c, Boutiette
listing_agent_mls_id__c, 806303
ffd_listingagentname, Dale T Boutiette
listing_agent_number__c, 166016715
listing_co_agent_mls_id__c, 803120
listing_co_agent_number__c, 803120
listing_co_office_mls_id__c, COMP7
listing_co_office_name__c, Compass
listing_co_office_number__c, 28751
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1649000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=uTjnhkenBif&brand=0
pba__longitude_pb__c, -122.430858
mls_id__c, 423721177
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O8W00000HtUwgUAF
monthly_parking_fees__c, 300
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-01
original_price__c, 1649000
overall_days_on_market__c, -81508
parking_access__c, Independent
parking_features__c, See Remarks
parking_type__c, Other
pba__pendingdate__c, 2023-03-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 763.27
pba__propertytype__c, Condominium
ListingId, a0E8W00000bErI3UAK
room_type__c, Storage;Living Room;Dining Room;Family Room;Primary Bathroom
sale_date__c, 2023-04-10
sale_price__c, 1625000
selling_agent_mls_id__c, 808979
selling_agent_number__c, 1039559
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2129
size__c, 2129
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fillmore
subdist__c, Alamo Square
ffd_name, 644 Fillmore Street, San Francisco, CA, 94117
website_property_type__c, Condominium
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/530585373-1.jpg