meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218071' 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, 1504 Mcallister Street #B, San Francisco, CA, 94115
ffd_mls_id, 421533716
ffd_salesforce_id, a0E1I00000TxdQbUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 9
address2__c, 1504 Mcallister Street #B, San Francisco, CA, 94115
pba__address_pb__c, 1504 Mcallister Street #B, San Francisco, CA, 94115
agent_only_remarks__c, Parking is leased on a month-to-month basis for $240 per month at the parking lot at 1464 McAllister; there is 24/7 access. Excluded from sale: Living Room Curtains, Bedroom Curtains (roman shade and long sheer).
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Free Standing Refrigerator;Self/Cont Clean Oven
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Low-Flow Toilet(s);Dual Flush Toilet;Low-Flow Shower(s);Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-04-15
ffd_createddate, 2021-04-02T14:47:49.000+0000
days_on_market__c, 838
dom__c, 32
ffd_description_pb, Enjoy Panoramic Views of the City and Downtown from this Luxuriously Renovated 3 Bedroom, 2 Bathroom Home! The Living Room has Boxed Beam Ceilings & wonderful Northern & Eastern Views. Enjoy more Views from the Eat-In Kitchen, which includes Bosch & Samsung Appliances, Custom Painted Cabinets & Quartz Countertops. There are 3 Large Bedrooms with Ample Closet Space & Two Spa-Like Bathrooms, one with a Walk-In Shower & the other with a Soaking Tub. Designer upgrades include Farrow & Ball Paint, Custom Lighting & Wallpaper. The entire building went through a down to the studs renovation from 2014-2016 , including New Roof, New Plumbing, New Electric/Data, Mostly New Windows, New Paint, Insulation, Security System, Fire Sprinklers & a Reinforced Foundation. Parking with 24/7 access is leased block away. Large Private Deeded Storage Closet in Basement. 1 Block to Alamo Square Park & Divisadero Street (gourmet eateries and boutiques) & short distance to NOPA & Hayes Valley.
district__c, SF District 6
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Trash
pba__hoafees__c, 590
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1500 McAllister HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Radiant;Central
ffd_lastmodifieddate, 2022-01-25T15:48:48.000+0000
pba__latitude_pb__c, 37.778195
pba__latitude_property__c, 37.778195
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2021-03-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alan
pba__listing_agent_lastname__c, Morcos
listing_agent_mls_id__c, 804261
ffd_listingagentname, Alan Morcos
listing_agent_number__c, 166013762
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.436921
mls_id__c, 421533716
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room
master_property__c, a0O8W00000DaE4KUAV
monthly_parking_fees__c, 240
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-02
original_price__c, 1395000
overall_days_on_market__c, 273
parking_access__c, Independent
parking_features__c, Other,See Remarks
parking_type__c, Other
pba__pendingdate__c, 2021-05-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1058.42
pba__propertytype__c, Tenancy In Common
id, a0E1I00000TxdQbUAJ
roof__c, Composition;Shingle
room_type__c, Kitchen;Living Room
sale_date__c, 2021-05-26
sale_price__c, 1395000
security_features__c, Smoke Detector;Security Gate;Fire Alarm;Secured Access;Carbon Mon Detector
selling_agent_mls_id__c, EB333035
selling_agent_number__c, 981347670
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams Tri-Valley
pba__status__c, Closed
pba__totalarea_pb__c, 1318
size__c, 1318
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mcallister
subdist__c, Alamo Square
ffd_name, 1504 Mcallister Street #B, San Francisco, CA, 94115
view__c, City;Panoramic;City Lights;San Francisco
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530211077-1.jpg
ListingId, a0E1I00000TxdQbUAJ