meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236454' 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, 1497 Mcallister Street, San Francisco, CA, 94115
ffd_mls_id, 422654823
ffd_salesforce_id, a0E8W00000Wif9NUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 4
address2__c, 1497 Mcallister Street, San Francisco, CA, 94115
pba__address_pb__c, 1497 Mcallister Street, San Francisco, CA, 94115
agent_only_remarks__c, Please contact either Mark Shumway or Marc Dickow for showing appointments. No private showings until after the first open house. Disclosure package available - https://bit.ly/3FlmPaR . Escrow opened with Janette Marcelo at Old Republic Title. All offers to be submitted on SFAR purchase contract.
appliances__c, Dishwasher;Free Standing Gas Range
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Marc Dickow
pba__contingentdate__c, 2022-05-12
cooling__c, None
ffd_createddate, 2022-05-06T18:46:48.000+0000
days_on_market__c, 439
dom__c, 33
ffd_description_pb, This gorgeous TOP floor Victorian condo is located in one of SF's hippest neighborhoods. Stunningly high ceilings, original Victorian detail, an ornate stained glass skylight, abundance of natural light, and original Lincrusta embossed wall covering. Located in a boutique 4-unit building. Spacious 3 bedroom, 1.5 bath with a formal dining room that includes the original built in china cabinet. Gas fireplace in main living room, and freshly refinished hardwood flooring. The perfect blend of updated finishes and original Victorian detail. Entertain guests between the updated kitchen, dining room, & living area. Two large bedrooms located in the rear make it perfect for either working from or relaxing. completed with a separate laundry room, stackable W/D, shared outdoor patio, 1 car garage parking, & an abundance of storage. Located just a few steps from Alamo Square Park, the Painted Ladies, shops and restaurants along Divisadero Street, Haight street & the Panhandle. A must see home!
district__c, SF District 6
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 410
hoa_name__c, 1493-1499 McAllister Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2022-06-11T01:50:51.000+0000
pba__latitude_pb__c, 37.777798
pba__latitude_property__c, 37.777798
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-04-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, Shumway
listing_agent_mls_id__c, 811167
ffd_listingagentname, Mark N Shumway
listing_agent_number__c, 1050184
listing_co_agent_mls_id__c, 807516
listing_co_agent_number__c, 1020348
listing_co_office_mls_id__c, CORE7
listing_co_office_name__c, Core7 Real Estate
listing_co_office_number__c, 25190
listing_office_mls_id__c, CORE7
listing_office_name__c, Core7 Real Estate
listing_office_number__c, 25190
pba__listingprice_pb__c, 1399000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.436465
mls_id__c, 422654823
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Closet
master_property__c, a0O1I000009yF6OUAU
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-05-06
original_price__c, 1399000
overall_days_on_market__c, -81209
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-06-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-06-10T11:56:58.000+0000
price_per_square_foot__c, 1096.65
pba__propertytype__c, Condominium
id, a0E8W00000Wif9NUAR
room_type__c, Laundry;Living Room;Dining Room;Primary Bedroom
sale_date__c, 2022-06-09
sale_price__c, 1475000
security_features__c, Security Gate
selling_agent_mls_id__c, 804728
selling_agent_number__c, 166014390
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1345
size__c, 1345
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mcallister
subdist__c, Alamo Square
ffd_name, 1497 Mcallister Street, San Francisco, CA, 94115
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530452653-1.jpg
ListingId, a0E8W00000Wif9NUAR