meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218681' 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] => 2023-10-31 10:38:12
[post_modified_gmt] => 2023-10-31 17:38:12
[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, 1495 Mcallister Street, San Francisco, CA, 94115
ffd_mls_id, 421544640
ffd_salesforce_id, a0E1I00000USVTFUA5
num_of_fireplaces__c, 2
num_of_rooms__c, 9
of_units__c, 4
address2__c, 1495 Mcallister Street, San Francisco, CA, 94115
pba__address_pb__c, 1495 Mcallister Street, San Francisco, CA, 94115
agent_only_remarks__c, Offers to be reviewed on Friday, May 14th at 11am. Email offers to [email protected]. No Pre-emptive offers. Vacant and easy to show by appointment only. See the property website here: www.mpowersells1495mcallister.com Please schedule all showings through Calendly here: https://calendly.com/mpowerproperties/1495mcallister-showings Please email a signed CAR Form PEAD prior to all showings. Disclosures can be found here: https://app.disclosures.io/link/1495-McAllister-Street-gi8youjx Offer date to be TBD after the first weekend. Escrow opened with Janette Marcelo at Old Republic Title. Disclosures linked to MLS. Staged and shows beautifully.
appliances__c, Free Standing Gas Range
architectural_style__c, Victorian
bath_features__c, Marble
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Marc Dickow
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-04T18:47:17.000+0000
days_on_market__c, 807
dom__c, 14
ffd_description_pb, This must see top floor victorian condo is located in one of SF's hippest neighborhoods. Stunningly high ceilings, original Victorian detail, & an ornate round stained glass skylight adorning the entry hall. Original Lincrusta embossed wall covering throughout. Located in a boutique 4-unit building. Spacious 3 bedroom, 1.5 bath. Formal dining room with original built in china cabinet, two period fireplaces, and freshly refinished hardwood flooring. The perfect blend of updated finishings and original victorian detail. Entertain guests between the open kitchen, dining room, & living area. Two large bedrooms located in the rear make it perfect for either working from home or relaxing after a long day. 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!
district__c, SF District 6
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Brick
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 380
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1493-1499 McAllister St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:51:25.000+0000
pba__latitude_pb__c, 37.777798
pba__latitude_property__c, 37.777798
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2021-02-08
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, 1349000
pba__listingtype__c, Sale
pba__listing_website__c, http://mpowersells1495mcallister.com
pba__longitude_pb__c, -122.436465
mls_id__c, 421544640
master_property__c, a0O1I000004VXUtUAO
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-05-03
original_price__c, 1349000
overall_days_on_market__c, 179
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2021-05-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 978.12
pba__propertytype__c, Condominium
id, a0E1I00000USVTFUA5
sale_date__c, 2021-06-15
sale_price__c, 1475000
selling_agent_mls_id__c, EB154821
selling_agent_number__c, 981012350
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Venture Sotheby's Intl Rlty
pba__status__c, Closed
pba__totalarea_pb__c, 1508
size__c, 1508
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mcallister
subdist__c, Alamo Square
ffd_name, 1495 Mcallister Street, San Francisco, CA, 94115
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530231403-1.jpg
ListingId, a0E1I00000USVTFUA5