meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='417930' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70652
[post_author] => 4
[post_date] => 2018-11-30 20:30:25
[post_date_gmt] => 2018-11-30 20:30:25
[post_content] => A thin sliver of streets as north as you can be on the west side of town without being in the Presidio. Compared to the Richmond, you'll generally find larger homes on shorter streets with select homes opening up to back-door Presidio access. West Clay is an exclusive enclave of special homes within a special neighborhood.
[post_title] => Lake Street
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lake-street
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 13:15:32
[post_modified_gmt] => 2024-04-09 20:15:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70652
[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, 1728698050
ffd_listing_title, 177 9th Avenue, San Francisco, CA, 94118
ffd_mls_id, 424066353
ffd_salesforce_id, a0EUd000003AntmMAC
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 2
address2__c, 177 9th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 177 9th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Vacant! This iconic two-unit building presents a rare opportunity, with no buyout or eviction history on record, buyer to due their own due diligence to confirm this with the Rent Board. 175 and 177 can be sold together as a duplex or separately as a TIC. Draft TIC Agreement is created by Rosemarie MacGuinness with Sirkin Law. Buyer to perform their due diligence on eligibility for fast track condo conversion. Property is staged and shows incredibly well for any discerning buyer or investor. One of the sellers is a California licensed real estate agent and related to the listing agent. Please contact Melanie Leung at 415-888-9188 or [email protected] with any questions/appointments. Sellers prefer to keep escrow with Old Republic Title Company-Michelle Pineda. Escrow No. #0227031005. Disclosures are at https://app.disclosures.io/link/175177-9th-Avenue-fcnbk8nk
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Built-In Refrigerator;Gas Plumbed
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile;Window
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-09-23T10:47:59.000+0000
days_on_market__c, 18
dom__c, 18
ffd_description_pb, Nestled in the prestigious Lake District, this newly renovated bi-level home radiates timeless luxury with custom designer finishes and a host of modern upgrades. The main level exudes warmth and elegance, with a living room featuring custom paneling and a cozy gas fireplace, seamlessly flowing into a formal dining room. The gourmet kitchen shines with stunning Calacatta countertops, custom cabinetry, and premium Thermador appliances. 3 spacious bedrooms complete this level, including a serene primary suite with a walk-in closet and a spa-inspired ensuite with dual vanities and heated floors. The lower-level invites relaxation with a spacious family room, a chic powder room, a convenient laundry room, and another bedroom ensuite opening to a charming wraparound deck. Additional perks include one-car parking, deeded storage, shared newly landscaped backyard and eligibility for fast-track condo conversion. Just steps from Mt Lake Park and the Presidio, this home offers a peaceful escape for nature, tennis and golf lovers. 175 9th Avenue is also available and can be purchased together or separately. Located near the lively Clement Street corridor, this residence provides easy access to world-class dining, boutique shopping, and the bustling Clement Street Farmers Market on Sundays.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced;Full
fireplace_features__c, Living Room;Gas Piped;Insert
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas;Natural Gas;Fireplace Insert
ffd_lastmodifieddate, 2024-10-12T01:48:52.000+0000
pba__latitude_pb__c, 37.7851867
pba__latitude_property__c, 37.7851867
laundry_features__c, Inside Room;Washer Included;Dryer Included;Electric
listed_date__c, 2024-09-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Melanie
pba__listing_agent_lastname__c, Leung
listing_agent_mls_id__c, 806887
ffd_listingagentname, Melanie P Leung
listing_agent_number__c, 166017801
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, KEYO
listing_office_name__c, KeyOpp Real Estate
listing_office_number__c, 29017
pba__listingprice_pb__c, 2195000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=AhbHhDif9fu
pba__longitude_pb__c, -122.4679401
lower_level__c, Family Room,Full Bath(s),Garage,Primary Bedroom,Partial Bath(s),Street Entrance
mls_id__c, 424066353
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-23
open_house_end__c, 2024-10-12T16:00:00.000+0000
open_house_start__c, 2024-10-12T14:00:00.000+0000
original_price__c, 2195000
overall_days_on_market__c, -82080
parking_access__c, Tandem
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Interior Access,Tandem Garage,Unassigned
parking_type__c, On Site - Unassigned (Condo Only)
patio_and_porch_features__c, Wrap Around 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, 0
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000003AntmMAC
road_surface_type__c, Asphalt,Paved
roof__c, Bitumen
room_type__c, Storage;Laundry;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom 2+
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 9th
subdist__c, Lake Street
ffd_name, 177 9th Avenue, San Francisco, CA, 94118
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full;Bay Window(s);Window Screens
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530843953-1.jpg