meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='371393' 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, 1706839002
ffd_listing_title, 618 Fillmore Street #3, San Francisco, CA, 94117
ffd_mls_id, 424000038
ffd_salesforce_id, a0EUd000000hXrxMAE
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 3
address2__c, 618 Fillmore Street #3, San Francisco, CA, 94117
pba__address_pb__c, 618 Fillmore Street #3, San Francisco, CA, 94117
appliances__c, Dishwasher;Hood Over Range;Electric Cook Top;Double Oven;Built-In Electric Oven
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1980
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-01-04T03:46:12.000+0000
days_on_market__c, 29
dom__c, 13
ffd_description_pb, Experience the ultimate City lifestyle in the heart of Hayes Valley! This top-floor gem, a 3-bed, 2-bath condo in a modern 3-unit building, combines urban sophistication with tranquility. Freshly painted with new carpeting, it's move-in ready. You'll be just steps away from trendy boutiques, art galleries, and top dining destinations, immersing you in the pulse of San Francisco's AI Cerebral Valley scene'' Food enthusiasts will adore the diverse culinary options, from Michelin-starred restaurants to cozy cafs, all within walking distance. For entertainment, catch a performance at the nearby SF Opera, Symphony, Ballet and Jazz, or explore the nightlife. Patricia's Green and Alamo Square Park provide a serene escape for picnics and leisurely strolls, offering stunning views of the iconic Painted Ladies. Enter through the renovated lobby, ascend to your top-floor oasis, and bask in abundant natural light streaming through large windows, framing the breathtaking city views and parklike greenery below. Featured are: a well-appointed kitchen, skylights, a private balcony, large deeded storage room, shared garden and deeded parking, you'll have everything you need for urban living at its finest.
district__c, SF District 6
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Carpet;Tile
pba__hoafees__c, 450
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 618 Fillmore Street Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-02-02T01:47:13.000+0000
pba__latitude_pb__c, 37.775269
pba__latitude_property__c, 37.775269
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2023-11-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Roland
pba__listing_agent_lastname__c, Jadryev
listing_agent_mls_id__c, 383842
ffd_listingagentname, Roland Jadryev CRS
listing_agent_number__c, 383842
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 1525000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.430791
mls_id__c, 424000038
master_property__c, a0O1I000001Vi96UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-03
original_price__c, 1525000
overall_days_on_market__c, -81816
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2024-01-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-02-01T08:51:37.000+0000
price_per_square_foot__c, 1046.67
pba__propertytype__c, Condominium
ListingId, a0EUd000000hXrxMAE
sale_date__c, 2024-01-31
sale_price__c, 1570000
security_features__c, Security Gate;Video System
selling_agent_mls_id__c, 813538
selling_agent_number__c, 1062005
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, 1500
size__c, 1500
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fillmore
subdist__c, Alamo Square
ffd_name, 618 Fillmore Street #3, San Francisco, CA, 94117
view__c, City;Downtown
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1980
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530715230-1.jpg