meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340050' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70658
[post_author] => 4
[post_date] => 2018-11-30 20:30:32
[post_date_gmt] => 2018-11-30 20:30:32
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors to the north, and it’s also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:32:49
[post_modified_gmt] => 2023-10-31 16:32:49
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70658
[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, 1700741602
ffd_listing_title, 618 Randolph Street, San Francisco, CA, 94132
ffd_mls_id, 423915403
ffd_salesforce_id, a0E8W00000dUSNTUA4
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 618 Randolph Street, San Francisco, CA, 94132
pba__address_pb__c, 618 Randolph Street, San Francisco, CA, 94132
agent_only_remarks__c, Please email or text Bill Mar at 415-203-2363 for showing or questions. Pre-Escrow opened with Chicago Title / Nancy Chan. Sellers would appreciate the escrow stays with Chicago Title. Please kindly submit an offer via Homelight (DisclosureIO)Disclosures: https://app.disclosures.io/link/618-Randolph-Street-hyazymnf
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 4
year_build_text__c, 1947
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bill Mar
pba__contingentdate__c, 2023-11-16
ffd_createddate, 2023-10-12T20:48:14.000+0000
days_on_market__c, 42
dom__c, 42
ffd_description_pb, Beautiful 4-bed, 1.5ba home flexible as owner-user, investment, or hybrid in the highly desirable Ingleside Heights! This spacious residence with an in-law unit offers a comfortable and warmly inviting living space. Step inside this well-maintained interior with a cozy fireplace, internal garage parking access, and direct backyard access that is perfect for outdoor enjoyment. One of the most appealing aspects of this home is its fantastic location. Just steps away, you'll find H-Mart, a popular grocery store that offers a wide range of fresh produce and international products. This home is conveniently located near San Francisco State University, making it perfect for students to rent for great additional income. Nearby major shopping centers of Stonestown and Westlake, the abundance of dining, shopping and entertainment options are endless. For those who rely on public transportation, this home offers very easy access to MUNI and nearby highway 280, ensuring convenient access. To explore all that San Francisco and the surrounding areas have to offer. Don't miss out on this wonderful opportunity to own a home in the sought-after Ingleside Heights neighborhood.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2023-11-23T11:47:19.000+0000
pba__latitude_pb__c, 37.7144859
pba__latitude_property__c, 37.7144859
listed_date__c, 2023-10-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Susie
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 814242
ffd_listingagentname, Susie Lee
listing_agent_number__c, 1065352
listing_co_agent_mls_id__c, 803381
listing_co_agent_number__c, 803381
listing_co_office_mls_id__c, COMP31
listing_co_office_name__c, Compass
listing_co_office_number__c, 27894
listing_office_mls_id__c, COMP31
listing_office_name__c, Compass
listing_office_number__c, 27894
pba__listingprice_pb__c, 999000
pba__listingtype__c, Sale
pba__listing_website__c, https://real.vision/my/618-randolph-street/tour
pba__longitude_pb__c, -122.4684092
mls_id__c, 423915403
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-10-12
original_price__c, 999000
overall_days_on_market__c, -81733
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
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, 562.82
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dUSNTUA4
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, 1775
size__c, 1775
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Randolph
subdist__c, Ingleside Heights
ffd_name, 618 Randolph Street, San Francisco, CA, 94132
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1947
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530691664-1.jpg