meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='418203' 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, 1727866397
ffd_listing_title, 740 Fell Street, San Francisco, CA, 94117
ffd_mls_id, 424046027
ffd_salesforce_id, a0EUd000003CbTWMA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 5
address2__c, 740 Fell Street, San Francisco, CA, 94117
pba__address_pb__c, 740 Fell Street, San Francisco, CA, 94117
agent_only_remarks__c, Credits to Buyers Considered. Please call, email or text listing agent David Ayerdi 415.794.3212, [email protected] to show or for disclosure packet. Escrow @ First American Title Company with Mijael Schmidt.
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Tub;Tile;Quartz;Window;Stone;Closet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1890
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-09-29
ffd_createddate, 2024-09-25T20:48:35.000+0000
days_on_market__c, 7
dom__c, 7
ffd_description_pb, First time on the market in over 18 years, this exquisite gated Victorian condominium offers approximately 1,700 square feet of exceptional living space. The home is rich in architectural details, featuring elegant oak hardwood floors, intricate crown moldings, double-pane Bay windows, and modern LED recessed lighting. Three bedrooms, two full bathrooms, formal entry, formal living room with decorative fireplace, formal dining room, remodeled eat-in kitchen, laundry room with stackable washer and dryer, walk-out deck, lightwell patio, one car garage parking, storage, expansive walk-out common landscaped sunny backyard/garden with lush greenery and mature trees. Enjoy seamless indoor-outdoor living with direct access from the kitchen and dining room to a sunny, spacious shared backyard and garden ideal for entertaining, family gatherings, and al fresco dining. On a tree-lined street and Walk Score of 98! Located in the vibrant Alamo Square neighborhood on a tree-lined street. Close to Alamo Square Park with its postcard views of the Painted Ladies and nearby cafes, restaurants, Fillmore Street, Hayes Valley, the Divisadero corridor, Bi-Rite Market, the new Traders Joe's, Patricia's Green and easy access to excellent schools and public transportation. HOA fee of $395 a month.
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Insurance,Maintenance Exterior,Maintenance Grounds,Trash,Water
pba__hoafees__c, 395
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 736-744 Fell Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-10-02T10:48:35.000+0000
pba__latitude_pb__c, 37.7751521
pba__latitude_property__c, 37.7751521
laundry_features__c, Inside Room;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2024-09-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Ayerdi
listing_agent_mls_id__c, 809742
ffd_listingagentname, David Ayerdi
listing_agent_number__c, 1043069
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB3
listing_office_name__c, Sotheby's International Realty Inc
listing_office_number__c, 28227
pba__listingprice_pb__c, 1175000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=TXv3AXm3DxT
pba__longitude_pb__c, -122.4300548
mls_id__c, 424046027
main_level__c, Bedroom(s);Kitchen;Garage;Living Room;Dining Room;Street Entrance
master_property__c, a0O1I00000AoKX1UAN
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-25
original_price__c, 1175000
overall_days_on_market__c, -82082
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
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, 691.18
pba__propertytype__c, Condominium
ListingId, a0EUd000003CbTWMA0
room_type__c, Laundry;Kitchen;Living Room;Baths Other;Dining Room
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, Contingent - Show
pba__totalarea_pb__c, 1700
size__c, 1700
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fell
subdist__c, Alamo Square
ffd_name, 740 Fell Street, San Francisco, CA, 94117
view__c, Garden/Greenbelt
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1890
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530847496-1.jpg