meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221441' 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, 1470 Mcallister Street, San Francisco, CA, 94115
ffd_mls_id, 421598519
ffd_salesforce_id, a0E8W00000V0bh3UAB
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 3
address2__c, 1470 Mcallister Street, San Francisco, CA, 94115
pba__address_pb__c, 1470 Mcallister Street, San Francisco, CA, 94115
agent_only_remarks__c, Pest clearance! Escrow is opened with Amy Edberg @ First American Title. Please schedule your showing on Calendly: https://calendly.com/mollie-poe-properties/private-showing-at-1470-mcallister Please review disclosures @ https://app.disclosures.io/link/1470-McAllister-Street-uedenp5t For more info, please visit www.1470McAllister.com
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2016
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jack McClellan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-10-04T19:48:54.000+0000
days_on_market__c, 653
dom__c, 34
ffd_description_pb, NEW PRICE! Sleek in design and offering the indoor/outdoor lifestyle a condo-dweller craves, this dynamic 2-level condo, just 1 block from Alamo Square and Divisadero Corridor's hot restaurant scene, exemplifies sophisticated city living. Newly constructed in 2016, this condo features modern finishes throughout. A large open floor plan where soaring ceilings meet wide-plank oak flooring and sliding doors to a rear deck on main level. Carrera marble counters wrap a large island and pair with beautiful cabinetry and high-end appliances. Bathrooms feature all of the perks; dual sinks, rain shower, designer tile, and a separate powder room for guests. Lower-level's media room poses well as a primary suite overlooking the Home's private landscaped rear garden. Built-in sound for entertaining, radiant floor heating powered by Nest, video entry security, and direct internal entry into the property garage with side-by-side parking. Excellent location for biking and commuting.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Electricity,Insurance,Insurance on Structure,Trash,Water
pba__hoafees__c, 754
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 147-1472-1474 McAllister HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2022-01-25T16:03:48.000+0000
pba__latitude_pb__c, 37.778279
pba__latitude_property__c, 37.778279
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2021-09-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mollie
pba__listing_agent_lastname__c, Poe
listing_agent_mls_id__c, 802851
ffd_listingagentname, Mollie W Poe
listing_agent_number__c, 802851
listing_co_agent_mls_id__c, 816237
listing_co_agent_number__c, 1075203
listing_co_office_mls_id__c, INDIGO
listing_co_office_name__c, Indigo Real Estate
listing_co_office_number__c, 28648
listing_office_mls_id__c, INDIGO
listing_office_name__c, Indigo Real Estate
listing_office_number__c, 28648
pba__listingprice_pb__c, 2349000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=Eahmbp8L8N2
pba__longitude_pb__c, -122.436328
lower_level__c, Master Bedroom
mls_id__c, 421598519
main_level__c, Bedroom(s);Kitchen;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Stone
master_property__c, a0O1I000001ViDuUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-10-04
original_price__c, 2495000
overall_days_on_market__c, 88
parking_access__c, Independent
parking_features__c, Garage Facing Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-11-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1200
pba__propertytype__c, Condominium
id, a0E8W00000V0bh3UAB
room_type__c, Dining Room;Master Bedroom;Great Room
sale_date__c, 2021-11-17
sale_price__c, 2400000
selling_agent_mls_id__c, 292619
selling_agent_number__c, 292619
selling_co_agent_mls_id__c, 400402
selling_co_agent_number__c, 400402
selling_co_office_mls_id__c, STHB
selling_co_office_name__c, Sotheby's International Realty
selling_co_office_number__c, 2050
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2000
size__c, 2000
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mcallister
subdist__c, Alamo Square
ffd_name, 1470 Mcallister Street, San Francisco, CA, 94115
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2016
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530334765-1.jpg
ListingId, a0E8W00000V0bh3UAB