meta_query='key:subdist__c;value:Central Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332708' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70208
[post_author] => 4
[post_date] => 2018-11-30 20:29:21
[post_date_gmt] => 2018-11-30 20:29:21
[post_content] => What used to be rolling sand dunes as far as the eye can see is now an orderly neighborhood of tidy homes. Views of the Golden Gate Bridge are a welcome surprise from the lucky parts. Proximity to the park appeals to those with canines and kids.
[post_title] => Central Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:27:28
[post_modified_gmt] => 2024-04-09 17:27:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70208
[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, 261 17th Avenue, San Francisco, CA, 94121
ffd_mls_id, 423723484
ffd_salesforce_id, a0E8W00000bEZIgUAO
num_of_rooms__c, 10
of_units__c, 2
address2__c, 261 17th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 261 17th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Transparent price. Easy to show. Use SFAR RPA please. Tenant downstairs pays $3,400/mo. Can be delivered vacant. Legal Duplex (2U) with great bones that could be occupied by a multigenerational family; or bought as an investment; or live in one unit and rent out the other unit; maybe condo converted; subject to limited rent control laws. Pre-escrow is open with Margaret Hui of First American Title, [email protected], 415.682.1101.
architectural_style__c, Traditional;Mediterranean
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1998
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Anna Karpie
pba__contingentdate__c, 2023-04-11
cooling__c, None
ffd_createddate, 2023-02-24T11:50:03.000+0000
days_on_market__c, 145
dom__c, 87
ffd_description_pb, Transparent price. Looking for a spacious home with investment potential in San Francisco? Look no further! This custom-built duplex offers an incredible opportunity for investment and condo conversion in a prime location with limited rent control laws. The 3-story, 5-bed, 4.5-bath residence boasts an impressive 4,535 square feet of living space and sits on a 3,000 square foot lot. Built in 1998, this palatial-sized duplex is perfectly situated in one of the best SF neighborhoods, just steps away from Sea Cliff, Golden Gate Park, Presidio, and your favorite cafes and restaurants. The main residence features 3-bedrooms plus an office and 3.5-bathrooms, with extra high ceilings, grand marble staircase, skylights, oversized windows, hardwood floors, and custom closet spaces and cabinetry. The lower residence is a 2-bed, 1-bath space facing the backyard, offering plenty of privacy and tranquility. Both residences have access to the large picturesque backyard with lemon trees and lilacs. The house has been painted inside and out. Don't miss your chance to own a piece of San Francisco's coveted real estate and invest in a property with incredible potential. Buyer is advised to investigate all info provided to their full satisfaction.
district__c, SF District 1
external_listing__c, 1
pba__floortype_pb__c, Marble;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant;Varies by Unit
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-06-03T02:48:44.000+0000
pba__latitude_pb__c, 37.7831099
pba__latitude_property__c, 37.7831099
laundry_features__c, Laundry Closet;In Each Unit;In Common Area
listed_date__c, 2023-02-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Yelena
pba__listing_agent_lastname__c, Laudati
listing_agent_mls_id__c, 809117
ffd_listingagentname, Yelena Laudati
listing_agent_number__c, 1040477
listing_co_agent_mls_id__c, MLSL5078672
listing_co_agent_number__c, 981343065
listing_co_office_mls_id__c, KWPEN-1
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 981051855
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3175000
pba__listingtype__c, Sale
pba__listing_website__c, https://player.vimeo.com/video/714347472
pba__longitude_pb__c, -122.4765671
mls_id__c, 423723484
parkingspaces__c, 1
on_market_date__c, 2023-02-24
original_price__c, 2988888
overall_days_on_market__c, -81503
parking_features__c, Attached,Covered,Garage,Garage Door Opener,Interior Access
patio_and_porch_features__c, Enclosed Patio;Uncovered Patio;Balcony/Deck;Varies by Unit
pba__pendingdate__c, 2023-05-26
price_per_square_foot__c, 672.55
pba__propertytype__c, Duplex
ListingId, a0E8W00000bEZIgUAO
roof__c, Bitumen
sale_date__c, 2023-06-01
sale_price__c, 3050000
security_features__c, Smoke Detector;Fire Alarm;Varies By Unit;Carbon Mon Detector;Security System Prewired
selling_agent_mls_id__c, 342642
selling_agent_number__c, 342642
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 4535
size__c, 4535
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 17th
subdist__c, Central Richmond
ffd_name, 261 17th Avenue, San Francisco, CA, 94121
view__c, Garden/Greenbelt;San Francisco;Woods;Varies by Unit
website_property_type__c, Duplex
window_features__c, Dual Pane Full;Window Coverings;Bay Window(s)
pba__yearbuilt_pb__c, 1998
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530583632-1.jpg