meta_query='key:subdist__c;value:Inner Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='339952' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12162
[post_author] => 4
[post_date] => 2018-10-29 01:21:18
[post_date_gmt] => 2018-10-29 01:21:18
[post_content] => Barely west of Laurel Village and Jordan Park. Very east of Ocean Beach. It's not a transitional neighborhood, it's the Inner Richmond. Delightful shops on Clement Street and a surprisingly central location. But no Muni light rail.
[post_title] => Inner Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 11:04:56
[post_modified_gmt] => 2024-03-19 18:04:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12162
[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, 1697022533
ffd_listing_title, 237 4th Avenue, San Francisco, CA, 94118
ffd_mls_id, 423900243
ffd_salesforce_id, a0E8W00000cqJwRUAU
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 0
address2__c, 237 4th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 237 4th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Looking at offers this Thursday, September 14th at Noon. Listing disclosures can be found here: https://app.disclosures.io/link/237-4th-Avenue-snmqt5qw
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Free Standing Gas Range
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1902
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-05T15:45:55.000+0000
days_on_market__c, 36
dom__c, 10
ffd_description_pb, This well-located, stately home offers a very desirable floor plan. You enter the home from the welcoming, sheltered covered porch. Enter the front door to the spacious living room with a period fireplace and inlaid hardwood floors. The living room is flooded with natural light from the west-facing windows. Glass inset pocket doors separate the living room from the formal dining room, where you find a second fireplace and built-in hutch. The adjacent eat-in kitchen has a commercial grade Wolf stove. Off the kitchen, the enclosed sun porch is home to laundry facilities and offers access to the large back yard. A powder room and internal access to the garage complete this level. The upper floor offers three well-proportioned bedrooms, and two full baths. The attic may offer future expansion potential, as does the large garage. The shops of Clement and Laurel Village are minutes away, as are the recreational opportunities of Mountain Lake Park and the Presidio. With a WalkScore of 99, this Walker's Paradise'' boasts one of the best locations in the desirable Inner Richmond.
district__c, SF District 1
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Decorative Only;Dining Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-10-11T10:47:31.000+0000
pba__latitude_pb__c, 37.7841352
pba__latitude_property__c, 37.7841352
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-09-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dennis
pba__listing_agent_lastname__c, Otto
listing_agent_mls_id__c, 803441
ffd_listingagentname, Dennis R Otto
listing_agent_number__c, 803441
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.237-4thAve.com
pba__longitude_pb__c, -122.4625781
lower_level__c, Garage
mls_id__c, 423900243
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Jetted Tub;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-09-05
original_price__c, 1995000
overall_days_on_market__c, -81696
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2023-09-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-10-10T15:45:58.000+0000
price_per_square_foot__c, 1185.57
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cqJwRUAU
roof__c, Composition
room_type__c, Storage;Sun Room;Kitchen;Living Room;Dining Room;Attic;Possible Guest;Workshop;Primary Bedroom
sale_date__c, 2023-10-10
sale_price__c, 2300000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 215754
selling_agent_number__c, 215754
selling_co_agent_mls_id__c, 308732
selling_co_agent_number__c, 308732
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1940
size__c, 1940
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 4th
subdist__c, Inner Richmond
ffd_name, 237 4th Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1902
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530671081-1.jpg