meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385954' 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, 1726225047
ffd_listing_title, 137 6th Avenue, San Francisco, CA, 94118
ffd_mls_id, 424063549
ffd_salesforce_id, a0EUd0000033dsjMAA
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 137 6th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 137 6th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Vacant & Staged Beautifully. Just completed renovations in August 2024. New windows, foundation perimeter, sewer line, electrical, plumbing, and utilities. Roof redone last year. Please contact L/A for more info. OFFERS by TUES. 9/17 by 1:00pm. Disclosures via Homelight link just copy/paste https://app.disclosures.io/link/137-6th-Avenue-zgk4d148 Pre-escrow with Fidelity National, 2001 Union St, SF with Bethe Battalio. Seller is out of U.S and request to pls keep escrow with Fidelity. *Seller to cooperate with Buyer concessions. *Seller Reserves the Rights to accept, reject and counter any buyer offers.
appliances__c, Dishwasher;Microwave;Disposal;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator;Self/Cont Clean Oven
architectural_style__c, Edwardian;Traditional;See Remarks
bath_features__c, Tub w/Shower Over;Stone
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-09-08T10:48:23.000+0000
days_on_market__c, 5
dom__c, 5
ffd_description_pb, Majestic Queen Anne home will satisfy even the most discerning buyer! Gorgeous 4 bed + sunroom, 3 bath, tri-level home located in San Francisco's coveted Inner Richmond/Lake area would be ideal for working family who is ready to create happy memories for years to come. This Edwardian era home originally built in 1904 and renovated in 2024 showcases timeless decor and modern design. Hardwood floors, grand staircase, pocket door, ceiling medallions + crown molding add an elegant touch while also providing designer lighting & high end utilities. Formal dining/living rooms are sure to entertain family or friends for any occasion. Enjoy the spacious family room next to the quartz counter center island in the beautiful designer eat-in kitchen. Home chefs will appreciate stainless steel appliances and plenty of cabinet space or for convenience an indoor laundry with new washer/dryer and full bath with walk-in shower. The upper level boasts four spacious bedrooms, two full baths and a bright sunroom with serene views. The primary bedroom provides for a king bed + private bath. All baths include custom vanity, seamless glass shower doors & lighted touch mirrors. There's also an insulated attic w/pull down ladder. Large yard & garage for possible expansion, New Windows, foundation & more!
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood;Fenced
pba__floortype_pb__c, Tile;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2024-09-13T10:46:56.000+0000
pba__latitude_pb__c, 37.7859016
pba__latitude_property__c, 37.7859016
laundry_features__c, Inside Room;Laundry Closet;Inside Area;Washer Included;Dryer Included
listed_date__c, 2024-09-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Matthew
pba__listing_agent_lastname__c, Hilzendrager
listing_agent_mls_id__c, 803362
ffd_listingagentname, Matthew T Hilzendrager
listing_agent_number__c, 803362
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 2795000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=U1uurJ1bNf4
pba__longitude_pb__c, -122.4649352
lower_level__c, Garage
mls_id__c, 424063549
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Quartz;Window;Stone
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-09-08
open_house_end__c, 2024-09-14T14:00:00.000+0000
open_house_start__c, 2024-09-14T12:00:00.000+0000
original_price__c, 2795000
overall_days_on_market__c, -82065
parking_access__c, Tandem
parking_features__c, Converted Garage,Covered,Garage Door Opener,Garage Facing Front,Tandem Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front 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, Single Family Residence
ListingId, a0EUd0000033dsjMAA
roof__c, Tar/Gravel;Shingle
room_type__c, Storage;Sun Room;Laundry;Kitchen;Living Room;Dining Room;Attic;Family Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate;Unguarded Gate;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, 0
pba__street_pb__c, 6th
subdist__c, Lake Street
ffd_name, 137 6th Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane Partial;Window Screens
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530838300-1.jpg
