meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376530' 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
(
)
)
_yoast_indexnow_last_ping, 1714561174
ffd_listing_title, 1407 Golden Gate Avenue, San Francisco, CA, 94115
ffd_mls_id, 424014816
ffd_salesforce_id, a0EUd000001pdy1MAA
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 3
address2__c, 1407 Golden Gate Avenue, San Francisco, CA, 94115
pba__address_pb__c, 1407 Golden Gate Avenue, San Francisco, CA, 94115
agent_only_remarks__c, Disclosure link: https://app.disclosures.io/link/1407-Golden-Gate-Avenue-c3erjrk2 Supra ibox on the railing, time restricted, please show between 8am-8pm. Please call or text agent regarding offer submission, Julie Peisner 415-823-0824.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
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, 1890
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-24T19:47:43.000+0000
days_on_market__c, 7
dom__c, 7
ffd_description_pb, Nestled in the heart of San Francisco's Alamo Square, on the famed Seattle block, this elegant flat seamlessly marries timeless charm with contemporary comfort. With its high ceilings, original molding, ceiling medallions, and redwood trim, this spacious condo is the perfect blend of old-world craftsmanship and modern sophistication. The living room beckons with large bay windows, tasteful period details, newer custom-built redwood shelving, and a restored gas fireplace. There are 3 bedrooms, plus a home office with two built-in desks, a generous full bathroom with shower over tub, plus a separate powder room. Toward the back of the home, you'll find an updated kitchen and formal dining room with a charming decorative fireplace. Sliding doors in both rooms open to a small patio, perfect for enjoying morning coffee or an evening cocktail. Included with this unit is a stackable washer and dryer, one car parking with an EV charger and built-in storage. There are solar panels exclusive to this unit. With its timeless charm, modern amenities, and prime location near Alamo Square's picturesque park, NoPa and Hayes Valley, this elegant home offers the perfect blend of historical character and contemporary luxury for those seeking a truly unforgettable San Francisco experience!
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
fireplace_features__c, Decorative Only;Gas Piped;See Remarks
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Electricity,Homeowners Insurance,Maintenance Exterior,Trash,Water,See Remarks
pba__hoafees__c, 525
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-05-01T10:47:00.000+0000
pba__latitude_pb__c, 37.779092
pba__latitude_property__c, 37.779092
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2024-03-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Julie
pba__listing_agent_lastname__c, Peisner
listing_agent_mls_id__c, 804005
ffd_listingagentname, Julie E Peisner
listing_agent_number__c, 166013400
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1475000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/938270736
pba__longitude_pb__c, -122.433818
mls_id__c, 424014816
master_property__c, a0OUd000006PHWzMAO
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-24
open_house_end__c, 2024-05-05T16:30:00.000+0000
open_house_start__c, 2024-05-05T13:30:00.000+0000
original_price__c, 1475000
overall_days_on_market__c, -81928
parking_access__c, Independent
parking_features__c, Assigned,Covered,EV Charging,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 924.76
pba__propertytype__c, Condominium
ListingId, a0EUd000001pdy1MAA
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1595
size__c, 1595
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Golden Gate
subdist__c, Alamo Square
ffd_name, 1407 Golden Gate Avenue, San Francisco, CA, 94115
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1890
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530744006-1.jpg
