meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320751' 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, 537 Steiner Street, San Francisco, CA, 94117
ffd_mls_id, 422694236
ffd_salesforce_id, a0E8W00000YZdOMUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 3
address2__c, 537 Steiner Street, San Francisco, CA, 94117
pba__address_pb__c, 537 Steiner Street, San Francisco, CA, 94117
agent_only_remarks__c, Transparent Pricing! Schedule a showing by contacting Casey Cowell at 415-652-1765, [email protected] or John Solaegui at 415-999-0673, [email protected]. Please do not use SHOWING TIME. Check with John regarding a possible offer deadline. Escrow is opened with Gerrie Brindley at Chicago Title, [email protected]. Offers will be submitted on most current 7-page SFAR contract (06/2022 edition). Prospective purchasers are advised to independently verify accuracy of square footage and to review any disclosure information before submitting offers.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-11-17
ffd_createddate, 2022-09-16T16:46:45.000+0000
days_on_market__c, 306
dom__c, 88
ffd_description_pb, Spectacular light & impressive scale define this top floor Victorian condo, graced with classic oak floors, traditional moldings, wainscoting & tall windows. The light is accentuated by windows on all four sides - very unusual for any San Francisco Victorian! - as well as a massive skylight in the dining room. The grand living room is anchored by a period mantle. The kitchen features soapstone counters & a Wedgewood range. Inviting den with box beam ceiling & gas fireplace. Three separated bedrooms maximize privacy for both owner & guests. The 1st bedroom enjoys morning light through the curved bay window. The central bedroom has a walk-in closet. The 3rd bedroom enjoys sunset views & looks over the shared garden. Modern touches such as recessed lighting & new heating are juxtaposed with period details. Recent HOA upgrades: new roof, new exterior siding on south & west walls, new front steps & structural upgrades. Exclusive use storage in the basement. Leased parking across the street @$400/mo. Centrally located near Hayes Valley, Divisadero St cafes & restaurants. Ideal access to freeways, public transit & tech shuttles.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Homeowners Insurance,Maintenance Exterior,Water
pba__hoafees__c, 377
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 533-535-537 Steiner Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2023-07-13T17:43:31.000+0000
pba__latitude_pb__c, 37.774228
pba__latitude_property__c, 37.774228
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-08-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Solaegui
listing_agent_mls_id__c, 803722
ffd_listingagentname, John R Solaegui
listing_agent_number__c, 803722
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1785000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.432875
mls_id__c, 422694236
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_property__c, a0O8W00000FrLGQUA3
monthly_parking_fees__c, 400
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-16
original_price__c, 2195000
overall_days_on_market__c, -81342
parking_access__c, Independent
parking_features__c, Garage Door Opener
parking_type__c, Other
pba__pendingdate__c, 2022-12-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 710.8
pba__propertytype__c, Condominium
ListingId, a0E8W00000YZdOMUA1
roof__c, Bitumen
room_type__c, Den;Kitchen;Living Room;Dining Room
sale_date__c, 2022-12-16
sale_price__c, 1750000
selling_agent_mls_id__c, 981678
selling_agent_number__c, 1017282
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2462
size__c, 2462
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Steiner
subdist__c, Alamo Square
ffd_name, 537 Steiner Street, San Francisco, CA, 94117
view__c, City Lights;Downtown
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530528026-1.jpg